SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_756776702c50 in signals