SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-13T11:48:55.367022+00:00","dedupe_key":"signal_enriched:news_delta:075f13dfc72d22b8","evidence_event_ids":["evt_5a1e1541a316"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxNR2piSEtIcGpCTWNHMXQtaUZORW5QN294LU1lMmJsVndoN3I0R3dNMndkNjU3VlZmNnYtdVFtbmtsd0hiQTdZNFlObTBFalVlV19lUWZnMzZ4b0VIbHd3YTVBT0ZjSVh3S2t2bUQ5aUhvdFdsMzBFUEcxY0FrN09NcUswOTF6T2pIb0ZuNzdweU9KWFRlaEZVVGJTaw?oc=5","as_of":"2026-04-13T11:48:55.367022+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxNR2piSEtIcGpCTWNHMXQtaUZORW5QN294LU1lMmJsVndoN3I0R3dNMndkNjU3VlZmNnYtdVFtbmtsd0hiQTdZNFlObTBFalVlV19lUWZnMzZ4b0VIbHd3YTVBT0ZjSVh3S2t2bUQ5aUhvdFdsMzBFUEcxY0FrN09NcUswOTF6T2pIb0ZuNzdweU9KWFRlaEZVVGJTaw?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_784cfa5243cbfa42","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-13T13:25:34.137875+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxNR2piSEtIcGpCTWNHMXQtaUZORW5QN294LU1lMmJsVndoN3I0R3dNMndkNjU3VlZmNnYtdVFtbmtsd0hiQTdZNFlObTBFalVlV19lUWZnMzZ4b0VIbHd3YTVBT0ZjSVh3S2t2bUQ5aUhvdFdsMzBFUEcxY0FrN09NcUswOTF6T2pIb0ZuNzdweU9KWFRlaEZVVGJTaw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"barrons.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxNR2piSEtIcGpCTWNHMXQtaUZORW5QN294LU1lMmJsVndoN3I0R3dNMndkNjU3VlZmNnYtdVFtbmtsd0hiQTdZNFlObTBFalVlV19lUWZnMzZ4b0VIbHd3YTVBT0ZjSVh3S2t2bUQ5aUhvdFdsMzBFUEcxY0FrN09NcUswOTF6T2pIb0ZuNzdweU9KWFRlaEZVVGJTaw?oc=5","source_event_id":"evt_5a1e1541a316","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"ce6282806299f694","published_at":"2026-04-13T09:55:00+00:00","publisher_domain":"barrons.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"media","name":"Barron's","relevance":"source of the headline","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The five pipeline stocks are not named in the provided text.","No ticker symbols are provided for the pipeline stocks.","No details are provided on the mechanism (e.g., contracts, volumes, tariffs) linking demand to stock performance.","No near-term catalyst timing (date/quarter) is provided.","No additional context from the article body is available."],"key_facts":["Barron\u2019s published an article titled \u201cThe World Wants More American Energy. 5 Pipeline Stocks That Benefit.\u201d","The headline asserts that five pipeline stocks benefit from increased demand for American energy."],"numeric_claims":[],"primary_claim":"The world wants more American energy, and Barron\u2019s identifies five pipeline stocks that benefit.","relevance_score":0.35,"sentiment":"positive","source_quality":"unknown","summary":"Barron\u2019s headline indicates that demand for more American energy is expected to benefit five pipeline stocks. No specific company names, tickers, or timing details are provided in the available text.","topics":["American energy demand","pipeline stocks","equities","energy infrastructure"]},"source":"Barron's","source_domain":"barrons.com","source_url":"https://www.barrons.com","summary":"The World Wants More American Energy. 5 Pipeline Stocks That Benefit. Barron's","title":"The World Wants More American Energy. 5 Pipeline Stocks That Benefit. - Barron's","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp"}}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 34504 in events