musiccaps_details (view)
5 rows where musiccaps_aspects contains "soloist" and musiccaps_aspects contains "western classical music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 73 ✖
- instrumental music 5
- soloist · 5 ✖
- western classical music · 5 ✖
- bad audio quality 3
- emotional 3
- entertaining 3
- medium tempo 3
- romantic 3
- exciting 2
- great composers 2
- home video 2
- passionate 2
- positive 2
- ambient room noises 1
- bach 1
- baroque music 1
- bow 1
- cascade of notes 1
- cellist 1
- cello 1
- cello suite 1
- cheerful comforting 1
- clarinetist 1
- classical masterpieces 1
- dance music 1
- fingering technique 1
- grandeur 1
- greta composers 1
- harp playing beautifully 1
- harpist 1
- harpsichord 1
- hissing noise 1
- home music video 1
- instrumental player 1
- kings and queens 1
- life is beautiful 1
- live audience 1
- live performance 1
- live recording 1
- low pitched notes 1
- medium fast tempo 1
- melancholic 1
- moody blues 1
- music demo 1
- music video 1
- no percussion instruments 1
- nostalgia 1
- nostalgic 1
- people dancing 1
- percussionist 1
- poignant 1
- practice room 1
- practice session 1
- precious moments 1
- rehearsal session 1
- relaxing music 1
- rowland 1
- royal music 1
- sight reading 1
- slow tempo 1
- soundboard 1
- spirited 1
- string quartet 1
- string section playing 1
- strings 1
- studio session 1
- tambourine playing percussively 1
- the kings court 1
- traditional stringed instrument 1
- ukulele 1
- ukulele player 1
- varying volume levels 1
- william byrd 1
musiccaps_names (array) 12 ✖
- Music 2
- Banjo 1
- Bowed string instrument 1
- Cello 1
- Double bass 1
- Harp 1
- Harpsichord 1
- Keyboard (musical) 1
- Mandolin 1
- Piano 1
- Strum 1
- Tambourine 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Rowland by William Byrd on virginal | The song is an instrumental. The tempo is medium with a harpsichord being played expertly with no other instrumentation. The song is melancholic and exciting. The song is western classical baroque piece that evokes a sense of grandeur. | 2012-03-01T07:57:04Z | My Years With Early Music | also know as Lord Willoughby's Welcome home, from the Fitzwilliam Virginal Book. http://en.wikipedia.org/wiki/Fitzwilliam_Virginal_Book edition by Dover: http://store.doverpublications.com/0486210693.html ernst stolz | ["Harpsichord", "Keyboard (musical)", "Piano"] | ["harpsichord", "instrumental player", "william byrd", "rowland", "grandeur", "great composers", "sight reading", "western classical music", "baroque music", "traditional stringed instrument", "royal music", "instrumental music", "soloist", "kings and queens", "medium tempo", "western classical music", "greta composers", "dance music", "people dancing", "nostalgia", "emotional", "entertaining", "positive", "cheerful comforting", "relaxing music", "the kings court"] | 1 | YOG_PPvTvW0 | 3284 | |
Chris Thile - Bach: Sonata No. 1 in G Minor, BWV 1001 (Complete) | A male ukulele player plays this emotional solo. The song is medium tempo with no other instrumentation than an ukulele playing. The song is emotional and poignant. The song is an instrumental tune. | 2013-10-14T17:44:07Z | ChrisThile | Chris Thile performs Bach's Sonata No. 1 in G Minor, BWV 1001 in full. Also featured on his album Bach: Sonatas and Partitas, Vol. I, available now on CD & vinyl from Nonesuch Records: http://punchbrothers.kungfustore.com/categories/553-bach-sonatas-and-partitas http://www.nonesuch.com/store/chris-thile iTunes: http://www.smarturl.it/thilebachitunes See Chris live on tour this fall: http://punchbrothers.com/thiletour | ["Banjo", "Music", "Mandolin", "Strum"] | ["ukulele", "ukulele player", "medium tempo", "music video", "romantic", "no percussion instruments", "music demo", "moody blues", "melancholic", "western classical music", "instrumental music", "soloist", "poignant", "entertaining", "emotional", "no percussion instruments", "home video"] | 1 | j3lH_Tevw5o | 4231 | |
Ravel Introduction et Allegro for Harp, stringquartet, flute, clarinet | The song is an instrumental. The song is in medium tempo with a harpist playing a beautiful cascade of notes while the orchestra watches. The song is exciting and passionate. The audio quality is poor. | 2008-10-20T22:15:32Z | eefkedegeus | Introduction et Allegro M. Ravel Harp, stringquartet, flute, clarinet. From left to right Mariana, Angela, David, Cristina, Eefke, Miguel, Germaine. M. Ravel - Introduction et Allegro Royal Conservatory Den Haag, Holland | ["Harp"] | ["harpist", "harp playing beautifully", "clarinetist", "string quartet", "bad audio quality", "live audience", "life is beautiful", "precious moments", "classical masterpieces", "live performance", "ambient room noises", "slow tempo", "cascade of notes", "live performance", "soloist", "western classical music", "exciting", "romantic", "instrumental music"] | 1 | u8aB6EALonk | 5091 | |
Carnival Overture - Tambourine performed by Steve Myers | The song is an instrumental. The song is medium fast tempo with a western classic al piece featuring a string string section plays and a tambourine player practices along with background music. The song is spirited and passionate. The audio quality is very poor. | 2011-06-22T18:06:47Z | ybooby | Dvoraks Carnival Overture | ["Music", "Tambourine"] | ["tambourine playing percussively", "home music video", "entertaining", "soloist", "percussionist", "rehearsal session", "bad audio quality", "practice room", "instrumental music", "hissing noise", "varying volume levels", "string section playing", "positive", "spirited", "passionate", "western classical music", "medium fast tempo"] | 1 | xzgnLpKkvdg | 5375 |
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;