musiccaps
2 rows where aspect_list contains "retro rock hits" and audioset_ids contains "/m/06by7"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Ztlcnd14Kn4 | A male singer sings this rock melody with backup singers in vocal harmony. The song is fast tempo with a strong drumming rhythm , percussive bass line, amplified guitar playing lead. The song is energetic and romantic. The song is a retro rock song with average audio quality. | ["make singer", "fast tempo", "rock band", "backup singers", "vocal harmony", "strong rock drumming", "distorted guitar rhythm", "guitar playing lead", "tambourine percussions", "cymbals crashing", "emotional", "romantic", "groovy rhythm", "high in adrenaline", "passionate", "spirited", "retro rock hits", "average audio quality"] | ["Singing", "Heavy metal", "Music", "Punk rock", "Independent music", "Rock music", "Progressive rock", "Grunge"] | 1 | 30 | 40 | 0 | 1 | ["/m/015lz1", "/m/03lty", "/m/04rlf", "/m/05r6t", "/m/05rwpb", "/m/06by7", "/m/0dl5d", "/m/0dls3"] | |
pHC25Ia8Dxo | A male rock singer sings this climatic solo with a long sustained note. The tempo is medium with strong rock drumming, guitar rhythm; guitar lead and a percussive bass line. The song is hard rock with a lot of spirit and excitement. The audio quality is bad with a lot of ambient crowd noises. | ["live performance", "bad audio quality", "singing long notes", "rock singer", "male singer", "crowds cheering", "rock music", "rock drumming rhythm", "cymbals crashing", "live audience", "ambient crowd noises", "groovy bass line", "guitar rhythm", "g]adrenaline rush", "lifetime experience", "groovy music", "excitement", "enthusiastic", "adrenaline rush", "passionate", "spirited", "retro rock hits"] | ["Singing", "Music", "Rock music", "Yell"] | 1 | 80 | 90 | 0 | 0 | ["/m/015lz1", "/m/04rlf", "/m/06by7", "/m/07sr1lc"] |
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 );