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/CBMie0FVX3lxTE41RUlkZnVJbXBCblh0bnduWVNzVW56Y1lLd043aFlkXzhfNXJ5b0pCNzhBdmlWcFNORjdBWWFVbHphNGp3Ty1pQTZpLVJNc2p2ekp0X19qU3B0aEtia25HVldvQ2VkdEh1ZFUzVFV6WmJ4aVpWVHQ2T1BMTQ?oc=5","as_of":"2026-04-13T13:18:39.839599+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/CBMie0FVX3lxTE41RUlkZnVJbXBCblh0bnduWVNzVW56Y1lLd043aFlkXzhfNXJ5b0pCNzhBdmlWcFNORjdBWWFVbHphNGp3Ty1pQTZpLVJNc2p2ekp0X19qU3B0aEtia25HVldvQ2VkdEh1ZFUzVFV6WmJ4aVpWVHQ2T1BMTQ?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_034fcc472d04597f","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-13T16:22:31.732428+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTE41RUlkZnVJbXBCblh0bnduWVNzVW56Y1lLd043aFlkXzhfNXJ5b0pCNzhBdmlWcFNORjdBWWFVbHphNGp3Ty1pQTZpLVJNc2p2ekp0X19qU3B0aEtia25HVldvQ2VkdEh1ZFUzVFV6WmJ4aVpWVHQ2T1BMTQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTE41RUlkZnVJbXBCblh0bnduWVNzVW56Y1lLd043aFlkXzhfNXJ5b0pCNzhBdmlWcFNORjdBWWFVbHphNGp3Ty1pQTZpLVJNc2p2ekp0X19qU3B0aEtia25HVldvQ2VkdEh1ZFUzVFV6WmJ4aVpWVHQ2T1BMTQ?oc=5","source_event_id":"evt_662a481af240","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"8b2f1775471114fd","published_at":"2026-04-13T12:52:43+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Goldman Sachs","relevance":"high","symbol":"","type":"company"},{"asset_class":"media","name":"The New York Times","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["No article text is provided, so the specific earnings impacts, magnitude, timing, and which other companies (if any) are not stated.","No details are given on the mechanism (e.g., markets, costs, sanctions, energy, insurance) or whether the impact is positive/negative for Goldman Sachs.","No near-term catalyst timing beyond the phrase 'starting with Goldman Sachs' is available."],"key_facts":["NYT headline indicates Iran-war effects are emerging in company earnings.","The first company mentioned is Goldman Sachs."],"numeric_claims":[],"primary_claim":"Effects of the Iran war are emerging in company earnings, starting with Goldman Sachs.","relevance_score":0.62,"sentiment":"mixed","source_quality":"unknown","summary":"The New York Times reports that impacts from the Iran war are beginning to show up in company earnings, with Goldman Sachs identified as an early example.","topics":["Iran war","company earnings","Goldman Sachs","geopolitical risk"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Effects of Iran War Emerge in Company Earnings, Starting With Goldman Sachs The New York Times","title":"Effects of Iran War Emerge in Company Earnings, Starting With Goldman Sachs - The New York Times","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_89fae3f53697 in signals