musiccaps_details (view)
4 rows where musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "blues" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- amateur recording · 4 ✖
- blues · 4 ✖
- acoustic drums 1
- acoustic guitar 1
- backing track 1
- bass guitar 1
- e-guitar 1
- e-piano 1
- easygoing 1
- electric guitar 1
- harmonica 1
- harmonica solo 1
- instrumental 1
- male deeper voice speaking 1
- male voice talkin 1
- medium tempo 1
- rock-n-roll 1
- slow tempo 1
- uptempo 1
musiccaps_names (array) 14 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Blues Piano Lesson - Improvising in D | This audio contains someone playing blues on an e-piano. This audio is in poor audio quality, you can hear white noise from the recording. This song may be playing piano at home. | 2007-06-04T16:39:45Z | MusicGuru12 | Hey, this is a short but sweet video on a few licks in D. I hope you like the rather zoomed in camera angle, and that it is not to blurry. Please leave a comment so I know what you think. Thanks, Ben | ["Blues", "Music", "Musical instrument", "Keyboard (musical)", "Piano"] | ["amateur recording", "blues", "e-piano", "uptempo"] | 6 | 2gc1L3g1itU | 396 | |
Gindick Lesson Improvising I | A deep male voice is talking then starts strumming chords on an acoustic guitar while blowing a melody on top with a harmonica. This song may be playing live explaining music. | 2006-09-28T00:45:28Z | JamCamp06 | Subscribe to Jon's newsletter at http://www.bluesharmonicajamcamp.com/newslettersubscribe.html Key of C. Like the lesson? Rate, subscribe and comment! It encourages the author to make more. | ["Harmonica", "Wind instrument, woodwind instrument"] | ["amateur recording", "blues", "male deeper voice speaking", "acoustic guitar", "harmonica", "slow tempo"] | 6 | P4zWSoib5BU | 2502 | |
Mondharmonica beginners video 5; solo opbouw deel 1 : diverse loopjes | This is an amateur recording of a harmonica solo being performed over a blues/rock-n-roll music piece. The piece is instrumental. The harmonica plays a melodic solo in the style of blues. The backing track consists of the electric guitar and the bass guitar playing a simple tune while the medium tempo acoustic drums are playing a basic blues rock beat. The atmosphere is easygoing. This piece could be playing from the radio during a road trip in a movie. | 2011-05-23T18:08:11Z | Harmonicaworkshops | Toonsoort: G , harp in C Video-instructie behorende bij de vervolg-lessen van Hans de Vries. Een solo wint aan kracht als je structuur aanbrengt. Al met een paar eenvoudige loopjes kun je een functionele solo spelen... je kunt in deze solo ook nog je handen gebruiken voor een mooi vibrato affect. Ik laat dit achterwege, zodat je goed kunt zien wat ik doe. De originele backingtrack om zelf op los te gaan , vind je hier: https://www.youtube.com/watch?v=68dvF4_5HK0 Want more? zie http://www.harmonicatips.nl | ["Harmonica", "Wind instrument, woodwind instrument"] | ["amateur recording", "blues", "rock-n-roll", "instrumental", "harmonica solo", "backing track", "electric guitar", "bass guitar", "acoustic drums", "easygoing"] | 9 | Ypuv3htJlpg | 3313 | |
Beginners, VERY EASY Country Lead Guitar Lesson With Scott Grove | This recording contains a male voice talking and then playing a blues riff on a clean e-guitar. This song may be playing as part of a video tutorial. | 2013-05-03T11:45:35Z | Groovy Music Lessons | Donations Via Paypal: mrmrswoodworker@aol.com Merchandise: https://www.doctorgroovymerch.com/ http://www.groovymusiclessons.com You can purchase the 200 plus hours of lessons for only $25. The deal of the century! NONE of my YouTube videos are in these 200 hours. Merchandise: https://www.doctorgroovymerch.com/ Donations Via Paypal: mrmrswoodworker@aol.com | ["Country", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument", "Bluegrass"] | ["blues", "amateur recording", "male voice talkin", "e-guitar", "medium tempo"] | 6 | JDWPJ1AiDKc | 1981 |
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;