musiccaps_details (view)
1 row where musiccaps_aspects contains "cello", musiccaps_aspects contains "cembalo" and "youtube_published" is on date 2016-04-14
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 |
---|---|---|---|---|---|---|---|---|---|---|
Antonio Vivaldi - Cello Sonata no. 3 in A minor, I. Largo, on baroque cello with harpsichord | Someone is playing a melody in the higher midrange on a cello. In the background you can hear someone playing along on a cembalo. This song may be playing at a live concert. | 2016-04-14T16:34:53Z | emilyplayscello | Support Emily and guests on the channel at http://patreon.com/emilyplayscello Vivaldi's Cello Sonatas are some of the greatest baroque cello pieces! Great to play this with continuo on harpsichord. Featuring guest Dylan Sauerwald, harpsichord http://www.dylansauerwald.com http://twitter.com/dsauerwald FOLLOW EMILY ON SPOTIFY: https://open.spotify.com/artist/4U2ufR0Ma24ITADCqZg20A Learn more about harpsichord continuo playing: https://www.youtube.com/watch?v=0BLr7Yt_ehw Download Emily's cello albums at: http://emilyplayscello.bandcamp.com http://oldstyle.bandcamp.com Leave your questions, and if you're looking for personal instruction, I offer Skype lessons. Email emilyplayscello [at] gmail dot com My gut strings are made by Damian Dlugolecki. They are the most stable strings I've found, being able to handle weather changes better than others, with great tone and resonance. You can order from him at http://www.damianstrings.com Follow on Facebook: http://facebook.com/emilyplayscello Instagram: http://instagram.com/emilyplayscello Twitter: http://twitter.com/emilyplayscello emilyplayscello.com Emily Davidson, baroque cello | ["Harpsichord", "Keyboard (musical)"] | ["classical", "cembalo", "cello", "slower tempo", "sad"] | 6 | cF7317DK0NQ | 3689 |
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;