musiccaps
2 rows where aspect_list contains "enthusiastic drumming" and audioset_ids contains "/m/06cqb"
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 |
---|---|---|---|---|---|---|---|---|---|---|
G-7BfzMgZL8 | A male vocalist sings this perky song. The tempo is medium fast with an animated trumpet harmony, intense drumming, keyboard accompaniment and punchy bass lines. The vocals are energetic, vivacious, spirited, lively, rhythmic speech. The song is a Latin Urbano. | ["male vocalist", "medium fast tempo", "vigorous vocals", "enthusiastic drumming", "funky bass lines", "keyboard accompaniment", "energetic", "vibrant", "animated", "rhythmic speech", "latin pop", "regional pop", "world music", "latin urbano", "bright trumpets", "boomy trombone"] | ["Music", "Rapping", "Reggae"] | 7 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/06bxc", "/m/06cqb"] | |
ZPK1hSPI540 | A female vocalist sings this pleasant pop song. The tempo is medium with a keyboard harmony, melodious acoustic guitar harmony, bright drumming , steel pan and the sound of birds chirping. The song is mellow, soft, pleasant, soothing, hopeful, sentimental, sweet and cheerful.this song is a Reggae Pop. | ["female vocalist", "medium tempo", "birds chirping", "melodic acoustic guitar", "steel pan", "enthusiastic drumming", "synthesiser arrangements", "soft", "mellow", "pleasant", "hopeful", "pop", "pop rap", "disco pop", "reggae", "multi genre soundscape", "soothing"] | ["Bird vocalization, bird call, bird song", "Music", "Reggae", "Chirp, tweet", "Outside, rural or natural"] | 7 | 220 | 230 | 0 | 0 | ["/m/020bb7", "/m/04rlf", "/m/06cqb", "/m/07pggtn", "/t/dd00129"] |
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 );