musiccaps
2 rows where aspect_list contains "booming bass line", aspect_list contains "exciting" and aspect_list contains "keyboard harmony"
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 |
---|---|---|---|---|---|---|---|---|---|---|
8wty3wJfmEY | A male Latin singer sings this cool melody. The song is medium tempo with keyboard accompaniment and steady drumming rhythm and a percussive bass-line with missing harmonies. The song is experimental and has bad audio quality. | ["male singer", "booming bass line", "bad audio quality", "missing harmony section", "experimental music", "medium tempo", "latin dance music", "groovy music", "percussive bass line", "exciting", "enthusiastic", "passionate", "spirited", "romantic", "keyboard harmony", "percussive rhythm"] | ["Music", "Reggae"] | 1 | 330 | 340 | 0 | 0 | ["/m/04rlf", "/m/06cqb"] | |
hgGCfJoYDUU | The song is an instrumental. The tempo is medium with a booming bass line, grooving drum rhythm, sweeping keyboard harmony, sonic sound effects, and pin pong ball sound effects. The song has trance vibes and is very groovy. The song has poor audio quality. | ["techno dance rhythm", "keyboard harmony", "poor audio quality", "trance music", "dj", "house mix", "party mix", "medium tempo", "instrumental music", "ping pong shot tones", "booming bass line", "various percussion hits", "groovy dance music", "exciting", "youthful", "energetic", "spirited", "party all night", "underground music scene", "sweeping keyboard harmony"] | ["Disco", "Drum and bass", "House music", "Music", "Techno", "Dubstep", "Electronic dance music", "Dance music"] | 1 | 30 | 40 | 0 | 1 | ["/m/026z9", "/m/0283d", "/m/03mb9", "/m/04rlf", "/m/07gxw", "/m/07s72n", "/m/08cyft", "/m/0ggx5q"] |
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 );