hospital_data

Table actions
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

68 rows where "fy_end_date" is on date 2019-04-30

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, statefips, csatitle, centraloutlyingcounty, filed_date, icu_beds, coronary_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, oth_longterm_beds, filed_date (date)

fy_end_date (date) ✖

  • 2019-04-30 · 68 ✖
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
27 27 NEMAHA COUNTY HOSPITAL 2022 13TH ST AUBURN NE 68305 NEMAHA (402) 274-4366 Critical Access Hospitals Government - Local TRUE 40.3920330 -95.8530200 0   127 31 31127         https://data.medicare.gov/resource/xubh-q36u/row-jgty.gwke-kfnb 281324 654855 2019-09-24 2019-04-30 16           16               16
107 107 LOVELACE WOMEN'S HOSPITAL 4701 MONTGOMERY BOULEVARD NE ALBUQUERQUE NM 87109 BERNALILLO (505) 727-7805 Acute Care Hospitals Government - State TRUE 35.1310050 -106.5910370 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-fycu~sc7u.8im7 320017 655223 2019-10-17 2019-04-30 112 8       42 162               162
138 138 CANYON VISTA MEDICAL CENTER 5700 EAST HIGHWAY 90 SIERRA VISTA AZ 85635 COCHISE (520) 263-3001 Acute Care Hospitals Voluntary non-profit - Other TRUE 31.5546350 -110.2307260 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-ghfv-yx8h~hkgn 30043 654824 2019-09-30 2019-04-30 63 12         75 19             94
437 437 MOUNT DESERT ISLAND HOSPITAL 10 WAYMAN LANE, PO BOX 8 BAR HARBOR ME 4609 HANCOCK (207) 288-5081 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3843690 -68.2023310 0   9 23 23009         https://data.medicare.gov/resource/xubh-q36u/row-egex~7j5d.98hj 201304 654844 2019-09-30 2019-04-30 25           25               25
487 487 MEMORIAL REGIONAL HOSPITAL 3501 JOHNSON ST HOLLYWOOD FL 33021 BROWARD (954) 265-5814 Acute Care Hospitals Government - Hospital District or Authority FALSE 26.0182620 -80.1788650 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-4ubz~aqu5.47ug 100038 654989 2019-10-01 2019-04-30 694 92       84 870 54 89           1013
488 488 MEMORIAL HOSPITAL PEMBROKE 7800 SHERIDAN ST PEMBROKE PINES FL 33024 BROWARD (954) 962-9650 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.0309290 -80.2461200 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-qfg8-j8yz-crbc 100230 658928 2019-09-30 2019-04-30 277 24         301               301
491 491 UNIVERSITY HOSPITAL AND MEDICAL CENTER 7201 N UNIVERSITY DR TAMARAC FL 33321 BROWARD (954) 721-2200 Acute Care Hospitals Proprietary TRUE 26.2113850 -80.2525430 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-qbz6.9rz8_v3uh 100224 654910 2019-09-30 2019-04-30 230 15         245 60             305
495 495 MEMORIAL HOSPITAL MIRAMAR 1901 SW 172ND AVE MIRAMAR FL 33029 BROWARD (954) 538-4810 Acute Care Hospitals Government - Hospital District or Authority TRUE 25.9910870 -80.3760050 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-7am8-6328_i4i2 100285 654991 2019-09-30 2019-04-30 144 18       16 178               178
496 496 MEMORIAL HOSPITAL WEST 703 N FLAMINGO RD PEMBROKE PINES FL 33028 BROWARD (954) 436-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.0132810 -80.3094570 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-fm4e~wg84.85pf 100281 654881 2019-10-01 2019-04-30 434 32       20 486               486
502 502 PERRY MEMORIAL HOSPITAL 530 PARK AVENUE EAST PRINCETON IL 61356 BUREAU (815) 875-2811 Critical Access Hospitals Government - Local TRUE 41.3680100 -89.4559580 0   11 17 17011 36860 Chicago-Naperville, IL-IN-WI Central Bureau County https://data.medicare.gov/resource/xubh-q36u/row-93jr-f3xy_p6h2 141337 654839 2019-09-30 2019-04-30 22 3         25               25
577 577 ABRAZO WEST CAMPUS 13677 WEST MCDOWELL ROAD GOODYEAR AZ 85395 MARICOPA (623) 882-1970 Acute Care Hospitals Proprietary TRUE 33.4642830 -112.3540240 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-6kds~arrq.mhdd 30110 654825 2019-09-26 2019-04-30 159 20         179               179
707 707 CARNEGIE TRI-COUNTY MUNICIPAL HOSPITAL 102 NORTH BROADWAY CARNEGIE OK 73015 CADDO (580) 654-1050 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.1075540 -98.6049180 0   15 40 40015         https://data.medicare.gov/resource/xubh-q36u/row-z387~mqsi.t58v 371334 654941 2019-10-02 2019-04-30 17           17               17
1049 1049 GREENBRIER VALLEY MEDICAL CENTER 1320 MAPLEWOOD AVENUE RONCEVERTE WV 24970 GREENBRIER (304) 647-4411 Acute Care Hospitals Proprietary TRUE 37.7683729 -80.4652400 1 ROOFTOP 25 54 54025         https://data.medicare.gov/resource/xubh-q36u/row-bajh.9uz3-qmwc 510002 655663 2019-10-11 2019-04-30 80 12         92               92
1106 1106 SETON MEDICAL CENTER HARKER HEIGHTS 850 W CENTRAL TEXAS EXPRESSWAY HARKER HEIGHTS TX 76548 BELL (254) 953-8342 Acute Care Hospitals Proprietary TRUE 31.0742920 -97.6837070 0   27 48 48027 28660   Central Bell County https://data.medicare.gov/resource/xubh-q36u/row-qig4_ei54~8nwu 670080 654707 2019-09-27 2019-04-30 56 10         66               66
1145 1145 LAKE REGIONAL HEALTH SYSTEM 54 HOSPITAL DRIVE OSAGE BEACH MO 65065 CAMDEN (573) 348-8000 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.1184860 -92.6810850 0   29 29 29029         https://data.medicare.gov/resource/xubh-q36u/row-dyab~fgyi.56gt 260186 654682 2019-09-20 2019-04-30 82 18         100       16       116
1227 1227 WEST SUBURBAN MEDICAL CENTER 3 ERIE COURT OAK PARK IL 60302 COOK (708) 383-6200 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.8918400 -87.7774710 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-inku-rcmb~ijb5 140049 662038 2019-12-02 2019-04-30 114 21         135       39       174
1319 1319 CRAWFORD MEMORIAL HOSPITAL 1000 NORTH ALLEN STREET ROBINSON IL 62454 CRAWFORD (618) 544-3131 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.0136680 -87.7489990 0   33 17 17033         https://data.medicare.gov/resource/xubh-q36u/row-2yid-zac4-j637 141343 654840 2019-10-01 2019-04-30 25           25       35       60
1338 1338 WINDOM AREA HEALTH 2150 HOSPITAL DRIVE, PO BOX 339 WINDOM MN 56101 COTTONWOOD (507) 831-2400 Critical Access Hospitals Government - Local TRUE 43.8785870 -95.1136590 0   33 27 27033         https://data.medicare.gov/resource/xubh-q36u/row-9bd7-ibcv.unjw 241332 654451 2019-09-27 2019-04-30 18           18               18
1546 1546 FRANKLIN COUNTY MEMORIAL HOSPITAL 40 UNION CHURCH RD MEADVILLE MS 39653 FRANKLIN (601) 384-5801 Critical Access Hospitals Government - Local TRUE 31.4732480 -90.8849240 0   37 28 28037         https://data.medicare.gov/resource/xubh-q36u/row-bz6b_zt43.ihwe 251330 655016 2019-10-02 2019-04-30 24           24               24
1585 1585 SOUTHEAST GEORGIA HEALTH SYSTEM- CAMDEN CAMPUS 2000 DAN PROCTOR DRIVE SAINT MARYS GA 31558 CAMDEN (912) 576-6401 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.7812260 -81.6162340 0   39 13 13039 41220 Jacksonville-St. Marys-Palatka, FL-GA Central Camden County https://data.medicare.gov/resource/xubh-q36u/row-6d77.tapq.d4fg 110146 654884 2019-10-09 2019-04-30 35 5         40               40
1587 1587 WARNER HOSPITAL AND HEALTH SERVICES 422 W WHITE ST CLINTON IL 61727 DE WITT (217) 935-9571 Critical Access Hospitals Government - Local TRUE 40.1489530 -88.9646160 0   39 17 17039 14010 Bloomington-Pontiac, IL Outlying De Witt County https://data.medicare.gov/resource/xubh-q36u/row-gzhh-tmyy.cr8h 141303 654575 2019-09-26 2019-04-30 15           15               15
1647 1647 FRANKLIN MEDICAL CENTER 2106 LOOP ROAD WINNSBORO LA 71295 FRANKLIN (318) 435-9411 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.1588800 -91.7052340 0   41 22 22041         https://data.medicare.gov/resource/xubh-q36u/row-pz3b~fmut.fx5c 190140 654726 2019-10-01 2019-04-30 23 6         29   8           37
1679 1679 EVANSTON REGIONAL HOSPITAL 190 ARROWHEAD DR EVANSTON WY 82930 UINTA (307) 789-3636 Acute Care Hospitals Proprietary TRUE 41.2422140 -110.9913360 0   41 56 56041 21740   Central Uinta County https://data.medicare.gov/resource/xubh-q36u/row-7bqu_vhhd.zycd 530032 654952 2019-10-01 2019-04-30 26 6         32               32
1796 1796 COZAD COMMUNITY HOSPITAL P O BOX 108, 300 EAST 12TH ST COZAD NE 69130 DAWSON (308) 784-2261 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.8608215 -99.9856389 1 ROOFTOP 47 31 31047 30420   Central Dawson County https://data.medicare.gov/resource/xubh-q36u/row-kmiy~67m8-urj8 281327 654099 2019-09-03 2019-04-30 20           20               20
1837 1837 CLARK REGIONAL MEDICAL CENTER 175 HOSPITAL DRIVE WINCHESTER KY 40391 CLARK (859) 737-8559 Acute Care Hospitals Proprietary TRUE 38.0105110 -84.2145900 0   49 21 21049 30460 Lexington-Fayette--Richmond--Frankfort, KY Outlying Clark County https://data.medicare.gov/resource/xubh-q36u/row-6qnq-q4j6-cjcb 180092 655000 2019-09-30 2019-04-30 46 8         54       25       79
1903 1903 OCHSNER MEDICAL CENTER-KENNER 180 WEST ESPLANADE AVENUE KENNER LA 70065 JEFFERSON (504) 468-4806 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.0232200 -90.2729400 0   51 22 22051 35380 New Orleans-Metairie-Hammond, LA-MS Central Jefferson Parish https://data.medicare.gov/resource/xubh-q36u/row-kpkz-yefx.8u7y 190274 654728 2019-10-01 2019-04-30 94 16       5 115               115
1929 1929 GRAND STRAND REGIONAL MEDICAL CENTER 809 82ND PARKWAY MYRTLE BEACH SC 29572 HORRY (843) 692-1000 Acute Care Hospitals Proprietary TRUE 33.7547630 -78.8170790 0   51 45 45051 34820 Myrtle Beach-Conway, SC-NC Central Horry County https://data.medicare.gov/resource/xubh-q36u/row-h3q4.fsbg_rq3u 420085 654978 2019-10-15 2019-04-30 269 56         325 20 24           369
2138 2138 ADVENTHEALTH OTTAWA 1301 S MAIN STREET OTTAWA KS 66067 FRANKLIN (785) 229-8200 Acute Care Hospitals Government - Local FALSE 38.5972850 -95.2687590 0   59 20 20059 36840 Kansas City-Overland Park-Kansas City, MO-KS Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-kk74.krt5~vw4m 170014 654922 2019-10-01 2019-04-30 42 5         47               47
2187 2187 GEARY COMMUNITY HOSPITAL 1102 ST MARY'S ROAD JUNCTION CITY KS 66441 GEARY (785) 238-4131 Acute Care Hospitals Government - Local TRUE 39.0139790 -96.8497980 0   61 20 20061 27920 Manhattan-Junction City, KS Central Geary County https://data.medicare.gov/resource/xubh-q36u/row-7icr.pnr6-2rrn 170074 654924 2019-10-01 2019-04-30 43 6         49               49
2224 2224 GRANDE RONDE HOSPITAL 900 SUNSET DRIVE LA GRANDE OR 97850 UNION (541) 963-8421 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.3194640 -118.1048280 0   61 41 41061 29260   Central Union County https://data.medicare.gov/resource/xubh-q36u/row-k86m-d2cq~y5ce 381321 655414 2019-09-30 2019-04-30 21 4         25               25
2228 2228 VALLEY BAPTIST MEDICAL CENTER- BROWNSVILLE 1040 W JEFFERSON ST BROWNSVILLE TX 78520 CAMERON (956) 544-1400 Acute Care Hospitals Proprietary TRUE 25.9179310 -97.5119980 0   61 48 48061 15180 Brownsville-Harlingen-Raymondville, TX Central Cameron County https://data.medicare.gov/resource/xubh-q36u/row-2uxr-b9vz.7eni 450028 654696 2019-09-26 2019-04-30 183 24       36 243               243
2294 2294 RIVERSIDE COMMUNITY HOSPITAL 4445 MAGNOLIA AVENUE RIVERSIDE CA 92501 RIVERSIDE (951) 788-3000 Acute Care Hospitals Proprietary TRUE 33.9756770 -117.3803740 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-ty8u-4v9q_uu58 50022 655522 2019-10-25 2019-04-30 389 69     20   478               478
2313 2313 TRI VALLEY HEALTH SYSTEM 1305 WEST HIGHWAY 6/34 CAMBRIDGE NE 69022 FURNAS (308) 697-3329 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.2799040 -100.1796670 0   65 31 31065         https://data.medicare.gov/resource/xubh-q36u/row-zzb6-y5xk.yxhu 281348 654968 2019-10-02 2019-04-30 20           20           34   54
2380 2380 CAPITAL MEDICAL CENTER 3900 CAPITAL MALL DR SW OLYMPIA WA 98502 THURSTON (360) 754-5858 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.0416660 -122.9514460 0   67 53 53067 36500 Seattle-Tacoma, WA Central Thurston County https://data.medicare.gov/resource/xubh-q36u/row-gmh8.c3a3.g94s 500139 654948 2019-10-01 2019-04-30 77 30         107               107
2471 2471 PHILLIPS COUNTY MEDICAL CENTER 311 S 8TH AVE E MALTA MT 59538 PHILLIPS (406) 654-1100 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3570980 -107.8603560 0   71 30 30071         https://data.medicare.gov/resource/xubh-q36u/row-igja_7yh6.38ai 271312 654589 2019-09-16 2019-04-30 6           6               6
2523 2523 CAPITAL REGIONAL MEDICAL CENTER 2626 CAPITAL MEDICAL BLVD TALLAHASSEE FL 32308 LEON (850) 656-5000 Acute Care Hospitals Proprietary TRUE 30.4753760 -84.2307280 0   73 12 12073 45220 Tallahassee-Bainbridge, FL-GA Central Leon County https://data.medicare.gov/resource/xubh-q36u/row-9js5~veid~7wjn 100254 654879 2019-10-01 2019-04-30 246 20         266               266
2689 2689 BLAKE MEDICAL CENTER 2020 59TH ST W BRADENTON FL 34209 MANATEE (941) 792-6611 Acute Care Hospitals Proprietary TRUE 27.4821760 -82.6204680 0   81 12 12081 35840 North Port-Sarasota, FL Central Manatee County https://data.medicare.gov/resource/xubh-q36u/row-u4hx_qmug-pkiw 100213 654646 2019-09-30 2019-04-30 312 43         355   28           383
2798 2798 ROOSEVELT MEDICAL CENTER 818 2ND AVE E CULBERTSON MT 59218 ROOSEVELT (406) 787-6401 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1513360 -104.5153960 0   85 30 30085         https://data.medicare.gov/resource/xubh-q36u/row-gk89.j8w2.ytb6 271308 655564 2019-10-03 2019-04-30 33           33               33
2929 2929 COLUMBUS COMMUNITY HOSPITAL 110 SHULT DR COLUMBUS TX 78934 COLORADO (979) 732-2371 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.6942870 -96.5424830 0   89 48 48089         https://data.medicare.gov/resource/xubh-q36u/row-sd44-u9xj_6uxs 450370 654698 2019-09-26 2019-04-30 40           40               40
2991 2991 RAULERSON HOSPITAL 1796 HWY 441 NORTH OKEECHOBEE FL 34972 OKEECHOBEE (863) 763-2151 Acute Care Hospitals Proprietary TRUE 27.2605370 -80.8298750 0   93 12 12093 36380 Miami-Fort Lauderdale-Port St. Lucie, FL Central Okeechobee County https://data.medicare.gov/resource/xubh-q36u/row-vc8e_g3z6_7i2k 100252 654911 2019-09-30 2019-04-30 92 8         100               100
3035 3035 GALESBURG COTTAGE HOSPITAL 695 N KELLOGG ST GALESBURG IL 61401 KNOX (309) 343-8131 Acute Care Hospitals Proprietary TRUE 40.9554830 -90.3661990 0   95 17 17095 23660   Central Knox County https://data.medicare.gov/resource/xubh-q36u/row-yqg9.hnf4.susd 140040 654913 2019-09-30 2019-04-30 84 12         96 16             112
3040 3040 KINGMAN COMMUNITY HOSPITAL 750 W AVE D KINGMAN KS 67068 KINGMAN (620) 532-3147 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.6467340 -98.1235520 0   95 20 20095 48620 Wichita-Arkansas City-Winfield, KS Outlying Kingman County https://data.medicare.gov/resource/xubh-q36u/row-tz8a.6b7b-6c5w 171378 655269 2019-10-09 2019-04-30 25           25               25
3256 3256 ST PETERSBURG GENERAL HOSPITAL 6500 38TH AVE N SAINT PETERSBURG FL 33710 PINELLAS (727) 384-1414 Acute Care Hospitals Proprietary TRUE 27.8062990 -82.7272970 0   103 12 12103 45300   Central Pinellas County https://data.medicare.gov/resource/xubh-q36u/row-3jhj_fk97_piqx 100180 654909 2019-09-30 2019-04-30 147 21         168               168
3565 3565 MARTIN GENERAL HOSPITAL 310 S MCCASKEY RD P O BOX 1128 WILLIAMSTON NC 27892 MARTIN (252) 809-6179 Acute Care Hospitals Government - Local TRUE 35.8404770 -77.0711780 0   117 37 37117         https://data.medicare.gov/resource/xubh-q36u/row-6ty4.gevs-5eff 340133 654859 2019-09-25 2019-04-30 37 6         43               43
3659 3659 TEXAS HEALTH PRESBYTERIAN HOSPITAL DENTON 3000 N I-35 DENTON TX 76201 DENTON (940) 898-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.2158990 -97.1684090 0   121 48 48121 19100 Dallas-Fort Worth, TX-OK Outlying Denton County https://data.medicare.gov/resource/xubh-q36u/row-zgka~geeq~8cey 450743 654761 2019-09-30 2019-04-30 166 20       10 196               196
3744 3744 SOUTHEAST GEORGIA HEALTH SYSTEM- BRUNSWICK CAMPUS 2415 PARKWOOD DRIVE BRUNSWICK GA 31520 GLYNN (912) 466-7000 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.1737850 -81.4845160 0   127 13 13127 15260   Central Glynn County https://data.medicare.gov/resource/xubh-q36u/row-imkf_sszd.zwtd 110025 654571 2019-10-01 2019-04-30 276   12   12   300               300
3787 3787 BRODSTONE MEMORIAL HOSP P O BOX 187, 520 EAST 10TH ST SUPERIOR NE 68978 NUCKOLLS (402) 879-3281 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.0266410 -98.0661260 1 ROOFTOP 129 31 31129         https://data.medicare.gov/resource/xubh-q36u/row-w2de_bhr4_4ftq 281315 653977 2019-08-27 2019-04-30 25           25               25
3791 3791 ROGER MILLS MEMORIAL HOSPITAL 501 SOUTH L L MALES AVENUE CHEYENNE OK 73628 ROGER MILLS (580) 497-3336 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.6092050 -99.6719970 0   129 40 40129         https://data.medicare.gov/resource/xubh-q36u/row-6ptj~4g4e-4ctv 371303 653453 2019-09-04 2019-04-30 15           15               15
3904 3904 ENNIS REGIONAL MEDICAL CENTER 2201 WEST LAMPASAS STREET ENNIS TX 75119 ELLIS (972) 875-0900 Acute Care Hospitals Proprietary TRUE 32.3085420 -96.6420240 0   139 48 48139 19100 Dallas-Fort Worth, TX-OK Central Ellis County https://data.medicare.gov/resource/xubh-q36u/row-qnja~psci_63qw 450833 654979 2019-10-02 2019-04-30 54 6         60               60
3911 3911 ROCHELLE COMMUNITY HOSPITAL 900 N 2ND ST ROCHELLE IL 61068 OGLE (815) 562-2181 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.9285730 -89.0628010 0   141 17 17141 40300 Rockford-Freeport-Rochelle, IL Central Ogle County https://data.medicare.gov/resource/xubh-q36u/row-k7rn.qbh3~e5z4 141312 652925 2019-08-09 2019-04-30 13 4         17               17
3921 3921 COLUMBUS COMMUNITY HOSPITAL 4600 38TH ST COLUMBUS NE 68601 PLATTE (402) 562-3351 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.4532730 -97.3849000 0   141 31 31141 18100   Central Platte County https://data.medicare.gov/resource/xubh-q36u/row-bffi-hycr-hipw 280111 654935 2019-09-30 2019-04-30 42 5         47           4   51
3969 3969 PINCKNEYVILLE COMMUNITY HOSPITAL 5383 STATE ROUTE 154 PINCKNEYVILLE IL 62274 PERRY (618) 357-2187 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.0802300 -89.3686310 0   145 17 17145         https://data.medicare.gov/resource/xubh-q36u/row-dga8~impq_xpvi 141307 654837 2019-09-30 2019-04-30 17           17               17
4121 4121 HOSPITAL DISTRICT #1 OF RICE COUNTY 619 SOUTH CLARK AVENUE LYONS KS 67554 RICE (620) 257-5173 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.3416700 -98.2161460 0   159 20 20159         https://data.medicare.gov/resource/xubh-q36u/row-pqa8~iuy6-awei 171330 654925 2019-09-30 2019-04-30 25           25               25
4194 4194 SUMNER REGIONAL MEDICAL CENTER 555 HARTSVILLE PIKE GALLATIN TN 37066 SUMNER (615) 452-4210 Acute Care Hospitals Proprietary TRUE 36.3911170 -86.4343410 0   165 47 47165 34980 Nashville-Davidson--Murfreesboro, TN Central Sumner County https://data.medicare.gov/resource/xubh-q36u/row-5cut-g6dp_ruat 440003 654752 2019-10-01 2019-04-30 108 18         126 12 17           155
4262 4262 FAIRVIEW PARK HOSPITAL 200 INDUSTRIAL BOULEVARD DUBLIN GA 31021 LAURENS (478) 274-3100 Acute Care Hospitals Proprietary TRUE 32.5342900 -82.9505710 0   175 13 13175 20140   Central Laurens County https://data.medicare.gov/resource/xubh-q36u/row-hhiu.9x9h.7ym6 110125 654912 2019-09-30 2019-04-30 129 16         145   15           160
4280 4280 SPOTSYLVANIA REGIONAL MEDICAL CENTER 4600 SPOTSYLVANIA PARKWAY FREDERICKSBURG VA 22408 SPOTSYLVANIA (540) 498-4000 Acute Care Hospitals Proprietary TRUE 38.2194960 -77.4964500 0   177 51 51177 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Outlying Spotsylvania County https://data.medicare.gov/resource/xubh-q36u/row-vmhu-vfub_yswh 490141 654902 2019-10-01 2019-04-30 93 12         105 28             133
4286 4286 OTTUMWA REGIONAL HEALTH CENTER 1001 E PENNSYLVANIA OTTUMWA IA 52501 WAPELLO (641) 682-7511 Acute Care Hospitals Proprietary TRUE 41.0288887 -92.3895049 1 ROOFTOP 179 19 19179 36900   Central Wapello County https://data.medicare.gov/resource/xubh-q36u/row-q5qs.dgin-w3wa 160089 654920 2019-10-01 2019-04-30 77 11         88 14 18           120
4334 4334 STE GENEVIEVE COUNTY MEMORIAL HOSPITAL 800 STE GENEVIEVE DRIVE, PO BOX 468 SAINTE GENEVIEVE MO 63670 STE. GENEVIEVE (573) 883-2751 Critical Access Hospitals Government - Local TRUE 37.9683470 -90.0539680 0   186 29 29186         https://data.medicare.gov/resource/xubh-q36u/row-iyp8-esxx-7fb7 261330 654735 2019-09-18 2019-04-30 25           25               25
4346 4346 WASHINGTON COUNTY HOSPITAL* 705 S GRAND AVE NASHVILLE IL 62263 WASHINGTON (618) 327-8236 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.3391180 -89.3900160 0   189 17 17189         https://data.medicare.gov/resource/xubh-q36u/row-auqk.8tcs_r835 141308 654623 2019-09-27 2019-04-30 22           22           28   50
4376 4376 CGH MEDICAL CENTER 100 EAST LEFEVRE ROAD STERLING IL 61081 WHITESIDE (815) 625-0400 Acute Care Hospitals Government - Local TRUE 41.8015640 -89.6967330 0   195 17 17195 44580 Dixon-Sterling, IL Central Whiteside County https://data.medicare.gov/resource/xubh-q36u/row-r8ij~7z4w-xsmp 140043 654428 2019-09-25 2019-04-30 87 9         96               96
4381 4381 FITZGIBBON HOSPITAL 2305 S 65 HIGHWAY MARSHALL MO 65340 SALINE (660) 886-7431 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0917436 -93.2127743 1 ROOFTOP 195 29 29195 32180   Central Saline County https://data.medicare.gov/resource/xubh-q36u/row-ys9m_swcv-jz6s 260142 655131 2019-10-03 2019-04-30 35 7         42 10             52
4396 4396 HEARTLAND REGIONAL MEDICAL CENTER 3333 W DEYOUNG MARION IL 62959 WILLIAMSON (618) 998-7000 Acute Care Hospitals Proprietary TRUE 37.7448910 -88.9888480 0   199 17 17199 16060   Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-emxq~znat.w4hm 140184 654916 2019-09-27 2019-04-30 76 18         94               94
4468 4468 UT HEALTH EAST TEXAS ATHENS HOSPITAL 2000 SOUTH PALESTINE ST ATHENS TX 75751 HENDERSON (903) 676-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.1714350 -95.8440220 0   213 48 48213 11980 Dallas-Fort Worth, TX-OK Central Henderson County https://data.medicare.gov/resource/xubh-q36u/row-6sng~44js.9u5g 450389 654699 2019-09-27 2019-04-30 117 10         127               127
4486 4486 TRIGG COUNTY HOSPITAL 254 MAIN STREET CADIZ KY 42211 TRIGG (270) 522-3215 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.8672470 -87.8212880 0   221 21 21221 17300   Outlying Trigg County https://data.medicare.gov/resource/xubh-q36u/row-qahg~w3bp-8dce 181304 655003 2019-10-01 2019-04-30 25           25               25
4543 4543 CHATUGE REGIONAL HOSPITAL 110 S MAIN STREET HIAWASSEE GA 30546 TOWNS (706) 896-2222 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.9462820 -83.7543180 0   281 13 13281         https://data.medicare.gov/resource/xubh-q36u/row-mh6r.8qji~7cpb 111324 654720 2019-10-07 2019-04-30 25           25 10     112       147
4548 4548 UNION GENERAL HOSPITAL 35 HOSPITAL ROAD BLAIRSVILLE GA 30512 UNION (706) 745-2111 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.8848420 -83.9630260 0   291 13 13291         https://data.medicare.gov/resource/xubh-q36u/row-rhka-pzv3.hh9q 110051 657716 2019-11-06 2019-04-30 34 5         39       150       189
4571 4571 WILLS MEMORIAL HOSPITAL 120 GORDON STREET WASHINGTON GA 30673 WILKES (706) 678-9212 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.7293020 -82.7423880 0   317 13 13317         https://data.medicare.gov/resource/xubh-q36u/row-xbea-eh76-aa8t 111325 654422 2019-09-23 2019-04-30 25           25               25
4572 4572 MARTIN COUNTY HOSPITAL DISTRICT 600 E INTERSTATE 20 PO BOX 640 STANTON TX 79782 MARTIN (432) 756-3345 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.1397988 -101.7870627 1 ROOFTOP 317 48 48317 33260 Midland-Odessa, TX Outlying Martin County https://data.medicare.gov/resource/xubh-q36u/row-b2bs_dpvv_us2e 451333 655474 2019-10-01 2019-04-30 18           18               18

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
);