musiccaps_details (view)
5 rows where musiccaps_aspects contains "amateur recording" and musiccaps_names contains "Harpsichord"
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- amateur recording · 5 ✖
- classical 3
- cembalo 2
- clavicembalo 1
- complex 1
- fast tempo 1
- harpsichord 1
- male voice talking 1
- medium/uptempo 1
- organ playing 1
- slow tempo 1
youtube_published (date) 5 ✖
- 2007-11-24 1
- 2007-12-11 1
- 2008-07-20 1
- 2009-04-15 1
- 2014-03-30 1
musiccaps_names (array) 4 ✖
- Harpsichord · 5 ✖
- Keyboard (musical) 5
- Hammond organ 1
- Organ 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sweelinck's Fantasia Chromatica in Werckmeister tuning | This audio contains a male voice talking with a lot of reverb on his voice. Then someone starts playing a single tone on a cembalo. This is an amateur recording and sounds more like a tutorial. | 2009-04-15T21:39:48Z | Michael Maxwell Steer | Three performances of the same piece in differing temperaments. This is Werckmeister tuning. For a discussion about temperaments see http://msteer.co.uk/edu/3temperament.htm | ["Harpsichord", "Keyboard (musical)"] | ["amateur recording", "male voice talking", "cembalo"] | 6 | G6ihF82lvEA | 1692 | |
Chiara Massini - J.S. Bach, Suite in a moll BWV 818 | This audio contains someone playing a complex and fast classical piece of music on a clavicembalo. This song may be playing live at a concert. | 2014-03-30T13:11:06Z | Chiara Massini | Chiara Massini plays Bach's Suite in a moll BWV 818 on the harpsichord. The instrument is a two manuals made by Joel Katzman. Prélude Allemande Courante Sarabande Menuet Gigue | ["Harpsichord", "Keyboard (musical)"] | ["amateur recording", "classical", "clavicembalo", "fast tempo", "complex"] | 6 | ULHPhjaJ6p0 | 2907 | |
ATTALOPE PARI K61N organ | Someone is playing a melody along with chords in the mid range on an organ. This song may be playing in a gospel church. | 2007-12-11T19:51:09Z | ATTALOPE | A Whiter shade of pale by ATTALO PELLINI with PARI K61N electromagnetic organ and 147 Leslie. | ["Organ", "Hammond organ", "Harpsichord", "Keyboard (musical)"] | ["amateur recording", "organ playing", "medium/uptempo"] | 6 | VCIN1OJkNbg | 2981 | |
Clavecin / Harpsichord : Prelude en ré mineur (baroque music) | This audio contains someone playing a classical piece on a harpsichord. This song may be playing live at a concert. | 2008-07-20T23:14:19Z | Claude Nadeau - orgue, clavecin- orchestre baroque | Concert au Château Ramezay, Salle de Nantes, Montréal, 10 juillet 2008. Claude Nadeau, clavecin / harpsichord. Prélude en ré mineur de la 3e suite pour clavecin de De Mars (compositeur breton) | ["Harpsichord", "Keyboard (musical)"] | ["amateur recording", "harpsichord", "classical", "slow tempo"] | 6 | oMgSuyPBINs | 4619 | |
Mein junges Leben hat ein End: J.P. Sweelinck | This audio contains someone playing a classical piece on a cembalo. This song may be playing at a theater. | 2007-11-24T09:07:12Z | My Years With Early Music | monumenta musica neerlandica: variations on mein junges leben hat ein End mein Freud und auch mein Leid Mein arme Seele soll behend scheiden von meinem Leib Leben kann nicht länger stehn es ist schwach es muß vergehen es fährt dahin mein Leid by Jan Pieterszoon Sweelinck 1562-1621 played by ernst stolz virginal: Terwal, Oss fecit paintings by Jan Lievens www.ernststolz.com | ["Harpsichord", "Keyboard (musical)"] | ["amateur recording", "cembalo", "classical"] | 6 | ocCIB2bPq_Y | 4646 |
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;