musiccaps_details (view)
4 rows where musiccaps_aspects contains "live audience", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "western classical music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 55 ✖
- instrumental music 4
- live audience · 4 ✖
- passionate · 4 ✖
- western classical music · 4 ✖
- emotional 3
- great composers 3
- live performance 3
- medium tempo 3
- opera hall 3
- baroque music 2
- concert hall 2
- conductor 2
- conductors 2
- philharmonic orchestra 2
- poor audio quality 2
- romantic 2
- spirited 2
- string section 2
- ambient room noises 1
- bach 1
- bad audio quality 1
- cellist 1
- cello concerto 1
- cello solo 1
- composers 1
- concerto 1
- duet 1
- dvorak 1
- engaging 1
- exciting 1
- great technique 1
- great vibrato 1
- groovy music 1
- harpsichord 1
- harpsichord harmony 1
- harpsichord player 1
- harpsichordist 1
- heart strings 1
- heartfelt 1
- live elector 1
- live music 1
- mace 1
- masterful string technique 1
- no other instrumentation 1
- orchestra 1
- royal dance 1
- sentimental 1
- string duet 1
- timpani bangs loud 1
- two harpsichords 1
- violin solo 1
- violins playing harmony 1
- virtuosos in play 1
- virtuously 1
- wind sections 1
musiccaps_names (array) 11 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Couperin & Clavecin | The song is an instrumental. The song is medium tempo with a harpsichord belting played with no other instrumentation. The music is emotional, passionate and melancholic. The song audio quality is poor. | 2007-10-14T21:47:21Z | profsha | Eric DEM joue Couperin au clavecin à l'église de Cesson-Sévigné. | ["Harpsichord", "Keyboard (musical)"] | ["harpsichord", "harpsichord player", "harpsichordist", "poor audio quality", "instrumental music", "medium tempo", "composers", "conductors", "live music", "live performance", "live audience", "emotional", "spirited", "romantic", "baroque music", "passionate", "western classical music"] | 1 | S38KjqRR418 | 2737 | |
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 | |
Kirito - Icaross (Orchestra Version) | The song is an instrumental. The song is slow tempo with a violin and cello playing a duet with no other instrumentation. The song is emotional and extremely heartfelt. The song is a western classical music hit. | 2007-09-07T19:31:10Z | Marcus | live from Kiritos Symphonic Concert | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["violin solo", "cello solo", "string duet", "heartfelt", "duet", "orchestra", "opera hall", "concert hall", "live audience", "string section", "great composers", "great vibrato", "masterful string technique", "virtuosos in play", "conductor", "live performance", "heart strings", "instrumental music", "philharmonic orchestra", "western classical music", "emotional", "romantic", "passionate", "sentimental"] | 1 | wBe5tW8iJew | 5246 | |
Dvořák: Cello Concerto / Isserlis · Gilbert · Berliner Philharmoniker | The song is an instrumental. The tempo is medium with a cellist playing a virtuoso solo accompanied by a string section harmony, flutes in harmony and a loud banging timpani. The song is spirited and passionate with poor audio quality. The song is a western classical piece. | 2009-06-19T08:28:26Z | Berliner Philharmoniker | Full-length concert: http://www.digitalconcerthall.com/concert/27/?a=youtube&c=true Antonín Dvořák: Cello Concerto / Steven Isserlis, cello · Alan Gilbert, conductor · Berliner Philharmoniker / Recorded at the Berlin Philharmonie, 19 April 2009. The Berliner Philharmoniker's Digital Concert Hall: http://www.digitalconcerthall.com Subscribe to our newsletter: http://www.digitalconcerthall.com/newsletter Website of the Berliner Philharmoniker: http://www.berliner-philharmoniker.de | ["Cello", "Music", "Musical instrument", "Orchestra", "Violin, fiddle", "Classical music", "Bowed string instrument"] | ["cellist", "string section", "philharmonic orchestra", "cello concerto", "dvorak", "virtuously", "timpani bangs loud", "medium tempo", "wind sections", "violins playing harmony", "groovy music", "western classical music", "great composers", "conductor", "opera hall", "live audience", "live performance", "instrumental music", "passionate", "spirited", "emotional", "great technique", "poor audio quality", "concert hall"] | 1 | yrme-KRBvzk | 5445 |
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;