Dorieh Data Platform
Contents
Introduction
What is Data Platform
Data Domains
Health
Handling Medicaid data
Medicare Files Handling
Data dictionary and lineage for Medicare processing
Table Lineage Diagram
Alphabetic list of all tables
Alphabetic list of all columns in all tables
The Data Dictionary Generation tool
Querying Medicaid Data
Overview of health data (Medicare and Medicaid)
Project Structure
Documentation Indices
Climate
Exposure (from Atmospheric Composition Analysis Group of Washington University in St. Louis)
Environmental Protection Agency (EPA) data
Demographics
Data Processing Pipelines
Python Packages
Data Modelling for Dorieh Data Platform
Examples
Data Platform Internals
Database Testing Framework
Adding more data
Executing containerized apps
Terms and Acronyms
Indices
Dorieh Data Platform
Data Domains
Dorieh CMS Package (manipulating with Health Data)
Medicare Files Handling
Data dictionary and lineage for Medicare processing
Table Lineage Diagram
View medicare.ps
Column medicare.ps.ssa3
Column medicare.ps.ssa3 Lineage SVG
View page source
Column medicare.ps.ssa3 Lineage SVG
medicare.ps.ssa3
medicare.ps.ssa3
Social Security Administration (SSA)
three digit code for county
cms.mbsf_ab_2011.CNTY_CD
cms.mbsf_ab_2011.CNTY_CD
County Code
cms.mbsf_ab_2011.CNTY_CD->medicare.ps.ssa3
union
cms.mbsf_ab_2012.CNTY_CD
cms.mbsf_ab_2012.CNTY_CD
County Code
cms.mbsf_ab_2012.CNTY_CD->medicare.ps.ssa3
union
cms.mbsf_ab_2013.CNTY_CD
cms.mbsf_ab_2013.CNTY_CD
County Code
cms.mbsf_ab_2013.CNTY_CD->medicare.ps.ssa3
union
cms.mbsf_abcd_2015.CNTY_CD
cms.mbsf_abcd_2015.CNTY_CD
SSA County Code
cms.mbsf_abcd_2016.CNTY_CD
cms.mbsf_abcd_2016.CNTY_CD
SSA County Code
cms.mbsf_abcd_2017.CNTY_CD
cms.mbsf_abcd_2017.CNTY_CD
SSA County Code
cms.mbsf_abcd_2018.CNTY_CD
cms.mbsf_abcd_2018.CNTY_CD
SSA County Code
cms.mbsf_ab_2014.CNTY_CD
cms.mbsf_ab_2014.CNTY_CD
County Code
cms.mbsf_ab_2014.CNTY_CD->medicare.ps.ssa3
union
cms.mbsf_abcd_2015.CNTY_CD->medicare.ps.ssa3
union
cms.mbsf_abcd_2016.CNTY_CD->medicare.ps.ssa3
union
cms.mbsf_abcd_2017.CNTY_CD->medicare.ps.ssa3
union
cms.mbsf_abcd_2018.CNTY_CD->medicare.ps.ssa3
union