musiccaps_details (view)
3 rows where musiccaps_aspects contains "female voice singing", musiccaps_aspects contains "pop" and musiccaps_aspects contains "uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- digital drums 3
- female voice singing · 3 ✖
- pop · 3 ✖
- uptempo · 3 ✖
- amateur recording 1
- backing voice 1
- crowd cheering 1
- dance 1
- digital bass 1
- digital brass 1
- e-bass 1
- keys 1
- marimba 1
- pad sounds 1
- piano 1
- simple production 1
- strings 1
- synth pluck 1
- xylophone sound 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
120521 Kara - Mister [HD] @ MBC Korean Music Wave in Google | This audio contains a digital drum with a kick on every beat. An e-bass is playing a slightly funky groove. A synthesizer is playing a short fast melody. Another synth sound is playing a string/pad sound rising up into focus. A female voice is singing, then another female voice takes over singing. The crowd is cheering loudly. This song may be playing during a live show. | 2012-05-26T12:15:23Z | kpopcouchcrew | For more kpop concert updates follow~ http://twitter.com/couch_crew | ["Music", "Exciting music"] | ["amateur recording", "pop", "dance", "e-bass", "digital drums", "synth pluck", "strings", "female voice singing", "crowd cheering", "uptempo"] | 6 | 4Ua6i_VDYU4 | 575 | |
Inas X - Stupid ft. PnB Rock (Official Music Video) | A digital drum is playing a groove with different little elements panned to the left and right side of the speakers. Little sprinkles of plucked digital synth sounds are playing melodies along with a keyboard playing soft chords. The female voice is singing being backed by a voice full of effects. Then padsounds come in serving as strings playing a slow chord progression. This song may be playing at the mall. | 2016-09-24T16:12:03Z | Inas X | https://m.soundcloud.com/inasx/stupid-ft-pnb-rock Music video by Inas X performing "Stupid" feat. PnB Rock. (C) 2016 Love X Entertainment Follow Inas X for the latest updates: Itunes: http://hyperurl.co/tcvmk9 Spotify: http://hyperurl.co/1qc6ue Instagram: https://www.instagram.com/InasX/ Facebook: https://www.facebook.com/InasX Twitter: https://www.twitter.com/InasX Snapchat: InasX Label: Love X Entertainment | ["Music", "Punk rock", "Tender music"] | ["pop", "digital drums", "pad sounds", "keys", "female voice singing", "backing voice", "simple production", "uptempo"] | 6 | MVYSWTF11Nc | 2274 | |
pat a cake baker's man Song | A digital drum is playing a techno groove with a kick on every beat. A synth bass is playing a simple line along to a piano playing major chords. Panned to the sides of the speakers you can hear a xylophone like sound playing the melody along in a higher key and a marimba adding notes. A digital brass sound is adding hits to the melody. A female voice is singing in a higher key. This song may be playing in a kids tv-show. | 2015-06-01T06:28:12Z | Turtle Interactive | pat a cake is a fun song about cooking delicious cakes. Our version is a story about a girl who goes to a bakery and sings to the baker's man. Here are the lyrics: Pat-a-cake, pat-a-cake baker's man Bake me a cake as fast as you can prick it and Pat it mark it with " B " And put in the oven for baby and me Make it with chocolate and make it with cream Make it the pretty as you ever seen Pat-a-cake, pat-a-cake baker's man. Bake me a cake as fast as you can Pat-a-cake, pat-a-cake baker's man Bake me a cake as fast as you can prick it and Pat it mark it with " B " And put in the oven for baby and me Make it with chocolate and make it with cream Make it the pretty as you ever seen Pat-a-cake, pat-a-cake baker's man Bake me a cake as fast as you can Hope you like our song. Subscribe to our channel to watch more of such songs - http://www.youtube.com/subscription_center?add_user=turtleinteractive | ["Music", "Music for children"] | ["pop", "piano", "digital bass", "digital drums", "xylophone sound", "digital brass", "marimba", "female voice singing", "uptempo"] | 6 | snJDZAnTMwQ | 4979 |
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;