musiccaps_details (view)
2 rows where musiccaps_aspects contains "swing" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- groovy 2
- swing · 2 ✖
- ambient 1
- bass drum 1
- blues 1
- brass instruments 1
- cello 1
- crescendo 1
- elegant 1
- emphatic 1
- heavy bass line 1
- hi-hats 1
- improvisation 1
- instrumental 1
- intense 1
- jazz 1
- jazz drumming 1
- lively 1
- orchestra 1
- polyrhythms 1
- saxophone 1
- slow tempo 1
- swing genre 1
- syncopated melody 1
- trombone 1
- trumpets 1
- upbeat 1
- vibrant 1
musiccaps_names (array) 4 ✖
- Brass instrument · 2 ✖
- Music 1
- Saxophone 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Thats All Me Bro! | This music is a Jazz instrumental. The tempo is slow with emphatic brass and wind instrumentation, with cello and jazz drumming. The trumpets are emphatic with a lively trombone riff. The other instruments add a rich, dense layer to the music. It is intense, complex, ambient, groovy and pleasant. This music is a Jazz instrumental.5. | 2014-10-25T07:37:25Z | CharlesAlatorre | VLOG CHANNEL: https://www.youtube.com/user/CharlesAlatorre2 Christina (Girl In the Video): https://twitter.com/xtinnnnna http://instagram.com/xtinnnnna Travis's Channel: https://www.youtube.com/user/TravieBASED TWITTER: http://twitter.com/CharlesAlatorre INSTAGRAM: CharlesAlatorre LIKE MY FACEBOOK PAGE: http://www.facebook.com/CharlesAlatorreTV FACEBOOK: http://www.facebook.com/CharlesAlatorre Royalty Free Music By: http://www.audiomicro.com/royalty-free-music | ["Brass instrument", "Saxophone"] | ["instrumental", "slow tempo", "trumpets", "saxophone", "emphatic", "groovy", "ambient", "jazz", "intense", "elegant", "jazz drumming", "lively", "polyrhythms", "blues", "swing", "bass drum", "trombone", "cello", "heavy bass line", "syncopated melody", "improvisation"] | 7 | p1-07VdP__Q | 4676 | |
《吹奏楽コンサート》Let's Swing!! | This is an upbeat swing style song with a choir of brass instruments playing a vibrant motif. The motif is a sort of crescendo that announces the next segment. It would be suitable as an intro to the arrival of a character in a musical or movie. | 2012-09-28T02:33:25Z | エムハチチャンネル | 【QC-190】Let's Swing!! 商品詳細はこちら→https://www.music8.com/products/detail3132.php 《収録曲》 0:00 メイク・ハー・マイン【MAKE HER MINE】 1:49 故郷の空 3:36 シング・シング・シング【SING,SING,SING】 | ["Swing music", "Brass instrument", "Music"] | ["orchestra", "brass instruments", "swing", "upbeat", "groovy", "swing genre", "vibrant", "hi-hats", "crescendo"] | 3 | pKFXFu8st9I | 4701 |
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;