musiccaps
1 row where aspect_list contains "clicking sound" and aspect_list contains "home recording"
This data as json, CSV (advanced)
aspect_list (array) 16 ✖
- amateur recording 1
- catchy riff 1
- clicking sound · 1 ✖
- digital drum beat 1
- dj 1
- dj mixer 1
- electric guitar riff 1
- fast tempo 1
- home recording · 1 ✖
- instrumental 1
- keyboard harmony 1
- muddled music 1
- scratching 1
- sharp sound 1
- static 1
- vinyl records 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
5tt_GKV13G0 | This music is an instrumental with a groovy rhythm. The audio is of inferior quality making the sound muddled and difficult to comprehend. There is a steady rhythm in the background with the sound of a turn table, scratching , a catchy riff on the electric guitar and some sound caused by disturbance in electrical energy. | ["instrumental", "fast tempo", "keyboard harmony", "digital drum beat", "scratching", "catchy riff", "electric guitar riff", "muddled music", "home recording", "amateur recording", "sharp sound", "vinyl records", "scratching", "dj", "dj mixer", "clicking sound", "static"] | ["Scratching (performance technique)", "Music", "Scratch"] | 7 | 20 | 30 | 0 | 1 | ["/m/01hgjl", "/m/04rlf", "/m/07qb_dv"] |
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 );