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-08T19:57:42.365437+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:43619d913b51690f","evidence_event_ids":["evt_5bb30fe34e5c"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.coingecko.com/en/coins/pudgy-penguins","as_of":"2026-04-08T19:57:42.365437+00:00","canonical_url":"https://www.coingecko.com/en/coins/pudgy-penguins","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/pudgy-penguins","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f787b97406a60ca5","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/pudgy-penguins","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T23:02:08.508406+00:00","extraction_method":"heuristic","fetched_description":"Track the latest Pudgy Penguins price, market cap, trading volume, news and more with CoinGecko's live PENGU/USD price chart and popular cryptocurrency price tracker.","fetched_title":"Pudgy Penguins Price: PENGU/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/pudgy-penguins","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/pudgy-penguins","source_event_id":"evt_5bb30fe34e5c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5fde63558dd3bfc3","kind":"crypto_extremes","published_at":"2026-04-08T19:57:58.888098+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Pudgy Penguins","relevance":"primary","symbol":"PENGU","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["No PENGU live price value is shown in the provided cleaned text.","No PENGU 24h change, volume, or market cap figures specific to PENGU are present in the provided text.","The cleaned text includes global CoinGecko market stats (e.g., total market cap, BTC dominance), but these are not explicitly tied to PENGU.","The \u201carticle\u201d content appears to be mostly page chrome/navigation; PENGU-specific chart/news details are not included in the provided excerpt."],"key_facts":["Headline indicates \u201cTrending: Pudgy Penguins (PENGU)\u201d.","Source summary states market cap rank is 106.","Source summary states trend score is 2.","Article text provided is largely CoinGecko site navigation and global market stats; no additional PENGU-specific numeric metrics are visible in the cleaned text."],"numeric_claims":[{"label":"market_cap_rank","value":"106"},{"label":"trend_score","value":"2"}],"primary_claim":"Pudgy Penguins (PENGU) has CoinGecko market cap rank 106 and a trend score of 2 in the \u201cTrending\u201d section.","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"CoinGecko is showing Pudgy Penguins (PENGU) as a trending crypto asset with market cap rank 106 and a trend score of 2. The provided page text does not include additional PENGU-specific price or performance metrics beyond these ranking/trend indicators.","topics":["crypto trending","market cap rank","trend score"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 106, trend score 2","tickers":["PENGU","PENGUUSD"],"title":"Trending: Pudgy Penguins (PENGU)","url":"https://www.coingecko.com/en/coins/pudgy-penguins"}}

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