musiccaps_details (view)
2 rows where musiccaps_names contains "Bowed string instrument" and musiccaps_names contains "Flute"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- acoustic guitar 1
- alto-flute 1
- calming 1
- cellos 1
- chinese 1
- classical 1
- classical concert 1
- classical music 1
- curiousity 1
- eastern 1
- easygoing 1
- exploration 1
- instrumental 1
- recorder 1
- string instruments 1
- tension building 1
- violas 1
- violins 1
- xiao 1
musiccaps_names (array) 9 ✖
- Bowed string instrument · 2 ✖
- Flute · 2 ✖
- Music 2
- Musical instrument 2
- Cello 1
- Classical music 1
- Harmonic 1
- Orchestra 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Klassikkuppel: Solisten, A.Vivaldi: Konzert für Blockflöte, Streicher und Basso continuo | This song elicits feelings of mystery, exploration and curiosity. It's a classical piece including violins, violas, cellos and a recorder or alto-flute. The end section builds tension and suspense - as if in a movie scene when a character is peaking curiously around new terrain. | 2012-07-30T02:21:01Z | Klassikkuppel | Antonio Vivaldi: Konzert für Blockflöte, Streicher und Basso continuo in c-Moll RV 441 Solo: M.Gloor Aus dem Konzert vom 19.04.2012, Kuppel Basel Produktion: Olivier Mueller Aufnahmen und Schnitt: Reverse.ch | ["Music", "Musical instrument", "Orchestra", "Violin, fiddle", "Classical music", "Bowed string instrument", "Flute"] | ["classical music", "classical concert", "string instruments", "violins", "cellos", "violas", "recorder", "alto-flute", "tension building", "exploration", "curiousity"] | 3 | 4vGLTrW04UE | 616 | |
淚光閃閃(夏川里美) / 陪我看日出(蔡淳佳) 之陶笛、大提琴、二胡合奏版 | This is an instrumental music piece with Chinese characteristics. The main tune is being played by a small xiao flute. There is a mellow acoustic guitar backing keeping a repeated theme in the background. The song is played on a major scale, giving it a feeling of hopefulness. The atmosphere of the song is soothing. This piece could be played as an opening soundtrack for a romantic anime movie. | 2008-05-16T18:17:26Z | Jones Santos | 主題曲「淚光閃閃」誕生於1998年,「森山良子」為了抒發她對22歲早逝的哥哥的思念,她不停的寫,把對哥哥的思念都寫在歌詞中,當她完成了整首歌的歌詞時,一直抑鬱在心中的那個心結,好像是解開了... 涙そうそう(淚光閃閃)是沖繩的方言,意指「眼淚一顆顆掉落,淚流不止」。想哭的時候,不需壓抑,就盡情的哭吧! 此片在沖繩拍攝,取景相當純樸美麗,劇情是描述一對沒有血緣關係的兄妹,因母親過世、父親失蹤只剩下兩人相依為命,哥哥付出不求回報的守護著他唯一的妹妹,兩人逐漸相互吸引,但現實生活的貧困與病苦,壓得兩人情路坎坷,相當讓人不可置信的哀愁結局。 但片尾放出「淚光閃閃」這首歌,幻燈片式的放出兩人從小到大的相片,讓人再次回想這個故事。最後一張是過了幾年後,妹妹穿著死去的哥哥送的和服端坐的獨照,似乎示意著被淚水沖洗過的心靈就會浮現希望。我似乎懂了,人生再如何哀愁,還是得堅強走下去,總有一天,哀愁ㄧ定會慢慢變淡的... 陪我看日出 雨的氣息是回家的小路 路上有我追著你的腳步 腳下邊保存著昨天的溫度 你抱著我就像溫暖的大樹 雨下了走好路 這句話我記住 風再大吹不走囑咐 雨過了就有路 像那年看日出 你牽著我穿過了霧 叫我看希望就在黑夜的盡處 哭過的眼看歲月更清楚 想一個人閃著淚光是一種幸福 又回到我離開家的小步 你送著我滿天燕子都在飛舞 雖然一個人 我並不孤獨 在心中你陪我看每一個日出 | ["Cello", "Music", "Musical instrument", "Harmonic", "Bowed string instrument", "Flute"] | ["instrumental", "acoustic guitar", "xiao", "eastern", "chinese", "classical", "calming", "easygoing"] | 9 | lDABsoatahM | 4381 |
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;