musiccaps
1 row where aspect_list contains "alternative rock", aspect_list contains "bass guitar" and aspect_list contains "hopeful"
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 |
---|---|---|---|---|---|---|---|---|---|---|
vvfs2TUj-D4 | This is a Christian rock piece. There is a male vocalist in the lead singing gently and melodically. A mild-tempered electric guitar is playing the main theme. There is a bass guitar holding the root notes. The rhythmic background is provided by the acoustic drums. This song has a mellow and hopeful atmosphere. Due to being religious in nature, this piece could be played in the background of Christian religious content. It could also be played at Christian religious events. | ["christian rock", "alternative rock", "soft rock", "male vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "mellow", "hopeful", "easygoing", "religious", "medium tempo"] | ["Country", "Music", "Tender music"] | 9 | 30 | 40 | 1 | 1 | ["/m/01lyv", "/m/04rlf", "/t/dd00034"] |
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 );