IRS provides resources data with NTEE code. However we are interested in only a few types of the codes, so we need a single program which can extract data for each code from IRS data located here:
We need to put each resource under supported categories
ServiceType Service Sub-Type
FOOD Food Pantry, Soup Kitchen
SHELTER Transitional Shelter, Transitional Housing, Emergency Shelter
HEALTH Medical Clinic, Mental Health Services
RESOURCES Miscellaneous Services, Support Services, Legal Assistance, Senior Resources
WORK
Zipcode should be 5 digits only.
Add Sources column to each entry indicating where this data was obtained
e.g Sources - IRS, HUD etc.
Each category will be in a separate temp table of its own. Which later can be merged into master (service collection) either manually or
IRS provides resources data with NTEE code. However we are interested in only a few types of the codes, so we need a single program which can extract data for each code from IRS data located here:
IRS publishes new data regularly here: https://www.irs.gov/charities-non-profits/exempt-organizations-business-master-file-extract-eo-bmf
So check this page every 2 months, make a note when we checked it last,
Files downloaded from June 11, 2020 are here. https://drive.google.com/drive/folders/1_zp0B49BN5MMTfOcWg4HHrcnLpSwqGuM
We need only following NTEE codes. NTEE Codes with serviceSummary E21 Community Health Systems (Medical Clinic) E30 Health Treatment Facilities, Primarily Outpatient (Medical Clinic) E32 Ambulatory Health Center, Community Clinic (Medical Clinic) E50 Rehabilitative Medical Services (Medical Clinic) E60 Health Support Services (Medical Clinic) F32 Community Mental Health Center (Mental Health Services) F40 HotLine, Crisis Intervention Services (Mental Health Services) F42 Rape Victim Services (Support Services) F60 Counseling, Support Groups (Mental Health Services) F99 Mental Health, Crisis Intervention N.E.C. (Mental Health Services) I80 Legal Services (Legal Assistance) K30 Food Service, Free Food Distribution Programs(Food Pantry) K31 Food Banks, Food Pantries (Food Pantry) K34 Congregate Meals (Soup Kitchen) K36 Meals on Wheels (Soup Kitchen) L30 Housing Search Assistance (Transitional Housing) L40 Low-Cost Temporary Housing (Transitional Housing) L41 Homeless, Temporary Shelter For ( Emergency Shelter) L80 Housing Support Services -- Other (Support Services) L99 Housing, Shelter N.E.C. ( Emergency Shelter) P24 Salvation Army (Support Services) P26 Volunteers of America (Support Services) P43 Family Violence Shelters, Services ( Emergency Shelter) P52 Transportation, Free or Subsidized (Support Services) P60 Emergency Assistance (Support Services) P72 Half-Way House (Support Services) P81 Senior Centers, Services (Senior Resources) P82 Developmentally Disabled Centers, Services (Disabled Resources) P85 Homeless Persons Centers, Services (Support Services) P86 Blind/Visually Impaired Centers, Services (Disabled Resources) P87 Deaf/Hearing Impaired Centers, Services (Disabled Resources)
Details of the logic :
e.g. K31 we might have subcodes like K31-E or P24B so we need all of those hence apply filter like
*Also we need to neglect military mailing locations AA, AE, AP
We already have data from specific counties so we can ignore zip codes from following counties
We need to put each resource under supported categories ServiceType Service Sub-Type FOOD Food Pantry, Soup Kitchen SHELTER Transitional Shelter, Transitional Housing, Emergency Shelter HEALTH Medical Clinic, Mental Health Services RESOURCES Miscellaneous Services, Support Services, Legal Assistance, Senior Resources WORK
Zipcode should be 5 digits only.
Add Sources column to each entry indicating where this data was obtained e.g Sources - IRS, HUD etc.
Each category will be in a separate temp table of its own. Which later can be merged into master (service collection) either manually or