musiccaps_details (view)
7 rows where musiccaps_aspects contains "soloist" and musiccaps_aspects contains "youtube music video"
This data as json, CSV (advanced)
musiccaps_aspects (array) 91 ✖
- soloist · 7 ✖
- youtube music video · 7 ✖
- instrumental music 6
- emotional 5
- medium tempo 4
- guitar demonstration 3
- guitar solo 3
- amateur player 2
- average audio quality 2
- bad audio quality 2
- cheerful 2
- exciting 2
- groovy 2
- guitar lessons online 2
- guitarist 2
- passionate 2
- poor audio quality 2
- positive 2
- romantic 2
- accordion harmony 1
- accordion lessons 1
- accordion player 1
- acoustic guitar 1
- acoustic guitar player 1
- acoustic love song 1
- adventure music 1
- adventurous 1
- ambient echoes 1
- ambient room noise 1
- ambient room noises 1
- beautiful melody 1
- booming bass line 1
- boring 1
- celtic music influences 1
- classical guitar accompaniment 1
- country music 1
- dance rhythm 1
- dissonant notes 1
- electric guitar 1
- electric guitar player 1
- excited 1
- folk music 1
- groovy music 1
- groovy rhythm 1
- groovy sluice 1
- guitar amplifier 1
- guitar amplifiers 1
- guitar demo 1
- guitar learner 1
- guitar licks 1
- guitar played accompaniment style 1
- guitar playing video 1
- guitar strumming rhythm 1
- happy 1
- high gain music 1
- hobbyist 1
- home recording 1
- home studio recording 1
- home video 1
- inspiring 1
- irish jig 1
- latin indie song 1
- latin love song 1
- latin pop hits 1
- lilting music 1
- live performance 1
- live sessions 1
- madly in love 1
- male singer 1
- mandolin playing 1
- medium fast tempo 1
- medium fats tempo 1
- melancholic 1
- minor scale played wrong 1
- music demo 1
- music video 1
- no percussions 1
- online music videos 1
- riffs 1
- screechy tones 1
- slow tempo 1
- soulful singer 1
- spirited 1
- strumming chords 1
- strumming rhythm 1
- style guitar playing 1
- subtle bass line 1
- tone generator 1
- traffic noise 1
- unsteady playing 1
- virtuoso 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ジャズコーラスの音色とマーシャルガバナーの威力 | The song is an instrumental. The song is medium tempo with an electric guitar playing chords and strumming rhythm with no other instrumentation. The song is emotional and interesting. The song is probably a demo of a guitar or guitar amplifier. The audio is average quality. | 2011-10-24T16:02:01Z | yskpai81 | ガバナー大好き。 http://mixi.jp/view_diary.pl?id=1786483877&owner_id=11016145 ↑これです。昔は四角い形だったのに、今は流線型のボディになってます。 音は昔の方が良かったような気がします。 | ["Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | ["electric guitar", "strumming chords", "virtuoso", "guitar lessons online", "guitar strumming rhythm", "guitar amplifiers", "guitar demonstration", "live performance", "youtube music video", "average audio quality", "medium tempo", "instrumental music", "emotional", "spirited", "soloist", "ambient room noises"] | 1 | 2xATintzaj4 | 420 | |
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 | |
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 | |
1964 Fender Deluxe Reverb + 1999 Fender 52 Vintage Telecaster Part2 | The song is an instrumental. The song is medium tempo with a guitar playing solo accompaniment style, with a subtle bass line. The song is entertaining and passionate. The song audio quality is poor with a lot of ambient echoes. | 2010-03-17T17:54:45Z | GregsGuitars | 1964 Fender Deluxe Reverb is an original vintage amp - not Reissue. Tele has a Texas Special Pickup at the neck and a nocaster bridge pickup. Okko Diablo Custom made overdrive pedal with 3 channels www.gregorhilden.de | ["Reverberation", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental music", "poor audio quality", "guitar solo", "ambient echoes", "guitar played accompaniment style", "guitar amplifier", "tone generator", "subtle bass line", "home video", "youtube music video", "soloist", "guitar solo", "exciting", "adventurous", "guitar demo", "passionate", "medium tempo", "emotional", "adventure music"] | 1 | DUNOn71oGCw | 1482 | |
Bill Lawrence "Wilde" L-45 pickups | The song is an instrumental. The song is medium tempo with an electric guitar playing guitar riffs with a nice low end; The audio quality is average. The song is passionate and exciting. | 2010-06-03T01:03:09Z | Flagrant Potato | Playing starts at 2:25. Quick sound test of the Bill and Becky "Wilde" L-45 strat pickups in my Warmoth guitar. Alnico V magnets, dual rail pole pieces (flat). Guitar is 1pc alder body with a goncalo alves neck and ebony fretboard. Guitar is plugged straight into a Yamaha Fifty (G50) 410 combo and was recorded with an active dual-ribbon mic. | ["Reverberation", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Inside, small room"] | ["electric guitar player", "guitarist", "riffs", "guitar licks", "passionate", "exciting", "guitar lessons online", "soloist", "youtube music video", "guitar demonstration", "excited", "positive", "medium fast tempo", "groovy music", "inspiring", "inspiring", "guitar solo", "medium fats tempo", "strumming rhythm", "groovy", "booming bass line", "instrumental music"] | 1 | Ta0GmXPnGWk | 2847 | |
Kitty (Pogues Cover) | The song is an instrumental. The song is medium tempo with an accordion playing in an accompaniment style with both medley and harmony and no other instrumentation. The music is romantic and melancholic. The audio quality is poor. | 2007-08-03T07:52:34Z | Hale Bopp | A cover of the song Kitty by the incredible Irish punk band The Pouges on my accordion. (in a different key though) Lyrics: Oh Kitty, My Darling, remember That the doom will be mine if I stay 'Tis far better to part, though it's hard to Than to rot in their prison away 'Tis far better to part, though it's hard to Than to rot in their prison away So softly he kissed her pale lips 'Twas the same story over an o'er Hush Mavourneen, the Police are watching And you know that I must go ashore Hush now Bernie, the Police are watching And you know that I must go ashore Any day I'll be over the mountain There'll be time enough left for to cry So good night and God gaurd you forever And write to me once you get by So good night and God gaurd you forever And write to me once you get by | ["Accordion"] | ["accordion player", "accordion harmony", "youtube music video", "accordion lessons", "high gain music", "bad audio quality", "soloist", "home recording", "slow tempo", "lilting music", "emotional", "cheerful", "melancholic", "groovy", "romantic", "instrumental music", "emotional", "screechy tones"] | 1 | o1E579RL33w | 4603 | |
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;