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/CBMiowFBVV95cUxQY2dHeVYtYUplSVpkSU1ZRWZBY0s4LW1NQ0ptZDRoMFdueG1NY0tVTUhtNUt3WU5pRmMzMExjOWJZVHNyU0RCamtOOHg3QjdkcUhYVTFBRnljSGFZMUNpTWE1MzQwM0ZKS1FyclY0MXM1eDY3U1VIUWlRdkFBNmx2bHdZTDc2R2cybUw3WGgyT1o1Q3k0SWswd3MtRS1fRnJxbHQ4?oc=5","as_of":"2026-04-08T11:43:27.549776+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiowFBVV95cUxQY2dHeVYtYUplSVpkSU1ZRWZBY0s4LW1NQ0ptZDRoMFdueG1NY0tVTUhtNUt3WU5pRmMzMExjOWJZVHNyU0RCamtOOHg3QjdkcUhYVTFBRnljSGFZMUNpTWE1MzQwM0ZKS1FyclY0MXM1eDY3U1VIUWlRdkFBNmx2bHdZTDc2R2cybUw3WGgyT1o1Q3k0SWswd3MtRS1fRnJxbHQ4?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2fbdd393287d53a8","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T11:44:12.915053+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiowFBVV95cUxQY2dHeVYtYUplSVpkSU1ZRWZBY0s4LW1NQ0ptZDRoMFdueG1NY0tVTUhtNUt3WU5pRmMzMExjOWJZVHNyU0RCamtOOHg3QjdkcUhYVTFBRnljSGFZMUNpTWE1MzQwM0ZKS1FyclY0MXM1eDY3U1VIUWlRdkFBNmx2bHdZTDc2R2cybUw3WGgyT1o1Q3k0SWswd3MtRS1fRnJxbHQ4?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/CBMiowFBVV95cUxQY2dHeVYtYUplSVpkSU1ZRWZBY0s4LW1NQ0ptZDRoMFdueG1NY0tVTUhtNUt3WU5pRmMzMExjOWJZVHNyU0RCamtOOHg3QjdkcUhYVTFBRnljSGFZMUNpTWE1MzQwM0ZKS1FyclY0MXM1eDY3U1VIUWlRdkFBNmx2bHdZTDc2R2cybUw3WGgyT1o1Q3k0SWswd3MtRS1fRnJxbHQ4?oc=5","source_event_id":"evt_1af28c7402a6","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ead2cfee9e368861","published_at":"2026-04-08T09:00:00+00:00","publisher_domain":"npr.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Abortion clinics","relevance":"affected","symbol":"","type":"organization_type"},{"asset_class":"","name":"Urgent care","relevance":"proposed/considered alternative","symbol":"","type":"healthcare_service"},{"asset_class":"","name":"NPR","relevance":"source","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["No specific number of closures, locations, or timeline is provided in the provided text.","No details are given on how urgent care would fill the gap (e.g., services offered, regulatory constraints, capacity).","No evidence or data from the article body is included in the provided text beyond the headline/summary."],"key_facts":["NPR headline states that abortion clinics are closing nationwide.","NPR headline frames a question about whether urgent care could help fill the gap created by clinic closures."],"numeric_claims":[],"primary_claim":"Abortion clinics are closing nationwide, and the article considers whether urgent care could fill the gap.","relevance_score":0.55,"sentiment":"mixed","source_quality":"high","summary":"NPR reports that abortion clinics are closing nationwide and asks whether urgent care could help address the resulting access gap.","topics":["healthcare access","abortion services","clinic closures","urgent care"]},"source":"NPR","source_domain":"npr.org","source_url":"https://www.npr.org","summary":"Abortion clinics are closing nationwide. Could urgent care help fill the gap? NPR","title":"Abortion clinics are closing nationwide. Could urgent care help fill the gap? - NPR","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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_2712da0c7487 in signals