musiccaps_details (view)
2 rows where musiccaps_aspects contains "emphatic", musiccaps_aspects contains "jazz" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- ambient 2
- emphatic · 2 ✖
- improvisation 2
- jazz · 2 ✖
- jazz drumming 2
- polyrhythms 2
- atmospheric 1
- bass drum 1
- blue notes 1
- blues 1
- cello 1
- complex chords 1
- deliberate dissonance 1
- elegant 1
- groovy 1
- groovy bass line 1
- heavy bass line 1
- instrumental 1
- intense 1
- jazz piano 1
- lively 1
- male vocalist 1
- medium tempo 1
- saxophone 1
- slow tempo 1
- swing 1
- syncopated harmony 1
- syncopated melody 1
- tambourine beats 1
- trombone 1
- trumpets 1
- vocal backup 1
musiccaps_names (array) 3 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Robert Glasper Experiment - Gonna Be Alright (F.T.B.) [feat. Ledisi] | A male vocalist sings this Jazz melody. The tempo is medium with a jazz style piano and drumming, groovy bass line, tambourine beats and vocal backup. The harmony is syncopated and complex. It is ambient, atmospheric, punchy, emphatic and enjoyable. | 2012-02-28T08:08:40Z | meandoughgreen | Album: Black Radio (2012). | ["Soul music"] | ["male vocalist", "medium tempo", "jazz", "jazz piano", "jazz drumming", "groovy bass line", "vocal backup", "syncopated harmony", "complex chords", "improvisation", "deliberate dissonance", "tambourine beats", "blue notes", "polyrhythms", "ambient", "atmospheric", "emphatic"] | 7 | nlWXsfjHeA8 | 4574 | |
Thats All Me Bro! | This music is a Jazz instrumental. The tempo is slow with emphatic brass and wind instrumentation, with cello and jazz drumming. The trumpets are emphatic with a lively trombone riff. The other instruments add a rich, dense layer to the music. It is intense, complex, ambient, groovy and pleasant. This music is a Jazz instrumental.5. | 2014-10-25T07:37:25Z | CharlesAlatorre | VLOG CHANNEL: https://www.youtube.com/user/CharlesAlatorre2 Christina (Girl In the Video): https://twitter.com/xtinnnnna http://instagram.com/xtinnnnna Travis's Channel: https://www.youtube.com/user/TravieBASED TWITTER: http://twitter.com/CharlesAlatorre INSTAGRAM: CharlesAlatorre LIKE MY FACEBOOK PAGE: http://www.facebook.com/CharlesAlatorreTV FACEBOOK: http://www.facebook.com/CharlesAlatorre Royalty Free Music By: http://www.audiomicro.com/royalty-free-music | ["Brass instrument", "Saxophone"] | ["instrumental", "slow tempo", "trumpets", "saxophone", "emphatic", "groovy", "ambient", "jazz", "intense", "elegant", "jazz drumming", "lively", "polyrhythms", "blues", "swing", "bass drum", "trombone", "cello", "heavy bass line", "syncopated melody", "improvisation"] | 7 | p1-07VdP__Q | 4676 |
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;