musiccaps_details (view)
2 rows where musiccaps_aspects contains "e-bass", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "uplifting energy"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- e-bass · 2 ✖
- medium tempo · 2 ✖
- uplifting energy · 2 ✖
- accordion-like sound 1
- acoustic drums 1
- digital drums 1
- higher register 1
- keys 1
- male voice sample 1
- male voices singing 1
- new ethiopian music 1
- organ 1
- reggae 1
- synth pluck sound 1
musiccaps_names (array) 3 ✖
- Music 2
- Jazz 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 |
---|---|---|---|---|---|---|---|---|---|---|
Melaku Nigus track 4 2013 New Ethiopian music, Rayan Music, Wollo Music, Ethiopian Music | A digital drum is playing a simple beat along with some percussive sounds. A bass is playing the same melody as the accordion-like instrument. A male voice is shouting little phrases. This song may be playing a country having a traditional dance. | 2013-08-05T08:14:54Z | At Love | Rayan music, Wollo Music, Ethiopian Music, Amharic Music, Rayan Cultural Music, Wollo Cultural Music, | ["Jazz", "Music"] | ["new ethiopian music", "digital drums", "male voice sample", "accordion-like sound", "e-bass", "medium tempo", "uplifting energy"] | 6 | 0PMFAO4TIU4 | 161 | |
Tribal seeds- The Harvest(lyrics) | An acoustic drum is playing a groove that is not strongly connected to reggae rhythm. A e-bass and piano-keys are bringing the typical reggae backbeat while another synth sound is playing short plucks as a melody. The male voice is singing in a reggae-fashion and in a higher key. In the background you can hear a big organ sound coming in and playing along with the melody. The elements are spread along the speakers. This song may be playing with speakers riding on your bike. | 2012-01-08T06:20:54Z | molokaiboi1998 | hope u guys liike it:) srry if da lyrics r wrong i got it off da internet dont turn off da annotations there's corrections to da lyrics Lyrics: (verse 1) Ooooh, ooooh, Yeah When I first picked up the mic I was 3 and on my brother's side Didn't know what I singing but the vibe was always right Didn't think sound would have such a strong impact on my life This music it gets I and I in such a natural high (chorus) Now a days we a work we a work we a work to spread Jah word(2x) Cause in a this a life we have to strive all the time strive to do good works and achieve this at mind Spreading the word in a positive vibe Educate the youth and tell them no lie Play the music of Jah, in the harvest time Come with sweet melodies, to ease your mind(2x) Ooooh, Ooooh, Yeah (verse 2) Now I'm 21 still working, never, never got the education Never want to be a stock on a shelf, wanted to be my self It in a world living in hell, you see you can't do very well So a man keep my mind focused and uprised it's worth my while (chorus) | ["Music", "Soul music"] | ["reggae", "acoustic drums", "e-bass", "keys", "synth pluck sound", "organ", "male voices singing", "higher register", "medium tempo", "uplifting energy"] | 6 | ZM0imDMXuw8 | 3367 |
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;