musiccaps
2 rows where aspect_list contains "hollow snare" and aspect_list contains "shimmering hi hats"
This data as json, CSV (advanced)
aspect_list (array) 20 ✖
- hollow snare · 2 ✖
- low quality 2
- shimmering hi hats · 2 ✖
- brass melody 1
- dissonant female vocal 1
- electric guitar melody 1
- energetic 1
- groovy 1
- groovy bass 1
- groovy double bass 1
- jazz 1
- noisy 1
- passionate 1
- rock 1
- saxophone solo melody 1
- shimmering shakers 1
- sloppy 1
- soft kick hits 1
- unbalanced stereo 1
- uptempo 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
YddV91xnUz4 | The low quality recording features a rock song where dissonant female vocals are singing over electric guitar melody, groovy bass guitar, hollow snare, shimmering hi hats and soft kick hits. It sounds sloppy and the recording is noisy. | ["low quality", "rock", "unbalanced stereo", "noisy", "electric guitar melody", "dissonant female vocal", "shimmering hi hats", "groovy bass", "hollow snare", "soft kick hits", "sloppy"] | ["Singing", "Ska"] | 4 | 310 | 320 | 0 | 0 | ["/m/015lz1", "/m/06rqw"] | |
bxZeGrM_0ac | The low quality recording features a jazz song that consists of a saxophone solo melody played over hollow snare, groovy double bass, shimmering hi hats, shimmering shakers and brass melody. It sounds uptempo, groovy and passionate - like something you would hear in a jazz club. | ["low quality", "jazz", "uptempo", "groovy", "passionate", "saxophone solo melody", "hollow snare", "groovy double bass", "shimmering hi hats", "shimmering shakers", "brass melody", "energetic"] | ["Brass instrument", "Saxophone"] | 4 | 400 | 410 | 0 | 0 | ["/m/01kcd", "/m/06ncr"] |
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 );