musiccaps_details (view)

1 row where musiccaps_aspects contains "barbershop quartet", musiccaps_aspects contains "slow jazz song" and musiccaps_aspects contains "slow tempo"

✎ 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
The Four Freshmen - I Remember You (Capitol Records 1956) This slow jazz song features male voices singing the main melody in harmony. This is accompanied by percussion playing a simple beat. The double bass plays the root notes of the chords. Trumpets play a fill in harmony in between lines. A piano plays an arpeggiated chord at the end of the first line. This song has a romantic mood. This song can be played in a classic romantic movie. 2011-01-02T22:24:04Z RoundMidnightTV "I Remember You" is a popular song. The music was written by Victor Schertzinger, the lyrics by Johnny Mercer. The song was published in 1941. The song was one of several introduced in the movie The Fleet's In (1942). It was sung in the film by Dorothy Lamour (with harmony by Bob Eberly, and Helen O'Connell and featuring the Jimmy Dorsey Orchestra). According to the TCM documentary Johnny Mercer: The Dream's On Me, Mercer wrote the song for Judy Garland, to express his strong infatuation with her. He gave it to her the day after she married David Rose. Australian singer Frank Ifield recorded the song in a yodeling country-music style on 27 May 1962, and his version went to number one on the Australian Top 40 charts, as well as the UK Singles Chart, selling 1.1 million copies in the UK. It also reached number five on the U.S. Billboard Hot 100 and number one on the U.S. Easy Listening chart. American country singer Slim Whitman, known for his yodeling, later recorded the song in a very similar fashion. The song is now something of a country standard as well as a jazz standard. The tune was featured as background music in the film, Star Trek III: The Search for Spock. It was also used, with slightly modified lyrics, in a Republican Party (U.S.) TV campaign commercial in 1988. In 1998s, More Tales of the City, Colin Ferguson sings part of the lyrics in a scene with Laura Linney. The song was recorded on the album, UAB SuperJazz, Featuring Ellis Marsalis (2001). Slim Whitman's recording of the song was used in a scene of Rob Zombie's 2003 horror film House of 1000 Corpses. The Four Freshmen is an American male vocal band quartet that blends open-harmonic jazz arrangements with the big band vocal group sounds of The Modernaires (Glenn Miller), The Pied Pipers (Tommy Dorsey), and The Mel-Tones (Artie Shaw), founded in the barbershop tradition. The Four Freshmen is considered a vocal band because the singers accompany themselves on guitar, horns, bass, and drums, among other instrumental configurations. In early 19… ["Brass instrument", "French horn"] ["slow jazz song", "barbershop quartet", "trumpets", "double bass", "vocal harmony", "male voices", "piano", "slow tempo", "romantic song"] 0 -XkbErI_7EU 59

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;