musiccaps_details (view)
1 row where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "no melody", musiccaps_aspects contains "no voice" and musiccaps_aspects contains "theremin song"
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 |
---|---|---|---|---|---|---|---|---|---|---|
NerdKits Theremin Halloween Costume | This song features a theremin being played. There is no melody to this song. There is no other instrument in this song. This sounds like the sounds of a computer on a spaceship. There is no voice in this song. This song can be played in a movie featuring an alien spaceship. | 2010-09-30T09:34:59Z | nerdkits | This video goes over the design and ideas behind the NerdKits 2010 Halloween costume: the Human Theremin. The costume features two homebuilt infrared distance sensors mounted on the wrists. Someone wishing to "play" your costume can move his or her hands up and down above the distance sensors. One hand controls the pitch of the note, and the other controls the volume. The sound is emitted from a piezoelectric buzzer mounted on the breadboard, worn around the neck. For more information about this project, including source code and more detailed explanations, please visit: http://www.nerdkits.com/videos/theremin_with_ir_distance_sensor/ | ["Music", "Theremin"] | ["theremin song", "high pitch music", "no other instruments", "no percussion", "no voice", "instrumental", "quirky sound", "no melody"] | 0 | _dF-ZGquRNY | 3480 |
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;