musiccaps_details (view)
3 rows where musiccaps_aspects contains "piano accompaniment", musiccaps_aspects contains "positive" and musiccaps_aspects contains "steady drumming rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 59 ✖
- cheerful 3
- piano accompaniment · 3 ✖
- positive · 3 ✖
- steady drumming rhythm · 3 ✖
- medium tempo 2
- spirited 2
- youthful 2
- amateur pop music 1
- animals 1
- animated singing 1
- animated video 1
- children dancing 1
- children’s song 1
- comically happy 1
- couples dancing 1
- dance club 1
- dance floor 1
- disc scarring tones 1
- dj 1
- dj face off 1
- dj lessons online 1
- e erotic 1
- educational material 1
- emotional 1
- energetic 1
- fast tempo 1
- feeling loved 1
- free spirit 1
- fun 1
- fun learning 1
- groovy bass line 1
- guitar accompaniment 1
- happy 1
- instrumental music 1
- keyboard accompaniment 1
- learning 1
- male singer 1
- new experiences 1
- nursery rhymes 1
- party time 1
- percussive bass line 1
- pop music 1
- preschool teaching 1
- retro youtube pop 1
- schools 1
- scratch tutorials 1
- scratching disc tones 1
- scream and shout 1
- screaming josies 1
- slow dance 1
- song introduction 1
- strong bass line 1
- syncopated rhythms 1
- techno dance music 1
- the first time 1
- toddlers 1
- vinyls 1
- yodelling vocals 1
- zoo 1
musiccaps_names (array) 5 ✖
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 | |
Animals | Zoo | Kids | Music | Preschool | Silly Bus | A male singer sings this animated melody . The song is medium tempo with a groovy bass , keyboard accompaniment and steady drumming rhythm. The song is cheerful and animated and designed as educational material for little children. | 2011-09-11T22:29:16Z | Silly Bus | Silly Bus is proud to release our At The Zoo song and video. | ["Funk", "Music", "Exciting music"] | ["medium tempo", "male singer", "groovy bass line", "preschool teaching", "educational material", "learning", "schools", "toddlers", "positive", "cheerful", "spirited", "fun learning", "children dancing", "animated video", "nursery rhymes", "zoo", "animals", "steady drumming rhythm", "piano accompaniment", "children’s song", "animated singing"] | 1 | hhohfEC82JI | 4130 |
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;