musiccaps
3 rows where aspect_list contains "drums" and audioset_ids contains "/m/07s8j8t"
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 |
---|---|---|---|---|---|---|---|---|---|---|
0pewITE1550 | The song is an instrumental. The song is medium tempo with various marching band drums playing in sync. The song is highly energetic and spirited. The song is bad in audio quality. The song is a college marching band playing enthusiastically. | ["poor audio quality", "medium tempo", "instrumental music", "groovy rhythm", "various percussion instruments", "steady drum rhythm", "various percussion hits", "snares", "drums", "drum sticks", "dance rhythm", "samba", "cheerleaders", "college band", "marching band", "enthusiastic", "passionate", "energetic", "high on adrenaline"] | ["Music", "Roll"] | 1 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07s8j8t"] | |
OFP5MYVDa4g | The punk-rock music features a male voice singing a static melody. An electric guitar with a distortion effect accompanies the singer with repetitive chords. The drums play a simple and repetitive rhythm. | ["male voice", "static melody", "drums", "electric guitar", "distortion effect", "punk-rock genre"] | ["Music", "Roll", "Rock and roll"] | 2 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07s8j8t", "/m/07sbbz2"] | |
wMi_0eEIpcM | This is a live recording from a rock music concert. There is an electric guitar playing the rhythm section upfront with a loud drum background. A harmonica solo is being played over the guitar and the drums. The song carries a playful and energetic atmosphere. This music could be played at a bar, especially a rock bar. | ["rock", "electric guitar", "drums", "harmonica", "live performance", "loud", "playful"] | ["Drum kit", "Music", "Musical instrument", "Rock music", "Roll", "Rock and roll", "Percussion"] | 9 | 220 | 230 | 1 | 1 | ["/m/02hnl", "/m/04rlf", "/m/04szw", "/m/06by7", "/m/07s8j8t", "/m/07sbbz2", "/m/0l14md"] |
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 );