musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy" and musiccaps_aspects contains "sensual"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- groovy · 2 ✖
- male vocal 2
- sensual · 2 ✖
- urban 2
- acoustic drums 1
- alternative r&b 1
- crowd cheering 1
- electronic drums 1
- female vocal 1
- groovy bass 1
- live performance 1
- melodic singing 1
- r&b 1
- rapping 1
- scracthing 1
- seductive singing 1
- soul 1
- strings sample 1
- strong bass 1
- turntable 1
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 | |
Tinashe Performs '2 On' Live At The Viper Room | This is a live performance of an alternative R&B music piece. There is a female vocalist singing in a seductive manner in the lead. Later on, a male vocalist starts rapping. There is a groovy bass line in the background. The DJ is scratching the turntable. The rhythmic background is provided by an R&B acoustic drum beat. The atmosphere is sensual and the sound is urban. Sounds of the crowd cheering can be heard in the recording. | 2014-05-28T20:28:16Z | xoNecole | New artist Tinashe performs her hit song 2 On Live At The Viper Room in Los Angeles | ["Singing", "Scratching (performance technique)", "Music"] | ["alternative r&b", "live performance", "female vocal", "seductive singing", "male vocal", "rapping", "turntable", "scracthing", "groovy bass", "acoustic drums", "crowd cheering", "sensual", "groovy", "urban"] | 9 | _GQnXfIGNKY | 3455 |
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;