musiccaps_details (view)
2 rows where musiccaps_aspects contains "shouting" and musiccaps_aspects contains "strings"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- dramatic 2
- shouting · 2 ✖
- strings · 2 ✖
- tension 2
- adventurous 1
- brass 1
- fighting 1
- footsteps 1
- gong 1
- instrumental 1
- jumping 1
- male voices 1
- martial arts movie 1
- orchestra 1
- paigu 1
- percussion sound effects 1
- swinging 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 | |
Jet lie- wonderful kong fuo video | These are the sounds coming from a martial arts movie. There are male voices shouting at each other. Sounds of footsteps and the movements of fighting can be heard. The music in the background has a dramatic tune being played on the strings. The rhythmic background is composed of Chinese paigu drums and the gong. There is a feeling of tension in this track. Some parts of this recording can be sampled for use in beat-making. | 2007-05-24T14:30:15Z | bashar105 | Jet lie beating an arrogant guy with some wonderful moves. sport.go to: wrongthings.org | ["Music", "Scary music", "Outside, urban or manmade"] | ["martial arts movie", "instrumental", "male voices", "shouting", "footsteps", "fighting", "strings", "gong", "paigu", "tension", "dramatic"] | 9 | MdsRmMxkF4k | 2284 |
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;