musiccaps
1 row where aspect_list contains "repeated theme" and aspect_list contains "rock and roll"
This data as json, CSV (advanced)
aspect_list (array) 12 ✖
- acoustic drums 1
- american 1
- bass guitar 1
- blues 1
- easygoing 1
- electric guitar 1
- groovy 1
- male back vocals 1
- male vocal 1
- repeated theme · 1 ✖
- rock and roll · 1 ✖
- simple tune 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
GQbUpJFArKI | This is a rock and roll music piece. There is a male vocal singer singing as the lead while other back vocals sing rhythmic back vocals at a higher pitch than the lead. An electric guitar is playing a simple and repeated tune while there is a bass guitar in the background. The acoustic drums are playing a basic 4/4 rock beat with claps simultaneous with the snare hits. There is an easygoing atmosphere in this piece. It could be playing in the background of a rock bar. This piece could also work well in sports venues. | ["rock and roll", "blues", "male vocal", "male back vocals", "electric guitar", "bass guitar", "acoustic drums", "american", "repeated theme", "simple tune", "easygoing", "groovy"] | ["Funk", "Music", "Soul music"] | 9 | 50 | 60 | 1 | 1 | ["/m/02x8m", "/m/04rlf", "/m/0gywn"] |
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 );