Tuscaloosa YouTube catalog gap (Jul–Oct 2026)
Issue: #562.
Cause
The City of Tuscaloosa channel (UC74dczS0B3MhDhUHp2ZGRPA) did post through July–October 2026. A live YouTube Data API listing of the uploads playlist for 2026-06-23 through 2026-11-15 returned 102 videos; 100 were missing from bronze.bronze_event_youtube on 2026-11-19. Month counts on YouTube included Jul 22, Aug 24, Sep 20, Oct 26.
The gap was discovery not scanning this channel during that window (not “the channel went quiet”). Other jurisdictions continued to receive transcripts in the same months.
Fix path
- Catalog backfill via Data API (no youtube.com HTML):
python -m scrapers.youtube.backfill_channel_from_api --channel-id UC74dczS0B3MhDhUHp2ZGRPA ... - Transcripts still need the VPN-guarded scraper path (
load_youtube_for_jurisdictionwith Surfshark up). channel_typealiases (municipality/unknown) normalize tomunicipalat write time and via a one-shot bronze update.- dbt singular test
assert_government_channel_catalog_freshness_45dflags government channels with no catalog video for 45+ days.