musiccaps_details (view)
2 rows where musiccaps_aspects contains "dramatic", musiccaps_aspects contains "orchestra" and musiccaps_aspects contains "strings"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- dramatic · 2 ✖
- orchestra · 2 ✖
- 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
- rock opera 1
- sentimental 1
- shouting 1
- swinging 1
- tension 1
- video game theme 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 | |
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;