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/CBMimwFBVV95cUxOSzBGS3djbVl5OHhsRlhyWHc4ZGZTaWtfYnVMUDUzMDd2aGR1SUJFV3BvUWoycGl2ejlLR0dvdXNfT1h6azdSaXc4UEpzeF9UVHF3Mk96NW1XMmk3UUE2OFpKUl9DTXlvSzh3Tnpwd0l6a1RhekxHak9rRUx2emxSdW1rMnhnSUJ0WXBDMDFkVWZ0TnZXZnV1Rjh3WQ?oc=5","as_of":"2026-04-09T12:52:06.151589+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/CBMimwFBVV95cUxOSzBGS3djbVl5OHhsRlhyWHc4ZGZTaWtfYnVMUDUzMDd2aGR1SUJFV3BvUWoycGl2ejlLR0dvdXNfT1h6azdSaXc4UEpzeF9UVHF3Mk96NW1XMmk3UUE2OFpKUl9DTXlvSzh3Tnpwd0l6a1RhekxHak9rRUx2emxSdW1rMnhnSUJ0WXBDMDFkVWZ0TnZXZnV1Rjh3WQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b38bb654e485cf9b","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-09T23:25:15.038555+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxOSzBGS3djbVl5OHhsRlhyWHc4ZGZTaWtfYnVMUDUzMDd2aGR1SUJFV3BvUWoycGl2ejlLR0dvdXNfT1h6azdSaXc4UEpzeF9UVHF3Mk96NW1XMmk3UUE2OFpKUl9DTXlvSzh3Tnpwd0l6a1RhekxHak9rRUx2emxSdW1rMnhnSUJ0WXBDMDFkVWZ0TnZXZnV1Rjh3WQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"apnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxOSzBGS3djbVl5OHhsRlhyWHc4ZGZTaWtfYnVMUDUzMDd2aGR1SUJFV3BvUWoycGl2ejlLR0dvdXNfT1h6azdSaXc4UEpzeF9UVHF3Mk96NW1XMmk3UUE2OFpKUl9DTXlvSzh3Tnpwd0l6a1RhekxHak9rRUx2emxSdW1rMnhnSUJ0WXBDMDFkVWZ0TnZXZnV1Rjh3WQ?oc=5","source_event_id":"evt_5b61f54eca0e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"15f24771736d2606","published_at":"2026-04-09T04:08:00+00:00","publisher_domain":"apnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"AP News","relevance":"primary_source","symbol":"","type":"news_outlet"},{"asset_class":"sovereign_government","name":"U.S. states","relevance":"affected_parties","symbol":"","type":"government_entities"},{"asset_class":"infrastructure","name":"Data centers","relevance":"causal_factor","symbol":"","type":"infrastructure_sector"},{"asset_class":"infrastructure","name":"U.S. power grid","relevance":"mechanism","symbol":"","type":"critical_infrastructure"}],"event_type":"macro_policy","information_gaps":["The provided text does not include the specific AP News article details (e.g., which states, which clean energy targets, or quantified grid/electricity impacts).","No explicit policy mechanism is stated in the extracted content (e.g., whether data centers are being required to pay for grid upgrades).","No near-term timing (dates/quarters) for catalysts or policy actions is included in the provided material."],"key_facts":["AP News headline indicates states are struggling to meet clean energy goals.","AP News attributes the strain to data centers.","A related theme in the provided source summary is that data centers are straining the U.S. power grid."],"numeric_claims":[],"primary_claim":"States are struggling to meet their clean energy goals because data centers are straining the U.S. power grid.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"AP News reports that U.S. states are struggling to meet their clean energy goals, with data centers identified as a key driver of the problem by straining electricity supply and the power grid.","topics":["clean energy goals","state energy policy","data center electricity demand","power grid strain","electricity infrastructure costs"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"States are struggling to meet their clean energy goals. Data centers are to blame AP News Opinion: These infrastructure stocks are gaining smart-money interest as data centers strain the U.S. power grid MarketWatch States are struggling to meet their clean energy goals. Data centers are to blame. Pittsburgh Post-Gazette Data centers are straining the grid. Can they be forced to pay for it? grist.org You're Paying for AI in Your Electric Bill: The Debate Over How to Power America's Data Centers cbn.com","title":"States are struggling to meet their clean energy goals. Data centers are to blame - AP 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_4220e3c44f8b in signals