musiccaps_details (view)
2 rows where musiccaps_aspects contains "vocal harmony" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- vocal harmony · 2 ✖
- barbershop quartet 1
- car horn playing percussively 1
- cheerful 1
- dance song 1
- double bass 1
- energetic 1
- exciting 1
- female backup singers 1
- groovy dance rhythm 1
- hip hop dance hits 1
- hip hop music 1
- hissing noise 1
- keyboard accompaniment 1
- male singer 1
- male voices 1
- medium-fast tempo 1
- piano 1
- poor audio quality 1
- retro dance hits 1
- romantic song 1
- slow jazz song 1
- slow tempo 1
- steady drumming rhythm 1
- strong bass line 1
- trumpets 1
musiccaps_names (array) 3 ✖
- Brass instrument · 2 ✖
- French horn 1
- Trumpet 1
youtube_published (date) 2 ✖
- 2011-01-02 1
- 2011-11-28 1
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 | |
Slam Trumpet - Quad City DJs vs. Skull Trumpet | A male singer sings this exciting melody with female backup singers in vocal harmony. The song is medium fast tempo with a strong bass line, steady drumming rhythm, keyboard accompaniment and a car horn playing percussively. The song has pretty bad audio quality. The song is a retro hip hop dance tune. | 2011-11-28T10:38:09Z | GravityGames | Is this the best Slam Jam Remix? | ["Brass instrument", "Trumpet"] | ["male singer", "hip hop music", "car horn playing percussively", "female backup singers", "groovy dance rhythm", "vocal harmony", "poor audio quality", "energetic", "exciting", "cheerful", "dance song", "retro dance hits", "hip hop dance hits", "steady drumming rhythm", "strong bass line", "keyboard accompaniment", "hissing noise", "medium-fast tempo"] | 1 | f4jW2H6V7gk | 3919 |
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;