musiccaps
1 row where aspect_list contains "ambient room noise" and aspect_list contains "master class"
This data as json, CSV (advanced)
aspect_list (array) 17 ✖
- ambient room noise · 1 ✖
- antique guitar 1
- bad audio quality 1
- buzzing noise 1
- country music 1
- guitar demo 1
- instrumental music 1
- master class · 1 ✖
- medium tempo 1
- melancholic 1
- passionate 1
- rich country traditions 1
- soloist 1
- spirited 1
- super tone unique tone 1
- vintage guitar tone 1
- youtube music class 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
-lPXTBXa0tE | The song is an instrumental. The song is medium tempo played by a solo guitarist on a vintage super tone with an exquisite tone. The song is emotional and passionate. The song has poor audio quality. | ["bad audio quality", "vintage guitar tone", "passionate", "spirited", "guitar demo", "soloist", "antique guitar", "youtube music class", "master class", "buzzing noise", "instrumental music", "ambient room noise", "bad audio quality", "super tone unique tone", "melancholic", "country music", "medium tempo", "rich country traditions"] | ["Tapping (guitar technique)", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | 1 | 30 | 40 | 0 | 1 | ["/m/01glhc", "/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/06w87", "/m/07s0s5r", "/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 );