musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "emotional", musiccaps_aspects contains "exciting" and musiccaps_aspects contains "spirited"
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- emotional · 3 ✖
- exciting · 3 ✖
- medium tempo 3
- spirited · 3 ✖
- poor audio quality 2
- acoustic song 1
- ambient room noises 1
- average audio quality 1
- celtic music 1
- clapping percussions 1
- country music 1
- cymbals crashing 1
- dance rhythm 1
- enteric 1
- fiddler 1
- folk singers 1
- groovy music 1
- groovy rhythm 1
- guitar accompaniment 1
- guitar rhythm 1
- guitar strumming 1
- hissing sounds 1
- home music video 1
- instrumental music 1
- live audience 1
- live performance 1
- male and female singer 1
- male singer 1
- marching rhythm 1
- mome music video 1
- old school music 1
- people clapping 1
- percussive bass line 1
- playful 1
- positive cheerful 1
- retro pop music 1
- snare hits 1
- spirited singing 1
- steady drumming rhythm 1
- story telling 1
- traditional folk music 1
- traditional folk song 1
- traditional music 1
- traditional percussion instruments 1
- vintage hits 1
- violin 1
- violins playing 1
- yodelling melody 1
musiccaps_names (array) 8 ✖
- Music 3
- Banjo 1
- Chant 1
- Progressive rock 1
- Psychedelic rock 1
- Rock music 1
- Singing 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
8 Year Old Jonny Mizzone - Flint Hill Special - Sleepy Man Banjo Boys | The song is an instrumental. The song is slow tempo with a fiddler plays a rhythmic melody accompanied by a guitar accompaniment and other percussive instruments. The song is spirited and energetic. The song has country or Celtic influences. The song has average quality audio. | 2011-02-21T02:57:35Z | Sleepy Man | Our new single "Rain" https://www.youtube.com/watch?v=ZcoOKXrJqY0 http://sleepyman.com **From 2011** Another bedroom practice of Earl Scruggs's Flint Hill Special. Brothers Jonny Mizzone age 8 on banjo, Robbie Mizzone age 12 on fiddle, and Tommy Mizzone age 13 on guitar. http://www.sleepymanbanjo.com http://facebook.com/sleepymanbanjo | ["Banjo", "Music"] | ["fiddler", "instrumental music", "celtic music", "spirited", "home music video", "exciting", "traditional folk music", "violin", "average audio quality", "mome music video", "groovy music", "traditional folk music", "guitar strumming", "traditional percussion instruments", "emotional", "playful", "exciting", "country music", "violins playing", "medium tempo"] | 1 | I3qbB4Kq3Y0 | 1869 | |
Eloy - Eloy ... Same (Mülltonnencover) - Rare Progressive | A male singer sings this cool spirited melody. The song is medium tempo with a steady drumming rhythm, guitar playing lead, guitar strumming, strong bass line and various percussion hits. The song is exciting and energetic. The song has poor audio quality. | 2009-05-26T06:56:15Z | SirHenryII | Eloy - Eloy ... Same (Mülltonnencover) - Rare Progressive | ["Music", "Psychedelic rock", "Rock music", "Progressive rock"] | ["male singer", "guitar rhythm", "percussive bass line", "medium tempo", "groovy rhythm", "old school music", "spirited singing", "retro pop music", "story telling", "steady drumming rhythm", "marching rhythm", "cymbals crashing", "snare hits", "enteric", "exciting", "positive cheerful", "spirited", "emotional", "vintage hits", "poor audio quality"] | 1 | ckOe-8qdaew | 3736 | |
요들송 _ 키스 요들 _ Kuss Jodle _ Kiss Yodel _ 목장주인김원섭 _ 박진아 | A male singer sings with a female backup singer in vocal harmony. The song is medium tempo with a yodelling medley and guitar strumming rhythm and no other instrumentation. The song is exciting and passionate. The song has poor audio quality. | 2010-11-11T11:53:45Z | 목장주인tv | 요들송 _ 키스 요들 _ Kuss Jodle _ Kiss Yodel 2009.5.7. 성남아트센터 김원섭(010-4061-6404)의 '나눔의 열린 음악회'중에서 kmwonseop@hanmail.net | ["Singing", "Chant", "Music", "Vocal music"] | ["male and female singer", "yodelling melody", "poor audio quality", "clapping percussions", "dance rhythm", "spirited", "traditional music", "guitar accompaniment", "acoustic song", "traditional folk song", "folk singers", "live performance", "live audience", "ambient room noises", "hissing sounds", "exciting", "emotional", "medium tempo", "people clapping"] | 1 | m9MQdg0k1t0 | 4448 |
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;