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/CBMi8gFBVV95cUxPMjBKZVhRZDZITEVUU2pZR2dLbEZ0THFMdnlHTzJlbmRMZk8xTzRreGRueUhSUktFYWFjc2JFeHFfeDc1U0ZkbTA4X0JHN3NQZWUxR3BaUWhjUkRGeTZDUExZTlNzUGNuV3dfZUNoVEFCd2k1bGF1VWs4d2lsWjhMdUZtcURFOGM5a2RNZ2JWb2hBVzhBOTFiZFdxVjF6Ullzd18tUWxTc2Z4TERPd3dZZVJ3RktJVlRtU2J1TGJiS2dEUHdhaHhROVRSN1hCbEVJTWc3ckdqendYaVd3SHZ6NVlYYmtVZjRrTGhqRl9RVWdHdw?oc=5","as_of":"2026-04-14T07:32:51.247454+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMi8gFBVV95cUxPMjBKZVhRZDZITEVUU2pZR2dLbEZ0THFMdnlHTzJlbmRMZk8xTzRreGRueUhSUktFYWFjc2JFeHFfeDc1U0ZkbTA4X0JHN3NQZWUxR3BaUWhjUkRGeTZDUExZTlNzUGNuV3dfZUNoVEFCd2k1bGF1VWs4d2lsWjhMdUZtcURFOGM5a2RNZ2JWb2hBVzhBOTFiZFdxVjF6Ullzd18tUWxTc2Z4TERPd3dZZVJ3RktJVlRtU2J1TGJiS2dEUHdhaHhROVRSN1hCbEVJTWc3ckdqendYaVd3SHZ6NVlYYmtVZjRrTGhqRl9RVWdHdw?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_707e4d923b07f398","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-14T07:34:19.957885+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi8gFBVV95cUxPMjBKZVhRZDZITEVUU2pZR2dLbEZ0THFMdnlHTzJlbmRMZk8xTzRreGRueUhSUktFYWFjc2JFeHFfeDc1U0ZkbTA4X0JHN3NQZWUxR3BaUWhjUkRGeTZDUExZTlNzUGNuV3dfZUNoVEFCd2k1bGF1VWs4d2lsWjhMdUZtcURFOGM5a2RNZ2JWb2hBVzhBOTFiZFdxVjF6Ullzd18tUWxTc2Z4TERPd3dZZVJ3RktJVlRtU2J1TGJiS2dEUHdhaHhROVRSN1hCbEVJTWc3ckdqendYaVd3SHZ6NVlYYmtVZjRrTGhqRl9RVWdHdw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"stockstory.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi8gFBVV95cUxPMjBKZVhRZDZITEVUU2pZR2dLbEZ0THFMdnlHTzJlbmRMZk8xTzRreGRueUhSUktFYWFjc2JFeHFfeDc1U0ZkbTA4X0JHN3NQZWUxR3BaUWhjUkRGeTZDUExZTlNzUGNuV3dfZUNoVEFCd2k1bGF1VWs4d2lsWjhMdUZtcURFOGM5a2RNZ2JWb2hBVzhBOTFiZFdxVjF6Ullzd18tUWxTc2Z4TERPd3dZZVJ3RktJVlRtU2J1TGJiS2dEUHdhaHhROVRSN1hCbEVJTWc3ckdqendYaVd3SHZ6NVlYYmtVZjRrTGhqRl9RVWdHdw?oc=5","source_event_id":"evt_b1f50b65900c","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"4d0720d96636239a","published_at":"2026-04-14T07:29:07+00:00","publisher_domain":"stockstory.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Jack in the Box","relevance":"primary","symbol":"JACK","type":"company"},{"asset_class":"other","name":"StockStory","relevance":"context","symbol":"","type":"publisher"}],"event_type":"earnings","information_gaps":["No article body text is available, so Q4 results (revenue, EPS, margins), management commentary, guidance, or any market reaction cannot be extracted.","No specific date for the Q4 earnings release or publication timing is provided.","No details on which other fast food stocks are included in the comparison are provided."],"key_facts":["Headline references \u201cUnpacking Q4 Earnings\u201d for Jack in the Box (NASDAQ:JACK).","Headline states the analysis is \u201cin the context of other traditional fast food stocks.\u201d"],"numeric_claims":[],"primary_claim":"StockStory is publishing an article unpacking Jack in the Box\u2019s Q4 earnings in the context of other traditional fast food stocks.","relevance_score":0.45,"sentiment":"neutral","source_quality":"unknown","summary":"The provided headline indicates a Q4 earnings discussion for Jack in the Box (NASDAQ:JACK) framed alongside other traditional fast food stocks. No specific earnings figures, guidance, or timing details are included in the provided text.","topics":["Q4 earnings","fast food stocks","comparative analysis"]},"source":"StockStory","source_domain":"stockstory.org","source_url":"https://stockstory.org","summary":"Unpacking Q4 Earnings: Jack in the Box (NASDAQ:JACK) In The Context Of Other Traditional Fast Food Stocks StockStory","title":"Unpacking Q4 Earnings: Jack in the Box (NASDAQ:JACK) In The Context Of Other Traditional Fast Food Stocks - StockStory","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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_dc140768fdaf in signals