musiccaps
3 rows where audioset_ids contains "/m/04rlf", audioset_ids contains "/m/07gxw" and author_id = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|
IbaQjxGDT-o | Electronic dance music features a repeating melody played by an electronic sound. The beat of the music is being driven by a kick drum played on every beat, a hi-hat played four times every beat and some sampled claps played on beats two and four. In the background one can hear an altered female voice singing a short melody. Another electronic/synth sound can be heard in the background having sparse interventions. The music is meant to be danced to. | ["electronic sounds", "kick drum", "altered female voice", "hi-hat", "electronic dance music genre"] | ["Drum and bass", "Music of Asia", "Music", "Pop music", "Techno", "Trance music", "Electronica"] | 2 | 30 | 40 | 0 | 1 | ["/m/0283d", "/m/028sqc", "/m/04rlf", "/m/064t9", "/m/07gxw", "/m/07lnk", "/m/0m0jc"] | |
UkZ76EFfLSg | The techno music excerpt features only a beat, no other melodic or harmonic instruments. By the sound of it, the beat was made using sampled drums. Other percussive instruments can be heard in the background. This music would be played in a club. | ["club music", "techno music", "drum beat", "percussive instruments", "no melody", "no harmony", "sampled drums"] | ["Drum and bass", "House music", "Music", "Techno", "Tick", "Dubstep", "Dance music"] | 2 | 30 | 40 | 0 | 1 | ["/m/0283d", "/m/03mb9", "/m/04rlf", "/m/07gxw", "/m/07qjznt", "/m/07s72n", "/m/0ggx5q"] | |
oJ0rdNlghn4 | The rock music features a bass guitar playing a repeating melody with a distortion effect in the really-low pitch register. A set of drums is accompanying the bassist with a well-rooted and repeating rhythm. | ["drums", "bass guitar", "distortion effect", "rock genre"] | ["Music", "Techno", "Chorus effect", "Dubstep"] | 2 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07gxw", "/m/07m2kt", "/m/07s72n"] |
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 );