musiccaps_details (view)
1 row where musiccaps_aspects contains "brass melody", musiccaps_aspects contains "emotional", musiccaps_aspects contains "passionate" and musiccaps_names contains "Bowed string instrument"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
La Pampa y la Puna - Peruvian Music serie. Kinsa Trio | The low quality recording features a groovy piano melody, mellow cello melody and brass melody. It sounds emotional and passionate, while the recording is noisy. | 2007-09-03T18:56:32Z | Marco Antonio Mazzini | ➡️ This score is for sale! If you want to perform this arrangement, please contact me at marcomazzini@clariperu.org La Pampa y la Puna is a short piece written by Peruvian composer Carlos Valderrama (1887-1950). Originally for voice and piano, I made this arrangement for my new Kinsa Trio (Belgium). This is the first of three Peruvian pieces we filmed specially for YouTube ("Himno al Sol" and "El Condor Pasa" are coming soon!). ________________________________________ In this video, Kinsa Trio are: Aygul Pribylovskaya, cello Marco Antonio Mazzini, clarinet&bass clarinet Ward De Vleeschhouwer, piano _______________________________________________________________ My Google+ https://plus.google.com/u/1/+MarcoAntonioMazziniclarinet Site: mazzini.clariperu.org Facebook page: www.facebook.com/marcoantoniomazzini/ | ["Cello", "Double bass", "Bowed string instrument"] | ["low quality", "groovy piano melody", "mellow cello melody", "brass melody", "noisy", "passionate", "emotional"] | 4 | hBT0bbJl1dU | 4083 |
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;