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-10T08:34:39.934773+00:00","dedupe_key":"signal_enriched:news_delta:5c64b53d80962fae","evidence_event_ids":["evt_0db6ee238463"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxQeGF1d0ZJdF9kYkZEYzVZYmx1YzNwRkpMdEhybEgydVVwRVJkT1FPU04xMG40Ny1qQVBWOUVXQnBwUTZaMU95R2FlSTdRVGdrR2NfWU5VdERId1p5b0pKVzhyZXZSLUZSMnVhWmVaX29ydzIzS09Xa0dCdEJKVC04aVBCcktYajRFX3VlYmFGcG1QX0ct?oc=5","as_of":"2026-04-10T08:34:39.934773+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxQeGF1d0ZJdF9kYkZEYzVZYmx1YzNwRkpMdEhybEgydVVwRVJkT1FPU04xMG40Ny1qQVBWOUVXQnBwUTZaMU95R2FlSTdRVGdrR2NfWU5VdERId1p5b0pKVzhyZXZSLUZSMnVhWmVaX29ydzIzS09Xa0dCdEJKVC04aVBCcktYajRFX3VlYmFGcG1QX0ct?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_69bf3be99065d212","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T08:35:34.597420+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxQeGF1d0ZJdF9kYkZEYzVZYmx1YzNwRkpMdEhybEgydVVwRVJkT1FPU04xMG40Ny1qQVBWOUVXQnBwUTZaMU95R2FlSTdRVGdrR2NfWU5VdERId1p5b0pKVzhyZXZSLUZSMnVhWmVaX29ydzIzS09Xa0dCdEJKVC04aVBCcktYajRFX3VlYmFGcG1QX0ct?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"lifehacker.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxQeGF1d0ZJdF9kYkZEYzVZYmx1YzNwRkpMdEhybEgydVVwRVJkT1FPU04xMG40Ny1qQVBWOUVXQnBwUTZaMU95R2FlSTdRVGdrR2NfWU5VdERId1p5b0pKVzhyZXZSLUZSMnVhWmVaX29ydzIzS09Xa0dCdEJKVC04aVBCcktYajRFX3VlYmFGcG1QX0ct?oc=5","source_event_id":"evt_0db6ee238463","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2108b64081f122e9","published_at":"2026-04-09T19:00:00+00:00","publisher_domain":"lifehacker.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.66,"dates_mentioned":[],"entities":[{"asset_class":"government","name":"Federal Bureau of Investigation (FBI)","relevance":"primary actor","symbol":"","type":"government_agency"},{"asset_class":"software","name":"Signal","relevance":"targeted communication platform","symbol":"","type":"messaging_app"},{"asset_class":"consumer_electronics","name":"iPhone (Apple)","relevance":"device from which data was extracted","symbol":"","type":"device"},{"asset_class":"person","name":"Defendant (unnamed)","relevance":"subject of the extraction","symbol":"","type":"individual"}],"event_type":"other","information_gaps":["The defendant\u2019s identity, case name, jurisdiction, and timeline are not provided in the supplied text.","The exact technical mechanism (which iPhone database/log fields, how they map to Signal message content) is not detailed in the provided excerpt.","Whether this is a confirmed court finding, a specific warrant-based extraction, or a general technique described in reporting is not specified here.","The extent of message recovery (how many messages, whether attachments/metadata were included) is not stated."],"key_facts":["The FBI recovered deleted Signal messages/chats from a defendant\u2019s iPhone.","The recovery method reportedly used iPhone notification data/logs (e.g., a notification database) to retrieve content that was no longer present in the Signal app.","The reports describe the chats as \u201cdisappearing,\u201d implying they were deleted/removed from the app but still recoverable via iPhone-stored notification artifacts."],"numeric_claims":[],"primary_claim":"The FBI extracted deleted Signal chats/messages from an iPhone by pulling them from the phone\u2019s notification database/logs.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"Multiple outlets report that the FBI was able to recover deleted Signal messages from a defendant\u2019s iPhone by using iPhone notification data/logs rather than relying on the Signal app itself.","topics":["digital forensics","Signal messaging","iPhone notification database","deleted messages recovery","law enforcement evidence extraction"]},"source":"Lifehacker","source_domain":"lifehacker.com","source_url":"https://lifehacker.com","summary":"How the FBI Extracted Deleted Signal Messages From a Defendant's iPhone Lifehacker FBI Extracts Suspect\u2019s Deleted Signal Messages Saved in iPhone Notification Database 404 Media FBI used iPhone notification data to retrieve deleted Signal messages 9to5Mac The FBI Just Recovered \u201cDisappearing\u201d Signal Chats From a Phone That No Longer Had the App Gadget Review FBI extracted Signal chats from an iPhone's notifications log Risky Business Newsletters","title":"How the FBI Extracted Deleted Signal Messages From a Defendant's iPhone - Lifehacker","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp"}}

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