musiccaps_details (view)
2 rows where musiccaps_aspects contains "hip" and musiccaps_aspects contains "remix" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- hip · 2 ✖
- male vocal 2
- remix · 2 ✖
- afro percussion 1
- afrobeat 1
- dance 1
- danceable 1
- electronic 1
- electronic drums 1
- female vocal 1
- groovy 1
- hip-hop 1
- hollering sample 1
- modern 1
- pop music 1
- rap-like singing 1
- strings sample 1
- turntable 1
- urban 1
- vocal samples 1
musiccaps_names (array) 5 ✖
- Music 2
- Afrobeat 1
- Drum and bass 1
- Drum machine 1
- Hip hop music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Gwen Stefani - Wind It Up (Kissy Sell Out Remix) | This is a dance remix of a pop music piece. There are two vocals in the piece, one male and one female. Heavy effects are used on the vocals to make them repeat syllables. There is a repeating string sample as the melody. A complex electronic drum beat provides the rhythmic background. The piece has a groovy feel. It can be played at nightclubs. It could also be used in the soundtrack of a high school drama. | 2009-09-27T13:22:33Z | under9r0und | ["Drum and bass", "Music", "Drum machine"] | ["pop music", "remix", "electronic", "dance", "female vocal", "male vocal", "vocal samples", "turntable", "electronic drums", "strings sample", "groovy", "hip", "modern"] | 9 | 92sRFZvCnWo | 974 | ||
"Look Like You" Afrobeat Remix DJ Tjaey | This is an afrobeat remix of a hip-hop music piece. There is a male vocalist singing in a rap-like manner. A repeated hollering sample can be heard. The rhythmic background is provided by a variety of afro percussion elements. There is a danceable feel to it. This piece could be played at nightclubs or dance clubs. It could also be used as an accompaniment piece at a modern dance course. | 2015-10-22T17:12:04Z | Kara Jenelle | Thank you for watching!! We hope you enjoyed our dance cover and stay tuned for a class coming to a studio near you... Like, Share, SUBSCRIBE!! #PanAfricanMovement through DANCE- embracing our African culture to unify and uplift others through traditional and modern dances. Though we may have different backgrounds, we strive towards the same destiny as we are one in the African Diaspora. #UBUNTU "I am who I am because of who we all are" Choreography & Performance by: Kara Jenelle (MSA) -karajenelle@gmail.com Lindiwe Rose (GTA) -lindoleen@gmail.com Videography & Editing by: Tiro Rose | ["Afrobeat", "Music", "Hip hop music"] | ["hip-hop", "afrobeat", "remix", "male vocal", "rap-like singing", "hollering sample", "afro percussion", "hip", "danceable", "urban"] | 9 | QQTWFTNy-WA | 2617 |
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;