musiccaps
2 rows where aspect_list contains "noisy", aspect_list contains "shimmering cymbals" and aspect_list contains "uptempo"
This data as json, CSV (advanced)
aspect_list (array) 20 ✖
- low quality 2
- noisy · 2 ✖
- passionate 2
- shimmering cymbals · 2 ✖
- uptempo · 2 ✖
- clapping 1
- cool 1
- country blues 1
- energetic 1
- fruity male vocal 1
- groovy 1
- groovy bass 1
- groovy bass guitar 1
- groovy electric guitar melodies 1
- groovy organ keys 1
- mellow snare 1
- punchy kick 1
- punchy snare 1
- soft kick hits 1
- vintage 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
6gTrMRQPZMU | The low quality recording features groovy organ keys played over punchy kick and snare hits, shimmering cymbals and groovy bass guitar. It sounds energetic, passionate and uptempo. The recording is noisy. | ["low quality", "uptempo", "noisy", "groovy organ keys", "punchy snare", "punchy kick", "groovy bass guitar", "shimmering cymbals", "energetic", "passionate"] | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | 4 | 200 | 210 | 0 | 0 | ["/m/013y1f", "/m/01s0ps", "/m/03xq_f", "/m/05148p4", "/m/05r5c"] | |
ZzyWbehtt0M | The low quality recording features a country blues song that consists of fruity male vocal singing over groovy electric guitar melodies, groovy bass, shimmering cymbals, mellow snare, soft kick hits and clapping. The recording is a bit noisy, as it is vintage, and it sounds passionate, groovy, uptempo and cool. | ["low quality", "country blues", "vintage", "noisy", "fruity male vocal", "groovy electric guitar melodies", "groovy bass", "shimmering cymbals", "mellow snare", "soft kick hits", "clapping", "uptempo", "groovy", "passionate", "cool"] | ["Blues", "Singing", "Swing music", "Country", "Music", "Rhythm and blues", "Music of Latin America"] | 4 | 30 | 40 | 0 | 0 | ["/m/0155w", "/m/015lz1", "/m/015y_n", "/m/01lyv", "/m/04rlf", "/m/06j6l", "/m/0g293"] |
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 );