musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "fast tempo", musiccaps_aspects contains "piano accompaniment" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- fast tempo · 2 ✖
- piano accompaniment · 2 ✖
- acoustic guitar 1
- ambient 1
- blues 1
- complex chords 1
- complex harmony 1
- cymbal rides 1
- dance groove 1
- electric guitar 1
- enthusiastic 1
- funk/soul 1
- funky bass line 1
- galloping beat 1
- groovy 1
- groovy bass lines 1
- heavy reverb 1
- improvisation 1
- infectious drum grooves 1
- instrumental 1
- jazz 1
- keyboard harmony 1
- lively 1
- lively spirited 1
- male vocalist 1
- mediocre audio recording 1
- peppy 1
- perky 1
- rhythmic 1
- rhythmic acoustic guitar 1
- rhythmic counter play 1
- rock 1
- simple melody 1
- slick drumming 1
- slightly off key vocals 1
- soothing 1
- soul 1
- steady drumming 1
- swing 1
- syncopated bass lines 1
- trumpets 1
- vivacious 1
musiccaps_names (array) 7 ✖
- Music 2
- Funk 1
- Pop music 1
- Singing 1
- Song 1
- Soul music 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 | |
FUNKY B & THE KINGS OF SHUFFLE - Phonin' - LIVE 2009 | A male vocalist sings this jazz style melody. The tempo is fast with syncopated piano accompaniment, slick drumming, groovy bass line and rhythmic acoustic guitar. The music is energetic, ambient, mellow, pleasant with a dance groove. | 2010-10-30T21:08:57Z | Kings of Shuffle | FUNKY B & THE KINGS OF SHUFFLE playing "Phonin'" live in Baden-Baden November 04, 2009 Hammond B3: Markus Lauer "Funky B" Guitar: Carsten Egger "Shuffle King Car" Drums: Jörg Mattern "Shuffle King Matt" | ["Singing", "Funk", "Music", "Pop music", "Song"] | ["male vocalist", "fast tempo", "piano accompaniment", "slightly off key vocals", "swing", "jazz", "galloping beat", "steady drumming", "rhythmic acoustic guitar", "mediocre audio recording", "heavy reverb", "funky bass line", "enthusiastic", "simple melody", "groovy"] | 7 | VHYxygh1STA | 2987 |
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;