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/CBMi6wFBVV95cUxPblR2UkN1dkR0QXUyeUJuSDgxTEJhWWlfUlRsRG9EeXM4QlBFY0VPbm1EbDUwOEM3aFZ0eHJNamQ4YUVaOFBtNGtpMTZPMjhDYUo2V0xlUFBqSjNNYXVUSzhFUHRSSnc3SnVPYnE0WHVBN1hpSVBqTmVfZXg1cWFlUnJOWmlwa1ZsamZCeTdCTDFhMG51UXNjQVotMmUxSDBpNTBzaE5PdmRlNVByV1NuUktJdkZrbDZEQzQzSlNZYVY0ekVHZHh1aW5iZ2ZZUDlQbkJNZklLRkVuNjZ4NS16a2d6cV93dHV0OVBJ?oc=5","as_of":"2026-04-20T21:37:11.423402+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.66Y3bu-8kXQ.L.X.O/am=GAIFAgCAA2YBAwpA/d=1/ed=1/rs=ALs0n2OvQgcBFbGEQHisaePTgNFsUePnGA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMi6wFBVV95cUxPblR2UkN1dkR0QXUyeUJuSDgxTEJhWWlfUlRsRG9EeXM4QlBFY0VPbm1EbDUwOEM3aFZ0eHJNamQ4YUVaOFBtNGtpMTZPMjhDYUo2V0xlUFBqSjNNYXVUSzhFUHRSSnc3SnVPYnE0WHVBN1hpSVBqTmVfZXg1cWFlUnJOWmlwa1ZsamZCeTdCTDFhMG51UXNjQVotMmUxSDBpNTBzaE5PdmRlNVByV1NuUktJdkZrbDZEQzQzSlNZYVY0ekVHZHh1aW5iZ2ZZUDlQbkJNZklLRkVuNjZ4NS16a2d6cV93dHV0OVBJ?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_2f16e1436c4fe163","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.66Y3bu-8kXQ.L.X.O/am=GAIFAgCAA2YBAwpA/d=1/ed=1/rs=ALs0n2OvQgcBFbGEQHisaePTgNFsUePnGA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T03:03:30.672035+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi6wFBVV95cUxPblR2UkN1dkR0QXUyeUJuSDgxTEJhWWlfUlRsRG9EeXM4QlBFY0VPbm1EbDUwOEM3aFZ0eHJNamQ4YUVaOFBtNGtpMTZPMjhDYUo2V0xlUFBqSjNNYXVUSzhFUHRSSnc3SnVPYnE0WHVBN1hpSVBqTmVfZXg1cWFlUnJOWmlwa1ZsamZCeTdCTDFhMG51UXNjQVotMmUxSDBpNTBzaE5PdmRlNVByV1NuUktJdkZrbDZEQzQzSlNZYVY0ekVHZHh1aW5iZ2ZZUDlQbkJNZklLRkVuNjZ4NS16a2d6cV93dHV0OVBJ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"whitehouse.gov","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi6wFBVV95cUxPblR2UkN1dkR0QXUyeUJuSDgxTEJhWWlfUlRsRG9EeXM4QlBFY0VPbm1EbDUwOEM3aFZ0eHJNamQ4YUVaOFBtNGtpMTZPMjhDYUo2V0xlUFBqSjNNYXVUSzhFUHRSSnc3SnVPYnE0WHVBN1hpSVBqTmVfZXg1cWFlUnJOWmlwa1ZsamZCeTdCTDFhMG51UXNjQVotMmUxSDBpNTBzaE5PdmRlNVByV1NuUktJdkZrbDZEQzQzSlNZYVY0ekVHZHh1aW5iZ2ZZUDlQbkJNZklLRkVuNjZ4NS16a2d6cV93dHV0OVBJ?oc=5","source_event_id":"evt_205df7628170","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"259693ad39430a59","published_at":"2026-04-20T19:05:31+00:00","publisher_domain":"whitehouse.gov","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.42,"dates_mentioned":[],"entities":[],"event_type":"other","information_gaps":["article_text_unavailable"],"key_facts":["Headline: President Trump\u2019s Landmark Order Advances Breakthrough Mental Health Treatments \u2014 Delivering New Hope to Veterans - The White House (.gov)","Source summary: President Trump\u2019s Landmark Order Advances Breakthrough Mental Health Treatments \u2014 Delivering New Hope to Veterans The White House (.gov) How Trump's psychedelics executive order could unlock stalled cannabis reform CNBC Trump Signs Executive Order to Loosen Restrictions on Psychedelic Drugs The New York Times Psychedelic drug developers rally after Trump orders FDA to expedite reviews Reuters Trump Signs Psychedelic "],"numeric_claims":[],"primary_claim":"President Trump\u2019s Landmark Order Advances Breakthrough Mental Health Treatments \u2014 Delivering New Hope to Veterans - The White House (.gov)","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"President Trump\u2019s Landmark Order Advances Breakthrough Mental Health Treatments \u2014 Delivering New Hope to Veterans The White House (.gov) How Trump's psychedelics executive order could unlock stalled cannabis reform CNBC Trump Signs Executive Order to Loosen Restrictions on Psychedelic Drugs The New York Times Psychedelic drug developers rally after Trump orders FDA to expedite reviews Reuters Trum","topics":["news headline"]},"source":"The White House (.gov)","source_domain":"whitehouse.gov","source_url":"https://www.whitehouse.gov","summary":"President Trump\u2019s Landmark Order Advances Breakthrough Mental Health Treatments \u2014 Delivering New Hope to Veterans The White House (.gov) How Trump's psychedelics executive order could unlock stalled cannabis reform CNBC Trump Signs Executive Order to Loosen Restrictions on Psychedelic Drugs The New York Times Psychedelic drug developers rally after Trump orders FDA to expedite reviews Reuters Trump Signs Psychedelic Drugs Order. 4 Stocks That Are Surging. Barron's","title":"President Trump\u2019s Landmark Order Advances Breakthrough Mental Health Treatments \u2014 Delivering New Hope to Veterans - The White House (.gov)","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.66Y3bu-8kXQ.L.X.O/am=GAIFAgCAA2YBAwpA/d=1/ed=1/rs=ALs0n2OvQgcBFbGEQHisaePTgNFsUePnGA/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_12ecd50ba310 in signals