home / musiccaps

musiccaps

1 row where aspect_list contains "holiday mood", aspect_list contains "instrumental", aspect_list contains "moderate tempo" and aspect_list contains "tambourine"

✎ 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
7kEeYQx2VLE This song features a trumpet playing the main melody. The melody is like a melody played before announcements are made in a kingdom. This is accompanied by a tambourine and a bass. The bass plays one note four times followed by a higher pitched note eight times and back to the first note once. After a three count rest, the bass phrase is repeated. This song can be played in a movie scene announcing the arrival of royalty. ["trumpet song", "tambourine", "bass", "instrumental", "no voices", "moderate tempo", "holiday mood", "music for announcement"] ["Christmas music", "Christian music", "Music", "Rattle (instrument)"] 0 0 10 0 0 ["/m/0140xf", "/m/02mscn", "/m/04rlf", "/m/05r5wn"]

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
);
Powered by Datasette · Queries took 806.519ms · About: simonw/musiccaps-datasette