Healthleads Data Mapping

Overview

Healthleads data are provided in 11 .csv files. Files should be named as follows:

1. eligibility.csv
2. languages.csv
3. locations.csv
4. organizations.csv
5. phones.csv
6. physical_addresses.csv
7. required_documents.csv
8. services.csv
9. services_at_location.csv
10. services_taxonomy.csv
11. taxonomy.csv
12. metadata.csv

Data can be provided in .json files as well.

Eligibility

Healthleads field (type)	Example value	Mapped to (type)
eligibility (string)	Description of eligibility	eligibility (string)

Languages

Healthleads field (type)	Example value	Mapped to (type)
language (string)	English;Spanish	Each language separated by ';' is saved as distinct Language entity

Locations

Healthleads field (type)	Example value	Mapped to (type)
name (string)	Location Name	name (string)
alternate_name (string)	Loca	alternateName (string)
description (string)	Description of location	description (string)
transportation (string)	Transportation	transportation (string)
latitude (double)	37.23932	latitude (double)
longitude (double)	12.3242342	longitude (double)
x_schedule (string)	Monday - Friday: 8 am - 4 pm Saturday: 8 am - 3 pm Sunday: CLOSED Community Produce Program: 1st and 3rd Thursday of each month, 12pm-1 pm Food Assistance Program: 3rd Tuesday of each month, 10am-12pm 9 am- 5pm	ignored

Organizations

Healthleads field (type)	Example value	Mapped to (type)
name (string)	Organization Name	name (string)
alternate_name (string)	Org	alternateName (string)
email (string)	[email protected]	email (string)
url (string)	www.url.com	url (string)
description (string)	Description of organization	description (string)
tax_status (string)	Status	taxStatus (string)
tax_id (string)	tax-123	taxId (string)
year_incorporated (string)	2018-01-02	yearIncorporated (LocalDate)
legal_status (string)	Legal status	legalStatus (string)

Phones

Healthleads field (type)	Example value	Mapped to (type)
number (string)	(123)-123-2222	number (string)
extension (string)	123	extensions (Integer)
type (string)	Voice	type (string)
language (string)	English	language (string)
description (string)	Description of phone	description (string)

Physical Addresses

Healthleads field (type)	Example value	Mapped to (type)
attention (string)	Attention	attention (string)
address_1 (string)	Street 12	address1 (string)
city (string)	San Francisco	city (string)
region (string)	Region	region (string)
state_province (string)	California	stateProvince (string)
postal_code (string)	12345	postalCode (string)
country (string)	USA	country (string)

Required documents

Healthleads field (type)	Example value	Mapped to (type)
document (string)	Document	document (string)

Services

Healthleads field (type)	Example value	Mapped to (type)
name (string)	Service Name	name (string)
alternate_name (string)	Serv	alternateName (string)
email (string)	[email protected]	email (string)
url (string)	www.url.com	url (string)
description (string)	Description of service	description (string)
status (string)	Available	status (string)
interpretation_services (string)	Interpretation services	interpretationServices (string)
application_process (string)	Application process	applicationProcess (string)
wait_time (string)	One day	waitTime (string)
fees (string)	No fees	fees (string)
accreditations (string)	Accreditations	accreditations (string)
licenses (string)	Licenses	licenses (string)
x_target_population (string)	Target population	ignored

Services At Location

Healthleads field (type)	Example value	Mapped to (type)
description (string)	Description	description (string)

Services Taxonomy

Healthleads field (type)	Example value	Mapped to (type)
taxonomy_detail (string)	Taonomy detail	taxonomyDetails (string)

Taxonomy

Healthleads field (type)	Example value	Mapped to (type)
name (sring)	Taxonomy Name	name (string)
vocabulary (string)	Vocabulary	vocabulary (string)
parent_name (string)	Parent Name	ignored

Metadata

Healthleads field (type)	Example value	Mapped to (type)
resource_id (sring)	a0jA000000CFbUAAAA	resourceId (string)
last_action_date (string)	2019-05-05T00:11:02.000Z	lastActionDate (ZonedDateTime)
updated_by (string)	John Doe [email protected]	updatedBy (string)
sn_primary_source (string)	""	ignored
last_action_type (string)	Partial Update	lastActionType (ActionType)

Entitites relatonships

• Organization is related to Locaton (but it can be empty)
• Each Language is related to Service and Location
• Physical Address is related to Location
• Service is related to Organization
• Each Phone is related to Service and Location
• Service At Location is related to Serive and Location
• Taxonomy is not related to parent Taxonomy
• ServiceTaxonomy is related to Taxonomy and Service
• Eigibility is related to Service
• Required Document is related to Service