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/CBMieEFVX3lxTE84UVVhUHhLcFdLRmo5YWR2SzFtTEttcW04am1zanhJbDliVWc4YjNrYUJ0TGxCbGdnRml4SEhNR052S0U1ci1CcjJ5dzJNdmhFbm1CZ1BoMlYzUUM5V3hMNHR6cktDenNiRHBiYWNYY1VPU3V6cVhfRg?oc=5","as_of":"2026-04-08T07:36:47.174200+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/CBMieEFVX3lxTE84UVVhUHhLcFdLRmo5YWR2SzFtTEttcW04am1zanhJbDliVWc4YjNrYUJ0TGxCbGdnRml4SEhNR052S0U1ci1CcjJ5dzJNdmhFbm1CZ1BoMlYzUUM5V3hMNHR6cktDenNiRHBiYWNYY1VPU3V6cVhfRg?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ef728434b83560aa","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:37:23.662275+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMieEFVX3lxTE84UVVhUHhLcFdLRmo5YWR2SzFtTEttcW04am1zanhJbDliVWc4YjNrYUJ0TGxCbGdnRml4SEhNR052S0U1ci1CcjJ5dzJNdmhFbm1CZ1BoMlYzUUM5V3hMNHR6cktDenNiRHBiYWNYY1VPU3V6cVhfRg?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cbssports.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMieEFVX3lxTE84UVVhUHhLcFdLRmo5YWR2SzFtTEttcW04am1zanhJbDliVWc4YjNrYUJ0TGxCbGdnRml4SEhNR052S0U1ci1CcjJ5dzJNdmhFbm1CZ1BoMlYzUUM5V3hMNHR6cktDenNiRHBiYWNYY1VPU3V6cVhfRg?oc=5","source_event_id":"evt_807cfdd58763","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"06b45182e04ff5cb","published_at":"2026-04-08T05:01:01+00:00","publisher_domain":"cbssports.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["April 7, 2026"],"entities":[{"asset_class":"equity","name":"Oklahoma City Thunder","relevance":"primary","symbol":"","type":"sports_team"},{"asset_class":"equity","name":"Los Angeles Lakers","relevance":"primary","symbol":"","type":"sports_team"},{"asset_class":"media","name":"CBS Sports","relevance":"source","symbol":"","type":"publisher"},{"asset_class":"media","name":"ESPN","relevance":"secondary","symbol":"","type":"publisher"},{"asset_class":"media","name":"Sports Illustrated","relevance":"secondary","symbol":"","type":"publisher"},{"asset_class":"media","name":"Yahoo Sports","relevance":"secondary","symbol":"","type":"publisher"}],"event_type":"price_action","information_gaps":["Player-level details (e.g., which Lakers were unavailable) are not included in the cleaned text.","The exact Western Conference standings context (current rank and how close to 5th) is not provided.","The cleaned article text appears to include mostly page styling/HTML rather than the actual recap content; only the provided source summary contains the substantive facts."],"key_facts":["Game date: April 7, 2026.","Final score: Oklahoma City Thunder 123, Los Angeles Lakers 87.","The Lakers were described as short-handed in the provided source summary.","The provided source summary indicates the Lakers were blown out again by the Thunder.","The provided source summary states the Lakers were on the verge of falling to 5th place in the West (standings implication)."],"numeric_claims":[{"label":"Thunder final score","value":"123"},{"label":"Lakers final score","value":"87"}],"primary_claim":"The Oklahoma City Thunder beat the Los Angeles Lakers 123\u201387 on April 7, 2026.","relevance_score":0.42,"sentiment":"mixed","source_quality":"high","summary":"On April 7, 2026, the Oklahoma City Thunder defeated the Los Angeles Lakers 123\u201387 in a lopsided game. The Lakers were described as short-handed and blown out, with commentary suggesting they were near a drop to 5th place in the Western Conference.","topics":["NBA game result","Thunder vs Lakers","Western Conference standings","short-handed Lakers","game recap"]},"source":"CBS Sports","source_domain":"cbssports.com","source_url":"https://www.cbssports.com","summary":"Oklahoma City Thunder vs. Los Angeles Lakers Live Score and Stats - April 7, 2026 Gametracker CBS Sports Thunder 123-87 Lakers (Apr 7, 2026) Game Recap ESPN Player Grades: Lakers vs. Thunder Silver Screen and Roll Isaiah Joe's Big Night From Deep Headlines Takeaways In The Thunder's Big Win Over The Lakers Sports Illustrated Short-handed Lakers blown out again by Thunder, on verge of falling to 5th place in West Yahoo Sports","title":"Oklahoma City Thunder vs. Los Angeles Lakers Live Score and Stats - April 7, 2026 Gametracker - CBS Sports","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_89fa9b674fda in signals