musiccaps_details (view)

1 row where musiccaps_aspects contains "bass", musiccaps_aspects contains "electronic/techno", musiccaps_aspects contains "uptempo" and musiccaps_aspects contains "white noise"

✎ 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
Vicetone feat. Collin McLoughlin - Heartbeat (PIXL Remix) [ FREE DOWNLOAD ] This song contains a piano playing minor chords with a lot of reverb, a synthesizer playing a countermelody with short notes and something like a processed and cut voice sample that gets repeated in a very short and rhythmical ways serving as percussive element and is panned to the left and the right side of the speakers along with white noise processed with delay. For a moment a short digital bass sound is coming in. This song may be playing in a club. 2013-05-13T17:06:50Z Spread The Jams Free Download ▼ http://dl.spreadthejams.com/heartbeat-pixl-remix Release Info: Spotlight Compilation 1 -- edmSpotlight has teamed up with Monstercat, Tasty Network and Trap & Bass to put out this massive 20-track free compilation! Get all the jams via the download link above! Genre: Electro 【 Submit your free music! 】 http://spreadthejams.com/submit ✖ Spread The Jams Facebook: http://facebook.com/spreadthejams Twitter: http://twitter.com/spreadthejams Subscribe! http://bit.ly/subscribetospreadthejams SUPPORT THE ARTISTS: ✖ PIXL Facebook: http://facebook.com/pixlmusic Twitter: http://twitter.com/PIXLMUSIC Soundcloud: http://soundcloud.com/pixl-music Youtube: http://youtube.com/user/PIXLOFFICIAL ✖ Vicetone Facebook: http://facebook.com/VicetoneOfficial Twitter: http://twitter.com/vicetone Soundcloud: http://soundcloud.com/vicetone Youtube: http://youtube.com/vicetoneofficial ✖ Collin McLoughlin Facebook: http://facebook.com/CollinMcLoughlinM... Twitter: http://twitter.com/McLoughlinMusic Soundcloud: http://soundcloud.com/collinmcloughlin SUPPORT THE NETWORK ✖ edmSpotlight Facebook: http://facebook.com/edmSpotlightTV Youtube: http://youtube.com/edmSpotlight Website: http://edmSpotlight.com COPYRIGHT / LICENSING: All of the music you hear on this channel has been provided to Spread The Jams with permission from the artists. The music is free to download but is not royalty free. If you want to use this music in a Youtube video and enable monetization you will need permission from the artists. ["Heart murmur", "Music"] ["electronic/techno", "piano", "synthesizer", "white noise", "bass", "uptempo", "melancholic"] 6 kTyI2unrdv0 4321

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;