musiccaps
1 row where aspect_list contains "rhythmic acoustic guitar" and aspect_list contains "slick drumming"
This data as json, CSV (advanced)
aspect_list (array) 18 ✖
- acoustic guita 1
- ambient 1
- engaging 1
- female vocalist 1
- funky bass line 1
- groovy 1
- groovy electric guitar 1
- medium tempo 1
- mellow 1
- melodic 1
- no lyrics 1
- perky 1
- pop 1
- rhythmic acoustic guitar · 1 ✖
- simple beat 1
- slick drumming · 1 ✖
- smooth 1
- vocalisation 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
c9tRbWSk7c4 | This song is a vocalisation by a female singer. The tempo is medium with an upbeat electronic guitar harmony, funky bass guitar, slick drumming and acoustic guitar accompaniment. The music is simple, engaging, pleasant, melodic, engaging and has a perky groove. | ["female vocalist", "vocalisation", "groovy", "perky", "no lyrics", "medium tempo", "groovy electric guitar", "funky bass line", "rhythmic acoustic guitar", "mellow", "melodic", "engaging", "slick drumming", "pop", "no lyrics", "simple beat", "ambient", "smooth", "acoustic guita"] | ["Electric guitar", "Music", "Song", "/t/dd00032"] | 7 | 30 | 40 | 0 | 1 | ["/m/02sgy", "/m/04rlf", "/m/074ft", "/t/dd00032"] |
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 );