US Hospitals
A list of all hospitals in the United States that filed a Medicare Report
@kaggle.sirsheep_us_hospitals
Ushospitals
@kaggle.sirsheep_us_hospitals.ushospitals
- 601.69 KB
- 3856 rows
- 22 columns
n__idId | hospitalnameHospitalName | cityCity | staffedbedsStaffedBeds | totaldischargesTotalDischarges | patientdaysPatientDays | grosspateientrevenueGrossPateientRevenue | stateState | latLat | longLong | place_idPlace Id | addressAddress | phonenumberPhoneNumber | websiteWebsite | hoursintextHoursInText | mondayhoursMondayHours | tuesdayhoursTuesdayHours | wednesdayhoursWednesdayHours | thursdayhoursThursdayHours | fridayhoursFridayHours | saturdayhoursSaturdayHours | sundayhoursSundayHours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| {\$oid\":\"5e83897a1cf89410eadf2e8d\"}" | Brookwood Baptist Medical Center | Birmingham | 595 | 15775 | 76452 | 3338482 | alabama | 33.4642249 | -86.7759119 | ChIJD-egVJ8ZiYgR-IhFan1ZJoA | 2010 Brookwood Medical Center Dr, Birmingham, AL 35209, USA | (205) 877-1000 | https://www.brookwoodbaptistmedicalcenter.com/ | Open 24/7 | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) | ('0000',) |
| {\$oid\":\"5e83897a1cf89410eadf2e93\"}" | Clay County Hospital | Ashland | 129 | 1027 | 4285 | 34610 | alabama | 33.2771472 | -85.823822 | ChIJgxa4vzSRi4gR9UGGfJvUSII | 83825 AL-9, Ashland, AL 36251, USA | (256) 354-2131 | http://www.claycountyhospital.com/ | Open 24/7 | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) | ('0000',) |
| {\$oid\":\"5e83897a1cf89410eadf2ea5\"}" | Gadsden Regional Medical Center | Gadsden | 271 | 12897 | 60383 | 2549046 | alabama | 34.007668 | -85.965891 | ChIJ64m-Byg_iogRdFyCdkO3OhQ | 1007 Goodyear Ave, Gadsden, AL 35903, USA | (256) 494-4000 | https://www.gadsdenregional.com/?utm_campaign=biz-listings&utm_source=chs-web&utm_medium=gmb | Open 24/7 | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) | ('0000',) |
| {\$oid\":\"5e83897a1cf89410eadf2eba\"}" | Medical West | Bessemer | 231 | 6336 | 33095 | 603658 | alabama | 33.3551807 | -86.8558303 | ChIJ-_DrtqkhiYgRFgmyzEm8h_U | 5300 Medford Dr, Hoover, AL 35244, USA | (205) 820-8416 | http://www.medicalwesthospital.org/ | Open 24/7 | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) | ('0000',) |
| {\$oid\":\"5e83897a1cf89410eadf2ebf\"}" | North Alabama Medical Center | Florence | 233 | 12472 | 61969 | 890905 | alabama | 34.8043939 | -87.6509453 | ChIJy9_mSK5JfYgRpk3OQO6Sa_c | 1701 Veterans Dr, Florence, AL 35630, USA | (256) 629-1000 | http://www.namccares.com/ | Open 24/7 | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) | ('0000',) |
| {\$oid\":\"5e83897a1cf89410eadf2e96\"}" | Crenshaw Community Hospital | Luverne | 49 | 314 | 1323 | 37017 | alabama | 31.6936146 | -86.2647235 | ChIJDT9F1GUHjogR5JQtWedcOco | 101 Hospital Dr, Luverne, AL 36049, USA | (334) 335-3374 | http://www.crenshawcommunityhospital.com/ | Open 24/7 | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) | ('0000',) |
| {\$oid\":\"5e83897a1cf89410eadf2ea9\"}" | Hale County Hospital | Greensboro | 28 | 459 | 1483 | 17746 | alabama | 32.6955444 | -87.5869077 | ChIJiZyo0dL0hYgRWX1h7mR9eFw | 508 Green St, Greensboro, AL 36744, USA | (334) 624-3024 | http://www.halecountyhospital.com/ | nan | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) |
| {\$oid\":\"5e83897a1cf89410eadf2eac\"}" | Hill Hospital Of Sumter County | York | 33 | 435 | 5460 | 10012 | alabama | 32.4919854 | -88.2954427 | ChIJK0QDTUVQhIgRP6YrLyDSFIA | 751 Derby Dr, York, AL 36925, USA | (205) 392-5263 | http://www.hillhospitalalabama.com/ | nan | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) |
| {\$oid\":\"5e83897a1cf89410eadf2eb1\"}" | DeKalb Regional Medical Center | Fort Payne | 115 | 3207 | 11591 | 456842 | alabama | 34.4419753 | -85.7550138 | ChIJ073sL-PXYYgRmMzdA76SB3M | 200 Medical Center Dr SW, Fort Payne, AL 35968, USA | (256) 845-3150 | http://www.dekalbregional.com/dekalb-regional-medical-center/home.aspx?utm_campaign=website-link&utm_medium=organic&utm_source=local-listing | Open 24/7 | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) | ('0000',) |
| {\$oid\":\"5e83897a1cf89410eadf2ec0\"}" | North Baldwin Infirmary | Bay Minette | 70 | 1922 | 6207 | 90949 | alabama | 30.9035455 | -87.7850321 | ChIJBZ_HayKKmogRO34QFiz40wU | 1815 Hand Ave, Bay Minette, AL 36507, USA | (251) 937-5521 | https://www.infirmaryhealth.org/ | Open 24/7 | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) | (nan,) | ('0000',) |
CREATE TABLE ushospitals (
"n__id" VARCHAR,
"hospitalname" VARCHAR,
"city" VARCHAR,
"staffedbeds" BIGINT,
"totaldischarges" BIGINT,
"patientdays" BIGINT,
"grosspateientrevenue" BIGINT,
"state" VARCHAR,
"lat" DOUBLE,
"long" DOUBLE,
"place_id" VARCHAR,
"address" VARCHAR,
"phonenumber" VARCHAR,
"website" VARCHAR,
"hoursintext" VARCHAR,
"mondayhours" VARCHAR,
"tuesdayhours" VARCHAR,
"wednesdayhours" VARCHAR,
"thursdayhours" VARCHAR,
"fridayhours" VARCHAR,
"saturdayhours" VARCHAR,
"sundayhours" VARCHAR
);