musiccaps_details (view)
3 rows where musiccaps_aspects contains "stringed instrument" and musiccaps_names contains "Harp"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- stringed instrument · 3 ✖
- celestial 2
- ethereal 2
- harp solo 2
- instrumental 2
- mellow 2
- minimalist 2
- slow tempo 2
- western classical 2
- amateur folk music 1
- ambient 1
- angel 1
- beautiful 1
- bow shaped harp 1
- calming 1
- cascading melody 1
- chordophone 1
- classical music 1
- clear 1
- dreamy 1
- enthralling 1
- euphonious 1
- flowing 1
- full sounding 1
- gentle 1
- harp 1
- harp melody 1
- low quality recording 1
- oldest instrument 1
- plucked string instrument 1
- plucking 1
- resonating 1
- rich 1
- shaker like percussion 1
- sharp sound 1
- soft 1
- soothing 1
- sound of the crowd 1
- sound of whistling 1
musiccaps_names (array) 6 ✖
- Harp · 3 ✖
- Pizzicato 2
- Classical music 1
- Music 1
- Musical instrument 1
- Plucked string instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Carla They - Concerto per sola Arpa (Ponti sul Mincio) | This music is instrumental. The tempo is slow with a euphonious harp melody with no accompaniment. The music is soft, mellow, ethereal, melancholic, nostalgic, pensive, soft and ambient. This music is a Western Classical. | 2012-09-26T18:14:50Z | Carla They | Pace e bellezza regnano a Ponti sul Mincio, comune di origini medievali. Tra i percorsi incantevoli e ritmi rilassanti, fanno il suo ingresso le musiche di "Carla They". La rassegna quest'anno si chiude con un importante concerto per sola arpa di un'artista d'eccezione: Carla They. La prestigiosa carriera dell'artista è testimoniata da varie esperienze in importanti teatri ed apparizioni televisive in Italia, Svizzera, Austria, Germania e Olanda. Il suo repertorio si muove tra celtico, folk e classico. Organizzazione riprese video e audio Tullio Mauro | ["Harp", "Music", "Musical instrument", "Plucked string instrument", "Classical music"] | ["instrumental", "slow tempo", "stringed instrument", "angel", "western classical", "harp solo", "harp melody", "ethereal", "soft", "mellow", "euphonious", "celestial", "enthralling", "minimalist", "plucking", "ambient"] | 7 | OiNlYrlJE4g | 2461 | |
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 | |
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 |
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;