musiccaps_details (view)
2 rows where musiccaps_aspects contains "winds section" and musiccaps_author = 9 sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- winds section · 2 ✖
- acoustic drums 1
- big band 1
- clarinet 1
- dramatic 1
- flute 1
- instrumental 1
- jazz 1
- lively 1
- orchestra 1
- piano 1
- playful 1
- rising pattern 1
- saxophone 1
- sound effects 1
- thunder 1
- timpani 1
- trumpet 1
- upbeat 1
- upright bass 1
musiccaps_names (array) 4 ✖
- Music 2
- Jazz 1
- Scary music 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 |
---|---|---|---|---|---|---|---|---|---|---|
A Griffon Day | This is a big band jazz music piece. It is an instrumental piece. The main melody is played by a wide variety of the winds section composed of the saxophone, the trumpet, the flute and the clarinet. The piano and the upright bass provide backing structures. The rhythmic background consists of a jazz acoustic drum beat. The atmosphere is playful. This piece could fit perfectly in the soundtrack of a Disney-type animation movie. | 2008-01-27T00:18:25Z | George Pfeiffer | Gus the Brussels Griffon documents a typical day in his life. If you like dogs...or monkeys...or Ewoks....then you'll love this little pooch! | ["Swing music", "Jazz", "Music"] | ["jazz", "big band", "instrumental", "winds section", "saxophone", "trumpet", "flute", "clarinet", "upright bass", "piano", "acoustic drums", "lively", "playful", "upbeat"] | 9 | JU6GUqRqbtI | 2011 | |
Inside The Berghof Movie part 1 | There is an orchestra composed of the winds section and the timpani playing a dramatic tune with a rising melody. Afterwards, a thunder sound effect can be heard. Sounds from this piece can be sampled for use in advertisement jingles or in beat-making. | 2010-01-31T23:30:46Z | rebuildtheberghof | HITLERS BERGHOF The RAF bombed the area on April 25, 1945, and a little of Obersalzberg was damaged. Since then the government of Bavaria has gradually destroyed or buried almost every trace of the Berghof. This DVD is for the historian interested in the Obersalzberg and the Berghof. Its an insight in to the impressive building of huge historical importance which was destroyed by the Bavarian government in a bid to remove all traces of the NAZI party from the hill side. The former Gastehaus Höher Göll houses a museum chronicling the span of World War II. The nearby Platterhof hotel survived the war and restored by the US Army and renamed the General Walker Hotel. It remained in US as a recreation center until the late 1990s and was demolished in 2000. It was replaced by the new 5-star hotel, InterContinental Resort Berchtesgaden which was built nearby on the former site of Hermann Göring's chalet. Following the departure of the U.S. military, the Bavarian government has made every attempt to remove or bury every trace of the Berghof and other Nazi buildings in an effort to return the area to a vacation site. Nevertheless, it's unlikely that the mountain's historical relevance will ever be completely erased and will continue as one of Germany's most popular "war tourism" destinations. | ["Music", "Scary music"] | ["orchestra", "winds section", "timpani", "rising pattern", "dramatic", "sound effects", "thunder"] | 9 | 4HhJneiP-hY | 554 |
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;