musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "r&b", musiccaps_aspects contains "vocal backup" and musiccaps_author = 7
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 64 ✖
- male singer 3
- r&b · 3 ✖
- vocal backup · 3 ✖
- groovy 2
- happy 2
- medium tempo 2
- african music 1
- ambient 1
- animated 1
- bongos 1
- brass band 1
- bright trumpets 1
- buoyant 1
- carrie an music 1
- catchy 1
- charming 1
- clapping cheering 1
- classic rock 1
- concert 1
- congas 1
- electric guitar 1
- elegant 1
- fast tempo 1
- funk 1
- funk pop 1
- funk soul 1
- funky 1
- funky electric guitar 1
- groovy bass line 1
- groovy bass lines 1
- infectious drumming 1
- jive music 1
- keyboard accompaniment 1
- keyboard harmony 1
- live performance 1
- lively animated 1
- lively cello 1
- man laughing 1
- movie soundtrack 1
- pleasant 1
- punchy 1
- reggae 1
- reggae tones 1
- retro 1
- rhythmic acousitc guitar 1
- rock and rock 1
- rock pop 1
- shakers 1
- simple 1
- slick 1
- slick drumming 1
- smooth 1
- soul 1
- spirited 1
- stage performance 1
- steady drumming 1
- tambourine beats 1
- the lord’s prayer 1
- trombone 1
- trumpets 1
- upbeat 1
- vibrant 1
- vivacious 1
- world music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Israel Vibration African Unification | A male vocalist sings the Lord’s Prayer. The tempo is medium with Keyboard harmony, steady drumming, groovy basslines, rhythmic guitar,beat of shakers, vocal backup and a trumpet flourish. The music is simple, rhythmic, pleasant, catchy, soulful and punchy Reggae. There are sounds of people clapping and cheering in the background indicating that this is a live performance. | 2007-02-25T01:52:21Z | David Ruiz | Israel Vibration African Unification | ["Music", "Reggae", "Ska"] | ["male singer", "medium tempo", "reggae", "live performance", "stage performance", "concert", "rhythmic acousitc guitar", "clapping cheering", "vocal backup", "shakers", "pleasant", "punchy", "groovy", "happy", "simple", "pleasant", "reggae tones", "groovy bass lines", "trumpets", "brass band", "shakers", "steady drumming", "keyboard accompaniment", "the lord’s prayer", "carrie an music", "african music", "r&b", "world music", "catchy"] | 7 | blsYgo-B1k8 | 3650 | |
Edwin Starr - Easin' In (1973) | A male vocalist sings this smooth Soul song. The tempo is medium with a groovy bass line, trombone harmony, electric guitar rhythm, slick drumming, vocal backup, congas and tambourine beats with smooth vocal backup. The song is soft, rich, elegant, ambient and smooth. This music is a Funk pop/Soul. | 2008-01-28T22:17:08Z | veewee | from the album "Hell Up in Harlem" | ["Music", "Reggae"] | ["male singer", "medium tempo", "man laughing", "tambourine beats", "groovy bass line", "congas", "elegant", "smooth", "slick", "bongos", "funky electric guitar", "vocal backup", "slick drumming", "keyboard harmony", "trombone", "funk pop", "soul", "r&b", "funk soul", "movie soundtrack", "ambient"] | 7 | kOBh4NZ4wZQ | 4313 | |
She's So Fine - Jackie Wilson | A male vocalist sings this lively Rock song. The tempo is fast with bright trumpet harmony, groovy bass, infectious drumming , electric guitar and vocal backup. The music is upbeat, groovy, funky, high-spirited, vibrant and enthusiastic. This song is Retro Rock and Roll. | 2012-09-22T18:49:33Z | Mike Swindle | Hard to find music. | ["Brass instrument", "Trombone"] | ["male singer", "fast tempo", "lively cello", "bright trumpets", "vibrant", "classic rock", "animated", "buoyant", "groovy", "funky", "vibrant", "vivacious", "happy", "charming", "vocal backup", "spirited", "retro", "jive music", "upbeat", "spirited", "infectious drumming", "electric guitar", "lively animated", "rock and rock", "rock pop", "funk", "r&b"] | 7 | r4nPBNL3D0E | 4849 |
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;