musiccaps_details (view)
3 rows where musiccaps_aspects contains "dramatic", musiccaps_aspects contains "orchestra" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- dramatic · 3 ✖
- orchestra · 3 ✖
- strings 2
- adventurous 1
- brass 1
- dreamy 1
- female vocal 1
- flute 1
- jumping 1
- live performance 1
- medium-to-high pitch singing 1
- percussion sound effects 1
- piano 1
- rising pattern 1
- rock opera 1
- sentimental 1
- shouting 1
- sound effects 1
- swinging 1
- tension 1
- thunder 1
- timpani 1
- video game theme 1
- winds section 1
musiccaps_names (array) 6 ✖
- Music 3
- Music of Asia 1
- Sad music 1
- Scary music 1
- Singing 1
- Timpani 1
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 | |
Shrek 2:The Game Level 4 part 1 | This is the gameplay recording of a video game. A lot of sound effects such as jumping, swinging and shouting related to the video game can be heard. There is an orchestra playing the theme that is composed of strings, brass and percussion. The atmosphere is dramatic and adventurous. Samples from this recording could be used in soundboards or in beat-making. | 2009-12-29T17:09:17Z | Dark Drake | shrek 2 game pc | ["Timpani", "Music"] | ["video game theme", "orchestra", "strings", "brass", "percussion sound effects", "jumping", "swinging", "shouting", "dramatic", "tension", "adventurous"] | 9 | 7MuFNZHhrOE | 837 | |
The Sound of Music - Musical-sing-a-long (repetitie) | This is a rock opera piece that is being sung by a female vocalist in a medium-to-high pitch range. There is an orchestra playing the melody in the background composed of strings, flute and a piano. The atmosphere of the piece is dreamy and sentimental. It could be used in the soundtrack of a fairytale movie. | 2014-09-01T19:54:18Z | Kindermuziek | De cast van The Sound of Music maakt haar opwachting tijdens de Musical-sing-a-long tijdens de Uitmarkt 2014 op het Museumplein in Amsterdam | ["Singing", "Music of Asia", "Music", "Sad music"] | ["rock opera", "live performance", "female vocal", "medium-to-high pitch singing", "orchestra", "strings", "flute", "piano", "dreamy", "sentimental", "dramatic"] | 9 | fZjQBgPD1Ys | 3960 |
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;