musiccaps
2 rows where aspect_list contains "energetic", aspect_list contains "groovy bass guitar", aspect_list contains "passionate" and aspect_list contains "punchy kick"
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 |
---|---|---|---|---|---|---|---|---|---|---|
1QFli7KSXAQ | The Rock song features a passionate male vocalist singing over wide electric guitar melodies, groovy bass guitar, shimmering cymbals, groovy toms, punchy snare and kick hits. It sounds energetic, passionate, emotional and loud. | ["rock", "punchy kick", "punchy snare", "groovy toms", "wide electric guitars melodies", "groovy bass guitar", "shimmering cymbals", "passionate male vocal", "energetic", "passionate", "emotional", "loud"] | ["Disco", "Music"] | 4 | 30 | 40 | 0 | 0 | ["/m/026z9", "/m/04rlf"] | |
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"] |
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 );