musiccaps_details (view)
2 rows where musiccaps_aspects contains "foreign language" and musiccaps_names contains "Ukulele"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- foreign language · 2 ✖
- mellow 2
- soft 2
- amateur guitarist 1
- amateur singing 1
- animated 1
- animated electronic sound 1
- bee buzzing 1
- children’s song 1
- christian worship 1
- emotional 1
- female vocalist 1
- four stringed instrument 1
- funny 1
- home recording 1
- instrumental 1
- lullaby 1
- male voice talking 1
- medium tempo 1
- muffled recording 1
- praise and worship 1
- sentimental 1
- sleepy 1
- slow tempo 1
- ukelele melody 1
- vocal harmony 1
musiccaps_names (array) 7 ✖
- Music 2
- Ukulele · 2 ✖
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Singing 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chikungunya | This music is a ukelele instrumental. The tempo is medium with the sound of a bee buzzing and an animated sound followed by a dialogue between two men in a foreign language. The music is mellow, soft and simple like it's meant for children. | 2014-10-04T21:51:37Z | Sancocho | Chinkungunya by Sancocho De los Creadores de "Ser Boricua Esta Brutal" Ahora les traemos Un tema exclusivo para internet Chinkungunya. Pronto Esperen el Disco Entero, pronto en Algun Momento y Despues las Presentaciones en Vivo, Creemos! WHAT!?! Composicion por Andre Caro y Osvaldo Friger con la Ayuda de Lejos de Dwella | ["Singing", "Guitar", "Music", "Musical instrument", "Ukulele", "Speech", "Plucked string instrument"] | ["instrumental", "medium tempo", "male voice talking", "soft", "mellow", "animated", "foreign language", "four stringed instrument", "bee buzzing", "ukelele melody", "animated electronic sound", "funny", "animated", "children’s song"] | 7 | I_wT76iYBdQ | 1920 | |
Still [Tagalog Version] | A female vocalist sings this emotional song. The tempo is slow with guitar accompaniment and vocal backup. The song is soft, mellow, emotional and sentimental in a foreign language that sounds like a lullaby.This is a Pop Folk song. | 2008-09-22T13:08:16Z | Carmina dela cruz | Eph 3:19, 20 Speak to one another with Psalms, hymns and spiritual songs. Sing and make music in your heart to the Lord. Always giving thanks to God and the Father for everything, in the name of our Lord Jesus Christ! ____________________________________________ sorry may konting sablay...but all honor and Glory to Jesus alone!! Words and music by Darlene Zchech [Hillsong] Tagalog Version by Richard bermudez and Carmina Dela cruz I do not own copyrights to translate these songs nor do I claim the melody as mine. I only translated them for my own enjoyment purposes. Thank You. | ["Music", "Ukulele"] | ["female vocalist", "slow tempo", "lullaby", "sleepy", "vocal harmony", "amateur guitarist", "amateur singing", "home recording", "muffled recording", "christian worship", "foreign language", "praise and worship", "soft", "mellow", "emotional", "sentimental"] | 7 | LEG7xkYOsWA | 2165 |
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;