musiccaps_details (view)

3 rows where musiccaps_aspects contains "r&b" and musiccaps_author = 5

✎ 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
Stickwitu - Male Version, Me Singing The music contains an erotic male voice which is out of key and clearly in the foreground. In the background there's a sustained soft piano synth and a drum kit playing a mid pitch beat. The atmosphere is sexual and seductive. 2010-11-14T12:44:11Z 抵死仔 I'm Kelmen...I'm from HK. I hope U all like this song !! Thanks !! Download this song:: http://www.box.net/shared/y7gythrrym ["Music", "/m/05zppz", "Soul music", "/t/dd00003"] ["r&b", "happy", "mid-pitched male vocals", "soft piano synth", "kick", "snare", "hi-hats", "upbeat", "out of key vocals", "mid tempo"] 5 DB38NRSHw9A 1450
Cinderella III: A Twist in Time - Please Remember The track is an emotional love ballad that features heartfelt female vocals. Piano chords play in the background as a string section that sounds inspiring sustains chords. A drum kit plays a slow beat that adds to the romantic mood of the song. 2007-04-15T07:04:50Z disneyscarlos So, I finally gathered up my courage to add a new and improved version of my classic fan video of Cinderella III: A Twist in Time *amazing sequel* with the song "Please Remember" from Cayote Ugly! Comment and rate! ["Music", "Tender music"] ["emotional", "bright", "heartfelt female vocals", "low tempo", "inspiring piano melody", "ballad", "soul", "r&b", "romantic", "slow tempo", "soft drum kit", "inspirational string section"] 5 W7U-glgu4GM 3067
My Big Chop The music contains an energetic female voice which is sharp and clear. It is between rapping and singing. In the background are electronic music effects, at medium to high pitch. The atmosphere is smooth and confident. A drum kit plays a mid tempo pattern and It is very digital sounding. 2010-07-11T06:19:47Z yaboyhip   ["Afrobeat", "Funk", "Jingle (music)", "Music", "Rapping", "Hip hop music"] ["female singer", "r&b", "hip-hop", "fuzzy synth", "kick", "guitar", "electronic bass", "smooth", "electronic drum kit"] 5 cbq6Q2htPRM 3723

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;