musiccaps
2 rows where aspect_list contains "dj" and audioset_ids contains "/m/0l14md"
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 |
---|---|---|---|---|---|---|---|---|---|---|
W5BB6pubJZI | The song is an instrumental. The tempo is variable with two different soundtracks with snare play, sitar accompaniment, techno drumming and keyboard accompaniment. The song is a techno dance rhythm. The audio has average audio quality. | ["male singer", "drums playing", "sitar music", "average audio quality", "hip hop music", "youtube music video", "fitness videos", "techno dance music", "snares playing", "instrumental music", "dj", "advertisement jingle", "modulated vocals", "techno dance rhythm", "electronics", "auto tune", "groovy rhythm"] | ["Drum", "Drum roll", "Percussion"] | 1 | 540 | 550 | 0 | 0 | ["/m/026t6", "/m/02k_mr", "/m/0l14md"] | |
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 );