musiccaps_details (view)
2 rows where musiccaps_aspects contains "choir" and musiccaps_aspects contains "string section"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- choir · 2 ✖
- string section · 2 ✖
- acoustic bass 1
- big band 1
- brass 1
- celebration song 1
- dixieland 1
- electric jazz guitar 1
- hand claps 1
- happy mood 1
- holiday song 1
- jazz clarinet 1
- lead clarinet 1
- low quality audio 1
- moderate tempo 1
- percussion 1
- swing 1
- trumpets 1
- walking bassline 1
- wind section 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jingle Bells - Auckland Symphony Orchestra | This song features the main melody sung by a choir. This is accompanied by the string section and brass section featuring violins and trumpets. Hand claps are heard on every count. Orchestral percussion plays in the background. As the quality of audio is low, many instruments cannot be heard. This song can be played in a celebration. | 2008-12-09T09:20:44Z | Calum Anderson | The Auckland Symphony Orchestra along with a combined choir perform Jingle Bells at their annual Christmas concert in the Auckland Town Hall in 2008. | ["Orchestra"] | ["celebration song", "holiday song", "string section", "low quality audio", "hand claps", "choir", "trumpets", "percussion", "moderate tempo", "happy mood"] | 0 | bQ9vpp_yXvk | 3624 | |
USAF Band WWII Holiday Flashback | Big band jazz style music featuring a lead clarinetist soloing over a walking bassline, electric jazz guitar, a wind section, brass, string section, and a choir. | 2015-12-04T12:56:21Z | The United States Air Force Band | Our 2015 holiday musical flash mob at Union Station in Washington, D.C. honors our nation’s WWII veterans and gives the performance a vintage look! This "pinks and greens" WWII era uniform earned its nickname from the pairing of the dark olive-drab wool coat with lighter drab trousers, which had a pinkish hue. This flashmob features an extraordinary dance troop from NYC (choreographed by Jessica Hartman), and a cameo appearance by Secretary of the Air Force Deborah Lee James! #TheUnitedStatesAirForceBand | #PinksAndGreens | #Vintage | ["Music", "Inside, public space"] | ["lead clarinet", "jazz clarinet", "walking bassline", "acoustic bass", "choir", "electric jazz guitar", "wind section", "string section", "big band", "brass", "dixieland", "swing"] | 8 | khQN5ylb3H0 | 4346 |
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;