musiccaps_details (view)
2 rows where musiccaps_aspects contains "enthusiastic" and musiccaps_aspects contains "vocal riff" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- enthusiastic · 2 ✖
- vocal riff · 2 ✖
- youthful 2
- atmospheric synthesiser 1
- boomy bass lines 1
- buoyant 1
- catchy beat 1
- club music 1
- dance music 1
- dj 1
- dj mixer 1
- dj mixer tutorial 1
- dj scratching techniques 1
- edm 1
- electronic arrangement 1
- electronic music 1
- energetic 1
- fast tempo 1
- infectious drumming 1
- instrumental 1
- keyboard harmony 1
- lively 1
- male vocalist 1
- medium fast 1
- psychedelic 1
- punchy 1
- repetitive 1
- scratching 1
- surround sound 1
- synthesiser arrangement 1
- trippy 1
- turn table 1
- upbeat 1
- vocal backup 1
musiccaps_names (array) 4 ✖
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DJ Scratching Techniques: Tears, Flares & Orbits : DJ Scratching Techniques: Orbit Scratch With Music | This music is instrumental . The tempo is medium fast with a catchy drumming rhythm and turntable effect with a vocal riff. The music is youthful, engaging, groovy and buoyant. This is a tutorial on DJ scratching techniques. | 2008-08-29T22:56:31Z | ExpertVillage Leaf Group | Practice the orbit scratch while wearing headphones. Learn how to do an orbit scratch with music in this free dj scratching video lesson from a experienced disk jockey and music teacher. | ["Scratching (performance technique)", "Scratch"] | ["instrumental", "medium fast", "scratching", "turn table", "dj", "dj mixer", "vocal riff", "dj scratching techniques", "dj mixer tutorial", "catchy beat", "energetic", "enthusiastic", "youthful"] | 7 | 7LlnLjZOqVI | 835 | |
Scotty Dynamo - On A Roll | A male vocalist sings this spirited song. The tempo is fast with a bright keyboard harmony, boomy bass drops, infectious drumming and atmospheric synthesiser and a vocal riff. The electronic arrangements and synthesised sounds give it a psychedelic, trippy, hypnotic vibe. It is perky, buoyant, thumping, youthful, vivacious with a dance groove. This song is an EDM/Synth Pop song. | 2009-06-27T17:02:38Z | ScottyDynamo | Myspace: http://www.myspace.com/scottydynamo Twitter: http://www.twitter.com/scottydynamo Blog: http://scottydynamo.com Recorded at King West Studio, Toronto, Canada. http://kingweststudio.com/ Verse 1: Don't even trip I got you covered like a placemat/ Shorty keep on starin' I'm like can I have my face back/ I can imagine you've won your share of pageants/ Lay down like a carpet shorty I can play Alladin/ My penmanship is baller, got the wordplay of a scholar/ And I've got men insecure because their bank accounts are smaller/ See her dancing in the spotlight steady throwing out her back and/ All I see is cleavage I should call her Janet Jackson/ Chorus: She's on a roll/ The way she drop it makin' profit down the poll/ She make the people at the party lose control/ The way she drop it makin' profit down the poll/ Oh you can tell that primma donna's on a roll/ Verse 2: She's so primma donna in her Dolce & Gabanna/ Shorty I just wanna see you back it up like a Honda/ Oh she chat it up and I appreciate the banter/ Shorty's Puerto Rican so I couldn't understand her/ I'm wildin' out you know my crew is straight orangutanin'/ Never see me talkin' to a hoochie with her fusions hangin'/ I'm fit to be the kind of lover you deserve/ Met your boyfriend at the party he was serving out or d'oeuvres/ Chorus x2 | ["Music", "Zing"] | ["male vocalist", "electronic music", "fast tempo", "vocal riff", "repetitive", "atmospheric synthesiser", "boomy bass lines", "surround sound", "punchy", "buoyant", "upbeat", "vocal backup", "psychedelic", "trippy", "youthful", "enthusiastic", "lively", "keyboard harmony", "synthesiser arrangement", "infectious drumming", "electronic arrangement", "edm", "dance music", "club music"] | 7 | esIzFH7vYLY | 3902 |
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;