musiccaps_details (view)
10 rows where musiccaps_aspects contains "acoustic drums" 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Slash not happy with guitar tech Camp Freddy 12- | An acoustic drum and a bass are repeating the same pattern along with two e-guitars playing along with the melody while a male voice sings slightly soulful and loud. In the background a crowd is sheering. The recording is of very poor audio quality. This song may be playing at a live concert. | 2013-12-24T22:43:09Z | jwalker1200 | Camp Freddy at The Roxy Hollywood,ca. Slash comes out to perform "Schools Out" discovers that his guitar is out of tune! | ["Singing", "Guitar", "Music", "Roll", "Rock and roll"] | ["alternative7rock", "e-guitars", "e-bass", "acoustic drums", "background cheering", "male voice singing", "amateur recording", "uptempo"] | 6 | 1MwaXCfUvX8 | 263 | |
| 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 | |
| 06. KISS - Do You Remember Rock and Roll Radio ( A tribute to Ramones) | This song contains male voices singing/shouting while an acoustic drum is playing an elevating pattern on the toms. You can hear hands clapping to the beat. A brass section/saxophones are playing a repeating melody creating tension. Then the song breaks into the next part with a piano playing along with the melody. This song may be playing at a live concert. | 2012-03-05T19:29:37Z | shunandro | I do not own the rights of the music | ["Music", "Roll", "Rock and roll"] | ["rock&roll", "e-guitars", "piano", "e-bass saxophones/brass", "acoustic drums", "male voices singing/shouting", "uplifting energy", "uptempo"] | 6 | U6SYfguaJtk | 2887 | |
| 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 | |
| Bionic Man - Fabulous Poodles - Urgente Rock and Roll | An acoustic drum is playing a light Rock&Roll groove with crash hits and emphasis on kick and snare along with a e-bass enhancing the fast paces mood and giving reasons to move the body along to the beat. Strings like a violin are adding some atmosphere with hits in the background and playing a crescendo to break into the next part of the song while male voices are singing together. This song may be playing when having or wanting a good mood. | 2008-12-27T03:00:04Z | opentaker | hay les dejo otra rola de los poodles muy buena esta la encontre en el cd de his masters choice | ["Music", "Roll", "Rock and roll"] | ["rock&roll", "e-bass", "acoustic drums", "male voices singing", "violin", "uptempo", "good mood"] | 6 | Vt3HzkNtOP4 | 3039 | |
| 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 |
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;