musiccaps_details (view)
2 rows where musiccaps_aspects contains "dj scratching sound effects" and musiccaps_names contains "Scratch"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- dj scratching sound effects · 2 ✖
- hip hop 2
- low quality 2
- punchy snare 2
- addictive 1
- addictive staccato violin melody 1
- arpeggiated electric guitar melody 1
- boomy bass 1
- bouncy 1
- bouncy kick 1
- claps 1
- energetic 1
- flat filtered male vocal 1
- groovy 1
- groovy bass 1
- haunting female vocals melody 1
- mono 1
- wide shimmering cymbals 1
musiccaps_names (array) 5 ✖
- Music 2
- Scratch · 2 ✖
- Musical instrument 1
- Scratching (performance technique) 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
violon vs scratch | The low quality recording features a hip hop song that contains boomy bass, punchy snare layered with claps, DJ scratching sound effects, addictive staccato violin melody and haunting female vocals melody in the background. The recording is in mono and it sounds energetic and addictive, regardless of the quality of the recording. | 2008-02-16T03:18:15Z | Finnels Workshop | c trop mortel style hip hop associé au style celtik ca donne un mix kje kiffe a mort | ["Scratching (performance technique)", "Music", "Musical instrument", "Scratch", "Violin, fiddle"] | ["low quality", "mono", "hip hop", "boomy bass", "punchy snare", "claps", "dj scratching sound effects", "addictive staccato violin melody", "haunting female vocals melody", "energetic", "addictive"] | 4 | A_oaLt-n4fQ | 1137 | |
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 |
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;