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/CBMiqAFBVV95cUxPNm02R1hHb1dma3EybThXR3QxTk9CUnBucUhHUGRzX3UtazV6SndURk43YWlOcHZLTG9IVVJ2b0tqMnRTVmI1bTBBcmk4X1pGMnAtaFRMaGNUNW9nbUlXdGZDdllqMHVDMWJsbFI3QnBySmRCMEp5YWZkSEloQnAxbVFyelNLOEx6X3AwNmgyRWRTQmJkbnpXTF9QUlFQTkhPVS16dkV3Ymk?oc=5","as_of":"2026-04-10T05:02:39.515454+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/CBMiqAFBVV95cUxPNm02R1hHb1dma3EybThXR3QxTk9CUnBucUhHUGRzX3UtazV6SndURk43YWlOcHZLTG9IVVJ2b0tqMnRTVmI1bTBBcmk4X1pGMnAtaFRMaGNUNW9nbUlXdGZDdllqMHVDMWJsbFI3QnBySmRCMEp5YWZkSEloQnAxbVFyelNLOEx6X3AwNmgyRWRTQmJkbnpXTF9QUlFQTkhPVS16dkV3Ymk?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a0d53595b67cffc9","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-10T05:03:07.776691+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqAFBVV95cUxPNm02R1hHb1dma3EybThXR3QxTk9CUnBucUhHUGRzX3UtazV6SndURk43YWlOcHZLTG9IVVJ2b0tqMnRTVmI1bTBBcmk4X1pGMnAtaFRMaGNUNW9nbUlXdGZDdllqMHVDMWJsbFI3QnBySmRCMEp5YWZkSEloQnAxbVFyelNLOEx6X3AwNmgyRWRTQmJkbnpXTF9QUlFQTkhPVS16dkV3Ymk?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiqAFBVV95cUxPNm02R1hHb1dma3EybThXR3QxTk9CUnBucUhHUGRzX3UtazV6SndURk43YWlOcHZLTG9IVVJ2b0tqMnRTVmI1bTBBcmk4X1pGMnAtaFRMaGNUNW9nbUlXdGZDdllqMHVDMWJsbFI3QnBySmRCMEp5YWZkSEloQnAxbVFyelNLOEx6X3AwNmgyRWRTQmJkbnpXTF9QUlFQTkhPVS16dkV3Ymk?oc=5","source_event_id":"evt_6433e897a866","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"935f01103e965173","published_at":"2026-04-10T04:31:00+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"media","name":"Yahoo Finance","relevance":"high","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The article body content is not provided (only cleaned HTML/CSS), so the specific dividend stock names and any quantitative details are missing.","No information is given about which Asian countries/markets are covered.","No near-term catalyst timing or market impact is stated in the provided text.","No tickers/symbols are available from the provided content."],"key_facts":["Headline: \u201cAsian Dividend Stocks To Consider For Your Portfolio\u201d (Yahoo Finance).","Source summary repeats the same headline text.","No specific companies, tickers, dividend yields, or performance claims are present in the provided article text."],"numeric_claims":[],"primary_claim":"Yahoo Finance published an article recommending \u201cAsian Dividend Stocks To Consider For Your Portfolio.\u201d","relevance_score":0.25,"sentiment":"neutral","source_quality":"high","summary":"Yahoo Finance published an article titled \u201cAsian Dividend Stocks To Consider For Your Portfolio,\u201d presenting dividend-focused stock ideas in Asia. The provided text does not include the specific stock list or any market-moving details.","topics":["Asian dividend stocks","portfolio ideas","equities","dividend investing"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"Asian Dividend Stocks To Consider For Your Portfolio Yahoo Finance","title":"Asian Dividend Stocks To Consider For Your Portfolio - Yahoo Finance","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_7dc10920a3a9 in signals