musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "instrumental", musiccaps_aspects contains "moderate tempo" and musiccaps_aspects contains "no other instruments"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- instrumental · 5 ✖
- moderate tempo · 5 ✖
- no other instruments · 5 ✖
- no percussion 4
- no voices 4
- folk song 2
- harmonica 2
- acoustic guitar 1
- acoustic song 1
- amateur recording 1
- bass guitar sound 1
- blues melody 1
- country song 1
- demo audio 1
- electric guitar 1
- fingerstyle guitar 1
- flamenco 1
- funk bass 1
- guitar song 1
- instructional audio 1
- no voice 1
- romantic mood 1
- sad melody 1
- slap bass 1
- upbeat 1
musiccaps_names (array) 12 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
David Serva por Seguiriya | This song features a guitar being played to a flamenco melody. Fingerstyle guitar is used. The song starts off at a higher register and ends at the lower register. The guitar is strummed at intervals. There are no other instruments in this song. There are no voices in this instrumental song. This song has a romantic mood. This song can be played at a quiet restaurant overlooking the sunset. | 2010-05-08T16:19:56Z | Dararith Long | David Jones (Serva) por Seguiriya in one of his public recordings. I really like the intro. The bulerias ending is quite nice as well. About the life of Serva: http://www.sfflamenco.com/historical/features/2002-04/balladofgypsydavy.html | ["Flamenco", "Acoustic guitar", "Music", "Strum", "Plucked string instrument"] | ["guitar song", "flamenco", "fingerstyle guitar", "no other instruments", "no voices", "instrumental", "moderate tempo", "romantic mood", "no percussion"] | 0 | EIzBD62ja8E | 1543 | |
Heart of Gold - Neil Young cover with harmonica | This folk song features a harmonica playing the main melody. The harmonica plays three descending notes. This is followed by a double stop being played a total of nine times in groupings of two, three, three and one time. Then it plays a higher note going down a descending scale of two more notes. This is accompanied by an acoustic guitar strumming chords. The mood of this song is sad. This song can be played at a house party. | 2007-06-22T22:38:17Z | mynamesche | **TUTORIAL IN RESPONSES** There are sixty million covers of heart of gold on youtube so I thought i'd add sixty million and one. Such a great, simple pop song from an amazing man who has pumped out so much amazing music over the years. Unfortunately no Linda Ronstadt and James Taylor on backing vocals but hey there's a wee bit o' harp in there at least. Please be careful if you're wearing headphones, i almost blew my ears up listening back to this and the harmonica came through like a sonic laser into my ear drum. | ["Harmonica", "Wind instrument, woodwind instrument"] | ["folk song", "acoustic song", "harmonica", "no voices", "no other instruments", "instrumental", "no percussion", "sad melody", "moderate tempo"] | 0 | XdBf_omYIO4 | 3203 | |
POD X3 LIVE - Bass sound Slap guitare | This song features a bass guitar. Slap bass is played. The riff is repetitive. There are no other instruments in this song. The tempo of this song is moderate. There are no voices in this song. This bass piece can be played in a funk song. | 2008-08-15T20:20:53Z | Olivier ESTELLE | Pod X3 live direct in PC - Simu ampli basse + octaver | ["Bass guitar", "Music"] | ["bass guitar sound", "instrumental", "no other instruments", "no percussion", "no voice", "moderate tempo", "funk bass", "slap bass"] | 0 | cXEJWtj2kT8 | 3715 | |
Guitar Harmonica WildWood Flower Folk music Country rack blues | This folk song features a harmonica playing the main melody. This is accompanied by an acoustic guitar strumming chords. There are no other instruments in this song. This is an instrumental song. There are no voices in this song. The mood of this song is upbeat and happy. This song can be played in a movie scene involving a highway drive. | 2008-06-01T07:49:24Z | Matthew Shelton | http://harmonicasuperstart.com/ Guitar and Harmonica simultaneously played: WildWood Flower Folk to Country styles, same song, 1 harmonica, two different keys. Go to HarmonicaSuperStart.com for more great info on playing the harmonica | ["Harmonica", "Wind instrument, woodwind instrument"] | ["harmonica", "acoustic guitar", "country song", "folk song", "no voices", "instrumental", "no percussion", "no other instruments", "moderate tempo", "upbeat"] | 0 | fWfQxB2pVrc | 3952 | |
Fender Blues Jr. with Clean Sound - Demo - Blues Junior | This song features an electric guitar. The guitar starts off with a descending pentatonic run. A descending slide is played followed by a moderate tempo blues lick. There are no other instruments in this song. There is no voice in this song. This is an instrumental song with a blues mood. This song can be played as an instructional blues song. | 2009-03-23T05:35:56Z | JVStratocasters | More info of JV (Japan Vintage) Stratocasters (1982~1984) at http://www.youtube.com/jvs30thanniversary (My new channel, please subscribe!) Questions? Feel free to email me at jvstratocasters@yahoo.com Fender Japan - Squier Logo JV Stratocaster 1983 - 2TS Fender Blues Jr. Amp - Blues Junior Strings - Dean Markley 10-46 | ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["electric guitar", "amateur recording", "blues melody", "no other instruments", "demo audio", "instructional audio", "no voices", "instrumental", "moderate tempo"] | 0 | vyNstX5b1V8 | 5223 |
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;