home / musiccaps

musiccaps

1 row where aspect_list contains "amateur live recording", aspect_list contains "tap dancing" and aspect_list contains "trumpets"

✎ 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
LByEH80c6Eg The music excerpt features a big band playing. The trumpets play a repeating melody, and thus, stand out the most. Throughout this passage one can hear sounds made by the shoes of tap dancers. The quality of the audio recording is not so good and this leads me to believe it was recorded at a live tap dancing show. ["tap dancing", "trumpets", "big band", "amateur live recording"] ["Music", "Tap"] 2 30 40 0 1 ["/m/04rlf", "/m/07qcpgn"]

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