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/CBMihAFBVV95cUxPRVlQRmFUS3lqVllBRlBTWFdUenNwWVdvcVJhV1ZGaXYwQWJwSXJIQ0RQX0dDTldld1dzQTZNZWdQMm9jNDZXM1dPRFpwbU84OGdLOXdXTTR3Nld2U2w2dFpHd0lBQVZfeHlvZ1dHeFpYRkxaNEpaOTUwdnNuemZhNHRPcmU?oc=5","as_of":"2026-04-09T22:47:29.414455+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/CBMihAFBVV95cUxPRVlQRmFUS3lqVllBRlBTWFdUenNwWVdvcVJhV1ZGaXYwQWJwSXJIQ0RQX0dDTldld1dzQTZNZWdQMm9jNDZXM1dPRFpwbU84OGdLOXdXTTR3Nld2U2w2dFpHd0lBQVZfeHlvZ1dHeFpYRkxaNEpaOTUwdnNuemZhNHRPcmU?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_076c669eb1861fd2","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-10T00:47:59.644066+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxPRVlQRmFUS3lqVllBRlBTWFdUenNwWVdvcVJhV1ZGaXYwQWJwSXJIQ0RQX0dDTldld1dzQTZNZWdQMm9jNDZXM1dPRFpwbU84OGdLOXdXTTR3Nld2U2w2dFpHd0lBQVZfeHlvZ1dHeFpYRkxaNEpaOTUwdnNuemZhNHRPcmU?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxPRVlQRmFUS3lqVllBRlBTWFdUenNwWVdvcVJhV1ZGaXYwQWJwSXJIQ0RQX0dDTldld1dzQTZNZWdQMm9jNDZXM1dPRFpwbU84OGdLOXdXTTR3Nld2U2w2dFpHd0lBQVZfeHlvZ1dHeFpYRkxaNEpaOTUwdnNuemZhNHRPcmU?oc=5","source_event_id":"evt_94869effbf7a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"53e55c566f889d91","published_at":"2026-04-09T17:39:08+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"International Union for Conservation of Nature (IUCN)","relevance":"high","symbol":"","type":"organization"},{"asset_class":"other","name":"Emperor penguin","relevance":"high","symbol":"","type":"species"},{"asset_class":"other","name":"Antarctic fur seal","relevance":"medium","symbol":"","type":"species"},{"asset_class":"other","name":"International Union for Conservation of Nature (IUCN) Red List","relevance":"high","symbol":"","type":"program/registry"},{"asset_class":"other","name":"The New York Times","relevance":"medium","symbol":"","type":"media outlet"},{"asset_class":"other","name":"The Guardian","relevance":"low","symbol":"","type":"media outlet"},{"asset_class":"other","name":"ABC News","relevance":"low","symbol":"","type":"media outlet"},{"asset_class":"other","name":"FOX 8 News","relevance":"low","symbol":"","type":"media outlet"}],"event_type":"regulation","information_gaps":["The exact IUCN assessment date/version and the specific criteria used for the \u201cEndangered\u201d classification are not present in the provided text.","The magnitude of population decline, geographic scope, and quantitative thresholds are not included in the provided content.","Near-term catalyst timing for any policy/market impact is not specified (this is primarily a conservation-status update).","The provided article text appears to be largely non-content (HTML/CSS), so only the headline and the supplied source summary were usable for grounded extraction."],"key_facts":["IUCN Red List updated the conservation status of emperor penguins to \u201cEndangered.\u201d","The reported driver of the status change is climate change.","The update also lists Antarctic fur seals as \u201cEndangered.\u201d","A cited risk mentioned in the provided source summary is mass drowning of chicks (as a threat contributing to extinction risk)."],"numeric_claims":[],"primary_claim":"IUCN\u2019s updated Red List moved emperor penguins to the \u201cEndangered\u201d category due to climate change-related risks.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"The IUCN Red List has updated the conservation status of emperor penguins, moving them to \u201cEndangered,\u201d citing climate change impacts. The update also lists Antarctic fur seals as \u201cEndangered.\u201d","topics":["IUCN Red List","species conservation status","climate change","Antarctica","emperor penguins","Antarctic fur seals"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"I.U.C.N. Red List Moves Emperor Penguins to \u201cEndangered\u201d The New York Times Emperor penguin and Antarctic fur seal now Endangered due to climate change \u2013 IUCN Red List - Press release International Union for Conservation of Nature Mass drowning of chicks puts emperor penguins at risk of extinction The Guardian Emperor penguin, Antarctic fur seal now listed as endangered in updated IUCN Red List ABC News Emperor penguin, Antarctic fur seal now considered endangered FOX 8 News","title":"I.U.C.N. Red List Moves Emperor Penguins to \u201cEndangered\u201d - The New York Times","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_5a37ca1dac3d in signals