musiccaps_details (view)
2 rows where musiccaps_aspects contains "male singer", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "pop hits"
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- emotional 2
- male singer · 2 ✖
- medium tempo 2
- passionate · 2 ✖
- pop hits · 2 ✖
- african rhythms 1
- backup singers 1
- bad audio quality 1
- christmas 1
- christmas ade nature 1
- christmas carols 1
- christmas classics 1
- christmas time 1
- dance hits 1
- devotional 1
- groovy bass line 1
- groovy dance rhythm 1
- groovy drumming rhythm 1
- guitar rhythm 1
- high pitched singing 1
- hissing noise 1
- inspiring 1
- love song 1
- miracles 1
- motivational 1
- movie soundtrack 1
- orchestra playing 1
- percussive bass line 1
- philharmonic orchestra 1
- piano accompaniment 1
- poor audio quality 1
- poor quality audio 1
- reindeers 1
- romantic 1
- santa claus 1
- snow 1
- soaring vocals 1
- spirited 1
- steady drumming rhythm 1
- string section harmony 1
- various percussion hits 1
- vocal harmony 1
- winter wonderland 1
- xylophone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kwabena Kwabena - Odo Nkoa (Feat. Kofi B) | A male singer sings this passionately with backup singers in vocal harmony. The song is medium tempo with a steady drumming rhythm, various percussion, percussive bass line, guitar rhythm and keyboard harmony . The song is passionate and romantic with a cool dance groove. The song has poor audio quality. | 2011-04-03T16:51:56Z | NaaKwame | Kwabena Kwabena - Odo Nkoa (Feat. Kofi B) Album: Dabi | ["Singing", "Music", "Pop music", "Maraca"] | ["male singer", "backup singers", "african rhythms", "poor audio quality", "guitar rhythm", "xylophone", "vocal harmony", "groovy drumming rhythm", "percussive bass line", "various percussion hits", "medium tempo", "groovy dance rhythm", "pop hits", "dance hits", "love song", "passionate", "emotional", "spirited", "bad audio quality", "high pitched singing", "romantic"] | 1 | IPO79GrOYjg | 1904 | |
The Polar Express- "Believe" | A male singer sings this passionate and emotional melody. The song is medium tempo with a groovy bass line, steady drumming rhythm, piano accompaniment and an emotional string section harmony. The song is inspiring and emotional. The song is a Christmas classic and movie soundtrack. The audio quality is poor with a lot of hissing noises. | 2009-11-16T04:28:03Z | MECFilmProductions | Wow, almost 50,000 views! Thank you everyone! This took two weeks because of Windows Movie Maker, which kept malfunctioning. Then when I upload WMG Copyright kicks in. Ya well it can't beat me;) Anyway here it is in all it's splendor. It didn't turn out as well as I hoped but I have no more patience with it. Enjoy! I do not own anything, movie and music belong to respectful owners! | ["Christian music", "Music"] | ["male singer", "soaring vocals", "hissing noise", "string section harmony", "medium tempo", "movie soundtrack", "christmas", "inspiring", "steady drumming rhythm", "groovy bass line", "piano accompaniment", "orchestra playing", "inspiring", "motivational", "devotional", "christmas time", "winter wonderland", "poor quality audio", "pop hits", "christmas classics", "miracles", "santa claus", "christmas ade nature", "christmas carols", "emotional", "passionate", "reindeers", "snow", "philharmonic orchestra"] | 1 | nZ19mW-TMRk | 4551 |
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;