musiccaps_details (view)
2 rows where musiccaps_aspects contains "country music", musiccaps_aspects contains "spirited", musiccaps_aspects contains "violin" 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Dewey Balfa - Jai Ete Au Bal - Awesome Fiddlesticks | This music is a lively fiddle instrumental. The tempo is fast with a percussion accompaniment. The music is spirited, vibrant, enthusiastic,cheerful, happy , merry and sunny. This music is Country Folk. | 2008-02-03T02:16:58Z | Paul | Clip is taken from Yasha Aginsky's documentary "Les Blues de Balfa". It is an AWESOME film I would HIGHLY recommend. Dewey Balfa and his nephew Tony Balfa preforming Jai Ete Au Bal (I Went To The Dance). | ["Country", "Traditional music", "Music", "Musical instrument", "Violin, fiddle", "Bowed string instrument"] | ["instrumental", "fast tempo", "fiddle", "string instrument", "cajun music", "spirited", "bright", "melodious", "violin", "western classical", "four stringed instrument", "high pitched", "bow stringed", "country music", "lively", "animated", "percussion", "spirited"] | 7 | UFyOGqmITjM | 2901 |
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;