💃🕺 BachataLibrary
Partners ▾
All partners → Claire 7 Emely 11 Erika 3 Janel 52 Jess 1 Joey 4 Xun 3
Boot camp ▾
All sessions → Musicality in partner work 25 Musicality in footwork 20 Musicality in body movement 20 Timing moves for musicality 14 Lyrics vs instruments 6
Loose ends ▾
All loose ends → 🎵 Songs needing ID ⚠ Song conflicts 📁 Duplicate clusters 📅 Missing dates 🏷 Event-type vocab drift 🗑 Orphan concepts & creators 🎯 Missing classifications 👤 Missing teacher 🖼 Suspicious thumbnails 🎤 Transcripts to review 📊 Coverage gaps 🕒 Recent ingest changes 🩺 Data-quality audit 📦 Compression compare 👥 Visitor log 🔗 Friend invites

Data quality audit

Re-runs every check live on each visit. Companion to docs/DATA_QUALITY_AUDIT_2026-05-03.md.

5 OK 3 low 2 medium

Active videos with file missing on disk

0 / 1284

Active videos with NULL parsed_date

55 / 1284

Backfill pipeline runs from IG/YT JSON sidecars; check Backups/v41-... for snapshot.

vid 148
SnapInsta.to_AQNSXBzhUPnDYXVZWc7Cp0bicd15Icq2EzdxcdvLOjXss7RQWeD_OFmgRvmQ3GEh_fs
vid 185
ebceb2bb-a6a4-45fb-ba97-96f74ddb93cf.MP4
vid 197
26316a8d-7987-4c05-ac9d-09be3267863b.MP4
vid 199
Week 4.MP4
vid 216
Seena and Joey at Joliet.mp4
vid 912
Windmill.mp4
vid 946
Impulso Nicole styling.mp4
vid 1181
Bachata - Bo Kai - Leaders Choreo - 1B - Counts 2 (8sec of hell) (Jerry).mp4
… and 47 more

Active videos with NULL duration_seconds

0 / 1284

videos_fts row count vs active videos

56 / 1284

FTS rows: 1340, active videos: 1284

Concepts with 0 linked active videos

100 / 175

These are filtered out of UI dropdowns. Optional cleanup.

  • "It's perfect", "horible", "How do you say feo?", "let's go!", "let her enjoy", "come with me" -Alan "Why not?" -Luis "meow", "ayyyyy" -Joe
  • 2-count Media straight to shadow body rolls of the above bullet.
  • Abrupt tunnel
  • Alan y Pati’s class on 2023-01-10 https://www.instagram.com/reel/Cn7nKOjgQnR/ (@xyz sec)
  • Alan y Pati’s class on 2023-01-24 Alan y Pati’s class on 2023-02-28 https://www.instagram.com/reel/Cneve8UB3PO/ (@xyz sec) https://www.instagram.com/reel/CqRtwf0t0nQ/
  • Alan y Pati’s class on 2023-02-28 https://www.instagram.com/reel/Cneve8UB3PO/ (@xyz sec)
  • Anytime - Bajo bajo
  • Anytime - Basso delay
  • Anytime - Patín
  • Anytime - Rond de jambe ("round of the leg")
  • … and 90 more

Creators with 0 linked active videos

4 / 28
  • Baychata
  • Cisco y Michelle
  • Emely
  • Joe y Nicole

Distinct parsed_event_type values out of vocab

110 / 110

Pollutes facet space. Either extend config/vocab.yaml or normalize at ingest.

#1 #2 #3 #4 #xyz 1A BREAKDOWN 1A BREAKDOWN (angle 1) Madrid 1A BREAKDOWN (angle 2) 1B DEMO (angle 1) 1B DEMO (angle 2) 1B EXPLANATION 27thmojo story 2A BREAKDOWN 2A BREAKDOWN (angle 1) (Windmill) 2A BREAKDOWN (angle 2.1) 2A BREAKDOWN (angle 2.2) 2A DEMO (angle 1) 2A EXPLANATION 2C MUSIC 2D Turn footwork 3A BREAKDOWN 3A BREAKDOWN (Pushback) 3B DEMO 4A BREAKDOWN 4B DEMO 5A BREAKDOWN 5A EXPLANATION 5B DEMO 6A BREAKDOWN 6A BREAKDOWN (Wrapped hands to Hand Swing) + 80 more

.mkv files (browser-incompatible container)

0 / 1
vid 318
✓ has converted copy — up drill/Bachata PATIN practice： Level Up Your Footwork!.mkv

partner_concepts pointing to dead concepts

0 / 46

Transcripts referencing non-existent videos

0 / 1090

See docs/DATA_QUALITY_AUDIT_2026-05-03.md for the static report and docs/AUDIT_2026-05-03.md for the UI-interaction audit results.