musiccaps_details (view)
3 rows where musiccaps_aspects contains "double bass" and musiccaps_aspects contains "trumpets"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- double bass · 3 ✖
- trumpets · 3 ✖
- instrumental 2
- moderate tempo 2
- no voices 2
- percussion 2
- piano 2
- barbershop quartet 1
- flute 1
- male voices 1
- romantic song 1
- ska song 1
- slow jazz song 1
- slow tempo 1
- swing music 1
- trombone 1
- vocal harmony 1
musiccaps_names (array) 5 ✖
- Music 2
- Brass instrument 1
- French horn 1
- Ska 1
- Swing music 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 | |
Swing Music | This swing music is an instrumental piece. It starts off with the trumpets playing high pitched notes in harmony. The percussion starts to play with an intro roll. A wind instrument swell is played after the intro percussion roll. A wind instrument plays a repetitive lick after this followed by a piano playing chords at higher octaves in the spaces between the wind instrument licks. The bass plays the same lick on a lower octave. There are no voices in this song. This song can be played in a retro movie dance scene. | 2011-01-19T02:10:58Z | IceSkaterDuckie | First piece of music: "Jumpin' Jack" by Big Bad Voodoo Daddy Second piece of music: "Viper" by Dixieland | ["Swing music", "Music"] | ["swing music", "instrumental", "no voices", "piano", "trumpets", "double bass", "trombone", "percussion", "moderate tempo"] | 0 | LPA8RDzl-Ss | 2184 | |
Best Selection (1) of Old School Ska & Original Reggae 1960's (Vinyl Recordings) Vol. 1 | This ska song features a flute playing the main melody. Other flutes play staccato notes in the background. This is backed by trumpets playing chords in the background. The percussion plays a simple beat in common time. The double bass plays a 12-bar blues style bassline. There are no voices in this song. This is an instrumental. This song can be played at a Broadway event. | 2012-04-08T17:15:32Z | Oscar | Best Selection of Old School Ska & Original Reggae 1960's (Vinyl Recordings) Vol. 1 This is the first of two volumes, a really old compilation that we think my dad bought on cassette in the early 80's from Gaz Mayalls dad at a market stall in Camden. Some nice old school ska and reggae, This lot of music came from Vinyl, was recorded onto cassette and then onto CD, to the computer. hence the sound quality is a bit crackly and truly original! See comments for track listing :) Enjoy! | ["Music", "Ska"] | ["ska song", "flute", "trumpets", "double bass", "percussion", "no voices", "instrumental", "moderate tempo"] | 0 | O40E8bpmONQ | 2396 |
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;