musiccaps_details (view)
1 row where musiccaps_aspects contains "bright hi hats triplets", musiccaps_aspects contains "flat male vocal" and musiccaps_aspects contains "low toms"
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
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;