musiccaps
2 rows where aspect_list contains "spirited" and audioset_ids contains "/m/01b9nn"
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 |
---|---|---|---|---|---|---|---|---|---|---|
6_zzu2KON6c | A male guitarist plays a cool guitar like on an electric guitar. The song is medium tempo with a guitar solo with heavy a[echoes played though a guitar amplifier and no other instrumentation. The song is bluesy and passionate. The song is a casual blue slick played on a guitar. | ["home video", "poor audio quality", "sound check", "deep", "emotional", "passionate", "blues influences", "instrumental music", "guitar solo", "tremolo effect", "guitar amplifier", "guitar lead", "echo tone", "solo guitar", "bad audio recording", "no other instrumentation", "guitar technique", "moody blues", "spirited", "passionate", "medium tempo", "blues lick"] | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument"] | 1 | 80 | 90 | 0 | 1 | ["/m/01b9nn", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw"] | |
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 );