musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic drums", musiccaps_aspects contains "strings sample" and musiccaps_names contains "Music"
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 | |
| 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 |
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;