musiccaps_details (view)
1 row where musiccaps_aspects contains "orchestra", musiccaps_aspects contains "rising pattern" and musiccaps_aspects contains "timpani"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;