musiccaps_details (view)
5 rows where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "e-guitar", musiccaps_aspects contains "male voice singing" and musiccaps_aspects contains "piano"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ngayong Gabi - brownman revival | This audio contains reggae-like drums playing along with a bass. An e-guitar is strumming short chords on the backbeat giving this song its typical reggae feel. An organ is playing a melody panned to the left side of the speakers playing short fast chords. A male voice is singing a melody in a higher pitch than a piano is walking down the scale creating a melody then a chime comes in getting the song ready for the next part. This song may be playing while sitting by a lake with your friends. | 2010-09-06T03:16:22Z | gin2141 | ["Soul music"] | ["reggae", "e-bass", "e-guitar", "acoustic drums", "male voice singing", "higher pitch", "organ", "piano", "chimes", "uptempo"] | 6 | 8HHrlxQuZKE | 909 | ||
12'' Sound Iration & Tena Stelin - Give Thanks & Praise | An acoustic drum is playing a fast groove with a kick-hit on every beat. The snare hit is full of reverb and panned to the right side of the speaker. A loud e-bass is playing a melody along with a clean e-guitar. A piano is playing a chord progression also adding a rhythmic element to the song. The male voice is singing in the mid range and gets support from backing voices that are barely noticeable. This song may be playing at a headshop. | 2012-01-20T00:18:05Z | RasDashanSound | www.youtube.com/user/RasDashanSound | ["Funk", "Music", "Reggae", "Rhythm and blues"] | ["reggae", "acoustic drums", "piano", "e-guitar", "e-bass", "male voice singing", "sound-effects", "backing vocals", "uptempo"] | 6 | Fsm-xDmyFKg | 1669 | |
vroom vroom i värmlandsskogen | This song contains acoustic drums holding the rhythm together with a bass and almost clean e-guitar strumming chords. A piano is adding single notes on top while a male voice is singing a melody getting backed up by a female voice singing along. In the background motor race sounds can be heard. This song may be playing in a car with windows open on a road trip. | 2013-01-14T20:08:43Z | robert bengtsson | ["Christian music", "Music", "Rock music"] | ["pop/rock", "e-bass", "piano", "e-guitar", "acoustic drums", "motor racing sound", "male voice singing", "female backing voice", "uptempo"] | 6 | WyGJdstaxK4 | 3153 | ||
FUNK MONSTERS SUPER 70´s MEDLEY | A male voice is singing a melody in the midrange sounding like having fun while doing so. Backing vocals are shouting at the end of his phrase. In the background you can hear the instruments playing funky melodies; rhythms and grooves. What stands out is a flute playing a flute melody sounding like a traditional chinese melody and digital strings are playing in the midrange. This song may be playing celebrating graduation with costumes. | 2008-10-29T19:50:41Z | dodefonk | FUNK MONSTERS | ["Funk", "Music", "Happy music"] | ["funk", "e-bass", "acoustic drums", "piano", "transverse flute", "digital strings", "e-guitar", "male voice singing", "medium to uptempo", "positive energy"] | 6 | tUZB_Xf1m6k | 5040 | |
ARCHIE BELL & THE DRELLS - DANCING TO YOUR MUSIC (GLADES) | This song contains acoustic drums playing a groove along with an e-bass and a tambourine. A brass section is playing along with the drum fills and the bongos. A piano is playing a melody together with a guitar strumming chords in the mid range. The male singer sounds loud and soulful. This song may be playing in a rollerblade disco. | 2011-09-16T12:58:50Z | EddiesSoulSounds | More early 70's brilliance. This one from Texas giants Archie and the Drells who released this cracking mid-tempo dancer on the Miami based Gllades label from 1972. Great stuff! | ["Swing music", "Music", "Musical instrument", "Reggae", "Song"] | ["r&b/soul", "e-bass", "brass section", "e-guitar", "bongos", "acoustic drums", "male voice singing", "tambourine", "piano", "medium to uptempo"] | 6 | vx5iuWuE2Ng | 5220 |
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;