search

OHDSI / ETL-CMS

Workproducts to ETL CMS datasets into OMOP Common Data Model
Apache License 2.0
94 stars 52 forks source link

columns mismatched in location table #31

Closed rstarr7 closed 7 years ago

rstarr7 commented 7 years ago

In the location csv file, the data for the zip_code is in the county column position. The zip code column position is null.

for example,

location_id,address_1,address_2,city,state,zip,county,location_source_value 1,,,,MO,,269500,26-95 2,,,,PA,,39230,39-230

ChristopheLambert commented 7 years ago

There are no zip codes in the data. The 5-digit codes are SSA county codes, where the first 2 digits are the state, and the next 3 digits are the county number.

rstarr7 commented 7 years ago

That's great. Thanks.

I was trying to decide whether to mention the fact that the zips and the states did not match up!

Richard Starr Institute for People and Technology (IPaT) at Georgia Tech (404) 491-1438 richard.starr@gatech.edumailto:richard.starr@gatech.edu

From: Christophe Lambert Reply-To: OHDSI/ETL-CMS Date: Monday, September 26, 2016 at 5:23 PM To: OHDSI/ETL-CMS Cc: Richard Starr, Author Subject: Re: [OHDSI/ETL-CMS] columns mismatched in location table (#31)

There are no zip codes in the data. The 5-digit codes are SSA county codes, where the first 2 digits are the state, and the next 3 digits are the county number.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/OHDSI/ETL-CMS/issues/31#issuecomment-249701671, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AQaF2aXRIcJeRfFKnxyStvrrFJoPm8txks5quDe9gaJpZM4KG9pq.