musiccaps_details (view)
5 rows where musiccaps_aspects contains "backup singers" and musiccaps_aspects contains "bad audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 75 ✖
- backup singers · 5 ✖
- bad audio quality · 5 ✖
- male singer 4
- medium tempo 4
- vocal harmony 4
- love song 3
- passionate 3
- percussive bass line 3
- emotional 2
- guitar rhythm 2
- guitar strumming 2
- retro hits 2
- romantic 2
- steady drumming 2
- tambourine percussions 2
- african rhythms 1
- autoharp accompaniment 1
- christian contemporary music 1
- church service 1
- classic county hits 1
- congregational music 1
- country classics 1
- country guitar band 1
- country music 1
- country singer 1
- country super hits 1
- crooning vocals 1
- cymbals crashing 1
- dance hits 1
- disco music 1
- disco romance hits 1
- energetic 1
- enthusiastic 1
- euro pop 1
- everlasting hits 1
- exciting 1
- falsetto 1
- female singer 1
- gospel band 1
- groovy bass line 1
- groovy dance rhythm 1
- groovy drumming rhythm 1
- groovy rhythm 1
- guitar leads 1
- high pitched singing 1
- hymns 1
- keyboard accompaniment 1
- madly in love 1
- marry me 1
- meditational 1
- modern country love songs 1
- nostalgia 1
- old memories 1
- organ accompaniment 1
- piano acc 1
- piano accompaniment 1
- pleasant 1
- poor audio quality 1
- pop hits 1
- pop super hits 1
- praise and worship 1
- prayers 1
- rejoicing 1
- retro pop song 1
- slowing down 1
- song cover 1
- song retarding 1
- spirited 1
- steady drumming rhythm 1
- story telling 1
- together forever 1
- various percussion hits 1
- walking bas s line 1
- walking bass line 1
- xylophone 1
musiccaps_names (array) 10 ✖
- Music 5
- Christian music 2
- Exciting music 1
- Gospel music 1
- Happy music 1
- Maraca 1
- Musical instrument 1
- Pop music 1
- Singing 1
- Soul music 1
youtube_published (date) 5 ✖
- 2006-12-19 1
- 2007-10-06 1
- 2009-03-23 1
- 2009-04-16 1
- 2011-04-03 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Aleksander Mežek - Siva pot | A male singer sings this popular country hit with backup singers in vocal harmony. The song is in medium tempo with a walking bass , acoustic guitar strumming rhythmically, autoharp accompaniment and steady drumming rhythm. The song is an emotional and nostalgic country hit. The audio quality is poor. | 2006-12-19T14:33:29Z | jaki386 | Aleksander Mežek - Siva pot | ["Christian music", "Music", "Musical instrument"] | ["male singer", "backup singers", "guitar strumming", "everlasting hits", "euro pop", "medium tempo", "walking bass line", "autoharp accompaniment", "walking bas s line", "steady drumming", "story telling", "nostalgia", "pleasant", "exciting", "enthusiastic", "old memories", "classic county hits", "pop super hits", "retro hits", "groovy rhythm", "country classics", "bad audio quality", "song cover", "country music"] | 1 | 3KQy3Cajo4E | 456 | |
'Kiss a Girl Sessions' Video Keith Urban AOL Music | A male country singer sings this passionate melody with backup singers in vocal harmony. The song is medium tempo with a strong drumming rhythm, guitar accompaniment, guitar lead, percussive bass line and percussion hits. The song is passionate and romantic. The song has bad audio quality. | 2009-04-16T00:03:13Z | Nick Czapiewski | http://nickwinch.blogspot.com/ Keith Urban singing Kiss a Girl on AOL music. Make sure you pick up "Defying Gravity" in stores and online now!! ***NO INFRINGEMENT INTENDED*** just spreading the good news of Keith Urban | ["Music", "Happy music", "Exciting music"] | ["male singer", "country singer", "backup singers", "vocal harmony", "crooning vocals", "medium tempo", "guitar leads", "guitar strumming", "percussive bass line", "keyboard accompaniment", "energetic", "passionate", "love song", "romantic", "country guitar band", "modern country love songs", "country super hits", "madly in love", "bad audio quality"] | 1 | 9uToez74x_M | 1048 | |
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 | |
PACHUCO ROLAS VOL 1 | A female singer sings this passionate melody with backup singers in vocal harmony. The tempo is medium and gradually slows down towards the end. The drumming rhythm is steady and retards to the end with a percussive bass line and keyboard accompaniment. The song is a retro disco or R&B love song. The song has poor audio quality. | 2009-03-23T07:20:30Z | pachucojae | PACHUCO MEMORIES.... | ["Music", "Soul music"] | ["female singer", "disco music", "song retarding", "bad audio quality", "slowing down", "backup singers", "falsetto", "vocal harmony", "steady drumming", "groovy bass line", "piano accompaniment", "guitar rhythm", "tambourine percussions", "cymbals crashing", "retro pop song", "retro hits", "emotional", "love song", "passionate", "together forever", "disco romance hits", "marry me"] | 1 | iS-iTbHndw8 | 4185 | |
Gospel Music - Because He Lives!! | A male singer leads backup singers into a gospel song in vocal harmony. The tempo is medium with a groovy bass line , organ accompaniment, tambourine percussion, guitar strumming and keyboard accompaniment. The song is prayerful and spirited. The song has bad audio quality. | 2007-10-06T00:34:24Z | Leah274 | Im not sure who is actually singing, i know the original guy is in the start then its another guy, i like this version. | ["Gospel music", "Christian music", "Music"] | ["male singer", "backup singers", "vocal harmony", "medium tempo", "percussive bass line", "tambourine percussions", "christian contemporary music", "praise and worship", "meditational", "congregational music", "hymns", "prayers", "rejoicing", "bad audio quality", "organ accompaniment", "gospel band", "church service", "steady drumming rhythm", "piano acc"] | 1 | wPmTJWybq_E | 5263 |
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;