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-08T19:34:52.504774+00:00","dedupe_key":"signal_enriched:news_delta:57037dad867e69b7","evidence_event_ids":["evt_3fec156d8da6"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxObDJfVWhESHhjTFd2V2FONHpaQmV6Q3c0eGY0WDM4c2ZleFZYZGd3TjdvSkEzd1gzUWNiRHc0c0t5R2Z5OFBybUJIeDlCb3lQNFdQWGxmSHppQVBuc0hRN0hhTHFGOXV5d3EtYmpMRjNyN2gyWjRyNm51RVd4cDJJUHJudHNBakNscFRHZmc5bGY?oc=5","as_of":"2026-04-08T19:34:52.504774+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/CBMikAFBVV95cUxObDJfVWhESHhjTFd2V2FONHpaQmV6Q3c0eGY0WDM4c2ZleFZYZGd3TjdvSkEzd1gzUWNiRHc0c0t5R2Z5OFBybUJIeDlCb3lQNFdQWGxmSHppQVBuc0hRN0hhTHFGOXV5d3EtYmpMRjNyN2gyWjRyNm51RVd4cDJJUHJudHNBakNscFRHZmc5bGY?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_461213c186dc1ed9","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-09T22:08:10.089038+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxObDJfVWhESHhjTFd2V2FONHpaQmV6Q3c0eGY0WDM4c2ZleFZYZGd3TjdvSkEzd1gzUWNiRHc0c0t5R2Z5OFBybUJIeDlCb3lQNFdQWGxmSHppQVBuc0hRN0hhTHFGOXV5d3EtYmpMRjNyN2gyWjRyNm51RVd4cDJJUHJudHNBakNscFRHZmc5bGY?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxObDJfVWhESHhjTFd2V2FONHpaQmV6Q3c0eGY0WDM4c2ZleFZYZGd3TjdvSkEzd1gzUWNiRHc0c0t5R2Z5OFBybUJIeDlCb3lQNFdQWGxmSHppQVBuc0hRN0hhTHFGOXV5d3EtYmpMRjNyN2gyWjRyNm51RVd4cDJJUHJudHNBakNscFRHZmc5bGY?oc=5","source_event_id":"evt_3fec156d8da6","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"bbc18dc34c8fa056","published_at":"2026-04-08T13:28:29+00:00","publisher_domain":"yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Donald Trump","relevance":"primary source of the proposal","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Iran","relevance":"counterparty in the proposed joint venture","symbol":"","type":"country"},{"asset_class":"geopolitical chokepoint","name":"Strait of Hormuz","relevance":"location of the toll policy under discussion","symbol":"","type":"geographic chokepoint"},{"asset_class":"","name":"Republicans (GOP dissenters)","relevance":"domestic political reaction to Trump\u2019s Iran-related threats","symbol":"","type":"political group"},{"asset_class":"","name":"White House","relevance":"referenced in source summary regarding reopening/tolls stance","symbol":"","type":"government body"},{"asset_class":"","name":"Reuters","relevance":"mentioned in source summary as reporting related statements","symbol":"","type":"news organization"},{"asset_class":"","name":"Axios","relevance":"mentioned in source summary as reporting GOP dissent and threat framing","symbol":"","type":"news organization"},{"asset_class":"","name":"ABC News","relevance":"mentioned in source summary as reporting Republican break with Trump","symbol":"","type":"news organization"},{"asset_class":"","name":"The New York Times","relevance":"mentioned in source summary as discussing war-crimes framing","symbol":"","type":"news organization"},{"asset_class":"","name":"Yahoo","relevance":"headline/source domain for this signal","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains no substantive content beyond page styling; only the headline and the supplied source summary were usable.","No details are provided on whether the joint venture is a formal proposal, timing, legal feasibility, or who would participate (companies/government entities).","No specifics are given on how \u201ctolls\u201d would be structured, collected, or enforced.","Near-term catalyst timing is unclear from the provided text (no dates or implementation milestones).","No direct market/sector impact is stated in the provided material; any directional impact on shipping/energy risk is inferred rather than explicitly reported."],"key_facts":["Trump said he is considering a \u201cjoint venture\u201d with Iran for Strait of Hormuz tolls (Yahoo headline).","The broader context includes U.S. pressure to reopen the Strait without tolls (per Reuters/White House reference in the provided source summary).","The provided source summary indicates some Republicans have broken with Trump over his Iran-related threats (Axios/ABC News references)."],"numeric_claims":[],"primary_claim":"Trump is considering a \u201cjoint venture\u201d with Iran for Strait of Hormuz tolls.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"Trump said he is considering a \u201cjoint venture\u201d with Iran related to Strait of Hormuz tolls. The proposal is tied to ongoing U.S. policy pressure around reopening the Strait and could affect near-term geopolitical and shipping-risk expectations.","topics":["Iran","Strait of Hormuz","tolls","joint venture","U.S. policy","shipping risk","U.S.-Iran tensions","domestic political reaction"]},"source":"Yahoo","source_domain":"yahoo.com","source_url":"https://www.yahoo.com","summary":"Trump says he\u2019s considering \u2018joint venture\u2019 with Iran for Strait of Hormuz tolls Yahoo Trump\u2019s Iran Threats Look Like Self-Incrimination for Potential War Crimes The New York Times Trump pushes for Strait of Hormuz reopening without tolls, White House says. Reuters GOP dissenters emerge on Trump's threat against Iranian \"civilization\" Axios 'That is not who we are': Some Republicans break with Trump over Iran threats ABC News","title":"Trump says he\u2019s considering \u2018joint venture\u2019 with Iran for Strait of Hormuz tolls - Yahoo","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 8291 in events