musiccaps_details (view)
2 rows where musiccaps_aspects contains "movie soundtrack" and musiccaps_aspects contains "triumphant"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- medium tempo 2
- movie soundtrack · 2 ✖
- triumphant · 2 ✖
- army marching 1
- brass band 1
- changing tones 1
- choir singers 1
- choral harmony 1
- composer 1
- conductor 1
- deteriorated audio quality 1
- emotional 1
- funeral march 1
- groovy 1
- instrumental music 1
- live audience 1
- live concert 1
- majestic 1
- passionate 1
- philharmonic orchestra 1
- poor audio quality 1
- retro movie themes 1
- royal march 1
- song ending 1
- song fade 1
- spirited 1
- steady drumming rhythm 1
- tribute 1
- trombones 1
- trumpet playing 1
- trumpets 1
- trumpets blaring 1
- tuba 1
- western classical music 1
musiccaps_names (array) 6 ✖
youtube_published (date) 2 ✖
- 2009-08-21 1
- 2012-02-26 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kirk Douglas (Einar) viking funeral | The song is an instrumental movie soundtrack. The song is medium tempo with a choral section changing, trumpet playing melody and drums playing in a march rhythm. The song is majestic like a funeral march. The song is a movie soundtrack with a poor audio quality issue. | 2012-02-26T07:20:29Z | Joe Cortez | Final scene and closing credits from The Vikings by Richard Fleischer (1958) Título brasileiro: Vikings, Os Conquistadores | ["Foghorn", "Music", "Outside, rural or natural"] | ["poor audio quality", "movie soundtrack", "deteriorated audio quality", "retro movie themes", "emotional", "tribute", "passionate", "spirited", "trumpet playing", "majestic", "choral harmony", "changing tones", "funeral march", "triumphant", "royal march", "steady drumming rhythm", "medium tempo", "army marching", "choir singers"] | 1 | LClTjcyNJSI | 2163 | |
Chicago Brass Festival 2009 | The song is an instrumental. The tempo is medium with a brass section including trumpets, trombones and tubas playing in an instrumental harmony. The song is emotional and spirited. The song is western classical music piece. | 2009-08-21T18:56:24Z | Chicagobrassfestival | The next Chicago Brass Festival will be held March 19 - 21, 2010. www.chicagobrassfestival.com for more information | ["Brass instrument", "French horn", "Trumpet"] | ["brass band", "trumpets", "tuba", "trombones", "western classical music", "philharmonic orchestra", "song fade", "song ending", "triumphant", "trumpets blaring", "instrumental music", "groovy", "movie soundtrack", "live concert", "live audience", "conductor", "composer", "medium tempo"] | 1 | _MjbdUaJcik | 3466 |
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;