musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "swing" and musiccaps_names contains "Swing music" sorted by musiccaps_rowid
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 27 ✖
- swing · 2 ✖
- acoustic guitar 1
- alto 1
- animated vocals 1
- b3 1
- blues 1
- brass band 1
- cello bass 1
- choral harmony 1
- classic 1
- drum breaks 1
- empahtic vocals 1
- fast tempo 1
- female vocalists 1
- hammond organ 1
- jazz 1
- jazz electric guitar 1
- lively cello 1
- lively trumpets 1
- male vocalist 1
- melodic 1
- mezzo-soprano 1
- organ trio 1
- slick drumming 1
- soprano 1
- steady ride pattern 1
- swing beat 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
You Upset Me - The Jesse Deane-Freeman Trio | A jazz organ trio playing a swing blues song with a male singer accompanied by electric guitar, Hammond organ, a steady ride pattern on the cymbals. The whole band hits on beat one with the drum breaks, as is common in this style of music. | 2009-07-20T16:02:59Z | Jesse Deane-Freeman | Jesse Deane-Freeman on Hammond organ, Sav Palakstoglou on guitar and Mick Garcia on drums at the Lion Hotel, North Adelaide, South Australia - filmed by Andrew Ingham | ["Singing", "Swing music", "Guitar", "Music"] | ["jazz", "swing", "blues", "jazz electric guitar", "male vocalist", "drum breaks", "organ trio", "hammond organ", "b3", "steady ride pattern"] | 8 | CD3OyaDW348 | 1342 | |
Royals - Lorde - Vintage/Swing Cover by Flash Mob Jazz ft Lady Armstrong | A group of female vocalists sing this enthusiastic swing song. The tempo is fast with bright trumpet harmony, cello , rhythmic acoustic guitar and slick drumming. The song is upbeat with vocal emphasis and a lively orchestra. This song is a Classic Swing. | 2015-07-09T13:46:23Z | Flash Mob Jazz | *Subscribe for more modern Covers Coming Soon* EP OUT NOW: http://flashmobjazz.bandcamp.com/releases We collaborated with the stunning Lady Armstrong team to creating this fun cover of Royals by Lorde! Check out our Digital albums at www.flashmobjazz.bandcamp.com Thanks for all the support! Website: www.flashmobjazz.com Instagram: @flashmobjazz Facebook: www.facebook.com/FlashMobJazz Twitter: @flashmobjazz Bandcamp: www.flashmobjazz.bandcamp.com Please direct all inquiries to: flashmobjazz@hotmail.co.uk Special thanks to Worthing Theatres and Lee Payne! Audio production: http://www.benjaminjamesrecording.com/ | ["Singing", "Swing music", "Jazz", "Music"] | ["female vocalists", "fast tempo", "choral harmony", "mezzo-soprano", "cello bass", "lively trumpets", "brass band", "slick drumming", "swing beat", "swing", "animated vocals", "melodic", "empahtic vocals", "alto", "soprano", "classic", "lively cello", "acoustic guitar"] | 7 | CWKBzt-v8w4 | 1372 |
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;