musiccaps
1 row where aspect_list contains "accordion" and aspect_list contains "no other instruments"
This data as json, CSV (advanced)
aspect_list (array) 10 ✖
- accordion · 1 ✖
- acoustic guitar 1
- bass 1
- folk song 1
- instrumental 1
- no other instruments · 1 ✖
- no percussion 1
- no voices 1
- violin 1
- waltz 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
pDgWT99uaJ0 | This folk song features a quarter. The main melody starts off with the accordion playing an ascending run. This is accompanied by the bass playing the root and fifth of the chords. An acoustic guitar strums chords in waltz time. After the accordion part, the violin plays the main melody and the same instruments back the violin. This song can be played in a village fair. | ["folk song", "waltz", "no voices", "instrumental", "violin", "accordion", "bass", "acoustic guitar", "no percussion", "no other instruments"] | ["Accordion"] | 0 | 110 | 120 | 0 | 0 | ["/m/0mkg"] |
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 );