musiccaps_details (view)
4 rows where musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "music video"
This data as json, CSV (advanced)
musiccaps_aspects (array) 56 ✖
- medium tempo · 4 ✖
- music video · 4 ✖
- emotional 3
- instrumental music 3
- home video 2
- music demo 2
- soloist 2
- amateur musician 1
- amateur player 1
- asian soap opera 1
- average audio quality 1
- bad music 1
- badly tuned strings 1
- banjo learning video 1
- banjo lessons 1
- banjo player 1
- beginner 1
- celtic music influences 1
- cheerful 1
- country music 1
- dance rhythm 1
- entertaining 1
- folk music 1
- happy 1
- hissing tones 1
- hobbyist 1
- irish jig 1
- keyboard accompaniment 1
- learning to play 1
- love song 1
- male singer 1
- mandolin playing 1
- melancholic 1
- moody blues 1
- movie soundtrack 1
- musicians diary 1
- no percussion instruments 1
- no percussions 1
- online music videos 1
- percussion hits 1
- piano accompaniment 1
- playing out of time 1
- poignant 1
- poor audio quality 1
- poor quality audio 1
- positive 1
- romantic 1
- romantic song 1
- shakers percussions 1
- strumming rhythm 1
- subtle drumming 1
- tv show theme 1
- ukulele 1
- ukulele player 1
- western classical music 1
- youtube music video 1
musiccaps_names (array) 9 ✖
- Music 4
- Banjo 3
- Mandolin 2
- Inside, small room 1
- Music of Asia 1
- Musical instrument 1
- Plucked string instrument 1
- Song 1
- Strum 1
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 | |
Mouse Loves Rice | A male singer sings this emotional melody. The song is medium tempo with shakers and other percussion, keyboard accompaniment and a subtle bass line. The audio quality is poor. The song is romantic and emotional.the song is probably a music video or a movie sound track. | 2008-10-01T08:57:41Z | tropicalhut6 | Tammy Chen And Ambrose Hsu | ["Music of Asia", "Music", "Song"] | ["emotional", "male singer", "poor audio quality", "asian soap opera", "medium tempo", "romantic song", "love song", "movie soundtrack", "music video", "percussion hits", "piano accompaniment", "subtle drumming", "shakers percussions", "keyboard accompaniment", "tv show theme", "hissing tones"] | 1 | W85w938G5ZM | 3069 | |
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 |
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;