SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-09T03:57:11.861792+00:00","dedupe_key":"signal_enriched:news_delta:e9e7322be4249604","evidence_event_ids":["evt_8ad7c8cb08e1"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxQbS15NWg3ZWc0VVE3a0ZUY2VjTlhvYi04TnY0MkFKbWVkVUMtUlRlaGNyLVl5eFgwWlBiRnZnSXRvVWJWQVlva3FhTWgzQ3ZHS3ZIeF80R0M5R01jOTZ0R3hoanNlRkd0cTJRZGN4c3FwWHBpVW5SaGxLYjJJWU1vamxEaGVLU3RxbmFuODRtQ19sYTFmcmk4a3dxSW1SNzFmUTRjUlM5dHBmRURKQTRiMTl3?oc=5","as_of":"2026-04-09T03:57:11.861792+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/CBMisgFBVV95cUxQbS15NWg3ZWc0VVE3a0ZUY2VjTlhvYi04TnY0MkFKbWVkVUMtUlRlaGNyLVl5eFgwWlBiRnZnSXRvVWJWQVlva3FhTWgzQ3ZHS3ZIeF80R0M5R01jOTZ0R3hoanNlRkd0cTJRZGN4c3FwWHBpVW5SaGxLYjJJWU1vamxEaGVLU3RxbmFuODRtQ19sYTFmcmk4a3dxSW1SNzFmUTRjUlM5dHBmRURKQTRiMTl3?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b2ddeda2bbc1626f","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-09T22:33:14.386637+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxQbS15NWg3ZWc0VVE3a0ZUY2VjTlhvYi04TnY0MkFKbWVkVUMtUlRlaGNyLVl5eFgwWlBiRnZnSXRvVWJWQVlva3FhTWgzQ3ZHS3ZIeF80R0M5R01jOTZ0R3hoanNlRkd0cTJRZGN4c3FwWHBpVW5SaGxLYjJJWU1vamxEaGVLU3RxbmFuODRtQ19sYTFmcmk4a3dxSW1SNzFmUTRjUlM5dHBmRURKQTRiMTl3?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"thedailytexan.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxQbS15NWg3ZWc0VVE3a0ZUY2VjTlhvYi04TnY0MkFKbWVkVUMtUlRlaGNyLVl5eFgwWlBiRnZnSXRvVWJWQVlva3FhTWgzQ3ZHS3ZIeF80R0M5R01jOTZ0R3hoanNlRkd0cTJRZGN4c3FwWHBpVW5SaGxLYjJJWU1vamxEaGVLU3RxbmFuODRtQ19sYTFmcmk4a3dxSW1SNzFmUTRjUlM5dHBmRURKQTRiMTl3?oc=5","source_event_id":"evt_8ad7c8cb08e1","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"424ca9482d09377e","published_at":"2026-04-09T03:26:31+00:00","publisher_domain":"thedailytexan.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"The Daily Texan","relevance":"primary source","symbol":"","type":"publisher"},{"asset_class":"","name":"Texas hockey","relevance":"core subject","symbol":"","type":"topic"}],"event_type":"other","information_gaps":["No article body content was provided beyond the headline/title, so specific mechanisms (e.g., teams, leagues, programs, venues, timelines, or metrics of popularity) are not available.","No named organizations, locations within Texas, or individuals are included in the provided text.","No near-term catalyst timing or measurable impact is stated in the provided excerpt."],"key_facts":["A The Daily Texan piece titled \u201cTexas hockey: How the sport has been popularized in non-traditional markets\u201d is referenced."],"numeric_claims":[],"primary_claim":"Texas hockey has been popularized in non-traditional markets, according to The Daily Texan.","relevance_score":0.25,"sentiment":"neutral","source_quality":"high","summary":"The Daily Texan article discusses how hockey has been popularized in Texas in non-traditional markets.","topics":["Texas hockey","sports popularization","non-traditional markets"]},"source":"The Daily Texan","source_domain":"thedailytexan.com","source_url":"https://thedailytexan.com","summary":"Texas hockey: How the sport has been popularized in non-traditional markets The Daily Texan","title":"Texas hockey: How the sport has been popularized in non-traditional markets - The Daily Texan","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 8824 in events