musiccaps_details (view)

1 row where musiccaps_aspects contains "gospel", musiccaps_aspects contains "mono" and musiccaps_names contains "Singing"

✎ View and edit SQL

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

CSV options: 

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;