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:a6e74f87b9aae89c","evidence_event_ids":["evt_98bf6f718918"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/edgex","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://www.coingecko.com/en/coins/edgex","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/edgex","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b609c27e2092e97f","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/edgex","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T01:00:50.252471+00:00","extraction_method":"heuristic","fetched_description":"Track the latest edgeX price, market cap, trading volume, news and more with CoinGecko's live EDGE/USD price chart and popular cryptocurrency price tracker.","fetched_title":"edgeX Price: EDGE/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/edgex","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/edgex","source_event_id":"evt_98bf6f718918","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"8635ec61d1fa07a9","kind":"crypto_extremes","published_at":"2026-04-07T23:23:59.708482+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"edgeX","relevance":"high","symbol":"EDGE","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["The provided text does not include edgeX\u2019s price, 24h change, market cap value, or volume\u2014only the market cap rank and trend score are given.","The excerpt does not specify the time window or methodology behind the \u201ctrend score.\u201d","The excerpt does not provide any news or catalyst details beyond the trending metrics."],"key_facts":["CoinGecko \u201cTrending\u201d includes edgeX (EDGE).","edgeX (EDGE) market cap rank is 113.","edgeX (EDGE) trend score is 10."],"numeric_claims":[{"label":"market_cap_rank","value":"113"},{"label":"trend_score","value":"10"}],"primary_claim":"edgeX (EDGE) is trending on CoinGecko with market cap rank 113 and trend score 10.","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"CoinGecko\u2019s \u201cTrending\u201d section lists edgeX (EDGE) with a market cap rank of 113 and a trend score of 10.","topics":["crypto trending","CoinGecko","market cap rank","trend score"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 113, trend score 10","tickers":["EDGE","EDGEUSD"],"title":"Trending: edgeX (EDGE)","url":"https://www.coingecko.com/en/coins/edgex"}}

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