musiccaps_details (view)
3 rows where musiccaps_aspects contains "brass melody" and musiccaps_aspects contains "groovy piano melody" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- brass melody · 3 ✖
- groovy piano melody · 3 ✖
- low quality 3
- groovy bass 2
- happy 2
- clapping 1
- emotional 1
- energetic 1
- fun 1
- joyful 1
- live performance 1
- mellow cello melody 1
- microphone boomy feedback 1
- noisy 1
- passionate 1
- passionate male vocal 1
- punchy snare 1
- regional mexican 1
- shimmering hi hats 1
- suspenseful 1
- tinny metallic percussions 1
- wooden percussions 1
musiccaps_names (array) 7 ✖
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 | |
Hoy yo te pido perdon salsa | The low quality recording features a regional Mexican song that consists of a passionate male vocal singing over brass melody, wooden percussions, tinny metallic percussions, groovy piano melody and groovy bass. It sounds joyful, happy and energetic. | 2009-04-08T06:41:41Z | Edgarcet17 | Salsa romantica hoy yo te pido perdon los chicos de la salsa | ["Music", "Music of Latin America", "Salsa music"] | ["low quality", "regional mexican", "brass melody", "wooden percussions", "tinny metallic percussions", "groovy piano melody", "groovy bass", "passionate male vocal", "joyful", "happy", "energetic"] | 4 | c3T1gWSVp6c | 3676 | |
Briana Babineaux - Power In The House & Fill Me Up | The low quality recording features a live performance that consists of shimmering hi hats, claps, groovy bass, groovy piano melody, brass melody and punchy snare. In the second half of the loop, there is a boomy microphone feedback, which makes a happy and fun atmosphere a bit suspenseful. | 2015-07-28T01:06:29Z | Joshua Moody | Briana Babineaux singing "Power In The House" and "Fill Me Up" | ["Folk music", "Music"] | ["low quality", "live performance", "microphone boomy feedback", "clapping", "shimmering hi hats", "groovy bass", "brass melody", "groovy piano melody", "punchy snare", "happy", "fun", "suspenseful"] | 4 | DXeiJpZXVAI | 1490 |
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;