musiccaps_details (view)
8 rows where musiccaps_aspects contains "medium tempo", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "story telling"
This data as json, CSV (advanced)
musiccaps_aspects (array) 123 ✖
- medium tempo · 8 ✖
- passionate · 8 ✖
- story telling · 8 ✖
- emotional 5
- energetic 3
- groovy music 3
- hip hop music 3
- male singer 3
- spirited 3
- female singer 2
- groovy 2
- groovy bass line 2
- keyboard harmony 2
- male rapper 2
- melancholic 2
- people dancing 2
- piano accompaniment 2
- poignant 2
- poor audio quality 2
- rapping vocals 2
- romantic 2
- slick drumming rhythm 2
- youthful 2
- amateur video quality 1
- ambient noise 1
- amplified organ 1
- auto tuned vocals 1
- backup female singers 1
- backup singers 1
- beeping tones 1
- booming bass line 1
- bridal send off song 1
- bridal song 1
- cheerful 1
- chimes 1
- classical ghazals 1
- damage rap music 1
- dance club 1
- dance groove 1
- dance mix 1
- dance music 1
- dance rhythm 1
- devotional music 1
- digital drum rhythm 1
- disco rap 1
- discotheque 1
- driving song 1
- electric rhythm guitar plays 1
- electronic instruments 1
- entertaining 1
- enthusiastic 1
- euro pop 1
- flute countermelody 1
- gangsta rap 1
- ghazal 1
- guiro percussions 1
- guitar accompaniment 1
- guitar rhythm 1
- gym talk 1
- hardship 1
- heart break 1
- heartfelt 1
- hip hop dance music 1
- hip hop hits 1
- hip-hop 1
- home rap video 1
- hustlers life 1
- indian percussions 1
- indian traditional song 1
- inspiring 1
- intense 1
- intense organ music 1
- keyboard accompaniment 1
- keyboard beep tones 1
- latin dance band 1
- latin folk singer 1
- latin percussions 1
- life is good 1
- life lessons 1
- life’s truths 1
- live performance 1
- male backup singers 1
- male latin singer 1
- mehandi ceremony 1
- money problems 1
- percussive bass line 1
- persuasive 1
- poor quality audio 1
- pop rap 1
- positive 1
- proverbs 1
- punchy bass 1
- punk rap 1
- purposeful 1
- rap 1
- relaxing playlists 1
- retro dance hits 1
- rhythmic chanting 1
- rhythmic patter 1
- rough male vocals 1
- russian hit songs 1
- russian rap music 1
- singer self introduction 1
- soaring vocals 1
- song fade 1
- song stops playing 1
- sound of picture being clicked 1
- steady drumming 1
- steady drumming rhythm 1
- street noises 1
- stringed instrument accompaniment 1
- synth countermelody 1
- synth horns playing 1
- synthesiser arrangements 1
- tabla playing steadily 1
- telephone ringing 1
- the hood 1
- typing sounds 1
- underground music 1
- vocal commentary 1
- vocal harmony 1
- walking bass line 1
- wedding song 1
musiccaps_names (array) 15 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
el grillo enamorado | A male singer sings this passionate melody. The song is medium tempo with Latin percussion, guiro percussions, guitar rhythm, piano accompaniment and guitar rhythm. The song is romantic and spirited. The song is a Latin dance song with poor audio quality. | 2008-09-05T17:39:10Z | Piko | el grillo enamorado con imagenes de grillos | ["Music of Africa", "Music", "Ska"] | ["male latin singer", "poor audio quality", "latin percussions", "people dancing", "latin dance band", "dance groove", "emotional", "soaring vocals", "latin folk singer", "walking bass line", "piano accompaniment", "dance rhythm", "entertaining", "romantic", "story telling", "passionate", "spirited", "guiro percussions", "medium tempo", "guitar rhythm"] | 1 | 2cxvYC9QZac | 391 | |
Hurricane Chris "FREESTYLE" *51/50 RATCHET IN STORES NOW* | A male vocalist sings this passionate rap. The tempo is medium with keyboard harmony, slick drumming, funky bass lines , sound of chimes and synthesiser arrangements. The song is emotional, passionate, emphatic, persuasive, youthful, impactful and rhythmic chanting. The song is a contemporary Hip-Hop/RAo. | 2007-11-01T00:16:48Z | Hurricane Chris | CHECK OUT HURRICANE CHRIS KILL THE "WHITE GIRL" TRACK!!! MAKE SURE YOU POST THIS ON YOUR PAGE AND SEND IT TO FRIENDS!! 51/50 RATCHET IN STORES NOW!! | ["Music", "Rapping", "Hip hop music"] | ["male singer", "medium tempo", "synthesiser arrangements", "rhythmic chanting", "disco rap", "pop rap", "hip-hop", "rap", "punk rap", "gangsta rap", "electronic instruments", "steady drumming", "punchy bass", "intense", "amplified organ", "intense organ music", "sound of picture being clicked", "chimes", "digital drum rhythm", "persuasive", "emotional", "passionate", "story telling", "rhythmic patter"] | 7 | IEVVHo9nr7g | 1883 | |
Street Workout Featuring Mysonne "All Around The World" | A male singer sings this rap vocals with backup singers in harmony. The song is medium tempo with typing and beeping tones, followed by steady drumming rhythm, groovy bass and keyboard harmony. The song is energetic and exciting. The song has a home video intro followed by a rap song. | 2009-11-16T19:20:34Z | djvlad | - http://VladTV.com - A gym membership is not necessary to be brolic. You are now training with Mysonne. Dir: Vernon Baines | ["Music", "Single-lens reflex camera"] | ["typing sounds", "male rapper", "backup singers", "singer self introduction", "groovy", "damage rap music", "beeping tones", "booming bass line", "amateur video quality", "home rap video", "vocal commentary", "medium tempo", "ambient noise", "street noises", "energetic", "passionate", "story telling", "amateur video quality", "gym talk", "poor quality audio"] | 1 | JI26wmUPcrM | 1988 | |
Gunshot - ROCMA ( Feat. XEptional ) | A male rapper sings this groovy melody. The song is medium tempo with a steady drumming rhythm, groovy bass line, a melancholic flute countermelody, keyboard harmony and guitar accompaniment. The song is exciting and passionate. The song is a modern Russian rap song with a story telling nature. | 2014-04-05T21:46:22Z | Mehdi Rafale | Produced and Mixed by XEptional https://www.facebook.com/Gunshot.officiel https://www.facebook.com/thexeptionalpage | ["Music", "Rapping", "Hip hop music"] | ["male rapper", "russian rap music", "medium tempo", "purposeful", "inspiring", "underground music", "youthful", "discotheque", "hardship", "flute countermelody", "guitar accompaniment", "groovy bass line", "steady drumming rhythm", "steady drumming rhythm", "keyboard harmony", "poignant", "melancholic", "emotional", "russian hit songs", "euro pop", "groovy music", "dance music", "dance mix", "dance club", "people dancing", "passionate", "story telling"] | 1 | TakkuFZJsis | 2849 | |
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 | |
Savvy - Stop It Official Music Video | A male rapper sings this emotional melody. The song is medium tempo with a steady techno drumming rhythm, strong bass line, various percussion hits, piano playing accompaniment and synth horns playing countermelody. The song is emotional and storytelling in nature. The song is a modern hip hop song. | 2016-06-17T14:13:21Z | NoLettingUpTheLabel | #loyalgang #betonme #artistontherise #youtubemusic #unsignedhype #vibegod #subscribe Loyal Gang Entertainment's Artist Savvy Performing Her Hit Record " Stop It " ( Dir By : Reggbvisual ) Follow Savvy On Social Media https://www.instagram.com?dareal_savvy https://www.twitter.com/Dareal_savvy https://www.facebook.com/Darealsavvy https://www.youtube.com/loyalgangentertainment Booking & Features : Loyalgangenetertainment@gmail.com | ["Music", "Rhythm and blues", "Tender music"] | ["male singer", "hip hop music", "hip hop hits", "groovy", "synth countermelody", "driving song", "auto tuned vocals", "medium tempo", "slick drumming rhythm", "percussive bass line", "piano accompaniment", "story telling", "emotional", "synth horns playing", "passionate", "the hood", "hustlers life", "money problems", "passionate", "spirited", "poignant", "youthful", "heart break"] | 1 | i6WtNBpRll0 | 4158 | |
'For Little Jimmy' (Official Music Video) - Ron Killings aka WWE Superstar "R-Truth" | A male singer with a rough voice sings this hip hop dance song. The song is medium tempo with a distorted electric guitar playing rhythm, keyboard accompaniment, slick drumming rhythm, telephone ring tones and various percussion hits. The song ends with a fade . The song has poor audio quality. | 2013-02-10T14:09:09Z | RonKillingsTV | 'For Little Jimmy' official music video from Ron Killings aka WWE Superstar "R-Truth" #RTruth #WWE #ForLittleJimmy #RonKillings #LittleJimmy Subscribe to RonKillingsTV: https://www.youtube.com/channel/UCkK8dn3G5IxAigWgRbdJmyw Website: https://www.theofficialronkillings.com Merchandise: https://www.ronkillings.com Facebook: https://www.facebook.com/ronkillings Twitter: https://www.twitter.com/ronkillings Tik Tok: https://www.tiktok.com/ronkillings1 Youtube: https://www.youtube.com/ronkillingstv IG: https://www.instagram.com/ronkillings1 Booking info: ronkillingsbooking1@gmail.com https://www.textrke.com (fan text line) (310) 406-7100 Director IG handle(s): @shotbyreginald | ["Music", "Telephone bell ringing", "Inside, small room", "Inside, large room or hall"] | ["male singer", "rapping vocals", "hip hop music", "telephone ringing", "slick drumming rhythm", "song stops playing", "keyboard beep tones", "keyboard accompaniment", "story telling", "enthusiastic", "medium tempo", "rough male vocals", "energetic", "passionate", "poor audio quality", "groovy music", "electric rhythm guitar plays", "song fade"] | 1 | sgJT5lIFttM | 4970 | |
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;