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/CBMirAFBVV95cUxONHhNWmtNdXZPVFFFV0ZMSGNEWjA3Vk1aUUw4YWRKWG9qVWhPZVhHXzBPLTI5SFNtdGdlRkJCQXU5b292TEROaXJ0b1RpVEZRWmVXaFZ0Um00dUNIWkJteVB4cTd1bkxHT0tZMWNfQk93OWxXb1ZOUWZ2cFhmUVJza1ZyV19hdUo5YkpQZUtLTzhRVXFXMnZDT2UwVmVwRVJUdjM5N25uMW9vQV9s0gGyAUFVX3lxTFB1SlNZQjgxVzVBRGoyRlhoZVdsUjNaN044RzJkNWhpNWFlMjBXNkYxYWdwalRPdGtoMkFxOTZfaHdYM0J3WEhKT1lPQl9GQTJITkUzU2RqV255SzZTNWwtbXZMV2h1Y2pCT082QVd5Wko0c0QzODR1elduUXFTaFBSUE1CU2NGakJ2SjBSSDZwRzVyN1lmX2h4SF9ZQUtWRWx1T1l0UWdpUWJnNjRMOFR4RWc?oc=5","as_of":"2026-04-10T15:28:44.293940+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/CBMirAFBVV95cUxONHhNWmtNdXZPVFFFV0ZMSGNEWjA3Vk1aUUw4YWRKWG9qVWhPZVhHXzBPLTI5SFNtdGdlRkJCQXU5b292TEROaXJ0b1RpVEZRWmVXaFZ0Um00dUNIWkJteVB4cTd1bkxHT0tZMWNfQk93OWxXb1ZOUWZ2cFhmUVJza1ZyV19hdUo5YkpQZUtLTzhRVXFXMnZDT2UwVmVwRVJUdjM5N25uMW9vQV9s0gGyAUFVX3lxTFB1SlNZQjgxVzVBRGoyRlhoZVdsUjNaN044RzJkNWhpNWFlMjBXNkYxYWdwalRPdGtoMkFxOTZfaHdYM0J3WEhKT1lPQl9GQTJITkUzU2RqV255SzZTNWwtbXZMV2h1Y2pCT082QVd5Wko0c0QzODR1elduUXFTaFBSUE1CU2NGakJ2SjBSSDZwRzVyN1lmX2h4SF9ZQUtWRWx1T1l0UWdpUWJnNjRMOFR4RWc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6fda243aa030c997","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-10T16:59:51.498549+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxONHhNWmtNdXZPVFFFV0ZMSGNEWjA3Vk1aUUw4YWRKWG9qVWhPZVhHXzBPLTI5SFNtdGdlRkJCQXU5b292TEROaXJ0b1RpVEZRWmVXaFZ0Um00dUNIWkJteVB4cTd1bkxHT0tZMWNfQk93OWxXb1ZOUWZ2cFhmUVJza1ZyV19hdUo5YkpQZUtLTzhRVXFXMnZDT2UwVmVwRVJUdjM5N25uMW9vQV9s0gGyAUFVX3lxTFB1SlNZQjgxVzVBRGoyRlhoZVdsUjNaN044RzJkNWhpNWFlMjBXNkYxYWdwalRPdGtoMkFxOTZfaHdYM0J3WEhKT1lPQl9GQTJITkUzU2RqV255SzZTNWwtbXZMV2h1Y2pCT082QVd5Wko0c0QzODR1elduUXFTaFBSUE1CU2NGakJ2SjBSSDZwRzVyN1lmX2h4SF9ZQUtWRWx1T1l0UWdpUWJnNjRMOFR4RWc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bleepingcomputer.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxONHhNWmtNdXZPVFFFV0ZMSGNEWjA3Vk1aUUw4YWRKWG9qVWhPZVhHXzBPLTI5SFNtdGdlRkJCQXU5b292TEROaXJ0b1RpVEZRWmVXaFZ0Um00dUNIWkJteVB4cTd1bkxHT0tZMWNfQk93OWxXb1ZOUWZ2cFhmUVJza1ZyV19hdUo5YkpQZUtLTzhRVXFXMnZDT2UwVmVwRVJUdjM5N25uMW9vQV9s0gGyAUFVX3lxTFB1SlNZQjgxVzVBRGoyRlhoZVdsUjNaN044RzJkNWhpNWFlMjBXNkYxYWdwalRPdGtoMkFxOTZfaHdYM0J3WEhKT1lPQl9GQTJITkUzU2RqV255SzZTNWwtbXZMV2h1Y2pCT082QVd5Wko0c0QzODR1elduUXFTaFBSUE1CU2NGakJ2SjBSSDZwRzVyN1lmX2h4SF9ZQUtWRWx1T1l0UWdpUWJnNjRMOFR4RWc?oc=5","source_event_id":"evt_6e0dce500b85","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"879acac9a44e9ba2","published_at":"2026-04-10T10:44:08+00:00","publisher_domain":"bleepingcomputer.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["about a year after its web launch (exact date not provided in supplied text)"],"entities":[{"asset_class":"equity","name":"Google","relevance":"high","symbol":"","type":"company"},{"asset_class":"software","name":"Gmail","relevance":"high","symbol":"","type":"product"},{"asset_class":"platform","name":"Android","relevance":"medium","symbol":"","type":"platform"},{"asset_class":"platform","name":"iOS","relevance":"medium","symbol":"","type":"platform"},{"asset_class":"media","name":"BleepingComputer","relevance":"low","symbol":"","type":"publisher"}],"event_type":"regulation","information_gaps":["The specific nature of the \u201ccatch\u201d/what users or message types are excluded is not present in the provided text.","The rollout timing details (exact release date, phased availability, or eligibility criteria) are not included in the supplied content.","No technical specifics are provided here (e.g., key management, backward compatibility, or whether attachments are included).","The supplied article text appears to be mostly HTML/CSS and does not contain the substantive content needed to verify details beyond the headline/summary."],"key_facts":["The headline reports that Google is rolling out Gmail end-to-end encryption on mobile devices.","The source summary indicates the E2EE rollout applies to both Android and iOS.","Multiple referenced summaries state there is a limitation described as a \u201ccatch,\u201d and that it is \u201cnot for everyone.\u201d","The source summary also states this mobile E2EE comes about a year after Gmail\u2019s web E2EE launch."],"numeric_claims":[],"primary_claim":"Google is adding Gmail end-to-end encryption on mobile devices (Android and iOS).","relevance_score":0.72,"sentiment":"positive","source_quality":"high","summary":"Google is rolling out end-to-end encryption (E2EE) for Gmail on mobile devices (Android and iOS). The rollout includes a limitation (\u201cwith a catch\u201d), implying not all messages/users may be covered.","topics":["end-to-end encryption","Gmail","mobile security","Android","iOS","privacy"]},"source":"BleepingComputer","source_domain":"bleepingcomputer.com","source_url":"https://www.bleepingcomputer.com","summary":"Google rolls out Gmail end-to-end encryption on mobile devices BleepingComputer Google Confirms New E2EE Android And iOS Gmail Encryption\u2014With A Catch Forbes Gmail finally offers end-to-end encryption for email on Android and iPhone How-To Geek Gmail\u2019s end-to-end encryption comes to mobile, a year after its web launch The Next Web Gmail gets end-to-end encryption on Android and iPhones but it is not for everyone The Times of India","title":"Google rolls out Gmail end-to-end encryption on mobile devices - BleepingComputer","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_9f925135abe4 in signals