musiccaps
1 row where aspect_list contains "electric" and aspect_list contains "keyboard harmony"
This data as json, CSV (advanced)
aspect_list (array) 18 ✖
- boomy sound 1
- bright electric guitar 1
- classic rock 1
- distorted sound 1
- electric · 1 ✖
- energetic 1
- enthusiastic 1
- fast tempo 1
- funky bass line 1
- intense drumming 1
- keyboard harmony · 1 ✖
- male vocalist 1
- poor audio quality 1
- retro 1
- rock 1
- rock hits 1
- vibrant 1
- vivacious 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
yesyhQkYrQM | A male vocalist sings this spirited Rock song. The tempo is fast with hard hitting drumming, punchy bass lines, electric guitar lead and keyboard harmony. The song is a vibrant, energetic, enthusiastic, engaging, catchy and upbeat Classic Rock. | ["male vocalist", "fast tempo", "funky bass line", "retro", "rock", "rock hits", "poor audio quality", "boomy sound", "distorted sound", "intense drumming", "bright electric guitar", "keyboard harmony", "classic rock", "electric", "energetic", "enthusiastic", "vivacious", "vibrant"] | ["Music", "Psychedelic rock"] | 7 | 180 | 190 | 1 | 1 | ["/m/04rlf", "/m/05w3f"] |
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 );