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/CBMikAFBVV95cUxNM1lIWVdjSjVlM1ZxdEhlX1BMcmZtb1FKZG5icnhLQVhYdGFFWnBHNHBpZXM0Mmg3R1pnU3pNOVp5VWZPQjRCcGF5V180VDIySFc0V3U2Y2s3aXk5dVV2alk2UGtsYjM4THVyb3VvbHZHRlhkUndkODJFa2QwdDlSdWxERHdNbEx6anVUanVFdGE?oc=5","as_of":"2026-04-09T20:52:32.406366+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/CBMikAFBVV95cUxNM1lIWVdjSjVlM1ZxdEhlX1BMcmZtb1FKZG5icnhLQVhYdGFFWnBHNHBpZXM0Mmg3R1pnU3pNOVp5VWZPQjRCcGF5V180VDIySFc0V3U2Y2s3aXk5dVV2alk2UGtsYjM4THVyb3VvbHZHRlhkUndkODJFa2QwdDlSdWxERHdNbEx6anVUanVFdGE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2b9aa512d62d23e1","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:32:32.594668+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxNM1lIWVdjSjVlM1ZxdEhlX1BMcmZtb1FKZG5icnhLQVhYdGFFWnBHNHBpZXM0Mmg3R1pnU3pNOVp5VWZPQjRCcGF5V180VDIySFc0V3U2Y2s3aXk5dVV2alk2UGtsYjM4THVyb3VvbHZHRlhkUndkODJFa2QwdDlSdWxERHdNbEx6anVUanVFdGE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"npr.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxNM1lIWVdjSjVlM1ZxdEhlX1BMcmZtb1FKZG5icnhLQVhYdGFFWnBHNHBpZXM0Mmg3R1pnU3pNOVp5VWZPQjRCcGF5V180VDIySFc0V3U2Y2s3aXk5dVV2alk2UGtsYjM4THVyb3VvbHZHRlhkUndkODJFa2QwdDlSdWxERHdNbEx6anVUanVFdGE?oc=5","source_event_id":"evt_5ca10c9e1b97","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"dfb02e37ce1193e5","published_at":"2026-04-09T18:45:39+00:00","publisher_domain":"npr.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":["last year","two decades ago","2025"],"entities":[{"asset_class":"sovereign","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"media","name":"NPR","relevance":"medium","symbol":"","type":"media_outlet"}],"event_type":"macro_policy","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the NPR article\u2019s substantive content, so only the headline and the provided source summary can be treated as grounded.","The exact year of \u201clast year\u201d and the baseline year used for the \u201ctwo decades ago\u201d comparison are not specified in the provided text.","The signal includes other publishers\u2019 claims (Yahoo/NYT/Reuters/Al Jazeera) but they are not directly quoted from their articles here; therefore those details are uncertain beyond the signal\u2019s mention."],"key_facts":["NPR headline states: 710,000 fewer babies were born last year in the U.S. compared with two decades ago.","The signal summary states the U.S. fertility rate dropped again.","Additional cited headlines in the signal (not verified from NPR text provided) indicate fertility rates are at record lows in 2025 and continuing a two-decade decline."],"numeric_claims":[{"label":"fewer births","value":"710,000 fewer"}],"primary_claim":"The U.S. had 710,000 fewer babies born last year than compared with two decades ago, alongside another drop in the fertility rate.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"NPR reports that the U.S. saw 710,000 fewer births last year than would have occurred compared with about two decades ago, reflecting another drop in fertility. The broader coverage cited in the signal indicates the U.S. fertility rate is falling to record lows and continuing a long decline.","topics":["fertility rate","births","demographics","U.S. population trends"]},"source":"NPR","source_domain":"npr.org","source_url":"https://www.npr.org","summary":"710,000 fewer babies were born last year in U.S. compared with two decades ago NPR The U.S. fertility rate dropped again. What's the big deal? Yahoo Women in Their 20s May Not Be Having Babies, but by 45 Most Probably Will The New York Times US fertility rates drop to record low in 2025 as births fall Reuters US fertility rate drops to all-time low, continuing a two-decade decline Al Jazeera","title":"710,000 fewer babies were born last year in U.S. compared with two decades ago - NPR","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_5140d90765cf in signals