musiccaps_details (view)
9 rows where musiccaps_aspects contains "piano" and musiccaps_aspects contains "trumpets"
This data as json, CSV (advanced)
musiccaps_aspects (array) 76 ✖
- piano · 9 ✖
- trumpets · 9 ✖
- instrumental 3
- acoustic drums 2
- cowbell 2
- double bass 2
- e-bass 2
- medium to uptempo 2
- moderate tempo 2
- organ 2
- percussion 2
- saxophones 2
- slow tempo 2
- trombone 2
- upright bass 2
- barbershop quartet 1
- baroque 1
- bass 1
- bass guitar 1
- bassoon 1
- cello 1
- choir 1
- clarinet 1
- clasical music 1
- compelling 1
- concert 1
- congas 1
- congo 1
- cuban ska 1
- cumbia 1
- dance 1
- dance song 1
- drums 1
- e-guitar 1
- electronic sound 1
- elegant 1
- energetic 1
- exquisite 1
- female vocal 1
- female voice 1
- flute 1
- french horn 1
- intense 1
- jazz/hiphop 1
- latin 1
- latin dance 1
- latin music 1
- latin percussion 1
- live orchestra 1
- live performance 1
- male vocals 1
- male voices 1
- male voices singing 1
- melancholic 1
- mid-range 1
- no voice 1
- no voices 1
- orchestra 1
- percussions 1
- playful 1
- rich 1
- romantic song 1
- salsa 1
- salsa song 1
- saxophone 1
- seductive singing 1
- slow jazz song 1
- steeldrum 1
- swing music 1
- symphony 1
- synth strings 1
- trombones 1
- upbeat 1
- violin 1
- vocal harmony 1
- western classic 1
musiccaps_names (array) 14 ✖
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 | |
ven a mi casa mama ( original ) HQ | This is a cumbia piece. There is a female vocal singing seductively joined by male back vocals singing in the chorus. The trumpet is playing the main melody joined by the piano and the bass guitar in the background. Latin percussion playing a cumbia beat provides the rhythmic background. The atmosphere of the piece is very playful. The ideal setting for this piece can be a latin dance course. | 2011-07-15T21:44:16Z | tecoloves | sonideros | ["Swing music", "Music"] | ["cumbia", "latin", "latin dance", "female vocal", "seductive singing", "male vocals", "choir", "latin percussion", "trumpets", "piano", "bass guitar", "playful", "dance"] | 9 | 7NnvEryyYdo | 840 | |
Nane Tsora | This music is a western classical. The tempo is slow with violins, trumpets, flute, cello. Viola, bassoon harmony. The music is soft, mellow, mellifluous, rich, elegant and exquisite. This is a live performance/concert. | 2007-05-23T12:20:55Z | ErnestNBE | Gipsy tradtional played by the NBE (www.nbe.nl) in the 2005 New Year's Concert in the Concertgebouw Amsterdam. Soloist on bass trombone is Brandt Attema. | ["Brass instrument", "Clarinet", "Trombone"] | ["instrumental", "slow tempo", "orchestra", "rich", "elegant", "exquisite", "compelling", "concert", "piano", "flute", "live performance", "live orchestra", "symphony", "rich", "melancholic", "trumpets", "violin", "cello", "clarinet", "bassoon", "french horn", "baroque", "intense", "western classic", "clasical music"] | 7 | 8y36aT4C_c0 | 961 | |
Beginners Salsa Steps with Music - Cross Body Lead with Turns | Various percussive instruments are being played. In the foreground stays the cowbell. A trumpet is playing the lead melody while other trumpets are supporting along with a piano playing chords together with an organ sound. A steeldrum is ending the phrase of a melody with his own melody. An e-bass is playing a complex salsa groove. This song may be playing dancing salsa. | 2010-11-08T12:01:58Z | SalsaMish | Salsa Mish & Aiste demonstrating beginners to intermediates salsa steps to a beautiful slow Salsa song from Palenke. By far the best way to learn these moves is to come along to Salsa Mish's classes at Greenwood Park, St Albans - every Friday night. You will have a great time, meet lots of friendly people, hear some fantastic music and lose any inhibitions you may have in no time. See www.salsamish.co.uk for details. | ["Country", "Music", "Music of Latin America", "Bluegrass", "Salsa music"] | ["salsa", "trumpets", "cowbell", "percussions", "steeldrum", "piano", "organ", "e-bass", "medium to uptempo"] | 6 | 9ZinCW4jTeE | 1026 | |
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 | |
The Pink Panther - Rats Song | This song contains an acoustic drum playing a simple groove along with an upright bass. A piano is playing short chords along with the snare of the drums. Trumpets are playing a melody along with the male voices singing together in unison and other harmonies. In the background you can hear a synth string chord and plucks playing a little melody. This song may be playing in a theater while watching a musical. | 2010-09-18T18:11:59Z | LilMsKiss | From the pc game The Pink Panther: Hocus Pocus Pink lyrics: Rats! Well, we're survivors It's hard to drown us 'cause we're excellent sea divers We can chew through pipes, survive a nuclear blast! Scale walls and fall and not get hurt at all - We've done it in the past Rats! Yes, we're resilient Despite attempts to wipe us out we grow by millions - And although we only live one sure year long A productive rat and wife could host a family - Fifteen thousand strong! Oh, rats! Oh, shucks! Us furry vermin's here to stay Oh, phooey! Rats, yes, rats! Ya know you're gonna need us anyway! Just think of all the break-throughs science made - At our expense! You can't deny no matter how hard you try - Our contribution's been immense! Rats! We're highly adaptable, so, what if we've got a few diseases that are contractible? And as for crops, we devastate - We've gotta eat! Tell me, what would you choose for an entree? - Poison pellets or rice, fruits, nuts and treats? Did you know that one year in Hawaii some of our brothers ate about 11 million dollars worth of sugar cane? Talk about a sweet tooth! You've heard of rats, nocturnal creatures, that means we're up all night inspecting kitchen features Wherever man goes, a rat too surely can There must be some way we could live to enjoy the same long life span Oh, rats! Oh, shucks! Us furry vermin's here to stay Oh, phooey! Rats, yes, rats! Ya know you're gonna need us anyway! Rats! Oh, rats! Us freaky vermin wanna play Rats, you bet your sweet patootie, rats Ya know you're gonna need us anyway! Rats! | ["Music", "Music for children", "Speech"] | ["jazz/hiphop", "upright bass", "synth strings", "trumpets", "piano", "acoustic drums", "male voices singing", "mid-range", "medium to uptempo"] | 6 | TcoRmHHHNgI | 2853 | |
Ain't Nobody (Salsa Version)-Alex Wilson | This salsa song features a female voice singing the main melody. This is accompanied by percussion on a drum kit as well as on a congo. The congo gives this song the salsa feel. The drum kit plays the cowbell and high pitched snare drum to add more of the salsa vibe. The bass plays groovy fills. Trumpets, trombones and saxophones play fills in between lines. They play in harmony. A piano plays jazzy chords in the background. This song can be played in a dance club for a salsa night. | 2010-05-06T09:50:53Z | tsiostini | ["Music", "Music of Latin America", "Salsa music"] | ["salsa song", "female voice", "percussion", "trumpets", "congo", "cowbell", "trombone", "saxophone", "dance song", "bass", "piano", "moderate tempo"] | 0 | gMgN50wSnNc | 4025 | ||
Jerry rivera Para ti | The instrumental latin music features a big band. The trumpets, saxophones and trombones play the same melody but on different pitches. The percussion section includes a drum kit played in the latin style and a pair of congas. A piano accompanies the brass section and blends in with the rest of the band. An electronic sound can be heard playing the same note throughout the music excerpt. | 2007-09-10T07:54:12Z | Donabboy | para ti | ["Music", "Salsa music"] | ["latin music", "trumpets", "trombones", "saxophones", "congas", "piano", "upright bass", "electronic sound", "instrumental", "no voice", "drums"] | 2 | nH_lVl3a3Uw | 4529 | |
Ska Cubano - Identity | This audio contains acoustic drums playing something like a reggae groove along with an e-bass. A e-guitar strumming chords, piano, organ saxophones and trumpets are playing a short melody on the backbeat giving this song its reggae feeling. In-between the instruments are playing a short loud melody to break into the next part. The instruments are spread across the sides of the speakers. This audio may be playing in an urban coffee shop. | 2011-05-16T22:21:47Z | Eder Eulogio | Canción del disco Mambo Ska de esta banda de nacionalidades múltiples y que ha resaltado la cultura musical de dos islas caribeñas como lo son Cuba y Jamaica..... Disfruten, Comenten y Suscríbanse!!!!!!!!!!!!!! | ["Wind instrument, woodwind instrument", "Accordion"] | ["cuban ska", "e-guitar", "trumpets", "saxophones", "organ", "piano", "acoustic drums", "e-bass", "upbeat", "energetic"] | 6 | nW6Naj6eeI4 | 4547 |
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;