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/CBMivwFBVV95cUxNNDRmZnNlYS13OE90VXM3TmFxTncyVGg4amotd1RVLW9Kc0haUzc3dXhFYUR6OFEyMUxwSFozS01OYWgzbG1Vam9BMkpLcC1WRnhSWlJBcDI2MXYyb3ZENS1mTm83dUMxajE2UG9UaERiOU9ycWVsMVQxSElva0VGWDZXalQwRV81ZC12N3hrcWRTZHNFdXJWOElfS0ZBRktQdlAtOFZvejltRUlodmF4R3phQmpnMUUtWFVUTzUzMA?oc=5","as_of":"2026-04-10T16:36:01.521193+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/CBMivwFBVV95cUxNNDRmZnNlYS13OE90VXM3TmFxTncyVGg4amotd1RVLW9Kc0haUzc3dXhFYUR6OFEyMUxwSFozS01OYWgzbG1Vam9BMkpLcC1WRnhSWlJBcDI2MXYyb3ZENS1mTm83dUMxajE2UG9UaERiOU9ycWVsMVQxSElva0VGWDZXalQwRV81ZC12N3hrcWRTZHNFdXJWOElfS0ZBRktQdlAtOFZvejltRUlodmF4R3phQmpnMUUtWFVUTzUzMA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_70280f9c126ca0c2","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-10T17:16:48.579645+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMivwFBVV95cUxNNDRmZnNlYS13OE90VXM3TmFxTncyVGg4amotd1RVLW9Kc0haUzc3dXhFYUR6OFEyMUxwSFozS01OYWgzbG1Vam9BMkpLcC1WRnhSWlJBcDI2MXYyb3ZENS1mTm83dUMxajE2UG9UaERiOU9ycWVsMVQxSElva0VGWDZXalQwRV81ZC12N3hrcWRTZHNFdXJWOElfS0ZBRktQdlAtOFZvejltRUlodmF4R3phQmpnMUUtWFVUTzUzMA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"thedailybeast.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMivwFBVV95cUxNNDRmZnNlYS13OE90VXM3TmFxTncyVGg4amotd1RVLW9Kc0haUzc3dXhFYUR6OFEyMUxwSFozS01OYWgzbG1Vam9BMkpLcC1WRnhSWlJBcDI2MXYyb3ZENS1mTm83dUMxajE2UG9UaERiOU9ycWVsMVQxSElva0VGWDZXalQwRV81ZC12N3hrcWRTZHNFdXJWOElfS0ZBRktQdlAtOFZvejltRUlodmF4R3phQmpnMUUtWFVUTzUzMA?oc=5","source_event_id":"evt_5023fd3c686f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"688c57cb43befc98","published_at":"2026-04-10T11:04:00+00:00","publisher_domain":"thedailybeast.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Vladimir Putin","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Keir Starmer","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"U.S. ally (unspecified in provided text)","relevance":"medium","symbol":"","type":"government_or_political_actor"},{"asset_class":"other","name":"United Kingdom (implied by Starmer)","relevance":"medium","symbol":"","type":"country"},{"asset_class":"other","name":"Iran (referenced in source summary)","relevance":"medium","symbol":"","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["The specific identity of the \u201cU.S. ally\u201d is not present in the provided headline text or cleaned article content.","The cleaned article text provided is largely non-informative (CSS/HTML styling), so detailed supporting statements from the Daily Beast article are not available here.","No concrete policy actions, timelines, or specific statements beyond the \u201cfed up\u201d framing are included in the provided material.","The near-term catalyst timing (e.g., when the ally/Starmer will act or what decision is imminent) is not specified in the provided text."],"key_facts":["The Daily Beast headline states that a U.S. ally says he is completely \u201cfed up\u201d with Trump and Putin\u2019s \u201cchaos.\u201d","The provided source summary includes that Keir Starmer says he is \u201cfed up\u201d with Trump and Putin.","The provided source summary references the Iran war/conflict as a defining issue and as a warning for resilience, including at home and with European allies.","The provided source summary also references Europe \u201csplintering\u201d from the U.S. over an Iran war context and mentions UK energy costs (as part of the broader discussion)."],"numeric_claims":[],"primary_claim":"A U.S. ally is described as being \u201ccompletely fed up\u201d with Trump and Putin\u2019s \u201cchaos,\u201d and UK leadership (Keir Starmer) is also described as \u201cfed up\u201d with Trump and Putin amid broader instability linked to the Iran conflict.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"The Daily Beast reports that a U.S. ally (described as \u201ccompletely fed up\u201d) is criticizing both Donald Trump and Vladimir Putin\u2019s handling of \u201cchaos,\u201d implying growing frustration within the alliance. The provided source summary also references UK Prime Minister Keir Starmer expressing being \u201cfed up\u201d with Trump and Putin and warning about impacts tied to the Iran conflict.","topics":["U.S.-Europe relations","Russia-Ukraine/Putin","U.S. foreign policy","Iran conflict","political frustration/criticism","energy costs/resilience (implied)"]},"source":"The Daily Beast","source_domain":"thedailybeast.com","source_url":"https://www.thedailybeast.com","summary":"U.S. Ally Says He\u2019s Completely \u2018Fed Up\u2019 With Trump and Putin\u2019s Chaos The Daily Beast Starmer Says He's 'Fed Up' With Trump as Europe Splinters From U.S. Over Iran War Time Magazine The Iran war is a warning: Britain must build resilience \u2013 at home and with our allies in Europe | Keir Starmer The Guardian Keir Starmer: 'I'm fed up' with Trump and Putin affecting UK energy costs CNBC Iran conflict will define us for a generation, says PM BBC","title":"U.S. Ally Says He\u2019s Completely \u2018Fed Up\u2019 With Trump and Putin\u2019s Chaos - The Daily Beast","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_02028947afe6 in signals