musiccaps_details (view)
4 rows where musiccaps_aspects contains "instrumental music" and musiccaps_aspects contains "music video"
This data as json, CSV (advanced)
musiccaps_aspects (array) 54 ✖
- instrumental music · 4 ✖
- music video · 4 ✖
- emotional 3
- home video 3
- medium tempo 3
- music demo 2
- poignant 2
- soloist 2
- aboriginal instruments 1
- amateur musician 1
- amateur player 1
- average audio quality 1
- bad audio quality 1
- bad music 1
- badly tuned strings 1
- banjo learning video 1
- banjo lessons 1
- banjo player 1
- beginner 1
- breathing technique 1
- celtic music influences 1
- cheerful 1
- country music 1
- dance rhythm 1
- deep breaths 1
- didgeridoo 1
- entertaining 1
- folk music 1
- groovy rhythm 1
- happy 1
- hobbyist 1
- home music video 1
- irish jig 1
- learning to play 1
- mandolin playing 1
- melancholic 1
- moody blues 1
- musicians diary 1
- no percussion instruments 1
- no percussions 1
- online music videos 1
- percussive blowing patterns 1
- playing out of time 1
- poor quality audio 1
- positive 1
- romantic 1
- solo instrument 1
- sonorous tones 1
- strumming rhythm 1
- traditional music 1
- ukulele 1
- ukulele player 1
- western classical music 1
- youtube music video 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mandolin Madness | The song is an instrumental. The song is a medium tempo with a mandolin player playing a cheerful melody with no other instrumentation. The song is positive and has a delightful dance rhythm. The song has an average audio quality. | 2013-10-15T23:19:40Z | Kimsey Lutherie | A compilation of all my mandolin videos- just playing, no talking. Elkhorn, Gilchrist, Kentucky, Krishot, Weber, Stanley. | ["Banjo", "Music", "Mandolin"] | ["mandolin playing", "instrumental music", "medium tempo", "online music videos", "folk music", "youtube music video", "soloist", "hobbyist", "emotional", "country music", "dance rhythm", "celtic music influences", "irish jig", "no percussions", "music video", "average audio quality", "amateur player", "happy", "positive", "dance rhythm", "cheerful", "music demo"] | 1 | 4vsI0Kwn8jY | 618 | |
George Formby - Leaning on a Lampost Solo (Normal Speed and Slowed Down) | The song is an instrumental. The tempo is medium and sometimes glitch out if time, with a banjo being played by a beginner. The song is amateurish in quality and not pleasant. The song audio quality is very poor. | 2013-01-26T14:37:58Z | AngusLUkulele | Hope this video helps! | ["Banjo", "Music", "Musical instrument", "Plucked string instrument", "Inside, small room"] | ["home video", "music video", "banjo learning video", "strumming rhythm", "beginner", "banjo lessons", "amateur musician", "learning to play", "musicians diary", "poor quality audio", "playing out of time", "badly tuned strings", "instrumental music", "bad music", "banjo player", "medium tempo"] | 1 | HrPnGYGrvm0 | 1839 | |
Chris Thile - Bach: Sonata No. 1 in G Minor, BWV 1001 (Complete) | A male ukulele player plays this emotional solo. The song is medium tempo with no other instrumentation than an ukulele playing. The song is emotional and poignant. The song is an instrumental tune. | 2013-10-14T17:44:07Z | ChrisThile | Chris Thile performs Bach's Sonata No. 1 in G Minor, BWV 1001 in full. Also featured on his album Bach: Sonatas and Partitas, Vol. I, available now on CD & vinyl from Nonesuch Records: http://punchbrothers.kungfustore.com/categories/553-bach-sonatas-and-partitas http://www.nonesuch.com/store/chris-thile iTunes: http://www.smarturl.it/thilebachitunes See Chris live on tour this fall: http://punchbrothers.com/thiletour | ["Banjo", "Music", "Mandolin", "Strum"] | ["ukulele", "ukulele player", "medium tempo", "music video", "romantic", "no percussion instruments", "music demo", "moody blues", "melancholic", "western classical music", "instrumental music", "soloist", "poignant", "entertaining", "emotional", "no percussion instruments", "home video"] | 1 | j3lH_Tevw5o | 4231 | |
Guida sulla Respirazione Circolare - Circular Breathing [ AboriginalTrip - Marcello Ballardini ] | The song is an instrumental. The song is medium fast tempo with a didgeridoo playing percussively with no other instrumentation. The song is played passionately and spirited. The audio quality is very poor. | 2010-03-08T15:58:09Z | Norbiz90 | Circular Breathing is one of the greatest difficulties encountered in learning to play the didjeridoo. Here is a video help guide on how to learn this technique. Happy viewing! This and other videos on: http://www.aboriginaltrip.com/ - All About Didjeridoo -- La Respirazione Circolare è una delle più grandi difficoltà che si incontrano nell'imparare a suonare il Didjeridoo. In aiuto eccovi una video guida su come imparare questa tecnica. Buona Visione!! Questo ed altri video Su: http://www.aboriginaltrip.com/ - Tutto sul Didjeridoo - | ["Didgeridoo", "Music"] | ["didgeridoo", "sonorous tones", "aboriginal instruments", "groovy rhythm", "deep breaths", "breathing technique", "home music video", "solo instrument", "instrumental music", "home video", "bad audio quality", "music video", "traditional music", "emotional", "poignant", "percussive blowing patterns"] | 1 | qfVIeq7s6tw | 4806 |
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;