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-08T10:33:26.208520+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:577d690ebac0e83c","evidence_event_ids":["evt_e6a213bae615"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://decrypt.co/363611/bitcoin-spikes-over-72k-as-trump-announces-conditional-ceasefire-with-iran","as_of":"2026-04-08T10:33:26.208520+00:00","canonical_url":"https://decrypt.co/363611/bitcoin-spikes-over-72k-as-trump-announces-conditional-ceasefire-with-iran","enrichment":{"aggregator_url":"https://decrypt.co/363611/bitcoin-spikes-over-72k-as-trump-announces-conditional-ceasefire-with-iran","article_chars":4967,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_e6bdec87963a6381","canonical_host":"decrypt.co","canonical_is_aggregator":false,"canonical_url":"https://decrypt.co/363611/bitcoin-spikes-over-72k-as-trump-announces-conditional-ceasefire-with-iran","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T10:37:24.556008+00:00","extraction_method":"heuristic","fetched_description":"Crypto prices jumped on the announcement of a two-week ceasefire and the reopening of the Strait of Hormuz\u2014but macro events loom.","fetched_title":"Bitcoin Spikes Over $72K as Trump Announces Conditional Ceasefire With Iran - Decrypt","final_url":"https://decrypt.co/363611/bitcoin-spikes-over-72k-as-trump-announces-conditional-ceasefire-with-iran","html_truncated":true,"paywall_likely":false,"publisher_domain":"decrypt.co","publisher_resolution":"canonical_url","requested_url":"https://decrypt.co/363611/bitcoin-spikes-over-72k-as-trump-announces-conditional-ceasefire-with-iran","source_event_id":"evt_e6a213bae615","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"73956d744afbc670","kind":"crypto_extremes","published_at":"2026-04-08T09:47:03+00:00","publisher_domain":"decrypt.co","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"crypto_asset"},{"asset_class":"cryptocurrency","name":"Ethereum","relevance":"medium","symbol":"ETH","type":"crypto_asset"},{"asset_class":"cryptocurrency","name":"XRP","relevance":"medium","symbol":"XRP","type":"crypto_asset"},{"asset_class":"other","name":"Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geographic_feature"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned text does not include the exact timestamp or the precise mechanism/wording of the 'conditional ceasefire' beyond the headline/summary.","The cleaned text does not provide evidence that the Strait of Hormuz was actually reopened\u2014only that it was announced as part of the event.","The headline says Bitcoin spiked over $72K, but the provided cleaned price list shows BTC at $71,540.00; the discrepancy (timing/measurement) is not resolved in the text.","No details are given about which 'macro events' loom or how they may affect crypto."],"key_facts":["Headline states Bitcoin spiked over $72K as Trump announced a conditional ceasefire with Iran.","Source summary states crypto prices jumped on the announcement of a two-week ceasefire.","Source summary states the reopening of the Strait of Hormuz was part of the announcement.","Article text includes a BTC price of $71,540.00 with a +4.10% move (as presented in the cleaned text).","Article text includes ETH at $2,246.84 (+6.66%) and XRP at $1.38 (+5.04%) (as presented in the cleaned text).","Source summary states macro events loom (no specifics provided)."],"numeric_claims":[{"label":"BTC price (as listed)","value":"$71,540.00"},{"label":"BTC move (as listed)","value":"+4.10%"},{"label":"ETH price (as listed)","value":"$2,246.84"},{"label":"ETH move (as listed)","value":"+6.66%"},{"label":"XRP price (as listed)","value":"$1.38"},{"label":"XRP move (as listed)","value":"+5.04%"}],"primary_claim":"Crypto prices jumped after Trump announced a conditional two-week ceasefire with Iran and the reopening of the Strait of Hormuz, with Bitcoin spiking over $72K.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"Bitcoin rose above $72K following an announcement by Trump of a conditional two-week ceasefire with Iran, alongside claims about reopening the Strait of Hormuz. The article also reports broad crypto gains across many assets, though it notes macro events may loom.","topics":["Bitcoin price spike","Trump announcement","Iran ceasefire","Strait of Hormuz reopening","crypto market rally","macro events risk"]},"source":"Decrypt RSS","source_domain":"decrypt.co","summary":"Crypto prices jumped on the announcement of a two-week ceasefire and the reopening of the Strait of Hormuz\u2014but macro events loom.","tickers":[],"title":"Bitcoin Spikes Over $72K as Trump Announces Conditional Ceasefire With Iran","url":"https://decrypt.co/363611/bitcoin-spikes-over-72k-as-trump-announces-conditional-ceasefire-with-iran"}}

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