musiccaps_details (view)

1 row where musiccaps_aspects contains "ambient", musiccaps_aspects contains "improvisations", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "lively"

✎ 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
Take Five - The Dave Brubeck Quartet (1959) This song is a lively Jazz instrumental. The tempo is medium with a spirited piano harmony, syncopated drum rhythm and groovy bass lines. The music is ambient, lively, engaging and catchy with complex chords, irregular beats, improvisations , syncopation and creative freedom for improvisations. 2010-08-15T19:37:28Z djbuddylovecooljazz "Take Five" is a jazz piece written by Paul Desmond and performed by The Dave Brubeck Quartet on their 1959 album "Time Out". Recorded at Columbia's 30th Street Studios in New York City on June 25, July 1, and August 18, 1959, this piece became one of the group's best-known records, famous for its distinctive, catchy saxophone melody and use of the unusual quintuple (5/4) time, from which its name is derived. While "Take Five" was not the first jazz composition to use this meter, it was one of the first in the United States to achieve mainstream significance, reaching number five on Billboard's Adult Contemporary Singles chart. "Take Five" was re-recorded and performed live multiple times by The Dave Brubeck Quartet throughout the group's career. In addition, there have been various covers of the piece. "Take Five" has also been included in countless movies and television soundtracks, and still receives significant radio play. Upon his death in 1977, Desmond left the rights to royalties for his performances and compositions, including "Take Five", to the American Red Cross, which has since received combined royalties of approximately $100,000 per year. "Time Out" is a 1959 album by The Dave Brubeck Quartet, based upon the use of time signatures that were unusual for jazz (mainly waltz or double-waltz time, but also 9/8, and most famously 5/4). Although the album was intended as an experiment and received negative reviews by critics upon its release, it became one of the best-known and biggest-selling jazz albums, reaching number two in the U.S. Billboard Pop Albums chart. In 2005, it was one of 50 recordings chosen that year by the Library of Congress to be added to the National Recording Registry. The Dave Brubeck Quartet was a jazz quartet, founded in 1951 by Dave Brubeck and originally featuring Paul Desmond on saxophone and Brubeck on piano. David Warren 'Dave' Brubeck (December 6, 1920 -- December 5, 2012) was an American jazz pianist. He has written a number of jazz standards, including "In Your… ["Timpani", "Music"] ["instrumental", "medium tempo", "jazz music", "funky piano", "jazz style drumming", "groovy bass line", "upbeat", "ambient", "engaging", "lively", "jazz pianist", "improvisations", "complex chords", "swing notes", "blues notes", "irregular beats", "deliberate syncopation", "creative", "poly rhytms"] 7 nzpnWuk3RjU 4600

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;