musiccaps_details (view)
9 rows where musiccaps_aspects contains "live performance", musiccaps_author = 4 and musiccaps_names contains "Jazz"
This data as json, CSV (advanced)
musiccaps_aspects (array) 53 ✖
- live performance · 9 ✖
- low quality 8
- noisy 6
- passionate 6
- groovy bass 4
- mono 4
- shimmering hi hats 4
- jazz 3
- soulful 3
- emotional 2
- energetic drums 2
- passionate female vocal 2
- punchy kick 2
- punchy snare 2
- acoustic guitar strummed chord 1
- acoustic rhythm guitar chords 1
- addictive 1
- alternative/indie 1
- crackling 1
- emotional female vocal 1
- energetic 1
- flute melody 1
- folk 1
- groovy double bass 1
- groovy piano melody 1
- hip hop 1
- jazz orchestra 1
- jazzy 1
- lip smack noise 1
- mellow keys chords 1
- mellow piano chords 1
- mellow piano melody 1
- r&b 1
- repetitive male vocal 1
- repetitive piano melody 1
- saxophone melody 1
- saxophone solo melody 1
- smooth bass 1
- snappy rimshots 1
- soft kick 1
- soft kick hits 1
- soft snare 1
- spanish guitar solo melody 1
- strings melody 1
- sustained strings 1
- synchronized brass melody 1
- tenor sax solo melody 1
- unbalanced stereo image 1
- upbeat 1
- uptempo 1
- vintage 1
- warm 1
- wooden percussive element 1
musiccaps_names (array) 15 ✖
- Jazz · 9 ✖
- Music 9
- Musical instrument 2
- Bluegrass 1
- Blues 1
- Brass instrument 1
- Guitar 1
- Harmonic 1
- Keyboard (musical) 1
- Piano 1
- Plucked string instrument 1
- Saxophone 1
- Singing 1
- Swing music 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lana Del Rey - Radio - Jazz Cafe London - 10.04.12 | The low quality recording features a live performance of a R&B song that consists of a mellow piano melody and an emotional female vocal singing over it. There are some noises in the recording, alongside lip smack noise. | 2012-04-12T04:33:59Z | knappafire | Live From The Jazz Cafe, Camden, London - 10.04.12 Artist reserves all rights. No copyright infringement intended. | ["Jazz", "Music"] | ["low quality", "mellow piano melody", "noisy", "lip smack noise", "r&b", "emotional female vocal", "live performance"] | 4 | -U16iKiXGuY | 50 | |
The Wild Reeds: NPR Music Tiny Desk Concert | The low quality recording features a live performance of an Alternative/Indie song and it consists of passionate female vocal singing over acoustic guitar strummed chord and wooden percussive element. The recording is noisy and the vocal is slightly moving throughout the stereo image making it unbalanced. It sounds passionate and emotional. | 2015-11-20T18:04:16Z | NPR Music | November 20, 2015 by BOB BOILEN Great singers aren't easy to come by, so finding three in one band is something special. The Wild Reeds' music shines when Sharon Silva, Kinsey Lee and Mackenzie Howe harmonize, but each also takes a leading role — and that's the power of the L.A. band, whose songs are clear and memorable, potent and sometimes delicate. The Wild Reeds' 2014 debut album Blind And Brave only hints at the talent on display here. Here, the group opens with my favorite song from the record, "Where I'm Going," and then offers a taste of 2016 with two new ones. Next year ought to be a big year for The Wild Reeds, and this Tiny Desk Concert will show you what I mean. Blind And Brave is available now. iTunes: https://itunes.apple.com/us/album/blind-and-brave/id907588390 Amazon: http://www.amazon.com/Blind-Brave-The-Wild-Reeds/dp/B00MKFKGES Set List "Where I'm Going" "Everything Looks Better In Hindsight" "The World We Built" Credits Producers: Bob Boilen, Morgan Walker; Audio Engineer: Josh Rogosin; Videographers: Morgan Walker, Nick Michael, Julia Reihs; Production Assistant: Kate Drozynski; Photo by Julia Reihs/NPR For more Tiny Desk Concerts, subscribe to our podcast: http://www.npr.org/podcasts/510292/tiny-desk-concerts-video | ["Jazz", "Music"] | ["low quality", "noisy", "alternative/indie", "wooden percussive element", "acoustic guitar strummed chord", "passionate female vocal", "emotional", "passionate", "live performance", "unbalanced stereo image"] | 4 | 0TiEO149Ydc | 173 | |
Rafael Lechowsky y la Banda de Jazz - Concierto Radio 3 | The Hip Hip songs live performance consists of repetitive male vocal singing over repetitive piano melody, smooth bass, shimmering hi hats and soft kick and snare hits. It sounds jazzy and warm. | 2008-04-19T22:10:21Z | MrSlowFlow23 | Rafael Lechowsky y la Banda de Jazz - Concierto Radio 3 | ["Jazz", "Music"] | ["hip hop", "live performance", "warm", "repetitive piano melody", "smooth bass", "repetitive male vocal", "shimmering hi hats", "soft snare", "soft kick", "jazzy"] | 4 | 3bg0iy-ypcw | 487 | |
Zdop si Zdup - Dj Vasile | The low quality recording features a live performance of folk songs played by flute, strings and energetic drums. The recording is noisy and in mono, as the audio is crackling and it sounds energetic and kind of addictive thanks to that flute and strings melody. | 2010-10-15T16:42:09Z | Ciprian BT | Zdop si Zdup - Dj Vasile | ["Jazz", "Music"] | ["low quality", "folk", "noisy", "mono", "flute melody", "strings melody", "energetic drums", "crackling", "live performance", "energetic", "addictive"] | 4 | 4mtfOkzOvBI | 606 | |
Thad Jones - Mel Lewis Jazz Orchestra "Us" | The low quality recording features a jazz orchestra live performance and it consists of synchronized brass melody played over energetic drums and groovy bass. The recording is vintage and therefore a bit noisy and in mono, but also passionate and upbeat. Sounds like something you would hear in old movies. | 2008-01-10T06:03:17Z | ilovebigband | Thad Jones - Mel Lewis Jazz Orchestra Live in TV Studio | ["Jazz", "Music"] | ["low quality", "noisy", "mono", "live performance", "jazz orchestra", "synchronized brass melody", "vintage", "energetic drums", "groovy bass", "passionate", "upbeat"] | 4 | 6lPgzqrvHHw | 785 | |
Fender Rhodes Mark VII | The low quality recording features a live performance of a jazz song and it consists of a saxophone solo melody played over mellow keys chords, groovy bass, punchy snare and kick hits and shimmering hi hats. It sounds passionate and soulful. | 2007-01-29T02:12:06Z | alex.rodrigues | Namm Show report on New Rhodes MK 7 http://www.rhodespiano.com/namm_info.htm | ["Jazz", "Music", "Keyboard (musical)", "Piano"] | ["low quality", "jazz", "live performance", "saxophone solo melody", "shimmering hi hats", "punchy kick", "punchy snare", "mellow keys chords", "groovy bass", "passionate", "soulful"] | 4 | Oe_xSG_ic-c | 2455 | |
Swing Amor "Rose Room" | The low quality recording features a live performance that consists of a Spanish guitar solo melody, groovy double bass and acoustic rhythm guitar chords. The recording is noisy, in mono and it sounds passionate and uptempo - like something you would dance to with your friends in a latin club. | 2008-12-02T16:54:14Z | hailletmusic | About SWING AMOR A gypsy swing band formed in 2004. Currently, the band performs in cafes and such based in Kumamoto Prefecture.In April 2006, their first album GYPSY SWING JAZZ was released. It includs 12 gems, from originals to standard Jazz tunes. In July 2007, they participated in a compilation album "DJANGO FESTIVAL4" which was released by a long-established Norwegian gypsy jazz label. In January 2009 the distribution of GYPSY SWING JAZZ will begin via iTunes stores in 22 nations. The recording of their second album, three years after the first, is scheduled as well. | ["Swing music", "Guitar", "Jazz", "Music", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["low quality", "spanish guitar solo melody", "live performance", "groovy double bass", "acoustic rhythm guitar chords", "noisy", "mono", "passionate", "uptempo"] | 4 | iUHqyjf3NcQ | 4191 | |
Shirley King - Let The Good Times Roll | The low quality recording features a live performance of a jazz song and it consists of a passionate female vocalist singing over groovy piano melody, saxophone melody, groovy bass, shimmering hi hats, punchy snare and soft kick hits. It sounds passionate, soulful and the recording is noisy and in mono. | 2008-11-26T05:14:33Z | Bob .Hampton | Daughter of the Blues Shirley King on B.B King's "Let The Good Times Roll". Performed at the VFW in Berwyn, IL at a benefit for Big Time Sarah's church | ["Blues", "Singing", "Jazz", "Music", "Harmonic"] | ["low quality", "live performance", "passionate female vocal", "groovy piano melody", "saxophone melody", "groovy bass", "shimmering hi hats", "punchy snare", "soft kick hits", "jazz", "passionate", "soulful", "noisy", "mono"] | 4 | mFcHGbnNtSQ | 4456 | |
Tony on Tenor Sax | The low quality recording features a live performance of a jazz song that consists of a tenor sax solo melody playing over mellow piano chords, sustained strings, groovy bass, snappy rimshots, shimmering hi hats and punchy kicks. It sounds emotional, passionate and soulful. | 2008-01-24T22:22:32Z | Tony Bolivar | Because of Who You Are | ["Brass instrument", "Jazz", "Music", "Musical instrument", "Wedding music", "Saxophone"] | ["low quality", "live performance", "jazz", "tenor sax solo melody", "groovy bass", "mellow piano chords", "shimmering hi hats", "punchy kick", "snappy rimshots", "sustained strings", "passionate", "emotional", "soulful"] | 4 | tuoBmxts5Xo | 5075 |
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;