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/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

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_93413eeb3f60 in signals