musiccaps

1 row where aspect_list contains "acoustic rhythm guitar", aspect_list contains "children song", aspect_list contains "happy" and aspect_list contains "joyful"

✎ 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
BfUoopDpmmY The low quality recording features a children's song that features a flat male vocal, alongside wide harmonizing children vocals, singing over acoustic rhythm guitar, steel guitar melody, happy bells melody, soft kick hits, mellow snare hits, shimmering hi hats and groovy bass. It sounds joyful, happy and exciting. ["low quality", "children song", "flat male vocal", "wide harmonizing children vocals", "groovy bass", "acoustic rhythm guitar", "steel guitar melody", "shimmering hi hats", "happy bells melody", "soft kick hits", "mellow snare hits", "joyful", "happy", "exciting"] ["Singing", "Music", "Music for children", "Song"] 4 30 40 0 0 ["/m/015lz1", "/m/04rlf", "/m/05fw6t", "/m/074ft"]

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
);