musiccaps
2 rows where aspect_list contains "electric guitar solo", aspect_list contains "energetic" and aspect_list contains "medium tempo"
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 |
---|---|---|---|---|---|---|---|---|---|---|
AFwtBviVhhM | This song is an instrumental. The tempo is medium with an enthusiastic electric guitar solo. There are no other instruments used. The guitar riff is loud, enthusiastic and youthful. | ["instrumental", "electric guitar feedback", "vibrations", "sonic power", "electric guitar solo", "medium tempo", "enthusiastic", "energetic", "vibrant"] | ["Reverberation", "Effects unit", "Electric guitar", "Music"] | 7 | 30 | 40 | 0 | 1 | ["/m/01b9nn", "/m/02rr_", "/m/02sgy", "/m/04rlf"] | |
Y_eh6C0EBP8 | The song is an instrumental followed by a long pause. The song is medium tempo and features an electric guitar playing a solemn solo. The song is passionate and mysterious. The audio quality is poor. | ["instrumental music", "long pause", "electric guitar solo", "poor audio quality", "song introduction", "soloist", "hissing tones", "ambient room sounds", "documentary sound track", "advertisement jingle", "amplified guitar solo", "solemn", "emotional", "energetic", "guitar amplifier tone", "medium tempo", "instrumental music"] | ["Silence", "Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | 1 | 0 | 10 | 0 | 1 | ["/m/028v0c", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0b_fwt", "/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 );