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-09T02:28:00.775532+00:00","dedupe_key":"signal_enriched:news_delta:c16dc4af1c55fe9c","evidence_event_ids":["evt_da28d622d442"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxPY1FpYjIyZ2ViYXVvVnN0YXN0RjEyNXZMRXlQRGZsb2sta1FkLUV1bHplUUVJaFZhVnNJU0tFRkJTTFhrVFlBemV4RnhSVWVNSFRVdEEtRk9QNzB0WkJrYm9IdGxsQjlrY0RJdmJBWmN0RTJfMXllX3FGbTBxQ2Z0RVVrRUZNaVFoTWlz?oc=5","as_of":"2026-04-09T02:28:00.775532+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/CBMiiwFBVV95cUxPY1FpYjIyZ2ViYXVvVnN0YXN0RjEyNXZMRXlQRGZsb2sta1FkLUV1bHplUUVJaFZhVnNJU0tFRkJTTFhrVFlBemV4RnhSVWVNSFRVdEEtRk9QNzB0WkJrYm9IdGxsQjlrY0RJdmJBWmN0RTJfMXllX3FGbTBxQ2Z0RVVrRUZNaVFoTWlz?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a5aa859a714b1e04","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-09T22:25:09.213694+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxPY1FpYjIyZ2ViYXVvVnN0YXN0RjEyNXZMRXlQRGZsb2sta1FkLUV1bHplUUVJaFZhVnNJU0tFRkJTTFhrVFlBemV4RnhSVWVNSFRVdEEtRk9QNzB0WkJrYm9IdGxsQjlrY0RJdmJBWmN0RTJfMXllX3FGbTBxQ2Z0RVVrRUZNaVFoTWlz?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"deadline.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxPY1FpYjIyZ2ViYXVvVnN0YXN0RjEyNXZMRXlQRGZsb2sta1FkLUV1bHplUUVJaFZhVnNJU0tFRkJTTFhrVFlBemV4RnhSVWVNSFRVdEEtRk9QNzB0WkJrYm9IdGxsQjlrY0RJdmJBWmN0RTJfMXllX3FGbTBxQ2Z0RVVrRUZNaVFoTWlz?oc=5","source_event_id":"evt_da28d622d442","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6e8d7245d82c0235","published_at":"2026-04-09T01:11:00+00:00","publisher_domain":"deadline.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Freida McFadden","relevance":"high","symbol":"","type":"person"},{"asset_class":"literature","name":"The Housemaid","relevance":"high","symbol":"","type":"work"},{"asset_class":"","name":"Deadline","relevance":"high","symbol":"","type":"publisher"},{"asset_class":"","name":"USA Today","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"","name":"People.com","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"","name":"E! News","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"","name":"10TV","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The cleaned article text provided contains no substantive body content beyond page styling; only the headline and source summary are available for extraction.","The signal does not specify what the \u201ctrue identity\u201d is (e.g., legal name) or the exact date/time of the reveal.","No details are provided about whether the identity change affects publishing contracts, royalties, or future releases."],"key_facts":["Deadline headline states that \u201cThe Housemaid\u201d author Freida McFadden reveals her true identity.","The disclosure is described as coming after keeping her identity secret for 23 years.","The headline includes the phrase \u201cIt\u2019s Time,\u201d implying a deliberate timing for the reveal."],"numeric_claims":[{"label":"years identity kept secret","value":"23"}],"primary_claim":"Freida McFadden revealed her real identity after keeping it secret for 23 years, according to Deadline.","relevance_score":0.18,"sentiment":"neutral","source_quality":"high","summary":"Deadline reports that author Freida McFadden has revealed her true identity after keeping it secret for 23 years, framed as a long-awaited disclosure. The headline suggests the reveal is a notable personal/branding update rather than a business or policy change.","topics":["publishing","author identity","book marketing","media coverage"]},"source":"Deadline","source_domain":"deadline.com","source_url":"https://deadline.com","summary":"\u2018The Housemaid\u2019 Author Reveals True Identity: \u201cIt\u2019s Time\u201d Deadline 'The Housemaid' author Freida McFadden reveals her real identity \u2013 Exclusive USA Today 'The Housemaid' Author Freida McFadden Reveals Her True Identity After Keeping It Secret for 23 Years People.com Housemaid Author Freida McFadden Finally Reveals Her Real Identity E! News Author of 'The Housemaid' reveals her true identity 10TV","title":"\u2018The Housemaid\u2019 Author Reveals True Identity: \u201cIt\u2019s Time\u201d - Deadline","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 8715 in events