musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "easygoing" and musiccaps_aspects contains "electric guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- amateur recording · 2 ✖
- easygoing · 2 ✖
- electric guitar · 2 ✖
- instrumental 2
- acoustic drums 1
- backing track 1
- bass guitar 1
- blues 1
- clean sound 1
- harmonica solo 1
- jam 1
- no singer 1
- rock-n-roll 1
- simple tunes 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
9 year old boy genius guitar player | This is an electric guitar jam being performed by a 9 year-old. It is an amateur recording, so there is a constant feedback noise coming from the amp. The electric guitar has a clean sound. The tunes are mostly simple with a lot of muted strokes. The recording has an easygoing atmosphere. If the feedback noise can be bypassed, the tunes from this recording can be used in beat-making. | 2007-02-27T05:22:37Z | ricki lake | Check this 9 year old guitar wizz playing jimi hendrix classic, Little Wing. | ["Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["jam", "no singer", "instrumental", "amateur recording", "electric guitar", "clean sound", "simple tunes", "easygoing"] | 9 | 1SO5RJLWKAs | 276 | |
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 |
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;