musiccaps
2 rows where aspect_list contains "easygoing", aspect_list contains "male vocals" and aspect_list contains "piano"
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 |
---|---|---|---|---|---|---|---|---|---|---|
5jQIuYPAODg | This is an amateur recording. There are two famous actors singing melodically but with a lot of mistakes on the words. The piano is playing a simple tune. The recording is a bit dated, so the quality is quite low. | ["amateur recording", "male vocals", "melodic singing", "medium pitch singing", "piano", "gentle", "easygoing", "simple", "fooling around"] | ["Music", "/t/dd00003"] | 9 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/t/dd00003"] | |
8KUV2TFTpGo | This is a live acoustic performance of a folk rock music piece. There are male vocals singing melodically in the lead. The melody consists of a wide range of elements such as the acoustic guitar, the bass guitar, the piano and the saxophone. The acoustic drums are being played with brushes in the rhythmic background. The atmosphere is easygoing and joyful. This piece could be playing in the soundtrack of a feelgood movie during a road trip scene. | ["folk rock", "soul", "acoustic live performance", "male vocals", "melodic singing", "acoustic guitars", "bass guitar", "saxophones", "piano", "acoustic drums", "easygoing", "joyful"] | ["Country", "Music"] | 9 | 410 | 420 | 0 | 0 | ["/m/01lyv", "/m/04rlf"] |
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 );