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-09T18:05:02.959642+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:0890cd5924f8ead3","evidence_event_ids":["evt_80d551bfdf81"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://decrypt.co/363819/solo-bitcoin-miner-hits-jackpot-225k-btc-reward","as_of":"2026-04-09T18:05:02.959642+00:00","canonical_url":"https://decrypt.co/363819/solo-bitcoin-miner-hits-jackpot-225k-btc-reward","enrichment":{"aggregator_url":"https://decrypt.co/363819/solo-bitcoin-miner-hits-jackpot-225k-btc-reward","article_chars":4985,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_642e69e47626f145","canonical_host":"decrypt.co","canonical_is_aggregator":false,"canonical_url":"https://decrypt.co/363819/solo-bitcoin-miner-hits-jackpot-225k-btc-reward","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T01:35:39.408546+00:00","extraction_method":"heuristic","fetched_description":"An individual Bitcoin miner hit the lottery overnight, scoring a $225,000 BTC reward when they found a block.","fetched_title":"Another Solo Bitcoin Miner Hits the Jackpot, Scoring $225K BTC Reward - Decrypt","final_url":"https://decrypt.co/363819/solo-bitcoin-miner-hits-jackpot-225k-btc-reward","html_truncated":true,"paywall_likely":false,"publisher_domain":"decrypt.co","publisher_resolution":"canonical_url","requested_url":"https://decrypt.co/363819/solo-bitcoin-miner-hits-jackpot-225k-btc-reward","source_event_id":"evt_80d551bfdf81","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"d528f36f48f9f48f","kind":"crypto_extremes","published_at":"2026-04-09T17:14:40+00:00","publisher_domain":"decrypt.co","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["overnight (exact date/time not provided)"],"entities":[{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"asset"},{"asset_class":"unknown","name":"Solo Bitcoin miner (unnamed)","relevance":"high","symbol":"","type":"person_or_entity"}],"event_type":"other","information_gaps":["The article text provided does not include the miner\u2019s name/identifier.","No block height, timestamp, or transaction/hash details are included in the provided text.","The text does not specify whether the $225,000 figure is based on BTC price at the time of reward or another valuation method.","No confirmation details (e.g., link to block explorer) are present in the provided text.","The large list of coin prices appears unrelated to the mining event and does not provide additional event-specific details."],"key_facts":["An individual solo Bitcoin miner reportedly found a block overnight.","The miner reportedly received a BTC reward valued at $225,000."],"numeric_claims":[{"label":"BTC reward value (USD)","value":"$225,000"}],"primary_claim":"Another individual (solo) Bitcoin miner scored a $225,000 BTC reward after finding a block overnight.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"A solo Bitcoin miner reportedly found a block overnight and received a BTC reward valued at $225,000.","topics":["Bitcoin mining","block found","solo miner","BTC reward"]},"source":"Decrypt RSS","source_domain":"decrypt.co","summary":"An individual Bitcoin miner hit the lottery overnight, scoring a $225,000 BTC reward when they found a block.","tickers":[],"title":"Another Solo Bitcoin Miner Hits the Jackpot, Scoring $225K BTC Reward","url":"https://decrypt.co/363819/solo-bitcoin-miner-hits-jackpot-225k-btc-reward"}}

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