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-13T08:10:29.000121+00:00","dedupe_key":"signal_enriched:market_headline_delta:3ada901fdbe34815","evidence_event_ids":["evt_308ecc4638cf"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxORzBRN3FlNmd4NFVRR2ZnemctS200TkVjbDlNMWlvbHNoV2RrMTRMZnZqZC1zT1JJUmQyWE5LQm5IS2tSbVNwWExGbFJKLUlRcVViVURQVF9IS3dCaXo3d25ENXVrYTUxd0JkNzdOTU80NHVKd0cxZlVJMmJadXY1ZnpSRWloVVBDa0E?oc=5","as_of":"2026-04-13T08:10:29.000121+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/CBMiigFBVV95cUxORzBRN3FlNmd4NFVRR2ZnemctS200TkVjbDlNMWlvbHNoV2RrMTRMZnZqZC1zT1JJUmQyWE5LQm5IS2tSbVNwWExGbFJKLUlRcVViVURQVF9IS3dCaXo3d25ENXVrYTUxd0JkNzdOTU80NHVKd0cxZlVJMmJadXY1ZnpSRWloVVBDa0E?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_6846068b243fc31e","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-13T08:53:02.670265+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxORzBRN3FlNmd4NFVRR2ZnemctS200TkVjbDlNMWlvbHNoV2RrMTRMZnZqZC1zT1JJUmQyWE5LQm5IS2tSbVNwWExGbFJKLUlRcVViVURQVF9IS3dCaXo3d25ENXVrYTUxd0JkNzdOTU80NHVKd0cxZlVJMmJadXY1ZnpSRWloVVBDa0E?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"techinasia.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxORzBRN3FlNmd4NFVRR2ZnemctS200TkVjbDlNMWlvbHNoV2RrMTRMZnZqZC1zT1JJUmQyWE5LQm5IS2tSbVNwWExGbFJKLUlRcVViVURQVF9IS3dCaXo3d25ENXVrYTUxd0JkNzdOTU80NHVKd0cxZlVJMmJadXY1ZnpSRWloVVBDa0E?oc=5","source_event_id":"evt_308ecc4638cf","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"93209b1d9bdd675d","published_at":"2026-04-13T06:47:00+00:00","publisher_domain":"techinasia.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"asset"}],"event_type":"price_action","information_gaps":["No article text or source summary was provided, so the specific strategy, rationale, timeframe, and whether the signal is from an analyst, model, or firm are unknown.","No price levels, percentage losses, or dates are included in the provided text.","No confirmation is provided about whether the losses are intraday, multi-day, or longer-term."],"key_facts":["Headline states: \"Strategy signals fresh bitcoin buy as losses widen\".","Bitcoin is explicitly mentioned.","The claim implies a buy signal in response to widening losses (trend context not fully specified)."],"numeric_claims":[],"primary_claim":"A strategy signals fresh Bitcoin buying as losses widen.","relevance_score":0.62,"sentiment":"mixed","source_quality":"unknown","summary":"The headline reports that a strategy is signaling fresh Bitcoin buys as Bitcoin losses widen. No additional article details are provided in the input.","topics":["bitcoin","trading strategy","losses widening","buy signal"]},"source":"Tech in Asia","source_domain":"techinasia.com","source_url":"https://www.techinasia.com","summary":"","tickers":[],"title":"Strategy signals fresh bitcoin buy as losses widen - Tech in Asia","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 33397 in events