musiccaps_details (view)
5 rows where musiccaps_aspects contains "acoustic guitars" and musiccaps_aspects contains "medium tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- acoustic guitars · 5 ✖
- medium tempo · 5 ✖
- flamenco 2
- percussion 2
- acoustic drums 1
- amateur recording 1
- background noises 1
- bluegrass 1
- e-bass 1
- folklore/country 1
- foreground-noises 1
- latin/spanisch 1
- male singer 1
- male voices singing 1
- mid to high register 1
- mood elevating 1
- percussion's 1
- pop/singer-songwriter 1
- sad 1
- shaker 1
- upright/e-bass 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 |
---|---|---|---|---|---|---|---|---|---|---|
岡林信康『山谷ブルース』 | This song contains two acoustic guitars strumming and fingerpicking minor key melodies. A male voice is singing in the mid to high register sounding sad. This song may be playing gathered around a bonfire. | 2009-01-26T14:10:26Z | Dusty Dirty | ["Folk music", "Music"] | ["pop/singer-songwriter", "acoustic guitars", "male singer", "mid to high register", "medium tempo", "sad"] | 6 | 8Y0FRjkX9xI | 927 | ||
Flamenco belly dance fusion music | Two acoustic guitars are strumming flamenco chords being panned to the left and right side of the speakers. A soft bass is playing subnotes. Percussive instruments are building up tension at the end. | 2013-03-16T08:30:44Z | Lily Vahid | ["Traditional music", "Flamenco", "Music", "Music of Latin America", "Dance music"] | ["flamenco", "acoustic guitars", "upright/e-bass", "percussion's", "medium tempo"] | 6 | 9EUXyEQZqLo | 985 | ||
Manejo Racional de Bovinos de Corte | This song contains three guitars playing chords, and two melodies while one of the guitars stands out to be playing the main melody. The guitars are panned to the left and the right side of the speakers. An e-bass is playing a walking line that repeats itself. Different percussive instruments are panned to the left and right side of the speakers. There are some noises of doors opening and closing that I think do not belong to the musical composition and they sound in the foreground. This song may be playing in a house in the countryside. | 2014-02-20T18:54:49Z | Adriana Albuquerque | ["Music", "Thunk"] | ["latin/spanisch", "folklore/country", "acoustic guitars", "percussion", "foreground-noises", "e-bass", "mood elevating", "medium tempo"] | 6 | HYjSrwSm0T4 | 1814 | ||
Flamenco Rumba in E Major Improvisation Stefan Schyga | This audio contains various acoustic guitars playing a lead melody, a countermelody and strumming chords. An acoustic drum is holding a simple bossa nova groove along with shaker and percussion. This song may be played live outside by a busker. | 2010-03-01T03:37:32Z | guitarlessons | Spotify: https://open.spotify.com/album/2YGyrJdCPMjhol3ZcwZ0Pi?si=5PC6HAKvTSixB6tcFwikSA Pandora: https://pandora.app.link/pgX82c2qX7 Apple Music: https://geo.music.apple.com/us/artist/stefan/19320100?mt=1&app=music Here's a melodic improvisation on a nice chord progression in the key of E Major. The tabs for the solo, scales chords etc are available for free on my site: LearnHowToPlayGuitar.com The guitar is a Flamenca Negra by my friend Francisco Navarro. | ["Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument", "Classical music"] | ["flamenco", "acoustic guitars", "shaker", "acoustic drums", "percussion", "medium tempo"] | 6 | Mhvgz5AjV3U | 2289 | |
Will You Miss Me - Rosine Kentucky Bluegrass Barn Jamboree - Traditional Bluegrass Music | Acoustic guitars are strumming chords while male voices are singing along. There are a lot of background noises of people talking. The recording is of very poor quality. This song may be playing at a local small town event. | 2009-11-10T07:40:04Z | db | Melvin Gill & Pat Meehan of the Kentuckiana Grass band play music with a few friends (Doug Morris & Guynn Cagle on flat top guitars, Sandy Morris on the Dobro) at the Rosine, KY Barn Jamboree Friday Nov. 6, 2009. *Pat Meehan-Mandolin *Melvin Gill-Singing & flat pickin. | ["Country", "Music", "Bluegrass"] | ["bluegrass", "acoustic guitars", "male voices singing", "background noises", "amateur recording", "medium tempo"] | 6 | ZqnbgQeeRbM | 3420 |
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;