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/CBMikwFBVV95cUxOYlNuLXRTWUgtbVlkb3g3d1V6V3ppMW80dTI4T1d2V0NhU1FSVmlCM1EwWUNBTnV4eDBVdjhLaDBaTHY2MExESVZpNjhBdXlzS3VlWlIwZ3lvY1JhX0hMRmRpV290Rkh2eFJRajNENkFPN1pyemFCNXZ5T0JzVnJYc21YVHVGWkxabUZORTh3d3pLeFU?oc=5","as_of":"2026-04-10T18:06:52.207934+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/CBMikwFBVV95cUxOYlNuLXRTWUgtbVlkb3g3d1V6V3ppMW80dTI4T1d2V0NhU1FSVmlCM1EwWUNBTnV4eDBVdjhLaDBaTHY2MExESVZpNjhBdXlzS3VlWlIwZ3lvY1JhX0hMRmRpV290Rkh2eFJRajNENkFPN1pyemFCNXZ5T0JzVnJYc21YVHVGWkxabUZORTh3d3pLeFU?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_460041672a35f442","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-10T18:46:04.848302+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxOYlNuLXRTWUgtbVlkb3g3d1V6V3ppMW80dTI4T1d2V0NhU1FSVmlCM1EwWUNBTnV4eDBVdjhLaDBaTHY2MExESVZpNjhBdXlzS3VlWlIwZ3lvY1JhX0hMRmRpV290Rkh2eFJRajNENkFPN1pyemFCNXZ5T0JzVnJYc21YVHVGWkxabUZORTh3d3pLeFU?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/CBMikwFBVV95cUxOYlNuLXRTWUgtbVlkb3g3d1V6V3ppMW80dTI4T1d2V0NhU1FSVmlCM1EwWUNBTnV4eDBVdjhLaDBaTHY2MExESVZpNjhBdXlzS3VlWlIwZ3lvY1JhX0hMRmRpV290Rkh2eFJRajNENkFPN1pyemFCNXZ5T0JzVnJYc21YVHVGWkxabUZORTh3d3pLeFU?oc=5","source_event_id":"evt_6123214a1668","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7a2c713d61a29cb2","published_at":"2026-04-10T15:22:00+00:00","publisher_domain":"9to5mac.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.55,"dates_mentioned":["September"],"entities":[{"asset_class":"equity","name":"Apple","relevance":"high","symbol":"AAPL","type":"company"},{"asset_class":"consumer_electronics","name":"iPhone Fold","relevance":"high","symbol":"","type":"product"},{"asset_class":"consumer_electronics","name":"\u201cUltra\u201d product line/name","relevance":"medium","symbol":"","type":"product_naming"}],"event_type":"price_action","information_gaps":["The cleaned article text appears to contain only page styling/boilerplate, not the actual article content; therefore, specific leak details (e.g., exact model names, specs, or exact pricing) are not verifiable from the provided text.","The signal references multiple other outlets (Bloomberg.com, entrepreneur.com, Mashable, Geeky Gadgets), but their specific claims are not included verbatim here.","No concrete price figures, screen sizes, or feature lists are present in the provided content\u2014only high-level descriptions from the signal summary."],"key_facts":["9to5Mac headline indicates new iPhone Fold leaks cover the \u201cUltra\u201d name and launch timing.","The provided source summary includes Bloomberg.com reporting that Apple is launching an \u201cUltra\u201d line of products with new capabilities and higher price tags.","The provided source summary states Apple\u2019s foldable iPhone remains on track for a September debut (attributed to Bloomberg.com in the signal text)."],"numeric_claims":[],"primary_claim":"Leaks suggest Apple\u2019s foldable iPhone will be associated with an \u201cUltra\u201d name and could launch in September.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The signal reports new leak coverage about Apple\u2019s upcoming foldable iPhone, including the possible \u201cUltra\u201d product naming and a September launch timeline. It also references broader reporting that Apple may be launching an \u201cUltra\u201d line with higher prices.","topics":["iPhone Fold","foldable iPhone","product naming","\u201cUltra\u201d line","launch timing","September debut","pricing"]},"source":"9to5Mac","source_domain":"9to5mac.com","source_url":"https://9to5mac.com","summary":"New iPhone Fold leaks cover \u2018Ultra\u2019 name, launch timing, more 9to5Mac Apple\u2019s Foldable iPhone Remains on Track for September Debut (AAPL) Bloomberg.com Apple Is Launching an 'Ultra' Line of Products With New Capabilities \u2014 and Much Higher Price Tags entrepreneur.com New iPhone Fold leak reveals size versus iPhone 18 Pro Mashable Forget the iPhone 18: The iPhone Fold Leaks Reveal a 7.8-Inch Monster Geeky Gadgets","title":"New iPhone Fold leaks cover \u2018Ultra\u2019 name, launch timing, more - 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_4e5e32ac198d in signals