musiccaps
1 row where aspect_list contains "live band performance" and aspect_list contains "piano accompaniment"
This data as json, CSV (advanced)
aspect_list (array) 21 ✖
- adrenaline rush 1
- backup singers 1
- barking tones 1
- brass band 1
- energetic 1
- exciting 1
- groovy rhythm 1
- guitar rhythm 1
- latin dance 1
- latin dance music 1
- latin percussions 1
- live band performance · 1 ✖
- live performance 1
- male singer 1
- passionate 1
- piano accompaniment · 1 ✖
- poor audio quality 1
- salsa 1
- trumpets blaring 1
- ttrumelts blaring 1
- vocal harmony 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
RlrNPBfOowg | A male singer sings this Latin melody with backup singers in vocal harmony. The song is medium tempo with a brass band accompaniment, latin percussion and guitar accompaniment. The song is exciting and spirited. The song is perfect for Latin dancing. The song has a poor audio quality. | ["latin dance music", "male singer", "live band performance", "trumpets blaring", "vocal harmony", "piano accompaniment", "exciting", "energetic", "passionate", "latin dance", "salsa", "passionate", "adrenaline rush", "groovy rhythm", "backup singers", "vocal harmony", "ttrumelts blaring", "brass band", "barking tones", "latin percussions", "guitar rhythm", "poor audio quality", "live performance"] | ["Music", "Salsa music"] | 1 | 160 | 170 | 0 | 1 | ["/m/04rlf", "/m/0ln16"] |
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 );