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-10T00:20:06.662113+00:00","dedupe_key":"signal_enriched:news_delta:7f38d264ccbe785a","evidence_event_ids":["evt_858881acd2bd"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxQbVhjbkF1cUQ2eDNfeVdSTG5nNHZ3eXpWNGhCNjFFc1hzWm43ZmlQZE8wTkczeEFPWl9mT25BTE5HYldhcUpBaXUtaFdBcEpEbVZNTHRGVy1EbklnTjlacHZtRS01Wl91bS1YQS03bVREeUZWQ29xTy1OWlRWd1VOa08zUXhfdlFtSEY5TmdHa1JOM0dpMDQxajdxSjRCRE1xLVJaRzFVRUhrU2NP?oc=5","as_of":"2026-04-10T00:20:06.662113+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/CBMirAFBVV95cUxQbVhjbkF1cUQ2eDNfeVdSTG5nNHZ3eXpWNGhCNjFFc1hzWm43ZmlQZE8wTkczeEFPWl9mT25BTE5HYldhcUpBaXUtaFdBcEpEbVZNTHRGVy1EbklnTjlacHZtRS01Wl91bS1YQS03bVREeUZWQ29xTy1OWlRWd1VOa08zUXhfdlFtSEY5TmdHa1JOM0dpMDQxajdxSjRCRE1xLVJaRzFVRUhrU2NP?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_952cf93b192d5023","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-10T00:58:36.165538+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxQbVhjbkF1cUQ2eDNfeVdSTG5nNHZ3eXpWNGhCNjFFc1hzWm43ZmlQZE8wTkczeEFPWl9mT25BTE5HYldhcUpBaXUtaFdBcEpEbVZNTHRGVy1EbklnTjlacHZtRS01Wl91bS1YQS03bVREeUZWQ29xTy1OWlRWd1VOa08zUXhfdlFtSEY5TmdHa1JOM0dpMDQxajdxSjRCRE1xLVJaRzFVRUhrU2NP?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nbcnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxQbVhjbkF1cUQ2eDNfeVdSTG5nNHZ3eXpWNGhCNjFFc1hzWm43ZmlQZE8wTkczeEFPWl9mT25BTE5HYldhcUpBaXUtaFdBcEpEbVZNTHRGVy1EbklnTjlacHZtRS01Wl91bS1YQS03bVREeUZWQ29xTy1OWlRWd1VOa08zUXhfdlFtSEY5TmdHa1JOM0dpMDQxajdxSjRCRE1xLVJaRzFVRUhrU2NP?oc=5","source_event_id":"evt_858881acd2bd","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0265923cd68fb23a","published_at":"2026-04-09T16:35:18+00:00","publisher_domain":"nbcnews.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":"","name":"NBC News","relevance":"publisher/source","symbol":"","type":"media_outlet"},{"asset_class":"literature","name":"The Housemaid","relevance":"work associated with the author","symbol":"","type":"book"}],"event_type":"other","information_gaps":["The cleaned article text provided contains no readable content beyond page styling, so the specific details of what her \u201ctrue identity\u201d is (e.g., legal name, prior identity, timeline) are not available here.","No information is provided about when the revelation occurred or whether it affects publishing contracts, royalties, or future releases.","The signal includes other outlets (USA Today, Yahoo, The Guardian, AOL) but only NBC News is explicitly identified as the source in the structured context; cross-verification of details is not possible from the provided text."],"key_facts":["The signal is based on an NBC News headline about Freida McFadden revealing her true/real identity.","The headline frames the disclosure as an \u201cexclusive\u201d revelation.","The disclosure is described as ending or exposing a \u201cdouble life\u201d lasting about 13 years (per the provided multi-outlet headline text)."],"numeric_claims":[{"label":"double life duration (years)","value":"13"}],"primary_claim":"Freida McFadden has revealed her real/true identity after a long period of concealing it.","relevance_score":0.28,"sentiment":"neutral","source_quality":"high","summary":"NBC News reports that bestselling author Freida McFadden has revealed her \u201ctrue identity,\u201d ending a long-running double life. The headline suggests a major personal disclosure that is likely to drive renewed public attention to her work.","topics":["author identity revelation","bestselling novel","media coverage","public disclosure"]},"source":"NBC News","source_domain":"nbcnews.com","source_url":"https://www.nbcnews.com","summary":"'The Housemaid' author Freida McFadden reveals her true identity NBC News 'The Housemaid' author Freida McFadden reveals her real identity \u2013 Exclusive USA Today 'The Housemaid' author Freida McFadden reveals her real identity Yahoo The Housemaid author Freida McFadden reveals her true identity The Guardian Bestselling Author Shocks Fans By Revealing True Identity After 13 Years Of Double Life AOL.com","title":"'The Housemaid' author Freida McFadden reveals her true identity - NBC News","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 11706 in events