musiccaps_details (view)
3 rows where musiccaps_aspects contains "folk song", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "slow tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- folk song · 3 ✖
- instrumental · 3 ✖
- no voices 3
- slow tempo · 3 ✖
- no other instruments 2
- accordion 1
- clarinet 1
- fingerpicking 1
- guitar 1
- happy mood 1
- harp song 1
- low quality audio 1
- lute song 1
- no percussion 1
- stringed instrument 1
- trumpet 1
- tuba 1
musiccaps_names (array) 7 ✖
- Accordion 1
- Harp 1
- Music 1
- Musical instrument 1
- Pizzicato 1
- Plucked string instrument 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Scarborough Fair | This folk song features the melody played on a harp. The instrument plays the bass and treble notes of the song. There are no other instruments in this song. There is no voice in this song. This song can be played in a sad movie. | 2010-09-13T19:06:37Z | maplesquirrel | My version of Scarborough Fair. It was learned completely by ear, so unfortunately I cannot share sheet music for it. I hope you enjoy! | ["Harp", "Pizzicato"] | ["harp song", "no other instruments", "no voices", "instrumental", "slow tempo", "folk song"] | 0 | FiKY19GK6-8 | 1662 | |
Italian Pavan - (lute) | This instrumental song features a lute being played. This is played using fingerstyle. The song sounds like a folk song. There are no other instruments in this song. There are no voices in this song. This song can be played in a documentary scene with green hills at the backdrop. The mood of this song is happy. | 2007-05-18T05:28:11Z | luteplayer80 | A short but beautiful dance by Joanambrosio Dalza. Somebody asked more italian renaissance music, so... here it is!!! Hope you'll like it :)))))) | ["Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["lute song", "no percussion", "no other instruments", "no voices", "instrumental", "stringed instrument", "fingerpicking", "folk song", "slow tempo", "happy mood"] | 0 | K63Z_abB314 | 2057 | |
Salzburg Quintett - Oberkrainer Medley | This folk song features a clarinet playing the main melody. A trumpet plays a similar melody in harmony. This is accompanied by a tuba playing the bass notes. An acoustic guitar plays chords for this song. There are no voices in this song. This is an instrumental song. There is no percussion in this song. This song can be played at an Oktoberfest party. | 2009-01-31T20:58:16Z | Salzburg Quintett ursprünglich | Salzburg Quintett - Oberkrainer Medley, Festzelt in Inzing/Tirol 1984 | ["Accordion"] | ["low quality audio", "folk song", "guitar", "accordion", "tuba", "no voices", "instrumental", "slow tempo", "clarinet", "trumpet"] | 0 | qRgefptkDeo | 4786 |
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;