musiccaps_details (view)
3 rows where musiccaps_aspects contains "rock", musiccaps_names contains "Grunge" and musiccaps_names contains "Psychedelic rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- rock · 3 ✖
- aggressive 1
- alternative rock 1
- calm emo male singer 1
- doubled flat male vocals 1
- e-guitars 1
- electric bass guitar 1
- electric guitar 1
- energetic 1
- energetic cymbals 1
- groovy bass guitar 1
- harsh 1
- heartbeat kick pattern 1
- hollow 1
- indie rock 1
- live performance 1
- live recording 1
- low quality recording 1
- male voice singing 1
- medium tempo 1
- melancholic vibe 1
- punchy snare 1
- rock band 1
- thin 1
- wide electric guitar chords 1
musiccaps_names (array) 8 ✖
- Grunge · 3 ✖
- Music 3
- Psychedelic rock · 3 ✖
- Punk rock 2
- Rock music 2
- Heavy metal 1
- Independent music 1
- Progressive rock 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
22-20s- Shake_ Shiver and Moan (live ep) | This song contains e-guitars playing melodies and rhythmic strumming that are spread to both sides of the speakers. A male voice is singing a melancholic melody in a higher key sitting in the middle of the track. This song may be playing while walking through the park while listening to this song with headphones. | 2010-09-26T10:25:28Z | etsithahtan | 22-20s- Shake_ Shiver and Moan (live ep) | ["Music", "Psychedelic rock", "Grunge"] | ["rock", "e-guitars", "male voice singing", "medium tempo", "melancholic vibe"] | 6 | IiBgER0W8iA | 1930 | |
Pink Noise : Beverley Westwood | This is a quintessential indie garage rock band. The singer is calm and sings with a sort of haunting demeanor typical of this style. It's a live recording and the audio is of low quality. The singer goes off-pitch at one point. | 2006-05-29T09:55:00Z | Nick Clay | Recorded live at the famous Adelphi in Hull. http://www.nickclay.karoo.net/pinknoise.htm | ["Music", "Punk rock", "Psychedelic rock", "Rock music", "Grunge"] | ["rock", "alternative rock", "indie rock", "live recording", "low quality recording", "live performance", "rock band", "electric guitar", "electric bass guitar", "calm emo male singer"] | 3 | ORt8LSgn-uA | 2441 | |
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;