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/CBMitwFBVV95cUxOeWVqWmd6cjZqQ1lsenE5Zk1uVXMwcVFxRVd3bzlxMGtPdE5ldDliY0xMMnNYS0k5Qmw5VEdkMkVRcU00b3VRb2RyS2pqYUI4dXkxYWVNd3J5UHhnSDVlMXdENU1qQUJqWUZTNVlYdlJCNEpwOThMQTZwTTZkYk8wMG1QZ1lwSGFzV04zXzdvWFBpRmVENTRtTHI0Z2ZFOWhUMnVLdmNNd1didEJucWRBUmozdlozc2s?oc=5","as_of":"2026-04-09T09:54:21.946013+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/CBMitwFBVV95cUxOeWVqWmd6cjZqQ1lsenE5Zk1uVXMwcVFxRVd3bzlxMGtPdE5ldDliY0xMMnNYS0k5Qmw5VEdkMkVRcU00b3VRb2RyS2pqYUI4dXkxYWVNd3J5UHhnSDVlMXdENU1qQUJqWUZTNVlYdlJCNEpwOThMQTZwTTZkYk8wMG1QZ1lwSGFzV04zXzdvWFBpRmVENTRtTHI0Z2ZFOWhUMnVLdmNNd1didEJucWRBUmozdlozc2s?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0257490876e52201","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-09T23:04:09.446816+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMitwFBVV95cUxOeWVqWmd6cjZqQ1lsenE5Zk1uVXMwcVFxRVd3bzlxMGtPdE5ldDliY0xMMnNYS0k5Qmw5VEdkMkVRcU00b3VRb2RyS2pqYUI4dXkxYWVNd3J5UHhnSDVlMXdENU1qQUJqWUZTNVlYdlJCNEpwOThMQTZwTTZkYk8wMG1QZ1lwSGFzV04zXzdvWFBpRmVENTRtTHI0Z2ZFOWhUMnVLdmNNd1didEJucWRBUmozdlozc2s?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/CBMitwFBVV95cUxOeWVqWmd6cjZqQ1lsenE5Zk1uVXMwcVFxRVd3bzlxMGtPdE5ldDliY0xMMnNYS0k5Qmw5VEdkMkVRcU00b3VRb2RyS2pqYUI4dXkxYWVNd3J5UHhnSDVlMXdENU1qQUJqWUZTNVlYdlJCNEpwOThMQTZwTTZkYk8wMG1QZ1lwSGFzV04zXzdvWFBpRmVENTRtTHI0Z2ZFOWhUMnVLdmNNd1didEJucWRBUmozdlozc2s?oc=5","source_event_id":"evt_dd8546ef619d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5762cacc177be45a","published_at":"2026-04-08T23:11:00+00:00","publisher_domain":"9to5mac.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":["iOS 26.4.1"],"entities":[{"asset_class":"software","name":"Apple iOS","relevance":"high","symbol":"iOS","type":"software_platform"},{"asset_class":"security_feature","name":"Stolen Device Protection","relevance":"high","symbol":"Stolen Device Protection","type":"security_feature"},{"asset_class":"devices","name":"Enterprise devices","relevance":"high","symbol":"enterprise","type":"device_segment"}],"event_type":"regulation","information_gaps":["Whether this applies to all enterprise devices or only specific enrollment/MDM configurations is not stated in the provided text.","No details are provided on behavioral changes (e.g., user prompts, recovery flow, or compatibility impacts).","The exact rollout timing (immediate vs phased) and any required admin/MDM settings are not specified.","The provided article text appears to be non-informative HTML/CSS rather than the actual article content, so details beyond the headline are uncertain."],"key_facts":["The change is reported for iOS 26.4.1.","\u201cStolen Device Protection\u201d is enabled by default for enterprise devices.","The signal references 9to5Mac as the source for the headline delta."],"numeric_claims":[],"primary_claim":"In iOS 26.4.1, Stolen Device Protection is enabled by default for enterprise devices.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"Apple\u2019s iOS 26.4.1 update enables \u201cStolen Device Protection\u201d by default for enterprise devices. This is a security hardening change that should take effect immediately for organizations deploying iOS 26.4.1.","topics":["iOS 26.4.1","enterprise device security","Stolen Device Protection","mobile security","Apple update"]},"source":"9to5Mac","source_domain":"9to5mac.com","source_url":"https://9to5mac.com","summary":"Stolen Device Protection now enabled by default for enterprise devices in iOS 26.4.1 9to5Mac iOS 26.4.1 Isn't a Big Update, but Download It Anyway CNET iOS 26.4.1 Includes These Two Changes for iPhones MacRumors iOS and iPadOS 26.4.1 is out to fix iCloud syncing bug Macworld iOS 26.4.1 Released: Apple\u2019s New iPhone Update Is An Unexpected, Urgent Bug Fix Forbes","title":"Stolen Device Protection now enabled by default for enterprise devices in iOS 26.4.1 - 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_18e1f4b21aba in signals