musiccaps_details (view)
3 rows where musiccaps_aspects contains "conductor", musiccaps_aspects contains "emotional" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- conductor · 3 ✖
- emotional · 3 ✖
- poor audio quality · 3 ✖
- instrumental music 2
- medium tempo 2
- philharmonic orchestra 2
- western classical music 2
- building anticipation 1
- cellist 1
- cello concerto 1
- classic composers 1
- concert hall 1
- crouching bass line 1
- dance like 1
- dramatic 1
- dvorak 1
- dynamics 1
- eerie 1
- flutes playing 1
- forever classics 1
- great composers 1
- great technique 1
- groovy music 1
- haunting 1
- horn section 1
- in love 1
- instrumental 1
- live audience 1
- live performance 1
- love song 1
- lullaby 1
- melancholic 1
- movie soundtrack 1
- no percussion instruments 1
- opera hall 1
- passionate 1
- piano playing 1
- piano solo 1
- poignant 1
- retro movie soundtrack 1
- spirited 1
- spooky movie 1
- string section 1
- string section harmony 1
- suspense 1
- timpani bangs loud 1
- violins playing harmony 1
- virtuously 1
- western classical masterpieces 1
- wind sections 1
- winter 1
musiccaps_names (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Winchester Mystery House Documentary (1963) - Lillian Gish | The song is an instrumental soundtrack. The tempo is medium with a string section harmony, horn section, flutes playing , violins playing and lower harmony played judiciously. The song is haunting and full of suspense. The song is a vintage suspense movie soundtrack. | 2015-02-18T06:50:32Z | stevers62 | This is the 1963 documentary (narrated by Lillian Gish) of the Winchester Mystery House. It's fascinating to see it as it was in 1963, and Lillian's narration is great. Hope you enjoy! Another YouTube user was kind enough to upload a version of this a couple years ago, and I found it fascinating. The only problem was the original source material was fairly washed out, and the full color network logo was extremely distracting. I made it black-and-white and increased the contrast to make it easier to see the material. It's still not great, but the content is so fascinating, historic, and spooky, it's still great viewing. If whoever posted the original wants to re-post this version, please just download and ping me and I'll take this one down. Just hoping to share this fascinating documentary. By the way, if you can redirect this to a 3-D television, it really gives a much better sense of depth and interest. | ["Foghorn", "Music", "Outside, urban or manmade"] | ["poor audio quality", "movie soundtrack", "haunting", "eerie", "string section harmony", "flutes playing", "crouching bass line", "horn section", "conductor", "instrumental", "suspense", "emotional", "building anticipation", "no percussion instruments", "retro movie soundtrack", "spooky movie", "dramatic", "philharmonic orchestra"] | 1 | 17AtKbQ7glU | 239 | |
Swan Lake for piano, Tchaikovsky + sheet music | The song is instrumental music. The song is medium tempo with just a piano playing pensively and no other instrumentation. The song is emotional and poignant. The song is a western classical masterpiece, but with bad audio quality issues. | 2011-01-22T16:54:57Z | ken | Swan Lake by Tchaikovsky. Sheet music available here: https://sowl.co/bgZ9cg | ["Music", "Sad music"] | ["western classical music", "poor audio quality", "poor audio quality", "western classical masterpieces", "piano playing", "love song", "forever classics", "poignant", "melancholic", "winter", "classic composers", "conductor", "piano solo", "emotional", "medium tempo", "dynamics", "instrumental music", "in love", "dance like", "lullaby"] | 1 | 1WlvXneu6oY | 284 | |
Dvořák: Cello Concerto / Isserlis · Gilbert · Berliner Philharmoniker | The song is an instrumental. The tempo is medium with a cellist playing a virtuoso solo accompanied by a string section harmony, flutes in harmony and a loud banging timpani. The song is spirited and passionate with poor audio quality. The song is a western classical piece. | 2009-06-19T08:28:26Z | Berliner Philharmoniker | Full-length concert: http://www.digitalconcerthall.com/concert/27/?a=youtube&c=true Antonín Dvořák: Cello Concerto / Steven Isserlis, cello · Alan Gilbert, conductor · Berliner Philharmoniker / Recorded at the Berlin Philharmonie, 19 April 2009. The Berliner Philharmoniker's Digital Concert Hall: http://www.digitalconcerthall.com Subscribe to our newsletter: http://www.digitalconcerthall.com/newsletter Website of the Berliner Philharmoniker: http://www.berliner-philharmoniker.de | ["Cello", "Music", "Musical instrument", "Orchestra", "Violin, fiddle", "Classical music", "Bowed string instrument"] | ["cellist", "string section", "philharmonic orchestra", "cello concerto", "dvorak", "virtuously", "timpani bangs loud", "medium tempo", "wind sections", "violins playing harmony", "groovy music", "western classical music", "great composers", "conductor", "opera hall", "live audience", "live performance", "instrumental music", "passionate", "spirited", "emotional", "great technique", "poor audio quality", "concert hall"] | 1 | yrme-KRBvzk | 5445 |
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;