musiccaps_details (view)
2 rows where musiccaps_aspects contains "live recording", musiccaps_aspects contains "low quality recording" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- live recording · 2 ✖
- low quality recording · 2 ✖
- classical piano piece 1
- complex motif 1
- female voice 1
- foreign language 1
- intricate piano playing 1
- no percussion 1
- rapid piano playing 1
- stringed instrument 1
- suspense 1
- tenor guitar 1
- tension 1
musiccaps_names (array) 7 ✖
- Music 2
- Musical instrument · 2 ✖
- Classical music 1
- Keyboard (musical) 1
- Mandolin 1
- Piano 1
- Rattle (instrument) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Remigio Fuentes_Joropo y Estribillo con Mónico Márquez | This song is a low quality live recording. This features an older female voice singing the main melody. This is accompanied by a tenor guitar playing two chords in a repeated rhythm. A male voice sings a fill after a line by the female voice. There is no percussion in this song. There are no other instruments. This is a celebration song sung in a foreign language. | 2009-05-25T20:10:09Z | Escucha Joropo | Joropo Tradicional del Oriente Venezolano. Remigio Fuentes popularmente conocido como "Morocho Fuentes" es extraordinario en la ejecución de La Mandolina con un alto dominio en la interpretación del Joropo con Estribillo. Músico del estado Sucre. Posee la gran jocosidad que caracteriza al oriental. Disfruta con mucha humildad de su música y de la compañía de sus coterráneos. Celebramos su amistad | ["Music", "Mandolin", "Musical instrument", "Rattle (instrument)"] | ["live recording", "low quality recording", "foreign language", "female voice", "stringed instrument", "tenor guitar", "no percussion"] | 0 | nb_7c2xPKYA | 4562 |
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;