πŸ’ƒπŸ•Ί 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 15 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 πŸ›‘ Admin (activity + invites) πŸ‘₯ Visitor log

Data quality audit

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

3 OK 4 low 2 medium 1 high

Active videos with file missing on disk

1286 / 1286
vid 1
nsual Bachata/2025-01-09 - DyM - Class - Dbl traveling BR & Walk - BREAKDOWN.mp4
vid 2
/Sensual Bachata/2024-12-10 - JT - Class - Follow as Big Spoon Lateral Waves.mp4
vid 3
edbrickip.com)/z Personal/Sensual Bachata/2025-01-19 - JyS - Practice - 0640.mp4
vid 4
Joriia - Class - OP hip throw, Walking into hair brush rock step - BREAKDOWN.mp4
vid 5
ickip.com)/z Personal/Sensual Bachata/2025-03-13 - Joe - Priv - Janel - 7747.mp4
vid 6
/2025-03-13 - Mariia - Priv - Janel - Example from Joriia class (2025-03-31).mp4
vid 7
Bachata/2025-01-12 - DyM - Priv #2 - Janel - Tilted Turns - Example Trimmed.mp4
vid 8
3 - Joriia - Class - OP hip throw, Walking into hair brush rock step - MUSIC.mp4
… and 1278 more

Active videos with NULL parsed_date

56 / 1286

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

Active videos with NULL duration_seconds

2 / 1286
vid 1345
2026-05-03 Bo Ladies Arm Styling.mp4
vid 1346
DTxtybNCKm2 2of3 copy.mp4

videos_fts row count vs active videos

58 / 1286

FTS rows: 1344, active videos: 1286

Concepts with 0 linked active videos

83 / 159

These are filtered out of UI dropdowns. Optional cleanup.

  • 2-count Media straight to shadow body rolls of the above bullet.
  • Abrupt tunnel
  • Anytime - Bajo bajo
  • Anytime - Basso delay
  • Anytime - PatΓ­n
  • Anytime - Rond de jambe ("round of the leg")
  • Anytime - Syncopated taps+slides+flicks+etc
  • Basic - Lead's styling during basic
  • Body rolls (facing each other)
  • Cha cha cha variation
  • … and 73 more

Creators with 0 linked active videos

20 / 117
  • BachaZouk
  • Bachata Flavour
  • Baychata
  • Bso Latin Dance
  • Cisco y Michelle
  • Daniel Camacho
  • Dickerson Monika
  • Emely
  • … and 12 more

Distinct parsed_event_type values out of vocab

111 / 111

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 (Catapult Arms) 4B DEMO 5A BREAKDOWN 5A EXPLANATION 5B DEMO 6A BREAKDOWN 6A BREAKDOWN (Wrapped hands to Hand Swing) + 81 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 / 45

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.