musiccaps
2 rows where aspect_list contains "groovy piano melody" and audioset_ids contains "/m/015y_n"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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"] | |
qET3h3w35EA | The Regional Mexican song features a passionate female vocal singing over groovy piano melody, wide muffled brass section melody layered with soft crashes and percussive elements. The recording is low quality and vintage, but it still sounds passionate and emotional - like something you would dance to in a latin pub. | ["regional mexican", "groovy piano melody", "wide muffled brass section", "passionate female vocal", "percussive elements", "soft crashes", "low quality", "vintage", "passionate", "emotional"] | ["Swing music", "Music", "Orchestra", "Music of Latin America", "Salsa music"] | 4 | 110 | 120 | 1 | 1 | ["/m/015y_n", "/m/04rlf", "/m/05pd6", "/m/0g293", "/m/0ln16"] |
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 );