musiccaps
2 rows where aspect_list contains "electric guitar lead", aspect_list contains "hard rock" and aspect_list contains "soft rock"
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 |
---|---|---|---|---|---|---|---|---|---|---|
7_yBcHaoR0w | This music is an electric guitar lead instrumental. The tempo is slow with no accompaniment and ambient sounds like a popping and swishing sound. The music is a rhythmic, controlled, pleasant, melancholic, sentimental and emotional Electric guitar solo. | ["instrumental", "slow tempo", "electric guitar lead", "rock", "hard rock", "metal", "heavy metal", "soft rock", "electric guitar", "external amplification", "ambient sounds", "popping sound", "rustling sound", "electric guitar lead", "vibrations", "resounding"] | ["Echo", "Electric guitar", "Music"] | 7 | 50 | 60 | 0 | 1 | ["/m/01jnbd", "/m/02sgy", "/m/04rlf"] | |
_0-2meOf9qY | This music is an electronic guitar instrumental. The tempo is slow with a melancholic , resounding harmony on the guitar. It is mellow, soft, poignant, sentimental and emotional. | ["instrumental", "slow tempo", "electric guitar harmony", "electric guitar solo", "electric guitar lead", "amplified guitar", "loud", "emphatic", "resounding", "sonic power", "loud feedback", "rock", "hard rock", "metal", "heavy metal", "soft rock", "pop", "youthful", "pensive", "melancholy", "sentimental", "emotional"] | ["Echo", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Inside, small room"] | 7 | 10 | 20 | 0 | 0 | ["/m/01jnbd", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/t/dd00125"] |
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 );