musiccaps
3 rows where aspect_list contains "e-guitars" and audioset_ids contains "/m/06rqw"
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 |
---|---|---|---|---|---|---|---|---|---|---|
CRDDdjDinYc | A e-guitar takes the lead melody along with the hammond organ. The drums and the bass are providing a rock groove in the background. Another e-guitar is playing along with the bass on the lower notes, it's highly distorted and has some overdrive on it. The male singer streams and sings. His voice is full of reverb and delay. The whole recording is of poor quality. This song may be playing at an old bar. | ["indirock", "hammond organ", "e-guitars", "male voice singing", "acoustic drums", "amateur recording", "medium tempo"] | ["Swing music", "Music", "Punk rock", "Ska", "Song"] | 6 | 50 | 60 | 0 | 1 | ["/m/015y_n", "/m/04rlf", "/m/05r6t", "/m/06rqw", "/m/074ft"] | |
FY8bZRm_QiE | This song contains acoustic drums playing kind of a slow drum&bass rhythm along with a bass playing the rootnote of a e-guitar strumming along. Another e-guitar is strumming along, panned to the right side of the speakers. A male voice is singing in a higher key with delay in his voice. This song may be playing with headphones on a rainy colder day. | ["rock", "e-bass", "e-guitars", "acoustic drums", "male voice singing", "higher register", "melancholic", "medium to uptempo"] | ["Singing", "Music", "Ska"] | 6 | 50 | 60 | 0 | 0 | ["/m/015lz1", "/m/04rlf", "/m/06rqw"] | |
HDSV7Pzq8CA | A drum is playing a four on the floor groove with a kick on every beat along to a bassline and a tambourine. Two e-guitars are strumming funky sounding chords. Male singers are singing a melody together in the mid-range. This song may be playing live at a local event. | ["popmusic", "e-guitars", "drums", "tambourine", "male voices singing", "mid range", "e-bass", "amateur recording", "uptempo"] | ["Singing", "Music", "Ska", "Tambourine", "Music of Latin America"] | 6 | 80 | 90 | 0 | 1 | ["/m/015lz1", "/m/04rlf", "/m/06rqw", "/m/07brj", "/m/0g293"] |
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 );