musiccaps
2 rows where aspect_list contains "dj set" and aspect_list contains "urban"
This data as json, CSV (advanced)
aspect_list (array) 12 ✖
- dj set · 2 ✖
- scratching 2
- turntable 2
- urban · 2 ✖
- dance 1
- dirty sound 1
- electronic drums 1
- groovy 1
- groovy bass 1
- guitar sample 1
- live performance 1
- mellow drums 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
Fa1c4qfBqzE | This is the recording of a DJ performance. In the rhythmic background, the electronic drums are playing a simple yet groovy beat. The DJ is scratching the turntable rapidly over this track. The piece is danceable. It has a dirty mix. Parts of this piece can be used as turntable samples for a beat. It could also be used in the soundtrack of a show with a big city setting. | ["dj set", "scratching", "turntable", "electronic drums", "dirty sound", "groovy", "dance", "urban"] | ["Music", "Scratch"] | 9 | 22 | 32 | 0 | 1 | ["/m/04rlf", "/m/07qb_dv"] | |
XYOnq7ju7o0 | This is a live DJ performance. There is a groovy bass line and a mellow electronic drum beat in the rhythmic background accompanied by the tune of a melodic guitar sample. The turntable is used to make a scratching sound over this track. There is an urban feeling to this piece. It could be used in the soundtrack of a crime movie/TV show taking place in the big city. It could be used in the background of an interesting sports video. | ["dj set", "live performance", "scratching", "turntable", "groovy bass", "mellow drums", "guitar sample", "urban"] | ["Scratching (performance technique)", "Music"] | 9 | 30 | 40 | 1 | 1 | ["/m/01hgjl", "/m/04rlf"] |
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 );