musiccaps_details (view)
3 rows where musiccaps_aspects contains "piano accompaniment" and musiccaps_names contains "Funk" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- piano accompaniment · 3 ✖
- groovy bass line 2
- male singer 2
- animals 1
- animated singing 1
- animated video 1
- bop tune 1
- brush drumming rhythm 1
- cheerful 1
- children dancing 1
- children’s song 1
- dance music 1
- dance rhythm 1
- dj 1
- double bass harmony 1
- educational material 1
- enthusiastic 1
- fast tempo 1
- female backup singer 1
- fun learning 1
- funky bass line 1
- galloping beat 1
- groovy 1
- groovy music 1
- heavy reverb 1
- jazz 1
- jazz dance music 1
- jazz music 1
- learning 1
- love performance 1
- male vocalist 1
- mediocre audio recording 1
- medium tempo 1
- nursery rhymes 1
- people dancing 1
- poor audio quality 1
- positive 1
- preschool teaching 1
- rhythmic acoustic guitar 1
- schools 1
- simple melody 1
- slightly off key vocals 1
- spirited 1
- steady drum rhythm 1
- steady drumming 1
- steady drumming rhythm 1
- swing 1
- toddlers 1
- trumpet playing percussively 1
- vocal harmony 1
- zoo 1
musiccaps_names (array) 10 ✖
- Funk · 3 ✖
- Music 3
- Exciting music 1
- Pop music 1
- Reggae 1
- Rock and roll 1
- Singing 1
- Ska 1
- Song 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 |
---|---|---|---|---|---|---|---|---|---|---|
Animals | Zoo | Kids | Music | Preschool | Silly Bus | A male singer sings this animated melody . The song is medium tempo with a groovy bass , keyboard accompaniment and steady drumming rhythm. The song is cheerful and animated and designed as educational material for little children. | 2011-09-11T22:29:16Z | Silly Bus | Silly Bus is proud to release our At The Zoo song and video. | ["Funk", "Music", "Exciting music"] | ["medium tempo", "male singer", "groovy bass line", "preschool teaching", "educational material", "learning", "schools", "toddlers", "positive", "cheerful", "spirited", "fun learning", "children dancing", "animated video", "nursery rhymes", "zoo", "animals", "steady drumming rhythm", "piano accompaniment", "children’s song", "animated singing"] | 1 | hhohfEC82JI | 4130 | |
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 | |
Groovy Live Musik : "We no speak americano" by 4 to the bar : jazzy swing and lounge music | A male singer sings this groovy bop tune. The song is medium tempo with a groovy double bass playing, piano accompaniment, trumpet playing percussively and brush drumming rhythm. The song is entertaining and exciting. The song is a jazz dance tune with an electronica twist. | 2011-02-01T14:48:22Z | loungemusicband | http://4tothebar.de : More groovy lounge music, swing sounds and jazzy live music for club, event and party. Lounge Music: Die Live Band 4 to the bar spielt Swing, Samba und Jazz mit Drums, Kontrabass, Piano und Sängerin und Deejay | ["Swing music", "Funk", "Music", "Reggae", "Ska", "Rock and roll"] | ["groovy music", "love performance", "dj", "dance music", "brush drumming rhythm", "groovy bass line", "steady drum rhythm", "piano accompaniment", "trumpet playing percussively", "male singer", "female backup singer", "vocal harmony", "bop tune", "double bass harmony", "jazz music", "jazz dance music", "poor audio quality", "people dancing", "dance rhythm"] | 1 | RtgHU1UMo5o | 2729 |
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;