musiccaps
3 rows where aspect_list contains "piano" and audioset_ids = "["/m/04rlf", "/m/06cqb"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
14hTDUjCr_g | The music features a male voice singing a melody while being backed at times by other male vocals. A piano accompanies the singer by playing a combination of chords and melody. For the most part a marimba plays in unison with the singer. In the low register, a synth bass plays long notes. The drummer makes use of only the hi-hat and China cymbal. | ["male voice", "male backing vocals", "piano", "marimba", "bass synth", "hi-hat", "china cymbal"] | ["Music", "Reggae"] | 2 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/06cqb"] | |
ID4AoAfHMVk | An acoustic drum is playing a reggae groove with a rim shot as a snare sound and shakers/tambourine in the background. An e-bass is playing a bassline accompanied by a clean e-guitar playing the same melody. A piano is playing short chords on the backbeat. Male voices are singing, sounding relaxed and joyful. This song may be playing at a reggae festival. | ["reggae", "piano", "e-bass", "e-guitar", "acoustic drums", "tambourine/shaker", "male voices singing", "slow to medium tempo", "relaxing and positive vibe"] | ["Music", "Reggae"] | 6 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/06cqb"] | |
JFGNmPzPXeA | Someone is playing an acoustic drum groove with a snare that uses reverb. An e-bass is playing a sub bassline. An e-guitar is strumming short rhythmic chords on the backbeat giving this music its reggae vibe. A keyboard is playing a sound in the mid range and another keyboard responds with a countermelody playing a melody using a brass sound. In the background you can hear people talking. This song may be playing live at a festival. | ["amateur recording", "reggae", "acoustic drums", "e-guitar", "e-bass", "piano", "medium tempo", "laid back energy"] | ["Music", "Reggae"] | 6 | 30 | 40 | 0 | 0 | ["/m/04rlf", "/m/06cqb"] |
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 );