musiccaps_details (view)
1 row where musiccaps_aspects contains "theatrical" and youtube_description = "Jean-Philippe Rameau, composer (transcribed by Claude Balbâtre) Jory Vinikour, harpsichord French double harpsichord by Cucchiara and Pierce Recorded April 13, 2011 in Shaker Heights, Ohio USA"
This data as json, CSV (advanced)
Suggested facets: musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ouverture de l'opéra-ballet Pygmalion | This is a French opera/opera-ballet music piece. There is no singer in this piece. The only instrument that is being played is a harpsichord. The sound and the tunes are reminiscent of the medieval era. There is a theatrical feel to the piece. This piece could be used in the soundtrack of a historical drama that takes place in the medieval era. It could also be used as an accompaniment piece for a theater play or a ballet dance performance. | 2011-07-25T21:59:45Z | Jory Vinikour | Jean-Philippe Rameau, composer (transcribed by Claude Balbâtre) Jory Vinikour, harpsichord French double harpsichord by Cucchiara and Pierce Recorded April 13, 2011 in Shaker Heights, Ohio USA | ["Harpsichord", "Keyboard (musical)"] | ["french opera", "opera-ballet", "no singer", "instrumental", "harpsichord", "medieval sounding", "theatrical", "ballet dance"] | 9 | Iz611KubW70 | 1957 |
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;