musiccaps
2 rows where aspect_list contains "energetic", aspect_list contains "loud" and aspect_list contains "tutorial"
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 |
---|---|---|---|---|---|---|---|---|---|---|
FYFapDVOFHg | This music is an enthusiastic instrumental. The tempo is fast with an amplified harmonica solo. The music is lively, animated, happy, cheerful, energetic, enthusiastic and peppy. | ["instrumental", "fast tempo", "harmonica solo", "loud", "playful", "energetic", "peppy", "happy", "animated", "enthusiastic", "cheerful", "amplified harmonica", "harmonica lesson", "tutorial"] | ["Harmonica", "Wind instrument, woodwind instrument"] | 7 | 440 | 450 | 0 | 0 | ["/m/03qjg", "/m/085jw"] | |
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"] |
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 );