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:19:32.356738+00:00","dedupe_key":"signal_enriched:news_delta:d280a0c6fc40e8b9","evidence_event_ids":["evt_85019222f987"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiowFBVV95cUxPNzJhWk00d0ViRG9meWoxUkJWNVdQQkhnQnFpOXotaEVlZGZOUF9scVRYYzdiZ3BzRkRjU0NfQ2pWVllJMVlHT3NabWhhNUtKVWc5cWhPZllXeVhPZFVsNGEwUnZfQklHTE5yQW0ySEVEeFc5NW5PSlcwLWZDU1pSLWdhNFJRa21ZclFDaFFQR3BKMjJDa1FXTzdWLXlxRWtjVzBN?oc=5","as_of":"2026-04-10T08:19:32.356738+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/CBMiowFBVV95cUxPNzJhWk00d0ViRG9meWoxUkJWNVdQQkhnQnFpOXotaEVlZGZOUF9scVRYYzdiZ3BzRkRjU0NfQ2pWVllJMVlHT3NabWhhNUtKVWc5cWhPZllXeVhPZFVsNGEwUnZfQklHTE5yQW0ySEVEeFc5NW5PSlcwLWZDU1pSLWdhNFJRa21ZclFDaFFQR3BKMjJDa1FXTzdWLXlxRWtjVzBN?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ab2bb3d17eb0fede","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:20:35.635889+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiowFBVV95cUxPNzJhWk00d0ViRG9meWoxUkJWNVdQQkhnQnFpOXotaEVlZGZOUF9scVRYYzdiZ3BzRkRjU0NfQ2pWVllJMVlHT3NabWhhNUtKVWc5cWhPZllXeVhPZFVsNGEwUnZfQklHTE5yQW0ySEVEeFc5NW5PSlcwLWZDU1pSLWdhNFJRa21ZclFDaFFQR3BKMjJDa1FXTzdWLXlxRWtjVzBN?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"9to5mac.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiowFBVV95cUxPNzJhWk00d0ViRG9meWoxUkJWNVdQQkhnQnFpOXotaEVlZGZOUF9scVRYYzdiZ3BzRkRjU0NfQ2pWVllJMVlHT3NabWhhNUtKVWc5cWhPZllXeVhPZFVsNGEwUnZfQklHTE5yQW0ySEVEeFc5NW5PSlcwLWZDU1pSLWdhNFJRa21ZclFDaFFQR3BKMjJDa1FXTzdWLXlxRWtjVzBN?oc=5","source_event_id":"evt_85019222f987","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"cca2de99da921af3","published_at":"2026-04-09T23:42:00+00:00","publisher_domain":"9to5mac.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"government","name":"Federal Bureau of Investigation (FBI)","relevance":"direct actor","symbol":"","type":"government_agency"},{"asset_class":"software","name":"Signal","relevance":"targeted communication platform","symbol":"","type":"messaging_app"},{"asset_class":"consumer_device","name":"Apple iPhone / iOS notification database","relevance":"data source used for recovery","symbol":"","type":"device_system_component"},{"asset_class":"person","name":"Defendant / suspect (unnamed)","relevance":"person whose messages were recovered","symbol":"","type":"individual"}],"event_type":"conflict","information_gaps":["The article text provided is not actually present (only page styling/HTML fragments), so details beyond the headline and the provided source summary cannot be verified here.","The reporting does not specify the jurisdiction, case name, or timing of the FBI action.","It is unclear whether the iPhone notification data contained full message bodies, only previews, or metadata (the summaries imply message content but do not confirm specifics).","The exact technical method (e.g., which iOS database/table, whether via backup, physical extraction, or legal process) is not included in the provided text."],"key_facts":["9to5Mac reports that the FBI used iPhone notification data to retrieve deleted Signal messages.","Multiple referenced summaries indicate the recovered content came from an iPhone notification database/log rather than Signal app storage.","The recovered messages were described as \u201cdeleted\u201d or \u201cdisappearing,\u201d implying they were not present in the Signal app at the time of recovery (per the reporting)."],"numeric_claims":[],"primary_claim":"The FBI used iPhone notification data to retrieve deleted Signal messages from a defendant\u2019s iPhone.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"The FBI reportedly used iPhone notification data to recover deleted Signal messages from a suspect\u2019s device. This suggests that message \u201cdisappearing\u201d behavior may not fully prevent forensic recovery via iOS notification logs.","topics":["FBI investigation","Signal messaging","iPhone notifications","forensic data extraction","deleted/disappearing messages","privacy/security"]},"source":"9to5Mac","source_domain":"9to5mac.com","source_url":"https://9to5mac.com","summary":"FBI used iPhone notification data to retrieve deleted Signal messages 9to5Mac FBI Extracts Suspect\u2019s Deleted Signal Messages Saved in iPhone Notification Database 404 Media How the FBI Extracted Deleted Signal Messages From a Defendant's iPhone Lifehacker 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":"FBI used iPhone notification data to retrieve deleted Signal messages - 9to5Mac","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 14963 in events