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/CBMiswFBVV95cUxOX1A4ejJFYlM3c193VktaLXRZTGw2Y3RQQnFoNUJTTEszVXJsSlZzUDB5T3ZuYVhiN0EtQ1JWbC1OLVQzN0JXWXgxOWFKcnFsMnFOTUJTV2UyMjR0UUlyd0ZIMGFDZ0NVdFhDYlZvMlJtcUVmZEdqQkpHemJWbWUxenBGRFUzYUFTS1dWaHJqbzg3SERIS0hyN2hBZ3Q3dVZqUnJjU0pNRTNoalBhYUlLZ1FfRQ?oc=5","as_of":"2026-04-08T04:33:58.974679+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/CBMiswFBVV95cUxOX1A4ejJFYlM3c193VktaLXRZTGw2Y3RQQnFoNUJTTEszVXJsSlZzUDB5T3ZuYVhiN0EtQ1JWbC1OLVQzN0JXWXgxOWFKcnFsMnFOTUJTV2UyMjR0UUlyd0ZIMGFDZ0NVdFhDYlZvMlJtcUVmZEdqQkpHemJWbWUxenBGRFUzYUFTS1dWaHJqbzg3SERIS0hyN2hBZ3Q3dVZqUnJjU0pNRTNoalBhYUlLZ1FfRQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e0d30be7a182ea67","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-08T04:34:44.110626+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiswFBVV95cUxOX1A4ejJFYlM3c193VktaLXRZTGw2Y3RQQnFoNUJTTEszVXJsSlZzUDB5T3ZuYVhiN0EtQ1JWbC1OLVQzN0JXWXgxOWFKcnFsMnFOTUJTV2UyMjR0UUlyd0ZIMGFDZ0NVdFhDYlZvMlJtcUVmZEdqQkpHemJWbWUxenBGRFUzYUFTS1dWaHJqbzg3SERIS0hyN2hBZ3Q3dVZqUnJjU0pNRTNoalBhYUlLZ1FfRQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"staradvertiser.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiswFBVV95cUxOX1A4ejJFYlM3c193VktaLXRZTGw2Y3RQQnFoNUJTTEszVXJsSlZzUDB5T3ZuYVhiN0EtQ1JWbC1OLVQzN0JXWXgxOWFKcnFsMnFOTUJTV2UyMjR0UUlyd0ZIMGFDZ0NVdFhDYlZvMlJtcUVmZEdqQkpHemJWbWUxenBGRFUzYUFTS1dWaHJqbzg3SERIS0hyN2hBZ3Q3dVZqUnJjU0pNRTNoalBhYUlLZ1FfRQ?oc=5","source_event_id":"evt_67f8c87488ae","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ee25ed7e9c58b688","published_at":"2026-04-08T00:31:10+00:00","publisher_domain":"staradvertiser.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"public_sector","name":"Hawaii Department of Health (DOH)","relevance":"primary investigator","symbol":"","type":"government_health_agency"},{"asset_class":"public_sector","name":"U.S. Centers for Disease Control and Prevention (CDC)","relevance":"co-investigator","symbol":"","type":"government_health_agency"},{"asset_class":"region","name":"West Hawai\u02bbi","relevance":"location of the reported rise in cases","symbol":"","type":"geographic_region"},{"asset_class":"health_risk","name":"Invasive Group A Streptococcal (iGAS)","relevance":"specific type of strep infection under investigation","symbol":"","type":"medical_condition"}],"event_type":"research","information_gaps":["No specific case counts, time window, or rate increase are provided in the provided text.","No details are given on severity outcomes (e.g., hospitalizations or deaths).","No stated timeline for investigation findings or public guidance is included.","The exact scope (which communities/facilities) within West Hawai\u02bbi is not specified in the provided content."],"key_facts":["DOH is investigating a rise in strep cases in West Hawai\u02bbi.","CDC is also investigating the rise in strep cases in West Hawai\u02bbi.","The investigation is described as involving invasive Group A Streptococcal (iGAS) infections.","The reporting source is the Honolulu Star-Advertiser (per headline)."],"numeric_claims":[],"primary_claim":"DOH and CDC are investigating an increase in strep cases in West Hawai\u02bbi.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"The Hawaii Department of Health (DOH) and the U.S. CDC are investigating a rise in strep infections in West Hawai\u02bbi. The focus is on invasive Group A Streptococcal (iGAS) cases, which are considered potentially dangerous.","topics":["public health","infectious disease","strep throat","Group A Streptococcus","invasive infections","disease surveillance","Hawai\u02bbi"]},"source":"Honolulu Star-Advertiser","source_domain":"staradvertiser.com","source_url":"https://www.staradvertiser.com","summary":"DOH, CDC investigating rise in strep cases in West Hawaii Honolulu Star-Advertiser Health officials investigate high rates of strep infections in West Hawaii Hawaii News Now DOH and CDC Investigate Invasive Group A Streptococcal (iGas) Infections in West Hawai\u02bbi Maui Now DOH investigates dangerous bacterial infections in West Hawaii hawaiitribune-herald.com DOH and CDC In\u00adves\u00adtigate Invasive Group A Strep\u00adto\u00adcoccal (iGas) In\u00adfec\u00adtions in West Hawaii Spectrum News","title":"DOH, CDC investigating rise in strep cases in West Hawaii - Honolulu Star-Advertiser","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_2ce728d97cc7 in signals