search

jeffjmei / Hospital-Privatization

0 stars 0 forks source link

Link Patient Outcomes to Hospital Ownership #2

Open jeffjmei opened 1 week ago

jeffjmei commented 1 week ago

There are probably many ways to do this. Perhaps we can discuss some ideas on accomplishing this task in this issue.

jeffjmei commented 1 week ago

One approach I thought we could take is to link the datasets PATIENT_REPORTED_OUTCOMES_FACILITY to Hospital_All_Owners. I'm going to name these datasets patients and owners, respectively.

We can link the variables patients$"Facility Name" to owners$"ORGANIZATION NAME". However, they do not overlap perfectly. This is likely because the owners often own several hospitals For example, the Banner Health System owns several hospitals in Arizona, but each of these hospitals have their own name.

john-j-park commented 2 hours ago

It looks like the PATIENT_REPORTED_OUTCOMES_FACILITY data only includes hip/knee replacement patients, and CMS will release more data later(?)

I found another dataset called "Patient Survey" that seems to have more data about individual patient surveys, although this dataset looks way more unwieldy. I will add it to the data folder.

jeffjmei commented 1 hour ago

Yeah that's a good point. It is also possible that I did not download all the data as I was just trying to get something to work with at the time. I know a lot of the data in the \data folder is really messy right now, so I intend on cleaning it up one of these days to remove any excess documents and whatnot.