musiccaps_details (view)

1 row where musiccaps_aspects contains "groovy bass guitar", musiccaps_aspects contains "groovy piano melody", musiccaps_aspects contains "noisy" and musiccaps_aspects contains "punchy snare"

✎ View and edit SQL

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
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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;