musiccaps
2 rows where aspect_list contains "brass instrument" and audioset_ids contains "/m/015lz1"
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 |
---|---|---|---|---|---|---|---|---|---|---|
oSg1VJHiPOE | The song has a generally cheerful, happy-go-lucky vibe to it. It's got a male vocalist who has a zesty and vibrant voice, as well as a female vocalist that brings power to the song as well. There's a brass motif that follows one of the phrases by the male vocalist, and the drumming is generally upbeat and jazzy. | ["musical vibes", "duet", "pop", "upbeat pop", "jazzy pop", "cheerful male pop vocal", "energetic female pop vocal", "acoustic guitar strumming", "brass instrument", "happy-go-lucky"] | ["Singing", "Music", "Pop music", "Happy music"] | 3 | 10 | 20 | 1 | 1 | ["/m/015lz1", "/m/04rlf", "/m/064t9", "/t/dd00031"] | |
wIP7AqIOU1s | A male vocalist sings this song. The tempo is medium with loud boomy singing.the audio quality is bad so the music and vocals are muffled. There are traces of tambourine beat, trumpet or some brass instrument,keyboard accompaniment, people talking, chanting and clapping. It is chaotic, confusing and noisy. | ["male vocalist", "muffled audio", "inferior audio quality", "tambourine beats", "boisterous", "chaotic", "confusing", "noisy", "syncopated", "enthusiastic", "energetic", "brass instrument", "clapping", "tambirine", "keyboard accompaniment", "chanting", "talking", "incoherent lyrics", "amateur recording", "loud"] | ["Singing", "Music", "Tambourine", "Vocal music"] | 7 | 30 | 40 | 1 | 1 | ["/m/015lz1", "/m/04rlf", "/m/07brj", "/m/0y4f8"] |
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 );