musiccaps_details (view)
7 rows where search matches "guitar", musiccaps_aspects contains "live performance", musiccaps_author = 4 and musiccaps_names contains "Rock and roll"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- live performance · 7 ✖
- low quality 7
- punchy snare 6
- energetic 5
- rock 5
- punchy kick 4
- shimmering hi hats 4
- groovy 3
- groovy bass guitar 3
- passionate male vocal 3
- exciting 2
- flat male vocal 2
- funky 2
- noisy 2
- passionate 2
- shimmering open hats 2
- wide electric guitar melody 2
- addictive 1
- alternative/indie 1
- arpeggiated electric guitar melody 1
- audio distortion 1
- boomy bass guitar 1
- boomy kick 1
- choir 1
- drum break 1
- easygoing 1
- echoing energetic male vocal 1
- electric guitar chord progression 1
- electric guitar melody 1
- emotional 1
- …
musiccaps_names (array) 13 ✖
- Music 7
- Rock and roll · 7 ✖
- Rock music 3
- Singing 3
- Ska 2
- Song 2
- Bass guitar 1
- Country 1
- Exciting music 1
- Pop music 1
- Punk rock 1
- Roll 1
- Yell 1
youtube_published (date) 7 ✖
- 2006-04-19 1
- 2008-06-25 1
- 2009-09-30 1
- 2010-12-07 1
- 2011-10-08 1
- 2012-03-10 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 |
---|---|---|---|---|---|---|---|---|---|---|
ill Scarlett - Babylon Song @ Sound of Music | The low quality recording features a live performance of an Alternative/Indie song and it consists flat male vocal singing over electric guitar chord progression, thin, but groovy bass guitar, punchy kick and snare hits, soft rimshots, soft crash cymbal, shimmering hi hats and a drum break. It sounds energetic, groovy and addictive, due to the cadence. | 2008-06-25T11:52:33Z | KyleCherops | ill Scarlett - "Babylon Song" live at Sound of Music Festival 2008 Burlington, ON | June 14, 2008 video 04 of 10 shot by Kyle Cheropita www.ishotyourset.net www.cherops.com | ["Music", "Rock and roll", "Exciting music"] | ["low quality", "live performance", "alternative/indie", "flat male vocal", "audio distortion", "electric guitar chord progression", "punchy kick", "shimmering hi hats", "punchy snare", "soft rimshots", "groovy thin bass guitar", "soft crash cymbal", "drum break", "addictive", "groovy", "energetic"] | 4 | 8akqVDDGsNQ | 931 | |
ずっと好きだった | The low quality recording features a live performance of a rock song and it consists of a passionate male vocal singing over groovy bass guitar, wide electric guitar melody, shimmering hi hats, punchy kick and snare hits. It sounds energetic and exciting. | 2011-10-08T06:45:59Z | Sheik | ["Singing", "Music", "Rock music", "Rock and roll"] | ["low quality", "rock", "live performance", "passionate male vocal", "wide electric guitar melody", "groovy bass guitar", "shimmering hi hats", "punchy kick", "punchy snare", "energetic", "exciting"] | 4 | InfQUMh935c | 1941 | ||
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 | |
Chuck Berry and Etta James - Rock N Roll Music | The low quality recording features a live performance of a rock & roll song performed by passionate female vocal and male vocal ad libs, followed by groovy piano melody, funky electric guitar melody, groovy bass guitar, shimmering hi hats, punchy snare and soft kick hits. It is a bit noisy and there are some subtle microphone feedback sounds in the middle of the performance. It sounds energetic, vintage and passionate. | 2012-03-10T00:09:38Z | John1948ThreeA | Chuck Berry (Charles Edward Anderson Berry - born Oct. 18, 1926, St. Louis, Mo., U.S.) singer, songwriter, and guitarist who was one of the most popular and influential performers in rhythm-and-blues and rock-and-roll music in the 1950s, '60s, and '70s. Raised in a working-class African-American neighbourhood on the north side of the highly segregated city of St. Louis, Berry grew up in a family proud of its African-American and Native-American ancestry. He gained early exposure to music through his family's participation in the choir of the Antioch Baptist Church, through the blues and country-western music he heard on the radio, and through music classes, especially at Sumner High School. Berry was still attending high school when he was sent to serve three years for armed robbery at a Missouri prison for young offenders. After his release and return to St. Louis, he worked at an auto plant, studied hairdressing, and played music in small nightclubs. Berry traveled to Chicago in search of a recording contract; Muddy Waters directed him to the Chess brothers. Leonard and Phil Chess signed him for their Chess label, and in 1955 his first recording session produced Maybellene (a country-and-western-influenced song that Berry had originally titled Ida Red), which stayed on the pop charts for 11 weeks, cresting at number five. Berry followed this success with extensive tours and hit after hit, including Roll Over Beethoven (1956), School Day (1957), Rock and Roll Music (1957), Sweet Little Sixteen (1958), Johnny B. Goode (1958), and Reelin' and Rockin' (1958). His vivid descriptions of consumer culture and teenage life, the distinctive sounds he coaxed from his guitar, and the rhythmic and melodic virtuosity of his piano player (Johnny Johnson) made Berry's songs staples in the repertoire of almost every rock-and-roll band. At the peak of his popularity, federal authorities prosecuted Berry for violating the Mann Act, alleging that he transported an underage female across state lines for immoral purposes. After tw… | ["Singing", "Music", "Pop music", "Rock music", "Ska", "Song", "Rock and roll"] | ["low quality", "male vocal ad libs", "passionate female vocal", "shimmering hi hats", "punchy snare", "soft kick", "groovy bass guitar", "funky electric guitar melody", "groovy piano melody", "rock & roll", "live performance", "subtle microphone feedback", "noisy", "energetic", "passionate", "vintage"] | 4 | QZoclbefgak | 2628 | |
Solomon Burke performs Rock and Roll Hall of Fame Inductions 2001 | The low quality recording features a live performance of a rock song and it consists of passionate male vocal singing over energetic drums, funky bass guitar, electric guitar melody and solo brass melody. At the end of the loop, there is a short snippet of choir singing in harmony. Overall it sounds funky, energetic, soulful and passionate - as a live performance should sound. | 2010-12-07T18:15:11Z | Rock & Roll Hall of Fame | Solomon Burke performs Rock and Roll Hall of Fame Inductions 2001 Visit us! http://rockhall.com/ Subscribe to RockHall : http://www.youtube.com/subscription_center?add_user=rockhall Facebook: http://www.facebook.com/rockandrollhalloffame Twitter: http://twitter.com/rock_hall Google +: http://plus.google.com/u/0/115412030406922618012 Check out all the inductees: http://rockhall.com/inductees/ Upcoming events: http://rockhall.com/events/ | ["Singing", "Music", "Rock music", "Song", "Rock and roll", "Yell"] | ["rock", "low quality", "live performance", "passionate male vocal", "choir", "solo brass melody", "funky bass guitar", "energetic drums", "electric guitar melody", "energetic", "soulful", "passionate", "funky"] | 4 | VfARCp38XtA | 3018 | |
Shake Rattle n' Roll demo video 1 | The low quality recording features a live performance of a rock song that consists of flat male vocal singing over a wide electric guitar melody, groovy keys chords, located in the right channel of the stereo image, smooth bass guitar, shimmering open hats and hi hats and punchy kick and snare hits. It sounds groovy, funky and easygoing - like something you could lightly dance to. | 2009-09-30T03:58:48Z | Bill Crane | Demo video recorded 9/28/09. | ["Country", "Music", "Ska", "Rock and roll"] | ["low quality", "rock", "live performance", "flat male vocal", "wide electric guitar melody", "groovy keys chords", "smooth bass guitar", "shimmering hi hats", "punchy snare", "punchy kick", "shimmering open hats", "groovy", "funky", "easygoing"] | 4 | rmKh9uaikTU | 4900 | |
"11 O'Clock Tick Tock" - Belfast , January 1981 | The low quality recording features a live performance of a rock song and it features passionate male vocals, alongside harmonizing male vocals, singing over arpeggiated electric guitar melody, boomy bass guitar, punchy kick and snare hits and shimmering open hats. It sounds noisy and messy, as the frequencies are clashing with each other, but it is still groovy and emotional regardless. | 2006-04-19T19:19:34Z | u2log | The audience reaction is great in this clip. | ["Bass guitar", "Music", "Punk rock", "Rock and roll"] | ["low quality", "rock", "live performance", "arpeggiated electric guitar melody", "passionate male vocal", "harmonizing male vocals", "boomy bass guitar", "shimmering open hats", "punchy kick", "punchy snare", "messy", "noisy", "groovy", "emotional"] | 4 | zWJC_qr2610 | 5486 |
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;