musiccaps
1 row where aspect_list contains "bright trumpets" and aspect_list contains "funky"
This data as json, CSV (advanced)
aspect_list (array) 25 ✖
- animated 1
- bright trumpets · 1 ✖
- buoyant 1
- charming 1
- classic rock 1
- electric guitar 1
- fast tempo 1
- funk 1
- funky · 1 ✖
- groovy 1
- happy 1
- infectious drumming 1
- jive music 1
- lively animated 1
- lively cello 1
- male singer 1
- r&b 1
- retro 1
- rock and rock 1
- rock pop 1
- spirited 1
- upbeat 1
- vibrant 1
- vivacious 1
- vocal backup 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
r4nPBNL3D0E | A male vocalist sings this lively Rock song. The tempo is fast with bright trumpet harmony, groovy bass, infectious drumming , electric guitar and vocal backup. The music is upbeat, groovy, funky, high-spirited, vibrant and enthusiastic. This song is Retro Rock and Roll. | ["male singer", "fast tempo", "lively cello", "bright trumpets", "vibrant", "classic rock", "animated", "buoyant", "groovy", "funky", "vibrant", "vivacious", "happy", "charming", "vocal backup", "spirited", "retro", "jive music", "upbeat", "spirited", "infectious drumming", "electric guitar", "lively animated", "rock and rock", "rock pop", "funk", "r&b"] | ["Brass instrument", "Trombone"] | 7 | 0 | 10 | 0 | 0 | ["/m/01kcd", "/m/07c6l"] |
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 );