musiccaps
2 rows where aspect_list contains "guitarist" 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"] | |
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 );