musiccaps
2 rows where aspect_list contains "electric guitar", aspect_list contains "energetic" and aspect_list contains "male vocals"
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 |
---|---|---|---|---|---|---|---|---|---|---|
JPZlyvPNZj4 | This music clip is a bass electric guitar instrumental. The tempo is medium fast with the guitarist playing an enthusiastic riff after giving instructions. No other instruments are used and the talking at the beginning of the audio clip indicates that this is a tutorial or instructional video. | ["male vocals", "electric guitar", "powerful", "loud", "skilful", "supporting instrument", "groovy", "dense sounds", "bass lines", "vibrations", "resonant", "bass electric guitar", "lower notes", "lower octave", "smooth", "instructional video", "sonic power", "amplified", "stringed guitar", "amplified guitar", "enthusiastic riff", "energetic", "youthful", "man talking", "tutorial", "instructions", "static"] | ["Tapping (guitar technique)", "Electric guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | 7 | 30 | 40 | 0 | 1 | ["/m/01glhc", "/m/02sgy", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/m/0g12c5"] | |
KV99GJg0tvA | This is a doo wop music piece. There are male vocals singing melodically. The main tune is being played by the electric guitar and the keyboard while the bass guitar is playing in the background. The rhythm is provided by the acoustic drums. The atmosphere is danceable and joyful. This piece could be playing at a dance club for an oldies night. | ["doo wop", "rock", "male vocals", "melodic singing", "electric guitar", "bass guitar", "keyboard", "acoustic drums", "danceable", "energetic", "joyful"] | ["Music", "Ska"] | 9 | 30 | 40 | 0 | 0 | ["/m/04rlf", "/m/06rqw"] |
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 );