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/CBMiiwFBVV95cUxOT3QwZVZlWVdqYWNCNDNrVHZsN3JSLVhWT1MxZEI0OGFvTzJScmxrRWlSTmxRRnlmQVVmTFlWcWNKaUVTS0t5UE00bDJudFV0Rm0xWGdlODZaUGRUUmUwcl9BSXBsNUY5aUV3b0hQZnIxR3ExSWJVcUNISHJDbUEzcDNnQzA0ajN2eFdN?oc=5","as_of":"2026-04-10T15:03:23.171303+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/CBMiiwFBVV95cUxOT3QwZVZlWVdqYWNCNDNrVHZsN3JSLVhWT1MxZEI0OGFvTzJScmxrRWlSTmxRRnlmQVVmTFlWcWNKaUVTS0t5UE00bDJudFV0Rm0xWGdlODZaUGRUUmUwcl9BSXBsNUY5aUV3b0hQZnIxR3ExSWJVcUNISHJDbUEzcDNnQzA0ajN2eFdN?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a22c5638a1a2d263","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-10T15:04:55.927719+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxOT3QwZVZlWVdqYWNCNDNrVHZsN3JSLVhWT1MxZEI0OGFvTzJScmxrRWlSTmxRRnlmQVVmTFlWcWNKaUVTS0t5UE00bDJudFV0Rm0xWGdlODZaUGRUUmUwcl9BSXBsNUY5aUV3b0hQZnIxR3ExSWJVcUNISHJDbUEzcDNnQzA0ajN2eFdN?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/CBMiiwFBVV95cUxOT3QwZVZlWVdqYWNCNDNrVHZsN3JSLVhWT1MxZEI0OGFvTzJScmxrRWlSTmxRRnlmQVVmTFlWcWNKaUVTS0t5UE00bDJudFV0Rm0xWGdlODZaUGRUUmUwcl9BSXBsNUY5aUV3b0hQZnIxR3ExSWJVcUNISHJDbUEzcDNnQzA0ajN2eFdN?oc=5","source_event_id":"evt_8ea648266c1e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0c3dcb2b3e822e49","published_at":"2026-04-10T14:08:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Jimmy Kimmel","relevance":"primary critic","symbol":"","type":"person"},{"asset_class":"","name":"Donald Trump","relevance":"subject of criticism","symbol":"","type":"person"},{"asset_class":"","name":"Billy Bush","relevance":"comparison used in quote","symbol":"","type":"person"},{"asset_class":"","name":"The Guardian","relevance":"source of headline","symbol":"","type":"publisher"},{"asset_class":"","name":"Iran","relevance":"geopolitical topic referenced","symbol":"","type":"location/country"},{"asset_class":"","name":"Stephen Colbert","relevance":"mentioned in source summary as also reacting","symbol":"","type":"person"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is largely HTML/CSS and does not contain the actual Guardian article content or the full quote context; only the headline and the multi-outlet source summary are usable here.","No specific date/time of the comments or the Iran/cease-fire events is included in the provided material.","The exact wording of the Trump Iran comments being criticized is not included in the provided text.","Near-term market/catalyst timing is not specified; any directional impact on assets would be speculative without additional context."],"key_facts":["The Guardian headline includes a quote attributed to Jimmy Kimmel criticizing Trump\u2019s tone about war.","The quote compares Trump\u2019s war talk to \u201cbragging about women with Billy Bush.\u201d","The provided source summary indicates late-night hosts (including Kimmel and Stephen Colbert) reacted to Trump\u2019s Iran comments and discussed a \u201cmixed message.\u201d","The source summary also references a cease-fire deal in connection with the reactions (exact details not present in the provided text)."],"numeric_claims":[],"primary_claim":"Jimmy Kimmel said Donald Trump \u201ctalks about war\u201d in a bragging manner, comparing the style to Billy Bush, in response to Trump\u2019s Iran-related comments.","relevance_score":0.42,"sentiment":"mixed","source_quality":"high","summary":"Jimmy Kimmel criticized Donald Trump\u2019s Iran-related rhetoric, arguing it mixes threats with a bragging tone. The Guardian frames the reaction as part of broader late-night commentary on Trump\u2019s \u201cmixed message\u201d on Iran and a cease-fire context.","topics":["Iran","Trump rhetoric","late-night commentary","cease-fire deal (mentioned in source summary)","media reaction"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Kimmel on Trump: \u2018He talks about war like he\u2019s bragging about women with Billy Bush\u2019 The Guardian Late Night Puzzles Over Trump\u2019s \u2018Mixed Message\u2019 on Iran The New York Times Jimmy Kimmel, Stephen Colbert ream Trump over Iran threats USA Today Jimmy Kimmel Explains Why He Hates the TACO Trump Taunts The Daily Beast \u2018He went from Mahatma Gandhi to General Zod like that\u2019: Kimmel, Colbert react to Trump\u2019s Iran comments, cease-fire deal The Boston Globe","title":"Kimmel on Trump: \u2018He talks about war like he\u2019s bragging about women with Billy Bush\u2019 - 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

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_9b52e489cb9b in signals