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-09T13:37:34.641242+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:7e583da891719578","evidence_event_ids":["evt_7b4f216ab9d5"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://decrypt.co/363739/meet-anti-trump-crypto-developer-running-congress-virginia","as_of":"2026-04-09T13:37:34.641242+00:00","canonical_url":"https://decrypt.co/363739/meet-anti-trump-crypto-developer-running-congress-virginia","enrichment":{"aggregator_url":"https://decrypt.co/363739/meet-anti-trump-crypto-developer-running-congress-virginia","article_chars":4954,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_91cda0cbb8d894b4","canonical_host":"decrypt.co","canonical_is_aggregator":false,"canonical_url":"https://decrypt.co/363739/meet-anti-trump-crypto-developer-running-congress-virginia","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T00:42:36.196732+00:00","extraction_method":"heuristic","fetched_description":"Ethereum developer Joe Schiarizzi says most pro-crypto lawmakers in D.C. \u201cjust want a check\u201d and don\u2019t actually understand the technology\u2014or its potential.","fetched_title":"Meet the Anti-Trump Crypto Developer Running for Congress in Virginia - Decrypt","final_url":"https://decrypt.co/363739/meet-anti-trump-crypto-developer-running-congress-virginia","html_truncated":true,"paywall_likely":false,"publisher_domain":"decrypt.co","publisher_resolution":"canonical_url","requested_url":"https://decrypt.co/363739/meet-anti-trump-crypto-developer-running-congress-virginia","source_event_id":"evt_7b4f216ab9d5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"af4b49cefd5463e5","kind":"crypto_extremes","published_at":"2026-04-09T13:01:03+00:00","publisher_domain":"decrypt.co","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Joe Schiarizzi","relevance":"high","symbol":"","type":"person"},{"asset_class":"cryptocurrency","name":"Ethereum","relevance":"high","symbol":"ETH","type":"crypto_asset"},{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"medium","symbol":"BTC","type":"crypto_asset"},{"asset_class":"cryptocurrency","name":"XRP","relevance":"low","symbol":"XRP","type":"crypto_asset"},{"asset_class":"","name":"Virginia (Congressional race)","relevance":"medium","symbol":"","type":"location"},{"asset_class":"","name":"D.C. (lawmakers)","relevance":"medium","symbol":"","type":"location"}],"event_type":"other","information_gaps":["The cleaned text provided does not include the full article body beyond the crypto price list; details such as the election district, campaign platform, and the exact context for the \u201cAnti-Trump\u201d characterization are not present.","No date/timeframe is provided for the crypto price changes shown in the text (e.g., whether they are 24h, intraday, etc.).","The article text excerpt does not specify how many lawmakers are being referred to by \u201cmost,\u201d nor does it provide supporting evidence for Schiarizzi\u2019s characterization."],"key_facts":["Headline states: \u201cMeet the Anti-Trump Crypto Developer Running for Congress in Virginia.\u201d","Source summary attributes to Ethereum developer Joe Schiarizzi a claim that most pro-crypto lawmakers in D.C. \u201cjust want a check\u201d and don\u2019t understand the technology or its potential.","The provided article text includes a list of crypto prices and percentage changes (e.g., BTC $71,859.00 +1.52%, ETH $2,190.58 +0.39%)."],"numeric_claims":[{"label":"BTC price","value":"$71,859.00"},{"label":"BTC 24h/period change (as shown)","value":"+1.52%"},{"label":"ETH price","value":"$2,190.58"},{"label":"ETH 24h/period change (as shown)","value":"+0.39%"},{"label":"XRP price","value":"$1.34"},{"label":"XRP 24h/period change (as shown)","value":"+0.62%"}],"primary_claim":"Joe Schiarizzi says most pro-crypto lawmakers in D.C. \u201cjust want a check\u201d and don\u2019t actually understand the technology\u2014or its potential.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Ethereum developer Joe Schiarizzi, running for Congress in Virginia, criticizes many pro-crypto lawmakers in D.C. as lacking understanding of the technology and focusing on personal gain. The article also notes current crypto price levels alongside the political commentary.","topics":["crypto politics","candidate running for Congress","Ethereum developer","criticism of pro-crypto lawmakers","D.C. lawmakers","crypto market prices"]},"source":"Decrypt RSS","source_domain":"decrypt.co","summary":"Ethereum developer Joe Schiarizzi says most pro-crypto lawmakers in D.C. \u201cjust want a check\u201d and don\u2019t actually understand the technology\u2014or its potential.","tickers":[],"title":"Meet the Anti-Trump Crypto Developer Running for Congress in Virginia","url":"https://decrypt.co/363739/meet-anti-trump-crypto-developer-running-congress-virginia"}}

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