musiccaps
1 row where aspect_list contains "4 on the floor kick" and aspect_list contains "northern soul"
This data as json, CSV (advanced)
aspect_list (array) 14 ✖
- 4 on the floor kick · 1 ✖
- flat male vocal 1
- funky guitar chords 1
- groovy bass 1
- groovy piano melody 1
- low quality 1
- melodic background male vocals 1
- mono 1
- northern soul · 1 ✖
- nostalgic 1
- sentimental 1
- shimmering open hats 1
- vintage 1
- warm 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
EUNTykrvpok | The low quality recording features a northern soul song that consists of flat male vocals, alongside melodic male background vocals, singing over funky guitar chords, groovy piano chords, groovy bass, "4 on the floor" kick pattern and shimmering open hats. It is noisy and in mono and therefore vintage, but it also sounds warm, nostalgic and sentimental. | ["low quality", "vintage", "northern soul", "groovy bass", "groovy piano melody", "funky guitar chords", "shimmering open hats", "4 on the floor kick", "flat male vocal", "melodic background male vocals", "mono", "warm", "nostalgic", "sentimental"] | ["Funk", "Music", "Ska", "Soul music"] | 4 | 30 | 40 | 1 | 1 | ["/m/02x8m", "/m/04rlf", "/m/06rqw", "/m/0gywn"] |
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 );