musiccaps_details (view)
8 rows where musiccaps_aspects contains "rock", musiccaps_names contains "Musical instrument" and musiccaps_names contains "Rock music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 76 ✖
- rock · 8 ✖
- energetic 3
- live performance 3
- electric guitar 2
- enthusiastic 2
- loud 2
- low quality 2
- male vocalist 2
- acoustic drums 1
- acoustic guitar 1
- alternative rock 1
- amateur recording 1
- artist 1
- background male vocal 1
- bass 1
- blues 1
- blues rock 1
- bright 1
- cello 1
- cheering clapping 1
- cheering fans 1
- closing riff 1
- concert 1
- contemporary 1
- dance music 1
- distorted electric guitar chords 1
- drums 1
- e-bass 1
- e-guitar 1
- electric guitar lick 1
- electric guitars melodies 1
- emotional 1
- fast tempo 1
- flat male vocal 1
- gig 1
- groovy bass 1
- groovy bass line 1
- guitar 1
- harmonica 1
- harsh 1
- inferior audio quality 1
- intense electric guitar 1
- jarring 1
- keyboard harmony 1
- live audience 1
- live recording 1
- male voices singing 1
- medium fast tempo 1
- medium to uptempo 1
- melancholic mood 1
- messy 1
- no other instruments 1
- no voice 1
- people cheering 1
- people talking 1
- percussion 1
- performer 1
- playback 1
- playful 1
- poor audio quality 1
- pop 1
- pop rock 1
- punchy drumming 1
- punchy kick 1
- punchy snare 1
- repetitive phrase 1
- rhythmic acoustic guitar 1
- rock and roll 1
- shimmering hi hats 1
- slow tempo 1
- soft rock 1
- song end 1
- southern rock 1
- stage performance 1
- vigorous vivacious 1
- vocal backup 1
musiccaps_names (array) 19 ✖
- Music 8
- Musical instrument · 8 ✖
- Rock music · 8 ✖
- Guitar 5
- Drum kit 4
- Plucked string instrument 3
- Rock and roll 2
- Roll 2
- Singing 2
- Bass guitar 1
- Electronic music 1
- Grunge 1
- Inside, large room or hall 1
- Percussion 1
- Progressive rock 1
- Pulse 1
- Punk rock 1
- Shout 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rock 'n' Roll Girls -- John Fogerty | A male vocalist sings this spirited rock and rock song. The tempo is fast with bright drumming, intense electric guitar feedback, keyboard harmony and rhythmic acoustic guitar with vocal backup. The song is upbeat, spirited, enthusiastic, vibrant, vivacious, buoyant and youthful with a dance groove. The sound quality is inferior making it difficult to understand the lyrics or the finer elements of this Rock and Roll song. | 2008-09-03T02:10:47Z | zanzkantdance | John Fogerty performs "Rock and Roll Girls" from Centerfield live in Oakland in 1986, set to various background videos. | ["Singing", "Music", "Musical instrument", "Rock music", "Roll", "Inside, large room or hall"] | ["male vocalist", "fast tempo", "intense electric guitar", "punchy drumming", "keyboard harmony", "vocal backup", "rhythmic acoustic guitar", "groovy bass line", "loud", "jarring", "inferior audio quality", "people cheering", "people talking", "energetic", "enthusiastic", "vigorous vivacious", "bright", "enthusiastic", "dance music", "pop", "pop rock", "rock", "rock and roll"] | 7 | 1ZaxqZMs21M | 287 | |
The Tea Party - Lullaby Live In Montreal - July 7, 2011 | This amateur recording features a rock song. A repetitive phrase is played on the guitar. The first bar consists of only the guitar sound. The bass and percussion start playing after one bar. The bass plays one note in groups of twos. The percussion plays a groovy rock beat. The hi-hat is played in a group of four strokes on the closed hi-hat followed by one stroke on the open hi-hat. There are no voices in this song. The mood of this song is melancholic. | 2011-07-10T12:36:07Z | Luc Beaulieu | Live at Le Métropolis, Montreal, Québec, Canada | ["Drum kit", "Guitar", "Music", "Musical instrument", "Rock music", "Pulse"] | ["amateur recording", "rock", "guitar", "repetitive phrase", "percussion", "bass", "no voice", "no other instruments", "slow tempo", "melancholic mood"] | 0 | GcYeBWujhjw | 1741 | |
Dr. Rockzo. "I'm a Rock n Roll Clown" | This is a recording of a live show performance by a rock band. We hear some cheering fans and then the song starts with an electric guitar lick and a bass guitar, and a kick on the drums. The audio quality is muffled and poor. | 2009-04-11T20:25:15Z | starz7007 | Brenden Small and the School of Rock all stars at the Starland Ballroom. 4-4-09. Dr. Rockzo. "I'm a Rock n Roll Clown" from metalocalypse | ["Drum kit", "Music", "Musical instrument", "Rock music", "Shout", "Rock and roll", "Speech"] | ["live recording", "cheering fans", "live performance", "rock", "poor audio quality", "electric guitar lick", "alternative rock", "blues rock"] | 3 | XHczpbtBhk4 | 3171 | |
Curtis Stigers-This Life | A male vocalist sings this spirited song. The tempo is medium fast with an acoustic and electric guitar flourish with a bass cello. This bit is the end of the song as the musician plays a closing riff and the sound of clapping and cheering can be heard. This song is an enthusiastic live performance of an energetic Soft Rock. | 2012-04-19T22:49:45Z | Roxxboise | Sons of Anarchy theme song from Curtis Stigers in-studio at KRVB, "The River," Boise, Idaho. | ["Singing", "Bass guitar", "Guitar", "Music", "Musical instrument", "Rock music", "Plucked string instrument"] | ["male vocalist", "medium fast tempo", "song end", "closing riff", "live performance", "concert", "live audience", "gig", "stage performance", "cheering clapping", "acoustic guitar", "electric guitar", "cello", "southern rock", "blues", "rock", "contemporary", "soft rock", "enthusiastic", "energetic", "performer", "artist"] | 7 | kkOGbgGJLF4 | 4352 | |
Dani California cover | The low quality recording features distorted electric guitar chords playing over rock songs played on playback. It sounds messy and harsh, as the frequencies of the room and the actual sound of the guitar and song are clashing with each other. | 2006-05-01T21:34:48Z | geraci89 | just me playing along to my favourite song on the radio right now by my favourite band:):) enjoy! | ["Guitar", "Music", "Musical instrument", "Rock music", "Progressive rock", "Plucked string instrument"] | ["low quality", "distorted electric guitar chords", "playback", "harsh", "messy", "rock"] | 4 | m8poFnEbvW8 | 4447 | |
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 | |
The Sunshine Underground - Put You In Your Place | This song contains a male voice repeating the same melody in a loop while another male voice is singing on top in a higher register. An acoustic drum is holding a four on the floor groove with a kick on every beat. The e-bass and e-guitar are playing along to the loop, repeating themselves. This song may be playing at a live concert downtown. | 2006-04-17T19:07:34Z | TomasTurbado | Videoclip indie rock | ["Electronic music", "Guitar", "Music", "Musical instrument", "Rock music", "Grunge", "Plucked string instrument"] | ["rock", "e-guitar", "e-bass", "male voices singing", "acoustic drums", "medium to uptempo"] | 6 | x7tOPTm31tQ | 5305 | |
Alkaline Trio - All On Black (Live On Letterman) | The low quality recording features a rock song that consists of a flat male vocal, alongside background male vocals, singing over shimmering hi hats, groovy bass, punchy kick and snare hits and electric guitar melodies. It sounds energetic and emotional. | 2007-06-24T14:06:26Z | AllHopeDeleted | All On Black Performed Live on Letterman from the album 'Good Mourning' http://www.youtube.com/jazzbandrock | ["Drum kit", "Guitar", "Music", "Musical instrument", "Punk rock", "Rock music"] | ["low quality", "rock", "background male vocal", "flat male vocal", "shimmering hi hats", "electric guitars melodies", "groovy bass", "punchy kick", "punchy snare", "emotional", "energetic"] | 4 | yQN9gj7Vk0w | 5408 |
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;