musiccaps
1 row where aspect_list contains "happy" and aspect_list contains "latin song"
This data as json, CSV (advanced)
aspect_list (array) 20 ✖
- banjo 1
- bright drumming 1
- cheerful 1
- enthusiastic 1
- fast tempo 1
- funky bass lines 1
- happy · 1 ✖
- keyboard harmony 1
- latin pop 1
- latin song · 1 ✖
- male vocalist 1
- pandeireta 1
- pleasant 1
- regional music 1
- rhythmic acoustic guitar 1
- spanish guitar 1
- sunny 1
- upbeat 1
- warm 1
- world music 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
CP3phqztym0 | A male vocalist sings this vivacious latin pop song. The tempo is fast with rhythmic Spanish guitar,keyboard harmony, bright drumming, mandolin harmony, groovy bass line and lively pandeira beats. The song is melodic, simple, happy, cheerful, bouncy, peppy , warm and joyful. | ["male vocalist", "fast tempo", "latin pop", "latin song", "banjo", "spanish guitar", "keyboard harmony", "bright drumming", "world music", "regional music", "happy", "cheerful", "enthusiastic", "warm", "sunny", "upbeat", "pleasant", "funky bass lines", "pandeireta", "rhythmic acoustic guitar"] | ["Music", "Soul music"] | 7 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/0gywn"] |
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 );