musiccaps_details (view)
3 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "violin" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- emotional · 3 ✖
- violin · 3 ✖
- male vocal 2
- acoustic drums 1
- acoustic guitar 1
- baroque 1
- cello 1
- classical music 1
- dramatic 1
- gentle 1
- instrumental 1
- intense 1
- melancholic 1
- moroccan 1
- piano 1
- romantic 1
- soap opera soundtrack 1
- soprano 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Kiralık Aşk - Enstrümantal Fon Müzik 2 || Instrumental Background Music 2 | This is an instrumental piece from a soap opera soundtrack. The violin and the acoustic guitar are playing a mellow tune while there is an occasional piano tune in the background. The rhythm is kept by a very quiet acoustic drum beat. The atmosphere is gentle and romantic. This piece could be used in the soundtrack of romance movies where the characters are having a good time in the presence of each other. | 2015-12-14T11:19:46Z | Kiralık Aşk Soundtrack | ABONE OL tuşuna basarak kanalıma abone olmayı unutmayın! Please do not forget to SUBSCRIBE my channel! | ["Music", "Sad music"] | ["soap opera soundtrack", "instrumental", "violin", "acoustic guitar", "piano", "acoustic drums", "gentle", "emotional", "romantic"] | 9 | 7eZTmLV9gcY | 871 | |
el mansouri star du tazi.DAT | This is a melancholic Moroccan music piece. The male vocalist is singing in an agitated, crying-like manner. The only accompaniment being the violin creates a dense atmosphere loaded with emotion. This piece could be used in the soundtrack of a movie or a TV show involving a tragedy which is taking place in North Africa. | 2010-01-09T21:48:11Z | ghrbaoui | a toutes les ghrbaouis | ["Music of Africa", "Traditional music", "Music", "Musical instrument"] | ["moroccan", "violin", "melancholic", "male vocal", "intense", "emotional"] | 9 | CBUAy9Zl6ZE | 1340 |
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;