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

4,766 rows sorted by oth_longterm_beds descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, burn_beds, subprovider_oth_beds, filed_date (date), fy_end_date (date)

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
3080 3080 SONOMA DEVELOPMENTAL CENTER 15000 ARNOLD DRIVE / P O BOX 1493 ELDRIDGE CA 95431 SONOMA (707) 938-6000 Acute Care Hospitals Government - State FALSE 38.3490270 -122.5169100 0   97 6 6097 42220 San Jose-San Francisco-Oakland, CA Central Sonoma County https://data.medicare.gov/resource/xubh-q36u/row-j6wx.73xx-wqrm 50547 638175 2018-11-27 2018-06-30 13           13           963   976
4632 4632 SWISHER MEMORIAL HOSPITAL 539 SOUTHEAST 2ND TULIA TX 79088 SWISHER (806) 995-3581 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.5355710 -101.7564100 0   437 48 48437         https://data.medicare.gov/resource/xubh-q36u/row-mwcs~qsjd_wfa3 451349 649506 2019-05-28 2018-12-31 20           20           9   29
415 415 MASONICARE HEALTH CENTER 22 MASONIC AVE WALLINGFORD CT 6492 NEW HAVEN (203) 679-5900 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.4606980 -72.8365860 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-qb4p-gu4j_xpz9 70039 645323 2019-02-28 2018-09-30 30           30 29     366   86   511
2442 2442 COMMUNITY HOSPITAL OF SAN BERNARDINO 1805 MEDICAL CENTER DRIVE SAN BERNARDINO CA 92411 SAN BERNARDINO (909) 887-6333 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1312380 -117.3225590 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-7h58.yy87~u565 50089 661456 2019-12-03 2019-06-30 155 21       9 185 74     88   84   431
2133 2133 ST MARY'S HOSPITAL 1230 BAXTER STREET ATHENS GA 30606 CLARKE (706) 389-3930 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.9459290 -83.4044670 0   59 13 13059 12020 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Clarke County https://data.medicare.gov/resource/xubh-q36u/row-sxr7_vrrg_xb9c 110006 660364 2019-12-03 2019-06-30 97 68         165   20       83   268
4347 4347 STEVENS COUNTY HOSPITAL 1006 S JACKSON HUGOTON KS 67951 STEVENS (620) 544-8511 Critical Access Hospitals Government - Local TRUE 37.1708080 -101.3497550 0   189 20 20189         https://data.medicare.gov/resource/xubh-q36u/row-39kr.3u54-pmuw 171335 649737 2019-06-03 2018-12-31 17           17           83   100
4220 4220 STORY COUNTY HOSPITAL 640 SOUTH 19TH STREET NEVADA IA 50201 STORY (515) 382-2111 Critical Access Hospitals Government - Local TRUE 42.0053340 -93.4349020 0   169 19 19169 11180 Des Moines-Ames-West Des Moines, IA Central Story County https://data.medicare.gov/resource/xubh-q36u/row-qdh4.4mty_76ab 161333 660968 2019-11-26 2019-06-30 17           17           80   97
347 347 MIDDLESEX HOSPITAL 28 CRESCENT ST MIDDLETOWN CT 6457 MIDDLESEX (860) 344-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.5548650 -72.6476330 0   7 9 9007 25540 Hartford-West Hartford, CT Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-5y9n.3un3_8zm4 70020 647876 2019-05-14 2018-09-30 185 24         209 20         8   237
3613 3613 NOVANT HEALTH PRESBYTERIAN MEDICAL CENTER 200 HAWTHORNE LANE BOX 33549 CHARLOTTE NC 28233 MECKLENBURG (704) 384-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.2128790 -80.8256140 0   119 37 37119 16740 Charlotte-Concord, NC-SC Central Mecklenburg County https://data.medicare.gov/resource/xubh-q36u/row-c933.3qxr.ys3x 340053 650338 2019-05-31 2018-12-31 483 34 12       535 55     12   8   610
4384 4384 HANSFORD COUNTY HOSPITAL 707 ROLAND ST SPEARMAN TX 79081 HANSFORD (806) 659-2535 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.1904750 -101.2001270 0   195 48 48195         https://data.medicare.gov/resource/xubh-q36u/row-4gxw_72vt-83ub 451344 643658 2019-02-26 2018-09-30 14           14           8   22
3052 3052 ST LUKES HOSPITAL OF KANSAS CITY 4401 WORNALL ROAD KANSAS CITY MO 64111 JACKSON (816) 932-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0461340 -94.5901500 0   95 29 29095 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-s8k3_pstx~aqw7 260138 650169 2019-05-31 2018-12-31 327 71       45 443   17       73   533
2096 2096 MILE BLUFF MEDICAL CENTER 1050 DIVISION ST MAUSTON WI 53948 JUNEAU (608) 847-6161 Acute Care Hospitals Proprietary TRUE 43.7826140 -90.0767780 0   57 55 55057         https://data.medicare.gov/resource/xubh-q36u/row-vhj9.ky6f.dqa4 520109 644389 2019-02-27 2018-09-30 40           40       60   72   172
4284 4284 HOPEDALE HOSPITAL 107 TREMONT STREET HOPEDALE IL 61747 TAZEWELL (309) 449-4296 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.4183830 -89.4177290 0   179 17 17179 37900 Peoria-Canton, IL Central Tazewell County https://data.medicare.gov/resource/xubh-q36u/row-xd8s-ubf6_48ka 141330 661879 2019-12-06 2019-06-30 25           25         59 72   156
3916 3916 SANFORD SHELDON MEDICAL CENTER 118 NORTH 7TH AVENUE SHELDON IA 51201 OBRIEN (712) 324-5041 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.1863870 -95.8472680 0   141 19 19141         https://data.medicare.gov/resource/xubh-q36u/row-dbh5_z7mp.tsgp 161381 648616 2019-05-23 2018-12-31 25           25           70   95
2136 2136 HANCOCK REGIONAL HOSPITAL 801 N STATE ST GREENFIELD IN 46140 HANCOCK (317) 462-5544 Acute Care Hospitals Government - Local TRUE 39.7949520 -85.7696040 0   59 18 18059 26900 Indianapolis-Carmel-Muncie, IN Central Hancock County https://data.medicare.gov/resource/xubh-q36u/row-9wnz_ckw6~khmk 150037 649205 2019-05-31 2018-12-31 37 24         61 10         7   78
3449 3449 CHAN SOON- SHIONG MEDICAL CENTER AT WINDBER 600 SOMERSET AVENUE WINDBER PA 15963 SOMERSET (814) 467-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.2421230 -78.8379170 0   111 42 42111 43740 Johnstown-Somerset, PA Central Somerset County https://data.medicare.gov/resource/xubh-q36u/row-fcgp~zjpu~zgnn 390112 660443 2019-11-27 2019-06-30 41 6         47           7   54
3619 3619 GENESIS HOSPITAL 2951 MAPLE AVENUE ZANESVILLE OH 43701 MUSKINGUM (740) 454-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9757310 -82.0142450 0   119 39 39119 49780 Columbus-Marion-Zanesville, OH Central Muskingum County https://data.medicare.gov/resource/xubh-q36u/row-p28m~2s52~jwnm 360039 649309 2019-05-31 2018-12-31 234 24 24       282           7   289
3169 3169 MERCY HOSPITAL JEFFERSON 1400 US HIGHWAY 61 FESTUS MO 63028 JEFFERSON (636) 933-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.1959620 -90.3954230 0   99 29 29099 41180 St. Louis-St. Charles-Farmington, MO-IL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-ucir-8k6g_zhv5 260023 660112 2019-11-26 2019-06-30 251 28         279   42       63   384
1848 1848 MISSISSIPPI METHODIST REHAB CTR 1350 E WOODROW WILSON DR JACKSON MS 39216 HINDS (601) 981-2611 Acute Care Hospitals Voluntary non-profit - Private FALSE 32.3268300 -90.1721800 0   49 28 28049 27140 Jackson-Vicksburg-Brookhaven, MS Central Hinds County https://data.medicare.gov/resource/xubh-q36u/row-msuq_x57k.afv9 250152 659986 2019-12-03 2019-06-30 31           31   93       60   184
2576 2576 ALLIANCE HEALTH CENTER 5000 HIGHWAY 39 NORTH MERIDIAN MS 39301 LAUDERDALE (601) 483-6211 Acute Care Hospitals Proprietary FALSE 32.4099880 -88.6788110 0   75 28 28075 32940   Central Lauderdale County https://data.medicare.gov/resource/xubh-q36u/row-u23i_wk6s_4s84 250151 649279 2019-05-29 2018-12-31 83           83 71         60   214
4204 4204 HEGG MEMORIAL HEALTH CENTER 1202 21ST AVENUE ROCK VALLEY IA 51247 SIOUX (712) 476-8000 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.2016930 -96.2850860 0   167 19 19167         https://data.medicare.gov/resource/xubh-q36u/row-5p5r_j23k-rsrv 161336 639251 2018-12-03 2018-06-30 25           25           60   85
4348 4348 ST LUKES HOSPITAL 232 S WOODS MILL RD CHESTERFIELD MO 63017 ST. LOUIS (314) 434-1500 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.6530660 -90.5059200 0   189 29 29189 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-sqq4~n4bf~fm2b 260179 661211 2019-12-02 2019-06-30 360 18 16       394       70   60   524
434 434 T J SAMSON COMMUNITY HOSPITAL 1301 NORTH RACE STREET GLASGOW KY 42141 BARREN (270) 651-4159 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.0115660 -85.9038620 0   9 21 21009 23980 Bowling Green-Glasgow, KY Central Barren County https://data.medicare.gov/resource/xubh-q36u/row-ry2c-3t2y_53py 180017 643409 2019-02-14 2018-09-30 94 10       4 108       16   6   130
2067 2067 GREAT RIVER MEDICAL CENTER 1221 SOUTH GEAR AVENUE WEST BURLINGTON IA 52655 DES MOINES (319) 768-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8073690 -91.1702780 0   57 19 19057 15460   Central Des Moines County https://data.medicare.gov/resource/xubh-q36u/row-8pkk_2khg-h2nd 160057 660081 2019-11-26 2019-06-30 124 12         136   11   160   6   313
2388 2388 ESTES PARK MEDICAL CENTER 555 PROSPECT AVE ESTES PARK CO 80517 LARIMER (970) 577-4470 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.3722590 -105.5140880 0   69 8 8069 22660   Central Larimer County https://data.medicare.gov/resource/xubh-q36u/row-3yeq~tw3h-6ggv 61312 649878 2019-06-03 2018-12-31 25           25       60   6   91
2856 2856 F W HUSTON MEDICAL CENTER 408 DELAWARE STREET WINCHESTER KS 66097 JEFFERSON (913) 774-4340 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3252310 -95.2704010 0   87 20 20087 45820   Outlying Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-ms4u_ppxf-axv2 171314 649589 2019-06-03 2018-12-31 25           25         38 6   69
3707 3707 PELLA REGIONAL HEALTH CENTER 404 JEFFERSON STREET PELLA IA 50219 MARION (641) 628-3150 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4123370 -92.9116670 0   125 19 19125         https://data.medicare.gov/resource/xubh-q36u/row-8vwd.cjzd~uvhp 161367 649107 2019-05-30 2018-12-31 22 3         25           6   31
3860 3860 UNIVERSITY OF NORTH CAROLINA HOSPITAL 101 MANNING DRIVE CHAPEL HILL NC 27514 ORANGE (919) 966-4141 Acute Care Hospitals Government - State TRUE 35.9035510 -79.0518940 0   135 37 37135 20500 Raleigh-Durham-Chapel Hill, NC Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-pha8_ahwj~xmph 340061 660649 2019-11-27 2019-06-30 676   13       803 104 30       6   943
4037 4037 MARLETTE REGIONAL HOSPITAL 2770 MAIN STREET MARLETTE MI 48453 SANILAC (989) 635-4000 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3325790 -83.0801600 0   151 26 26151         https://data.medicare.gov/resource/xubh-q36u/row-zwdj_2e6m-nqmv 231330 661912 2019-12-04 2019-06-30 25           25       39   6   70
4523 4523 ANSON GENERAL HOSPITAL 101 AVENUE J ANSON TX 79501 JONES (325) 823-3231 Acute Care Hospitals Government - Local TRUE 32.7681010 -99.8955140 0   253 48 48253 10180   Outlying Jones County https://data.medicare.gov/resource/xubh-q36u/row-yt33_gjz7-gmyy 450078 653860 2019-09-03 2019-03-31 7           7           6   13
1299 1299 SOUTHWESTERN MEDICAL CENTER 5602 SOUTHWEST LEE BOULEVARD LAWTON OK 73505 COMANCHE (580) 531-4700 Acute Care Hospitals Proprietary TRUE 34.5943840 -98.4616920 0   31 40 40031 30020   Central Comanche County https://data.medicare.gov/resource/xubh-q36u/row-ug5c.7srv-ty4g 370097 645946 2019-03-29 2018-10-31 118 8         126   14       59   199
2037 2037 KERSHAWHEALTH 1315 ROBERTS STREET CAMDEN SC 29020 KERSHAW (803) 432-4311 Acute Care Hospitals Proprietary TRUE 34.2531640 -80.5895790 0   55 45 45055 17900 Columbia-Orangeburg-Newberry, SC Outlying Kershaw County https://data.medicare.gov/resource/xubh-q36u/row-938m.r575~tkt8 420048 643943 2019-02-28 2018-09-30 113 10         123           55   178
3466 3466 MERCY MEDICAL CENTER - CEDAR RAPIDS 701 10TH STREET SE CEDAR RAPIDS IA 52403 LINN (319) 398-6011 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.9789040 -91.6547980 0   113 19 19113 16300 Cedar Rapids-Iowa City, IA Central Linn County https://data.medicare.gov/resource/xubh-q36u/row-7dnx~5kka-c4y8 160079 659786 2019-11-19 2019-06-30 165 20       9 194 20 8   21   55   298
2787 2787 MIDWEST MEDICAL CENTER 1 MEDICAL CENTER DRIVE GALENA IL 61036 JO DAVIESS (815) 777-1340 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.4466220 -90.4569720 0   85 17 17085         https://data.medicare.gov/resource/xubh-q36u/row-gqwe-keau_be9a 141302 645763 2019-03-04 2018-09-30 25           25       5   52   82
3356 3356 AVERA GETTYSBURG HOSPITAL 606 EAST GARFIELD GETTYSBURG SD 57442 POTTER (605) 765-2480 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.0135510 -99.9481280 0   107 46 46107         https://data.medicare.gov/resource/xubh-q36u/row-5ptc-f9a4-vq7p 431302 660878 2019-12-02 2019-06-30 10           10           50   60
3859 3859 PERKINS COUNTY HEALTH SERVICES 900 LINCOLN AVE GRANT NE 69140 PERKINS (308) 352-7200 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.8482680 -101.7271820 0   135 31 31135         https://data.medicare.gov/resource/xubh-q36u/row-g4pp~ymgi-thrv 281356 661045 2019-12-02 2019-06-30 20           20           50   70
969 969 JFK MEDICAL CTR - ANTHONY M. YELENCSICS COMMUNITY 65 JAMES STREET EDISON NJ 8818 MIDDLESEX (732) 321-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5578700 -74.3494990 0   23 34 34023 35620 New York-Newark, NY-NJ-CT-PA Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-zhxr.nkau-6xsq 310108 654971 2019-10-11 2018-12-31 319   38       357   90       5   452
1457 1457 PIH HEALTH HOSPITAL-WHITTIER 12401 WASHINGTON BLVD WHITTIER CA 90602 LOS ANGELES (526) 698-0811 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.9674330 -118.0481430 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-b7rk~kcm9_yqnp 50169 645229 2019-03-20 2018-09-30 274 24         332   17   35   5   389
3058 3058 TOWNER COUNTY MEDICAL CENTER HWY 281 N CANDO ND 58324 TOWNER (701) 968-4411 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.4931522 -99.2110430 1 ROOFTOP 95 38 38095         https://data.medicare.gov/resource/xubh-q36u/row-8pd6_eppf-kx3r 351331 638004 2018-11-28 2018-06-30 20           20       30   5   55
1125 1125 DELANO REGIONAL MEDICAL CENTER 1401 GARCES HIGHWAY DELANO CA 93215 KERN (661) 725-4800 Acute Care Hospitals Proprietary TRUE 35.7614180 -119.2388780 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-6xns.bkw3_m9qr 50608 650656 2019-05-31 2018-12-31 95 10         105       2   49   156
392 392 BENNETT COUNTY HOSPITAL AND NURSING HOME - CAH 102 MAJOR ALLEN POST OFFICE BOX 70D MARTIN SD 57551 BENNETT (605) 685-6622 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.1691630 -101.7266636 1 RANGE_INTERPOLATED 7 46 46007         https://data.medicare.gov/resource/xubh-q36u/row-q2mg~bq2u~fi2w 431314 649823 2019-06-03 2018-12-31 14           14           48   62
981 981 PLATTE HEALTH CENTER - CAH 601 E 7TH ST POST OFFICE BOX 200 PLATTE SD 57369 CHARLES MIX (605) 337-3364 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3841820 -98.8363950 0   23 46 46023         https://data.medicare.gov/resource/xubh-q36u/row-xvc7~qr28~rnsw 431306 656513 2019-11-05 2019-06-30 17           17           48   65
2709 2709 MEMORIAL HOSPITAL 1423 SEVENTH ST AURORA NE 68818 HAMILTON (402) 694-3171 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.8718120 -98.0095310 0   81 31 31081 24260   Outlying Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-t366-wmec-vg9c 281320 643279 2019-02-12 2018-09-30 14           14           47   61
414 414 CONNECTICUT HOSPICE INC,THE 100 DOUBLE BEACH ROAD BRANFORD CT 6405 NEW HAVEN (203) 315-7500 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.2563050 -72.8333670 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-9pw4-ddrr.eyyi 70038 645241 2019-03-01 2018-09-30 6           6           46   52
1070 1070 MANNING REGIONAL HEALTHCARE CENTER 1550 SIXTH STREET MANNING IA 51455 CARROLL (712) 655-2072 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.9066500 -95.0750130 0   27 19 19027         https://data.medicare.gov/resource/xubh-q36u/row-guzz_e3r6~bpt6 161332 660967 2019-12-02 2019-06-30 17           17           46   63
3370 3370 LOGAN COUNTY HOSPITAL 211 CHERRY AVENUE OAKLEY KS 67748 LOGAN (785) 672-3211 Critical Access Hospitals Government - Local TRUE 39.1269150 -100.8622790 0   109 20 20109         https://data.medicare.gov/resource/xubh-q36u/row-wi6i-q2iz.xd59 171326 649592 2019-06-03 2018-12-31 25           25           45   70
3594 3594 MEADE DISTRICT HOSPITAL 510 EAST CARTHAGE MEADE KS 67864 MEADE (620) 873-2141 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.2854900 -100.3342670 0   119 20 20119         https://data.medicare.gov/resource/xubh-q36u/row-9yc7~mw74.3m9f 171321 649590 2019-06-03 2018-12-31 20           20           45   65
2685 2685 SETON MEDICAL CENTER 1900 SULLIVAN AVENUE DALY CITY CA 94015 SAN MATEO (650) 992-4000 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.6803150 -122.4729100 0   81 6 6081 41860 San Jose-San Francisco-Oakland, CA Central San Mateo County https://data.medicare.gov/resource/xubh-q36u/row-cym9-4kks~kvua 50289 660168 2019-11-25 2019-06-30 227 28         255 24     155   44   478
2698 2698 SATANTA DISTRICT HOSPITAL CHEYENNE & APACHE SATANTA KS 67870 HASKELL (620) 649-2761 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.4374237 -100.9856235 1 GEOMETRIC_CENTER 81 20 20081         https://data.medicare.gov/resource/xubh-q36u/row-5zm3-qnsy-hby4 171324 648917 2019-05-28 2018-12-31 13           13           44   57
4307 4307 WASHINGTON COUNTY HOSPITAL AND CLINICS 400 EAST POLK STREET WASHINGTON IA 52353 WASHINGTON (319) 653-5481 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.2885070 -91.6873410 0   183 19 19183 26980 Cedar Rapids-Iowa City, IA Outlying Washington County https://data.medicare.gov/resource/xubh-q36u/row-nap2.kaue_yw5q 161344 659673 2019-11-20 2019-06-30 25           25           43   68
2250 2250 GOVE COUNTY MEDICAL CENTER 520 WEST 5TH STREET QUINTER KS 67752 GOVE (785) 754-3341 Critical Access Hospitals Voluntary non-profit - Other TRUE 39.0671610 -100.2413110 0   63 20 20063         https://data.medicare.gov/resource/xubh-q36u/row-yfic-b2ck-cmkm 171367 648622 2019-05-24 2018-12-31 21           21           42   63
504 504 VIRGINIA GAY HOSPITAL 502 NORTH 9TH AVENUE VINTON IA 52349 BENTON (319) 472-6200 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1736740 -92.0133850 0   11 19 19011 16300 Cedar Rapids-Iowa City, IA Outlying Benton County https://data.medicare.gov/resource/xubh-q36u/row-9sfp.7tdh~i4z3 161349 660977 2019-12-02 2019-06-30 25           25           40   65
934 934 DIVINE SAVIOR HEALTHCARE 2817 NEW PINERY ROAD PORTAGE WI 53901 COLUMBIA (608) 742-4131 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.5662780 -89.4694450 0   21 55 55021 31540 Madison-Janesville-Beloit, WI Outlying Columbia County https://data.medicare.gov/resource/xubh-q36u/row-qhad~azvf~jeqw 520041 661128 2019-11-26 2019-06-30 37 6         43       83   40   166
2405 2405 REGIONAL WEST GARDEN COUNTY HOSPITAL 1100 WEST 2ND ST OSHKOSH NE 69154 GARDEN (308) 772-3283 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4124850 -102.3475730 0   69 31 31069         https://data.medicare.gov/resource/xubh-q36u/row-ak6k-74t4-rjik 281310 649128 2019-05-30 2018-12-31 10           10           40   50
4329 4329 HENDERSON HEALTH CARE SERVICES 1621 FRONT STREET HENDERSON NE 68371 YORK (402) 723-4512 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.7828880 -97.8073610 0   185 31 31185         https://data.medicare.gov/resource/xubh-q36u/row-eqsp-f96h~xhhx 281308 654683 2019-09-20 2019-06-30 13           13           40   53
405 405 NORTH ARKANSAS REGIONAL MEDICAL CENTER 620 NORTH MAIN STREET HARRISON AR 72601 BOONE (870) 414-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.2362810 -93.1071480 0   9 5 5009 25460   Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-arky~dirt~vz74 40017 653366 2019-09-03 2019-03-31 96 24         120 14         4   138
1942 1942 COMMUNITY HOSPITAL OF THE MONTEREY PENINSULA 23625 W R HOLMAN HIGHWAY MONTEREY CA 93940 MONTEREY (831) 624-5311 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.5788637 -121.9131591 1 ROOFTOP 53 6 6053 41500   Central Monterey County https://data.medicare.gov/resource/xubh-q36u/row-ctib_v5m9-fnq5 50145 659197 2019-06-18 2018-12-31 199 20         227 18 13   28   4   290
1956 1956 PARK NICOLLET METHODIST HOSPITAL 6500 EXCELSIOR BLVD SAINT LOUIS PARK MN 55426 HENNEPIN (952) 993-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.9270540 -93.3623910 0   53 27 27053 33460 Minneapolis-St. Paul, MN-WI Central Hennepin County https://data.medicare.gov/resource/xubh-q36u/row-vshk-nqdg.9jmb 240053 649450 2019-05-23 2018-12-31 339 22         361           4   365
3698 3698 VERNON MEMORIAL HOSPITAL 507 SOUTH MAIN ST VIROQUA WI 54665 VERNON (608) 637-2101 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.5514600 -90.8889460 0   123 55 55123         https://data.medicare.gov/resource/xubh-q36u/row-93xe.mfha_xdyx 521348 644392 2019-02-27 2018-09-30 25           25           4   29
3752 3752 CARRIS HEALTH - REDWOOD, LLC 100 FALLWOOD ROAD REDWOOD FALLS MN 56283 REDWOOD (507) 637-4500 Critical Access Hospitals Government - Local TRUE 44.5370300 -95.1072680 0   127 27 27127         https://data.medicare.gov/resource/xubh-q36u/row-nr7s_ak8r_x54m 241351 661207 2019-11-27 2019-06-30 25           25           4   29
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
824 824 BUCHANAN COUNTY HEALTH CENTER 1600 FIRST ST EAST INDEPENDENCE IA 50644 BUCHANAN (319) 332-0999 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.4687870 -91.8750150 0   19 19 19019         https://data.medicare.gov/resource/xubh-q36u/row-cq2e.inyq-2gxf 161335 660969 2019-11-27 2019-06-30 25           25           39   64
3724 3724 GENOA COMMUNITY HOSPITAL P O BOX 310, 706 EWING AVE GENOA NE 68640 PLATTE (402) 993-2283 Critical Access Hospitals Government - Local TRUE 41.4438882 -97.7325043 1 ROOFTOP 125 31 31125         https://data.medicare.gov/resource/xubh-q36u/row-c2af.d7kh~u8nh 281312 657908 2019-10-30 2019-06-30 19           19           39   58
1268 1268 SOUTHERN MAINE HEALTH CARE 1 MEDICAL CENTER DRIVE BIDDEFORD ME 4005 YORK (207) 283-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.4784360 -70.4921740 0   31 23 23031 38860 Portland-Lewiston-South Portland, ME Central York County https://data.medicare.gov/resource/xubh-q36u/row-am4g_dvue_z9bw 200019 649741 2019-05-30 2018-12-31 131 9         140 12     74   38   264
1948 1948 GIBSON COMMUNITY HOSPITAL 1120 N MELVIN STREET GIBSON CITY IL 60936 FORD (217) 784-4251 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.4780720 -88.3707160 0   53 17 17053 16580   Outlying Ford County https://data.medicare.gov/resource/xubh-q36u/row-f8jw.6gex-n8ig 141317 645250 2019-03-01 2018-09-30 23 2         25       5   37   67
4378 4378 TREGO COUNTY LEMKE MEMORIAL HOSPITAL 320 THIRTEENTH ST WA KEENEY KS 67672 TREGO (785) 743-2182 Critical Access Hospitals Government - Local TRUE 39.0272190 -99.8716200 0   195 20 20195         https://data.medicare.gov/resource/xubh-q36u/row-y4gc.24zy.c8cd 171355 649596 2019-06-03 2018-12-31 25           25           37   62
172 172 ANDERSON COUNTY HOSPITAL 421 S MAPLE GARNETT KS 66032 ANDERSON (785) 204-4000 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.2801200 -95.2493000 0   3 20 20003         https://data.medicare.gov/resource/xubh-q36u/row-3ktx.x5ze~zgrj 171316 648620 2019-05-24 2018-12-31 12           12           36   48
656 656 HALQUIST MEMORIAL INPATIENT CENTER 4715 NORTH 15 STREET ARLINGTON VA 22205 ARLINGTON (703) 525-7070 Acute Care Hospitals Voluntary non-profit - Private FALSE 38.8879410 -77.1216690 0   13 51 51013 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Arlington County https://data.medicare.gov/resource/xubh-q36u/row-vmzf.p4zi.8e5f 490129 651083 2019-06-03 2018-12-31                         36   36
998 998 MINNEOLA DISTRICT HOSPITAL NBR 2 212 MAIN MINNEOLA KS 67865 FORD (620) 885-4264 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.4415040 -100.0138120 0   25 20 20025         https://data.medicare.gov/resource/xubh-q36u/row-qfsy_k4qi-ia9b 171368 651617 2019-06-24 2018-12-31 14           14           36   50
512 512 BOLIVAR MEDICAL CENTER 901 E SUNFLOWER RD CLEVELAND MS 38732 BOLIVAR (662) 846-0061 Acute Care Hospitals Proprietary TRUE 33.7474710 -90.7081280 0   11 28 28011 17380 Cleveland-Indianola, MS Central Bolivar County https://data.medicare.gov/resource/xubh-q36u/row-6ymk.r4nx_mhwx 250093 653424 2019-09-03 2019-03-31 144 8         152 12         35   199
2454 2454 COLQUITT REGIONAL MEDICAL CENTER 3131 THOMASVILLE HWY BOX 40 MOULTRIE GA 31768 COLQUITT (229) 985-3420 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.1267470 -83.7829180 0   71 13 13071 34220   Central Colquitt County https://data.medicare.gov/resource/xubh-q36u/row-cjar.baa5~jr3x 110105 645063 2019-03-01 2018-09-30 84 10         94           35   129
2994 2994 KEARNY COUNTY HOSPITAL 500 THORPE STREET LAKIN KS 67860 KEARNY (620) 355-7111 Critical Access Hospitals Government - Local TRUE 37.9459710 -101.2510360 0   93 20 20093 23780   Outlying Kearny County https://data.medicare.gov/resource/xubh-q36u/row-62du-eigp.wszj 171313 660224 2019-11-26 2019-06-30 25           25         40 35   100
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
352 352 BEAR LAKE MEMORIAL HOSPITAL 164 SOUTH FIFTH STREET MONTPELIER ID 83254 BEAR LAKE (208) 847-1630 Critical Access Hospitals Government - Local TRUE 42.3162420 -111.3008470 0   7 16 16007         https://data.medicare.gov/resource/xubh-q36u/row-mggi-9epd.588z 131316 647888 2019-05-16 2018-12-31 21           21       36   32   89
1045 1045 COLUMBIA BASIN HOSPITAL 200 NAT WASHINGTON WAY EPHRATA WA 98823 GRANT (509) 754-4631 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.3157420 -119.5481250 0   25 53 53025 34180 Moses Lake-Othello, WA Central Grant County https://data.medicare.gov/resource/xubh-q36u/row-xhgk~wjue-em7x 501317 652555 2019-06-14 2018-12-31 25           25         12 32   69
1383 1383 ADVENTHEALTH PALM COAST 60 MEMORIAL MEDICAL PKWY PALM COAST FL 32164 FLAGLER (386) 586-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 29.4789870 -81.1900890 0   35 12 12035 19660 Orlando-Deltona-Daytona Beach, FL Central Flagler County https://data.medicare.gov/resource/xubh-q36u/row-zkit_irst-fsuv 100118 649415 2019-05-30 2018-12-31 81 18         99           32   131
2457 2457 GREELEY COUNTY HEALTH SERVICES 506 3RD STREET TRIBUNE KS 67879 GREELEY (620) 376-4221 Critical Access Hospitals Government - Local TRUE 38.4704770 -101.7497620 0   71 20 20071         https://data.medicare.gov/resource/xubh-q36u/row-3jpb-nuq6_kq8a 171359 647618 2019-05-07 2018-12-31 18           18           32   50
3530 3530 ST LUKE HOSPITAL & LIVING CENTER 535 SOUTH FREEBORN MARION KS 66861 MARION (620) 382-2177 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.3427080 -97.0100140 0   115 20 20115         https://data.medicare.gov/resource/xubh-q36u/row-uqvu-kkp6-ivun 171356 645551 2019-03-05 2018-09-30 10           10           32   42
4145 4145 GORDON MEMORIAL HOSPITAL DISTRICT 300 EAST 8TH ST GORDON NE 69343 SHERIDAN (308) 282-0401 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.8118390 -102.1996530 0   161 31 31161         https://data.medicare.gov/resource/xubh-q36u/row-4riz_taj9.4fxw 281358 662402 2019-12-05 2019-06-30 25           25           32   57
4287 4287 SHERIDAN COUNTY HOSPITAL 826 18TH STREET HOXIE KS 67740 SHERIDAN (785) 675-3281 Critical Access Hospitals Government - Local TRUE 39.3541880 -100.4327350 0   179 20 20179         https://data.medicare.gov/resource/xubh-q36u/row-x8uv-c85y_dgpp 171347 647617 2019-05-06 2018-12-31 18           18           32   50
1348 1348 ALICE HYDE MEDICAL CENTER 133 PARK STREET MALONE NY 12953 FRANKLIN (518) 483-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.8566580 -74.2919300 0   33 36 36033 31660   Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-493x~ftr5.jry8 330084 651569 2019-06-27 2018-09-30 43 5         48       135   30   213
1488 1488 GLENDALE MEM HOSPITAL & HLTH CENTER 1420 S CENTRAL AVE GLENDALE CA 91204 LOS ANGELES (818) 502-1900 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1277890 -118.2577950 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-7nps-ge35~jh8j 50058 657613 2018-12-03 2018-06-30 204 24       13 241 49 14       30   334
3424 3424 MERCY HARVARD HOSPITAL 901 S GRANT STREET HARVARD IL 60033 MC HENRY (815) 943-5431 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.4259920 -88.6077480 0   111 17 17111 16980 Chicago-Naperville, IL-IN-WI Central McHenry County https://data.medicare.gov/resource/xubh-q36u/row-kww9-q8j9_zquu 141335 661880 2019-12-06 2019-06-30 10 3         13       15   30   58
3855 3855 GRISELL MEMORIAL HOSPITAL 210 SOUTH VERMONT AVENUE RANSOM KS 67572 NESS (785) 731-2231 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.6367100 -99.9315460 0   135 20 20135         https://data.medicare.gov/resource/xubh-q36u/row-m6sz.xvcu-brgm 171300 649227 2019-05-28 2018-12-31 12           12           30   42
3856 3856 NESS COUNTY HOSPITAL DISTRICT #2 312 CUSTER STREET NESS CITY KS 67560 NESS (785) 798-2291 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.4578110 -99.9009320 0   135 20 20135         https://data.medicare.gov/resource/xubh-q36u/row-45c5~w9n7~gmam 171336 647293 2019-04-25 2018-12-31 25           25           30   55
872 872 JOHNSON COUNTY HEALTHCARE CENTER 497 WEST LOTT BUFFALO WY 82834 JOHNSON (307) 684-5521 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.3497880 -106.7072480 0   19 56 56019         https://data.medicare.gov/resource/xubh-q36u/row-jfvm_9yjt_xtnf 531308 662298 2019-12-03 2019-06-30 22           22           3   69
4450 4450 ST CLAIRE REGIONAL MEDICAL CENTER 222 MEDICAL CIRCLE MOREHEAD KY 40351 ROWAN (606) 783-6502 Acute Care Hospitals Government - Federal TRUE 38.1800160 -83.4424540 0   205 21 21205         https://data.medicare.gov/resource/xubh-q36u/row-epvn~wthp~wxsz 180018 660556 2019-11-26 2019-06-30 76 14         90 20 10   7   3   130
2945 2945 HUMBOLDT COUNTY MEMORIAL HOSPITAL 1000 NORTH 15TH STREET HUMBOLDT IA 50548 HUMBOLDT (515) 332-4200 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.7318350 -94.2302160 0   91 19 19091         https://data.medicare.gov/resource/xubh-q36u/row-vk9h.9r4x-cbu7 161334 660218 2019-11-26 2019-06-30 17           17           28   45
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
1978 1978 HIRAM W DAVIS MEDICAL CENTER P O BOX 4030 PETERSBURG VA 23803 PETERSBURG CITY (804) 524-7344 Acute Care Hospitals Government - State FALSE 37.2098658 -77.4509355 1 ROOFTOP 53 51 51053 40060   Central Dinwiddie County https://data.medicare.gov/resource/xubh-q36u/row-xvn2.38q5-2xg5 490104 661117 2019-11-27 2019-06-30 4           4       50 30 277   361
613 613 MERCY MEDICAL CTR 271 CAREW STREET SPRINGFIELD MA 1104 HAMPDEN (413) 748-9000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.1158780 -72.5954420 0   13 25 25013 44140 Springfield-Greenfield Town, MA Central Hampden County https://data.medicare.gov/resource/xubh-q36u/row-9554.m9ge.qe6w 220066 661337 2019-12-03 2019-06-30 210 27         237 50 30       26   343
988 988 STAR VALLEY MEDICAL CENTER 901 ADAMS STREET AFTON WY 83110 LINCOLN (307) 885-5800 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.7172500 -110.9314610 0   23 56 56023         https://data.medicare.gov/resource/xubh-q36u/row-763v_wyb3.smi9 531313 658921 2019-11-15 2019-06-30 22           22           24   46
1667 1667 MCLEOD REGIONAL MEDICAL CENTER-PEE DEE 555 E CHEVES ST BOX 8700 FLORENCE SC 29506 FLORENCE (843) 777-2900 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.1959310 -79.7587840 0   41 45 45041 22500   Central Florence County https://data.medicare.gov/resource/xubh-q36u/row-5upv.sgxu_d9vz 420051 653093 2019-08-09 2018-09-30 360 26 20   15   509           24   533
2130 2130 LUTHERAN MEDICAL CENTER 8300 W 38TH AVE WHEAT RIDGE CO 80033 JEFFERSON (303) 425-4500 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7693280 -105.0892910 0   59 8 8059 19740 Denver-Aurora, CO Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-h45t-vvz5~5dzw 60009 649546 2019-05-31 2018-12-31 148 18         186 96         24   306
4205 4205 RUSSELL REGIONAL HOSPITAL 200 S MAIN STREET RUSSELL KS 67665 RUSSELL (785) 483-3131 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.8832620 -98.8598360 0   167 20 20167         https://data.medicare.gov/resource/xubh-q36u/row-jqcp-w49x~7w2h 171350 640712 2019-01-03 2018-07-31 19           19           22   41
4295 4295 UNION COUNTY HOSPITAL 517 NORTH MAIN STREET ANNA IL 62906 UNION (618) 833-4511 Critical Access Hospitals Proprietary TRUE 37.4653050 -89.2450190 0   181 17 17181         https://data.medicare.gov/resource/xubh-q36u/row-pcrc-gp3a~kn84 141342 653887 2019-08-27 2018-12-31 25           25           22   47
793 793 GARFIELD MEMORIAL HOSPITAL 200 NORTH 400 EAST PANGUITCH UT 84759 GARFIELD (435) 676-8811 Critical Access Hospitals Government - Local TRUE 37.8287720 -112.4354760 0   17 49 49017         https://data.medicare.gov/resource/xubh-q36u/row-76zy~3pmz.9dc6 461333 658918 2019-11-13 2018-12-31 15           15           21   36
2702 2702 METRO HEALTH HOSPITAL 5900 BYRON CENTER AVENUE, SW WYOMING MI 49519 KENT (616) 252-7200 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.8580670 -85.7229370 0   81 26 26081 24340 Grand Rapids-Wyoming-Muskegon, MI Central Kent County https://data.medicare.gov/resource/xubh-q36u/row-hjd9~97p4.t5d2 230236 661017 2019-11-26 2019-06-30 171 16         187           21   208
621 621 BENEFIS HOSPITALS INC 1101 26TH ST S GREAT FALLS MT 59405 CASCADE (406) 455-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.4918480 -111.2626150 0   13 30 30013 24500   Central Cascade County https://data.medicare.gov/resource/xubh-q36u/row-hf5d-meey.a7xt 270012 649795 2019-05-24 2018-12-31 268 20         312   20   146   20   498
1199 1199 ST BERNARDS MEDICAL CENTER 225 E JACKSON JONESBORO AR 72401 CRAIGHEAD (870) 972-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.8374780 -90.7021420 0   31 5 5031 27860 Jonesboro-Paragould, AR Central Craighead County https://data.medicare.gov/resource/xubh-q36u/row-tdxp_ingv-y9gs 40020 644208 2019-02-27 2018-09-30 287 30         329 24         20   373

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