musiccaps_details (view)
2 rows where musiccaps_aspects contains "easygoing" and musiccaps_aspects contains "positive" sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- easygoing · 2 ✖
- positive · 2 ✖
- acoustic 1
- acoustic guitar 1
- appealing female vocals 1
- bright piano 1
- fun 1
- jazzy drums 1
- k-pop 1
- kids music 1
- korean 1
- male vocal 1
- mellow tune 1
- melodic singing 1
- mid-tempo 1
- subtle trumpets 1
- uplifting 1
musiccaps_names (array) 4 ✖
- Music 2
- Happy music 1
- Singing 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
Dumb (Minecraft) ways to Die | The track is a Kids Music song. A female voice with appealing vocals sings an easygoing melody. A piano with a bright sound plays a jazzy melody. A jazz drum kit plays a smooth beat. In the background there are trumpets playing a melody that matches the positive and fun atmosphere of the track. | 2012-12-09T11:55:51Z | Christopher Gutteridge | There are lots of dumb ways to die in Minecraft. This video was created 100% in survival mode, anything less would be cheating. That said, since then there have been some amazingly talented videos made which put this one to shame. | ["Music", "Happy music"] | ["kids music", "positive", "fun", "bright piano", "subtle trumpets", "appealing female vocals", "easygoing", "mid-tempo", "jazzy drums"] | 5 | 4PNPgaLKFlc | 565 | |
110507 CNBLUE Jong Hyun singing 'I'm Yours', BGGG, Shy Boy & I don't Care @ Dιρεcτορ's cuτ | This is an acoustic performance of a k-pop piece. The lead is a male vocal that is singing gently and melodically in the Korean language. He is also playing an acoustic guitar as the melodic background of the piece. The song is in the major scale which gives it this positive and uplifting aura. This piece could be used in the soundtrack of a coming-of-age/teenage drama TV series that takes place in Korea. It could also be playing in the background of a coffee house. | 2011-05-07T16:24:09Z | CNBlueTV | CNBLUE Jong Hyun singing 'I'm Yours', BGGG, Shy Boy & I don't Care | ["Singing", "Music", "Ukulele"] | ["k-pop", "korean", "acoustic", "male vocal", "melodic singing", "acoustic guitar", "mellow tune", "easygoing", "positive", "uplifting"] | 9 | lqCx0HgF1ZM | 4425 |
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;