musiccaps_details (view)
6 rows where musiccaps_aspects contains "instrumental music", musiccaps_aspects contains "soloist" and musiccaps_aspects contains "youtube music video"
This data as json, CSV (advanced)
musiccaps_aspects (array) 76 ✖
- instrumental music · 6 ✖
- soloist · 6 ✖
- youtube music video · 6 ✖
- emotional 4
- guitar demonstration 3
- guitar solo 3
- medium tempo 3
- amateur player 2
- average audio quality 2
- cheerful 2
- exciting 2
- groovy 2
- guitar lessons online 2
- guitarist 2
- passionate 2
- poor audio quality 2
- positive 2
- accordion harmony 1
- accordion lessons 1
- accordion player 1
- acoustic guitar 1
- adventure music 1
- adventurous 1
- ambient echoes 1
- ambient room noise 1
- ambient room noises 1
- bad audio quality 1
- booming bass line 1
- boring 1
- celtic music influences 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
- 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 video 1
- inspiring 1
- irish jig 1
- lilting music 1
- live performance 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
- romantic 1
- screechy tones 1
- slow tempo 1
- spirited 1
- strumming chords 1
- strumming rhythm 1
- subtle bass line 1
- tone generator 1
- traffic noise 1
- unsteady playing 1
- virtuoso 1
musiccaps_names (array) 15 ✖
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 |
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;