musiccaps_details (view)
1 row where musiccaps_author = 3, musiccaps_names contains "Brass instrument" and youtube_description = "Adam Rapa playing some of his 7/8 arrangement of "Flight of the Bumble Bee" just half an hour after he took delivery of his new PRANA P3S Bb, March 2007."
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|
Adam Rapa's "Flight of the Bumble Bee" | This clip is a live recording of a complex and rapid piece being played on the trumpet. The trumpet is very high pitched and the piece ascends and descends rapidly in succession. | 2008-10-29T06:12:39Z | MonetteCorporation | Adam Rapa playing some of his 7/8 arrangement of "Flight of the Bumble Bee" just half an hour after he took delivery of his new PRANA P3S Bb, March 2007. | ["Brass instrument", "Jazz", "Music", "Musical instrument", "Trumpet"] | ["high pitched brass instrument", "trumpet", "rapid trumpet motif", "complex brass motif"] | 3 | _vwBe9ZXWXE | 3498 |
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;