musiccaps
2 rows where aspect_list contains "energetic", aspect_list contains "folk", aspect_list contains "low quality" 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 |
---|---|---|---|---|---|---|---|---|---|---|
GuHDy--gWiM | The low quality recording features a live performance of a folk song and it contains a steel guitar solo melody played over, acoustic rhythm guitar, electric guitar melody, shimmering cymbals, punchy snare, groovy bass, followed by violin melody, crowd noises and claps. It sounds passionate, uptempo, soulful and energetic. | ["low quality", "folk", "live performance", "wide clapping", "crowd noises", "steel guitar solo melody", "acoustic rhythm guitar melody", "groovy bass", "punchy snare", "shimmering cymbals", "electric guitar melody", "violin melody", "passionate", "uptempo", "soulful", "energetic"] | ["Banjo", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | 4 | 30 | 40 | 0 | 0 | ["/m/018j2", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y"] | |
kMmjr8deHis | The low quality recording features a folk song that consists of an echoing male chant over punchy kick and snare hits, wooden percussion, addictive strings and brass melodies and simple bass. It sounds traditional, addictive, passionate and energetic. The recording is noisy and in mono. | ["low quality", "mono", "noisy", "folk", "echoing male chant", "punchy snare", "punchy kick", "addictive strings melody", "addictive brass melody", "traditional", "addictive", "passionate", "wooden percussions", "simple bass", "energetic"] | ["Bagpipes", "Wind instrument, woodwind instrument"] | 4 | 40 | 50 | 0 | 0 | ["/m/0192l", "/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 );