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/CBMihwFBVV95cUxObXkwWGdzUDRLUWlkZzFZMnhIWWdPaHhDaXdmYW1EcUQ3UDJDMXc3SUg2b2Z6SXlaV0toWWVNeVgtSVowTXdHM2lQMnp1YnFWUUV2Z3pfNDJDTm5OejVvSVMwZEp0dFBQX09fV3oxbzA0MmJNWlFqRXd5Sm4yOEQ0b1JVVG1vR2s?oc=5","as_of":"2026-04-10T13:32:23.106541+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/CBMihwFBVV95cUxObXkwWGdzUDRLUWlkZzFZMnhIWWdPaHhDaXdmYW1EcUQ3UDJDMXc3SUg2b2Z6SXlaV0toWWVNeVgtSVowTXdHM2lQMnp1YnFWUUV2Z3pfNDJDTm5OejVvSVMwZEp0dFBQX09fV3oxbzA0MmJNWlFqRXd5Sm4yOEQ0b1JVVG1vR2s?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_c535aebc077a9e66","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-10T13:32:59.636420+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxObXkwWGdzUDRLUWlkZzFZMnhIWWdPaHhDaXdmYW1EcUQ3UDJDMXc3SUg2b2Z6SXlaV0toWWVNeVgtSVowTXdHM2lQMnp1YnFWUUV2Z3pfNDJDTm5OejVvSVMwZEp0dFBQX09fV3oxbzA0MmJNWlFqRXd5Sm4yOEQ0b1JVVG1vR2s?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"global.morningstar.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxObXkwWGdzUDRLUWlkZzFZMnhIWWdPaHhDaXdmYW1EcUQ3UDJDMXc3SUg2b2Z6SXlaV0toWWVNeVgtSVowTXdHM2lQMnp1YnFWUUV2Z3pfNDJDTm5OejVvSVMwZEp0dFBQX09fV3oxbzA0MmJNWlFqRXd5Sm4yOEQ0b1JVVG1vR2s?oc=5","source_event_id":"evt_faa99b75507a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"467319575b807532","published_at":"2026-04-10T13:23:19+00:00","publisher_domain":"global.morningstar.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":["Q1"],"entities":[{"asset_class":"","name":"Morningstar Canada","relevance":"high","symbol":"","type":"publisher"},{"asset_class":"equities","name":"US markets","relevance":"medium","symbol":"","type":"market"}],"event_type":"other","information_gaps":["The six charts themselves are not present in the provided text, so no specific assets/tickers, sectors, or price/return moves can be extracted.","No directionality (trend continuation vs reversal) or magnitude (percent moves, levels) is available from the supplied content.","The \u201cSource Summary\u201d field is empty, and the provided article text appears to be largely HTML/CSS rather than readable article body content."],"key_facts":["The provided headline is: \u201c6 Charts That Defined US Markets in Q1 - Morningstar Canada.\u201d","The article is described as defining/influential for US markets in Q1.","No additional article content (beyond HTML/CSS) includes specific chart details, asset tickers, or quantified market outcomes."],"numeric_claims":[],"primary_claim":"Morningstar Canada published an article titled \u201c6 Charts That Defined US Markets in Q1,\u201d covering US market-defining charts from Q1.","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"The headline indicates an article by Morningstar Canada listing six charts that were influential for US markets during Q1. No specific charts, tickers, or market moves are provided in the supplied text.","topics":["US markets","Q1","charts","market performance context"]},"source":"Morningstar Canada","source_domain":"global.morningstar.com","source_url":"https://global.morningstar.com","summary":"","tickers":[],"title":"6 Charts That Defined US Markets in Q1 - Morningstar Canada","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_227cfdc00d0b in signals