musiccaps
2 rows where aspect_list contains "soloist" and audioset_ids contains "/m/042v_gx"
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"] | |
4H1nc2Xv2Hg | The song is an instrumental. The tempo is slow and unsure, with a guitarist attempting to play a minor scale and gets the scale wrong. The song has poor audio quality with ambient traffic noise in the background. | ["guitarist", "acoustic guitar", "minor scale played wrong", "guitar playing video", "amateur player", "guitar learner", "ambient room noise", "instrumental music", "soloist", "guitar solo", "boring", "unsteady playing", "youtube music video", "guitar demonstration", "dissonant notes", "poor audio quality", "traffic noise"] | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | 1 | 30 | 40 | 0 | 0 | ["/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/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 );