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-10T15:28:44.267537+00:00","dedupe_key":"signal_enriched:news_delta:49a90730ecb80399","evidence_event_ids":["evt_95618de29788"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxPMERvVkRyV1llTW5DcTU5S1BpX2tlVVREejFpeDRiUXo4ZFlxZ1VSM1VHd3NIeExUTzc4WHFVTmE1R2lIUmNzaXNSZTFNV1hBQ2s2bDkxVXNxa0JFT2NzQW5KYWFCZG9hVFZwSVJJTHFTUndIQThKVkJIN0xvd3J3QlJzY3JwMURKeF82bnAwV014bk13dXVmZ1l0QlIydTFYelR1TnBMODU3Skx1bzRETdIBtgFBVV95cUxNUDQ3UldBTFpibnRPTU5haFpNQmZIa2JPQjl3cVotTUhTODdfR2tOQnk0WFdJSU80N1BQTzlfUGVNUnFLRUladlFRbFVlR19hdWhIMjF1VG5DTWxJVHZpLXVQRjVuNXJrRjZsRkktTU9Sb2tkak5KVzdCZWVBaG1nMkk3M20yd2NoaUVtVDVMYkhjU2k3ZzdIVTB5SlVReUh5MG9sYUpnc3BicUVvTXlMVWpPMnZjdw?oc=5","as_of":"2026-04-10T15:28:44.267537+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/CBMisAFBVV95cUxPMERvVkRyV1llTW5DcTU5S1BpX2tlVVREejFpeDRiUXo4ZFlxZ1VSM1VHd3NIeExUTzc4WHFVTmE1R2lIUmNzaXNSZTFNV1hBQ2s2bDkxVXNxa0JFT2NzQW5KYWFCZG9hVFZwSVJJTHFTUndIQThKVkJIN0xvd3J3QlJzY3JwMURKeF82bnAwV014bk13dXVmZ1l0QlIydTFYelR1TnBMODU3Skx1bzRETdIBtgFBVV95cUxNUDQ3UldBTFpibnRPTU5haFpNQmZIa2JPQjl3cVotTUhTODdfR2tOQnk0WFdJSU80N1BQTzlfUGVNUnFLRUladlFRbFVlR19hdWhIMjF1VG5DTWxJVHZpLXVQRjVuNXJrRjZsRkktTU9Sb2tkak5KVzdCZWVBaG1nMkk3M20yd2NoaUVtVDVMYkhjU2k3ZzdIVTB5SlVReUh5MG9sYUpnc3BicUVvTXlMVWpPMnZjdw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_86f072d712cd0a51","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-10T16:21:28.426021+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxPMERvVkRyV1llTW5DcTU5S1BpX2tlVVREejFpeDRiUXo4ZFlxZ1VSM1VHd3NIeExUTzc4WHFVTmE1R2lIUmNzaXNSZTFNV1hBQ2s2bDkxVXNxa0JFT2NzQW5KYWFCZG9hVFZwSVJJTHFTUndIQThKVkJIN0xvd3J3QlJzY3JwMURKeF82bnAwV014bk13dXVmZ1l0QlIydTFYelR1TnBMODU3Skx1bzRETdIBtgFBVV95cUxNUDQ3UldBTFpibnRPTU5haFpNQmZIa2JPQjl3cVotTUhTODdfR2tOQnk0WFdJSU80N1BQTzlfUGVNUnFLRUladlFRbFVlR19hdWhIMjF1VG5DTWxJVHZpLXVQRjVuNXJrRjZsRkktTU9Sb2tkak5KVzdCZWVBaG1nMkk3M20yd2NoaUVtVDVMYkhjU2k3ZzdIVTB5SlVReUh5MG9sYUpnc3BicUVvTXlMVWpPMnZjdw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"aljazeera.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxPMERvVkRyV1llTW5DcTU5S1BpX2tlVVREejFpeDRiUXo4ZFlxZ1VSM1VHd3NIeExUTzc4WHFVTmE1R2lIUmNzaXNSZTFNV1hBQ2s2bDkxVXNxa0JFT2NzQW5KYWFCZG9hVFZwSVJJTHFTUndIQThKVkJIN0xvd3J3QlJzY3JwMURKeF82bnAwV014bk13dXVmZ1l0QlIydTFYelR1TnBMODU3Skx1bzRETdIBtgFBVV95cUxNUDQ3UldBTFpibnRPTU5haFpNQmZIa2JPQjl3cVotTUhTODdfR2tOQnk0WFdJSU80N1BQTzlfUGVNUnFLRUladlFRbFVlR19hdWhIMjF1VG5DTWxJVHZpLXVQRjVuNXJrRjZsRkktTU9Sb2tkak5KVzdCZWVBaG1nMkk3M20yd2NoaUVtVDVMYkhjU2k3ZzdIVTB5SlVReUh5MG9sYUpnc3BicUVvTXlMVWpPMnZjdw?oc=5","source_event_id":"evt_95618de29788","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"fd9c5d0bbf0f4dce","published_at":"2026-04-10T11:46:40+00:00","publisher_domain":"aljazeera.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"NATO","relevance":"high","symbol":"","type":"organization"},{"asset_class":"other","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"Mark Rutte","relevance":"medium","symbol":"","type":"person"},{"asset_class":"other","name":"NATO Secretary General (Mark Rutte)","relevance":"medium","symbol":"","type":"role"},{"asset_class":"other","name":"Rutte","relevance":"medium","symbol":"","type":"person"},{"asset_class":"other","name":"Iran","relevance":"medium","symbol":"","type":"country"},{"asset_class":"other","name":"Hormuz","relevance":"medium","symbol":"","type":"location/strait"}],"event_type":"geopolitical_risk","information_gaps":["The full Al Jazeera article text is not available in the provided content (only page styling/HTML appears after the cleaned text), so details of the argument and evidence are missing.","The exact nature of \u201cpulls the US out\u201d (withdrawal vs. threat vs. conditional statements) is not specified in the provided excerpt.","The Reuters-referenced \u201cwithin days\u201d timing is not anchored to a specific date in the excerpt.","No concrete policy mechanism (e.g., treaty article, withdrawal timeline, or formal decision) is provided in the excerpt.","Market/financial implications are not stated; only geopolitical/alliance risk is implied."],"key_facts":["Al Jazeera headline poses the question of whether NATO can survive if Trump pulls the US out.","The provided source summary states Trump is \u201cbullying NATO again.\u201d","The source summary includes that NATO is working to \u201csurvive the Iran war\u201d (wording as provided).","The source summary includes a Reuters-referenced claim that NATO\u2019s Rutte tells allies Trump wants Hormuz pledges within days (exact timing and details are not fully present in the provided text)."],"numeric_claims":[],"primary_claim":"NATO\u2019s survival is in question if the US, under Trump, pulls out of the alliance.","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"Al Jazeera frames NATO as being at heightened risk of fracture if President Trump withdraws or threatens to withdraw the US from the alliance. The signal also references near-term NATO efforts to manage Trump-related demands amid Iran/Hormuz-related security pressures.","topics":["NATO cohesion","US-NATO relations","Trump statements","alliance burden/security commitments","Iran war","Strait of Hormuz pledges","diplomatic timelines"]},"source":"Al Jazeera","source_domain":"aljazeera.com","source_url":"https://www.aljazeera.com","summary":"\u2018Closer to a break than ever\u2019: Can NATO survive if Trump pulls the US out? Al Jazeera Trump is bullying NATO again. But Americans like the alliance CNN What Trump\u2019s blowup with Rutte was really about Politico Amid Trump\u2019s Threats, NATO Labors to Survive the Iran War The New York Times NATO's Rutte tells allies Trump wants Hormuz pledges within days, diplomats say Reuters","title":"\u2018Closer to a break than ever\u2019: Can NATO survive if Trump pulls the US out? - Al Jazeera","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 17981 in events