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/CBMipgFBVV95cUxPbGxrQ1liNmtjMzFENDdFaXhsV3luN0NXS0FnaEdsSk1xa25CeldjdWdfbUFGdmJKNlg5aHEwckx3X1pYdVUydUpvVXhtd1QxNlVzS3paTHNHS3NaUlN4b29INXpYeFAzb3NrLVZwQnhoQ0dTSGxTSE5kRlNWRm1zNjVTUHlzaWttWmJpUXJJZ2hMYnllTTY1Ymt4X3dYOWthX1RBbm930gGrAUFVX3lxTE80eFRDRlM1Rjl6RFJ4QVBHSTVvWS1vNVptd3ZZTzM0QzJ5Ym8wVHJjMjE4Ry1UYmVwZEJ0OENJdHB5ZnNTcTBHN1QyOHVTUkJralU0enJSQzRYeE5TSlRjQ3FqckJ1Z0xMSEh5bXd6bmZqQi1WYnBiM09EZThnVzBmX2hzNjRjZGRnbkFBQjFZM3FpOTR2ZGFsTlFmWUlXbDJ5RGJBYnEtZENSbw?oc=5","as_of":"2026-04-10T00:52:01.445783+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/CBMipgFBVV95cUxPbGxrQ1liNmtjMzFENDdFaXhsV3luN0NXS0FnaEdsSk1xa25CeldjdWdfbUFGdmJKNlg5aHEwckx3X1pYdVUydUpvVXhtd1QxNlVzS3paTHNHS3NaUlN4b29INXpYeFAzb3NrLVZwQnhoQ0dTSGxTSE5kRlNWRm1zNjVTUHlzaWttWmJpUXJJZ2hMYnllTTY1Ymt4X3dYOWthX1RBbm930gGrAUFVX3lxTE80eFRDRlM1Rjl6RFJ4QVBHSTVvWS1vNVptd3ZZTzM0QzJ5Ym8wVHJjMjE4Ry1UYmVwZEJ0OENJdHB5ZnNTcTBHN1QyOHVTUkJralU0enJSQzRYeE5TSlRjQ3FqckJ1Z0xMSEh5bXd6bmZqQi1WYnBiM09EZThnVzBmX2hzNjRjZGRnbkFBQjFZM3FpOTR2ZGFsTlFmWUlXbDJ5RGJBYnEtZENSbw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_86361df54d8f1312","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-10T00:59:29.013306+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxPbGxrQ1liNmtjMzFENDdFaXhsV3luN0NXS0FnaEdsSk1xa25CeldjdWdfbUFGdmJKNlg5aHEwckx3X1pYdVUydUpvVXhtd1QxNlVzS3paTHNHS3NaUlN4b29INXpYeFAzb3NrLVZwQnhoQ0dTSGxTSE5kRlNWRm1zNjVTUHlzaWttWmJpUXJJZ2hMYnllTTY1Ymt4X3dYOWthX1RBbm930gGrAUFVX3lxTE80eFRDRlM1Rjl6RFJ4QVBHSTVvWS1vNVptd3ZZTzM0QzJ5Ym8wVHJjMjE4Ry1UYmVwZEJ0OENJdHB5ZnNTcTBHN1QyOHVTUkJralU0enJSQzRYeE5TSlRjQ3FqckJ1Z0xMSEh5bXd6bmZqQi1WYnBiM09EZThnVzBmX2hzNjRjZGRnbkFBQjFZM3FpOTR2ZGFsTlFmWUlXbDJ5RGJBYnEtZENSbw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cbsnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxPbGxrQ1liNmtjMzFENDdFaXhsV3luN0NXS0FnaEdsSk1xa25CeldjdWdfbUFGdmJKNlg5aHEwckx3X1pYdVUydUpvVXhtd1QxNlVzS3paTHNHS3NaUlN4b29INXpYeFAzb3NrLVZwQnhoQ0dTSGxTSE5kRlNWRm1zNjVTUHlzaWttWmJpUXJJZ2hMYnllTTY1Ymt4X3dYOWthX1RBbm930gGrAUFVX3lxTE80eFRDRlM1Rjl6RFJ4QVBHSTVvWS1vNVptd3ZZTzM0QzJ5Ym8wVHJjMjE4Ry1UYmVwZEJ0OENJdHB5ZnNTcTBHN1QyOHVTUkJralU0enJSQzRYeE5TSlRjQ3FqckJ1Z0xMSEh5bXd6bmZqQi1WYnBiM09EZThnVzBmX2hzNjRjZGRnbkFBQjFZM3FpOTR2ZGFsTlFmWUlXbDJ5RGJBYnEtZENSbw?oc=5","source_event_id":"evt_c0b147030720","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"170c149c5b9e1c76","published_at":"2026-04-10T00:02:00+00:00","publisher_domain":"cbsnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"","name":"White House staff","relevance":"primary subject of the warning","symbol":"","type":"group"},{"asset_class":"","name":"White House","relevance":"context for where the email was sent","symbol":"","type":"government body"},{"asset_class":"","name":"Prediction markets","relevance":"the activity staff were warned not to bet on","symbol":"","type":"market mechanism"},{"asset_class":"","name":"CBS News","relevance":"source of the report","symbol":"","type":"media outlet"}],"event_type":"regulation","information_gaps":["The article text provided here does not include the email\u2019s date, sender, or exact wording.","No details are provided on which prediction markets were referenced.","The rationale for the warning (e.g., ethics, conflicts of interest, legal compliance) is not included in the provided text.","No information is provided on whether the warning affects specific offices/roles or has enforcement consequences.","Near-term catalyst timing for markets is not specified in the provided text."],"key_facts":["CBS News reports that White House staff received an email warning them not to place bets on prediction markets.","Officials told CBS News about the email warning."],"numeric_claims":[],"primary_claim":"White House staff received an email warning them not to place bets on prediction markets, according to officials cited by CBS News.","relevance_score":0.42,"sentiment":"neutral","source_quality":"high","summary":"CBS News reports that White House staff received an email warning them not to place bets on prediction markets. The warning was described by officials to CBS News.","topics":["prediction markets","White House communications","ethics/compliance","government staff guidance"]},"source":"CBS News","source_domain":"cbsnews.com","source_url":"https://www.cbsnews.com","summary":"White House staff received email warning them not to place bets on prediction markets, officials say CBS News","title":"White House staff received email warning them not to place bets on prediction markets, officials say - CBS News","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_7f12e3ca0430 in signals