Sparksoft Corporation: Centers for Medicare & Medicaid Services (CMS) Public Data Offerings

Offering analytic ready copies of CMS's Public Data Offerings (NPPES, Open Payments, etc.)

Description:

We are offering CMS’s public data including:
NPPES, Open Payments, and every dataset published on https://data.cms.gov/. –*Datasets are continually updated to ensure the data fresh and relevant.
*Each data set includes detailed metadata about the original file
This allowing users to associate each record back to the original source file details. *Each column on every dataset is profiled.
Allowing users to understand if columns are populated, how unique any specific field is or if fields etc.
*Original source values, fields (beginning with „SRC_“) are loaded as text.
*Datatype transformations are also provided by expanding the datasets to incorporate a transformed versions of the source field. These fields beginning with „IVT_“. In cases where data is provided over time, we load the individual data files into a single time based table.
*We also provide slowly changing (Contiguous Non-Overlapping) date for dimensional datasets like NPPES.
*We are happy to expand this data offering to include any additional public data asset our customers would like us to maintain.

Federal Documentation exists for all datasets and can be used in combination with our load specific documentation:
See:
https://data.cms.gov/ for documentation specific to data.gov sources
https://download.cms.gov/nppes/NPI_Files.html for NPPES Specific documentation
https://www.cms.gov/OpenPayments/Data/Dataset-Downloads for Open Payments Specific Documentation

—————————————————————
— Subset of Tables Provided
—————————————————————
* Key Metadata Tables :
CMS_DATA.PUBLIC.IVT_FILE_LOAD_LOG — Metadata for each loaded file
Key Columns:
— TGT_DB_NAME VARCHAR
— TGT_SCMA_NAME VARCHAR
— TGT_TBL_NAME VARCHAR
— FILE_LOAD_TS TIMESTAMP

CMS_DATA.PUBLIC.IVT_PARM_TBL — Enhancements for each column
Key Columns:
— DB_NAME VARCHAR
— SCMA_NAME VARCHAR
— TBL_NAME VARCHAR
— CLMN_NAME VARCHAR

CMS_DATA.PUBLIC.IVT_DATA_PRFL_RPT — Profile per for each file by column
Key Columns:
— DB_NAME VARCHAR
— SCMA_NAME VARCHAR
— DATA_PRFL_NAME VARCHAR
— TBL_NAME VARCHAR
— CLMN_NAME VARCHAR
— LOAD_TS TIMESTAMP

* Code Lookups Table:
CMS_DATA.PUBLIC..CODE_DESC_LKUP — Code Description Lookup
Key Columns:
— DB_NAME VARCHAR
— SCMA_NAME VARCHAR
— TBL_NAME VARCHAR
— CLMN_NAME VARCHAR
— CODE_VAL VARCHAR

* NPPES TABLES:
CMS_DATA.PUBLIC.NPPES_WKLY_NPIDATA_LST — Primary NPI FILE Over Time
Key Columns:
— SRC_NPI VARCHAR
— IVT_FILE_CMNT VARCHAR

* Open Payment Tables:
CMS_DATA.PUBLIC.OPEN_PAY_GNRL_PMNTS — General payments to physicians
Sample Columns:
— SRC_CHANGE_TYPE VARCHAR
— SRC_COVERED_RECIPIENT_TYPE VARCHAR
— SRC_TEACHING_HOSPITAL_CCN VARCHAR
— SRC_TEACHING_HOSPITAL_ID VARCHAR
— SRC_PHYSICIAN_PROFILE_ID VARCHAR

CMS_DATA.PUBLIC.OPEN_PAY_OWNRSHIP_PMNTS — Ownership payments
Sample Columns:
— SRC_CHANGE_TYPE VARCHAR
— SRC_PHYSICIAN_PROFILE_ID VARCHAR
— SRC_RECIPIENT_PRIMARY_BUSINESS_STREET_ADDRESS_LINE1 VARCHAR

CMS_DATA.PUBLIC.OPEN_PAY_RSRCH_PMNTS — Research Payments to Physicians
Sample Columns:
— SRC_CHANGE_TYPE VARCHAR
— SRC_COVERED_RECIPIENT_TYPE VARCHAR
— SRC_NONCOVERED_RECIPIENT_ENTITY_NAME VARCHAR
— SRC_TEACHING_HOSPITAL_CCN VARCHAR
— SRC_TEACHING_HOSPITAL_ID VARCHAR
— SRC_PHYSICIAN_PROFILE_ID VARCHAR
— SRC_RECIPIENT_PRIMARY_BUSINESS_STREET_ADDRESS_LINE1 VARCHAR

About the Provider:

Sparksoft Corporation has a 17-year proven record of successfully delivering IT services for more than a dozen Federal, State, and Commercial customers including serving the Centers for Medicare & Medicaid Services (CMS). We are now offering analytic ready, public CMS data sets as part of our mission is to simply access to CMS’s public data.

Visit the provider’s website for more information

Get access to the Sparksoft Corporation: Centers for Medicare & Medicaid Services (CMS) Public Data Offerings Listing in Snowflake

SIGN UP FOR A SNOWFLAKE FREE TRIAL

Already a Snowflake customer?
Access this listing directly from your Snowflake account.

LOGIN