musiccaps_details (view)
2 rows where musiccaps_aspects contains "upbeat", musiccaps_author = 9 and musiccaps_names contains "Scratching (performance technique)"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- electronic drums 2
- scratching 2
- upbeat · 2 ✖
- dance 1
- dj performance 1
- drum & bass 1
- eerie 1
- electronic dance music 1
- energetic 1
- hip-hop breakbeat 1
- hollering sample 1
- kids performance 1
- live recording 1
- modern sound 1
- synth 1
- turntable 1
- urban 1
musiccaps_names (array) 4 ✖
- Music 2
- Scratching (performance technique) · 2 ✖
- Drum and bass 1
- Scratch 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
tenminmix 2009 jump up drum and bass | This is a drum & bass music piece. There is a constantly repeating hollering sample accompanied by rapid turntable scratching. A synth sound can be heard playing an ominous tune. The rhythmic background consists of a fast-tempo electronic drum beat. The atmosphere is energetic. This piece could be used in the soundtrack of a car racing game. It could also be playing at nightclubs during early-2000s themed parties. | 2009-09-12T09:36:43Z | morbid1980 | another fresh mini mix from myself....little bit of scratching at the start as well tracklisting tantrum desire - electric brain cabbie - come in cabbie - woke up erb n dub - bass deli j - fight club DP - day off catch my sets on www.reflectfm.net | ["Scratching (performance technique)", "Drum and bass", "Music", "Scratch"] | ["drum & bass", "electronic dance music", "hollering sample", "scratching", "synth", "electronic drums", "upbeat", "energetic", "eerie"] | 9 | -Dtir74TiUM | 28 | |
DJ Kids Scratching! | This is a DJ performance recording of two kids scratching a turntable. The turntable is being scratched over a hip-hop breakbeat that consists of a loud electronic drum beat. The atmosphere is danceable and there is an urban sound. This piece could be played at sports venues. It could also be sampled for use in beat-making. | 2007-09-14T19:58:53Z | valentinesday01 | this little dudes get down on the turntables!! Yeah they're bad asses. For those who continue to say it's fake check out their page: Sarahscratch. Their names are DJ Sara and DJ Ryusei. | ["Scratching (performance technique)", "Music"] | ["dj performance", "live recording", "kids performance", "turntable", "scratching", "hip-hop breakbeat", "electronic drums", "dance", "urban", "upbeat", "modern sound"] | 9 | WiAFUo2nxIk | 3129 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;