Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

244 rows where "filed_date" is on date 2019-05-30 sorted by hospital_ownership

View and edit SQL

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, fy_end_date, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_irf_beds, subprovider_oth_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date)

  • 2019-05-30 · 244
Link rowid hospital_name address city state zip_code county_name phone_number hospital_type hospital_ownership ▼ emergency_services lat lng geocode_flag geocode_accuracy countyfips statefips statecountyfips cbsacode csatitle centraloutlyingcounty countyequivalent hosp_lookup_url PRVDR_NUM RPT_REC_NUM filed_date fy_end_date acute_beds icu_beds coronary_beds burn_beds surg_icu_beds oth_spec_beds subtotal_acute_beds subprovider_ipf_beds subprovider_irf_beds subprovider_oth_beds skilled_nursing_beds nursing_fac_beds oth_longterm_beds hospice_beds all_beds
455 PLAINS REGIONAL MEDICAL CENTER 2100 N MARTIN LUTHER KING, JR, BLVD CLOVIS NM 88101 CURRY (575) 769-7155 Acute Care Hospitals Government - Federal TRUE 34.4204900 -103.2317630 0   9 35 35009 17580 Clovis-Portales, NM Central Curry County https://data.medicare.gov/resource/xubh-q36u/row-dvw2.36gg-bpn9 320022 650185 2019-05-30 2018-12-31 98 8         106               106
254 MEDICAL CENTER BARBOUR 820 W WASHINGTON ST EUFAULA AL 36027 BARBOUR (334) 688-7271 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.8879800 -85.1566130 0   5 1 1005         https://data.medicare.gov/resource/xubh-q36u/row-b9cj~n2ap_7hxj 10069 651152 2019-05-30 2018-12-31 25 5         30 17             47
376 ATRIUM HEALTH ANSON 2301 US HIGHWAY 74 WEST WADESBORO NC 28170 ANSON (704) 694-5131 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.9785320 -80.1096790 0   7 37 37007         https://data.medicare.gov/resource/xubh-q36u/row-mv5j_iuia_xbie 340084 650339 2019-05-30 2018-12-31 15           15               15
984 GARFIELD COUNTY MEMORIAL HOSPITAL 66 NORTH SIXTH STREET POMEROY WA 99347 GARFIELD (509) 843-1591 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.4751830 -117.6025510 0   23 53 53023         https://data.medicare.gov/resource/xubh-q36u/row-estz_txzt_98nt 501301 650792 2019-05-30 2018-12-31 25           25               25
1032 CAROLINAS HEALTHCARE SYSTEM NORTHEAST 920 CHURCH ST N CONCORD NC 28025 CABARRUS (704) 783-3000 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.4343130 -80.6030880 0   25 37 37025 16740 Charlotte-Concord, NC-SC Outlying Cabarrus County https://data.medicare.gov/resource/xubh-q36u/row-gm6z.wfwa~gf2v 340001 650331 2019-05-30 2018-12-31 393 15 10       447 10             457
1182 SOUTH TEXAS SPINE AND SURGICAL HOSPITAL 18600 NORTH HARDY OAK BLVD SAN ANTONIO TX 78258 BEXAR (210) 404-0800 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.6132070 -98.4784930 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-hrzf~ehe3.nfy2 450856 648491 2019-05-30 2018-12-31 30           30               30
1698 UNITED HOSPITAL DISTRICT 515 SOUTH MOORE STREET, PO BOX 160 BLUE EARTH MN 56013 FARIBAULT (507) 526-3273 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.6342900 -94.1008840 0   43 27 27043         https://data.medicare.gov/resource/xubh-q36u/row-hive~sdke_37q9 241369 649912 2019-05-30 2018-12-31 20 4         24           1   25
1749 ATRIUM HEALTH CLEVELAND 201 E GROVER ST SHELBY NC 28150 CLEVELAND (704) 487-3000 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.3018370 -81.5353430 0   45 37 37045 43140 Charlotte-Concord, NC-SC Central Cleveland County https://data.medicare.gov/resource/xubh-q36u/row-qvep_5kn5-mu56 340021 650335 2019-05-30 2018-12-31 190 51         241               241
1830 MIDDLE PARK MEDICAL CENTER 214 4TH ST KREMMLING CO 80459 GRAND (970) 724-3442 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.0575000 -106.3911830 0   49 8 8049         https://data.medicare.gov/resource/xubh-q36u/row-zyfv.qfrq_5wh2 61318 649174 2019-05-30 2018-12-31 21           21               21
2092 SKAGIT VALLEY HOSPITAL 1415 KINCAID STREET MOUNT VERNON WA 98274 SKAGIT (360) 424-4111 Acute Care Hospitals Government - Hospital District or Authority TRUE 48.4174220 -122.3243350 0   57 53 53057 34580 Seattle-Tacoma, WA Central Skagit County https://data.medicare.gov/resource/xubh-q36u/row-35tt.efdg~xsq2 500003 650919 2019-05-30 2018-12-31 125   12       137               137
2297 ST VINCENT GENERAL HOSPITAL DISTRICT 822 W 4TH ST LEADVILLE CO 80461 LAKE (719) 486-0230 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2443920 -106.3033020 0   65 8 8065         https://data.medicare.gov/resource/xubh-q36u/row-zkkb~2fq8_8dib 61319 648894 2019-05-30 2018-12-31 8           8               8
2585 WHITMAN HOSPITAL AND MEDICAL CENTER 1200 WEST FAIRVIEW COLFAX WA 99111 WHITMAN (509) 397-3435 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.8689190 -117.3750120 0   75 53 53075 39420 Pullman-Moscow, WA-ID Central Whitman County https://data.medicare.gov/resource/xubh-q36u/row-rc2f_yynj.hvxs 501327 652125 2019-05-30 2018-12-31 25           25               25
2607 PATTERSON HEALTH CENTER 485 N. KS HWY 2 ANTHONY KS 67003 HARPER (620) 842-5111 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.1563360 -98.0393230 0   77 20 20077         https://data.medicare.gov/resource/xubh-q36u/row-twh3.zvup_2ech 171346 648922 2019-05-30 2018-12-31 25           25               25
3086 ASPEN VALLEY HOSPITAL 401 CASTLE CREEK RD ASPEN CO 81611 PITKIN (970) 544-1261 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.1900570 -106.8377840 0   97 8 8097 24060 Edwards-Glenwood Springs, CO Outlying Pitkin County https://data.medicare.gov/resource/xubh-q36u/row-w4f4-8yin.fcc5 61324 649403 2019-05-30 2018-12-31 21 4         25               25
3269 SLIDELL MEMORIAL HOSPITAL 1001 GAUSE BLVD SLIDELL LA 70458 ST. TAMMANY (985) 643-2200 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.2846510 -89.7704210 0   103 22 22103 35380 New Orleans-Metairie-Hammond, LA-MS Outlying St. Tammany Parish https://data.medicare.gov/resource/xubh-q36u/row-dj7e.4fyq~ywkm 190040 649436 2019-05-30 2018-12-31 123 100         231               231
3384 ATRIUM HEALTH LINCOLN 433 MCALISTER RD LINCOLNTON NC 28092 LINCOLN (980) 212-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.4883870 -81.2013140 0   109 37 37109 16740 Charlotte-Concord, NC-SC Outlying Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-6cgz~kmkt_vk9q 340145 650346 2019-05-30 2018-12-31 91 10         101               101
3615 ATRIUM HEALTH PINEVILLE 10628 PARK RD CHARLOTTE NC 28210 MECKLENBURG (704) 379-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.0913500 -80.8695290 0   119 37 37119 16740 Charlotte-Concord, NC-SC Central Mecklenburg County https://data.medicare.gov/resource/xubh-q36u/row-bjzs_ptmb_rc7h 340098 650341 2019-05-30 2018-12-31 181 30       10 221   29           250
3617 ATRIUM HEALTH UNIVERSITY CITY 8800 NORTH TYRON STREET CHARLOTTE NC 28262 MECKLENBURG (704) 548-6000 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.3078360 -80.7479850 0   119 37 37119 16740 Charlotte-Concord, NC-SC Central Mecklenburg County https://data.medicare.gov/resource/xubh-q36u/row-95dh.i4xn.dtuq 340166 650349 2019-05-30 2018-12-31 84 8       8 100               100
3680 GILLETTE CHILDRENS SPECIALTY HOSPITAL 200 UNIVERSITY AVENUE EAST SAINT PAUL MN 55106 RAMSEY (651) 578-5611 Childrens Government - Hospital District or Authority FALSE 44.9565470 -93.0956600 0   123 27 27123 33460 Minneapolis-St. Paul, MN-WI Central Ramsey County https://data.medicare.gov/resource/xubh-q36u/row-asad.d5pr_r5a5 243300 649913 2019-05-30 2018-12-31 50 10         60               60
4009 TMC- BONHAM HOSPITAL 504 LIPSCOMB STREET BONHAM TX 75418 FANNIN (903) 640-7311 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.5781300 -96.1674790 0   147 48 48147         https://data.medicare.gov/resource/xubh-q36u/row-va26~mxxb.q557 451370 649507 2019-05-30 2018-12-31 23 2         25               25
4255 SANFORD CANBY MEDICAL CENTER 112 ST OLAF AVENUE SOUTH CANBY MN 56220 YELLOW MEDCINE (507) 223-7277 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.7078990 -96.2775550 0   173 27 27173         https://data.medicare.gov/resource/xubh-q36u/row-dj3n-ee8i_z8u5 241347 649785 2019-05-30 2018-12-31 22           22       53       75
4290 ATRIUM HEALTH UNION 600 HOSPITAL DR MONROE NC 28112 UNION (704) 283-3100 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.9751110 -80.5228530 0   179 37 37179 16740 Charlotte-Concord, NC-SC Central Union County https://data.medicare.gov/resource/xubh-q36u/row-z2m5~mpse-nkc2 340130 650345 2019-05-30 2018-12-31 164 14       4 182       70       252
4323 WABASH GENERAL HOSPITAL 1 1418 COLLEGE DRIVE MOUNT CARMEL IL 62863 WABASH (618) 262-8621 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.4216250 -87.7687720 0   185 17 17185         https://data.medicare.gov/resource/xubh-q36u/row-4k4x-d3n5.d5n5 141327 649727 2019-05-30 2018-12-31 21 4         25               25
4641 WISE HEALTH SYSTEM 3200 NORTH TARRANT PARKWAY FORT WORTH TX 76177 TARRANT (817) 502-7300 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.8974340 -97.3122990 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-nkp3_nyc5_hqkg 670116 650433 2019-05-30 2018-12-31 36           36               36
4707 WISE REGIONAL HEALTH SYSTEM 609 MEDICAL CENTER DRIVE DECATUR TX 76234 WISE (940) 627-5921 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.2202630 -97.5931070 0   497 48 48497 19100 Dallas-Fort Worth, TX-OK Outlying Wise County https://data.medicare.gov/resource/xubh-q36u/row-cn54-zrya.j3rq 450271 649353 2019-05-30 2018-12-31 60 21         81 20 15           116
88 ADAMS MEMORIAL HOSPITAL 1100 MERCER AVE DECATUR IN 46733 ADAMS (260) 724-2145 Critical Access Hospitals Government - Local TRUE 40.8179660 -84.9125350 0   1 18 18001 19540 Fort Wayne-Huntington-Auburn, IN Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-vdys.bcxa-gdh7 151330 649100 2019-05-30 2018-12-31 21 4         25               25
117 ADAMS COUNTY REGIONAL MEDICAL CENTER 230 MEDICAL CENTER DRIVE SEAMAN OH 45679 ADAMS (937) 386-3400 Critical Access Hospitals Government - Local TRUE 38.9338480 -83.5856120 0   1 39 39001         https://data.medicare.gov/resource/xubh-q36u/row-wb9j-jzwz-2xmu 361326 649329 2019-05-30 2018-12-31 25           25               25
958 PROMEDICA COLDWATER REGIONAL HOSPITAL 274 E CHICAGO ST COLDWATER MI 49036 BRANCH (517) 279-5400 Acute Care Hospitals Government - Local TRUE 41.9389690 -84.9905850 0   23 26 26023 17740   Central Branch County https://data.medicare.gov/resource/xubh-q36u/row-c7fm~x3c9_q2bd 230022 649113 2019-05-30 2018-12-31 77 10         87               87
1073 BRECKINRIDGE MEMORIAL HOSPITAL 1011 OLD HIGHWAY 60 HARDINSBURG KY 40143 BRECKINRIDGE (270) 756-7000 Critical Access Hospitals Government - Local TRUE 37.7666150 -86.4416430 0   27 21 21027         https://data.medicare.gov/resource/xubh-q36u/row-x9zn_pcg8_7qr2 181319 648926 2019-05-30 2018-12-31 25           25       18       43
1636 MARINHEALTH MEDICAL CENTER 250 BON AIR ROAD, PO BOX 8010 GREENBRAE CA 94904 MARIN (415) 925-7900 Acute Care Hospitals Government - Local TRUE 37.9488840 -122.5358970 0   41 6 6041 41860 San Jose-San Francisco-Oakland, CA Central Marin County https://data.medicare.gov/resource/xubh-q36u/row-dkgh~wvb6.ei3e 50360 650650 2019-05-30 2018-12-31 164 10 36     8 218 17             235
1650 ALOMERE HEALTH 111 17TH AVENUE EAST ALEXANDRIA MN 56308 DOUGLAS (320) 762-1511 Acute Care Hospitals Government - Local TRUE 45.8726690 -95.3763800 0   41 27 27041 10820   Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-psb9.f8hy_pu25 240030 649757 2019-05-30 2018-12-31 91 8         99               99
1694 NEWMAN MEMORIAL HOSPITAL 905 SOUTH MAIN STREET SHATTUCK OK 73858 ELLIS (580) 938-2551 Critical Access Hospitals Government - Local TRUE 36.2681320 -99.8815380 0   45 40 40045         https://data.medicare.gov/resource/xubh-q36u/row-7tme~3s76_iax8 371336 649132 2019-05-30 2018-12-31 25           25               25
2063 RIVERVIEW HEALTH 395 WESTFIELD RD NOBLESVILLE IN 46060 HAMILTON (317) 773-0760 Acute Care Hospitals Government - Local TRUE 40.0470260 -86.0240810 0   57 18 18057 26900 Indianapolis-Carmel-Muncie, IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-2tme-mzbr.en9s 150059 659262 2019-05-30 2018-12-31 94 15         109   24   25       158
2088 MEMORIAL MEDICAL CENTER 815 N VIRGINIA STREET PORT LAVACA TX 77979 CALHOUN (361) 552-6713 Critical Access Hospitals Government - Local TRUE 28.6209120 -96.6315370 0   57 48 48057 38920 Victoria-Port Lavaca, TX Central Calhoun County https://data.medicare.gov/resource/xubh-q36u/row-fkri_527j~nq75 451356 650380 2019-05-30 2018-12-31 19 6         25               25
2426 JOHNSON REGIONAL MEDICAL CENTER 1100 EAST POPLAR STREET CLARKSVILLE AR 72830 JOHNSON (479) 754-5454 Acute Care Hospitals Government - Local TRUE 35.4643840 -93.4457970 0   71 5 5071         https://data.medicare.gov/resource/xubh-q36u/row-uar5.h8rs.rsi2 40002 648883 2019-05-30 2018-12-31 49 8         57 20 12           89
3669 PROVIDENCE SEWARD HOSPITAL 417 FIRST AVENUE, PO BOX 365 SEWARD AK 99664 KENAI PENINSULA (907) 224-5205 Critical Access Hospitals Government - Local TRUE 60.1050460 -149.4453830 0   122 2 2122         https://data.medicare.gov/resource/xubh-q36u/row-bjag~4kwr.8ihd 21302 652058 2019-05-30 2018-12-31 6           6       40       46
3917 OSBORNE COUNTY MEMORIAL HOSPITAL 424 W NEW HAMPSHIRE STREET OSBORNE KS 67473 OSBORNE (785) 346-2121 Critical Access Hospitals Government - Local TRUE 39.4366820 -98.7011590 0   141 20 20141         https://data.medicare.gov/resource/xubh-q36u/row-fbsc.wavi.k36j 171364 648924 2019-05-30 2018-12-31 24           24               24
3970 MAJOR HOSPITAL 2451 INTELLIPLEX DR SHELBYVILLE IN 46176 SHELBY (317) 392-3211 Acute Care Hospitals Government - Local TRUE 39.5600170 -85.7839700 0   145 18 18145 26900 Indianapolis-Carmel-Muncie, IN Outlying Shelby County https://data.medicare.gov/resource/xubh-q36u/row-r4ki.27zg-ps3s 150097 659263 2019-05-30 2018-12-31 40 6         46               46
4265 SOUTHWEST MEDICAL CENTER 315 WEST 15TH STREET LIBERAL KS 67901 SEWARD (620) 629-6291 Acute Care Hospitals Government - Local TRUE 37.0542160 -100.9265690 0   175 20 20175 30580   Central Seward County https://data.medicare.gov/resource/xubh-q36u/row-vgq9-s5vq_zsjm 170068 649108 2019-05-30 2018-12-31 63 8         71       18       89
4449 WILSON MEDICAL CENTER REECE CAMPUS 2600 OTTAWA ROAD NEODESHA KS 66757 WILSON (620) 325-2611 Critical Access Hospitals Government - Local TRUE 37.4085290 -95.7082419 1 ROOFTOP 205 20 20205         https://data.medicare.gov/resource/xubh-q36u/row-fh4a~9srx~xwnp 171344 649229 2019-05-30 2018-12-31 15           15               15
4529 PROVIDENCE VALDEZ MEDICAL CENTER PO BOX 550 VALDEZ AK 99686 VALDEZ-CORDOVA (907) 835-2249 Critical Access Hospitals Government - Local TRUE 61.1364781 -146.3458866 1 ROOFTOP 261 2 2261         https://data.medicare.gov/resource/xubh-q36u/row-2ygw.872k~d2en 21301 652057 2019-05-30 2018-12-31 11           11       10       21
4530 CORDOVA COMMUNITY MEDICAL CENTER PO BOX 160 - 602 CHASE AVENUE CORDOVA AK 99574 VALDEZ-CORDOVA (907) 424-8000 Critical Access Hospitals Government - Local TRUE 60.5413354 -145.7505310 1 ROOFTOP 261 2 2261         https://data.medicare.gov/resource/xubh-q36u/row-kscp_6dza~rvey 21307 650633 2019-05-30 2018-12-31 13           13       10       23
1384 WADLEY REGIONAL MEDICAL CENTER 1000 PINE STREET TEXARKANA TX 75501 BOWIE (903) 798-8000 Acute Care Hospitals Physician TRUE 33.4284820 -94.0471880 0   37 48 48037 45500   Central Bowie County https://data.medicare.gov/resource/xubh-q36u/row-tvfa~q5ve.ejfb 450200 650527 2019-05-30 2018-12-31 159 26         185 14             199
1450 OAKLEAF SURGICAL HOSPITAL 1000 OAKLEAF WAY ALTOONA WI 54720 EAU CLAIRE (715) 831-8130 Acute Care Hospitals Physician FALSE 44.8150020 -91.4517640 0   35 55 55035 20740 Eau Claire-Menomonie, WI Central Eau Claire County https://data.medicare.gov/resource/xubh-q36u/row-4tiq~2hj5~t8xv 520196 650624 2019-05-30 2018-12-31 13           13               13
2008 LAFAYETTE GENERAL SURGICAL HOSPITAL 1000 W PINHOOK RD SUITE 100 LAFAYETTE LA 70503 LAFAYETTE (337) 289-8095 Acute Care Hospitals Physician FALSE 30.2042530 -92.0134680 0   55 22 22055 29180 Lafayette-Opelousas-Morgan City, LA Central Lafayette Parish https://data.medicare.gov/resource/xubh-q36u/row-i7bm~9svd~q42h 190268 649248 2019-05-30 2018-12-31 10           10               10
2009 PARK PLACE SURGICAL HOSPITAL 4811 AMBASSADOR CAFFERY PARKWAY LAFAYETTE LA 70508 LAFAYETTE (337) 237-8119 Acute Care Hospitals Physician FALSE 30.1497980 -92.0401140 0   55 22 22055 29180 Lafayette-Opelousas-Morgan City, LA Central Lafayette Parish https://data.medicare.gov/resource/xubh-q36u/row-pekc_yry2_bpdk 190255 649246 2019-05-30 2018-12-31 10           10               10
2463 ST CHARLES SURGICAL HOSPITAL LLC 1717 ST CHARLES AVE NEW ORLEANS LA 70130 ORLEANS (504) 529-6600 Acute Care Hospitals Physician FALSE 29.9373710 -90.0768800 0   71 22 22071 35380 New Orleans-Metairie-Hammond, LA-MS Central Orleans Parish https://data.medicare.gov/resource/xubh-q36u/row-bm2i-2rpj_kw3b 190300 649438 2019-05-30 2018-12-31 39           39               39
2806 EDGEWOOD SURGICAL HOSPITAL 239 EDGEWOOD DRIVE EXTENSION TRANSFER PA 16154 MERCER (724) 646-0400 Acute Care Hospitals Physician FALSE 41.3300510 -80.4178550 0   85 42 42085 49660 Youngstown-Warren, OH-PA Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-rh2b~kawm~nsdh 390307 649489 2019-05-30 2018-12-31 10           10               10
3386 NORTHWEST SURGICAL HOSPITAL 9204 NORTH MAY AVENUE OKLAHOMA CITY OK 73120 OKLAHOMA (405) 848-1918 Acute Care Hospitals Physician TRUE 35.5641660 -97.5671590 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-a9dt_8msh-9ahb 370192 650519 2019-05-30 2018-12-31 9           9               9
3391 COMMUNITY HOSPITAL, LLC 3100 SOUTHWEST 89TH STREET OKLAHOMA CITY OK 73159 OKLAHOMA (405) 602-8100 Acute Care Hospitals Physician TRUE 35.3771130 -97.5704530 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-ftkm_6raj-yxui 370203 649480 2019-05-30 2018-12-31 42 3         45               45
3914 UNITY MEDICAL AND SURGICAL HOSPITAL 4455 EDISON LAKES PKWY MISHAWAKA IN 46545 ST. JOSEPH (574) 231-6800 Acute Care Hospitals Physician FALSE 41.7007230 -86.1767810 0   141 18 18141 43780 South Bend-Elkhart-Mishawaka, IN-MI Central St. Joseph County https://data.medicare.gov/resource/xubh-q36u/row-ezgx~i6vb_t9ti 150177 649092 2019-05-30 2018-12-31 29           29               29
4077 SUMMIT SURGICAL, LLC 1818 EAST 23RD AVENUE HUTCHINSON KS 67502 RENO (620) 662-6000 Acute Care Hospitals Physician FALSE 38.0795300 -97.8885950 0   155 20 20155 26740   Central Reno County https://data.medicare.gov/resource/xubh-q36u/row-rrpw.z43u-xa5d 170198 649226 2019-05-30 2018-12-31 10           10               10
144 MANCHESTER MEMORIAL HOSPITAL 71 HAYNES ST MANCHESTER CT 6040 HARTFORD (860) 647-4780 Acute Care Hospitals Proprietary TRUE 41.7810870 -72.5252210 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-shzd.8q5k_ybhg 70027 650673 2019-05-30 2018-12-31 108 32         140 31             171
200 DIGNITY HEALTH ST ROSE DOMINICAN N L V CAMPUS 1550 W CRAIG RANCH NORTH LAS VEGAS NV 89031 CLARK (702) 777-3615 Acute Care Hospitals Proprietary TRUE 36.2434428 -115.1500008 1 ROOFTOP 3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-u3b3_a37u-466v 290058 652436 2019-05-30 2018-12-31 32           32               32
204 CENTENNIAL HILLS HOSPITAL MEDICAL CENTER 6900 N DURANGO DR LAS VEGAS NV 89149 CLARK (702) 835-9700 Acute Care Hospitals Proprietary TRUE 36.2860140 -115.2877300 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-mxjv~899t-ww8w 290054 648952 2019-05-30 2018-12-31 217 16         248               248
339 OZARKS COMMUNITY HOSPITAL OF GRAVETTE 1101 JACKSON STREET SW GRAVETTE AR 72736 BENTON (479) 787-5291 Critical Access Hospitals Proprietary TRUE 36.4085630 -94.4598700 0   7 5 5007 22220   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-snva.mem9_cs94 41331 651314 2019-05-30 2018-12-31 25           25               25
385 OUR LADY OF FATIMA HOSPITAL 200 HIGH SERVICE AVENUE NORTH PROVIDENCE RI 2904 PROVIDENCE (401) 456-3000 Acute Care Hospitals Proprietary TRUE 41.8557960 -71.4584980 0   7 44 44007 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Providence County https://data.medicare.gov/resource/xubh-q36u/row-ya2z~83y5.tnki 410005 650779 2019-05-30 2018-12-31 148 15         163 124 25           312
386 ROGER WILLIAMS MEDICAL CENTER 825 CHALKSTONE AVENUE PROVIDENCE RI 2908 PROVIDENCE (401) 456-2025 Acute Care Hospitals Proprietary TRUE 41.8340150 -71.4345800 0   7 44 44007 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Providence County https://data.medicare.gov/resource/xubh-q36u/row-k87m-wjy5_7p2x 410004 650778 2019-05-30 2018-12-31 134       14   148 12             160
413 WATERBURY HOSPITAL 64 ROBBINS ST WATERBURY CT 6721 NEW HAVEN (203) 573-6000 Acute Care Hospitals Proprietary TRUE 41.5582690 -73.0586080 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-na88_kufh.6cuk 70005 650439 2019-05-30 2018-12-31 193 20         213 30             243
597 ROCKVILLE GENERAL HOSPITAL 31 UNION ST ROCKVILLE CT 6066 TOLLAND (860) 872-5160 Acute Care Hospitals Proprietary TRUE 41.8669620 -72.4509880 0   13 9 9013 25540 Hartford-West Hartford, CT Central Tolland County https://data.medicare.gov/resource/xubh-q36u/row-fjuu~c5fd_6w23 70012 650672 2019-05-30 2018-12-31 93 9         102       130       232
953 SOUTH CAMERON MEMORIAL HOSPITAL 5360 WEST CREOLE HWY CAMERON LA 70631 CAMERON (337) 542-4111 Acute Care Hospitals Proprietary TRUE 29.8071730 -93.1652450 0   23 22 22023 29340   Outlying Cameron Parish https://data.medicare.gov/resource/xubh-q36u/row-59pq~i76h_a9yh 190307 648537 2019-05-30 2018-12-31 25           25 24             49
961 POPLAR BLUFF REGIONAL MEDICAL CENTER 3100 OAK GROVE ROAD POPLAR BLUFF MO 63901 BUTLER (573) 785-7721 Acute Care Hospitals Proprietary TRUE 36.7889870 -90.4432870 0   23 29 29023 38740   Central Butler County https://data.medicare.gov/resource/xubh-q36u/row-ats4-xdcp~iw65 260119 649121 2019-05-30 2018-12-31 206 14         220   12           232
1011 SHRINERS' HOSPITAL FOR CHILDREN - BOSTON, THE 51 BLOSSOM STREET BOSTON MA 2114 SUFFOLK (617) 722-3000 Childrens Proprietary FALSE 42.3630790 -71.0669040 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-pfzw.md7z-rufe 223304 652751 2019-05-30 2018-12-31                              
1030 LEA REGIONAL MEDICAL CENTER 5419 N LOVINGTON HIGHWAY HOBBS NM 88240 LEA (575) 492-5000 Acute Care Hospitals Proprietary TRUE 32.7659880 -103.1860340 0   25 35 35025 26020   Central Lea County https://data.medicare.gov/resource/xubh-q36u/row-86mj-st3t_222u 320065 649297 2019-05-30 2018-12-31 53 8         61 15     16       92
1090 SAINT CLARE'S HOSPITAL/ DENVILLE CAMPUS 25 POCONO ROAD DENVILLE NJ 7834 MORRIS (973) 983-5569 Acute Care Hospitals Proprietary TRUE 40.8943760 -74.4644790 0   27 34 34027 35620 New York-Newark, NY-NJ-CT-PA Central Morris County https://data.medicare.gov/resource/xubh-q36u/row-esnm_pmpi~hgpj 310050 651221 2019-05-30 2018-12-31 284 25       16 325 42             367
1109 DELTA COMMUNITY HOSPITAL 126 SOUTH WHITE SAGE AVENUE DELTA UT 84624 MILLARD (435) 864-5591 Critical Access Hospitals Proprietary TRUE 39.3502940 -112.5600230 0   27 49 49027         https://data.medicare.gov/resource/xubh-q36u/row-drqc-aprc.hcpi 461300 652115 2019-05-30 2018-12-31 18           18               18
1176 NIX HEALTH CARE SYSTEM 414 NAVARRO, SUITE 600 SAN ANTONIO TX 78205 BEXAR (210) 271-2188 Acute Care Hospitals Proprietary TRUE 29.4255770 -98.4897180 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-6ir7_mgdd.hab9 450130 648576 2019-05-30 2018-12-31 189 12         201 33 18           252
1189 BAPTIST EMERGENCY HOSPITAL 16088 SAN PEDRO SAN ANTONIO TX 78232 BEXAR (210) 402-4092 Acute Care Hospitals Proprietary TRUE 29.5879550 -98.4741980 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-4y9d~e7dz-wrhw 670078 649389 2019-05-30 2018-12-31 50           50               50
1288 ST MARY'S GENERAL HOSPITAL 350 BOULEVARD PASSAIC NJ 7055 PASSAIC (973) 365-4300 Acute Care Hospitals Proprietary TRUE 40.8582800 -74.1372100 0   31 34 34031 35620 New York-Newark, NY-NJ-CT-PA Central Passaic County https://data.medicare.gov/resource/xubh-q36u/row-aiiy.n2qz_h3vu 310006 648719 2019-05-30 2018-12-31 120 25         145               145
1455 SOUTHERN CALIFORNIA HOSPITAL AT HOLLYWOOD 6245 DE LONGPRE AVE HOLLYWOOD CA 90028 LOS ANGELES (323) 462-2271 Acute Care Hospitals Proprietary TRUE 34.0961920 -118.3253710 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-k6q2.64iy.buw8 50135 652414 2019-05-30 2018-12-31 531 15 13       559   32   21       612
1462 LOS ANGELES COMMUNITY HOSPITAL 4081 E OLYMPIC BLVD LOS ANGELES CA 90023 LOS ANGELES (323) 267-0477 Acute Care Hospitals Proprietary TRUE 34.0188740 -118.1864610 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-rprf_mcdz_p4qe 50663 649540 2019-05-30 2018-12-31 263 22         285       39       324
1502 WEST COVINA MEDICAL CENTER, INC 725 S ORANGE AVE WEST COVINA CA 91790 LOS ANGELES (626) 338-8481 Acute Care Hospitals Proprietary FALSE 34.0709280 -117.9441660 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-mrqt_jczt_crz9 50096 652580 2019-05-30 2018-12-31 13           13       33       46
1519 ENCINO HOSPITAL MEDICAL CENTER 16237 VENTURA BLVD ENCINO CA 91436 LOS ANGELES (818) 995-5000 Acute Care Hospitals Proprietary FALSE 34.1568260 -118.4869480 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-9gh4~7pmm-pjtp 50158 652415 2019-05-30 2018-12-31 60   22       82 13 25   28       148
1713 PARK CITY HOSPITAL 900 ROUND VALLEY DRIVE PARK CITY UT 84060 SUMMIT (435) 658-6700 Acute Care Hospitals Proprietary TRUE 40.6876970 -111.4689520 0   43 49 49043 44920 Salt Lake City-Provo-Orem, UT Central Summit County https://data.medicare.gov/resource/xubh-q36u/row-ecxv.jm7a~8gnk 460057 652113 2019-05-30 2018-12-31 33 4         37               37
1933 SOUTHERN TENNESSEE REGIONAL HLTH SYSTEM WINCHESTER 185 HOSPITAL ROAD WINCHESTER TN 37398 FRANKLIN (931) 967-8295 Acute Care Hospitals Proprietary TRUE 35.1760230 -86.0910760 0   51 47 47051 46100   Outlying Franklin County https://data.medicare.gov/resource/xubh-q36u/row-au3a_wp3s-29ym 440058 651234 2019-05-30 2018-12-31 118 10         128 12 12   46       198
2120 FOOTHILL REGIONAL MEDICAL CENTER 14662 NEWPORT AVE TUSTIN CA 92780 ORANGE (714) 619-7700 Acute Care Hospitals Proprietary FALSE 33.7307730 -117.8294850 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-sm2c.wjav~dxth 50780 648890 2019-05-30 2018-12-31 120 15         135       42       177
2229 HARLINGEN MEDICAL CENTER 5501 SOUTH EXPRESSWAY 77 HARLINGEN TX 78550 CAMERON (956) 365-1000 Acute Care Hospitals Proprietary TRUE 26.1573230 -97.6769680 0   61 48 48061 15180 Brownsville-Harlingen-Raymondville, TX Central Cameron County https://data.medicare.gov/resource/xubh-q36u/row-y5xq.uxm4~ujtf 450855 648991 2019-05-30 2018-12-31 80 14         112               112
2264 NORTH CAROLINA SPECIALTY HOSPITAL 3916 BEN FRANKLIN BOULEVARD DURHAM NC 27704 DURHAM (919) 956-9300 Acute Care Hospitals Proprietary FALSE 36.0428650 -78.8975480 0   63 37 37063 20500 Raleigh-Durham-Chapel Hill, NC Central Durham County https://data.medicare.gov/resource/xubh-q36u/row-qk28.yf4v-b8w5 340049 650337 2019-05-30 2018-12-31 18           18               18
2517 ALVARADO HOSPITAL MEDICAL CENTER 6655 ALVARADO ROAD SAN DIEGO CA 92120 SAN DIEGO (619) 229-3172 Acute Care Hospitals Proprietary TRUE 32.7771360 -117.0566020 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-nt9q.cx94-9sbi 50757 648888 2019-05-30 2018-12-31 226 28         254   50           304
2691 MANATEE MEMORIAL HOSPITAL 206 2ND ST E BRADENTON FL 34208 MANATEE (941) 746-5111 Acute Care Hospitals Proprietary TRUE 27.4972090 -82.5612410 0   81 12 12081 35840 North Port-Sarasota, FL Central Manatee County https://data.medicare.gov/resource/xubh-q36u/row-8dn6~8qtb.vm5v 100035 649713 2019-05-30 2018-12-31 254 35         295               295
2814 BAYLOR MEDICAL CENTER AT FRISCO 5601 WARREN PARKWAY FRISCO TX 75034 DENTON (214) 618-2000 Acute Care Hospitals Proprietary TRUE 33.1067100 -96.8379190 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-y75i-gkwy-z8z2 450853 649836 2019-05-30 2018-12-31 60         8 68               68
2828 WESTCHESTER GENERAL HOSPITAL 2500 SW 75TH AVE MIAMI FL 33155 MIAMI-DADE (305) 263-9270 Acute Care Hospitals Proprietary TRUE 25.7480400 -80.3172240 0   86 12 12086 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Miami-Dade County https://data.medicare.gov/resource/xubh-q36u/row-c5ca_542y.hxzz 100284 651511 2019-05-30 2018-12-31 90 8         98 27             125
2883 SHASTA REGIONAL MEDICAL CENTER 1100 BUTTE ST REDDING CA 96001 SHASTA (530) 244-5454 Acute Care Hospitals Proprietary TRUE 40.5853760 -122.3866830 0   89 6 6089 39820 Redding-Red Bluff, CA Central Shasta County https://data.medicare.gov/resource/xubh-q36u/row-444t_kxts-infi 50764 648889 2019-05-30 2018-12-31 168 37         205 21             226
3055 ST JOSEPH MEDICAL CENTER 1000 CARONDELET DR KANSAS CITY MO 64114 JACKSON (816) 942-4400 Acute Care Hospitals Proprietary TRUE 38.9344710 -94.6053420 0   95 29 29095 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-risq_3sj8-p556 260085 649119 2019-05-30 2018-12-31 111 16         127   14           141
3177 SURGICAL HOSPITAL AT SOUTHWOODS 7630 SOUTHERN BLVD YOUNGSTOWN OH 44512 MAHONING (330) 729-8000 Acute Care Hospitals Proprietary FALSE 41.0153550 -80.6534390 0   99 39 39099 49660 Youngstown-Warren, OH-PA Central Mahoning County https://data.medicare.gov/resource/xubh-q36u/row-422i~a2cq-j6nr 360352 648972 2019-05-30 2018-12-31 24           24               24
3488 MEDICAL CITY LAS COLINAS 6800 N MACARTHUR BLVD IRVING TX 75039 DALLAS (972) 969-2000 Acute Care Hospitals Proprietary TRUE 32.9020470 -96.9586790 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-wvh9-krw7~fy64 450822 649140 2019-05-30 2018-12-31 66 8       6 80               80
3499 DALLAS MEDICAL CENTER 7 MEDICAL PARKWAY DALLAS TX 75234 DALLAS (972) 247-1000 Acute Care Hospitals Proprietary TRUE 32.9143350 -96.8730980 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-hw8i~2d9s~wysi 450379 650528 2019-05-30 2018-12-31 107 12         119               119
3502 DALLAS REGIONAL MEDICAL CENTER 1011 NORTH GALLOWAY AVENUE MESQUITE TX 75149 DALLAS (214) 320-7000 Acute Care Hospitals Proprietary TRUE 32.7775750 -96.5997200 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-f3bu_fxyn_gxk5 450688 649674 2019-05-30 2018-12-31 178 24         202               202
3510 FIRST TEXAS HOSPITAL CARROLLTON LLC 1401 E TRINITY MILLS ROAD CARROLLTON TX 75006 DALLAS (972) 810-0700 Acute Care Hospitals Proprietary TRUE 32.9850010 -96.8982210 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-pssx_vyvi-xhzt 670110 651438 2019-05-30 2018-12-31 18           18               18
3658 BAYLOR SCOTT AND WHITE EMERGENCY HOSPITAL AUBREY 26791 HIGHWAY 380 AUBREY TX 76227 DENTON (972) 347-2525 Acute Care Hospitals Proprietary TRUE 33.2206581 -96.9135249 1 ROOFTOP 121 48 48121 19100 Dallas-Fort Worth, TX-OK Outlying Denton County https://data.medicare.gov/resource/xubh-q36u/row-9pb6.v6ys-8mdu 670062 649013 2019-05-30 2018-12-31 40           40               40
3661 TEXAS HEALTH PRESBYTERIAN HOSPITAL FLOWER MOUND 4400 LONG PRAIRIE ROAD FLOWER MOUND TX 75028 DENTON (972) 419-1530 Acute Care Hospitals Proprietary TRUE 33.0452270 -97.0693310 0   121 48 48121 19100 Dallas-Fort Worth, TX-OK Outlying Denton County https://data.medicare.gov/resource/xubh-q36u/row-cv43_dzrr_v22n 670068 650226 2019-05-30 2018-12-31 91 8         99               99
3759 DUNES SURGICAL HOSPITAL 600 N SIOUX POINT ROAD DAKOTA DUNES SD 57049 UNION (605) 232-3332 Acute Care Hospitals Proprietary FALSE 42.5047530 -96.4968160 0   127 46 46127 43580 Sioux City-Vermillion, IA-SD-NE Central Union County https://data.medicare.gov/resource/xubh-q36u/row-c5z7~7eiv-hfta 430089 650781 2019-05-30 2018-12-31 38           38               38
3777 INDIANHEAD MEDICAL CENTER SHELL LAKE 113 4TH AVE SHELL LAKE WI 54871 WASHBURN (715) 468-7833 Critical Access Hospitals Proprietary TRUE 45.7421020 -91.9257800 0   129 55 55129         https://data.medicare.gov/resource/xubh-q36u/row-kcr4.6q2e-4e5f 521342 650795 2019-05-30 2018-12-31 25           25               25
3781 DOCTORS' CENTER HOSPITAL SAN JUAN PDA. 20 C/ SAN RAFAEL # 1395 FERNANDEZ JUNCOS PR 909 SAN JUAN (787) 723-2950 Acute Care Hospitals Proprietary TRUE 18.4446749 -66.0761443 1 RANGE_INTERPOLATED 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-u5ha_su64_x3jd 400006 649492 2019-05-30 2018-12-31 123 6         129               129
3933 THE HOSPITALS OF PROVIDENCE HORIZON CITY CAMPUS 13600 HORIZON STREET, SUITE 100 HORIZON CITY TX 79928 EL PASO (915) 407-7878 Acute Care Hospitals Proprietary TRUE 31.6827230 -106.2073480 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-m5db~xjiy~dvv3 670124 649391 2019-05-30 2018-12-31 9           9               9
4159 DETROIT RECEIVING HOSPITAL & UNIV HEALTH CENTER 4201 ST ANTOINE ST - 2C DETROIT MI 48201 WAYNE (313) 745-3104 Acute Care Hospitals Proprietary TRUE 42.3535426 -83.0550940 1 ROOFTOP 163 26 26163 19820 Detroit-Warren-Ann Arbor, MI Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-niud-7c22~chx9 230273 649265 2019-05-30 2018-12-31 134 28 12 9 12   195 19             214
4162 CHILDREN'S HOSPITAL OF MICHIGAN 3901 BEAUBIEN STREET DETROIT MI 48201 WAYNE (313) 745-5437 Childrens Proprietary TRUE 42.3518160 -83.0537500 0   163 26 26163 19820 Detroit-Warren-Ann Arbor, MI Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-z5kc-2ncc~crci 233300 649116 2019-05-30 2018-12-31 122 48   19   39 228               228
4168 SINAI-GRACE HOSPITAL 6071 W OUTER DRIVE DETROIT MI 48235 WAYNE (313) 966-3300 Acute Care Hospitals Proprietary TRUE 42.4201020 -83.1814710 0   163 26 26163 19820 Detroit-Warren-Ann Arbor, MI Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-xx67-s2aj_ub5i 230024 649114 2019-05-30 2018-12-31 296 39 3     19 357 21 12           390
4248 WESLEY MEDICAL CENTER 550 N HILLSIDE STREET WICHITA KS 67214 SEDGWICK (316) 962-2000 Acute Care Hospitals Proprietary TRUE 37.6954890 -97.2990580 0   173 20 20173 48620 Wichita-Arkansas City-Winfield, KS Central Sedgwick County https://data.medicare.gov/resource/xubh-q36u/row-fncw-tisj.5akn 170123 649109 2019-05-30 2018-12-31 435 93 26       593               593
4423 MEMORIAL HERMANN FIRST COLONY HOSPITAL 24429 TOMBALL PARKWAY, SUITE 100 TOMBALL TX 77375 HARRIS (281) 516-0911 Acute Care Hospitals Proprietary FALSE 30.0371760 -95.6053230 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-wtak~qp2w~qmyj 670095 649016 2019-05-30 2018-12-31 15           15               15

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [hospital_data] (
   [hospital_name] TEXT,
   [address] TEXT,
   [city] TEXT,
   [state] TEXT,
   [zip_code] INTEGER,
   [county_name] TEXT,
   [phone_number] TEXT,
   [hospital_type] TEXT,
   [hospital_ownership] TEXT,
   [emergency_services] TEXT,
   [lat] TEXT,
   [lng] TEXT,
   [geocode_flag] INTEGER,
   [geocode_accuracy] TEXT,
   [countyfips] INTEGER,
   [statefips] INTEGER,
   [statecountyfips] INTEGER,
   [cbsacode] TEXT,
   [csatitle] TEXT,
   [centraloutlyingcounty] TEXT,
   [countyequivalent] TEXT,
   [hosp_lookup_url] TEXT,
   [PRVDR_NUM] INTEGER,
   [RPT_REC_NUM] INTEGER,
   [filed_date] TEXT,
   [fy_end_date] TEXT,
   [acute_beds] INTEGER,
   [icu_beds] TEXT,
   [coronary_beds] TEXT,
   [burn_beds] TEXT,
   [surg_icu_beds] TEXT,
   [oth_spec_beds] TEXT,
   [subtotal_acute_beds] INTEGER,
   [subprovider_ipf_beds] TEXT,
   [subprovider_irf_beds] TEXT,
   [subprovider_oth_beds] TEXT,
   [skilled_nursing_beds] TEXT,
   [nursing_fac_beds] TEXT,
   [oth_longterm_beds] TEXT,
   [hospice_beds] TEXT,
   [all_beds] INTEGER
);