musiccaps_details (view)
2 rows where musiccaps_aspects contains "punchy" and musiccaps_names contains "Jazz" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- fast tempo 2
- punchy · 2 ✖
- atmospheric synthesiser 1
- auto tune 1
- auxiliary percussions 1
- bass drum 1
- boomy bass drops 1
- bouncy 1
- bright 1
- buoyant 1
- club music 1
- cymbal rides 1
- dance groove 1
- dance hits 1
- dance music 1
- digital drumming 1
- dj 1
- drum solo 1
- energetic 1
- enthusiastic 1
- female singer 1
- floor tom 1
- groovy acoustic guitar accompaniment 1
- heavy reverb 1
- instrumental 1
- intense drumming 1
- lively 1
- mallets 1
- percussion 1
- percussion solo 1
- slick drumming 1
- snare drum 1
- spirited 1
- synthesised vocals 1
- tom-toms 1
- vocal backup 1
- youthful 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bill Bruford Drum Solo | This music is a percussion solo. The tempo is fast with the drummer playing an energetic solo. The beat is vigorous, enthusiastic, spirited, infectious and punchy with a flourish of cymbals. | 2007-06-01T01:14:42Z | metalmasher | Bruford does a solo during a performance with his jazz group, Earthworks | ["Drum", "Drum kit", "Jazz", "Music"] | ["instrumental", "percussion", "percussion solo", "fast tempo", "enthusiastic", "bass drum", "tom-toms", "bass drum", "snare drum", "floor tom", "mallets", "auxiliary percussions", "intense drumming", "drum solo", "cymbal rides", "bright", "energetic", "punchy", "lively"] | 7 | oD0Xp--xxjE | 4611 | |
Sandra Lyng - Electric City (Official Music Video) | A female vocalist sings this spirited pop. The tempo is fast with a spirited, upbeat acoustic guitar accompaniment, synthesiser arrangements, slick drumming, digital drum rhythm, boomy bass drop , added reverb and auto tune for better effects.The song is young, fresh, upbeat, bouncy, punchy, and has a dance groove.this song is a synth pop. | 2014-08-15T16:57:07Z | Sandra Lyng | Offisiell musikkvideo til "Electric City", den nye singelen til Sandra Lyng. Electric City er tilgjengelig på alle digitale plattformer, last ned og stream singelen her: - iTunes: https://itunes.apple.com/no/album/electric-city-single/id893197707?l=nb - Spotify: http://open.spotify.com/album/27Axz7vCZGIw1w1bQgqtIP - Wimp: http://wimp.no/album/31787918 - SoundCloud: https://soundcloud.com/sandra-lyng/sandra-lyng-electric-city | ["Jazz", "Music", "Dance music"] | ["female singer", "fast tempo", "auto tune", "boomy bass drops", "slick drumming", "digital drumming", "dj", "dance hits", "dance music", "club music", "dance groove", "groovy acoustic guitar accompaniment", "atmospheric synthesiser", "synthesised vocals", "vocal backup", "heavy reverb", "punchy", "bouncy", "youthful", "buoyant", "boomy bass drops", "spirited"] | 7 | 33dCbb1MyYU | 439 |
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;