musiccaps_details (view)
3 rows where musiccaps_aspects contains "melancholic" and musiccaps_names contains "Rhythm and blues"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- melancholic · 3 ✖
- medium tempo 2
- ballad 1
- cheerful 1
- electric guitar 1
- electronic drums 1
- energetic 1
- female singer 1
- female voice singing 1
- groovy 1
- groovy bass line 1
- groovy music 1
- hip hop dance music 1
- hip hop music 1
- keyboard 1
- keyboard harmony 1
- life is good 1
- life lessons 1
- male backup singers 1
- male vocal 1
- melodic singing 1
- neo-soul 1
- passionate 1
- pianos 1
- r&b 1
- rapping vocals 1
- relaxing playlists 1
- retro dance hits 1
- romantic 1
- sentimental 1
- slow tempo 1
- spirited 1
- story telling 1
- strong bass 1
- very high pitch 1
musiccaps_names (array) 4 ✖
- Rhythm and blues · 3 ✖
- Music 2
- Singing 1
- Tender music 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 | |
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 | |
OFFICIAL VIDEO: "Dealing" featuring Lalah Hathaway | This is an R&B/neo-soul music piece. There is a male vocalist in the lead singing melodically. The main tune is being played by the electric guitar and the keyboard. There is a strong and groovy bass sound. The rhythmic background consists of a slow tempo electronic drum beat. The atmosphere is sentimental. This piece could be used in the soundtrack of a romantic comedy movie that takes place in the big city, especially during the scenes where a character is going through the feeling of heartbreak. | 2009-12-19T06:08:47Z | Eric Roberson | "Dealing" feat. Lalah Hathaway Directed by Impakt Studio (Chris & Blaq) www.ericrobersonmusic.com www.impaktstudio.com www.lalahhathaway.com | ["Singing", "Rhythm and blues"] | ["r&b", "neo-soul", "male vocal", "melodic singing", "keyboard", "electric guitar", "strong bass", "electronic drums", "slow tempo", "groovy", "sentimental", "melancholic"] | 9 | lAMiOhScSPg | 4378 |
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;