musiccaps_details (view)
6 rows where musiccaps_aspects contains "piano" and musiccaps_names contains "Trumpet"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 数字変形 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 | |
| 6 WHITE BOOMERS 2013 | This song contains a piano playing short rhythmic chords along with an acoustic guitar and an upright bass playing the same melody. A brass melody is opening the scene. sound A male voice is singing in a higher register. This song may be playing while celebrating with the whole family on a national holiday. | 2014-11-25T23:03:53Z | Snapshot 21st Century | ["Brass instrument", "Trumpet"] | ["country", "acoustic guitar", "piano", "acoustic drums", "upright bass", "male voice singing", "higher key", "brass", "uptempo", "uplifting energy"] | 6 | Qu76GhRO9Yk | 2648 | ||
| "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 | |
| Robots by Dan Mangan | This slow pop song features the brass section playing the main melody in harmony. This is accompanied by hand claps on every alternate count. A tambourine plays a rhythmic beat in the background. Two piano notes are played in the background in the first bar of the song. There are no voices in this song. This instrumental song has a romantic theme. This song can be played in a romantic movie. | 2009-08-20T01:31:13Z | Taylor Jones | This song is called Robots and is preformed by Dan Mangan. This is a compilation of photos. | ["Brass instrument", "Trombone", "Trumpet"] | ["slow pop song", "hand claps", "tambourine", "brass section", "no voice", "instrumental", "piano", "romantic theme"] | 0 | T7khbuOBHbo | 2814 | |
| 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 | |
| Arturo & Doc Solos.mp4 | a latin jazz ensemble performing in a recital hall. A trumpet solo is accompanied by acoustic bass, syncopated drums and piano. The rhythm is upbeat and danceable. You can hear the reverb of the recital hall as well as audience sounds, someone sneezing. | 2010-11-29T02:19:26Z | jazzman1222 | This is my second Video of Doc and Arturo at the Rafael Mendez Trumpet Festival in Mexico City. Hard to believe that Doc is 83, he still has a wonderful sound!!! Arturo is still burnin´as usual!! | ["Brass instrument", "Jazz", "Music", "Musical instrument", "Trumpet", "Inside, large room or hall"] | ["latin jazz", "trumpet solo", "acoustic bass", "recital hall", "reverb", "audience sounds", "sneeze", "piano", "syncopated drums", "upbeat rhythm", "danceable"] | 8 | eiyyoUt64Zc | 3894 |
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;