musiccaps_details (view)
3 rows where musiccaps_aspects contains "female singer", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "story telling"
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- female singer · 3 ✖
- medium tempo · 3 ✖
- story telling · 3 ✖
- emotional 2
- passionate 2
- romantic 2
- backup female singers 1
- bad audio quality 1
- bridal send off song 1
- bridal song 1
- cheerful 1
- classical ghazals 1
- devotional music 1
- energetic 1
- ghazal 1
- groovy bass line 1
- groovy music 1
- guitar accompaniment 1
- heartfelt 1
- hip hop dance music 1
- hip hop music 1
- indian percussions 1
- indian traditional song 1
- inspiring 1
- keyboard harmony 1
- life is good 1
- life lessons 1
- life’s truths 1
- live performance 1
- male backup singers 1
- mehandi ceremony 1
- melancholic 1
- motivational 1
- nostalgia 1
- old classics 1
- piano accompaniment 1
- pop song 1
- positive 1
- proverbs 1
- rapping vocals 1
- relaxing playlists 1
- retro dance hits 1
- retro hits 1
- spirited 1
- string section harmony 1
- stringed instrument accompaniment 1
- strong bass line 1
- tabla playing steadily 1
- vibrato 1
- vocal harmony 1
- wedding song 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
A time for us ~ lyrics ***there is a mistake with the name of singer. This is not Loreena*** | A female singer sings this lilting melody. The song is medium tempo with an acoustic guitar accompaniment, strong bass line, steady rhythm and piano accompaniment. The song has a bad audio quality. The song is emotional and nostalgic in nature. | 2010-08-25T18:09:52Z | CathCthrn | (Love Theme from Romeo and Juliet) (Words by Larry Kusik, Eddie Snyder / Music by Nino Rota) Lyrics A time for us, some day there'll be When chains are torn by courage born of a love that's free A time when dreams so long denied can flourish As we unveil the love we now must hide A time for us, at last to see A life worthwhile for you and me And with our love, through tears and thorns We will endure as we pass surely through every storm A time for us, some day there'll be a new world A world of shining hope for you and me A time for us, at last to see A life worthwhile for you and me And with our love, through tears and thorns We will endure as we pass surely through every storm A time for us, some day there'll be a new world A world of shining hope for you and me | ["Music", "Tender music"] | ["female singer", "bad audio quality", "medium tempo", "strong bass line", "guitar accompaniment", "pop song", "vibrato", "piano accompaniment", "string section harmony", "old classics", "retro hits", "story telling", "inspiring", "motivational", "emotional", "romantic", "nostalgia"] | 1 | 5Tq56BN8PCQ | 661 | |
J. Cole - Too Deep For The Intro | Friday Night Lights | A female singer sings this cool melody with male backup singer in harmony. The song is medium tempo with a groovy bass line, steady drumming rhythm, keyboard harmony and other percussion hits. The song is groovy with a story telling nature. The song is a retro hip hop dance hit. | 2010-11-12T23:44:00Z | Archive | J. Cole - Too Deep For The Intro J. Cole - Too Deep For The Intro J. Cole - Too Deep For The Intro http://coastingonadream.tumblr.com/ | ["Music", "Rhythm and blues"] | ["female singer", "male backup singers", "hip hop music", "retro dance hits", "keyboard harmony", "groovy bass line", "rapping vocals", "story telling", "romantic", "groovy music", "energetic", "spirited", "passionate", "life lessons", "melancholic", "cheerful", "life is good", "relaxing playlists", "hip hop dance music", "medium tempo"] | 1 | UfEGX0rNOvA | 2932 | |
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;