musiccaps_details (view)

2 rows where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "e-bass", musiccaps_aspects contains "medium tempo", musiccaps_author = 6 and musiccaps_names contains "Soul music"

✎ View and edit SQL

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
FUNK: Sir Joe Quarterman & Free Soul - The Trouble With Trouble An acoustic drum is playing a hiphop/funk groove along with a bassline. One e-guitar is strumming a funk chord while the other guitar is playing a melody sequence and then the other guitar responds with a chord. The male voice sings in the mid to high range and at the end of the song a keyboard is playing a chord with a string sound. This song may be playing at home cleaning the house. 2012-08-03T13:54:16Z Cis Verfaillie Artist: Sir Joe Quarterman & Free Soul Title: The Trouble With Trouble Year: 1973 (RE 20??) Label: GSF Records - GSF-S-1009 (RE ") Country: US Genre: Funk, Soul This upload is for promo use only, please check my channel for more uploads ["Funk", "Music", "Soul music"] ["funk/soul", "e-guitars", "e-bass", "acoustic drums", "male singer", "keyboard-strings", "medium tempo"] 6 DysXetu2I0E 1523
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

CSV options: 

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;