musiccaps
2 rows where aspect_list contains "energetic", aspect_list contains "noisy", aspect_list contains "passionate" and aspect_list contains "shimmering cymbals"
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"] | |
ovomUNSo_uo | The low quality recording features a live performance of blues songs and it consists of a harmonica solo melody played over groovy bass, punchy snare, shimmering cymbals and electric guitar melody. As it was recorded with a phone, there are some whistling crowd noises, aside from the fact that the recording is in mono and noisy. It still sounds energetic and passionate. | ["low quality", "whistling sound", "mono", "noisy", "harmonica solo melody", "groovy bass", "punchy snare", "shimmering cymbals", "electric guitar melody", "live performance", "blues", "passionate", "energetic"] | ["Harmonica", "Wind instrument, woodwind instrument"] | 4 | 120 | 130 | 0 | 0 | ["/m/03qjg", "/m/085jw"] |
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 );