musiccaps: musiccaps_details: 6 rows where youtube

6 rows where youtube_channel = "Chiara Massini"

descending

youtube_link	musiccaps_caption	youtube_published	youtube_channel	youtube_description	musiccaps_names	musiccaps_aspects	musiccaps_author	youtube_id	musiccaps_rowid
Chiara Massini - J.S. Bach, Fantasia in g moll BWV 917 // Fuge in a moll BWV 947	The low quality recording features a wide harpsichord melody. It sounds passionate, emotional and the recording is noisy.	2015-06-21T21:35:23Z	Chiara Massini	Chiara Massini plays Bach's Fantasia in g moll BWV 917 and Bach's Fuge in a moll BWV 947 on the harpsichord. The instrument is a two manuals made by Joel Katzman.	["Harpsichord", "Keyboard (musical)"]	["low quality", "noisy", "wide harpsichord melody", "passionate", "emotional"]	4	3PwR0D7CuwM	465
Chiara Massini - J. S. Bach: Toccata BWV 916	The low quality recording features a widely spread harpsichord melody. The recording is a bit noisy and it sounds emotional and passionate.	2015-03-01T22:33:15Z	Chiara Massini	Chiara Massini plays Bach's Toccata BWV 916 on the harpsichord. The instrument is a two manuals made by Joel Katzman. Vienna, 1.03.2015	["Harpsichord", "Keyboard (musical)"]	["low quality", "noisy", "wide harpsichord melody", "emotional", "passionate"]	4	A_NkQM85g6Q	1135
Chiara Massini - J.S. Bach, BWV 871 (WTK II) - Präludium und Fuga in c-moll	This classical song features the main melody played on a harpsichord. The mood of this song is happy. This song does not have any percussion or any other instruments. There are no voices in this song. This song can be played for aristocracy.	2013-08-02T21:02:11Z	Chiara Massini	Chiara Massini plays Bach's Präludium und Fuga, c-moll BWV 871 on the harpsichord. The instrument is a two manuals made by Joel Katzman.	["Harpsichord", "Keyboard (musical)"]	["classical song", "harpsichord", "instrumental", "no voices", "happy mood", "no other instrument", "music for aristocracy"]	0	IcPbxJRbe5g	1924
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
Chiara Massini - J.S. Bach, BWV 893 (WTK II) - Präludium und Fuga in h-moll	This is a classical music piece. The piece is being performed on a harpsichord. There is a sophisticated aura to it. The piece has a medieval sound. It would fit perfectly in the soundtrack of a historical drama movie that takes place in the medieval era. It could also work well as the opening theme for a literature YouTube channel.	2013-08-17T11:22:24Z	Chiara Massini	Chiara Massini plays Bach's Präludium und Fuga, h-moll BWV 893 on the harpsichord. The instrument is a two manuals made by Joel Katzman. Kamera: Roman Wiehart Kienersee, August 2013	["Harpsichord", "Keyboard (musical)"]	["classical music", "instrumental", "harpsichord", "medieval sounding", "tender", "sophisticated"]	9	_qf0UiKtB3k	3496
Chiara Massini - J.S. Bach, Französische Suite in E Dur, BWV 817	The low quality recording features a cover of a classical song played on buzzy harpsichord melody. The recording is a bit noisy.	2014-02-16T17:25:12Z	Chiara Massini	Chiara Massini plays Bach's Franzoesische Suite in E Dur BWV 817 on the harpsichord. The instrument is a two manuals made by Joel Katzman. Allemande Courante Sarabande Gavotte Polonaise Bourrée Gigue	["Harpsichord", "Keyboard (musical)"]	["buzzy harpsichord melody", "low quality", "noisy", "classical", "cover"]	4	rFE_bKOr1W0	4859

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;

musiccaps_details (view)

6 rows where youtube_channel = "Chiara Massini"

Advanced export