musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "fast tempo", musiccaps_aspects contains "male vocalist" and musiccaps_aspects contains "steady drumming"
This data as json, CSV (advanced)
musiccaps_aspects (array) 47 ✖
- fast tempo · 3 ✖
- male vocalist · 3 ✖
- steady drumming · 3 ✖
- enthusiastic 2
- jazz 2
- acustic guitar 1
- amateur recording 1
- bass guitar 1
- blues 1
- boomy 1
- boomy bass 1
- chaotic 1
- classic pop 1
- concert 1
- confusing 1
- dissonant strings 1
- electric guitar riff 1
- engaging 1
- female vocal backup 1
- funky bass line 1
- galloping beat 1
- groovy 1
- groovy bass 1
- groovy bass lines 1
- heavy reverb 1
- incoherent music 1
- inferior audio quality 1
- insistent 1
- intense 1
- keyboard accompaniment 1
- keyboard harmony 1
- live performance 1
- lively drumming 1
- mediocre audio recording 1
- muddled sounds 1
- piano accompaniment 1
- recurring vocal riff 1
- rhythmic acoustic guitar 1
- simple melody 1
- slightly off key vocals 1
- superimposed syncopated strings 1
- swing 1
- syncopated music 1
- two tracks playing 1
- ukele 1
- unrelated tracks 1
- youthful 1
musiccaps_names (array) 9 ✖
- Music 3
- Funk 1
- Music of Latin America 1
- Pop music 1
- Rock and roll 1
- Singing 1
- Song 1
- Ukulele 1
- Vibration 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Ukulele Orchestra - Wuthering Heights | A male vocalist sings this melodic jazz/blues. The tempo is medium fast with a piano accompaniment, groovy bass lines, infectious drumming and guitar accompaniment. There is a sound of syncopated ukulele and another string instrument playing over the song. The song is melodic and ambient but the superimposed strings melody is making it chaotic, busy, confusing and confusing. | 2007-02-12T00:31:35Z | daviie | The Ukulele Orchestra - Wuthering Heights | ["Music", "Ukulele"] | ["male vocalist", "fast tempo", "jazz", "blues", "dissonant strings", "groovy bass", "steady drumming", "intense", "keyboard harmony", "lively drumming", "superimposed syncopated strings", "syncopated music", "groovy bass lines", "two tracks playing", "unrelated tracks", "chaotic", "confusing", "ukele", "acustic guitar", "bass guitar", "boomy"] | 7 | KmBaE7ozWow | 2117 | |
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 | |
Ziggy Marley - Positive Vibration ( thx guys! :] ) | A male vocalist sings this energetic song. The tempo is fast with boomy bass lines, steady drumming, keyboard harmony and enthusiastic electric guitar riff with vocal backup. The audio quality is very bad and the song is muffled and muddy. This song is a live performance with ambient sounds of people clapping and cheering. | 2007-06-01T05:36:28Z | FSUSeaAngel | Ziggy Marley in West Palm Beach, FL | ["Vibration", "Music", "Rock and roll", "Music of Latin America"] | ["male vocalist", "fast tempo", "boomy bass", "enthusiastic", "insistent", "recurring vocal riff", "youthful", "engaging", "enthusiastic", "classic pop", "electric guitar riff", "female vocal backup", "steady drumming", "incoherent music", "inferior audio quality", "muddled sounds", "live performance", "concert", "amateur recording", "keyboard accompaniment"] | 7 | kZBFQAQI7Pg | 4328 |
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;