musiccaps_details (view)
2 rows where musiccaps_aspects contains "stringed instrument" and musiccaps_names contains "Pizzicato" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- stringed instrument · 2 ✖
- amateur folk music 1
- beautiful 1
- bow shaped harp 1
- calming 1
- cascading melody 1
- celestial 1
- chordophone 1
- classical music 1
- clear 1
- dreamy 1
- ethereal 1
- flowing 1
- full sounding 1
- gentle 1
- harp 1
- harp solo 1
- instrumental 1
- low quality recording 1
- mellow 1
- minimalist 1
- oldest instrument 1
- plucked string instrument 1
- resonating 1
- rich 1
- shaker like percussion 1
- sharp sound 1
- slow tempo 1
- soothing 1
- sound of the crowd 1
- sound of whistling 1
- western classical 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
FIESTA EN POQUE HUANUCO HUAMALIES CON EDWIN JARA | This amateur folk song features a stringed instrument being played by plucking the strings. This is accompanied by a percussion that sounds like a shaker. This is a low quality recording and the sound of whistling can be heard in the background. There are no voices in the song. This song can be played in a movie featuring a visit to a village. | 2015-10-21T17:32:29Z | Alejandro francisco roque | MARYORDOMO FM MOISES FRANCISCO . EUTEMIA MORALES | ["Harp", "Pizzicato"] | ["amateur folk music", "stringed instrument", "shaker like percussion", "low quality recording", "sound of whistling", "sound of the crowd"] | 0 | pS1X6Au1EAU | 4710 | |
Bach Prelude and Fugue BWV 539 | This music is a beautiful Harp instrumental. The tempo is slow with a mellow, gentle and rich Harp melody. The music is dreamy, cascading, ethereal, soothing, calming and harmonic. This music is a Western Classical Harp Solo. | 2011-01-08T20:54:38Z | cbembia | Caroline Bembia playing Bach's Prelude and Fugue in d minor, transcribed for harp | ["Harp", "Pizzicato"] | ["instrumental", "slow tempo", "harp", "gentle", "mellow", "soothing", "harp solo", "minimalist", "celestial", "ethereal", "beautiful", "calming", "stringed instrument", "plucked string instrument", "classical music", "western classical", "bow shaped harp", "chordophone", "oldest instrument", "full sounding", "clear", "flowing", "dreamy", "resonating", "sharp sound", "cascading melody", "rich"] | 7 | POOu05eUvqE | 2531 |
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;