musiccaps
2 rows where aspect_list contains "energetic", aspect_list contains "groovy bass guitar", aspect_list contains "noisy" and aspect_list contains "passionate"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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"] | |
QZoclbefgak | The low quality recording features a live performance of a rock & roll song performed by passionate female vocal and male vocal ad libs, followed by groovy piano melody, funky electric guitar melody, groovy bass guitar, shimmering hi hats, punchy snare and soft kick hits. It is a bit noisy and there are some subtle microphone feedback sounds in the middle of the performance. It sounds energetic, vintage and passionate. | ["low quality", "male vocal ad libs", "passionate female vocal", "shimmering hi hats", "punchy snare", "soft kick", "groovy bass guitar", "funky electric guitar melody", "groovy piano melody", "rock & roll", "live performance", "subtle microphone feedback", "noisy", "energetic", "passionate", "vintage"] | ["Singing", "Music", "Pop music", "Rock music", "Ska", "Song", "Rock and roll"] | 4 | 30 | 40 | 1 | 1 | ["/m/015lz1", "/m/04rlf", "/m/064t9", "/m/06by7", "/m/06rqw", "/m/074ft", "/m/07sbbz2"] |
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 );