musiccaps
1 row where aspect_list contains "amateur recording" and aspect_list contains "hammond organ"
This data as json, CSV (advanced)
aspect_list (array) 7 ✖
- acoustic drums 1
- amateur recording · 1 ✖
- e-guitars 1
- hammond organ · 1 ✖
- indirock 1
- male voice singing 1
- medium tempo 1
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"] |
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 );