hospital_data
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"
This data as json, copyable, CSV (advanced)
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 | 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 | 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 | ||||||||||||
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 | |||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | |||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | ||||||||||||||
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 | ||||||||||
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 | ||||||||||||||||
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 | ||||||||||||
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 | |||||||||||||
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 | |||||||||||
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 | ||||||||||||||||
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 | |||||||||||
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 | ||||||||||
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 | ||||||||||||
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 | |||||||||
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 | |||||||||||||
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 | ||||||||||
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 | ||||||||||
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 | ||||||||||
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 | |||||||||||
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 | ||||||||||
4064 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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
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 );