musiccaps_details (view)
2 rows where musiccaps_aspects contains "male voice" and "youtube_published" is on date 2009-12-18
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 |
---|---|---|---|---|---|---|---|---|---|---|
Yellow Ledbetter Tab How to Play Pearl Jam guitar Lesson - Eddie Vedder | This clip features a guitar chord being strummed in the beginning. This is followed by a male voice narrating a song. There are no other instruments in this song. There is no vocal melody in this clip. | 2009-12-18T08:33:21Z | GuitarJamz | click here to request your song http://www.guitarjamz.com/new_requests/ Great Lessons at http://www.guitarjamz.com/shop/ | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | ["electric guitar", "male voice", "narration", "no other instruments", "no vocal melody"] | 0 | 1o7iTDLNTFk | 312 | |
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 |
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;