musiccaps
2 rows where audioset_ids contains "/m/02cz_7" and author_id = 1
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 |
---|---|---|---|---|---|---|---|---|---|---|
9r01cpNx2vk | The song is an acapella cover of a game theme song. The song is medium tempo with no instrumentation by different male vocals engaging in different vocal mimicry of actual instruments, like bass line, melody , percussion and harmony tones. The song is cheerful and amateurish in production. The song is a cover of a popular game theme. | ["beatbox music", "game tune cover", "male singers", "children’s favourite", "retro game theme", "amateur production", "cheerful", "fun venture", "vocal mimicry", "game theme song cover", "vocal harmony", "spitting vocals", "rolling tongues", "playful", "game song cover", "medium tempo", "no instrumentation", "vocal acapella", "cheerful", "amateur recording"] | ["Beatboxing", "Music"] | 1 | 10 | 20 | 0 | 1 | ["/m/02cz_7", "/m/04rlf"] | |
kZPz8ExTzBk | A male beatboxer creates a cool groove with animated sounds like grunting and mouth percussion. The song is medium tempo with no other instrumentation. The song is energetic and passionate. The song has bad audio quality. | ["male singer", "beatboxing", "medium tempo", "energetic", "passionate", "live performance", "ambient noises", "beatboxer", "spirited", "animated sounds", "grunting noises", "soloist", "entertainer", "performer", "groovy rhythm", "animated interactions", "bad audio quality"] | ["Beatboxing", "Vocal music"] | 1 | 280 | 290 | 0 | 0 | ["/m/02cz_7", "/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 );