musiccaps_details (view)
3 rows where musiccaps_aspects contains "classical", musiccaps_aspects contains "strings" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- classical · 3 ✖
- strings · 3 ✖
- piano 2
- ambient synth 1
- animal-like 1
- cinematic 1
- compilation 1
- crestfallen 1
- female vocal 1
- haunting 1
- high-pitched singing 1
- instrumental 1
- lullaby 1
- male vocal 1
- medium-to-high pitch singing 1
- melancholic 1
- opera 1
- orchestra 1
- outer space 1
- russian 1
- sound effects 1
- underwater 1
- vocal range 1
musiccaps_names (array) 7 ✖
- Music 3
- Opera 2
- Ambient music 1
- Lullaby 1
- Singing 1
- Theme music 1
- Whale vocalization 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cecilia Bartoli's Operatic Vocal Range (in about a minute!) | This piece is a compilation of an opera singer's high-pitched singing that shows how high of a pitch she can reach. For the most part, she is holding a single high note as the strings in the orchestra provide the harmonic background. | 2010-12-23T17:05:25Z | SsteinwayS | US: http://amzn.to/2itVgnr Canada: http://amzn.to/2iRUtNK Cecilia Bartoli’s vocal range: from low E below middle C to high E-flat above soprano high C! | ["Singing", "Music", "Opera"] | ["opera", "classical", "orchestra", "strings", "female vocal", "high-pitched singing", "compilation", "vocal range"] | 9 | AElgGuUSSKE | 1088 | |
Константин Плужников Lullaby Berceuse de la Bretagne | This is a Russian lullaby piece with classical music elements. The male vocalist is singing at a medium-to-high pitch in an opera-like manner. The strings and the piano are playing a gentle but crestfallen melody. The atmosphere is haunting. This piece could fit perfectly in the soundtrack of a post-apocalyptic war movie or a video game of similar theme. It could also work well in the soundtrack of a drama movie or an art movie that takes place in Russia or Eastern Europe. It might also be playing in the background at a high-tier Russian cuisine restaurant. | 2012-12-24T03:43:59Z | Bronisliva | Константин Плужников Бретонская колыбельная песня (М.Ипполитов-Иванов - В. Соловьев) Konstantin Pluzhnikov Berceuse de la Bretagne Lullaby (M.Ippolitov-Ivanov - V. Soloviev) Artist - P. de Chavannes | ["Music", "Opera", "Lullaby"] | ["russian", "lullaby", "classical", "male vocal", "medium-to-high pitch singing", "strings", "piano", "crestfallen", "haunting", "melancholic"] | 9 | ZKkfCOqLrT0 | 3363 | |
Song of The Whales | This is a cinematic classical music piece. There is a piano playing the chords while the strings are holding the melodic background. There is a mysterious ambient synth sound coming and going. A repetitive low-to-mid frequency percussive sound effect is being played to imply the sound of whales. The atmosphere of the piece is reminiscent of both underwater and outer space at the same time. That is why it could be used in science fiction movies and shows that have an aquatic or outer space setting. | 2008-03-22T21:38:54Z | 664FREEDOM | Whales are Universal Beings. Photo Slide Show by 664Freedom . Warning Photo Video Contains Shocking pictures. Music: Vangelis - Heaven and Hell & I`ll Find My Way Home | ["Theme music", "Whale vocalization", "Music", "Ambient music"] | ["classical", "instrumental", "piano", "strings", "ambient synth", "sound effects", "cinematic", "animal-like", "underwater", "outer space"] | 9 | nxdHojfss_A | 4596 |
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;