musiccaps_details (view)
4 rows where musiccaps_aspects contains "male voice", musiccaps_author = 9 and musiccaps_names contains "Electronic tuner"
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 Butterflies & Hurricanes - Part 1 (LearnMUSE) | This is the recording of a keyboard lesson. There is a male instructor that plays the notes on the keyboard first and then describes the placement of the fingers and the notes that are being played. The audio quality of the lesson is not that great. | 2008-03-10T19:35:06Z | LearnMUSE | Band: Muse Album: Absolution Song: Butterflies & Hurricanes -- Part 1 of 3 -- This is a tutorial for Butterflies and Hurricanes by Muse on the piano by Samuel Deacon. Sorry about the camera positioning, its very difficult to fit everything in, especially on this song. If my hands go off the screen, just try to listen to the notes I'm telling you to play. I've made this with beginners in mind, so if you're a seasoned player you can ignore me talking about notes of chords and stuff. Remember, don't give up, a lot of the song is repeated so if you can get one part down the rest becomes easy. Don't give up on the tricky bits (the solo lol), it takes time before it all becomes smooth. It's a great song to play, really not THAT difficult and a great for showing off! | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Speech", "Electronic tuner", "Inside, small room"] | ["lesson recording", "amateur recording", "keyboard lesson", "male voice", "instructive speaking"] | 9 | 2pTnwe3DzCs | 408 | |
| intermediate to advanced guitar lesson -Blues Soul R&B Funk Jazz Progression | This is the recording of a guitar lesson. The instructor at first plays the chords on a clean sounding electric guitar and then describes the nature of the chord that he is playing. The chords that were strummed could be used as clean electric guitar samples in beat-making. | 2009-04-16T18:13:58Z | GuitarJamz Lessons | http://guitarjamz.com here is a great progression to solo over, or practice your soloing!! follow me at twitter http://twitter.com/martyschwartz http://youtube.com/martyfs74 | ["Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | ["lesson recording", "guitar lesson", "electric guitar", "clean sound", "simple tune", "male voice", "instructive speaking"] | 9 | 3noh9LiQNrs | 503 | |
| Guitar Lesson - Hallelujah by Jeff Buckley - Simple How to Play Tutorial | This is the recording of a guitar lesson video. There is a male speaking in an instructive manner, giving the name of the chord he is about to play next. The chords are being played gently on a clean sounding electric guitar. There is a mellow feel to the sound. Parts of this recording can be sampled for use in beat-making. | 2011-02-02T23:22:19Z | FullDistortionDotCom | http://www.FullDistortion.com - Lesson on how to play Hallelujah by Jeff Buckley. To view this lesson with the tab go to http://www.FullDistortion.com. To join the Full Distortion Players' Club go to http://www.FullDistortion.com/players-club Copyrights to any songs mentioned or used are the property of the artist and its promoters, producers and/or affiliates and is used here for informational and educational purposes only as outlined in the Fair Use provision of Title 17 of the United States Code as amended by the Digital Millennium Copyright Act of 1998. No copyright infringement intended. | ["Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | ["guitar lesson", "male voice", "instructive speaking", "electric guitar", "clean sound", "gentle playing", "mellow"] | 9 | WvaIypMvAHY | 3149 | |
| Joe Bonamassa Inspired Guitar Lick - Blues Rock Guitar Lessons - Speed Building | This is the recording of a guitar lesson video. There is a male instructor first performing the tune and then describing what he is playing. The tune is being played on a clean sounding electric guitar and there is a blues feel to it. The atmosphere is easygoing. The parts the male voice is not heard can be sampled for use in beat-making. | 2011-06-01T23:23:19Z | GuitarJamz | My Technique and review channel http://www.youtube.com/youcanlearnguitar Joe Bonamassa Inspired Guitar Lick - Blues Rock Guitar Lessons - Speed Building Excercise marty schwartz lesson against rise electric metal picking steve play "guitar lesson" chords gilbert sweep improvisation guitarist solos beginner learn acoustic tab jazz scales jam instrumental guitars "electric guitar" minor classical "guitar lessons" | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument"] | ["guitar lesson", "male voice", "electric guitar", "clean sound", "blues", "easygoing"] | 9 | YDh36ZdneAU | 3266 |
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;