musiccaps_details (view)

3 rows where musiccaps_aspects contains "acoustic piano" and musiccaps_names contains "Theremin"

✎ View and edit SQL

This data as json, CSV (advanced)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Mother, A Word That Means The World To Me This audio contains a theremin playing a melody in the higher register along to an acoustic piano recording in the background. This song may be practicing theremin playing along with a backing track. 2007-05-12T04:55:28Z ThomasGrillo http://www.thomasgrillo.com Dedicated to Mother. This is a tune which was written around 1914 by Howard Johnson (words), and Theodore Morse (music). Lyrics: M is for the million things she gave me. O means only that she's growing old. T is for the tears she shed to save me. H is for her heart of purest gold. E is for her eyes with love-light shining. R means right, and right, she'll allways be. Put them all together, they spell MOTHER, a word that means the world, to me. Played by Thomas Grillo on Moog Etherwave Pro theremin. Please excuse the ambient noise of two computers, as my mixer was not functioning, and I was forced to use a live microphone from a camcorder. Just turn your trebble down a bit. Copyright 2007 Thomas Grillo ["Music", "Theremin", "Inside, small room"] ["classical", "amateur recording", "theremin", "acoustic piano", "medium to uptempo"] 6 02Qntw26enM 113
Theremin player Armen Ra Someone is playing an acoustic piano repeating a phrase of a chord with single notes in the mid-range while a voice-like synthesizer sound is being played in a higher register. The instrument does sound like a female opera singer with a lot of vibrato. This song may be playing in a theater. 2006-06-28T06:42:04Z Klara Palotai Armen Ra at a benefit concert on April 4, 2006 at the Angel Orensanz Foundation in New York ["Music", "Theremin"] ["piano/opera", "acoustic piano", "synthesizer", "vocal sound", "amateur recording"] 6 Wd5l_FHGWfE 3112
Leon Theremin playing his own instrument An acoustic piano is playing a sad sounding composition while someone is playing a synthesizer lead-sound that sounds like someone crying. You can hear a lot of white noise in the recording. This seems to be an amateur recording. This song may be playing on a TV show. 2008-01-15T01:22:56Z slonikyouth Leon Theremin ["Music", "Theremin"] ["50s/60s music", "acoustic piano", "white noise", "synthesizer string like instrument", "sad atmosphere"] 6 w5qf9O6c20o 5239

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;