musiccaps
2 rows where aspect_list contains "electronic music", aspect_list contains "punchy drumming" and is_balanced_subset = 1
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 |
---|---|---|---|---|---|---|---|---|---|---|
f8nysknTFUo | A female vocalist sings this spirited rap. The tempo is medium with punchy drumming and synthesiser arrangements. The song is youthful,energetic,spirited with a catchy recurring vocal riff. The song is an Electro Rap/Hip-Hop song. | ["female singer", "medium fast tempo", "rap", "hip-hop", "female rapper", "passionate", "intense", "rapper", "synthesiser arrangements", "electronic music", "electro rap", "punchy drumming", "drum machine", "bass drum", "psychedelic music", "syncopated", "youthful", "energetic", "enthusiastic", "pop rap", "disco rap", "insistent", "catchy vocal riff", "recurring beat", "dance music", "club", "dj"] | ["Afrobeat", "Music", "Hip hop music"] | 7 | 30 | 40 | 1 | 1 | ["/m/0145m", "/m/04rlf", "/m/0glt670"] | |
oSoP9Is0UH4 | A male vocalist sings this melodious contemporary Christian song. The tempo is medium with punchy drumming, keyboard accompaniment ,vigorous violin harmony, steady bass line and synth arrangements. The song is peppy, appealing to the youth, melodious, mellow and sincere. | ["male singer", "medium tempo", "electronic music", "mellow", "punchy", "sincere", "earnest", "drum machine", "gospel", "contemporary christian music", "youth music", "groovy", "catchy", "youthful", "christian gospel music", "punchy drumming", "synthesiser arrangement", "steady bass lines", "violin harmony", "vocal backup"] | ["Music", "Exciting music"] | 7 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/t/dd00035"] |
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 );