musiccaps_details (view)
3 rows where musiccaps_aspects contains "claps", musiccaps_aspects contains "groovy" and musiccaps_aspects contains "hip hop"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- claps · 3 ✖
- groovy · 3 ✖
- hip hop · 3 ✖
- addictive 2
- low quality 2
- punchy kick 2
- addictive plucked strings melody 1
- bright wide steel guitar melody 1
- dull 1
- energetic 1
- filtered pitched up female chant 1
- flat male vocal 1
- groovy bass 1
- mellow synth pad 1
- repetitive echoing piano melody 1
- repetitive synth chords 1
- reverberant flute melody 1
- shimmering triangle 1
- soft kick 1
- stuttering hi hats 1
- sustained synth bass 1
- tinny muffled percussive elements 1
- tinny wooden percussive elements 1
- tropical 1
musiccaps_names (array) 4 ✖
- Music 3
- Exciting music 1
- Steelpan 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Wordsmith ft. Bizzle & Sevin - Neighborhood HOPE Dealer (Official Music Video) | The Hip Hop song features a flat male vocal rapping over repetitive, echoing piano melody, claps and punchy kick hits. At the very beginning of the loop, there are stuttering hi hats, sustained synth bass and filtered, pitched up female chant playing. It sounds groovy and addictive - thanks to the way rappers are rapping. | 2016-04-26T21:09:42Z | Wordsmith | Music Video "Neighborhood Hope Dealer" Get it right here on iTunes: https://itun.es/us/RIJ6bb ©2016 NHD NeighborhoodHopeDealer.com | ["Music", "Exciting music"] | ["hip hop", "punchy kick", "flat male vocal", "repetitive echoing piano melody", "claps", "stuttering hi hats", "filtered pitched up female chant", "addictive", "groovy", "sustained synth bass"] | 4 | 374R7te0ra0 | 442 | |
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 | ||
Jonny Pow Khaen Lao | The low quality recording features a hip hop instrumental that consists of punchy kick, claps, repetitive synth chords, addictive plucked strings melody and tinny wooden percussive elements. It sounds groovy and very addictive, due to that string melody. | 2011-02-02T03:34:15Z | Jonny Olsen | This is Jonny's theme song. Jonny raps in English and Nyot sings along with a catchy chorus "Jonny Pow Khaen Lao." ຈອນນີ ເປ່ົາແຄນລາວ The second part where Nyot sings is the Sueng Bung Fai melody. Jonny loves to entertain you all and had a fun time teaming up with Nyot Sengathid- Morlum Hip Hop Savannakhet. We can learn about other people's culture. We can share ideas, have fun, and make the world a better place. Lets all get along and love each other. End the hate. Thank you. Album-"Mawlum Hip Hop Lao-America 2010." Jonny is the first Farang or foreigner to ever make and release an album in Laos. He is also the first foreigner to win a khaen competition in Khon Kaen, Thailand 2005. Thank you 🙏❤ | ["Music", "Steelpan"] | ["hip hop", "punchy kick", "claps", "repetitive synth chords", "addictive plucked strings melody", "low quality", "tinny wooden percussive elements", "addictive", "groovy"] | 4 | navn7jCBp_o | 4559 |
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;