musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_author = 4, musiccaps_names contains "Progressive rock" and musiccaps_names contains "Psychedelic rock"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 33 ✖
- energetic 4
- low quality 3
- punchy snare 3
- rock 3
- aggressive 2
- distorted bass guitar 2
- energetic cymbals 2
- shimmering hi hats 2
- addictive 1
- doubled flat male vocals 1
- groovy bass 1
- groovy bass guitar 1
- harsh 1
- heartbeat kick pattern 1
- hollow 1
- imbalanced 1
- instrumental 1
- loud 1
- manic 1
- mellow 1
- metal 1
- muffled 1
- passionate female vocal 1
- punchy kick 1
- screaming male vocal 1
- short snare rolls 1
- soft 1
- thin 1
- uptempo kick pattern 1
- wide electric guitar chords 1
- wide electric guitar melody 1
- wide electric guitars chord progressions 1
- wide electric guitars riffs 1
musiccaps_names (array) 9 ✖
- Progressive rock · 4 ✖
- Psychedelic rock · 4 ✖
- Rock music 4
- Music 3
- Punk rock 3
- Heavy metal 2
- Grunge 1
- Independent music 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rat Race - Seminal Rats | The low quality recording features a rock song that consists of wide electric guitar chord progressions, distorted bass guitar, shimmering hi hats, uptempo kick pattern and punchy snare. This instrumental sounds a bit muffled and imbalanced in volume, as the guitars are really loud, but it is very energetic regardless. | 2008-12-31T23:39:53Z | Seminalrats | On the occasion of the 10th. anniversary of the death of Mick Weber. | ["Music", "Punk rock", "Psychedelic rock", "Rock music", "Progressive rock"] | ["rock", "low quality", "wide electric guitars chord progressions", "distorted bass guitar", "shimmering hi hats", "uptempo kick pattern", "punchy snare", "imbalanced", "energetic", "instrumental", "muffled"] | 4 | 9dBWFEpcJIo | 1030 | |
the whip - freelance liaison | The low quality recording features a metal song that consists of screaming male vocal singing over widely spread electric guitar riffs, distorted bass guitar, energetic cymbals and short snare rolls. It sounds loud, aggressive, energetic and manic - as every metal song should sound. | 2011-04-08T04:05:08Z | mullettaimer | the whip - freelance liaison from the 7inch | ["Heavy metal", "Music", "Psychedelic rock", "Rock music", "Progressive rock"] | ["low quality", "metal", "screaming male vocal", "energetic", "punchy snare", "wide electric guitars riffs", "distorted bass guitar", "energetic cymbals", "short snare rolls", "loud", "manic", "aggressive"] | 4 | eUZ-v8GEcNk | 3866 | |
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 | |
Silent Hill Shattered Memories - Hell Frozen Rain | The low quality recording features a rock song that consists of a passionate female vocal singing over punchy kick and snare hits, shimmering hi hats, wide electric guitar melody and groovy bass guitar. It sounds energetic and addictive in the first half of the loop, while in the second part it's mellow and softer. | 2009-12-17T08:21:09Z | Person Whatname | Artist : Akira Yamaoka Vocals: Mary Elizabeth McGlynn at 3:56, it's "THERE's one that confuses me". thanks to ares5566 for the correction. From Silent Hill Shattered Memories Soundtrack. This song plays during the credits, depends on which ending you get. AWESOME FACT : at 3:34, you can hear part of Silent Hill 1 theme :) | ["Punk rock", "Psychedelic rock", "Rock music", "Song", "Progressive rock"] | ["low quality", "rock", "passionate female vocal", "wide electric guitar melody", "groovy bass", "shimmering hi hats", "punchy kick", "punchy kick", "mellow", "energetic", "addictive", "soft"] | 4 | qrzNABqN420 | 4828 |
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;