musiccaps_details (view)

1 row where musiccaps_aspects contains "afro percussion", musiccaps_aspects contains "hollering sample" and musiccaps_names contains "Hip hop 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
"Look Like You" Afrobeat Remix DJ Tjaey This is an afrobeat remix of a hip-hop music piece. There is a male vocalist singing in a rap-like manner. A repeated hollering sample can be heard. The rhythmic background is provided by a variety of afro percussion elements. There is a danceable feel to it. This piece could be played at nightclubs or dance clubs. It could also be used as an accompaniment piece at a modern dance course. 2015-10-22T17:12:04Z Kara Jenelle Thank you for watching!! We hope you enjoyed our dance cover and stay tuned for a class coming to a studio near you... Like, Share, SUBSCRIBE!! #PanAfricanMovement through DANCE- embracing our African culture to unify and uplift others through traditional and modern dances. Though we may have different backgrounds, we strive towards the same destiny as we are one in the African Diaspora. #UBUNTU "I am who I am because of who we all are" Choreography & Performance by: Kara Jenelle (MSA) -karajenelle@gmail.com Lindiwe Rose (GTA) -lindoleen@gmail.com Videography & Editing by: Tiro Rose ["Afrobeat", "Music", "Hip hop music"] ["hip-hop", "afrobeat", "remix", "male vocal", "rap-like singing", "hollering sample", "afro percussion", "hip", "danceable", "urban"] 9 QQTWFTNy-WA 2617

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;