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-12T09:52:31.786694+00:00","dedupe_key":"signal_enriched:news_delta:db64802d4e30821d","evidence_event_ids":["evt_3be6c52a1d03"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxPdHEtMHRKWXo4S2FkRFJxdm0zbzM4Vk9Vemh3dTloSkh1TExITWR0bG1tbFl0c2F3RXZCSElvUWRQNDZfRkFvN3FQWEVETzB4MG9fTzRSMHE2UnIzZVowN0JuUTZLVzdJSlRaY3IzV0N3eF8ySElJUUczNnJDWGxqdWpYUWlKNm1wM082R1JIdWJsWkRhQTVJ?oc=5","as_of":"2026-04-12T09:52:31.786694+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/CBMilwFBVV95cUxPdHEtMHRKWXo4S2FkRFJxdm0zbzM4Vk9Vemh3dTloSkh1TExITWR0bG1tbFl0c2F3RXZCSElvUWRQNDZfRkFvN3FQWEVETzB4MG9fTzRSMHE2UnIzZVowN0JuUTZLVzdJSlRaY3IzV0N3eF8ySElJUUczNnJDWGxqdWpYUWlKNm1wM082R1JIdWJsWkRhQTVJ?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_08c8e89f50f951df","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-12T09:54:00.733767+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxPdHEtMHRKWXo4S2FkRFJxdm0zbzM4Vk9Vemh3dTloSkh1TExITWR0bG1tbFl0c2F3RXZCSElvUWRQNDZfRkFvN3FQWEVETzB4MG9fTzRSMHE2UnIzZVowN0JuUTZLVzdJSlRaY3IzV0N3eF8ySElJUUczNnJDWGxqdWpYUWlKNm1wM082R1JIdWJsWkRhQTVJ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"businessinsider.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxPdHEtMHRKWXo4S2FkRFJxdm0zbzM4Vk9Vemh3dTloSkh1TExITWR0bG1tbFl0c2F3RXZCSElvUWRQNDZfRkFvN3FQWEVETzB4MG9fTzRSMHE2UnIzZVowN0JuUTZLVzdJSlRaY3IzV0N3eF8ySElJUUczNnJDWGxqdWpYUWlKNm1wM082R1JIdWJsWkRhQTVJ?oc=5","source_event_id":"evt_3be6c52a1d03","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"d54a4e3b1a91046e","published_at":"2026-04-12T09:45:00+00:00","publisher_domain":"businessinsider.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Citi","relevance":"context/source attribution","symbol":"","type":"company"},{"asset_class":"other","name":"Business Insider","relevance":"source of the headline","symbol":"","type":"publisher"}],"event_type":"earnings","information_gaps":["The names/tickers of the 16 stocks are not provided.","No Q1 earnings date/timing or catalyst window is specified.","No performance metrics, valuation rationale, or risk factors are included.","No evidence is provided about whether the stocks are already trading or expected to move on specific earnings releases."],"key_facts":["Headline states: \u201cBuy These 16 Stocks That Are Primed to Pop After Q1 Earnings: Citi - Business Insider.\u201d","Source summary repeats the same claim.","No list of the 16 stocks is included in the provided text."],"numeric_claims":[{"label":"number_of_stocks","value":"16"}],"primary_claim":"Business Insider published a Citi-related article claiming 16 stocks are primed to rise after Q1 earnings.","relevance_score":0.35,"sentiment":"positive","source_quality":"unknown","summary":"Business Insider (via a Citi-related piece) lists 16 stocks described as \u201cprimed to pop after Q1 earnings.\u201d No article details are provided beyond the headline and source summary.","topics":["Q1 earnings","stock picks","equity research","market reaction"]},"source":"Business Insider","source_domain":"businessinsider.com","source_url":"https://www.businessinsider.com","summary":"Buy These 16 Stocks That Are Primed to Pop After Q1 Earnings: Citi Business Insider","title":"Buy These 16 Stocks That Are Primed to Pop After Q1 Earnings: Citi - Business Insider","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 28580 in events