musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic piano" and musiccaps_aspects contains "male voices singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- acoustic piano · 3 ✖
- male voices singing · 3 ✖
- uptempo 2
- acoustic drums 1
- amateur recording 1
- background laughter 1
- brass section 1
- e-bass 1
- e-guitar 1
- flute 1
- funny 1
- gospel/blues 1
- jazz/pop 1
- low to higher register 1
- male voice talking 1
- medium tempo 1
- upright bass 1
musiccaps_names (array) 8 ✖
- Music 3
- Classical music 1
- Gospel music 1
- Meow 1
- Rhythm and blues 1
- Singing 1
- Ska 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Meow Song | An acoustic piano is playing a minor chord progression while two men are singing in the mid and higher register. They seem to be imitating cat sounds so the crowd is laughing. This is an amateur recording. This song may be playing in a comedic live performance on stage. | 2010-05-30T02:11:37Z | mhv199 | Michael and Mike Kirksey sang the Meow song at Backstage Cabaret 2010. | ["Music", "Meow", "Classical music"] | ["acoustic piano", "background laughter", "male voices singing", "amateur recording", "medium tempo"] | 6 | W0aT3SdtnfY | 3054 | |
Robbie Williams I Wan'na Be Like You feat Olly Murs The Graham Norton | A male voice is singing in the midrange then another male voice joins singing in a lower harmony. In the background you can hear a jazz drum playing along with an upright bass and a flute. An acoustic piano is playing jazzy licks. Then the drum breaks the beat with strong fill-ins before a brass section elevates the piece. This song may be playing live during a jazz performance. | 2013-11-23T09:37:56Z | Jenny Ocean | ["Singing", "Music", "Ska"] | ["jazz/pop", "male voices singing", "acoustic piano", "flute", "upright bass", "brass section", "uptempo", "funny"] | 6 | XhV4zf-Xlmk | 3213 | ||
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;