musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "uptempo" and musiccaps_names contains "Rhythm and blues"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- acoustic drums · 3 ✖
- e-bass 3
- uptempo · 3 ✖
- e-guitar 2
- acoustic piano 1
- backing vocals 1
- e-guitars 1
- female voice singing 1
- gospel/blues 1
- keys 1
- low to higher register 1
- male backing voice 1
- male voice singing 1
- male voice talking 1
- male voices singing 1
- piano 1
- reggae 1
- rock 1
- sound-effects 1
musiccaps_names (array) 8 ✖
- Music 3
- Rhythm and blues · 3 ✖
- Exciting music 1
- Funk 1
- Gospel music 1
- Happy music 1
- Reggae 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Tra La La Song Music Video - Full Version | An acoustic drum is playing a simple rock groove with some drum fills on the toms and snare along with a distorted e-bass and e-guitar playing the same line. Panned to the right side of the speaker you can hear a piano sound playing a little melody. A female voice is singing a happy sounding melody while male backing voices are supporting her. This song may be playing sitting in your room enjoying being at home alone. | 2010-02-11T03:47:04Z | Derek Bartholomaus | This is the full version of "The Tra La La Song (One Banana, Two Banana)" aka The Banana Splits Theme as performed by Liz Phair and Material Issue for the Saturday Morning Cartoons' Greatest Hits music and video project. This version was not released on home video and was only aired on MTV. This material is © 1995 by MCA Records. | ["Music", "Rhythm and blues", "Happy music", "Exciting music"] | ["rock", "e-guitars", "e-bass", "acoustic drums", "keys", "female voice singing", "male backing voice", "uptempo"] | 6 | -JvB5AL59fM | 36 | |
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 | |
The Gospel Music of the Statler Brothers | This song contains someone playing a blues melody on the acoustic piano along with an e-guitar and an e-bass. The acoustic drums are playing a constant rhythm while male deep voice is backed by higher sounding male voices singing harmonies along with him. Then a male voice starts talking that seems not to be part of the musical composition. This song may be playing in a cafe. | 2010-03-05T16:11:23Z | Gaither Music TV | Gaither Studios teamed up with the Statler Brothers to bring gospel music lovers a new, must-have DVD collection! Bill Gaither recently sat down with the Statler Brothers to talk about life, music, faith and of course, gospel music. The 2-DVD & CD collection will be out in stores May 18, 2010. You won't want to miss this special DVD event. Check out Gaither.com for more details! | ["Gospel music", "Music", "Rhythm and blues", "Speech"] | ["gospel/blues", "male voices singing", "low to higher register", "male voice talking", "acoustic piano", "e-bass", "acoustic drums", "e-guitar", "uptempo"] | 6 | imIFtW4O5S0 | 4218 |
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;