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 RPT_REC_NUM

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
3468 3468 MERCY HOSPITAL, INC 218 E PACK STREET MOUNDRIDGE KS 67107 MCPHERSON (620) 345-6391 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.2050720 -97.5169960 0   113 20 20113 32700   Central McPherson County https://data.medicare.gov/resource/xubh-q36u/row-7sai~qa9i.bde5 170075 643207 2019-02-11 2018-09-30 21           21               21
3533 3533 BYRD REGIONAL HOSPITAL 1020 FERTITTA BLVD LEESVILLE LA 71446 VERNON (337) 239-9041 Acute Care Hospitals Proprietary TRUE 31.1373240 -93.2687910 0   115 22 22115 22860 DeRidder-Fort Polk South, LA Central Vernon Parish https://data.medicare.gov/resource/xubh-q36u/row-strz-rejf.3ijm 190164 643212 2019-02-11 2018-07-31 45 7         52               52
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
4127 4127 MEMORIAL HEALTH CARE SYSTEMS 300 NORTH COLUMBIA AVE SEWARD NE 68434 SEWARD (402) 643-2971 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.9092170 -97.0919160 0   159 31 31159 30700 Lincoln-Beatrice, NE Outlying Seward County https://data.medicare.gov/resource/xubh-q36u/row-3sqr.3kpq_q356 281339 643280 2019-02-19 2018-09-30 24           24               24
764 764 WENTWORTH-DOUGLASS HOSPITAL 789 CENTRAL AVE DOVER NH 3820 STRAFFORD (603) 740-2580 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.2124420 -70.8751390 0   17 33 33017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Outlying Strafford County https://data.medicare.gov/resource/xubh-q36u/row-4p72~hzkw.rjnh 300018 643281 2019-02-25 2018-09-30 107 11         118               118
449 449 COTTAGE HOSPITAL 90 SWIFTWATER RD WOODSVILLE NH 3785 GRAFTON (603) 747-9000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.1362340 -72.0222910 0   9 33 33009 17200   Central Grafton County https://data.medicare.gov/resource/xubh-q36u/row-8qq6_qdvh_tpdv 301301 643282 2019-02-20 2018-09-30 25           25 10             35
983 983 CENTRAL VERMONT MEDICAL CENTER BOX 547 BARRE VT 5641 WASHINGTON (802) 371-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.1969972 -72.5019392 1 GEOMETRIC_CENTER 23 50 50023 12740   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-q5w8.7vxg_es2c 470001 643309 2019-02-22 2018-09-30 62 14         76               76
2520 2520 GROSSMONT HOSPITAL 5555 GROSSMONT CENTER DRIVE BOX 58 LA MESA CA 91942 SAN DIEGO (619) 465-0711 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7794350 -117.0091780 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-j2di_g3bq~q2tc 50026 643325 2019-02-25 2018-09-30 371 48         443 46 18   17   16   540
2508 2508 SHARP CHULA VISTA MEDICAL CENTER 751 MEDICAL CENTER COURT CHULA VISTA CA 91911 SAN DIEGO (619) 502-5800 Acute Care Hospitals Proprietary TRUE 32.6184480 -117.0239900 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-75gp_4nzp_4ubq 50222 643329 2019-02-25 2018-09-30 199 35         243       50 50     343
2656 2656 PRESENTATION MEDICAL CENTER 213 SECOND AVE NE ROLLA ND 58367 ROLETTE (701) 477-3161 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.8615620 -99.6155150 0   79 38 38079         https://data.medicare.gov/resource/xubh-q36u/row-e43c~yjqv.3ca8 351316 643363 2019-02-22 2018-09-30 25           25               25
1873 1873 HAMPTON REGIONAL MEDICAL CENTER 595 WEST CAROLINA AVENUE VARNVILLE SC 29944 HAMPTON (803) 943-2771 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.8552580 -81.0876920 0   49 45 45049         https://data.medicare.gov/resource/xubh-q36u/row-fqdk-8968-57an 420072 643373 2019-02-20 2018-09-30 26 6         32               32
3697 3697 CUERO REGIONAL HOSPITAL 2550 N ESPLANADE CUERO TX 77954 DE WITT (361) 275-6191 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.1124950 -97.2816930 0   123 48 48123         https://data.medicare.gov/resource/xubh-q36u/row-awr8_s97f~hye5 450597 643378 2019-02-21 2018-09-30 44           44               44
4534 4534 KIMBLE HOSPITAL 349 REID ROAD JUNCTION TX 76849 KIMBLE (325) 446-3321 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.4991940 -99.7802540 0   267 48 48267         https://data.medicare.gov/resource/xubh-q36u/row-k7bm_txp3.mutf 451306 643379 2019-02-20 2018-09-30 15           15               15
3664 3664 CARILION NEW RIVER VALLEY MEDICAL CENTER 2900 LAMB CIRCLE CHRISTIANSBURG VA 24073 MONTGOMERY (540) 731-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.0889400 -80.5067860 0   121 51 51121 13980   Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-brdf_eca5_d2f5 490042 643382 2019-02-19 2018-09-30 98 12         110 36             146
2507 2507 SHARP CORONADO HOSPITAL AND HLTHCR CTR 250 PROSPECT PLACE CORONADO CA 92118 SAN DIEGO (619) 435-6251 Acute Care Hospitals Proprietary TRUE 32.6942570 -117.1679470 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-987m_du2e.9una 50234 643396 2019-02-25 2018-09-30 52 7         59       122       181
2345 2345 MINIDOKA MEMORIAL HOSPITAL 1224 8TH STREET RUPERT ID 83350 MINIDOKA (208) 436-0481 Critical Access Hospitals Government - Local TRUE 42.6196250 -113.6853620 0   67 16 16067 15420   Outlying Minidoka County https://data.medicare.gov/resource/xubh-q36u/row-m4t9~2798.xb46 131319 643405 2019-02-26 2018-09-30 16           16       46       62
3342 3342 ABRAHAM LINCOLN MEMORIAL HOSPITAL 200 STAHLHUT DRIVE LINCOLN IL 62656 LOGAN (217) 732-2161 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.1523730 -89.3886980 0   107 17 17107 30660 Springfield-Jacksonville-Lincoln, IL Central Logan County https://data.medicare.gov/resource/xubh-q36u/row-m2j2_9ezc_vv3r 141322 643406 2019-02-25 2018-09-30 25           25               25
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
754 754 MOUNT AUBURN HOSPITAL 330 MOUNT AUBURN STREET CAMBRIDGE MA 2138 MIDDLESEX (617) 492-3500 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3749170 -71.1341070 0   17 25 25017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-us36-j8cn~rdb7 220002 643419 2019-02-25 2018-09-30 173 10 10       193 15             208
747 747 MARLBOROUGH HOSPITAL 157 UNION STREET MARLBOROUGH MA 1752 MIDDLESEX (508) 481-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3543170 -71.5538640 0   17 25 25017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-sez3-udg5-nvjw 220049 643420 2019-02-25 2018-09-30 57 10         67               67
3436 3436 PERHAM HEALTH 1000 CONEY STREET WEST PERHAM MN 56573 OTTER TAIL (218) 347-1301 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.5926850 -95.5951650 0   111 27 27111 22260   Central Otter Tail County https://data.medicare.gov/resource/xubh-q36u/row-zmw6~bp7u-2zf8 241373 643422 2019-02-22 2018-09-30 25           25       96       121
115 115 ALAMANCE REGIONAL MEDICAL CENTER 1240 HUFFMAN MILL RD BURLINGTON NC 27216 ALAMANCE (336) 538-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0637490 -79.5025280 0   1 37 37001 15500 Greensboro--Winston-Salem--High Point, NC Central Alamance County https://data.medicare.gov/resource/xubh-q36u/row-x8vw.bx9c.7dbj 340070 643428 2019-02-27 2018-09-30 144 20         176 36             212
4044 4044 RANDOLPH HOSPITAL 364 WHITE OAK STREET ASHEBORO NC 27204 RANDOLPH (336) 625-5151 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.7119580 -79.8148250 0   151 37 37151 24660 Greensboro--Winston-Salem--High Point, NC Outlying Randolph County https://data.medicare.gov/resource/xubh-q36u/row-ixf6-gq86-pf9f 340123 643429 2019-02-26 2018-09-30 133 12         145               145
4679 4679 MCCAMEY HOSPITAL 2500 HWY 305 SOUTH MCCAMEY TX 79752 UPTON (432) 652-8626 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.1145414 -102.2102683 1 ROOFTOP 461 48 48461         https://data.medicare.gov/resource/xubh-q36u/row-ezrc~bqk8~d5gy 451309 643464 2019-02-22 2018-09-30 11           11               11
2630 2630 CLAY COUNTY MEMORIAL HOSPITAL 310 W SOUTH STREET HENRIETTA TX 76365 CLAY (940) 538-5621 Critical Access Hospitals Government - Local TRUE 33.8139220 -98.1979950 0   77 48 48077 48660   Outlying Clay County https://data.medicare.gov/resource/xubh-q36u/row-tnt6-7h3c_zq5a 451362 643465 2019-02-25 2018-09-30 25           25               25
4752 4752 NORTON COMMUNITY HOSPITAL 100 15TH NW STREET NORTON VA 24273 NORTON CITY (276) 439-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.9320310 -82.6433800 0   720 51 51720 13720   Central Norton city https://data.medicare.gov/resource/xubh-q36u/row-z9rr.uwbu~pseu 490001 643467 2019-02-22 2018-09-30 54 11         65   13           78
2693 2693 TETON VALLEY HOSPITAL 120 EAST HOWARD AVE DRIGGS ID 83422 TETON (208) 354-2383 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.7272850 -111.1086080 0   81 16 16081 27220   Outlying Teton County https://data.medicare.gov/resource/xubh-q36u/row-73s3-g6zw_arid 131313 643497 2019-02-27 2018-09-30 13           13               13
1397 1397 NORTHERN ROCKIES MEDICAL CENTER 802 2ND ST SE CUT BANK MT 59427 GLACIER (406) 873-2251 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.6287800 -112.3263450 0   35 30 30035         https://data.medicare.gov/resource/xubh-q36u/row-mzwj.8j2h.fdnu 271337 643521 2019-02-26 2018-09-30 20           20               20
4553 4553 LIMESTONE MEDICAL CENTER 701 MCCLINTIC DRIVE GROESBECK TX 76642 LIMESTONE (254) 729-3281 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.5319230 -96.5296210 0   293 48 48293         https://data.medicare.gov/resource/xubh-q36u/row-3e5u-tjfa_7eb2 451303 643539 2019-02-22 2018-09-30 20           20               20
547 547 LA PAZ REGIONAL HOSPITAL 1200 WEST MOHAVE ROAD PARKER AZ 85344 LAPAZ (928) 669-9201 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1351370 -114.2855970 0   12 4 4012         https://data.medicare.gov/resource/xubh-q36u/row-sg3z_d8n6.kjbm 31317 643569 2019-02-25 2018-09-30 22 3         25               25
261 261 SWEDISH MEDICAL CENTER 501 E HAMPDEN AVE ENGLEWOOD CO 80113 ARAPAHOE (303) 788-5000 Acute Care Hospitals Proprietary TRUE 39.6531360 -104.9817100 0   5 8 8005 19740 Denver-Aurora, CO Central Arapahoe County https://data.medicare.gov/resource/xubh-q36u/row-3yvr.y5p2.2bay 60034 643574 2019-02-26 2018-09-30 281 58       17 356   16           372
3168 3168 NESHOBA COUNTY GENERAL HOSPITAL 1001 HOLLAND AVENUE PHILADELPHIA MS 39350 NESHOBA (601) 663-1200 Acute Care Hospitals Government - Local TRUE 32.7578160 -89.1054150 0   99 28 28099         https://data.medicare.gov/resource/xubh-q36u/row-k6bw.w463_gjg8 250043 643619 2019-02-26 2018-09-30 38           38 10     160       208
2575 2575 ANDERSON REGIONAL MEDICAL CTR 2124 14 ST MERIDIAN MS 39301 LAUDERDALE (601) 553-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.3707750 -88.6998580 0   75 28 28075 32940   Central Lauderdale County https://data.medicare.gov/resource/xubh-q36u/row-6bta-h82p-22h6 250104 643621 2019-02-25 2018-09-30 231 17 12       260               260
4342 4342 GUADALUPE REGIONAL MEDICAL CENTER 1215 E COURT ST SEGUIN TX 78155 GUADALUPE (830) 379-2411 Acute Care Hospitals Voluntary non-profit - Other TRUE 29.5690430 -97.9483340 0   187 48 48187 41700   Central Guadalupe County https://data.medicare.gov/resource/xubh-q36u/row-gyz4_fre4.eqtq 450104 643647 2019-02-26 2018-09-30 108 9         117   22           139
4638 4638 TEXAS HEALTH HARRIS METHODIST HOSPITAL AZLE 108 DENVER TRAIL AZLE TX 76020 TARRANT (817) 444-8700 Acute Care Hospitals Voluntary non-profit - Church TRUE 32.8811960 -97.5337690 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-jm6x.kyhw.4ivn 450419 643652 2019-02-27 2018-09-30 25 6         31               31
4603 4603 PARMER COUNTY COMMUNITY HOSPITAL 1307 CLEVELAND STREET FRIONA TX 79035 PARMER (806) 250-2754 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.6436340 -102.7210880 0   369 48 48369         https://data.medicare.gov/resource/xubh-q36u/row-tza2_si74_zn9j 451300 643654 2019-02-27 2018-09-30 25           25               25
4577 4577 MEDINA REGIONAL HOSPITAL 3100 AVENUE E HONDO TX 78861 MEDINA (830) 426-7700 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.3352470 -99.1334160 0   325 48 48325 41700   Outlying Medina County https://data.medicare.gov/resource/xubh-q36u/row-i6se_ecqu-nzyr 451330 643655 2019-02-27 2018-09-30 25           25               25
4697 4697 ELECTRA MEMORIAL HOSPITAL 1207 S BAILEY STREET ELECTRA TX 76360 WICHITA (940) 495-3981 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.0184550 -98.9238740 0   485 48 48485 48660   Central Wichita County https://data.medicare.gov/resource/xubh-q36u/row-cvz8.wx35~2ua3 451343 643657 2019-02-25 2018-09-30 19           19               19
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
2871 2871 COLLINGSWORTH GENERAL HOSPITAL 1013 15TH ST WELLINGTON TX 79095 COLLINGSWORTH (806) 447-2521 Critical Access Hospitals Proprietary TRUE 34.8491100 -100.2120150 0   87 48 48087         https://data.medicare.gov/resource/xubh-q36u/row-iy62.m34i.p94f 451355 643660 2019-02-27 2018-09-30 15           15               15
2843 2843 JACKSON MEMORIAL HOSPITAL 1611 NW 12TH AVE MIAMI FL 33136 MIAMI-DADE (305) 585-1111 Acute Care Hospitals Government - Hospital District or Authority TRUE 25.7906120 -80.2149450 0   86 12 12086 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Miami-Dade County https://data.medicare.gov/resource/xubh-q36u/row-7crg~caqv-izm8 100022 643685 2019-02-22 2018-09-30 1169 26 11   65 63 1457 151 55           1663
2885 2885 BAPTIST MEDICAL CENTER - NASSAU 1250 S 18TH ST FERNANDINA BEACH FL 32034 NASSAU (904) 321-3500 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.6530280 -81.4494620 0   89 12 12089 27260 Jacksonville-St. Marys-Palatka, FL-GA Outlying Nassau County https://data.medicare.gov/resource/xubh-q36u/row-v3si~mbmz-bg64 100140 643689 2019-02-26 2018-09-30 54           54               54
421 421 CAPE CANAVERAL HOSPITAL 701 W COCOA BEACH CAUSEWAY COCOA BEACH FL 32932 BREVARD (321) 799-7111 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.3578790 -80.6227330 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-x5ei~t9en-75k9 100177 643691 2019-02-27 2018-09-30 138 12         150               150
885 885 PHYSICIANS REGIONAL MEDICAL CENTER - PINE RIDGE 6101 PINE RIDGE ROAD NAPLES FL 34119 COLLIER (239) 348-4000 Acute Care Hospitals Proprietary TRUE 26.2117640 -81.7307070 0   21 12 12021 34940 Cape Coral-Fort Myers-Naples, FL Central Collier County https://data.medicare.gov/resource/xubh-q36u/row-z54t-v8nq.fk93 100286 643693 2019-02-28 2018-09-30 177 24         201               201
1893 1893 HENDRY REGIONAL MEDICAL CENTER 524 W SAGAMORE AVE CLEWISTON FL 33440 HENDRY (863) 902-3033 Critical Access Hospitals Voluntary non-profit - Other TRUE 26.7532390 -80.9422760 0   51 12 12051 17500   Central Hendry County https://data.medicare.gov/resource/xubh-q36u/row-ati4-fhfd_57wb 101309 643695 2019-02-28 2018-09-30 22 3         25               25
2641 2641 MADISON COUNTY MEMORIAL HOSPITAL 224 NW CRANE AVE MADISON FL 32340 MADISON (850) 973-2271 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.4714130 -83.4198980 0   79 12 12079         https://data.medicare.gov/resource/xubh-q36u/row-gara~x4i8-9hau 101311 643696 2019-02-27 2018-09-30 25           25               25
1222 1222 NORTHSHORE UNIVERSITY HEALTHSYSTEM EVANSTON HOSP 2650 RIDGE AVE EVANSTON IL 60201 COOK (847) 432-8000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.0653000 -87.6832930 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-emix~ri9w-scyq 140010 643702 2019-02-25 2018-09-30 583 71         698 33 20           751
2536 2536 JOHNSON MEMORIAL HOSPITAL 1282 WALNUT STREET DAWSON MN 56232 LAC QUI PARLE (320) 769-4323 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.9309710 -96.0670630 0   73 27 27073         https://data.medicare.gov/resource/xubh-q36u/row-aiqt_9tq3~e2sg 241314 643711 2019-03-04 2018-09-30 20           20       56       76
624 624 CONCORD HOSPITAL 250 PLEASANT ST CONCORD NH 3301 MERRIMACK (603) 225-2711 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.1963290 -71.5623660 0   13 33 33013 18180 Boston-Worcester-Providence, MA-RI-NH-CT Central Merrimack County https://data.medicare.gov/resource/xubh-q36u/row-uzp6_t3mc.vwkr 300001 643718 2019-02-28 2018-09-30 188 18         206 15             221
3515 3515 HOSPITAL SAN CRISTOBAL CARR 506 KM 1 0 COTO LAUREL PR 780 PONCE (787) 848-2100 Acute Care Hospitals Voluntary non-profit - Private TRUE 18.0489279 -66.5531847 1 GEOMETRIC_CENTER 113 72 72113 38660 Ponce-Coamo-Santa Isabel, PR Central Ponce Municipio https://data.medicare.gov/resource/xubh-q36u/row-f3ni_a74v_j5mm 400113 643733 2019-02-28 2018-09-30 110 35         157               157
4521 4521 TEXAS HEALTH HARRIS METHODIST HOSPITAL CLEBURNE 201 WALLS DRIVE CLEBURNE TX 76033 JOHNSON (817) 641-2551 Acute Care Hospitals Voluntary non-profit - Church TRUE 32.3308450 -97.4391890 0   251 48 48251 19100 Dallas-Fort Worth, TX-OK Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-wybt~sj5v-jxx6 450148 643738 2019-02-27 2018-09-30 102 7         109               109
4629 4629 STEPHENS MEMORIAL HOSPITAL 200 SOUTH GENEVA STREET BRECKENRIDGE TX 76424 STEPHENS (254) 559-2241 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7540560 -98.8877190 0   429 48 48429         https://data.medicare.gov/resource/xubh-q36u/row-f2c3_a9xb.afpq 450498 643739 2019-02-27 2018-09-30 14           14               14
2770 2770 COLEMAN COUNTY MEDICAL CENTER COMPANY 310 SOUTH PECOS STREET COLEMAN TX 76834 COLEMAN (325) 625-2135 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.8286260 -99.4252380 0   83 48 48083         https://data.medicare.gov/resource/xubh-q36u/row-arcj.jjrh_hge7 451347 643742 2019-02-28 2018-09-30 25           25               25
395 395 UNIVERSITY OF VERMONT MEDICAL CENTER 111 COLCHESTER AVE BURLINGTON VT 5401 CHITTENDEN (802) 847-0000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.4809910 -73.1955180 0   7 50 50007 15540   Central Chittenden County https://data.medicare.gov/resource/xubh-q36u/row-sa3g~qvqf.2559 470003 643744 2019-02-28 2018-09-30 349 21     25   415   35           450
540 540 NORTHWESTERN MEDICAL CENTER INC 133 FAIRFIELD STREET SAINT ALBANS VT 5478 FRANKLIN (802) 524-5911 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.8064630 -73.0725490 0   11 50 50011 15540   Outlying Franklin County https://data.medicare.gov/resource/xubh-q36u/row-3i6b-md48~jcq5 470024 643745 2019-02-25 2018-09-30 53           53               53
1044 1044 GRACE COTTAGE HOSPITAL PO BOX 216 TOWNSHEND VT 5353 WINDHAM (802) 365-7920 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.0489148 -72.6682465 1 ROOFTOP 25 50 50025         https://data.medicare.gov/resource/xubh-q36u/row-u9ts~hp4k-kd62 471300 643746 2019-02-22 2018-09-30 19           19               19
794 794 GIFFORD MEDICAL CENTER 44 SOUTH MAIN STREET RANDOLPH VT 5060 ORANGE (802) 728-4441 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.9175470 -72.6662550 0   17 50 50017 17200   Outlying Orange County https://data.medicare.gov/resource/xubh-q36u/row-yeuf.js9v_q9as 471301 643747 2019-02-25 2018-09-30 27 2         29               29
1111 1111 MT ASCUTNEY HOSPITAL 289 COUNTY ROAD WINDSOR VT 5089 WINDSOR (802) 674-6711 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.4875220 -72.4009100 0   27 50 50027 17200   Central Windsor County https://data.medicare.gov/resource/xubh-q36u/row-wz4v-vria_i3xt 471302 643748 2019-02-25 2018-09-30 25           25   10           35
1112 1112 SPRINGFIELD HOSPITAL PO BOX 2003 SPRINGFIELD VT 5156 WINDSOR (802) 885-2151 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.2981414 -72.4948662 1 ROOFTOP 27 50 50027 17200   Central Windsor County https://data.medicare.gov/resource/xubh-q36u/row-zewq-djn4-pp8m 471306 643749 2019-02-25 2018-09-30 25           25 10             35
2985 2985 MARION REGIONAL MEDICAL CENTER 1256 MILITARY STREET SOUTH HAMILTON AL 35570 MARION (205) 921-6200 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1258520 -87.9898060 0   93 1 1093         https://data.medicare.gov/resource/xubh-q36u/row-ak6z-c9hr~7upb 10044 643754 2019-02-28 2018-09-30 32 4         36       79       115
721 721 LITTLE COLORADO MEDICAL CENTER 1501 NORTH WILLIAMSON AVENUE WINSLOW AZ 86047 NAVAJO (928) 289-4691 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.0354550 -110.6917420 0   17 4 4017 43320   Central Navajo County https://data.medicare.gov/resource/xubh-q36u/row-wt4g_v5ea_tink 31311 643756 2019-02-27 2018-09-30 25           25               25
891 891 TAYLORVILLE MEMORIAL HOSPITAL 201 EAST PLEASANT STREET TAYLORVILLE IL 62568 CHRISTIAN (217) 824-3331 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.5537530 -89.2937540 0   21 17 17021 45380 Springfield-Jacksonville-Lincoln, IL Central Christian County https://data.medicare.gov/resource/xubh-q36u/row-vfba-cp55.36er 141339 643765 2019-02-26 2018-09-30 25           25               25
825 825 KING'S DAUGHTERS' MEDICAL CENTER 2201 LEXINGTON AVENUE ASHLAND KY 41101 BOYD (606) 408-4401 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.4704010 -82.6359160 0   19 21 21019 26580 Charleston-Huntington-Ashland, WV-OH-KY Central Boyd County https://data.medicare.gov/resource/xubh-q36u/row-2h99.b8qq_r6h2 180009 643766 2019-02-28 2018-09-30 388 38         439       47       486
4079 4079 SPRING VIEW HOSPITAL 320 LORETTO ROAD LEBANON KY 40033 MARION (270) 692-5145 Acute Care Hospitals Proprietary TRUE 37.5703250 -85.2593970 0   155 21 21155         https://data.medicare.gov/resource/xubh-q36u/row-ri6m~j23x~rpdu 180024 643767 2019-02-28 2018-09-30 57 6         63 12             75
1391 1391 MURRAY-CALLOWAY COUNTY HOSPITAL 803 POPLAR STREET MURRAY KY 42071 CALLOWAY (270) 762-1100 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.6086600 -88.3094980 0   35 21 21035 34660   Central Calloway County https://data.medicare.gov/resource/xubh-q36u/row-m7pf.9rnr~pkib 180027 643768 2019-02-25 2018-09-30 89 10         99 12 12   154       277
4380 4380 PIKEVILLE MEDICAL CENTER 911 BYPASS ROAD PIKEVILLE KY 41501 PIKE (606) 218-3500 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.4725100 -82.5239500 0   195 21 21195         https://data.medicare.gov/resource/xubh-q36u/row-h2q9~be2e-2gte 180044 643769 2019-02-28 2018-09-30 189 70         268   26           294
897 897 EPHRAIM MCDOWELL REGIONAL MEDICAL CENTER 217 SOUTH THIRD STREET DANVILLE KY 40422 BOYLE (859) 239-2409 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.6438180 -84.7726380 0   21 21 21021 19220   Central Boyle County https://data.medicare.gov/resource/xubh-q36u/row-umsp-afi7~cb4h 180048 643770 2019-03-01 2018-09-30 148 22         170 27     25       222
2004 2004 CRITTENDEN COMMUNITY HOSPITAL 520 WEST GUM STREET MARION KY 42064 CRITTENDEN (270) 965-1001 Acute Care Hospitals Government - Local TRUE 37.3296160 -88.0919450 0   55 21 21055         https://data.medicare.gov/resource/xubh-q36u/row-29y5_rw8y-4sga 180095 643771 2019-03-01 2018-09-30 48           48               48
3872 3872 EPHRAIM MCDOWELL FORT LOGAN HOSPITAL 110 METKER TRAIL STANFORD KY 40484 LINCOLN (606) 365-4788 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.5436160 -84.6538790 0   137 21 21137 19220   Outlying Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-r5qq~biyw~n5dv 181315 643775 2019-03-01 2018-09-30 25           25               25
1329 1329 BATON ROUGE GENERAL MEDICAL CENTER 3600 FLORIDA BLVD BATON ROUGE LA 70806 E. BATON ROUGE (225) 387-7767 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4503360 -91.1546380 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-wzk2-7azq.gecu 190065 643777 2019-02-28 2018-09-30 212 24   8   9 253 50 8   54       365
3162 3162 ST MARTIN HOSPITAL 210 CHAMPAGNE BOULEVARD BREAUX BRIDGE LA 70517 ST. MARTIN (337) 332-2178 Critical Access Hospitals Voluntary non-profit - Private TRUE 30.2824450 -91.8905530 0   99 22 22099 29180 Lafayette-Opelousas-Morgan City, LA Outlying St. Martin Parish https://data.medicare.gov/resource/xubh-q36u/row-sqtt_6xnf.ujt3 191302 643779 2019-03-01 2018-09-30 25           25               25
748 748 LOWELL GENERAL HOSPITAL 295 VARNUM AVENUE LOWELL MA 1854 MIDDLESEX (978) 937-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6463070 -71.3413230 0   17 25 25017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-2fw8.fd6r.2ntv 220063 643784 2019-02-26 2018-09-30 367 40         407               407
286 286 SOUTHCOAST HOSPITAL GROUP, INC 363 HIGHLAND AVENUE FALL RIVER MA 2720 BRISTOL (508) 679-3131 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7105220 -71.1464390 0   5 25 25005 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Bristol County https://data.medicare.gov/resource/xubh-q36u/row-veij_kb96-ysvv 220074 643785 2019-02-26 2018-09-30 761 58       16 835   32           867
3920 3920 TISHOMINGO HEALTH SERVICES INC 1777 CURTIS DRIVE IUKA MS 38852 TISHOMINGO (662) 423-6051 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.8036860 -88.2092180 0   141 28 28141         https://data.medicare.gov/resource/xubh-q36u/row-8vqy~22mf_tvap 250002 643792 2019-02-28 2018-09-30 48           48               48
186 186 MAGNOLIA REGIONAL HEALTH CENTER 611 ALCORN DRIVE CORINTH MS 38834 ALCORN (662) 293-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.9358670 -88.5586480 0   3 28 28003 18420   Central Alcorn County https://data.medicare.gov/resource/xubh-q36u/row-7e2c-erdj.3exa 250009 643795 2019-02-28 2018-09-30 139 24         163 19             182
2195 2195 JASPER GENERAL HOSPITAL 15 SOUTH 6TH STREET BAY SPRINGS MS 39422 JASPER (601) 764-2101 Acute Care Hospitals Government - Local FALSE 31.9766880 -89.2905550 0   61 28 28061 29860   Outlying Jasper County https://data.medicare.gov/resource/xubh-q36u/row-y8rq~vqyv_stwk 250018 643796 2019-02-27 2018-09-30 20           20               20
4082 4082 WEBSTER GENERAL HOSPITAL/ SWING BED 70 MEDICAL PLAZA EUPORA MS 39744 WEBSTER (662) 258-6221 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.5347360 -89.2669430 0   155 28 28155         https://data.medicare.gov/resource/xubh-q36u/row-a3qx_u9bd-sjek 250020 643797 2019-02-28 2018-09-30 38           38               38
1535 1535 GEORGE REGIONAL HEALTH SYSTEM 859 WINTER STREET LUCEDALE MS 39452 GEORGE (601) 947-3161 Acute Care Hospitals Government - Local TRUE 30.9222350 -88.5928530 0   39 28 28039         https://data.medicare.gov/resource/xubh-q36u/row-f75f~mexp.zvtb 250036 643798 2019-02-28 2018-09-30 36 6         42               42
99 99 MERIT HEALTH NATCHEZ 52 SERGEANT PRENTISS DRIVE NATCHEZ MS 39120 ADAMS (601) 443-2100 Acute Care Hospitals Proprietary TRUE 31.5279831 -91.3884516 1 RANGE_INTERPOLATED 1 28 28001 35020   Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-36cp~uwxv-3duz 250084 643800 2019-02-27 2018-09-30 132 15         147 12 20           179
3536 3536 PONTOTOC HEALTH SERVICE CAH 176 SOUTH MAIN STREET PONTOTOC MS 38863 PONTOTOC (662) 489-5510 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.2428270 -88.9968000 0   115 28 28115 46180   Outlying Pontotoc County https://data.medicare.gov/resource/xubh-q36u/row-cgtx~8fwc-42mt 251308 643801 2019-02-28 2018-09-30 25           25               25
3112 3112 TYLER HOLMES MEMORIAL HOSPITAL CAH 409 TYLER HOLMES DRIVE WINONA MS 38967 MONTGOMERY (662) 283-4114 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.4906520 -89.7377480 0   97 28 28097         https://data.medicare.gov/resource/xubh-q36u/row-ynxj~8abv-iadk 251312 643802 2019-03-01 2018-09-30 25           25               25
1276 1276 COVINGTON COUNTY HOSPITAL CAH 701 SOUTH HOLLY AVENUE COLLINS MS 39428 COVINGTON (601) 765-6711 Critical Access Hospitals Government - Local TRUE 31.6382360 -89.5544240 0   31 28 28031         https://data.medicare.gov/resource/xubh-q36u/row-6qgj_6i6m-qfrk 251325 643804 2019-02-27 2018-09-30 25           25               25
1651 1651 GREENE COUNTY HOSPITAL CAH 1017 JACKSON STREET LEAKESVILLE MS 39451 GREENE (601) 394-4135 Critical Access Hospitals Government - Local TRUE 31.1547640 -88.5626450 0   41 28 28041         https://data.medicare.gov/resource/xubh-q36u/row-w43a~rntf~brjp 251329 643805 2019-02-28 2018-09-30 7           7               7
618 618 BMH-CALHOUN 140 BURKE-CALHOUN CITY ROAD CALHOUN CITY MS 38916 CALHOUN (662) 628-6611 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.8696650 -89.3171760 0   13 28 28013         https://data.medicare.gov/resource/xubh-q36u/row-583j-immm~hxvr 251331 643806 2019-03-01 2018-09-30 25           25               25
1915 1915 CAPE FEAR VALLEY MEDICAL CENTER 1638 OWEN DRIVE P O BOX 2000 FAYETTEVILLE NC 28302 CUMBERLAND (910) 609-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0324120 -78.9310960 0   51 37 37051 22180 Fayetteville-Lumberton-Laurinburg, NC Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-9vgu~9uhh_eymv 340028 643815 2019-02-28 2018-09-30 492 48         584   72           656
4005 4005 VIDANT MEDICAL CENTER 2100 STANTONSBURG RD GREENVILLE NC 27834 PITT (252) 847-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.6058100 -77.4009520 0   147 37 37147 24780 Greenville-Washington, NC Central Pitt County https://data.medicare.gov/resource/xubh-q36u/row-7q4f-6u6k_hghr 340040 643816 2019-02-28 2018-09-30 637 71         816 52 75           943
4315 4315 WAKEMED 3000 NEW BERN AVE RALEIGH NC 27610 WAKE (919) 350-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.7861390 -78.5890670 0   183 37 37183 39580 Raleigh-Durham-Chapel Hill, NC Central Wake County https://data.medicare.gov/resource/xubh-q36u/row-b29x_tvnt.h38s 340069 643817 2019-02-28 2018-09-30 445 12 38   9 10 585   98           683
2801 2801 BETSY JOHNSON REGIONAL HOSPITAL 800 TILGHMAN DR DUNN NC 28334 HARNETT (910) 892-7161 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.3065550 -78.6330880 0   85 37 37085 20380 Raleigh-Durham-Chapel Hill, NC Central Harnett County https://data.medicare.gov/resource/xubh-q36u/row-28jj~ikwb_xihf 340071 643818 2019-02-28 2018-09-30 137 14         151               151
4316 4316 WAKEMED 1900 KILDARE FARM ROAD CARY NC 27518 WAKE (919) 350-2550 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.7401880 -78.7799180 0   183 37 37183 39580 Raleigh-Durham-Chapel Hill, NC Central Wake County https://data.medicare.gov/resource/xubh-q36u/row-hbjc.gqsf_6a5b 340173 643819 2019-02-27 2018-09-30 158 12         178               178
3006 3006 CAPE FEAR VALLEY HOKE HOSPITAL 210 MEDICAL PAVILION DRIVE RAEFORD NC 28376 HOKE (910) 904-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0314260 -79.1088240 0   93 37 37093 22180 Fayetteville-Lumberton-Laurinburg, NC Central Hoke County https://data.medicare.gov/resource/xubh-q36u/row-awx4~hxxz-7m7w 340188 643820 2019-02-28 2018-09-30 41           41               41
4239 4239 COMMUNITY HOSPITALS AND WELLNESS CENTERS 433 WEST HIGH STREET BRYAN OH 43506 WILLIAMS (419) 636-1131 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.4746100 -84.5568240 0   171 39 39171         https://data.medicare.gov/resource/xubh-q36u/row-bs9m~yv3v_fpkc 360121 643825 2019-02-27 2018-09-30 68 7         75               75
4238 4238 COMMUNITY HOSPITALS AND WELLNESS CENTERS 909 EAST SNYDER AVENUE MONTPELIER OH 43543 WILLIAMS (419) 485-3154 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.5893210 -84.5955160 0   171 39 39171         https://data.medicare.gov/resource/xubh-q36u/row-kbd3.ekvw_88qh 361327 643830 2019-02-27 2018-09-30 25           25               25
2720 2720 STROUD REGIONAL MEDICAL CENTER 2308 HIGHWAY 66 WEST STROUD OK 74079 LINCOLN (918) 968-3571 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.7500350 -96.6832260 0   81 40 40081 36420 Oklahoma City-Shawnee, OK Outlying Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-32s4-f67h_3c7q 371316 643835 2019-03-01 2018-09-30 25           25               25
1762 1762 PRISMA HEALTH GREER MEMORIAL HOSPITAL 830 SOUTH BUNCOMBE ROAD GREER SC 29650 GREENVILLE (864) 848-8200 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.9193100 -82.2420310 0   45 45 45045 24860 Greenville-Spartanburg-Anderson, SC Central Greenville County https://data.medicare.gov/resource/xubh-q36u/row-xcyi~2q2z~2aqn 420033 643840 2019-02-28 2018-09-30 49 8         57               57
1763 1763 PRISMA HEALTH HILLCREST HOSPITAL 741 SOUTH EAST MAIN STREET SIMPSONVILLE SC 29681 GREENVILLE (864) 454-6100 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7181340 -82.2467360 0   45 45 45045 24860 Greenville-Spartanburg-Anderson, SC Central Greenville County https://data.medicare.gov/resource/xubh-q36u/row-7tzq.68bi~s86f 420037 643841 2019-02-28 2018-09-30 37 6         43               43
2164 2164 PRISMA HEALTH LAURENS COUNTY HOSPITAL 22725 HIGHWAY 76 EAST CLINTON SC 29325 LAURENS (864) 833-9100 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.4797180 -81.9411520 0   59 45 45059 24860 Greenville-Spartanburg-Anderson, SC Outlying Laurens County https://data.medicare.gov/resource/xubh-q36u/row-qum6.2nj9-aisw 420038 643842 2019-02-28 2018-09-30 35   8       43       14       57
1759 1759 PRISMA HEALTH GREENVILLE MEMORIAL HOSPITAL 905 VERDAE BLVD SUITE 102 GREENVILLE SC 29605 GREENVILLE (864) 455-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.8291560 -82.3192040 0   45 45 45045 24860 Greenville-Spartanburg-Anderson, SC Central Greenville County https://data.medicare.gov/resource/xubh-q36u/row-rfz9-6mpm-5bj3 420078 643844 2019-02-28 2018-09-30 526 58 28       682 46 53   18       799
1760 1760 PRISMA HEALTH PATEWOOD HOSPITAL 175 PATEWOOD DRIVE GREENVILLE SC 29615 GREENVILLE (864) 797-1000 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.8527350 -82.3261150 0   45 45 45045 24860 Greenville-Spartanburg-Anderson, SC Central Greenville County https://data.medicare.gov/resource/xubh-q36u/row-6pw3~wdbm.z7ry 420102 643846 2019-02-28 2018-09-30 38           38               38
4645 4645 BAYLOR SCOTT AND WHITE ALL SAINTS MEDICAL CENTER 1400 EIGHTH AVE FORT WORTH TX 76104 TARRANT (817) 926-2544 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.7302880 -97.3437290 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-99v8_22t5~zuq2 450137 643849 2019-02-28 2018-09-30 275 39       63 377               377
3966 3966 TEXAS HEALTH HARRIS METHODIST HOSPITAL STEPHENVILL 411 N BELKNAP ST STEPHENVILLE TX 76401 ERATH (254) 965-1500 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.2231630 -98.2048710 0   143 48 48143 44500   Central Erath County https://data.medicare.gov/resource/xubh-q36u/row-3e4m_j29y-qggx 450351 643850 2019-02-28 2018-09-30 45 5         50               50

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