musiccaps
2 rows where aspect_list contains "folk" and audioset_ids contains "/m/01lyv"
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 |
---|---|---|---|---|---|---|---|---|---|---|
ecS6SJGkhIw | The low quality recording features a flat girl vocal talking over a folk song that consists of an arpeggiated guitar melody played over groovy bass, shimmering shakers and "4 on the floor" kick pattern. There are some birds chirping sounds in the background. It sounds energetic, fun and happy. | ["low quality", "flat girl vocal", "folk", "arpeggiated guitar melody", "shimmering shaker", "groovy bass", "\"4 on the floor\" kick pattern", "energetic", "fun", "happy", "birds chirping"] | ["Banjo", "Country"] | 4 | 40 | 50 | 0 | 0 | ["/m/018j2", "/m/01lyv"] | |
qyCea2TuUV4 | The low quality recording features a live performance of a folk song and it consists of acoustic guitar solo melody, followed by banjo melody. The recording is noisy, there are some natural sounds - since it was performed outdoors and the stereo image is unbalanced due to the fact that the instruments are leaning towards the right channel of the stereo image. It still sounds passionate and upbeat. | ["low quality", "noisy", "live perforamnce", "unbalanced stereo", "nature sounds", "acoustic guitar solo melody", "upbeat", "banjo melody", "folk", "passionate"] | ["Banjo", "Country", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | 4 | 100 | 110 | 0 | 0 | ["/m/018j2", "/m/01lyv", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y"] |
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 );