musiccaps
2 rows where aspect_list contains "soul" and audioset_ids contains "/m/06bxc"
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 |
---|---|---|---|---|---|---|---|---|---|---|
S7R3NMq3MKk | A male vocalist sings this groovy R&B. The tempo is medium with a funky bass guitar, steady guitar, bright electric guitar and keyboard harmony. The song is mellow, emotional, soft, smooth and engaging. This song is an R&B. | ["male singer", "medium tempo", "groovy bass line", "mellow", "smooth", "emotional", "engaging", "steady drumming", "keyboard harmony", "hip-hop", "r&b", "soul", "alternative rap", "rhythmic electric guitar"] | ["Music", "Rapping", "Reggae"] | 7 | 90 | 100 | 0 | 0 | ["/m/04rlf", "/m/06bxc", "/m/06cqb"] | |
ltysCJWnvsI | A male vocalist sings this spirited song. The tempo is medium fast with enthusiastic trumpet, funky keyboard harmony, groovy bass lines, slick drumming and piano accompaniment. The song is simple,spirited, enthusiastic, energetic and buoyant. This song is an R&B/Soul. | ["male singer", "fast tempo", "brass band", "funky keyboard harmony", "piano accompaniment", "vibrant trumpet harmony", "slick drumming", "funky bass lines", "tambourine", "congas", "punchy", "bouncy", "buoyant", "perky", "soul", "r&b’simple melody", "catchy tune"] | ["Music", "Rapping", "Reggae"] | 7 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/06bxc", "/m/06cqb"] |
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 );