musiccaps_details (view)
1 row where musiccaps_aspects contains "banjo solo", musiccaps_aspects contains "playful", musiccaps_aspects contains "uplifting" and musiccaps_names contains "Mandolin"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Greensky Bluegrass | 3/01/2014 | "Letter To Seymour" - "New Rize Hill" | This is the live performance of a bluegrass music piece. There are male vocals singing together in a lively manner. There are two banjos playing the melody, one acting as the lead and the other as the rhythm. There is also an acoustic guitar following the banjos. An upright bass is playing the bass line which acts as a rhythmic background. The general atmosphere of the piece is very uplifting. The piece can be used in the soundtrack of rural comedies. It could also be used in the background for funny social media content. | 2014-04-20T16:36:51Z | GreenskyBluegrass | Greensky Bluegrass live at the Neptune Theater in Seattle, Washington on March 1, 2014 performing a medley of Letter To Seymour into New Rize Hill. Anders Beck: dobro Michael Arlen Bont: banjo and vocals Dave Bruzza: guitar and vocals Mike Devol: bass and vocals Paul Hoffman: mandolin and vocals Filmed & Edited by Mark Burgin (tapermark) © 2014 Greensky Bluegrass All Rights Reserved www.greenskybluegrass.com | ["Flamenco", "Music", "Mandolin", "Bluegrass"] | ["bluegrass", "live performance", "male vocals", "banjo", "banjo solo", "upright bass", "acoustic guitar", "playful", "joyful", "uplifting", "easygoing"] | 9 | Tvwi_YuLehk | 2876 |
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;