musiccaps_details (view)
3 rows where musiccaps_aspects contains "female singer", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "story telling"
This data as json, CSV (advanced)
musiccaps_aspects (array) 55 ✖
- female singer · 3 ✖
- passionate · 3 ✖
- story telling · 3 ✖
- emotional 2
- medium tempo 2
- spirited 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
- heartfelt 1
- hip hop dance music 1
- hip hop music 1
- hissing and buzzing distortions 1
- hissing tones 1
- indian percussions 1
- indian traditional song 1
- inspiring 1
- keyboard accompaniment 1
- keyboard harmony 1
- life is good 1
- life lessons 1
- life’s lessons 1
- life’s truths 1
- live performance 1
- male backup singers 1
- mehandi ceremony 1
- melancholic 1
- modern pop covers 1
- movie soundtrack 1
- odern pop hits 1
- pop song 1
- positive 1
- proverbs 1
- rapping vocals 1
- relaxing playlists 1
- retro dance hits 1
- romantic 1
- slamming door percussion 1
- slow tempo 1
- song cover 1
- stringed instrument accompaniment 1
- strong bass line 1
- suspense 1
- tabla playing steadily 1
- vocal echoes 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
LORDE | Everybody Wants to Rule the World (Lyrics) | A female singer sings this iconic pop cover. The song is slow tempo with a piano accompaniment, strong drum hit and low pitched keyboard harmony. The song is tense and mysterious. The song is a modern pop cover and has poor audio quality with hissing and buzzing tones. | 2013-11-14T05:03:56Z | hrbrocks10 | Song: Everybody Wants to Rule the World : Lorde - Tears For Fears Cover No copyright infringement intended! | ["Music", "Scary music"] | ["bad audio quality", "hissing tones", "female singer", "hissing and buzzing distortions", "emotional", "spirited", "passionate", "inspiring", "life’s lessons", "vocal echoes", "slamming door percussion", "pop song", "song cover", "suspense", "slow tempo", "odern pop hits", "movie soundtrack", "strong bass line", "story telling", "modern pop covers", "keyboard accompaniment"] | 1 | cY3g6N5Sokk | 3716 | |
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;