Comments (3)
While the original data provided identifiers for both the provider and provider institution, there does not appear to be any location information for either in the source data. Hence null is placed for the location of care_site to signify it is not known.
Patients, on the other hand, do have location information down to state and FIPS county code. One might try to take the most frequent residence state for patient visits to a given care_site to infer a good guess of its location, assuming there is some consistency in the identifiers versus some kind of randomization or blinding being done in the synthetic transformation process that created these pseudo-patients. For instance, there are fields for the "Provider Institution Tax Number", within the Carrier Claims records, but there are way more of these than number of healthcare institutions in the US, suggesting they are random numbers.
from etl-cms.
Closing out issue, as it appears to be a limitation on the source data.
from etl-cms.
Thanks @ChristopheLambert !
from etl-cms.
Related Issues (20)
- Column mismatch in create_CDMv5_tables.sql and load_CDMv5_vocabulary.sql HOT 1
- Error on Step 5 of Python ETL process HOT 2
- Person ID as integer, CMS's synthetic data has string IDs HOT 1
- CMS RIF to OMOP ETL? HOT 2
- CMS ACO CCLF --> OMOP V5 HOT 1
- md5 sums don't match files - https://github.com/OHDSI/ETL-CMS/blob/master/python_etl/README.md HOT 4
- Issue while running python code to get the claims data HOT 6
- Memory issue of steps 5 in ETL Script HOT 9
- drug_era, observation_period, cost column mismatch HOT 5
- Update ETL logic to support CDM 6.X HOT 5
- CDMv5.2 is not accessible HOT 2
- KeyError: 'Place of Service' HOT 3
- missing 'DE1_0_2010_Beneficiary_Summary_File_Sample_1.zip' HOT 5
- FTP server down? HOT 1
- Downloading final data HOT 1
- Incorrect URL to one source Synpuf file HOT 5
- Updating to newer CDM versions + upload R script available HOT 1
- key error '40213148'
- Convert CMS SynPUF to OMOP v5.4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from etl-cms.