musiccaps_details (view)
2 rows where musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "low quality", musiccaps_names contains "Brass instrument" and musiccaps_names contains "Saxophone"
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 | |
How to Play The Simpsons Theme on the Alto Sax | The low quality recording features a tutorial where a flat male vocal is talking in-between notes of alto saxophone. The recording is noisy and in mono. | 2010-01-18T02:29:03Z | MrAwesomelyawesome | How to Play the Simpsons Theme on the Alto Sax plz leave a comment and subscribe | ["Brass instrument", "Saxophone"] | ["low quality", "noisy", "mono", "flat male vocal", "alto saxophone notes", "tutorial"] | 4 | wcLPCMoy5hk | 5279 |
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;