musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "positive" and musiccaps_names contains "Singing" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- positive · 2 ✖
- acoustic 1
- acoustic guitar 1
- blues 1
- blues drum kit 1
- bouncy bass 1
- bright male vocals 1
- easygoing 1
- falsetto male vocals 1
- fast tempo 1
- happy 1
- k-pop 1
- korean 1
- male vocal 1
- mellow tune 1
- melodic singing 1
- raspy male vocals 1
- upbeat 1
- uplifting 1
musiccaps_names (array) 7 ✖
- Music 2
- Singing · 2 ✖
- Music of Asia 1
- Rock and roll 1
- Ska 1
- Ukulele 1
- Whoop 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
The Blues Willies - Shout | The track is an upbeat blues song that features falsetto and raspy male vocals. A drum kit plays an energetic and happy beat. A bass guitar follows the rhythm and adds a bouncy vibe to the song. The overall sound of the instruments is bright and happy. A guitar follows the bass and the drum kit. | 2007-05-03T10:44:42Z | Alfredo | I Blues Willies al concertone del primo Maggio 2007 a S. Giovanni. A parte il mitico Chuck Berry, l'unico vero gruppo che c'entrava qualcosa con il rock'n'roll! www.blueswillies.it | ["Singing", "Music of Asia", "Music", "Ska", "Whoop", "Rock and roll"] | ["blues", "upbeat", "falsetto male vocals", "raspy male vocals", "fast tempo", "blues drum kit", "positive", "happy", "bright male vocals", "bouncy bass"] | 5 | vtVfl5Ff5lw | 5216 |
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;