musiccaps_details (view)
3 rows where musiccaps_names contains "Christian music" and musiccaps_names contains "Music of Asia" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- melodic singing 2
- acoustic drums 1
- acoustic guitar 1
- bass guitar 1
- bells 1
- cheerful 1
- christian 1
- christmas 1
- devotional 1
- electronic drums 1
- emotional 1
- female vocals 1
- festive 1
- gospel 1
- groovy bass 1
- male vocal 1
- mellow piano melody 1
- original pilipino music 1
- passionate 1
- passionate male vocal 1
- percussion 1
- punchy kick 1
- punchy snare 1
- religious 1
- remix 1
- shimmering hi hats 1
- soul 1
- strings 1
- wide sustained strings melody 1
- wide wooden percussions 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
MUSICA CRISTIANA Ayudame Señor Jose Felipe | This is a Christian gospel music piece. The male vocalist is singing melodically in the Spanish language. There is an acoustic guitar playing the main melody while a bass guitar plays in the background. In the rhythmic background, the acoustic drums are playing a calm beat. The atmosphere is religious. This music would suit well in Christian religious events in Spanish speaking countries. | 2009-08-18T23:55:02Z | YETSEL | ["Music of Asia", "Christian music", "Music", "Song"] | ["christian", "gospel", "male vocal", "melodic singing", "acoustic guitar", "bass guitar", "acoustic drums", "religious", "devotional"] | 9 | CdgQIiMdBa4 | 1387 | ||
opm christmas song (megamix) ft.dj klu - part 2 | This is the remix of an Original Pilipino Music (OPM) Christmas song. The female vocalist is singing melodically and in a festive manner. The melody is being played by a strings section while the rhythm consists of an electronic drum beat with heavy usage of percussive elements. The atmosphere is cheerful. This piece could be played at Christmas events in the Philippines. | 2009-09-11T06:15:35Z | edwell143 | wala lang trip lang to.ramdam ko kasi pasko na..advance merry christmas sa inyong lahat... | ["Christmas music", "Music of Asia", "Christian music", "Music"] | ["original pilipino music", "christmas", "remix", "female vocals", "melodic singing", "electronic drums", "percussion", "bells", "strings", "festive", "cheerful"] | 9 | lZavPVn7O4Q | 4409 | |
Chemong ding chu - Janglal Khongsai | The Soul song features a passionate male vocal singing over shimmering hi hats and shakers, groovy bass, widely spread wooden percussions, punchy kick and snare hits, wide sustained strings melody and mellow piano melody. It sounds emotional and passionate. | 2015-11-12T17:56:14Z | Bombiel Media | Senorita 3: Thadou-Kuki Visual Album M.Lien Thugs Production | ["Music of Asia", "Christian music", "Music", "Song"] | ["soul", "passionate male vocal", "wide wooden percussions", "punchy kick", "groovy bass", "wide sustained strings melody", "mellow piano melody", "shimmering hi hats", "punchy snare", "emotional", "passionate"] | 4 | BiQik0xsWxk | 1279 |
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;