musiccaps_details (view)
1 row where musiccaps_aspects contains "harmonizing clarinet melodies", musiccaps_names contains "Saxophone" and "youtube_published" is on date 2013-08-02
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 |
---|---|---|---|---|---|---|---|---|---|---|
High School Band Teacher | The low quality recording features a flat male talking, after which there are harmonizing clarinet melodies playing. It sounds soulful and the recording is in mono and noisy. | 2013-08-02T17:29:12Z | GO PUBLIC: A Day in the Life of an American School District | Joel Lopez is the high school band director at Marshall Secondary School. He educates his class of aspiring rock stars and jazz musicians by day, then takes care of his baby daughter by night. For more information visit www.gopublicproject.org | ["Brass instrument", "Clarinet", "Saxophone"] | ["low quality", "mono", "noisy", "harmonizing clarinet melodies", "flat male vocal", "soulful"] | 4 | k6F3gc8f8kI | 4299 |
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;