musiccaps

1 row where aspect_list contains "christmas", aspect_list contains "melodic singing" and aspect_list contains "percussion"

✎ View and edit SQL

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
lZavPVn7O4Q This is the remix of an Original Pilipino Music (OPM) Christmas song. The female vocalist is singing melodically and in a festive manner. The melody is being played by a strings section while the rhythm consists of an electronic drum beat with heavy usage of percussive elements. The atmosphere is cheerful. This piece could be played at Christmas events in the Philippines. ["original pilipino music", "christmas", "remix", "female vocals", "melodic singing", "electronic drums", "percussion", "bells", "strings", "festive", "cheerful"] ["Christmas music", "Music of Asia", "Christian music", "Music"] 9 180 190 0 0 ["/m/0140xf", "/m/028sqc", "/m/02mscn", "/m/04rlf"]

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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
);