musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "hip hop" and musiccaps_author = 4 sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- groovy 4
- hip hop · 4 ✖
- low quality 4
- groovy bass 3
- punchy snare 3
- energetic 2
- punchy kick 2
- shimmering hi hats 2
- arpeggiated electric guitar melody 1
- background male vocals 1
- bouncy 1
- bouncy kick 1
- brass melody 1
- bright wide steel guitar melody 1
- camera shuttering sound effects 1
- claps 1
- dj scratching sound effects 1
- dull 1
- echoing male vocal 1
- electric guitar melody 1
- exciting 1
- flat filtered male vocal 1
- flat male vocal 1
- funky electric guitar 1
- groovy synth keys melody 1
- low pitched male vocal 1
- low toms 1
- mellow synth pad 1
- reverberant flute melody 1
- reversed crash cymbal riser 1
- shimmering triangle 1
- soft kick 1
- tinny muffled percussive elements 1
- tropical 1
- wide shimmering cymbals 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
New York State Of Mind - Cuban Link, Poe Rilla & Mysonne (OFFICIAL VIDEO) | The low quality recording features hip hop song that contains a low pitched male vocal singing over some camera shuttering sound effects, after which an echoing male vocal starts rapping over punchy kick and snare hits, low toms, electric guitar melody, reversed crash cymbal riser and shimmering hi hats. It sounds groovy. | 2011-07-02T06:00:06Z | 326MUZIK | 3.2.6 Muzik Presents Cuban Link, Mysonne & PoeRilla.... Ny State Of Mind !!! Directed By Picture Perfect Produced By The Salazar Brothers | ["Music", "Single-lens reflex camera", "Hip hop music"] | ["low quality", "low pitched male vocal", "camera shuttering sound effects", "punchy kick", "punchy snare", "electric guitar melody", "reversed crash cymbal riser", "shimmering hi hats", "echoing male vocal", "hip hop", "groovy", "low toms"] | 4 | I06TOd9pXng | 1861 | |
Antaeus - Kyrie (Official Music) | The low quality recording features a hip hop song that consists bright, widely spread steel guitar melody, tinny muffled percussive elements, shimmering triangle, reverberant flute melody, claps, soft kick hits, mellow synth pad and groovy bass that glues everything together. It sounds kind of dull, but groovy, energetic and tropical - thanks to those flute and guitar melodies. | 2015-02-12T11:31:28Z | A L P H A | ["Traditional music", "Music"] | ["low quality", "hip hop", "tinny muffled percussive elements", "bright wide steel guitar melody", "shimmering triangle", "reverberant flute melody", "claps", "soft kick", "groovy bass", "mellow synth pad", "dull", "energetic", "tropical", "groovy"] | 4 | HS_ikHx4LIQ | 1803 | ||
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 | |
Fabolous, Jay Z, & Young Jeezy F A B O L O U S Vol 2 Block On Smash | The low quality recording features a hip hop song that consists of a flat male vocal, alongside some background male vocals, rapping over punchy kick and snare hits, shimmering hi hats, funky electric guitar, brass melody, groovy synth keys melody and groovy bass. It sounds energetic, groovy and exciting. | 2009-08-07T17:12:38Z | briellehursl21 | ["Music", "Rapping", "Hip hop music"] | ["hip hop", "punchy snare", "punchy kick", "funky electric guitar", "brass melody", "groovy synth keys melody", "groovy bass", "shimmering hi hats", "flat male vocal", "background male vocals", "energetic", "groovy", "exciting", "low quality"] | 4 | x6U1gX5a_4M | 5304 |
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;