musiccaps
1 row where aspect_list contains "acoustic guitar", aspect_list contains "banjo", aspect_list contains "country folk" and aspect_list contains "country pop"
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 |
---|---|---|---|---|---|---|---|---|---|---|
iaDrtIon6FU | This song is a male vocal harmony. The tempo is medium with banjo and guitar accompaniment. The song is merry, naughty, suggestive and harmless fun with the sound of stifled laughter in the background and with the expletives drowned with the sound of a beep. This song is Country pop/Country Folk. | ["male harmony", "country song", "medium harmony", "merry", "boys having fun", "stifled laughter", "giggling", "drunk singing", "banjo", "acoustic guitar", "censored lyrics", "beep", "laughing", "vocal harmony", "group singing", "naughty", "suggestive", "country folk", "country pop", "amateur recording", "home recording"] | ["Beep, bleep", "Music"] | 7 | 30 | 40 | 1 | 1 | ["/m/02fs_r", "/m/04rlf"] |
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 );