musiccaps_details (view)
2 rows where musiccaps_aspects contains "jazz piano" and musiccaps_aspects contains "medium tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- ambient 2
- jazz 2
- jazz piano · 2 ✖
- medium tempo · 2 ✖
- syncopated harmony 2
- animated piano 1
- atmospheric 1
- blue notes 1
- blues 1
- brass instruments 1
- complex chords 1
- deliberate dissonance 1
- emphatic 1
- groovy bass line 1
- groovy bass lines 1
- improvisation 1
- improvisations 1
- jazz drumming 1
- male singer 1
- male vocalist 1
- pleasant 1
- polyrhythms 1
- romantic 1
- saxophone accompaniment 1
- slick drumming 1
- swing 1
- tambourine beats 1
- trumpets 1
- vocal backup 1
- wind instruments 1
musiccaps_names (array) 4 ✖
- Music 1
- Song 1
- Soul music 1
- Swing music 1
youtube_published (date) 2 ✖
- 2008-11-13 1
- 2012-02-28 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Straighten up and Fly Right-SWING SUPREME | A male vocalist sings this mellow jazz song. The tempo is medium with a spirited saxophone accompaniment, jazzy piano, groovy bass lines, slick drumming and trumpet . The song is melodic, catchy, ambient, romantic, groovy, light and breezy with a swing rhythm. This song is a lively Jazz song. | 2008-11-13T17:49:53Z | Ian Boyter | A swing standard recorded by the Edinburgh Band Swing Supreme. www.swingsupreme.co.uk | ["Swing music", "Music", "Song"] | ["male singer", "medium tempo", "jazz piano", "trumpets", "romantic", "pleasant", "saxophone accompaniment", "wind instruments", "brass instruments", "slick drumming", "groovy bass lines", "animated piano", "swing", "jazz", "blues", "ambient", "pleasant", "syncopated harmony", "improvisations"] | 7 | CphwhKgYHaM | 1405 | |
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 |
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;