musiccaps_details (view)
3 rows where musiccaps_aspects contains "amateur recording", musiccaps_names contains "Keyboard (musical)" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- amateur recording · 3 ✖
- acoustic piano 1
- blues 1
- classical 1
- e-piano 1
- instructive speaking 1
- kazoo 1
- keyboard lesson 1
- lesson recording 1
- male voice 1
- medium to uptempo 1
- uptempo 1
musiccaps_names (array) 10 ✖
- Keyboard (musical) · 3 ✖
- Music 3
- Musical instrument · 3 ✖
- Piano 3
- Blues 1
- Electronic tuner 1
- Harmonic 1
- Inside, large room or hall 1
- Inside, small room 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Blues Piano Lesson - Improvising in D | This audio contains someone playing blues on an e-piano. This audio is in poor audio quality, you can hear white noise from the recording. This song may be playing piano at home. | 2007-06-04T16:39:45Z | MusicGuru12 | Hey, this is a short but sweet video on a few licks in D. I hope you like the rather zoomed in camera angle, and that it is not to blurry. Please leave a comment so I know what you think. Thanks, Ben | ["Blues", "Music", "Musical instrument", "Keyboard (musical)", "Piano"] | ["amateur recording", "blues", "e-piano", "uptempo"] | 6 | 2gc1L3g1itU | 396 | |
How to Play Butterflies & Hurricanes - Part 1 (LearnMUSE) | This is the recording of a keyboard lesson. There is a male instructor that plays the notes on the keyboard first and then describes the placement of the fingers and the notes that are being played. The audio quality of the lesson is not that great. | 2008-03-10T19:35:06Z | LearnMUSE | Band: Muse Album: Absolution Song: Butterflies & Hurricanes -- Part 1 of 3 -- This is a tutorial for Butterflies and Hurricanes by Muse on the piano by Samuel Deacon. Sorry about the camera positioning, its very difficult to fit everything in, especially on this song. If my hands go off the screen, just try to listen to the notes I'm telling you to play. I've made this with beginners in mind, so if you're a seasoned player you can ignore me talking about notes of chords and stuff. Remember, don't give up, a lot of the song is repeated so if you can get one part down the rest becomes easy. Don't give up on the tricky bits (the solo lol), it takes time before it all becomes smooth. It's a great song to play, really not THAT difficult and a great for showing off! | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Speech", "Electronic tuner", "Inside, small room"] | ["lesson recording", "amateur recording", "keyboard lesson", "male voice", "instructive speaking"] | 9 | 2pTnwe3DzCs | 408 | |
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 |
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;