💃🕺 BachataLibrary

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 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

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.