musiccaps_details (view)
6 rows where musiccaps_aspects contains "male singer" and musiccaps_aspects contains "rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 91 ✖
- male singer · 6 ✖
- rock · 6 ✖
- energetic 4
- hard rock 4
- enthusiastic 3
- fast tempo 3
- youthful 3
- animated 2
- buoyant 2
- dance groove 2
- groovy bass line 2
- hard hitting drums 2
- heavy metal 2
- metal 2
- pop rock 2
- punchy 2
- spirited 2
- alternative/indie 1
- amplified instruments 1
- amplified keyboard harmony 1
- amplified piano 1
- animated electric guitar accompaniment 1
- art rock 1
- ballad 1
- bitter 1
- blues 1
- blues-rock 1
- blues-rockvigorous electric guitar 1
- boisterous 1
- boomy bass lines 1
- breakup 1
- busy 1
- captivating keyboard harmony 1
- catchy 1
- chaotic 1
- classic rock 1
- concert 1
- cymbal crash 1
- cymbals 1
- dance music 1
- depressed 1
- dominating electric guitar 1
- electrifying 1
- electronic music 1
- emphatic piano 1
- enthusiastic vocals 1
- freddie mercury 1
- funky bass line 1
- heart break 1
- hit songs 1
- hurt 1
- imposing music 1
- intense 1
- intense drumming 1
- intense electric guitar lead 1
- keyboard harmony 1
- lonely 1
- loud 1
- loud electric guitar feedback 1
- medium fast tempo 1
- medium tempo 1
- opera 1
- perky 1
- poignant 1
- pop 1
- progressive pop 1
- progressive rock 1
- pulsating 1
- punchy drumming 1
- queen 1
- rock hits 1
- sad 1
- shakers 1
- simple melody 1
- slow tempo 1
- soft 1
- soft rock 1
- song introduction 1
- sonic power 1
- strong vocals 1
- subdued vocals 1
- synthesiser arrangement 1
- tambourine beats 1
- upbeat 1
- video game music 1
- vigorous 1
- vigorous drumming 1
- vigorous electric guitar riff 1
- vital 1
- vivacious 1
- youthfull 1
musiccaps_names (array) 12 ✖
- Music 6
- Grunge 2
- Blues 1
- Exciting music 1
- Funk 1
- Independent music 1
- Progressive rock 1
- Rock music 1
- Ska 1
- Song 1
- Soul music 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Halloween 2014 Light Show. Queen, Bohemian Rhapsody. Thomas Halloween House, Naperville IL | A male vocalist sings this Pop song. The tempo is slow with a melodic and emphatic piano accompaniment. This bit has minimal instrumentation as it is the introduction. The music is burgeoning with a cymbal crash introduced at the end of this clip. The song is slow, sad, poignant, reflective and nostalgic. This song is a hit Pop Rock. | 2014-10-01T05:31:59Z | Steve Jandick | Thomas Halloween 2014, Conan Doyle Rd, Naperville IL. 96 LOR Channels Donations are being collected for Gigi's Playhouse this year. Come out and see the light show and donate, or donate here: http://gigisplayhouse.org/ For sequence info, check out holidaysequences.com For info on the singing faces, check out holidaycoro.com | ["Music", "Independent music"] | ["male singer", "slow tempo", "soft", "emphatic piano", "cymbal crash", "strong vocals", "song introduction", "hard rock", "progressive rock", "alternative/indie", "progressive pop", "pop", "rock", "art rock", "queen", "hit songs", "freddie mercury", "ballad", "opera"] | 7 | 4vWChPYkuwA | 617 | |
I Prevail - Stuck In Your Head (Official Music Video) | A male vocalist sings this enthusiastic Rock song. The tempo is fast with bright drumming, enthusiastic electric guitar harmony, keyboard accompaniment , groovy bass line. The song is youthful, enthusiastic, energetic, vital, vigorous and passionate rock. | 2016-10-22T16:00:46Z | IPrevailBand | Stream ‘TRUE POWER’ - https://found.ee/iptruepower Get Official I Prevail merch - https://found.ee/tp_merch "Stuck In Your Head" taken from the album 'Lifelines' available now. ITUNES: http://smarturl.it/IPlifelines Video by Drew Russ. http://drewruss.com/ Follow I Prevail: Website: https://found.ee/ip_web Facebook: https://found.ee/ip_facebook Twitter: https://found.ee/ip_twitter Instagram: https://found.ee/ip_instagram TikTok: https://found.ee/ip_tiktok Spotify: https://found.ee/ip_spotify Apple Music: https://found.ee/ip_applemusic Stay Connected with Fearless Records: Website: http://www.fearlessrecords.com/ Facebook: https://found.ee/FearlessFB Instagram: https://found.ee/FearlessIG Twitter:https://found.ee/FearlessTW Subscribe to Fearless Records on Youtube: http://found.ee/fr_youtube LYRICS: You’re not the one I want in my bed But I’m gonna be the song stuck in your head Stuck in your head Stuck in your head Guess what? For the record you’re the broken one Tried to sing along but we got stuck So we turn it over and over again But now, a thousand scratches on the song we held A million cuts finally wore it down Couldn’t turn it over and over again Turn it over and over again This’ll be the last time that I spin our life Never gonna play again You’re not the one I want in my bed I’m not the song you want in your head This’ll be the last time that I spin our life Never gonna play again You’re not the one I want in my bed But I’m gonna be the song stuck in your head Stuck in your head Guess what? Didn’t wanna have to write these words Now you’re on the other side reversed Never turning over and over again So now, I’ll turn it off cuz it’s so damn loud All your lies finally wore me down You can skip our track, cuz I’m not coming back This’ll be the last time that I spin our life Never gonna play again You’re not the one I want in my bed I’m not the song you want in your head This’ll be the last time that I spin our life Never gonna play again You’re not the one I want in my bed But I’m gonna be the… | ["Music", "Exciting music"] | ["male singer", "fast tempo", "rock", "hard rock", "metal", "heavy metal", "hard hitting drums", "animated electric guitar accompaniment", "groovy bass line", "captivating keyboard harmony", "enthusiastic vocals", "youthful", "electronic music", "dance music", "energetic", "enthusiastic", "spirited", "animated", "vigorous", "vital", "dance groove"] | 7 | 5keRbrVx-G4 | 690 | |
Joe Bonamassa - "Blues of Desperation" - Official Music Video | A male vocalist sings this emphatic rock. The tempo is medium with vigorous electric guitar, synthesiser arrangement, groovy bass line and intense drumming. The vocals are soft ,sad, lonely, poignant, mellow, and melodic in contrast to the intense instrumentation. This song is Blues-Rock. | 2016-08-01T14:41:20Z | JoeBonamassaTV | ► STREAM JOE NOW: https://jbonamassa.com/streaming/ ► FREE ALBUM DOWNLOAD - http://goo.gl/9oI018 ● Official Tickets ● http://jbonamassa.com/tour-dates/ ● Official Social Links ● https://www.facebook.com/JoeBonamassa https://twitter.com/jbonamassa https://instagram.com/joebonamassa/ https://www.pinterest.com/jbonamassa/ ● Official Merchandise ● http://shop.jbonamassa.com/ | ["Blues", "Music"] | ["male singer", "medium tempo", "sad", "depressed", "heart break", "blues-rock", "vigorous electric guitar riff", "breakup", "hurt", "poignant", "bitter", "lonely", "blues-rockvigorous electric guitar", "synthesiser arrangement", "blues", "rock", "groovy bass line", "intense drumming"] | 7 | 6JJMlY3Go9s | 743 | |
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 | |
Ace Pk Session 1 | Maxed Chaotic Pure | 100% Pure Hybridding | Eruption of Pures | A male vocalist sings this spirited Rock song. The tempo is fast with an upbeat Amplified keyboard harmony, hard hitting drums, punchy bass lines and a dominating electric guitar accompaniment. The vocals are subdued for a Rock song. The song is youthful, vibrant, energetic, enthusiastic, buoyant, punchy and vivacious. This song is Classic Hard Rock. | 2011-11-25T01:44:13Z | AceyFiasco | I tried my best guys, all feedback is appreciated. You can join the clan I'm in @ EoP-Rs.com Runescape is owned and operated by Jagex Limited ("JaGeX"), I Do Not own Runescape i make videos for entertainment purposes "Only" and not for the sake of profiting.All music used in my videos is purchased and not for the intent of redistributing it. You Can Play Runescape At: http://www.runescape.com IGNORE THE FOLOWING~~~~~~~~~~~~~ bounty hunter TERMPINATION TERMPINATIONZ BH VID # 1 blue stanger TERPINATIONownage range of ish PD OWN TRILE12 STR B0S 001 runescape bs bh pking bounty hunter pking blue bountyhunter bs bh rs runescape jagex ltd rs elvemage kids ranqe defil3d elf mage pka i ayzee i wildy owns1 spanjol 91 bloodhoun34zezima youbleedred i kasoy i xxphatmagexx dawgsaysftw skychi review best Bounty Hunter video armadylgodsword ownage ko pk whip pks barrow pks spartacus121 best pker in rs best pker pk vid. best pker bounty hunter vid Archer96 Letterbomb05's Dark Bow theunforgiving yogosun yogosun2 fat wrecked zeldagirl8 lvl126inrs sosolid2k maxboisen Tehnoobshow Runescape Zezima Interview max hits high hits Best Lure video ever purple 0wnz bloodhoun34 OMG runescape pking wild pker ownage zezima phat lure KIDS RANQE PURPLE 0WNZ ZEZIMA N0VALYFE PHAT LURE OWNAGE RUNESCAPE WILDY WILDERNESS ELVEMAGE ELVEMAGE RUNESCAPE PKING RUN3 4RR0WPK OWNAGE MAIKEL PRO I MAHATMA I EVO BLOODHOUN34 KIDS RANQE KRAZYFAKEN RUNESCAPE PKER RUNESCAPE PKING INTIATE PURE OWNAGE LURE PHAT 99 1337 PWNAGE PKING PKERS PK PARTYHAT ZEZIMA N0VALYFE RUNESCAPE WILDY BARRAGE ANCIENTS LURING FROSTYDAPKER JETCHIMP BLOOD SEASON BLOODHOUN34 I Mahatma I, Stonecoldpkr,P0ke N Die2, Sourpatchk1d, Krazyfaken, Kids Ranqe ,dragon claws maxxing 1 Pure Devil, Evilsexc, Dizzy Mauler, I Shonomercy, E4t F0od Nub, Im Easy Xp, Iminsan3, Pure insan3, and Xoxofuryxoxo.pvp best loots whipper whip elvemage sv3rige bloofhoun34 is elvemage bloodhoun34 hiei the pk lexmark78 6th outlaw i meleed i ultimate strength hybrid barrage blitz burst 99 range mage krazyfaken f… | ["Music", "Grunge"] | ["male singer", "fast tempo", "rock", "hard rock", "dominating electric guitar", "punchy", "buoyant", "vivacious", "video game music", "animated", "chaotic", "busy", "rock hits", "concert", "hard hitting drums", "loud electric guitar feedback", "amplified keyboard harmony", "funky bass line", "subdued vocals", "imposing music", "youthful", "energetic", "enthusiastic", "spirited", "vivacious", "classic rock", "intense"] | 7 | dHGAXJ9RPJs | 3773 |
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;