In OHDSI/ETL-Synthea: A Builder for Converting the Synthea Data to the OMOP CDM

Person

Reading from Synthea table patients.csv

| Destination Field | Source field | Logic | Comment field | | --- | --- | --- | --- | | person_id | | Autogenerated | | | gender_concept_id | gender | When gender = ‘M’ then set gender_concept_id to 8507, when gender = ‘F’ then set to 8532 | Drop any rows with missing/unknown gender. | | year_of_birth | birthdate | Take year from birthdate | | | month_of_birth | birthdate | Take month from birthdate | | | day_of_birth | birthdate | Take day from birthdate | | | birth_datetime | birthdate | With midnight as time 00:00:00 | | | death_datetime | deathdate | With midnight as time 00:00:00 | | | race_concept_id | race | When race = ‘WHITE’ then set as 8527, when race = ‘BLACK’ then set as 8516, when race = ‘ASIAN’ then set as 8515, otherwise set as 0 | | | ethnicity_concept_id | race ethnicity | When race = ‘HISPANIC’ then set as 38003563, otherwise set as 0 When race = ‘HISPANIC’ then set as 38003563, otherwise set as 0 | | | location_id | | Set as null for all records | | | provider_id | | Set as null for all records | | | care_site_id | | Set as null for all records | | | person_source_value | id | | | | gender_source_value | gender | | | | gender_source_concept_id | | Set as 0 for all records | | | race_source_value | race | | | | race_source_concept_id | | Set as 0 for all records | | | ethnicity_source_value | ethnicity | | | | ethnicity_source_concept_id | |Set as 0 for all records | |

OHDSI/ETL-Synthea documentation built on Feb. 24, 2025, 3:48 a.m.