musiccaps_details (view)
13 rows where musiccaps_aspects contains "electric guitar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Arcade Fire (live) - "Poupee de Cire, Poupe de son" | This folk rock song features an electric guitar playing the main melody in the form of a solo. This is accompanied by fast paced percussion. Another guitar plays a galloping rhythm. A violin plays staccato notes at a fast tempo and the notes follow the root notes of the chords but at higher octaves. This is an instrumental song with no voices. This song has a hippie feel. This song can be played in a retro movie with a hippie theme. | 2007-10-04T15:11:40Z | Ismael Fernandez | A "new" song from Arcade Fire performed at the Olympia Theater in Paris. It's a cover of an old song. http://www.youtube.com/watch?v=8OHJEm2IwLw | ["Singing", "Music", "Roll"] | ["folk rock", "no voices", "instrumental", "fast tempo", "low quality audio", "electric guitar", "distortion guitar", "fast paced percussion", "staccato violin", "uptempo"] | 0 | 752bW5cjXzw | 808 | |
| Grateful Dead - Cream Puff War 1967 | This is a rock music piece. There is a medium-to-high pitched electric guitar solo at the forefront. In the melodic background, a keyboard and a bass guitar repeating the same pattern can be heard. The acoustic drums are playing a loud and slightly fast-paced rock drum beat. There is a rebellious atmosphere to this piece. It can be used in the soundtrack of a teenage drama or a crime shootout video game. | 2008-12-06T17:32:21Z | gratefulvideo | Quote from Jerry Garcia (with typo) Something's Happening 1967 | ["Music", "Roll"] | ["rock music", "electric guitar", "guitar solo", "keyboard", "bass guitar", "acoustic drums", "loud", "rebellious", "eclectic", "psychedelic"] | 9 | C1M5xqDQW58 | 1319 | |
| 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 | |
| Yeah Yeah (Je-Je) - Deja Voodoo - Urgente Rock and Roll | The punk-rock music features a male voice singing a static melody. An electric guitar with a distortion effect accompanies the singer with repetitive chords. The drums play a simple and repetitive rhythm. | 2008-12-23T04:36:51Z | opentaker | si alguien sabe como se llama y quien la canta me deja el comentario para modificar el video por favor | ["Music", "Roll", "Rock and roll"] | ["male voice", "static melody", "drums", "electric guitar", "distortion effect", "punk-rock genre"] | 2 | OFP5MYVDa4g | 2419 | |
| 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 | |
| Acrobatic Rock and Roll - Europe championship 2009 - Foot technique | This is the live recording of a dance performance that uses a pop music piece as accompaniment. There is a male and a female vocalist singing melodically. The tune of the piece is being played by the electric guitar, the bass guitar and the synth. There is an upbeat acoustic drum beat in the rhythmic background. The audience can be heard clapping to the beat. The atmosphere is loud and lively. It could work well as the backing track in a modern dance course. | 2009-11-16T10:03:37Z | Tomáš Tlášek | RNR - Velika Gorica - 7.11.2009 - Foot technique - Ivan KLIMOV - Katrin GAZAZYAN (RUS), Lukas FURST - Alzbeta SLAMOVA (CZE), Maurizio MANDORINO - Jade MANDORINO (SUI), Jacek TARCZYLO - Anna MIADZIELEC (POL), Julien FOULON - Ingrid FOULON (FRA), Michael TRÜB - Stephanie RÜEGG (SUI), Neven IVIC - Ivana MIHALIC (CRO) | ["Music", "Roll", "Rock and roll"] | ["pop music", "dance", "male and female vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "synth", "audience clapping", "loud", "lively", "catchy", "upbeat"] | 9 | ggBivmG6yHQ | 4045 | |
| ROCK AND ROLL (G) BY SILASOUREN | This is an instrumental rock and roll music piece. An overdriven electric guitar is playing the melody while a bass guitar is playing the background. There is a basic rock drum beat keeping the rhythmic structure. There is a groovy, easygoing atmosphere. This music could be played in the background at a rock bar or a sports venue. | 2010-06-08T13:26:18Z | silasouren | BASE DE ROCK EN G DISFRUTENLA PINCHES | ["Music", "Roll", "Rock and roll"] | ["rock and roll", "instrumental", "electric guitar", "overdriven", "bass guitar", "acoustic drums", "simple tune", "groovy", "easygoing"] | 9 | hzr2aY33EuI | 4155 | |
| 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 | |
| Chuck Berry - Let It Rock | This is a live recording from a rock music concert. There is an electric guitar playing the rhythm section upfront with a loud drum background. A harmonica solo is being played over the guitar and the drums. The song carries a playful and energetic atmosphere. This music could be played at a bar, especially a rock bar. | 2007-02-01T07:57:35Z | scout free | Chuck Berry - 29/01/07, BEC (Barakaldo, Spain) In The Heat Of The Day Down In Mobile Alabama Working on the railroad with the steel driving hammer Gotta make some money to buy some brand new shoes Tryin' to find somebody to take away these blues "She don't love me" hear them singing in the sun Payday's coming and my work is all done Later in the evening when the sun is sinking low All day I been waiting for the whistle to blow Sitting in a teepee built right on the tracks Rolling them bones until the foreman comes back Pick up you belongings boys and scatter about We've got an off-schedule train comin' two miles out Everybody's scrambling,'n'jumping around Picking up their money, tearing the teepee down Foreman wants to panic, 'bout to go insane Trying to get the workers out the way of the train Engineer blows the whistle long and long Can't stop the train, gotta let it roll on | ["Drum kit", "Music", "Musical instrument", "Rock music", "Roll", "Rock and roll", "Percussion"] | ["rock", "electric guitar", "drums", "harmonica", "live performance", "loud", "playful"] | 9 | wMi_0eEIpcM | 5262 | |
| 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;