musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic guitars" and musiccaps_aspects contains "male voice singing" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- acoustic guitars · 3 ✖
- male voice singing · 3 ✖
- acoustic drums 2
- medium to uptempo 2
- amateur recording 1
- crowd cheering 1
- digital drums 1
- higher pitch 1
- mandolin 1
- oriental/orchestral 1
- oud 1
- percussion 1
- pop 1
- pop/singer-songwriter 1
- strings 1
- uplifting energy 1
- upright bass 1
- uptempo 1
musiccaps_names (array) 7 ✖
- Music 2
- Banjo 1
- Country 1
- Happy music 1
- Orchestra 1
- Singing 1
- Soundtrack music 1
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 | |
posdata te quiero galway girl | Two acoustic guitars being strummed can be heard while a male voice is singing in the mid range. Someone is strumming chords in a higher key alone. In the background you can hear acoustic drums and the crowd is cheering. This song may be playing live in a pub. | 2009-09-12T14:37:30Z | Adri Terroba | galway girl-posdata te quiero DISCLAIMER: NO COPYRIGHT INFRINGEMENT INTENDED. FOR ENTERTAINMENT PURPOSES ONLY | ["Singing", "Banjo", "Country", "Music"] | ["pop/singer-songwriter", "amateur recording", "acoustic guitars", "mandolin", "male voice singing", "acoustic drums", "crowd cheering", "uptempo", "uplifting energy"] | 6 | BhJa0kTUdGY | 1276 | |
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 |
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;