musiccaps_details (view)
2 rows where musiccaps_aspects contains "cymbal ride" and musiccaps_aspects contains "youthful" sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- cymbal ride · 2 ✖
- energetic 2
- fast tempo 2
- keyboard harmony 2
- synthesiser arrangements 2
- youthful · 2 ✖
- acoustic guitar 1
- bachata 1
- bongos 1
- booming sounds 1
- bright steel drumming 1
- buoyant 1
- catchy 1
- club music 1
- congas 1
- congas rhythm 1
- dance hits 1
- dissonant booming sounds 1
- edm 1
- electronic music 1
- electronically arranged sounds 1
- funky bass line 1
- groovy 1
- groovy bass lines 1
- hissing sound 1
- instrumental 1
- latin dance music 1
- latin hits 1
- latin song 1
- latin urbano 1
- male singer 1
- party music 1
- punch digital drum beat 1
- punchy 1
- punchy drumming 1
- rhythmic bongos 1
- salsa 1
- sound of bubbling 1
- spanish music 1
- spirited 1
- steady drumming 1
- upbeat 1
- vibrant 1
- vivacious 1
- water boiling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
"Stalker" Spray paint art video | This music is an electronic instrumental. The tempo is fast with punchy drumming rhythm, keyboard harmony, vigorous guitar rhythm and electronically arranged sounds like a dissonant booming drum, water bubbling, hissing and whistle like instrument playing harmony. The song is youthful, energetic, enthusiastic, vigorous, vivacious and youthful with a dance groove. This music is EDM. | 2015-09-23T22:06:58Z | The Art Surgeon | A spray painting of a tiger that I did in about an hour and a half .Done with only rustoleum spraypaint, magazine paper, a cheap foam brush,and my trusty index f.inger! Enjoy! www.theartsurgeon.com www.facebook.com/TheArtSurgeon http://instagram.com/theartsurgeoncom/ music by: Chirpfront "Abandoned Summer" http://click.dj/freebackgroundmusic/chirtfront-rapture-free-background-music-no-copyright-music ► YouTube - www.youtube.com/user/ChirpfrontOfficial ► SoundCloud - https://soundcloud.com/chirpfrontoffi provided by Free Background Music YouTube - http://goo.gl/fFI0z8 SoundCloud - https://soundcloud.com/freebmusic Facebook - http://goo.gl/2otgOU Twitter - https://twitter.com/FreeBMusic Google+ - http://goo.gl/TybZuK | ["Music", "Spray", "Dubstep", "Electronic dance music"] | ["instrumental", "fast tempo", "punchy drumming", "funky bass line", "electronic music", "acoustic guitar", "keyboard harmony", "sound of bubbling", "water boiling", "electronically arranged sounds", "groovy", "youthful", "energetic", "vibrant", "vivacious", "edm", "booming sounds", "synthesiser arrangements", "cymbal ride", "steady drumming", "hissing sound", "dissonant booming sounds", "punch digital drum beat"] | 7 | hmkPWxTIwwU | 4140 | |
flamenco salsero 2017 - SALSA CHOKE - CHOKECHACHE - los chaches | A male vocalist sings this spirited song. The tempo is fast with a fast keyboard harmony, boomy bass line, rhythmic drums, steel drums,congas and bongos, cymbal ride and sound of clapping. The song is upbeat, punchy, buoyant, spirited, energetic and youthful with a dance groove. This song is Latin Urbano. | 2015-04-21T18:31:13Z | Los Chaches Record | flamenco salsero 2017 - rap 2017 - salsa choke 2017 - chokechache 2017 - flamenco 2017 - maketas flamencas 2017 - perreo 2017 - rumba 2017 - rap flamenco 2017 - video bailando riko de los chaches - moncho chavea - el vaka los chaches record | ["Flamenco", "Music"] | ["male singer", "fast tempo", "latin song", "latin dance music", "bright steel drumming", "youthful", "energetic", "congas", "bongos", "cymbal ride", "buoyant", "club music", "party music", "dance hits", "latin urbano", "punchy", "spirited", "upbeat", "catchy", "spanish music", "latin hits", "salsa", "bachata", "groovy bass lines", "keyboard harmony", "congas rhythm", "rhythmic bongos", "synthesiser arrangements"] | 7 | m3uiITzeM70 | 4442 |
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;