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-09T21:31:27.146578+00:00","dedupe_key":"signal_enriched:news_delta:64764a1f13fabb55","evidence_event_ids":["evt_5cded5e2dbdc"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxPZGN5WDY0Uk9uZ21YR1YySG96aGN4VEdJQzdhQ25NanFWNlhBblpSUjR3dkxBa1pWNDZDMFZKay0yYW5QOGU1bzl3bS1RVkVrQVNPdTFMZXJCVnlKcXBKUHo3TDZtMmpTdlE2NVVVVVJaRUpsc2xyekFvOVIwcjZET0pKNGt3aDhyY3ZJbEpXYW1rTF9CMmlHd05faU1YdEhiVkJ3dzVTcldNTmc2?oc=5","as_of":"2026-04-09T21:31:27.146578+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/CBMirAFBVV95cUxPZGN5WDY0Uk9uZ21YR1YySG96aGN4VEdJQzdhQ25NanFWNlhBblpSUjR3dkxBa1pWNDZDMFZKay0yYW5QOGU1bzl3bS1RVkVrQVNPdTFMZXJCVnlKcXBKUHo3TDZtMmpTdlE2NVVVVVJaRUpsc2xyekFvOVIwcjZET0pKNGt3aDhyY3ZJbEpXYW1rTF9CMmlHd05faU1YdEhiVkJ3dzVTcldNTmc2?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_af7ced3bd8515d53","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:36:51.546930+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxPZGN5WDY0Uk9uZ21YR1YySG96aGN4VEdJQzdhQ25NanFWNlhBblpSUjR3dkxBa1pWNDZDMFZKay0yYW5QOGU1bzl3bS1RVkVrQVNPdTFMZXJCVnlKcXBKUHo3TDZtMmpTdlE2NVVVVVJaRUpsc2xyekFvOVIwcjZET0pKNGt3aDhyY3ZJbEpXYW1rTF9CMmlHd05faU1YdEhiVkJ3dzVTcldNTmc2?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"washingtonpost.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxPZGN5WDY0Uk9uZ21YR1YySG96aGN4VEdJQzdhQ25NanFWNlhBblpSUjR3dkxBa1pWNDZDMFZKay0yYW5QOGU1bzl3bS1RVkVrQVNPdTFMZXJCVnlKcXBKUHo3TDZtMmpTdlE2NVVVVVJaRUpsc2xyekFvOVIwcjZET0pKNGt3aDhyY3ZJbEpXYW1rTF9CMmlHd05faU1YdEhiVkJ3dzVTcldNTmc2?oc=5","source_event_id":"evt_5cded5e2dbdc","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"80ce84608e92c479","published_at":"2026-04-09T20:25:30+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"wildlife/species","name":"Emperor penguins","relevance":"directly affected by the endangered listing","symbol":"","type":"species"},{"asset_class":"nonprofit/standards body","name":"International Union for Conservation of Nature (IUCN)","relevance":"source of the endangered classification via updated Red List","symbol":"","type":"organization"},{"asset_class":"wildlife/species","name":"Antarctic fur seal","relevance":"also mentioned as endangered in the same updated IUCN context (per provided source summary)","symbol":"","type":"species"},{"asset_class":"media","name":"The Washington Post","relevance":"reports the development","symbol":"","type":"publisher"}],"event_type":"regulation","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the actual article content; therefore, details such as the exact IUCN category/subcategory, assessment date, and specific climate-change mechanisms are not verifiable from the supplied text.","No population numbers, geographic scope, or timeline for when the listing takes effect are included in the provided material.","The exact wording of the Washington Post claim (e.g., whether it is 'endangered' vs. 'endangered in the IUCN Red List') cannot be fully confirmed beyond the headline and the provided summaries."],"key_facts":["The Washington Post headline states emperor penguins have been declared endangered.","The provided source summary indicates the endangered status comes from an updated IUCN Red List press release.","The provided source summary attributes the risk to climate change.","The provided source summary also mentions Antarctic fur seals as endangered in the updated IUCN Red List context."],"numeric_claims":[],"primary_claim":"Emperor penguins have been declared endangered in an updated IUCN Red List assessment.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"The Washington Post reports that emperor penguins have been newly declared endangered, citing an updated IUCN Red List assessment. The listing is attributed to climate change impacts, with near-term implications for conservation attention and protections.","topics":["biodiversity","species conservation","IUCN Red List","climate change impacts","endangered species status"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"Emperor penguins have just been declared endangered The Washington Post Emperor penguin and Antarctic fur seal now Endangered due to climate change \u2013 IUCN Red List - Press release International Union for Conservation of Nature Emperor penguins now endangered, international wildlife group finds USA Today 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","title":"Emperor penguins have just been declared endangered - The Washington Post","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 11363 in events