musiccaps_details (view)
2 rows where musiccaps_aspects contains "brass band", musiccaps_aspects contains "cello" and musiccaps_aspects contains "trumpet"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- brass band · 2 ✖
- cello · 2 ✖
- instrumental 2
- trumpet · 2 ✖
- animated 1
- bass 1
- bowed string instruments 1
- brass instrument 1
- cheerful 1
- church bell 1
- clarinet 1
- classic music 1
- energetic 1
- exciting 1
- flute harmony 1
- happy 1
- joyful 1
- lively 1
- lively violin 1
- orchestral music 1
- slow tempo 1
- spirited 1
- spirted drums 1
- symphony 1
- trombone 1
- tuba 1
- viola 1
- wind instrument 1
- youthful 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Sound of Music Soundtrack - 1 - Prelude/The Sound of Music | This music clip is an Orchestral piece. There is a trumpet playing a lively solo to the accompaniment of an animated, vigorous Violin symphony and a church bell at the end. The music is lively, spirited, vivacious, happy and cheerful with the violins, cello and viola adding a happy, cheerful vibe to this Classical Instrumental. | 2011-03-15T01:38:18Z | xosoundtrackloverxo | The Sound of Music Soundtrack - 40th Anniversary Edition | ["Music", "Classical music", "Soundtrack music"] | ["instrumental", "lively violin", "orchestral music", "cheerful", "symphony", "bowed string instruments", "brass instrument", "brass band", "trumpet", "classic music", "church bell", "lively", "happy", "spirited", "animated", "exciting", "energetic", "youthful", "joyful", "cello", "viola"] | 7 | I4Rhe1XViYg | 1871 | |
【RWBY】 Recording Session feat. White Rose 【手描きMAD】 | This music is a mellow instrumental. The tempo is slow with a mellifluous flute harmony with trumpet, trombone tuba accompaniment , lively drumming and bass cello. The music is playful, sunny, melodic, animated and pleasant. | 2014-07-16T21:09:46Z | ムロマキch | Edit: Rest in power, Monty. I'm sorry my most famous RWBY fanwork is so unapologetically gay. _____________ ★☆ http://www3.to/muromaki ☆★ _____________ My first RWBY Fan Animation and my first animation not starring Original Characters. A cutie on Twitter sent me the original Love Live video from Nico², and I found it so utterly inspirational that I wanted to make a RWBY version of it. Actually, I'm still in the middle of finishing a comic book and therefore didn't have time for this, but... you know how it goes. Stupid teenagers do what they want. There are some spelling errors and other minor mistakes in it, but correcting frames is kind of... complicated in the program I use, therefore I left everything uncorrected. (ugly YOLO laughter) I hope you can enjoy it a little bit nevertheless! Thank you so much for watching! ニコニコの小使さんへどうもありがとうございました! ____________ S O N G : 『硝子の花園』 "Flower Garden of Glass" from "Love Live!" O R I G I N A L : http://www.nicovideo.jp/watch/sm22057561 R W B Y : © Monty Oum & Rooster Teeth Productions | ["Brass instrument", "Trombone"] | ["instrumental", "slow tempo", "brass band", "flute harmony", "bass", "cello", "trumpet", "trombone", "spirted drums", "tuba", "clarinet", "wind instrument"] | 7 | f_NR19LpA_E | 3962 |
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;