musiccaps_details (view)
4 rows where musiccaps_author = 8 and musiccaps_names contains "Trumpet"
This data as json, CSV (advanced)
Suggested facets: musiccaps_names, youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Canadian Brass: "Perfect Landing" CD Discussion | A brass ensemble playing a fast piece with a quick tempo and virtuosity. Male voice over. | 2015-11-05T14:10:33Z | Canadian Brass | "Perfect Landing," the new Canadian Brass album to be released Nov. 6th by Opening Day Entertainment, comes after the wildly successful album "Takes Flight". This discussion is a rare insight into the making of a groundbreaking album which will feature a slew of new compositions, new arrangements and audience favourites. | ["Brass instrument", "French horn", "Trombone", "Trumpet"] | ["fast", "quick tempo", "brass ensemble", "male voice over", "virtuosity"] | 8 | 86YDiQjYU1U | 897 | |
| Euphonium Solo | Quick, forceful wind ensemble music featuring a horn solo with brass, tuba, bass drum and snare drum accompanying. | 2007-09-17T18:54:27Z | tubajs | Barry Morrison playing with Imperial Brass (Jeff Schultz-Conductor) "A Better World | ["Brass instrument", "Foghorn", "Music", "Musical instrument", "Orchestra", "Trumpet", "Classical music"] | ["horn solo", "wind ensemble", "brass", "bass drum", "snare drum", "tuba", "quick tempo", "forceful"] | 8 | DTkKGYCRMlc | 1478 | |
| Ewald - Quintet No. 1, I. Moderato | A live recording of a brass ensemble in a chamber style arrangement. Natural reverb from a recital hall is present. The music features counterpoint amongst the different instruments, and the mood is stately and noble. | 2010-03-03T22:12:00Z | FlatironsBrass | ["Brass instrument", "French horn", "Trombone", "Trumpet"] | ["live recording", "recital hall", "natural reverb", "brass ensemble", "chamber music", "stately", "noble", "counterpoint"] | 8 | dzW5M4sCphI | 3833 | ||
| Arturo & Doc Solos.mp4 | a latin jazz ensemble performing in a recital hall. A trumpet solo is accompanied by acoustic bass, syncopated drums and piano. The rhythm is upbeat and danceable. You can hear the reverb of the recital hall as well as audience sounds, someone sneezing. | 2010-11-29T02:19:26Z | jazzman1222 | This is my second Video of Doc and Arturo at the Rafael Mendez Trumpet Festival in Mexico City. Hard to believe that Doc is 83, he still has a wonderful sound!!! Arturo is still burnin´as usual!! | ["Brass instrument", "Jazz", "Music", "Musical instrument", "Trumpet", "Inside, large room or hall"] | ["latin jazz", "trumpet solo", "acoustic bass", "recital hall", "reverb", "audience sounds", "sneeze", "piano", "syncopated drums", "upbeat rhythm", "danceable"] | 8 | eiyyoUt64Zc | 3894 |
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;