musiccaps_details (view)
3 rows where musiccaps_aspects contains "classical", musiccaps_names contains "Keyboard (musical)" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- classical · 3 ✖
- acoustic piano 1
- amateur recording 1
- celebration 1
- emotional 1
- festive 1
- heart-touching 1
- joyful 1
- kazoo 1
- live performance 1
- medium to uptempo 1
- no singer 1
- organ 1
- passionate 1
- piano 1
- procession 1
- single instrument 1
- wedding 1
musiccaps_names (array) 8 ✖
- Keyboard (musical) · 3 ✖
- Music 3
- Musical instrument · 3 ✖
- Piano 3
- Classical music 1
- Harmonic 1
- Inside, large room or hall 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kazoo Solo - The Ode to Joy by Beethoven | Someone is playing a classical piece on the acoustic piano while someone is playing/singing along with a kazoo. This song may be playing in a live concert. | 2008-02-13T14:50:31Z | Kazoo | A student from Emmanuel College, University of Cambridge, performs Beethoven's Ode to Joy from his 9th Symphony, Opus 125. | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Harmonic", "Inside, large room or hall"] | ["classical", "acoustic piano", "kazoo", "amateur recording", "medium to uptempo"] | 6 | ikJKSqnTylI | 4217 | |
Bridal Chorus - Wagner - Here Comes the Bride - Lohengrin - Royal Wedding Music | This is a classical music piece performance. It is meant to be played at a wedding. There is an organ playing a simple and festive tune. There is an atmosphere of celebration in this piece. This music would fit perfectly with weddings. Organ samples could also be lifted from this recording to be used in beat-making. | 2008-05-20T19:47:02Z | Denise Hewitt | The Famous Bridal Chorus by Richard Wagner from his Romantic Opera Lohengrin composed in 1848. Also known as the Wedding March or simply as - Here comes the Bride. This well known wedding processional march is played here on Technics electronic PR60 Keyboard in synthesised church organ mode by Transgendered Musician - Denise Hewitt - wearing full white lace wedding costume, tiara and veil. This wonderful chorus was played at the Royal Wedding Service of British Princess Victoria (eldest daughter of Queen Victoria and Prince Albert) and the Prussian Prince Frederick William in 1858. | ["Music", "Musical instrument", "Wedding music", "Keyboard (musical)", "Piano"] | ["classical", "no singer", "single instrument", "organ", "wedding", "procession", "joyful", "celebration", "festive"] | 9 | vmBkZflwViA | 5201 | |
Schubert: Impromptu in G flat Op. 90 No. 3 | This is a classical music performance. The piece is played by a classical piano which is complex with rising and falling sequences. The atmosphere is filled with emotion and passion. This heart-touching piece could certainly be used in the soundtrack of a drama movie or a TV show. | 2012-12-25T19:58:02Z | Boris Bizjak | Piano recital by Olga Jegunova - http://www.jegunova.com/ Bishopsgate Institute (London), October 2012. Franz Schubert: Impromptu in G flat Op. 90 No. 3 Multimedia engineer - Boris Bizjak http://www.borisbizjak.com/#!hedone | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Classical music"] | ["classical", "piano", "live performance", "emotional", "passionate", "heart-touching"] | 9 | w_z9oSn-eIM | 5277 |
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;