musiccaps_details (view)
5 rows where musiccaps_aspects contains "female singer", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "vocal harmony"
This data as json, CSV (advanced)
musiccaps_aspects (array) 85 ✖
- female singer · 5 ✖
- passionate · 5 ✖
- vocal harmony · 5 ✖
- emotional 3
- backup singers 2
- dance rhythm 2
- female backup singers 2
- heartfelt 2
- medium tempo 2
- poor audio quality 2
- retro pop song 2
- romantic 2
- acapella 1
- acoustic guitar strumming 1
- backup female singers 1
- bad audio quality 1
- bridal send off song 1
- bridal song 1
- careless nights 1
- cheerful 1
- cheerful courtship song 1
- classical ghazals 1
- cymbals crashing 1
- dance with you 1
- devotional music 1
- disco music 1
- disco romance hits 1
- dj 1
- doo-wop hits 1
- electronic dance music 1
- enthusiastic 1
- exciting 1
- falsetto 1
- fast percussion rhyme 1
- fast tempo 1
- feel good 1
- feeling good 1
- ghazal 1
- groovy 1
- groovy bass line 1
- groovy drumming rhythm 1
- groovy guitar rhythm 1
- guitar rhythm 1
- ibiza nights 1
- indian percussions 1
- indian traditional song 1
- keybiard harmony 1
- keyboard accompaniment 1
- life’s truths 1
- live performance 1
- love song 1
- male backup singers 1
- marry me 1
- mehandi ceremony 1
- memdium tempo 1
- party night 1
- percussive bass line 1
- percussive hits 1
- piano accompaniment 1
- positive 1
- proverbs 1
- retro dance hits 1
- retro hits 1
- retro pop hits 1
- retro pop super hits 1
- retro super hits 1
- sexy 1
- slowing down 1
- song retarding 1
- soulful singer 1
- steady drumming 1
- story telling 1
- string bass 1
- string bass line 1
- stringed instrument accompaniment 1
- strong bass line 1
- sundowner 1
- tabla playing steadily 1
- tambourine percussions 1
- techno dance music 1
- together forever 1
- tropical beach party 1
- vocal crooning 1
- wedding song 1
- woo her 1
musiccaps_names (array) 11 ✖
- Music 4
- Disco 2
- Flamenco 1
- Folk music 1
- Funk 1
- Middle Eastern music 1
- Music of Bollywood 1
- Pop music 1
- Singing 1
- Soul music 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DJ Snake & AlunaGeorge - You Know You Like It (T-Mass & Arman Cekin Remix) | A female singer sings this cool melody with backup singers in vocal harmony. The song is fast tempo with a percussive bass line, steady drumming with various percussion hits, keyboard harmony and other sonic effects. The song is groovy and exciting. The song is a modern techno dance hit. | 2015-05-09T16:08:18Z | Trap City | PREMIERE: DJ Snake & AlunaGeorge - You Know You Like It (T-Mass & Arman Cekin Remix) Subscribe here: http://trapcity.tv/subscribe Free Download: http://trapcity.tv/uvjbX ➥ Become a fan of Trap City: http://trapcity.tv/soundcloud http://trapcity.tv/facebook http://trapcity.tv/twitter http://trapcity.tv/instagram http://trapcity.tv/vine http://trapcity.tv/plugdj http://www.trapcity.net ➥ Follow T-Mass: http://www.soundcloud.com/t-mass http://www.facebook.com/tmassofficial http://www.twitter.com/tmassofficial http://www.instagram.com/tmassofficial ➥ Follow Arman Cekin: http://www.soundcloud.com/armancekin http://www.facebook.com/arman.cekin http://www.twitter.com/cekinarman http://www.instagram.com/armancekin | ["Disco"] | ["female singer", "backup singers", "vocal harmony", "techno dance music", "electronic dance music", "percussive bass line", "percussive hits", "keyboard accompaniment", "exciting", "dj", "party night", "dance with you", "careless nights", "exciting", "enthusiastic", "groovy", "passionate", "romantic", "ibiza nights", "tropical beach party", "sundowner", "fast percussion rhyme", "fast tempo"] | 1 | B2yLFcmZ51I | 1197 | |
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 | |
Salt N Pepa Twist and Shout yrics | A female singer sings this cool melody with backup singers in vocal harmony. The song is medium tempo with a groovy bass line and guitar rhythm, steady drums g rhythm and keyboard harmony. The song is catchy and has a dance groove. The song is a retro dance hit. The song has a poor audio quality issue. | 2013-06-01T16:22:35Z | katcat654 | ["Disco", "Funk", "Music", "Pop music"] | ["retro pop hits", "doo-wop hits", "female singer", "memdium tempo", "female backup singers", "vocal harmony", "groovy guitar rhythm", "strong bass line", "keybiard harmony", "groovy drumming rhythm", "dance rhythm", "passionate", "cheerful courtship song", "woo her", "sexy", "feeling good", "retro pop super hits", "retro dance hits", "poor audio quality"] | 1 | kQw2NQ_eqyg | 4315 | ||
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 | |
Mehandi Ni Mehandi | Geet Shagna De | Punjabi Marriage Ceremony Songs | Popular Wedding Music | A female singer sings this beautiful wedding song for the bride. The song is a medium tempo with traditional Indian instruments like the tabla playing percussion and stringed instruments playing rhythm. The song is heartfelt and emotional. The song is a mehendi ceremony song or a bridal preparation song for her wedding, | 2012-03-18T15:20:43Z | Catrack Entertainment | Mehndi Ni Mehndi, Mehndi Ni Mehndi, Mehndi Ni Mehndi, Mehndi Ni Mehndi Aaj Ralke Laawan Aayo Ni Bhaina Te Bharjaiyan Mehndi Ni Mehndi, Mehndi Ni Mehndi, Mehndi Ni Mehndi, Mehndi Ni Mehndi Ambi Da Buta Vehde Laaye Maali Gairan Di Jholi Paye Tenu Aap Sajawan Aaiyan Ni Bhaina Te Bharjaiyan Mehndi Ni Mehndi, Mehndi Ni Mehndi, Mehndi Ni Mehndi, Mehndi Ni Mehndi Beh Gaiyan Sakhiyan Chaar Chuphere Rondiyan Akhiyan Hasde Chehre Rang Ratda Lawan Aaiyan Ni Bhaina Te Bharjaiyan Mehndi Ni Mehndi, Mehndi Ni Mehndi, Mehndi Ni Mehndi, Mehndi Ni Mehndi Bhuan Te Chachiyan Taiyan Aaiyan Lakh Duawan Te Den Vadhaiyan Tere Shagan Manawan Aaiyan Ni Bhaina Te Bharjaiyan Mehndi Ni Mehndi, Mehndi Ni Mehndi, Mehndi Ni Mehndi, Mehndi Ni Mehndi This Song/Boliyan represents the Rich Punjabi Culture and Music and is Part of Rituals in every Traditional Punjabi Wedding Ceremony whether it takes place in a Village of Punjab (India) or Anywhere in the World. These Folk / Marriage Songs are integral part of Punjabi Culture and have various forms of Song & Dance like Tappe, Bolian, Gidha, Bhangra and Sithniyan. These are also called Shagna De Geet. All Punjabi Songs / Punjabi Music By Catrack is Available On I-Tunes, Spotify, Rhapsody, Nokia, emusic, Google Music, Amazon & Sound Cloud. Subscribe to Catrack's Youtube Channel http://www.youtube.com/subscription_center?add_user=catrackentertainment Join Us On Facebook http://www.facebook.com/CatrackOfficial Twitter https://twitter.com/catrack Google+ https://plus.google.com/112539272523400923462/ For Any Content, Advertising, or Marketing Related Queries for All our Platforms, including Heeroz OTT, Kindly Visit: http://www.catrack.com | ["Folk music", "Music", "Wedding music", "Middle Eastern music", "Music of Bollywood"] | ["female singer", "backup female singers", "bridal send off song", "mehandi ceremony", "vocal harmony", "medium tempo", "proverbs", "tabla playing steadily", "stringed instrument accompaniment", "passionate", "emotional", "positive", "classical ghazals", "live performance", "heartfelt", "devotional music", "story telling", "life’s truths", "wedding song", "bridal song", "indian traditional song", "indian percussions", "ghazal"] | 1 | uHgpDP_4Lsc | 5105 |
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;