musiccaps_details (view)
2 rows where musiccaps_aspects contains "orchestra" and musiccaps_aspects contains "staccato strings melody" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- live performance 2
- low quality 2
- noisy 2
- orchestra · 2 ✖
- staccato strings melody · 2 ✖
- background music 1
- classical 1
- distorted 1
- mono 1
- solo low tuba melody 1
- staccato brass section 1
- sustained woodwinds melody 1
- woodwinds melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Russian Sailor's Dance, CHS Symphony Orchestra | The low quality recording features a live performance of an orchestra that consists of staccato strings melody and sustained woodwinds melody at least. The recording is very noisy, to the point that it is distorting, and in mono - as it was probably recorded with a poor quality microphone. | 2008-05-22T11:27:06Z | CHSBandBooster | Russian Sailor's Dance, CHS Symphony Orchestra Russian Sailor's Dance by R. Gliere preformed by the Coronado High School Symphony Orchestra. Ida Stedman, Orchestra director. The Symphony Orchestra is composed of students from Band and the String Orchestra. The EPISD Festival for Orchestra was held on Thursday May 15, 2008 at the "Ross Capshaw Auditorium" Coronado High School in El Paso Texas. | ["Orchestra"] | ["low quality", "noisy", "live performance", "mono", "orchestra", "distorted", "staccato strings melody", "sustained woodwinds melody"] | 4 | O6xMQnKJROc | 2400 | |
Andreas Martin Hofmeir - Tuba - Echo Classic Verleihung 2013 - Instrumentalist des Jahres | The low quality recording features a classical music played by orchestra that consists of staccato string melody, woodwinds melody, staccato brass melody and solo, low tuba melody. The recording is a bit noisy and it sounds like background music for old movies. | 2013-10-10T05:37:26Z | MoLeMove | Andreas Martin Hofmeir spiel Tuba mit dem Konzerhaus Orchester Berlin | ["Echo", "Music"] | ["live performance", "orchestra", "classical", "noisy", "low quality", "staccato strings melody", "woodwinds melody", "staccato brass section", "solo low tuba melody", "background music"] | 4 | GNjsxLdSwHI | 1713 |
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;