What the is the code you are using in your data. Is it SNOMED? CPT4? Something else?

CDM codes and REV codes are listed, both of which are a different coding system than SNOMED or CPT, specifically built for billing purposes.

https://en.m.wikipedia.org/wiki/Chargemaster

We're gotta work with whatever the hospitals give us.

The most common codes we see are CPT/HCPCS codes (coupled with revenue codes), or DRG codes. When the hospital provides any one of REV, CPT, HCPCS, MS-DRG, APR-DRG, APC, NDC, or EAPG, we break them out into their own columns.

We keep all the code metadata -- that is, we leave the code strings mostly intact, and then extract the code itself into a separate column. This preserves things like "CPT4" or whatever, as a string, but we do not have a way yet of splitting CPT codes into multiple subtypes. So we haven't lost any data, but we haven't totally figured out how to query it perfectly well either.

Can you share how are the data collected?

Sure. We get it via pull requests:

https://www.dolthub.com/repositories/dolthub/transparency-in...