Community Platform DC/DC Tutoring & Mentoring Initiative Our Logo

Congregational Support for Nonprofits

Tracks support by congregations in volunteers, donations, use of space, etc. to operating nonprofit organizations.
idOrg nameCongregation nameVol supportFin support
1 ()HOLY TRINITY LUTHERAN CHURCH (LEESBURG)Yes - regularlyNo
12ABUNDANT ACTIONS FOR CHILDREN YOUTH AND FAMILIES (ARLINGTON) ()YesNo
7 ()Christ Lutheran Church (Washington)Yes
9 ()Faith Lutheran Church (Arlington)Yes - regularlyYes
10 ()Epiphany Lutheran Church (Burtonsville)Yes - regularlyYes - intermittently
Elapsed time: 08:13:49 - fin: 08:13:58

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'))