musiccaps_details (view)
4 rows where musiccaps_aspects contains "moderate tempo", musiccaps_aspects contains "no other instruments", musiccaps_names contains "Music" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
How to Play Trust by Megadeth Guitar Lesson (w/ Tabs!!) | This song features a distortion guitar. This is an instructional video. The song features an open note followed by the octave. Then a descending pattern is played on the distortion guitar. The voice gives instructions on how to play the pattern. There is no percussion in this song. There are no other instruments in this song. There is no vocal melody in this song. | 2009-03-15T04:06:25Z | m169marroquin | http://www.ObeyYourMATTster.com | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | ["distortion guitar", "heavy metal", "male voice", "instructional audio", "octaves", "no other instruments", "no percussion", "no vocal melody", "moderate tempo"] | 0 | 52odOK7G2kg | 628 | |
Notable Vainika Series: Jayanthi Kumaresh | This is a low quality recording of a veena being played. This is a classical Hindustani song. The veena plays a note bending the string to a higher note and then descending back to the original note. The audio gets cut off intermittently. Briefly, during the places where the audio is heard, a tabla is heard. There are no voices in this song. This song can be played in a conservative Indian movie featuring a wedding scene. | 2007-05-30T23:22:30Z | GopalMeera | Part-1: An exponent of the Tanjore style and a direct desciple of the legendary Veena S. Balachander. | ["Carnatic music", "Music", "Musical instrument", "Plucked string instrument", "Classical music"] | ["low quality audio", "hindustani music", "veena", "no voices", "no other instruments", "sound cut off", "intermittent cutting off of sound", "moderate tempo"] | 0 | XzRxO8n3WRE | 3243 | |
Ukulele Tutorial - Learn How To Play Redemption Song by Bob Marley | This song features chords being played on a ukulele. A male voice narrates the chords being played. There is no vocal melody in this song. There are no other instruments in this song. This clip can be used in an instructional lesson for ukulele. | 2010-08-24T05:59:04Z | Easy Ukulele | Learn how to play "Redemption Song" by Bob Marley. G Em Old Pirates, yes, they rob I. C Bm Am Sold I to the merchant ships G Em C Bm D minutes after they took I from the bottomless pit. G Em But my hand was made strong C Bm Am By the hand of the Almighty. G Em C Bm D We forward in this generation triumphantly. Chorus D G C D G Won't you help to sing these songs of freedom? C D Em C D G 'Cause all I ever had, redemption songs, C D G C redemption songs. D G Em Emancipate yourselves from mental slavery, C Bm Am None but ourselves can free our minds. G Em Have no fear for atomic energy, C Bm D 'Cause none of them can stop the time. G Em How long shall they kill our prophets C Bm Am While we stand a side and look? G Em Yes, some say it's just a part of it. C Bm D We've got to fulfill the book. Chorus Breakdown (Em, C, D 4x) Emancipate yourselves from mental slavery, None but ourselves can free our minds. Have no fear for atomic energy, 'Cause none of them can stop the time. How long shall they kill our prophets While we stand aside and look? Yes, some say it's just a part of it. We've got to fulfill the book. Won't you help to sing these songs of freedom? 'Cause all I ever had, redemption songs, These songs of freedom, songs of freedom. Breakdown http://www.easyukulele.com | ["Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["ukulele song", "chords", "strumming", "male voice", "narration", "simple melody", "simple rhythm", "moderate tempo", "instruction", "no vocal melody", "no other instruments"] | 0 | aQdZtz90Yzw | 3538 | |
Fender Blues Jr. with Clean Sound - Demo - Blues Junior | This song features an electric guitar. The guitar starts off with a descending pentatonic run. A descending slide is played followed by a moderate tempo blues lick. There are no other instruments in this song. There is no voice in this song. This is an instrumental song with a blues mood. This song can be played as an instructional blues song. | 2009-03-23T05:35:56Z | JVStratocasters | More info of JV (Japan Vintage) Stratocasters (1982~1984) at http://www.youtube.com/jvs30thanniversary (My new channel, please subscribe!) Questions? Feel free to email me at jvstratocasters@yahoo.com Fender Japan - Squier Logo JV Stratocaster 1983 - 2TS Fender Blues Jr. Amp - Blues Junior Strings - Dean Markley 10-46 | ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["electric guitar", "amateur recording", "blues melody", "no other instruments", "demo audio", "instructional audio", "no voices", "instrumental", "moderate tempo"] | 0 | vyNstX5b1V8 | 5223 |
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;