musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "rock", musiccaps_names contains "Grunge" and musiccaps_names contains "Independent music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- groovy bass guitar 3
- rock · 3 ✖
- emotional 2
- low quality 2
- melancholic male vocal 2
- punchy kick 2
- punchy snare 2
- acoustic rhythm guitar 1
- aggressive 1
- bouncy snare 1
- doubled flat male vocals 1
- energetic 1
- energetic cymbals 1
- groovy 1
- harsh 1
- heartbeat kick pattern 1
- heartfelt 1
- hollow 1
- melancholic 1
- messy 1
- muddy 1
- noisy 1
- shimmering ride cymbals 1
- thin 1
- wide electric guitar chords 1
- wide electric guitar melody 1
musiccaps_names (array) 8 ✖
- Grunge · 3 ✖
- Independent music · 3 ✖
- Music 3
- Progressive rock 2
- Heavy metal 1
- Psychedelic rock 1
- Punk rock 1
- Rock music 1
youtube_published (date) 3 ✖
- 2007-05-01 1
- 2011-03-07 1
- 2012-04-26 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Smashing Pumpkins - Whir (Whirl) | The low quality recording features a rock song that consists of melancholic male vocal singing over a wide electric guitar melody, bouncy snare, groovy bass guitar and punchy kick. The recording is noisy, muddy and messy, since the frequencies are clashing with each other - drums cymbals are inaudible. Regardless, it sounds groovy, emotional and melancholic thanks to that vocal. | 2012-04-26T21:13:42Z | xthreenightsx | Demo '92 | ["Music", "Independent music", "Grunge"] | ["low quality", "rock", "wide electric guitar melody", "melancholic male vocal", "bouncy snare", "groovy bass guitar", "noisy", "muddy", "messy", "punchy kick", "melancholic", "emotional", "groovy"] | 4 | aO0QzRPiEC4 | 3533 | |
Kurt Cobain-Half The Man I Used To Be | The low quality recording features a rock song that consists of a melancholic male vocal singing over punchy kick and snare hits, shimmering ride cymbals, groovy bass guitar and acoustic rhythm guitar. It sounds emotional and heartfelt. | 2007-05-01T17:41:40Z | crkuhifan | half the man i used to be song with nirvana's leader kurt cobain | ["Music", "Independent music", "Progressive rock", "Grunge"] | ["low quality", "rock", "melancholic male vocal", "punchy snare", "shimmering ride cymbals", "punchy kick", "groovy bass guitar", "acoustic rhythm guitar", "emotional", "heartfelt"] | 4 | nvRd4xgEWbw | 4591 | |
Hoover EmPower Vacuum Jingle | The Rock song features a doubled flat male vocals singing over wide electric guitar chords, groovy bass guitar, energetic cymbals, punchy snare hits and heartbeat kick pattern. It lacks low frequencies, therefore it sounds thin, hollow and harsh, but regardless, also energetic and aggressive. | 2011-03-07T07:54:13Z | Jim Simonian | This was a fun jingle that we did for the Hoover Empower Vacuum cleaner back in 2005. Kelly Derrick - vocals, Jim Simonian - Drums, Vocals, Ron Gregorcic - Guitars. | ["Heavy metal", "Music", "Punk rock", "Independent music", "Psychedelic rock", "Rock music", "Progressive rock", "Grunge"] | ["rock", "wide electric guitar chords", "groovy bass guitar", "doubled flat male vocals", "energetic cymbals", "punchy snare", "heartbeat kick pattern", "harsh", "thin", "hollow", "aggressive", "energetic"] | 4 | qDiTICmdUQg | 4765 |
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;