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
Materialized view medicare.mbsf_d
Column medicare.mbsf_d.dual_indicators
Column medicare.mbsf_d.dual_indicators Lineage SVG
View page source
Column medicare.mbsf_d.dual_indicators Lineage SVG
medicare.mbsf_d.dual_indicators
medicare.mbsf_d.dual_indicators
cms.mbsf_abcd_2015.DUAL_08
cms.mbsf_abcd_2015.DUAL_08
State Reported Dual Eligible Status
Code: August
cms.mbsf_abcd_2015.DUAL_08->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2016.DUAL_08
cms.mbsf_abcd_2016.DUAL_08
State Reported Dual Eligible Status
Code: August
cms.mbsf_abcd_2016.DUAL_08->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2017.DUAL_08
cms.mbsf_abcd_2017.DUAL_08
State Reported Dual Eligible Status
Code: August
cms.mbsf_abcd_2017.DUAL_08->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2018.DUAL_08
cms.mbsf_abcd_2018.DUAL_08
State Reported Dual Eligible Status
Code: August
cms.mbsf_abcd_2018.DUAL_08->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2011.DUAL_08
cms.mbsf_d_2011.DUAL_08
Aug. Dual Status Code
cms.mbsf_d_2011.DUAL_08->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2012.DUAL_08
cms.mbsf_d_2012.DUAL_08
Aug. Dual Status Code
cms.mbsf_d_2012.DUAL_08->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2017.DUAL_06
cms.mbsf_abcd_2017.DUAL_06
State Reported Dual Eligible Status
Code: June
cms.mbsf_abcd_2018.DUAL_06
cms.mbsf_abcd_2018.DUAL_06
State Reported Dual Eligible Status
Code: June
cms.mbsf_d_2011.DUAL_06
cms.mbsf_d_2011.DUAL_06
Jun. Dual Status Code
cms.mbsf_d_2012.DUAL_06
cms.mbsf_d_2012.DUAL_06
Jun. Dual Status Code
cms.mbsf_d_2013.DUAL_06
cms.mbsf_d_2013.DUAL_06
Jun. Dual Status Code
cms.mbsf_d_2014.DUAL_06
cms.mbsf_d_2014.DUAL_06
Jun. Dual Status Code
cms.mbsf_abcd_2015.DUAL_11
cms.mbsf_abcd_2015.DUAL_11
State Reported Dual Eligible Status
Code: November
cms.mbsf_abcd_2016.DUAL_11
cms.mbsf_abcd_2016.DUAL_11
State Reported Dual Eligible Status
Code: November
cms.mbsf_abcd_2017.DUAL_11
cms.mbsf_abcd_2017.DUAL_11
State Reported Dual Eligible Status
Code: November
cms.mbsf_abcd_2018.DUAL_11
cms.mbsf_abcd_2018.DUAL_11
State Reported Dual Eligible Status
Code: November
cms.mbsf_d_2013.DUAL_08
cms.mbsf_d_2013.DUAL_08
Aug. Dual Status Code
cms.mbsf_d_2013.DUAL_08->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2014.DUAL_08
cms.mbsf_d_2014.DUAL_08
Aug. Dual Status Code
cms.mbsf_d_2014.DUAL_08->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2015.DUAL_06
cms.mbsf_abcd_2015.DUAL_06
State Reported Dual Eligible Status
Code: June
cms.mbsf_abcd_2015.DUAL_06->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2016.DUAL_06
cms.mbsf_abcd_2016.DUAL_06
State Reported Dual Eligible Status
Code: June
cms.mbsf_abcd_2016.DUAL_06->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2017.DUAL_06->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2018.DUAL_06->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2011.DUAL_06->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2012.DUAL_06->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2013.DUAL_06->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2014.DUAL_06->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2011.DUAL_11
cms.mbsf_d_2011.DUAL_11
Nov. Dual Status Code
cms.mbsf_d_2012.DUAL_11
cms.mbsf_d_2012.DUAL_11
Nov. Dual Status Code
cms.mbsf_d_2013.DUAL_11
cms.mbsf_d_2013.DUAL_11
Nov. Dual Status Code
cms.mbsf_d_2014.DUAL_11
cms.mbsf_d_2014.DUAL_11
Nov. Dual Status Code
cms.mbsf_abcd_2015.DUAL_07
cms.mbsf_abcd_2015.DUAL_07
State Reported Dual Eligible Status
Code: July
cms.mbsf_abcd_2016.DUAL_07
cms.mbsf_abcd_2016.DUAL_07
State Reported Dual Eligible Status
Code: July
cms.mbsf_abcd_2017.DUAL_07
cms.mbsf_abcd_2017.DUAL_07
State Reported Dual Eligible Status
Code: July
cms.mbsf_abcd_2018.DUAL_07
cms.mbsf_abcd_2018.DUAL_07
State Reported Dual Eligible Status
Code: July
cms.mbsf_d_2011.DUAL_07
cms.mbsf_d_2011.DUAL_07
Jul. Dual Status Code
cms.mbsf_d_2012.DUAL_07
cms.mbsf_d_2012.DUAL_07
Jul. Dual Status Code
cms.mbsf_abcd_2015.DUAL_11->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2016.DUAL_11->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2017.DUAL_11->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2018.DUAL_11->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2011.DUAL_11->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2012.DUAL_11->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2013.DUAL_11->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2014.DUAL_11->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2015.DUAL_07->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2016.DUAL_07->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2013.DUAL_07
cms.mbsf_d_2013.DUAL_07
Jul. Dual Status Code
cms.mbsf_d_2014.DUAL_07
cms.mbsf_d_2014.DUAL_07
Jul. Dual Status Code
cms.mbsf_abcd_2015.DUAL_05
cms.mbsf_abcd_2015.DUAL_05
State Reported Dual Eligible Status
Code: May
cms.mbsf_abcd_2016.DUAL_05
cms.mbsf_abcd_2016.DUAL_05
State Reported Dual Eligible Status
Code: May
cms.mbsf_abcd_2017.DUAL_05
cms.mbsf_abcd_2017.DUAL_05
State Reported Dual Eligible Status
Code: May
cms.mbsf_abcd_2018.DUAL_05
cms.mbsf_abcd_2018.DUAL_05
State Reported Dual Eligible Status
Code: May
cms.mbsf_d_2011.DUAL_05
cms.mbsf_d_2011.DUAL_05
May Dual Status Code
cms.mbsf_d_2012.DUAL_05
cms.mbsf_d_2012.DUAL_05
May Dual Status Code
cms.mbsf_d_2013.DUAL_05
cms.mbsf_d_2013.DUAL_05
May Dual Status Code
cms.mbsf_d_2014.DUAL_05
cms.mbsf_d_2014.DUAL_05
May Dual Status Code
cms.mbsf_abcd_2017.DUAL_07->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2018.DUAL_07->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2011.DUAL_07->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2012.DUAL_07->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2013.DUAL_07->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2014.DUAL_07->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2015.DUAL_05->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2016.DUAL_05->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2017.DUAL_05->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2018.DUAL_05->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2015.DUAL_10
cms.mbsf_abcd_2015.DUAL_10
State Reported Dual Eligible Status
Code: October
cms.mbsf_abcd_2016.DUAL_10
cms.mbsf_abcd_2016.DUAL_10
State Reported Dual Eligible Status
Code: October
cms.mbsf_abcd_2017.DUAL_10
cms.mbsf_abcd_2017.DUAL_10
State Reported Dual Eligible Status
Code: October
cms.mbsf_abcd_2018.DUAL_10
cms.mbsf_abcd_2018.DUAL_10
State Reported Dual Eligible Status
Code: October
cms.mbsf_d_2011.DUAL_10
cms.mbsf_d_2011.DUAL_10
Oct. Dual Status Code
cms.mbsf_d_2012.DUAL_10
cms.mbsf_d_2012.DUAL_10
Oct. Dual Status Code
cms.mbsf_d_2013.DUAL_10
cms.mbsf_d_2013.DUAL_10
Oct. Dual Status Code
cms.mbsf_d_2014.DUAL_10
cms.mbsf_d_2014.DUAL_10
Oct. Dual Status Code
cms.mbsf_abcd_2015.DUAL_12
cms.mbsf_abcd_2015.DUAL_12
State Reported Dual Eligible Status
Code: December
cms.mbsf_abcd_2016.DUAL_12
cms.mbsf_abcd_2016.DUAL_12
State Reported Dual Eligible Status
Code: December
cms.mbsf_d_2011.DUAL_05->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2012.DUAL_05->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2013.DUAL_05->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2014.DUAL_05->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2015.DUAL_10->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2016.DUAL_10->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2017.DUAL_10->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2018.DUAL_10->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2011.DUAL_10->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2012.DUAL_10->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2017.DUAL_12
cms.mbsf_abcd_2017.DUAL_12
State Reported Dual Eligible Status
Code: December
cms.mbsf_abcd_2018.DUAL_12
cms.mbsf_abcd_2018.DUAL_12
State Reported Dual Eligible Status
Code: December
cms.mbsf_d_2011.DUAL_12
cms.mbsf_d_2011.DUAL_12
Dec. Dual Status Code
cms.mbsf_d_2012.DUAL_12
cms.mbsf_d_2012.DUAL_12
Dec. Dual Status Code
cms.mbsf_d_2013.DUAL_12
cms.mbsf_d_2013.DUAL_12
Dec. Dual Status Code
cms.mbsf_d_2014.DUAL_12
cms.mbsf_d_2014.DUAL_12
Dec. Dual Status Code
cms.mbsf_abcd_2015.DUAL_09
cms.mbsf_abcd_2015.DUAL_09
State Reported Dual Eligible Status
Code: September
cms.mbsf_abcd_2016.DUAL_09
cms.mbsf_abcd_2016.DUAL_09
State Reported Dual Eligible Status
Code: September
cms.mbsf_abcd_2017.DUAL_09
cms.mbsf_abcd_2017.DUAL_09
State Reported Dual Eligible Status
Code: September
cms.mbsf_abcd_2018.DUAL_09
cms.mbsf_abcd_2018.DUAL_09
State Reported Dual Eligible Status
Code: September
cms.mbsf_d_2013.DUAL_10->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2014.DUAL_10->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2015.DUAL_12->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2016.DUAL_12->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2017.DUAL_12->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2018.DUAL_12->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2011.DUAL_12->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2012.DUAL_12->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2013.DUAL_12->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2014.DUAL_12->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2011.DUAL_09
cms.mbsf_d_2011.DUAL_09
Sep. Dual Status Code
cms.mbsf_d_2012.DUAL_09
cms.mbsf_d_2012.DUAL_09
Sep. Dual Status Code
cms.mbsf_d_2013.DUAL_09
cms.mbsf_d_2013.DUAL_09
Sep. Dual Status Code
cms.mbsf_d_2014.DUAL_09
cms.mbsf_d_2014.DUAL_09
Sep. Dual Status Code
cms.mbsf_abcd_2015.DUAL_01
cms.mbsf_abcd_2015.DUAL_01
State Reported Dual Eligible Status
Code: January
cms.mbsf_abcd_2016.DUAL_01
cms.mbsf_abcd_2016.DUAL_01
State Reported Dual Eligible Status
Code: January
cms.mbsf_abcd_2017.DUAL_01
cms.mbsf_abcd_2017.DUAL_01
State Reported Dual Eligible Status
Code: January
cms.mbsf_abcd_2018.DUAL_01
cms.mbsf_abcd_2018.DUAL_01
State Reported Dual Eligible Status
Code: January
cms.mbsf_d_2011.DUAL_01
cms.mbsf_d_2011.DUAL_01
Jan. Dual Status Code
cms.mbsf_d_2012.DUAL_01
cms.mbsf_d_2012.DUAL_01
Jan. Dual Status Code
cms.mbsf_abcd_2015.DUAL_09->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2016.DUAL_09->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2017.DUAL_09->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2018.DUAL_09->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2011.DUAL_09->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2012.DUAL_09->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2013.DUAL_09->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2014.DUAL_09->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2015.DUAL_01->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2016.DUAL_01->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2013.DUAL_01
cms.mbsf_d_2013.DUAL_01
Jan. Dual Status Code
cms.mbsf_d_2014.DUAL_01
cms.mbsf_d_2014.DUAL_01
Jan. Dual Status Code
cms.mbsf_abcd_2015.DUAL_04
cms.mbsf_abcd_2015.DUAL_04
State Reported Dual Eligible Status
Code: April
cms.mbsf_abcd_2016.DUAL_04
cms.mbsf_abcd_2016.DUAL_04
State Reported Dual Eligible Status
Code: April
cms.mbsf_abcd_2017.DUAL_04
cms.mbsf_abcd_2017.DUAL_04
State Reported Dual Eligible Status
Code: April
cms.mbsf_abcd_2018.DUAL_04
cms.mbsf_abcd_2018.DUAL_04
State Reported Dual Eligible Status
Code: April
cms.mbsf_d_2011.DUAL_04
cms.mbsf_d_2011.DUAL_04
Apr. Dual Status Code
cms.mbsf_d_2012.DUAL_04
cms.mbsf_d_2012.DUAL_04
Apr. Dual Status Code
cms.mbsf_d_2013.DUAL_04
cms.mbsf_d_2013.DUAL_04
Apr. Dual Status Code
cms.mbsf_d_2014.DUAL_04
cms.mbsf_d_2014.DUAL_04
Apr. Dual Status Code
cms.mbsf_abcd_2017.DUAL_01->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2018.DUAL_01->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2011.DUAL_01->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2012.DUAL_01->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2013.DUAL_01->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2014.DUAL_01->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2015.DUAL_04->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2016.DUAL_04->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2017.DUAL_04->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2018.DUAL_04->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2015.DUAL_02
cms.mbsf_abcd_2015.DUAL_02
State Reported Dual Eligible Status
Code: February
cms.mbsf_abcd_2016.DUAL_02
cms.mbsf_abcd_2016.DUAL_02
State Reported Dual Eligible Status
Code: February
cms.mbsf_abcd_2017.DUAL_02
cms.mbsf_abcd_2017.DUAL_02
State Reported Dual Eligible Status
Code: February
cms.mbsf_abcd_2018.DUAL_02
cms.mbsf_abcd_2018.DUAL_02
State Reported Dual Eligible Status
Code: February
cms.mbsf_d_2011.DUAL_02
cms.mbsf_d_2011.DUAL_02
Feb. Dual Status Code
cms.mbsf_d_2012.DUAL_02
cms.mbsf_d_2012.DUAL_02
Feb. Dual Status Code
cms.mbsf_d_2013.DUAL_02
cms.mbsf_d_2013.DUAL_02
Feb. Dual Status Code
cms.mbsf_d_2014.DUAL_02
cms.mbsf_d_2014.DUAL_02
Feb. Dual Status Code
cms.mbsf_abcd_2015.DUAL_03
cms.mbsf_abcd_2015.DUAL_03
State Reported Dual Eligible Status
Code: March
cms.mbsf_abcd_2016.DUAL_03
cms.mbsf_abcd_2016.DUAL_03
State Reported Dual Eligible Status
Code: March
cms.mbsf_d_2011.DUAL_04->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2012.DUAL_04->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2013.DUAL_04->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2014.DUAL_04->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2015.DUAL_02->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2016.DUAL_02->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2017.DUAL_02->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2018.DUAL_02->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2011.DUAL_02->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2012.DUAL_02->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2017.DUAL_03
cms.mbsf_abcd_2017.DUAL_03
State Reported Dual Eligible Status
Code: March
cms.mbsf_abcd_2018.DUAL_03
cms.mbsf_abcd_2018.DUAL_03
State Reported Dual Eligible Status
Code: March
cms.mbsf_d_2011.DUAL_03
cms.mbsf_d_2011.DUAL_03
Mar. Dual Status Code
cms.mbsf_d_2012.DUAL_03
cms.mbsf_d_2012.DUAL_03
Mar. Dual Status Code
cms.mbsf_d_2013.DUAL_03
cms.mbsf_d_2013.DUAL_03
Mar. Dual Status Code
cms.mbsf_d_2014.DUAL_03
cms.mbsf_d_2014.DUAL_03
Mar. Dual Status Code
cms.mbsf_d_2013.DUAL_02->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2014.DUAL_02->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2015.DUAL_03->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2016.DUAL_03->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2017.DUAL_03->medicare.mbsf_d.dual_indicators
union
cms.mbsf_abcd_2018.DUAL_03->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2011.DUAL_03->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2012.DUAL_03->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2013.DUAL_03->medicare.mbsf_d.dual_indicators
union
cms.mbsf_d_2014.DUAL_03->medicare.mbsf_d.dual_indicators
union