musiccaps_details (view)
2 rows where musiccaps_aspects contains "hip hop" and musiccaps_names contains "Dance music" sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- hip hop · 2 ✖
- clapping 1
- cow bell 1
- dry flat male vocal 1
- energetic 1
- kick drum 1
- low quality 1
- male laughing 1
- minimal production 1
- pitched vocal sample 1
- punchy kick 1
- shaker 1
- shimmering open hat 1
- simple hi hats 1
- soft crash cymbal 1
- stuttering synth chords 1
- triangle 1
- unnatural mix 1
- wide arpeggiated synth melody 1
- young male rapper 1
musiccaps_names (array) 7 ✖
- Dance music · 2 ✖
- Music 2
- Funk 1
- Happy music 1
- Jazz 1
- Rhythm and blues 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
Oden Park ( Fresh Boyz ) - iSkateBoard ( HOT MUSIC ) | hip hop music featuring a young male rapper over a minimalist beat with only percussion such as cowbell, kick drum, shaker, and triangle. | 2009-06-11T07:28:41Z | Oden Park | iSkateBoard by Oden Park (there's a dance to this song)Yuh mainly jerk to it but dont forget to hit the Skate Board with it! Type iSkateboard dance....Twitter us @OdenPark http://itunes.apple.com/us/album/iskateboard/id425746911?i=425746950 | ["Jazz", "Music", "Rhythm and blues", "Dance music"] | ["hip hop", "cow bell", "kick drum", "young male rapper", "pitched vocal sample", "triangle", "male laughing", "minimal production", "shaker"] | 8 | 2RMOegT2Jn8 | 362 | |
Fortune Family - Young Hearts (Official Music Video) | The Low Quality Hip Hop song features a dry, flat male vocal rapping over punchy kick layered with shimmering open hats, punchy kick, simple hi hats, claps, syncopated snare hits, wide arpeggiated synth melody and stuttering synth chords. It sounds energetic and kind of unnatural, since the vocal is so detached from the instrumental due to the bad mixing of the song. | 2011-08-08T23:13:33Z | FortuneFam | Fortune Family is back with a new single "Young Hearts," directed by Ryan Do and presented by ThisSongIsSick.com. http://www.facebook.com/FF610 http://www.twitter.com/FortuneFamily Young Hearts samples Rod Stewart's "Young Turks." Download Link http://www.mediafire.com/?xem05efdcddgwqn For management and booking, contact Nick McCarthy at dpreppp@gmail.com | ["Funk", "Music", "Dance music", "Soul music", "Happy music"] | ["low quality", "dry flat male vocal", "punchy kick", "shimmering open hat", "simple hi hats", "soft crash cymbal", "stuttering synth chords", "wide arpeggiated synth melody", "clapping", "hip hop", "unnatural mix", "energetic"] | 4 | 2kcSUBkFbaQ | 404 |
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;