musiccaps
2 rows where aspect_list contains "relaxing" and audioset_ids contains "/m/026t6"
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 |
---|---|---|---|---|---|---|---|---|---|---|
cQpK9zs_uv0 | This is the live performance of a percussion piece. There is a playful sounding jazz steel pan solo being performed on stage. The atmosphere is easygoing. This piece could be used during tropical scenery shots in a movie with a summer/vacation theme. | ["percussion", "rhythm", "live performance", "instrumental", "jazz steel pan", "playful", "relaxing", "easygoing"] | ["Organ", "Drum", "Drum kit", "Jazz", "Electronic organ", "Music", "Musical instrument", "Percussion", "Steelpan"] | 9 | 220 | 230 | 0 | 0 | ["/m/013y1f", "/m/026t6", "/m/02hnl", "/m/03_d0", "/m/03xq_f", "/m/04rlf", "/m/04szw", "/m/0l14md", "/m/0l156b"] | |
f8QGA4vN6HY | The song is an instrumental. The tempo is fast with a groovy jazz drumming rhythm with good brush works, strong bass line, piano accompaniment and various percussion hits. The song is groovy and energetic. The song is jazz fusion. | ["jazz music", "groovy bass line", "jazz fusion", "dance rhythm", "dj", "modern jazz hits", "documentary soundtrack", "dancing all night", "sophisticated", "piano accompaniment", "brush work", "fast tempo", "instrumental music", "relaxing", "passionate", "techno jazz line", "funk music", "entertaining"] | ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 1 | 0 | 10 | 0 | 0 | ["/m/01qbl", "/m/026t6", "/m/02hnl", "/m/03qtq", "/m/03t3fj", "/m/06rvn", "/m/0bm02", "/m/0l14md"] |
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 );