musiccaps_details (view)
1 row where musiccaps_aspects contains "acoustic jazz piano sample", musiccaps_aspects contains "synthesizer riser", musiccaps_names contains "Electronica" and musiccaps_names contains "Keys jangling"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Last Call - Bobby C Sound TV (Glitch Hop) | An electro swing, or swing house track featuring a four on the floor kick pattern, acoustic jazz piano sample playing a classic rhythm changes chord progression, a female blues singer, synthesizer risers, ambient bell sounds, a walking synth bassline and a snare on backbeat. Would be fitting music for a modern day speakeasy. | 2015-12-09T13:46:27Z | YC Promotion | Last Call - Bobby C Sound TV (Glitch Hop) Bobby C Sound TV http://bobbycsound.tv http://facebook.com/Bobbycsoundtv http://soundcloud.com/bobby-c-sound-tv http://twitter.com/BobbyCSoundTV Ghetto Funk http://ghettofunk.co.uk http://facebook.com/ghettofunk http://soundcloud.com/ghettofunk http://twitter.com/ghettofunkhq ---------------------------------------------------- Follow us Facebook: https://www.facebook.com/YCPromo Website: http://www.yc-promo.com/ Soundcloud: https://soundcloud.com/yc-promotion Twitter: https://twitter.com/YC_promotion Instagram: https://www.instagram.com/ycpromotion/ Google plus: https://plus.google.com/102693194037153401998 ---------------------------------------------------- If you can sing or publishes music, message us and we will upload it to our channel supporting you in anyway we can. Cheers guys! ---------------------------------------------------- If there are copyright issues with any of my videos from producer or label's side (including artists of the images used), please send an personal message to me through YouTube or Facebook and I will remove it immediately! | ["Keys jangling", "Music", "Techno", "Dubstep", "Electronic dance music", "Dance music", "Electronica"] | ["electro swing", "swing house", "four on the floor", "acoustic jazz piano sample", "rhythm changes chord progression", "female blues singer", "synthesizer riser", "ambient bell sounds", "walking synth bassline", "snare on backbeat"] | 8 | HMJe5jS0Yt4 | 1794 |
Advanced export
JSON shape: default, array, newline-delimited
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;