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-10T08:19:32.479759+00:00","dedupe_key":"signal_enriched:news_delta:2c06d2d079ed97a5","evidence_event_ids":["evt_76703d37a987"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxNY1F3WExpNWJIYWxaenY3SmJzbTNtdUV2UU0xMDdEV1BDblJKY0hQQ0lCSjJYc21nTHREaEtqRVpJak5lbV9Ob2tUV2Y3cUptdWZDanAzalhBTGFtRHpudlR2UHJzcXM5cU1uZ2MwcGw3cTcydnlLenVvQkpNVWpRaE5WM2FCNTVSMHRoQmE0ZmV0QnAyclBOS0R4YkhZNmNwT3pnc3V0R3NHTUpHNEtnYw?oc=5","as_of":"2026-04-10T08:19:32.479759+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/CBMisAFBVV95cUxNY1F3WExpNWJIYWxaenY3SmJzbTNtdUV2UU0xMDdEV1BDblJKY0hQQ0lCSjJYc21nTHREaEtqRVpJak5lbV9Ob2tUV2Y3cUptdWZDanAzalhBTGFtRHpudlR2UHJzcXM5cU1uZ2MwcGw3cTcydnlLenVvQkpNVWpRaE5WM2FCNTVSMHRoQmE0ZmV0QnAyclBOS0R4YkhZNmNwT3pnc3V0R3NHTUpHNEtnYw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b76ac690b681d0aa","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-10T08:20:43.025748+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxNY1F3WExpNWJIYWxaenY3SmJzbTNtdUV2UU0xMDdEV1BDblJKY0hQQ0lCSjJYc21nTHREaEtqRVpJak5lbV9Ob2tUV2Y3cUptdWZDanAzalhBTGFtRHpudlR2UHJzcXM5cU1uZ2MwcGw3cTcydnlLenVvQkpNVWpRaE5WM2FCNTVSMHRoQmE0ZmV0QnAyclBOS0R4YkhZNmNwT3pnc3V0R3NHTUpHNEtnYw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"hollywoodreporter.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxNY1F3WExpNWJIYWxaenY3SmJzbTNtdUV2UU0xMDdEV1BDblJKY0hQQ0lCSjJYc21nTHREaEtqRVpJak5lbV9Ob2tUV2Y3cUptdWZDanAzalhBTGFtRHpudlR2UHJzcXM5cU1uZ2MwcGw3cTcydnlLenVvQkpNVWpRaE5WM2FCNTVSMHRoQmE0ZmV0QnAyclBOS0R4YkhZNmNwT3pnc3V0R3NHTUpHNEtnYw?oc=5","source_event_id":"evt_76703d37a987","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f1a1b9d7fc04dcab","published_at":"2026-04-09T17:11:34+00:00","publisher_domain":"hollywoodreporter.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Freida McFadden","relevance":"primary subject","symbol":"","type":"person"},{"asset_class":"literature","name":"The Housemaid","relevance":"work associated with the author","symbol":"","type":"book"},{"asset_class":"","name":"The Hollywood Reporter","relevance":"source of the headline","symbol":"","type":"publisher"},{"asset_class":"","name":"BBC","relevance":"additional outlet referenced in the signal","symbol":"","type":"publisher"},{"asset_class":"","name":"The Boston Globe","relevance":"additional outlet referenced in the signal","symbol":"","type":"publisher"},{"asset_class":"","name":"The Guardian","relevance":"additional outlet referenced in the signal","symbol":"","type":"publisher"},{"asset_class":"","name":"TODAY.com","relevance":"additional outlet referenced in the signal","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the actual article content, so the extracted facts rely on the provided source summary/headline rather than the full article body.","The signal does not specify Freida McFadden\u2019s actual legal name (only that she is a Boston-area brain doctor).","Near-term catalyst timing for any market/financial impact is not applicable/unclear from the provided signal."],"key_facts":["The Hollywood Reporter headline states that \u201cThe Housemaid\u201d author finally shares her real identity.","The signal summary indicates the author is Freida McFadden.","The signal summary states she is a Boston-area brain doctor.","The signal summary states she used a pen name for 13 years (timing/context for the reveal)."],"numeric_claims":[{"label":"pen name duration (years)","value":"13"}],"primary_claim":"Freida McFadden has finally revealed her real identity as a Boston-area brain doctor after using a pen name for 13 years.","relevance_score":0.22,"sentiment":"neutral","source_quality":"high","summary":"The Hollywood Reporter reports that bestselling \u201cThe Housemaid\u201d author Freida McFadden has publicly revealed her real identity after writing under a pen name for about 13 years. The disclosed identity is that she is a Boston-area brain doctor.","topics":["author identity reveal","pen name","bestselling novel","publishing","media coverage"]},"source":"The Hollywood Reporter","source_domain":"hollywoodreporter.com","source_url":"https://www.hollywoodreporter.com","summary":"\u2018The Housemaid\u2019 Author Finally Shares Real Identity The Hollywood Reporter Best-selling The Housemaid author Freida McFadden reveals true identity BBC \u2018The Housemaid\u2019 author Freida McFadden \u2014 a Boston-area brain doctor \u2014 finally reveals her identity The Boston Globe The Housemaid author Freida McFadden reveals her true identity The Guardian Author Freida McFadden Reveals Real Identity After Using Pen Name for 13 Years TODAY.com","title":"\u2018The Housemaid\u2019 Author Finally Shares Real Identity - The Hollywood Reporter","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 14965 in events