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/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

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_321563352fe6 in signals