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/CBMifkFVX3lxTE1UdnZPd1FKMlZFNmxHTmMyS21rMmFiVW5JWjF5MmZibDVKRkdkVkg4bU5DdWNBQ3pWazRNaldOUjU5MWR5RkdvVFgzdkdiQmkwUks4NDN2c3MwSG1KUkxfYklrQVkxRXUtanBOS3EyOG9YNjB3TTdGRkNDanNJdw?oc=5","as_of":"2026-04-08T07:21:41.267091+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/CBMifkFVX3lxTE1UdnZPd1FKMlZFNmxHTmMyS21rMmFiVW5JWjF5MmZibDVKRkdkVkg4bU5DdWNBQ3pWazRNaldOUjU5MWR5RkdvVFgzdkdiQmkwUks4NDN2c3MwSG1KUkxfYklrQVkxRXUtanBOS3EyOG9YNjB3TTdGRkNDanNJdw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_cf056bd8921291d0","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-08T07:22:10.425931+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTE1UdnZPd1FKMlZFNmxHTmMyS21rMmFiVW5JWjF5MmZibDVKRkdkVkg4bU5DdWNBQ3pWazRNaldOUjU5MWR5RkdvVFgzdkdiQmkwUks4NDN2c3MwSG1KUkxfYklrQVkxRXUtanBOS3EyOG9YNjB3TTdGRkNDanNJdw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theverge.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTE1UdnZPd1FKMlZFNmxHTmMyS21rMmFiVW5JWjF5MmZibDVKRkdkVkg4bU5DdWNBQ3pWazRNaldOUjU5MWR5RkdvVFgzdkdiQmkwUks4NDN2c3MwSG1KUkxfYklrQVkxRXUtanBOS3EyOG9YNjB3TTdGRkNDanNJdw?oc=5","source_event_id":"evt_743195af7c2d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"db178642c578eb34","published_at":"2026-04-07T15:39:30+00:00","publisher_domain":"theverge.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"consumer_electronics","name":"Apple MacBook Air (new)","relevance":"high","symbol":"","type":"product"},{"asset_class":"consumer_electronics","name":"Apple MacBook Air (last year\u2019s model)","relevance":"high","symbol":"","type":"product"},{"asset_class":"media","name":"The Verge","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"price_action","information_gaps":["The exact final sale price (e.g., $999 to $849) is not present in the provided excerpt.","Which specific MacBook Air configuration/model year (e.g., chip/size) is discounted is not specified in the provided text.","Whether the deal is limited-time and the end date are not included in the provided excerpt.","No confirmation is provided on whether the comparison is for the same storage/RAM configuration as last year\u2019s model."],"key_facts":["The new MacBook Air is described as being $150 off.","The discounted price is stated to be lower than last year\u2019s MacBook Air model.","The report is attributed to The Verge."],"numeric_claims":[{"label":"Discount amount","value":"$150 off"},{"label":"Price reference","value":"$150 off (headline context); exact final price not provided in the provided text"}],"primary_claim":"With a $150 discount, the new MacBook Air is priced lower than last year\u2019s model.","relevance_score":0.45,"sentiment":"positive","source_quality":"high","summary":"The Verge reports that a new MacBook Air is discounted by $150, making it cheaper than last year\u2019s MacBook Air model. The near-term catalyst is the limited-time sale price being available now.","topics":["Apple","MacBook Air","laptop pricing","discounts","consumer electronics deals"]},"source":"The Verge","source_domain":"theverge.com","source_url":"https://www.theverge.com","summary":"At $150 off, the new MacBook Air is now cheaper than last year\u2019s model The Verge Regularly $999, get a MacBook Air for just $200 with this limited-time deal Mashable Apple\u2019s new MacBook Air M5 just became our favorite laptop. Now, it\u2019s $149 off CNN Apple's 2026 MacBook Pro Hits All-Time Low Prices on Amazon With Up to $199 Off MacRumors M5 MacBook Air is no longer Apple\u2019s entry point so who is it for now? [Video] 9to5Mac","title":"At $150 off, the new MacBook Air is now cheaper than last year\u2019s model - The Verge","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_edda3a4b2953 in signals