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:c6cc0f55134e27f2","evidence_event_ids":["evt_ea20865daa1f"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/pepe","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://www.coingecko.com/en/coins/pepe","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/pepe","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ae5b00d7a7b97db5","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/pepe","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T01:00:53.223658+00:00","extraction_method":"heuristic","fetched_description":"Track the latest Pepe price, market cap, trading volume, news and more with CoinGecko's live PEPE/USD price chart and popular cryptocurrency price tracker.","fetched_title":"Pepe Price: PEPE/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/pepe","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/pepe","source_event_id":"evt_ea20865daa1f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"cafb25ff5b7f9060","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.72,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Pepe","relevance":"high","symbol":"PEPE","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["The provided text does not include the actual PEPE price, 24h change, or market cap value\u2014only the market cap rank and trend score are given.","The time window or definition of \u201ctrend score\u201d is not provided in the extracted text.","No additional context is provided about why PEPE is trending (e.g., volume, price movement, news)."],"key_facts":["Source indicates \u201cTrending: Pepe (PEPE)\u201d.","Source summary states \u201cMarket cap rank 52\u201d.","Source summary states \u201ctrend score 11\u201d.","Publisher domain is coingecko.com and source quality hint is high."],"numeric_claims":[{"label":"Market cap rank","value":"52"},{"label":"Trend score","value":"11"}],"primary_claim":"Pepe (PEPE) is listed as trending with market cap rank 52 and trend score 11.","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"CoinGecko\u2019s \u201cTrending\u201d section shows Pepe (PEPE) with a market-cap rank of 52 and a trend score of 11.","topics":["crypto","trending","Pepe","market cap rank","trend score"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 52, trend score 11","tickers":["PEPE","PEPEUSD"],"title":"Trending: Pepe (PEPE)","url":"https://www.coingecko.com/en/coins/pepe"}}

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