musiccaps
2 rows where aspect_list contains "acoustic drums" and audioset_ids contains "/m/0ggx5q"
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 |
---|---|---|---|---|---|---|---|---|---|---|
0RcMzUdXDRQ | This is a song for children. The song is in major key as is usual with almost all kids songs. There is a female vocalist in the lead. The melody is being played by an acoustic guitar while a bass guitar plays a simple bass line. The electric guitar is playing delayed notes for texture. The acoustic drums are playing a basic medium tempo beat in the rhythmic background. The atmosphere is easygoing. This piece could be used during activities in a kindergarten. | ["children's song", "female vocal", "acoustic guitar", "electric guitar", "bass guitar", "acoustic guitar", "repeated theme", "acoustic drums", "simple", "easygoing", "playful", "medium tempo"] | ["Jazz", "Music", "Dance music"] | 9 | 30 | 40 | 0 | 1 | ["/m/03_d0", "/m/04rlf", "/m/0ggx5q"] | |
Ade0UZnb6dw | This is a modern sounding Afrobeat music piece. There is a male vocal singing the same line repeatedly vocal with a male back vocal ad-libbing in the background. The electric guitar is playing a mellow tune. A low-to-medium range bass line that can be heard. The rhythm consists of an acoustic drum beat with supporting percussive elements. Brass stabs can be heard every now and then. The atmosphere is groovy. This piece could be played at African nightclubs or dance clubs. | ["afrobeat", "modern sound", "male vocal", "repeated theme", "electric guitar", "bass guitar", "acoustic drums", "percussion", "brass stab", "energetic", "groovy", "danceable"] | ["Blues", "Music", "Dance music"] | 9 | 30 | 40 | 0 | 0 | ["/m/0155w", "/m/04rlf", "/m/0ggx5q"] |
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 );