musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "medium to uptempo" and musiccaps_names contains "Percussion" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- medium to uptempo · 3 ✖
- acoustic drums 2
- amateur recording 2
- e-guitar 2
- reggae 2
- acoustic guitar 1
- backing track 1
- bongos 1
- congas 1
- digital/acoustic drums 1
- djembe 1
- e-bass 1
- male voice samples 1
- seductive 1
- shaker 1
- steel drums 1
- techno/singer-songwriter 1
musiccaps_names (array) 11 ✖
- Percussion · 3 ✖
- Music 2
- Bass drum 1
- Cymbal 1
- Drum 1
- Hi-hat 1
- Musical instrument 1
- Rattle (instrument) 1
- Rimshot 1
- Snare drum 1
- Steelpan 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tinashe - Mr. Presumption | A digital kick in playing on every beat along with short voice samples with breathy sounds that sound seductive. Then the song changes into someone fingerpicking an acoustic guitar along to someone playing an acoustic snare/hihat with brushes. This first song may be playing in a club and the second one at a live concert. | 2009-12-02T21:26:27Z | boXd productions | as introduced by 4Music's 'Intros' series - but without the annoying and highly pretentious introduction at the beginning ... | ["Cymbal", "Drum", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["techno/singer-songwriter", "acoustic guitar", "digital/acoustic drums", "male voice samples", "seductive", "medium to uptempo"] | 6 | gjujPd1lP8E | 4050 | |
reggae.avi | People are playing the same groove on a lot of percussive instruments. In the background you can hear shakers. Someone is strumming chords with an effect on an e-guitar and someone is playing fill-ins on acoustic drums. This song may be playing at a local live concert from a music school. | 2010-09-10T18:11:18Z | pchedy | Primer contacto en la composicion de un reggae de la escuela de percusion de Santa Ursula bajo la direccion de Chedy Perera | ["Music", "Rattle (instrument)", "Percussion"] | ["amateur recording", "reggae", "shaker", "bongos", "djembe", "congas", "bongos", "acoustic drums", "e-guitar", "medium to uptempo"] | 6 | 9Tl2l3bsLpE | 1011 | |
Is This Love? | This audio contains someone playing a melody on steeldrums along to a backing track containing an e-bass playing a melody along with an e-guitar. A kick is being played on every beat. This song may be played on the streets by a busker. | 2011-03-22T14:37:55Z | Steel Drum Music | Bob Marley's classic reggae hit played in 2011 at the Harbor Beach Marriott, Fort Lauderdale, Florida. This song is featured on the 'Steel Drum Rub-a-Dub: Bob Marley Tribute' album. You can get it at: iTunes - http://bit.ly/aE3djW Amazon - http://bit.ly/cgT7rA or directly from Bob Lyons' web site: http://www.SteelDrumMusic.net | ["Music", "Musical instrument", "Percussion", "Steelpan"] | ["amateur recording", "reggae", "backing track", "e-bass", "acoustic drums", "steel drums", "e-guitar", "medium to uptempo"] | 6 | msnm_tYXcYw | 4497 |
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;