musiccaps_details (view)
4 rows where musiccaps_aspects contains "emotional" and musiccaps_aspects contains "music video"
This data as json, CSV (advanced)
musiccaps_aspects (array) 55 ✖
- emotional · 4 ✖
- music video · 4 ✖
- instrumental music 3
- medium tempo 3
- home video 2
- music demo 2
- poignant 2
- soloist 2
- aboriginal instruments 1
- amateur player 1
- asian soap opera 1
- average audio quality 1
- bad audio quality 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
- hissing tones 1
- hobbyist 1
- home music video 1
- irish jig 1
- keyboard accompaniment 1
- love song 1
- male singer 1
- mandolin playing 1
- melancholic 1
- moody blues 1
- movie soundtrack 1
- no percussion instruments 1
- no percussions 1
- online music videos 1
- percussion hits 1
- percussive blowing patterns 1
- piano accompaniment 1
- poor audio quality 1
- positive 1
- romantic 1
- romantic song 1
- shakers percussions 1
- solo instrument 1
- sonorous tones 1
- subtle drumming 1
- traditional music 1
- tv show theme 1
- ukulele 1
- ukulele player 1
- western classical music 1
- youtube music video 1
musiccaps_names (array) 7 ✖
- Music 4
- Banjo 2
- Mandolin 2
- Didgeridoo 1
- Music of Asia 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 | |
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 | |
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;