musiccaps_details (view)
4 rows where musiccaps_aspects contains "cheerful", musiccaps_aspects contains "youthful" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 75 ✖
- cheerful · 4 ✖
- youthful · 4 ✖
- energetic 2
- medium tempo 2
- piano accompaniment 2
- positive 2
- steady drumming rhythm 2
- amateur pop music 1
- amateur video 1
- average audio quality 1
- clapping rhythm 1
- classic rock 1
- college humour 1
- comically happy 1
- couples dancing 1
- dance club 1
- dance floor 1
- desk tapping rhythm 1
- disc scarring tones 1
- distorted guitars 1
- dj 1
- dj face off 1
- dj lessons online 1
- e erotic 1
- electric guitar lead 1
- emotional 1
- fart jokes 1
- fast tempo 1
- feeling loved 1
- female singer 1
- free spirit 1
- fun 1
- funny videos 1
- groovy 1
- groovy bass line 1
- guitar accompaniment 1
- happy 1
- having fun 1
- instrumental music 1
- keyboard accompaniment 1
- killing time 1
- laughing 1
- made up songs 1
- make your own songs 1
- male singer 1
- medium fast tempo 1
- new experiences 1
- no harmony instrumentation 1
- party time 1
- passionate 1
- percussive bass line 1
- percussive guitar strumming 1
- poor quality 1
- pop music 1
- retro rock 1
- retro youtube pop 1
- rock band 1
- rock music 1
- scratch tutorials 1
- scratching disc tones 1
- scream and shout 1
- screaming josies 1
- slow dance 1
- song introduction 1
- spirited 1
- string rock drumming 1
- strong bass line 1
- studio recording 1
- syncopated rhythms 1
- tambourine percussions 1
- techno dance music 1
- teen age fun 1
- the first time 1
- vinyls 1
- yodelling vocals 1
musiccaps_names (array) 10 ✖
- Music 4
- Clapping 1
- Grunge 1
- Hands 1
- Heavy metal 1
- Progressive rock 1
- Punk rock 1
- Scratching (performance technique) 1
- Singing 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bayartsengel yodel | A male singer sings cheerful yodelling vocals. The song is fast tempo, with a steady drumming rhythm, groovy bass line, guitar accompaniment and piano playing enthusiastically. The song is cheerful and thoroughly entertaining. The song is a modern pop tune with yodelling to express happiness and free spirit. | 2011-06-09T11:54:50Z | ulzii bat | Bayartsengel yodel | ["Yodeling", "Music"] | ["fast tempo", "guitar accompaniment", "retro youtube pop", "song introduction", "scream and shout", "pop music", "amateur pop music", "free spirit", "energetic", "song introduction", "youthful", "e erotic", "new experiences", "feeling loved", "the first time", "comically happy", "piano accompaniment", "strong bass line", "steady drumming rhythm", "yodelling vocals", "cheerful", "happy", "positive", "emotional", "spirited", "fun", "party time"] | 1 | I-C14nCneBs | 1857 | |
Chirp Scratch DJ Tutorial - How To Scratch | The song is an instrumental. The tempo is medium, with a dj creating vinyl scratch tones to a steady drumming rhythm, groovy bass line and a keyboard accompaniment. The song is youthful and groovy. The song is a techno dance rhythm. | 2009-11-17T16:11:29Z | Studio Scratches / School of Scratch | NEW updated HD video tutorials at: http://www.schoolofscratch.com For more info please visit: http://www.studioscratches.com/scratchy-100-chirp-scratch-tutorial/ Chirp Scratch Tutorial by DJ Short-e. One of Short-e's fav scratches! Short-E Scratches with her fader reversed or hamster style. See (http://www.studioscratches.com/hamster-reverse-vs-regular-scratching/) DJ Short-e teaches you how to do the Chirp scratch. Named because it sounds like a bird chirping away, this scratch is attained by playing the sample forwards and cutting the end of the sample off, then bringing the record back and turning the fader on. Repeat. You probably heard DJ Premier use this scratch loads and it can be really funky. Although relatively simple you can achieve much with this scratch, combining it with flares for the chirp flare. Beat # 8528 used in this clip is available here: http://studioscratches.bandcamp.com/album/85-bpm-hip-hop-instrumental-beats Happy Scratching! :D | ["Scratching (performance technique)", "Music"] | ["dj", "instrumental music", "medium tempo", "scratch tutorials", "dj lessons online", "scratching disc tones", "vinyls", "piano accompaniment", "screaming josies", "disc scarring tones", "syncopated rhythms", "steady drumming rhythm", "percussive bass line", "youthful", "positive", "cheerful", "dj face off", "techno dance music", "slow dance", "couples dancing", "dance floor", "dance club", "keyboard accompaniment"] | 1 | Kojo5khAAS0 | 2121 | |
I be Farting | A female singer sings this casual melody. The tempo is medium with clapping and desk tapping percussion and no other instrumentation. The song is very casual and made up for fun. The song has poor audio quality. | 2010-05-02T02:34:49Z | Genesis19 | New SONG ------- FOLLOW http://www.twitter.com/woahitsbrittney http://www.twitter.com/qenesis | ["Singing", "Music", "Hands", "Clapping"] | ["female singer", "amateur video", "poor quality", "youthful", "teen age fun", "groovy", "made up songs", "cheerful", "college humour", "killing time", "having fun", "killing time", "make your own songs", "fart jokes", "laughing", "funny videos", "clapping rhythm", "desk tapping rhythm", "no harmony instrumentation", "medium tempo"] | 1 | Z8L3jychP14 | 3343 | |
ROCK 'N ROLL ICE CREAM - Marky Ramone & Missing Sound.mov | A male singer sings this rock melody. The song is medium fast tempo with a strong rock drumming rhythm, percussive bass line, distorted guitars playing rhythm and lead along with tambourine percussion. The song is energetic and cheerful. The song is a rock song with an average quality audio. | 2012-02-10T11:45:21Z | gian maria emendatori | ["Heavy metal", "Music", "Punk rock", "Progressive rock", "Grunge"] | ["male singer", "rock music", "classic rock", "string rock drumming", "average audio quality", "retro rock", "passionate", "rock band", "youthful", "energetic", "cheerful", "studio recording", "medium fast tempo", "string rock drumming", "tambourine percussions", "electric guitar lead", "percussive guitar strumming", "groovy bass line", "distorted guitars"] | 1 | fXhN3_gGpQw | 3957 |
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;