musiccaps_details (view)
4 rows where musiccaps_aspects contains "noisy", musiccaps_names contains "Brass instrument" and musiccaps_names contains "Clarinet"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- low quality 4
- noisy · 4 ✖
- mono 3
- bass clarinet melody 1
- clarinet solo melody 1
- flat male vocal 1
- fun 1
- happy 1
- harmonizing clarinet melodies 1
- harmonizing woodwinds melody 1
- joyful 1
- mellow piano melody 1
- passionate 1
- reverberant 1
- soulful 1
- wide brass melody 1
musiccaps_names (array) 8 ✖
- Brass instrument · 4 ✖
- Clarinet · 4 ✖
- Saxophone 2
- Flute 1
- Music 1
- Musical instrument 1
- Theme music 1
- Wind instrument, woodwind instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mario Bros Theme - Flute & Clarinet | The low quality recording features a harmonizing woodwinds melody playing. The recording is noisy, in mono and it sounds happy and fun. | 2006-11-28T00:13:16Z | Cristiano Vieira | Sheets (scores) at http://sites.google.com/site/ccvieira/ Flute and Clarinet Duet. Cristiano Vieira and Diogo Paiva playing the Mario Bros Theme. Thanks!!! Telexfree A new way to use cell phones. Talk more pay less. Doubts? Then try a courtesy for 1h. Talk to + than 40 countries http://www.telexfree.com/ad/baruelfree | ["Brass instrument", "Clarinet", "Theme music", "Music", "Musical instrument", "Wind instrument, woodwind instrument", "Flute"] | ["low quality", "harmonizing woodwinds melody", "noisy", "mono", "happy", "fun"] | 4 | 2wZCoeq9Ppc | 417 | |
《サックス四重奏》Everything/MISIA | The low quality recording features a wide brass melody played over mellow piano melody. The recording is very noisy and it sounds like it was recorded in a large room. | 2012-05-10T05:10:15Z | エムハチチャンネル | 【MASX-5】 Everything/MISIA 商品詳細はこちら→https://www.music8.com/products/detail4229.php ミュージックエイトHP http://www.music8.com/ | ["Brass instrument", "Clarinet", "Saxophone"] | ["low quality", "wide brass melody", "mellow piano melody", "noisy", "reverberant"] | 4 | IwobTmzjOiQ | 1954 | |
Contradanza de Paquito D'Rivera | The low quality recording features a clarinet solo melody and bass clarinet melody playing. It sounds passionate and joyful, while the recording is noisy and in mono. | 2008-02-01T14:46:53Z | WaltSax López | Arr. Walter López para Dúo de la Contradanza de Paquito D`rivera interpretado por Liam Harman(Clar. Bajo) y Walter López(Clar. Bb) Espero que les guste. Para Descargar Partitura: http://www.clariperu.org/ContradanzaduoCLARIPERU.pdf Arr. Walter López performed by Liam Harman(Bass Clarinet) and Walter López(Bb clarinet) Hope you like it. To Download: http://www.clariperu.org/ContradanzaduoCLARIPERU.pdf | ["Brass instrument", "Clarinet"] | ["low quality", "clarinet solo melody", "bass clarinet melody", "noisy", "mono", "passionate", "joyful"] | 4 | e9ptOl22Duc | 3848 | |
High School Band Teacher | The low quality recording features a flat male talking, after which there are harmonizing clarinet melodies playing. It sounds soulful and the recording is in mono and noisy. | 2013-08-02T17:29:12Z | GO PUBLIC: A Day in the Life of an American School District | Joel Lopez is the high school band director at Marshall Secondary School. He educates his class of aspiring rock stars and jazz musicians by day, then takes care of his baby daughter by night. For more information visit www.gopublicproject.org | ["Brass instrument", "Clarinet", "Saxophone"] | ["low quality", "mono", "noisy", "harmonizing clarinet melodies", "flat male vocal", "soulful"] | 4 | k6F3gc8f8kI | 4299 |
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;