musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic guitars" and musiccaps_aspects contains "percussion" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- acoustic guitars · 3 ✖
- percussion · 3 ✖
- acoustic drums 2
- medium tempo 2
- e-bass 1
- flamenco 1
- folklore/country 1
- foreground-noises 1
- higher pitch 1
- latin/spanisch 1
- male voice singing 1
- medium to uptempo 1
- mood elevating 1
- oriental/orchestral 1
- oud 1
- shaker 1
- strings 1
- upright bass 1
musiccaps_names (array) 9 ✖
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lior Boker playing "A gate that closed" in maqam sika | This composition contains acoustic guitars strumming chords panned to the right side of the speakers. Other plucked string instruments are playing a melody along. An acoustic drum is playing a simple dance groove with a pregnant hihat. In the background you can hear an upright bass and violins playing a melody on the next part of the song. A male voice is singing in the mid-to high range. This song may be playing live. | 2008-09-19T14:59:57Z | lior boker | Lior Boker with the Israeli Andalusian Orchestra and Shimon Sibony | ["Orchestra"] | ["oriental/orchestral", "acoustic guitars", "oud", "strings", "acoustic drums", "percussion", "upright bass", "male voice singing", "higher pitch", "medium to uptempo"] | 6 | DPW5M1FYxu4 | 1473 | |
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 | |
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 |
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;