musiccaps
2 rows where aspect_list contains "bad audio quality", aspect_list contains "country music" and aspect_list contains "spirited"
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 |
---|---|---|---|---|---|---|---|---|---|---|
-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"] | |
O84YjlJ_Qw4 | The song is instrumental. The tempo is medium with a prolific fiddler playing melody and a banjo and guitar accompaniment. The song is adventurous and exciting. The song is a classic country instrumental. The song has poor audio quality. | ["violinists", "country music", "fiddlers", "child performers", "instrumental music", "guitar strumming", "country folk music", "live performance", "groovy rhythm", "country dance music", "the country life", "the wild west", "dance rhythm", "passionate", "emotional", "spirited", "never give up", "cheerful", "positive", "traditional music", "bad audio quality", "country bluegrass", "banjo", "medium tempo"] | ["Banjo", "Country", "Music", "Musical instrument", "Plucked string instrument", "Bowed string instrument"] | 1 | 40 | 50 | 0 | 0 | ["/m/018j2", "/m/01lyv", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/m/0l14_3"] |
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 );