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/CBMi2AFBVV95cUxNZnVTeGV6V0V1ZEg2TlNyaXd1dXhyQW8wOVdZRURSaHEtLUR5bUlQejYwdzMyQkFPWlRiWXF5ek5WWG00eldnREt3LTVNQVNDaHQ5QkpQNWVWVThOcWFyeldhXzA2TlhyVjVPek5jWEhwSWFmZS1zak5nOGttTTBQV0pfNUhHTXJEWndISVcyNk9NbmMyUDd3RXRYbDNJb1Z3Qldza0liTG9velJXZHVQcWlGNnlhVVJRWi1iTlRLUE5jSTR6Mkk5anNZSl9HM2R0cFcxU0NpcWE?oc=5","as_of":"2026-04-08T01:28:20.250011+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/CBMi2AFBVV95cUxNZnVTeGV6V0V1ZEg2TlNyaXd1dXhyQW8wOVdZRURSaHEtLUR5bUlQejYwdzMyQkFPWlRiWXF5ek5WWG00eldnREt3LTVNQVNDaHQ5QkpQNWVWVThOcWFyeldhXzA2TlhyVjVPek5jWEhwSWFmZS1zak5nOGttTTBQV0pfNUhHTXJEWndISVcyNk9NbmMyUDd3RXRYbDNJb1Z3Qldza0liTG9velJXZHVQcWlGNnlhVVJRWi1iTlRLUE5jSTR6Mkk5anNZSl9HM2R0cFcxU0NpcWE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_59aa8be41091ed18","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-08T01:28:37.591349+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi2AFBVV95cUxNZnVTeGV6V0V1ZEg2TlNyaXd1dXhyQW8wOVdZRURSaHEtLUR5bUlQejYwdzMyQkFPWlRiWXF5ek5WWG00eldnREt3LTVNQVNDaHQ5QkpQNWVWVThOcWFyeldhXzA2TlhyVjVPek5jWEhwSWFmZS1zak5nOGttTTBQV0pfNUhHTXJEWndISVcyNk9NbmMyUDd3RXRYbDNJb1Z3Qldza0liTG9velJXZHVQcWlGNnlhVVJRWi1iTlRLUE5jSTR6Mkk5anNZSl9HM2R0cFcxU0NpcWE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"9news.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi2AFBVV95cUxNZnVTeGV6V0V1ZEg2TlNyaXd1dXhyQW8wOVdZRURSaHEtLUR5bUlQejYwdzMyQkFPWlRiWXF5ek5WWG00eldnREt3LTVNQVNDaHQ5QkpQNWVWVThOcWFyeldhXzA2TlhyVjVPek5jWEhwSWFmZS1zak5nOGttTTBQV0pfNUhHTXJEWndISVcyNk9NbmMyUDd3RXRYbDNJb1Z3Qldza0liTG9velJXZHVQcWlGNnlhVVJRWi1iTlRLUE5jSTR6Mkk5anNZSl9HM2R0cFcxU0NpcWE?oc=5","source_event_id":"evt_45d8f7c3e431","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4188999e978beaa8","published_at":"2026-04-08T01:17:00+00:00","publisher_domain":"9news.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Colorado","relevance":"high","symbol":"","type":"jurisdiction"},{"asset_class":"","name":"Parents","relevance":"high","symbol":"","type":"affected_group"},{"asset_class":"","name":"\u201ckidfluencer\u201d earnings","relevance":"high","symbol":"","type":"earnings_category"},{"asset_class":"","name":"Trust accounts","relevance":"high","symbol":"","type":"legal_financial_structure"},{"asset_class":"","name":"9news.com","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"regulation","information_gaps":["The article text provided contains no additional details beyond the headline/source summary.","Unclear whether the bill is proposed, passed, or at what stage.","Unclear the effective date and enforcement mechanism.","Unclear how \u201ckidfluencer\u201d is defined in the bill.","Unclear whether the requirement applies to all parents/children or only specific circumstances.","No details provided on penalties, exemptions, or administrative process."],"key_facts":["The signal references a Colorado bill.","The bill would require parents to share \u201ckidfluencer\u201d earnings in trust accounts.","The information is attributed to 9news.com."],"numeric_claims":[],"primary_claim":"The Colorado bill would require parents to share \u201ckidfluencer\u201d earnings in trust accounts.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"A Colorado bill would require parents to place earnings from \u201ckidfluencer\u201d activities into trust accounts and share those earnings under the bill\u2019s requirements, according to 9news.com.","topics":["Colorado legislation","parental obligations","trust accounts","\u201ckidfluencer\u201d earnings","consumer/child media earnings"]},"source":"9news.com","source_domain":"9news.com","source_url":"https://www.9news.com","summary":"Colorado bill would require parents to share 'kidfluencer' earnings in trust accounts 9news.com","title":"Colorado bill would require parents to share 'kidfluencer' earnings in trust accounts - 9news.com","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_8515ab0b4afe in signals