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-08T01:12:26.621898+00:00","dedupe_key":"signal_enriched:news_delta:4a9dd443234d1f03","evidence_event_ids":["evt_81d5a31b08aa"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMidkFVX3lxTFBPQ0xwckpoc0VRNzZYYmV1b252azRseWJVZmVlVU5sVEN6YU93clgxVW9vM2tYUlNkZ1Ftak5lV3NGRC12dFpJdVBPUjMxNUc5eXd5SFpIaFZ0aTA0OGR1eVZmOE9zRC1ybl9ZZ0xfeHBGWTZVcnfSAXtBVV95cUxOR2tlWHc2VkVid1JzeEZ6STg3Y3cwMUstNENwTncwNUVoTHgzWlFXUkx0THZpMHp2M0JlNTBOSnhONXhuUjJqSWl3bjQ4WFl1U1dqcU1mQWJ6akN0UUF3NWkwTzQ3Tkk3M2RDamFLU2JoT0JIQjV5RGpjOVk?oc=5","as_of":"2026-04-08T01:12:26.621898+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/CBMidkFVX3lxTFBPQ0xwckpoc0VRNzZYYmV1b252azRseWJVZmVlVU5sVEN6YU93clgxVW9vM2tYUlNkZ1Ftak5lV3NGRC12dFpJdVBPUjMxNUc5eXd5SFpIaFZ0aTA0OGR1eVZmOE9zRC1ybl9ZZ0xfeHBGWTZVcnfSAXtBVV95cUxOR2tlWHc2VkVid1JzeEZ6STg3Y3cwMUstNENwTncwNUVoTHgzWlFXUkx0THZpMHp2M0JlNTBOSnhONXhuUjJqSWl3bjQ4WFl1U1dqcU1mQWJ6akN0UUF3NWkwTzQ3Tkk3M2RDamFLU2JoT0JIQjV5RGpjOVk?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2bafd1d75d591511","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-08T01:14:56.130650+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMidkFVX3lxTFBPQ0xwckpoc0VRNzZYYmV1b252azRseWJVZmVlVU5sVEN6YU93clgxVW9vM2tYUlNkZ1Ftak5lV3NGRC12dFpJdVBPUjMxNUc5eXd5SFpIaFZ0aTA0OGR1eVZmOE9zRC1ybl9ZZ0xfeHBGWTZVcnfSAXtBVV95cUxOR2tlWHc2VkVid1JzeEZ6STg3Y3cwMUstNENwTncwNUVoTHgzWlFXUkx0THZpMHp2M0JlNTBOSnhONXhuUjJqSWl3bjQ4WFl1U1dqcU1mQWJ6akN0UUF3NWkwTzQ3Tkk3M2RDamFLU2JoT0JIQjV5RGpjOVk?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cbsnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMidkFVX3lxTFBPQ0xwckpoc0VRNzZYYmV1b252azRseWJVZmVlVU5sVEN6YU93clgxVW9vM2tYUlNkZ1Ftak5lV3NGRC12dFpJdVBPUjMxNUc5eXd5SFpIaFZ0aTA0OGR1eVZmOE9zRC1ybl9ZZ0xfeHBGWTZVcnfSAXtBVV95cUxOR2tlWHc2VkVid1JzeEZ6STg3Y3cwMUstNENwTncwNUVoTHgzWlFXUkx0THZpMHp2M0JlNTBOSnhONXhuUjJqSWl3bjQ4WFl1U1dqcU1mQWJ6akN0UUF3NWkwTzQ3Tkk3M2RDamFLU2JoT0JIQjV5RGpjOVk?oc=5","source_event_id":"evt_81d5a31b08aa","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"67cffeca993b36a6","published_at":"2026-04-07T19:42:26+00:00","publisher_domain":"cbsnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"","name":"U.S. lawmakers","relevance":"primary","symbol":"","type":"government"},{"asset_class":"","name":"CFTC (Commodity Futures Trading Commission)","relevance":"primary","symbol":"","type":"regulator"},{"asset_class":"","name":"Prediction markets","relevance":"primary","symbol":"","type":"market structure"},{"asset_class":"","name":"U.S. airmen","relevance":"context","symbol":"","type":"individuals"},{"asset_class":"","name":"CBS News","relevance":"source","symbol":"","type":"media"}],"event_type":"regulation","information_gaps":["Which specific prediction market(s) or platform(s) were involved is not stated in the provided text.","Who placed the bet and when it occurred are not stated.","What form the \u201ccrackdown\u201d would take (e.g., enforcement action, rule changes, bans) is not specified.","Whether any CFTC action has already occurred is not stated.","No market/financial instrument symbols are provided because the text does not identify any tradable assets."],"key_facts":["The headline states lawmakers are calling for a CFTC crackdown on prediction markets.","The call is described as being after a bet on downed U.S. airmen.","The source is CBS News."],"numeric_claims":[],"primary_claim":"Lawmakers are calling for a CFTC crackdown on prediction markets following a bet connected to downed U.S. airmen.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"CBS News reports that U.S. lawmakers are urging the CFTC to crack down on prediction markets after a bet was placed related to downed U.S. airmen.","topics":["prediction markets","CFTC","regulatory crackdown","U.S. airmen incident","lawmakers"]},"source":"CBS News","source_domain":"cbsnews.com","source_url":"https://www.cbsnews.com","summary":"Lawmakers call for CFTC crackdown on prediction markets after bet on downed U.S. airmen CBS News","title":"Lawmakers call for CFTC crackdown on prediction markets after bet on downed U.S. airmen - CBS News","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

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 3100 in events