musiccaps_details (view)
5 rows where musiccaps_aspects contains "clarinet", musiccaps_author = 9 and musiccaps_names contains "Wind instrument, woodwind instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- clarinet · 5 ✖
- instrumental 3
- cheerful 2
- orchestra 2
- accordeon 1
- accordion 1
- acoustic drums 1
- acoustic guitar 1
- alpine folk music 1
- background music 1
- basset horn 1
- bassoon 1
- brass 1
- cello 1
- classical music 1
- comedy 1
- contrabass 1
- dramatic 1
- emotional 1
- goofy tune 1
- inauthentic 1
- jazz 1
- joyful 1
- lively 1
- major key 1
- male spoken word 1
- mourning 1
- nai 1
- no singer 1
- oboe 1
- package opening 1
- piano 1
- positive 1
- recital 1
- romanian 1
- strings 1
- toy review 1
- tragic 1
- upright bass 1
- virtual sounds 1
- winds 1
musiccaps_names (array) 12 ✖
- Wind instrument, woodwind instrument · 5 ✖
- Accordion 2
- Brass instrument 2
- Clarinet 2
- Harmonica 1
- Keyboard (musical) 1
- Music 1
- Musical instrument 1
- Piano 1
- Traditional music 1
- Trombone 1
- Trumpet 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mitja kvintet - S klarineti na pot-Mit Klarinetten unterwegs | This is an Alpine folk music piece. The piece is instrumental. It is being performed by an orchestra composed of the clarinets, the accordion, the cello and the acoustic guitar. The atmosphere is cheerful. This piece could be used in the soundtrack of a movie that takes place in the Alps region. | 2008-01-16T21:07:21Z | horni110607 | Mit Klarinetten unterwegs Komp.: Damir Tkavc - Alpenoberkrainer / Alpski kvintet Mitja Mastnak Robi Marzel Sandi Jug Zmago Tkavc Matjaz Vodisek Mario Reumüller | ["Wind instrument, woodwind instrument", "Accordion"] | ["alpine folk music", "instrumental", "orchestra", "clarinet", "accordion", "cello", "acoustic guitar", "cheerful", "joyful"] | 9 | 9mqA4YdX444 | 1041 | |
Sibelius 7 Sounds - 3. Winds | This is a classical music piece played with the virtual sounds of a wind orchestra. The orchestra is composed of the oboe, the clarinet, the basset horn, the bassoon and the contrabass. The piece is in major key which gives the piece a more positive aura in general, but the virtual sounds make it feel inauthentic. | 2011-11-26T01:00:19Z | OrchestrationOnline | Third in a series of reviews of the new sound set from Sibelius 7. Please watch full-screen with high fidelity sound. Many thanks to special guest Justus Rozemond, contrabass clarinetist. | ["Brass instrument", "Clarinet", "Keyboard (musical)", "Piano", "Wind instrument, woodwind instrument"] | ["classical music", "no singer", "instrumental", "virtual sounds", "orchestra", "winds", "oboe", "clarinet", "basset horn", "bassoon", "contrabass", "major key", "positive", "inauthentic"] | 9 | GMFWnMRtfNI | 1711 | |
Gheorghe Zamfir,Dumitru Farcas,Dan Zahan,Adrian Paunescu part 1 | This is a live performance of a recital. A loud accordion is holding the melodic background as the clarinet performs a solo on top of it. There is also a now (Romanian pan flute) being played. A male voice starts speaking on the recording possibly retelling a story or a poem. There is a tragic atmosphere. This piece could be used in the soundtracks of drama movies or TV series with an Eastern European/Balkan setting. | 2011-02-03T03:31:37Z | Peter Peterr | Recital omagial pentru victimele genocidului din Kosovo,moderatorul emisiunii poetul Adrian Paunescu. | ["Traditional music", "Music", "Musical instrument", "Wind instrument, woodwind instrument", "Accordion"] | ["clarinet", "recital", "accordeon", "nai", "male spoken word", "emotional", "tragic", "mourning", "romanian"] | 9 | JDBu-3VCyWc | 1980 | |
数字変形 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 | |
Ranma 1/2 Live Action Cast | This is an instrument comedy music piece. There is a clarinet playing a goofy tune. Then, the clarinet stops and the strings section starts playing a dramatic melody. This piece could be sampled to be used as instrumentals in an advertisement jingle. | 2011-10-21T00:40:13Z | Rumic World | The cast of the new Ranma 1/2 special in full costume. The special will air on December 9, 2011 at 7:00pm on NTV. Kento Kaku (male Ranma) Natsuna Wantanabe (female Ranma) Yui Aragaki (Akane) Kyoko Hasegawa (Kasumi) Shosuke Tanihara (Dr. Tofu) Maki Nishiyama (Nabiki) Kento Nagayama (Tatewaki Kuno) Yuta Kanai (Hikaru Gosunkugi) Arata Furuta (Genma) Katsuhisa Namase (Soun) Ryousei Tayama (Okamada) The song is "Lychee & Jasmine" from the Movie 1 OST. | ["Harmonica", "Wind instrument, woodwind instrument"] | ["comedy", "instrumental", "clarinet", "goofy tune", "strings", "dramatic"] | 9 | fvTh5m9RHZw | 3988 |
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;