musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy bass guitar", musiccaps_aspects contains "passionate male vocal" and musiccaps_aspects contains "shimmering cymbals"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- groovy bass guitar · 3 ✖
- passionate male vocal · 3 ✖
- shimmering cymbals · 3 ✖
- emotional 2
- energetic 2
- low quality 2
- passionate 2
- rock 2
- wide electric guitars melodies 2
- "4 on the floor" kick pattern 1
- alternative/indie 1
- distant 1
- easygoing 1
- electric guitar melody 1
- groovy toms 1
- live performance 1
- loud 1
- mellow 1
- mellow kick hits 1
- mellow snare 1
- passionate female vocal 1
- punchy kick 1
- punchy snare 1
- reverberant 1
musiccaps_names (array) 5 ✖
- Music 2
- Disco 1
- Independent music 1
- Punk rock 1
- Rock music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Particles Like Planets - Out Of Reach (OFFICIAL Music Video) | The Rock song features a passionate male vocalist singing over wide electric guitar melodies, groovy bass guitar, shimmering cymbals, groovy toms, punchy snare and kick hits. It sounds energetic, passionate, emotional and loud. | 2011-11-06T00:52:20Z | Particles Like Planets | Particles Like Planets- http://www.facebook.com/particleslikeplanets If you want to help support us it is available on iTunes Music Video for "Out Of Reach" Artist: Particles Like Planets Album: The Owl In The Archer Director: Jaime Martinez Jaime Martinez- http://www.ilovegrafixphotography.com Credits: Band: Cody Vanhoozen, Tyler Shippy, Eric Boudreau, Mikey Tucker Film Credits: Jaime Martinez, Todd Mckernan, Jasmine Quail Location Credits: Daryl Shippy & Hemet Ryan Airport Label: Unsigned | ["Disco", "Music"] | ["rock", "punchy kick", "punchy snare", "groovy toms", "wide electric guitars melodies", "groovy bass guitar", "shimmering cymbals", "passionate male vocal", "energetic", "passionate", "emotional", "loud"] | 4 | 1QFli7KSXAQ | 270 | |
Babyshambles - Gang of Gin | The low quality recording features an alternative/indie song that consists of a passionate male vocal singing over groovy bass guitar, wide electric guitar melodies, shimmering cymbals and "4 on the floor" kick pattern. It sounds mellow, easygoing, emotional and passionate. | 2009-01-25T10:38:31Z | ninsajala | Babyshambles Gang of Gin Lyrics: I get around to singing about That gang of gin I'm in Then you'll know most certainly The kind of game I'm in You sound around to swinging about The gang of gin I'm rolling in, oh Then you'll know The kind of state I'm in Who will buy my beautiful roses? Who will buy my beautiful songs? Who will buy my beautiful roses? Who will buy my beautiful songs? Oh in a nutshell Yeah in a nutshell, oh In a nutshell In a nutshell I get around to singing about That gang of gin I'm in Then you'll know The kind of game I'm in She was getting pally with a scally in the alley Giving head for gear She calls a spade a spade Got slit from ear to ear Who will buy my beautiful roses? Who will buy my beautiful songs? Who will buy my beautiful roses? Who will buy my beautiful songs? Well I showed no decorum Span my heart out on the forum Looked like a snapshot Of the most tragic day I'll tell you my story The treachery it bores me Carl and McGee both promised me It would not happen this way Carl is kept sedated The frontman elevated And McGee doing all he can to ruin my band And keep me out the way In this industry of fools Musclemen and ghouls If you're not a puppet or a muppet Then you might as well call it a day-ayay The truth here gets distorted The wall scrapings get snorted I'm welcome back if I give up crack But you gave me my first pipe anyway Can't show no decorum Posts left on the forum Was like a snapshot Of the most tragic day | ["Music", "Independent music"] | ["low quality", "alternative/indie", "passionate male vocal", "wide electric guitars melodies", "groovy bass guitar", "shimmering cymbals", "\"4 on the floor\" kick pattern", "mellow", "easygoing", "emotional", "passionate"] | 4 | XI-tRuDZ6HA | 3172 | |
Don't Stop Believin' Karaoke | The low quality recording features a live performance of a rock song that consists of a passionate male vocal, followed by passionate female vocal singing over shimmering cymbals, mellow snare and kick hits, electric guitar melody and groovy bass guitar. It sounds distant, reverberant, but also energetic. | 2008-11-26T18:49:47Z | camelllamamoose | This is a very rough version of a karaoke version of Don't Stop Believin' by Journey If you listen carefully you can hear the vocals in the background | ["Punk rock", "Rock music"] | ["low quality", "rock", "live performance", "passionate male vocal", "passionate female vocal", "shimmering cymbals", "mellow snare", "electric guitar melody", "groovy bass guitar", "mellow kick hits", "reverberant", "distant", "energetic"] | 4 | s5kz8qg4B2Y | 4923 |
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;