musiccaps_details (view)
3 rows where musiccaps_aspects contains "female singer", musiccaps_author = 7 and musiccaps_names contains "Christian music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 58 ✖
- female singer · 3 ✖
- medium tempo 3
- emotional 2
- acordion melody 1
- acoustic guitar 1
- acoustic guitar accompaniment 1
- auto harp 1
- bongos 1
- breakup 1
- breakup song 1
- celebratory 1
- cheerful 1
- choral backup 1
- christian gospel song 1
- christian music 1
- christian song 1
- classic latin songs 1
- congas 1
- country pop 1
- country song 1
- despondent 1
- devotional 1
- dobro 1
- earnest 1
- electric guitar 1
- fervent 1
- folk song 1
- foreign language 1
- groovy bass 1
- guiro 1
- happy 1
- harmonica 1
- hymns 1
- keyboard accompaniment 1
- latin folk songs 1
- latin music 1
- latin percussions 1
- lively 1
- lonely 1
- love song 1
- male backup 1
- mellow 1
- melodious tune 1
- muddled audio 1
- passionate 1
- praise and worship 1
- regional music 1
- resonator guitar 1
- sad song 1
- sentimental 1
- simple 1
- soft 1
- spanish music 1
- spirited 1
- steady bass line 1
- steady bass lines 1
- steady drumming 1
- world music 1
musiccaps_names (array) 8 ✖
- Christian music · 3 ✖
- Music 3
- Choir 1
- Christmas music 1
- Crowd 1
- Gospel music 1
- Rattle (instrument) 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Coro Gospel AGUAVIVA en Albacete 1 | A female vocalist sings this Gospel song. The tempo is medium with groovy bass lines, keyboard accompaniment, electric guitar and acoustic guitar rhythm,tambourine beats and choral harmony. The song is a spirited,emotional,fervent, earnest and devotional Christian Worship Song. | 2010-02-07T02:22:15Z | MakinGospel | Video Oficial producido por MAKINGOSPEL del concierto del Coro Gospel Aguaviva en Albacete el 21-03-09, primera parte. | ["Singing", "Gospel music", "Christian music", "Crowd", "Music", "Choir"] | ["female singer", "medium tempo", "electric guitar", "groovy bass", "keyboard accompaniment", "choral backup", "christian music", "christian song", "hymns", "christian gospel song", "devotional", "praise and worship", "fervent", "earnest", "passionate", "emotional", "acoustic guitar"] | 7 | 0oIFGARD9xE | 210 | |
~Good As I Was To You~ (With Lyrics) | A female singer sings this sad Country song. The tempo is medium with a Harmonica harmony, steady bass line, acoustic guitar, auto harp and dobro accompaniment. The song is soft, mellow, sad, poignant, emotional, sentimental and despondent with a melodious tune. This Song is a classic Country Pop. | 2008-09-22T07:04:10Z | VampiressSilvia | Lorrie Morgan's Good As I Was To You With the lyrics | ["Christian music", "Music"] | ["female singer", "medium tempo", "country song", "despondent", "melodious tune", "country pop", "regional music", "folk song", "love song", "sad song", "breakup song", "breakup", "harmonica", "steady drumming", "steady bass lines", "auto harp", "dobro", "resonator guitar", "mellow", "lonely", "soft", "sentimental", "emotional"] | 7 | tUJ_ZniLjhc | 5038 | |
LLEGO DICIEMBRE CON SU ALEGRIA | A female vocalist sings this classic Spanish song. The tempo is medium with a lively accordion harmony, guiro , congas and bongos rhythm, steady bass line, and acoustic guitar accompaniment. The music is simple, light, happy, joyful, cheerful, celebratory and spirited with vocal backup.There are sounds of people cheering in the background. This is a Classic Latin Folk Song. | 2012-12-02T02:33:13Z | max pardo | LLEGO DICIEMBRE | ["Christmas music", "Christian music", "Music", "Rattle (instrument)"] | ["female singer", "medium tempo", "cheerful", "happy", "spirited", "celebratory", "simple", "classic latin songs", "lively", "latin folk songs", "latin percussions", "latin music", "spanish music", "guiro", "acordion melody", "foreign language", "world music", "congas", "bongos", "acoustic guitar accompaniment", "steady bass line", "male backup", "muddled audio"] | 7 | wQN7fRaPl2A | 5264 |
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;