musiccaps
1 row where aspect_list contains "electric bass guitar" and aspect_list contains "spirited"
This data as json, CSV (advanced)
aspect_list (array) 20 ✖
- a keyboard harmony 1
- amplified instruments 1
- boisterous 1
- electric bass guitar · 1 ✖
- energetic electric guitar lead 1
- enthusiastic 1
- fast tempo 1
- hard hitting drums 1
- hard rock 1
- intense 1
- live performance 1
- male vocalist 1
- metal 1
- passionate 1
- rock concert 1
- rock hits 1
- sonic power 1
- spirited · 1 ✖
- vigorous 1
- vociferous 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
M_s-49rNCdw | A male vocalist sings this spirited song. The song is medium tempo with energetic electric guitar lead, enthusiastic electric bass guitar , hard hitting drums and keyboard harmony. The vocals are passionate, youthful,energetic, vociferous, powerful and loud . This song is Hard Rock/Metal. | ["male vocalist", "fast tempo", "hard rock", "rock hits", "rock concert", "live performance", "spirited", "boisterous", "metal", "hard hitting drums", "energetic electric guitar lead", "electric bass guitar", "enthusiastic", "sonic power", "amplified instruments", "vigorous", "passionate", "intense", "vociferous", "a keyboard harmony"] | ["Singing", "Music", "Roll", "Yell"] | 7 | 50 | 60 | 0 | 1 | ["/m/015lz1", "/m/04rlf", "/m/07s8j8t", "/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 );