musiccaps
2 rows where aspect_list contains "guitar song" and audioset_ids contains "/m/0gg8l"
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"] | |
f6wrXzvByrg | This folk song is a duet and features a male and a female voice singing in harmony. This is accompanied by an acoustic guitar strumming chords. A banjo player fills in between lines. There is no percussion in this song. The mood of this song is happy and upbeat. This song can be played in a coffee shop. | ["folk song", "duet", "male voice", "female voice", "vocal harmony", "banjo song", "guitar song", "no percussion", "minimal instruments", "happy mood", "moderate tempo", "repetitive melody"] | ["Christmas music", "Banjo", "Country", "Music", "Song", "Bluegrass"] | 0 | 30 | 40 | 0 | 1 | ["/m/0140xf", "/m/018j2", "/m/01lyv", "/m/04rlf", "/m/074ft", "/m/0gg8l"] |
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 );