musiccaps
2 rows where aspect_list contains "acoustic guitar" and aspect_list contains "solo"
This data as json, CSV (advanced)
aspect_list (array) 18 ✖
- acoustic guitar · 2 ✖
- solo · 2 ✖
- accordion 1
- bass guitar 1
- chill 1
- coffee shop music 1
- cover 1
- gentle 1
- groovy 1
- harmonica 1
- jazz ballad 1
- keyboard 1
- live performance 1
- major key 1
- soul music 1
- unique 1
- uplifting 1
- upright bass 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
gp1DYuoQH08 | This is a live performance of a jazz ballad music piece. The accordion is playing a solo as the main melody. There is an acoustic guitar playing the chords of the piece. The bass line is being played by the upright bass. The atmosphere is gentle. This piece is the perfect music to be played in the background at a coffee shop. | ["jazz ballad", "live performance", "accordion", "solo", "acoustic guitar", "upright bass", "gentle", "chill", "coffee shop music"] | ["Accordion"] | 9 | 40 | 50 | 0 | 0 | ["/m/0mkg"] | |
xZTlnE6IcYQ | This is a harmonica cover of a soul music piece. The harmonica plays a groovy solo. In the melodic background, there is a keyboard and a bass guitar. The rhythm is provided by the acoustic drums. The atmosphere is uplifting. The song is in major key. | ["cover", "soul music", "harmonica", "solo", "keyboard", "bass guitar", "acoustic guitar", "groovy", "unique", "uplifting", "major key"] | ["Harmonica", "Wind instrument, woodwind instrument"] | 9 | 50 | 60 | 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 );