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-08T08:41:30.947704+00:00","dedupe_key":"signal_enriched:market_headline_delta:4044adcac369fdfb","evidence_event_ids":["evt_2625ed3289f3"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMihwJBVV95cUxPWFF3Q29zX2ZRUFRfbE4tNzU3aURkQ3FNSGk3Yjg4QnA4VkJ5al9ncjF5Qy1nMHNmTmJYRXhBQWhncFloTFR2N1RMcW45SmplRTk4ZjRMbTZ5SWF2eDBMY2hYTEFIellYQlkwN0tFVm5qUkRERjlKQmRtYmNFTUlGTWVxMXpvX05Nc3NITnY5b1Fidkp5MjByNEpxbTN6UWdheXV3NTI1U0ZMeHRhNm1ndlU5MXNYaEFYbTZkUWFYdlBVWWdGY3J2Yi14SXN4RUtCblhSSVN6WkNmZ1Vvdl9SbllPaVowbi1TZTFmajM3dmdsT0k2MVljNm1fNzJHT2lnWjJ0Z2hpUQ?oc=5","as_of":"2026-04-08T08:41:30.947704+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/CBMihwJBVV95cUxPWFF3Q29zX2ZRUFRfbE4tNzU3aURkQ3FNSGk3Yjg4QnA4VkJ5al9ncjF5Qy1nMHNmTmJYRXhBQWhncFloTFR2N1RMcW45SmplRTk4ZjRMbTZ5SWF2eDBMY2hYTEFIellYQlkwN0tFVm5qUkRERjlKQmRtYmNFTUlGTWVxMXpvX05Nc3NITnY5b1Fidkp5MjByNEpxbTN6UWdheXV3NTI1U0ZMeHRhNm1ndlU5MXNYaEFYbTZkUWFYdlBVWWdGY3J2Yi14SXN4RUtCblhSSVN6WkNmZ1Vvdl9SbllPaVowbi1TZTFmajM3dmdsT0k2MVljNm1fNzJHT2lnWjJ0Z2hpUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6eef847999a5ca1b","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-08T08:41:59.931603+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihwJBVV95cUxPWFF3Q29zX2ZRUFRfbE4tNzU3aURkQ3FNSGk3Yjg4QnA4VkJ5al9ncjF5Qy1nMHNmTmJYRXhBQWhncFloTFR2N1RMcW45SmplRTk4ZjRMbTZ5SWF2eDBMY2hYTEFIellYQlkwN0tFVm5qUkRERjlKQmRtYmNFTUlGTWVxMXpvX05Nc3NITnY5b1Fidkp5MjByNEpxbTN6UWdheXV3NTI1U0ZMeHRhNm1ndlU5MXNYaEFYbTZkUWFYdlBVWWdGY3J2Yi14SXN4RUtCblhSSVN6WkNmZ1Vvdl9SbllPaVowbi1TZTFmajM3dmdsT0k2MVljNm1fNzJHT2lnWjJ0Z2hpUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"barrons.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihwJBVV95cUxPWFF3Q29zX2ZRUFRfbE4tNzU3aURkQ3FNSGk3Yjg4QnA4VkJ5al9ncjF5Qy1nMHNmTmJYRXhBQWhncFloTFR2N1RMcW45SmplRTk4ZjRMbTZ5SWF2eDBMY2hYTEFIellYQlkwN0tFVm5qUkRERjlKQmRtYmNFTUlGTWVxMXpvX05Nc3NITnY5b1Fidkp5MjByNEpxbTN6UWdheXV3NTI1U0ZMeHRhNm1ndlU5MXNYaEFYbTZkUWFYdlBVWWdGY3J2Yi14SXN4RUtCblhSSVN6WkNmZ1Vvdl9SbllPaVowbi1TZTFmajM3dmdsT0k2MVljNm1fNzJHT2lnWjJ0Z2hpUQ?oc=5","source_event_id":"evt_2625ed3289f3","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7100734a63f9e368","published_at":"2026-04-08T08:08:00+00:00","publisher_domain":"barrons.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.86,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"cryptocurrency"},{"asset_class":"crypto","name":"Ethereum","relevance":"high","symbol":"ETH","type":"cryptocurrency"},{"asset_class":"crypto","name":"XRP","relevance":"high","symbol":"XRP","type":"cryptocurrency"},{"asset_class":"geopolitical","name":"Iran","relevance":"medium","symbol":"","type":"country"}],"event_type":"price_action","information_gaps":["No article body content was provided beyond the headline; magnitude (% change), timing, and whether the move is sustained are not specified.","\u201cIran hope\u201d is not defined in the provided text (no details on the specific development or timeframe).","No confirmation of exact prices for Ethereum or XRP is included in the provided text (only that they \u201cjumped\u201d)."],"key_facts":["Headline states Bitcoin price surged above $70,000.","Headline states Ethereum and XRP jumped.","Headline attributes the crypto rally to \u201cIran hope.\u201d"],"numeric_claims":[{"label":"Bitcoin price level","value":"above $70,000"}],"primary_claim":"Bitcoin surged above $70,000, and Ethereum and XRP rose as cryptos rallied on hope related to Iran.","relevance_score":0.78,"sentiment":"positive","source_quality":"high","summary":"Barron's reports Bitcoin has risen above $70,000, with Ethereum and XRP also jumping as crypto prices rally on \u201cIran hope.\u201d","topics":["cryptocurrency rally","Bitcoin price level breakout","Ethereum price increase","XRP price increase","Iran-related optimism"]},"source":"Barron's","source_domain":"barrons.com","source_url":"https://www.barrons.com","summary":"","tickers":[],"title":"Bitcoin Price Surges Above $70,000. Ethereum, XRP Jump as Cryptos Rally on Iran Hope. - Barron's","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 5494 in events