musiccaps
1 row where aspect_list contains "amateur recording" and aspect_list contains "jazz percussion"
This data as json, CSV (advanced)
aspect_list (array) 9 ✖
- amateur recording · 1 ✖
- bass 1
- harmonica 1
- instrumental 1
- jazz percussion · 1 ✖
- jazz song 1
- no voices 1
- pop 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 |
---|---|---|---|---|---|---|---|---|---|---|
sEIn8YYD9jw | This song features a harmonica playing the main melody. This is accompanied by percussion playing a simple beat with the focus on the snare. The bass plays the root note of the chord. Due to the low quality of the audio, the other instruments cannot be heard. T. | ["jazz song", "pop", "harmonica", "jazz percussion", "no voices", "instrumental", "amateur recording", "bass", "slow tempo"] | ["Harmonica", "Wind instrument, woodwind instrument"] | 0 | 170 | 180 | 0 | 0 | ["/m/03qjg", "/m/085jw"] |
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 );