musiccaps_details (view)
2 rows where musiccaps_names contains "Pop music" and "youtube_published" is on date 2010-08-29
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- aggressive 1
- bass guitar 1
- breathy female vocals 1
- distorted electric guitar 1
- energetic 1
- fry scream 1
- hip hop 1
- industrial effects 1
- industrial metal 1
- laughing vocals 1
- live performance 1
- loud 1
- loud acoustic drums 1
- male vocal 1
- nu metal 1
- pop dance music 1
- powerful 1
- seductive female pop vocals 1
- strings motif 1
- upbeat 1
- violent 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Static-X - Black And White | This is an industrial metal piece. The male vocalist in the lead is singing using the fry scream technique. The distorted electric guitar is playing a heavy riff while there is a groovy bass line. There is a loud metal beat being played by the acoustic drums in the rhythmic background. Industrial sound effects can be heard which are distinctive to the industrial and nu metal scenes. The atmosphere is aggressive and energetic. This piece could be played at a rock/metal bar. It could also be included in the soundtrack of an action movie/video game. | 2010-08-29T19:54:25Z | Triggerself | Lyrics: Lost in my own World Lost in my own World Lost in my Lost in my own World Lost in my own World Lost in my Getting to the right Getting to the wrong Getting mine Getting to the right Getting to the wrong Getting high Losing your mind Losing your mind It's bluring It's fading Your soul's on fire It's black and white Burning inside Burning inside Burning into white Burning inside Burning inside Burning into night Yourself collides Yourself collides Yourself into mine Yourself collides Yourself collides Yourself splinters like Losing your mind Losing your mind It's bluring It's fading Your soul's on fire It's black and white Blurring the light Blurring the light It's ours for the taking Flickering colors It's black and white | ["Disco", "Jazz", "Music", "Pop music"] | ["industrial metal", "nu metal", "male vocal", "fry scream", "distorted electric guitar", "bass guitar", "loud acoustic drums", "industrial effects", "aggressive", "energetic", "loud", "violent", "powerful"] | 9 | 7OgH3B49_E4 | 842 | |
Pussycat Dolls - Beep (Live) | The song is an upbeat pop song with a slight hip hop influence. It's a live performance and features a breathy, seductive female vocalist. The backup singers almost chant or laugh in a staccato way that creates a vocal riff. There are string instruments in the background. This is a live performance. | 2010-08-29T11:39:18Z | Suniuke | ["Music of Asia", "Music", "Pop music"] | ["live performance", "laughing vocals", "seductive female pop vocals", "strings motif", "pop dance music", "upbeat", "breathy female vocals", "hip hop"] | 3 | NsYVaRI6rXg | 2373 |
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;