musiccaps
3 rows where aspect_list contains "medium to uptempo" and audioset_ids contains "/m/018j2"
This data as json, CSV (advanced)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
669Fk7afszw | An acoustic guitar is strumming chords while a banjo is playing a fast melody over it. In the background you can hear an upright bass playing a fast walking bassline. Also in the background noises of people speaking can be heard. This song may be playing live on the streets performed by buskers. | ["bluegrass", "amateur recording", "banjo", "acoustic guitar", "upright bass", "background voices", "medium to uptempo"] | ["Banjo", "Country", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Bluegrass"] | 6 | 10 | 20 | 0 | 0 | ["/m/018j2", "/m/01lyv", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/09x0r", "/m/0fx80y", "/m/0gg8l"] | |
YqZNMFyPJOQ | This audio contains someone playing a melody on a banjo. A male voice is speaking with a deeper voice. This is an amateur recording. | ["amateur recording", "banjo", "male voice speaking", "medium to uptempo"] | ["Banjo", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | 6 | 240 | 250 | 0 | 0 | ["/m/018j2", "/m/04rlf", "/m/04rzd", "/m/04szw", "/m/0fx80y"] | |
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 );