musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "happy" and musiccaps_aspects contains "r&b" sorted by youtube_channel
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 47 ✖
- groovy 2
- happy · 2 ✖
- male singer 2
- r&b · 2 ✖
- vocal backup 2
- african music 1
- animated 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
- electric guitar 1
- fast tempo 1
- funk 1
- funky 1
- groovy bass lines 1
- infectious drumming 1
- jive music 1
- keyboard accompaniment 1
- live performance 1
- lively animated 1
- lively cello 1
- medium tempo 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
- spirited 1
- stage performance 1
- steady drumming 1
- the lord’s prayer 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 | |
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;