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/CBMiugFBVV95cUxNdUE1XzhRUFpObWhmc2VoTFBJQV8tLVJFczNrV3p5REV5ZW9fcFZCdUFndkxXNzh4dV93djEwZ1JlRmRVSjFVV1VTS3ZaMXo5VDBvV255TnhnOExqZXF5WnNqQVN5dVpEcTJPOV9xbFJnMVpkZ1RkVkNZdWtjYmx3ejBfSU5ReHA0eWVwUzg2eS0yS2JhQzZfN25wbllJY2JyN0U4cV9RX01sZmVqU093VGdZNS02anBZWmc?oc=5","as_of":"2026-04-09T16:31:19.618180+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/CBMiugFBVV95cUxNdUE1XzhRUFpObWhmc2VoTFBJQV8tLVJFczNrV3p5REV5ZW9fcFZCdUFndkxXNzh4dV93djEwZ1JlRmRVSjFVV1VTS3ZaMXo5VDBvV255TnhnOExqZXF5WnNqQVN5dVpEcTJPOV9xbFJnMVpkZ1RkVkNZdWtjYmx3ejBfSU5ReHA0eWVwUzg2eS0yS2JhQzZfN25wbllJY2JyN0U4cV9RX01sZmVqU093VGdZNS02anBZWmc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_d6d7882b56295339","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:57:59.534107+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiugFBVV95cUxNdUE1XzhRUFpObWhmc2VoTFBJQV8tLVJFczNrV3p5REV5ZW9fcFZCdUFndkxXNzh4dV93djEwZ1JlRmRVSjFVV1VTS3ZaMXo5VDBvV255TnhnOExqZXF5WnNqQVN5dVpEcTJPOV9xbFJnMVpkZ1RkVkNZdWtjYmx3ejBfSU5ReHA0eWVwUzg2eS0yS2JhQzZfN25wbllJY2JyN0U4cV9RX01sZmVqU093VGdZNS02anBZWmc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nbcnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiugFBVV95cUxNdUE1XzhRUFpObWhmc2VoTFBJQV8tLVJFczNrV3p5REV5ZW9fcFZCdUFndkxXNzh4dV93djEwZ1JlRmRVSjFVV1VTS3ZaMXo5VDBvV255TnhnOExqZXF5WnNqQVN5dVpEcTJPOV9xbFJnMVpkZ1RkVkNZdWtjYmx3ejBfSU5ReHA0eWVwUzg2eS0yS2JhQzZfN25wbllJY2JyN0U4cV9RX01sZmVqU093VGdZNS02anBZWmc?oc=5","source_event_id":"evt_be7d4963a504","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"aed3d3f120869f8e","published_at":"2026-04-09T15:34:00+00:00","publisher_domain":"nbcnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Republicans","relevance":"high","symbol":"","type":"political_party"},{"asset_class":"equity","name":"Democrats","relevance":"high","symbol":"","type":"political_party"},{"asset_class":"equity","name":"President Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"equity","name":"House of Representatives","relevance":"medium","symbol":"","type":"government_body"},{"asset_class":"equity","name":"U.S. Senate","relevance":"medium","symbol":"","type":"government_body"},{"asset_class":"other","name":"NBC News","relevance":"low","symbol":"","type":"media_outlet"}],"event_type":"regulation","information_gaps":["The specific bill/resolution name, text, and vote count/margin are not provided in the supplied content.","Timing details (exact date/time of the Senate vote or House action) are not included.","The nature of the \u201ccivilization\u201d threat claim (who said it and in what context) is not specified beyond the headline framing.","Whether the blocked effort would have fully halted hostilities or only constrained war powers is not fully determinable from the provided excerpt."],"key_facts":["NBC News headline states Republicans blocked an effort to halt Trump\u2019s war with Iran.","The headline frames the rationale as a \u201ccivilization\u201d threat.","Source summary indicates Democrats were pushing to pass an Iran war powers resolution despite a House recess.","Source summary indicates a U.S. Senate vote on a resolution to curb Trump\u2019s Iran war powers was expected (Reuters mention)."],"numeric_claims":[],"primary_claim":"Republicans blocked a Democratic bill/resolution aimed at halting or ending Trump\u2019s war with Iran after citing a \u201ccivilization\u201d threat.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"Republicans blocked a Democratic effort to halt or curb President Trump\u2019s war powers related to the U.S. conflict with Iran, despite a tenuous ceasefire. The dispute is framed around claims that the situation poses a \u201ccivilization\u201d threat.","topics":["U.S. Iran war powers","U.S. congressional action","ceasefire","partisan conflict","foreign policy authorization"]},"source":"NBC News","source_domain":"nbcnews.com","source_url":"https://www.nbcnews.com","summary":"Republicans block effort to halt Trump's war with Iran after 'civilization' threat NBC News Republicans block Democratic bill to end Iran war amid tenuous ceasefire USA Today Democrats push to pass Iran war powers resolution despite House recess, accusing Trump of \u2018unhinged behavior\u2019 \u2013 US politics live The Guardian Republicans block Jeffries' gambit to curb Trump's Iran war powers Fox News US Senate to vote on resolution to curb Trump's Iran war powers Reuters","title":"Republicans block effort to halt Trump's war with Iran after 'civilization' threat - NBC 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_806f923440ba in signals