SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-09T06:04:20.702642+00:00","dedupe_key":"signal_enriched:news_delta:fe6e471bf91421e9","evidence_event_ids":["evt_46f40a43c763"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxNa1N6UjZjck1FaWVGNXlMdHplNGlPMUFqeUlxMU5iazZiSHFzR2E2YmVzc29aSTZHRTg3ZDlQbk93TTBINUwxX1ctZVZYTTJxdVU5d2JLeWVDMzRTNjNZTzRiM3RxRDlheTFYQWkwbUFxTDRCaVRDamRSX2doclFDWEhHQWZpaHN3QnZhQU5MQQ?oc=5","as_of":"2026-04-09T06:04:20.702642+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/CBMijwFBVV95cUxNa1N6UjZjck1FaWVGNXlMdHplNGlPMUFqeUlxMU5iazZiSHFzR2E2YmVzc29aSTZHRTg3ZDlQbk93TTBINUwxX1ctZVZYTTJxdVU5d2JLeWVDMzRTNjNZTzRiM3RxRDlheTFYQWkwbUFxTDRCaVRDamRSX2doclFDWEhHQWZpaHN3QnZhQU5MQQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f0705590663fa2d3","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-09T22:44:16.186518+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxNa1N6UjZjck1FaWVGNXlMdHplNGlPMUFqeUlxMU5iazZiSHFzR2E2YmVzc29aSTZHRTg3ZDlQbk93TTBINUwxX1ctZVZYTTJxdVU5d2JLeWVDMzRTNjNZTzRiM3RxRDlheTFYQWkwbUFxTDRCaVRDamRSX2doclFDWEhHQWZpaHN3QnZhQU5MQQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxNa1N6UjZjck1FaWVGNXlMdHplNGlPMUFqeUlxMU5iazZiSHFzR2E2YmVzc29aSTZHRTg3ZDlQbk93TTBINUwxX1ctZVZYTTJxdVU5d2JLeWVDMzRTNjNZTzRiM3RxRDlheTFYQWkwbUFxTDRCaVRDamRSX2doclFDWEhHQWZpaHN3QnZhQU5MQQ?oc=5","source_event_id":"evt_46f40a43c763","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"805b175ce8b4cbc4","published_at":"2026-04-09T04:01:27+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["Tuesday"],"entities":[{"asset_class":"other","name":"Clean Energy Slate","relevance":"high","symbol":"","type":"political_group"},{"asset_class":"utility","name":"Salt River Project (SRP)","relevance":"high","symbol":"","type":"utility_company"},{"asset_class":"other","name":"Arizona","relevance":"medium","symbol":"","type":"region"},{"asset_class":"other","name":"Turning Point","relevance":"medium","symbol":"","type":"political_group"}],"event_type":"listing","information_gaps":["The provided text does not specify the exact vote totals, seat counts, or which SRP board positions were won.","The provided text does not state the effective date of the new control or immediate policy changes.","The provided text does not clarify what \u201ccontrol\u201d means operationally (e.g., majority of board seats vs. specific leadership roles).","No direct details are included about SRP\u2019s planned actions (e.g., generation mix, rates, or regulatory filings) following the election."],"key_facts":["Clean Energy Slate won control of SRP, described as Arizona\u2019s biggest utility.","The SRP election drew increased attention due to climate activists\u2019 gains.","The election was held as voters went to polls on Tuesday (near-term timing).","The election saw long lines and early ballots reportedly about three times the amount from the prior year (as stated in the provided source summary).","The election outcome is described as jolting/ surprising attention, with multiple outlets referenced (NYT, azcentral/The Arizona Republic, AP, KJZZ)."],"numeric_claims":[{"label":"early ballots (vs prior year)","value":"3x"}],"primary_claim":"Clean Energy Slate won control of Arizona\u2019s biggest utility, Salt River Project (SRP), in SRP elections.","relevance_score":0.74,"sentiment":"mixed","source_quality":"high","summary":"Clean Energy Slate won control of Salt River Project (SRP), Arizona\u2019s biggest utility, in elections that drew heightened attention from climate activists. The result is expected to shift SRP\u2019s direction on energy and policy matters in the near term.","topics":["utility governance","elections","climate activism","energy policy","SRP","Arizona electricity bills"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Clean Energy Slate Wins Control of Arizona\u2019s Biggest Utility The New York Times Climate activists make gains in SRP elections jolted by Turning Point azcentral.com and The Arizona Republic Salt River Project election gaining surprising attention as voters go to polls Tuesday ABC15 Arizona Low-voltage utility elections face surge of attention as electricity bills rise AP News The normally sleepy SRP election was marked by long lines, 3 times the early ballots this year KJZZ","title":"Clean Energy Slate Wins Control of Arizona\u2019s Biggest Utility - The New York Times","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 9138 in events