musiccaps_details (view)
4 rows where musiccaps_aspects contains "electronic drums", musiccaps_aspects contains "groovy", musiccaps_aspects contains "r&b" and musiccaps_aspects contains "urban"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Thong song - Runescape Style | This is an R&B/soul music piece. There is a male vocalist singing melodically and in a sensual manner over multiple tracks. The melody of the beat is provided by a string sample. There is a strong bass sound in the piece. The rhythm is provided by a groovy electronic drum beat. There is an urban feel to this piece. It could be used in the soundtrack of a TV series where two characters are sharing intimate moments. | 2007-07-20T10:33:10Z | Sladeakakevin | That Thong th thong thong thong :) Enjoy! HONORS FOR THIS VID: --TODAY-- #16 - Most Viewed (Today) - Gadgets & Games #2 - Top Rated (Today) - Gadgets & Games #1 - Most Discussed (Today) - Gadgets & Games #2 - Top Favorites (Today) - Gadgets & Games --THIS WEEK-- #8 - Top Rated (This Week) - Gadgets & Games #6 - Most Discussed (This Week) - Gadgets & Games #10 - Top Favorites (This Week) - Gadgets & Games --THIS MONTH-- #16 - Top Rated (This Month) - Gadgets & Games #22 - Most Discussed (This Month) - Gadgets & Games #11 - Top Favorites (This Month) - Gadgets & Games _______ RuneScape is a registered trademark of JaGeX Limited. I do not claim, or have any, affiliation with JaGeX Ltd. This video was not intended for any personal gain, only for entertainment purposes. All comments expressed in the video are solely my own, all comments by others are their own and I do not take responsibility for their actions. Consider this, free advertising http://www.runescape.com/ | ["Music", "Exciting music"] | ["r&b", "soul", "male vocal", "melodic singing", "strings sample", "strong bass", "electronic drums", "sensual", "groovy", "urban"] | 9 | -6pcgdLfb_A | 16 | |
Mariah Carey - Fantasy + Lyrics (HD) | This is an R&B/pop dance music piece. There is a versatile female vocalist singing melodically. There is a keyboard and an electric guitar playing the melody while there is a groovy bass guitar line in the background. The rhythmic background is provided by an electronic drum beat. The atmosphere is urban and danceable. This piece could be used in the soundtrack of a romantic comedy movie. | 2009-05-30T15:48:31Z | MIMINHEROFOREVER | Oh when you walk by every night Talking sweet and looking fine I get kind of hectic inside Oh baby I'm so into you Darling if you only knew All the things that flow through my mind But it's just a [Chorus:] Sweet sweet fantasy baby When I close my eyes You come and take me On and on and on It's so deep in my daydreams But it's just a sweet sweet fantasy baby Images of rapture Creep into me slowly As you're going to my head And my heart beats faster When you take me over Time and time and time again But it's just a [Chorus] I'm in heaven With my boyfriend My laughing boyfriend There's no beginning and there is no end Feels like I'm dreaming but I'm not sleeping It's just a [Chorus] | ["Disco"] | ["r&b", "pop dance", "versatile female vocal", "melodic singing", "keyboard", "electric guitar", "bass guitar", "electronic drums", "groovy", "urban", "danceable"] | 9 | JmbrGzgxrJ4 | 2032 | |
Does He Love Me by Keshia Chante | This is an R&B/hip-hop music piece. There is a female vocalist singing melodically. The melody is being played by the keyboard which has a crisp sound. There is a strong bass sound in the background. The rhythm is provided by a loud acoustic drum beat. The atmosphere is hip and urban. This piece could be used in the soundtrack of a drama movie that takes place in the big city. | 2007-06-13T22:08:12Z | Keshia Chante | Official "Does He Love Me" Video by Keshia Chante. Directed by Little X. Made in 2004; Keshia was 16. | ["Funk", "Music"] | ["r&b", "hip-hop", "female vocal", "melodic singing", "keyboard", "strong bass", "electronic drums", "hip", "groovy", "urban"] | 9 | dsVzafZik3c | 3822 | |
LOOSE ENDS HANGIN ON A STRING | This is a soul/R&B music piece. There is a trio of two male vocalists and a female vocalist singing melodically. The keyboard is holding the chords in the background while the electric guitar and the bass guitar are playing a groovy tune. The rhythmic background contains an electronic drum beat. The atmosphere is urban. The piece could be played during a retro-themed party at a nightclub. | 2011-05-05T23:25:50Z | PaulinaDePoros559 | I've waited oh so long for you to come to me What did I do wrong It's all a mystery to me Baby I feel it too What am I supposed to do Maybe I've just changed Or could I be wrong for you You,you've got me hangin' on a string now I'm not your plaything You,you've got me hangin' on a string now Am I your plaything You never told me you were waiting,contemplating With my heart,my love You never told me you were waiting,contemplating With my heart,my love Do you mean to say that after all this time i've waited like a fool now who's been changin' you You,you've got me hangin' on a string now I'm not your plaything You,you've got me hangin' on a string now I aint your plaything You,you've got me hangin' on a string now I'm masquerading You,you've got me hangin' on a string now I aint your plaything,whoa You never told me you were waiting,contemplating You never told me you were waiting,contemplating Come on, child Take me by the hand You,you've got me hangin' on a string now I'm not your plaything,no,no,no You,you've got me hangin' on a string now Hang on,hang on, yeah You,you've got me hangin' on a string now I'm not your plaything You,you've got me hangin' on a string now You never told me You,you've got me hangin' on a string now You never told me you were waiting,contemplating You,you've got me hangin' on a string now You never told me you were waiting,contemplating (I'm not your plaything) You,you've got me hangin' on a string now You never told me you were waiting,contemplating You,you've got me hangin' on a string now You never told me you were waiting,contemplating | ["Music", "Reggae"] | ["soul", "r&b", "male vocals", "female vocal", "melodic singing", "keyboard", "electric guitar", "bass guitar", "electronic drums", "groovy", "funky", "urban"] | 9 | j8FYy5YfK7k | 4237 |
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;