musiccaps_details (view)
2 rows where musiccaps_aspects contains "accordion song" and musiccaps_aspects contains "no percussion" sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- accordion song · 2 ✖
- no percussion · 2 ✖
- easy listening 1
- female voice 1
- foreign language 1
- instrumental 1
- marimba song 1
- minimal instruments 1
- moderate tempo 1
- no voices 1
- pop song 1
- relaxing music 1
- romantic theme 1
- waltz song 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
Valses Mexicanos (Popurrí) - Marimba de Nandayapa | This song is an instrumental song. There are no voices. An accordion plays in a waltz beat. The main melody starts off later when a marimba plays high pitched notes. Other accordions join and play in harmony in the background. There is no percussion in this song. The mood of this song is happy and upbeat. This song can be used in a retro scene of a movie involving a happy couple. | 2010-05-25T07:24:20Z | ogtotes | Considerado como el soundtrack del porfirísmo, el vals es traído a México por los franceses en una de sus intervenciones, y obtuvo características nacionales conforme se adentraba en el gusto popular, como la cadencia. Es de notar que los compositores que más lo desarrollaron fueron del interior del país, aunque fue ejecutado en mayor cantidad para la sociedad metropolitana. El presente video contiene imágenes de Chiapa de Corzo, Chiapas., localidad que sirve de cuna a Zeferino Nandayapa y su marimba, ejecutor de éste popurrí de valses mexicanos. 1- Alejandra 2- Viva mi desgracia 3- Rival 4- Maria Elena 5- Morir por tu amor 6- Cuando escuches este vals 7- Recuerdo 8- Club verde | ["Music", "Vibraphone"] | ["marimba song", "accordion song", "waltz song", "no percussion", "easy listening", "relaxing music", "no voices", "instrumental"] | 0 | KlVO3gu-j70 | 2116 | |
New-Age Korean traditional music group IS - MBC drama, HyangDanJeon | This pop song features a female voice singing the main melody in a foreign language. This is accompanied by an accordion playing a harmonized melody in the background. There is no percussion in this song. Minimal instruments are used in this song. The theme of this song feels romantic. | 2010-05-19T12:42:41Z | InfinityofSound | MBC drama, HyangDanJeon | ["New-age music", "Music", "Music of Bollywood"] | ["pop song", "romantic theme", "female voice", "foreign language", "accordion song", "moderate tempo", "no percussion", "minimal instruments"] | 0 | aJHv6TV7JpY | 3528 |
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;