musiccaps
1 row where aspect_list contains "childlike", aspect_list contains "no drums" and author_id = 8
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 |
---|---|---|---|---|---|---|---|---|---|---|
sgTZHSTnU40 | An ambient instrumental piece with no drums, big reverb and complex sound design elements. Tape hiss can be heard in the background and the vibe is hazy and warm with childlike wonder. | ["instrumental", "big reverb", "complex sound design", "tape hiss", "ethereal", "hazy", "warm", "childlike", "no drums", "ambient"] | ["Bell", "Music"] | 8 | 410 | 420 | 0 | 1 | ["/m/0395lw", "/m/04rlf"] |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );