musiccaps_details (view)
3 rows where musiccaps_aspects contains "male singer", musiccaps_aspects contains "medium tempo" and musiccaps_names contains "Tender music"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- male singer · 3 ✖
- medium tempo · 3 ✖
- emotional 2
- acoustic guitar 1
- acoustic kick 1
- arpeggios 1
- auto tuned vocals 1
- calm 1
- driving song 1
- folk song 1
- foreign language 1
- funky bass line 1
- groovy 1
- heart break 1
- hip hop hits 1
- hip hop music 1
- hustlers life 1
- keyboard harmony 1
- love song 1
- mandolin 1
- mid-range 1
- money problems 1
- passionate 1
- percussive bass line 1
- piano accompaniment 1
- poignant 1
- romantic 1
- slick drumming rhythm 1
- soothing 1
- soulfu 1
- …
musiccaps_names (array) 5 ✖
- Music 3
- Tender music · 3 ✖
- Folk music 1
- Music of Africa 1
- Rhythm and blues 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
tsehay yohannes - Old music | A male vocalist sings this lilting melody. The tempo is medium with keyboard harmony, groovy bass line, steady drumming and mandolin harmony. The song is emotional, romantic, soulful, sentimental and soothing. This song is Regional Pop, | 2012-06-02T11:28:06Z | Banchi Avera | This song taking me back to my past ......... | ["Folk music", "Music", "Tender music"] | ["male singer", "medium tempo", "foreign language", "romantic", "soulful", "mandolin", "steady drumming", "soulfulromantic", "soulfu", "soothing", "calm", "soulful", "emotional", "love song", "folk song", "world music", "funky bass line", "keyboard harmony", "acoustic guitar"] | 7 | c9h4p6325Xo | 3684 | |
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 | |
City Of Night (Miracle Of Sound Music Video) | A male voice is singing with a mid-melody. Different synthesizer sounds are playing arpeggios being used as bassline and other sounds as melody in the mid range and higher register. An acoustic sounding kick is playing on every beat. This song may be playing in a synth retro movie. | 2013-05-25T13:36:57Z | Jevanimation | So basically I was doing my final major project in college and long story short I had to drop my first film idea with 3 weeks until the deadline. So after finding out I couldn't afford the flight to Mexico I decided yo make an animation. After 3 weeks (I think) this is what I ended up with. I know the animation is a bit rough but it was a bit rushed towards the end because I'm lazy and didn't do much in the first two weeks. But anyway, huge thanks to Miracle Of Sound for letting me use this track, if you haven't heard his music look him up on youtube he makes awesome game and movie related original songs. Hope you guys enjoy :) Also kudos for actually reading all the description, what a kind soul! | ["Music of Africa", "Music", "Tender music"] | ["synthpop", "male singer", "mid-range", "synthesizer sounds", "arpeggios", "acoustic kick", "medium tempo"] | 6 | nc6h6rC3wdk | 4564 |
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;