musiccaps_details (view)
12 rows where musiccaps_aspects contains "electric guitar" and musiccaps_names contains "Rock and 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Whir - Daria's Theme (Live at Circus Bar - 2001) | The rock music features a male voice singing a repeating melody and being backed by other male vocals. The electric guitar plays fast chords with a distortion effect on and the bass guitar follows with the same speed. The drums play a fast repeating rhythm. The quality of the audio is really low and so this leads me to believe this is an amateur recording. | 2007-12-16T16:36:07Z | Rety Matos | É isso aí: Show do Whir - Torto, mal gravado, com erros, muitos amigos e foda. Bem, pelo menos pra mim era muito foda... :) Sétima música do show: 7) Daria's Theme (Splendora Cover) Ah, show gravado no Circus Bar em 2001, dia do meu aniversário \o/ Abertura do Fuss. | ["Music", "Whir", "Rock and roll"] | ["low quality recording", "male voice", "male backing vocals", "electric guitar", "distortion effect", "drums", "bass guitar", "rock genre", "fast tempo"] | 2 | 3sIlpn9nvKU | 510 | |
| Blue devils - Mystery girl | This is a rock-n-roll music piece. There is a male vocalist singing as if he is telling a story in the lead. The electric and the bass guitar are playing a simple tune. The acoustic drums are playing an upbeat rhythm with a heavy use of rimshots. The atmosphere of the piece is groovy. This piece could be used in the soundtrack of a romance/romantic comedy movie where the protagonist cannot stop thinking about a girl. | 2008-09-10T20:16:30Z | Tage_ | ["Music", "Ska", "Rock and roll"] | ["rock-n-roll", "male vocal", "story-telling mood", "electric guitar", "simple tune", "bass guitar", "acoustic drums", "rimshots", "upbeat", "energetic", "groovy"] | 9 | D6xrH93lnoc | 1437 | ||
| 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 | |
| Stray Cat Strut by The Nosey Joe Band | The music features a male voice singing a descending melody that repeats. The instrumental consists of a drum kit that's playing a light rhythm, a double bass that's playing a repeating descending melody and an electric guitar that's strumming chords once per beat. The quality of the audio recording is not so good which leads me to believe this is an amateur recording and not something professional. | 2008-05-28T02:57:13Z | pookyfmr | This is our version of the song made famous by the Stray Cats. | ["Blues", "Singing", "Music", "Rock and roll"] | ["male voice", "reverb effect", "electric guitar", "double bass", "drums", "low audio recording quality"] | 2 | FvQgVl5IBHw | 1676 | |
| 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 | |
| Strawfoot - churchyard cough live | This is a country music piece. There is a male vocalist singing in a preaching manner. The melody is being played by a violin, a banjo and an electric guitar while an upright bass is playing in the background. The rhythmic background consists of an accentuated acoustic drum beat. The atmosphere is lively and hard-hitting. This piece could be used in the soundtrack of a historical crime movie taking place in the US. | 2009-06-01T06:07:26Z | Word Smith | Dirge-Country pioneers, Strawfoot, bring a dark sound of candy-coated salvation and eternal hellfire and damnation to the public with haunting cautionary tales of outlaw scarecrows, wayward preachers, falling pianos, and the devil. Strawfoot creates an original sound steeped in the rich, dark history of America and beyond. Fronted by a crazed and angry preacher, Strawfoot is a seven-piece band consisting of violin, banjo, harmonica, upright bass, guitar, percussion and the occasional mandolin and accordian. Strawfoot has quickly become a fan favorite wherever they take the stage, gaining fans across America and abroad. | ["Music", "Ska", "Song", "Rock and roll"] | ["country music", "male vocal", "preach-like singing", "violin", "banjo", "electric guitar", "upright bass", "acoustic drums", "lively", "hard-hitting"] | 9 | adYFXYPqo2M | 3562 | |
| 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 | ||
| 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 |
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;