musiccaps_details (view)
2 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2010-12-24
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- acoustic drums 1
- aggressive 1
- alternative metal 1
- bass guitar 1
- digital drum elements 1
- distorted electric guitar 1
- dubstep/electronic 1
- guttural singing 1
- high pitched melody 1
- industrial metal 1
- keyboard 1
- loud 1
- male vocal 1
- pulsating noise sounds 1
- rising 1
- scary atmosphere 1
- uptempo 1
- violent 1
musiccaps_names (array) 7 ✖
- Music · 2 ✖
- Angry music 1
- Dubstep 1
- Electronic music 1
- Heavy metal 1
- Inside, large room or hall 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Resident Evil - Dubstep remix | This song contains a lot of atmospheric noise, sounds rising and falling in velocity and panning to the left and right side of the speakers with a lot of reverb. A high pitched pluck sound is playing a faster melody that is slightly panned to the right side while digital drums are only playing hihat and light snare sounds panned to both sides of the speakers and using a lot of delay and reverb. This song may be playing in a scary videogame. | 2010-12-24T09:40:15Z | bdavidbdavid92 | My newest track.i was experimenting a bit with dubstep basses . youtube added the usual distortion so sry about that. I hope you will enjoy this one. | ["Electronic music", "Music", "Dubstep"] | ["dubstep/electronic", "scary atmosphere", "digital drum elements", "high pitched melody", "rising", "pulsating noise sounds", "uptempo"] | 6 | PXd0NCqZLzU | 2544 | |
Illidiance - New Millenium Crushers music video HD | This is an industrial metal/alternative metal music piece. There is a male vocal singing in a harsh manner using the guttural technique. The melody is being played by the keyboard and the distorted electric guitar while the bass guitar is playing in the background. The acoustic drums are playing a loud and fast-paced metal beat with heavy use of twin pedals on the kick drum. The atmosphere is violent. This piece could be used in the soundtrack of a gruesome horror video game. | 2010-12-24T09:52:38Z | ModernMelodicMetal | Illidiance new music video for ''New Millenium Crushers'' in High Definition from their latest album ''Damage Theory''. © Mazzar Records 2010 | ["Singing", "Heavy metal", "Music", "Angry music", "Inside, large room or hall"] | ["industrial metal", "alternative metal", "male vocal", "guttural singing", "distorted electric guitar", "keyboard", "bass guitar", "acoustic drums", "loud", "aggressive", "violent"] | 9 | U3TpCc2zHrI | 2884 |
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;