musiccaps
1 row where aspect_list contains "amateur recording", aspect_list contains "jazz percussion" and aspect_list contains "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 |
---|---|---|---|---|---|---|---|---|---|---|
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 );