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/CBMifkFVX3lxTFA4YUxQTUI1bEhBT3RRZVlPb3FlSFp1cEpxN1VqYzVHUGQ2eUJwUkNHYW9kLXJoRmRaY05qUDNfeGZ5Q3dRZDBwc3FKSXFhOTRrckpOZnB1emJQbEpzclVEQmhBVlNTZEF1TmZSQjhqMW9zcmM2N19MMFQ4MTRPZw?oc=5","as_of":"2026-04-07T02:56:08.017008+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/CBMifkFVX3lxTFA4YUxQTUI1bEhBT3RRZVlPb3FlSFp1cEpxN1VqYzVHUGQ2eUJwUkNHYW9kLXJoRmRaY05qUDNfeGZ5Q3dRZDBwc3FKSXFhOTRrckpOZnB1emJQbEpzclVEQmhBVlNTZEF1TmZSQjhqMW9zcmM2N19MMFQ4MTRPZw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_5bc5d13d4d04a266","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-07T16:22:51.722258+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTFA4YUxQTUI1bEhBT3RRZVlPb3FlSFp1cEpxN1VqYzVHUGQ2eUJwUkNHYW9kLXJoRmRaY05qUDNfeGZ5Q3dRZDBwc3FKSXFhOTRrckpOZnB1emJQbEpzclVEQmhBVlNTZEF1TmZSQjhqMW9zcmM2N19MMFQ4MTRPZw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"mashable.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTFA4YUxQTUI1bEhBT3RRZVlPb3FlSFp1cEpxN1VqYzVHUGQ2eUJwUkNHYW9kLXJoRmRaY05qUDNfeGZ5Q3dRZDBwc3FKSXFhOTRrckpOZnB1emJQbEpzclVEQmhBVlNTZEF1TmZSQjhqMW9zcmM2N19MMFQ4MTRPZw?oc=5","source_event_id":"evt_72108033e136","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9eca344139a4f701","published_at":"2026-04-06T20:11:25+00:00","publisher_domain":"mashable.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"none","name":"FBI","relevance":"high","symbol":"","type":"government agency"},{"asset_class":"software","name":"CapCut","relevance":"high","symbol":"","type":"app"}],"event_type":"regulation","information_gaps":["Specific apps other than CapCut not listed","Details on data theft mechanisms not provided"],"key_facts":["FBI warns against foreign mobile apps","Potential data theft risks","Applies to iPhone and Android users"],"numeric_claims":[],"primary_claim":"The FBI warns against downloading foreign mobile apps like CapCut due to data security concerns.","relevance_score":0.8,"sentiment":"negative","source_quality":"high","summary":"The FBI has issued a warning to users of iPhone and Android devices against downloading foreign mobile apps like CapCut due to potential risks of personal data theft.","topics":["data security","mobile apps","FBI warning"]},"source":"Mashable","source_domain":"mashable.com","source_url":"https://mashable.com","summary":"FBI warns against foreign mobile apps like CapCut in new PSA Mashable iPhone, Android get FBI warning: Don\u2019t download these apps AL.com FBI warns iPhone, Android users against installing certain apps \u2014 as personal data could be collected, stored overseas New York Post The FBI Is Warning Users About 'Foreign-Developed' Apps Lifehacker FBI warns millions of iPhone and Android users: These apps could steal your data SILive.com","title":"FBI warns against foreign mobile apps like CapCut in new PSA - Mashable","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_9c154e65259e in signals