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/CBMipAFBVV95cUxOekJCZUFzWVQwcjdGZUFEVjlVWWs3ckhaUzZNMUJ4YlhKcVkxckVKYlNJV1l3d1kwSEtQVVNseUs0MXF3R19WdXJiRzlHX1hOLS04dWVUaEJhMkxuV2NraHFtTnFLLVdDclJSUktodVpuSFNyU05sUi1TMVJONW9qeG1XVlAxZlJEM1NlbFVLclRvYkV6VExwRWZ4cG1EVzI5UlN2d9IBqgFBVV95cUxNVDkwRkNqQ0V2S2pFZzVwclVrdHRhbDZEMGVTOXRlSlpnOWNfUEdzTGJUNTBUSGVSS1F4eUJTbHByVHBnVUFmRmRjQl9hd3pudEpjcHV4VXQyWVlZOTRMMWxkUEJGWlBOaEhKT3IzSHd1UFBWZlJoaDdPSmxhVVZlUGpIckRucTNZWmExbDRycWxNZ2NGUDB3RDRGek5KVExMUWlzc3A2aU1uZw?oc=5","as_of":"2026-04-09T12:52:05.832001+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/CBMipAFBVV95cUxOekJCZUFzWVQwcjdGZUFEVjlVWWs3ckhaUzZNMUJ4YlhKcVkxckVKYlNJV1l3d1kwSEtQVVNseUs0MXF3R19WdXJiRzlHX1hOLS04dWVUaEJhMkxuV2NraHFtTnFLLVdDclJSUktodVpuSFNyU05sUi1TMVJONW9qeG1XVlAxZlJEM1NlbFVLclRvYkV6VExwRWZ4cG1EVzI5UlN2d9IBqgFBVV95cUxNVDkwRkNqQ0V2S2pFZzVwclVrdHRhbDZEMGVTOXRlSlpnOWNfUEdzTGJUNTBUSGVSS1F4eUJTbHByVHBnVUFmRmRjQl9hd3pudEpjcHV4VXQyWVlZOTRMMWxkUEJGWlBOaEhKT3IzSHd1UFBWZlJoaDdPSmxhVVZlUGpIckRucTNZWmExbDRycWxNZ2NGUDB3RDRGek5KVExMUWlzc3A2aU1uZw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_85ed4f23587a871d","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-09T23:21:28.577036+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipAFBVV95cUxOekJCZUFzWVQwcjdGZUFEVjlVWWs3ckhaUzZNMUJ4YlhKcVkxckVKYlNJV1l3d1kwSEtQVVNseUs0MXF3R19WdXJiRzlHX1hOLS04dWVUaEJhMkxuV2NraHFtTnFLLVdDclJSUktodVpuSFNyU05sUi1TMVJONW9qeG1XVlAxZlJEM1NlbFVLclRvYkV6VExwRWZ4cG1EVzI5UlN2d9IBqgFBVV95cUxNVDkwRkNqQ0V2S2pFZzVwclVrdHRhbDZEMGVTOXRlSlpnOWNfUEdzTGJUNTBUSGVSS1F4eUJTbHByVHBnVUFmRmRjQl9hd3pudEpjcHV4VXQyWVlZOTRMMWxkUEJGWlBOaEhKT3IzSHd1UFBWZlJoaDdPSmxhVVZlUGpIckRucTNZWmExbDRycWxNZ2NGUDB3RDRGek5KVExMUWlzc3A2aU1uZw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cbsnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMipAFBVV95cUxOekJCZUFzWVQwcjdGZUFEVjlVWWs3ckhaUzZNMUJ4YlhKcVkxckVKYlNJV1l3d1kwSEtQVVNseUs0MXF3R19WdXJiRzlHX1hOLS04dWVUaEJhMkxuV2NraHFtTnFLLVdDclJSUktodVpuSFNyU05sUi1TMVJONW9qeG1XVlAxZlJEM1NlbFVLclRvYkV6VExwRWZ4cG1EVzI5UlN2d9IBqgFBVV95cUxNVDkwRkNqQ0V2S2pFZzVwclVrdHRhbDZEMGVTOXRlSlpnOWNfUEdzTGJUNTBUSGVSS1F4eUJTbHByVHBnVUFmRmRjQl9hd3pudEpjcHV4VXQyWVlZOTRMMWxkUEJGWlBOaEhKT3IzSHd1UFBWZlJoaDdPSmxhVVZlUGpIckRucTNZWmExbDRycWxNZ2NGUDB3RDRGek5KVExMUWlzc3A2aU1uZw?oc=5","source_event_id":"evt_ffcd88a0ab5b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"829b264eba851a6f","published_at":"2026-04-09T12:17:00+00:00","publisher_domain":"cbsnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Donald Trump","relevance":"primary","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Iran","relevance":"primary","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States","relevance":"primary","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Israel","relevance":"secondary","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Lebanon","relevance":"secondary","symbol":"","type":"country"},{"asset_class":"","name":"CBS News","relevance":"source","symbol":"","type":"media"},{"asset_class":"","name":"CNBC","relevance":"source","symbol":"","type":"media"},{"asset_class":"","name":"The Hill","relevance":"source","symbol":"","type":"media"},{"asset_class":"","name":"The Boston Globe","relevance":"source","symbol":"","type":"media"},{"asset_class":"","name":"KCRA","relevance":"source","symbol":"","type":"media"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided appears to be unrelated page markup/CSS and does not contain the substantive news content; extraction is therefore based on the headline and the provided source summary only.","No specific ceasefire agreement name, parties, or timing details are included in the provided text.","No concrete details are provided about what \u201cnext conquest\u201d or the threatened attacks would entail (targets, timing, or authorization).","The claim about \u201cwar crimes\u201d is attributed to The Boston Globe in the summary, but the underlying specifics are not present here."],"key_facts":["CBS News headline frames the update as Trump threatening Iran while a dispute over Israel\u2019s war in Lebanon casts doubt on a ceasefire.","Trump is described (per the provided source summary) as saying the U.S. is ready for \u201cnext conquest.\u201d","Trump is described (per the provided source summary) as warning the military to remain near Iran until a \u201creal agreement\u201d is honored.","Trump is described (per the provided source summary) as warning of \u201cbigger,\u201d \u201cbetter,\u201d \u201cstronger\u201d attacks if an Iran deal is not reached.","The Boston Globe is described (per the provided source summary) as characterizing the threats as part of a long pattern involving potential war crimes against Iran (uncertainty: the exact wording and evidence are not included in the provided text)."],"numeric_claims":[],"primary_claim":"Trump threatened Iran and warned U.S. forces to remain near Iran until a \u201creal agreement\u201d is honored, as disputes over Israel\u2019s Lebanon war cast doubt on a ceasefire.","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"CBS News reports that Trump is threatening Iran amid uncertainty over a ceasefire related to Israel\u2019s war in Lebanon. Multiple outlets cited in the provided source summary describe Trump warning of escalation if Iran does not comply with a \u201creal agreement.\u201d","topics":["Iran","U.S.-Iran tensions","ceasefire uncertainty","Israel-Lebanon conflict","military posture","threat of escalation"]},"source":"CBS News","source_domain":"cbsnews.com","source_url":"https://www.cbsnews.com","summary":"Live Updates: Trump threatens Iran as dispute over Israel's war in Lebanon casts doubt on ceasefire CBS News Trump says U.S. ready for 'next conquest,' warns military to remain near Iran until 'real agreement' is honored CNBC Trump warns of \u2018bigger,\u2019 \u2018better,\u2019 stronger\u2019 attacks if Iran deal is not reached The Hill Trump\u2019s threats of potential war crimes against Iran are part of a long pattern The Boston Globe President Trump warns 'Shootin' Starts' again if Iran does not comply with ceasefire agreement KCRA","title":"Live Updates: Trump threatens Iran as dispute over Israel's war in Lebanon casts doubt on ceasefire - CBS News","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_e4e240bee6a8 in signals