musiccaps_details (view)
2 rows where musiccaps_aspects contains "dramatic" and musiccaps_aspects contains "emotional"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- dramatic · 2 ✖
- emotional · 2 ✖
- baroque 1
- building anticipation 1
- cello 1
- classical music 1
- conductor 1
- crouching bass line 1
- eerie 1
- flutes playing 1
- haunting 1
- horn section 1
- instrumental 1
- male vocal 1
- movie soundtrack 1
- no percussion instruments 1
- philharmonic orchestra 1
- poor audio quality 1
- retro movie soundtrack 1
- soprano 1
- spooky movie 1
- string section harmony 1
- suspense 1
- violin 1
musiccaps_names (array) 5 ✖
youtube_published (date) 2 ✖
- 2012-04-07 1
- 2015-02-18 1
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 | |
Baroque music - Extremely rare voice (Sad classical music) | This is a classic music piece belonging to the baroque era. There is a soprano male vocal singing at an extraordinarily high pitch. The melody is being played by the violin and the cello. There is an emotional atmosphere to this piece. It could be playing in the background at a classy restaurant. It could also work well in the soundtrack of an art movie. | 2012-04-07T00:22:30Z | Ksenia Vorobieva | Baroque, classical music ... Extremely rare voice - male soprano Radu Marian sings aria from Baroque cantata "Vorrei, pupille belle, con Violini" (Bononcini). This is his natural soprano voice, not falsetto. For more songs and videos: http://www.youtube.com/user/radumariandotnet If you like, please share this video with others. --- Раду Марьян (мужское сопрано). http://www.youtube.com/user/radumariandotnet --- Baroque music, sad classical music | ["Music", "Opera", "Classical music"] | ["classical music", "baroque", "male vocal", "soprano", "violin", "cello", "emotional", "dramatic"] | 9 | 5nJr7iar6ZM | 695 |
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;