musiccaps
1 row where aspect_list contains "crowds cheering" and aspect_list contains "rock singer"
This data as json, CSV (advanced)
aspect_list (array) 22 ✖
- adrenaline rush 1
- ambient crowd noises 1
- bad audio quality 1
- crowds cheering · 1 ✖
- cymbals crashing 1
- enthusiastic 1
- excitement 1
- g]adrenaline rush 1
- groovy bass line 1
- groovy music 1
- guitar rhythm 1
- lifetime experience 1
- live audience 1
- live performance 1
- male singer 1
- passionate 1
- retro rock hits 1
- rock drumming rhythm 1
- rock music 1
- rock singer · 1 ✖
- singing long notes 1
- spirited 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
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 );