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/CBMingFBVV95cUxOUjJlWS1iMENHbHFqRlM1RHhuTnNlR1hkRDdHR1ZvX3FtLTc2YnR2MmNMaGxWS3NlbzNGNzc3TlRmMFpsNXFEN0F2TVVoXzZPQ3RGMWtTSnBUS25uaEZ2U2VIYjgwaUh2cWF3Tkp6TUdQTjJ2X0tIekJCcTVmNE5vcXJFeGUwQnBrMk5kOVJRSlo3S0FSck80dm5DeE1SUQ?oc=5","as_of":"2026-04-15T11:10:55.600043+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMingFBVV95cUxOUjJlWS1iMENHbHFqRlM1RHhuTnNlR1hkRDdHR1ZvX3FtLTc2YnR2MmNMaGxWS3NlbzNGNzc3TlRmMFpsNXFEN0F2TVVoXzZPQ3RGMWtTSnBUS25uaEZ2U2VIYjgwaUh2cWF3Tkp6TUdQTjJ2X0tIekJCcTVmNE5vcXJFeGUwQnBrMk5kOVJRSlo3S0FSck80dm5DeE1SUQ?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_4061436ba217c165","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-15T22:01:09.153250+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMingFBVV95cUxOUjJlWS1iMENHbHFqRlM1RHhuTnNlR1hkRDdHR1ZvX3FtLTc2YnR2MmNMaGxWS3NlbzNGNzc3TlRmMFpsNXFEN0F2TVVoXzZPQ3RGMWtTSnBUS25uaEZ2U2VIYjgwaUh2cWF3Tkp6TUdQTjJ2X0tIekJCcTVmNE5vcXJFeGUwQnBrMk5kOVJRSlo3S0FSck80dm5DeE1SUQ?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/CBMingFBVV95cUxOUjJlWS1iMENHbHFqRlM1RHhuTnNlR1hkRDdHR1ZvX3FtLTc2YnR2MmNMaGxWS3NlbzNGNzc3TlRmMFpsNXFEN0F2TVVoXzZPQ3RGMWtTSnBUS25uaEZ2U2VIYjgwaUh2cWF3Tkp6TUdQTjJ2X0tIekJCcTVmNE5vcXJFeGUwQnBrMk5kOVJRSlo3S0FSck80dm5DeE1SUQ?oc=5","source_event_id":"evt_1a5331c2d4b4","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"a64417ae30548da9","published_at":"2026-04-14T18:32:00+00:00","publisher_domain":"9to5mac.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.42,"dates_mentioned":[],"entities":[],"event_type":"other","information_gaps":["article_text_unavailable"],"key_facts":["Headline: This fall\u2019s iPhone 18 launch lineup has one big wildcard remaining - 9to5Mac","Source summary: This fall\u2019s iPhone 18 launch lineup has one big wildcard remaining 9to5Mac Apple iPhone 18 Pro Latest Leak Signals Significant Design Change Forbes iPhone 18 Pro Deep Red Color Likely as Android Rivals Prep Same Shade MacRumors iPhone 18 Pro Max Rumors: 2nm A20 Chip, Variable Aperture Camera and Record Battery International Business Times Australia Apple To Observe A Price Freeze On iPhone 18 Pro To Gain Massive Edge"],"numeric_claims":[],"primary_claim":"This fall\u2019s iPhone 18 launch lineup has one big wildcard remaining - 9to5Mac","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"This fall\u2019s iPhone 18 launch lineup has one big wildcard remaining 9to5Mac Apple iPhone 18 Pro Latest Leak Signals Significant Design Change Forbes iPhone 18 Pro Deep Red Color Likely as Android Rivals Prep Same Shade MacRumors iPhone 18 Pro Max Rumors: 2nm A20 Chip, Variable Aperture Camera and Record Battery International Business Times Australia Apple To Observe A Price Freeze On iPhone 18 Pro ","topics":["news headline"]},"source":"9to5Mac","source_domain":"9to5mac.com","source_url":"https://9to5mac.com","summary":"This fall\u2019s iPhone 18 launch lineup has one big wildcard remaining 9to5Mac Apple iPhone 18 Pro Latest Leak Signals Significant Design Change Forbes iPhone 18 Pro Deep Red Color Likely as Android Rivals Prep Same Shade MacRumors iPhone 18 Pro Max Rumors: 2nm A20 Chip, Variable Aperture Camera and Record Battery International Business Times Australia Apple To Observe A Price Freeze On iPhone 18 Pro To Gain Massive Edge Over Rivals, But At The Expense Of Offering Fewer Options To Buyers Wccftech","title":"This fall\u2019s iPhone 18 launch lineup has one big wildcard remaining - 9to5Mac","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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_181d3f9d7e58 in signals