musiccaps_details (view)
3 rows where musiccaps_aspects contains "gospel" and musiccaps_aspects contains "keyboard"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- gospel · 3 ✖
- keyboard · 3 ✖
- religious 3
- male vocal 2
- melodic singing 2
- spiritual 2
- acoustic drums 1
- acoustic guitar 1
- acoustic sounding drums 1
- bass guitar 1
- christian 1
- christian music 1
- christian pop 1
- crowd cheering 1
- devotional 1
- electric guitar 1
- electronic drums 1
- emotional 1
- female vocal 1
- harp sound 1
- live performance 1
- male choir 1
- modern 1
- passionate singing 1
- telephone sound effect 1
- urban 1
musiccaps_names (array) 7 ✖
- Music 3
- Singing 2
- Busy signal 1
- Choir 1
- Gospel music 1
- Ska 1
- Song 1
youtube_published (date) 3 ✖
- 2008-12-27 1
- 2009-01-05 1
- 2014-03-08 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Yaweh(Official Video HD)- Ausward 2014 | This is a Christian gospel music piece. There is a male vocalist singing melodically and in an emotion-filled manner. The keyboard is playing the melody with a harp sound while the rhythmic background consists of a simple acoustic sounding drum beat that is only played on the hi-hats. The atmosphere is spiritual. This piece could be playing in the background at a Christian religious event. | 2014-03-08T09:11:01Z | Sfe Productions | Artist: Ausward Title: Yaweh Video by Bezariel Mwanza for Sound Factory Entertainment. For more information contact 0977751165 or 0966963340. | ["Singing", "Gospel music", "Music", "Song", "Choir"] | ["gospel", "christian music", "live performance", "crowd cheering", "male vocal", "melodic singing", "keyboard", "harp sound", "acoustic sounding drums", "religious", "spiritual", "emotional"] | 9 | AVogdV8khxc | 1128 | |
saray danez es mejor musica cristiana | This is a Christian pop piece. There is a telephone sound effect in the opening. There is a female vocalist singing melodically as the lead. The melody is being played on the acoustic guitar and the keyboard. The rhythm is provided by an electronic drum beat. There is a modern feel to this piece. It could be used in the background of social media content related to Christianity. | 2008-12-27T19:08:53Z | cristianoactur | ["Busy signal", "Music"] | ["christian pop", "gospel", "telephone sound effect", "female vocal", "melodic singing", "keyboard", "acoustic guitar", "electronic drums", "religious", "modern", "urban"] | 9 | hlquKjPgxmY | 4138 | ||
Keith Wonderboy Johnson "Time to Get Close to Jesus" {Official Video} | This is a Christian gospel music piece. There is a male vocalist singing passionately in the lead with a male choir that is at a relatively higher pitch than him singing in the back. The main melody is played by the keyboard and the electric guitar. There is a bass guitar that can be heard. The acoustic drums are playing an upbeat rhythm. The atmosphere is religious. This piece could be played at Christian religious events. | 2009-01-05T22:09:48Z | Daphanie Cassel | Official Video for the New Single, Time to Get Close to Jesus, from Keith Wonderboy Johnson & The Spiritual Voices. | ["Singing", "Music", "Ska"] | ["gospel", "christian", "male vocal", "passionate singing", "male choir", "keyboard", "electric guitar", "bass guitar", "acoustic drums", "religious", "spiritual", "devotional"] | 9 | xmSMAmnoRug | 5352 |
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;