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/CBMiY0FVX3lxTFBiRHdZQVBmYnZHazJ4NDZ6MUxNT0QxQ0NSdlhfLWVhbUMtUWZzMS1lbll6dUxhdW5GNnVnWGdxVTFoekNVc3JkTjdrZUdiZFdqQ1h2dXd5VmtYUVNsamZxemFWVQ?oc=5","as_of":"2026-04-08T05:04:20.600838+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/CBMiY0FVX3lxTFBiRHdZQVBmYnZHazJ4NDZ6MUxNT0QxQ0NSdlhfLWVhbUMtUWZzMS1lbll6dUxhdW5GNnVnWGdxVTFoekNVc3JkTjdrZUdiZFdqQ1h2dXd5VmtYUVNsamZxemFWVQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6a0c485235ea0716","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-08T05:04:39.395619+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiY0FVX3lxTFBiRHdZQVBmYnZHazJ4NDZ6MUxNT0QxQ0NSdlhfLWVhbUMtUWZzMS1lbll6dUxhdW5GNnVnWGdxVTFoekNVc3JkTjdrZUdiZFdqQ1h2dXd5VmtYUVNsamZxemFWVQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"tmz.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiY0FVX3lxTFBiRHdZQVBmYnZHazJ4NDZ6MUxNT0QxQ0NSdlhfLWVhbUMtUWZzMS1lbll6dUxhdW5GNnVnWGdxVTFoekNVc3JkTjdrZUdiZFdqQ1h2dXd5VmtYUVNsamZxemFWVQ?oc=5","source_event_id":"evt_69d9e98d2bd1","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b7987647ffd63b36","published_at":"2026-04-08T01:23:28+00:00","publisher_domain":"tmz.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":["one year after"],"entities":[{"asset_class":"","name":"Aubrey Plaza","relevance":"primary subject","symbol":"","type":"person"},{"asset_class":"","name":"TMZ","relevance":"source of headline","symbol":"","type":"media_outlet"},{"asset_class":"","name":"Jeff Baena","relevance":"context: husband\u2019s death timing mentioned","symbol":"","type":"person"},{"asset_class":"","name":"Christopher Abbott","relevance":"context: co-star mentioned as partner in other source summaries","symbol":"","type":"person"}],"event_type":"other","information_gaps":["The cleaned article text provided contains only CSS/HTML styling and no readable article content; only the headline and the provided source summary are usable.","No specific pregnancy timeline (e.g., trimester, due date) is included in the provided text.","The relationship details (e.g., who the father is) are only mentioned in other source summaries, not in the TMZ headline itself."],"key_facts":["TMZ headline states: \"Aubrey Plaza Is Pregnant\".","Source summary indicates the pregnancy is her first baby.","Other provided source summaries state she is expecting her first child about one year after husband Jeff Baena\u2019s death.","Other provided source summaries state she is expecting first child with \"Girls\" star Christopher Abbott."],"numeric_claims":[],"primary_claim":"Aubrey Plaza is pregnant and expecting her first baby (TMZ exclusive).","relevance_score":0.18,"sentiment":"neutral","source_quality":"high","summary":"TMZ reports that Aubrey Plaza is pregnant and expecting her first baby. The signal also notes she is expecting about a year after her husband Jeff Baena\u2019s death.","topics":["celebrity news","pregnancy announcement","personal life","family","media coverage"]},"source":"TMZ","source_domain":"tmz.com","source_url":"https://www.tmz.com","summary":"Aubrey Plaza Is Pregnant TMZ Aubrey Plaza Is Pregnant with Her First Baby (Exclusive) People.com Aubrey Plaza expecting first child Yahoo Aubrey Plaza Is Pregnant, Expecting First Baby One Year After Husband Jeff Baena's Death E! News Aubrey Plaza expecting first child with 'Girls' star Christopher Abbott Entertainment Weekly","title":"Aubrey Plaza Is Pregnant - TMZ","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_23f0f3381481 in signals