musiccaps_details (view)
2 rows where musiccaps_author = 9 and "youtube_published" is on date 2009-09-27
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- male vocal 2
- acoustic drums 1
- aggressive 1
- alternative 1
- bass guitar 1
- chaotic 1
- dance 1
- distorted electric guitar 1
- electronic 1
- electronic drums 1
- electronic elements 1
- energetic 1
- fast tempo 1
- female vocal 1
- groovy 1
- harsh singing 1
- hip 1
- loud 1
- modern 1
- nu-metal 1
- percussive elements 1
- pop music 1
- remix 1
- strings sample 1
- turntable 1
- violent 1
- vocal samples 1
musiccaps_names (array) 4 ✖
- Music 2
- Angry music 1
- Drum and bass 1
- Drum machine 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Gwen Stefani - Wind It Up (Kissy Sell Out Remix) | This is a dance remix of a pop music piece. There are two vocals in the piece, one male and one female. Heavy effects are used on the vocals to make them repeat syllables. There is a repeating string sample as the melody. A complex electronic drum beat provides the rhythmic background. The piece has a groovy feel. It can be played at nightclubs. It could also be used in the soundtrack of a high school drama. | 2009-09-27T13:22:33Z | under9r0und | ["Drum and bass", "Music", "Drum machine"] | ["pop music", "remix", "electronic", "dance", "female vocal", "male vocal", "vocal samples", "turntable", "electronic drums", "strings sample", "groovy", "hip", "modern"] | 9 | 92sRFZvCnWo | 974 | ||
slipknot pulse of the maggots | This is a nu-metal/alternative metal music piece. There is a male vocalist singing in a harsh, shout-like manner in the lead. The main melody is being played by a distorted electric guitar with a strong bass guitar backing. There are various electronic elements such as a crowd cheering sample and an evolving synth sound adding texture to the piece. The rhythmic background consisted of a loud metal acoustic drum beat and secondary percussive elements such as steel percussion. The atmosphere is energetic and violent. This piece could be used in the soundtrack of an action-filled/shootout video game. It could also be playing in the background at a metal bar. | 2009-09-27T06:17:51Z | slayer4728 | I have a good faith belief that the material was disabled as a result of a mistake or misidentification, and that I am not intentionally abusing this dispute process. I do NOT own this video. It was recorded by SlipKnot, I do NOT take part in this video. Enjoy! | ["Music", "Angry music"] | ["nu-metal", "alternative", "male vocal", "harsh singing", "distorted electric guitar", "bass guitar", "electronic elements", "acoustic drums", "percussive elements", "loud", "energetic", "aggressive", "chaotic", "violent", "fast tempo"] | 9 | cCyfADwHiWs | 3688 |
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;