musiccaps_details (view)
3 rows where musiccaps_aspects contains "intricate piano playing" and musiccaps_author = 3
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- intricate piano playing · 3 ✖
- bongos 1
- brass instruments 1
- build-up 1
- classical piano piece 1
- complex motif 1
- dance 1
- east asian music 1
- energetic 1
- groovy 1
- jazz 1
- latin music 1
- live recording 1
- low quality recording 1
- percussion rhythm 1
- piano 1
- rapid piano playing 1
- saxophone 1
- suspense 1
- tension 1
- timpani 1
- traditional percussive instruments 1
- trumpets 1
- upbeat 1
musiccaps_names (array) 9 ✖
- Music 2
- Percussion 2
- Classical music 1
- Drum 1
- Keyboard (musical) 1
- Musical instrument 1
- Orchestra 1
- Piano 1
- Timpani 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Marvin Diz Performs in the LP Studio | This is a jazz song with some latin infusions into the style. The brass section plays bright and ascending melodies. The percussionists play bongos and snares with brushes. The song is fun and suitable for some loose dancing. | 2009-12-15T20:54:15Z | Latin Percussion | The Marvin Diz Band Performs "Pensando en la Habana" LP Instruments: LP Bata Drums LP Giovanni Palladium Series Congas LP Giovanni Palladium Series Bongos LP Tito Puente Timbales LP Jam Block LP Salsa Cowbell | ["Drum", "Orchestra", "Percussion"] | ["jazz", "latin music", "brass instruments", "trumpets", "saxophone", "traditional percussive instruments", "bongos", "intricate piano playing", "groovy", "dance"] | 3 | A6HJBIU1rD0 | 1068 | |
Corneria from Star Fox on Piano | The pianist plays a classical piano piece which brings out a feeling of suspense and tension. The piece is complex and rapid. It has the sense of building up due to the low rumbling of the bass notes. The recording is a low-quality recording, and it is live. | 2006-09-06T05:04:03Z | Alan Chang | Me playing Corneria from Star Fox (the SNES one) on the piano. Messed up a few times because I was nervous... =/ Sheet music: http://vgsm.learn2cube.com NOTE: There's no video editing at all. I don't understand why some people think there is... | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Classical music"] | ["low quality recording", "live recording", "intricate piano playing", "classical piano piece", "rapid piano playing", "complex motif", "tension", "suspense"] | 3 | XYQnMxWnetY | 3195 | |
光の隙間 打楽器五重奏 Full | Some big and bold percussion instruments, namely timpanis, are used in this piece and create a bold and magnetic atmosphere. There is an intricate piano melody that comes in after the rhythmic percussive intro. The song fits into the east asian part of the world. | 2012-09-15T13:57:41Z | 味うに | 吹奏楽部打楽器(パーカッション)専用 光の隙間 Full 打楽器五重奏! アンサンブルコンテストに参加する方は、頑張ってください! ビブラ、グロッケン、マリンバ、ティンパニ、ドラム | ["Timpani", "Music", "Percussion"] | ["timpani", "percussion rhythm", "upbeat", "energetic", "build-up", "piano", "intricate piano playing", "east asian music"] | 3 | uknhELOFYmY | 5134 |
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;