musiccaps
1 row where aspect_list contains "bass guitar" and aspect_list contains "rural"
This data as json, CSV (advanced)
aspect_list (array) 11 ✖
- acoustic guitar 1
- banjo 1
- bass guitar · 1 ✖
- bluegrass 1
- cover 1
- easygoing 1
- male vocal 1
- mandolin 1
- melodic singing 1
- playful 1
- rural · 1 ✖
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
_AVegKwklcg | This is a bluegrass cover of an originally heavy metal music piece. There is a male vocalist singing melodically in the lead. The tune is being played by the banjo, the mandolin and the acoustic guitar while the bass guitar is playing in the background. The atmosphere is playful and there is a rural feel to the piece. This piece could be used in the soundtrack of a comedy movie that takes place in the rural parts of the USA. | ["bluegrass", "cover", "male vocal", "melodic singing", "banjo", "mandolin", "acoustic guitar", "bass guitar", "playful", "easygoing", "rural"] | ["Country", "Music", "Bluegrass"] | 9 | 30 | 40 | 0 | 0 | ["/m/01lyv", "/m/04rlf", "/m/0gg8l"] |
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 );