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/CBMisAFBVV95cUxNZm5rZlpjT3BiTEViWTNHd1FzbkoySnFCX1BvQkFabGxaSUJDeWt1ck1kNmxwNDM2N3NPV1NBeEIwQWZEeTNVdjlNRU4tRkNqeHJ5Rk0ydU1uSGt4d3g1QzRUMW9SSXFUQWV3T3JCUnNyT0ZwZXNucUFtbG5CblVTMDNMQlZ3UDYwaldYNW5KOVZBMFNxMVgtUFhveWxzRl90ZEdqdXRub1ZnVmtKc3lUSg?oc=5","as_of":"2026-04-08T06:04:59.282414+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/CBMisAFBVV95cUxNZm5rZlpjT3BiTEViWTNHd1FzbkoySnFCX1BvQkFabGxaSUJDeWt1ck1kNmxwNDM2N3NPV1NBeEIwQWZEeTNVdjlNRU4tRkNqeHJ5Rk0ydU1uSGt4d3g1QzRUMW9SSXFUQWV3T3JCUnNyT0ZwZXNucUFtbG5CblVTMDNMQlZ3UDYwaldYNW5KOVZBMFNxMVgtUFhveWxzRl90ZEdqdXRub1ZnVmtKc3lUSg?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a3590a619ee40af2","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-08T06:05:46.366832+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxNZm5rZlpjT3BiTEViWTNHd1FzbkoySnFCX1BvQkFabGxaSUJDeWt1ck1kNmxwNDM2N3NPV1NBeEIwQWZEeTNVdjlNRU4tRkNqeHJ5Rk0ydU1uSGt4d3g1QzRUMW9SSXFUQWV3T3JCUnNyT0ZwZXNucUFtbG5CblVTMDNMQlZ3UDYwaldYNW5KOVZBMFNxMVgtUFhveWxzRl90ZEdqdXRub1ZnVmtKc3lUSg?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"gizmodo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxNZm5rZlpjT3BiTEViWTNHd1FzbkoySnFCX1BvQkFabGxaSUJDeWt1ck1kNmxwNDM2N3NPV1NBeEIwQWZEeTNVdjlNRU4tRkNqeHJ5Rk0ydU1uSGt4d3g1QzRUMW9SSXFUQWV3T3JCUnNyT0ZwZXNucUFtbG5CblVTMDNMQlZ3UDYwaldYNW5KOVZBMFNxMVgtUFhveWxzRl90ZEdqdXRub1ZnVmtKc3lUSg?oc=5","source_event_id":"evt_dbc1a1ec8f81","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"88fe017b5fe09172","published_at":"2026-04-07T20:00:43+00:00","publisher_domain":"gizmodo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Aunt Lydia","relevance":"high","symbol":"","type":"fictional_character"},{"asset_class":"media","name":"\u2018The Handmaid\u2019s Tale\u2019","relevance":"high","symbol":"","type":"tv_series"},{"asset_class":"media","name":"\u2018The Testaments\u2019","relevance":"high","symbol":"","type":"tv_series"},{"asset_class":"media_outlet","name":"Gizmodo","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["No specific episode/season timing for when Aunt Lydia\u2019s survival is established is provided in the supplied text.","No concrete details are given about what \u2018new complexity\u2019 entails (e.g., specific character motivations, conflicts, or outcomes).","The excerpted article text appears to be mostly unrelated page styling/HTML, so only the headline and the provided source summary are usable for grounded extraction."],"key_facts":["The Gizmodo headline states that Aunt Lydia survived \u2018The Handmaid\u2019s Tale.\u2019","The Gizmodo headline frames that survival as bringing new complexity to \u2018The Testaments.\u2019","The provided source summary indicates \u2018The Testaments\u2019 is coming to TV and is described as a sequel to Hulu\u2019s \u2018The Handmaid\u2019s Tale\u2019.","The provided source summary includes additional coverage references (e.g., Deadline/Variety/NPR/NYT) but does not provide specific plot details beyond the headline framing."],"numeric_claims":[],"primary_claim":"Aunt Lydia\u2019s survival from \u2018The Handmaid\u2019s Tale\u2019 is used to introduce new complexity in \u2018The Testaments.\u2019","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"Gizmodo reports that the character Aunt Lydia survives events from Hulu\u2019s \u2018The Handmaid\u2019s Tale\u2019 and that this will add new complexity to the upcoming sequel series \u2018The Testaments.\u2019","topics":["television","streaming","entertainment","adaptation","plot development","sequel series"]},"source":"Gizmodo","source_domain":"gizmodo.com","source_url":"https://gizmodo.com","summary":"Aunt Lydia Survived \u2018The Handmaid\u2019s Tale\u2019 to Bring New Complexity to \u2018The Testaments\u2019 Gizmodo A \u2018Handmaid\u2019s Tale\u2019 Sequel Is Coming to TV. Here\u2019s What You Need to Know. The New York Times 'The Testaments' star Chase Infiniti discusses her 'rocket ship' career success NPR Elisabeth Moss Reprises \u2018Handmaid\u2019s Tale\u2019 Role On \u2018The Testaments\u2019 Series Premiere Deadline \u2018The Testaments\u2019 Is a Stunning Follow-Up to Hulu\u2019s Dystopian \u2018The Handmaid\u2019s Tale\u2019: TV Review Variety","title":"Aunt Lydia Survived \u2018The Handmaid\u2019s Tale\u2019 to Bring New Complexity to \u2018The Testaments\u2019 - Gizmodo","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_a1741d687643 in signals