musiccaps_details (view)
1 row where musiccaps_aspects contains "gospel", musiccaps_aspects contains "mono" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
our God he is alive Westside Church of Christ A Capella | The low quality recording features a gospel song that consists of harmonizing mixed choir singing. The recording is noisy, in mono and it sounds passionate, joyful, soulful and reverberant. | 2008-09-05T16:47:09Z | church0fchrist | This is the Westside Church of Christ singing Hymns of praise to Jesus Christ our savior. We are located at 1705 Starview Dr Salem, VA 24153 Our website http://www.westsidecofc-salem.com/ Speaking to one another in psalms and hymns and spiritual songs, singing and making melody in your heart to the Lord (Ephesians 5:19). Let the word of Christ dwell in you richly in all wisdom, teaching and admonishing one another in psalms and hymns and spiritual songs, singing with grace in your hearts to the Lord (Colossians 3:16). Why do some churches teach that it is wrong to use musical instruments to accompany our singing during Christian worship assemblies when the above verses don't precisely forbid it? I think most will agree that God has specifically instructed (even "commanded") Christians to sing as part of the worship that He expects (even "demands"). Since He has not commanded nor even suggested to us to play musical instruments in worship, we can be absolutely certain that if we don't use musical instruments, then He will be pleased with Christians singing if their worship comes from the heart. | ["Singing", "Gospel music", "Christian music", "Choir", "Vocal music", "A capella"] | ["low quality", "gospel", "harmonizing mixed choir", "reverberant", "noisy", "mono", "joyful", "passionate", "soulful"] | 4 | 9ziKfjHWqZ0 | 1054 |
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;