musiccaps_details (view)
12 rows where musiccaps_aspects contains "female singer", musiccaps_aspects contains "poor audio quality" and musiccaps_aspects contains "romantic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 140 ✖
- female singer · 12 ✖
- poor audio quality · 12 ✖
- romantic · 12 ✖
- emotional 8
- passionate 8
- medium tempo 6
- steady drumming rhythm 5
- groovy bass line 4
- love song 4
- guitar accompaniment 3
- keyboard accompaniment 3
- live performance 3
- madly in love 3
- vocal harmony 3
- amateur singing 2
- bad audio quality 2
- cheerful 2
- dance rhythm 2
- groovy music 2
- groovy rhythm 2
- home video 2
- inspiring 2
- lilting vocals 2
- male singer 2
- medium fast tempo 2
- motivational 2
- retro pop hits 2
- soul music 2
- strong bass line 2
- vocal duet 2
- acapella 1
- acoustic guitar strumming 1
- acoustic love song 1
- adorable 1
- adoration 1
- adventurous 1
- ambient crowd noise 1
- ambient room noises 1
- arabic dance music sultry vocals 1
- arabic dance song 1
- arabic music 1
- arabic percussion 1
- arabic percussions 1
- arabic pop song 1
- arabic singer 1
- backup singers 1
- belly dancing music 1
- black gospel influences 1
- blues music 1
- blues turnaround 1
- cameras clicking 1
- child tv stars 1
- children singing 1
- classic hits 1
- club 1
- country hits 1
- crowds clapping 1
- crowds whistling 1
- cymbals crashing 1
- dance tunes 1
- dealing with depression 1
- dholak percussions 1
- distorted audio quality 1
- distorted harmony 1
- distorted vocals 1
- diva 1
- drum rolls 1
- emotional al 1
- encouraging crowd 1
- energetic 1
- euro pop hits 1
- exciting 1
- feel good 1
- female backup singers 1
- fret noise 1
- funk music 1
- funky groove 1
- groovy bas line 1
- guitar bass line 1
- guitar notes playing 1
- guitar playing 1
- guitar strumming 1
- heartfelt 1
- hissing ambient sound 1
- hissing noise 1
- inspirational love song 1
- jazz music 1
- keybiard accompaniment 1
- keybiard harmony 1
- life lessons 1
- live audience 1
- loneliness 1
- love songs 1
- loving 1
- lyrical singing 1
- male backup singers 1
- melancholic 1
- missing you 1
- music concert 1
- no percussion instruments 1
- percussive bass line 1
- piano accompaniment 1
- pop cover 1
- pop diva 1
- pop song 1
- pop songs 1
- pop super hits 1
- r&b music influences 1
- retro pop 1
- retro pop song 1
- retro super hits 1
- retro tv show tunes 1
- russian pop star 1
- sad song 1
- say sorry 1
- singer talking 1
- slow tempo 1
- song cover 1
- song covers 1
- song introduction 1
- sonic effects 1
- soul singer 1
- soulful singer 1
- soulful singing 1
- spirited 1
- string bass 1
- string bass line 1
- string section 1
- string section harmony 1
- strong bass drum hits 1
- subtle bass line 1
- tambourine percussion 1
- tambourine percussions 1
- timeless hits 1
- together forever 1
- traditional music influences 1
- tv show tune 1
- vocal crooning 1
- vocal vibrato 1
- with you forever 1
musiccaps_names (array) 24 ✖
- Music 12
- Singing 3
- /t/dd00004 2
- Pop music 2
- /t/dd00003 1
- Afrobeat 1
- Applause 1
- Bell 1
- Crackle 1
- Flamenco 1
- Folk music 1
- Funk 1
- Grunge 1
- Humming 1
- Independent music 1
- Inside, large room or hall 1
- Middle Eastern music 1
- Music of Africa 1
- Music of Asia 1
- Music of Latin America 1
- Reggae 1
- Sad music 1
- Soul music 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Raven-Symone Singing On "Hangin With Mr. Cooper" | A male and female child singers sing this vocal duet in harmony. The song is medium tempo with keyboard accompaniment , groovy bass line and an enthusiastic drumming rhythm. The song is passionate and loving. The song is a retro tv show tune and in poor audio quality. | 2010-02-27T15:22:24Z | JaMuzik2 | Raven's character, Nicole, singing "With You" by Tony Terry with Tyler (played by Marquise Wilson). | ["Music", "/t/dd00003", "/t/dd00004"] | ["male singer", "female singer", "child tv stars", "vocal duet", "vocal harmony", "poor audio quality", "keybiard harmony", "amateur singing", "emotional al", "medium tempo", "r&b music influences", "tv show tune", "inspirational love song", "romantic", "adorable", "steady drumming rhythm", "groovy bass line", "retro tv show tunes", "children singing"] | 1 | 0vFPs6XsU_Q | 222 | |
Alizee - Sound Of Silence, Moscow, 18-05-2008 | A female singer sings this live cover version of a famous song. The song is medium tempo with guitar accompaniment, crowds cheering and whistling and cameras clicking. The song has a poor audio quality and has a lot of ambient crowd noises, | 2008-05-24T21:54:38Z | mazarakis | Alizee - Sound Of Silence, Moscow, 18-05-2008 thanks to Didevil, ikm, pavel zubarev links to big files is here http://alizeeforum.fastbb.ru/?1-0-0-00001519-000-0-0#028 http://alizeeforum.fastbb.ru/?1-0-0-00001519-000-0-0#029.001 | ["Applause", "Music", "Crackle"] | ["female singer", "live performance", "song cover", "romantic", "loneliness", "dealing with depression", "crowds whistling", "crowds clapping", "poor audio quality", "song cover", "guitar accompaniment", "encouraging crowd", "emotional", "spirited", "passionate", "inspiring", "motivational", "amateur singing", "strong bass line", "home video", "music concert", "cameras clicking"] | 1 | 69oU6LfyQ_4 | 731 | |
Rif Music 2018 | A female singer sings this sultry vocals. The song is medium tempo with traditional Arabic percussions playing steadily, tambourine percussion, keyboard accompaniment and a strong bass-line. The song is romantic and passionate. The audio quality is poor. | 2010-04-16T23:11:47Z | Moha Dulce Rifeño | www.Rifmelody.com | ["Folk music", "Music"] | ["female singer", "arabic music", "medium tempo", "poor audio quality", "groovy music", "arabic dance music sultry vocals", "tambourine percussion", "keyboard accompaniment", "steady drumming rhythm", "dholak percussions", "arabic percussion", "passionate", "romantic", "love songs", "dance tunes"] | 1 | 7dmT4SgS_EM | 869 | |
Adele North American Tour 2008 | A female singer sings this bluesy melody. The song is medium tempo with minimal guitar accompaniment and no other instrumentation. The song's medium tempo is very emotional and passionate. The song is a modern pop hit but with poor audio quality. | 2011-03-17T20:16:50Z | Viswijfable | This shortfilm was on the bonus disc. of 19. Directed by Charlie Robins © | ["Singing", "Music", "/t/dd00004", "Inside, large room or hall"] | ["female singer", "blues music", "live audience", "romantic", "hissing ambient sound", "madly in love", "love song", "passionate", "ambient crowd noise", "guitar playing", "singer talking", "song introduction", "blues turnaround", "fret noise", "pop song", "pop super hits", "pop diva", "poor audio quality", "guitar notes playing", "live performance", "lilting vocals", "soul singer", "soul music"] | 1 | B90BOtSOD2Q | 1210 | |
Zwan - Lyric (Video Version) | A male and female singer sing this vocal duet. The song is medium fast tempo with a guitar accompaniment, steady drumming rhythm with exciting drum rolls, cymbals crashes and a percussive bass line. The song is romantic and exciting. The song is retro pop with a bad audio quality. | 2009-10-27T01:54:19Z | Warner Records Vault | © 2005 WMG Lyric (Video Version) | ["Music", "Independent music", "Pop music", "Grunge"] | ["male singer", "female singer", "guitar accompaniment", "keyboard accompaniment", "vocal duet", "retro pop hits", "medium fast tempo", "poor audio quality", "groovy rhythm", "steady drumming rhythm", "percussive bass line", "keyboard accompaniment", "drum rolls", "cymbals crashing", "romantic", "exciting", "emotional", "adventurous", "passionate", "retro pop hits"] | 1 | CwmUMySSNQc | 1417 | |
When I Loved You (interlude)/original (a YT feature) READ INFO BOX! | A female singer sings this soulful melody. The song is slow tempo with a guitar playing a subtle bass line and no other instrumentation. The song is romantic and emotional. The song is soul music with jazz and black gospel influences. The audio quality is poor as it is recorded casually at home. | 2007-07-22T20:00:02Z | mishalmooremusic | THANK YOU ALL FOR SHOWING ME LOVE!!!! You can follow me if you'd like: http://www.twitter.com/mishalmoore My single "Oh Lord" is available at: http://www.itunes.com/mishalmoore and/or any other major music site! Be sure to rate/review if you're purchasing from Itunes!! :) Myspace: http://myspace.com/mishalmmoore WARNING: All rights reserved. © 2007 Mishal Moore Cocobread Entertaiment LLC http://twitter.com/mishalmoore http://myspace.com/mishalmmoore | ["Humming", "Music"] | ["female singer", "soulful singing", "guitar bass line", "slow tempo", "home video", "ambient room noises", "poor audio quality", "jazz music", "no percussion instruments", "subtle bass line", "emotional", "romantic", "love song", "vocal vibrato", "soul music", "black gospel influences", "guitar accompaniment", "passionate", "madly in love", "together forever"] | 1 | KjMRf4egAyA | 2112 | |
OPM Love Songs Medley by Kai Brosas | A female singer sings this beautiful melody. The tempo is medium with a piano or keyboard accompaniment and no other instrumentation. The song is emotional and passionate like a love song. The audio quality is very poor with a lot of hissing noise and distortion. | 2010-10-25T09:07:45Z | chelrada713 | ["Singing", "Bell", "Music"] | ["female singer", "poor audio quality", "hissing noise", "distorted vocals", "pop songs", "pop cover", "song covers", "piano accompaniment", "acoustic love song", "live performance", "club", "romantic", "emotional", "sad song", "passionate", "melancholic", "with you forever", "missing you", "passionate", "bad audio quality", "medium tempo"] | 1 | N8Fg3L1Cc5E | 2323 | ||
FUNK!! Starr-Shes So Fine | A male singer sings this groovy melody. The tempo is medium with a strong bass line, steady drumming, keyboard playing a countermelody and various percussion hits. The song is funk pop in nature. The song has poor audio quality. | 2010-06-18T18:51:57Z | turtle101392 | Starr-Shes so Fine | ["Funk", "Music"] | ["female singer", "bad audio quality", "romantic", "emotional", "dance rhythm", "retro pop", "distorted audio quality", "poor audio quality", "distorted harmony", "keyboard accompaniment", "steady drumming rhythm", "strong bass drum hits", "groovy music", "energetic", "funky groove", "funk music", "groovy bass line"] | 1 | NZn4-gP2GiI | 2347 | |
Sylwia Grzeszczak - Flirt [Official Music Video] | A female singer sings this emotional melody. The song is medium tempo with guitar strumming rhythm, strong bass line, steady drumming rhythm, keyboard accompaniment and sound effects. The song is emotional and romantic. The song is a euro pop love song and has poor audio quality. | 2013-04-16T09:57:50Z | SylwiaGrzeszczak | ✅ Subskrybuj: https://bit.ly/WMP_YT ✅ Instagram https://instagram.com/warnermusicpoland ✅ Facebook: https://fb.com/warnermusicpoland ✅ TikTok: https://www.tiktok.com/@warnermusicpoland Music video by Sylwia Grzeszczak performing Flirt. (P) 2013 The copyright in this audiovisual recording is owned by Gorgo under exclusive licence to EMI Music Poland Sp. z.o.o. | ["Music", "Tender music"] | ["female singer", "russian pop star", "medium tempo", "groovy bass line", "emotional", "passionate", "madly in love", "say sorry", "poor audio quality", "guitar strumming", "groovy bas line", "sonic effects", "keybiard accompaniment", "steady drumming rhythm", "romantic", "love song", "euro pop hits"] | 1 | ORikRIu7s1o | 2440 | |
yongseo arab fan- (عالبال (سميرة سعيد | A female Arabic singer sings this beautiful melody with backup singers in vocal harmony. The song is medium tempo with a string section, Arabic percussion instruments, tambourine percussion, steady drum rhythm, groovy bass line and keyboard accompaniment. The song is romantic and celebratory in nature. The audio quality is very poor. | 2011-09-20T18:50:38Z | yasmin ali | ["Afrobeat", "Music of Africa", "Music of Asia", "Music", "Pop music", "Reggae", "Middle Eastern music", "Music of Latin America", "Soul music"] | ["female singer", "arabic singer", "arabic pop song", "lyrical singing", "poor audio quality", "medium fast tempo", "backup singers", "vocal harmony", "string section", "arabic percussions", "groovy bass line", "arabic dance song", "arabic pop song", "lyrical singing", "traditional music influences", "belly dancing music", "groovy rhythm", "cheerful", "romantic", "love song", "adoration", "tambourine percussions"] | 1 | aOGNUGgTQ8k | 3534 | ||
Anne Murray: You've Got A Friend | A female singer sings this beautiful melody. The tempo is medium with a string section harmony and a strong bass line. The audio quality is poor. The song is a retro pop hit with inspiring and romantic vibes. | 2009-03-30T09:21:45Z | happysun | ["Music", "Sad music"] | ["female singer", "lilting vocals", "strong bass line", "poor audio quality", "country hits", "diva", "timeless hits", "classic hits", "emotional", "romantic", "life lessons", "inspiring", "motivational", "loving", "romantic", "medium tempo", "retro pop hits", "diva", "string section harmony", "medium tempo"] | 1 | oNryELagQUM | 4623 | ||
Joan Armatrading - Love And Affection 1976 | A female singer sings this beautiful melody with male and female backup singers in vocal harmony. The song is medium tempo with an acoustic guitar playing rhythm and strong string bass line with no percussion instrumentation. The song is emotional and heartfelt. The song has acapella influences and is soulful. The song is of poor audio recording quality. | 2010-03-19T15:03:53Z | fritz51329 | Joan Armatrading - Love And Affection 1976 I am not in love But I'm open to persuasion East or West Where's the best For romancing With a friend I can smile But with a lover I could hold my head back I could really laugh Really laugh Thank you You took me dancing 'Cross the floor Cheek to cheek But with a lover I could really move Really move I could really dance Really dance Really dance Really dance I could really move Really move Really move Really move Now if I can feel the sun In my eyes And the rain on my face Why can't I Feel love I can really love Really love Really love Really love Really love Love love love love Love love love love Now I got all The friends that I want I may need more But I shall just stick to those That I have got With friends I still feel So insecure Little darling I believe you could Help me a lot Just take my hand And lead me where you will No conversation No wave goodnight Just make love With affection Sing me another love song But this time With a little dedication Sing it, sing it You know that's what I like Once more with feeling Give me love Give me love Give me love Love (Instrumental) Make love with affection Sing me another love song But this time With a little dedication Sing it, sing it You know that's what I like With affection Sing me another love song But this time With a little dedication Sing it, sing it You know that's what I like With affection With a little dedication Once more with feeling You know that's what I like | ["Singing", "Flamenco", "Music"] | ["female singer", "soulful singer", "poor audio quality", "male backup singers", "string bass line", "acoustic guitar strumming", "vocal harmony", "female backup singers", "retro pop song", "cheerful", "emotional", "retro super hits", "dance rhythm", "medium tempo", "string bass", "acapella", "passionate", "romantic", "heartfelt", "feel good", "vocal crooning"] | 1 | oag3I4VRXyM | 4645 |
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;