musiccaps
2 rows where aspect_list contains "bass", aspect_list contains "instrumental" and audioset_names contains "Blues"
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 |
---|---|---|---|---|---|---|---|---|---|---|
-0SdAVK79lg | This song features an electric guitar as the main instrument. The guitar plays a descending run in the beginning then plays an arpeggiated chord followed by a double stop hammer on to a higher note and a descending slide followed by a descending chord run. The percussion plays a simple beat using rim shots. The percussion plays in common time. The bass plays only one note on the first count of each bar. The piano plays backing chords. There are no voices in this song. The mood of this song is relaxing. This song can be played in a coffee shop. | ["guitar song", "piano backing", "simple percussion", "relaxing melody", "slow tempo", "bass", "country feel", "instrumental", "no voice"] | ["Blues", "Country", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument", "Bluegrass"] | 0 | 30 | 40 | 0 | 0 | ["/m/0155w", "/m/01lyv", "/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/07s0s5r", "/m/0fx80y", "/m/0gg8l"] | |
W4nQpOHIPEw | This song features a solo played on a pedal steel guitar. This is a country blues melody. This involves slides on the guitar. This is accompanied by percussion playing a simple beat in common time. The bass plays 12 bar blues style bassline. An organ outlines chords in the background. This is an instrumental song. There are no voices. This song can be played in a bar. | ["pedal steel guitar solo", "slide guitar", "country song", "percussion", "bass", "organ", "no voices", "instrumental", "moderate tempo", "blues mood"] | ["Blues", "Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | 0 | 30 | 40 | 0 | 0 | ["/m/0155w", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/06w87", "/m/0fx80y"] |
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 );