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-07T23:23:54.391414+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:7349297b9b29d489","evidence_event_ids":["evt_3867d600d88c"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.bitcoin.com/trump-announces-two-week-ceasefire-with-iran-after-pakistan-mediation-bitcoin-spikes-to-71k/","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://news.bitcoin.com/trump-announces-two-week-ceasefire-with-iran-after-pakistan-mediation-bitcoin-spikes-to-71k/","enrichment":{"aggregator_url":"https://news.bitcoin.com/trump-announces-two-week-ceasefire-with-iran-after-pakistan-mediation-bitcoin-spikes-to-71k/","article_chars":3963,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_443e4a62b712be4e","canonical_host":"news.bitcoin.com","canonical_is_aggregator":false,"canonical_url":"https://news.bitcoin.com/trump-announces-two-week-ceasefire-with-iran-after-pakistan-mediation-bitcoin-spikes-to-71k/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T00:51:37.033169+00:00","extraction_method":"heuristic","fetched_description":"Trump suspended planned U.S. military strikes on Iran on Tuesday, announcing a two-week ceasefire contingent on Iran reopening the Strait.","fetched_title":"Trump Announces Two-Week Ceasefire With Iran After Pakistan Mediation, Bitcoin Spikes to $71K \u2013 Bitcoin News","final_url":"https://news.bitcoin.com/trump-announces-two-week-ceasefire-with-iran-after-pakistan-mediation-bitcoin-spikes-to-71k/","html_truncated":true,"paywall_likely":false,"publisher_domain":"news.bitcoin.com","publisher_resolution":"canonical_url","requested_url":"https://news.bitcoin.com/trump-announces-two-week-ceasefire-with-iran-after-pakistan-mediation-bitcoin-spikes-to-71k/","source_event_id":"evt_3867d600d88c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e6506f96ed451f57","kind":"crypto_extremes","published_at":"2026-04-07T23:06:11+00:00","publisher_domain":"news.bitcoin.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["April 7, 2026","September 2025"],"entities":[{"asset_class":"","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"","name":"Pakistan","relevance":"medium","symbol":"","type":"country"},{"asset_class":"","name":"Shehbaz Sharif","relevance":"medium","symbol":"","type":"person"},{"asset_class":"","name":"Asim Munir","relevance":"medium","symbol":"","type":"person"},{"asset_class":"","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"location"},{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"crypto_asset"}],"event_type":"geopolitical_risk","information_gaps":["Whether Iran formally confirmed the conditions after the time stated is not provided.","The article does not provide the exact mechanism/timing for \u201ccomplete, immediate, and safe reopening\u201d beyond stating it is the central condition.","Details of the \u201c10-point proposal\u201d are not enumerated in the provided text.","The claim that Israel agreed is described as \u201creportedly\u201d without sourcing details in the provided text."],"key_facts":["Trump announced a two-week ceasefire with Iran on April 7, 2026.","The ceasefire is contingent on Iran reopening the Strait of Hormuz to global shipping.","Trump suspended planned U.S. military strikes minutes before an 8:00 p.m. EDT deadline.","Trump said U.S. forces had \u201cmet and exceeded all Military objectives\u201d before the pause.","The Strait of Hormuz carries roughly 20.3 million barrels of oil per day (and significant LNG volumes, per the text).","The article states Pakistan\u2019s Field Marshal Asim Munir and PM Shehbaz Sharif brokered the deal.","Trump said Iran submitted a 10-point proposal through mediators and described it as a \u201cworkable basis\u201d for negotiations.","Bitcoin rose above $71,000 after Trump\u2019s announcement and reached an intraday high of $71,720.","The article says Israel has reportedly agreed to the ceasefire terms.","As of the evening of April 7, Iran had not issued a formal public confirmation of the conditions (per the text)."],"numeric_claims":[{"label":"Ceasefire duration","value":"two weeks"},{"label":"Announcement date","value":"April 7, 2026"},{"label":"Strike deadline","value":"8:00 p.m. EDT"},{"label":"Bitcoin intraday high","value":"$71,720"},{"label":"Bitcoin move","value":"up 3%"},{"label":"Oil through Strait of Hormuz","value":"20.3 million barrels/day"},{"label":"Oil/LNG trade affected (stated range)","value":"20 to 30 percent"}],"primary_claim":"Trump suspended planned U.S. military strikes on Iran for two weeks, contingent on Iran reopening the Strait of Hormuz to global shipping, and bitcoin subsequently spiked above $71,000.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"Trump announced a two-week U.S. ceasefire with Iran, suspending planned strikes contingent on Iran reopening the Strait of Hormuz to global shipping. After the announcement, bitcoin rose above $71,000 and reached an intraday high of $71,720.","topics":["U.S.-Iran ceasefire","Strait of Hormuz reopening","U.S. military strikes suspension","Pakistan mediation","Bitcoin price spike"]},"source":"Bitcoin.com News","source_domain":"news.bitcoin.com","summary":"President Donald Trump suspended planned U.S. military strikes on Iran on Tuesday, announcing a two-week ceasefire contingent on Iran reopening the Strait of Hormuz to global shipping. Following the announcement from Trump, the leading crypto asset, bitcoin, rose above the $71,000 mark. Key Takeaways: Trump declared a two-week ceasefire with Iran on April 7, 2026, [\u2026]","tickers":[],"title":"Trump Announces Two-Week Ceasefire With Iran After Pakistan Mediation, Bitcoin Spikes to $71K","url":"https://news.bitcoin.com/trump-announces-two-week-ceasefire-with-iran-after-pakistan-mediation-bitcoin-spikes-to-71k/"}}

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 2640 in events