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/CBMid0FVX3lxTFBNdGxpcVoyOVloZDMwU0w1RkN3N3hhMEh2NVJVc05oQVZjN1paOWwtX3J0VjcxMTZVeFlmOU9obFpLN2tMZ1FYR2F4aFdiMS1mZVRiaDNlR0xHQ0dMeGpzNnp2Z1NoMGE4WFotWU5Lb2lMd0ZIQ2Vn?oc=5","as_of":"2026-04-12T22:11:41.963555+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/CBMid0FVX3lxTFBNdGxpcVoyOVloZDMwU0w1RkN3N3hhMEh2NVJVc05oQVZjN1paOWwtX3J0VjcxMTZVeFlmOU9obFpLN2tMZ1FYR2F4aFdiMS1mZVRiaDNlR0xHQ0dMeGpzNnp2Z1NoMGE4WFotWU5Lb2lMd0ZIQ2Vn?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_909d3108ac24dc90","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-13T00:23:41.899969+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMid0FVX3lxTFBNdGxpcVoyOVloZDMwU0w1RkN3N3hhMEh2NVJVc05oQVZjN1paOWwtX3J0VjcxMTZVeFlmOU9obFpLN2tMZ1FYR2F4aFdiMS1mZVRiaDNlR0xHQ0dMeGpzNnp2Z1NoMGE4WFotWU5Lb2lMd0ZIQ2Vn?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/CBMid0FVX3lxTFBNdGxpcVoyOVloZDMwU0w1RkN3N3hhMEh2NVJVc05oQVZjN1paOWwtX3J0VjcxMTZVeFlmOU9obFpLN2tMZ1FYR2F4aFdiMS1mZVRiaDNlR0xHQ0dMeGpzNnp2Z1NoMGE4WFotWU5Lb2lMd0ZIQ2Vn?oc=5","source_event_id":"evt_9f9f9525135b","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"26dfc6dc83829166","published_at":"2026-04-12T14:47:00+00:00","publisher_domain":"bgr.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":["2026"],"entities":[{"asset_class":"equity","name":"Amazon","relevance":"basis for the user-review claim","symbol":"","type":"company"},{"asset_class":"other","name":"bgr.com","relevance":"source of the headline claim","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The specific tablet model/product name is not provided in the supplied headline text.","No article details, methodology, or review metrics are included in the provided content.","No information is provided about market impact, pricing, availability, or any company financials."],"key_facts":["Headline: \"This Is The Best Tablet You Can Buy In 2026, According To Amazon User Reviews\"","Publisher/domain: bgr.com","No specific tablet model is named in the provided text."],"numeric_claims":[],"primary_claim":"bgr.com states that the best tablet you can buy in 2026 is determined according to Amazon user reviews.","relevance_score":0.2,"sentiment":"neutral","source_quality":"unknown","summary":"The headline claims that a specific tablet is the best option to buy in 2026 based on Amazon user reviews, as reported by bgr.com.","topics":["consumer electronics","tablets","online reviews","2026 buying guidance"]},"source":"bgr.com","source_domain":"bgr.com","source_url":"https://www.bgr.com","summary":"This Is The Best Tablet You Can Buy In 2026, According To Amazon User Reviews bgr.com","title":"This Is The Best Tablet You Can Buy In 2026, According To Amazon User Reviews - bgr.com","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_af52b2c2713d in signals