home / musiccaps

musiccaps

2 rows where aspect_list contains "instrumental", aspect_list contains "jazz song", aspect_list contains "moderate tempo" 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
50fuQm8B2Yg This jazz song features a saxophone playing the main melody. This is accompanied by percussion playing a jazz beat. A piano plays jazz chords. The double bass plays the root notes with flourishes and fills. This song is the outro of a song and abruptly pauses. The mood of this song is happy. There are no voices in this song. This is an instrumental song. This song can be played in a luxury bar. ["jazz song", "saxophone", "piano", "percussion", "double bass", "no voice", "instrumental", "upbeat", "moderate tempo", "outro"] ["Jazz"] 0 110 120 0 0 ["/m/03_d0"]
iBH5X5SKirU This jazz song features a guitar solo. This is accompanied by percussion playing a simple beat. An acoustic guitar strums chords on each count of the bar. The bass plays the root notes of the chords. There are no voices in this song. The song has a happy mood. This song can be played in a coffee shop. ["jazz song", "acoustic guitar", "guitar solo", "bass guitar", "instrumental", "no voices", "percussion", "moderate tempo", "easy listening", "happy mood"] ["Music", "Ukulele"] 0 80 90 1 1 ["/m/04rlf", "/m/07xzm"]

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 824.837ms · About: simonw/musiccaps-datasette