home / musiccaps

musiccaps

1 row where aspect_list contains "chill", aspect_list contains "danceable" and aspect_list contains "pop"

✎ 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
YB_PzRgHOeo This is a pop music piece with an early 2000s feel. There is one male and one female vocalist singing melodically. The melody is being played by the electric guitar and the keyboard guitar with the bass guitar in the background. The rhythm is provided by the acoustic drums with occasional clap sounds. The atmosphere is easygoing and danceable. This piece could be used in the soundtrack of a sit-com movie or a TV show. ["pop", "rock", "male vocal", "female vocal", "melodic singing", "electric guitar", "keyboard", "bass guitar", "acoustic drums", "chill", "easygoing", "danceable"] ["Funk", "Music"] 9 30 40 0 0 ["/m/02x8m", "/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
);
Powered by Datasette · Queries took 819.919ms · About: simonw/musiccaps-datasette