musiccaps_details (view)
2 rows where musiccaps_aspects contains "animated", musiccaps_aspects contains "brass band" and musiccaps_aspects contains "lively"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- animated · 2 ✖
- brass band · 2 ✖
- instrumental 2
- lively · 2 ✖
- spirited 2
- trumpet 2
- banjo 1
- bowed string instruments 1
- brass instrument 1
- brass instruments 1
- buskers 1
- busking 1
- busking percussion 1
- cello 1
- cheerful 1
- church bell 1
- clarinet 1
- classic music 1
- energetic 1
- exciting 1
- fast tempo 1
- guiro 1
- happy 1
- joyful 1
- lively violin 1
- orchestral music 1
- resonator 1
- scratching sound 1
- shakers 1
- street busking 1
- symphony 1
- trombones 1
- tuba 1
- viola 1
- wind instrument 1
- youthful 1
musiccaps_names (array) 7 ✖
- Brass instrument 1
- Clarinet 1
- Classical music 1
- Music 1
- Soundtrack music 1
- Trombone 1
- Trumpet 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tuba Skinny @ Louisiana Music Factory 2015 - Southern Sounds Tour Party - PT 1 | This music is a lively harmony of the brass and wind instruments. The tempo is fast with lively tuba, trombone, trumpet, clarinet with mandolin and resonator accompaniment and busking percussion that sounds like scratching. His music is loud, vibrant, perky, engaging and animated street busking. | 2015-04-17T00:17:15Z | LAMUSICFACTORY | CDs Available @ Link Below http://www.louisianamusicfactory.com Free Concert Series Southern Sounds Tour Party April 14th Tuba Skinny | ["Brass instrument", "Clarinet", "Trombone", "Trumpet"] | ["instrumental", "fast tempo", "brass band", "tuba", "clarinet", "street busking", "trumpet", "scratching sound", "guiro", "busking percussion", "lively", "animated", "spirited", "trombones", "clarinet", "wind instrument", "brass instruments", "banjo", "resonator", "shakers", "busking", "buskers"] | 7 | 4EwWBI-tHLk | 549 | |
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 |
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;