search

rkiddy / ca_hhs

The California Health and Human Services department publishes data in different formats. These apps will import and display the data. This is a work in progress.
0 stars 0 forks source link

chargemasters: some files are missing the hcai_id numbers in their names, or the numbers are wrong #2

Open rkiddy opened 3 months ago

rkiddy commented 3 months ago

This is know of by the HCAI chargemaster, but they may not have the authority to demand that the hospitals name the files correctly.

See:

2011/Catalina Island Medical Center/1061900045_CDM_2011.pdf
2011/Catalina Island Medical Center/1061900045_Comments_2011.doc
2011/Catalina Island Medical Center/1061900045_Common25_2011.xls
2011/Catalina Island Medical Center/1061900045_PCT_CHG_2011.docx
2013/Riverside Center for Behavioral Medicine/1066331226_CDM_2013.xls
2013/Riverside Center for Behavioral Medicine/1066331226_Comments_2013.docx
2013/Riverside Center for Behavioral Medicine/1066331226_Common25_2013.xls
2013/Riverside Center for Behavioral Medicine/1066331226_PCT_CHG_2013.xls
2014/Riverside Center for Behavioral Medicine/1066331226_CDM_Rx_2014.xls
2014/Riverside Center for Behavioral Medicine/1066331226_Comments_2014.docx
2014/Riverside Center for Behavioral Medicine/1066331226_PCT_CHG(1)_2014.xls
2014/Riverside Center for Behavioral Medicine/1066331226_PCT_CHG(2)_2014.xls
2016/Kindred Hospital - San Francisco Bay Area/10610887_CDM_2016.xlsx
2016/Kindred Hospital - San Francisco Bay Area/10610887_Common25_2016.doc
2016/Kindred Hospital - San Francisco Bay Area/10610887_PCT_CHG_2016.xls
2017/L.A. Co. - USC Medical Center/AB1627 1045 2017 submission.xlsx
2017/L.A. Co. - USC Medical Center/LAC - USC Medical Center Contact Info.docx
2017/State - Fairview Developmental Center/10630178_CDM_All_2017.xls
2018/Sutter Coast Hospital/10608401_CDM_All_2018.xlsx
2018/Sutter Coast Hospital/Comments.docx
2023/Aliso Ridge Behavioral Health, LLC/16304589_CDM_ALL.xlsx
2023/Coast Plaza Hospital/10690766_CDM.xlsx
2023/Coast Plaza Hospital/10690766_Common25.xlsx
2023/Coast Plaza Hospital/10690766_PCT_CHG.xlsx
2023/Kaiser Foundation Hospital - Antioch/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation Hospital - Antioch/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation Hospital - Antioch/HCAI KP NCAL_PCT_CHG.xlsx
2023/Kaiser Foundation Hospital - Fremont/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation Hospital - Fremont/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation Hospital - Fremont/HCAI KP NCAL_PCT_CHG.xlsx
2023/Kaiser Foundation Hospital - Fresno/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation Hospital - Fresno/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation Hospital - Fresno/HCAI KP NCAL_PCT_CHG.xlsx
2023/Kaiser Foundation Hospital - Manteca/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation Hospital - Manteca/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation Hospital - Manteca/HCAI KP NCAL_PCT_CHG.xlsx
2023/Kaiser Foundation Hospital - Modesto/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation Hospital - Modesto/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation Hospital - Modesto/HCAI KP NCAL_PCT_CHG.xlsx
2023/Kaiser Foundation Hospital - Moreno Valley/106334048191300_PCT_CHG.xlsx
2023/Kaiser Foundation Hospital - Oakland/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation Hospital - Oakland/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation Hospital - Oakland/HCAI KP NCAL_PCT_CHG.xlsx
2023/Kaiser Foundation Hospital - Redwood City/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation Hospital - Redwood City/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation Hospital - Redwood City/HCAI KP NCAL_PCT_CHG.xlsx
2023/Kaiser Foundation Hospital - Richmond/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation Hospital - Richmond/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation Hospital - Richmond/HCAI KP NCAL_PCT_CHG.xlsx
2023/Kaiser Foundation Hospital - Roseville/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation Hospital - Roseville/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation Hospital - Roseville/HCAI KP NCAL_PCT_CHG.xlsx
2023/Kaiser Foundation Hospital - Sacramento/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation Hospital - Sacramento/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation Hospital - Sacramento/HCAI KP NCAL_PCT_CHG.xlsx
2023/Kaiser Foundation Hospital - San Fransisco/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation Hospital - San Fransisco/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation Hospital - San Fransisco/HCAI KP NCAL_PCT_CHG.xlsx
2023/Kaiser Foundation Hospital - San Rafael/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation Hospital - San Rafael/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation Hospital - San Rafael/HCAI KP NCAL_PCT_CHG.xlsx
2023/Kaiser Foundation Hospital - Santa Clara/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation Hospital - Santa Clara/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation Hospital - Santa Clara/HCAI KP NCAL_PCT_CHG.xlsx
2023/Kaiser Foundation Hospital - Santa Rosa/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation Hospital - Santa Rosa/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation Hospital - Santa Rosa/HCAI KP NCAL_PCT_CHG.xlsx
2023/Kaiser Foundation Hospital - South Sacramento/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation Hospital - South Sacramento/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation Hospital - South Sacramento/HCAI KP NCAL_PCT_CHG.xlsx
2023/Kaiser Foundation Hospital - South San Fransisco/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation Hospital - South San Fransisco/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation Hospital - South San Fransisco/HCAI KP NCAL_PCT_CHG.xlsx
2023/Kaiser Foundation Hospital - Vacaville/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation Hospital - Vacaville/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation Hospital - Vacaville/HCAI KP NCAL_PCT_CHG.xlsx
2023/Kaiser Foundation Hospital - Vallejo/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation Hospital - Vallejo/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation Hospital - Vallejo/HCAI KP NCAL_PCT_CHG.xlsx
2023/Kaiser Foundation Hospital - Walnut Creek/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation Hospital - Walnut Creek/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation Hospital - Walnut Creek/HCAI KP NCAL_PCT_CHG.xlsx
2023/Kaiser Foundation - San Jose/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation - San Jose/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation - San Jose/HCAI KP NCAL_PCT_CHG.xlsx
2023/Kaiser Foundation - San Leandro/HCAI KP NCAL_CDM_Charge description master.xlsx
2023/Kaiser Foundation - San Leandro/HCAI KP NCAL Common 25 _Average charges for 25 common outpatient procedures proved by hospitals.xlsx
2023/Kaiser Foundation - San Leandro/HCAI KP NCAL_PCT_CHG.xlsx
2023/Orchard Hospital/1006040802_PCT_CHG.xlsx
rkiddy commented 3 months ago

This is after removing all of the Thumb.db files, because they are just useless.