musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic", musiccaps_aspects contains "male vocal", musiccaps_aspects contains "melodic singing" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
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 | |
"White Sandy Beach" - Play along karaoke style | This is an acoustic piece. There is a male vocalist singing melodically. There is a simple tune being played on a ukulele. The atmosphere of the piece is easygoing. This piece could be used in the background of wholesome social media content. | 2007-06-28T01:14:21Z | honoluluadvertiser | Notes: Remember the number you see next to the chords indicate the number of times you need to repeat the strum pattern. The strum pattern is: Down Down Up Up Down Chords: F, Bb, Bbm, and C7 | ["Music", "Ukulele"] | ["acoustic", "male vocal", "melodic singing", "ukulele", "simple tune", "gentle", "summer", "easygoing", "calming"] | 9 | RS43EP1EXz4 | 2702 | |
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;