musiccaps_details (view)
5 rows where musiccaps_aspects contains "live recording" and musiccaps_aspects contains "piano"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- live recording · 5 ✖
- piano · 5 ✖
- low quality recording 2
- acoustic song 1
- active drums 1
- amateur band 1
- bass 1
- bongo drums 1
- boomy 1
- brass instruments 1
- calming 1
- choral singing 1
- clarinet 1
- crowd noise 1
- drum kit 1
- drum roll 1
- electric bass 1
- emotional 1
- humming 1
- hymnal singing 1
- instrumental 1
- latin american music 1
- live performance 1
- low fidelity 1
- moderate tempo 1
- outro 1
- percussion 1
- piano trio 1
- pretty piano 1
- quirky sounds from the crowd 1
- rock and roll 1
- salsa 1
- saxophone 1
- sidestick 1
- soothing 1
- spanish 1
- spanish speaking 1
- trumpet 1
musiccaps_names (array) 15 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Humming Chorus from Madam Butterfly | The clip features a choir singing a hymnal type of song. This was recorded live. There's a piano accompanying the choir. They are humming in a gentle and angelic way. | 2008-01-22T11:58:42Z | FrnkF5 | Preston Opera chorus sing the "Humming Chorus" from Puccini's opera Madam Butterfly. Performed in St. John's Minster Preston.Now check out Triumphal March from Aida by Preston Opera | ["Humming", "Music"] | ["choral singing", "live recording", "low quality recording", "humming", "piano", "hymnal singing"] | 3 | 1uHF1-8TcEk | 317 | |
Ya te olvide - Son Tentación // Mulata Salsa Club | This is a live recording of the outro of a latin american salsa song. There are brass instruments like the saxophone and trumpet. There is a man who speaks in Spanish once the music stops. It was the end section or outro of a song. | 2015-05-21T06:59:37Z | Mulata Salsa | https://www.facebook.com/MulataSalsaClub Son Tentación@Ya te olvide MULATA SALSA CLUB | ["Singing", "Music", "Speech", "Music of Latin America", "Salsa music"] | ["latin american music", "salsa", "spanish", "outro", "brass instruments", "saxophone", "trumpet", "spanish speaking", "live recording", "live performance", "bongo drums", "drum roll", "piano"] | 3 | FYux89o7Hhk | 1649 | |
2) Guy Dangain Master Class en Turquie Concertino Opus 26 de weber pour clarinette | Here we have a gentle and soothing instrumental piece on the piano and clarinet. The pianist plays an accompaniment to the lead melody of the clarinet - which feels like a relaxing afternoon at the beach. This is a live recording. | 2009-10-13T19:03:42Z | MICHELMUSIK123 | Concertino Opus 26 de weber pour clarinette Guy Dangain Master Class en Turquie Académie de Musique UMA Urla Guy Dangain est clarinettiste, concertiste international, Professeur au Conservatoire National Supérieur de Musique de Paris, Professeur à l'Ecole Normale de Musique de Paris - Soliste à l'Orchestre National de France. Il est aussi Directeur de l'Académie du Haut-Bugey en Rhône Alpes. UMA URLA Müzik Akademisi le 29 septembre 2009. Ont également participé à cette Académie de Musique: Andras Adorjan Professeur de flûte à Munich (Professor in München - Flöte) Hans Jörg Schellenberger Hautboïste à l'Orchestre Philharmonique de Berlin (Oboe im Berliner Philharmoniker) Heidi Litschauer violoncelliste (Cello) au Mozarteum de Salzbourg Andrée Sommer pianiste (Klavier) au CNSM de Paris. Vidéo de M. Guy Dangain | ["Brass instrument", "Clarinet", "Wind instrument, woodwind instrument"] | ["clarinet", "piano", "live recording", "calming", "soothing", "emotional"] | 3 | PRRcVdXsBQg | 2536 | |
Rock-Jerry & The Sounds 2014 Taarasti | This rock and roll song is a live recording of low quality. This features a male voice singing the main melody. This is accompanied by percussion playing a simple melody in common time. The bass plays a rock and roll bassline. The keyboard plays chords and fills using a piano tone. An acoustic guitar plays chords. A voice from the crowd sings a quirky sound at the beginning of the second bar. This song can be used in a retro movie in a music festival or carnival scene. | 2014-10-21T16:53:27Z | seti kolj | Kunnianosoitus Suomalaisen rockin pioneerille | ["Music", "Punk rock", "Psychedelic rock", "Rock music", "Rock and roll", "Bluegrass"] | ["rock and roll", "live recording", "low quality recording", "amateur band", "acoustic song", "bass", "quirky sounds from the crowd", "piano", "percussion", "moderate tempo"] | 0 | b8okzVltB5Q | 3604 | |
Karla Urias singing Amazing Grace w/Gospel Choir | A live recording of an instrumental piano trio. The recording is boomy and low fidelity. The drumming is active and the piano playing is pretty. The drum kit features a sidestick. Electric bass is also present. Crowd noise can be heard. Sounds like gospel music that might be heard at a church service. | 2007-07-31T04:49:03Z | Karla Urias | This was the Gospel Choir + Me singing Amazing Grace 7-29-2007 @ the Fairbanks Summer Arts Festival | ["Gospel music", "Music"] | ["live recording", "boomy", "low fidelity", "piano trio", "instrumental", "drum kit", "sidestick", "piano", "electric bass", "active drums", "pretty piano", "crowd noise"] | 8 | gAURHUoIK0M | 4011 |
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;