musiccaps_details (view)
2 rows where musiccaps_aspects contains "dj scratching sound effects" and musiccaps_aspects contains "groovy bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- dj scratching sound effects · 2 ✖
- groovy bass · 2 ✖
- low quality 2
- aggressive 1
- arpeggiated electric guitar melody 1
- bouncy 1
- bouncy kick 1
- buzzy synth leads 1
- claps 1
- energetic 1
- flat filtered male vocal 1
- groovy 1
- hip hop 1
- punchy "4 on the floor" kick pattern 1
- punchy snare 1
- shimmering hi hats 1
- techno 1
- weird 1
- wide shimmering cymbals 1
musiccaps_names (array) 5 ✖
- Music 2
- Electronic music 1
- House music 1
- Scratch 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DJ MOUSS - SCRATCH ROOM ( SEASON I - EP.V ) TEASER | The low quality recording features a hip hop song being scratched by the DJ. The song features a filtered flat male vocal, punchy snare, bouncy kick, widely spread shimmering cymbals, groovy bass and arpeggiated electric guitar melody. It sounds bouncy and groovy, as the DJ is probably practicing his scratching skills. | 2014-09-23T15:14:17Z | DJ Mouss | DJ MOUSS - SCRATCH ROOM ( SEASON I - EP.V ) TEASER DJ MOUSS CONTACT: Melany@djmouss.com http://www.djmouss.com http://www.vimeo.com/djmouss http://www.twitter.com/DJMouss http://www.soundcloud.com/dj-mouss http://www.facebook.com/World.DjMouss | ["Music", "Scratch"] | ["low quality", "hip hop", "dj scratching sound effects", "punchy snare", "groovy bass", "flat filtered male vocal", "arpeggiated electric guitar melody", "bouncy kick", "groovy", "bouncy", "wide shimmering cymbals"] | 4 | EzP7PB2x670 | 1606 | |
Dancing to Techno Music | The low quality recording features a techno song that consists of DJ scratching sound effects, groovy bass, buzzy synth leads, punchy "4 on the floor" kick pattern, shimmering hi hats and some claps. It sounds energetic, aggressive and weird - due to those synth lead "screams". | 2007-10-27T05:55:40Z | Sebastien Verrot | A french dancer, Spoke, dancing to techno music with a combination of smurf, break dance and tecktonik. | ["Electronic music", "House music", "Music", "Techno"] | ["techno", "low quality", "dj scratching sound effects", "groovy bass", "buzzy synth leads", "punchy \"4 on the floor\" kick pattern", "shimmering hi hats", "claps", "energetic", "weird", "aggressive"] | 4 | nvoGwmKh6NI | 4592 |
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;