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/CBMijgFBVV95cUxPR1dFYWwyU0ZmeFNwcTVqZVpkZC1nejhCbGlKMUJaZXJFQ0s3ekdGV1dRQnJJNE41RXRwb3hVWXpBSU1sd0dYRWY4OG9VQ1RjbGhpVWR0UGRQdTJVVThSNFpaakJacXItdXFUbGdZMm5HWmtLcmRLckcwWThHTngyb0FWREVrRDZTY1BLLWFR?oc=5","as_of":"2026-04-13T01:48:35.745484+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/CBMijgFBVV95cUxPR1dFYWwyU0ZmeFNwcTVqZVpkZC1nejhCbGlKMUJaZXJFQ0s3ekdGV1dRQnJJNE41RXRwb3hVWXpBSU1sd0dYRWY4OG9VQ1RjbGhpVWR0UGRQdTJVVThSNFpaakJacXItdXFUbGdZMm5HWmtLcmRLckcwWThHTngyb0FWREVrRDZTY1BLLWFR?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_62c674871edd90b6","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-13T02:14:22.237340+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxPR1dFYWwyU0ZmeFNwcTVqZVpkZC1nejhCbGlKMUJaZXJFQ0s3ekdGV1dRQnJJNE41RXRwb3hVWXpBSU1sd0dYRWY4OG9VQ1RjbGhpVWR0UGRQdTJVVThSNFpaakJacXItdXFUbGdZMm5HWmtLcmRLckcwWThHTngyb0FWREVrRDZTY1BLLWFR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"barrons.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxPR1dFYWwyU0ZmeFNwcTVqZVpkZC1nejhCbGlKMUJaZXJFQ0s3ekdGV1dRQnJJNE41RXRwb3hVWXpBSU1sd0dYRWY4OG9VQ1RjbGhpVWR0UGRQdTJVVThSNFpaakJacXItdXFUbGdZMm5HWmtLcmRLckcwWThHTngyb0FWREVrRDZTY1BLLWFR?oc=5","source_event_id":"evt_007b14dc5334","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"2153f5b558bd210f","published_at":"2026-04-13T01:12:00+00:00","publisher_domain":"barrons.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"JPMorgan","relevance":"high","symbol":"","type":"company"},{"asset_class":"equity","name":"Other banks","relevance":"medium","symbol":"","type":"group"}],"event_type":"earnings","information_gaps":["No specific earnings date/time is provided.","No other bank names are provided beyond \u201cother banks.\u201d","No details are provided on what specifically constitutes the \u201cwall of worry.\u201d","No article text is available, so no additional grounded facts (e.g., guidance, estimates, risks) can be extracted."],"key_facts":["Barron\u2019s headline states JPMorgan and other banks are set to report earnings.","The headline references a \u201cwall of worry\u201d looming."],"numeric_claims":[],"primary_claim":"JPMorgan and other banks are scheduled to report earnings as a \u201cwall of worry\u201d looms.","relevance_score":0.62,"sentiment":"mixed","source_quality":"unknown","summary":"Barron\u2019s reports that JPMorgan and other banks are set to report earnings, with a \u201cwall of worry\u201d looming.","topics":["bank earnings","market uncertainty","earnings reporting"]},"source":"Barron's","source_domain":"barrons.com","source_url":"https://www.barrons.com","summary":"JPMorgan and Other Banks Set to Report Earnings as \u2018Wall of Worry\u2019 Looms Barron's","title":"JPMorgan and Other Banks Set to Report Earnings as \u2018Wall of Worry\u2019 Looms - Barron's","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_78df81559bc1 in signals