musiccaps_details (view)
2 rows where musiccaps_aspects contains "celestial", musiccaps_aspects contains "high notes" and musiccaps_aspects contains "instrumental"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- celestial · 2 ✖
- ethereal 2
- high notes · 2 ✖
- instrumental · 2 ✖
- air notes 1
- angelic organ 1
- beautiful 1
- better watch out 1
- captivating 1
- christmas carol 1
- eerie sound 1
- electromagnetic instrument 1
- electronic instrument 1
- electronic sounds 1
- enigmatic 1
- enthralling 1
- fast tempo 1
- female voice like sound 1
- glass harp 1
- melodious 1
- mesmerising music 1
- musical glasses 1
- no accompaniment 1
- no contact instrument 1
- piano accompaniment 1
- scuffling sound in the background 1
- sharp sounds 1
- theremin 1
- unique instrument 1
- wine glasses 1
musiccaps_names (array) 4 ✖
- Music 2
- Glass 1
- Musical instrument 1
- Theremin 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Wii Theremin - Santa Claus is Coming to Town | This music is an instrumental of the Christmas Carol “You Better Watch Out’. The tempo is medium with the lead harmony on the theremin and piano accompaniment. The music is haunting, ethereal, lilting, mesmerising and captivating. This music is a Theremin Instrument. | 2008-12-17T15:23:34Z | Ken Moore | This is my submission for NPR's National Caroling Party 2008. The instrument is my homemade Wiimote-powered Theremin (simulator). The technology links a Wiimote controller, infrared LED gloves and a Roland JV-1080 synthesizer to create Theremin-like sounds. | ["Music", "Musical instrument", "Theremin"] | ["instrumental", "theremin", "electronic sounds", "female voice like sound", "high notes", "better watch out", "piano accompaniment", "christmas carol", "no contact instrument", "ethereal", "eerie sound", "electronic instrument", "air notes", "electromagnetic instrument", "celestial", "beautiful", "captivating", "enthralling", "mesmerising music"] | 7 | 2-K-7T8ZIWA | 323 | |
[Canon] 캐논 EOS 70D 글라스 하프 광고 영상 (Full ver.) | This music is instrumental. The tempo is fast with the musician playing a high , vigorous, high pitched melody on a Glass harp or angelic organ. The music is sharp, unique, enchanting, and celestial with no accompaniment. | 2013-09-13T03:39:06Z | 캐논TV - Canon Korea | 글라스로 연주되는 아름다운 선율과 캐논의 가장 빠르고 유연한 오토포커스와의 만남! 오토포커스로 또 한번 캐논이 캐논을 넘다 - EOS 70D ········································································· ↘ 캐논 EOS 90D 스펙 확인하기 https://youtu.be/PeaiYIde_AQ ↘ EOS M6 Mark II 득템찬스! #캐논으로브이로그 챌린지 https://youtu.be/T_uUis2LzOk ↘ 캐논Easy 입문편 보고 카.알.못 탈출하세요! https://youtu.be/y-ch1tPNhKg?list=PLb-fDmS7DW0cbzbn73514Q4Xw_tydkDIR ·········································································· 사진, 영상 기본 지식부터 전문 촬영 노하우가 담긴 팁들과 다양한 분야의 크리에이터가 만드는 트렌디한 이야기까지! 재미와 정보를 모두 담은 캐논TV, 지금 만나보세요. ▶http://bit.ly/2JvOvyx ·········································································· 📷같이 보면 더 좋아요! ↘다양한 유튜버들의 트렌디한 이야기 보러가기 https://bit.ly/2jWfmtn ↘흙손에서 금손으로, 촬영비법 알아보기 http://bit.ly/2Yyv9kA ↘카메라 기초 용어가 궁금할 땐, 캐논Easy! http://bit.ly/2YBDQuq ↘진정한 카.알.못을 위한 카메라 사용법! https://bit.ly/2L5woA1 ↘나에게 딱 맞는 렌즈를 알아보자! http://bit.ly/2YBDXWS ↘각양각색 캐논피플들의 이야기! http://bit.ly/2YCmvkW | ["Glass", "Music"] | ["instrumental", "fast tempo", "sharp sounds", "celestial", "high notes", "glass harp", "melodious", "scuffling sound in the background", "ethereal", "enigmatic", "wine glasses", "musical glasses", "angelic organ", "unique instrument", "no accompaniment"] | 7 | PlQibWaPAcM | 2562 |
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;