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-22T14:13:37.135360+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:9abd9e5db889eaea","evidence_event_ids":["evt_780f3fd0d56d"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://cryptoslate.com/will-apple-new-ceo-combat-fake-crypto-apps-littering-the-walled-garden-app-store/","as_of":"2026-04-22T14:13:37.135360+00:00","canonical_url":"https://cryptoslate.com/will-apple-new-ceo-combat-fake-crypto-apps-littering-the-walled-garden-app-store/","enrichment":{"aggregator_url":"https://cryptoslate.com/will-apple-new-ceo-combat-fake-crypto-apps-littering-the-walled-garden-app-store/","article_chars":335,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_4189a8213df68d6b","canonical_host":"cryptoslate.com","canonical_is_aggregator":false,"canonical_url":"https://cryptoslate.com/will-apple-new-ceo-combat-fake-crypto-apps-littering-the-walled-garden-app-store/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T14:17:14.279449+00:00","extraction_method":"trafilatura","fetched_description":"John Ternus built Apple\u2019s physical empire. Now, the incoming CEO must plug a multimillion-dollar crypto leak in the App Store.","fetched_title":"Will new Apple CEO combat fake crypto apps littering the \"walled garden\" App Store?","final_url":"https://cryptoslate.com/will-apple-new-ceo-combat-fake-crypto-apps-littering-the-walled-garden-app-store/","html_truncated":true,"paywall_likely":false,"publisher_domain":"cryptoslate.com","publisher_resolution":"canonical_url","requested_url":"https://cryptoslate.com/will-apple-new-ceo-combat-fake-crypto-apps-littering-the-walled-garden-app-store/","source_event_id":"evt_780f3fd0d56d","source_quality":"low","status_code":200,"version":"signal_enrichment_v2"},"fp":"bcb347c3b1bd2b22","kind":"crypto_extremes","published_at":"2026-04-22T13:26:57+00:00","publisher_domain":"cryptoslate.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.5,"dates_mentioned":["April 20"],"entities":[{"asset_class":"equity","name":"Apple","relevance":"high","symbol":"","type":"company"},{"asset_class":"person","name":"John Ternus","relevance":"high","symbol":"","type":"person"},{"asset_class":"person","name":"Tim Cook","relevance":"high","symbol":"","type":"person"},{"asset_class":"platform","name":"App Store","relevance":"medium","symbol":"","type":"platform"}],"event_type":"regulation","information_gaps":["No specific evidence, statistics, or examples of fake crypto apps are provided in the cleaned text.","The effective date/timing of the CEO succession is not included in the provided excerpt (only that it is \u201cby [\u2026]\u201d).","The excerpt does not specify what \u201cscrutiny\u201d entails or which parties are conducting it.","No details are provided on the nature, scale, or attribution of \u201ccrypto theft on iPhones.\u201d","The cleaned text does not include any direct quotes or concrete policy/security changes tied to the new CEO."],"key_facts":["Apple revealed on April 20 that John Ternus, senior vice president of hardware engineering, will succeed Tim Cook as chief executive officer.","The article links the leadership transition to scrutiny over App Store security and the rise of crypto theft on iPhones.","The headline poses a question about whether the new Apple CEO will combat fake crypto apps in the App Store (framed as a concern)."],"numeric_claims":[],"primary_claim":"Apple announced on April 20 that John Ternus will succeed Tim Cook as CEO.","relevance_score":0.55,"sentiment":"mixed","source_quality":"low","summary":"CryptoSlate frames Apple\u2019s upcoming CEO transition as occurring amid growing scrutiny of App Store security and reports of crypto theft/fake crypto apps on iPhones. The article states that John Ternus will succeed Tim Cook as CEO, effective after Apple\u2019s April 20 announcement.","topics":["Apple leadership transition","App Store security scrutiny","fake crypto apps","crypto theft on iPhones"]},"source":"CryptoSlate RSS","source_domain":"cryptoslate.com","summary":"Apple is heading into its biggest leadership transition in years, just as scrutiny is mounting over the security of its App Store and the rise of crypto theft on iPhones. On April 20, the company revealed that John Ternus, its senior vice president of hardware engineering, will succeed Tim Cook as chief executive officer by [\u2026] The post Will new Apple CEO combat fake crypto apps littering the \u201cwalled garden\u201d App Store? appeared first on CryptoSlate .","tickers":[],"title":"Will new Apple CEO combat fake crypto apps littering the \u201cwalled garden\u201d App Store?","url":"https://cryptoslate.com/will-apple-new-ceo-combat-fake-crypto-apps-littering-the-walled-garden-app-store/"}}

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