musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "keys" and musiccaps_names contains "Soul music" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- acoustic drums 2
- keys · 2 ✖
- 90s/2000s 1
- bass 1
- deeper voice singer 1
- e-bass 1
- e-guitar 1
- female voice singing 1
- guitar 1
- intimate atmosphere 1
- male 1
- r&b/love-ballad 1
- reggae 1
- relaxing mood 1
- slow tempo 1
- slower tempo 1
- white noise 1
musiccaps_names (array) 5 ✖
- Music 2
- Soul music · 2 ✖
- Independent music 1
- Reggae 1
- Rhythm and blues 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
K-Ci & JoJo - Love Ballad [Cover of L.T.D.] | The drums hold a solid R&B groove with little fill-ins here and there that are panned to the left and right side of the speakers. Along with the drums a e-bass is playing a round and full-sounding bassline in the background. One e-guitar is strumming chords panned to the right side of the speakers. While the other guitar is playing a lead melody ending the phrases of the keys playing chords in the mid range. The male singer sounds soulful and his voice is deep. This song may be playing at home on a romantic dinner with your partner. | 2011-10-25T23:34:59Z | aft3rTh0ught | {DISCLAIMER} I Don't Own This Song No Copyright Intended This Song Belongs To Its Respective Owners Please Support The Artist By Buying Their Songs/Albums | ["Music", "Independent music", "Rhythm and blues", "Soul music"] | ["90s/2000s", "r&b/love-ballad", "acoustic drums", "keys", "e-guitar", "e-bass", "male", "deeper voice singer", "intimate atmosphere", "slow tempo"] | 6 | C6m_OWe-JE4 | 1330 | |
CHERRY PIE RIDDIM - ??? & ERIC DONALDSON | The drums are just playing the hihat and the kick on the second beat which is typical for reggae. The keys are playing one chord on the offbeat. A guitar is playing some repeating chords along while the bass is playing a simple rhythmic pattern to support the drums. The female voice is singing with some reverb on her voice. This song may be playing on a sunny day at home with open windows mixed with the noises of a lovely small town. | 2009-03-11T20:18:42Z | Micha Otto | ▬► Mr.Rek .... | ["Music", "Reggae", "Soul music"] | ["reggae", "acoustic drums", "white noise", "bass", "keys", "guitar", "female voice singing", "slower tempo", "relaxing mood"] | 6 | C5MhO2HM2Wg | 1327 |
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;