musiccaps_details (view)
9 rows where musiccaps_aspects contains "piano", musiccaps_aspects contains "upright bass" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 61 ✖
- piano · 9 ✖
- upright bass · 9 ✖
- acoustic drums 5
- jazz 5
- instrumental 3
- lively 3
- acoustic jazz drums 2
- cheerful 2
- clarinet 2
- complex 2
- female vocal 2
- flute 2
- male vocal 2
- saxophone 2
- trumpet 2
- upbeat 2
- vibrant 2
- anime music 1
- background music 1
- big band 1
- brass 1
- brass section 1
- comedic 1
- complaining 1
- dreamy 1
- easygoing 1
- eccentric 1
- educational 1
- electric guitar 1
- electronic drums 1
- electronic percussion 1
- emotional 1
- exhilarating 1
- gentle singing 1
- gibberish singing 1
- groovy 1
- improvisation 1
- instructive 1
- japanese jazz 1
- jazz fusion 1
- jazz music 1
- jolly 1
- live performance 1
- movie music 1
- musical 1
- no singer 1
- old recording 1
- package opening 1
- playful 1
- quirky 1
- restless 1
- shoes 1
- story-telling mood 1
- strings 1
- swing 1
- tap dancing 1
- toy review 1
- trumpet solo 1
- vibraphone 1
- video game theme 1
- winds section 1
musiccaps_names (array) 18 ✖
- Music 6
- Brass instrument 3
- Trumpet 3
- Clarinet 1
- Hip hop music 1
- Jazz 1
- Lullaby 1
- Rapping 1
- Roll 1
- Saxophone 1
- Soul music 1
- Soundtrack music 1
- Swing music 1
- Tap 1
- Tick 1
- Trombone 1
- Wind instrument, woodwind instrument 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
TAP DANCING CONTEST | This is a jazz music piece used as an accompaniment for a tap dancing contest. It is an old recording. There is a brass section and a piano that are playing the melody while the upright bass is playing a simple bass line. The rhythmic background consists of acoustic drums and the tapping of the shoes to the ground. There is a lively atmosphere. This piece is used in the background of comedic social media content or advertisement jingles. | 2006-12-24T05:40:32Z | DCLAQUETTE | From a short. A collegiate contest. The other side could have had Eleanor Powell--no matter, she would have sucked. Partisanship at its worst--but, what the hell, it's fiction. | ["Music", "Tap"] | ["jazz music", "tap dancing", "shoes", "brass section", "piano", "upright bass", "acoustic drums", "lively", "jolly", "upbeat", "old recording"] | 9 | BjIksWR4oKw | 1282 | |
Matter Chatter (song for kids about solids, liquids, and gases) | This is an educational music piece. The male vocalist is singing in an instructive manner asking questions directed at kids. There is a quirky piano sound joined by an upright bass. The rhythmic background consists of an electronic drum beat joined by electronic percussive sounds. There is an eccentric atmosphere to this piece. It could be used in an educational atmosphere such as an introductory physics class. | 2014-06-12T22:01:53Z | Harry Kindergarten Music | MATTER CHATTER! A song for kids about the 3 states of matter: solid, liquid, and gas To purchase this song in video format (.mp4) or audio format (.m4a), please visit www.harrykindergartenmusic.com! WWW.HARRYKINDERGARTENMUSIC.COM Hip songs & videos for the K-2 classroom! - Most videos on my website: $2.49 - All audio files on my website: $1.00 - Audio/video song packs for a discounted price also available! Check out the Harry Kindergarten Music FACEBOOK page! www.facebook.com/groups/harrykindergarten To contact Mr. Harry about a speaking engagement for teachers, or if you have any other questions/comments, please contact pete@harrykindergartenmusic.com. *Disclaimer: Videos produced and shared by Harry Kindergarten Music are intended to be shown on the official HARRY KINDERGARTEN MUSIC YouTube channel and are NOT to be uploaded anywhere else. Please do NOT rip videos off of my channel and put them on yours. If YouTube is blocked in your school district, I graciously ask you to purchase the video or audio files from my website shown above. Happy teaching! Q: Can my class perform a "Harry Kindergarten song" for an audience? A: If you desire to have your class or group of students perform one of my “Harry Kindergarten” songs for an audience, please note that there is a $6.00 PERFORMANCE FEE. Here are some hypothetical examples of performance groups: * Students perform a song for an audience during a graduation ceremony. * Students perform a song for an audience during a school or community talent show. * Students perform a song for an audience during a school assembly. If you are unsure if you need to purchase a performance license or not, please inquire at: pete@harrykindergartenmusic.com. If you want more details about using a song multiple years or multiple classes, etc., e-mail me for a detailed PDF file. $6.00 can be sent to: Harry Kindergarten Music, LLC 508 Stewart Street Bellwood, PA 16617 | ["Music", "Rapping", "Tick", "Hip hop music"] | ["educational", "instructive", "male vocal", "piano", "upright bass", "electronic drums", "electronic percussion", "quirky", "eccentric"] | 9 | C33WdI64FiY | 1321 | |
A Griffon Day | This is a big band jazz music piece. It is an instrumental piece. The main melody is played by a wide variety of the winds section composed of the saxophone, the trumpet, the flute and the clarinet. The piano and the upright bass provide backing structures. The rhythmic background consists of a jazz acoustic drum beat. The atmosphere is playful. This piece could fit perfectly in the soundtrack of a Disney-type animation movie. | 2008-01-27T00:18:25Z | George Pfeiffer | Gus the Brussels Griffon documents a typical day in his life. If you like dogs...or monkeys...or Ewoks....then you'll love this little pooch! | ["Swing music", "Jazz", "Music"] | ["jazz", "big band", "instrumental", "winds section", "saxophone", "trumpet", "flute", "clarinet", "upright bass", "piano", "acoustic drums", "lively", "playful", "upbeat"] | 9 | JU6GUqRqbtI | 2011 | |
Katamari Roll (you up into my life) | This is a video game theme in the style of jazz music. There is a male vocalist singing gibberish while imitating a brass instrument. The vibraphone is playing the main melody. There is a piano playing chords in a syncopated manner. The bass guitar is playing a groovy bass line. The rhythmic background consists of an acoustic jazz drum beat. The atmosphere is dreamy and cheerful. This piece could be playing in the soundtrack of an animation movie during a dream sequence. | 2008-11-26T21:49:26Z | leftofftheark | I know you love me I want to wad you up into my life Lets roll up to be a single star in the sky I hear you calling me I want to wad you up into my life Lets lump up to make a single star in the sky To you, to you Im so in love with you I want to wad you up into my life Lets roll up to be a single star in the sky I need you to feel me I want to wad you up into my life Lets lump up to make a single star in the sky To you I know you love me I want to wad you up into my life Lets roll up to be a single star in the sky I hear you calling me I want to wad you up into my life Lets lump up to make a single star in the sky To you, oh to you Yes to you | ["Music", "Roll", "Soul music"] | ["video game theme", "jazz", "male vocal", "gibberish singing", "vibraphone", "piano", "upright bass", "acoustic jazz drums", "dreamy", "complex", "cheerful"] | 9 | Mv90uA0tmgc | 2307 | |
The Sound of Music Soundtrack - 4 - Maria | This is a musical piece. There is a story-telling mood in this piece. The female vocalist is singing about her troubles in a complaining manner. There are many instruments in the melodic background such as piano, strings, flute and upright bass. The atmosphere of the piece is easygoing and comedic. | 2011-03-15T01:45:42Z | xosoundtrackloverxo | ["Yodeling", "Music", "Soundtrack music"] | ["musical", "movie music", "female vocal", "story-telling mood", "piano", "strings", "flute", "upright bass", "complaining", "easygoing", "comedic"] | 9 | OKZF0oG1E14 | 2427 | ||
数字変形 Numbers transform to vehicles for kids | This is a toy package opening video with a jazz music piece in the background. In the piece, there is a clarinet playing the leading melody while other brass elements, the piano and the upright bass are accompanying it with backing tunes. The rhythm is being played by the upbeat jazz acoustic drums. The atmosphere of the piece is lively. If the package opening sounds could be removed, the piece would suit well in the soundtrack of a feelgood animation movie. | 2015-10-11T07:57:43Z | Talking Toyss | This video shows how Numbers transform to vehicles. The number includes 1,2,3. Hope you enjoy our video, pls subscribe, leave comments and check out TalkingToyss channel! learn to count numbers 1 to 10 for kids with street vechicles tomica and tomica factory https://www.youtube.com/watch?v=0ajlonqR7VY Choro-Q TRANSFORMERS チョロQ・トランスフォーマー for kids with Q Transformer and Hello Kitty cross over https://www.youtube.com/watch?v=1zDtV3Og5xY Learning Street Vehicles Names and Sounds for kids with tomica tayo robocar Poli https://www.youtube.com/watch?v=cFeJ-ORLYpI VooV ブーブ 変身 Transform street vehicles for kids with Trains https://www.youtube.com/watch?v=jfpBPYrCRrA VooV ブーブ 変身 Transform street vehicles for kids with Cars and Trucks 2 https://www.youtube.com/watch?v=OkVB75ZnwVw Learning street vehicle name with Roboca Poli English https://www.youtube.com/watch?v=99LFSxjHYbI VooV ブーブ 変身 Transform street vehicles for kids with Cars and Trucks https://www.youtube.com/watch?v=OrAW8wNYuas Vintage Lego 10196 Grand Carousel in white with sound and motor spin https://www.youtube.com/watch?v=rQ5-ycJZkyk Minions Stuart banana toys for minions movie 2015 with Sounds and Flash https://www.youtube.com/watch?v=H70IwYW9q2I Super Mario World Toys Collection unboxing https://www.youtube.com/watch?v=sFtsQvGhzJw 5 Kinder Surprise Eggs Airbus A330-300 Airplane collection https://www.youtube.com/watch?v=pZSbivWZqcw Play Doh meal makin kitchen Playset https://www.youtube.com/watch?v=iYTm2x5haM4 How to build Lego Emerald Express train - Lego Creator 31015 https://www.youtube.com/watch?v=1x0N3NGqP8c 20 Surprise Eggs,Play Doh Kinder Surprise Spongebob Disney Pixar Frozen Cars Mario https://www.youtube.com/watch?v=W4rtfPtjJ4A Toy Cutting Fruit Velcro Vegetable Salad Cooking Playset velcro steak fish chicken Cooking Playset https://www.youtube.com/watch?v=AkRYQf2gBwU Doraemon robot figure playset toy reviews https://www.youtube.com/watch?v=OG8pw04SN9I | ["Brass instrument", "Clarinet", "Trombone", "Trumpet", "Wind instrument, woodwind instrument"] | ["toy review", "package opening", "background music", "jazz", "clarinet", "brass", "upright bass", "piano", "acoustic drums", "cheerful", "lively"] | 9 | Pzp_oTEn0Yk | 2585 | |
"Milestones" (Miles Davis) | This is the live performance of a jazz music piece. There is a trumpet solo at the forefront. The background consists of the piano, the upright bass and a jazz acoustic drum beat. The atmosphere is restless. This piece could be playing in the background at a jazz bar. | 2006-08-18T02:23:52Z | Bobbelden | BOB BELDEN BIG BAND "Birdland" May 26, 2004 Jeremy Pelt-trumpet soloist, Joe Lovano-tenor sax soloist Seneca Black, Tony Kadleck, Ray Vega, Lew Glucken-trumpets Dave Gibson, Andre Hayward-trombones John Clark-french horn Howard Johnson-tuba Tim Ries, Charles Pillow, Mike Migliore, Ronnie Cuber, Gary Smulyan(winds) Kevin Hays-piano Derek Neyvergeld-bass Tommy Crane-drums Camera: Mantis Evar | ["Brass instrument", "Trumpet"] | ["jazz", "jazz fusion", "live performance", "no singer", "instrumental", "trumpet solo", "piano", "upright bass", "acoustic jazz drums", "improvisation", "complex", "restless"] | 9 | R6k2BkwZt1Y | 2670 | |
Miles Davis Quintet - Doxy | This is a jazz music piece. There is a trumpet and a saxophone playing the lead melody. The piano is playing the chords of the piece while the upright bass is playing a groovy bass line. The acoustic drums are playing a swing type beat for the rhythmic background. The atmosphere is groovy. This piece could be playing in the background at a coffee shop. | 2014-06-22T16:09:17Z | 60otaku4 | Miles Davis Quintet - Doxy (1954) Personnel: Miles Davis (trumpet), Sonny Rollins (tenor sax), Horace Silver (piano), Percy Heath (bass), Kenny Clarke (drums) from the album 'BAGS' GROOVE' (Prestige Records) | ["Brass instrument", "Saxophone", "Trumpet"] | ["jazz", "instrumental", "trumpet", "saxophone", "upright bass", "piano", "acoustic drums", "groovy", "vibrant"] | 9 | XpueyrkcMyQ | 3228 | |
Sakamichi no Apollon OST - Lullaby of Birdland | This is a japanese jazz music piece that is used in an anime soundtrack. There is a female lead vocal singing gently in the lead. The melody is being played by the piano, the electric guitar and the upright bass. In the rhythmic background, there is an acoustic jazz drum beat in the style of swing. There is an exhilarating atmosphere, full of rich sounds. The mix is perfect. This piece could be used in the soundtrack of a romance/drama movie as well as its original use in an anime. It could also be playing in the background at a coffee shop or a classy restaurant. | 2012-04-25T12:32:31Z | Soponon | 16 - Lullaby of Birdland | ["Music", "Lullaby"] | ["japanese jazz", "female vocal", "gentle singing", "piano", "electric guitar", "upright bass", "acoustic drums", "swing", "vibrant", "exhilarating", "emotional", "anime music"] | 9 | gDzi8N3BYMw | 4017 |
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;