musiccaps_details (view)
3 rows where musiccaps_aspects contains "orchestral accompaniment", musiccaps_author = 8 and musiccaps_names contains "Singing"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Sarah Brightman performing 'Music Of the Night' at Queen Mother's 90th Birthday Gala 1990 | Dramatic female opera singer accompanied by orchestra and brass and cymbal crash. | 2010-06-23T02:57:11Z | tapesalvage | Sarah Brightman performing 'Music Of the Night' from Phantom Of the Opera at Queen Mother's 90th Birthday Gala 1990 | ["Singing", "Music", "Opera", "Classical music"] | ["opera", "dramatic", "cymbal crash", "orchestral brass", "orchestral accompaniment"] | 8 | XUzaEsoOlWQ | 3187 | |
| Amira Willighagen - O Mio Babbino Caro - Andre Rieu - Maastricht - July 2014 | A female opera singer accompanied by an orchestra featuring string bass, harp and string ensemble. It sounds like it was performed in a concert hall. Dramatic. | 2014-07-13T11:01:00Z | pa1189j | ["Singing", "Music", "Opera"] | ["opera", "female singer", "orchestral accompaniment", "string bass", "harp", "string ensemble", "concert hall reverb", "dramatic"] | 8 | Z0htOHTOtHY | 3336 | ||
| Winter Wonder - The Florin Street Band - Original Christmas Songs | Cheery and joyous music which would fit well in a musical. Complex vocal arrangements with female background vocals, male and female lead vocalists singing in unison one octave apart. Piano, electric bass, and orchestral accompaniment drive the compound meter. | 2013-12-15T17:50:47Z | The Florin Street Band | If you've got Christmas in your heart, please subscribe and share our Christmas songs! Follow us on Spotify: http://bit.ly/spoti-band Christmas on Facebook: http://bit.ly/face-band Twitter: http://bit.ly/twitter-band @florinstreet Instagram: http://bit.ly/insta-band Official website: http://www.florinstreet.com Made independently with no industry support; The Winter Wonder is a Christmas celebration in a town where music is paramount and Christmas is in everyone’s heart. As part of the story, the good people of Florin Street come together for a night of festive music and dancing with The Florin Street Band. See how this Christmas video was made here: http://youtu.be/MKfJP5gAI5o Winter Wonder is now available to download at iTunes and the three-track E.P. also includes the video edit of My Favourite Time of Year. Look out for more music from The Florin Street Band soon! ©Calmsound 2022 Production companies: Cinematica Media & Walk Tall Media Directed by Jackson Kingsley Location: Englishcombe Tithe Barn, Bath - by kind permission of the Walker family. Leigh would like to thank everybody involved in helping make this video - the full credits list can be seen here.: https://www.florinstreet.com/winter-wonder Band: Leigh Haggerwood - Song, Vocals, Piano Vaughan Jones - Violin Bryony Purdue - Vocals Nina Clarke - Vocals Poppy Pitt - Vocals Nina Garcia - Vocals Beth Porter - Vocals, Cello Ben Please - Vocals, Guitar Harry Palmer - Vocals, Drums Will Hyde - Double Bass Cliff Elliott - Vocals Winter Wonder Words & Music by Leigh Haggerwood Verse 1 Some have lots to say, Some have started singing, Some already had a few jars! We all share a wonderful thing; All love what this season brings. A smiling face; as Christmas bells are ringing, They chime with every beat of our hearts. At this wonderful time, the magic is ours! We've got Christmas on our minds and in our hearts, 'cause it's in our hearts... Chorus Winter, Wonder, dancing through the night 'till the sun comes up, Older younger, just celebrate and… | ["Christmas music", "Singing", "Music", "Independent music"] | ["cheery", "joyous", "musical", "complex vocal arrangement", "piano", "electric bass", "compound meter", "male lead vocalist", "female vocalist", "unison", "orchestral accompaniment", "female background vocals"] | 8 | ZYUAY6EN05Q | 3390 |
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;