musiccaps_details (view)
10 rows where musiccaps_aspects contains "jazz", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 52 ✖
- jazz · 10 ✖
- live performance · 10 ✖
- passionate · 10 ✖
- low quality 9
- shimmering hi hats 8
- groovy bass 5
- noisy 5
- punchy kick 5
- punchy snare 4
- emotional 3
- groovy 3
- groovy double bass 3
- soulful 3
- funky 2
- groovy piano chords 2
- groovy piano melody 2
- mellow piano chords 2
- mono 2
- passionate female vocal 2
- saxophone solo melody 2
- audio crackles 1
- big bend 1
- chill 1
- clarinet solo melody 1
- easygoing 1
- electric guitar melody 1
- energetic cymbals 1
- fun 1
- funky electric guitar melody 1
- groovy rhodes keys melody 1
- happy 1
- intimate 1
- manic tom roll 1
- mellow brass melody 1
- mellow keys chords 1
- mellow kick hits 1
- organ keys chords 1
- passionate trumpet melody 1
- reverberant 1
- saxophone melody 1
- shimmering cymbals 1
- smooth double bass 1
- snappy rimshots 1
- soft kick hits 1
- sustained strings 1
- synth pad 1
- tenor sax solo melody 1
- trombone solo 1
- unbalanced stereo 1
- upbeat 1
- warm 1
- wide passionate harmonizing male vocals 1
musiccaps_names (array) 26 ✖
- Brass instrument 4
- Music 4
- Jazz 3
- Trombone 3
- Keyboard (musical) 2
- Piano 2
- Saxophone 2
- Bass drum 1
- Blues 1
- Clarinet 1
- Cowbell 1
- Drum 1
- Drum kit 1
- Electric piano 1
- Electronic organ 1
- Harmonic 1
- Lullaby 1
- Musical instrument 1
- Organ 1
- Percussion 1
- Rimshot 1
- Singing 1
- Ska 1
- Snare drum 1
- Trumpet 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 |
---|---|---|---|---|---|---|---|---|---|---|
Sleepy Time Down South | The low quality recording features a live performance of a jazz song that consists of a clarinet solo melody played over groovy piano, mellow brass melody, shimmering hi hats and mellow kick hits. It sounds emotional, easygoing and chill. | 2007-06-23T22:34:36Z | glengillo | Another clip from the Carling family at the Stockamollan Jazz Festival in June 2007, playing the old Louis Armstrong classic "When it's Sleepy Time Down South". With such tight ensemble playing it would be wrong to pick out any particular soloist -- they are all great! | ["Brass instrument", "Clarinet", "Trombone", "Trumpet"] | ["low quality", "live performance", "jazz", "clarinet solo melody", "mellow brass melody", "groovy piano melody", "shimmering hi hats", "mellow kick hits", "passionate", "emotional", "easygoing", "chill"] | 4 | 588osm3C4bw | 635 | |
Brian Auger - Compared to what (Live at Baked Potato) | The low quality recording features a live performance of a jazz song and it consists of a groovy bass guitar, groovy rhodes keys, electric guitar melody, shimmering hi hats, punchy kick and punchy snare hits. It sounds groovy, funky and passionate. The recording is noisy and in mono. | 2011-11-22T14:17:10Z | Bluedreams | The Brian Auger's Oblivion express live at "Baked Potato", Hollywood 2004. The Band is: Brian Auger - Hammond Organ, Keyboards and Electric piano Savannah Grace Auger - Vocals Derek Frank - Bass Karma D. Auger - Drums | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | ["low quality", "jazz", "live performance", "mono", "noisy", "groovy bass", "groovy rhodes keys melody", "electric guitar melody", "shimmering hi hats", "punchy kick", "punchy snare", "funky", "groovy", "passionate"] | 4 | CrkxrgTiVyk | 1410 | |
Lullaby of Birdland - Shearing & Weiss - Nasiya Alzhanova | The low quality recording features a live performance of a jazz song and it features a passionate female vocal singing over shimmering hi hats, groovy piano chords and smooth double bass. The recording has some audio crackles and that would be the only reason for it to go under the "low quality" category. It sounds emotional, passionate and groovy. | 2014-07-17T20:13:49Z | accademiadelsuono | Nasiya Alzhanova is a Modern Music Singing Course student. Nasiya studies Singing with Leyla Tommasi. Nasiya Alzhanova è iscritta al Corso di Canto Moderno. Nasiya studia canto con Leyla Tommasi. | ["Music", "Lullaby"] | ["low quality", "jazz", "passionate female vocal", "groovy piano chords", "smooth double bass", "shimmering hi hats", "audio crackles", "live performance", "emotional", "passionate", "groovy"] | 4 | ETl0hYRlVmg | 1562 | |
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 | |
Welcome to Big Band Music - Swing and Jazz in Denmark | The low quality recording features a live performance of a jazz big bend that consists of passionate trumpet melody, over groovy double bass, shimmering cymbals and mellow piano chords. It sounds reverberant, happy, passionate and fun. The recording is a bit noisy and the sound is leaning towards the right channel, which makes the stereo image unbalanced. | 2010-02-04T21:07:14Z | Kurt Lykke Lindved | Randers Big Band is one of the best Big Bands in Denmark with more More than 30 years experience in the fields of swing, jazz and musicals - A dynamic band and popular in a greater part of the world. The repertoire is wide spread in styles and performances including the music from evergreens to our today`s modern tunes in swing and jazz. Several famous vocalists have been performing with the band and a yearly tradition like the New Year`s Brunch Concert is always popular and visited again and again by the same audience including the newcomers. | ["Brass instrument", "Saxophone", "Trombone"] | ["low quality", "noisy", "live performance", "unbalanced stereo", "reverberant", "passionate trumpet melody", "jazz", "big bend", "shimmering cymbals", "mellow piano chords", "groovy double bass", "passionate", "happy", "fun"] | 4 | S0W_zIUYwrE | 2733 | |
Jon Cleary - When You Get Back (Live at Jazz Fest 2007) | The low quality recording features a live performance of a jazz song that consists of a wide passionate, harmonizing male vocals singing over punchy snare and kick hits, shimmering hi hats, groovy bass guitar, synth pad and funky electric guitar melody. It sounds funky, groovy and passionate. | 2009-04-24T23:01:22Z | Jon Cleary | Jon Cleary live at the New Orleans Jazz & Heritage Festival Follow Jon https://www.facebook.com/jonclearymusicofficial/ https://www.instagram.com/jonclearymusic/ https://twitter.com/jonclearymusic http://www.bandsintown.com/JonCleary | ["Ska"] | ["low quality", "noisy", "jazz", "live performance", "synth pad", "groovy bass", "funky electric guitar melody", "wide passionate harmonizing male vocals", "punchy kick", "punchy kick", "shimmering hi hats", "funky", "groovy", "passionate"] | 4 | _y07ENAx2_E | 3503 | |
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 | |
Jazz Cimbasso - Donna Lee, WDR Big Band featuring Mattis Cederberg | The low quality recording features a live performance of a jazz song and it consists of groovy double bass, trombone solo and shimmering hi-hats. The recording is a bit noisy and it sounds warm, intimate and passionate. | 2012-01-20T22:52:27Z | cimbassonista | Here's an arrangement of Donna Lee by Michael Philip Mossman. The WDR Big Band featuring me on cimbasso. As always, I play the HAAG cimbasso. | ["Brass instrument", "Trombone"] | ["low quality", "noisy", "intimate", "live performance", "jazz", "trombone solo", "groovy double bass", "shimmering hi hats", "passionate", "warm"] | 4 | p1DNl8BF49U | 4677 | |
Shirazette Tinnin - Inner Frustration | The low quality recording features a jazz live performance that consists of saxophone solo melody played over energetic cymbals, manic tom roll, punchy snare and kick hits, organ keys chords, groovy double bass and groovy piano chords. It sounds passionate and upbeat. | 2012-08-16T17:50:49Z | Latin Percussion | Shirazette Tinnin visits the LP studio to perform "Inner Frustration." Drums: Shirazette Tinnin Piano : Willerm Delisfort Piano: Rachel Eckroft Guitar: Seth Johnson Bass: Tom DiCarlo Saxophone: Camille Thurman LP LP204A Black Beauty Cowbell LP204A LP Americana Series Peruvian Cajon LP1439 | ["Cowbell", "Drum", "Drum kit", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["live performance", "jazz", "saxophone solo melody", "manic tom roll", "energetic cymbals", "punchy snare", "organ keys chords", "groovy double bass", "punchy kick", "groovy piano chords", "passionate", "upbeat"] | 4 | t1ULMDpL35I | 4998 | |
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;