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-07T23:23:39.223569+00:00","dedupe_key":"signal_enriched:news_delta:29a0ec4351c8881a","evidence_event_ids":["evt_af95dc3c3d09"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxNclpOWkZYTUxLLTd4cllZMXM1dzh5eGhKX0hoemZFdFVCRUlYVVZ6WWJoVU93aFkwYWd6cVktMTRPeG9tRHNoMTFIR3czdTNyMVp2RG5RX1d3b2lWX1NLb0NDT05LYTlEb2hRLS1saVNDZmpVY0oxRnFtZzJ6dlQwTjA3QQ?oc=5","as_of":"2026-04-07T23:23:39.223569+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/CBMigwFBVV95cUxNclpOWkZYTUxLLTd4cllZMXM1dzh5eGhKX0hoemZFdFVCRUlYVVZ6WWJoVU93aFkwYWd6cVktMTRPeG9tRHNoMTFIR3czdTNyMVp2RG5RX1d3b2lWX1NLb0NDT05LYTlEb2hRLS1saVNDZmpVY0oxRnFtZzJ6dlQwTjA3QQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_52c4c4eed1457249","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-08T00:36:32.565987+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxNclpOWkZYTUxLLTd4cllZMXM1dzh5eGhKX0hoemZFdFVCRUlYVVZ6WWJoVU93aFkwYWd6cVktMTRPeG9tRHNoMTFIR3czdTNyMVp2RG5RX1d3b2lWX1NLb0NDT05LYTlEb2hRLS1saVNDZmpVY0oxRnFtZzJ6dlQwTjA3QQ?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/CBMigwFBVV95cUxNclpOWkZYTUxLLTd4cllZMXM1dzh5eGhKX0hoemZFdFVCRUlYVVZ6WWJoVU93aFkwYWd6cVktMTRPeG9tRHNoMTFIR3czdTNyMVp2RG5RX1d3b2lWX1NLb0NDT05LYTlEb2hRLS1saVNDZmpVY0oxRnFtZzJ6dlQwTjA3QQ?oc=5","source_event_id":"evt_af95dc3c3d09","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2e024dca7311df68","published_at":"2026-04-07T16:18:18+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["2025-26"],"entities":[{"asset_class":"media","name":"The New York Times","relevance":"high","symbol":"","type":"media_outlet"},{"asset_class":"arts_venue","name":"Metropolitan Opera (Met Opera)","relevance":"high","symbol":"","type":"organization"},{"asset_class":"composer","name":"Kaija Saariaho","relevance":"high","symbol":"","type":"person"},{"asset_class":"opera","name":"\u201cInnocence\u201d","relevance":"high","symbol":"","type":"artwork"},{"asset_class":"geopolitical_event","name":"Finnish school shooting (referenced contextually)","relevance":"medium","symbol":"","type":"event"}],"event_type":"other","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the actual review content, so details (e.g., specific plot points, dates of performances, critical assessments) cannot be extracted from the article body.","The exact school shooting(s) referenced (which incident, year, and how directly it is portrayed) is not fully specified in the provided text; only contextual mention of a Finnish school shooting appears in the snippet.","No explicit near-term catalyst timing for markets/companies is provided; this is an arts/culture item rather than a financial catalyst."],"key_facts":["The New York Times published a review titled along the lines of \u201cInnocence Tackles School Shootings at the Met Opera.\u201d","The production is described as an opera that addresses school shootings.","The Met Opera is the staging venue referenced in the headline.","The provided source summary also indicates the production examines the aftermath of a Finnish school shooting (as described by other outlets in the snippet)."],"numeric_claims":[],"primary_claim":"Kaija Saariaho\u2019s opera \u201cInnocence\u201d (reviewed by The New York Times) tackles school shootings in its Met Opera production.","relevance_score":0.28,"sentiment":"neutral","source_quality":"high","summary":"The New York Times review covers Kaija Saariaho\u2019s opera \u201cInnocence,\u201d which depicts and examines the aftermath of school shootings, staged at the Metropolitan Opera. The headline indicates the production\u2019s subject matter is school shootings and its thematic focus is on lingering impact.","topics":["opera","Met Opera","Kaija Saariaho","\u201cInnocence\u201d","school shootings","artistic depiction of violence","thematic aftermath/impact"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Review: \u2018Innocence\u2019 Tackles School Shootings at the Met Opera The New York Times \u2018The events still haunt\u2019: New York stage production examines aftermath of Finnish school shooting The Guardian Should a School Shooting Be Turned Into Opera? Vulture Metropolitan Opera 2025-26 Review: Innocence OperaWire Review: Kaija Saariaho\u2019s INNOCENCE \u2013 An Opera About a Killing Spree \u2013 Doesn\u2019t Let Up in Met Premiere BroadwayWorld","title":"Review: \u2018Innocence\u2019 Tackles School Shootings at the Met Opera - 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 2311 in events