musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "female voice singing" and musiccaps_names contains "Soul music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- acoustic drums · 3 ✖
- female voice singing · 3 ✖
- e-bass 2
- background noises 1
- backing voices 1
- bass 1
- cheerful 1
- e-guitar 1
- funk/rock 1
- guitar 1
- keys 1
- medium to uptempo 1
- piano 1
- pop 1
- reggae 1
- relaxing mood 1
- romantic 1
- slow to medium tempo 1
- slower tempo 1
- strings 1
- white noise 1
musiccaps_names (array) 8 ✖
- Music 3
- Soul music · 3 ✖
- Funk 1
- Independent music 1
- Psychedelic rock 1
- Reggae 1
- Rhythm and blues 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Как разжечь огонь без спичек | An acoustic drum is playing a simple groove with a strong kick. The e-bass is playing on every hit of the kick together with an e-guitar strumming a chord. A female voice is singing a slow paced melody. In the background you can hear some maschine sounds and piping sounds. This song may be playing in a James Bond movie-scene. | 2011-06-12T15:43:43Z | Scotch Soda | Как разжечь огонь в безвыходной ситуации, когда вы заперты на кухне, а зомби вокруг и у вас нет спичек. Подробности на http://scotchnsoda.net | ["Funk", "Music", "Rhythm and blues", "Soul music"] | ["funk/rock", "acoustic drums", "e-guitar", "e-bass", "female voice singing", "slow to medium tempo", "background noises"] | 6 | CRxIJ7YbcZA | 1368 | |
Neil Sedaka - Laughter In The Rain [w/ lyrics] | An acoustic drum is played along with a bassline, an acoustic guitar and piano all playing the same rhythm. Strings are playing a melody in the mid range along with the female singer that gets accompanied by backing vocals singing harmonies along. This song sounds romantic and cheerful. This song may be playing at the beginning scene of a rom-com movie. | 2011-06-01T19:40:57Z | cyberman000051 | "Laughter in the Rain" is a song recorded by Neil Sedaka, composed by him with lyrics by Phil Cody. It includes a 20-second saxophone solo by Jim Horn.[1] Cody reports writing the lyrics in about five minutes after smoking marijuana and falling asleep under a tree for a couple of hours. In the USA, "Laughter in the Rain" reached number one on the Billboard Hot 100 on February 1, 1975 (it was his first single to top the Hot 100 since 1962).[3] The song spent two weeks at the top of the adult contemporary chart. The song was likewise a major hit in Canada, reaching number two on the pop singles chart and number one on the Adult Contemporary chart. The song was also released in the UK where it spent nine weeks on the Singles Chart, peaking at No. 15 on June 22, 1974 | ["Music", "Independent music", "Psychedelic rock", "Song", "Soul music"] | ["pop", "strings", "acoustic drums", "piano", "e-bass", "acoustic drums", "female voice singing", "backing voices", "medium to uptempo", "romantic", "cheerful"] | 6 | VCusyLPrFCo | 2984 |
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;