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-22T14:13:37.135360+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:b5824846d3c722a9","evidence_event_ids":["evt_c422eacbad8b"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/bitcoin","as_of":"2026-04-22T14:13:37.135360+00:00","canonical_url":"https://www.coingecko.com/en/coins/bitcoin","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/bitcoin","article_chars":174,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_1428b6eeb391d7d8","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/bitcoin","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T14:17:58.124442+00:00","extraction_method":"trafilatura","fetched_description":"Track the latest Bitcoin price, market cap, trading volume, news and more with CoinGecko's live BTC/PHP price chart and popular cryptocurrency price tracker.","fetched_title":"Bitcoin Price: BTC/PHP Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/bitcoin","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/bitcoin","source_event_id":"evt_c422eacbad8b","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"9f0d695c76bc590a","kind":"crypto_extremes","published_at":"2026-04-22T14:13:46.185501+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["2 hours ago"],"entities":[{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"crypto_asset"}],"event_type":"price_action","information_gaps":["The text does not specify which ceasefire extension or which corporate buyers.","No percentage change, volume, or timeframe beyond '2 hours ago' is provided.","The 'trend score 6' and 'market cap rank 1' are mentioned in the source summary but not defined in the article text.","No confirmation is provided for the causal attribution (ceasefire extension and corporate buys) beyond the headline wording."],"key_facts":["BTC price shown as $78,975.69.","BTC is described as #1 by market cap rank in the source summary.","A 24h range is given as $74,935.37 to $79,001.18.","The headline states Bitcoin surged past $78K.","The headline attributes the surge to a ceasefire extension and major corporate buys."],"numeric_claims":[{"label":"BTC price","value":"78975.69"},{"label":"24h range low","value":"74935.37"},{"label":"24h range high","value":"79001.18"},{"label":"trend score","value":"6"},{"label":"market cap rank","value":"1"}],"primary_claim":"BTC is at $78,975.69 and surged past $78K, with a stated 24h range of $74,935.37\u2013$79,001.18.","relevance_score":0.62,"sentiment":"positive","source_quality":"unknown","summary":"Bitcoin (BTC) is trading around $78,975.69 and is reported to have surged past $78K. The provided text attributes the move to a ceasefire extension and major corporate buys, and shows a 24h price range of $74,935.37 to $79,001.18.","topics":["Bitcoin price","24h range","market move","ceasefire extension","corporate buys","trend score"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 1, trend score 6","tickers":["BTC","BTCUSD"],"title":"Trending: Bitcoin (BTC)","url":"https://www.coingecko.com/en/coins/bitcoin"}}

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