musiccaps_details (view)
1 row where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "medium to uptempo" and "youtube_published" is on date 2007-05-12
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 |
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;