musiccaps
1 row where aspect_list contains "ambient room noises" and aspect_list contains "fast fingers"
This data as json, CSV (advanced)
aspect_list (array) 19 ✖
- ambient room noises · 1 ✖
- audio hiss tones 1
- dance music 1
- disc scratching tones 1
- dj 1
- dj face off 1
- dj practising 1
- dj turntable 1
- electronic dance music 1
- fast fingers · 1 ✖
- freestyle dj 1
- groovy 1
- home recording 1
- instrumental all music 1
- medium tempo 1
- poor audio quality 1
- steady drumming rhythm 1
- tone manipulation 1
- vinyls 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
KUE_I30--AY | The song is an instrumental. The tempo is medium with a slick drumming rhythm and a DJ creating cool melodies by scratching and manipulating spinning music discs. The song is energetic and has a dance groove. The song is electronic dance music with poor audio quality and is at home. | ["instrumental all music", "dj", "electronic dance music", "home recording", "audio hiss tones", "fast fingers", "freestyle dj", "dj face off", "medium tempo", "steady drumming rhythm", "vinyls", "tone manipulation", "groovy", "disc scratching tones", "dance music", "dj practising", "ambient room noises", "poor audio quality", "dj turntable"] | ["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 );