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/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

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_f69fbeececd2 in signals