musiccaps
2 rows where aspect_list contains "e-guitars" and audioset_ids contains "/m/015y_n"
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"] | |
Mir959i7F2M | Someone is playing a e-guitar solo over another e-guitar providing jazz chords along with acoustic drums playing a jazzy groove with little licks and a steady straight groove in the ride that is panned to the right side of the speakers. An upright bass in playing a walking bassline. This song may be playing at a jazz bar. | ["jazz", "e-guitars", "acoustic drums", "upright bass", "medium to uptempo"] | ["Swing music", "Guitar", "Jazz", "Music"] | 6 | 30 | 40 | 0 | 1 | ["/m/015y_n", "/m/0342h", "/m/03_d0", "/m/04rlf"] |
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 );