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-10T06:10:21.194253+00:00","dedupe_key":"signal_enriched:market_headline_delta:e7f98952a1ec062e","evidence_event_ids":["evt_271540076fc7"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiwwFBVV95cUxOSUQ0S3NUT1Rka0VZVlczZkxERW1nVXBhZlFHdjcxWjRxZjhQTGF4NlJQd2Nfd3NIclY1VUtPT1RsWlhrS3NqUlFVTkJCeHpORDhyR01jMEpkX19HZzNuMkZ4Wi1KUXFmQ3dxNlZyQ3kzQUU4ejh1VXFhbGJ2TWUwWmJfUDc4czhidnpITFR0c29GbFNobTBsU2tIU3VFdGVGZ3VWdF9ZemZKUTFUNXlWTDVpZGkyM01ZRFNHT2ZxN081RGs?oc=5","as_of":"2026-04-10T06:10:21.194253+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/CBMiwwFBVV95cUxOSUQ0S3NUT1Rka0VZVlczZkxERW1nVXBhZlFHdjcxWjRxZjhQTGF4NlJQd2Nfd3NIclY1VUtPT1RsWlhrS3NqUlFVTkJCeHpORDhyR01jMEpkX19HZzNuMkZ4Wi1KUXFmQ3dxNlZyQ3kzQUU4ejh1VXFhbGJ2TWUwWmJfUDc4czhidnpITFR0c29GbFNobTBsU2tIU3VFdGVGZ3VWdF9ZemZKUTFUNXlWTDVpZGkyM01ZRFNHT2ZxN081RGs?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_37c97ddcf6f9d59d","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-10T06:10:47.200118+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiwwFBVV95cUxOSUQ0S3NUT1Rka0VZVlczZkxERW1nVXBhZlFHdjcxWjRxZjhQTGF4NlJQd2Nfd3NIclY1VUtPT1RsWlhrS3NqUlFVTkJCeHpORDhyR01jMEpkX19HZzNuMkZ4Wi1KUXFmQ3dxNlZyQ3kzQUU4ejh1VXFhbGJ2TWUwWmJfUDc4czhidnpITFR0c29GbFNobTBsU2tIU3VFdGVGZ3VWdF9ZemZKUTFUNXlWTDVpZGkyM01ZRFNHT2ZxN081RGs?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"marketwatch.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiwwFBVV95cUxOSUQ0S3NUT1Rka0VZVlczZkxERW1nVXBhZlFHdjcxWjRxZjhQTGF4NlJQd2Nfd3NIclY1VUtPT1RsWlhrS3NqUlFVTkJCeHpORDhyR01jMEpkX19HZzNuMkZ4Wi1KUXFmQ3dxNlZyQ3kzQUU4ejh1VXFhbGJ2TWUwWmJfUDc4czhidnpITFR0c29GbFNobTBsU2tIU3VFdGVGZ3VWdF9ZemZKUTFUNXlWTDVpZGkyM01ZRFNHT2ZxN081RGs?oc=5","source_event_id":"evt_271540076fc7","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"87b30c7bc8dc1c44","published_at":"2026-04-09T21:02:00+00:00","publisher_domain":"marketwatch.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"stock","name":"Fox Corp. Class B","relevance":"high","symbol":"FOXA","type":"equity"}],"event_type":"price_action","information_gaps":["No article body content was provided beyond page-cleaning HTML/CSS, so the magnitude of outperformance (percent/price change) and which specific competitors are not stated.","No date/timeframe for the \u201cstrong trading day\u201d is included in the provided text.","No confirmation of the exact ticker mapping for \u201cFox Corp. Cl B\u201d is present in the provided text (symbol FOXA is inferred from common market convention, not explicitly stated)."],"key_facts":["The headline states Fox Corp. Class B stock outperformed competitors.","The headline characterizes the day as a strong trading day."],"numeric_claims":[],"primary_claim":"Fox Corp. Cl B stock outperformed competitors on a strong trading day.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"MarketWatch reports that Fox Corp. Class B shares rose more than its competitors on a strong trading day.","topics":["stock performance","relative performance","trading day","media/entertainment equities"]},"source":"MarketWatch","source_domain":"marketwatch.com","source_url":"https://www.marketwatch.com","summary":"","tickers":[],"title":"Fox Corp. Cl B stock outperforms competitors on strong trading day - MarketWatch","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 14519 in events