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/CBMi1wFBVV95cUxPdjFjWFpyMEQxNXBaZ0lzdjFtb1ZTUTFJWjFDaVpGRG04eXNCUU1JWE4zT0x0al83dEFsMHlNbDMyYVNtMGR6aDBNdEgweE5hUzREMVhhMTFUQ29sekoxLXd1MVhScW42NEJKak1tcWRlMjZpVXJjdkYwYjF1eVpBSWhvSnVuUm9mRThzUDRWLXBsRzZXM1VrTlA4b3l6U0lzMlYtLW1JMHhzVlMzaklZVmNUbm1wdFRTaWhHSGlSbUhQX1pvZGl6bG84UWduN25SakZZaU1aOA?oc=5","as_of":"2026-04-13T08:10:29.912187+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/CBMi1wFBVV95cUxPdjFjWFpyMEQxNXBaZ0lzdjFtb1ZTUTFJWjFDaVpGRG04eXNCUU1JWE4zT0x0al83dEFsMHlNbDMyYVNtMGR6aDBNdEgweE5hUzREMVhhMTFUQ29sekoxLXd1MVhScW42NEJKak1tcWRlMjZpVXJjdkYwYjF1eVpBSWhvSnVuUm9mRThzUDRWLXBsRzZXM1VrTlA4b3l6U0lzMlYtLW1JMHhzVlMzaklZVmNUbm1wdFRTaWhHSGlSbUhQX1pvZGl6bG84UWduN25SakZZaU1aOA?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_28ad63cd06020be9","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:54:10.587171+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi1wFBVV95cUxPdjFjWFpyMEQxNXBaZ0lzdjFtb1ZTUTFJWjFDaVpGRG04eXNCUU1JWE4zT0x0al83dEFsMHlNbDMyYVNtMGR6aDBNdEgweE5hUzREMVhhMTFUQ29sekoxLXd1MVhScW42NEJKak1tcWRlMjZpVXJjdkYwYjF1eVpBSWhvSnVuUm9mRThzUDRWLXBsRzZXM1VrTlA4b3l6U0lzMlYtLW1JMHhzVlMzaklZVmNUbm1wdFRTaWhHSGlSbUhQX1pvZGl6bG84UWduN25SakZZaU1aOA?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/CBMi1wFBVV95cUxPdjFjWFpyMEQxNXBaZ0lzdjFtb1ZTUTFJWjFDaVpGRG04eXNCUU1JWE4zT0x0al83dEFsMHlNbDMyYVNtMGR6aDBNdEgweE5hUzREMVhhMTFUQ29sekoxLXd1MVhScW42NEJKak1tcWRlMjZpVXJjdkYwYjF1eVpBSWhvSnVuUm9mRThzUDRWLXBsRzZXM1VrTlA4b3l6U0lzMlYtLW1JMHhzVlMzaklZVmNUbm1wdFRTaWhHSGlSbUhQX1pvZGl6bG84UWduN25SakZZaU1aOA?oc=5","source_event_id":"evt_e30cdafa298a","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"a0406f78904a0101","published_at":"2026-04-13T07:11:41+00:00","publisher_domain":"stockstory.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.45,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"StockStory","relevance":"primary source","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The names and ticker symbols of the \u201c2 mooning\u201d semiconductor stocks are not provided.","The name and ticker symbol of the \u201c1 risky\u201d semiconductor stock are not provided.","No evidence, metrics, catalysts, time horizon, or rationale are included beyond the headline wording.","No directional impact details (e.g., earnings, guidance, contracts, regulatory events) are provided."],"key_facts":["Headline states: \u201c2 Mooning Semiconductor Stocks with Competitive Advantages and 1 We Find Risky - StockStory.\u201d","No article body text, tickers, company names, or specific risk factors are included in the provided material."],"numeric_claims":[],"primary_claim":"StockStory claims there are two semiconductor stocks with competitive advantages that are \u201cmooning,\u201d and one semiconductor stock it considers risky.","relevance_score":0.25,"sentiment":"mixed","source_quality":"unknown","summary":"The StockStory headline indicates that it highlights two semiconductor stocks it views as having competitive advantages and rising (\u201cmooning\u201d), and separately flags one semiconductor stock as risky. No specific stock tickers or details are provided in the provided text.","topics":["semiconductors","stock selection","risk assessment"]},"source":"StockStory","source_domain":"stockstory.org","source_url":"https://stockstory.org","summary":"2 Mooning Semiconductor Stocks with Competitive Advantages and 1 We Find Risky StockStory","title":"2 Mooning Semiconductor Stocks with Competitive Advantages and 1 We Find Risky - StockStory","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_7435a9d3ee06 in signals