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/CBMia0FVX3lxTFBhY0hTUnY0Zzd1YjNnQ29uNUhVeVMwRTluZ19sd1ROUmxPd1VxSUtkVEwxLWdVTHRrMkZIR1dxY1V5emtvVGh6VGhHTnZlLUF5dGRxVG54YzZJTzVHem5MYlJYY2NZcXNQUEU4?oc=5","as_of":"2026-04-09T06:55:02.688294+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/CBMia0FVX3lxTFBhY0hTUnY0Zzd1YjNnQ29uNUhVeVMwRTluZ19sd1ROUmxPd1VxSUtkVEwxLWdVTHRrMkZIR1dxY1V5emtvVGh6VGhHTnZlLUF5dGRxVG54YzZJTzVHem5MYlJYY2NZcXNQUEU4?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f44f076a3e152aad","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-09T22:49:36.954273+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMia0FVX3lxTFBhY0hTUnY0Zzd1YjNnQ29uNUhVeVMwRTluZ19sd1ROUmxPd1VxSUtkVEwxLWdVTHRrMkZIR1dxY1V5emtvVGh6VGhHTnZlLUF5dGRxVG54YzZJTzVHem5MYlJYY2NZcXNQUEU4?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"9to5google.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMia0FVX3lxTFBhY0hTUnY0Zzd1YjNnQ29uNUhVeVMwRTluZ19sd1ROUmxPd1VxSUtkVEwxLWdVTHRrMkZIR1dxY1V5emtvVGh6VGhHTnZlLUF5dGRxVG54YzZJTzVHem5MYlJYY2NZcXNQUEU4?oc=5","source_event_id":"evt_5cb8804ad225","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a6d33299c09d46fd","published_at":"2026-04-08T21:39:00+00:00","publisher_domain":"9to5google.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"platform","name":"YouTube Shorts","relevance":"directly affected","symbol":"","type":"product"},{"asset_class":"media","name":"9to5Google","relevance":"source of headline","symbol":"","type":"publisher"},{"asset_class":"media","name":"Android Police","relevance":"secondary mention in provided source summary","symbol":"","type":"publisher"},{"asset_class":"media","name":"Times Creators","relevance":"secondary mention in provided source summary","symbol":"","type":"publisher/section (as referenced)"}],"event_type":"other","information_gaps":["The cleaned article text provided contains no readable content about the feature (only page styling/HTML), so details beyond the headline and the short source summary cannot be verified from the provided article text.","No timing (launch date, rollout schedule) is included in the provided headline/summary.","No specifics are provided on requirements (e.g., whether users must opt in, supported languages, limits, or how voice cloning is handled).","No information is provided on availability (regions/devices) or whether the feature is limited to certain creator accounts."],"key_facts":["The headline states that YouTube Shorts will use AI to make avatars that look and sound like the user.","The provided source summary indicates the feature enables creators to add their face and voice to videos (described as \u201cLive Selfie\u201d in the summary).","The provided source summary frames this as a step-by-step/creator workflow for creating AI videos for YouTube Shorts."],"numeric_claims":[],"primary_claim":"YouTube Shorts will use AI to create avatars that look and sound like the user.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"YouTube Shorts is rolling out an AI feature that can generate avatars that resemble a user and can also produce matching voice output. The change is positioned as a creator tool for making AI-assisted Shorts using the creator\u2019s face and voice.","topics":["AI avatars","creator tools","YouTube Shorts","synthetic voice","video generation"]},"source":"9to5Google","source_domain":"9to5google.com","source_url":"https://9to5google.com","summary":"YouTube Shorts will use AI to make avatars that look and sound like you 9to5Google How to Create AI Videos for YouTube Shorts Step-by-Step desdeSoria YouTube Shorts 'AI Avatars' Easily Adds Your Face, Voice to Videos via Live Selfie Tech Times Creators can now use AI versions of themselves to make YouTube Shorts Android Police","title":"YouTube Shorts will use AI to make avatars that look and sound like you - 9to5Google","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_cdb5e78e8db1 in signals