musiccaps_details (view)
2 rows where musiccaps_aspects contains "conductor" and musiccaps_aspects contains "slow tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- conductor · 2 ✖
- emotional 2
- philharmonic orchestra 2
- slow tempo · 2 ✖
- string section harmony 2
- a great adventure 1
- against all odds 1
- calming 1
- cellos playing lower register 1
- cheerful 1
- children’s movie 1
- classical vocalist 1
- composer 1
- composers 1
- concert hall 1
- fight the good fight 1
- heart felt 1
- high pitched singing 1
- inspirational 1
- instrumental music 1
- lilting music 1
- live performance 1
- lyrical singing 1
- movie soundtrack 1
- nostalgia 1
- opera classics 1
- opera hall 1
- opera legend 1
- opera singer 1
- passion 1
- pizzicato 1
- poignant 1
- positive 1
- relaxing 1
- retro classic hits 1
- romance 1
- spirited 1
- string section singing 1
- subdued harmony 1
- trudge along 1
- vintage opera 1
- violins strings plucked 1
- western classic music legends 1
- western classical music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Frühlingsstimmenwaltzer- Natalie Dessay- A Flat | A female opera singer sings this high pitched lyrical melody. The song tempo is slow with a philharmonic orchestra accompaniment, with a string section harmony and pizzicato violin play. The song is extremely emotional and spirited. The song is a vintage opera hit. | 2007-03-25T06:59:02Z | LaViolettaValery | natalie dessay and her debut at the Vienna State Opera - 1993!! | ["Music", "Opera"] | ["opera singer", "high pitched singing", "vintage opera", "string section harmony", "western classic music legends", "live performance", "philharmonic orchestra", "lyrical singing", "string section singing", "slow tempo", "opera classics", "opera legend", "lilting music", "subdued harmony", "retro classic hits", "classical vocalist", "emotional", "poignant", "cheerful", "positive", "inspirational", "violins strings plucked", "pizzicato", "composers", "conductor", "opera hall", "western classical music"] | 1 | CZWLPPO0KL4 | 1377 | |
Nausicaä of the Valley of the Wind Soundtrack 2 | The song is an instrumental. The song is slow tempo with a philharmonic orchestra playing a string section harmony, lower register harmony Ina lilting manner. The song is emotional and heartfelt. The song is a movie soundtrack. | 2010-08-20T02:55:43Z | MyCrunchyCookie | Second part to the Nausicaa soundtrack. :) Hope you like it!!! Rate, Fave and Sub!!! Please??? :) | ["Music", "Sad music"] | ["instrumental music", "slow tempo", "calming", "philharmonic orchestra", "composer", "conductor", "concert hall", "string section harmony", "cellos playing lower register", "a great adventure", "nostalgia", "passion", "romance", "spirited", "trudge along", "fight the good fight", "against all odds", "relaxing", "emotional", "movie soundtrack", "children’s movie", "heart felt"] | 1 | bt8iHoIf2mo | 3664 |
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;