SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_89e595730e46 in signals