US Hospitals

A list of all hospitals in the United States that filed a Medicare Report

@kaggle.sirsheep_us_hospitals

Table List

1 table(601.69 KB)

Ushospitals

@kaggle.sirsheep_us_hospitals.ushospitals

601.69 KB
3856 rows
22 columns

n__id Id	hospitalname HospitalName	city City	staffedbeds StaffedBeds	totaldischarges TotalDischarges	patientdays PatientDays	grosspateientrevenue GrossPateientRevenue	state State	lat Lat	long Long	place_id Place Id	address Address	phonenumber PhoneNumber	website Website	hoursintext HoursInText	mondayhours MondayHours	tuesdayhours TuesdayHours	wednesdayhours WednesdayHours	thursdayhours ThursdayHours	fridayhours FridayHours	saturdayhours SaturdayHours	sundayhours SundayHours
{\$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
);