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-09T15:51:36.226291+00:00","dedupe_key":"signal_enriched:market_headline_delta:d18e8fcbd22ce853","evidence_event_ids":["evt_cc9c4d63dfa8"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxONTVCTjU3LWp6NG9qZWJwb0tFUlk4NDBfc1BjcnF3aXVkdXJZbEFYZEJFbnRaYnpyQk9OX3lhMk9sbnE5NTBfZjA3S3prMG10SmpxUFNnOVRDWVVtc2xiLXNHN2pUSFJRbWNfdHFFTWYwWWpfSm1POFV1ZWhnNTRxcmpkM1I4UG1SMXVBQTQ2T2VPa084SDBBWkxOTzgtQkwyMTB6MFhPLUZXc2ROMi1N?oc=5","as_of":"2026-04-09T15:51:36.226291+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/CBMirwFBVV95cUxONTVCTjU3LWp6NG9qZWJwb0tFUlk4NDBfc1BjcnF3aXVkdXJZbEFYZEJFbnRaYnpyQk9OX3lhMk9sbnE5NTBfZjA3S3prMG10SmpxUFNnOVRDWVVtc2xiLXNHN2pUSFJRbWNfdHFFTWYwWWpfSm1POFV1ZWhnNTRxcmpkM1I4UG1SMXVBQTQ2T2VPa084SDBBWkxOTzgtQkwyMTB6MFhPLUZXc2ROMi1N?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_25e134adf28c56c1","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:40:56.458600+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxONTVCTjU3LWp6NG9qZWJwb0tFUlk4NDBfc1BjcnF3aXVkdXJZbEFYZEJFbnRaYnpyQk9OX3lhMk9sbnE5NTBfZjA3S3prMG10SmpxUFNnOVRDWVVtc2xiLXNHN2pUSFJRbWNfdHFFTWYwWWpfSm1POFV1ZWhnNTRxcmpkM1I4UG1SMXVBQTQ2T2VPa084SDBBWkxOTzgtQkwyMTB6MFhPLUZXc2ROMi1N?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxONTVCTjU3LWp6NG9qZWJwb0tFUlk4NDBfc1BjcnF3aXVkdXJZbEFYZEJFbnRaYnpyQk9OX3lhMk9sbnE5NTBfZjA3S3prMG10SmpxUFNnOVRDWVVtc2xiLXNHN2pUSFJRbWNfdHFFTWYwWWpfSm1POFV1ZWhnNTRxcmpkM1I4UG1SMXVBQTQ2T2VPa084SDBBWkxOTzgtQkwyMTB6MFhPLUZXc2ROMi1N?oc=5","source_event_id":"evt_cc9c4d63dfa8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5b965b2b78861051","published_at":"2026-04-09T15:18:19+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"primary","symbol":"BTC","type":"asset"},{"asset_class":"equity","name":"Coinbase","relevance":"primary","symbol":"COIN","type":"company"}],"event_type":"macro_policy","information_gaps":["No article body text was provided, so the specific inflation metric (e.g., CPI/PPI), the direction/magnitude of price moves, timing (release date/time), and causal mechanism are not available.","No explicit mention of the Coinbase ticker (COIN) or Bitcoin ticker (BTC) appears in the provided text; symbols are inferred only from standard conventions, not from the text itself.","No confirmation is provided on whether the impact is contemporaneous with the data release or based on historical correlations."],"key_facts":["Yahoo Finance headline states that inflation data is hitting Bitcoin prices.","Yahoo Finance headline states that inflation data is hitting Coinbase stock."],"numeric_claims":[],"primary_claim":"Inflation data is affecting both Bitcoin prices and Coinbase stock.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The Yahoo Finance article headline links inflation data to movements in Bitcoin prices and Coinbase stock.","topics":["inflation data","Bitcoin price impact","Coinbase stock impact","macro data sensitivity"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"","tickers":[],"title":"How inflation data is hitting bitcoin prices and Coinbase stock - Yahoo Finance","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 10330 in events