musiccaps_details (view)
1 row where musiccaps_aspects contains "live performance", musiccaps_aspects contains "sustained woodwinds melody" and "youtube_published" is on date 2008-05-22
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;