musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "female voice singing" and musiccaps_aspects contains "keys"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- acoustic drums · 3 ✖
- female voice singing · 3 ✖
- keys · 3 ✖
- e-bass 2
- bass 1
- e-guitar 1
- e-guitars 1
- erotic 1
- guitar 1
- male backing voice 1
- medium tempo 1
- reggae 1
- relaxing mood 1
- rock 1
- sensual 1
- slower tempo 1
- soul 1
- synthesizer 1
- uptempo 1
- white noise 1
musiccaps_names (array) 9 ✖
- Music 3
- Reggae 2
- Rhythm and blues 2
- Afrobeat 1
- Exciting music 1
- Happy music 1
- Hip hop music 1
- Music of Africa 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Tra La La Song Music Video - Full Version | An acoustic drum is playing a simple rock groove with some drum fills on the toms and snare along with a distorted e-bass and e-guitar playing the same line. Panned to the right side of the speaker you can hear a piano sound playing a little melody. A female voice is singing a happy sounding melody while male backing voices are supporting her. This song may be playing sitting in your room enjoying being at home alone. | 2010-02-11T03:47:04Z | Derek Bartholomaus | This is the full version of "The Tra La La Song (One Banana, Two Banana)" aka The Banana Splits Theme as performed by Liz Phair and Material Issue for the Saturday Morning Cartoons' Greatest Hits music and video project. This version was not released on home video and was only aired on MTV. This material is © 1995 by MCA Records. | ["Music", "Rhythm and blues", "Happy music", "Exciting music"] | ["rock", "e-guitars", "e-bass", "acoustic drums", "keys", "female voice singing", "male backing voice", "uptempo"] | 6 | -JvB5AL59fM | 36 | |
Slow Train Soul - Tell Me Somethin' | This song sounds sensual, slightly erotic. The female voice is singing in the mid range and with delay and reverb on her voice. The bass is playing long notes with little changes. The drums are playing a rather complex groove. An e-guitar is playing single notes contributing to the rhythm while another guitar is playing an almost looped melody on top. This guitar has some effect on it and it sounds sensual and provocative. Synthesizer hits and keys are adding more little elements that are panned to the left and right side of the speakers. This is a very rhythmic song with its harmonic elements. This song may be playing at a nightclub for adults. | 2014-01-28T17:16:31Z | SlowTrainSoul Official | ["Afrobeat", "Music of Africa", "Music", "Reggae", "Rhythm and blues", "Hip hop music"] | ["soul", "e-guitar", "keys", "synthesizer", "e-bass", "female voice singing", "acoustic drums", "sensual", "erotic", "medium tempo"] | 6 | B7V_grbxflg | 1207 | ||
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;