musiccaps_details (view)
3 rows where musiccaps_aspects contains "piano", musiccaps_author = 9 and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- piano · 3 ✖
- emotional 2
- heart-touching 2
- instrumental 2
- no singer 2
- acoustic drums 1
- backing track 1
- bass guitar 1
- blues 1
- classical 1
- classical music 1
- eccentric 1
- electric guitar 1
- groovy 1
- guitar solo 1
- jam 1
- live performance 1
- passionate 1
- rock music 1
- shredding 1
- theremin 1
- unique 1
musiccaps_names (array) 10 ✖
- Music 3
- Musical instrument · 3 ✖
- Blues 1
- Classical music 1
- Electric guitar 1
- Guitar 1
- Keyboard (musical) 1
- Piano 1
- Plucked string instrument 1
- Theremin 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Epiphone Les Paul Blues in G | This is an instrumental rock music piece recording in the style of blues. There is an electric guitar playing a solo using the shredding technique. The backing track consists of a piano, a bass guitar and acoustic drums. There is a groovy feel to it. Parts of this recording could be sampled for use in beat-making. | 2006-02-22T07:39:48Z | Raúl Cabezalí | Download my tunes for free from http://www.jamendo.com/en/artist/353294/raulin-de-los-bosques Raulin de los Bosques plays some blues licks over a g-blues backing track on a Epiphone 'Les Paul' Standard through his Behringer V-amp2. | ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["rock music", "jam", "no singer", "instrumental", "electric guitar", "guitar solo", "shredding", "backing track", "piano", "bass guitar", "acoustic drums", "groovy", "blues"] | 9 | hVVrl9FkKnY | 4113 | |
Samuel Hoffman's RCA Theremin | This is a classical music performance. There is a gentle piano tune playing in the background while there is a theremin playing the main melody. The performance has a unique feel to it. The atmosphere is out of the ordinary but also heart-touching. This piece could be used in the soundtrack of an animation movie/TV series. | 2007-07-15T11:34:12Z | Peter Pringle | Dr. Samuel Hoffman took his 1929 RCA theremin with him when he moved from New York City to Los Angeles, California, in 1941. He eventually became world famous as "The Hollywood Thereminist" and the distinctive sound of his instrument can be heard on the soundtracks of over 40 major motion pictures of the 1940's and 50's. Alfred Hitchcock's SPELLBOUND (music by Miklos Rosza), the SciFi classic THE DAY THE EARTH STOOD STILL (music by Bernard Herrmann) and Cecile B. deMille's perennial THE TEN COMMANDMENTS, are just a few of the movies in which this theremin can be heard. I acquired this unique vintage instrument from the Hoffman family in 1998 and have carefully maintained it and enjoyed playing it ever since. It sounds today just the way it sounded when the late Dr. Hoffman played it at the "Casino In The Air" on top of mid-town Manhattan's Hotel Montclair in the 1930's. In order to give the camera a better view of the inside, for the purpose of this video, I removed the two cabinet doors (which normally remain closed). I am playing French chanteuse Edith Piaf's hit from the 1940's, LA VIE EN ROSE. | ["Music", "Musical instrument", "Theremin"] | ["classical music", "no singer", "instrumental", "piano", "theremin", "emotional", "unique", "eccentric", "heart-touching"] | 9 | nIL_xrqjo1g | 4530 | |
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;