musiccaps_details (view)
3 rows where musiccaps_aspects contains "cello", musiccaps_aspects contains "live performance" and musiccaps_names contains "Double bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- cello · 3 ✖
- live performance · 3 ✖
- string quartet 2
- viola 2
- violin 2
- acoustic guitar strumming 1
- chamber orchestra 1
- cheerful 1
- classical 1
- classical music 1
- composer 1
- dance music 1
- dramatic 1
- elegant 1
- enthusiastic 1
- exciting 1
- gloomy 1
- impressionist 1
- instrumental 1
- instrumental music 1
- lively 1
- medium tempo 1
- movie music 1
- party music 1
- passionate 1
- poor audio quality 1
- profound 1
- string harmony 1
- string trio 1
- strings section 1
- studio performance 1
- tarantella 1
- vibrant 1
- wedding music 1
- western classical music 1
musiccaps_names (array) 5 ✖
- Bowed string instrument 3
- Cello 3
- Double bass · 3 ✖
- Violin, fiddle 2
- String section 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Claude Debussy: Quartet in G Minor, Op. 10 - 4th Mvmt. | This is a live performance of a classical music piece from the impressionist school. It is being performed by a string quartet of two violins, one viola and one cello. The quartet is playing a dramatic tune. The atmosphere is gloomy. This piece could be used in the soundtrack of a drama movie during tragic scenes. | 2006-12-05T01:46:20Z | mashaskripka | Debussy Quartet in G Minor, Op. 10 Tres modere -- tres mouvemente et avec passion. First Violin - Maria Bessmeltseva, second violin - Paris Paraschoudis, Viola - Jesse Griggs, Cello - Heather Scott | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["classical music", "live performance", "impressionist", "instrumental", "string quartet", "violin", "viola", "cello", "dramatic", "profound", "gloomy"] | 9 | WSMdqFEjGXE | 3095 | |
J.Mouret - Rondeau String Quartet | The song is an instrumental. The song is medium tempo with a violin, viola, cello playing a string harmony accompanied by an acoustic guitar strumming chords. The song is a western classical music piece. | 2012-06-04T17:03:48Z | cellony | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["violin", "viola", "cello", "acoustic guitar strumming", "poor audio quality", "wedding music", "party music", "string quartet", "string trio", "string harmony", "instrumental music", "western classical music", "live performance", "studio performance", "medium tempo", "exciting", "cheerful", "dance music", "composer", "enthusiastic", "passionate", "exciting"] | 1 | fxznho_kNPY | 3995 | ||
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;