musiccaps
1 row where aspect_list contains "12 bar blues", aspect_list contains "bass" and aspect_list contains "piano"
This data as json, CSV (advanced)
aspect_list (array) 9 ✖
- 12 bar blues · 1 ✖
- bass · 1 ✖
- guitar solo 1
- instrumental 1
- no voices 1
- piano · 1 ✖
- simple percussion 1
- slow blues song 1
- slow tempo 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
qAgZ__fk9LY | This slow blues song features a solo played on a guitar. The tempo of this song is slow. This is accompanied by percussion playing a simple beat. The bass follows the 12 bar blues pattern. The piano plays chords in the background. The mood of this song is romantic and the pattern played on the guitar is similar to a call-response theme. This song can be played in a bar. | ["slow blues song", "instrumental", "guitar solo", "bass", "simple percussion", "12 bar blues", "piano", "slow tempo", "no voices"] | ["Guitar", "Jazz", "Music", "Musical instrument", "Plucked string instrument"] | 0 | 50 | 60 | 1 | 1 | ["/m/0342h", "/m/03_d0", "/m/04rlf", "/m/04szw", "/m/0fx80y"] |
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 );