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-08T20:43:08.936476+00:00","dedupe_key":"signal_enriched:news_delta:6f1aca59814cf6a0","evidence_event_ids":["evt_d3c6cbbe84ae"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxOeXByVjdvS0dkb3ktMkFJNmlnbTl3by1HVUp5VmpNNnhoN0ctZGJKSmtnRTFna2RTZmoxVVh1dHVvZ0llOW5mY0xNb2U2N3BwUWpiYkJoQ0tOTDVPd1IxLWhNM2M3dGhHbHc1cmQycTBLVXd6T3pBRk5ZeUFJUEE2WnM1Zw?oc=5","as_of":"2026-04-08T20:43:08.936476+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/CBMigwFBVV95cUxOeXByVjdvS0dkb3ktMkFJNmlnbTl3by1HVUp5VmpNNnhoN0ctZGJKSmtnRTFna2RTZmoxVVh1dHVvZ0llOW5mY0xNb2U2N3BwUWpiYkJoQ0tOTDVPd1IxLWhNM2M3dGhHbHc1cmQycTBLVXd6T3pBRk5ZeUFJUEE2WnM1Zw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f4079979d835e2e8","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:11:47.695479+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxOeXByVjdvS0dkb3ktMkFJNmlnbTl3by1HVUp5VmpNNnhoN0ctZGJKSmtnRTFna2RTZmoxVVh1dHVvZ0llOW5mY0xNb2U2N3BwUWpiYkJoQ0tOTDVPd1IxLWhNM2M3dGhHbHc1cmQycTBLVXd6T3pBRk5ZeUFJUEE2WnM1Zw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"washingtonpost.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxOeXByVjdvS0dkb3ktMkFJNmlnbTl3by1HVUp5VmpNNnhoN0ctZGJKSmtnRTFna2RTZmoxVVh1dHVvZ0llOW5mY0xNb2U2N3BwUWpiYkJoQ0tOTDVPd1IxLWhNM2M3dGhHbHc1cmQycTBLVXd6T3pBRk5ZeUFJUEE2WnM1Zw?oc=5","source_event_id":"evt_d3c6cbbe84ae","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"d18bd0f018d94b6b","published_at":"2026-04-08T18:04:22+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["through Friday","Tuesday Evening Forecast"],"entities":[{"asset_class":"geography","name":"Hawaii","relevance":"high","symbol":"","type":"region"},{"asset_class":"media","name":"Washington Post","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"media","name":"CNN","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"media","name":"KITV","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"media","name":"The New York Times","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"media","name":"hawaiinewsnow.com","relevance":"low","symbol":"","type":"publisher/website"}],"event_type":"supply_disruption","information_gaps":["The cleaned article text provided is largely HTML/CSS and does not contain the substantive weather details; extraction relies on the provided headline and source summary rather than the full article body.","Specific rainfall totals, affected islands/locations, and whether any evacuations or official emergency declarations occurred are not included in the provided text.","Exact date for \u201cFriday\u201d relative to the article\u2019s publication date is not determinable from the provided content."],"key_facts":["The Washington Post reports Hawaii is bracing for another deluge following record-breaking rain.","First Alert Weather Days were declared for another round of possible heavy rain and flooding (as referenced in the provided source summary).","CNN reports Hawaii\u2019s flood risk continues through Friday as a storm system brings numerous rounds of rain to the islands.","The New York Times reports more rain is expected after recent floods.","The source summary states this new flood threat comes about two weeks after Hawaii\u2019s worst flooding in 20 years."],"numeric_claims":[{"label":"recency_of_worst_flooding","value":"~2 weeks prior"},{"label":"historical_comparison","value":"worst flooding in 20 years"}],"primary_claim":"Hawaii has been issued warnings for another deluge and continued flood risk through Friday, following record-breaking rain and major flooding roughly two weeks earlier.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"Hawaii is facing another round of potentially heavy rain and flooding risk shortly after record-breaking rainfall and severe flooding about two weeks earlier. Multiple outlets report First Alert/forecast warnings extending through at least Friday as a storm system brings numerous rain rounds to the islands.","topics":["weather","flooding","heavy rainfall","storm system","Hawaii emergency preparedness","forecast warnings"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"Hawaii braces for another deluge on the heels of record-breaking rain The Washington Post First Alert Weather Days declared for another round of possible heavy rain, flooding hawaiinewsnow.com Hawaii faces another major flood threat 2 weeks after its worst flooding in 20 years CNN Tuesday Evening Forecast - Flood risk continues through Friday as a storm system brings numerous rounds of rain to the islands KITV Hawaii Storm Will Bring More Rain After Recent Floods The New York Times","title":"Hawaii braces for another deluge on the heels of record-breaking rain - The Washington Post","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 8387 in events