musiccaps
1 row where aspect_list contains "acoustic guitar" and aspect_list contains "harmonica song"
This data as json, CSV (advanced)
aspect_list (array) 9 ✖
- acoustic guitar · 1 ✖
- bass 1
- blues song 1
- harmonica song · 1 ✖
- instrumental 1
- no percussion 1
- no voices 1
- piano 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 |
---|---|---|---|---|---|---|---|---|---|---|
FNnKFUkFJ5M | This blues song features a solo played on a harmonica. It starts off with the harmonica playing three descending notes. This is followed by the same three notes but the first note is played twice followed by the remaining two notes. This is accompanied by a guitar playing a rock and roll strumming pattern. The bass plays the root note of the chord. A piano plays in the background. There are no voices in this song. This song can be played in a bar scene in a movie. | ["harmonica song", "acoustic guitar", "piano song", "no voices", "bass", "instrumental", "no percussion", "no voices", "blues song", "slow tempo"] | ["Harmonica", "Wind instrument, woodwind instrument"] | 0 | 0 | 10 | 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 );