Dorieh Data Platform
Contents
Introduction
What is Data Platform
Data Domains
Health
Health Data in Dorieh (Medicare and Medicaid)
Medicare: Building a Data Warehouse from ResDac Files
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
Medicaid: Building a Data Warehouse from ResDac Files
Querying Medicaid Data
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
Dorieh Tutorials
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 ResDac Health Data)
Medicare: Building a Data Warehouse from ResDac Files
Data dictionary and lineage for Medicare processing
Table Lineage Diagram
View medicare.ip
Column medicare.ip.drg_price_amt
Column medicare.ip.drg_price_amt Lineage SVG
View page source
Column medicare.ip.drg_price_amt Lineage SVG
medicare.ip.drg_price_amt
medicare.ip.drg_price_amt
The amount (called the 'DRG price' for
purposes of MEDPAR analysis) that would
have been paid if no deductibles,
coinsurance, primary payers, or outliers
were involved (rounded to whole
dollars).
cms.medpar_2011.DRGPRICE
cms.medpar_2011.DRGPRICE
Wld hv bn pd if no
dedctbls,coinsrnc,prmry payrs,otlrs were
invlvd ($)
cms.medpar_2011.DRGPRICE->medicare.ip.drg_price_amt
union
cms.medpar_2012.DRGPRICE
cms.medpar_2012.DRGPRICE
Wld hv bn pd if no
dedctbls,coinsrnc,prmry payrs,otlrs were
invlvd ($)
cms.medpar_2012.DRGPRICE->medicare.ip.drg_price_amt
union
cms.medpar_2013.DRGPRICE
cms.medpar_2013.DRGPRICE
Wld hv bn pd if no
dedctbls,coinsrnc,prmry payrs,otlrs were
invlvd ($)
cms.medpar_2013.DRGPRICE->medicare.ip.drg_price_amt
union
cms.medpar_2015.DRGPRICE
cms.medpar_2015.DRGPRICE
Wld hv bn pd if no
dedctbls,coinsrnc,prmry payrs,otlrs were
invlvd ($)
cms.medpar_2016.DRGPRICE
cms.medpar_2016.DRGPRICE
Wld hv bn pd if no
dedctbls,coinsrnc,prmry payrs,otlrs were
invlvd ($)
cms.medpar_2017.DRGPRICE
cms.medpar_2017.DRGPRICE
Wld hv bn pd if no
dedctbls,coinsrnc,prmry payrs,otlrs were
invlvd ($)
cms.medpar_2018.DRGPRICE
cms.medpar_2018.DRGPRICE
Wld hv bn pd if no
dedctbls,coinsrnc,prmry payrs,otlrs were
invlvd ($)
cms.medpar_2014.DRGPRICE
cms.medpar_2014.DRGPRICE
Wld hv bn pd if no
dedctbls,coinsrnc,prmry payrs,otlrs were
invlvd ($)
cms.medpar_2014.DRGPRICE->medicare.ip.drg_price_amt
union
cms.medpar_2015.DRGPRICE->medicare.ip.drg_price_amt
union
cms.medpar_2016.DRGPRICE->medicare.ip.drg_price_amt
union
cms.medpar_2017.DRGPRICE->medicare.ip.drg_price_amt
union
cms.medpar_2018.DRGPRICE->medicare.ip.drg_price_amt
union