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-09T13:30:32.171766+00:00","dedupe_key":"signal_enriched:market_headline_delta:a7a8978a0365ec4e","evidence_event_ids":["evt_6e59afb4a95e"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMirgFBVV95cUxNLWQtZkJUM0ZpaWFxVEdoeEcxVzBRRF9Ta1JiMHBjdWtENWRrT1lZdUxhXzVXTWVCcUVHX210aFNaZDdKcTJReWtGN1BBNzhzWWNTSWx5YnpYNW5UYmZUSXMybmhTTWx2dG1SQWowZEg1N01nMGN3UG95bUoxY0xBYWItTHFPRUdoN2t3U2R4R3lxUXI2b2VfVlA3MXJVb0FCUUNuMjJKQ1RUbF9kd3c?oc=5","as_of":"2026-04-09T13:30:32.171766+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/CBMirgFBVV95cUxNLWQtZkJUM0ZpaWFxVEdoeEcxVzBRRF9Ta1JiMHBjdWtENWRrT1lZdUxhXzVXTWVCcUVHX210aFNaZDdKcTJReWtGN1BBNzhzWWNTSWx5YnpYNW5UYmZUSXMybmhTTWx2dG1SQWowZEg1N01nMGN3UG95bUoxY0xBYWItTHFPRUdoN2t3U2R4R3lxUXI2b2VfVlA3MXJVb0FCUUNuMjJKQ1RUbF9kd3c?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ece72e762ac6f21d","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-09T23:26:10.225737+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirgFBVV95cUxNLWQtZkJUM0ZpaWFxVEdoeEcxVzBRRF9Ta1JiMHBjdWtENWRrT1lZdUxhXzVXTWVCcUVHX210aFNaZDdKcTJReWtGN1BBNzhzWWNTSWx5YnpYNW5UYmZUSXMybmhTTWx2dG1SQWowZEg1N01nMGN3UG95bUoxY0xBYWItTHFPRUdoN2t3U2R4R3lxUXI2b2VfVlA3MXJVb0FCUUNuMjJKQ1RUbF9kd3c?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"pro.thestreet.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirgFBVV95cUxNLWQtZkJUM0ZpaWFxVEdoeEcxVzBRRF9Ta1JiMHBjdWtENWRrT1lZdUxhXzVXTWVCcUVHX210aFNaZDdKcTJReWtGN1BBNzhzWWNTSWx5YnpYNW5UYmZUSXMybmhTTWx2dG1SQWowZEg1N01nMGN3UG95bUoxY0xBYWItTHFPRUdoN2t3U2R4R3lxUXI2b2VfVlA3MXJVb0FCUUNuMjJKQ1RUbF9kd3c?oc=5","source_event_id":"evt_6e59afb4a95e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7a963e69ed854446","published_at":"2026-04-09T12:36:00+00:00","publisher_domain":"pro.thestreet.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.62,"dates_mentioned":["Thursday"],"entities":[{"asset_class":"commodity","name":"Oil prices","relevance":"high","symbol":"CL=F","type":"commodity"}],"event_type":"price_action","information_gaps":["The supplied article text is only HTML/CSS and does not include the actual content of the eight items.","No specific oil price level, percentage change, or timeframe is provided.","No stock tickers or indices are mentioned in the provided text.","The direction of market impact (bullish/bearish) beyond the oil-price rise is not specified."],"key_facts":["TheStreet Pro headline states: \"8 Key Items Shaping the Stock Market Thursday.\"","The headline includes: \"Oil Prices Back on the Rise.\"","No additional of the other seven items are provided in the supplied text."],"numeric_claims":[],"primary_claim":"Oil prices are back on the rise, and this is listed as one of eight key items shaping the stock market Thursday.","relevance_score":0.45,"sentiment":"mixed","source_quality":"high","summary":"TheStreet Pro headline indicates that oil prices are rising and are one of several factors expected to influence the stock market on Thursday.","topics":["stock market outlook","oil prices","market drivers"]},"source":"TheStreet Pro","source_domain":"pro.thestreet.com","source_url":"https://pro.thestreet.com","summary":"","tickers":[],"title":"8 Key Items Shaping the Stock Market Thursday: Oil Prices Back on the Rise - TheStreet Pro","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 10000 in events