musiccaps_details (view)
2 rows where musiccaps_author = 9, musiccaps_names contains "Wind instrument, woodwind instrument" and youtube_channel = "Håkan Ehn"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
How to play Iron Man - Black Sabbath rock riff harmonica lessons with tabs | This is the recording of a harmonica lesson. There is a male instructor who is playing the harmonica and then describing his technique. | 2009-12-18T17:27:24Z | Håkan Ehn | Watch my Black Sabbath harmonica videos: http://www.youtube.com/view_play_list?p=3141E65F21D0B7F9 Harmonica: Håkan Ehn. Watch my version of Iron Man: http://www.youtube.com/watch?v=v2pczYsbhHM ****See tabs below******** 1 draw 2 draw-bend- whole tone 2 draw-bend- whole tone 2 draw 2 draw BREATHE OUT !! 3 draw-bend- half tone 3 draw-bend- whole tone 3 draw-bend- half tone 3 draw-bend- whole tone 3 draw-bend- half tone 3 draw-bend- whole tone 2 draw-bend- whole tone 2 draw-bend- whole tone 2 draw 2 draw BREATHE OUT !! . | ["Harmonica", "Wind instrument, woodwind instrument"] | ["lesson recording", "harmonica", "male voice", "instructive speaking"] | 9 | ZK3bYlekfm0 | 3361 | |
Harmonica Lessons: Stone Fox Chase Part 1 | This is an instrument lesson recording. The same tune is being played repeatedly on a harmonica to present a technique on how to play it. The male instructor gives occasional descriptions about the technique. | 2008-07-21T14:00:53Z | Håkan Ehn | Harmonica in the key of A (music in E). Study these tabs. Learn to play the song all harp pros play, for example Adam Gussow, Mark Feltham and Charlie McCoy (Area Code 615). This video shows (see tabs below) how to play the part between 0:00-0:26 in the video STONE FOX CHASE in the tunnel: http://uk.youtube.com/watch?v=tX_OG4Q4bfQ See also Stone Fox Chase Lessons Pt 2: http://uk.youtube.com/watch?v=pxBc5ss2ceQ See also Stone Fox Chase Lessons Pt 3: http://uk.youtube.com/watch?v=n5G7vKicWeo BLOCK A (0:06-0:16) SEGMENT A.1 Draw hole 2 -- bend Draw hole 2 Draw hole 2 Blow hole 1-4 Blow hole 1-4 SEGMENT A.2 Draw hole 2 Draw hole 2 Draw hole 3 -- bend Draw hole 2 Draw hole 2 -- bend Draw hole 1 SEGMENT A.3 (same as A.1, A.5) Draw hole 2 -- bend Draw hole 2 Draw hole 2 Blow hole 1-4 Blow hole 1-4 SEGMENT A.4 Draw hole 4 Draw hole 4 -- bend Blow hole 4 Blow hole 3 Draw hole 3 -- bend SEGMENT A.5 (same as A.1, A3) Draw hole 2 -- bend Draw hole 2 Draw hole 2 Blow hole 1-4 Blow hole 1-4 SEGMENT A.6 Draw hole 2 Draw hole 2 Draw hole 3 -- bend Draw hole 2 Draw hole 2 -- bend SEGMENT A.7 Draw hole 3 -- bend Draw hole 2 Draw hole 2 -- bend Draw hole 3 -- bend Draw hole 2 Draw hole 2 -- bend SEGMENT A.8 Draw hole 3 -- bend Draw hole 2 Draw hole 2 -- bend Draw hole 2 Blow hole 1-4 Blow hole 1-4 BLOCK B (0:16-0:26) Same as Block A, D. BLOCK C (0:26-0:36) SEGMENT C.1 Draw hole 4 Draw hole 4 -- bend Blow hole 4 SEGMENT C.2 Draw hole 2 Draw hole 3 Blow hole 4 Draw hole 4 -- bend Draw hole 3 Blow hole 4 Blow hole 3 Draw hole 3 Draw hole 2 SEGMENT C.3 Draw hole 2 Draw hole 2 -- bend Draw hole 2 Draw hole 3 -- bend Blow hole 1-4 Blow hole 1-4 SEGMENT C.4 (same as C.1) Draw hole 4 Draw hole 4 -- bend Blow hole 4 SEGMENT C.5 (same as C.2) Draw hole 2 Draw hole 3 Blow hole 4 Draw hole 4 -- bend Draw hole 3 Blow hole 4 Blow hole 3 Draw hole 3 Draw hole 2 SEGMENT C.3 Draw hole 2 Draw hole 2 -- bend Draw hole 2 Draw hole 2 -- bend Blow hole… | ["Harmonica", "Wind instrument, woodwind instrument"] | ["instrument tutorial", "harmonica", "repeated tune", "male voice", "instructive"] | 9 | l3YrliBpOdM | 4372 |
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;