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/CBMiZ0FVX3lxTFBiemZUMnRhckgwOVBJV3ZiVHJWeTQ0NTJHRERpRFdyNldQd1VWS3JGNzQ5aDNfOXB3UHhLZ3lUeWlUREJwMnRmN0NPd1ZYZFZUc3lmU3NreE85elUzQlpUX21QcEhHZ0k?oc=5","as_of":"2026-04-08T03:31:26.595606+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiZ0FVX3lxTFBiemZUMnRhckgwOVBJV3ZiVHJWeTQ0NTJHRERpRFdyNldQd1VWS3JGNzQ5aDNfOXB3UHhLZ3lUeWlUREJwMnRmN0NPd1ZYZFZUc3lmU3NreE85elUzQlpUX21QcEhHZ0k?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4f2f9357147d25ad","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T03:49:38.009840+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiZ0FVX3lxTFBiemZUMnRhckgwOVBJV3ZiVHJWeTQ0NTJHRERpRFdyNldQd1VWS3JGNzQ5aDNfOXB3UHhLZ3lUeWlUREJwMnRmN0NPd1ZYZFZUc3lmU3NreE85elUzQlpUX21QcEhHZ0k?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bgr.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiZ0FVX3lxTFBiemZUMnRhckgwOVBJV3ZiVHJWeTQ0NTJHRERpRFdyNldQd1VWS3JGNzQ5aDNfOXB3UHhLZ3lUeWlUREJwMnRmN0NPd1ZYZFZUc3lmU3NreE85elUzQlpUX21QcEhHZ0k?oc=5","source_event_id":"evt_43b8846e68bb","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2c08b57e4ab65800","published_at":"2026-04-07T23:17:00+00:00","publisher_domain":"bgr.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"","name":"BGR.com","relevance":"source of the article","symbol":"","type":"publisher"},{"asset_class":"","name":"Amazon","relevance":"where the gadgets can be found","symbol":"","type":"retailer/platform"}],"event_type":"other","information_gaps":["The provided article text is not actually the article content (it appears to be page styling/HTML), so the specific four gadgets are not available.","No timing (publication date) is included in the provided text.","No information is provided about brands, models, pricing, availability, or whether these are new releases vs. existing products.","No market/financial impact details are included; this appears to be a consumer product roundup rather than a company/earnings/regulatory event."],"key_facts":["Headline states there are 4 \u201c80s Inspired Retro Gadgets\u201d that can be found on Amazon.","Source summary repeats the same claim.","No specific gadget names, brands, prices, or technical details are present in the provided text."],"numeric_claims":[{"label":"number_of_gadgets","value":"4"}],"primary_claim":"The article presents four 1980s-inspired retro gadgets available on Amazon.","relevance_score":0.15,"sentiment":"neutral","source_quality":"high","summary":"BGR.com published an article listing four retro gadgets inspired by the 1980s that readers can find on Amazon.","topics":["consumer electronics","retro/80s style","e-commerce","product recommendations"]},"source":"bgr.com","source_domain":"bgr.com","source_url":"https://www.bgr.com","summary":"4 '80s Inspired Retro Gadgets You Can Find On Amazon bgr.com","title":"4 '80s Inspired Retro Gadgets You Can Find On Amazon - bgr.com","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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_06db67f928c0 in signals