musiccaps
2 rows where aspect_list contains "noisy", aspect_list contains "sentimental" and audioset_names contains "Yodeling"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Nt0U-CXK6O0 | The low quality recording features a Chanson song that consists of passionate female vocal singing over mellow piano melody and soft sustained strings melody. The recording is noisy, crushed and it sounds vintage, and therefore sentimental and nostalgic. | ["low quality", "noisy", "mono", "vintage", "crushed", "passionate female vocal", "mellow piano melody", "soft sustained string melody", "chanson", "sentimental", "nostalgic"] | ["Singing", "Yodeling", "Music"] | 4 | 50 | 60 | 1 | 1 | ["/m/015lz1", "/m/01swy6", "/m/04rlf"] | |
tcOHcop3sCQ | The low quality recording features a soft rock song sung by a flat male vocal over mellow, acoustic rhythm guitar chords. It sounds vintage and therefore nostalgic, emotional, sentimental and warm. The recording is a bit noisy and in mono as well. | ["soft rock", "low quality", "mono", "noisy", "flat male vocal", "mellow acoustic rhythm guitar chords", "vintage", "sentimental", "nostalgic", "emotional", "warm"] | ["Singing", "Country", "Yodeling", "Acoustic guitar", "Music", "Steel guitar, slide guitar"] | 4 | 30 | 40 | 1 | 1 | ["/m/015lz1", "/m/01lyv", "/m/01swy6", "/m/042v_gx", "/m/04rlf", "/m/06w87"] |
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 );