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-10T00:01:31.055484+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:d005c9a888ff38b8","evidence_event_ids":["evt_5174cb494dca"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/lab","as_of":"2026-04-10T00:01:31.055484+00:00","canonical_url":"https://www.coingecko.com/en/coins/lab","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/lab","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_fdc4a62628ffc423","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/lab","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T02:03:18.010200+00:00","extraction_method":"heuristic","fetched_description":"Track the latest LAB price, market cap, trading volume, news and more with CoinGecko's live LAB/USD price chart and popular cryptocurrency price tracker.","fetched_title":"LAB Price: LAB/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/lab","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/lab","source_event_id":"evt_5174cb494dca","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"bfb906aa872f7efa","kind":"crypto_extremes","published_at":"2026-04-10T00:01:39.347701+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"LAB","relevance":"high","symbol":"LAB","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["The extracted text does not provide LAB\u2019s current price, 24h change, volume, or market cap value\u2014only rank and trend score are stated.","The time window or definition of \u201ctrend score\u201d is not provided in the text.","The excerpt contains unrelated site-wide metrics (e.g., total market cap, BTC dominance) but does not tie them specifically to LAB."],"key_facts":["CoinGecko lists LAB (LAB) as trending.","Market cap rank for LAB is 611.","Trend score for LAB is 11."],"numeric_claims":[{"label":"market_cap_rank","value":"611"},{"label":"trend_score","value":"11"}],"primary_claim":"LAB (LAB) has a CoinGecko market cap rank of 611 and a trend score of 11.","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"CoinGecko shows LAB (LAB) as a trending cryptocurrency with market cap rank 611 and a trend score of 11. The provided page text does not include additional price-change or performance details for LAB.","topics":["crypto trending","CoinGecko","market cap rank","trend score"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 611, trend score 11","tickers":["LAB","LABUSD"],"title":"Trending: LAB (LAB)","url":"https://www.coingecko.com/en/coins/lab"}}

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