home / musiccaps

musiccaps

1 row where aspect_list contains "cymbals", aspect_list contains "folk song" and aspect_list contains "no stringed instrument"

✎ 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
iZjIuV_cTe8 This folk song features a reed instrument playing the main melody. A similar melody is played on a percussion instrument by a skilled percussionist. Another percussion instrument plays a tabla-sounding instrument. Cymbals also play a melody keeping time with the melody being played. The end of the song features an ascending run on the reed and the harmonized percussion. ["traditional music", "folk song", "reed instrument", "percussion melody", "cymbals", "moderate tempo", "instrumental", "no voices", "no stringed instrument"] ["Folk music", "Music", "Rattle (instrument)"] 0 210 220 1 1 ["/m/02w4v", "/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 828.957ms · About: simonw/musiccaps-datasette