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-12T10:44:59.953808+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:e6d07606d8ed2652","evidence_event_ids":["evt_0f57834b233b"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.bitcoin.com/philadelphia-musician-g-love-loses-nearly-6-btc-to-fake-ledger-wallet-app-on-apples-app-store/","as_of":"2026-04-12T10:44:59.953808+00:00","canonical_url":"https://news.bitcoin.com/philadelphia-musician-g-love-loses-nearly-6-btc-to-fake-ledger-wallet-app-on-apples-app-store/","enrichment":{"aggregator_url":"https://news.bitcoin.com/philadelphia-musician-g-love-loses-nearly-6-btc-to-fake-ledger-wallet-app-on-apples-app-store/","article_chars":3643,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_f35c7d48cce3f9bd","canonical_host":"news.bitcoin.com","canonical_is_aggregator":false,"canonical_url":"https://news.bitcoin.com/philadelphia-musician-g-love-loses-nearly-6-btc-to-fake-ledger-wallet-app-on-apples-app-store/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-12T10:49:11.530505+00:00","extraction_method":"trafilatura","fetched_description":"Musician G. Love lost 5.92 BTC to a fake Ledger app on the Apple App Store. ZachXBT traced funds to Kucoin.","fetched_title":"Philadelphia Musician G. Love Loses Nearly 6 BTC to Fake Ledger Wallet App on Apple's App Store \u2013 Crypto News Bitcoin News","final_url":"https://news.bitcoin.com/philadelphia-musician-g-love-loses-nearly-6-btc-to-fake-ledger-wallet-app-on-apples-app-store/","html_truncated":true,"paywall_likely":false,"publisher_domain":"news.bitcoin.com","publisher_resolution":"canonical_url","requested_url":"https://news.bitcoin.com/philadelphia-musician-g-love-loses-nearly-6-btc-to-fake-ledger-wallet-app-on-apples-app-store/","source_event_id":"evt_0f57834b233b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"fe00525c0e76d8bd","kind":"crypto_extremes","published_at":"2026-04-12T10:31:23+00:00","publisher_domain":"news.bitcoin.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["2026-04-11","2025"],"entities":[{"asset_class":"crypto","name":"G. Love (Garrett Dutton)","relevance":"primary victim and source of disclosure","symbol":"","type":"person"},{"asset_class":"other","name":"Ledger","relevance":"hardware wallet/software provider issuing warnings about app stores","symbol":"","type":"company"},{"asset_class":"other","name":"ZachXBT","relevance":"onchain investigator who traced stolen funds","symbol":"","type":"person"},{"asset_class":"crypto_exchange","name":"Kucoin","relevance":"deposit addresses reportedly used to launder stolen funds","symbol":"","type":"exchange"},{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"stolen asset","symbol":"BTC","type":"asset"}],"event_type":"supply_disruption","information_gaps":["The article does not provide the exact transaction hash/address details in the cleaned text (it says Dutton posted them on X).","The article does not specify the exact Apple platform wording (it mentions \u201cApple App Store\u201d and \u201cApple Mac App Store\u201d); the precise store listing details are not included.","The article states funds were \u201creportedly laundered\u201d into Kucoin deposit addresses; it does not provide evidence of final destination beyond the Kucoin deposit addresses.","The article does not state the exact timing between seed phrase entry and the draining transaction beyond \u201cimmediately.\u201d","The article does not provide the exact amount of \u201cnearly 5.9 BTC\u201d beyond the stated 5.92 BTC figure."],"key_facts":["G. Love (Garrett Dutton) disclosed losing nearly 6 BTC after downloading a fraudulent Ledger app from Apple\u2019s App Store on April 11, 2026.","The article states the stolen amount was 5.92 BTC and that it was his entire retirement savings held for roughly a decade (as characterized in the text).","The fake app prompted Dutton to enter his 24-word seed phrase (secret recovery phrase).","After he entered the seed phrase, the attackers drained his bitcoin holdings immediately (per the article\u2019s description of his account).","The article says the stolen funds were worth $424,175 at press time.","ZachXBT confirmed approximately 5.92 BTC was stolen and allegedly laundered across nine transactions into Kucoin deposit addresses.","Ledger warned users to download software only from ledger.com and stated it is not present in consumer app stores; apps under different developer names are fraudulent.","The article notes public reaction on X included skepticism about plausibility and that some users raised questions about Ledger hardware wallet physical confirmation requirements.","The article says Dutton clarified he was socially engineered into entering the seed phrase voluntarily and that the attack vector exploited that behavior.","The article states the incident follows a documented pattern targeting macOS users, referencing Moonlock\u2019s 2025 report about malware replacing legitimate Ledger Live installations on macOS and prompting seed phrase entry."],"numeric_claims":[{"label":"BTC stolen","value":"5.92 BTC"},{"label":"BTC described as nearly 6","value":"~6 BTC"},{"label":"seed phrase length","value":"24 words"},{"label":"transactions to Kucoin deposit addresses","value":"9"},{"label":"stolen stash value at press time","value":"$424,175"},{"label":"date of app download","value":"2026-04-11"}],"primary_claim":"Musician G. Love lost approximately 5.92 BTC to a fake Ledger wallet app downloaded from Apple\u2019s App Store on April 11, 2026 after entering his 24-word seed phrase.","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"G. Love (Garrett Dutton) reported losing about 5.92 BTC after installing a fraudulent \u201cLedger\u201d wallet app from Apple\u2019s App Store on April 11, 2026 and entering his 24-word seed phrase, which attackers then used to drain his bitcoin holdings. Onchain investigator ZachXBT traced the theft to Kucoin deposit addresses, and Ledger reiterated that its software is only available via ledger.com.","topics":["crypto scam","fake Ledger app","seed phrase theft","Apple App Store","onchain tracing","Kucoin deposit addresses","macOS attack pattern"]},"source":"Bitcoin.com News","source_domain":"news.bitcoin.com","summary":"Musician G. Love lost nearly 5.9 BTC, his entire retirement savings held for roughly a decade, after downloading a fraudulent Ledger app from the Apple App Store on April 11, 2026. Key Takeaways: Musician G. Love lost 5.92 BTC to a fake Ledger app on the Apple Mac App Store on April 11, 2026. The [\u2026]","tickers":[],"title":"Philadelphia Musician G. Love Loses Nearly 6 BTC to Fake Ledger Wallet App on Apple\u2019s App Store","url":"https://news.bitcoin.com/philadelphia-musician-g-love-loses-nearly-6-btc-to-fake-ledger-wallet-app-on-apples-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 28824 in events