musiccaps
2 rows where aspect_list contains "energetic" and audioset_ids contains "/m/01jnbd"
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 |
---|---|---|---|---|---|---|---|---|---|---|
RczzNAr1T_Q | The song is an instrumental. The tempo is medium with a guitar strumming to different settings of an effects delay pedal with echoes and effects being heard. The song is an effects pedal demonstration. The audio quality is poor with hissing sounds. | ["instrumental music", "turning knobs", "delay pedal", "poor audio quality", "hissing sounds", "rehearsals session", "ambient room noise", "guitar effects pedal", "tone generator", "poor audio quality", "guitar strumming", "echo tones", "testing effects", "guitar demo", "energetic", "casual playing", "reverb peas", "echoes", "medium tempo"] | ["Reverberation", "Tapping (guitar technique)", "Echo", "Effects unit", "Guitar", "Music", "Distortion"] | 1 | 30 | 40 | 0 | 1 | ["/m/01b9nn", "/m/01glhc", "/m/01jnbd", "/m/02rr_", "/m/0342h", "/m/04rlf", "/m/0g12c5"] | |
U-L9YCIdLbg | This music is instrumental. The tempo is medium with rhythmic drumming accompaniment. The melody is simple and gets interesting as a layer of drums gets added. It is spirited, catchy and engaging. | ["instrumental", "medium tempo", "electric guitar", "sonic power", "spirited", "catchy", "engaging", "smooth", "rock", "external amplification", "vibrating strings", "slick drumming", "layers of music", "groovy", "catchy", "energetic", "sonic power", "minimal instrumentation"] | ["Reverberation", "Echo", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Distortion"] | 7 | 80 | 90 | 0 | 1 | ["/m/01b9nn", "/m/01jnbd", "/m/02rr_", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/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 );