musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "acoustic", musiccaps_aspects contains "male vocal" and musiccaps_aspects contains "melodic singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- acoustic · 2 ✖
- acoustic guitar 2
- male vocal · 2 ✖
- melodic singing · 2 ✖
- christian 1
- deep 1
- easygoing 1
- gospel music 1
- k-pop 1
- korean 1
- mellow tune 1
- passionate 1
- positive 1
- religious 1
- simple tune 1
- uplifting 1
musiccaps_names (array) 4 ✖
- Music 2
- Middle Eastern 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 |
---|---|---|---|---|---|---|---|---|---|---|
Spreading Christian music in India, Phil Fischer in Pakistan, Stuck on You | This is a Christian gospel music piece. There is a male vocalist singing melodically at the forefront. The simple tune is being played by a mellow acoustic guitar. The piece has a deep and passionate atmosphere. It could be used in Christian religious events and gatherings. It could also be used in the background of Christian social media content. | 2009-11-03T20:11:26Z | northwestmusician | http://philfischer.com Phil Fischer in Pakistan, Stuck on You, spreading Christian music in India, singing music in Pakistan, mercy me youtube Channel, casting crowns myspace page, download free acoustic Christian music | ["Music", "Middle Eastern music"] | ["gospel music", "christian", "acoustic", "male vocal", "melodic singing", "acoustic guitar", "simple tune", "religious", "deep", "passionate"] | 9 | 0jFQ21A6GRA | 202 | |
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;