musiccaps_details (view)
3 rows where musiccaps_aspects contains "heart-touching" and musiccaps_aspects contains "sentimental"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- heart-touching · 3 ✖
- sentimental · 3 ✖
- live performance 2
- classical music 1
- crying 1
- emotional 1
- female voice 1
- flute 1
- french horn 1
- german romantic music 1
- grand piano 1
- hindi film music 1
- orchestra 1
- piano 1
- poor quality 1
- sitar 1
- strings 1
- violin 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
2009文化盃音樂大賽 -決賽音樂會 | This is a German Romantic era music piece. It is being performed live, however the quality of the recording is poor with frequently occurring peak noise. The french horn is playing the main melody while the background consists of a steady grand piano tune. The piece has a heart-touching feel to it. | 2009-04-12T17:58:41Z | oyutan131 | 6. 史特勞斯:降E大調第一號法國號協奏曲作品11 Richard Strauss:Concerto No.1 in E flat major Op.11 法國號 / 劉品均 (第二名) | ["Brass instrument", "French horn"] | ["german romantic music", "live performance", "poor quality", "french horn", "grand piano", "sentimental", "heart-touching"] | 9 | NDJEKij2qOg | 2326 | |
Nicola Benedetti plays Bruch at the Last Night of the Proms 2012 | This is a live performance of a classical music piece. There is an orchestra performing the piece with a violin lead playing the main melody. The atmosphere is sentimental and heart-touching. This piece could be playing in the background at a classy restaurant. | 2012-09-10T19:04:24Z | ecodef | Violin concerto No. 1 in G minor, by Bruch soloist: Nicola Benedetti conductor: Jiri Belohlavek BBC Symphony Orchestra recorded @ the Royal Albert Hall, London (8 sept. 2012) | ["Music", "Musical instrument", "Violin, fiddle", "Classical music", "Bowed string instrument"] | ["classical music", "live performance", "orchestra", "violin", "sentimental", "heart-touching"] | 9 | XmMN-6g1L8w | 3222 | |
Dil Tujhe Dia Tha... (Malhar) | This is a Hindi film music piece. Initially, there is a female voice crying. Afterwards, an orchestra made up of a flute, a string element, a sitar and a piano starts playing an emotional tune. The atmosphere of the piece is heart-touching. It could be used in the soundtracks of Bollywood movies during heartbreaking scenes. | 2008-07-10T00:15:10Z | IMIRZA777 | oldie. | ["Traditional music", "Music"] | ["hindi film music", "female voice", "crying", "flute", "strings", "sitar", "piano", "sentimental", "emotional", "heart-touching"] | 9 | nnc6m1pBJ4c | 4578 |
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;