musiccaps_details (view)

1 row where musiccaps_aspects contains "banger beat", musiccaps_author = 6 and musiccaps_names contains "Electronica"

✎ 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
PAY$O - New Bounce Rap |Club Instrumental 2015 This beat contains a bassline that stands out also serving as melody. A rather complex digital drum is played along with male and female short vocal samples. A little tabla samples spices up the rhythm section along with a synthesizer hit. This instrumental is full of rhythmic elements. This song may be playing at home practicing rapping. 2015-07-30T06:25:52Z YB MUZiK Download: http://soundclick.com/ybmuzik Purchase: http://www.ybmuzik.com ($24.95) Contact: ybmuzikofficial@gmail.com DESCRIPTION New School hip hop instrumental. BEAT'S TITLE "PAY$O" ABOUT US YB MUZiK is an independent instrumental licensing company that offers a wide array of beats for both non-profit and for-profit use. Selection categories include: Dance/Electronic Beats, Hip Hop Beats, Pop Beats, and Urban/R&B Beats. All instrumentals are available for free download via the company website. Free downloads are to be used solely for non-profit & demo uses only. Buyers utilizing instrumentals for a profit based use may either lease a non-exclusive license or for the more serious buyer, purchase exclusive rights. Please see details below. Alongside our wide selection, we also offer special services for those individual buyers looking to buy beats that is custom made; tailored to their preference. Please contact via e-mail for further information. CREDITS All instrumentals purchased from YB MUZiK are to state: "Produced by YB MUZik" or "Music by YB MUZiK." LICENSING TERMS Standard Lease ($24.95) - Non Exclusive - Untagged instrumental in MP3 format - Digital download via e-mail within 24 hours - Standard Lease Contract (PDF) - Royalty-free distribution to not exceed 5,000 copies Premium Lease ($79.95) - Non Exclusive - Untagged instrumental in MP3 & .Wav format - Multi-track stems for mixing and mastering - Digital download via e-mail within 24 hours - Premium Lease Contract (PDF) - Royalty-free distribution to not exceed 15,000 copies Unlimited Lease ($99.95) - Non Exclusive - Untagged instrumental in MP3 & .Wav format - Multi-track stems for mixing and mastering - Digital download via e-mail within 24 hours - Unlimited Lease Contract (PDF) - Royalty-free distribution for UNLIMITED copies SOCIAL MEDIA Official Website: http://www.ybmuzik.com Email: ybmuzikofficial@gmail.com Soundclick: http://www.soundclick.com/ybmuzik Soundcloud: http://www.soundcloud.com/ybmuzik.com Twitter: http://www.twitt… ["Sampler", "Music", "Drum machine", "Hip hop music", "Electronica"] ["trap/rap", "digital bass", "digital drums", "male shouting sample", "female voice sample", "tabla hit", "medium to uptempo", "banger beat"] 6 j43Dwqzd8w8 4232

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;