musiccaps
2 rows where aspect_list contains "guitar demo" 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 |
---|---|---|---|---|---|---|---|---|---|---|
-5xOcMJpTUk | A male guitarist plays the guitar and speaks about technique in this online video tutorial. The male voice is strong and commanding, along with guitar string twang sounds, clearly demonstrating the technique. The audio quality is mediocre. | ["guitarist", "male talking", "twang sounds", "mediocre audio quality", "guitar string tones", "guitar technique", "fretboard sounds", "guitar demo", "online guitar lessons", "home music video", "youtube tutorial", "bas]d audio quality", "humming noise", "energetic", "passionate", "spirited okay", "strong voice", "ambient room noises"] | ["Bass guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | 1 | 70 | 80 | 0 | 0 | ["/m/018vs", "/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/09x0r", "/m/0fx80y"] | |
-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 );