musiccaps_details (view)
4 rows where musiccaps_aspects contains "soloist" and musiccaps_names contains "Strum"
This data as json, CSV (advanced)
musiccaps_aspects (array) 58 ✖
- soloist · 4 ✖
- instrumental music 3
- medium tempo 3
- ambient room noise 2
- bad audio quality 2
- emotional 2
- melancholic 2
- romantic 2
- youtube music video 2
- acoustic guitar 1
- acoustic guitar player 1
- acoustic love song 1
- amateur player 1
- antique guitar 1
- beautiful melody 1
- boring 1
- buzzing noise 1
- classical guitar accompaniment 1
- country music 1
- dissonant notes 1
- entertaining 1
- groovy rhythm 1
- groovy sluice 1
- guitar demo 1
- guitar demonstration 1
- guitar learner 1
- guitar playing video 1
- guitar solo 1
- guitarist 1
- home studio recording 1
- home video 1
- latin indie song 1
- latin love song 1
- latin pop hits 1
- live sessions 1
- madly in love 1
- male singer 1
- master class 1
- minor scale played wrong 1
- moody blues 1
- music demo 1
- music video 1
- no percussion instruments 1
- passionate 1
- poignant 1
- poor audio quality 1
- rich country traditions 1
- soulful singer 1
- spirited 1
- style guitar playing 1
- super tone unique tone 1
- traffic noise 1
- ukulele 1
- ukulele player 1
- unsteady playing 1
- vintage guitar tone 1
- western classical music 1
- youtube music class 1
musiccaps_names (array) 11 ✖
- Music 4
- Strum · 4 ✖
- Guitar 3
- Musical instrument 3
- Plucked string instrument 3
- Acoustic guitar 2
- Banjo 1
- Mandolin 1
- Singing 1
- Steel guitar, slide guitar 1
- Tapping (guitar technique) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SOLD! Vintage Supertone Guitar / bottleneck slide blues hawaiian slack key | The song is an instrumental. The song is medium tempo played by a solo guitarist on a vintage super tone with an exquisite tone. The song is emotional and passionate. The song has poor audio quality. | 2010-01-18T16:55:46Z | Keni Lee Burgess | Please visit www.ebay.com Search: Keni Lee | ["Tapping (guitar technique)", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | ["bad audio quality", "vintage guitar tone", "passionate", "spirited", "guitar demo", "soloist", "antique guitar", "youtube music class", "master class", "buzzing noise", "instrumental music", "ambient room noise", "bad audio quality", "super tone unique tone", "melancholic", "country music", "medium tempo", "rich country traditions"] | 1 | -lPXTBXa0tE | 80 | |
Tum hi ho-Aashiqui 2(Arijit Singh) Complete Guitar tabs Lesson/Tutorial by Likhith Kurba | The song is an instrumental. The tempo is slow and unsure, with a guitarist attempting to play a minor scale and gets the scale wrong. The song has poor audio quality with ambient traffic noise in the background. | 2014-01-17T13:10:27Z | Likhith Kurba | U may catch me on facebook...Likhith Kurba... For complete solo check... https://www.youtube.com/watch?v=HUCm4hoGZlk The song is on F scale...the lesson is on E scale...the scale starts on 3rd string 9th fret and ends on 1st string 12th fret...both these frets have inlays or markings on the guitar and hence easy to follow while learning the lesson... | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["guitarist", "acoustic guitar", "minor scale played wrong", "guitar playing video", "amateur player", "guitar learner", "ambient room noise", "instrumental music", "soloist", "guitar solo", "boring", "unsteady playing", "youtube music video", "guitar demonstration", "dissonant notes", "poor audio quality", "traffic noise"] | 1 | 4H1nc2Xv2Hg | 552 | |
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 | |
Colby O'Donis - What You Got | A male Latin singer sings this romantic melody. The song is medium tempo with an acoustic guitar accompaniment with no other instrumentation. The song is emotional and passionate. The audio quality is poor. | 2009-02-04T21:16:04Z | esmusicatv | http://www.facebook.com/pages/ES-Musica-TV/107227706027532 And I like the way you take advantage of every man you love I see, I seem to know your game girl But I don't mind if ya come and play ya thug just don't talk too much I see, I see it so you don't have to say a word Yeah those guys wanna come treat ya right Cause you're sweeter than apple pie Everything that you want you got Girl you know that you need to stop Most beautiful thing in sight Always takin' on the spotlight Always in the club lookin hot Girl you know that you need to stop Always talkin' bout what you got Always talkin' bout what you got Always talkin' bout what you got Girl you know that you need to stop Always talkin' bout what you got Always talkin' bout what you got Always talkin' bout what you got Girl you know that you need to stop Girl I can tell you want something to love That's why you hold on to everything that pass you by Can't resist girl one can't lie Now tell if you are here for me Or everybody watchin' you shake from left to right The way you move got me hypnotized | ["Singing", "Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["acoustic guitar player", "soulful singer", "live sessions", "youtube music video", "medium tempo", "latin love song", "latin pop hits", "groovy rhythm", "beautiful melody", "latin indie song", "home studio recording", "style guitar playing", "emotional", "romantic", "groovy sluice", "soloist", "acoustic love song", "bad audio quality", "madly in love", "classical guitar accompaniment", "male singer"] | 1 | oxhFIoExrMk | 4670 |
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;