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-07T23:35:18.302653+00:00","dedupe_key":"signal_enriched:market_headline_delta:8aaa2887f10f2e87","evidence_event_ids":["evt_0475dd0c8490"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMipAFBVV95cUxOY3l0b3BRUTd0MEJXcWUxcXpvbHFpRlBZLV9PSmNaMU1qZFdkRGZuR2pYQmU5NG9iT05FRnBDNVByNl9ERldGc0w5dUZ3aDFCY21UMlVOVnR6ZzdoaEFCZHFMOG9tWVZ4aUV4TnhWUDZ1TGlyUWI0TktRVV93NkxYck4xUlNNZlUyZ3J5andiVW5SY0hRVHowRGNQZGJzYUtnQ042Xw?oc=5","as_of":"2026-04-07T23:35:18.302653+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/CBMipAFBVV95cUxOY3l0b3BRUTd0MEJXcWUxcXpvbHFpRlBZLV9PSmNaMU1qZFdkRGZuR2pYQmU5NG9iT05FRnBDNVByNl9ERldGc0w5dUZ3aDFCY21UMlVOVnR6ZzdoaEFCZHFMOG9tWVZ4aUV4TnhWUDZ1TGlyUWI0TktRVV93NkxYck4xUlNNZlUyZ3J5andiVW5SY0hRVHowRGNQZGJzYUtnQ042Xw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_db3bccde90e0a25d","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-08T00:38:24.553066+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipAFBVV95cUxOY3l0b3BRUTd0MEJXcWUxcXpvbHFpRlBZLV9PSmNaMU1qZFdkRGZuR2pYQmU5NG9iT05FRnBDNVByNl9ERldGc0w5dUZ3aDFCY21UMlVOVnR6ZzdoaEFCZHFMOG9tWVZ4aUV4TnhWUDZ1TGlyUWI0TktRVV93NkxYck4xUlNNZlUyZ3J5andiVW5SY0hRVHowRGNQZGJzYUtnQ042Xw?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/CBMipAFBVV95cUxOY3l0b3BRUTd0MEJXcWUxcXpvbHFpRlBZLV9PSmNaMU1qZFdkRGZuR2pYQmU5NG9iT05FRnBDNVByNl9ERldGc0w5dUZ3aDFCY21UMlVOVnR6ZzdoaEFCZHFMOG9tWVZ4aUV4TnhWUDZ1TGlyUWI0TktRVV93NkxYck4xUlNNZlUyZ3J5andiVW5SY0hRVHowRGNQZGJzYUtnQ042Xw?oc=5","source_event_id":"evt_0475dd0c8490","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"8ad1866dccb87415","published_at":"2026-04-07T17:20:00+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":["this year"],"entities":[{"asset_class":"commodity","name":"Silver","relevance":"directly referenced as the potential beneficiary","symbol":"XAG","type":"commodity"}],"event_type":"price_action","information_gaps":["No article body content was provided, so the specific historical findings, time periods, magnitude, or conditions for silver's performance are unknown.","No tickers beyond 'silver' are explicitly provided in the provided text.","The headline does not specify which stock market index or definition of 'crash' is used."],"key_facts":["Headline asks whether silver would rise if the stock market crashes this year.","The headline attributes the answer to historical evidence ('Here's What History Says')."],"numeric_claims":[],"primary_claim":"If the stock market crashes this year, silver may soar, based on what history says.","relevance_score":0.42,"sentiment":"mixed","source_quality":"high","summary":"The Yahoo Finance headline frames a scenario where a stock market crash could coincide with silver potentially rising, referencing historical patterns.","topics":["silver","stock market crash","historical performance","safe-haven/hedge narrative"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"","tickers":[],"title":"If the Stock Market Crashes This Year, Will Silver Soar? Here's What History Says - Yahoo Finance","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 2353 in events