musiccaps_details (view)

1 row where musiccaps_aspects contains "beeping style synth", musiccaps_aspects contains "hip hop inspired drum beat", musiccaps_names contains "Electronica" and musiccaps_names contains "Independent 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
Indie Music R&B Instrumental "Backhand" Inspired by Janell Monae This is an R&B and hip hop inspired instrumental. The drum pattern is 808 kick heavy and typically found in hip hop. The main melodic instruments are the fuzzy bass which plays long sustained notes, and there's also a beeping synth which sounds like the tones of old morse code machines. There are sound effects like a laughing man, children chanting, and a muffled shouting sound. 2015-04-26T03:48:15Z CP the Creator This "Backhand" 🎧 beat is available at https://air.bi/grj4N Email jayjoshbeats@gmail.com SUBSCRIBE and stay updated with the royalty free background music movement https://www.youtube.com/channel/UCwvU... If you need to reach out me here are all of my social media links ... Twitter: @jayjoshrocstar Instagram: @jayjoshrocstar Facebook: jayjoshrocstar Snapchat: jayjoshrocstar This channel is consistently creating new original Hip Hop and RnB Instrumentals for you to use for mixtapes, singles, albums, movies, TV media, and anything else your creative mind can think of. Music Producer JayJosh RocStar is more than happy to provide you with the music that you need. R&B MUSIC PRODUCTION https://air.bi/grj4N ["Music", "Independent music", "Electronica"] ["fuzzy sustained bass", "808 kick drum", "beeping style synth", "hip hop inspired drum beat", "sound effects", "slow tempo", "laughing sound effect", "muffled shouting sound effect", "children speaking"] 3 tju-t_Bz_W8 5059

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;