musiccaps
2 rows where aspect_list contains "groovy bass" and audioset_ids contains "/m/05pd6"
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 |
---|---|---|---|---|---|---|---|---|---|---|
6J3X0whM_-4 | The low quality recording features a steel pans melody, shimmering hi hats, syncopated snare and "4 on the floor" kick pattern. It is a bit reverberant as it was played in a concert hall. There are some crowd cheering and applause sounds. It sounds exotic, fun and happy. | ["low quality", "steel pans melody", "reverberant", "shimmering hi hats", "syncopated snare", "\"4 on the floor\" kick pattern", "groovy bass", "crowd cheering", "applause", "exotic", "fun", "happy"] | ["Music", "Musical instrument", "Orchestra", "Percussion", "Steelpan"] | 4 | 310 | 320 | 0 | 1 | ["/m/04rlf", "/m/04szw", "/m/05pd6", "/m/0l14md", "/m/0l156b"] | |
ChqJYrmQIN4 | The low quality recording features a live performance of a folk song that consists of an accordion melody playing over groovy bass, shimmering hi hats, punchy snare and electric guitar melody. There are crowd chattering noises in the background. It sounds passionate and groovy. | ["low quality", "live performance", "crowd chattering", "folk", "groovy bass", "accordion melody", "electric guitar melody", "shimmering hi hats", "punchy snare", "passionate", "groovy"] | ["Singing", "Traditional music", "Music", "Musical instrument", "Orchestra", "Speech", "Music of Latin America", "Accordion"] | 4 | 50 | 60 | 0 | 0 | ["/m/015lz1", "/m/02p0sh1", "/m/04rlf", "/m/04szw", "/m/05pd6", "/m/09x0r", "/m/0g293", "/m/0mkg"] |
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 );