musiccaps_details (view)
3 rows where musiccaps_aspects contains "noisy", musiccaps_names contains "Music", musiccaps_names contains "Musical instrument" and musiccaps_names contains "Orchestra"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Vaughan Williams Tuba Concerto Part 3 | The low quality recording features a live performance that consists of a tuba solo melody and some loud impact in the background. The recording is noisy, loud and distorted. | 2008-06-17T12:09:48Z | sersvet | National Filarmonica, Chisinau,R.V. Williams - Tuba Concerto, Part 3. Solist Serghei Svet | ["Brass instrument", "Foghorn", "Music", "Musical instrument", "Orchestra"] | ["low quality", "loud", "distorted", "loud impact", "tuba solo melody", "noisy", "live performance"] | 4 | KB4e9v_5uTE | 2062 | |
Hydraulophone in concert | The low quality recording features a hydraulophone melody played alongside water leaking sound. The recording is wide, noisy and it sounds relaxing and calming. | 2007-04-12T01:31:06Z | hydraulist | Suite for Hydraulophone, as performed by Ryan Janzen in the Great Hall, with the Hart House Symphonic Band. This is the world's first orchestral performance in which instruments make sound from all three states of matter (solid, liquid, and gas). Other orchestras use only 2 states of matter: solid (percussion and strings), and gas (wind instruments). For more videos, see www.splashtones.com | ["Music", "Musical instrument", "Orchestra", "Classical music", "Inside, large room or hall"] | ["low quality", "hydraulophone melody", "water leaking", "noisy", "wide", "mystical", "calming", "relaxing"] | 4 | tnJb9WyhCUc | 5066 | |
Renegades Steel Orchestra | The low quality recording features a live performance of steel drums, followed by energetic drums in the background. It sounds exotic, passionate, energetic and the recording is noisy and in mono. | 2008-02-16T07:33:29Z | panjumbie | Highest-profile ambassadors for the steel pan music, the Renegades Steel Orchestra from Trinidad & Tobago on European Tour 2007. The Panyard Bern (Switzerland) hosted 3 concerts (10 - 12 July 2007) at http://www.thepanyard.ch These 3 concerts have been sponsored by: pan-jumbie.com, panmusic.ch, panch.ch, funlandserenaders.ch, Richardson Steeldrums, and brewery Feldschlösschen Video production by VJ Peter Krüsi | ["Drum", "Drum kit", "Music", "Musical instrument", "Orchestra", "Percussion", "Steelpan"] | ["low quality", "live performance", "steel drums melody", "energetic drums", "energetic", "exotic", "passionate", "mono", "noisy"] | 4 | x22NHqwKSNE | 5302 |
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;