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

120 rows where "fy_end_date" is on date 2019-03-31 sorted by csatitle

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

fy_end_date (date) ✖

  • 2019-03-31 · 120 ✖
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
116 116 WEST RIVER REGIONAL MEDICAL CENTER-CAH 1000 HIGHWAY 12 HETTINGER ND 58639 ADAMS (701) 567-4561 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.0013230 -102.6282390 0   1 38 38001         https://data.medicare.gov/resource/xubh-q36u/row-kpck-85x6-gtvw 351330 654546 2019-08-29 2019-03-31 25           25               25
175 175 OAKDALE COMMUNITY HOSPITAL 130 N HOSPITAL DR OAKDALE LA 71463 ALLEN (318) 335-3700 Acute Care Hospitals Proprietary TRUE 30.8162640 -92.6445450 0   3 22 22003         https://data.medicare.gov/resource/xubh-q36u/row-7xwr-vazc_74w6 190106 654443 2019-09-09 2019-03-31 46 3         49               49
184 184 MUNISING MEMORIAL HOSPITAL 1500 SAND POINT RD MUNISING MI 49862 ALGER (906) 387-4110 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4238490 -86.6257160 0   3 26 26003         https://data.medicare.gov/resource/xubh-q36u/row-7pqa.fabg.y26z 231308 654139 2019-09-04 2019-03-31 11           11               11
323 323 CACHE VALLEY HOSPITAL 2380 NORTH 400 EAST NORTH LOGAN UT 84341 CACHE (435) 713-9580 Acute Care Hospitals Proprietary TRUE 41.7757140 -111.8230920 0   5 49 49005 30860   Central Cache County https://data.medicare.gov/resource/xubh-q36u/row-quy7.rbde-cdcc 460054 653289 2019-08-22 2019-03-31 28           28               28
340 340 SILOAM SPRINGS REGIONAL HOSPITAL 603 NORTH PROGRESS AVENUE SILOAM SPRINGS AR 72761 BENTON (479) 524-4141 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.1903770 -94.5096580 0   7 5 5007 22220   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-6neb~fx59-g35b 40001 653533 2019-08-30 2019-03-31 38 6         44               44
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
565 565 ABRAZO CENTRAL CAMPUS 2000 WEST BETHANY HOME ROAD PHOENIX AZ 85015 MARICOPA (602) 249-0212 Acute Care Hospitals Physician TRUE 33.5241160 -112.1019340 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-apke-ic6r-dws7 30030 654065 2019-08-30 2019-03-31 116 28         144   16           160
566 566 ABRAZO ARROWHEAD CAMPUS 18701 NORTH 67TH AVENUE GLENDALE AZ 85308 MARICOPA (623) 561-1000 Acute Care Hospitals Proprietary TRUE 33.6550420 -112.2028890 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-mbqg~urbx.9rm7 30094 654000 2019-08-29 2019-03-31 224 38         262               262
725 725 CHICOT MEMORIAL MEDICAL CENTER 2729 SOUTH HIGHWAY 65 & 82 LAKE VILLAGE AR 71653 CHICOT (870) 265-5351 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.3056420 -91.2903530 0   17 5 5017         https://data.medicare.gov/resource/xubh-q36u/row-n4n3~4tmq_i4ky 41328 660163 2019-11-22 2019-03-31 25           25               25
830 830 DEQUINCY MEMORIAL HOSPITAL 110 WEST 4TH STREET DEQUINCY LA 70633 CALCASIEU (337) 786-1200 Critical Access Hospitals Proprietary TRUE 30.4518030 -93.4371910 0   19 22 22019 29340   Central Calcasieu Parish https://data.medicare.gov/resource/xubh-q36u/row-9sya_iav2.y4rk 191307 653779 2019-09-09 2019-03-31 19           19 10             29
857 857 TRIDENT MEDICAL CENTER 9330 MEDICAL PLAZA DR CHARLESTON SC 29406 CHARLESTON (843) 847-4100 Acute Care Hospitals Proprietary TRUE 32.9751280 -80.0722740 0   19 45 45019 16700   Central Charleston County https://data.medicare.gov/resource/xubh-q36u/row-p4db.5rji~qzvv 420079 654485 2019-09-24 2019-03-31 384 36       14 434 17             451
898 898 CITIZENS MEDICAL CENTER 7939 U S HWY 165 SOUTH COLUMBIA LA 71418 CALDWELL (318) 649-6106 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.0778710 -92.0952180 0   21 22 22021         https://data.medicare.gov/resource/xubh-q36u/row-ivth~mw7c.ra49 190184 653245 2019-08-30 2019-03-31 40           40               40
949 949 BLECKLEY MEMORIAL HOSPITAL 145 PEACOCK STREET COCHRAN GA 31014 BLECKLEY (478) 934-6211 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.3845450 -83.3459270 0   23 13 13023         https://data.medicare.gov/resource/xubh-q36u/row-wjpa_e9pd.p88y 111302 653882 2019-09-05 2019-03-31 15           15               15
1146 1146 THE HEALTHCENTER 320 SUNNYVIEW LANE KALISPELL MT 59901 FLATHEAD (406) 756-4720 Acute Care Hospitals Proprietary FALSE 48.2162080 -114.3240470 0   29 30 30029 28060   Central Flathead County https://data.medicare.gov/resource/xubh-q36u/row-q8tk.6pjn~75zu 270087 653252 2019-08-26 2019-03-31 17           17   10           27
1147 1147 KALISPELL REGIONAL MEDICAL CENTER 310 SUNNYVIEW LANE KALISPELL MT 59901 FLATHEAD (406) 752-5111 Acute Care Hospitals Voluntary non-profit - Private TRUE 48.2156850 -114.3247530 0   29 30 30029 28060   Central Flathead County https://data.medicare.gov/resource/xubh-q36u/row-n6nd-i5ym.67yu 270051 653251 2019-08-26 2019-03-31 151 18         178       110       288
1148 1148 NORTH VALLEY HOSPITAL 1600 HOSPITAL WAY WHITEFISH MT 59937 FLATHEAD (406) 863-3550 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3810320 -114.3313260 0   29 30 30029 28060   Central Flathead County https://data.medicare.gov/resource/xubh-q36u/row-29tt-ysrs_pnbv 271336 654458 2019-08-28 2019-03-31 21 4         25               25
1161 1161 LINTON HOSPITAL - CAH 518 NORTH BROADWAY LINTON ND 58552 EMMONS (701) 254-4511 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.2710630 -100.2328710 0   29 38 38029         https://data.medicare.gov/resource/xubh-q36u/row-zu7c~i74a~kiv4 351328 651912 2019-07-15 2019-03-31 14           14               14
1281 1281 CHERRY COUNTY HOSPITAL P O BOX 410, 510 NORTH GREEN ST VALENTINE NE 69201 CHERRY (402) 376-2525 Critical Access Hospitals Government - Local TRUE 42.8790786 -100.5384010 1 ROOFTOP 31 31 31031         https://data.medicare.gov/resource/xubh-q36u/row-fpwc_rzae.e38t 281344 652757 2019-07-23 2019-03-31 25           25               25
1311 1311 SHOALS HOSPITAL 201 WEST AVALON AVENUE MUSCLE SHOALS AL 35661 COLBERT (256) 386-1601 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.7449410 -87.6765110 0   33 1 1033 22520   Central Colbert County https://data.medicare.gov/resource/xubh-q36u/row-ks6f.h6du~x2iz 10157 653870 2019-09-04 2019-03-31 112 10         122 30 32           184
1394 1394 CUYUNA REGIONAL MEDICAL CENTER 320 EAST MAIN STREET CROSBY MN 56441 CROW WING (218) 546-2300 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.4824080 -93.9452500 0   35 27 27035 14660   Central Crow Wing County https://data.medicare.gov/resource/xubh-q36u/row-57iz_j5w8~gija 241353 654337 2019-09-09 2019-03-31 19 6         25       113       138
1540 1540 VIA CHRISTI HOSPITAL PITTSBURG INC 1 MT CARMEL WAY PITTSBURG KS 66762 CRAWFORD (620) 231-6100 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3815300 -94.6838500 0   37 20 20037 38260   Central Crawford County https://data.medicare.gov/resource/xubh-q36u/row-vkqa-3pn8_khmc 170006 654017 2019-08-29 2019-03-31 54 12         66   12           78
1580 1580 ANDALUSIA HEALTH 849 SOUTH THREE NOTCH STREET ANDALUSIA AL 36420 COVINGTON (334) 222-8466 Acute Care Hospitals Proprietary TRUE 31.2974620 -86.4955990 0   39 1 1039         https://data.medicare.gov/resource/xubh-q36u/row-5sky_nfni.vnsr 10036 653819 2019-08-30 2019-03-31 75 8         83               83
1607 1607 ALLIANCEHEALTH CLINTON 100 NORTH 30TH STREET CLINTON OK 73601 CUSTER (580) 323-2363 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.5147890 -98.9968790 0   39 40 40039 48220   Central Custer County https://data.medicare.gov/resource/xubh-q36u/row-dvix_7ap3~spry 370029 653451 2019-08-30 2019-03-31 41 4         45   11           56
1681 1681 DREW MEMORIAL HOSPITAL 778 SCOGIN DRIVE MONTICELLO AR 71655 DREW (870) 367-2411 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6106280 -91.8149780 0   43 5 5043         https://data.medicare.gov/resource/xubh-q36u/row-fv6e_36f4.x8wa 40051 654082 2019-09-03 2019-03-31 44 5         49               49
1826 1826 DEKALB REGIONAL MEDICAL CENTER 200 MED CENTER DRIVE FORT PAYNE AL 35968 DE KALB (256) 845-3150 Acute Care Hospitals Proprietary TRUE 34.4419753 -85.7550138 1 ROOFTOP 49 1 1049         https://data.medicare.gov/resource/xubh-q36u/row-pt4k~hfcs.k9m2 10012 653737 2019-08-22 2019-03-31 85 12         97 18             115
1952 1952 THE MEDICAL CENTER AT ALBANY 723 BURKESVILLE ROAD ALBANY KY 42602 CLINTON (606) 387-6421 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.6983350 -85.1465540 0   53 21 21053         https://data.medicare.gov/resource/xubh-q36u/row-py7x~3tmy.cdg5 180106 653670 2019-09-03 2019-03-31 38           38               38
1965 1965 CABINET PEAKS MEDICAL CENTER 209 HEALTH PARK DR LIBBY MT 59923 LINCOLN (406) 293-0100 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3926210 -115.5462710 0   53 30 30053         https://data.medicare.gov/resource/xubh-q36u/row-rev2~xaru.cjba 271320 654457 2019-08-28 2019-03-31 25           25               25
2397 2397 HARDIN COUNTY GENERAL HOSPITAL FERRELL ROAD ROSICLARE IL 62982 HARDIN (618) 285-6634 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.4103431 -88.3558252 1 GEOMETRIC_CENTER 69 17 17069         https://data.medicare.gov/resource/xubh-q36u/row-p9aq.m5aa.6pkb 141328 653315 2019-08-29 2019-03-31 25           25               25
2409 2409 HEART OF AMERICA MEDICAL CENTER 800 S MAIN AVE RUGBY ND 58368 PIERCE (701) 776-5261 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3635110 -99.9961110 0   69 38 38069         https://data.medicare.gov/resource/xubh-q36u/row-qi8i~9ssv.ufv2 351332 654478 2019-08-30 2019-03-31 25           25       55       80
2538 2538 MERIT HEALTH WESLEY 5001 W HARDY ST HATTIESBURG MS 39402 LAMAR (601) 268-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.3230580 -89.3669000 0   73 28 28073 25620   Central Lamar County https://data.medicare.gov/resource/xubh-q36u/row-km5x_fm4w~g8dw 250094 653587 2019-08-29 2019-03-31 113 17         130 13     24       167
2603 2603 MEMORIAL HOSPITAL OF CARBONDALE 405 W JACKSON CARBONDALE IL 62901 JACKSON (618) 549-0721 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7279730 -89.2201210 0   77 17 17077 16060   Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-2ipw_2w48-wu9a 140164 653132 2019-08-27 2019-03-31 133 21       13 167               167
2604 2604 ST JOSEPH MEMORIAL HOSPITAL 2 SOUTH HOSPITAL DRIVE MURPHYSBORO IL 62966 JACKSON (618) 684-3156 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.7732050 -89.3263500 0   77 17 17077 16060   Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-nyfv~asqm.5q4f 141334 653239 2019-08-23 2019-03-31 25           25               25
2707 2707 HARRISON COUNTY COMMUNITY HOSPITAL 2600 MILLER STREET BETHANY MO 64424 HARRISON (660) 425-0284 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.2652920 -94.0261450 0   81 29 29081         https://data.medicare.gov/resource/xubh-q36u/row-myhp~ktka_u8d3 261312 653250 2019-08-20 2019-03-31 14           14               14
2754 2754 GOLDEN VALLEY MEMORIAL HOSPITAL 1600 N 2ND ST CLINTON MO 64735 HENRY (660) 885-5511 Acute Care Hospitals Government - Hospital District or Authority TRUE 38.3913890 -93.7705060 0   83 29 29083         https://data.medicare.gov/resource/xubh-q36u/row-4nw8.8waa_7twa 260175 653249 2019-08-21 2019-03-31 34 8         42               42
2790 2790 HOLTON COMMUNITY HOSPITAL 1110 COLUMBINE DRIVE HOLTON KS 66436 JACKSON (785) 364-2116 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.4794640 -95.7509080 0   85 20 20085 45820   Outlying Jackson County https://data.medicare.gov/resource/xubh-q36u/row-8a8r_8yba-yt3v 171319 653242 2019-08-21 2019-03-31 12           12               12
2792 2792 SABINE MEDICAL CENTER 240 HIGHLAND DRIVE MANY LA 71449 SABINE (318) 256-1232 Acute Care Hospitals Proprietary TRUE 31.5604480 -93.4709830 0   85 22 22085         https://data.medicare.gov/resource/xubh-q36u/row-hq48.q6wx-zncf 190218 654331 2019-09-09 2019-03-31 48           48               48
2872 2872 HENRICO DOCTORS' HOSPITAL 1602 SKIPWITH ROAD RICHMOND VA 23229 HENRICO (804) 289-4500 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.6040450 -77.5377170 0   87 51 51087 40060   Central Henrico County https://data.medicare.gov/resource/xubh-q36u/row-d52i.bns3.tppc 490118 653527 2019-09-03 2019-03-31 595 17 24   12 37 685 46 36           767
2884 2884 ARKANSAS VALLEY REGIONAL MEDICAL CENTER 1100 CARSON AVENUE LA JUNTA CO 81050 OTERO (719) 383-6000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9769290 -103.5487420 0   89 8 8089         https://data.medicare.gov/resource/xubh-q36u/row-967u~ukgn_sq4q 61336 653832 2019-08-29 2019-03-31 16 506         522       30       552
2938 2938 NORTH OKALOOSA MEDICAL CENTER 151 REDSTONE AVE SE CRESTVIEW FL 32539 OKALOOSA (850) 689-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.7369470 -86.5618420 0   91 12 12091 18880   Central Okaloosa County https://data.medicare.gov/resource/xubh-q36u/row-st5i~zswh-quid 100122 654719 2019-09-20 2019-03-31 90 20         110               110
3065 3065 ALLIANCEHEALTH MADILL 901 S 5TH AVE MADILL OK 73446 MARSHALL (580) 795-3384 Critical Access Hospitals Proprietary TRUE 34.0817380 -96.7784500 0   95 40 40095         https://data.medicare.gov/resource/xubh-q36u/row-b6vq_dbi2_tjfb 371326 653270 2019-08-30 2019-03-31 21           21               21
3110 3110 MACKINAC STRAITS HOSPITAL AND HEALTH CENTER 1140 N STATE STREET SAINT IGNACE MI 49781 MACKINAC (906) 643-8585 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.8910240 -84.7275690 0   97 26 26097         https://data.medicare.gov/resource/xubh-q36u/row-qcen.rt7a~rgc3 231306 655210 2019-10-09 2019-03-31 15           15       48       63
3122 3122 HILLCREST HOSPITAL PRYOR 111 NORTH BAILEY STREET PRYOR OK 74361 MAYES (918) 825-1600 Acute Care Hospitals Proprietary TRUE 36.3082740 -95.3053880 0   97 40 40097         https://data.medicare.gov/resource/xubh-q36u/row-zivh.t584.w3vu 370015 653268 2019-08-30 2019-03-31 24           24               24
3161 3161 THE MEDICAL CENTER AT CAVERNA 1501 SOUTH DIXIE STREET HORSE CAVE KY 42749 HART (270) 786-2191 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.1603360 -85.9231720 0   99 21 21099         https://data.medicare.gov/resource/xubh-q36u/row-iigz-6fve-xf87 181314 654250 2019-09-03 2019-03-31 25           25               25
3310 3310 LINCOLN COUNTY HOSPITAL 624 N SECOND LINCOLN KS 67455 LINCOLN (785) 524-4403 Critical Access Hospitals Government - Local FALSE 39.0451750 -98.1443700 0   105 20 20105         https://data.medicare.gov/resource/xubh-q36u/row-teha_g9nc~sv4a 171360 654126 2019-09-04 2019-03-31 10           10               10
3350 3350 ALLIANCEHEALTH SEMINOLE 2401 WRANGLER BOULEVARD SEMINOLE OK 74868 SEMINOLE (405) 303-4050 Acute Care Hospitals Proprietary TRUE 35.2464640 -96.6990130 0   133 40 40133         https://data.medicare.gov/resource/xubh-q36u/row-t47q~8ahq-97c8 370229 654158 2019-09-13 2019-03-31 32           32               32
3363 3363 TROY REGIONAL MEDICAL CENTER 1330 HIGHWAY 231 SOUTH TROY AL 36081 PIKE (334) 670-5000 Acute Care Hospitals Government - Federal TRUE 31.7803220 -85.9455290 0   109 1 1109 45980   Central Pike County https://data.medicare.gov/resource/xubh-q36u/row-5ter_pyex-x2fe 10126 654064 2019-08-30 2019-03-31 88 9         97 18             115
3373 3373 TERREBONNE GENERAL MEDICAL CENTER 8166 MAIN STREET HOUMA LA 70360 TERREBONNE (985) 873-4141 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.5985370 -90.7143220 0   109 22 22109 26380   Central Terrebonne Parish https://data.medicare.gov/resource/xubh-q36u/row-4s8d.7jh4_ep57 190008 653139 2019-08-28 2019-03-31 162 18         188   14   8       210
3406 3406 CULBERSON HOSPITAL EISENHOWER ROAD AND FM 2185 VAN HORN TX 79855 CULBERSON (432) 283-2760 Critical Access Hospitals Proprietary FALSE 31.0496690 -104.8283880 0   109 48 48109         https://data.medicare.gov/resource/xubh-q36u/row-g73p-emdj_vjx2 451338 653287 2019-08-29 2019-03-31 14           14               14
3512 3512 HAYWARD AREA MEMORIAL HOSPITAL 11040 N STATE RD 77 HAYWARD WI 54843 SAWYER (715) 934-4321 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.0354000 -91.4884650 0   113 55 55113         https://data.medicare.gov/resource/xubh-q36u/row-m9mb_emjr_zips 521336 653363 2019-08-29 2019-03-31 25           25       50       75
3542 3542 MEDICAL ARTS HOSPITAL 2200 N BRYAN AVE LAMESA TX 79331 DAWSON (806) 872-2183 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7502790 -101.9664700 0   115 48 48115 29500   Central Dawson County https://data.medicare.gov/resource/xubh-q36u/row-epaw-jzbp_b5c6 450489 653519 2019-09-03 2019-03-31 22           22               22
3677 3677 MITCHELL COUNTY HOSPITAL HEALTH SYSTEMS 400 W 8TH STREET, P O BOX 399 BELOIT KS 67420 MITCHELL (785) 738-2266 Critical Access Hospitals Government - Local TRUE 39.4664990 -98.1142350 0   123 20 20123         https://data.medicare.gov/resource/xubh-q36u/row-pzzg_8xf8_sq7i 171375 654375 2019-08-30 2019-03-31 12 4         16 10     40       66
3749 3749 THREE RIVERS MEDICAL CENTER 2485 HIGHWAY 644 LOUISA KY 41230 LAWRENCE (606) 638-9451 Acute Care Hospitals Proprietary TRUE 38.0933000 -82.6047400 0   127 21 21127         https://data.medicare.gov/resource/xubh-q36u/row-j4ps_phu6_dvj7 180128 654022 2019-08-29 2019-03-31 59 6         65 19             84
3750 3750 WINN PARISH MEDICAL CENTER 301 W BOUNDARY AVE WINNFIELD LA 71483 WINN (318) 648-3000 Acute Care Hospitals Proprietary TRUE 31.9249790 -92.6451390 0   127 22 22127         https://data.medicare.gov/resource/xubh-q36u/row-tecb_9uuz_3xte 190090 653892 2019-09-09 2019-03-31 41 5         46               46
3757 3757 PUSHMATAHA COUNTY TOWN OF ANTLERS HOSPITAL 510 EAST MAIN STREET ANTLERS OK 74523 PUSHMATAHA (580) 298-3341 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.2317170 -95.6156030 0   127 40 40127         https://data.medicare.gov/resource/xubh-q36u/row-2h9r-9buw.dkj2 370083 653854 2019-09-03 2019-03-31 42           42               42
3796 3796 SPOONER HEALTH SYSTEM 1280 CHANDLER DR SPOONER WI 54801 WASHBURN (715) 635-2111 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.8414373 -91.8703438 1 ROOFTOP 129 55 55129         https://data.medicare.gov/resource/xubh-q36u/row-y5vj~v6dk_vfyv 521332 653362 2019-08-30 2019-03-31 20           20               20
3861 3861 SEQUOYAH COUNTY-CITY OF SALLISAW HOSPITAL AUTHORIT 213 EAST REDWOOD SALLISAW OK 74955 SEQUOYAH (918) 774-1100 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.4635630 -94.7890400 0   135 40 40135 22900   Outlying Sequoyah County https://data.medicare.gov/resource/xubh-q36u/row-8fna.wsab~hcry 370112 653452 2019-09-04 2019-03-31 41           41               41
3997 3997 PHILLIPS COUNTY HEALTH SYSTEMS 1150 STATE STREET PHILLIPSBURG KS 67661 PHILLIPS (785) 543-5226 Critical Access Hospitals Government - Local TRUE 39.7558850 -99.3135760 0   147 20 20147         https://data.medicare.gov/resource/xubh-q36u/row-e4xe_bqr9-weeq 171353 654090 2019-09-03 2019-03-31 25           25               25
4100 4100 PERRY COUNTY MEMORIAL HOSPITAL 434 NORTH WEST STREET PERRYVILLE MO 63775 PERRY (573) 547-2530 Critical Access Hospitals Government - Local TRUE 37.7316200 -89.8648010 0   157 29 29157         https://data.medicare.gov/resource/xubh-q36u/row-eq8k_bsjm.6xy8 261311 654147 2019-08-30 2019-03-31 25           25               25
4183 4183 FERRELL HOSPITAL COMMUNITY FOUNDATIONS 1201 PINE STREET ELDORADO IL 62930 SALINE (618) 273-3361 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.8153320 -88.4414510 0   165 17 17165         https://data.medicare.gov/resource/xubh-q36u/row-7gt3_vkhk~hsp3 141324 662524 2019-12-04 2019-03-31 25           25               25
4308 4308 SMITH COUNTY MEMORIAL HOSPITAL 921 E. HIGHWAY 36 SMITH CENTER KS 66967 SMITH (785) 282-6845 Critical Access Hospitals Government - Local TRUE 39.7852490 -98.7727680 0   183 20 20183         https://data.medicare.gov/resource/xubh-q36u/row-2xcp~xm86-a2da 171377 654020 2019-08-29 2019-03-31 16           16               16
4395 4395 HERRIN HOSPITAL 201 S 14TH ST HERRIN IL 62948 WILLIAMSON (618) 942-2171 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.8016130 -89.0265080 0   199 17 17199 16060   Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-haub~x6q9.4zji 140011 653130 2019-08-23 2019-03-31 77 8         85   29           114
4466 4466 THE MEDICAL CENTER AT FRANKLIN 1100 BROOKHAVEN ROAD FRANKLIN KY 42135 SIMPSON (270) 598-4800 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.6999970 -86.5755630 0   213 21 21213         https://data.medicare.gov/resource/xubh-q36u/row-848t_jjxn~tf6j 181318 654251 2019-09-03 2019-03-31 25           25               25
4512 4512 DOCTORS HOSPITAL 3651 WHEELER ROAD AUGUSTA GA 30909 RICHMOND (706) 651-6008 Acute Care Hospitals Proprietary TRUE 33.4824770 -82.0910920 0   245 13 13245 12260   Central Richmond County https://data.medicare.gov/resource/xubh-q36u/row-6f2z-s2e9_rrn9 110177 654237 2019-09-03 2019-03-31 191 24   36   9 260   28           288
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
4554 4554 PARKVIEW REGIONAL HOSPITAL 600 SOUTH BONHAM STREET MEXIA TX 76667 LIMESTONE (254) 562-5332 Acute Care Hospitals Proprietary TRUE 31.6750590 -96.4800130 0   293 48 48293         https://data.medicare.gov/resource/xubh-q36u/row-eqsz~67zm-42nm 450400 653518 2019-09-05 2019-03-31 43 6         49 9             58
4566 4566 HEART OF TEXAS MEMORIAL HOSPITAL 2008 NINE ROAD BRADY TX 76825 MC CULLOCH (325) 597-2901 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.1163340 -99.3466000 0   307 48 48307         https://data.medicare.gov/resource/xubh-q36u/row-kqsv.fye9_9h3c 451348 653867 2019-09-03 2019-03-31 14           14               14
173 173 THE MEDICAL CENTER AT SCOTTSVILLE 456 BURNLEY ROAD SCOTTSVILLE KY 42164 ALLEN (270) 622-2800 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.7597650 -86.2162120 0   3 21 21003 14540 Bowling Green-Glasgow, KY Outlying Allen County https://data.medicare.gov/resource/xubh-q36u/row-v9hf~phby-c7vz 181324 654252 2019-09-03 2019-03-31 25           25       110       135
4495 4495 THE MEDICAL CENTER AT BOWLING GREEN 250 PARK STREET BOWLING GREEN KY 42101 WARREN (270) 745-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.9963660 -86.4302320 0   227 21 21227 14540 Bowling Green-Glasgow, KY Central Warren County https://data.medicare.gov/resource/xubh-q36u/row-vk4p_q6rn~eusz 180013 653666 2019-09-03 2019-03-31 260 16 20     12 308 8             316
2227 2227 VALLEY REGIONAL MEDICAL CENTER 100 A ALTON GLOOR BROWNSVILLE TX 78526 CAMERON (956) 350-7000 Acute Care Hospitals Proprietary TRUE 25.9780246 -97.5146344 1 ROOFTOP 61 48 48061 15180 Brownsville-Harlingen-Raymondville, TX Central Cameron County https://data.medicare.gov/resource/xubh-q36u/row-8upk-rgcf.533w 450662 653217 2019-08-28 2019-03-31 186 18       10 214               214
2327 2327 PARKRIDGE MEDICAL CENTER 2333 MCCALLIE AVE CHATTANOOGA TN 37404 HAMILTON (423) 894-4220 Acute Care Hospitals Proprietary TRUE 35.0337390 -85.2688600 0   65 47 47065 16860 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-5m9j_jhfi~zhhr 440156 653858 2019-08-30 2019-03-31 325 33       22 380 44 12 24         460
1253 1253 JACKSON PARK HOSPITAL 7531 S STONY ISLAND AVE CHICAGO IL 60649 COOK (773) 947-7500 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7573320 -87.5857100 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-6y5k.zxz3~agdm 140177 653314 2019-08-29 2019-03-31 193 8         201               201
1254 1254 ROSELAND COMMUNITY HOSPITAL 45 W 111TH STREET CHICAGO IL 60628 COOK (773) 995-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.6925620 -87.6247340 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-pt5k~csix_ikqj 140068 654202 2019-09-03 2019-03-31 124 10         134               134
3092 3092 LAKE BEHAVIORAL HOSPITAL 2615 W WASHINGTON ST WAUKEGAN IL 60085 LAKE (847) 249-3900 Acute Care Hospitals Proprietary TRUE 42.3594020 -87.8666050 0   97 17 17097 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-t57b.6rbp-musy 140033 654119 2019-09-04 2019-03-31               46             46
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
3790 3790 BERGER HOSPITAL 600 NORTH PICKAWAY STREET CIRCLEVILLE OH 43113 PICKAWAY (740) 420-8020 Acute Care Hospitals Government - Local TRUE 39.6102810 -82.9377470 0   129 39 39129 18140 Columbus-Marion-Zanesville, OH Outlying Pickaway County https://data.medicare.gov/resource/xubh-q36u/row-zp45_7tue~gsqz 360170 655646 2019-10-23 2019-03-31 75 8         83               83
2811 2811 BAYLOR SCOTT & WHITE MEDICAL CENTER - CENTENNIAL 12505 LEBANON ROAD FRISCO TX 75035 COLLIN (972) 963-3333 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.1158710 -96.7698920 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-mwua_bzhk.yenq 450885 653285 2019-08-29 2019-03-31 92 12       14 118               118
2812 2812 MEDICAL CITY PLANO 3901 W 15TH ST PLANO TX 75075 COLLIN (972) 596-6800 Acute Care Hospitals Proprietary TRUE 33.0193870 -96.7657300 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-tpnt.jr5f_tzah 450651 653284 2019-08-28 2019-03-31 324   76     41 441   20           461
635 635 MOUNTAIN VIEW REGIONAL MEDICAL CENTER 4311 EAST LOHMAN AVENUE LAS CRUCES NM 88011 DONA ANA (575) 556-7610 Acute Care Hospitals Proprietary TRUE 32.3226390 -106.7282970 0   13 35 35013 29740 El Paso-Las Cruces, TX-NM Central Doña Ana County https://data.medicare.gov/resource/xubh-q36u/row-6m6j-xb3y-q4ig 320085 654343 2019-08-30 2019-03-31 145 23         180               180
166 166 DUPONT HOSPITAL LLC 2520 E DUPONT RD FORT WAYNE IN 46825 ALLEN (260) 416-3000 Acute Care Hospitals Proprietary TRUE 41.1786890 -85.1106030 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-q73v-xd2h_rmgd 150150 654122 2019-09-04 2019-03-31 92 10         131               131
3560 3560 SHERIDAN COMMUNITY HOSPITAL 301 N MAIN ST SHERIDAN MI 48884 MONTCALM (989) 291-3261 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.2154440 -85.0735660 0   117 26 26117 24340 Grand Rapids-Wyoming-Muskegon, MI Outlying Montcalm County https://data.medicare.gov/resource/xubh-q36u/row-76f7~3hgm.9t9p 231312 654260 2019-09-04 2019-03-31 22           22               22
3892 3892 HOLLAND COMMUNITY HOSPITAL 602 MICHIGAN AVE HOLLAND MI 49423 OTTAWA (616) 392-5141 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.7745810 -86.1127720 0   139 26 26139 24340 Grand Rapids-Wyoming-Muskegon, MI Outlying Ottawa County https://data.medicare.gov/resource/xubh-q36u/row-c44k-ptca~3ckt 230072 654029 2019-08-29 2019-03-31 181 8         189               189
4692 4692 EL CAMPO MEMORIAL HOSPITAL 303 SANDY CORNER RD EL CAMPO TX 77437 WHARTON (979) 578-5251 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.2191220 -96.2895760 0   481 48 48481 20900 Houston-The Woodlands, TX Central Wharton County https://data.medicare.gov/resource/xubh-q36u/row-qz6e-3k5d-x6a4 450694 653522 2019-08-30 2019-03-31 22 4         26               26
3243 3243 DECATUR MORGAN HOSPITAL-DECATUR CAMPUS 1201 7TH STREET SE DECATUR AL 35601 MORGAN (256) 341-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.5911680 -86.9726210 0   103 1 1103 19460 Huntsville-Decatur-Albertville, AL Central Morgan County https://data.medicare.gov/resource/xubh-q36u/row-j3pt~7hw5~edsk 10085 653820 2019-09-03 2019-03-31 166 23 11       200 64             264
4180 4180 INDIAN PATH COMMUNITY HOSPITAL 2000 BROOKSIDE DR KINGSPORT TN 37660 SULLIVAN (423) 431-1941 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.5506860 -82.5179160 0   163 47 47163 28700 Johnson City-Kingsport-Bristol, TN-VA Central Sullivan County https://data.medicare.gov/resource/xubh-q36u/row-u24n-h93t-5hij 440176 653514 2019-08-27 2019-03-31 134 14         148               148
4292 4292 FRANKLIN WOODS COMMUNITY HOSPITAL 300 MED TECH PARKWAY JOHNSON CITY TN 37604 WASHINGTON (423) 302-1120 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.3379450 -82.4010470 0   179 47 47179 27740 Johnson City-Kingsport-Bristol, TN-VA Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-hx2g_udv9-ac45 440184 653515 2019-08-27 2019-03-31 60 20         80       31       111
3984 3984 FREEMAN HEALTH SYSTEM - FREEMAN WEST 1102 WEST 32ND STREET JOPLIN MO 64804 JASPER (417) 347-1111 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.0544080 -94.5268840 0   145 29 29145 27900 Joplin-Miami, MO-OK Outlying Newton County https://data.medicare.gov/resource/xubh-q36u/row-z9xx.uegx.4u5a 260137 654453 2019-09-05 2019-03-31 298 39       24 361 10 20           391
3986 3986 FREEMAN NEOSHO HOSPITAL 113 WEST HICKORY STREET NEOSHO MO 64850 NEWTON (417) 451-1234 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.8676140 -94.3687870 0   145 29 29145 27900 Joplin-Miami, MO-OK Outlying Newton County https://data.medicare.gov/resource/xubh-q36u/row-w9w5_ehe3-ntf6 261331 654736 2019-10-01 2019-03-31 25           25               25
1020 1020 OAKLAWN HOSPITAL 200 N MADISON MARSHALL MI 49068 CALHOUN (269) 781-4271 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.2735330 -84.9577960 0   25 26 26025 12980 Kalamazoo-Battle Creek-Portage, MI Central Calhoun County https://data.medicare.gov/resource/xubh-q36u/row-ixqw.78q4_jfqy 230217 653972 2019-08-28 2019-03-31 66 12         78               78
3054 3054 CENTERPOINT MEDICAL CENTER 19600 EAST 39TH STREET INDEPENDENCE MO 64057 JACKSON (816) 698-7000 Acute Care Hospitals Proprietary TRUE 39.0477710 -94.3493130 0   95 29 29095 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-iwpd.bh6w~c7gg 260095 653909 2019-08-26 2019-03-31 177 40 36       265   16           281
3352 3352 MERCER COUNTY JOINT TOWNSHIP COMMUNITY HOSPITAL 800 WEST MAIN STREET COLDWATER OH 45828 MERCER (419) 678-4843 Acute Care Hospitals Government - Hospital District or Authority FALSE 40.4797820 -84.6382430 0   107 39 39107 16380 Lima-Van Wert-Celina, OH Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-wqa9_97uu.ces7 360058 653713 2019-08-27 2019-03-31 37 5         42               42
1464 1464 CASA COLINA HOSPITAL 255 E BONITA AVE POMONA CA 91767 LOS ANGELES (909) 596-7733 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.0962420 -117.7468610 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-rhgb.p6kp-nbju 50782 662170 2019-11-26 2019-03-31 25 6         31   68           99
4503 4503 TAYLOR REGIONAL HOSPITAL 222 PERRY HWY HAWKINSVILLE GA 31036 PULASKI (478) 783-0200 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.2956250 -83.4858100 0   235 13 13235 47580 Macon-Warner Robins, GA Outlying Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-9ftv~ddzf.9gyj 110135 654087 2019-09-13 2019-03-31 49 6         55       102       157
4015 4015 COMMUNITY HOSPITAL, ONAGA AND ST MARYS CAMPUS 120 WEST 8TH STREET ONAGA KS 66521 POTTAWATOMIE (785) 889-4272 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.4951550 -96.1708610 0   149 20 20149 31740 Manhattan-Junction City, KS Outlying Pottawatomie County https://data.medicare.gov/resource/xubh-q36u/row-9qa8.y7me.htnm 171354 654124 2019-09-04 2019-03-31 25           25               25
4136 4136 ASCENSION VIA CHRISTI HOSPITAL MANHATTAN, INC 1823 COLLEGE AVE MANHATTAN KS 66502 RILEY (785) 776-2831 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.2031140 -96.5981860 0   161 20 20161 31740 Manhattan-Junction City, KS Central Riley County https://data.medicare.gov/resource/xubh-q36u/row-xk7z_mz4w_2w6u 170142 654018 2019-08-29 2019-03-31 78 8         86   8           94
4107 4107 DELTA MEDICAL CENTER 3000 GETWELL RD MEMPHIS TN 38118 SHELBY (901) 369-8100 Acute Care Hospitals Proprietary TRUE 35.0677880 -89.9322130 0   157 47 47157 32820 Memphis-Forrest City, TN-MS-AR Central Shelby County https://data.medicare.gov/resource/xubh-q36u/row-kyna.ig4i~7fve 440159 653280 2019-08-20 2019-03-31 112           112 111             223
134 134 THOMAS HOSPITAL 750 MORPHY AVENUE FAIRHOPE AL 36532 BALDWIN (251) 928-2375 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.5199990 -87.8903330 0   3 1 1003 19300 Mobile-Daphne-Fairhope, AL Central Baldwin County https://data.medicare.gov/resource/xubh-q36u/row-47ke~57kn.r69r 10100 653821 2019-08-30 2019-03-31 112 10     7   129   12           141
135 135 NORTH BALDWIN INFIRMARY 1815 HAND AVENUE BAY MINETTE AL 36507 BALDWIN (251) 937-5521 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.9024920 -87.7833180 0   3 1 1003 19300 Mobile-Daphne-Fairhope, AL Central Baldwin County https://data.medicare.gov/resource/xubh-q36u/row-vac9~xsmg.2gg8 10129 653823 2019-08-30 2019-03-31 51 4         55 15             70
3077 3077 MOBILE INFIRMARY MEDICAL CENTER 5 MOBILE INFIRMARY CIRCLE MOBILE AL 36652 MOBILE (251) 435-4700 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.6964430 -88.0810170 0   97 1 1097 33660 Mobile-Daphne-Fairhope, AL Central Mobile County https://data.medicare.gov/resource/xubh-q36u/row-5pcu_va59~2efz 10113 653822 2019-08-30 2019-03-31 547 14 14   24 12 611 17 41           669
243 243 TENNOVA HEALTHCARE-SHELBYVILLE 2835 HWY 231 NORTH SHELBYVILLE TN 37160 BEDFORD (931) 685-5433 Acute Care Hospitals Proprietary TRUE 35.5632180 -86.4463720 0   3 47 47003 43180 Nashville-Davidson--Murfreesboro, TN Central Bedford County https://data.medicare.gov/resource/xubh-q36u/row-nnwj-ykm6~eviv 440137 654172 2019-09-04 2019-03-31 36 8         44               44
4026 4026 TRISTAR STONECREST MEDICAL CENTER 200 STONECREST BOULEVARD SMYRNA TN 37167 RUTHERFORD (615) 768-2000 Acute Care Hospitals Proprietary TRUE 35.9737430 -86.5637600 0   149 47 47149 34980 Nashville-Davidson--Murfreesboro, TN Outlying Rutherford County https://data.medicare.gov/resource/xubh-q36u/row-c6gn~midg_8g93 440227 654866 2019-10-09 2019-03-31 91 10       8 109               109

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