musiccaps_details (view)
2 rows where musiccaps_aspects contains "piano", musiccaps_author = 8, musiccaps_names contains "Inside, large room or hall" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Matt Andersen - So Gone Now - Halifax, NS | Trio recorded live in a concert hall with a loud upright bass, piano and acoustic guitar playing a solo. Jazz feel and chord progression with no drums. Heartfelt performance. | 2009-04-22T01:20:12Z | techy72 | I took this and with Matt's permission am posting it up here for all of you too SEE!!!! It's a great song and a fantastic preformance!!! | ["Music", "Harmonic", "Inside, large room or hall"] | ["loud upright bass", "acoustic guitar solo", "jazz chord progression", "piano", "no drums", "instrumental", "trio", "concert hall", "live", "heartfelt"] | 8 | d1nz5tZckSA | 3757 | |
Arturo & Doc Solos.mp4 | a latin jazz ensemble performing in a recital hall. A trumpet solo is accompanied by acoustic bass, syncopated drums and piano. The rhythm is upbeat and danceable. You can hear the reverb of the recital hall as well as audience sounds, someone sneezing. | 2010-11-29T02:19:26Z | jazzman1222 | This is my second Video of Doc and Arturo at the Rafael Mendez Trumpet Festival in Mexico City. Hard to believe that Doc is 83, he still has a wonderful sound!!! Arturo is still burnin´as usual!! | ["Brass instrument", "Jazz", "Music", "Musical instrument", "Trumpet", "Inside, large room or hall"] | ["latin jazz", "trumpet solo", "acoustic bass", "recital hall", "reverb", "audience sounds", "sneeze", "piano", "syncopated drums", "upbeat rhythm", "danceable"] | 8 | eiyyoUt64Zc | 3894 |
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;