musiccaps_details (view)
2 rows where musiccaps_aspects contains "brass melody", musiccaps_aspects contains "low quality", musiccaps_aspects contains "noisy", musiccaps_aspects contains "passionate" and musiccaps_author = 4
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 | |
Teen Opera Singer Aria Tesolin at 13 | The low quality recording features a live performance of an opera that consists of a passionate female vocal singing over strings melody, brass melody and mellow percussion. It sounds emotional and passionate. | 2007-05-17T22:15:55Z | Aria Tesolin | Teen opera singer, Aria Tesolin sings Mozart aria Voi Che Sapete. The teen talent's videos are Amazing 8 Year Old Child Opera Singing Sensation, Youngest Opera Singer in the World, & Teen Opera Singer Sings Puccini | ["Singing", "Music", "Opera", "Classical music"] | ["low quality", "noisy", "live performance", "opera", "passionate female vocal", "strings melody", "brass melody", "mellow percussions", "passionate", "emotional"] | 4 | hlHb9HwNxk8 | 4136 |
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;