musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "soulful" and musiccaps_names contains "Soul music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- soulful · 2 ✖
- build-up 1
- church organ chords progression 1
- crackling effect 1
- electric guitar licks 1
- emotional 1
- funky 1
- funky rhythmic bassline 1
- groovy 1
- groovy piano melody 1
- hi-hats 1
- mellow kick 1
- passionate 1
- passionate electric guitar melody 1
- powerful rich female vocal 1
- punchy snare 1
- rock 1
- shimmering cymbals 1
- soulful female vocal 1
- strummed acoustic rhythm guitar chords progression 1
- twangy electric guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Grateful Dead - Ship of Fools | The Rock song features a groovy piano melody followed by passionate electric guitar melody, church organ chord progression, strummed acoustic rhythm guitar chords, shimmering cymbals, punchy snare and mellow kick hits. It sounds emotional, soulful and passionate. | 2011-05-30T15:59:43Z | Istofn | ["Music", "Soul music"] | ["rock", "groovy piano melody", "passionate electric guitar melody", "church organ chords progression", "strummed acoustic rhythm guitar chords progression", "shimmering cymbals", "punchy snare", "mellow kick", "emotional", "soulful", "passionate"] | 4 | 6iZ49s7eH5g | 777 | ||
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 |
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;