musiccaps
1 row where aspect_list contains "latin pop" and aspect_list contains "regional pop"
This data as json, CSV (advanced)
aspect_list (array) 16 ✖
- animated 1
- boomy trombone 1
- bright trumpets 1
- energetic 1
- enthusiastic drumming 1
- funky bass lines 1
- keyboard accompaniment 1
- latin pop · 1 ✖
- latin urbano 1
- male vocalist 1
- medium fast tempo 1
- regional pop · 1 ✖
- rhythmic speech 1
- vibrant 1
- vigorous vocals 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 |
---|---|---|---|---|---|---|---|---|---|---|
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"] |
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 );