musiccaps
1 row where aspect_list contains "piano" and audioset_ids = "["/m/0164x2", "/m/04rlf", "/m/06bxc", "/m/06j6l", "/m/0gywn"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
LF-5BAUGvWI | This song is a classical flamenco mixed with a HipHop groove drums playing a digital set along with a cowbell sound. A piano is playing a salsa melody in the low to high range. A trumpet sample is playing a short melody every fourth beat. A male voice is singing in a higher pitch along with backing vocals spread across both sides of the speakers. Then another male voice takes over rapping over the instrumental. This song may be playing with a speaker sitting on the bike cruising. | ["salsa/hiphop", "digital drums", "cowbell", "trumped sample", "piano", "male voices singing/rapping", "uptempo", "positive vibes"] | ["Music of Africa", "Music", "Rapping", "Rhythm and blues", "Soul music"] | 6 | 30 | 40 | 0 | 1 | ["/m/0164x2", "/m/04rlf", "/m/06bxc", "/m/06j6l", "/m/0gywn"] |
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 );