musiccaps_details (view)
2 rows where musiccaps_aspects contains "instructive", musiccaps_aspects contains "no singer" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- instructive · 2 ✖
- no singer · 2 ✖
- bizarre 1
- eerie 1
- electric guitar 1
- high pitched sounds 1
- instrumental 1
- jam 1
- male voice 1
- mini theremin 1
- repeated notes 1
- tuning 1
- weird 1
musiccaps_names (array) 4 ✖
- Music 2
- Electronic tuner 1
- Speech 1
- Theremin 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
My Theremin Mini From Ebay! | This is an instrumental jam recording. There is a mini theremin being played at a high pitch. It is making vibrating and squeaking sounds. There is an instructive male voice speaking. There is an eerie feel to the sound. This recording could be sampled for use in beat-making. | 2009-08-01T23:22:16Z | CosmosTheMouse | Opening, construction, and explanation of a small "Theremin Mini" I bought on Ebay from Hong Kong. I'm pretty amused that it actually works as well as it does! One of these days I may have to buy a real life sized one. No disrespect to the person who sent it to me by the way. The poorly translated instructions are actually a blast to read. | ["Music", "Theremin", "Speech"] | ["jam", "no singer", "instrumental", "mini theremin", "high pitched sounds", "male voice", "instructive", "eerie", "bizarre", "weird"] | 9 | NeSIT6sqLRA | 2353 | |
D# (Eb) Standard Guitar Tuner (D# G# C# F# A# D# Tuning) | This is the recording of a tuning video in the key of D sharp. There is an electric guitar playing the note on each string repeatedly. This piece could be used to lift samples to be used in a beat or in the making of a virtual guitar plug-in. | 2012-10-28T18:23:31Z | Mykola MrHardGuitar - Guitar Reviews And Lessons | Free Online Chromatic Guitar Tuner using Microphone - http://hard-guitar.com/free-online-chromatic-guitar-tuner-using-microphone-how-to-tune-a-guitar/ This is Online Guitar Tuner D# (Eb) Standard Tuning (D# G# C# F# A# D#). D Sharp Tuning or E Flat Tuning | ["Music", "Electronic tuner"] | ["tuning", "instructive", "no singer", "electric guitar", "repeated notes"] | 9 | PvHKu1XRSJ0 | 2579 |
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;