musiccaps_details (view)

1 row where musiccaps_aspects contains "energetic", musiccaps_names contains "Timpani" and youtube_description contains "No copyright infringement intended"

✎ 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
Luke Christopher - Bedroom Trip The low quality recording features a R&B song that consists flat male vocal singing over layered repetitive plucked arpeggiated melody and synth arpeggiated melody, followed by smooth synth bass, bouncy snare, punchy kick, bright hi hats triplets and low toms. It sounds energetic and groovy, although it seems that the song is finishing, judging by the arrangement. 2014-04-25T23:18:07Z SwagyTracks Subscribe to SwagyTracks for more music daily ! http://bit.ly/SubscribeSwagy ......... Download this track • http://eargasmic.me/1pA0BYu • Luke Christopher - https://twitter.com/LukeChrisMuzic https://soundcloud.com/lukechristopher https://www.facebook.com/lukechrismuzic Picture credit • Not found. If somebody knows who took this picture, please contact me! If you are the owner of this picture and want it removed, contact me and I will delete the video as soon as possible, no drama! ......... Follow SwagyTracks on Facebook • http://www.facebook.com/SwagyTracks Twitter • https://twitter.com/SwagyTracks SoundCloud • https://soundcloud.com/SwagyTracks Instagram • http://instagram.com/swagytracks Tumblr • http://swagytracks.tumblr.com ......... There is no copyright infringement intended for the song or picture. If you have an issue with me posting this song or picture please contact me through one of my social networks or YouTube private messaging system. Once I have received your message and determined you are the proper owner of this content I will have it removed, no drama at all. This channel is strictly for promotion towards the artists of the music. I try to help promote their music and their social networks. ["Timpani", "Music"] ["low quality", "repetitive plucked arpeggiated melody", "arpeggiated synth melody", "low toms", "punchy kick", "bouncy snare", "bright hi hats triplets", "r&b", "flat male vocal", "smooth synth bass", "energetic", "outro", "groovy"] 4 Pm6vRblouxc 2564

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;