musiccaps_details (view)
2 rows where musiccaps_aspects contains "dreamy", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "meditative"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Horus" -- (RESCUED!) Dog at Collin County Animal Services | This music is a pensive instrumental.The tempo is medium with a melancholic cello, rhythmic ukulele and a percussion instrument. The song is pensive, contemplative, meditative, melancholic ,solemn and dreamy. | 2012-06-28T16:02:16Z | CCASAdoptable | Neutered, Micro-chipped and up-to-date on vaccinations! Hi there, my name is Horus! I am a 2 year old Lab Mix. I am a very sweet and happy dog. I am full of personality and charm. Come meet me, you won't regret it! We can play all day or give sweet kisses, it's up to you! Just hurry up and come see! Animal ID#: 353654 Name: Horus Sex: Male Age: Approx 2 years Breed: Lab mix Neutered: Yes For additional information on rescue or adopting contact the shelter directly. You need the ID NUMBER AND NOT NAME WHEN INQUIRING ON THE ANIMAL Collin County Animal Services 4750 Community Blvd. Collin County Justice Complex Mckinney, TX 75071 Email: animalshelter@co.collin.tx.us and ldrummonds@co.collin.tx.us (to inquire about an animal email is the best if no response then call) Phone: 972-547-7292 Hours of Operation Tues-Fri 9am-6pm and Sat 12pm-5pm Sunday 12pm-5pm Monday - closed to public, search for a lost dog by appointment only. | ["Music", "Mandolin", "Yip", "Bluegrass"] | ["instrumental", "upbeat ukelele", "contemplative", "medium tempo", "syncopated rhythm", "deliberate", "meditative", "solemn", "dreamy", "reflective", "melancholic cello", "percussion", "minimalist", "pensive", "emotional"] | 7 | 1FU5odlgLmo | 249 | |
【純音樂】葬花吟(紅樓夢主題曲) 古箏:鍾嘉鳳(Chinese traditional music/Guzheng) | This music is a mesmerising Chinese instrumental. The tempo is medium with a melodious Chinese harp or Guzheng with rhythmic pipa, violin harmony and Chinese percussion instruments. The music is soft, soothing, calming, ethereal, meditative, mellifluous,euphonious and enchanting. | 2012-04-01T13:01:21Z | 莊國年&鍾嘉鳳-台北古箏教學-琹韻箏樂中心 | 黃石老師 作曲 小放牛出版社發行 我們的服務內容: 1. 團體/個別教學/樂團培訓 2. 婚禮/宴會/公益演出(古箏+keyboard/古箏獨奏/古箏樂團) 3. 錄音/編曲參與 4. 教材訂購(包含流行、古曲、現代箏曲等教材、教學CD) 更多相關資訊請看這裡:http://chinyunguzheng.weebly.com/32879320972510520497.html ------------------------------------------------------------------------------------------------------------------------------------------------------- 想更深入了解我們嗎? 歡迎加入我們的粉絲團: http://www.facebook.com/pages/%E8%8E%8A%E5%9C%8B%E5%B9%B4/379841705402286 http://www.facebook.com/pages/%E9%8D%BE%E5%98%89%E9%B3%B3/491977007496223 --莊國年.鍾嘉鳳 | ["Traditional music", "Music"] | ["instrumental", "medium tempo", "guzheng harmony", "soothing", "calming", "meditative", "mellifluous", "euphonious", "chinese instruments", "chinese string instruments", "chinese instrumental music", "chinese harp", "chimes lute", "dreamy", "enchanting", "mesmerising", "violins", "pipa"] | 7 | q-86OQ3HZ4o | 4749 |
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;