Congregational Support for Nonprofits
Tracks support by congregations in volunteers, donations, use of space, etc. to operating nonprofit organizations.id | Org name | Congregation name | Vol support | Fin support |
---|---|---|---|---|
1 | () | HOLY TRINITY LUTHERAN CHURCH (LEESBURG) | Yes - regularly | No |
12 | ABUNDANT ACTIONS FOR CHILDREN YOUTH AND FAMILIES (ARLINGTON) | () | Yes | No |
7 | () | Christ Lutheran Church (Washington) | Yes | |
9 | () | Faith Lutheran Church (Arlington) | Yes - regularly | Yes |
10 | () | Epiphany Lutheran Church (Burtonsville) | Yes - regularly | Yes - intermittently |
SELECT j.id, if( length(regOrgs.name) > 0, CONCAT_WS('', regOrgs.name, ' (', regOrgs.city, ')'), CONCAT_WS('', unregOrgs.name, ' (', unregOrgs.city, ')') ) as Org_name, if( length(regCongs.name) > 0, concat_ws('', regCongs.name,' (', regCongs.city, ')'), concat_ws('', unregCongs.name, ' (', unregCongs.city,')' ) ) as Congregation_name, volunteerSupport as Vol_support, financialSupport as Fin_support FROM platform.congregationOrganizationJoin j LEFT JOIN nccs.nteedocAllEins regOrgs ON j.orgEin > ' ' and j.orgEin = regOrgs.ein LEFT JOIN nccs.nteedocNoEin unregOrgs ON j.orgId > 0 and j.orgId = unregOrgs.id LEFT JOIN nccs.nteedocAllEins regCongs ON j.congregationEin > ' ' and j.congregationEin = regCongs.ein LEFT JOIN nccs.nteedocNoEin unregCongs ON j.congregationId > 0 and j.congregationId = unregCongs.id where (regOrgs.state in ('DC','MD','VA') OR unregOrgs.state in ('DC','MD','VA') OR regCongs.state in ('DC','MD','VA') OR unregCongs.state in ('DC','MD','VA'))