musiccaps
2 rows where aspect_list contains "groovy double bass", aspect_list contains "jazz" and aspect_list contains "uptempo"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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"] | |
oBwt8T8P8Zs | The Jazz song features reverberant saxophones and trumpet melodies playing over groovy double bass, groovy piano melody, shimmering cymbals and soft kick hits. It sounds uptempo, groovy and passionate, like something you would hear in traditional jazz bars. | ["jazz", "reverberant saxophone", "trumpet melody", "shimmering cymbals", "soft kick hits", "groovy double bass", "groovy piano melody", "groovy", "uptempo", "passionate"] | ["Swing music", "Jazz", "Music"] | 4 | 380 | 390 | 0 | 0 | ["/m/015y_n", "/m/03_d0", "/m/04rlf"] |
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 );