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-08T13:34:57.076205+00:00","dedupe_key":"signal_enriched:news_delta:d10f0758aad23921","evidence_event_ids":["evt_6c240cf68634"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMipwFBVV95cUxQRkFHeVBldDFwc19nbjZ2VkhKWVlNRGlYamo1bS1EcVNMRzI5Z29sbDEtWnRjMk5tTWRRd3ZrOWtfS3NVNFhZM0dvQlQ5RTlFSnNUbDRRd09oZkREbnFJMmYyYmo0VHRxWGZLd2dkRFQ3LUxMdk94LV9zWWJzT0EyUTJhVThyeF9jdE5ESjNFbVVQdWJ0UmJVOXZWTWZTVlRLeWpCWER0RQ?oc=5","as_of":"2026-04-08T13:34:57.076205+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/CBMipwFBVV95cUxQRkFHeVBldDFwc19nbjZ2VkhKWVlNRGlYamo1bS1EcVNMRzI5Z29sbDEtWnRjMk5tTWRRd3ZrOWtfS3NVNFhZM0dvQlQ5RTlFSnNUbDRRd09oZkREbnFJMmYyYmo0VHRxWGZLd2dkRFQ3LUxMdk94LV9zWWJzT0EyUTJhVThyeF9jdE5ESjNFbVVQdWJ0UmJVOXZWTWZTVlRLeWpCWER0RQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_fe802a9236885df9","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-08T16:25:47.774992+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipwFBVV95cUxQRkFHeVBldDFwc19nbjZ2VkhKWVlNRGlYamo1bS1EcVNMRzI5Z29sbDEtWnRjMk5tTWRRd3ZrOWtfS3NVNFhZM0dvQlQ5RTlFSnNUbDRRd09oZkREbnFJMmYyYmo0VHRxWGZLd2dkRFQ3LUxMdk94LV9zWWJzT0EyUTJhVThyeF9jdE5ESjNFbVVQdWJ0UmJVOXZWTWZTVlRLeWpCWER0RQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"wsj.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMipwFBVV95cUxQRkFHeVBldDFwc19nbjZ2VkhKWVlNRGlYamo1bS1EcVNMRzI5Z29sbDEtWnRjMk5tTWRRd3ZrOWtfS3NVNFhZM0dvQlQ5RTlFSnNUbDRRd09oZkREbnFJMmYyYmo0VHRxWGZLd2dkRFQ3LUxMdk94LV9zWWJzT0EyUTJhVThyeF9jdE5ESjNFbVVQdWJ0UmJVOXZWTWZTVlRLeWpCWER0RQ?oc=5","source_event_id":"evt_6c240cf68634","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"cc7207776785a502","published_at":"2026-04-08T10:58:00+00:00","publisher_domain":"wsj.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"The Wall Street Journal (WSJ)","relevance":"primary source of the headline delta","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"Donald Trump","relevance":"subject of the countdown coverage","symbol":"","type":"person"},{"asset_class":"other","name":"Iran","relevance":"target of the referenced threats/countdown","symbol":"","type":"country"},{"asset_class":"other","name":"The New York Times","relevance":"mentioned as providing a related critique","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"ABC News","relevance":"mentioned as providing a related critique","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"PBS","relevance":"mentioned as providing legal context","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"The Daily Beast","relevance":"mentioned as providing a related critique","symbol":"","type":"media_outlet"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is not the actual article content; it appears to be unrelated page styling/HTML, so no additional grounded details (e.g., exact wording, timing, or specific claims from WSJ) can be extracted beyond the headline and the provided source summary.","The signal does not specify when the \u201c12-hour\u201d countdown occurred or whether it was a literal operational threat versus rhetorical framing.","No direct confirmation is provided here of the specific targets mentioned (e.g., bridges/power plants) beyond what the source summary attributes to other outlets; those details cannot be verified from the provided text."],"key_facts":["The WSJ headline references coverage of Trump\u2019s \u201c12-hour Iran \u2018civilization\u2019 countdown.\u201d","Other cited outlets (NYT, ABC News, PBS, Daily Beast) are described in the provided source summary as discussing critiques of Trump\u2019s Iran threats, including international law/war-crimes framing and Republican disagreement (as characterized by those outlets)."],"numeric_claims":[{"label":"countdown_duration","value":"12 hours"}],"primary_claim":"WSJ covered Trump\u2019s \u201c12-hour Iran \u2018civilization\u2019 countdown.\u201d","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The signal indicates WSJ coverage of Trump\u2019s \u201c12-hour\u201d Iran \u201ccivilization\u201d countdown framing, and it is contrasted with other outlets\u2019 critiques of the threats and their legal/ethical implications.","topics":["Iran threats","Trump rhetoric","international law","potential war crimes","political dissent","media coverage"]},"source":"WSJ","source_domain":"wsj.com","source_url":"https://www.wsj.com","summary":"How the Journal Covered Trump\u2019s 12-Hour Iran \u2018Civilization\u2019 Countdown WSJ Trump\u2019s Iran Threats Look Like Self-Incrimination for Potential War Crimes The New York Times 'That is not who we are': Some Republicans break with Trump over Iran threats ABC News What international law says about Trump's threats to bomb Iran's bridges and power plants PBS Donald Trump Floats Absurd Fantasy to Cope With Iran Humiliation The Daily Beast","title":"How the Journal Covered Trump\u2019s 12-Hour Iran \u2018Civilization\u2019 Countdown - WSJ","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 7216 in events