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/CBMinwFBVV95cUxOUFF3akxxVjRtZUUyZGJqcDVkWnRZcVgxLVQ2LWlneW5zZ3lkMWlad1dLSTlVX3VKX2dGeFI3aFFrYnNxZS1WQTR5aGwyT2RpSjlQQVE4VGV4Z0hsWjV3MDMxdG5UTEY5dmJuWVVZYmV1ZVNJajdGeEI1emNocDk0RENCWjZLQlVYOFBwbGxya0JsV0VLS1dnSDNCaUpVMEE?oc=5","as_of":"2026-04-10T05:39:04.792338+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/CBMinwFBVV95cUxOUFF3akxxVjRtZUUyZGJqcDVkWnRZcVgxLVQ2LWlneW5zZ3lkMWlad1dLSTlVX3VKX2dGeFI3aFFrYnNxZS1WQTR5aGwyT2RpSjlQQVE4VGV4Z0hsWjV3MDMxdG5UTEY5dmJuWVVZYmV1ZVNJajdGeEI1emNocDk0RENCWjZLQlVYOFBwbGxya0JsV0VLS1dnSDNCaUpVMEE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_241e19fe33a42b66","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:39:55.823424+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMinwFBVV95cUxOUFF3akxxVjRtZUUyZGJqcDVkWnRZcVgxLVQ2LWlneW5zZ3lkMWlad1dLSTlVX3VKX2dGeFI3aFFrYnNxZS1WQTR5aGwyT2RpSjlQQVE4VGV4Z0hsWjV3MDMxdG5UTEY5dmJuWVVZYmV1ZVNJajdGeEI1emNocDk0RENCWjZLQlVYOFBwbGxya0JsV0VLS1dnSDNCaUpVMEE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"meyka.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMinwFBVV95cUxOUFF3akxxVjRtZUUyZGJqcDVkWnRZcVgxLVQ2LWlneW5zZ3lkMWlad1dLSTlVX3VKX2dGeFI3aFFrYnNxZS1WQTR5aGwyT2RpSjlQQVE4VGV4Z0hsWjV3MDMxdG5UTEY5dmJuWVVZYmV1ZVNJajdGeEI1emNocDk0RENCWjZLQlVYOFBwbGxya0JsV0VLS1dnSDNCaUpVMEE?oc=5","source_event_id":"evt_be5643db037a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e04260ddeebd77a7","published_at":"2026-04-10T05:07:21+00:00","publisher_domain":"meyka.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":["April 10"],"entities":[{"asset_class":"equity","name":"Z74.SI","relevance":"high","symbol":"Z74.SI","type":"stock"},{"asset_class":"unknown","name":"Meyka","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["No article body content was provided (the cleaned text appears to be unrelated CSS/HTML), so the mechanism and implications of the \u201cCPF-to-CDP shift\u201d are not described.","Unclear what \u201cin play\u201d means operationally (e.g., trading eligibility, settlement, transfer, or liquidity impact).","No confirmation of whether Z74.SI is the only affected security or whether other tickers are involved.","No details on who the \u201c615k holders\u201d are (retail vs institutional, beneficial owners vs registered holders).","No quantitative market impact (price/volume) is provided in the provided text."],"key_facts":["Headline references \u201cZ74.SI Stock Today: April 10 CPF-to-CDP Shift Puts 615k Holders in Play - Meyka.\u201d","The date mentioned is April 10.","The headline states \u201c615k holders\u201d are \u201cin play\u201d due to a \u201cCPF-to-CDP shift.\u201d"],"numeric_claims":[{"label":"holders_in_play","value":"615k"}],"primary_claim":"On April 10, a CPF-to-CDP shift will put 615k holders in play for Z74.SI (as stated in the Meyka headline).","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"The article headline says a \u201cCPF-to-CDP shift\u201d on April 10 will put 615k holders of Z74.SI stock in play, citing Meyka.","topics":["CPF-to-CDP shift","holder count","Z74.SI","April 10","market-moving corporate/market action (implied)"]},"source":"Meyka","source_domain":"meyka.com","source_url":"https://meyka.com","summary":"","tickers":[],"title":"Z74.SI Stock Today: April 10 CPF-to-CDP Shift Puts 615k Holders in Play - Meyka","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_5c924a298cc0 in signals