musiccaps_details (view)
2 rows where musiccaps_aspects contains "no other instruments" and "youtube_published" is on date 2008-12-27
This data as json, CSV (advanced)
musiccaps_names (array) 10 ✖
musiccaps_aspects (array) 10 ✖
- instrumental 2
- no other instruments · 2 ✖
- no voices 2
- cello 1
- classical sonata 1
- electric guitar 1
- flanger effect 1
- harpsichord 1
- no percussion 1
- slow tempo 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
J. S. Bach Violin & Harpsichord Sonata in F minor, BWV 1018 | This classical sonata features a harpsichord playing a melody. This is accompanied by a cello playing the bass notes. There are no other instruments in this song. There is no voice in this song. This song can be played as a lullaby. | 2008-12-27T20:30:54Z | Elaine Comparone | Violinist Robert Zubrycki joins harpsichordist Elaine Comparone and cellist Peter Seidenberg (The Queen's Chamber Trio) for the first movement of Bach's F minor Sonata for Violin & Obbligato Harpsichord, BWV 1018. for more info: www.harpsichord.org; www.lyrichord.com. | ["Harpsichord", "Keyboard (musical)"] | ["classical sonata", "instrumental", "no voices", "harpsichord", "cello", "no percussion", "no other instruments", "slow tempo"] | 0 | OxxRnDpN9cc | 2485 | |
MXR Micro Flanger | This song features an electric guitar playing arpeggiated chords. The guitar is playing with a flanger effect added to change the tone. There are no other instruments in this song. There are no voices in this song. This is an instrumental song. This song can be used in an instructional video on an effects processor. | 2008-12-27T17:59:29Z | blondegraemey | Vintage MXR Micro Flanger with crumbling foam problem! Description and demonstration. | ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion", "Inside, small room"] | ["electric guitar", "flanger effect", "no other instruments", "no voices", "instrumental"] | 0 | wYtd_Sq2-Tw | 5274 |
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;