musiccaps
2 rows where aspect_list contains "big band" and audioset_ids contains "/m/0l156b"
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 |
---|---|---|---|---|---|---|---|---|---|---|
_fKntnlIYTQ | The low quality recording features a live performance of a big band that consists of shimmering hi hats, steel pan melody, punchy snare, soft kick hits, bright brass melody, groovy double bass melody and cowbell percussion. The recording is a bit noisy and it sounds happy and fun. | ["low quality", "live performance", "noisy", "big band", "shimmering hi hats", "punchy snare", "soft kick hits", "steel pan melody", "bright brass melody", "groovy double bass melody", "cowbell percussion", "fun", "happy"] | ["Music", "Steelpan"] | 4 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/0l156b"] | |
lNg2y6SRZPo | The song is an instrumental. The tempo is fast with trumpets playing percussively along with other brass instruments, piano accompaniment, groovy bass line jazz drumming rhythm. The song is energetic and passionate. The song is a retro big band jazz classic with poor audio quality. | ["instrumental music", "jazz music", "fast jazz drumming", "energetic", "passionate", "retro jazz classics", "jazz super hits", "jazz legends", "big band hits", "trumpets playing percussively", "fast tempo", "piano accompaniment", "fats jazz drumming", "brass section harmony", "groovy bass line", "big band", "poor audio quality", "jazz band"] | ["Music", "Steelpan"] | 1 | 220 | 230 | 1 | 1 | ["/m/04rlf", "/m/0l156b"] |
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 );