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

77 rows where "filed_date" is on date 2019-11-25 and hospital_type = "Acute Care Hospitals"

View and edit SQL

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

Link rowid ▼ hospital_name address city state zip_code county_name phone_number hospital_type hospital_ownership emergency_services lat lng geocode_flag geocode_accuracy countyfips statefips statecountyfips cbsacode csatitle centraloutlyingcounty countyequivalent hosp_lookup_url PRVDR_NUM RPT_REC_NUM filed_date fy_end_date acute_beds icu_beds coronary_beds burn_beds surg_icu_beds oth_spec_beds subtotal_acute_beds subprovider_ipf_beds subprovider_irf_beds subprovider_oth_beds skilled_nursing_beds nursing_fac_beds oth_longterm_beds hospice_beds all_beds
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
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 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 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
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 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 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 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
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
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
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
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 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
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
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 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 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 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
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 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 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 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 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 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
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 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 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
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 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 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
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 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
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
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 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
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
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 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
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 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 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
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
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 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 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 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
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
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 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 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 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 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 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 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
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 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
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
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 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 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 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
4064 AKRON GENERAL MEDICAL CENTER 1 AKRON GENERAL AVENUE AKRON OH 44307 SUMMIT (330) 344-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0778590 -81.5327870 0   153 39 39153 10420 Cleveland-Akron-Canton, OH Central Summit County https://data.medicare.gov/resource/xubh-q36u/row-fwyk~yqdc~my3b 360027 660664 2019-11-25 2018-12-31 315 34 34       383 53             436
4278 SAINT THOMAS RIVER PARK HOSPITAL 1559 SPARTA STREET MC MINNVILLE TN 37110 WARREN (931) 815-4101 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.6986940 -85.7423390 0   177 47 47177 32660   Central Warren County https://data.medicare.gov/resource/xubh-q36u/row-qm5q~p4wm-m3k7 440151 659458 2019-11-25 2019-06-30 92 8         100 10 15           125
4279 MEMORIAL HOSPITAL 1110 NORTH SARAH DEWITT DRIVE GONZALES TX 78629 GONZALES (830) 672-7581 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.5158950 -97.4288680 0   177 48 48177         https://data.medicare.gov/resource/xubh-q36u/row-7g7y.b4hd-s8g5 450235 659735 2019-11-25 2019-06-30 34           34               34
4330 SAINT THOMAS HIGHLANDS HOSPITAL 401 SEWELL DR SPARTA TN 38583 WHITE (931) 738-9211 Acute Care Hospitals Proprietary TRUE 35.9481200 -85.4770740 0   185 47 47185         https://data.medicare.gov/resource/xubh-q36u/row-kw75.zwj7_gsiz 440192 660314 2019-11-25 2019-06-30 28 4         32 14             46
4366 WAYNE MEMORIAL HOSPITAL 2700 WAYNE MEMORIAL DR GOLDSBORO NC 27534 WAYNE (919) 736-1110 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.4008310 -77.9533420 0   191 37 37191 24140   Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-4zsd_c7iy.v8vj 340010 659334 2019-11-25 2019-06-30 245 16         261               261
4367 JOHNSTON MEMORIAL HOSPITAL 16000 JOHNSTON MEMORIAL DRIVE ABINGDON VA 24211 WASHINGTON (276) 258-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.7206700 -81.9085600 0   191 51 51191 28700 Johnson City-Kingsport-Bristol, TN-VA Outlying Washington County https://data.medicare.gov/resource/xubh-q36u/row-ysbq~qbac~97nx 490053 660721 2019-11-25 2019-06-30 101 14         115               115
4417 HCA HOUSTON HEALTHCARE TOMBALL 605 HOLDERRIETH TOMBALL TX 77375 HARRIS (281) 351-1623 Acute Care Hospitals Proprietary TRUE 30.0887030 -95.6239850 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-qwg3~p4ci.ubu8 450670 659543 2019-11-25 2019-06-30 167 20       7 194 21 26           241
4419 MEMORIAL HERMANN HOSPITAL SYSTEM 1635 NORTH LOOP WEST HOUSTON TX 77008 HARRIS (713) 448-6796 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.8122660 -95.4308990 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-2kjx_z9h3~iiu7 450184 659537 2019-11-25 2019-06-30 1068 157       85 1310   78           1388
4436 MEMORIAL HERMANN TEXAS MEDICAL CENTER 6411 FANNIN HOUSTON TX 77030 HARRIS (713) 704-3700 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.7136840 -95.3976270 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-dk5e-jq9i-qp7s 450068 659613 2019-11-25 2019-06-30 658 38 18     118 994   12   8       1014
4568 PROVIDENCE HEALTH CENTER 6901 MEDICAL PARKWAY WACO TX 76712 MC LENNAN (254) 751-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.5132430 -97.1984310 0   309 48 48309 47380   Central McLennan County https://data.medicare.gov/resource/xubh-q36u/row-vgx2-viz4_yy8e 450042 659893 2019-11-25 2019-06-30 195 30         225 46             271
4667 DELL SETON MED CENTER AT THE UNIVERSITY OF TX 601 E 15TH STREET AUSTIN TX 78701 TRAVIS (512) 324-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2750550 -97.7329770 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-8gyh.j6jb.jjky 450124 660050 2019-11-25 2019-06-30 166 60         226               226
4674 ASCENSION SETON MEDICAL CENTER AUSTIN 1201 W 38TH ST AUSTIN TX 78705 TRAVIS (512) 324-1000 Acute Care Hospitals Physician TRUE 30.3061540 -97.7452180 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-qf7b-dsjj.a9dv 450056 659731 2019-11-25 2019-06-30 304 83       43 430               430
4675 ASCENSION SETON NORTHWEST 11113 RESEARCH BOULEVARD AUSTIN TX 78759 TRAVIS (512) 324-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4048200 -97.7450100 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-qudt_ghtb~xy35 450867 660331 2019-11-25 2019-06-30 77 16       13 106               106
4678 TYLER COUNTY HOSPITAL 1100 WEST BLUFF WOODVILLE TX 75979 TYLER (409) 283-8141 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.7752870 -94.4282200 0   457 48 48457         https://data.medicare.gov/resource/xubh-q36u/row-xfu9.wq3c~xr3i 450460 660053 2019-11-25 2019-06-30 25           25               25
4702 SETON MEDICAL CENTER WILLIAMSON 201 SETON PARKWAY ROUND ROCK TX 78664 WILLIAMSON (512) 324-0000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.5679440 -97.6527840 0   491 48 48491 12420   Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-rfq6_5szx.kb6y 670041 659749 2019-11-25 2019-06-30 93 26         119               119
4756 MEDICAL COLLEGE OF VIRGINIA HOSPITALS BOX 980510 1250 EAST MARSHALL STREET RICHMOND VA 23298 RICHMOND CITY (804) 828-0938 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.5400695 -77.4299163 1 ROOFTOP 760 51 51760 40060   Central Richmond city https://data.medicare.gov/resource/xubh-q36u/row-p6wh~7aeu~ic6q 490032 659745 2019-11-25 2019-06-30 502 28 14 16 28   715 28 38           781

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