SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-09T22:47:29.414455+00:00","dedupe_key":"signal_enriched:news_delta:1362353c39fc73ec","evidence_event_ids":["evt_94869effbf7a"],"signal_type":"news_headline_delta","source":"news_rss","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 11539 in events