musiccaps_details (view)
3 rows where "youtube_published" is on date 2009-12-29 sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- orchestra 2
- adventurous 1
- amateur recording 1
- background noises 1
- big 1
- brass 1
- clarinets 1
- cymbals 1
- didgeridoo 1
- dramatic 1
- exciting 1
- french horns 1
- grand 1
- important moment 1
- jumping 1
- people talking 1
- percussion sound effects 1
- shouting 1
- strings 1
- swinging 1
- tension 1
- thrilling 1
- timpani 1
- trumpet 1
- tuba 1
- video game theme 1
musiccaps_names (array) 8 ✖
- Music 3
- Timpani 2
- Brass instrument 1
- Classical music 1
- Didgeridoo 1
- Musical instrument 1
- Orchestra 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
WADHOM live "au brio" didgeridoo / hang drum - | This audio contains someone playing a low didgeridoo while people are talking in the background. The didgeridoo sounds amplified. This song may be playing live at a festival. | 2009-12-29T16:42:25Z | thewillstyle | didgeridoo / hang drum - WADHOM live "au brio" | ["Didgeridoo", "Music", "Musical instrument", "Speech"] | ["amateur recording", "didgeridoo", "background noises", "people talking"] | 6 | 7k3M0pQvzhY | 876 | |
Shostakovich: Symphony No. 12 / Dudamel · Berliner Philharmoniker | This is a symphonic orchestra playing a piece that's riveting, thrilling and exciting. The peace would be suitable in a movie when something grand and impressive happens. There are clarinets, tubas, trumpets and french horns being played. The brass instruments help create that sense of a momentous occasion. The percussion is done on timpanis and a cymbal. | 2009-12-29T09:21:58Z | Berliner Philharmoniker | Full-length concert: http://www.digitalconcerthall.com/concert/248/?a=youtube&c=true Dmitri Shostakovich: Symphony No. 12 "The Year 1917" / Gustavo Dudamel, conductor · Berliner Philharmoniker / Recorded at the Berlin Philharmonie, 19 September 2009. The Berliner Philharmoniker's Digital Concert Hall: http://www.digitalconcerthall.com Subscribe to our newsletter: http://www.digitalconcerthall.com/newsletter Website of the Berliner Philharmoniker: http://www.berliner-philharmoniker.de | ["Timpani", "Brass instrument", "Music", "Orchestra", "Classical music"] | ["timpani", "orchestra", "grand", "big", "french horns", "tuba", "trumpet", "clarinets", "cymbals", "thrilling", "exciting", "important moment"] | 3 | XM4hxyK-Ddo | 3178 |
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;