musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "funky", musiccaps_aspects contains "soulful" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- funky · 3 ✖
- soulful · 3 ✖
- groovy 2
- bright brass sounding instruments 1
- bright synths 1
- build-up 1
- choir 1
- crackling effect 1
- dance 1
- disco 1
- electric guitar licks 1
- electric guitar melody 1
- energetic 1
- energetic drums 1
- funky bass guitar 1
- funky rhythmic bassline 1
- hi-hats 1
- live performance 1
- low quality 1
- passionate 1
- passionate male vocal 1
- powerful rich female vocal 1
- rock 1
- simple drum beat 1
- solo brass melody 1
- soulful female vocal 1
- twangy electric guitar 1
- upbeat 1
- vibrant soulful male vocal 1
musiccaps_names (array) 9 ✖
- Music · 3 ✖
- Funk 2
- Disco 1
- Rock and roll 1
- Rock music 1
- Singing 1
- Song 1
- Soul music 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sunfire - Never Too Late For Your Lovin' (12" Funk 1983) | The song is a funky, soulful disco song. The whole vibe is vibrant and upbeat and features a bouncy groove from a bass guitar as well as bright and shimmery sounding brass instruments. There's a sustained silky synth sound. The singer sounds cheerful. The song is suitable for dancing. | 2016-03-15T18:37:57Z | Coolfunk Zézé 2 | Funk Never Too Late For Your Lovin' (12" Funk 1983) | ["Disco", "Funk", "Music"] | ["disco", "funky", "soulful", "upbeat", "groovy", "dance", "vibrant soulful male vocal", "bright synths", "simple drum beat", "bright brass sounding instruments"] | 3 | ABr4Q_ecoPw | 1082 | |
Shain Caw - No Mercy | The song feels funky and soulful. There's a rumbling funky bassline, and an electric guitar playing intermittent licks. The drumming sticks on the hi-hats for the feeling of a build-up;. The female vocalist has a powerful, soulful voice. | 2010-07-12T21:30:43Z | Marc de Groot | From Shain Caws new album The Incredible Decibel. Filmed, directed and edited by Marc de Groot. | ["Funk", "Music", "Soul music"] | ["funky", "soulful", "groovy", "funky rhythmic bassline", "twangy electric guitar", "soulful female vocal", "powerful rich female vocal", "crackling effect", "hi-hats", "build-up", "electric guitar licks"] | 3 | KPnIFb7T7VM | 2080 | |
Solomon Burke performs Rock and Roll Hall of Fame Inductions 2001 | The low quality recording features a live performance of a rock song and it consists of passionate male vocal singing over energetic drums, funky bass guitar, electric guitar melody and solo brass melody. At the end of the loop, there is a short snippet of choir singing in harmony. Overall it sounds funky, energetic, soulful and passionate - as a live performance should sound. | 2010-12-07T18:15:11Z | Rock & Roll Hall of Fame | Solomon Burke performs Rock and Roll Hall of Fame Inductions 2001 Visit us! http://rockhall.com/ Subscribe to RockHall : http://www.youtube.com/subscription_center?add_user=rockhall Facebook: http://www.facebook.com/rockandrollhalloffame Twitter: http://twitter.com/rock_hall Google +: http://plus.google.com/u/0/115412030406922618012 Check out all the inductees: http://rockhall.com/inductees/ Upcoming events: http://rockhall.com/events/ | ["Singing", "Music", "Rock music", "Song", "Rock and roll", "Yell"] | ["rock", "low quality", "live performance", "passionate male vocal", "choir", "solo brass melody", "funky bass guitar", "energetic drums", "electric guitar melody", "energetic", "soulful", "passionate", "funky"] | 4 | VfARCp38XtA | 3018 |
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;