musiccaps_details (view)
8 rows where musiccaps_aspects contains "male vocal" and musiccaps_names contains "Roll"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| ROCK AND ROLL DANCE Argentina ZONA SUR | This is a rock and roll piece used as an accompaniment for a dance. There is a male vocal singing at a low-to-medium pitch. The main melody is being played by an electric guitar while the bass guitar is repeating a bass line with a groovy pattern in the background. The acoustic drums are playing an upbeat 4/4 rock and roll beat. There is a raw feeling to it. The tune is catchy. This piece could be playing in the background of a sports bar or a rock bar. It could also work well at sports venues. | 2007-10-26T05:36:25Z | jorgetapdance | rock and roll - ZONA SUR dedicado a todos los rockers ABEL-LUISITO-DANI. la larva - TOTITO - SIMON y mas..... EL EDEN 2006 - | ["Music", "Roll", "Rock and roll"] | ["rock and roll", "dance", "male vocal", "low-to-medium pitch singing", "electric guitar", "bass guitar", "loud", "raw", "catchy", "upbeat"] | 9 | D8-x1T8M4gk | 1442 | |
| Katamari Roll (you up into my life) | This is a video game theme in the style of jazz music. There is a male vocalist singing gibberish while imitating a brass instrument. The vibraphone is playing the main melody. There is a piano playing chords in a syncopated manner. The bass guitar is playing a groovy bass line. The rhythmic background consists of an acoustic jazz drum beat. The atmosphere is dreamy and cheerful. This piece could be playing in the soundtrack of an animation movie during a dream sequence. | 2008-11-26T21:49:26Z | leftofftheark | I know you love me I want to wad you up into my life Lets roll up to be a single star in the sky I hear you calling me I want to wad you up into my life Lets lump up to make a single star in the sky To you, to you Im so in love with you I want to wad you up into my life Lets roll up to be a single star in the sky I need you to feel me I want to wad you up into my life Lets lump up to make a single star in the sky To you I know you love me I want to wad you up into my life Lets roll up to be a single star in the sky I hear you calling me I want to wad you up into my life Lets lump up to make a single star in the sky To you, oh to you Yes to you | ["Music", "Roll", "Soul music"] | ["video game theme", "jazz", "male vocal", "gibberish singing", "vibraphone", "piano", "upright bass", "acoustic jazz drums", "dreamy", "complex", "cheerful"] | 9 | Mv90uA0tmgc | 2307 | |
| Desperation - Steppenwolf | This is a hard rock music piece. There is a male vocalist singing in the lead. The electric guitar is playing the main melody while a bass guitar plays in the background. The acoustic drums are playing a groovy rock beat. There is a raw, psychedelic feel to this piece. It could be playing in the background of a rock bar. | 2009-05-15T23:16:39Z | ELGROOVER | Track 4. 'Desperation'. From the album 'Rest In Peace'. Written by John Kay John Kay: guitars, harmonica, vocals. Rushton Moreve: bass guitar, vocals. Michael Monarch: guitars, backing vocals. Goldy McJohn: hamond organ, piano, electric piano. Jerry Edmonton: drums, percussion, vocals. Gabriel Mekler: Producer Bill Cooper: Engineer Richard Podolor: Engineer ♪♫ When rain drops fall and you feel low Ah, do you ever think it's useless Do you feel like letting go Do you ever sit and do you wonder Will the world ever change And just how long will it take To have it all rearranged Tell me why these things are still the same Tell me why no one can seem to learn from mistakes Take my hand if you don't know where your goin' I'll understand, I've lost the way myself Oh, don't take that old road it leads to nowhere We must return before the clock strikes twelve It's so easy to do nothin' When you're busy night and day Take a step in one direction And take a step the other way So don't quit tryin' when you stumble Don't give up should you fall Keep on searchin' for the passway That will lead you through the wall Don't look back or you'll be left behind Don't look back or you will never find peace of mind Take my hand if you don't know where your goin' I'll understand, I've lost the way myself Oh, don't take that old road it leads to nowhere We must return before the clock strikes twelve Take my hand if you don't know where your goin' I'll understand, I've lost the way myself Oh, don't take that old road it leads to nowhere We must return before the clock strikes ♪♫ http://www.steppenwolf.com/ The official Steppenwolf website. ~ Audio blocked by UMG, 20th July 2012 ~ | ["Music", "Roll"] | ["hard rock", "male vocal", "electric guitar", "bass guitar", "acoustic drums", "groovy", "raw", "psychedelic"] | 9 | Utl5it7YMUs | 2953 | |
| SOY TU ROMANTICO ROCK AND ROLL | This is a rock music piece. The male vocalist is singing melodically in the Spanish language. The keyboard is playing the chords of the song while the electric guitar joins with the occasional fills. There is a relatively quiet bass guitar supporting them in the background. The acoustic drums provide a basic rock beat for the rhythm. It has an easygoing feeling. This piece could be used in a teenage drama taking place in a Spanish-speaking country. | 2011-07-13T23:21:03Z | Alejandro Emmanuel | ["Music", "Roll", "Rock and roll"] | ["rock music", "male vocal", "electric guitar", "bass guitar", "keyboard", "acoustic drums", "spanish", "easygoing"] | 9 | deIj55UAxeo | 3806 | ||
| My SunShine ROCK'A'TRENCH cover HD 【THE FUCKIN' EVOLBAND】 | This is a pop rock music piece being performed in the studio. There is a male vocalist singing melodically in the lead. The electric guitar is playing a simple tune with the bass guitar in the background. The acoustic drums are playing an upbeat rhythm with off-beat hi-hat strokes. The atmosphere is energetic. This piece could be used as the opening theme of a Korean teenage drama TV series. | 2009-11-06T14:31:39Z | PROJECTJEI | in STUDIO YOU Oct. 30, 2009 | ["Drum kit", "Music", "Musical instrument", "Ska", "Roll"] | ["pop rock", "studio performance", "male vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drum", "upbeat", "energetic", "lively"] | 9 | eJFZuX0WHgk | 3856 | |
| Rock And Roll Mix!!!! Glam Classic Rock | This is a glam rock/classic rock music piece. There is a male vocalist singing melodically. The main theme is being played by the electric guitar while the bass guitar is playing in the background. The rhythm is provided by a rock acoustic drum beat. There is a loud vinyl hiss because of how aged the record is. The atmosphere is groovy. This piece could be playing in the background of a rock bar. | 2008-09-14T00:48:03Z | realmss | Mix includes: The Sweet-Blockbuster, David Bowie-Jean Genie, Chicory Tip-Son Of my Father, T. Rex-Hot Love, T. Rex- Metal Guru, Norman Greenbaum-Spirits in the Sky and Gary Glitter-Rock and Roll Part 1. Enjoy!!! | ["Music", "Rock music", "Roll", "Rock and roll"] | ["glam rock", "classic rock", "male vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "vinyl hiss", "groovy", "crunchy", "easygoing"] | 9 | ot6SpwD1hzk | 4661 | |
| Poison- I Won't Forget you Lyrics | This is a glam metal/heavy metal ballad. There is a male vocal and male back vocals singing melodically. The melody is being played on an electric guitar with a chorus effect applied alongside a bass guitar. The rhythmic background consists of a rock acoustic drum beat.The atmosphere is both hard-hitting and sentimental at the same time. This piece could be playing in the background of a rock/metal bar. It could also be included in the soundtrack of an 80s themed romance movie. | 2009-08-26T19:16:57Z | GenreLyrics | Thank you MaSSaChRoNiC for suggesting this song to me. | ["Music", "Roll", "Rock and roll"] | ["glam metal", "heavy metal", "ballad", "male vocal", "male back vocals", "electric guitar", "bass guitar", "acoustic drums", "hard-hitting", "sentimental", "medium tempo"] | 9 | uiHyWdYkBvY | 5133 | |
| Musical Youth - Pass The Dutchie live in 1983 (with lyrics) | This is the live performance of a reggae piece. There is a male vocal hollering while a younger sounding male vocal is singing in a Jamaican accent. An electric guitar is strumming chords in staccato while a bass guitar is playing a groovy bass line. In the rhythmic background, there is an acoustic drum playing a reggae beat. The atmosphere is chill. This piece could be played at beach parties and in the soundtracks of summer vacation-themed movies or TV shows. | 2007-10-03T03:19:51Z | reggaeman91 | Facebook: https://www.facebook.com/BobMarleyArchive Website: http://bobmarleyarchive.com/ The song was a cover version of the song "Pass the Kouchie" by The Mighty Diamonds, which deals with the recreational use of cannabis, "kouchie" being slang for a cannabis pipe. For the cover version, the song's title was bowdlerized to "Pass the Dutchie" and all obvious drug references were removed from the lyrics; e. g., when the original croons "How does it feel when you got no herb?", the cover version refers to "food" instead. Musical Youth Pass The Dutchie on stage in 1983 LYRICS : This generation Rules the nation With version Music happen to be the food of love Sounds to really make you rub and scrub I say Pass the Dutchie on the left hand side Pass the Dutchie on the left hand side It a good burn, give me music make me jump and prance It a go done, give me the music make me rock in the dance It was a cool and lovely breezy afternoon (How does it feel when you've got no food) You could feel it 'cause it was the month of June (How does it feel when you've got no food) So I left my gate and went out for a walk (How does it feel when you've got no food) As I pass the dreadlocks' camp I heard them say (How does it feel when you've got no food) Pass the Dutchie on the left hand side Pass the Dutchie on the left hand side It a good burn, give me music make me jump and prance It a go done, give me the music make me rock in the dance So I stopped to find out what was going on (How does it feel when you've got no food) 'Cause the spirit of Jah, you know he leads you on (How does it feel when you've got no food) There was a ring of dreads and a session was there in swing (How does it feel when you've got no food) You could feel the chill as I seen and heard them say (How does it feel when you've got no food) Pass the Dutchie on the left hand side Pass the Dutchie on the left hand side It a good burn, give me music make me jump and prance It a go done, give me the music make me rock in the dance 'Cause me say listen t… | ["Singing", "Music", "Roll"] | ["reggae", "dub", "live performance", "male vocal", "teen male vocal", "electric guitar", "bass guitar", "acoustic guitar", "groovy", "laid back", "fun", "chill"] | 9 | xt6V3Ic72nE | 5359 |
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;