3 ms·
I meant to submit this from my work account and not my personal one, but oh well. I helped make this. AMA or email me at alec@doltub.com.
by alecst 3y ago
I meant to submit this from my work account and not my personal one, but oh well.
I helped make this. AMA or email me at alec@doltub.com.
- adunsulag 3y agoWhat the is the code you are using in your data. Is it SNOMED? CPT4? Something else?
- tdstein 3y agoCDM 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 https://en.m.wikipedia.org/wiki/Chargemaster
- alecst 3y agoWe'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.
- throwaway918243 3y agoCan you share how are the data collected?
- alecst 3y agoSure. We get it via pull requests: https://www.dolthub.com/repositories/dolthub/transparency-in-pricing/pulls?refName=main https://www.dolthub.com/repositories/dolthub/transparency-in...