musiccaps
1 row where aspect_list contains "country song" and aspect_list contains "drunk singing"
This data as json, CSV (advanced)
aspect_list (array) 21 ✖
- acoustic guitar 1
- amateur recording 1
- banjo 1
- beep 1
- boys having fun 1
- censored lyrics 1
- country folk 1
- country pop 1
- country song · 1 ✖
- drunk singing · 1 ✖
- giggling 1
- group singing 1
- home recording 1
- laughing 1
- male harmony 1
- medium harmony 1
- merry 1
- naughty 1
- stifled laughter 1
- suggestive 1
- vocal harmony 1
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 );