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-09T03:57:12.084640+00:00","dedupe_key":"signal_enriched:news_delta:1f627d28f87a957c","evidence_event_ids":["evt_33899a61063b"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMidkFVX3lxTFBwQS05NE1mcmF4VGg1YWVnVTBvR2E2bmFJMl9PYlRFU3laNXFLbngzeC10SGR2dEJjVHhOZC0yWC1FUjZhMzBlbjZKTXhncEtwUG5zR2h0ejRLTlhNZTVCSXY0THZ5UDd6YktHeGthNmNtcV9wN2c?oc=5","as_of":"2026-04-09T03:57:12.084640+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/CBMidkFVX3lxTFBwQS05NE1mcmF4VGg1YWVnVTBvR2E2bmFJMl9PYlRFU3laNXFLbngzeC10SGR2dEJjVHhOZC0yWC1FUjZhMzBlbjZKTXhncEtwUG5zR2h0ejRLTlhNZTVCSXY0THZ5UDd6YktHeGthNmNtcV9wN2c?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_56f9f73e18aab79a","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-09T22:36:26.412722+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMidkFVX3lxTFBwQS05NE1mcmF4VGg1YWVnVTBvR2E2bmFJMl9PYlRFU3laNXFLbngzeC10SGR2dEJjVHhOZC0yWC1FUjZhMzBlbjZKTXhncEtwUG5zR2h0ejRLTlhNZTVCSXY0THZ5UDd6YktHeGthNmNtcV9wN2c?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/CBMidkFVX3lxTFBwQS05NE1mcmF4VGg1YWVnVTBvR2E2bmFJMl9PYlRFU3laNXFLbngzeC10SGR2dEJjVHhOZC0yWC1FUjZhMzBlbjZKTXhncEtwUG5zR2h0ejRLTlhNZTVCSXY0THZ5UDd6YktHeGthNmNtcV9wN2c?oc=5","source_event_id":"evt_33899a61063b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"62104547ad0bcb10","published_at":"2026-04-08T20:59:03+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Donald Trump","relevance":"central","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Iran","relevance":"central","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States","relevance":"central","symbol":"","type":"country"},{"asset_class":"","name":"U.S.-Iran ceasefire/truce","relevance":"high","symbol":"","type":"event"},{"asset_class":"","name":"The New York Times","relevance":"source","symbol":"","type":"publisher"},{"asset_class":"","name":"Politico","relevance":"source","symbol":"","type":"publisher"},{"asset_class":"","name":"The Washington Post","relevance":"source","symbol":"","type":"publisher"},{"asset_class":"","name":"NPR","relevance":"source","symbol":"","type":"publisher"},{"asset_class":"","name":"The New Yorker","relevance":"source","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The provided NYT text is only a headline and not the article\u2019s specific conclusions or evidence.","No explicit details are given about what Trump\u2019s \u201cwar goals\u201d were.","The timing/date of the ceasefire/truce is not provided in the supplied text.","No concrete outcomes (e.g., specific policy changes, territorial/negotiation terms, or compliance metrics) are included in the provided snippets.","Directional impact is inferred from critical framing (e.g., \u201closing,\u201d \u201cbacklash at home\u201d) but the exact nature/magnitude of impacts is not specified."],"key_facts":["NYT headline: \u201cHas Trump Met His War Goals in Iran?\u201d","NYT framing implies uncertainty/critique about whether U.S. objectives were achieved (question form).","Politico snippet: \u201cSeems like losing\u201d: What the US hasn\u2019t won in Iran (suggests U.S. did not achieve certain aims).","New Yorker snippet: \u201cA U.S.-Iran Ceasefire Is Here, but Trump\u2019s Stone Age Mentality Endures\u201d (indicates a ceasefire/truce and continued criticism of Trump\u2019s approach).","Washington Post snippet: \u201cTrump\u2019s Iran brinkmanship reaches truce, escalates backlash at home\u201d (indicates brinkmanship leading to truce and backlash domestically).","NPR snippet: \u201cWhat has the U.S. war with Iran accomplished?\u201d (suggests evaluation/criticism of outcomes)."],"numeric_claims":[],"primary_claim":"The New York Times asks whether Trump has met his war goals in Iran.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The NYT headline questions whether Trump has achieved his stated war objectives in Iran, framing the outcome as unresolved or not fully met. Other provided source snippets indicate a U.S.-Iran ceasefire/truce occurred but that domestic backlash and criticism of U.S. strategy persist.","topics":["U.S.-Iran relations","Trump foreign policy","war goals","ceasefire/truce","domestic backlash","assessment of war outcomes"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Has Trump Met His War Goals in Iran? The New York Times \u2018Seems like losing\u2019: What the US hasn\u2019t won in Iran Politico A U.S.-Iran Ceasefire Is Here, but Trump\u2019s Stone Age Mentality Endures The New Yorker Trump\u2019s Iran brinkmanship reaches truce, escalates backlash at home The Washington Post What has the U.S. war with Iran accomplished? NPR","title":"Has Trump Met His War Goals in Iran? - 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 8897 in events