musiccaps_details (view)
3 rows where musiccaps_aspects contains "blues" and musiccaps_names contains "Soul music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- blues · 3 ✖
- electric guitar 2
- acoustic drums 1
- acoustic guitar 1
- ambient 1
- american 1
- bass guitar 1
- complex chords 1
- complex harmony 1
- cymbal rides 1
- dance 1
- dance groove 1
- easygoing 1
- energetic male vocalist 1
- fast tempo 1
- funk/soul 1
- funky 1
- groovy 1
- groovy bass lines 1
- groovy bassline 1
- improvisation 1
- infectious drum grooves 1
- instrumental 1
- keyboard harmony 1
- lively 1
- lively spirited 1
- male back vocals 1
- male vocal 1
- peppy 1
- perky 1
- piano accompaniment 1
- raspy male vocal 1
- repeated theme 1
- rhythm & blues 1
- rhythmic 1
- rhythmic counter play 1
- rock 1
- rock and roll 1
- simple drum beat 1
- simple tune 1
- slick drumming 1
- soothing 1
- soul 1
- soulful 1
- syncopated bass lines 1
- trumpets 1
- upbeat 1
- vibrant 1
- vivacious 1
musiccaps_names (array) 4 ✖
- Music 3
- Soul music · 3 ✖
- Funk 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
HONK - Hesitation | This music is instrumental. The tempo is fast with trumpet harmony, keyboard accompaniment, infectious drumming, syncopated, funky bass lines, lively piano and electric and acoustic guitar riffs. The music is upbeat, groovy, complex harmony, ambient, soulful and funky. This song is Funk Soul; | 2010-05-19T16:30:27Z | 123c123c123c | Honk - Honk LP :: 1974 | ["Swing music", "Music", "Soul music"] | ["instrumental", "fast tempo", "rock", "blues", "trumpets", "lively spirited", "complex harmony", "complex chords", "cymbal rides", "dance groove", "peppy", "perky", "vivacious", "keyboard harmony", "piano accompaniment", "groovy bass lines", "acoustic guitar", "electric guitar", "slick drumming", "trumpets", "lively", "ambient", "soothing", "improvisation", "soul", "funk/soul", "rhythmic", "dance groove", "syncopated bass lines", "rhythmic counter play", "infectious drum grooves"] | 7 | 2sIfE3KOi5s | 410 | |
MITCH RIDER & the DETROIT WHEELS - BREAKOUT | This is a rock and roll music piece. There is a male vocal singer singing as the lead while other back vocals sing rhythmic back vocals at a higher pitch than the lead. An electric guitar is playing a simple and repeated tune while there is a bass guitar in the background. The acoustic drums are playing a basic 4/4 rock beat with claps simultaneous with the snare hits. There is an easygoing atmosphere in this piece. It could be playing in the background of a rock bar. This piece could also work well in sports venues. | 2011-04-23T15:20:22Z | PaulGTSE | MITCH RIDER & the DETROIT WHEELS with BREAKOUT on the UK PYE DISCO DEMAND LABEL 100mph NORTHERN SOUL | ["Funk", "Music", "Soul music"] | ["rock and roll", "blues", "male vocal", "male back vocals", "electric guitar", "bass guitar", "acoustic drums", "american", "repeated theme", "simple tune", "easygoing", "groovy"] | 9 | GQbUpJFArKI | 1720 | |
Arthur Conley ~ Sweet Soul Music (1967) | This is an upbeat, soulful and funky song. It's got a catchy and fast paced rhythm which makes it good to dance to. The singer has a raspy and energetic voice. | 2011-10-24T15:04:43Z | TheOldrecordclub | This great soul song by "Arthur Conley" was released in 1967 and i believe this was the biggest hit song he had.He actually wrote this song with "Otis Redding" and the song was originally released on the Atco label. | ["Music", "Soul music"] | ["blues", "funky", "soulful", "upbeat", "dance", "vibrant", "groovy bassline", "rhythm & blues", "raspy male vocal", "energetic male vocalist", "simple drum beat"] | 3 | grE0lwTsSPg | 4060 |
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;