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/CBMiiwFBVV95cUxQMndpOVNkTXFnb1dTd0t3QXZpT0RvcmVOUjBkRmgwaGRMWU84Wko3cmo5ZS14MFlxcEUxNzFoblR0NmNuSmRCa3FSSGFoNmZscDAxNUxFWGVrTkJBeVZseTN1RkEzRVB5LWd6M0c5NmhFYlpKZ3FZQkkxbldZNUl3Q1o4TTF6UklnSGM0?oc=5","as_of":"2026-04-10T13:38:20.341367+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/CBMiiwFBVV95cUxQMndpOVNkTXFnb1dTd0t3QXZpT0RvcmVOUjBkRmgwaGRMWU84Wko3cmo5ZS14MFlxcEUxNzFoblR0NmNuSmRCa3FSSGFoNmZscDAxNUxFWGVrTkJBeVZseTN1RkEzRVB5LWd6M0c5NmhFYlpKZ3FZQkkxbldZNUl3Q1o4TTF6UklnSGM0?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_c5331af718989621","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-10T13:39:07.006128+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxQMndpOVNkTXFnb1dTd0t3QXZpT0RvcmVOUjBkRmgwaGRMWU84Wko3cmo5ZS14MFlxcEUxNzFoblR0NmNuSmRCa3FSSGFoNmZscDAxNUxFWGVrTkJBeVZseTN1RkEzRVB5LWd6M0c5NmhFYlpKZ3FZQkkxbldZNUl3Q1o4TTF6UklnSGM0?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"pitchfork.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxQMndpOVNkTXFnb1dTd0t3QXZpT0RvcmVOUjBkRmgwaGRMWU84Wko3cmo5ZS14MFlxcEUxNzFoblR0NmNuSmRCa3FSSGFoNmZscDAxNUxFWGVrTkJBeVZseTN1RkEzRVB5LWd6M0c5NmhFYlpKZ3FZQkkxbldZNUl3Q1o4TTF6UklnSGM0?oc=5","source_event_id":"evt_e1fa24d8a8b8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"392e6775774a55b5","published_at":"2026-04-10T11:52:35+00:00","publisher_domain":"pitchfork.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["2026"],"entities":[{"asset_class":"other","name":"Coachella","relevance":"high","symbol":"","type":"music_festival"},{"asset_class":"other","name":"YouTube","relevance":"high","symbol":"","type":"platform"},{"asset_class":"other","name":"Pitchfork","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"Sabrina Carpenter","relevance":"medium","symbol":"","type":"artist"},{"asset_class":"other","name":"Devo","relevance":"medium","symbol":"","type":"artist"}],"event_type":"listing","information_gaps":["The provided article text is not actually present (only CSS/HTML boilerplate), so the exact schedule times, dates, and full lineup are not verifiable from the supplied content.","The specific YouTube channel/URL and whether the schedule covers multiple days beyond Day 1 are not confirmed from the provided text.","The source summary mentions other outlets (Yahoo, USA Today, Los Angeles Times), but their specific claims are not independently extracted here."],"key_facts":["Pitchfork published an article titled along the lines of \u201cCoachella 2026 YouTube Live Stream Schedule & Details.\u201d","The article is described as covering how to watch Coachella 2026 via YouTube livestreams.","The coverage includes a Day 1 livestream schedule.","The livestream coverage is said to include performances by Sabrina Carpenter and Devo (as examples mentioned in the provided source summary)."],"numeric_claims":[],"primary_claim":"Pitchfork\u2019s Coachella 2026 guide provides the YouTube livestream schedule and viewing details for Day 1, featuring artists such as Sabrina Carpenter and Devo.","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"Pitchfork published details for Coachella 2026\u2019s \u201cCouch-Chella\u201d YouTube livestream, including how to watch and the Day 1 schedule. The coverage highlights specific artists expected to appear on the livestream (e.g., Sabrina Carpenter and Devo).","topics":["Coachella 2026","livestream schedule","YouTube","music festival viewing","Day 1 livestream","Couch-Chella"]},"source":"Pitchfork","source_domain":"pitchfork.com","source_url":"https://pitchfork.com","summary":"Coachella 2026 YouTube Live Stream Schedule & Details Pitchfork How to watch Sabrina Carpenter, Devo and more on the Coachella Day 1 livestream Yahoo See Coachella 2026 first week lineup, daily schedule, livestream, more USA Today Feeling FOMO That You\u2019re Not At Coachella 2026 This Weekend? Here\u2019s How To Livestream Every Show For \u2018Couch-Chella\u2019 Secret Los Angeles 18 Coachella 2026 acts we can\u2019t wait to see Los Angeles Times","title":"Coachella 2026 YouTube Live Stream Schedule & Details - Pitchfork","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_71ba11aa5740 in signals