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

124 rows where "filed_date" is on date 2019-11-25

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, fy_end_date, 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-11-25 · 124 ✖
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
2 2 HUGGINS HOSPITAL 240 SOUTH MAIN STREET WOLFEBORO NH 3894 CARROLL (603) 569-7500 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.5809440 -71.2015750 0   3 33 33003         https://data.medicare.gov/resource/xubh-q36u/row-u6j2-zv25.9ghd 301312 659991 2019-11-25 2018-09-30 21 4         25               25
32 32 SHARE MEDICAL CENTER 800 SHARE DRIVE ALVA OK 73717 WOODS (580) 327-2800 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.7869690 -98.6700230 0   151 40 40151         https://data.medicare.gov/resource/xubh-q36u/row-gzmq-89k6~9n3d 371341 659863 2019-11-25 2019-06-30 25           25         80     105
60 60 UNIVERSITY OF COLORADO HOSPITAL AUTHORITY 12605 E 16TH AVE AURORA CO 80045 ADAMS (720) 848-0000 Acute Care Hospitals Government - Hospital District or Authority TRUE 39.7413640 -104.8412750 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-sx7w-4iik_kiyq 60024 659482 2019-11-25 2019-06-30 432 101   19 24 50 650   12           662
136 136 COPPER QUEEN COMMUNITY HOSPITAL 101 COLE AVENUE BISBEE AZ 85603 COCHISE (520) 432-6401 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.4172540 -109.8826000 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-3x2q~x9dv.fg6n 31312 659555 2019-11-25 2019-06-30 14           14               14
137 137 BENSON HOSPITAL 450 SOUTH OCOTILLO AVENUE BENSON AZ 85602 COCHISE (520) 586-2261 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.9648290 -110.3071230 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-bbyb-3jvj_e7ef 31301 660910 2019-11-25 2019-06-30 22           22               22
215 215 HACKENSACK MERIDIAN HEALTH PASCACK VALLEY MEDICAL 250 OLD HOOK ROAD WESTWOOD NJ 7675 BERGEN (201) 383-1035 Acute Care Hospitals Proprietary TRUE 40.9836580 -74.0141950 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-kwcd-72qg_ygd9 310130 660416 2019-11-25 2019-06-30 64 9         78               78
343 343 ENLOE MEDICAL CENTER 1531 ESPLANADE CHICO CA 95926 BUTTE (530) 332-7300 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7422840 -121.8491280 0   7 6 6007 17020   Central Butte County https://data.medicare.gov/resource/xubh-q36u/row-tmgf-6deh.hnij 50039 659472 2019-11-25 2019-06-30 259 33         298   40           338
359 359 MIDMICHIGAN MEDICAL CENTER - ALPENA 1501 W CHISHOLM ST ALPENA MI 49707 ALPENA (989) 356-7390 Acute Care Hospitals Proprietary TRUE 45.0768570 -83.4506720 0   7 26 26007 10980   Central Alpena County https://data.medicare.gov/resource/xubh-q36u/row-3cst~3hfe~ssf7 230036 660579 2019-11-25 2019-06-30 119 9         128   11           139
393 393 ERLANGER BLEDSOE HOSPITAL 71 WHEELERTOWN AVENUE PIKEVILLE TN 37367 BLEDSOE (423) 447-2112 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.6218300 -85.1883040 0   7 47 47007         https://data.medicare.gov/resource/xubh-q36u/row-86fw~zcvu.6xu7 441306 659536 2019-11-25 2019-06-30 25           25               25
430 430 AUDUBON COUNTY MEMORIAL HOSPITAL 515 PACIFIC AVENUE AUDUBON IA 50025 AUDUBON (712) 563-2611 Critical Access Hospitals Government - Local TRUE 41.7154230 -94.9370440 0   9 19 19009         https://data.medicare.gov/resource/xubh-q36u/row-7tp4_zwyw_2d9j 161330 659788 2019-11-25 2019-06-30 25           25               25
464 464 ST MICHAEL'S HOSPITAL - CAH 410 W 16TH AVE TYNDALL SD 57066 BON HOMME (605) 589-2100 Critical Access Hospitals Government - Local TRUE 42.9912530 -97.8678960 0   9 46 46009         https://data.medicare.gov/resource/xubh-q36u/row-sqz9_y3kz.mu4d 431327 659612 2019-11-25 2019-06-30 25           25               25
466 466 BLOUNT MEMORIAL HOSPITAL 907 E LAMAR ALEXANDER PARKWAY MARYVILLE TN 37804 BLOUNT (865) 983-7211 Acute Care Hospitals Government - Local TRUE 35.7549750 -83.9586020 0   9 47 47009 28940 Knoxville-Morristown-Sevierville, TN Central Blount County https://data.medicare.gov/resource/xubh-q36u/row-q2u9.xgek.22ux 440011 659450 2019-11-25 2019-06-30 177 8 8       193 10     76       279
471 471 ST MARYS HOSPITAL MEDICAL CTR 1726 SHAWANO AVE GREEN BAY WI 54303 BROWN (920) 498-4200 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.5321840 -88.0665610 0   9 55 55009 24580 Green Bay-Shawano, WI Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-kt4k-sbbe~w8n6 520097 660733 2019-11-25 2019-06-30 75 8         83               83
506 506 MAINEGENERAL MEDICAL CENTER 35 MEDICAL CENTER PARKWAY AUGUSTA ME 4330 KENNEBEC (207) 626-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.3608530 -69.7857180 0   11 23 23011 12300   Central Kennebec County https://data.medicare.gov/resource/xubh-q36u/row-k6q5-wdks.vqnn 200039 659964 2019-11-25 2019-06-30 156 16         172   20           192
518 518 SOUTHERN NH MEDICAL CENTER 8 PROSPECT STREET NASHUA NH 3060 HILLSBOROUGH (603) 577-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.7560610 -71.4612290 0   11 33 33011 31700 Boston-Worcester-Providence, MA-RI-NH-CT Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-z29g.nws7.yp8q 300020 659990 2019-11-25 2019-06-30 131 11         142 18             160
527 527 MERCY HOSPITAL WATONGA, INC 500 NORTH CLARENCE NASH BOULEVARD WATONGA OK 73772 BLAINE (580) 623-7211 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.8494550 -98.4192480 0   11 40 40011         https://data.medicare.gov/resource/xubh-q36u/row-sccp_42z7.7ame 371302 659715 2019-11-25 2019-06-30 25           25               25
686 686 UNION HOSPITAL OF CECIL COUNTY 106 BOW STREET ELKTON MD 21921 CECIL (410) 392-7009 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.6080100 -75.8310280 0   15 24 24015 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Cecil County https://data.medicare.gov/resource/xubh-q36u/row-pkde-hn33.kiax 210032 660230 2019-11-25 2019-06-30 91 5         96               96
688 688 SPECTRUM HEALTH PENNOCK 1009 W GREEN ST HASTINGS MI 49058 BARRY (269) 945-3451 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.6442000 -85.3021000 0   15 26 26015 24340 Grand Rapids-Wyoming-Muskegon, MI Outlying Barry County https://data.medicare.gov/resource/xubh-q36u/row-7m4u.pz7d~8678 231339 660108 2019-11-25 2019-06-30 19 6         25               25
709 709 CURRY GENERAL HOSPITAL 94220 FOURTH STREET GOLD BEACH OR 97444 CURRY (541) 247-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.4116590 -124.4186580 0   15 41 41015 15060   Central Curry County https://data.medicare.gov/resource/xubh-q36u/row-9rud.6rf5~it7z 381322 659603 2019-11-25 2019-06-30 16           16               16
714 714 SAINT THOMAS STONES RIVER HOSPITAL 324 DOOLITTLE ROAD WOODBURY TN 37190 CANNON (615) 563-4001 Acute Care Hospitals Proprietary TRUE 35.8328650 -86.0729430 0   15 47 47015 34980 Nashville-Davidson--Murfreesboro, TN Outlying Cannon County https://data.medicare.gov/resource/xubh-q36u/row-cff9_8h9t.y7xa 440200 659459 2019-11-25 2019-06-30 30           30 22             52
832 832 MILLINOCKET REGIONAL HOSPITAL 200 SOMERSET STREET MILLINOCKET ME 4462 PENOBSCOT (207) 723-5161 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.6527290 -68.7150760 0   19 23 23019 12620   Central Penobscot County https://data.medicare.gov/resource/xubh-q36u/row-j6pc.k4d7~avr8 201307 659965 2019-11-25 2019-06-30 25           25               25
852 852 MERCY HOSPITAL ARDMORE, INC 1011 FOURTEENTH AVENUE, NORTHWEST ARDMORE OK 73401 CARTER (580) 223-5400 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1884510 -97.1400180 0   19 40 40019 11620   Central Carter County https://data.medicare.gov/resource/xubh-q36u/row-vred.e6gv~ukx2 370047 659857 2019-11-25 2019-06-30 127 13         140 20 20           180
853 853 MERCY HOSPITAL HEALDTON, INC. 3462 HOSPITAL RD HEALDTON OK 73438 CARTER (580) 229-0701 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.2229910 -97.4921780 0   19 40 40019 11620   Central Carter County https://data.medicare.gov/resource/xubh-q36u/row-i6td_hvi7_qxjw 371310 659717 2019-11-25 2019-06-30 22           22               22
854 854 LOWER UMPQUA HOSPITAL DISTRICT 600 RANCH ROAD REEDSPORT OR 97467 DOUGLAS (541) 271-2171 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.6953240 -124.1355710 0   19 41 41019 40700   Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-nysc.rhhn_bb99 381311 659602 2019-11-25 2019-06-30 16           16               16
902 902 FREDERICK HEALTH HOSPITAL 400 WEST SEVENTH ST FREDERICK MD 21701 FREDERICK (240) 566-3300 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.4237450 -77.4140700 0   21 24 24021 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Outlying Frederick County https://data.medicare.gov/resource/xubh-q36u/row-kk8k_tw4w-dcjn 210005 659799 2019-11-25 2019-06-30 248 18       15 281               281
930 930 SETON SMITHVILLE REGIONAL HOSPITAL 1201 HILL RD SMITHVILLE TX 78957 BASTROP (512) 237-3214 Acute Care Hospitals Voluntary non-profit - Church TRUE 30.0039505 -97.1360218 1 ROOFTOP 21 48 48021 12420   Outlying Bastrop County https://data.medicare.gov/resource/xubh-q36u/row-d2dp~cvuc~gmre 450143 659733 2019-11-25 2019-06-30 8           8               8
1029 1029 NOR-LEA HOSPITAL DISTRICT 1600 NORTH MAIN AVE LOVINGTON NM 88260 LEA (575) 396-6611 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.9647900 -103.3486370 0   25 35 35025 26020   Central Lea County https://data.medicare.gov/resource/xubh-q36u/row-9cky_vw6p_hbsu 321305 659823 2019-11-25 2019-06-30 25           25               25
1202 1202 NATIONAL JEWISH HEALTH 1400 JACKSON ST DENVER CO 80206 DENVER (303) 388-4461 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7400190 -104.9428920 0   31 8 8031 19740 Denver-Aurora, CO Central Denver County https://data.medicare.gov/resource/xubh-q36u/row-7hr7.gg8i-chk4 60107 659641 2019-11-25 2019-06-30 24           24               24
1221 1221 LARABIDA CHILDRENS HOSPITAL I E 65TH ST AT LAKE MICHIGAN CHICAGO IL 60649 COOK (773) 363-6700 Childrens Voluntary non-profit - Private FALSE 41.7768110 -87.6015927 1 GEOMETRIC_CENTER 31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-cnjg.zfnx-s5dn 143301 659950 2019-11-25 2019-06-30 49           49               49
1277 1277 SAINT FRANCIS MEDICAL CENTER 211 ST FRANCIS DR CAPE GIRARDEAU MO 63703 CAPE GIRARDEAU (573) 331-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.3034070 -89.5712971 1 ROOFTOP 31 29 29031 16020 Cape Girardeau-Sikeston, MO-IL Central Cape Girardeau County https://data.medicare.gov/resource/xubh-q36u/row-2cqn~hh59_aitm 260183 660119 2019-11-25 2019-06-30 216 31         283   24           307
1284 1284 RENOWN REGIONAL MEDICAL CENTER 1155 MILL STREET RENO NV 89502 WASHOE (775) 982-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.5247470 -119.7967210 0   31 32 32031 39900 Reno-Carson City-Fernley, NV Central Washoe County https://data.medicare.gov/resource/xubh-q36u/row-i3ys.ziyg-wgzb 290001 661049 2019-11-25 2019-06-30 344 216 38       637               637
1286 1286 RENOWN SOUTH MEADOWS MEDICAL CENTER 10101 DOUBLE R BLVD RENO NV 89521 WASHOE (775) 982-7063 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.4358940 -119.7583930 0   31 32 32031 39900 Reno-Carson City-Fernley, NV Central Washoe County https://data.medicare.gov/resource/xubh-q36u/row-hisx-cy9i-2hnh 290049 660259 2019-11-25 2019-06-30 42 34         76   62           138
1301 1301 CLARION HOSPITAL ONE HOSPITAL DRIVE CLARION PA 16214 CLARION (814) 226-9500 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.1927583 -79.3976930 1 ROOFTOP 31 42 42031         https://data.medicare.gov/resource/xubh-q36u/row-5n3x.3zm2.8hqq 390093 660440 2019-11-25 2019-06-30 50 7         57   8           65
1307 1307 ESSENTIA HEALTH ST MARY'S HOSPITAL - SUPERIOR 3500 TOWER AVE SUPERIOR WI 54880 DOUGLAS (715) 817-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.6981950 -92.1040480 0   31 55 55031 20260   Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-e5mc~9gdv_htnc 521329 660735 2019-11-25 2019-06-30 25           25               25
1366 1366 HARBORVIEW MEDICAL CENTER 325 9TH AVENUE SEATTLE WA 98104 KING (206) 731-3000 Acute Care Hospitals Government - Local TRUE 47.6040840 -122.3233720 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-fu42.79v4.ss25 500064 659621 2019-11-25 2019-06-30 232 89         321 68 24           413
1372 1372 UW MEDICINE/NORTHWEST HOSPITAL 1550 NORTH 115TH STREET SEATTLE WA 98133 KING (206) 368-1700 Acute Care Hospitals Voluntary non-profit - Other TRUE 47.7122630 -122.3359360 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-drv9~ptgn-5qjd 500001 660337 2019-11-25 2019-06-30 147 32         179 27             206
1395 1395 ESSENTIA HEALTH ST JOSEPH'S MEDICAL CENTER 523 NORTH 3RD STREET BRAINERD MN 56401 CROW WING (218) 829-2861 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.3625090 -94.2051430 0   35 27 27035 14660   Central Crow Wing County https://data.medicare.gov/resource/xubh-q36u/row-qjsu~wksq.gb8w 240075 659977 2019-11-25 2019-06-30 117 10         127               127
1496 1496 SAINT FRANCIS MEDICAL CENTER 3630 EAST IMPERIAL HIGHWAY LYNWOOD CA 90262 LOS ANGELES (310) 900-8900 Acute Care Hospitals Voluntary non-profit - Church FALSE 33.9310160 -118.2038340 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-dsew-en9m.iktv 50104 662017 2019-11-25 2019-06-30 279 36       29 344       30       374
1527 1527 SAINT VINCENT MEDICAL CENTER 2131 W 3RD ST LOS ANGELES CA 90057 LOS ANGELES (213) 484-7111 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.0631900 -118.2736650 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-eg7n_qzjr.u6rm 50502 660171 2019-11-25 2019-06-30 253 67         320   19   27       366
1572 1572 SAINT THOMAS MIDTOWN HOSPITAL 2000 CHURCH ST NASHVILLE TN 37236 DAVIDSON (615) 284-5555 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.1534000 -86.8008350 0   37 47 47037 34980 Nashville-Davidson--Murfreesboro, TN Central Davidson County https://data.medicare.gov/resource/xubh-q36u/row-bacj-bxth_hwij 440133 659456 2019-11-25 2019-06-30 317 37       41 395   24           419
1602 1602 COOPERSTOWN MEDICAL CENTER 1200 ROBERTS AVE NE COOPERSTOWN ND 58425 GRIGGS (701) 797-2221 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.4456240 -98.1185500 0   39 38 38039         https://data.medicare.gov/resource/xubh-q36u/row-qi2g~gwic_kc3w 351306 660659 2019-11-25 2019-06-30 18           18               18
1643 1643 SPENCER MUNICIPAL HOSPITAL 1200 1ST AVENUE EAST SPENCER IA 51301 CLAY (712) 264-8300 Acute Care Hospitals Government - Local TRUE 43.1500090 -95.1438420 0   41 19 19041 43980   Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-nipj.ewp3-j7u2 160112 660216 2019-11-25 2019-06-30 49           49 15             64
1670 1670 SAINT THOMAS DEKALB HOSPITAL 520 W MAIN ST SMITHVILLE TN 37166 DE KALB (615) 215-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 35.9594030 -85.8298410 0   41 47 47041         https://data.medicare.gov/resource/xubh-q36u/row-vj84-zvtf.4wg9 440148 659457 2019-11-25 2019-06-30 48 4         52               52
1678 1678 STONEWALL JACKSON MEMORIAL HOSPITAL 230 HOSPITAL PLAZA WESTON WV 26452 LEWIS (304) 269-8080 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0482850 -80.4927430 0   41 54 54041         https://data.medicare.gov/resource/xubh-q36u/row-2afu_zh5p.j9t2 510038 660725 2019-11-25 2019-06-30 64 6         70               70
1683 1683 CENTURA HEALTH-ST THOMAS MORE HOSPITAL 1338 PHAY AVENUE CANON CITY CO 81212 FREMONT (719) 285-2000 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.4557470 -105.2302640 0   43 8 8043 15860 Pueblo-Cañon City, CO Central Fremont County https://data.medicare.gov/resource/xubh-q36u/row-6heh-cpck-6gmw 61344 659766 2019-11-25 2019-06-30 21 4         25       108       133
1789 1789 LIBERTY HOSPITAL 2525 GLENN HENDREN DR LIBERTY MO 64069 CLAY (816) 781-7200 Acute Care Hospitals Government - Hospital District or Authority TRUE 39.2767570 -94.4243430 0   47 29 29047 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-e8b7~a55p.dgyp 260177 660118 2019-11-25 2019-06-30 179 20         199               199
1866 1866 OHIO STATE UNIVERSITY HOSPITALS 410 WEST 10TH AVENUE COLUMBUS OH 43210 FRANKLIN (614) 293-9700 Acute Care Hospitals Government - State TRUE 39.9948840 -83.0176860 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-fagn.mmer_2f8n 360085 660671 2019-11-25 2019-06-30 885 97         982 91 60           1133
1943 1943 NATIVIDAD MEDICAL CENTER 1441 CONSTITUTION BOULEVARD SALINAS CA 93906 MONTEREY (831) 755-4195 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.6954720 -121.6312400 0   53 6 6053 41500   Central Monterey County https://data.medicare.gov/resource/xubh-q36u/row-ye8m-fbff-nu37 50248 659560 2019-11-25 2019-06-30 123 10         148   24           172
1976 1976 SETON HIGHLAND LAKES HIGHWAY 281 SOUTH BURNET TX 78611 BURNET (512) 715-3000 Critical Access Hospitals Voluntary non-profit - Private TRUE 30.7113209 -98.2467221 1 GEOMETRIC_CENTER 53 48 48053         https://data.medicare.gov/resource/xubh-q36u/row-khw5~6jgp-v7pk 451365 659615 2019-11-25 2019-06-30 21 4         25               25
2002 2002 REGIONAL MEDICAL CENTER 709 W MAIN STREET MANCHESTER IA 52057 DELAWARE (563) 927-3232 Critical Access Hospitals Proprietary TRUE 42.4839030 -91.4666440 0   55 19 19055         https://data.medicare.gov/resource/xubh-q36u/row-znx9.yjf2.jpru 161343 660219 2019-11-25 2019-06-30 25           25           1   26
2035 2035 CHAMBERSBURG HOSPITAL 112 NORTH SEVENTH STREET CHAMBERSBURG PA 17201 FRANKLIN (717) 267-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9349150 -77.6474510 0   55 42 42055 16540 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-iq68~7hvz.5n6c 390151 659608 2019-11-25 2019-06-30 211   24     7 242 26 17           285
2036 2036 WAYNESBORO HOSPITAL 501 EAST MAIN ST WAYNESBORO PA 17268 FRANKLIN (717) 765-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7518060 -77.5705810 0   55 42 42055 16540 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-uwye.3yp9-qu7a 390138 659607 2019-11-25 2019-06-30 57           57               57
2040 2040 ASCENSION SETON EDGAR B DAVIS 130 HAYS STREET LULING TX 78648 CALDWELL (830) 875-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 29.6725300 -97.6542540 0   55 48 48055 12420   Outlying Caldwell County https://data.medicare.gov/resource/xubh-q36u/row-wn52-vdac_k6nj 451371 660154 2019-11-25 2019-06-30 23           23               23
2073 2073 MIDMICHIGAN MEDICAL CENTER-GRATIOT 300 E WARWICK DR ALMA MI 48801 GRATIOT (989) 463-1101 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.3916800 -84.6622780 0   57 26 26057 10940 Mount Pleasant-Alma, MI Central Gratiot County https://data.medicare.gov/resource/xubh-q36u/row-7bpx_say8-8gij 230030 660577 2019-11-25 2019-06-30 49           49 30 18           97
2081 2081 SAKAKAWEA MEDICAL CENTER - CAH 510 8TH AVENUE NE HAZEN ND 58545 MERCER (701) 748-2225 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.2982860 -101.6115600 0   57 38 38057         https://data.medicare.gov/resource/xubh-q36u/row-772i_c662.4xam 351310 660272 2019-11-25 2019-06-30 13           13               13
2355 2355 BAPTIST HEALTH LEXINGTON 1740 NICHOLASVILLE ROAD LEXINGTON KY 40503 FAYETTE (859) 260-6104 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.0188420 -84.5139480 0   67 21 21067 30460 Lexington-Fayette--Richmond--Frankfort, KY Central Fayette County https://data.medicare.gov/resource/xubh-q36u/row-w47h-k353~ymyx 180103 660563 2019-11-25 2018-08-31 339 52         391               391
2375 2375 MUSC HEALTH MARION MEDICAL CENTER 2829 E HWY 76 MULLINS SC 29574 MARION (843) 431-2000 Acute Care Hospitals Government - State TRUE 34.1892320 -79.3219450 0   67 45 45067         https://data.medicare.gov/resource/xubh-q36u/row-nueg_7h5n~iagx 420055 660703 2019-11-25 2019-06-30 84 10         94               94
2377 2377 AVERA ST BENEDICT HEALTH CENTER - CAH 401 WEST GLYNN DRIVE PARKSTON SD 57366 HUTCHINSON (605) 928-3311 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3989450 -97.9900610 0   67 46 46067         https://data.medicare.gov/resource/xubh-q36u/row-w4r3_dmvi-zsg5 431330 660035 2019-11-25 2019-06-30 25           25         49     74
2392 2392 SOUTH LAKE HOSPITAL 1900 DON WICKHAM DR CLERMONT FL 34711 LAKE (352) 394-4071 Acute Care Hospitals Government - Hospital District or Authority FALSE 28.5511780 -81.7234150 0   69 12 12069 36740 Orlando-Deltona-Daytona Beach, FL Outlying Lake County https://data.medicare.gov/resource/xubh-q36u/row-z7xz~yu83_5nfj 100051 661477 2019-11-25 2018-09-30 124 16         140       30       170
2411 2411 MERCY HOSPITAL TISHOMINGO 1000 SOUTH BYRD TISHOMINGO OK 73460 JOHNSTON (580) 371-2327 Critical Access Hospitals Voluntary non-profit - Church TRUE 34.2224450 -96.6752940 0   69 40 40069         https://data.medicare.gov/resource/xubh-q36u/row-d4ji~yfmc.9fmx 371304 659716 2019-11-25 2019-06-30 25           25               25
2488 2488 NEWBERRY COUNTY MEMORIAL HOSPITAL 2669 KINARD ST PO BOX 497 NEWBERRY SC 29108 NEWBERRY (803) 405-7145 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.2894330 -81.6049150 0   71 45 45071 35140 Columbia-Orangeburg-Newberry, SC Central Newberry County https://data.medicare.gov/resource/xubh-q36u/row-9ehy.xh96.39uz 420053 659725 2019-11-25 2019-06-30 41 7         48               48
2504 2504 GRANDVIEW MEDICAL CENTER 3690 GRANDVIEW PARKWAY BIRMINGHAM AL 35243 JEFFERSON (205) 971-1000 Acute Care Hospitals Proprietary TRUE 33.4343630 -86.7204830 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-pwut_di96_m4tu 10104 660349 2019-11-25 2019-06-30 289 72         373 12 17           402
2544 2544 MERCY HOSPITAL KINGFISHER, INC 1000 KINGFISHER HOSPITAL DRIVE KINGFISHER OK 73750 KINGFISHER (405) 375-3141 Critical Access Hospitals Voluntary non-profit - Church TRUE 35.8100746 -97.9449387 1 ROOFTOP 73 40 40073         https://data.medicare.gov/resource/xubh-q36u/row-h8q6~j6ue-y5ca 371313 660141 2019-11-25 2019-06-30 25           25               25
2582 2582 ELKVIEW GENERAL HOSPITAL 429 WEST ELM STREET HOBART OK 73651 KIOWA (580) 726-3324 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.0368290 -99.0983400 0   75 40 40075         https://data.medicare.gov/resource/xubh-q36u/row-gdd4_6kz4-h5ey 370153 659714 2019-11-25 2019-06-30 38           38               38
2600 2600 PIEDMONT NEWNAN HOSPITAL, INC 745 POPLAR ROAD NEWNAN GA 30265 COWETA (770) 400-2300 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.3593630 -84.7540620 0   77 13 13077 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Coweta County https://data.medicare.gov/resource/xubh-q36u/row-nhqn.yikd_3ahg 110229 659491 2019-11-25 2019-06-30 122 18       10 150               150
2660 2660 WILKES-BARRE GENERAL HOSPITAL 575 NORTH RIVER STREET WILKES-BARRE PA 18764 LUZERNE (570) 829-8111 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2582610 -75.8681650 0   79 42 42079 42540   Central Luzerne County https://data.medicare.gov/resource/xubh-q36u/row-jy6y.9gqv-dbyu 390137 659527 2019-11-25 2019-06-30 228 30         258   19           277
2666 2666 MADISON REGIONAL HEALTH SYSTEM 323 SW 10TH ST MADISON SD 57042 LAKE (605) 256-6551 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.9930210 -97.1197520 0   79 46 46079         https://data.medicare.gov/resource/xubh-q36u/row-j5pm.hb44_44j6 431300 659611 2019-11-25 2019-06-30 22           22               22
2685 2685 SETON MEDICAL CENTER 1900 SULLIVAN AVENUE DALY CITY CA 94015 SAN MATEO (650) 992-4000 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.6803150 -122.4729100 0   81 6 6081 41860 San Jose-San Francisco-Oakland, CA Central San Mateo County https://data.medicare.gov/resource/xubh-q36u/row-cym9-4kks~kvua 50289 660168 2019-11-25 2019-06-30 227 28         255 24     155   44   478
2727 2727 SAINT THOMAS HICKMAN HOSPITAL 135 EAST SWAN STREET CENTERVILLE TN 37033 HICKMAN (931) 729-4271 Critical Access Hospitals Voluntary non-profit - Private FALSE 35.7795390 -87.4602420 0   81 47 47081 34980 Nashville-Davidson--Murfreesboro, TN Outlying Hickman County https://data.medicare.gov/resource/xubh-q36u/row-3u9v~yfau~8vwh 441300 659460 2019-11-25 2019-06-30 25           25         40     65
2763 2763 MERCY HOSPITAL LOGAN COUNTY, INC 200 S ACADEMY RD GUTHRIE OK 73044 LOGAN (405) 282-6700 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.8775430 -97.4604910 0   83 40 40083 36420 Oklahoma City-Shawnee, OK Central Logan County https://data.medicare.gov/resource/xubh-q36u/row-gqau_gh2v.54h6 371317 659600 2019-11-25 2019-06-30 25           25               25
2796 2796 POPLAR COMMUNITY HOSPITAL 211 H ST E POPLAR MT 59255 ROOSEVELT (406) 768-6100 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1149570 -105.1921240 0   85 30 30085         https://data.medicare.gov/resource/xubh-q36u/row-ivpb.zvpr-3zj8 271300 660638 2019-11-25 2019-06-30 20           20               20
2797 2797 TRINITY HOSPITAL 315 KNAPP ST WOLF POINT MT 59201 ROOSEVELT (406) 653-6500 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1008930 -105.6411380 0   85 30 30085         https://data.medicare.gov/resource/xubh-q36u/row-8zsu~ksjh-u24d 271341 659988 2019-11-25 2019-06-30 22           22       60       82
2850 2850 FISHERMEN'S COMMUNITY HOSPITAL 3301 OVERSEAS HWY MARATHON FL 33050 MONROE (305) 743-5533 Critical Access Hospitals Voluntary non-profit - Private TRUE 24.7111300 -81.0947200 0   87 12 12087 28580   Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-3mjy.7a5u.ezdd 101312 659771 2019-11-25 2019-06-30 4 1         5               5
2890 2890 RUSH COPLEY MEDICAL CENTER 2000 OGDEN AVENUE AURORA IL 60504 KANE (630) 978-6200 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7277220 -88.2684150 0   89 17 17089 16980 Chicago-Naperville, IL-IN-WI Central Kane County https://data.medicare.gov/resource/xubh-q36u/row-39d4~37w6~ivsi 140029 659945 2019-11-25 2019-06-30 157 22         192   18           210
2943 2943 FRANCISCAN HEALTH MICHIGAN CITY 3500 FRANCISCAN WAY MICHIGAN CITY IN 46360 LA PORTE (219) 879-8511 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.6595891 -86.8986778 1 ROOFTOP 91 18 18091 33140 Chicago-Naperville, IL-IN-WI Central LaPorte County https://data.medicare.gov/resource/xubh-q36u/row-3sxf-2kxc.xexc 150015 660075 2019-11-25 2018-12-31 135 14         149 18 16           183
3076 3076 PROVIDENCE HOSPITAL 6801 AIRPORT BOULEVARD MOBILE AL 36608 MOBILE (251) 633-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 30.6816900 -88.1983290 0   97 1 1097 33660 Mobile-Daphne-Fairhope, AL Central Mobile County https://data.medicare.gov/resource/xubh-q36u/row-e52k.abk5_gk2c 10090 659399 2019-11-25 2019-06-30 296 33 20       349               349
3102 3102 ORTHOINDY HOSPITAL 8400 NORTHWEST BLVD INDIANAPOLIS IN 46278 MARION (317) 956-1000 Acute Care Hospitals Physician FALSE 39.9067020 -86.2662580 0   97 18 18097 26900 Indianapolis-Carmel-Muncie, IN Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-sa8x~jqdx_zkr2 150160 660543 2019-11-25 2018-12-31 38           38               38
3214 3214 AVERA CREIGHTON HOSPITAL P O BOX 186, 1503 MAIN ST CREIGHTON NE 68729 KNOX (402) 358-5700 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.4664016 -97.9072475 1 ROOFTOP 107 31 31107         https://data.medicare.gov/resource/xubh-q36u/row-7tv3_vise~cn54 281331 660258 2019-11-25 2019-06-30 23           23       47       70
3216 3216 JOHNSTON HEALTH 509 BRIGHT LEAF BLVD SMITHFIELD NC 27577 JOHNSTON (919) 934-8171 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.5131610 -78.3336590 0   101 37 37101 39580 Raleigh-Durham-Chapel Hill, NC Central Johnston County https://data.medicare.gov/resource/xubh-q36u/row-m8in-cgbk_vjwx 340090 659711 2019-11-25 2019-06-30 155 24         179 20         18   217
3217 3217 KENMARE COMMUNITY HOSPITAL PO BOX 697 KENMARE ND 58746 WARD (701) 385-4296 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.6742881 -102.0844703 1 ROOFTOP 101 38 38101 33500   Central Ward County https://data.medicare.gov/resource/xubh-q36u/row-tfzi_r3ee-4azt 351305 660271 2019-11-25 2019-06-30 25           25               25
3218 3218 TRINITY HOSPITALS 407 3RD ST SE MINOT ND 58701 WARD (701) 857-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 48.2324790 -101.2884520 0   101 38 38101 33500   Central Ward County https://data.medicare.gov/resource/xubh-q36u/row-7zuw.yviv_94dm 350006 661068 2019-11-25 2019-06-30 117 19         152 26 20   230   2   430
3263 3263 UNIVERSITY OF IOWA HOSPITAL & CLINICS 200 HAWKINS DRIVE IOWA CITY IA 52242 JOHNSON (319) 356-1616 Acute Care Hospitals Government - State TRUE 41.6612030 -91.5507590 0   103 19 19103 26980 Cedar Rapids-Iowa City, IA Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-cxgc_xna4~4mhi 160058 660215 2019-11-25 2019-06-30 497   24 17 36 88 716 73             789
3315 3315 SPECTRUM HEALTH LUDINGTON HOSPITAL ONE N ATKINSON DRIVE LUDINGTON MI 49431 MASON (231) 843-2591 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.9582193 -86.4302207 1 ROOFTOP 105 26 26105 31220   Central Mason County https://data.medicare.gov/resource/xubh-q36u/row-4jbc-wihk_b6pr 230110 660590 2019-11-25 2019-06-30 39 6         45               45
3336 3336 SIERRA VIEW MEDICAL CENTER 465 W PUTNAM AVE PORTERVILLE CA 93257 TULARE (559) 784-1110 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0695730 -119.0272740 0   107 6 6107 47300 Visalia-Porterville-Hanford, CA Central Tulare County https://data.medicare.gov/resource/xubh-q36u/row-vc8a~kkez_xqy4 50261 660354 2019-11-25 2019-06-30 118 10         128       35       163
3346 3346 SPECTRUM HEALTH BIG RAPIDS HOSPITAL 605 OAK STREET BIG RAPIDS MI 49307 MECOSTA (231) 796-8691 Acute Care Hospitals Government - Local TRUE 43.6931260 -85.4757630 0   107 26 26107 13660 Grand Rapids-Wyoming-Muskegon, MI Central Mecosta County https://data.medicare.gov/resource/xubh-q36u/row-6wsn~km5g_qqzq 230093 660588 2019-11-25 2019-06-30 45 4         49               49
3392 3392 MERCY HOSPITAL OKLAHOMA CITY, INC 4300 WEST MEMORIAL ROAD OKLAHOMA CITY OK 73120 OKLAHOMA (405) 752-3754 Acute Care Hospitals Voluntary non-profit - Church TRUE 35.6090260 -97.5996250 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-bxb9~8ruy_a7b8 370013 659855 2019-11-25 2019-06-30 244 36       28 308               308
3525 3525 REDMOND REGIONAL MEDICAL CENTER 501 REDMOND ROAD ROME GA 30165 FLOYD (706) 802-3012 Acute Care Hospitals Proprietary TRUE 34.2781910 -85.1941310 0   115 13 13115 40660 Rome-Summerville, GA Central Floyd County https://data.medicare.gov/resource/xubh-q36u/row-z5aw~bjka~vbtd 110168 659773 2019-11-25 2019-06-30 168 16 24       208   20           228
3561 3561 PIPESTONE COUNTY MEDICAL CENTER 916 4TH AVENUE SOUTHWEST PIPESTONE MN 56164 PIPESTONE (507) 825-5811 Critical Access Hospitals Government - Local TRUE 43.9910820 -96.3221070 0   117 27 27117         https://data.medicare.gov/resource/xubh-q36u/row-pzdb_wxvr-4ugg 241374 659508 2019-11-25 2019-06-30 18           18               18
3571 3571 COMMUNITY MEMORIAL HOSPITAL 1755 NORTH MECKLENBURG AVENUE SOUTH HILL VA 23970 MECKLENBURG (434) 447-3151 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.7476560 -78.1041060 0   117 51 51117         https://data.medicare.gov/resource/xubh-q36u/row-k7c8~fbew_tsmb 490098 659747 2019-11-25 2019-06-30 56   10       66       140       206
3631 3631 PIEDMONT HOSPITAL 1968 PEACHTREE RD NW ATLANTA GA 30309 FULTON (404) 605-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.8088020 -84.3933690 0   121 13 13121 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Fulton County https://data.medicare.gov/resource/xubh-q36u/row-53ay_f9xi~a54p 110083 659489 2019-11-25 2019-06-30 407 56 20     29 512               512
3667 3667 SOUTH PENINSULA HOSPITAL 4300 BARTLETT ST HOMER AK 99603 KENAI PENINSULA (907) 235-8101 Critical Access Hospitals Voluntary non-profit - Private TRUE 59.6521330 -151.5502960 0   122 2 2122         https://data.medicare.gov/resource/xubh-q36u/row-cng5-kv9j-dmyn 21313 659751 2019-11-25 2019-06-30 21           21       28       49
3692 3692 MERCY HOSPITAL ADA 430 NORTH MONTE VISTA ADA OK 74820 PONTOTOC (580) 332-2323 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7780680 -96.6348130 0   123 40 40123 10220   Central Pontotoc County https://data.medicare.gov/resource/xubh-q36u/row-itqt-xmxc.8n32 370020 659524 2019-11-25 2019-06-30 96 12         108 20 20           148
3830 3830 SPECTRUM HEALTH REED CITY HOSPITAL 300 N PATTERSON, PO BOX 75 REED CITY MI 49677 OSCEOLA (231) 832-3271 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.8782450 -85.5211907 1 ROOFTOP 133 26 26133         https://data.medicare.gov/resource/xubh-q36u/row-hhgy~8j82.d9qv 231323 660106 2019-11-25 2019-06-30 21 4         25       50       75
3852 3852 HILLSBORO AREA HOSPITAL 1200 E TREMONT STREET HILLSBORO IL 62049 MONTGOMERY (217) 532-6111 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1536720 -89.4815080 0   135 17 17135         https://data.medicare.gov/resource/xubh-q36u/row-hr8s~ac96_26fy 141332 659949 2019-11-25 2019-06-30 25           25               25
3922 3922 PENDER MEMORIAL HOSPITAL 507 E FREMONT ST BURGAW NC 28425 PENDER (910) 300-4004 Critical Access Hospitals Government - Local TRUE 34.5512630 -77.9204230 0   141 37 37141 48900   Outlying Pender County https://data.medicare.gov/resource/xubh-q36u/row-7fvf-phgu_s8i7 341307 659598 2019-11-25 2018-09-30 25           25       43       68
3981 3981 ST CLOUD HOSPITAL 1406 6TH AVE NORTH SAINT CLOUD MN 56303 STEARNS (320) 255-5661 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5753250 -94.1704500 0   145 27 27145 41060 Minneapolis-St. Paul, MN-WI Central Stearns County https://data.medicare.gov/resource/xubh-q36u/row-i2df-wytp-8ht6 240036 659976 2019-11-25 2019-06-30 385 42       30 457   20           477
4008 4008 NORTHCREST MEDICAL CENTER 100 NORTHCREST DRIVE SPRINGFIELD TN 37172 ROBERTSON (615) 384-2411 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.4795180 -86.8888980 0   147 47 47147 34980 Nashville-Davidson--Murfreesboro, TN Outlying Robertson County https://data.medicare.gov/resource/xubh-q36u/row-xhnc.dc7v_7vxz 440065 660043 2019-11-25 2019-06-30 101 8         109               109
4027 4027 SAINT THOMAS RUTHERFORD HOSPITAL 1700 MEDICAL CENTER PARKWAY MURFREESBORO TN 37129 RUTHERFORD (615) 396-4100 Acute Care Hospitals Voluntary non-profit - Church TRUE 35.8586400 -86.4242410 0   149 47 47149 34980 Nashville-Davidson--Murfreesboro, TN Outlying Rutherford County https://data.medicare.gov/resource/xubh-q36u/row-nv4b-ikm9-tmer 440053 659454 2019-11-25 2019-06-30 202 68       17 287               287
4029 4029 PIEDMONT HENRY HOSPITAL 1133 EAGLE'S LANDING PARKWAY STOCKBRIDGE GA 30281 HENRY (678) 604-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.5089960 -84.2255610 0   151 13 13151 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Henry County https://data.medicare.gov/resource/xubh-q36u/row-vhdk-mf48~gr2g 110191 659490 2019-11-25 2019-06-30 196   40     16 252       89       341
4031 4031 POCAHONTAS COMMUNITY HOSPITAL 606 N W 7TH STREET POCAHONTAS IA 50574 POCAHONTAS (712) 335-3501 Critical Access Hospitals Government - Local TRUE 42.7408220 -94.6787780 0   151 19 19151         https://data.medicare.gov/resource/xubh-q36u/row-mhbi~vwku-j27n 161305 659787 2019-11-25 2019-06-30 25           25               25

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