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/CBMiuwFBVV95cUxOUjNWWnNKWjZmQ2hNUEFNVnN6eTUzMGd3b1BrbjVUNHVtODk4RkhZa0ZqVENEX0Zpa1NwY2NEaHpUZ2FFcFVMMGFNb05KRFRKV09aOUVPanhvNjFyS3NQc1JuWWVOd19LdEhIUEpCY3BkNEd5azlfM2U4UUwxLWZJSWsySy12VnBDdl9XWGh4TmVPUlJIV2J4TE4wRmQwUHlaX1cwWVRuLXJWLU5HM1Ftd2U2U0lEcjREcGRR?oc=5","as_of":"2026-04-09T09:54:21.360181+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/CBMiuwFBVV95cUxOUjNWWnNKWjZmQ2hNUEFNVnN6eTUzMGd3b1BrbjVUNHVtODk4RkhZa0ZqVENEX0Zpa1NwY2NEaHpUZ2FFcFVMMGFNb05KRFRKV09aOUVPanhvNjFyS3NQc1JuWWVOd19LdEhIUEpCY3BkNEd5azlfM2U4UUwxLWZJSWsySy12VnBDdl9XWGh4TmVPUlJIV2J4TE4wRmQwUHlaX1cwWVRuLXJWLU5HM1Ftd2U2U0lEcjREcGRR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_03d0cb18f58376a5","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-09T23:02:41.471567+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiuwFBVV95cUxOUjNWWnNKWjZmQ2hNUEFNVnN6eTUzMGd3b1BrbjVUNHVtODk4RkhZa0ZqVENEX0Zpa1NwY2NEaHpUZ2FFcFVMMGFNb05KRFRKV09aOUVPanhvNjFyS3NQc1JuWWVOd19LdEhIUEpCY3BkNEd5azlfM2U4UUwxLWZJSWsySy12VnBDdl9XWGh4TmVPUlJIV2J4TE4wRmQwUHlaX1cwWVRuLXJWLU5HM1Ftd2U2U0lEcjREcGRR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiuwFBVV95cUxOUjNWWnNKWjZmQ2hNUEFNVnN6eTUzMGd3b1BrbjVUNHVtODk4RkhZa0ZqVENEX0Zpa1NwY2NEaHpUZ2FFcFVMMGFNb05KRFRKV09aOUVPanhvNjFyS3NQc1JuWWVOd19LdEhIUEpCY3BkNEd5azlfM2U4UUwxLWZJSWsySy12VnBDdl9XWGh4TmVPUlJIV2J4TE4wRmQwUHlaX1cwWVRuLXJWLU5HM1Ftd2U2U0lEcjREcGRR?oc=5","source_event_id":"evt_77d53ec3dc2f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1f606743dcdb269e","published_at":"2026-04-09T09:01:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"biological_species","name":"Emperor penguins","relevance":"high","symbol":"","type":"species"},{"asset_class":"biological_species_life_stage","name":"Chicks (emperor penguin chicks)","relevance":"high","symbol":"","type":"life_stage"},{"asset_class":"geography","name":"Antarctica","relevance":"medium","symbol":"","type":"location"},{"asset_class":"climate_factor","name":"Warming planet / climate warming","relevance":"medium","symbol":"","type":"driver"},{"asset_class":"media","name":"The Guardian","relevance":"low","symbol":"","type":"publisher"}],"event_type":"supply_disruption","information_gaps":["No article body content is provided beyond page-cleaning artifacts; only the headline and the prompt\u2019s source summary are available.","Unclear whether the drowning is caused by sea-ice loss, storm events, flooding, or another specific mechanism.","No numbers are provided for mortality rates, population size, or how quickly the risk is increasing.","No specific assessment name/authority, criteria, or date for the \u201cendangered\u201d designation is included in the provided text.","Near-term catalyst timing (e.g., upcoming breeding season impacts) is not specified in the provided material."],"key_facts":["The Guardian headline states that mass drowning of emperor penguin chicks puts emperor penguins at risk of extinction.","The prompt\u2019s source summary and other referenced headlines indicate emperor penguins have been declared/endangered based on rapid decline and warming/ice loss.","The prompt does not provide quantitative details (e.g., number of chicks, drowning mechanism, or timeframe) in the provided text."],"numeric_claims":[],"primary_claim":"Mass drowning of emperor penguin chicks is putting emperor penguins at risk of extinction.","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"The Guardian reports that mass drowning of emperor penguin chicks is putting the species at risk of extinction, linking the problem to rapid environmental change in Antarctica. The broader coverage referenced in the prompt indicates emperor penguins have been assessed as endangered due to a warming planet and ice loss.","topics":["climate change","Antarctica","emperor penguins","endangered species","penguin chick mortality","extinction risk"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Mass drowning of chicks puts emperor penguins at risk of extinction The Guardian These two iconic polar species have been driven to endangered status by a warming planet CNN Emperor Penguins Declared Endangered as Antarctica Loses Ice Bloomberg.com Emperor Penguins Are Now Endangered, a New Assessment Finds The New York Times Emperor penguins added to endangered list after rapid decline New Scientist","title":"Mass drowning of chicks puts emperor penguins at risk of extinction - The Guardian","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_3f9e32e5257b in signals