musiccaps_details (view)
4 rows where musiccaps_aspects contains "classical", musiccaps_aspects contains "live performance" and musiccaps_names contains "Double bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- classical · 4 ✖
- live performance · 4 ✖
- low quality 3
- noisy 2
- passionate 2
- cello 1
- cello strings melody 1
- chamber orchestra 1
- cover 1
- distorted 1
- double bass melody 1
- elegant 1
- emotional 1
- lively 1
- mono 1
- movie music 1
- passionate piano melody 1
- plucked cello melody 1
- rock 1
- strings section 1
- sustained cello melody 1
- sustained strings melody 1
- tarantella 1
- vibrant 1
- woodwinds melody 1
musiccaps_names (array) 6 ✖
- Bowed string instrument 4
- Cello 4
- Double bass · 4 ✖
- Orchestra 1
- String section 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kosower cello. Beethoven 7 variations - Mozart's Magic Flute | The low quality recording features a live performance of a classical song and it consists of sustained cello melody played over passionate piano melody, after which there is a plucked cello melody. It sounds emotional and passionate. | 2008-03-03T18:54:23Z | stodplatt | Mark Kosower, Concert Cellist, plays Beethoven seven variations in Eb major based on Mozart's Opera "The Magic Flute". Recorded April 6, 2003 for The Omega Ensemble at Fifth Avenue Presbyterian Church,NYC. http://www.OmegaEnsemble.com/ Mr. Kosower plays on a Stradivarius cello on loan from The Juilliard School. Doris Konig, piano. | ["Cello", "Double bass", "Bowed string instrument"] | ["low quality", "classical", "live performance", "passionate piano melody", "plucked cello melody", "sustained cello melody", "emotional", "passionate"] | 4 | dS8AZdmn8Wk | 3785 | |
Michelle - The Beatles | The low quality recording features a live performance of a classical cover of a rock song that consists of a cello strings melody playing.The recording is noisy, slightly distorted and in mono. | 2007-04-11T00:32:13Z | bronichka | 6th grade students from Advanced String Orchestra performed songs at the International Art Exhibition in our local school. (There were beautiful drawings and paintings by young students from Uganda, Kazachstan, China, etc.) Encouraging comments to our students are welcome. | ["Cello", "Double bass", "Bowed string instrument"] | ["low quality", "live performance", "rock", "classical", "cover", "cello strings melody", "noisy", "mono", "distorted"] | 4 | i6dFcfV64RE | 4159 | |
Johann Sebastian Bach concierto para clave en fa menor | The low quality recording features a live performance of a classical song that consists of a woodwinds melody, sustained strings melody and double bass melody. It sounds passionate and the recording is in mono and noisy. | 2009-03-31T03:44:15Z | Gisela Gregori - Clave y Piano | Johann Sebastian Bach 1685-1750 concierto para clave en fa menor BWV 1056 2do movimiento: Largo 3er movimiento: Presto Solista: Gisela Gregori 22 12 2009 Santa Rosa, La Pampa, Argentina | ["Cello", "Double bass", "Orchestra", "Violin, fiddle", "Bowed string instrument"] | ["low quality", "live performance", "noisy", "classical", "woodwinds melody", "sustained strings melody", "double bass melody", "passionate"] | 4 | mlrarQ5nVlU | 4491 | |
BOTTESINI, Tarantella | Božo Paradžik & Budapesti Vonósok | This is a live performance classical music piece played by a chamber orchestra. It is in the style of a tarantella, which is a genre of Italian folk music. The strings section is playing the melody with a cello as the lead. The atmosphere is lively and elegant. It could be used in the soundtrack of a movie especially during a scene involving a pursuit, a face-off or a duel. | 2015-07-30T22:18:34Z | bozoparadzikcom | Haydn Festival in Fertöd (H), LIVE 24th July 2015 (encore piece) Eszterházy Castle, Marionett Theater Giovanni Bottesini (1821-1889), Tarantella orchestrated and edited by Božo Paradžik Božo Paradžik, soloist Budapest Strings Chamber Orchestra / artistic leader: János Pilz (concertmaster) Dear visitors, please mind that I don't use Google+ with this account, so I am since 2014 not able to answer any comments or posts here anymore. I don't want to upgrade my channel to G+. End of July 2015 Google has announced to remove the enforcing of using G+ for YouTube users, but so far without any effect. | ["Cello", "Double bass", "String section", "Bowed string instrument"] | ["classical", "tarantella", "chamber orchestra", "live performance", "strings section", "cello", "lively", "vibrant", "elegant", "movie music"] | 9 | w0A-4EbkVz8 | 5228 |
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;