SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

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

event_store.db — signals

Update row sig_631be0be2e9b in signals