musiccaps_details (view)
1 row where musiccaps_aspects contains "higher register", musiccaps_names contains "Music" and musiccaps_names contains "Soul music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;