musiccaps_details (view)
3 rows where musiccaps_author = 4, musiccaps_names contains "Clarinet" and musiccaps_names contains "Saxophone"
This data as json, CSV (advanced)
Suggested facets: musiccaps_names, youtube_published (date)
musiccaps_aspects (array) 18 ✖
musiccaps_names (array) 4 ✖
- Brass instrument 3
- Clarinet · 3 ✖
- Saxophone · 3 ✖
- Trombone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
《サックス四重奏》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 | |
Partitura Brasileirinho samba jazz solo e improviso, flauta e trombone. | The low quality recording features shimmering cymbals, brass melody, woodwinds melody, groovy piano, groovy bass and soft kick and snare hits played altogether. It sounds chaotic and manic. | 2014-02-04T21:14:11Z | jeferson ramos | ["Brass instrument", "Clarinet", "Saxophone", "Trombone"] | ["low quality", "shimmering cymbals", "brass melody", "woodwinds melody", "groovy piano", "groovy bass", "soft kick", "soft snare", "manic", "chaotic"] | 4 | KLFoZA8btu4 | 2075 | ||
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;