musiccaps_details (view)
4 rows where musiccaps_aspects contains "acoustic guitars" and musiccaps_aspects contains "medium to uptempo" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- acoustic guitars · 4 ✖
- medium to uptempo · 4 ✖
- male voice singing 2
- pop 2
- acoustic drums 1
- digital drums 1
- e-bass 1
- female duo singing 1
- higher pitch 1
- kids voices 1
- latin/country/folk 1
- male voices singing 1
- oriental/orchestral 1
- oud 1
- percussion 1
- percussion's 1
- strings 1
- upright bass 1
- upright-bass 1
musiccaps_names (array) 8 ✖
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ADAM - Smoorverlief [Official Music Video] | This song contains two acoustic guitars picking a melody. A digital drum is playing a simple groove when a male voice starts to sing in a higher register with backing vocals. Then the melody drops one octave. The guitars are panned to the left and right side of the speakers. This song may be playing on a road trip with friends. | 2014-12-15T09:58:51Z | adamgroep | ADAM se derde enkelsnit vanaf hulle nuutste album Goud - "Smoorverlief" se musiek video word aan al die fans uitgemaak! Geniet hom! Musiek en lirieke: Hugo Ludik & Reynardt Hugo Hierdie is die amptelike video vir "Smoorverlief" ons het soveel fun gehad met die shoot dat ons ook vir julle bonus videos gemaak het. Gaan check hulle ook uit: Bonus video #1: http://youtu.be/Uip6zvPKUZY Bonus video #2: http://youtu.be/Rd7vxmcj-ts Goud is nou landswyd beskikbaar by alle goeie musiek winkels of op itunes: https://itunes.apple.com/za/album/goud/id883444570 Sien ook ons vorige musiek video: ADAM - Goud https://www.youtube.com/watch?v=RsZB0EEct4w Vold ons op Facebook: https://www.facebook.com/adamgroep en Twitter: https://twitter.com/adamgroep en ons Website: http://www.adamband.co.za en onthou om die video te share en te like! ;) Video: http://fathom.co.za/video/smoorverlief © 2014 Copyright. ADAM Band | ["Music", "Soundtrack music", "Happy music"] | ["pop", "acoustic guitars", "male voice singing", "digital drums", "medium to uptempo"] | 6 | 5fPxUI0Fl-4 | 678 | |
Arunachal Pradesh Traditional Dance and Modern Dance FUSION Music Video | A lot of percussive instruments are being played and panned to the left and right side of the speakers. A funky bassline is repeating the same pattern with fill-ins. An acoustic guitar is strumming funky chords and another guitar-like instrument is playing a melody on top. Male voices are singing in unison and kids voices are responding as backing vocals. This is an amateur recording. | 2013-06-09T04:36:31Z | cosmo z | Arunachal Pradesh Traditional Dance and Modern Dance FUSION Music Video-Song:-Nyodege Haaduku-Language:-Nyishi | ["Music of Africa", "Music", "Music of Bollywood", "Dance music"] | ["pop", "acoustic guitars", "male voices singing", "kids voices", "e-bass", "percussion's", "medium to uptempo"] | 6 | kUQ1xfK82Q0 | 4322 | |
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 | |
Por que te conoci - Hermanas Nuñez de Tere Beltrán - Alfa Music | An acoustic guitar almost fully panned to the left side of the speakers is strumming a single chord as a rhythmic element while an upright-bass is playing a walking bassline. The other acoustic guitar is adding a little melody at the end of the phrase of the singers. The female duo is singing a melody together. One a little deeper and the other a little higher creating a harmony. This song may be playing in the countryside of a Latin country. | 2010-03-19T05:43:31Z | terebeltran | Por que te conoci - Hermanas Nuñez de Tere Beltrán - Alfa Music | ["Traditional music", "Music", "Happy music"] | ["latin/country/folk", "acoustic guitars", "upright-bass", "female duo singing", "medium to uptempo"] | 6 | 4AejyFDHP_k | 542 |
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;