musiccaps
1 row where aspect_list contains "electronic music", aspect_list contains "youth music" 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 );