musiccaps_details (view)
5 rows where musiccaps_aspects contains "medium tempo", musiccaps_author = 6 and musiccaps_names contains "Tender music"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- medium tempo · 5 ✖
- ballad 2
- keyboard 2
- piano 2
- acoustic kick 1
- acoustic piano 1
- arpeggios 1
- cymbal 1
- digital drums 1
- digital flute 1
- digital strings 1
- dreamy 1
- e-bass 1
- female voice sample 1
- female voice singing 1
- high register 1
- male singer 1
- male voice singing 1
- male voices singing/rapping 1
- melancholic 1
- mid-range 1
- peaceful 1
- pianos 1
- pop 1
- r&b/soul 1
- romantic 1
- sensitive 1
- sensual 1
- strings 1
- synthesizer sounds 1
- …
musiccaps_names (array) 7 ✖
- Music 5
- Tender music · 5 ✖
- Background music 1
- Blues 1
- Independent 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 |
---|---|---|---|---|---|---|---|---|---|---|
Hatsune Miku Sings "Lost My Music" | This song contains two pianos panned to both sides of the speakers playing melodies in the mid to upper range. A female voice, maybe a child sings a melody in a very high pitch. THis song may be playing as part of a movie-scene. | 2007-11-03T07:07:14Z | Myuface | As most of you know this song is made through Vocaloid2. Hatsune Miku Sings "Lost My Music" from Suzumiya Haruhi no Yuutsu/The Malancholy of Haruhi Suzumiya in English. Check http://en.wikipedia.org/wiki/Vocaloid or something simular for more info on the Vocaloid2 program. ニコニコ動画 http://www.nicovideo.jp/watch/sm1421215 | ["Music", "Rhythm and blues", "Tender music"] | ["ballad", "pianos", "female voice singing", "very high pitch", "medium tempo", "melancholic"] | 6 | 0Q1JLNfm8oU | 162 | |
JOE LYNN TURNER - Endlessly [Official Music Video] | A keyboard is playing chords with a string sound along with something that sounds like a cembalo or another keyboard playing chords and a melody in the mid to higher register. A male voice is singing in an upper key sounding soulful and sensitive. This song may be playing for a sensual music video. | 2011-02-02T14:06:50Z | AchillesAgonyEcstasy | JOE LYNN TURNER - Endlessly https://www.facebook.com/pages/AOR/103201933053191 | ["Blues", "Music", "Independent music", "Tender music"] | ["r&b/soul", "acoustic piano", "digital strings", "keyboard", "e-bass", "male voice singing", "high register", "sensual", "medium tempo"] | 6 | 31DNFoW3NAw | 432 | |
Amor Secreto - Kendo Kaponi ( Lyrics ) | This song contains a piano playing a melody in the mid range and also in the higher register. A flute is adding another melody in the mid range. A digital drum is holding a simple groove before dropping out completely. A male voice is softly rapping/talking in the mid range then another male with an effect takes over singing in a higher pitch. In the background you can hear strings underlaying chords. This song may be playing with headphones daydreaming. | 2011-06-16T16:52:05Z | MsCuBaNiTa01 | ["Music", "Tender music"] | ["pop", "piano", "strings", "digital drums", "digital flute", "male voices singing/rapping", "romantic", "sensitive", "medium tempo"] | 6 | 6sWVG6GyJBU | 793 | ||
메이플스토리 BGM - 시간의신전(Temple of time) | This song contains a cymbal holding the rhythm while different piano and keyboards are playing melodies. A xylophone is playing a melody in a higher pitch on top of that. A female voice choir sample comes in every year and then being part of the rhythmic composition. This song may be playing in a adventure video-game with beautiful landscapes. | 2014-08-01T03:44:09Z | yeon H | 원하신 브금을 댓글창에 적어주시면 업로드 해드립니다. | ["Background music", "Music", "Tender music"] | ["ballad", "piano", "keyboard", "cymbal", "female voice sample", "xylophone", "medium tempo", "dreamy", "peaceful"] | 6 | BdhaR2QUGqY | 1269 | |
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;