musiccaps_details (view)
5 rows where musiccaps_aspects contains "male singer" and musiccaps_aspects contains "pop rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 83 ✖
- male singer · 5 ✖
- pop rock · 5 ✖
- buoyant 2
- energetic 2
- fast tempo 2
- poignant 2
- rock 2
- simple melody 2
- soft rock 2
- youthful 2
- acoustic guitar 1
- acoustic music 1
- alternative rock 1
- amplified instruments 1
- amplified piano 1
- animated 1
- atmospheric 1
- boisterous 1
- boomy bass lines 1
- breakup song 1
- catchy 1
- children’s song 1
- classic rock 1
- cymbals 1
- dance groove 1
- dream pop 1
- droning keyboard harmony 1
- electric guitar melody 1
- electrifying 1
- electronic rhythm 1
- emotional 1
- energetic music 1
- enthusiastic 1
- enthusiastic drumming 1
- folk rock 1
- fun 1
- geek rock 1
- happy 1
- hard rock 1
- heavy metal 1
- intense electric guitar lead 1
- introspective 1
- keyboard accompaniment 1
- keyboard harmony 1
- lonely 1
- longing 1
- loud 1
- love song 1
- medium fast tempo 1
- melancholic 1
- mellow 1
- melodic 1
- metal 1
- movie soundtrack 1
- passionate 1
- peppy 1
- perky 1
- pulsating 1
- punchy 1
- punchy drumming 1
- regretful 1
- rhythmic acoustic guitar 1
- rock music 1
- romantic 1
- sad 1
- sentimental 1
- shakers 1
- simple harmony 1
- slow tempo 1
- sombre 1
- sonic power 1
- spirted 1
- steady bass line 1
- steady bass lines 1
- straightforward drumming 1
- synth arrangements 1
- synth pop 1
- tambourine beats 1
- upbeat 1
- vigorous drumming 1
- vivacious 1
- wistful 1
- youthfull 1
musiccaps_names (array) 12 ✖
- Music 5
- /t/dd00032 1
- Exciting music 1
- Funk 1
- Grunge 1
- Progressive rock 1
- Rock music 1
- Ska 1
- Song 1
- Soul music 1
- Swing music 1
- Theremin 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ratrace Music Video | A male vocalist sings this simple, peppy melody. The tempo is fast with keyboard harmony, enthusiastic drumming, steady bass line, acoustic guitar rhythm and electronic arrangements. The song is fun, animated, upbeat, catchy, energetic, spirited and vibrant and appealing to children . This song is a Synth Pop/Rock. | 2008-10-01T02:40:34Z | PlasticManFilms | Aniamting to the song Ratrace. clips of many of our videos along with the stort story of a hobo who has a spending problem.PLEASE COMMENT | ["Music", "/t/dd00032"] | ["male singer", "fast tempo", "energetic music", "peppy", "buoyant", "electronic rhythm", "enthusiastic drumming", "rhythmic acoustic guitar", "steady bass line", "fun", "youthful", "animated", "spirted", "vivacious", "happy", "children’s song", "synth arrangements", "synth pop", "pop rock"] | 7 | EaGhKzpkNso | 1574 | |
Barenaked Ladies - Sound of Your Voice [Official Music Video] | A male vocalist sings this simple pop. The tempo is medium with an electric guitar melody, keyboard accompaniment, steady drumming, steady bass lines and acoustic guitar rhythm. The song is a simple, melodic, earnest, engaging Soft Rock; | 2007-02-06T16:45:04Z | Barenaked Ladies (official) | "Sound of Your Voice" by Barenaked Ladies from Barenaked Ladies Are Men, available now. Download on iTunes: http://smarturl.it/kk3vd8 Links: http://www.facebook.com/barenakedladies http://twitter.com/barenakedladies "Sound Of Your Voice" Lyrics: The moon is full but there is an incompleteness The days are beautiful but I feel a bitter sweetness If I had a wish, or even a choice I'd wake up to the sound of your voice How I miss waking up to the sound of your voice I let you down and fell right off of your good list I hope each day you'll find peace and forgiveness The alarm clock rings, What a lonely noise And I long for the sound of your voice Oh, how I miss waking up to the sound of your voice Take it from me: there's not much to see In this void The saying goes there will be other dances (don't give up) This little song is about second chances Just say the word and I will rejoice And wake up to the sound of your voice Oh, how I miss waking up to the sound To the sound (sound) To the sound (to the sound) To the sound Waking up to the sound of your voice Take it from me: there's not much to see In this void Subscribe to Nettwerk's YouTube channel: http://smarturl.it/nettwerkyoutube | ["Music", "Exciting music"] | ["male singer", "electric guitar melody", "folk rock", "pop rock", "rock music", "acoustic music", "alternative rock", "introspective", "melancholic", "poignant", "geek rock", "simple harmony", "classic rock", "straightforward drumming", "keyboard accompaniment", "simple melody", "soft rock", "pop rock", "mellow", "melodic", "romantic", "love song", "steady bass lines"] | 7 | FoFMRXlNJ6Y | 1666 | |
Forgotten Suns - Walk On | A male vocalist sings this enthusiastic Rock. The tempo is fast and upbeat with a vigorous electric guitar lead and harmony, hard hitting drums and amplified keyboard. The music is an energetic, boisterous, youthful, enthusiastic, engaging, pulsating and electrifying Hard Rock. | 2006-12-13T08:02:40Z | tyepennington | Footage taken from a gig at The Mandarin Club on 5th August 2006. | ["Music", "Rock music", "Progressive rock", "Grunge"] | ["male singer", "fast tempo", "rock", "hard rock", "sonic power", "cymbals", "youthful", "pulsating", "electrifying", "enthusiastic", "amplified instruments", "vigorous drumming", "intense electric guitar lead", "keyboard harmony", "upbeat", "energetic", "loud", "boisterous", "enthusiastic", "metal", "heavy metal", "pop rock", "dance groove"] | 7 | J9ZlahUawkg | 1975 | |
WHITE STRIPES - My Doorbell | A male vocalist sings this perky pop song. His tempo is medium fast with punchy drumming; animated amplified piano accompaniment, tambourine beats and funky bass lines. The song is simple, peppy, engaging, energetic, story telling, and catchy. This song is Classic Pop/ Soft Rock. | 2013-05-04T13:12:45Z | Jurassic56 | "My Doorbell" by the American alternative rock band The White Stripes is the second single from their album Get Behind Me Satan (2005). The song garnered The White Stripes a 2006 Grammy nomination for Best Pop Performance by a Duo or Group with Vocals. The White Stripes were an American rock duo, formed in 1997 in Detroit, Michigan. The group consisted of drummer Meg White (drums and occasional vocals) and songwriter Jack White (vocals, guitar, and keyboards). Meg and Jack White were previously married to each other, but are now divorced. After releasing several singles and three albums within the Detroit music scene, the White Stripes rose to prominence in 2002, as part of the garage rock revival scene. Their successful and critically acclaimed albums White Blood Cells and Elephant drew them attention from a large variety of media outlets in the United States and the United Kingdom, with the single "Seven Nation Army" and its now-iconic guitar riff becoming a huge hit. The band recorded a further two albums, Get Behind Me Satan in 2005 and Icky Thump in 2007. The group was dissolved in 2011 after a lengthy hiatus from performing and recording. The White Stripes used a low-fidelity approach to writing and recording. Their music featured a melding of garage rock and blues influences and a raw simplicity of composition, arrangement, and performance. The duo was also noted for their fashion and design aesthetic which featured an exclusive use of a simple color scheme of red, white, and black, which was used on every album and single cover the band released- as well as the band's obsession with the number three. The band's discography consists of six studio albums, one live album, two extended plays (EP), one concert film, one tour documentary, twenty-six singles, and fourteen music videos. Their last three albums each won the Grammy Award for Best Alternative Music Album. LYRICS: I'm thinkin' about my doorbell When ya gonna ring it, when ya gonna ring it Yeah, I'm thinkin' about my doorbell When … | ["Swing music", "Funk", "Music", "Ska", "Song", "Soul music"] | ["male singer", "medium fast tempo", "amplified piano", "tambourine beats", "punchy drumming", "boomy bass lines", "buoyant", "punchy", "perky", "energetic", "youthfull", "shakers", "simple melody", "catchy", "rock", "pop rock", "soft rock"] | 7 | MzUgHy7SyS8 | 2314 | |
harry & eggsy | all i want | A male vocalist sings this sad melody. The tempo is slow with an acoustic guitar accompaniment and a droning keyboard harmony. The song is soft ,mellow, sad, emotional, sentimental, regretful , lonely and poignant. This song is an Alternative Rock/Indie. | 2015-08-20T05:52:36Z | stoleyourmateria | HARTWIN WEEK: Day 5: angst ----------------------------------------------------------------- (PLEASE WATCH IN HD) this is kind of a companion piece to my hartwin "love love love" fanvid. i had a lot of fun editing this. hope you enjoy the angst! :D ----------------------------------------------------------------- • fandom: kingsman • pairing: harry hart & eggsy unwin • song: "all i want" by kodaline ---------------------------------------------------------------- Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use. | ["Music", "Theremin"] | ["male singer", "slow tempo", "acoustic guitar", "atmospheric", "poignant", "dream pop", "lonely", "pop rock", "longing", "sombre", "breakup song", "passionate", "sad", "wistful", "emotional", "sentimental", "regretful", "wistful", "movie soundtrack", "droning keyboard harmony"] | 7 | gTX4SG70cEY | 4032 |
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;