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-10T18:45:20.839466+00:00","dedupe_key":"signal_enriched:news_delta:dae101e52457e464","evidence_event_ids":["evt_b0895dfea6b5"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMixgFBVV95cUxQRHpKdTgxUlVlakFwSXFXN2dPVkZ2dkJtS3JJQWwxT1VGcmJOVTNJeVBWUUNxcFEwTV9jX05SRFZGemJwV1lPS1QwZ0RMYzN6Sms0Z01CeXpYSHpGejdwRDNVcjJ4d1Y5UUlIeVVLdVJkUV94dy14R3hRQ1V5cExBeUd3SDB6NGVNX1BnNk9fU2MwY2lCaV83T0pPWkt2R1c3Zk1lWUZMbXZrYWhqQnhvOGxPemxaa2Q0eHo5blhfcERFUG9JMVE?oc=5","as_of":"2026-04-10T18:45:20.839466+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/CBMixgFBVV95cUxQRHpKdTgxUlVlakFwSXFXN2dPVkZ2dkJtS3JJQWwxT1VGcmJOVTNJeVBWUUNxcFEwTV9jX05SRFZGemJwV1lPS1QwZ0RMYzN6Sms0Z01CeXpYSHpGejdwRDNVcjJ4d1Y5UUlIeVVLdVJkUV94dy14R3hRQ1V5cExBeUd3SDB6NGVNX1BnNk9fU2MwY2lCaV83T0pPWkt2R1c3Zk1lWUZMbXZrYWhqQnhvOGxPemxaa2Q0eHo5blhfcERFUG9JMVE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b1d4c1401c4c05b4","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-10T18:47:28.986136+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMixgFBVV95cUxQRHpKdTgxUlVlakFwSXFXN2dPVkZ2dkJtS3JJQWwxT1VGcmJOVTNJeVBWUUNxcFEwTV9jX05SRFZGemJwV1lPS1QwZ0RMYzN6Sms0Z01CeXpYSHpGejdwRDNVcjJ4d1Y5UUlIeVVLdVJkUV94dy14R3hRQ1V5cExBeUd3SDB6NGVNX1BnNk9fU2MwY2lCaV83T0pPWkt2R1c3Zk1lWUZMbXZrYWhqQnhvOGxPemxaa2Q0eHo5blhfcERFUG9JMVE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMixgFBVV95cUxQRHpKdTgxUlVlakFwSXFXN2dPVkZ2dkJtS3JJQWwxT1VGcmJOVTNJeVBWUUNxcFEwTV9jX05SRFZGemJwV1lPS1QwZ0RMYzN6Sms0Z01CeXpYSHpGejdwRDNVcjJ4d1Y5UUlIeVVLdVJkUV94dy14R3hRQ1V5cExBeUd3SDB6NGVNX1BnNk9fU2MwY2lCaV83T0pPWkt2R1c3Zk1lWUZMbXZrYWhqQnhvOGxPemxaa2Q0eHo5blhfcERFUG9JMVE?oc=5","source_event_id":"evt_b0895dfea6b5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2d23f9570f2f4f5b","published_at":"2026-04-10T17:19:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"n/a","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"n/a","name":"JD Vance","relevance":"high","symbol":"","type":"person"},{"asset_class":"n/a","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"n/a","name":"Pakistan","relevance":"medium","symbol":"","type":"country"},{"asset_class":"n/a","name":"The Guardian","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"n/a","name":"Bloomberg","relevance":"low","symbol":"","type":"media_outlet"},{"asset_class":"n/a","name":"CNN","relevance":"low","symbol":"","type":"media_outlet"},{"asset_class":"n/a","name":"New York Post","relevance":"low","symbol":"","type":"media_outlet"}],"event_type":"geopolitical_risk","information_gaps":["The specific talks/deal terms are not provided in the provided text.","No exact timing/date for when strikes would occur is stated in the provided excerpt.","The location/scale of any potential strikes (targets, platforms, number of assets) is not specified.","Whether Vance\u2019s trip is directly related to Iran talks or broader regional coordination is not explicitly stated.","The excerpt includes references to other outlets\u2019 claims, but the underlying details from those outlets are not included here."],"key_facts":["The Guardian headline states Trump warns of fresh strikes on Iran if talks fail.","The Guardian source summary says Trump told The Post he is preparing military action if Iran fails to comply in talks (quote: \u201cWe\u2019re loading up the ships\u201d).","The Guardian source summary says Vance is heading to Pakistan.","The source summary references Bloomberg reporting on US readiness for new strikes if Iran talks fail.","The source summary references CNN discussion about whether targeting Iran\u2019s civilian infrastructure could constitute war crimes (framing/controversy, not a confirmed legal finding)."],"numeric_claims":[],"primary_claim":"Trump warned that the US would resume/launch fresh strikes on Iran if talks fail or Iran does not comply, as Vance heads to Pakistan.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"The Guardian reports that Trump is warning Iran of fresh US strikes if talks fail, while JD Vance is reportedly traveling to Pakistan amid the Middle East crisis. The signal implies a near-term escalation risk tied to whether Iran complies with a proposed deal.","topics":["Middle East crisis","US-Iran tensions","military strike threat","diplomatic talks","US political messaging","regional diplomacy","Pakistan visit"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Middle East crisis live: Trump warns of fresh strikes on Iran if talks fail as Vance heads to Pakistan The Guardian Exclusive | Trump tells The Post he's preparing military if Iran fails to comply in talks: 'We're loading up the ships' New York Post US Readies for New Strikes If Iran Talks Fail, Report Says Bloomberg.com Live updates: Trump warns Iran that US assault will resume if deal is not reached CNN Is the US committing war crimes by targeting Iran\u2019s civilian infrastructure? The Guardian","title":"Middle East crisis live: Trump warns of fresh strikes on Iran if talks fail as Vance heads to Pakistan - The Guardian","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 18970 in events