musiccaps
1 row where aspect_list contains "freestyle disc scratching" and aspect_list contains "poor audio quality"
This data as json, CSV (advanced)
aspect_list (array) 16 ✖
- ambient room noises 1
- dance rhythm 1
- disc scratching tones 1
- dj 1
- freestyle disc scratching · 1 ✖
- groovy 1
- hissing tones 1
- home music video 1
- instrumental music 1
- medium tempo 1
- people dancing 1
- poor audio quality · 1 ✖
- practice session 1
- techno dance rhythm 1
- vinyl disc 1
- youtube music video 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
2uvHgwAljPA | The song is an instrumental. The song is medium tempo with a groovy drum rhythm, vinyl disc scratching tones and a percussive bass line. The song is energetic and groovy. The audio quality is very poor with a lot of hissing noise. | ["dj", "practice session", "vinyl disc", "youtube music video", "disc scratching tones", "home music video", "freestyle disc scratching", "groovy", "dance rhythm", "poor audio quality", "ambient room noises", "instrumental music", "people dancing", "techno dance rhythm", "hissing tones", "medium tempo"] | ["Scratching (performance technique)", "Music", "Scratch", "Drum machine"] | 1 | 30 | 40 | 0 | 1 | ["/m/01hgjl", "/m/04rlf", "/m/07qb_dv", "/m/0cfdd"] |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [musiccaps] ( [ytid] TEXT PRIMARY KEY, [url] TEXT, [caption] TEXT, [aspect_list] TEXT, [audioset_names] TEXT, [author_id] TEXT, [start_s] TEXT, [end_s] TEXT, [is_balanced_subset] INTEGER, [is_audioset_eval] INTEGER, [audioset_ids] TEXT );