musiccaps
1 row where aspect_list contains "male and female voices singing" and aspect_list contains "mandolin"
This data as json, CSV (advanced)
aspect_list (array) 8 ✖
- acoustic guitar 1
- amateur recording 1
- country/folk 1
- male and female voices singing · 1 ✖
- mandolin · 1 ✖
- medium to uptempo 1
- upright bass 1
- violin 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
j0UMI2DrnMA | This song contains an upright bass playing a simple bassline along with an acoustic guitar strumming chords and a mandolin playing a fast paced melody. A violin is ending the phrase in the mid range. Then male and female voices are singing with the female voice being the lead voice. In the background you can hear the crowd laughing. This song may be playing as a local concert. | ["country/folk", "upright bass", "acoustic guitar", "violin", "mandolin", "male and female voices singing", "medium to uptempo", "amateur recording"] | ["Banjo", "Music", "Musical instrument", "Violin, fiddle", "Bowed string instrument"] | 6 | 130 | 140 | 0 | 0 | ["/m/018j2", "/m/04rlf", "/m/04szw", "/m/07y_7", "/m/0l14_3"] |
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 );