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/CBMitAFBVV95cUxOSW94cHZBX2hwakpXM0J5WDY4Y2ZuQkd1NWFSN0V6cTdTVVlfSUNzVG5NSkJVdmRQanFsdng0c2RhSDdrdWxwejJSbmZybmtGSUNBbHRkeXVRZW8tVHRpaUxJbXVOZ3h0b21kNnd4YjBNcVFjU0MyMEdHODc5SUtzaGxpenVaaWc0RGZ1VkRSR1I1MlBoc2UwcjVGSU1IX21nRmduX01OWGVETVRaeGV2TTlIUFA?oc=5","as_of":"2026-04-10T19:36:11.967727+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/CBMitAFBVV95cUxOSW94cHZBX2hwakpXM0J5WDY4Y2ZuQkd1NWFSN0V6cTdTVVlfSUNzVG5NSkJVdmRQanFsdng0c2RhSDdrdWxwejJSbmZybmtGSUNBbHRkeXVRZW8tVHRpaUxJbXVOZ3h0b21kNnd4YjBNcVFjU0MyMEdHODc5SUtzaGxpenVaaWc0RGZ1VkRSR1I1MlBoc2UwcjVGSU1IX21nRmduX01OWGVETVRaeGV2TTlIUFA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_22ae40b6fbfe3ea5","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-10T20:15:32.256688+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMitAFBVV95cUxOSW94cHZBX2hwakpXM0J5WDY4Y2ZuQkd1NWFSN0V6cTdTVVlfSUNzVG5NSkJVdmRQanFsdng0c2RhSDdrdWxwejJSbmZybmtGSUNBbHRkeXVRZW8tVHRpaUxJbXVOZ3h0b21kNnd4YjBNcVFjU0MyMEdHODc5SUtzaGxpenVaaWc0RGZ1VkRSR1I1MlBoc2UwcjVGSU1IX21nRmduX01OWGVETVRaeGV2TTlIUFA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"wsj.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMitAFBVV95cUxOSW94cHZBX2hwakpXM0J5WDY4Y2ZuQkd1NWFSN0V6cTdTVVlfSUNzVG5NSkJVdmRQanFsdng0c2RhSDdrdWxwejJSbmZybmtGSUNBbHRkeXVRZW8tVHRpaUxJbXVOZ3h0b21kNnd4YjBNcVFjU0MyMEdHODc5SUtzaGxpenVaaWc0RGZ1VkRSR1I1MlBoc2UwcjVGSU1IX21nRmduX01OWGVETVRaeGV2TTlIUFA?oc=5","source_event_id":"evt_d6aef0a9580e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"dd433bfe073d2a4d","published_at":"2026-04-10T15:45:00+00:00","publisher_domain":"wsj.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Families living in coastal Louisiana bayou camps","relevance":"high","symbol":"","type":"population"},{"asset_class":"utility","name":"The power company (utility) that pulled the plug","relevance":"high","symbol":"","type":"organization"},{"asset_class":"other","name":"Coastal Louisiana homes/camps","relevance":"high","symbol":"","type":"location_group"},{"asset_class":"other","name":"NOLA.com (referenced)","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"The Shreveport-Bossier City Advocate (referenced)","relevance":"low","symbol":"","type":"media_outlet"}],"event_type":"supply_disruption","information_gaps":["The specific utility/company name is not present in the provided text.","The mechanism/trigger for the shutoff (e.g., nonpayment, infrastructure abandonment, regulatory action) is not specified in the provided content.","The geographic scope (which parishes/communities) and the number of affected households are not provided.","Timing/catalyst window for \u201cothers could be next\u201d is not specified.","Whether power was fully disconnected or temporarily suspended is not clarified in the provided text."],"key_facts":["Coastal Louisiana camps/homes lost power after a utility \u201cpulled the plug.\u201d","The report suggests other coastal homes/camps could be affected next.","The provided source summary frames the situation as making parts of the coast unlivable (via referenced coverage)."],"numeric_claims":[],"primary_claim":"A Louisiana power company disconnected electricity to coastal bayou camps, leaving some homes without power and raising the risk that other coastal areas could be next.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"WSJ reports that coastal Louisiana families living in long-established bayou camps lost electricity after their utility \u201cpulled the plug,\u201d and that additional communities could face similar shutoffs.","topics":["electricity shutoffs","utility service withdrawal","coastal Louisiana livability","risk of additional disconnections"]},"source":"WSJ","source_domain":"wsj.com","source_url":"https://www.wsj.com","summary":"Families Spent Decades on Louisiana\u2019s Bayous. The Power Company Pulled the Plug. WSJ These coastal Louisiana camps lost power when their utility pulled out. Others could be next. NOLA.com Faimon Roberts: Lake De Cade case shows how a coast becomes unlivable The Shreveport-Bossier City Advocate NO.abandoned.adv.1345.JPG The Advocate These coastal Louisiana homes may have their power shut off for good. Here's why. NOLA.com","title":"Families Spent Decades on Louisiana\u2019s Bayous. The Power Company Pulled the Plug. - WSJ","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_0fa31a826b32 in signals