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

64 rows where "filed_date" is on date 2019-02-27

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

filed_date (date) ✖

  • 2019-02-27 · 64 ✖
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
11 11 CROSSRIDGE COMMUNITY HOSPITAL 310 SOUTH FALLS BOULEVARD WYNNE AR 72396 CROSS (870) 238-3300 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.2203530 -90.7874210 0   37 5 5037         https://data.medicare.gov/resource/xubh-q36u/row-9vam~w7bd~4ivg 41307 644210 2019-02-27 2018-09-30 15           15               15
24 24 ST ALOISIUS MEDICAL CENTER 325 E BREWSTER ST HARVEY ND 58341 WELLS (701) 324-4651 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.7676870 -99.9330890 0   103 38 38103         https://data.medicare.gov/resource/xubh-q36u/row-u657.4sxp.u7ix 351327 644053 2019-02-27 2018-09-30 25           25       91       116
64 64 DANBURY HOSPITAL 24 HOSPITAL AVE DANBURY CT 6810 FAIRFIELD (203) 739-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.4067760 -73.4443390 0   1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-ekru_jpam-gjnq 70033 644104 2019-02-27 2018-09-30 319 41         360 22 14           396
65 65 BRIDGEPORT HOSPITAL 267 GRANT STREET BRIDGEPORT CT 6610 FAIRFIELD (203) 384-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.1887760 -73.1660800 0   1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-i2q3_c2gu.vbzu 70010 644221 2019-02-27 2018-09-30 300 16     16   332 39             371
67 67 GREENWICH HOSPITAL ASSOCIATION - 5 PERRYRIDGE RD GREENWICH CT 6830 FAIRFIELD (203) 863-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0343950 -73.6296320 0   1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-z487-bxe7-a8jv 70018 644223 2019-02-27 2018-09-30 161 10       10 181               181
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
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
288 288 STURDY MEMORIAL HOSPITAL 211 PARK STREET ATTLEBORO MA 2703 BRISTOL (508) 222-5200 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.9426950 -71.2752790 0   5 25 25005 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Bristol County https://data.medicare.gov/resource/xubh-q36u/row-hsm9~94fs~psx5 220008 644033 2019-02-27 2018-09-30 117 14         131               131
368 368 UPPER CONNECTICUT VALLEY HOSPITAL 181 CORLISS LANE COLEBROOK NH 3576 COOS (603) 237-4971 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9044120 -71.4814890 0   7 33 33007 13620   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-5jxk.h2s8~zvc6 301300 644312 2019-02-27 2018-09-30 16           16               16
410 410 YALE-NEW HAVEN HOSPITAL 20 YORK ST NEW HAVEN CT 6504 NEW HAVEN (203) 688-4242 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.3042850 -72.9346890 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-vv7z~adrr_fj28 70022 644224 2019-02-27 2018-09-30 1020 50 30   38 19 1279 118 24   119       1540
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
422 422 PALM BAY HOSPITAL 1425 MALABAR RD, NE PALM BAY FL 32907 BREVARD (321) 434-8000 Acute Care Hospitals Proprietary TRUE 27.9983300 -80.6120800 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-a9fd-uaut~kpyk 100316 646071 2019-02-27 2018-09-30 108 12         120 18             138
442 442 BEVERLY HOSPITAL CORPORATION 85 HERRICK STREET BEVERLY MA 1915 ESSEX (978) 922-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.5675920 -70.8762010 0   9 25 25009 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Essex County https://data.medicare.gov/resource/xubh-q36u/row-2c3b_zuwj.rint 220033 644036 2019-02-27 2018-09-30 274 22         296 68             364
700 700 CARLSBAD MEDICAL CENTER 2430 WEST PIERCE STREET CARLSBAD NM 88220 EDDY (575) 887-4570 Acute Care Hospitals Proprietary FALSE 32.4418400 -104.2586420 0   15 35 35015 16100   Central Eddy County https://data.medicare.gov/resource/xubh-q36u/row-5km2_nhcx~29i4 320063 655571 2019-02-27 2018-08-31 84 12         96   10   15       121
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
749 749 WINCHESTER HOSPITAL 41 HIGHLAND AVENUE WINCHESTER MA 1890 MIDDLESEX (781) 729-9000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.4654960 -71.1214080 0   17 25 25017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-q8fw-g6i4-ywa7 220105 644740 2019-02-27 2018-09-30 179 10         205               205
750 750 LAHEY HOSPITAL & MEDICAL CENTER, BURLINGTON 41 & 45 MALL ROAD BURLINGTON MA 1803 MIDDLESEX (781) 744-5100 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.4865780 -71.2056300 0   17 25 25017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-jtcm.j8qc.8xmv 220171 644998 2019-02-27 2018-09-30 293 52         345               345
758 758 COMMUNITY MEMORIAL HOSPITAL 512 SKYLINE BOULEVARD CLOQUET MN 55720 CARLTON (218) 879-4641 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.7318440 -92.4624590 0   17 27 27017 20260   Outlying Carlton County https://data.medicare.gov/resource/xubh-q36u/row-wydg_i87y-v2ai 241364 645271 2019-02-27 2018-09-30 18   4       22       44       66
802 802 ORO VALLEY HOSPITAL 1551 EAST TANGERINE ROAD ORO VALLEY AZ 85755 PIMA (520) 901-3549 Acute Care Hospitals Proprietary TRUE 32.4271830 -110.9495400 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-mmb4.ma8p-hv7h 30114 644207 2019-02-27 2018-09-30 75 36         111 17 18           146
906 906 SOUTH SHORE HOSPITAL 55 FOGG ROAD SOUTH WEYMOUTH MA 2190 NORFOLK (781) 340-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.1747200 -70.9540750 0   21 25 25021 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Norfolk County https://data.medicare.gov/resource/xubh-q36u/row-cywc_kz9x_rwwf 220100 645265 2019-02-27 2018-09-30 358 34         392               392
1077 1077 MILFORD REGIONAL MEDICAL CENTER 14 PROSPECT STREET MILFORD MA 1757 WORCESTER (508) 473-1190 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.1328350 -71.5290140 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-29x2.m737-ktj6 220090 644739 2019-02-27 2018-09-30 135 10         145               145
1165 1165 ASANTE ASHLAND COMMUNITY HOSPITAL 280 MAPLE STREET ASHLAND OR 97520 JACKSON (541) 201-4017 Acute Care Hospitals Government - Local TRUE 42.2064450 -122.7251290 0   29 41 41029 32780 Medford-Grants Pass, OR Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-xsnr-xsme.wejp 380005 644057 2019-02-27 2018-09-30 34 4         38               38
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
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
1340 1340 BAPTIST MEMORIAL HOSPITAL DESOTO 7601 SOUTHCREST PARKWAY SOUTHAVEN MS 38671 DE SOTO (662) 772-4000 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.9683480 -89.9955350 0   33 28 28033 32820 Memphis-Forrest City, TN-MS-AR Central DeSoto County https://data.medicare.gov/resource/xubh-q36u/row-p6mp~9htx.zd8z 250141 644306 2019-02-27 2018-09-30 273   36       309   30           339
1404 1404 BLUE MOUNTAIN HOSPITAL 802 SOUTH 200 WEST BLANDING UT 84511 SAN JUAN (435) 678-3993 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.6144490 -109.4815440 0   37 49 49037         https://data.medicare.gov/resource/xubh-q36u/row-fzdn.n6iq~872c 461310 644671 2019-02-27 2018-09-30 11           11               11
1579 1579 MIZELL MEMORIAL HOSPITAL 702 N MAIN ST OPP AL 36467 COVINGTON (334) 493-3541 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.2919720 -86.2554150 0   39 1 1039         https://data.medicare.gov/resource/xubh-q36u/row-syeg~nab9~7ee4 10007 644003 2019-02-27 2018-09-30 40 5         45 14             59
1790 1790 EXCELSIOR SPRINGS HOSPITAL 1700 RAINBOW BOULEVARD EXCELSIOR SPRINGS MO 64024 CLAY (816) 630-6081 Critical Access Hospitals Government - Local TRUE 39.3622170 -94.2365190 0   47 29 29047 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-7pwj-2gs7.gpk5 261322 644516 2019-02-27 2018-09-30 25           25         60     85
1856 1856 CAROLINA EAST MEDICAL CENTER 2000 NEUSE BLVD NEW BERN NC 28560 CRAVEN (252) 633-8640 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.1118930 -77.0662160 0   49 37 37049 35100 New Bern-Morehead City, NC Central Craven County https://data.medicare.gov/resource/xubh-q36u/row-p2zz.x8hz~epee 340131 645136 2019-02-27 2018-09-30 214 72         286   20           306
1990 1990 GADSDEN REGIONAL MEDICAL CENTER 1007 GOODYEAR AVENUE GADSDEN AL 35903 ETOWAH (256) 494-4000 Acute Care Hospitals Proprietary TRUE 34.0093890 -85.9675200 0   55 1 1055 23460   Central Etowah County https://data.medicare.gov/resource/xubh-q36u/row-bfqk~mdpt-2yrq 10040 644005 2019-02-27 2018-09-30 182 40         222 49             271
2049 2049 TAMPA GENERAL HOSPITAL 1 TAMPA GENERAL CIR TAMPA FL 33606 HILLSBOROUGH (813) 844-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 27.9372720 -82.4591280 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-wsdc~nyp9_puqz 100128 644241 2019-02-27 2018-09-30 698 77 30 6 18 9 920   59           979
2072 2072 THIBODAUX REGIONAL MEDICAL CENTER 602 N ACADIA ROAD THIBODAUX LA 70301 LAFOURCHE (985) 447-5500 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.7805460 -90.8068190 0   57 22 22057 26380   Central Lafourche Parish https://data.medicare.gov/resource/xubh-q36u/row-gquu-42z7-apmr 190004 643886 2019-02-27 2018-09-30 114 16         130 16 14           160
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
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
2346 2346 BLESSING HOSPITAL BROADWAY ST & N 11TH ST QUINCY IL 62305 ADAMS (217) 223-1200 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3930840 -91.3440810 0   67 17 17067 22800   Outlying Hancock County https://data.medicare.gov/resource/xubh-q36u/row-pfrr.qnhm.x236 140015 645244 2019-02-27 2018-09-30 223 25         248 41 18   20       327
2359 2359 SOUTH CENTRAL REG MED CTR 1220 JEFFERSON ST BOX 607 LAUREL MS 39440 JONES (601) 426-4000 Acute Care Hospitals Government - Local TRUE 31.6859110 -89.1413500 0   67 28 28067 29860   Central Jones County https://data.medicare.gov/resource/xubh-q36u/row-5i4a~fevp-cvm5 250058 644753 2019-02-27 2018-09-30 254 14         268               268
2425 2425 HIGHLANDS MEDICAL CENTER 380 WOODS COVE ROAD SCOTTSBORO AL 35768 JACKSON (256) 259-4444 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6612540 -86.0471160 0   71 1 1071 42460 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-pkzd.p7rm.i3y6 10061 644084 2019-02-27 2018-09-30 158 10         168       50       218
2537 2537 MADISON HOSPITAL 820 THIRD AVENUE MADISON MN 56256 LAC QUI PARLE (320) 598-7536 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.0166350 -96.1887820 0   73 27 27073         https://data.medicare.gov/resource/xubh-q36u/row-dn7z_rt9e.ipjw 241372 645272 2019-02-27 2018-09-30 12           12       65       77
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
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
2718 2718 THE MOSES H CONE MEMORIAL HOSPITAL 1200 N ELM ST GREENSBORO NC 27401 GUILFORD (336) 832-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0906520 -79.7888150 0   81 37 37081 24660 Greensboro--Winston-Salem--High Point, NC Central Guilford County https://data.medicare.gov/resource/xubh-q36u/row-qjmt_pnnp-uzqk 340091 645134 2019-02-27 2018-09-30 586 77 22   11 36 732 50 49           831
2861 2861 BAPTIST MEMORIAL HOSPITAL GOLDEN TRIANGLE INC 2520 5TH STREET N COLUMBUS MS 39701 LOWNDES (662) 244-1500 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5264880 -88.4290710 0   87 28 28087 18060   Central Lowndes County https://data.medicare.gov/resource/xubh-q36u/row-tjf2_igtg~9u4g 250100 644756 2019-02-27 2018-09-30 140 18         158 30     23       211
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
3293 3293 CRANE COUNTY HOSPITAL DISTRICT 1310 S ALFORD ST CRANE TX 79731 CRANE (432) 558-3555 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.3905650 -102.3493730 0   103 48 48103         https://data.medicare.gov/resource/xubh-q36u/row-q9vt-2wgg.5txf 451353 655608 2019-02-27 2018-09-30 25           25               25
3409 3409 WESTERN WISCONSIN HEALTH 1100 BERGSLIEN ST BALDWIN WI 54002 ST. CROIX (715) 684-1111 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9412820 -92.3760280 0   109 55 55109 33460 Minneapolis-St. Paul, MN-WI Outlying St. Croix County https://data.medicare.gov/resource/xubh-q36u/row-a6vz_52c3-apfq 521347 644391 2019-02-27 2018-09-30 25           25               25
3437 3437 LAKE REGION HEALTHCARE CORPORATION 712 SOUTH CASCADE FERGUS FALLS MN 56537 OTTER TAIL (218) 736-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.2771380 -96.0724070 0   111 27 27111 22260   Central Otter Tail County https://data.medicare.gov/resource/xubh-q36u/row-c4f3_9mxv.cwip 240052 645268 2019-02-27 2018-09-30 75 5         80 14 14           108
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
3712 3712 MCLAREN OAKLAND 50 N PERRY ST PONTIAC MI 48342 OAKLAND (248) 338-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6383940 -83.2910950 0   125 26 26125 19820 Detroit-Warren-Ann Arbor, MI Central Oakland County https://data.medicare.gov/resource/xubh-q36u/row-3bzu-t8bq_ne8q 230207 644748 2019-02-27 2018-09-30 99 9         108 27 16           151
3740 3740 HALIFAX HEALTH MEDICAL CENTER 303 N CLYDE MORRIS BLVD DAYTONA BEACH FL 32114 VOLUSIA (386) 254-4000 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.2005500 -81.0553400 0   127 12 12127 19660 Orlando-Deltona-Daytona Beach, FL Central Volusia County https://data.medicare.gov/resource/xubh-q36u/row-jefw_v3dx.hcti 100017 644230 2019-02-27 2018-09-30 310   43       436 68 40           544
3845 3845 OCONOMOWOC MEMORIAL HOSPITAL 791 E SUMMIT AVE OCONOMOWOC WI 53066 WAUKESHA (262) 569-9400 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.1011360 -88.4861090 0   133 55 55133 33340 Milwaukee-Racine-Waukesha, WI Central Waukesha County https://data.medicare.gov/resource/xubh-q36u/row-2h4h-p3qh-q6i3 520062 644387 2019-02-27 2018-09-30 47 11         58               58
3857 3857 LIFECARE MEDICAL CENTER 715 DELMORE DRIVE ROSEAU MN 56751 ROSEAU (218) 463-2500 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.8398220 -95.7599470 0   135 27 27135         https://data.medicare.gov/resource/xubh-q36u/row-k2tw.t9zs_excc 241344 645269 2019-02-27 2018-09-30 25           25       50       75
4061 4061 WAYNE GENERAL HOSPITAL 950 MATTHEW DR WAYNESBORO MS 39367 WAYNE (601) 735-5151 Acute Care Hospitals Government - Local TRUE 31.6736010 -88.6333120 0   153 28 28153         https://data.medicare.gov/resource/xubh-q36u/row-tfe3.zk6i-7e8n 250077 644509 2019-02-27 2018-09-30 43 6         49               49
4131 4131 JEFF DAVIS HOSPITAL 163 SOUTH TALLAHASSEE STREET HAZLEHURST GA 31539 JEFF DAVIS (912) 375-7781 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.8578930 -82.6073970 0   161 13 13161         https://data.medicare.gov/resource/xubh-q36u/row-s2ua.vggz_haj5 111333 644115 2019-02-27 2018-09-30 21 4         25               25
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
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
4276 4276 RAY COUNTY MEMORIAL HOSPITAL 904 WOLLARD BOULEVARD RICHMOND MO 64085 RAY (816) 470-5432 Critical Access Hospitals Government - Local TRUE 39.2643940 -93.9561730 0   177 29 29177 28140 Kansas City-Overland Park-Kansas City, MO-KS Outlying Ray County https://data.medicare.gov/resource/xubh-q36u/row-mqv3.5d72~fjx6 261327 644761 2019-02-27 2018-10-31 25           25               25
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
4388 4388 SILVER CROSS HOSPITAL AND MEDICAL CENTERS 1900 SILVER CROSS BLVD NEW LENOX IL 60451 WILL (815) 300-1100 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.5454300 -87.9860490 0   197 17 17197 16980 Chicago-Naperville, IL-IN-WI Central Will County https://data.medicare.gov/resource/xubh-q36u/row-s43s~6uzs_wn7g 140213 645249 2019-02-27 2018-09-30 229 28         257 20 25           302
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
4565 4565 LYNN COUNTY HOSPITAL DISTRICT 2600 LOCKWOOD STREET TAHOKA TX 79373 LYNN (806) 998-4533 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.1665390 -101.8155070 0   305 48 48305 31180 Lubbock-Levelland, TX Outlying Lynn County https://data.medicare.gov/resource/xubh-q36u/row-i29z.nfyx~xbur 451351 643982 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
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
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
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

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