musiccaps
1 row where aspect_list contains "dance groove" and aspect_list contains "rock and rock"
This data as json, CSV (advanced)
aspect_list (array) 12 ✖
- dance groove · 1 ✖
- electric guitar 1
- enthusiastic drumming 1
- jive 1
- lively piano 1
- male singer 1
- medium tempo 1
- popular music 1
- retro 1
- rhythmic acoustic guitar 1
- rock and rock · 1 ✖
- rock and roll 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
d20qTsF6ll8 | A male vocalist sings this upbeat retro song. The tempo is medium with an infectious electronic guitar, hard hitting drums, rhythmic acoustic guitar and funky bass. The song is rhythmic, groovy, upbeat, catchy, and energetic. This song is Retro Rock and Roll. | ["male singer", "medium tempo", "rock and roll", "rhythmic acoustic guitar", "popular music", "retro", "dance groove", "jive", "enthusiastic drumming", "lively piano", "rock and rock", "electric guitar"] | ["Country", "Music"] | 7 | 20 | 30 | 0 | 0 | ["/m/01lyv", "/m/04rlf"] |
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 );