musiccaps_details (view)
3 rows where musiccaps_aspects contains "keyboard", musiccaps_aspects contains "male vocal sample" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- keyboard · 3 ✖
- male vocal sample · 3 ✖
- afrobeat 1
- bells 1
- chill 1
- club music 1
- dance 1
- danceable 1
- deep house 1
- electronic 1
- electronic afrobeat 1
- electronic dance 1
- electronic dance music 1
- electronic drums 1
- electronic percussion 1
- energetic 1
- erotic 1
- exotic 1
- female vocal 1
- female vocal sample 1
- groovy 1
- repeated theme 1
- rising pattern 1
- seductive singing 1
- sound effects 1
- sound effects electronic drums 1
musiccaps_names (array) 5 ✖
- Music 3
- Afrobeat 1
- Drum machine 1
- Music of Africa 1
- Skateboard 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Freeline Skates are Strangely Awesome | This is a deep house piece. There is a repeating female vocal sample playing while the keyboard and bells are carrying the melody playing the same two chords repeatedly. There is also a nice sound effect. The electronic drum beat is in a crescendo movement creating a hyped-up atmosphere. A male vocal uttering a few words can be heard later on. The piece has a danceable but chill aura to it. It could be used at house parties, dance clubs and tourism advertisements. | 2015-04-07T19:56:18Z | Kuma Films | If rollerblades and ripsticks had a baby, this is what they would look like. These crazy inline skates are like mini skateboards for each foot! Snag Some Freeline Skates Here!: http://amzn.to/1ThrUCG We spent a day with Light and 曾昱暠 cruising the streets of Taipei on their freeline skates. These guys kill it on a longboard as well. Subscribe! http://bit.ly/1tLVDYk Click to Facebook: http://on.fb.me/1E1aCnt http://www.KumaFilms.com Behind the Scenes: http://bit.ly/1FOaeYB Like us on Facebook! https://www.facebook.com/KumaFilms Follow us on Instagram! http://instagram.com/KumaFilms @KumaFilms Follow us on Twitter! https://twitter.com/kumakumafilms @kumakumafilms Follow us on Soundcloud! https://soundcloud.com/kuma-films Contact us at kumakumafilms@live.com Featuring: Light Liu & 曾昱暠 Facebook: https://www.facebook.com/sk7777777 Facebook: http://on.fb.me/1C7Nj6E Music: Arman Cekin - Smooth Waves FREE Download: https://soundcloud.com/mrsuicidesheep... Soundcloud: https://soundcloud.com/armancekin Facebook: https://www.facebook.com/arman.cekin Twitter: https://twitter.com/CekinArman Instagram: https://instagram.com/armancekin/ | ["Music", "Skateboard"] | ["electronic dance music", "deep house", "female vocal sample", "keyboard", "bells", "sound effects electronic drums", "male vocal sample", "danceable", "chill"] | 9 | BlhUt8AJJO8 | 1289 | |
White boy Dancing to yemi alade johnny #afrobeats #azonto #whiteboyafrican | This is an afrobeat music piece. There is a female vocalist singing in a seductive manner. There is an occasional male vocal sample. The keyboard is playing a minimalistic tune. There is an electronic drum beat. The atmosphere is groovy and erotic. This piece could be playing at an African nightclub. | 2015-01-17T09:09:09Z | Aaron Lesta Lopez Candal | via YouTube Capture | ["Afrobeat", "Music"] | ["afrobeat", "electronic", "dance", "female vocal", "seductive singing", "male vocal sample", "keyboard", "electronic drums", "sound effects", "groovy", "erotic", "exotic"] | 9 | tIS1Jaw9dCg | 5025 | |
VEE MAMPEEZY"HAPPY!!!"(AFRICAN MUSIC#BOTSWANA) | This is an electronic afrobeat music piece. The electronic percussive elements are providing the rhythmic background. The keyboard is playing a repeated theme in a rising pattern. There is a brief shouting male vocal sample in the distance. The atmosphere is energetic. This piece could be playing at a nightclub or a dance club. | 2015-11-17T16:45:31Z | VEE MAMPEEZY | OFFICIAL VIDEO FOR THE 2ND SINGLE FROM #SUPERNATURAL VOL. 3 #HAPPY#SNVL3#AFRICA#WALAOLAJESO | ["Music of Africa", "Music", "Drum machine"] | ["electronic afrobeat", "electronic dance", "electronic percussion", "male vocal sample", "keyboard", "repeated theme", "rising pattern", "energetic", "club music"] | 9 | vfscNjNneZg | 5196 |
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;