musiccaps_details (view)
3 rows where musiccaps_aspects contains "bad audio quality" and musiccaps_aspects contains "great composers" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- bad audio quality · 3 ✖
- great composers · 3 ✖
- instrumental music 3
- passionate 3
- western classical music 3
- bach 2
- exciting 2
- medium tempo 2
- ambient room noises 1
- baroque music 1
- bow 1
- cellist 1
- cello 1
- cello suite 1
- concerto 1
- conductor 1
- conductors 1
- documentary soundtrack 1
- documentary video 1
- emotional 1
- engaging 1
- fast tempo 1
- fingering technique 1
- harpsichord harmony 1
- high pitched notes 1
- home video 1
- live audience 1
- live elector 1
- live recording 1
- low pitched notes 1
- mace 1
- melancholic 1
- no other instrumentation 1
- nostalgic 1
- opera hall 1
- practice session 1
- romantic 1
- royal dance 1
- soloist 1
- soundboard 1
- spirited 1
- string quartet 1
- string section 1
- strings 1
- studio 1
- studio session 1
- two harpsichords 1
- vibrato 1
- violin solo 1
- violin technique 1
- water splashing sound 1
musiccaps_names (array) 10 ✖
- Bowed string instrument 2
- Cello 1
- Double bass 1
- Harpsichord 1
- Keyboard (musical) 1
- Music 1
- Musical instrument 1
- Piano 1
- Pour 1
- Violin, fiddle 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bach: Concerto for 2 Harpsichords in C major, BWV 1061 (3/3) | The song is an instrumental. The tempo is medium fast with two harpsichordists playing an instrument harmony with no other instrumentation. The song is exciting like a dance but has a bad audio quality. | 2007-04-26T01:52:16Z | Ty Chan | J.S. Bach: Concerto for Two Harpsichords in C major, BWV 1061: 3. Fuga vivace Stephen Gamboa and Tyrone Chan, soloists U.C. Berkeley University Baroque Ensemble Spring 2007 Concert April 24, 2007 125 Morrison Hall | ["Harpsichord", "Keyboard (musical)", "Piano"] | ["two harpsichords", "bach", "concerto", "harpsichord harmony", "bad audio quality", "ambient room noises", "instrumental music", "western classical music", "opera hall", "great composers", "conductors", "live audience", "live elector", "mace", "engaging", "exciting", "passionate", "passionate", "baroque music", "instrumental music", "medium tempo", "royal dance", "no other instrumentation"] | 1 | spyBrs3relU | 4982 | |
J.S.Bach - Cello Suite No.1 - Prelude - Double Bass | The song is an instrumental. The tempo is medium with a cellist playing a JS Bach tune with exemplary skill in a rehearsal session. The song has bad audio quality. The song is a western classical music tune. | 2014-09-03T19:30:44Z | TESEO | J.S.Bach - Suite No.1 for Double Bass BWV 1007 - Prelude - Plays Francesco Tesei - New Fan Page - https://www.facebook.com/Teseoguitar - SUBSCRIBE! http://www.youtube.com/user/teseoguitar?sub_confirmation=1 | ["Cello", "Double bass", "Bowed string instrument"] | ["cello suite", "cello", "cellist", "home video", "emotional", "passionate", "romantic", "nostalgic", "instrumental music", "medium tempo", "bad audio quality", "western classical music", "bach", "practice session", "live recording", "exciting", "low pitched notes", "strings", "soundboard", "fingering technique", "bow", "studio session", "great composers", "soloist"] | 1 | B1ixRtiUJ-U | 1194 | |
Quatuor EBENE: Ravel, Debussy, Fauré -String Quartets | The song is instrumental. The tempo is fast with violins playing in harmony showing exemplary technique. The song is emotional, spirited and passionate. The song is a western classical music hit. The audio quality is poor. | 2013-07-26T16:49:10Z | Warner Classics | Debussy, Fauré & Ravel: String Quartets CD available on: http://bit.ly/FaureRavelStringquartet http://www.emiclassics.com/quatuor-ebene https://www.facebook.com/QuatuorEbene The Quatuor Ebènes debut recording on Virgin Classics brings together the string quartets of the three emblematic French composers of the late 19th and early 20tb centuries: Fauré, Debussy and Ravel. ________________________________________ ________________________________________ Buy from Amazon (USA): http://www.amazon.com/exec/obidos/ASIN/B001BWQWKS/emi-jazz-class-21/ref%3Dnosim ________________________________________ Buy from Amazon (UK): http://www.amazon.co.uk/exec/obidos/ASIN/B001BWQWKS/emi-jazz-class-21/ref%3Dnosim ________________________________________ Buy from Amazon (FR): http://www.amazon.fr/exec/obidos/ASIN/B001BWQWKS/emi-jazz-class-21/ref%3Dnosim ________________________________________ Buy from Amazon (DE): http://www.amazon.de/exec/obidos/ASIN/B001BWQWKS/emi-jazz-class-21/ref%3Dnosim ________________________________________ http://www.quatuorebene.com/ http://www.emiclassics.com http://www.emiclassics.de ________________________________________ __________ Warner Classics ► Website: http://www.warnerclassics.com Subscribe to our: ► YT- Channel: https://wnrcl.me/subscribeYT ► Newsletter https://wnrcl.me/subscribeNL Follow us on: ► Facebook: http://www.fb.com/WarnerClassicsErato ► Instagram: http://www.instagram.com/warner_classics ► Twitter: http://twitter.com/WarnerClassics ► YouTube: https://www.youtube.com/warnerclassics Listen to us on: ► Spotify: http://open.spotify.com/user/warnerclassics ► Apple Music: http://itunes.apple.com/curator/warner-classics/1153741571 ► Deezer https://www.deezer.com/profile/321050935 Warner Classics is the home of classical music, featuring iconic high audio quality recordings from the greatest classical legends, opera stars and orchestras of the last century. Discover our unique collection of live performances, studio sessions and films featuring Maria Callas, Jacqueline du … | ["Music", "Musical instrument", "Pour", "Violin, fiddle", "Bowed string instrument"] | ["water splashing sound", "violin solo", "instrumental music", "great composers", "conductor", "studio", "fast tempo", "string quartet", "string section", "fast tempo", "bad audio quality", "documentary soundtrack", "documentary video", "melancholic", "passionate", "spirited", "vibrato", "high pitched notes", "violin technique", "western classical music"] | 1 | 0qtbbK5HVMw | 213 |
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;