musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "live performance", musiccaps_names contains "Rock and roll" and musiccaps_names contains "Roll"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- live performance · 4 ✖
- rock 3
- clapping 2
- energetic 2
- enthusiastic 2
- fast tempo 2
- ambient background sounds 1
- amplified guitar harmony 1
- amplified instruments 1
- boomy kick 1
- brass band 1
- bright trumpeting 1
- buoyant 1
- cheering 1
- compelling 1
- concert 1
- crowd cheering 1
- dance groove 1
- drums 1
- echoing energetic male vocal 1
- electric guitar 1
- electrifying 1
- emphatic vocals 1
- energetic crash cymbals 1
- enthusiastic electronic guitar melody 1
- exciting 1
- fans 1
- gig 1
- groovy bass guitar 1
- groovy bass line 1
- …
musiccaps_names (array) 7 ✖
- Music 4
- Rock and roll · 4 ✖
- Roll · 4 ✖
- Drum kit 1
- Musical instrument 1
- Percussion 1
- Rock music 1
youtube_published (date) 4 ✖
- 2007-02-01 1
- 2007-11-18 1
- 2008-03-13 1
- 2012-12-27 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Foo Fighters - Rock and Roll - Kennedy Center Honors - Led Zeppelin | The low quality recording features a live performance of a rock song that consists of echoing, energetic male vocals that are singing over wide electric guitar chord progression, energetic crash cymbals, punchy snare, boomy kick and groovy bass guitar. It sounds energetic and exciting. | 2012-12-27T03:55:00Z | saveyouckufer | Foo Fighters - Rock and Roll - Kennedy Center Honors - Led Zeppelin Celebration Day http://amzn.to/TFuvtc | ["Music", "Roll", "Rock and roll"] | ["low quality", "echoing energetic male vocal", "wide electric guitar chord progression", "energetic crash cymbals", "punchy snare", "boomy kick", "groovy bass guitar", "rock", "live performance", "energetic", "exciting"] | 4 | Q8f6y2IcVg0 | 2600 | |
Led Zeppelin - Rock and Roll (Live) | A male vocalist sings this energetic Rock song. The tempo is fast with intense drumming, vigorous electric guitar, funky bass and keyboard harmony. The song is a vibrant, enthusiastic, youthful, animated, spirited, buoyant and electrifying Heavy Metal/Rock. There are sounds of people cheering, clapping and singing along, indicating that this is a live performance. | 2008-03-13T23:04:36Z | Rodolfo Baravalle | Rock and Roll en no sé donde.. Viva la pepa (?) | ["Music", "Roll", "Rock and roll"] | ["male vocalist", "fast tempo", "enthusiastic", "string instruments", "amplified instruments", "sonic power", "infectious drumming", "live performance", "gig", "intense electric guitar feedback", "amplified guitar harmony", "keyboard accompaniment", "emphatic vocals", "concert", "live performance", "hard rock", "heavy metal", "rock", "crowd cheering", "clapping", "singing along", "fans", "enthusiastic", "youthful", "electrifying", "compelling"] | 7 | QvwD7NEg3Mw | 2650 | |
Torvill and Dean 1983 Rock n Roll OSP | This music is a high energy Rock and Roll. The tempo is fast with a vivacious electric guitar melody, punchy drumming, animated trumpets, funky bass line, keyboard and acoustic guitar accompaniment . The music is high energy, vivacious, bright, groovy,enthusiastic and animated Rock and Roll instrumental. | 2007-11-18T01:14:20Z | BJH1981 | Torvill & Dean's Rock n Roll OSP from 1983 World Championships | ["Music", "Roll", "Rock and roll"] | ["instrumental", "fast tempo", "ambient background sounds", "clapping", "live performance", "poor audio quality", "muffled music", "cheering", "people talking", "enthusiastic electronic guitar melody", "hard hitting drumming", "bright trumpeting", "groovy bass line", "rhythmic acoustic guitar", "keyboard harmony", "brass band", "wind instruments", "dance groove", "jive", "rock and roll", "retro rock", "energetic", "enthusiastic", "pulsating", "buoyant", "upbeat", "high spirited"] | 7 | fEHsR679g1M | 3934 | |
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;