cocoon icon

Data Cleaning

Powered by Cocoon

hospital

(First 100 rows)
Before After
address_2 address_3 state address_1 condition measure_name index county measure_code city phone provider_number zip state_average name owner type sample score emergency_service
0 empty empty al 1720 university blvd surgical infection prevention surgery patients who were taking heart drugs caxxed beta bxockers before coming to the hospitax who were kept on the beta bxockers during the period just before and after their surgery 1 jefferson scip-card-2 birmingham 2053258100 10018 35233 al_scip-card-2 callahan eye foundation hospital voluntary non-profit - private acute care hospitals empty empty yes
1 empty empty al 1720 university blvd surgical infection prevention surgery patients who were given an antibiotic at the right time (within one hour before surgery) to help prevent infection 2 jefferson scip-inf-1 birmingham 2053258100 10018 35233 al_scip-inf-1 callahan eye foundation hospital voluntary non-profit - private acute care hospitals empty empty yes
2 empty empty al 1720 university blvd surgical infection prevention surgery patients who were given the right kind of antibiotic to help prevent infection 3 jefferson scip-inf-2 birmingham 2053258100 10018 35233 al_scip-inf-2 callahan eye foundation hospital voluntary non-profit - private acute care hospitals empty empty yes
3 empty empty al 1720 university blvd surgical infection prevention surgery patients whose preventive antibiotics were stopped at the right time (within 24 hours after surgery) 4 jefferson scip-inf-3 birminghxm 2053258100 10018 35233 al_scip-inf-3 callahan eye foundation hospital voluntary non-profit - private acute care hospitals empty empty yes
4 empty empty al 1720 university blvd surgical infection prevention all heart surgery patients whose blood sugar (blood glucose) is kept under good control in the days right after surgery 5 jefferson scip-inf-4 birmingham 2053258100 10018 35233 al_scip-inf-4 callahan eye foundation hospital voluntary non-profit - private acute care hospitals empty empty yes
5 empty empty al 1720 university blvd surgical infection prevention surgery patients needing hair removed from the surgical area before surgery who had hair removed using a safer method (electric clippers or hair removal cream c not a razor) 6 jefferson scip-inf-6 birmingham 2053258100 10018 35233 al_scip-inf-6 callahan eye foundation hospital voluntary non-profit - private acute care hospitals empty empty yes
6 empty empty al 1720 university blvd surgical infection prevention surgery patients whose doctors ordered treatments to prevent blood clots after certain types of surgeries 7 jefferson scip-vte-1 birmingham 2053258100 10018 35233 al_scip-vte-1 callahan eye foundation hospital voluntary non-profit - private acute care hospitals empty empty yes
7 empty empty al 1720 university blvd surgical infection prevention patients who got treatment at the right time (within 24 hours before or after their surgery) to help prevent blood clots after certain types of surgery 8 jefferson scip-vte-2 birmingxam 2053258100 10018 35233 al_scip-vte-2 callahan eye foundation hospital voluntary non-profit - private acute care hospitals empty empty yes
8 empty empty al 1300 south montgomery avenue heart attack heart attack patients given aspirin at arrival 9 jefferson ami-1 sheffield 2563864556 10019 35660 al_ami-1 helen keller memorial hospital government - hospital district or authority acute care hospitals 33 patients 97% yes
9 empty empty al 1300 south montgomery avenue heart attack heart attack patients given aspirin at discharge 10 jefferson ami-2 sheffield 2563864556 10019 35660 al_ami-2 helen keller memorial hospital government - hospital district or authority acute care hospitals 13 patients 92% yes
10 empty empty al 1300 south montgomery avenue heart attack heart attack patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd) 11 jefferson ami-3 sheffxeld 2563864556 10019 35660 al_ami-3 helen keller memorial hospital government - hospital district or authority acute care hospitals 4 patients 75% yes
11 empty empty al 1300 south montgomery avenue heart attack heart attack patients given smoking cessation advice/counseling 12 jefferson ami-4 sheffield 2563864556 10019 35660 al_ami-4 helen keller memorial hospital government - hospital district or authority acute care hospitals 4 patients 100% yes
12 empty empty al 1300 south montgomery avenue heart attack heart attack patients given beta blocker at discharge 13 jefferson ami-5 sheffield 2563864556 10019 35660 al_ami-5 helen keller memorial hospital government - hospital district or authority acute care hospitals 14 patients 86% yes
13 empty empty al 1300 south montgomery avenue heart attack heart attack patients given fibrinolytic medication within 30 minutes of arrival 14 jefferson ami-7a sheffield 2563864556 1xx19 35660 al_ami-7a helen keller memorial hospital government - hospital district or authority acute care hospitals 0 patients empty yes
14 empty empty al 1300 south montgomery avenue heart attack heart attack patients given pci within 90 minutes of arrival 15 jefferson ami-8a sheffield 2563864556 10019 35660 al_ami-8a helen keller memorial hospital government - hospital district or authority acute care hospitals 0 patients empty yes
15 empty empty al 1300 south montgomery avenue heart failure heart failure patients given discharge instructions 16 jefferson hf-1 sheffield 2563864556 10019 35660 al_hf-1 helen keller memorial hospital government - hospital district or authority acute care hospitals 114 patients 80% yes
16 empty empty al 1300 south montgomery avenue heart failure heart failure patients given an evaluation of left ventricular systolic (lvs) function 17 jefferson hf-2 sheffield 2563864556 10019 35660 al_hf-2 helen keller memorial hospital government - hospital district or authority acuxe care hospixals 149 patients 99% yes
17 empty empty al 1300 south montgomery avenue heart failure heart failure patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd) 18 jefferson hf-3 sheffield 2563864556 10019 35660 al_hf-3 helen keller memorial hospital government - hospital district or authority acute care hospitals 3x patients 92% yes
18 empty empty al 1300 south montgomery avenue heart failure heart failure patients given smoking cessation advice/counseling 19 jefferson hf-4 sheffield 2563864556 10019 35660 al_hf-4 helen keller memorial hospital government - hospital district or authority acute care hospitals 41 patients 100% yes
19 empty empty al 1108 ross clark circle heart attack heart attack patients given aspirin at arrival 20 houston ami-1 dothan 3347938701 10001 36302 al_ami-1 southeast alabama medical center government - hospital district or authority acute care hospitals 270 patients 98% yes
20 empty empty al 1108 ross clark circle heart attack heart attack patients given aspirin at discharge 21 houston ami-2 dothan 3347938701 10001 36302 al_ami-2 southeast alabama medical center government - hospital district or authority acute care hospitals 516 patients 99% yes
21 empty empty al 1108 ross clark circle heart attaxk heart attack patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd) 22 houston ami-3 dothan 3347938701 10001 36302 al_ami-3 southeast alabama medical center government - hospital district or authority acute care hospitals 71 patients 96% yes
22 empty empty al 1108 ross clark circle hearx axxack heart attack patients given smoking cessation advice/counseling 23 houston ami-4 dothan 3347938701 10001 36302 al_ami-4 southeast alabama medical center government - hospxtal dxstrxct or authorxty acute care hospitals 244 patients 100% yes
23 empty empty al 1108 ross clark circle heart attack heart attack patients given beta blocker at discharge 24 houston ami-5 dothan 3347938701 10001 36302 al_ami-5 southeast alabama medical center government - hospital district or authority acute care hospitals 441 patients 99% yes
24 empty empty al 1108 ross clark circle heart attack heart attack patients given fibrinolytic medication within 30 minutes of arrival 25 houston ami-7a dothan 334793870x 10001 36302 al_ami-7a southeast alabama medical center government - hospital district or authority acute care hospitals 0 patients empty yxs
25 empty empty al 1108 ross clark circle heart attack heart attack patients given pci within 90 minutes of arrival 26 houston ami-8a dothan 3347938701 10001 36302 al_ami-8a southeast alabama medical center government - hospital district or authority acute care hospitals 40 patients 72% yes
26 empty empty al 1108 ross clark circle heart failure heart failure patients given discharge instructions 27 houston hf-1 dothan 3347938701 10001 36302 al_hf-1 southeast alabama medxcal center government - hospital district or authority acute care hospitals 455 patients 78% yes
27 empty empty al 1108 ross clark circle heart failure heart failure patients given an evaluation of left ventricular systolic (lvs) function 28 houston hf-2 dothan 3347938701 10001 36302 al_hf-2 southeast alabama medical center government - hospital xistrict or authority acute care hospitals 514 patients 99% yes
28 empty empty al 1108 ross clark circle heart failure heart failure patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd) 29 houston hf-3 dothan 3347938701 10001 36302 al_hf-3 southeast alabama medical center government - hospital district or authority acute care hospitals 165 patients 91% yes
29 empty empty al 1108 ross clark circle heart failure heart failure patients given smoking cessation advice/counseling 30 houston hf-4 dothan 3347938701 10001 36302 al_hf-4 southeast alabama medical center government - hospital district or authority acute care hospitals 110 patients 100% yes
30 empty empty al 1108 ross clark circle pneumonia pneumonia patients assessed and given pneumococcal vaccination 31 houston pn-2 dothan 3347938701 10001 36302 al_pn-2 southeast alabama medical center government - hospital district or authority acute care hospitals 191 patients 93% yes
31 empty empty al 1108 ross clark circle pneumonia pneumonia patients whose initial emergency room blood culture was performed prior to the administration of the first hospital dose of antibiotics 32 houston pn-3b dothan 3347938701 10001 36302 al_pn-3b southeast alabama medical center governmenx - hospixal disxricx or auxhorixy acute care hospitals 125 patients 89% yes
32 empty empty al 1108 ross clark circle pneumonia pneumonia patients given smoking cessation advice/counseling 33 houston pn-4 dothan 3347938701 10001 36302 al_pn-4 southeast alabama medical center government - hospital district or authority acute care hospitals 107 patients 99% yes
33 empty empty al 1108 ross clark circle pneumonia pneumonia patients given initial antibiotic(s) within 6 hours after arrival 34 houston pn-5c dothan 3347938701 10001 36302 al_pn-5c southeast alabama medical center government - hospital district or authority acute care hospitals 196 patients 92% yes
34 empty empty al 1108 ross clark circle pneumonia pneumonia patients given the most appropriate initial antibiotic(s) 35 houston pn-6 dothan 3347938701 10001 36302 al_pn-6 southeast alabama medical center government - hospital district or authority acute care hospitals 147 patients 80% yes
35 empty empty al 1108 ross clark circle pneumonia pneumonia patients assessed and given influenza vaccination 36 houston pn-7 dothan 3347938701 10001 36302 al_pn-7 southeast alabama medical center government - hospital district or authority acute care hospitals 160 patients 84% yes
36 empty empty al 1108 ross clark circle surgical infection prevention surgery patients who were taking heart drugs called beta blockers before coming to the hospital who were kept on the beta blockers during the period just before and after their surgery 37 houston scip-card-2 dothan xx479x8701 10001 36302 al_scip-card-2 southeast alabama medical center government - hospital district or authority acute care hospitals 79 patients 72% yes
37 empty empty al 1108 ross clark circle surgical infection prevention surgery patients who were given an antibiotic at the right time (within one hour before surgery) to help prevent infection 38 houston scip-inf-1 dothan 3347938701 10001 36302 al_scip-inf-1 southeast alabama medical center government - hospital district or authority acute care hospitals 399 patients 94% yes
38 empty empty al 1108 ross clark circle surgical infection prevention surgery patients who were given the right kind of antibiotic to help prevent infection 39 houston scip-inf-2 dothan 3347938701 10001 36302 al_scip-inf-2 southeast alabama medical center government - hospital district or authority acute care hospitals 405 patients 98% yes
39 empty empty al 1108 ross clark circle surgical infection prevention surgery patients whose preventive antibiotics were stopped at the right time (within 24 hours after surgery) 40 houston scip-inf-3 dothan 3347938701 10001 36302 al_scip-inf-3 southeast alabama medical center government - hospital district or authority acxte care hospitals 385 patients 88% yes
40 empty empty al 1108 ross clark circle surgical infection prevention all heart surgery patients whose blood sugar (blood glucose) is kept under good control in the days right after surgery 41 houston scip-inf-4 dothan 3347938701 10001 36302 al_scip-inf-4 southeast alabama medical center government - hospital district or authority acute care hospitals 136 patients 96% yes
41 empty empty al 1108 ross clark circle surgical infection prevention surgery patients needing hair removed from the surgical area before surgery who had hair removed using a safer method (electric clippers or hair removal cream c not a razor) 42 houston scip-inf-6 dothan 3347938701 10001 36302 al_scip-inf-6 southeast alabama medical center government - hospital district or authority acute care hospitals 537 patients 90% yes
42 empty empty xl 1108 ross clark circle surgical infection prevention surgery patients whose doctors ordered treatments to prevent blood clots after certain types of surgeries 43 houston scip-vte-1 dothan 3347938701 10001 36302 al_scip-vte-1 southeast alabama medical center gxvernment - hxspital district xr authxrity acute care hospitals 185 patients 86% yes
43 empty empty al 1108 ross clark circle surgical infection prevention patients who got treatment at the right time (within 24 hours before or after their surgery) to help prevent blood clots after certain types of surgery 44 houston scip-vte-2 dothan 3347938701 10001 36302 al_scip-vte-2 southeast alabama medical center government - hospital district or authority acute care hospitals 184 patients 83% yex
44 empty empty al 2505 u s highway 431 north heart attack heart attack patients given aspirin at arrival 45 marshall ami-1 boaz 2565938310 10005 x5957 al_ami-1 marshall medical center south government - hospital district or authority acute care hospitals 20 patients 80% yes
45 empty empty al 2505 u s highway 431 north heart attack heart attack patients given aspirin at discharge 46 marshall ami-2 boaz 2565938310 x0005 35957 al_ami-2 marshall medical center south government - hospital district or authority acute care hospitals 5 patients 60% yes
46 empty empty xl 2505 u s highway 431 north heart attack heart attack patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd) 47 marshall ami-3 boaz 2565938310 10005 35957 al_ami-3 marshall medical center south government - hospital district or authority acute care hospitals 2 patients 100% yes
47 empty empty al 2505 u s highway 431 north heart attack heart attack patients given smoking cessation advice/counseling 48 marshall ami-4 boaz 2565938310 10005 35957 al_ami-4 marshall medical center south government - hospital district or authority acute care hospitals 0 patients empty yes
48 empty empty al 2505 u s highway 431 north heart attack heart attack patients given beta blocker at discharge 49 marshall ami-5 boaz 2565938310 10005 35957 al_ami-5 marshall medical center south government - hospital district or authority acute care hospitals 5 patients 100% yes
49 empty empty al 2505 u s highway 431 north heart attack heart attack patients given fibrinolytic medication within 30 minutes of arrival 50 marshall ami-7a boaz 2565938310 10005 35957 al_ami-7a marshall medical center south government - hospital district or authority acute care hospitals 0 patients empty yes
50 empty empty xl 2505 u s highway 431 north heart attack heart attack patients given pci within 90 minutes of arrival 51 marshall ami-8a boaz 2565938310 10005 35957 al_ami-8a marshall medical center south government - hospital district or authority acute care hospitals 0 patients empty yes
51 empty empty al 2505 u s highway 431 north heart failure heart failure patients given discharge instructions 52 marshall hf-1 boaz 2565938310 10005 35957 al_hf-1 marshall medical center south government - hospital district or authority acute care hospitals 110 patients 78% yxs
52 empty empty al 2505 u s highway 431 north heart failure heart failure patients given an evaluation of left ventricular systolic (lvs) function 53 marshall hf-2 boaz 2565938310 10005 35957 al_hf-2 marshall medical center south government - hospital district or authority acute care hospitals 160 patients 99% yes
53 empty empty al 2505 u s highway 431 north heart failure heart failure patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd) 54 marshall hf-3 boaz 2565938310 10005 35957 al_hf-3 marshall medical center south government - hospital district or authority acute care hospitals 69 patients 90% yes
54 empty empty al 2505 u s highway 431 north heart failure heart failure patients given smoking cessation advice/counseling 55 marshall hf-4 boaz 2565938310 10005 35957 al_hf-4 marshall medical center south government - hospital district or authority acute care hospitals 34 patients 94% yes
55 empty empty al 2505 u s highway 431 north pneumonia pneumonia patients assessed and given pneumococcal vaccination 56 marshall pn-2 boaz 2565938310 10005 35957 al_pn-2 marshall medical center south government - hospital district or authority acute care hospitals 172 patients 97% yes
56 empty empty al 2505 u s highway 431 north pneumonia pneumonia patients whose initial emergency room blood culture was performed prior to the administration of the first hospital dose of antibiotics 57 marshall pn-3b boxz 2565938310 10005 35957 al_pn-xb marshall medical center south government - hospital district or authority acute care hospitals 120 patients 97% yes
57 empty empty al 2505xuxsxhighwayx431xnorth pneumonia pneumonia patients given smoking cessation advice/counseling 58 marshall pn-4 boaz 2x6x938310 10005 35957 al_pn-4 marshall medical center south government - hospital district or authority acute care hospitals 98 patients 97% yes
58 empty empty al 2505 u s highway 431 north pneumonia pneumonia patients given initial antibiotic(s) within 6 hours after arrival 59 marshall pn-5c boaz 2565938310 10005 35957 al_pn-5c marshall medical center south government - hospital district or authority acute care hospitals 211 patients 96% yes
59 empty empty al 2505 u s highway 431 north pneumonia pneumonia patients given the most appropriate initial antibiotic(s) 60 marshall pn-6 boaz 2565938310 10005 35957 al_pn-6 marshall medical center south government - hospital district or authority acute care hospitals 175 patients 92% yes
60 empty empty al 2505 u s highway 431 north pneumonia pneumonia patients assessed and given influenza vaccination 61 marshall pn-7 boaz 2x6x938310 10005 35957 al_pn-7 marshall medical center south government - hospital district or authority acute care hospitals 118 patients 81% yes
61 empty empty al 2505 u s highway 431 north surgical infection prevention surgery patients who were taking heart drugs called beta blockers before coming to the hospital who were kept on the beta blockers during the period just before and after their surgery 62 marshall scip-card-2 boaz 2565938310 10005 35957 al_scip-card-2 marshall medical center south government - hospital district or authority acute care hospitals 14 patients 36% yes
62 empty empty al 2505 u s highway 431 north surgical infection prevention surgery patients who were given an antibiotic at the right time (within one hour before surgery) to help prevent infection 63 marshall scip-inf-1 boaz 2565938310 10005 35957 al_scip-inf-1 marshall medical center south government - hospital district or authority acute care hospitals 168 patients 96% yes
63 empty empty al 2505 u s highway 431 north surgical infection prevention surgery patients who were given the right kind of antibiotic to help prevent infection 64 marshall scip-inf-2 boaz 2565938310 10005 3595x al_scip-inf-2 marshall medical center south government - hospital district or authority acute care hospitals 167 patients 93% yes
64 empty empty al 2505 u s highway 431 north surgical infection prevention surgery patients whose preventive antibiotics were stopped at the right time (within 24 hours after surgery) 65 marshall scip-inf-3 boaz 2565938310 10005 35957 al_scip-inf-3 marshall medical center south government - hospital district or authority acute care hospitals 158 patients 95% yes
65 empty empty al 2505 u s highway 431 north surgical infection prevention all heart surgery patients whose blood sugar (blood glucose) is kept under good control in the days right after surgery 66 marshall scip-inf-4 boaz 2565x38310 10005 35957 al_scip-inf-4 marshall medical center south government - hospital district or authority acute care hospitals 0 patients empty yes
66 empty empty al 2505 u s highway 431 north surgical infection prevention surgery patients needing hair removed from the surgical area before surgery who had hair removed using a safer method (electric clippers or hair removal cream c not a razor) 67 marshall scip-inf-6 boaz 2565938310 10005 35957 al_scip-inf-6 marshall medical center south government - hospital district or authority acute care hospitals 237 patients 100% yes
67 empty empty al 2505 u s highway 431 north surgical infection prevention surgery patients whose doctors ordered treatments to prevent blood clots after certain types of surgeries 68 mxrshxll scip-vte-1 boaz 2565938310 10005 35957 al_scip-vte-1 marshall medical center south government - hospital district or authority acute care hospitals 76 patients 78% yes
68 empty empty al 2505 u s highway 431 north surgical infection prevention patients who got treatment at the right time (within 24 hours before or after their surgery) to help prevent blood clots after certain types of surgery 69 marshall scip-vte-2 boaz 2565938310 10005 35957 al_scip-vte-2 marshall medical center south government - hospital district or authority acute care hospitals 76 patients 74% yes
69 empty empty al 205 marengo street heart attack heart attack patients given aspirin at arrival 70 lauderdale ami-1 florence 2567688400 10006 35631 al_amx-1 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 159 patients 97% yes
70 empty empty al 205 marengo street heart attack heart attack patients given aspirin at discharge 71 lauderdale ami-2 florence 2567688400 10006 3563x al_ami-2 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 247 patients 96% yes
71 empty empty al 205 marengo street heart attack heart attack patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd) 72 lauderdale ami-3 florence 2567688400 10006 35631 al_ami-3 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 43 patients 93% yes
72 empty empty al 205 marengo street heart attack heart attack patients given smoking cessation advice/counseling 73 laudxrdalx ami-4 florence 2567688400 10006 35631 al_ami-4 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 103 patients 100% yes
73 empty empty al 205 marengo street hearx axxack heart attack patients given beta blocker at discharge 74 lauderdale ami-5 florence 2567688400 10006 35631 al_ami-5 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 227 patients 96% yes
74 empty empty al 205 marengo street heart attack heart attack patients given fibrinolytic medication within 30 minutes of arrival 75 lauderdale ami-7a florence 2567688400 10006 35631 al_ami-7a eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 0 patients empty yes
75 empty empty al 205 marengo street heart attack heart attack patients given pci within 90 minutes of arrival 76 lauderdale ami-8a florence 2567688400 10006 35631 al_ami-8a eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 61 patients 98% yes
76 empty empty al 205 marengo street heart failure heart failure patients given discharge instructions 77 lauderdale hf-1 florence 2567688400 10006 35631 al_hf-1 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 217 patients 79% yes
77 empty empty al 205 marengo street heart failure heart failure patients given an evaluation of left ventricular systolic (lvs) function 78 laudexdale hf-2 florence 2567688400 10006 35631 al_hf-2 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 259 patients 97% yes
78 empty empty al 205 marengo street heart failure heart failure patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd) 79 lauderdale hf-3 florence 2567688400 10006 35631 al_hf-3 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 84 patients 82% yes
79 empty empty al 205 marengo street heart failure heart failure patients given smoking cessation advice/counseling 80 lauderdale hf-4 fxorence 2567688400 10006 35631 al_hf-4 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 53 patients 100% yes
80 empty empty al 205 marengo street pneumonia pneumonia patients assessed and given pneumococcal vaccination 81 lauderdale pn-2 florence 2567688400 10006 35631 al_pn-2 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 174 patients 90% yes
81 empty empty al 205 marengo street pneumonia pneumonia patients whose initial emergency room blood culture was performed prior to the administration of the first hospital dose of antibiotics 82 lauderdale pn-3b florence 2567688400 1000x 35631 al_pn-3b eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 137 patients 95% yes
82 empty empty al 205 marengo street pneumonia pneumonia patients given smoking cessation advice/counseling 83 lauderdale pn-4 florence 2567688400 10006 35631 al_pn-4 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 65 patients 100% yes
83 empty empty xl 205 marengo street pneumonia pneumonia patients given initial antibiotic(s) within 6 hours after arrival 84 lauderdale pn-5c florence 2567688400 10006 35631 al_pn-5c eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 200 patients 96% yes
84 empty empty al 205 marengo street pneumonia pneumonia patients given the most appropriate initial antibiotic(s) 85 lauderdale pn-6 florence 2567688400 10006 35631 al_pn-6 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 138 patients 91% yes
85 empty empty al 205 marengo street pneumonia pneumonia patients assessed and given influenza vaccination 86 lauderdale pn-7 florence 2567688400 10006 35631 al_pn-7 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 85 patients 88% yes
86 empty empty al 205 marengo street surgical infection prevention surgery patients who were taking heart drugs called beta blockers before coming to the hospital who were kept on the beta blockers during the period just before and after their surgery 87 lauderdale scip-card-2 florence 2567688400 10006 35631 al_scip-card-2 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 107 patients 96% yes
87 empty empty al 205 marengo street surgical infection prevention surgery patients who were given an antibiotic at the right time (within one hour before surgery) to help prevent infection 88 lauderdale scip-inf-1 florence 2567688400 10006 35631 al_scip-inf-1 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 457 patients 99% yes
88 empty empty al 205 marengo street surgical infection prevention surgery patients who were given the right kind of antibiotic to help prevent infection 89 lauderdale scip-inf-2 florxncx 2567688400 10006 35631 al_scip-inf-2 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 462 patients 99% yes
89 empty empty al 205 marengo street surgical infection prevention surgery patients whose preventive antibiotics were stopped at the right time (within 24 hours after surgery) 90 lauderdale scip-inf-3 florence 2567688400 10006 35631 al_scip-inf-3 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 439 patients 94% yes
90 empty empty al 205 marengo street surgical infection prevention all heart surgery patients whose blood sugar (blood glucose) is kept under good control in the days right after surgery 91 lauderdale scip-inf-4 florence 2567688400 10006 35631 al_scip-inf-4 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 130 patients 89% yes
91 empty empty al 205 marengo street surgical infection prevention surgery patients needing hair removed from the surgical area before surgery who had hair removed using a safer method (electric clippers or hair removal cream c not a razor) 92 lauderdale scip-inf-6 florence 2567688400 10006 35631 al_scip-inf-6 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 619 paxienxs 100% yes
92 empty empty al 205 marengo street surgical infection prevention surgery patients whose doctors ordered treatments to prevent blood clots after certain types of surgeries 93 lauderdale scip-vte-1 florence 2567688400 10006 35631 al_scip-vte-1 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 242 patients 95% yes
93 empty empty al 205 marengo street surgical infection prevention patients who got treatment at the right time (within 24 hours before or after their surgery) to help prevent blood clots after certain types of surgery 94 lauderdale scip-vte-2 flxrence 2567688400 10006 3563x al_scip-vte-2 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 242 patients 92% yes
94 empty empty al 702xnxmainxst heart attack xeart attack patients given aspirin at arrival 95 covington ami-1 opp 3344933541 10007 36467 al_ami-1 mizell memorial hospital voluntary non-profit - private acute care hospitals 5 patients 60% no
95 empty empty al 702 n main st heart attack heart attack patients given aspirin at discharge 96 covington ami-2 opp 3344933541 10007 36467 al_ami-2 mizell memorial hospital voluntary non-profit - private acute care hospitals 2 patients 50% no
96 empty empty al 702 n main st heart attack heart attack patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd) 97 covington ami-3 opp 3344933541 10007 36467 al_ami-3 mizell memorial hospital voluntary non-profit - private acute care hospitals 0 patients empty no
97 empty empty al 702 n main st heart attack heart attack patients given smoking cessation advice/counseling 98 covington axi-4 opp 3344933541 10007 36467 al_ami-4 mizell memorial hospital voluntary non-profit - private acute care hospitals 0 patients empty no
98 empty empty xl 702 n main st heart attack heart attack patients given beta blocker at discharge 99 covington ami-5 opp 3344933541 10007 36467 al_ami-5 mizell memorial hospital voluntary non-profit - private acute care hosxitals 2 patients 100% no
99 empty empty al 702 n main st heart attack heart attack patients given fibrinolytic medication within 30 minutes of arrival 100 covington ami-7a opp 3344933541 10007 36467 al_ami-7a mizell memorial hospital voluntary non-profit - private acute care hospitals 0 patients empty no
address_2 address_3 state street_address treatment_category measure_description row_id county measure_code city phone_number provider_id zip_code state_average_code hospital_name ownership_type hospital_type sample_size measure_score has_emergency_service
0 None None al 50 medical park east drive surgical infection prevention surgery patients who were taking heart drugs called beta blockers before coming to the hospital who were kept on the beta blockers during the period just before and after their surgery 1 jefferson scip-card-2 birmingham 2053258100 10018 35233 al_scip-card-2 callahan eye foundation hospital voluntary non-profit - private acute care hospitals NaN NaN True
1 None None al 50 medical park east drive surgical infection prevention surgery patients who were given an antibiotic at the right time (within one hour before surgery) to help prevent infection 2 jefferson scip-inf-1 birmingham 2053258100 10018 35233 al_scip-inf-1 callahan eye foundation hospital voluntary non-profit - private acute care hospitals NaN NaN True
2 None None al 50 medical park east drive surgical infection prevention surgery patients who were given the right kind of antibiotic to help prevent infection 3 jefferson scip-inf-2 birmingham 2053258100 10018 35233 al_scip-inf-2 callahan eye foundation hospital voluntary non-profit - private acute care hospitals NaN NaN True
3 None None al 50 medical park east drive surgical infection prevention surgery patients whose preventive antibiotics were stopped at the right time (within 24 hours after surgery) 4 jefferson scip-inf-3 birmingham 2053258100 10018 35233 al_scip-inf-3 callahan eye foundation hospital voluntary non-profit - private acute care hospitals NaN NaN True
4 None None al 50 medical park east drive surgical infection prevention all heart surgery patients whose blood sugar (blood glucose) is kept under good control in the days right after surgery 5 jefferson scip-inf-4 birmingham 2053258100 10018 35233 al_scip-inf-4 callahan eye foundation hospital voluntary non-profit - private acute care hospitals NaN NaN True
5 None None al 50 medical park east drive surgical infection prevention surgery patients needing hair removed from the surgical area before surgery who had hair removed using a safer method (electric clippers or hair removal cream c not a razor) 6 jefferson scip-inf-6 birmingham 2053258100 10018 35233 al_scip-inf-6 callahan eye foundation hospital voluntary non-profit - private acute care hospitals NaN NaN True
6 None None al 50 medical park east drive surgical infection prevention surgery patients whose doctors ordered treatments to prevent blood clots after certain types of surgeries 7 jefferson scip-vte-1 birmingham 2053258100 10018 35233 al_scip-vte-1 callahan eye foundation hospital voluntary non-profit - private acute care hospitals NaN NaN True
7 None None al 50 medical park east drive surgical infection prevention patients who got treatment at the right time (within 24 hours before or after their surgery) to help prevent blood clots after certain types of surgery 8 jefferson scip-vte-2 birmingham 2053258100 10018 35233 al_scip-vte-2 callahan eye foundation hospital voluntary non-profit - private acute care hospitals NaN NaN True
8 None None al 50 medical park east drive heart attack heart attack patients given aspirin at arrival 9 jefferson ami-1 birmingham 2053258100 10018 35233 al_ami-1 callahan eye foundation hospital voluntary non-profit - private acute care hospitals 33.0 97.0 True
9 None None al 50 medical park east drive heart attack heart attack patients given aspirin at discharge 10 jefferson ami-2 birmingham 2053258100 10018 35233 al_ami-2 callahan eye foundation hospital voluntary non-profit - private acute care hospitals 13.0 92.0 True
10 None None al 50 medical park east drive heart attack heart attack patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd) 11 jefferson ami-3 birmingham 2053258100 10018 35233 al_ami-3 callahan eye foundation hospital voluntary non-profit - private acute care hospitals 4.0 75.0 True
11 None None al 50 medical park east drive heart attack heart attack patients given smoking cessation advice/counseling 12 jefferson ami-4 birmingham 2053258100 10018 35233 al_ami-4 callahan eye foundation hospital voluntary non-profit - private acute care hospitals 4.0 100.0 True
12 None None al 50 medical park east drive heart attack heart attack patients given beta blocker at discharge 13 jefferson ami-5 birmingham 2053258100 10018 35233 al_ami-5 callahan eye foundation hospital voluntary non-profit - private acute care hospitals 14.0 86.0 True
13 None None al 50 medical park east drive heart attack heart attack patients given fibrinolytic medication within 30 minutes of arrival 14 jefferson ami-7a birmingham 2053258100 10018 35233 al_ami-7a callahan eye foundation hospital voluntary non-profit - private acute care hospitals 0.0 NaN True
14 None None al 50 medical park east drive heart attack heart attack patients given pci within 90 minutes of arrival 15 jefferson ami-8a birmingham 2053258100 10018 35233 al_ami-8a callahan eye foundation hospital voluntary non-profit - private acute care hospitals 0.0 NaN True
15 None None al 50 medical park east drive heart failure heart failure patients given discharge instructions 16 jefferson hf-1 birmingham 2053258100 10018 35233 al_hf-1 callahan eye foundation hospital voluntary non-profit - private acute care hospitals 114.0 80.0 True
16 None None al 50 medical park east drive heart failure heart failure patients given an evaluation of left ventricular systolic (lvs) function 17 jefferson hf-2 birmingham 2053258100 10018 35233 al_hf-2 callahan eye foundation hospital voluntary non-profit - private acute care hospitals 149.0 99.0 True
17 None None al 50 medical park east drive heart failure heart failure patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd) 18 jefferson hf-3 birmingham 2053258100 10018 35233 al_hf-3 callahan eye foundation hospital voluntary non-profit - private acute care hospitals NaN 92.0 True
18 None None al 50 medical park east drive heart failure heart failure patients given smoking cessation advice/counseling 19 jefferson hf-4 birmingham 2053258100 10018 35233 al_hf-4 callahan eye foundation hospital voluntary non-profit - private acute care hospitals 41.0 100.0 True
19 None None al 1108 ross clark circle heart attack heart attack patients given aspirin at arrival 20 houston ami-1 dothan 3347938701 10001 36302 al_ami-1 southeast alabama medical center government - hospital district or authority acute care hospitals 270.0 98.0 True
20 None None al 1108 ross clark circle heart attack heart attack patients given aspirin at discharge 21 houston ami-2 dothan 3347938701 10001 36302 al_ami-2 southeast alabama medical center government - hospital district or authority acute care hospitals 516.0 99.0 True
21 None None al 1108 ross clark circle heart attack heart attack patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd) 22 houston ami-3 dothan 3347938701 10001 36302 al_ami-3 southeast alabama medical center government - hospital district or authority acute care hospitals 71.0 96.0 True
22 None None al 1108 ross clark circle heart attack heart attack patients given smoking cessation advice/counseling 23 houston ami-4 dothan 3347938701 10001 36302 al_ami-4 southeast alabama medical center government - hospital district or authority acute care hospitals 244.0 100.0 True
23 None None al 1108 ross clark circle heart attack heart attack patients given beta blocker at discharge 24 houston ami-5 dothan 3347938701 10001 36302 al_ami-5 southeast alabama medical center government - hospital district or authority acute care hospitals 441.0 99.0 True
24 None None al 1108 ross clark circle heart attack heart attack patients given fibrinolytic medication within 30 minutes of arrival 25 houston ami-7a dothan 3347938701 10001 36302 al_ami-7a southeast alabama medical center government - hospital district or authority acute care hospitals 0.0 NaN True
25 None None al 1108 ross clark circle heart attack heart attack patients given pci within 90 minutes of arrival 26 houston ami-8a dothan 3347938701 10001 36302 al_ami-8a southeast alabama medical center government - hospital district or authority acute care hospitals 40.0 72.0 True
26 None None al 1108 ross clark circle heart failure heart failure patients given discharge instructions 27 houston hf-1 dothan 3347938701 10001 36302 al_hf-1 southeast alabama medical center government - hospital district or authority acute care hospitals 455.0 78.0 True
27 None None al 1108 ross clark circle heart failure heart failure patients given an evaluation of left ventricular systolic (lvs) function 28 houston hf-2 dothan 3347938701 10001 36302 al_hf-2 southeast alabama medical center government - hospital district or authority acute care hospitals 514.0 99.0 True
28 None None al 1108 ross clark circle heart failure heart failure patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd) 29 houston hf-3 dothan 3347938701 10001 36302 al_hf-3 southeast alabama medical center government - hospital district or authority acute care hospitals 165.0 91.0 True
29 None None al 1108 ross clark circle heart failure heart failure patients given smoking cessation advice/counseling 30 houston hf-4 dothan 3347938701 10001 36302 al_hf-4 southeast alabama medical center government - hospital district or authority acute care hospitals 110.0 100.0 True
30 None None al 1108 ross clark circle pneumonia pneumonia patients assessed and given pneumococcal vaccination 31 houston pn-2 dothan 3347938701 10001 36302 al_pn-2 southeast alabama medical center government - hospital district or authority acute care hospitals 191.0 93.0 True
31 None None al 1108 ross clark circle pneumonia pneumonia patients whose initial emergency room blood culture was performed prior to the administration of the first hospital dose of antibiotics 32 houston pn-3b dothan 3347938701 10001 36302 al_pn-3b southeast alabama medical center government - hospital district or authority acute care hospitals 125.0 89.0 True
32 None None al 1108 ross clark circle pneumonia pneumonia patients given smoking cessation advice/counseling 33 houston pn-4 dothan 3347938701 10001 36302 al_pn-4 southeast alabama medical center government - hospital district or authority acute care hospitals 107.0 99.0 True
33 None None al 1108 ross clark circle pneumonia pneumonia patients given initial antibiotic(s) within 6 hours after arrival 34 houston pn-5c dothan 3347938701 10001 36302 al_pn-5c southeast alabama medical center government - hospital district or authority acute care hospitals 196.0 92.0 True
34 None None al 1108 ross clark circle pneumonia pneumonia patients given the most appropriate initial antibiotic(s) 35 houston pn-6 dothan 3347938701 10001 36302 al_pn-6 southeast alabama medical center government - hospital district or authority acute care hospitals 147.0 80.0 True
35 None None al 1108 ross clark circle pneumonia pneumonia patients assessed and given influenza vaccination 36 houston pn-7 dothan 3347938701 10001 36302 al_pn-7 southeast alabama medical center government - hospital district or authority acute care hospitals 160.0 84.0 True
36 None None al 1108 ross clark circle surgical infection prevention surgery patients who were taking heart drugs called beta blockers before coming to the hospital who were kept on the beta blockers during the period just before and after their surgery 37 houston scip-card-2 dothan 3347938701 10001 36302 al_scip-card-2 southeast alabama medical center government - hospital district or authority acute care hospitals 79.0 72.0 True
37 None None al 1108 ross clark circle surgical infection prevention surgery patients who were given an antibiotic at the right time (within one hour before surgery) to help prevent infection 38 houston scip-inf-1 dothan 3347938701 10001 36302 al_scip-inf-1 southeast alabama medical center government - hospital district or authority acute care hospitals 399.0 94.0 True
38 None None al 1108 ross clark circle surgical infection prevention surgery patients who were given the right kind of antibiotic to help prevent infection 39 houston scip-inf-2 dothan 3347938701 10001 36302 al_scip-inf-2 southeast alabama medical center government - hospital district or authority acute care hospitals 405.0 98.0 True
39 None None al 1108 ross clark circle surgical infection prevention surgery patients whose preventive antibiotics were stopped at the right time (within 24 hours after surgery) 40 houston scip-inf-3 dothan 3347938701 10001 36302 al_scip-inf-3 southeast alabama medical center government - hospital district or authority acute care hospitals 385.0 88.0 True
40 None None al 1108 ross clark circle surgical infection prevention all heart surgery patients whose blood sugar (blood glucose) is kept under good control in the days right after surgery 41 houston scip-inf-4 dothan 3347938701 10001 36302 al_scip-inf-4 southeast alabama medical center government - hospital district or authority acute care hospitals 136.0 96.0 True
41 None None al 1108 ross clark circle surgical infection prevention surgery patients needing hair removed from the surgical area before surgery who had hair removed using a safer method (electric clippers or hair removal cream c not a razor) 42 houston scip-inf-6 dothan 3347938701 10001 36302 al_scip-inf-6 southeast alabama medical center government - hospital district or authority acute care hospitals 537.0 90.0 True
42 None None al 1108 ross clark circle surgical infection prevention surgery patients whose doctors ordered treatments to prevent blood clots after certain types of surgeries 43 houston scip-vte-1 dothan 3347938701 10001 36302 al_scip-vte-1 southeast alabama medical center government - hospital district or authority acute care hospitals 185.0 86.0 True
43 None None al 1108 ross clark circle surgical infection prevention patients who got treatment at the right time (within 24 hours before or after their surgery) to help prevent blood clots after certain types of surgery 44 houston scip-vte-2 dothan 3347938701 10001 36302 al_scip-vte-2 southeast alabama medical center government - hospital district or authority acute care hospitals 184.0 83.0 True
44 None None al 2505 u s highway 431 north heart attack heart attack patients given aspirin at arrival 45 marshall ami-1 boaz 2565938310 10005 35957 al_ami-1 marshall medical center south government - hospital district or authority acute care hospitals 20.0 80.0 True
45 None None al 2505 u s highway 431 north heart attack heart attack patients given aspirin at discharge 46 marshall ami-2 boaz 2565938310 10005 35957 al_ami-2 marshall medical center south government - hospital district or authority acute care hospitals 5.0 60.0 True
46 None None al 2505 u s highway 431 north heart attack heart attack patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd) 47 marshall ami-3 boaz 2565938310 10005 35957 al_ami-3 marshall medical center south government - hospital district or authority acute care hospitals 2.0 100.0 True
47 None None al 2505 u s highway 431 north heart attack heart attack patients given smoking cessation advice/counseling 48 marshall ami-4 boaz 2565938310 10005 35957 al_ami-4 marshall medical center south government - hospital district or authority acute care hospitals 0.0 NaN True
48 None None al 2505 u s highway 431 north heart attack heart attack patients given beta blocker at discharge 49 marshall ami-5 boaz 2565938310 10005 35957 al_ami-5 marshall medical center south government - hospital district or authority acute care hospitals 5.0 100.0 True
49 None None al 2505 u s highway 431 north heart attack heart attack patients given fibrinolytic medication within 30 minutes of arrival 50 marshall ami-7a boaz 2565938310 10005 35957 al_ami-7a marshall medical center south government - hospital district or authority acute care hospitals 0.0 NaN True
50 None None al 2505 u s highway 431 north heart attack heart attack patients given pci within 90 minutes of arrival 51 marshall ami-8a boaz 2565938310 10005 35957 al_ami-8a marshall medical center south government - hospital district or authority acute care hospitals 0.0 NaN True
51 None None al 2505 u s highway 431 north heart failure heart failure patients given discharge instructions 52 marshall hf-1 boaz 2565938310 10005 35957 al_hf-1 marshall medical center south government - hospital district or authority acute care hospitals 110.0 78.0 True
52 None None al 2505 u s highway 431 north heart failure heart failure patients given an evaluation of left ventricular systolic (lvs) function 53 marshall hf-2 boaz 2565938310 10005 35957 al_hf-2 marshall medical center south government - hospital district or authority acute care hospitals 160.0 99.0 True
53 None None al 2505 u s highway 431 north heart failure heart failure patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd) 54 marshall hf-3 boaz 2565938310 10005 35957 al_hf-3 marshall medical center south government - hospital district or authority acute care hospitals 69.0 90.0 True
54 None None al 2505 u s highway 431 north heart failure heart failure patients given smoking cessation advice/counseling 55 marshall hf-4 boaz 2565938310 10005 35957 al_hf-4 marshall medical center south government - hospital district or authority acute care hospitals 34.0 94.0 True
55 None None al 2505 u s highway 431 north pneumonia pneumonia patients assessed and given pneumococcal vaccination 56 marshall pn-2 boaz 2565938310 10005 35957 al_pn-2 marshall medical center south government - hospital district or authority acute care hospitals 172.0 97.0 True
56 None None al 2505 u s highway 431 north pneumonia pneumonia patients whose initial emergency room blood culture was performed prior to the administration of the first hospital dose of antibiotics 57 marshall pn-3b boaz 2565938310 10005 35957 al_pn-3b marshall medical center south government - hospital district or authority acute care hospitals 120.0 97.0 True
57 None None al 2505 u s highway 431 north pneumonia pneumonia patients given smoking cessation advice/counseling 58 marshall pn-4 boaz 2565938310 10005 35957 al_pn-4 marshall medical center south government - hospital district or authority acute care hospitals 98.0 97.0 True
58 None None al 2505 u s highway 431 north pneumonia pneumonia patients given initial antibiotic(s) within 6 hours after arrival 59 marshall pn-5c boaz 2565938310 10005 35957 al_pn-5c marshall medical center south government - hospital district or authority acute care hospitals 211.0 96.0 True
59 None None al 2505 u s highway 431 north pneumonia pneumonia patients given the most appropriate initial antibiotic(s) 60 marshall pn-6 boaz 2565938310 10005 35957 al_pn-6 marshall medical center south government - hospital district or authority acute care hospitals 175.0 92.0 True
60 None None al 2505 u s highway 431 north pneumonia pneumonia patients assessed and given influenza vaccination 61 marshall pn-7 boaz 2565938310 10005 35957 al_pn-7 marshall medical center south government - hospital district or authority acute care hospitals 118.0 81.0 True
61 None None al 2505 u s highway 431 north surgical infection prevention surgery patients who were taking heart drugs called beta blockers before coming to the hospital who were kept on the beta blockers during the period just before and after their surgery 62 marshall scip-card-2 boaz 2565938310 10005 35957 al_scip-card-2 marshall medical center south government - hospital district or authority acute care hospitals 14.0 36.0 True
62 None None al 2505 u s highway 431 north surgical infection prevention surgery patients who were given an antibiotic at the right time (within one hour before surgery) to help prevent infection 63 marshall scip-inf-1 boaz 2565938310 10005 35957 al_scip-inf-1 marshall medical center south government - hospital district or authority acute care hospitals 168.0 96.0 True
63 None None al 2505 u s highway 431 north surgical infection prevention surgery patients who were given the right kind of antibiotic to help prevent infection 64 marshall scip-inf-2 boaz 2565938310 10005 35957 al_scip-inf-2 marshall medical center south government - hospital district or authority acute care hospitals 167.0 93.0 True
64 None None al 2505 u s highway 431 north surgical infection prevention surgery patients whose preventive antibiotics were stopped at the right time (within 24 hours after surgery) 65 marshall scip-inf-3 boaz 2565938310 10005 35957 al_scip-inf-3 marshall medical center south government - hospital district or authority acute care hospitals 158.0 95.0 True
65 None None al 2505 u s highway 431 north surgical infection prevention all heart surgery patients whose blood sugar (blood glucose) is kept under good control in the days right after surgery 66 marshall scip-inf-4 boaz 2565938310 10005 35957 al_scip-inf-4 marshall medical center south government - hospital district or authority acute care hospitals 0.0 NaN True
66 None None al 2505 u s highway 431 north surgical infection prevention surgery patients needing hair removed from the surgical area before surgery who had hair removed using a safer method (electric clippers or hair removal cream c not a razor) 67 marshall scip-inf-6 boaz 2565938310 10005 35957 al_scip-inf-6 marshall medical center south government - hospital district or authority acute care hospitals 237.0 100.0 True
67 None None al 2505 u s highway 431 north surgical infection prevention surgery patients whose doctors ordered treatments to prevent blood clots after certain types of surgeries 68 marshall scip-vte-1 boaz 2565938310 10005 35957 al_scip-vte-1 marshall medical center south government - hospital district or authority acute care hospitals 76.0 78.0 True
68 None None al 2505 u s highway 431 north surgical infection prevention patients who got treatment at the right time (within 24 hours before or after their surgery) to help prevent blood clots after certain types of surgery 69 marshall scip-vte-2 boaz 2565938310 10005 35957 al_scip-vte-2 marshall medical center south government - hospital district or authority acute care hospitals 76.0 74.0 True
69 None None al 205 marengo street heart attack heart attack patients given aspirin at arrival 70 lauderdale ami-1 florence 2567688400 10006 35631 al_ami-1 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 159.0 97.0 True
70 None None al 205 marengo street heart attack heart attack patients given aspirin at discharge 71 lauderdale ami-2 florence 2567688400 10006 35631 al_ami-2 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 247.0 96.0 True
71 None None al 205 marengo street heart attack heart attack patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd) 72 lauderdale ami-3 florence 2567688400 10006 35631 al_ami-3 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 43.0 93.0 True
72 None None al 205 marengo street heart attack heart attack patients given smoking cessation advice/counseling 73 lauderdale ami-4 florence 2567688400 10006 35631 al_ami-4 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 103.0 100.0 True
73 None None al 205 marengo street heart attack heart attack patients given beta blocker at discharge 74 lauderdale ami-5 florence 2567688400 10006 35631 al_ami-5 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 227.0 96.0 True
74 None None al 205 marengo street heart attack heart attack patients given fibrinolytic medication within 30 minutes of arrival 75 lauderdale ami-7a florence 2567688400 10006 35631 al_ami-7a eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 0.0 NaN True
75 None None al 205 marengo street heart attack heart attack patients given pci within 90 minutes of arrival 76 lauderdale ami-8a florence 2567688400 10006 35631 al_ami-8a eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 61.0 98.0 True
76 None None al 205 marengo street heart failure heart failure patients given discharge instructions 77 lauderdale hf-1 florence 2567688400 10006 35631 al_hf-1 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 217.0 79.0 True
77 None None al 205 marengo street heart failure heart failure patients given an evaluation of left ventricular systolic (lvs) function 78 lauderdale hf-2 florence 2567688400 10006 35631 al_hf-2 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 259.0 97.0 True
78 None None al 205 marengo street heart failure heart failure patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd) 79 lauderdale hf-3 florence 2567688400 10006 35631 al_hf-3 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 84.0 82.0 True
79 None None al 205 marengo street heart failure heart failure patients given smoking cessation advice/counseling 80 lauderdale hf-4 florence 2567688400 10006 35631 al_hf-4 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 53.0 100.0 True
80 None None al 205 marengo street pneumonia pneumonia patients assessed and given pneumococcal vaccination 81 lauderdale pn-2 florence 2567688400 10006 35631 al_pn-2 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 174.0 90.0 True
81 None None al 205 marengo street pneumonia pneumonia patients whose initial emergency room blood culture was performed prior to the administration of the first hospital dose of antibiotics 82 lauderdale pn-3b florence 2567688400 10006 35631 al_pn-3b eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 137.0 95.0 True
82 None None al 205 marengo street pneumonia pneumonia patients given smoking cessation advice/counseling 83 lauderdale pn-4 florence 2567688400 10006 35631 al_pn-4 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 65.0 100.0 True
83 None None al 205 marengo street pneumonia pneumonia patients given initial antibiotic(s) within 6 hours after arrival 84 lauderdale pn-5c florence 2567688400 10006 35631 al_pn-5c eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 200.0 96.0 True
84 None None al 205 marengo street pneumonia pneumonia patients given the most appropriate initial antibiotic(s) 85 lauderdale pn-6 florence 2567688400 10006 35631 al_pn-6 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 138.0 91.0 True
85 None None al 205 marengo street pneumonia pneumonia patients assessed and given influenza vaccination 86 lauderdale pn-7 florence 2567688400 10006 35631 al_pn-7 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 85.0 88.0 True
86 None None al 205 marengo street surgical infection prevention surgery patients who were taking heart drugs called beta blockers before coming to the hospital who were kept on the beta blockers during the period just before and after their surgery 87 lauderdale scip-card-2 florence 2567688400 10006 35631 al_scip-card-2 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 107.0 96.0 True
87 None None al 205 marengo street surgical infection prevention surgery patients who were given an antibiotic at the right time (within one hour before surgery) to help prevent infection 88 lauderdale scip-inf-1 florence 2567688400 10006 35631 al_scip-inf-1 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 457.0 99.0 True
88 None None al 205 marengo street surgical infection prevention surgery patients who were given the right kind of antibiotic to help prevent infection 89 lauderdale scip-inf-2 florence 2567688400 10006 35631 al_scip-inf-2 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 462.0 99.0 True
89 None None al 205 marengo street surgical infection prevention surgery patients whose preventive antibiotics were stopped at the right time (within 24 hours after surgery) 90 lauderdale scip-inf-3 florence 2567688400 10006 35631 al_scip-inf-3 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 439.0 94.0 True
90 None None al 205 marengo street surgical infection prevention all heart surgery patients whose blood sugar (blood glucose) is kept under good control in the days right after surgery 91 lauderdale scip-inf-4 florence 2567688400 10006 35631 al_scip-inf-4 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 130.0 89.0 True
91 None None al 205 marengo street surgical infection prevention surgery patients needing hair removed from the surgical area before surgery who had hair removed using a safer method (electric clippers or hair removal cream c not a razor) 92 lauderdale scip-inf-6 florence 2567688400 10006 35631 al_scip-inf-6 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 619.0 100.0 True
92 None None al 205 marengo street surgical infection prevention surgery patients whose doctors ordered treatments to prevent blood clots after certain types of surgeries 93 lauderdale scip-vte-1 florence 2567688400 10006 35631 al_scip-vte-1 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 242.0 95.0 True
93 None None al 205 marengo street surgical infection prevention patients who got treatment at the right time (within 24 hours before or after their surgery) to help prevent blood clots after certain types of surgery 94 lauderdale scip-vte-2 florence 2567688400 10006 35631 al_scip-vte-2 eliza coffee memorial hospital voluntary non-profit - other acute care hospitals 242.0 92.0 True
94 None None al 702 n main st heart attack heart attack patients given aspirin at arrival 95 covington ami-1 opp 3344933541 10007 36467 al_ami-1 mizell memorial hospital voluntary non-profit - private acute care hospitals 5.0 60.0 True
95 None None al 702 n main st heart attack heart attack patients given aspirin at discharge 96 covington ami-2 opp 3344933541 10007 36467 al_ami-2 mizell memorial hospital voluntary non-profit - private acute care hospitals 2.0 50.0 True
96 None None al 702 n main st heart attack heart attack patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd) 97 covington ami-3 opp 3344933541 10007 36467 al_ami-3 mizell memorial hospital voluntary non-profit - private acute care hospitals 0.0 NaN True
97 None None al 702 n main st heart attack heart attack patients given smoking cessation advice/counseling 98 covington ami-4 opp 3344933541 10007 36467 al_ami-4 mizell memorial hospital voluntary non-profit - private acute care hospitals 0.0 NaN True
98 None None al 702 n main st heart attack heart attack patients given beta blocker at discharge 99 covington ami-5 opp 3344933541 10007 36467 al_ami-5 mizell memorial hospital voluntary non-profit - private acute care hospitals 2.0 100.0 True
99 None None al 702 n main st heart attack heart attack patients given fibrinolytic medication within 30 minutes of arrival 100 covington ami-7a opp 3344933541 10007 36467 al_ami-7a mizell memorial hospital voluntary non-profit - private acute care hospitals 0.0 NaN True
address_2
▲
📃 Summary: Second line of hospital address
❓ Missing: Secondary address line not needed for all locations.

address_3
▲
📃 Summary: Third line of hospital address
❓ Missing: Tertiary address line not needed for all locations.

state
▲
not_null

📃 Summary: State where the hospital is located

street_address
▲
not_null

📃 Summary: First line of hospital address

treatment_category
▲
not_null

📃 Summary: Type of medical condition or treatment

measure_description
▲
not_null

📃 Summary: Description of the quality measure

row_id
▲
not_nullunique

📃 Summary: Unique identifier for each row
🦄 Unique: This column is a unique identifier for each row. For this table, each row represents a different measure for the same hospital. row_id is unique across rows.

county
▲
not_null

📃 Summary: County where the hospital is located

measure_code
▲
not_null

📃 Summary: Code for specific quality measure

city
▲
not_null

📃 Summary: City where the hospital is located

phone_number
▲
not_null

📃 Summary: Hospital's phone number

provider_id
▲
not_null

📃 Summary: Unique identifier for the hospital

zip_code
▲
not_null

📃 Summary: ZIP code of the hospital

state_average_code
▲
not_null

📃 Summary: State average for the measure

hospital_name
▲
not_null

📃 Summary: Name of the hospital

ownership_type
▲
not_nullaccepted_values

📃 Summary: Type of hospital ownership

hospital_type
▲
not_nullaccepted_values

📃 Summary: Type of hospital

sample_size
▲
not_null

📃 Summary: Sample size for the measure (empty in data)

measure_score
▲
not_null

📃 Summary: Score for the quality measure (empty in data)

has_emergency_service
▲
not_null

📃 Summary: Indicates if emergency services are available

Cocoon Cleaning Summary 🤗


📃 1. Table Summary


The table is about hospital data. It includes details like provider number, name, address, and contact information. The table also contains information about the hospital's type, ownership, and emergency services. It lists various surgical infection prevention measures and their scores. Each row represents a different measure for the same hospital.


📊 2. Column Rename


😎 14 columns have been renamed
Column Summary New Column Name Renamed?
0 index Unique identifier for each row row_id ✔️ Yes
1 provider_number Unique identifier for the hospital provider_id ✔️ Yes
2 name Name of the hospital hospital_name ✔️ Yes
3 address_1 First line of hospital address street_address ✔️ Yes
4 address_2 Second line of hospital address address_2 ❌ No
5 address_3 Third line of hospital address address_3 ❌ No
6 city City where the hospital is located city ❌ No
7 state State where the hospital is located state ❌ No
8 zip ZIP code of the hospital zip_code ✔️ Yes
9 county County where the hospital is located county ❌ No
10 phone Hospital's phone number phone_number ✔️ Yes
11 type Type of hospital hospital_type ✔️ Yes
12 owner Type of hospital ownership ownership_type ✔️ Yes
13 emergency_service Indicates if emergency services are available has_emergency_service ✔️ Yes
14 condition Type of medical condition or treatment treatment_category ✔️ Yes
15 measure_code Code for specific quality measure measure_code ❌ No
16 measure_name Description of the quality measure measure_description ✔️ Yes
17 score Score for the quality measure (empty in data) measure_score ✔️ Yes
18 sample Sample size for the measure (empty in data) sample_size ✔️ Yes
19 state_average State average for the measure state_average_code ✔️ Yes



🚧 3. Erroneous Values


🔍 17 columns have erroneous values
  1. provider_id: '1xx32', '100x4', 'x0005' are unusual due to 'x' placeholders. '10086' and '20017' have different lengths than most others.
    ✔️ The column has been cleaned:
    Original Value Cleaned Value
    0 1xx32 10032
    1 100x4 10004
    2 x0005 10005
    3 1000x 10000
    4 1003x 10030
    5 1004x 10040
    6 100x5 10005
    7 100x6 10006
    8 100x8 10008
    9 100x9 10009
    10 1xx15 10015
    11 1xx16 10016
    12 1xx19 10019
    13 1xx24 10024
    14 1xx29 10029
    15 1xx35 10035
    16 1xx36 10036
    17 1xx39 10039
    18 1xx44 10044
    19 1xx45 10045
    20 1xx47 10047
    21 x0027 10027
    22 x0029 10029
    23 x0045 10045
    24 x00x5 10005
    25 x00xx
    26 x0x08 10008

  2. hospital_name: Entries like 'andaluxia regional hoxpital' and 'xivexview xegional medical centex' contain typos and character replacements, indicating data quality issues.
    ✔️ The column has been cleaned:
    Original Value Cleaned Value
    0 andaluxia regional hoxpital andalusia regional hospital
    1 andaxusia regionax hospitax andalusia regional hospital
    2 baptist medical cexter south baptist medical center south
    3 communitx hospital inc community hospital inc
    4 communixy hospixal inc community hospital inc
    5 crenshaw cxmmunity hxspital crenshaw community hospital
    6 xivexview xegional medical centex riverview regional medical center
    7 cullmxn regionxl medicxl center cullman regional medical center
    8 dexalb regional medical center dekalb regional medical center
    9 floxers hospital flowers hospital
    10 georgiaxa hospital georgia hospital
    11 huntsvxlle hospxtal huntsville hospital
    12 jaxkson hospital & xlinix inx jackson hospital & clinic inc
    13 marshall medical cenxer norxh marshall medical center north
    14 medixal xenter enterprise medical center enterprise
    15 medxcal center enterprxse medical center enterprise
    16 rivxrvixw rxgional mxdical cxntxr riverview regional medical center
    17 southeast alabama medxcal center southeast alabama medical center
    18 st vincents bxount st vincents blount
    19 univ ox south alabama medical center univ of south alabama medical center
    20 wedowee hosxital wedowee hospital
    21 xlxskx regionxl hospitxl alaska regional hospital
    22 xniv of soxth alabama medical center univ of south alabama medical center

  3. street_address: Addresses like '1000 fixst stxeet noxth' and '124xsxmemorialxdr' contain typos and unusual character substitutions, likely representing data entry errors.
    ✔️ The column has been cleaned:
    Original Value Cleaned Value
    0 1000 fixst stxeet noxth 1000 first street north
    1 124xsxmemorialxdr 124 s memorial dr
    2 1256 military street sxuth 1256 military street south
    3 126xhospitalxave 126 hospital ave
    4 150 gilxreath drive 150 gilbreath drive
    5 124 s mxmorial dr 124 s memorial dr
    6 1530xuxsxhighwayx43 1530 U.S. Highway 43
    7 1720 univxrsity blvd 1720 University Blvd
    8 1912xalabamaxhighwayx157 1912 Alabama Highway 157
    9 1x6 hospital ave 106 Hospital Ave
    10 201 pine sxreex norxhwesx 201 Pine Street Northwest
    11 209 xorth maix street 209 North Main Street
    12 2505xuxsxhighwayx431xnorth 2505 U.S. Highway 431 North
    13 301 east 1xth st 301 East 18th St
    14 301xeastx18thxst 301 East 18th St
    15 315 w hickxry st 315 W Hickory St
    16 315xwxhickoryxst 315 W Hickory St
    17 33700 highway x3 33700 Highway 43
    18 33700 hxghway 43 33700 Highway 43
    19 400xnxedwardsxstreet 400 N Edwards Street
    20 4370xwestxmainxstreet 4370 West Main Street
    21 515 miranda sx 515 Miranda St
    22 515 miranxa st 515 Miranda St
    23 515 mirxndx st 515 Miranda St
    24 600 souxh xhird sxreex 600 South Third Street
    25 702 x maix st 702 N Main St
    26 702xnxmainxst 702 N Main St
    27 8000 alabama xigxway 69 8000 Alabama Highway 69
    28 810 st vxncents drxve 810 St Vincents Drive
    29 po box 287 PO Box 287
    30 poxboxx287 PO Box 287
    31 x0x0 lay dam road 1010 Lay Dam Road

  4. city: Entries like 'birminghxm', 'anchoraxe', and 'xntxrprisx' are unusual because they contain 'x' in place of correct letters.
    ✔️ The column has been cleaned:
    Original Value Cleaned Value
    0 anchoraxe anchorage
    1 andaluxia andalusia
    2 annxston anniston
    3 axxistox anniston
    4 birminghxm birmingham
    5 birmingxam birmingham
    6 birminxham birmingham
    7 birmixgham birmingham
    8 boxz boaz
    9 bxrmxngham birmingham
    10 cuxxman cullman
    11 xntxrprisx enterprise
    12 enterprxse enterprise
    13 exba elba
    14 faxette fayette
    15 florxncx florence
    16 flxrence florence
    17 fort payxe fort payne
    18 fxorence florence
    19 geoxgiana georgiana
    20 guntxrsvillx guntersville
    21 gxdsden gadsden
    22 hamilxon hamilton
    23 montxomery montgomery
    24 onxonta oneonta
    25 ozarx ozark
    26 sheffxeld sheffield
    27 tallaxxee tallassee
    28 vallex valley
    29 vxlley valley
    30 winfielx winfield
    31 wxdowxx woodville
    32 xzark ozark

  5. state: 'xl' and 'ax' are unusual because they are not standard US state abbreviations.
    ✔️ The column has been cleaned:
    Original Value Cleaned Value
    0 xl
    1 ax

  6. zip_code: Values like '3x640', 'x5957', and '3x23x' are unusual because they contain 'x' characters, which are not standard in zip codes.
    ✔️ The column has been cleaned:
    Original Value Cleaned Value
    0 3563x 35630
    1 3x640 35640
    2 3xx94 35994
    3 3590x 35901
    4 3595x 35957
    5 359x8 35968
    6 360x9 36009
    7 3642x 36420
    8 36x01 36001
    9 36x49 36049
    10 36x78 36078
    11 3x007 30007
    12 3x0x7 30007
    13 3x10x 31000
    14 3x1x0 31000
    15 3x233 32330
    16 3x23x 32300
    17 3x305 33050
    18 x5007 05007
    19 x5150 05150
    20 x52xx 05200
    21 x590x 05900
    22 x5957 05957
    23 x5960 05960
    24 x6784 06784
    25 x6x05 06005
    26 x6x60 06060

  7. county: chxrokxx, cxllman, dx kalb are unusual misspellings. jexxerson, jxffxrson, xefferson are inconsistent representations of Jefferson county.
    ✔️ The column has been cleaned:
    Original Value Cleaned Value
    0 chxrokxx cherokee
    1 cxllman cullman
    2 dx kalb de kalb
    3 jexxerson jefferson
    4 jxffxrson jefferson
    5 xefferson jefferson
    6 monxgomery montgomery
    7 xe kalb de kalb
    8 butxer butler
    9 calhoxn calhoun
    10 caxhoun calhoun
    11 chaxbers chambers
    12 coffxx coffee
    13 coxington covington
    14 crxnshaw crenshaw
    15 cxffee coffee
    16 elmoxe elmore
    17 elxore elmore
    18 etowxh etowah
    19 fayexxe fayette
    20 housxon houston
    21 jeffersxn jefferson
    22 laudexdale lauderdale
    23 laudxrdalx lauderdale
    24 madisox madison
    25 madisxn madison
    26 montgomexy montgomery
    27 mxrshxll marshall
    28 tallaxega talladega
    29 xee lee
    30 xhambers chambers
    31 xlarke clarke

  8. phone_number: Entries like '25x47x7xx0', '2x6x938310', '3342938xxx' are unusual because they contain 'x' characters, likely representing redacted digits.
    ✔️ The column has been cleaned:
    Original Value Cleaned Value
    0 25x47x7xx0 2564777000
    1 2x6x938310 2565938310
    2 3342938xxx 3342938000
    3 2058x8x122 2058383122
    4 20593xx011 2059344011
    5 x0593x5966 2059325966
    6 20x9216200 2009216200
    7 256235x900 2562350900
    8 2564944xxx 2564944000
    9 2565x38310 2565038310
    10 2568453x50 2568453050
    11 33422284xx 3342228400
    12 3342xx2100 3342002100
    13 3344x33541 3344033541
    14 334774x601 3347740601
    15 334793870x 3347938700
    16 334x3xx221 3340300221
    17 334x561400 3340561400
    18 334x836541 3340836541
    19 334xxx8466 3340008466
    20 33x28365x1 3302836501
    21 33x2938000 3302938000
    22 33x361x267 3303610267
    23 33x8972257 3308972257
    24 x059x16x00 0059016000
    25 x565435x00 0565435000
    26 xx46x66221 0046066221
    27 xx479x5000 0047905000
    28 xx479x8701 0047908701

  9. hospital_type: All values except 'acute care hospitals' are unusual due to typos and inconsistent spellings of the same concept.
    ✔️ The column has been cleaned:
    Original Value Cleaned Value
    0 acuxe care hospixals acute care hospitals
    1 acutexcarexhospitals acute care hospitals
    2 acute care hosxitals acute care hospitals
    3 acute care hospitaxs acute care hospitals
    4 acute caxe hospitals acute care hospitals
    5 acutx carx hospitals acute care hospitals
    6 acute care hoxpitalx acute care hospitals
    7 acute care hxspitals acute care hospitals
    8 acute cxre hospitxls acute care hospitals
    9 acute xare hospitals acute care hospitals
    10 acxte care hospitals acute care hospitals
    11 axute care hospitals acute care hospitals

  10. ownership_type: Misspellings like 'proxrietary', 'pxopxietaxy', and 'voxuntary' are unusual. Inconsistent representations like 'government' and 'gxvernment' exist.
    ✔️ The column has been cleaned:
    Original Value Cleaned Value
    0 proxrietary proprietary
    1 prxprietary proprietary
    2 gxvernment - hxspital district xr authxrity government - hospital district or authority
    3 pxopxietaxy proprietary
    4 voluntaxy non-pxofit - pxivate voluntary non-profit - private
    5 volunxary non-profix - privaxe voluntary non-profit - private
    6 government - hospital xistrict or authority government - hospital district or authority
    7 government - hospxtal dxstrxct or authorxty government - hospital district or authority
    8 governmenx - hospixal disxricx or auxhorixy government - hospital district or authority
    9 governxent - federal government - federal
    10 goverxmext - hospital district or authority government - hospital district or authority
    11 voluntary non-profit - otxer voluntary non-profit - other
    12 voluntary nonxprofit x private voluntary non-profit - private
    13 voluntaryxnon-profitx-xchurch voluntary non-profit - church
    14 voluntaryxnon-profitx-xprivate voluntary non-profit - private
    15 voluxtary xox-profit - private voluntary non-profit - private
    16 volxntary non-profit - chxrch voluntary non-profit - church
    17 voxuntary non-profit - church voluntary non-profit - church
    18 xroprietary proprietary

  11. has_emergency_service: 'yxs', 'yex', 'xes', 'xo' are unusual because they appear to be typos or inconsistent representations of 'yes' and 'no'.
    ✔️ The column has been cleaned:
    Original Value Cleaned Value
    0 yxs yes
    1 yex yes
    2 xes yes
    3 xo no

  12. treatment_category: Values like 'heart attaxk', 'hexrt attxck', 'hearx axxack' are unusual because they're misspellings of 'heart attack'.
    ✔️ The column has been cleaned:
    Original Value Cleaned Value
    0 heart attaxk heart attack
    1 hexrt attxck heart attack
    2 hearx axxack heart attack
    3 hxart failurx heart failure
    4 surgical ixfectiox prevextiox surgical infection prevention
    5 suxgical infection pxevention surgical infection prevention
    6 xneumonia pneumonia
    7 heart faixure heart failure
    8 heart faxlure heart failure
    9 heartxattack heart attack
    10 heaxt attack heart attack
    11 heaxt failuxe heart failure
    12 hexrt fxilure heart failure
    13 pneumonix pneumonia
    14 pneumonxa pneumonia
    15 pnexmonia pneumonia
    16 pnxumonia pneumonia
    17 pxeumoxia pneumonia
    18 surgical infection xrevention surgical infection prevention
    19 surgical infxction prxvxntion surgical infection prevention
    20 surgical xnfection prevention surgical infection prevention
    21 surgxcal infectxon preventxon surgical infection prevention
    22 xeart failure heart failure

  13. measure_code: Values like 'amix1', 'amx-3', 'pnx5c', 'scipxinfx1', 'scxp-xnf-3' are unusual due to inconsistent formatting or potential typos.
    ✔️ The column has been cleaned:
    Original Value Cleaned Value
    0 amix1 ami-1
    1 amix2 ami-2
    2 amx-3 ami-3
    3 amx-4 ami-4
    4 ami-x ami-1
    5 axi-2 ami-2
    6 axi-4 ami-4
    7 hfx1 hf-1
    8 hfx4 hf-4
    9 hf-x hf-1
    10 hx-1 hf-1
    11 hx-2 hf-2
    12 pn-x pn-1
    13 pn-xb pn-3b
    14 pnx5c pn-5c
    15 pnx6 pn-6
    16 px-4 pn-4
    17 px-5c pn-5c
    18 scip-inx-4 scip-inf-4
    19 scip-vtx-1 scip-vte-1
    20 scipxinfx1 scip-inf-1
    21 scix-inf-2 scip-inf-2

  14. measure_description: Many entries have 'x' substituted for various letters, like 'heaxt' for 'heart'. Some have spaces removed or replaced with 'x'.
    ✔️ The column has been cleaned:
    Original Value Cleaned Value
    0 all heart surgerx patients whose blood sugar (blood glucose) is kept under good control in the daxs right after surgerx all heart surgery patients whose blood sugar (blood glucose) is kept under good control in the days right after surgery
    1 all heaxt suxgexy patients whose blood sugax (blood glucose) is kept undex good contxol in the days xight aftex suxgexy all heart surgery patients whose blood sugar (blood glucose) is kept under good control in the days right after surgery
    2 allxheartxsurgeryxpatientsxwhosexbloodxsugarx(bloodxglucose)xisxkeptxunderxgoodxcontrolxinxthexdaysxrightxafterxsurgery all heart surgery patients whose blood sugar (blood glucose) is kept under good control in the days right after surgery
    3 childrenxwhoxreceivedxrelieverxmedicationxwhilexhospitalizedxforxasthma children who received reliever medication while hospitalized for asthma
    4 heart attack patients given aspirin at arrivax heart attack patients given aspirin at arrival
    5 heart attack patxents gxven aspxrxn at arrxval heart attack patients given aspirin at arrival
    6 heart attaxk patients given aspirin at disxharge heart attack patients given aspirin at discharge
    7 heart failure patients given ace inhibitor or arb for left xentricular systolic dysfunction (lxsd) heart failure patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd)
    8 heart faxlure patxents gxven ace inhxbxtor or arb for left ventrxcular systolxc dysfunctxon (lvsd) heart failure patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd)
    9 heart faxlure patxents gxven smokxng cessatxon advxce/counselxng heart failure patients given smoking cessation advice/counseling
    10 heart xailure patients given smoking cessation advice/counseling heart failure patients given smoking cessation advice/counseling
    11 heartxattackxpatientsxgivenxaspirinxatxarrival heart attack patients given aspirin at arrival
    12 heartxattackxpatientsxgivenxpcixwithinx90xminutesxofxarrival heart attack patients given pci within 90 minutes of arrival
    13 hearx failure paxienxs given smoking cessaxion advice/counseling heart failure patients given smoking cessation advice/counseling
    14 heaxt attack patients given aspixin at dischaxge heart attack patients given aspirin at discharge
    15 heaxt attack patients given beta blockex at dischaxge heart attack patients given beta blocker at discharge
    16 heaxt failuxe patients given an evaluation of left ventxiculax systolic (lvs) function heart failure patients given an evaluation of left ventricular systolic (lvs) function
    17 heaxt failuxe patients given dischaxge instxuctions heart failure patients given discharge instructions
    18 hexrt attxck pxtients given aspirin xt arrivxl heart attack patients given aspirin at arrival
    19 hxart attack patixnts givxn ace inhibitor or arb for lxft vxntricular systolic dysfunction (lvsd) heart attack patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd)
    20 pneumonia patients assessed and given influenza vaxxination pneumonia patients assessed and given influenza vaccination
    21 pneumoniaxpatientsxassessedxandxgivenxinfluenzaxvaccination pneumonia patients assessed and given influenza vaccination
    22 pneumonix pxtients assessed xnd given influenzx vxccinxtion pneumonix pxtients xssessed xnd given influenzx vxccinxtion
    23 pneumonix pxtients given initixl antibiotic(s) within 6 hours after arrivxl pneumonix pxtients given initixl xntibiotic(s) within 6 hours xfter xrrivxl
    24 pneumonxa patxents whose inxtxal emergency room blood culture was performed prxor to the admxnxstratxon of the fxrst hospxtal dose of antxbxotxcs pneumonix pxtients whose initixl emergency room blood culture wxs performed prior to the xdministrxtion of the first hospitxl dose of xntibiotics
    25 pnxumonia patixnts whosx initial emxrgxncy room blood culturx was pxrformxd prior to thx administration of thx first hospital dosx of antibiotics pneumonix pxtients whose initixl emergency room blood culture wxs performed prior to the xdministrxtion of the first hospitxl dose of xntibiotics
    26 pxeumoxia patiexts assessed axd givex ixfluexza vaccixatiox pneumonix pxtients xssessed xnd given influenzx vxccinxtion
    27 pxeumoxia patiexts givex ixitial axtibiotic(s) withix 6 hours after arrival pneumonix pxtients given initixl xntibiotic(s) within 6 hours xfter xrrivxl
    28 pxeumoxia patiexts givex the most appropriate ixitial axtibiotic(s) pneumonix pxtients given the most xpproprixte initixl xntibiotic(s)
    29 surgery patients who were taking heart drugs caxxed beta bxockers before coming to the hospitax who were kept on the beta bxockers during the period just before and after their surgery surgery pxtients who were txking hexrt drugs cxlled betx blockers before coming to the hospitxl who were kept on the betx blockers during the period just before xnd xfter their surgery
    30 surgery patiexts who were takixg heart drugs called beta blockers before comixg to the hospital who were kept ox the beta blockers durixg the period just before axd after their surgery surgery pxtients who were txking hexrt drugs cxlled betx blockers before coming to the hospitxl who were kept on the betx blockers during the period just before xnd xfter their surgery
    31 surgery paxienxs needing hair removed from xhe surgical area before surgery who had hair removed using a safer mexhod (elecxric clippers or hair removal cream c nox a razor) surgery pxtients needing hxir removed from the surgicxl xrex before surgery who hxd hxir removed using x sxfer method (electric clippers or hxir removxl crexm - not x rxzor)
    32 surgeryxpatientsxneedingxhairxremovedxfromxthexsurgicalxareaxbeforexsurgery& xwhoxhadxhairxremovedxusingxaxsaferxmethodx(electricxclippersxorxhairxremovalxcreamx�cxnotxaxrazor) surgery pxtients needing hxir removed from the surgicxl xrex before surgery who hxd hxir removed using x sxfer method (electric clippers or hxir removxl crexm - not x rxzor)
    33 xeart attack patients given aspirin at arrival hexrt xttxck pxtients given xspirin xt xrrivxl

  15. measure_score: '1xx%', 'x5%', '80x', 'empty' are unusual due to non-numeric characters or inconsistent formatting for percentages.
    ✔️ The column has been cleaned:
    Original Value Cleaned Value
    0 1xx% 100%
    1 x5% 85%
    2 x7% 87%
    3 9x% 90%
    4 x00% 100%
    5 xx%
    6 80x 80%
    7 empty
    8 89x 89%
    9 93x 93%
    10 95x 95%
    11 x3% 43%
    12 x4% 44%
    13 x6% 46%

  16. sample_size: Entries like '0 patixnts', '25x patients', 'xx patients', '6xpatients' contain typos or non-numeric characters. Some use 'x' instead of numbers.
    ✔️ The column has been cleaned:
    Original Value Cleaned Value
    0 0 patixnts 0 patients
    1 25x patients 25 patients
    2 xx patients empty
    3 6xpatients 6 patients
    4 x patients
    5 0 patxents 0 patients
    6 1 patiexts 1 patients
    7 121 patiexts 121 patients
    8 125 patixnts 125 patients
    9 126 patxents 126 patients
    10 15 patiexts 15 patients
    11 172 patxents 172 patients
    12 193 paxienxs 193 patients
    13 1x patients
    14 21 pxtients 21 patients
    15 27 paxienxs 27 patients
    16 29 xatients 29 patients
    17 3x patients
    18 4 patiexts 4 patients
    19 4 xatients 4 patients
    20 44 paxienxs 44 patients
    21 50 pxtients 50 patients
    22 521 patiexts 521 patients
    23 618 xatients 618 patients
    24 619 paxienxs 619 patients
    25 62 patientx 62 patients
    26 74 patxents 74 patients
    27 82 patientx 82 patients
    28 87 patientx 87 patients
    29 87 paxienxs 87 patients

  17. state_average_code: 'al_', 'ak_', 'ax_', 'xl_', 'alx' prefixes are inconsistent. 'x' insertions like 'amx', 'hx', 'pnx' likely typos.
    ✔️ The column has been cleaned:
    Original Value Cleaned Value
    0 ax_ami-1 ak_ami-1
    1 ax_ami-2 ak_ami-2
    2 ax_hf-1 ak_hf-1
    3 ax_hf-2 ak_hf-2
    4 ax_hf-3 ak_hf-3
    5 ax_hf-4 ak_hf-4
    6 ax_pn-2 ak_pn-2
    7 ax_pn-3b ak_pn-3b
    8 ax_pn-4 ak_pn-4
    9 ax_pn-5c ak_pn-5c
    10 ax_pn-6 ak_pn-6
    11 ax_pn-7 ak_pn-7
    12 ax_scip-card-2 ak_scip-card-2
    13 ax_scip-inf-1 ak_scip-inf-1
    14 ax_scip-inf-2 ak_scip-inf-2
    15 ax_scip-inf-3 ak_scip-inf-3
    16 ax_scip-inf-4 ak_scip-inf-4
    17 ax_scip-inf-6 ak_scip-inf-6
    18 ax_scip-vte-1 ak_scip-vte-1
    19 ax_scip-vte-2 ak_scip-vte-2
    20 al_amix8a al_ami-8a
    21 al_sxip-inf-2 al_scip-inf-2
    22 al_amx-1 al_am-1
    23 al_amx-7a al_am-7a
    24 al_axi-1 al_am-1
    25 al_hf-x al_hf-1
    26 al_hx-2 al_h-2
    27 al_pn-5x al_pn-5
    28 al_pn-xb al_pn-1b
    29 al_pnx2 al_pn-2
    30 al_pnx6 al_pn-6
    31 al_scipxinfx2 al_scip-inf-2
    32 al_scipxvtex1 al_scip-vte-1
    33 al_scipxvtex2 al_scip-vte-2
    34 al_scix-vte-1 al_scip-vte-1
    35 al_scix-vte-2 al_scip-vte-2
    36 alxami-7a al_am-7a
    37 alxpn-3b al_pn-3b
    38 alxpn-6 al_pn-6
    39 alxpn-7 al_pn-7
    40 xl_scip-inf-2 al_scip-inf-2
    41 xl_xmi-1 al_am-1
    42 xl_xmi-2 al_am-2
    43 xl_xmi-5 al_am-5


🕵️‍♂️ 4. Disguised Missing Values


🔍 3 columns have disguised missing values
✔️ 3 columns have been cleaned
Column Disguised Missing Values Impute to NULL? Values to NULL (Sep By ,)
0 address_2 [empty] True empty
1 address_3 [empty] True empty
2 sample_size [empty] True empty



🔧 5. Data Type


✔️ 3 columns have been casted
Column Name Clause Reasoning
0 sample_size CAST(REGEXP_EXTRACT("sample_size", '(\d+)') AS INT) To transform the 'sample_size' column from VARCHAR to INT, we need to extract the numeric part from the string. The current values follow the pattern '\d+ patients', where we only need the numeric part. We can use REGEXP_EXTRACT to extract the number, and then cast it to INT.\n
1 measure_score CAST(REPLACE("measure_score", '%', '') AS INT) To transform the 'measure_score' column from VARCHAR to INT, we need to remove the percentage sign and cast the remaining numeric value to an integer. Since the values are whole numbers, we don't need to use REGEXP_EXTRACT. We can simply use the REPLACE function to remove the '%' character and then cast the result to INT.\n
2 has_emergency_service CAST(\n CASE \n WHEN "has_emergency_service" = 'yes' THEN TRUE\n WHEN "has_emergency_service" = 'no' THEN FALSE\n ELSE NULL\n END AS BOOLEAN\n) To transform the 'has_emergency_service' column from VARCHAR to BOOLEAN in DuckDB, we need to use a CAST function. Since the only distinct value in the column is 'yes', we can directly cast it to BOOLEAN. In DuckDB, the string 'yes' is automatically interpreted as TRUE when casting to BOOLEAN. Any other value (which doesn't exist in this case) would be interpreted as FALSE.\n



🔗 6. Functional Dependencies


🔍 16 functional dependencies found
  1. street_address determines:
    state:
    street_address state
    0 2505 u s highway 431 north al
    1 200 med center drive al
    2 1000 first street north al
    3 1530 u s highway 43 al
    4 987 drayton street al
    5 101 sivley rd al
    6 1108 ross clark circle al
    7 702 n main st al
    8 2451 fillingim street al
    9 126 hospital ave al
    10 205 marengo street al
    11 8000 alabama highway 69 al
    12 400 northwood dr al
    13 4800 48th st al
    14 849 south three notch street al
    15 101 hospital circle al
    16 201 pine street northwest al
    17 124 s memorial dr al
    18 1725 pine street al
    19 805 friendship road al
    20 1653 temple avenue north al
    21 600 south third street al

    city:
    street_address city
    0 209 north main street wedowee

    phone_number:
    street_address phone_number
    0 1108 ross clark circle 3347938701
    1 702 n main st 3344933541
    2 301 east 18th st 2562358900
    3 2451 fillingim street 2514717110
    4 126 hospital ave 3347742601
    5 1256 military street south 2059216200
    6 33700 highway 43 3346366221
    7 4800 48th st 3347561400
    8 849 south three notch street 3342228466
    9 4370 west main street 3347935000
    10 124 s memorial dr 3343614267
    11 2105 east south boulevard 3342882100
    12 1725 pine street 3342938000
    13 805 friendship road 3342836541
    14 600 south third street 2565435200
    15 2505 u s highway 431 north 2565938310
    16 200 med center drive 2568453150
    17 987 drayton street 3348972257

    provider_id:
    street_address provider_id
    0 205 marengo street 10006
    1 33700 highway 43 10015
    2 1530 u s highway 43 10086
    3 101 sivley rd 10039
    4 124 s memorial dr 10108
    5 805 friendship road 10034
    6 1912 alabama highway 157 10035
    7 400 n edwards street 10049
    8 50 medical park east drive 10011
    9 301 east 18th st 10038

    zip_code:
    street_address zip_code
    0 2505 u s highway 431 north 35957
    1 1000 first street north 35007
    2 1530 u s highway 43 35594
    3 315 w hickory st 35150
    4 50 medical park east drive 35235
    5 301 east 18th st 36201
    6 126 hospital ave 36360
    7 619 south 19th street 35233
    8 205 marengo street 35631
    9 33700 highway 43 36784
    10 400 northwood dr 35960
    11 1007 goodyear avenue 35903
    12 101 hospital circle 36049
    13 4370 west main street 36305
    14 124 s memorial dr 36067
    15 1725 pine street 36106

    hospital_name:
    street_address hospital_name
    0 600 south third street riverview regional medical center
    1 515 miranda st georgiana hospital

    Explanation: For each value in 'street_address', there possibly is a unique value in all the listed columns. This is because the table appears to contain information about individual hospitals, where each hospital would have a unique combination of address, contact details, and other characteristics. The 'street_address' is likely to be unique for each hospital, and the other details associated with that address (such as name, city, state, phone number, etc.) would be specific to that hospital. The surgical infection prevention measures and their scores are listed in separate rows for the same hospital, so they don't affect the one-to-one relationship between 'street_address' and the other hospital details.
  2. treatment_category determines:
    state:
    treatment_category state
    0 pneumonia al
    1 heart attack al
    2 surgical infection prevention al
    3 heart failure al

    has_emergency_service:
    treatment_category has_emergency_service
    0 heart attack yes
    1 surgical infection prevention yes
    2 pneumonia yes
    3 heart failure yes

    Explanation: For each value in 'treatment_category', there possibly is a unique value in 'address_2', 'address_3', 'state', 'has_emergency_service', and 'hospital_type'. This is because the table structure suggests that each row represents a different measure for the same hospital. Therefore, the hospital's basic information (address, type, emergency services) would remain constant across all rows for that particular hospital. Each 'treatment_category' would correspond to a specific hospital, and that hospital would have unique values for these fields.
  3. measure_description determines:
    measure_code:
    measure_description measure_code
    0 surgery patients whose preventive antibiotics were stopped at the right time (within 24 hours after surgery) scip-inf-3
    1 children who received reliever medication while hospitalized for asthma cac-1
    2 pneumonia patients assessed and given pneumococcal vaccination pn-2
    3 surgery patients whose doctors ordered treatments to prevent blood clots after certain types of surgeries scip-vte-1
    4 heart failure patients given discharge instructions hf-1
    5 heart failure patients given an evaluation of left ventricular systolic (lvs) function hf-2
    6 heart attack patients given beta blocker at discharge ami-5

    state_average_code:
    measure_description state_average_code
    0 surgery patients whose doctors ordered treatments to prevent blood clots after certain types of surgeries al_scip-vte-1
    1 heart attack patients given aspirin at arrival al_ami-1
    2 heart failure patients given discharge instructions al_hf-1
    3 heart failure patients given an evaluation of left ventricular systolic (lvs) function al_hf-2
    4 heart failure patients given ace inhibitor or arb for left ventricular systolic dysfunction (lvsd) al_hf-3
    5 heart failure patients given smoking cessation advice/counseling al_hf-4
    6 pneumonia patients given smoking cessation advice/counseling al_pn-4
    7 pneumonia patients assessed and given influenza vaccination al_pn-7
    8 surgery patients whose preventive antibiotics were stopped at the right time (within 24 hours after surgery) al_scip-inf-3
    9 pneumonia patients whose initial emergency room blood culture was performed prior to the administration of the first hospital dose of antibiotics al_pn-3b
    10 surgery patients who were taking heart drugs called beta blockers before coming to the hospital who were kept on the beta blockers during the period just before and after their surgery al_scip-card-2
    11 surgery pxtients needing hxir removed from the surgicxl xrex before surgery who hxd hxir removed using x sxfer method (electric clippers or hxir removxl crexm - not x rxzor) ak_scip-inf-6
    12 all heart surgery patients whose blood sugar (blood glucose) is kept under good control in the days right after surgery al_scip-inf-4
    13 patients who got treatment at the right time (within 24 hours before or after their surgery) to help prevent blood clots after certain types of surgery al_scip-vte-2
    14 heart attack patients given fibrinolytic medication within 30 minutes of arrival al_ami-7a
    15 pneumonia patients assessed and given pneumococcal vaccination al_pn-2
    16 pneumonia patients given initial antibiotic(s) within 6 hours after arrival al_pn-5c
    17 surgery patients who were given an antibiotic at the right time (within one hour before surgery) to help prevent infection al_scip-inf-1
    18 surgery patients who were given the right kind of antibiotic to help prevent infection al_scip-inf-2
    19 heart attack patients given aspirin at discharge al_ami-2
    20 heart attack patients given beta blocker at discharge al_ami-5
    21 pneumonia patients given the most appropriate initial antibiotic(s) al_pn-6

    Explanation: For each value in 'measure_description', there possibly is a unique value in 'address_2', 'address_3', 'state', 'treatment_category', 'measure_code', 'state_average_code', 'has_emergency_service', and 'hospital_type'. This is because the table represents different measures for the same hospital, so the hospital-specific information (address, type, emergency services) and the measure-specific information (treatment category, measure code, state average code) would remain constant for each measure description.
  4. county determines:
    provider_id:
    county provider_id
    0 jefferson 10018
    1 montgomery 10023
    2 marshall 10005
    3 morgan 10009
    4 etowah 10046
    5 marion 10086
    6 coffee 10027
    7 houston 10001
    8 covington 10007

    hospital_name:
    county hospital_name
    0 jefferson callahan eye foundation hospital
    1 montgomery baptist medical center south
    2 houston southeast alabama medical center
    3 covington mizell memorial hospital
    4 marion northwest medical center
    5 coffee elba general hospital
    6 marshall marshall medical center south
    7 morgan hartselle medical center
    8 etowah riverview regional medical center

    Explanation: For each value in 'county', there possibly is a unique value in provider_id and hospital_name. This is because typically, each hospital (which would have a unique provider_id and name) is located in a single county. However, the other attributes like address, city, zip_code, phone_number, has_emergency_service, ownership_type, and hospital_type are not guaranteed to be unique for each county. Multiple hospitals in the same county could share these attributes.
  5. measure_code determines:
    measure_description:
    measure_code measure_description
    0 scip-inf-6 surgery patients needing hair removed from the surgical area before surgery who had hair removed using a safer method (electric clippers or hair removal cream c not a razor)
    1 scip-vte-1 surgery patients whose doctors ordered treatments to prevent blood clots after certain types of surgeries
    2 pn-5c pneumonia patients given initial antibiotic(s) within 6 hours after arrival
    3 scip-card-2 surgery patients who were taking heart drugs called beta blockers before coming to the hospital who were kept on the beta blockers during the period just before and after their surgery
    4 pn-6 pneumonia patients given the most appropriate initial antibiotic(s)
    5 pn-7 pneumonia patients assessed and given influenza vaccination
    6 ami-1 heart attack patients given aspirin at arrival
    7 pn-3b pneumonia patients whose initial emergency room blood culture was performed prior to the administration of the first hospital dose of antibiotics

    state_average_code:
    measure_code state_average_code
    0 scip-inf-6 al_scip-inf-6

    Explanation: For each value in 'measure_code', there possibly is a unique value in address_2, address_3, state, treatment_category, measure_description, state_average_code, has_emergency_service, and hospital_type. This is because these attributes are likely to be consistent for a given hospital across different measures. Each 'measure_code' represents a different surgical infection prevention measure for the same hospital, so the hospital's basic information (address, type, emergency services) and the measure's description and category would remain the same for that specific measure code.
  6. city determines:
    street_address:
    city street_address
    0 opp 702 n main st
    1 anniston 301 east 18th st
    2 montgomery 2105 east south boulevard
    3 georgiana 515 miranda st
    4 birmingham 50 medical park east drive
    5 thomasville 33700 highway 43
    6 sylacauga 315 w hickory st
    7 wedowee 209 north main street
    8 gadsden 600 south third street
    9 dothan 1108 ross clark circle
    10 hartselle 201 pine street northwest
    11 cullman 1912 alabama highway 157
    12 boaz 2505 u s highway 431 north
    13 guntersville 8000 alabama highway 69
    14 winfield 1530 u s highway 43
    15 ozark 126 hospital ave
    16 clanton 1010 lay dam road
    17 enterprise 400 n edwards street

    zip_code:
    city zip_code
    0 dothan 36302
    1 montgomery 36116
    2 birmingham 35233
    3 gadsden 35901

    phone_number:
    city phone_number
    0 dothan 3347938701
    1 montgomery 3342882100
    2 birmingham 2053258100
    3 gadsden 2565435200

    ownership_type:
    city ownership_type
    0 montgomery voluntary non-profit - church
    1 birmingham voluntary non-profit - private
    2 dothan government - hospital district or authority

    Explanation: For each value in 'city', there possibly is a unique value in provider_id, hospital_name, street_address, address_2, address_3, county, state, zip_code, phone_number, hospital_type, ownership_type, and has_emergency_service. This is because these attributes are typically specific to a single hospital location. Each hospital in a city would have its own unique provider ID, name, full address, contact information, type, ownership, and emergency service status. However, it's important to note that while this is likely, it's not guaranteed without examining the actual data. For example, a hospital chain might have multiple locations in the same city with the same name but different addresses.
  7. provider_id determines:
    street_address:
    provider_id street_address
    0 10007 702 n main st
    1 10005 2505 u s highway 431 north
    2 10086 1530 u s highway 43
    3 10018 50 medical park east drive
    4 10009 201 pine street northwest
    5 10027 987 drayton street

    city:
    provider_id city
    0 10018 birmingham
    1 10009 hartselle
    2 10005 boaz
    3 10086 winfield
    4 10007 opp
    5 10027 elba

    phone_number:
    provider_id phone_number
    0 10005 2565938310
    1 10086 2054877736
    2 10018 2053258100
    3 10009 2567736511
    4 10007 3344933541
    5 10027 3348972257

    zip_code:
    provider_id zip_code
    0 10018 35233
    1 10009 35640
    2 10005 35957
    3 10086 35594
    4 10007 36467
    5 10027 36323

    ownership_type:
    provider_id ownership_type
    0 10007 voluntary non-profit - private
    1 10086 proprietary
    2 10018 voluntary non-profit - private
    3 10009 proprietary
    4 10027 voluntary non-profit - other

    Explanation: For each value in 'provider_id', there possibly is a unique value in address_2, address_3, state, street_address, county, city, phone_number, zip_code, has_emergency_service, hospital_name, ownership_type, and hospital_type. This is because these attributes are typically constant for a given hospital, and each 'provider_id' represents a unique hospital. The data is organized such that each row represents a different measure for the same hospital, meaning these hospital-specific details would remain the same across rows with the same 'provider_id'.

❓ 7. Missing Values


🔍 4 columns have missing values
✔️ 2 of them are acceptable
Column NULL (%) Is NULL Acceptable? Explanation
0 address_2 100.0 True Secondary address line not needed for all locations.
1 address_3 100.0 True Tertiary address line not needed for all locations.
2 measure_score 16.9 False
3 sample_size 6.5 False