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-07T04:04:22.157934+00:00","dedupe_key":"signal_enriched:news_delta:67121bdbb47349e9","evidence_event_ids":["evt_aa40e33d1b26"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMif0FVX3lxTE95RHJlV0R4LU9sc29pd1dZSDZYb2RYS29BTUxZVUZtZzJFVThKVjRPVllOWmNTREFiMlN2c05uN1Jka0tkbGZJc1ZqSGlTRnlvSU9DNkpMbDFKSVlkbk1jVXI3eVNSWTZPWk52YUJ0bFg1c3V0aktJWWxlZGFWSmM?oc=5","as_of":"2026-04-07T04:04:22.157934+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/CBMif0FVX3lxTE95RHJlV0R4LU9sc29pd1dZSDZYb2RYS29BTUxZVUZtZzJFVThKVjRPVllOWmNTREFiMlN2c05uN1Jka0tkbGZJc1ZqSGlTRnlvSU9DNkpMbDFKSVlkbk1jVXI3eVNSWTZPWk52YUJ0bFg1c3V0aktJWWxlZGFWSmM?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9fc32e15ba479ee4","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-07T17:20:58.953897+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMif0FVX3lxTE95RHJlV0R4LU9sc29pd1dZSDZYb2RYS29BTUxZVUZtZzJFVThKVjRPVllOWmNTREFiMlN2c05uN1Jka0tkbGZJc1ZqSGlTRnlvSU9DNkpMbDFKSVlkbk1jVXI3eVNSWTZPWk52YUJ0bFg1c3V0aktJWWxlZGFWSmM?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/CBMif0FVX3lxTE95RHJlV0R4LU9sc29pd1dZSDZYb2RYS29BTUxZVUZtZzJFVThKVjRPVllOWmNTREFiMlN2c05uN1Jka0tkbGZJc1ZqSGlTRnlvSU9DNkpMbDFKSVlkbk1jVXI3eVNSWTZPWk52YUJ0bFg1c3V0aktJWWxlZGFWSmM?oc=5","source_event_id":"evt_aa40e33d1b26","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a66587c643521fe8","published_at":"2026-04-06T23:38:58+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"military","name":"U.S. Airman","relevance":"directly involved in the rescue","symbol":"N/A","type":"person"},{"asset_class":"media","name":"Hegseth","relevance":"commentator making the comparison","symbol":"N/A","type":"person"}],"event_type":"other","information_gaps":["Details on the specific circumstances of the airman's rescue are not provided.","The broader implications of Hegseth's comparison are unclear."],"key_facts":["Two planes were destroyed by the U.S. during the rescue operation.","The U.S. set up an airfield inside Iran for the rescue.","The injured airman used a Boeing device to signal rescuers."],"numeric_claims":[],"primary_claim":"Hegseth likens the rescue of a U.S. airman to the resurrection of Jesus Christ.","relevance_score":0.7,"sentiment":"neutral","source_quality":"high","summary":"Hegseth draws a parallel between the Easter rescue of a U.S. airman and the resurrection of Jesus Christ, highlighting the significance of the event.","topics":["military rescue","religious symbolism","media commentary"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Hegseth Likens Easter Rescue of U.S. Airman to Resurrection of Jesus Christ The New York Times Two Planes Destroyed by U.S. During Rescue Operation WSJ Trump seizes on rescue of downed airman to recast unpopular Iran war Reuters The US set up an airfield inside Iran to rescue the F-15 airman. Marines just practiced building one Fortune Injured US Airman in Iran Used Boeing Device to Signal Rescuers Bloomberg.com","title":"Hegseth Likens Easter Rescue of U.S. Airman to Resurrection of Jesus Christ - 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 38903 in events