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

325 rows where "filed_date" is on date 2019-06-03 sorted by hospital_ownership

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, coronary_beds, burn_beds, oth_spec_beds, subprovider_oth_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-06-03 · 325 ✖
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
257 257 PAGE HOSPITAL 501 NORTH NAVAJO DRIVE PAGE AZ 86040 COCONINO (928) 645-2424 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.9169600 -111.4631860 0   5 4 4005 22380   Central Coconino County https://data.medicare.gov/resource/xubh-q36u/row-pwtm.vez8_t2h2 31304 649070 2019-06-03 2018-12-31 25           25               25
328 328 TRIOS 900 SOUTH AUBURN STREET KENNEWICK WA 99336 BENTON (509) 586-6111 Acute Care Hospitals Government - Hospital District or Authority TRUE 46.1988750 -119.1184630 0   5 53 53005 28420   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-hs4k~gp5j~yv74 500053 651430 2019-06-03 2018-12-31 87 14       10 111               111
397 397 LAKE CHELAN COMMUNITY HOSPITAL 503 EAST HIGHLAND CHELAN WA 98816 CHELAN (509) 682-3300 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.8451390 -120.0105110 0   7 53 53007 48300   Central Chelan County https://data.medicare.gov/resource/xubh-q36u/row-a77p~uq78~jh3e 501334 651089 2019-06-03 2018-12-31 25           25               25
552 552 BANNER THUNDERBIRD MEDICAL CENTER 5555 WEST THUNDERBIRD ROAD GLENDALE AZ 85306 MARICOPA (602) 865-4470 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.6107310 -112.1786980 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-fmq8_nzm3.7bhy 30089 649065 2019-06-03 2018-12-31 407 40 18       499 56             555
674 674 SUTTER COAST HOSPITAL 800 E WASHINGTON BLVD CRESCENT CITY CA 95531 DEL NORTE (707) 464-8880 Acute Care Hospitals Government - Hospital District or Authority TRUE 41.7726980 -124.1941440 0   15 6 6015 18860   Central Del Norte County https://data.medicare.gov/resource/xubh-q36u/row-m7v2.npcd-rkyf 50417 650951 2019-06-03 2018-12-31 33 6         39   10           49
828 828 WEST CALCASIEU CAMERON HOSPITAL 701 EAST CYPRESS STREET SULPHUR LA 70663 CALCASIEU (337) 527-7034 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.2310740 -93.3692900 0   19 22 22019 29340   Central Calcasieu Parish https://data.medicare.gov/resource/xubh-q36u/row-swji~irkf_eud2 190013 650585 2019-06-03 2018-12-31 95 12         107               107
1034 1034 CIMARRON MEMORIAL HOSPITAL 100 SOUTH ELLIS BOISE CITY OK 73933 CIMARRON (580) 544-2501 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.7290550 -102.5175370 0   25 40 40025         https://data.medicare.gov/resource/xubh-q36u/row-9zte.pc9m_addj 371307 650201 2019-06-03 2018-12-31 25           25               25
1042 1042 KANE COUNTY HOSPITAL 355 NORTH MAIN STREET KANAB UT 84741 KANE (435) 644-5811 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.0543240 -112.5285900 0   25 49 49025         https://data.medicare.gov/resource/xubh-q36u/row-g8j5_itr8_6iiy 461309 649842 2019-06-03 2018-12-31 25           25               25
1047 1047 SAMARITAN HOSPITAL 801 EAST WHEELER ROAD MOSES LAKE WA 98837 GRANT (509) 765-5606 Acute Care Hospitals Government - Hospital District or Authority TRUE 47.1311150 -119.2647350 0   25 53 53025 34180 Moses Lake-Othello, WA Central Grant County https://data.medicare.gov/resource/xubh-q36u/row-6jdp_7427-cpfp 500033 659384 2019-06-03 2018-12-31 36 12         48               48
1363 1363 EVERGREENHEALTH MEDICAL CENTER 12040 NE 128TH STREET KIRKLAND WA 98034 KING (425) 899-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 47.7148720 -122.1785060 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-czqf-dh5d_37vj 500124 651252 2019-06-03 2018-12-31 241 20         304   14       15   333
1575 1575 KITTITAS VALLEY COMMUNITY HOSPITAL 603 SOUTH CHESTNUT ELLENSBURG WA 98926 KITTITAS (509) 962-9841 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.9876880 -120.5367610 0   37 53 53037 21260   Central Kittitas County https://data.medicare.gov/resource/xubh-q36u/row-c8za_geg7~y7ap 501333 651088 2019-06-03 2018-12-31 19 6         25           1   26
1622 1622 KLICKITAT VALLEY HOSPITAL 310 SOUTH ROOSEVELT GOLDENDALE WA 98620 KLICKITAT (509) 773-4022 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.8202390 -120.8122990 0   39 53 53039         https://data.medicare.gov/resource/xubh-q36u/row-hemh_kxtf-bs6t 501316 649846 2019-06-03 2018-12-31 14           14               14
2094 2094 ISLAND HOSPITAL 1211 24TH STREET ANACORTES WA 98221 SKAGIT (360) 299-1300 Acute Care Hospitals Government - Hospital District or Authority TRUE 48.5028830 -122.6158250 0   57 53 53057 34580 Seattle-Tacoma, WA Central Skagit County https://data.medicare.gov/resource/xubh-q36u/row-7mqw.zfgi.xhpw 500007 651429 2019-06-03 2018-12-31 37 6         43               43
2232 2232 EVERGREENHEALTH MONROE 14701 179TH SE MONROE WA 98272 SNOHOMISH (360) 794-7497 Acute Care Hospitals Government - Hospital District or Authority TRUE 47.8637270 -121.9906240 0   61 53 53061 42660 Seattle-Tacoma, WA Central Snohomish County https://data.medicare.gov/resource/xubh-q36u/row-usdb-25x2~srt8 500084 651085 2019-06-03 2018-12-31 23 4         27               27
2242 2242 KIT CARSON COUNTY MEMORIAL HOSPITAL 286 16TH ST BURLINGTON CO 80807 KIT CARSON (719) 346-5311 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.3023780 -102.2707110 0   63 8 8063         https://data.medicare.gov/resource/xubh-q36u/row-xqzu-2pvu-xrfj 61313 648525 2019-06-03 2018-12-31 19           19               19
2388 2388 ESTES PARK MEDICAL CENTER 555 PROSPECT AVE ESTES PARK CO 80517 LARIMER (970) 577-4470 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.3722590 -105.5140880 0   69 8 8069 22660   Central Larimer County https://data.medicare.gov/resource/xubh-q36u/row-3yeq~tw3h-6ggv 61312 649878 2019-06-03 2018-12-31 25           25       60   6   91
2395 2395 COFFEE REGIONAL MEDICAL CENTER, INC 1101 OCILLA ROAD DOUGLAS GA 31533 COFFEE (912) 383-5620 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.5095890 -82.8634600 0   69 13 13069 20060   Central Coffee County https://data.medicare.gov/resource/xubh-q36u/row-d473_ue4x.74tq 110089 652866 2019-06-03 2018-12-31 76 10         86               86
2848 2848 EAST MORGAN COUNTY HOSPITAL 2400 WEST EDISON STREET BRUSH CO 80723 MORGAN (970) 842-6222 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.2547380 -103.6491780 0   87 8 8087 22820   Central Morgan County https://data.medicare.gov/resource/xubh-q36u/row-33cv-duhz_he5u 61303 649171 2019-06-03 2018-12-31 25           25               25
3209 3209 WESTERN MISSOURI MEDICAL CENTER 403 BURKARTH ROAD WARRENSBURG MO 64093 JOHNSON (660) 747-2500 Acute Care Hospitals Government - Hospital District or Authority TRUE 38.7664740 -93.7237010 0   101 29 29101 47660 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-74d6_q73a.h7xv 260097 650167 2019-06-03 2018-12-31 46           46 12             58
3211 3211 OGALLALA COMMUNITY HOSPITAL 2601 NORTH SPRUCE ST OGALLALA NE 69153 KEITH (308) 284-4011 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.1501770 -101.7204470 0   101 31 31101         https://data.medicare.gov/resource/xubh-q36u/row-g68g~zk9i.gtc5 281355 650174 2019-06-03 2018-12-31 18           18               18
3555 3555 RIVERSIDE MEDICAL CENTER 1900 SOUTH MAIN ST FRANKLINTON LA 70438 WASHINGTON (985) 795-4431 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.8351320 -90.1519790 0   117 22 22117 14220 New Orleans-Metairie-Hammond, LA-MS Central Washington Parish https://data.medicare.gov/resource/xubh-q36u/row-biqu.ctdj-naqx 191313 649031 2019-06-03 2018-12-31 20 5         25               25
3594 3594 MEADE DISTRICT HOSPITAL 510 EAST CARTHAGE MEADE KS 67864 MEADE (620) 873-2141 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.2854900 -100.3342670 0   119 20 20119         https://data.medicare.gov/resource/xubh-q36u/row-9yc7~mw74.3m9f 171321 649590 2019-06-03 2018-12-31 20           20           45   65
3703 3703 WRAY COMMUNITY DISTRICT HOSPITAL 1017 WEST 7TH ST WRAY CO 80758 YUMA (970) 332-4811 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.0754050 -102.2346600 0   125 8 8125         https://data.medicare.gov/resource/xubh-q36u/row-jpdk~yrgm-qq54 61309 649710 2019-06-03 2018-12-31 16           16               16
4270 4270 WYANDOT MEMORIAL HOSPITAL 885 NORTH SANDUSKY AVENUE UPPER SANDUSKY OH 43351 WYANDOT (419) 294-4991 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.8418840 -83.2807200 0   175 39 39175         https://data.medicare.gov/resource/xubh-q36u/row-7m8m~3eqa_t4vr 361329 649655 2019-06-03 2018-12-31 19   5       24               24
4364 4364 SUMNER COUNTY HOSPITAL DISTRICT NO 1 601 SOUTH OSAGE STREET CALDWELL KS 67022 SUMNER (620) 845-6492 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.0262800 -97.6096160 0   191 20 20191 48620 Wichita-Arkansas City-Winfield, KS Outlying Sumner County https://data.medicare.gov/resource/xubh-q36u/row-9v8g_4uhf~am74 171329 649593 2019-06-03 2018-12-31 25           25               25
212 212 BERGEN NEW BRIDGE MEDICAL CENTER 230 EAST RIDGEWOOD AVE PARAMUS NJ 7652 BERGEN (201) 967-4000 Acute Care Hospitals Government - Local TRUE 40.9586020 -74.0621510 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-uajf_w5ak.e5wh 310058 651020 2019-06-03 2018-12-31 118 9         127 319     574       1020
691 691 SLEEPY EYE MUNICIPAL HOSPITAL 400 FOURTH AVENUE NORTHWEST SLEEPY EYE MN 56085 BROWN (507) 794-3571 Critical Access Hospitals Government - Local TRUE 44.2993190 -94.7273150 0   15 27 27015 35580 Mankato-New Ulm-North Mankato, MN Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-td5y_avnx_gs7p 241327 651011 2019-06-03 2018-12-31 16           16               16
882 882 PIGGOTT COMMUNITY HOSPITAL 216 EAST MAIN STREET PIGGOTT AR 72454 CLAY (870) 598-3881 Critical Access Hospitals Government - Local TRUE 36.3820190 -90.1884430 0   21 5 5021         https://data.medicare.gov/resource/xubh-q36u/row-73yu_ywme-uu8m 41330 649163 2019-06-03 2018-12-31 25           25               25
1069 1069 DAVIESS COMMUNITY HOSPITAL 1314 E WALNUT ST WASHINGTON IN 47501 DAVIESS (812) 254-2760 Acute Care Hospitals Government - Local TRUE 38.6586950 -87.1603190 0   27 18 18027 47780   Central Daviess County https://data.medicare.gov/resource/xubh-q36u/row-khjv_h54z-usqa 150061 649895 2019-06-03 2018-12-31 37 5         42 20 12           74
1072 1072 CLAY COUNTY MEDICAL CENTER 617 LIBERTY CLAY CENTER KS 67432 CLAY (785) 632-2144 Critical Access Hospitals Government - Local TRUE 39.3916810 -97.1241960 0   27 20 20027         https://data.medicare.gov/resource/xubh-q36u/row-5isq.mc8m-iybh 171371 650581 2019-06-03 2018-12-31 17           17               17
1136 1136 HIGHPOINT HEALTH 600 WILSON CREEK RD LAWRENCEBURG IN 47025 DEARBORN (812) 537-1010 Acute Care Hospitals Government - Local TRUE 39.1129220 -84.8839510 0   29 18 18029 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Outlying Dearborn County https://data.medicare.gov/resource/xubh-q36u/row-ngjg.xy9w~6uaw 150086 649567 2019-06-03 2018-12-31 78 8         86               86
1308 1308 PLATTE COUNTY MEMORIAL HOSPITAL 201 14TH STREET WHEATLAND WY 82201 PLATTE (307) 322-3636 Critical Access Hospitals Government - Local TRUE 42.0498100 -104.9602210 0   31 56 56031         https://data.medicare.gov/resource/xubh-q36u/row-xwas~nr7a-7yiz 531305 649858 2019-06-03 2018-12-31 25           25               25
1406 1406 ALTRU HOSPITAL 1200 S COLUMBIA RD GRAND FORKS ND 58201 GRAND FORKS (701) 780-5000 Acute Care Hospitals Government - Local TRUE 47.9105352 -97.0681107 1 ROOFTOP 35 38 38035 24220   Central Grand Forks County https://data.medicare.gov/resource/xubh-q36u/row-tfgh.9uft~bxhm 350019 650883 2019-06-03 2018-12-31 245 16     10   271   23           294
1588 1588 ELKHART GENERAL HOSPITAL 600 E BLVD ELKHART IN 46514 ELKHART (574) 294-2621 Acute Care Hospitals Government - Local TRUE 41.6787610 -85.9918330 0   39 18 18039 21140 South Bend-Elkhart-Mishawaka, IN-MI Central Elkhart County https://data.medicare.gov/resource/xubh-q36u/row-xq9p.barv.suqr 150018 649560 2019-06-03 2018-12-31 169 23         200 10 20           230
1719 1719 WASHAKIE MEDICAL CENTER 400 SOUTH 15TH STREET WORLAND WY 82401 WASHAKIE (307) 347-3221 Critical Access Hospitals Government - Local TRUE 44.0135560 -107.9484090 0   43 56 56043         https://data.medicare.gov/resource/xubh-q36u/row-wgjq-rwdt.3x58 531306 649859 2019-06-03 2018-12-31 18           18               18
2301 2301 HENRY COUNTY MEMORIAL HOSPITAL 1000 N 16TH ST NEW CASTLE IN 47362 HENRY (765) 521-0890 Acute Care Hospitals Government - Local TRUE 39.9424740 -85.3650100 0   65 18 18065 35220 Indianapolis-Carmel-Muncie, IN Central Henry County https://data.medicare.gov/resource/xubh-q36u/row-7hck_n6zg-4n7p 150030 649565 2019-06-03 2018-12-31 38 10         48               48
3099 3099 ESKENAZI HEALTH 720 ESKENAZI AVENUE INDIANAPOLIS IN 46202 MARION (317) 880-4818 Acute Care Hospitals Government - Local TRUE 39.7805300 -86.1734500 0   97 18 18097 26900 Indianapolis-Carmel-Muncie, IN Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-fv8t.e66e-c8mj 150024 649564 2019-06-03 2018-12-31 192 72   15     316 20             336
3274 3274 RIVER'S EDGE HOSPITAL & CLINIC 1900 NORTH SUNRISE DRIVE ST PETER MN 56082 NICOLLET (507) 934-7602 Critical Access Hospitals Government - Local TRUE 44.3478460 -93.9708750 0   103 27 27103 31860 Mankato-New Ulm-North Mankato, MN Central Nicollet County https://data.medicare.gov/resource/xubh-q36u/row-83di-yjvp_x3zt 241334 649780 2019-06-03 2018-12-31 17           17               17
3349 3349 WHEATLAND MEMORIAL HOSPITAL 530 3RD ST NW HARLOWTON MT 59036 WHEATLAND (406) 632-4351 Critical Access Hospitals Government - Local TRUE 46.4370010 -109.8405050 0   107 30 30107         https://data.medicare.gov/resource/xubh-q36u/row-ttwx.8piz~nq2c 271321 651017 2019-06-03 2018-12-31 25           25               25
3370 3370 LOGAN COUNTY HOSPITAL 211 CHERRY AVENUE OAKLEY KS 67748 LOGAN (785) 672-3211 Critical Access Hospitals Government - Local TRUE 39.1269150 -100.8622790 0   109 20 20109         https://data.medicare.gov/resource/xubh-q36u/row-wi6i-q2iz.xd59 171326 649592 2019-06-03 2018-12-31 25           25           45   70
3650 3650 MERRICK MEDICAL CENTER 1715 26TH ST CENTRAL CITY NE 68826 MERRICK (308) 946-3015 Critical Access Hospitals Government - Local TRUE 41.1066100 -98.0026520 0   121 31 31121 24260   Outlying Merrick County https://data.medicare.gov/resource/xubh-q36u/row-tf8v-t66v_jxv4 281328 649920 2019-06-03 2018-12-31 20           20               20
3726 3726 PAULDING COUNTY HOSPITAL 1035 WEST WAYNE ST. PAULDING OH 45879 PAULDING (419) 399-1103 Critical Access Hospitals Government - Local TRUE 41.1352900 -84.6004940 0   125 39 39125         https://data.medicare.gov/resource/xubh-q36u/row-2ara~5qbu_gakf 361300 649651 2019-06-03 2018-12-31 25           25               25
3888 3888 RUSH MEMORIAL HOSPITAL 1300 N MAIN ST RUSHVILLE IN 46173 RUSH (765) 932-7513 Critical Access Hospitals Government - Local TRUE 39.6214420 -85.4447920 0   139 18 18139         https://data.medicare.gov/resource/xubh-q36u/row-bit2.6ykr-x2sd 151304 649573 2019-06-03 2018-12-31 25           25               25
4083 4083 PEMISCOT COUNTY MEMORIAL HOSPITAL 946 EAST REED HAYTI MO 63851 PEMISCOT (573) 359-1372 Acute Care Hospitals Government - Local TRUE 36.2368550 -89.7399750 0   155 29 29155         https://data.medicare.gov/resource/xubh-q36u/row-r644.jfav_m4mz 260070 650166 2019-06-03 2018-12-31 42 7         49 52       66     167
4144 4144 PHELPS HEALTH 1000 W 10TH ST ROLLA MO 65401 PHELPS (573) 458-8899 Acute Care Hospitals Government - Local TRUE 37.9514420 -91.7849930 0   161 29 29161 40620   Central Phelps County https://data.medicare.gov/resource/xubh-q36u/row-peg4_q7re-c685 260017 649918 2019-06-03 2018-12-31 154 18         172 20 30   20       242
4227 4227 WOOSTER COMMUNITY HOSPITAL 1761 BEALL AVENUE WOOSTER OH 44691 WAYNE (330) 263-8100 Acute Care Hospitals Government - Local TRUE 40.8207130 -81.9342470 0   169 39 39169 49300   Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-bh63_heg3-ryxh 360036 649308 2019-06-03 2018-12-31 90 14         104   10   22       136
4297 4297 GOODLAND REGIONAL MEDICAL CENTER 220 WEST SECOND STREET GOODLAND KS 67735 SHERMAN (785) 890-3625 Critical Access Hospitals Government - Local TRUE 39.3575900 -101.7132560 0   181 20 20181         https://data.medicare.gov/resource/xubh-q36u/row-5axd_6ykz-azjm 171370 650580 2019-06-03 2018-12-31 21           21               21
4325 4325 STAFFORD COUNTY HOSPITAL 502 S BUCKEYE STAFFORD KS 67578 STAFFORD (620) 234-5221 Critical Access Hospitals Government - Local TRUE 37.9568590 -98.5961510 0   185 20 20185         https://data.medicare.gov/resource/xubh-q36u/row-e2nn-qquj.hgq6 171323 649591 2019-06-03 2018-12-31 25           25               25
4337 4337 STANTON COUNTY HOSPITAL 404 N CHESTNUT JOHNSON KS 67855 STANTON (620) 492-6250 Critical Access Hospitals Government - Local TRUE 37.5741650 -101.7494100 0   187 20 20187         https://data.medicare.gov/resource/xubh-q36u/row-nbvv-b265_tdp8 171343 649594 2019-06-03 2018-12-31 16           16               16
4347 4347 STEVENS COUNTY HOSPITAL 1006 S JACKSON HUGOTON KS 67951 STEVENS (620) 544-8511 Critical Access Hospitals Government - Local TRUE 37.1708080 -101.3497550 0   189 20 20189         https://data.medicare.gov/resource/xubh-q36u/row-39kr.3u54-pmuw 171335 649737 2019-06-03 2018-12-31 17           17           83   100
4378 4378 TREGO COUNTY LEMKE MEMORIAL HOSPITAL 320 THIRTEENTH ST WA KEENEY KS 67672 TREGO (785) 743-2182 Critical Access Hospitals Government - Local TRUE 39.0272190 -99.8716200 0   195 20 20195         https://data.medicare.gov/resource/xubh-q36u/row-y4gc.24zy.c8cd 171355 649596 2019-06-03 2018-12-31 25           25           37   62
4405 4405 WASHINGTON COUNTY HOSPITAL 304 E 3RD STREET WASHINGTON KS 66968 WASHINGTON (785) 325-2211 Critical Access Hospitals Government - Local TRUE 39.8174780 -97.0455720 0   201 20 20201         https://data.medicare.gov/resource/xubh-q36u/row-hks4_sdgj_3m95 171351 649595 2019-06-03 2018-12-31 25           25               25
425 425 MAUI MEMORIAL MEDICAL CENTER 221 MAHALANI STREET WAILUKU HI 96793 MAUI (808) 442-5101 Acute Care Hospitals Government - State FALSE 20.8844550 -156.4880870 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-66fd~zrmp.8s5u 120002 649892 2019-06-03 2018-12-31 199 20         219               219
426 426 LANAI COMMUNITY HOSPITAL 628 7TH STREET LANAI CITY HI 96763 MAUI (808) 565-8450 Critical Access Hospitals Government - State TRUE 20.8267350 -156.9180020 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-keiy_dtd7_smny 121305 648608 2019-06-03 2018-12-31 4           4       10       14
427 427 KULA HOSPITAL 100 KEOKEA PLACE KULA HI 96790 MAUI (808) 878-1221 Critical Access Hospitals Government - State TRUE 20.7019940 -156.3570990 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-8svz_bunk-n2za 121308 648609 2019-06-03 2018-12-31 9           9       105       123
1804 1804 UNIVERSITY HOSPITAL OF BROOKLYN ( DOWNSTATE ) 445 LENOX ROAD BROOKLYN NY 11203 KINGS (718) 270-1000 Acute Care Hospitals Government - State TRUE 40.6544570 -73.9451600 0   47 36 36047 35620 New York-Newark, NY-NJ-CT-PA Central Kings County https://data.medicare.gov/resource/xubh-q36u/row-j3yr.94x8.z8x2 330350 651036 2019-06-03 2018-12-31 245 19 7     29 305   18           323
1881 1881 OCEAN BEACH HOSPITAL 174 FIRST AVENUE NORTH ILWACO WA 98624 PACIFIC (360) 642-3181 Critical Access Hospitals Government - State TRUE 46.3116960 -124.0433520 0   49 53 53049         https://data.medicare.gov/resource/xubh-q36u/row-6yj2-723x_f5cn 501314 649845 2019-06-03 2018-12-31 25           25               25
576 576 CORE INSTITUTE SPECIALTY HOSPITAL, THE 6501 NORTH 19TH AVENUE PHOENIX AZ 85015 MARICOPA (602) 795-6020 Acute Care Hospitals Physician FALSE 33.5318370 -112.0996140 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-ymwb.kuwb~xe6j 30108 659179 2019-06-03 2018-12-31 32           32               32
740 740 SPECIALISTS HOSPITAL SHREVEPORT 1500 LINE AVENUE SHREVEPORT LA 71101 CADDO (318) 213-3800 Acute Care Hospitals Physician FALSE 32.4969260 -93.7460460 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-kr9t-dd8q-wfhi 190278 649901 2019-06-03 2018-12-31 15           15               15
1305 1305 UNITY MEDICAL CENTER 481 INTERSTATE DRIVE MANCHESTER TN 37355 COFFEE (931) 728-6354 Acute Care Hospitals Physician TRUE 35.4979320 -86.0781410 0   31 47 47031 46100   Central Coffee County https://data.medicare.gov/resource/xubh-q36u/row-7ihq-cddj~pgik 440007 651231 2019-06-03 2018-12-31 49           49               49
2282 2282 MENIFEE GLOBAL MEDICAL CENTER 28400 MCCALL B0ULEVARD SUN CITY CA 92585 RIVERSIDE (951) 679-8888 Acute Care Hospitals Physician FALSE 33.7189772 -117.1681518 1 ROOFTOP 65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-rqjx-c4v4.2ewv 50684 651179 2019-06-03 2018-12-31 74 10         84               84
2285 2285 HEMET VALLEY MEDICAL CENTER 1117 EAST DEVONSHIRE HEMET CA 92543 RIVERSIDE (951) 652-2811 Acute Care Hospitals Physician TRUE 33.7512200 -116.9598590 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-nd99_qqgq_fexi 50390 650949 2019-06-03 2018-12-31 286 18         304       113       417
2532 2532 MONROE SURGICAL HOSPITAL 2408 BROADMOOR BLVD MONROE LA 71201 OUACHITA (318) 410-0002 Acute Care Hospitals Physician FALSE 32.5367710 -92.1022040 0   73 22 22073 33740 Monroe-Ruston-Bastrop, LA Central Ouachita Parish https://data.medicare.gov/resource/xubh-q36u/row-2viy_tht4-abuk 190245 650140 2019-06-03 2018-12-31 10           10               10
2624 2624 SURGICAL SPECIALTY CENTER AT COORDINATED HEALTH 1503 CEDAR CREST BOULEVARD ALLENTOWN PA 18104 LEHIGH (610) 871-9110 Acute Care Hospitals Physician FALSE 40.6121900 -75.5327500 0   77 42 42077 10900 New York-Newark, NY-NJ-CT-PA Central Lehigh County https://data.medicare.gov/resource/xubh-q36u/row-ecs5-8dzv.54i7 390321 650522 2019-06-03 2018-12-31 20           20       12       32
3066 3066 COORDINATED HEALTH ORTHOPEDIC HOSPITAL 2310 HIGHLAND AVENUE BETHLEHEM PA 18017 NORTHAMPTON (610) 691-4300 Acute Care Hospitals Physician FALSE 40.6737620 -75.3654010 0   95 42 42095 10900 New York-Newark, NY-NJ-CT-PA Central Northampton County https://data.medicare.gov/resource/xubh-q36u/row-sc4k-g4c8.mwqt 390314 651057 2019-06-03 2018-12-31 20           20               20
3191 3191 SUTTER SURGICAL HOSPITAL - NORTH VALLEY 455 PLUMAS BLVD YUBA CITY CA 95991 SUTTER (530) 749-5700 Acute Care Hospitals Physician FALSE 39.1321670 -121.6136030 0   101 6 6101 49700 Sacramento-Roseville, CA Central Sutter County https://data.medicare.gov/resource/xubh-q36u/row-rm5f.jnvd.d3k4 50766 651185 2019-06-03 2018-12-31 14           14               14
3401 3401 OKLAHOMA SPINE HOSPITAL 14101 PARKWAY COMMONS DRIVE OKLAHOMA CITY OK 73134 OKLAHOMA (405) 749-2700 Acute Care Hospitals Physician TRUE 35.6141370 -97.5821240 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-g6tz_y8sg_qryk 370206 648756 2019-06-03 2018-12-31 23           23               23
4475 4475 DOCTORS HOSPITAL AT RENAISSANCE 5501 SOUTH MCCOLL EDINBURG TX 78539 HIDALGO (956) 362-8677 Acute Care Hospitals Physician TRUE 26.2524240 -98.2041090 0   215 48 48215 32580 McAllen-Edinburg, TX Central Hidalgo County https://data.medicare.gov/resource/xubh-q36u/row-ie54-gr3x-shm2 450869 649837 2019-06-03 2018-12-31 287 58         394 87 38           519
4625 4625 BAYLOR SCOTT & WHITE TEXAS SPINE & JOINT HOSPITAL 1814 ROSELAND BOULEVARD TYLER TX 75701 SMITH (903) 525-3300 Acute Care Hospitals Physician TRUE 32.3292480 -95.2994670 0   423 48 48423 46340 Tyler-Jacksonville, TX Central Smith County https://data.medicare.gov/resource/xubh-q36u/row-id2a~8wab-iya8 450864 649358 2019-06-03 2018-12-31 20           20               20
168 168 THE ORTHOPAEDIC HOSPITAL OF LUTHERAN HEALTH NETWOR 7952 W JEFFERSON BLVD FORT WAYNE IN 46804 ALLEN (260) 435-2999 Acute Care Hospitals Proprietary FALSE 41.0373520 -85.2459180 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-65sn_hsdz_dbbf 150168 649728 2019-06-03 2018-12-31 39           39               39
221 221 INSTITUTE FOR ORTHOPAEDIC SURGERY 801 MEDICAL DRIVE, SUITE B LIMA OH 45804 ALLEN (419) 224-7586 Acute Care Hospitals Proprietary FALSE 40.6985860 -84.0864770 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-kbua_iifb.k5nj 360263 649649 2019-06-03 2018-12-31 12           12               12
394 394 CASTLEVIEW HOSPITAL 300 NORTH HOSPITAL DRIVE PRICE UT 84501 CARBON (435) 637-4800 Acute Care Hospitals Proprietary TRUE 39.6054020 -110.8319110 0   7 49 49007 39220   Central Carbon County https://data.medicare.gov/resource/xubh-q36u/row-z6mk.zxuw_qeet 460011 651250 2019-06-03 2018-12-31 33 6         39               39
456 456 OLEAN GENERAL HOSPITAL 515 MAIN STREET OLEAN NY 14760 CATTARAUGUS (716) 373-2600 Acute Care Hospitals Proprietary TRUE 42.0894480 -78.4269770 0   9 36 36009 36460 Buffalo-Cheektowaga, NY Central Cattaraugus County https://data.medicare.gov/resource/xubh-q36u/row-hkii~eckc~6rgh 330103 650862 2019-06-03 2018-12-31 260           260 14     293       567
575 575 DIGNITY HEALTH - ARIZONA GENERAL HOSPITAL 7171 SOUTH 51ST AVENUE LAVEEN AZ 85339 MARICOPA (623) 584-5100 Acute Care Hospitals Proprietary FALSE 33.3806770 -112.1682330 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-6h9g-s46a~aiyi 30136 651169 2019-06-03 2018-12-31 16           16               16
607 607 BIENVILLE MEDICAL CENTER 1175 PINE STREET ARCADIA LA 71001 BIENVILLE (318) 263-4700 Critical Access Hospitals Proprietary TRUE 32.5530850 -92.9157770 0   13 22 22013         https://data.medicare.gov/resource/xubh-q36u/row-ui8b~9pic.2t2z 191320 650142 2019-06-03 2018-12-31 21           21               21
620 620 GREAT FALLS CLINIC HOSPITAL 3010 15TH AVENUE SOUTH GREAT FALLS MT 59405 CASCADE (406) 216-8000 Acute Care Hospitals Proprietary TRUE 47.4877370 -111.2545610 0   13 30 30013 24500   Central Cascade County https://data.medicare.gov/resource/xubh-q36u/row-zzvw_fvcf~g44t 270086 651217 2019-06-03 2018-12-31 20           20               20
662 662 SAGEWEST HEALTH CARE 2100 W SUNSET DR RIVERTON WY 82501 FREMONT (307) 856-4161 Acute Care Hospitals Proprietary TRUE 43.0336670 -108.4186540 0   13 56 56013 40180   Central Fremont County https://data.medicare.gov/resource/xubh-q36u/row-8cgp~ktku_un2q 530008 652129 2019-06-03 2018-12-31 121 12         133 13 8           154
679 679 BAYFRONT HEALTH PORT CHARLOTTE 2500 HARBOR BLVD PORT CHARLOTTE FL 33952 CHARLOTTE (941) 766-4122 Acute Care Hospitals Proprietary TRUE 26.9898400 -82.0966820 0   15 12 12015 39460 North Port-Sarasota, FL Central Charlotte County https://data.medicare.gov/resource/xubh-q36u/row-hxde-mw35~h46w 100077 649183 2019-06-03 2018-12-31 225 22         254               254
682 682 KANSAS MEDICAL CENTER LLC 1124 WEST 21ST STREET ANDOVER KS 67002 BUTLER (316) 300-4000 Acute Care Hospitals Proprietary TRUE 37.7232400 -97.1464800 0   15 20 20015 48620 Wichita-Arkansas City-Winfield, KS Outlying Butler County https://data.medicare.gov/resource/xubh-q36u/row-nnyh-wp4p~qnyp 170197 649587 2019-06-03 2018-12-31 45 10         55               55
785 785 ROTHMAN ORTHOPAEDIC SPECIALTY HOSPITAL LLC 3300 TILLMAN DRIVE BENSALEM PA 19020 BUCKS (215) 244-7400 Acute Care Hospitals Proprietary FALSE 40.1143500 -74.9620930 0   17 42 42017 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Bucks County https://data.medicare.gov/resource/xubh-q36u/row-w5gs-9pze-8zau 390322 649490 2019-06-03 2018-12-31 24           24               24
989 989 JACKSON MEDICAL CENTER 220 HOSPITAL DRIVE JACKSON AL 36545 CLARKE (251) 246-9021 Acute Care Hospitals Proprietary TRUE 31.5304820 -87.8931800 0   25 1 1025         https://data.medicare.gov/resource/xubh-q36u/row-p276~rdhi_nmej 10128 651157 2019-06-03 2018-12-31 35           35               35
1130 1130 BAKERSFIELD HEART HOSPITAL 3001 SILLECT AVENUE BAKERSFIELD CA 93308 KERN (661) 316-6000 Acute Care Hospitals Proprietary TRUE 35.3861060 -119.0408470 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-e89i~sm2j_vijv 50724 651182 2019-06-03 2018-12-31 47           47               47
1190 1190 FOUNDATION SURGICAL HOSPITAL OF SAN ANTONIO 9522 HUEBNER ROAD SAN ANTONIO TX 78240 BEXAR (210) 478-5400 Acute Care Hospitals Proprietary TRUE 29.5310350 -98.5925540 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-pvs4~yydr-y7qv 670054 649387 2019-06-03 2018-12-31 20           20               20
1377 1377 EVERGREEN MEDICAL CENTER 101 CRESTVIEW AVENUE EVERGREEN AL 36401 CONECUH (251) 578-2480 Acute Care Hospitals Proprietary TRUE 31.4312600 -86.9420500 0   35 1 1035         https://data.medicare.gov/resource/xubh-q36u/row-f8ut-az4v~dn63 10148 651159 2019-06-03 2018-12-31 44           44               44
1420 1420 UHHS RICHMOND HEIGHTS HOSPITAL 27100 CHARDON ROAD RICHMOND HEIGHTS OH 44143 CUYAHOGA (440) 585-6170 Acute Care Hospitals Proprietary TRUE 41.5810430 -81.4902720 0   35 39 39035 17460 Cleveland-Akron-Canton, OH Central Cuyahoga County https://data.medicare.gov/resource/xubh-q36u/row-rvfd.96ei_5i7w 360075 649315 2019-06-03 2018-12-31 84 17         101               101
1469 1469 PACIFICA HOSPITAL OF THE VALLEY 9449 SAN FERNANDO RD SUN VALLEY CA 91352 LOS ANGELES (818) 767-3310 Acute Care Hospitals Proprietary TRUE 34.2411340 -118.3956690 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-dhg6-n9an_6w25 50378 650948 2019-06-03 2018-12-31 126   7       133       98       231
1472 1472 COLLEGE MEDICAL CENTER 2776 PACIFIC AVENUE LONG BEACH CA 90806 LOS ANGELES (562) 595-1911 Acute Care Hospitals Proprietary TRUE 33.8072010 -118.1937210 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-sybg_fugk_i72x 50776 650806 2019-06-03 2018-12-31 213 8         221               221
1530 1530 OLYMPIA MEDICAL CENTER 5900 WEST OLYMPIC BOULEVARD LOS ANGELES CA 90036 LOS ANGELES (310) 657-5900 Acute Care Hospitals Proprietary FALSE 34.0575270 -118.3598570 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-h6xu_zz9e_g4g4 50742 649703 2019-06-03 2018-12-31 192   12       204               204
1863 1863 WOODS AT PARKSIDE,THE 349 OLDE RIDENOUR ROAD COLUMBUS OH 43230 FRANKLIN (614) 471-2552 Acute Care Hospitals Proprietary FALSE 40.0268200 -82.8811560 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-4avu~kmf5~3quj 360247 649648 2019-06-03 2018-12-31 12         38 50               50
1905 1905 OMEGA HOSPITAL, LLC 2525 SEVERN AVENUE METAIRIE LA 70002 JEFFERSON (504) 849-4900 Acute Care Hospitals Proprietary FALSE 29.9991620 -90.1595830 0   51 22 22051 35380 New Orleans-Metairie-Hammond, LA-MS Central Jefferson Parish https://data.medicare.gov/resource/xubh-q36u/row-fybn~uix6_hmgd 190302 649030 2019-06-03 2018-12-31 16           16               16
1910 1910 SSM HEALTH ST. MARY'S HOSPITAL - JEFFERSON CITY 2505 MISSION DRIVE JEFFERSON CITY MO 65109 COLE (573) 681-3000 Acute Care Hospitals Proprietary TRUE 38.5601420 -92.2202850 0   51 29 29051 27620   Central Cole County https://data.medicare.gov/resource/xubh-q36u/row-gt2e.ahrn_f7q9 260011 649917 2019-06-03 2018-12-31 154 13         167               167
1999 1999 NORTHWEST SPECIALTY HOSPITAL 1593 EAST POLSTON AVENUE POST FALLS ID 83854 KOOTENAI (208) 262-2466 Acute Care Hospitals Proprietary FALSE 47.7144100 -116.9244550 0   55 16 16055 17660 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Central Kootenai County https://data.medicare.gov/resource/xubh-q36u/row-68rq_3jru~i59y 130066 649721 2019-06-03 2018-12-31 34           34               34
2039 2039 SOUTHERN TENNESSEE REGIONAL HEALTH SYSTEM PULASKI 1265 E COLLEGE ST PULASKI TN 38478 GILES (931) 363-7531 Acute Care Hospitals Proprietary TRUE 35.1912900 -87.0043220 0   55 47 47055         https://data.medicare.gov/resource/xubh-q36u/row-5e7x~i85y_dgtz 440020 651233 2019-06-03 2018-12-31 75 6         81 14             95
2123 2123 COLLEGE HOSPITAL COSTA MESA 301 VICTORIA STREET COSTA MESA CA 92627 ORANGE (949) 642-2734 Acute Care Hospitals Proprietary FALSE 33.6526050 -117.9119650 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-3tfg-v7t4-p88q 50543 651370 2019-06-03 2018-12-31 122           122               122
2950 2950 MINIMALLY INVASIVE SURGERY HOSPITAL 11217 LAKEVIEW AVENUE LENEXA KS 66219 JOHNSON (913) 322-7401 Acute Care Hospitals Proprietary FALSE 38.9243760 -94.7697050 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-jnfx.rz75-i6pf 170199 649588 2019-06-03 2018-12-31 7       2   9               9
2986 2986 NORTHWEST MEDICAL CENTER 1530 U S HIGHWAY 43 WINFIELD AL 35594 FAYETTE (205) 487-7736 Acute Care Hospitals Proprietary TRUE 33.9293160 -87.8245070 0   93 1 1093         https://data.medicare.gov/resource/xubh-q36u/row-r4dk-tpsz_u57n 10086 651153 2019-06-03 2018-12-31 57 4         61 10             71
3044 3044 NORTH MISSISSIPPI MEDICAL CENTER-GILMORE AMORY 1105 EARL FRYE BLVD AMORY MS 38821 MONROE (662) 256-7111 Acute Care Hospitals Proprietary TRUE 33.9775510 -88.4776250 0   95 28 28095         https://data.medicare.gov/resource/xubh-q36u/row-mseb-a3c5-hfq8 250025 649915 2019-06-03 2018-12-31 80 9       6 95               95
3088 3088 ST CLOUD REGIONAL MEDICAL CENTER 2906 17TH STREET SAINT CLOUD FL 34769 OSCEOLA (407) 498-3432 Acute Care Hospitals Proprietary TRUE 28.2424140 -81.3026580 0   97 12 12097 36740 Orlando-Deltona-Daytona Beach, FL Outlying Osceola County https://data.medicare.gov/resource/xubh-q36u/row-we5j.muyn.k764 100302 649887 2019-06-03 2018-12-31 76 8         84               84
3204 3204 TECHE REGIONAL MEDICAL CENTER 1125 MARGUERITE STREET MORGAN CITY LA 70380 ST. MARY (985) 384-2200 Acute Care Hospitals Proprietary TRUE 29.7084710 -91.2001570 0   101 22 22101 34020 Lafayette-Opelousas-Morgan City, LA Central St. Mary Parish https://data.medicare.gov/resource/xubh-q36u/row-niny~u25y.qjmy 190014 650586 2019-06-03 2018-12-31 120 10         130 17 10           157
3222 3222 ST CHRISTOPHER'S HOSPITAL FOR CHILDREN 160 EAST ERIE AVE PHILADELPHIA PA 19134 PHILADELPHIA (215) 427-5000 Childrens Proprietary TRUE 40.0074930 -75.1255350 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-z7p6.dkcr_rdax 393307 650206 2019-06-03 2018-12-31 115 44       29 188               188

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