musiccaps_details (view)
2 rows where musiccaps_aspects contains "mellow harp melody", musiccaps_aspects contains "noisy", musiccaps_names contains "Harp" and musiccaps_names contains "Pizzicato"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mika Agematsu - Natsunoomoide.flv | The low quality recording features a mellow harp melody. The recording is noisy, in mono and it sounds soft and mellow. | 2011-05-29T19:19:13Z | Jorge Mars | Sublime interpretación de esta melodía, por un ángel que llego a Japón desde el cielo. | ["Harp", "Pizzicato"] | ["low quality", "noisy", "mono", "mellow harp melody", "soft", "mellow"] | 4 | IOEwc-N2rX4 | 1902 | |
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;