musiccaps_details (view)
2 rows where musiccaps_aspects contains "mellow harp melody" and musiccaps_aspects contains "passionate" sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- low quality 2
- mellow harp melody · 2 ✖
- passionate · 2 ✖
- car rev sound 1
- cover 1
- emotional 1
- flamenco acoustic guitar melody 1
- harmonizing female vocals 1
- hypnotic 1
- mystical 1
- noisy 1
- raw 1
- regional mexican 1
- soft 1
video ▼ | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Walls of Time live bluegrass w/ celtic harp Maeve Gilchrist | The low quality recording features a mellow harp melody that sounds mystical, soft, hypnotic and passionate. | 2007-07-15T17:53:41Z | wherzmymule | Vintage Maeve Gilchrist on celtic harp and vocals w/ a talented young bluegrass/newgrass band. Boston, May 5, 2004. Fresh interpretation of "Walls of Time" (Bill Monroe). Small room, nice vibe. (No video of this concert - Sorry!) To learn more about this splendid artist, see: http://www.maevegilchristmusic.com/ | ["Harp", "Pizzicato"] | ["mellow harp melody", "mystical", "low quality", "soft", "hypnotic", "passionate"] | 4 | Xsvi5Mgl3qo | 3232 | |
Las Morenitas - La Despedida (Tonada con arpa) | The low quality recording features a cover of a regional Mexican song and it consists of harmonizing female vocals singing over a mellow harp melody and flamenco acoustic guitar melody. It sounds raw, emotional and passionate. The recording is a bit noisy and there are some car rev noises in the background. | 2013-01-28T22:29:18Z | LasMorenitas Cantoras | Tonada chilena "La despedida" interpretada por Chabelita Fuentes (arpa), Fani Flores (tormento) y Mili Ramirez (guitarra), y que juntas conforman la agrupación de cantoras "Las Morenitas", de San Vicente de Tagua Tagua. Tonada compuesta por Ana Flores Espínola, integrante de Las del Puerto, de la región de Valparaíso. Registro realizado por Diego Barrera el 16 de enero en la comuna en San Vicente de Tagua-Tagua, Región de O'higgins, Chile. Mas información y contactos: Correos: lasmorenitascantoras@gmail.com, dbarrerab@gmail.com Blog: http://lasmorenitascantoras.blogspot.com/ Mas musica en: https://soundcloud.com/las-morenitas-cantoras | ["Harp", "Pizzicato"] | ["low quality", "noisy", "car rev sound", "mellow harp melody", "harmonizing female vocals", "flamenco acoustic guitar melody", "passionate", "raw", "emotional", "cover", "regional mexican"] | 4 | mQ1E8rx2dnI | 4469 |
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;