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:f82445fecbeaaf73","evidence_event_ids":["evt_930c822e9251"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/zcash","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://www.coingecko.com/en/coins/zcash","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/zcash","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_09cd5e3ef8c703b4","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/zcash","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T01:00:06.890898+00:00","extraction_method":"heuristic","fetched_description":"Track the latest Zcash price, market cap, trading volume, news and more with CoinGecko's live ZEC/USD price chart and popular cryptocurrency price tracker.","fetched_title":"Zcash Price: ZEC/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/zcash","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/zcash","source_event_id":"evt_930c822e9251","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"79e4b059908de52d","kind":"crypto_extremes","published_at":"2026-04-07T23:23:59.708482+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Zcash","relevance":"high","symbol":"ZEC","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["The provided cleaned text does not include the actual ZEC price, 24h change, or any extreme/delta metrics beyond the stated market cap rank and trend score.","The text does not specify the time window or definition used for \u201ctrend score.\u201d","The excerpt contains extensive CoinGecko site navigation and unrelated content; it is unclear whether additional ZEC-specific details were omitted from the cleaned text."],"key_facts":["CoinGecko shows \u201cTrending: Zcash (ZEC)\u201d.","The signal text reports market cap rank 22 for Zcash.","The signal text reports trend score 0 for Zcash."],"numeric_claims":[{"label":"market_cap_rank","value":"22"},{"label":"trend_score","value":"0"}],"primary_claim":"Zcash (ZEC) has market cap rank 22 and a trend score of 0 on CoinGecko\u2019s \u201cTrending\u201d section.","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"The CoinGecko page indicates Zcash (ZEC) is currently listed under \u201cTrending,\u201d with market cap rank 22 and a trend score of 0.","topics":["CoinGecko","Trending coins","Zcash","market cap rank","trend score"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 22, trend score 0","tickers":["ZEC","ZECUSD"],"title":"Trending: Zcash (ZEC)","url":"https://www.coingecko.com/en/coins/zcash"}}

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