SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

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

event_store.db — signals

Update row sig_fd28a6479c0e in signals