musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_author = 7, musiccaps_names contains "Pop music" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) >30 ✖
- fast tempo 2
- synthesiser articulation 2
- alternative rock 1
- ambient 1
- classic rock 1
- club music 1
- contemporary pop 1
- dance music 1
- dance pop 1
- digital drumming 1
- electric guitar riff 1
- electro pop 1
- electronic music 1
- emotional 1
- engaging 1
- enthusiastic 1
- female singer 1
- female vocalist 1
- funky bass line 1
- galloping beat 1
- groovy 1
- groovy bass lines 1
- groovy rhythm 1
- heavy reverb 1
- jazz 1
- keyboard arrangement 1
- male vocalist 1
- mediocre audio recording 1
- medium fast tempo 1
- piano accompaniment 1
- …
musiccaps_names (array) 11 ✖
- Music 3
- Pop music · 3 ✖
- Singing · 3 ✖
- Song 2
- /m/05zppz 1
- /t/dd00003 1
- Funk 1
- Heavy metal 1
- Independent music 1
- Progressive rock 1
- Rock music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Gimme More (Britney Spears) - Cover/Male Singing. | A female singer sings soft pop songs. The tempo is medium fast with electronically arranged music, electric guitar harmony, digital drum beats, and melodious vocal backup. The song is simple, soft, emotional, upbeat, catchy, with a dance groove. This song is an Electro Pop song. | 2013-03-03T05:27:25Z | TheMaleBritney | Please Like, Subscribe, Share and Comment :D I Don't Own "Gimme More" Britney Does. Heres the link to buy the original Gimme More: https://itunes.apple.com/au/album/gimme-more-single/id264025647 | ["Singing", "Music", "/m/05zppz", "Pop music", "/t/dd00003"] | ["female singer", "medium fast tempo", "emotional", "contemporary pop", "upbeat", "groovy rhythm", "dance music", "dance pop", "club music", "electro pop", "synth pop", "ambient", "electronic music", "synthesiser articulation", "digital drumming", "keyboard arrangement", "electric guitar riff", "vocal backup"] | 7 | MY0PsDE3xHs | 2279 | |
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 | |
Magenta - King Of The Skies | A female vocalist sings this spirited song. The tempo is fast with enthusiastic electric guitar harmony, slick drumming, groovy bass lines and synthesiser arrangements. The song is energetic, youthful, fun, pulsating, engaging and emphatic. This song is Alternative Rock. | 2006-06-21T17:59:15Z | chrismagenta | Track from Magenta's The Gathering DVD. Amazing Welsh Progressive Rock band in the vain of Genesis, Yes and Renaissance. | ["Singing", "Heavy metal", "Music", "Independent music", "Pop music", "Rock music", "Song", "Progressive rock"] | ["female vocalist", "fast tempo", "vibrant electric guitars", "progressive rock", "symphonic rock", "alternative rock", "slick drumming", "synthesiser articulation", "vivacious", "youthful", "vibrant", "groovy bass lines", "engaging", "powerful", "rock", "classic rock", "soft rock"] | 7 | pp6eSGANq0Y | 4737 |
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;