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

1,122 rows where centraloutlyingcounty = "" sorted by fy_end_date

View and edit SQL

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, fy_end_date, icu_beds, coronary_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, nursing_fac_beds, filed_date (date), fy_end_date (date)

centraloutlyingcounty

  • - · 1,122
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
476 LBJ TROPICAL MEDICAL CENTER FAGAALU VILLAGE PAGO PAGO AS 96799 EASTERN DISTRICT (684) 633-4590 Acute Care Hospitals Government - Hospital District or Authority TRUE -14.2900610 -170.6847054 1 APPROXIMATE 10 60 60010         https://data.medicare.gov/resource/xubh-q36u/row-6iv4.yudm-sdek                                      
2922 MCCURTAIN MEMORIAL HOSPITAL 1301 LINCOLN ROAD IDABEL OK 74745 MCCURTAIN (580) 286-7623 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.8827686 -94.8112299 1 ROOFTOP 89 40 40089         https://data.medicare.gov/resource/xubh-q36u/row-pgd6-5hq6_fe4r                                      
3599 QUITMAN COUNTY HOSPITAL CAH 340 GETWELL DRIVE MARKS MS 38646 QUITMAN (662) 326-8031 Critical Access Hospitals Proprietary TRUE 34.2474640 -90.2770590 0   119 28 28119         https://data.medicare.gov/resource/xubh-q36u/row-94fq~mrkf~464e                                      
4374 HAMILTON GENERAL HOSPITAL 400 N BROWN, BUILDING 1 HAMILTON TX 76531 HAMILTON (254) 386-3151 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.7038520 -98.1134620 0   193 48 48193         https://data.medicare.gov/resource/xubh-q36u/row-u9ir-x2hd-6nbs                                      
4493 CROCKETT MEDICAL CENTER 1100 E LOOP 304 CROCKETT TX 75835 HOUSTON (936) 546-3890 Critical Access Hospitals Proprietary TRUE 31.3236990 -95.4372570 0   225 48 48225         https://data.medicare.gov/resource/xubh-q36u/row-2gki~micg.zrhe                                      
4683 TEXAS GENERAL HOSPITAL- VZRMC LP 707 N WALDRIP ST GRAND SALINE TX 75140 VAN ZANDT (903) 962-5200 Acute Care Hospitals Proprietary TRUE 32.6791930 -95.7217370 0   467 48 48467         https://data.medicare.gov/resource/xubh-q36u/row-6c8j-ja3g-2qcb                                      
4579 LITTLE RIVER HEALTHCARE 1700 BRAZOS ROCKDALE TX 76567 MILAM (512) 446-4500 Critical Access Hospitals Proprietary TRUE 30.6503240 -97.0201050 0   331 48 48331         https://data.medicare.gov/resource/xubh-q36u/row-afvn-5pmv_graz 451357 630239 2018-06-01 2017-12-31 25           25               25
15 GARRISON MEMORIAL HOSPITAL 407 3RD AVE SE GARRISON ND 58540 MCLEAN (701) 463-2275 Critical Access Hospitals Voluntary non-profit - Church TRUE 47.6483420 -101.4113010 0   55 38 38055         https://data.medicare.gov/resource/xubh-q36u/row-e4ej.ybr6_ritz 351303 640250 2018-12-03 2018-06-30 22           22       28       50
18 HOUSTON COUNTY COMMUNITY HOSPITAL 5001 EAST MAIN STREET ERIN TN 37061 HOUSTON (931) 289-4211 Critical Access Hospitals Government - Local TRUE 36.3195160 -87.6891930 0   83 47 47083         https://data.medicare.gov/resource/xubh-q36u/row-dt3z.s9ya.age2 441322 639931 2018-12-03 2018-06-30 25           25               25
147 BIG HORN HOSPITAL 17 N MILES HARDIN MT 59034 BIG HORN (406) 665-2310 Critical Access Hospitals Government - Local TRUE 45.7288560 -107.6170100 0   3 30 30003         https://data.medicare.gov/resource/xubh-q36u/row-2cgz.f5s8-gu8f 271338 652087 2018-11-27 2018-06-30 25           25               25
509 ASCENSION STANDISH HOSPITAL 805 W CEDAR ST STANDISH MI 48658 ARENAC (517) 846-4521 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.9828300 -83.9693520 0   11 26 26011         https://data.medicare.gov/resource/xubh-q36u/row-3a56-bznt.bz29 231305 639965 2018-12-12 2018-06-30 20 5         25       29       54
545 CROOK COUNTY HOSPITAL 713 OAK STREET SUNDANCE WY 82729 CROOK (307) 283-3501 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.4088300 -104.3735960 0   11 56 56011         https://data.medicare.gov/resource/xubh-q36u/row-ikyx-7gnq-abzi 531311 640303 2018-12-04 2018-06-30 16           16       32       48
655 UINTAH BASIN MEDICAL CENTER 250 WEST 300 NORTH ROOSEVELT UT 84066 DUCHESNE (435) 722-4691 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.3027550 -109.9970860 0   13 49 49013         https://data.medicare.gov/resource/xubh-q36u/row-qmgd.dczn~ghmv 460019 658598 2019-01-10 2018-06-30 31 4         35               35
763 GROVER C DILS MEDICAL CENTER 700 N SPRING ST, BOX 1010-C-ADM BLDG CALIENTE NV 89008 LINCOLN (775) 726-3171 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.6222810 -114.5118240 0   17 32 32017         https://data.medicare.gov/resource/xubh-q36u/row-5bun~jms2_227p 291312 654895 2018-12-03 2018-06-30 4           4       16       20
798 HOT SPRINGS COUNTY MEMORIAL HOSPITAL 150 EAST ARAPAHOE THERMOPOLIS WY 82443 HOT SPRINGS (307) 864-3121 Critical Access Hospitals Government - Local TRUE 43.6474320 -108.1995900 0   17 56 56017         https://data.medicare.gov/resource/xubh-q36u/row-ktb5~jtkf~b2ae 531304 640300 2018-11-30 2018-06-30 25           25               25
851 CAVALIER COUNTY MEMORIAL HOSPITAL ASSOCIATION 909 2ND ST LANGDON ND 58249 CAVALIER (701) 256-6100 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.7612430 -98.3666610 0   19 38 38019         https://data.medicare.gov/resource/xubh-q36u/row-m8nv.tvsx-unkm 351323 638003 2018-11-28 2018-06-30 20           20               20
912 GLENDIVE MEDICAL CENTER 202 PROSPECT DR GLENDIVE MT 59330 DAWSON (406) 345-3306 Critical Access Hospitals Voluntary non-profit - Other TRUE 47.1172260 -104.7049530 0   21 30 30021         https://data.medicare.gov/resource/xubh-q36u/row-x469.qqvr~n68h 271332 642881 2019-02-07 2018-06-30 22 3         25       56       81
914 MOUNT GRANT GENERAL HOSPITAL 200 SOUTH A ST HAWTHORNE NV 89415 MINERAL (702) 945-2461 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.5166320 -118.6284520 0   21 32 32021         https://data.medicare.gov/resource/xubh-q36u/row-dzph~qsgj~bgaf 291300 652888 2018-12-04 2018-06-30 11           11       24       35
974 ST LUKE'S HOSPITAL 702 1ST ST SW CROSBY ND 58730 DIVIDE (701) 965-6384 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.9067080 -103.2982300 0   23 38 38023         https://data.medicare.gov/resource/xubh-q36u/row-pn67~uvq9.k3y8 351325 638546 2018-11-26 2018-06-30 15           15       40       55
1120 NIOBRARA HEALTH & LIFE CENTER 921 SOUTH BALLANCEE AVENUE LUSK WY 82225 NIOBRARA (307) 334-4000 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.7532780 -104.4460830 0   27 56 56027         https://data.medicare.gov/resource/xubh-q36u/row-ee9k~358g.gwyk 531314 640304 2018-12-03 2018-06-30 24           24               24
1195 CODY REGIONAL HEALTH 707 SHERIDAN AVENUE CODY WY 82414 PARK (307) 578-2488 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.5260710 -109.0735760 0   29 56 56029         https://data.medicare.gov/resource/xubh-q36u/row-hbhj.vs4q~3zsw 531312 638925 2018-12-03 2018-06-30 21 4         25       94       119
1560 LAKE DISTRICT HOSPITAL 700 SOUTH J STREET LAKEVIEW OR 97630 LAKE (541) 947-2114 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.1815830 -120.3514370 0   37 41 41037         https://data.medicare.gov/resource/xubh-q36u/row-2rpx~hmxp~n924 381309 640591 2018-12-10 2018-06-30 24           24               24
1595 GRANITE COUNTY MEDICAL CENTER 310 SANSOME ST PHILIPSBURG MT 59858 GRANITE (406) 859-3271 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.3327550 -113.2942070 0   39 30 30039         https://data.medicare.gov/resource/xubh-q36u/row-wazi~b6n6_xzju 271303 640231 2018-12-03 2018-06-30 25           25               25
1770 WESTON COUNTY HEALTH SERVICES 1124 WASHINGTON BOULEVARD NEWCASTLE WY 82701 WESTON (307) 746-4491 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.8487470 -104.1887560 0   45 56 56045         https://data.medicare.gov/resource/xubh-q36u/row-jibn-3jkh~ba9g 531303 640299 2018-12-03 2018-06-30 12           12       58       70
1969 MCKENZIE COUNTY HEALTHCARE SYSTEMS INC 709 4TH AVE NE WATFORD CITY ND 58854 MCKENZIE (701) 842-3000 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.8046820 -103.2713580 0   53 38 38053         https://data.medicare.gov/resource/xubh-q36u/row-ph32.gcyn.yevx 351302 652530 2018-12-03 2018-06-30 24           24       47       71
2032 CHI ST ALEXIUS HEALTH TURTLE LAKE 220 5TH AVE W TURTLE LAKE ND 58575 MCLEAN (701) 448-2331 Critical Access Hospitals Voluntary non-profit - Church TRUE 47.5179250 -100.8944420 0   55 38 38055         https://data.medicare.gov/resource/xubh-q36u/row-w8fb-47fy-9nzg 351304 640251 2018-12-03 2018-06-30 25           25               25
2041 PEACEHEALTH PEACE ISLAND MEDICAL CENTER 1117 SPRING STREET FRIDAY HARBOR WA 98250 SAN JUAN (360) 378-2141 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.5298570 -123.0281710 0   55 53 53055         https://data.medicare.gov/resource/xubh-q36u/row-tq94~fpij_9q58 501340 640562 2018-11-30 2018-06-30 10           10               10
2241 PLUMAS DISTRICT HOSPITAL 1065 BUCKS LAKE ROAD QUINCY CA 95971 PLUMAS (530) 283-2121 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.9347670 -120.9192510 0   63 6 6063         https://data.medicare.gov/resource/xubh-q36u/row-k6tt~sk6g~887z 51326 640492 2018-12-13 2018-06-30 23           23               23
2265 NELSON COUNTY HEALTH SYSTEM 200 N MAIN ST MCVILLE ND 58254 NELSON (701) 322-4328 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.7656260 -98.1773140 0   63 38 38063         https://data.medicare.gov/resource/xubh-q36u/row-mxe5_p48x_qufq 351308 640252 2018-11-29 2018-06-30 19           19       39       58
2708 MARCUS DALY MEMORIAL HOSPITAL - CAH 1200 WESTWOOD DR HAMILTON MT 59840 RAVALLI (406) 375-4408 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.2471580 -114.1713650 0   81 30 30081         https://data.medicare.gov/resource/xubh-q36u/row-r262~sb7s_y9sk 271340 640517 2018-12-04 2018-06-30 20 5         25               31
3058 TOWNER COUNTY MEDICAL CENTER HWY 281 N CANDO ND 58324 TOWNER (701) 968-4411 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.4931522 -99.2110430 1 ROOFTOP 95 38 38095         https://data.medicare.gov/resource/xubh-q36u/row-8pd6_eppf-kx3r 351331 638004 2018-11-28 2018-06-30 20           20       30   5   55
3114 PIONEER MEDICAL CENTER 301 W 7TH AVE BIG TIMBER MT 59011 SWEET GRASS (406) 932-4603 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.8284800 -109.9524270 0   97 30 30097         https://data.medicare.gov/resource/xubh-q36u/row-y6u6-i6dq_6uh8 271313 639315 2018-12-03 2018-06-30 25           25               25
4204 HEGG MEMORIAL HEALTH CENTER 1202 21ST AVENUE ROCK VALLEY IA 51247 SIOUX (712) 476-8000 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.2016930 -96.2850860 0   167 19 19167         https://data.medicare.gov/resource/xubh-q36u/row-5p5r_j23k-rsrv 161336 639251 2018-12-03 2018-06-30 25           25           60   85
4484 SITKA COMMUNITY HOSPITAL 209 MOLLER DRIVE SITKA AK 99835 SITKA BOROUGH (907) 747-3241 Critical Access Hospitals Government - Local TRUE 57.0589920 -135.3459290 0   220 2 2220         https://data.medicare.gov/resource/xubh-q36u/row-asew~ba2y_nt2p 21303 638783 2018-12-03 2018-06-30 12           12       15       27
1654 CALLAWAY DISTRICT HOSPITAL P O BOX 100, 211 E KIMBALL CALLAWAY NE 68825 CUSTER (308) 836-2228 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.2909887 -99.9242095 1 ROOFTOP 41 31 31041         https://data.medicare.gov/resource/xubh-q36u/row-nfg8_ccxm-ja7t 281335 660412 2019-01-02 2018-07-31 12           12               12
4004 COMMUNITY MEDICAL CENTER, INC P O BOX 399, 3307 BARADA ST FALLS CITY NE 68355 RICHARDSON (402) 245-2428 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.0778770 -95.6075970 1 ROOFTOP 147 31 31147         https://data.medicare.gov/resource/xubh-q36u/row-xcna_pb8z-kjhc 281352 640654 2018-12-28 2018-07-31 24           24               24
4205 RUSSELL REGIONAL HOSPITAL 200 S MAIN STREET RUSSELL KS 67665 RUSSELL (785) 483-3131 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.8832620 -98.8598360 0   167 20 20167         https://data.medicare.gov/resource/xubh-q36u/row-jqcp-w49x~7w2h 171350 640712 2019-01-03 2018-07-31 19           19           22   41
4257 SWAIN COUNTY HOSPITAL 45 PLATEAU STREET BRYSON CITY NC 28713 SWAIN (828) 488-2155 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.4351230 -83.4446880 0   173 37 37173         https://data.medicare.gov/resource/xubh-q36u/row-xctq~5kw9.id78 341305 640115 2018-12-27 2018-07-31 24           24               24
4451 COON MEMORIAL HOSPITAL 1411 DENVER AVENUE DALHART TX 79022 DALLAM (806) 244-4571 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.0515690 -102.5219060 0   205 48 48205         https://data.medicare.gov/resource/xubh-q36u/row-8mcz-n3gr~ux5g 451331 646182 2019-03-19 2018-07-31 21           21               21
4510 SOUTHWEST GEORGIA REGIONAL MEDICAL CENTER 361 RANDOLPH STREET CUTHBERT GA 39840 RANDOLPH (229) 732-2181 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.7748230 -84.7936060 0   243 13 13243         https://data.medicare.gov/resource/xubh-q36u/row-9bkz.mqd7-hbvn 111300 641801 2019-01-02 2018-07-31 25           25       80       105
4601 UT HEALTH EAST TEXAS CARTHAGE HOSPITAL 409 COTTAGE RD CARTHAGE TX 75633 PANOLA (093) 693-3841 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.1671260 -94.3460390 0   365 48 48365         https://data.medicare.gov/resource/xubh-q36u/row-tyuw-zwkq.zq2r 450210 640322 2018-12-28 2018-07-31 42           42               42
78 APPLING HOSPITAL 163 E TOLLISON STREET BAXLEY GA 31513 APPLING (912) 367-9841 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.7687680 -82.3493510 0   1 13 13001         https://data.medicare.gov/resource/xubh-q36u/row-j4qq-twpw~u8jw 110071 658240 2019-03-29 2018-08-31 31 3         34 30     101       165
694 NIOBRARA VALLEY HOSPITAL P O BOX 118, 401 SOUTH 5TH STREET LYNCH NE 68746 BOYD (402) 569-2451 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.8245631 -98.4684820 1 ROOFTOP 15 31 31015         https://data.medicare.gov/resource/xubh-q36u/row-34qy.5xrg_j9e4 281303 658942 2018-11-19 2018-08-31 20           20               20
1000 KENTUCKY RIVER MEDICAL CENTER 540 JETT DRIVE JACKSON KY 41339 BREATHITT (606) 666-6000 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.5654340 -83.3701110 0   25 21 21025         https://data.medicare.gov/resource/xubh-q36u/row-ewjp.xkmp_edhx 180139 657105 2019-08-21 2018-08-31 45 4         49               49
2105 THOMAS H BOYD MEMORIAL HOSPITAL 800 SCHOOL ST CARROLLTON IL 62016 GREENE (217) 942-6946 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.2961700 -90.4123030 0   61 17 17061         https://data.medicare.gov/resource/xubh-q36u/row-vab7-2ww3-xwdi 141300 642094 2019-01-30 2018-08-31 25           25               25
2567 REGIONAL GENERAL HOSPITAL WILLISTON 125 SW 7TH ST WILLISTON FL 32696 LEVY (352) 528-2801 Acute Care Hospitals Proprietary TRUE 29.3843540 -82.4557930 0   75 12 12075         https://data.medicare.gov/resource/xubh-q36u/row-tm6t.5fgm.s5u5 100322 642986 2019-02-04 2018-08-31 20           20               20
3294 RAPPAHANNOCK GENERAL HOSPITAL 101 HARRIS ROAD KILMARNOCK VA 22482 LANCASTER (804) 435-8000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.7002900 -76.3897780 0   103 51 51103         https://data.medicare.gov/resource/xubh-q36u/row-ft5v.4v76~xrcw 491308 642300 2019-01-31 2018-08-31 25           25 10             35
3362 MARSHFIELD MEDICAL CENTER - LADYSMITH 900 COLLEGE AVE WEST LADYSMITH WI 54848 RUSK (715) 532-5561 Critical Access Hospitals Government - Local TRUE 45.4556050 -91.1111300 0   107 55 55107         https://data.medicare.gov/resource/xubh-q36u/row-bp7n_sbwx-c86k 521328 642554 2019-02-05 2018-08-31 21 4         25               25
4148 FREESTONE MEDICAL CENTER 125 NEWMAN ST FAIRFIELD TX 75840 FREESTONE (903) 389-1612 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.7256440 -96.1696100 0   161 48 48161         https://data.medicare.gov/resource/xubh-q36u/row-7ffj_67x5_e9my 450658 657537 2019-01-31 2018-08-31 37           37               37
4487 WASHINGTON COUNTY MEMORIAL HOSPITAL 300 HEALTH WAY POTOSI MO 63664 WASHINGTON (573) 438-5451 Critical Access Hospitals Government - Local TRUE 37.9259900 -90.7731330 0   221 29 29221         https://data.medicare.gov/resource/xubh-q36u/row-f9yf_fkru~8ynh 261308 643043 2019-01-29 2018-08-31 25           25               25
4557 BAYLOR SCOTT & WHITE MEDICAL CENTER - LLANO 200 W OLLIE LLANO TX 78643 LLANO (325) 247-5040 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.7433450 -98.6779960 0   299 48 48299         https://data.medicare.gov/resource/xubh-q36u/row-f5ig_zcze-hhqw 450219 657514 2019-03-04 2018-08-31 25           25               25
4558 WASHINGTON COUNTY REGIONAL MEDICAL CENTER 610 SPARTA ROAD SANDERSVILLE GA 31082 WASHINGTON (478) 240-2100 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.9968170 -82.8050420 0   303 13 13303         https://data.medicare.gov/resource/xubh-q36u/row-2tqu-phgw~rfp2 110086 658248 2019-02-01 2018-08-31 56           56       60       116
1 ASHLEY COUNTY MEDICAL CENTER 1015 UNITY ROAD CROSSETT AR 71635 ASHLEY (870) 364-4111 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.1372060 -91.9387800 0   3 5 5003         https://data.medicare.gov/resource/xubh-q36u/row-gq3d.ak25_8qvw 41323 642385 2019-01-15 2018-09-30 19 6         25 10             35
2 HUGGINS HOSPITAL 240 SOUTH MAIN STREET WOLFEBORO NH 3894 CARROLL (603) 569-7500 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.5809440 -71.2015750 0   3 33 33003         https://data.medicare.gov/resource/xubh-q36u/row-u6j2-zv25.9ghd 301312 659991 2019-11-25 2018-09-30 21 4         25               25
4 SGMC BERRIEN CAMPUS 1221 E MCPHERSON AVENUE NASHVILLE GA 31639 BERRIEN (229) 543-7100 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.2036290 -83.2383370 0   19 13 13019         https://data.medicare.gov/resource/xubh-q36u/row-nuhh.ufkh.cshr 110234 644717 2019-03-01 2018-09-30 51           51 12             63
11 CROSSRIDGE COMMUNITY HOSPITAL 310 SOUTH FALLS BOULEVARD WYNNE AR 72396 CROSS (870) 238-3300 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.2203530 -90.7874210 0   37 5 5037         https://data.medicare.gov/resource/xubh-q36u/row-9vam~w7bd~4ivg 41307 644210 2019-02-27 2018-09-30 15           15               15
24 ST ALOISIUS MEDICAL CENTER 325 E BREWSTER ST HARVEY ND 58341 WELLS (701) 324-4651 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.7676870 -99.9330890 0   103 38 38103         https://data.medicare.gov/resource/xubh-q36u/row-u657.4sxp.u7ix 351327 644053 2019-02-27 2018-09-30 25           25       91       116
38 FORT DEFIANCE INDIAN HOSPITAL PO BOX 649 FORT DEFIANCE AZ 86504 APACHE (928) 729-8000 Acute Care Hospitals Government - Federal TRUE 35.7593170 -109.0483992 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-ss8d_atq6.7xb3 30071 651311 2019-07-02 2018-09-30 56           56               56
39 SAGE MEMORIAL HOSPITAL STATE ROUTE 264 SOUTH 191 GANADO AZ 86505 APACHE (928) 755-4541 Critical Access Hospitals Voluntary non-profit - Private FALSE 35.7108602 -109.5423597 1 ROOFTOP 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-vmgp-erfi.puty 31309 652060 2019-05-06 2018-09-30 25           25               25
40 CHINLE COMPREHENSIVE HEALTH CARE FACILITY US HWY 191, HOSPITAL ROAD CHINLE AZ 86503 APACHE (928) 674-7001 Acute Care Hospitals Government - Federal TRUE 36.1575812 -109.6076963 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-u7kj_iqgg.38d9 30084 649393 2019-06-12 2018-09-30 60           60               60
90 T J HEALTH COLUMBIA 901 WESTLAKE DRIVE COLUMBIA KY 42728 ADAIR (270) 384-4753 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.0962890 -85.2949400 0   1 21 21001         https://data.medicare.gov/resource/xubh-q36u/row-7iis-x23i.zsak 180149 640382 2018-12-31 2018-09-30 49           49 20             69
98 RIVERWOOD HEALTHCARE CENTER 200 BUNKER HILL DRIVE AITKIN MN 56431 AITKIN (218) 927-5501 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.5292020 -93.6968080 0   1 27 27001         https://data.medicare.gov/resource/xubh-q36u/row-ybgp~gnb5~d4ww 241305 655456 2019-10-08 2018-09-30 21 4         25               25
126 PORTER HOSPITAL, INC 115 PORTER DRIVE MIDDLEBURY VT 5753 ADDISON (802) 388-4701 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.9994700 -73.1698030 0   1 50 50001         https://data.medicare.gov/resource/xubh-q36u/row-xcfu_sc2r.d4bu 471307 653360 2019-08-29 2018-09-30 25           25               25
177 NORTHERN MAINE MEDICAL CENTER 194 E MAIN STREET FORT KENT ME 4743 AROOSTOOK (207) 834-3195 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.2650680 -68.5911770 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-cr45-cm3b-wfye 200052 645099 2019-02-28 2018-09-30 43           43 6     45       94
178 NORTHERN LIGHT A R GOULD HOSPITAL PO BOX 151 PRESQUE ISLE ME 4769 AROOSTOOK (207) 768-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.6751494 -67.9985861 1 ROOFTOP 3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-ihck.jhth~929r 200018 650152 2019-05-29 2018-09-30 43 6         49   5   14 50     118
179 HOULTON REGIONAL HOSPITAL 20 HARTFORD STREET HOULTON ME 4730 AROOSTOOK (207) 532-2900 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1329620 -67.8426440 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-tx6y-y4iu-nd9t 201308 645561 2019-03-04 2018-09-30 25           25               25
187 P H S INDIAN HOSPITAL CROW / NORTHERN CHEYENNE 1010 SOUTH 7650 EAST, POST OFFICE BOX 9 CROW AGENCY MT 59022 BIG HORN (406) 638-2626 Critical Access Hospitals Government - Federal TRUE 45.5821958 -107.4488586 1 ROOFTOP 3 30 30003         https://data.medicare.gov/resource/xubh-q36u/row-pgmt~4b42~eq7a 271339 646565 2019-03-26 2018-09-30 24           24               24
209 MEMORIAL HOSPITAL, THE 3073 WHITE MOUNTAIN HIGHWAY NORTH CONWAY NH 3860 CARROLL (603) 356-5461 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0605190 -71.1385100 0   3 33 33003         https://data.medicare.gov/resource/xubh-q36u/row-n7xq-6ijr_9ppy 301307 645671 2019-03-01 2018-09-30 21 4         25         45     70
251 MEMORIAL MEDICAL CENTER 1615 MAPLE LANE ASHLAND WI 54806 ASHLAND (715) 685-5500 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.5668870 -90.8879780 0   3 55 55003         https://data.medicare.gov/resource/xubh-q36u/row-d5tf.6nqz~nbsb 521359 645519 2019-03-01 2018-09-30 25           25 10             35
294 P H S INDIAN HOSPITAL-FT BELKNAP AT HARLEM - CAH 456 GROS VENTRE AVE, RR 1 HARLEM MT 59526 BLAINE (406) 353-3100 Critical Access Hospitals Government - Federal TRUE 48.4851890 -108.7670010 0   5 30 30005         https://data.medicare.gov/resource/xubh-q36u/row-sifm_y3g6.gq5p 271315 646038 2019-03-29 2018-09-30 6           6               6
309 ALLEGHANY COUNTY MEMORIAL HOSPITAL 617 DOCTORS STREET SPARTA NC 28675 ALLEGHANY (336) 372-5511 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.5095115 -81.1150447 1 RANGE_INTERPOLATED 5 37 37005         https://data.medicare.gov/resource/xubh-q36u/row-zjv8.p46n-e733 341320 645140 2019-03-04 2018-09-30 25           25               25
317 ALLENDALE COUNTY HOSPITAL 1787 ALLENDALE FAIRFAX RD FAIRFAX SC 29827 ALLENDALE (803) 632-3311 Critical Access Hospitals Government - Local TRUE 32.9662250 -81.2477270 0   5 45 45005         https://data.medicare.gov/resource/xubh-q36u/row-bjdu~dq8g.u82d 421300 645444 2019-03-04 2018-09-30 25           25       44       69
324 NORTHEASTERN VERMONT REGIONAL HOSPITAL 1315 HOSPITAL DRIVE SAINT JOHNSBURY VT 5819 CALEDONIA (802) 748-7400 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4452620 -72.0095160 0   5 50 50005         https://data.medicare.gov/resource/xubh-q36u/row-868v.jqmt-84z2 471303 649002 2019-05-21 2018-09-30 21 4         25               25
330 MARSHFIELD MEDICAL CENTER - RICE LAKE 1700 WEST STOUT STREET RICE LAKE WI 54868 BARRON (715) 234-1515 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5080420 -91.7590270 0   5 55 55005         https://data.medicare.gov/resource/xubh-q36u/row-skqj~bt33-3hxj 520011 640931 2019-01-10 2018-09-30 35 5         40               40
363 BAPTIST MEDICAL CENTER-ATTALA 220 HWY 12 WEST KOSCIUSKO MS 39090 ATTALA (662) 289-4311 Critical Access Hospitals Voluntary non-profit - Other TRUE 33.0655920 -89.5967210 0   7 28 28007         https://data.medicare.gov/resource/xubh-q36u/row-24jy_6div~59c7 251336 644042 2019-03-01 2018-09-30 25           25               25
438 NORTHERN LIGHT BLUE HILL MEMORIAL HOSPITAL 57 WATER STREET BLUE HILL ME 4614 HANCOCK (207) 374-2836 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4114200 -68.5862130 0   9 23 23009         https://data.medicare.gov/resource/xubh-q36u/row-ib5k-im2e_vk94 201300 645100 2019-02-28 2018-09-30 25           25               25
439 NORTHERN LIGHT MAINE COAST HOSPITAL 50 UNION STREET ELLSWORTH ME 4605 HANCOCK (207) 667-5311 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.5465740 -68.4155260 0   9 23 23009         https://data.medicare.gov/resource/xubh-q36u/row-4sb2~q3gq.pkmc 200050 651565 2019-06-26 2018-09-30 42 6         48               48
446 COX MONETT HOSPITAL 801 NORTH LINCOLN AVENUE MONETT MO 65708 BARRY (417) 354-1400 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.9266330 -93.9312500 0   9 29 29009         https://data.medicare.gov/resource/xubh-q36u/row-egvf~xwpf-7msx 261329 645668 2019-03-06 2018-09-30 25           25               25
458 ST ANDREWS HEALTH CENTER - CAH 316 OHMER STREET BOTTINEAU ND 58318 BOTTINEAU (701) 228-9300 Critical Access Hospitals Voluntary non-profit - Church TRUE 48.8291900 -100.4490790 0   9 38 38009         https://data.medicare.gov/resource/xubh-q36u/row-srt8.v5j2-m5pz 351307 645009 2019-03-05 2018-09-30 25           25               25
477 GUAM MEMORIAL HOSPITAL AUTHORITY 85O GOV CARLOS G CAMACHO ROAD TAMUNING GU 96913 GUAM (671) 647-2552 Acute Care Hospitals Government - Local TRUE 13.5008229 144.7755910 1 GEOMETRIC_CENTER 10 66 66010         https://data.medicare.gov/resource/xubh-q36u/row-4hjs.vy3n_hawy 650001 644079 2019-02-28 2018-09-30 147 14         161       40       201
479 GOV JUAN F LUIS HOSPITAL & MEDICAL CTR #4007 EST DIAMOND RUBY, CHRISTIANSTED ST CROIX VI 820 SAINT CROIX ISLAND (340) 778-6311 Acute Care Hospitals Government - State TRUE 17.7336768 -64.7515758 1 ROOFTOP 10 78 78010         https://data.medicare.gov/resource/xubh-q36u/row-bs2s~9p8n_k2e3 480002 644383 2019-02-28 2018-09-30 66 11         77               77
481 BRADLEY COUNTY MEDICAL CENTER 404 SOUTH BRADLEY STREET WARREN AR 71671 BRADLEY (870) 226-3731 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.6105380 -92.0586650 0   11 5 5011         https://data.medicare.gov/resource/xubh-q36u/row-ga7d-t3u8~gykp 41327 644212 2019-03-04 2018-09-30 25           25 10             35
510 ORTONVILLE AREA HEALTH SERVICES 450 EASTVOLD AVE ORTONVILLE MN 56278 BIG STONE (320) 839-2505 Critical Access Hospitals Government - Local TRUE 45.3147690 -96.4465630 0   11 27 27011         https://data.medicare.gov/resource/xubh-q36u/row-jt8y~id78.iwpi 241342 645770 2019-03-28 2018-09-30 25           25       51       76
513 COX BARTON COUNTY HOSPITAL 29 NW 1ST LANE LAMAR MO 64759 BARTON (417) 682-6081 Critical Access Hospitals Government - Local TRUE 37.5052820 -94.2994820 0   11 29 29011         https://data.medicare.gov/resource/xubh-q36u/row-8cv5-t4zj_7sig 261325 645577 2019-03-04 2018-09-30 21 4         25               25
515 BOONE COUNTY HEALTH CENTER P O BOX 151, 723 WEST FAIRVIEW ST ALBION NE 68620 BOONE (402) 395-2191 Critical Access Hospitals Government - Local TRUE 41.6921113 -98.0002224 1 ROOFTOP 11 31 31011         https://data.medicare.gov/resource/xubh-q36u/row-3j5p_6aw6-77k2 281334 645125 2019-02-28 2018-09-30 25           25               25
523 CHARLES A CANNON JR MEMORIAL HOSPITAL 434 HOSPITAL DRIVE LINVILLE NC 28646 AVERY (828) 737-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.0674800 -81.8856780 0   11 37 37011         https://data.medicare.gov/resource/xubh-q36u/row-8t8e~pm2z_adds 341323 645351 2019-02-28 2018-09-30 21           21 10             31
546 PARKER INDIAN HEALTH CENTER 12033 AGENCY ROAD PARKER AZ 85344 LAPAZ (928) 669-2137 Critical Access Hospitals Government - Federal TRUE 34.1464940 -114.3013140 0   12 4 4012         https://data.medicare.gov/resource/xubh-q36u/row-942m-hgdi~yjfy 31307 645964 2019-04-01 2018-09-30 20           20               20
547 LA PAZ REGIONAL HOSPITAL 1200 WEST MOHAVE ROAD PARKER AZ 85344 LAPAZ (928) 669-9201 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1351370 -114.2855970 0   12 4 4012         https://data.medicare.gov/resource/xubh-q36u/row-sg3z_d8n6.kjbm 31317 643569 2019-02-25 2018-09-30 22 3         25               25
548 REGIONAL MEDICAL CENTER OF CENTRAL ALABAMA 29 L V STABLER DRIVE GREENVILLE AL 36037 BUTLER (334) 382-2200 Acute Care Hospitals Proprietary TRUE 31.8294500 -86.6458600 0   13 1 1013         https://data.medicare.gov/resource/xubh-q36u/row-ca8j-ucpx~zp9d 10150 645390 2019-03-01 2018-09-30 37 7         44 13             57
616 BARAGA COUNTY MEMORIAL HOSPITAL 18341 US HIGHWAY 41 L' ANSE MI 49946 BARAGA (906) 524-3300 Critical Access Hospitals Government - Local TRUE 46.7344600 -88.4280420 0   13 26 26013         https://data.medicare.gov/resource/xubh-q36u/row-kzgx-j54h-paej 231307 645568 2019-03-05 2018-09-30 24           24               24
618 BMH-CALHOUN 140 BURKE-CALHOUN CITY ROAD CALHOUN CITY MS 38916 CALHOUN (662) 628-6611 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.8696650 -89.3171760 0   13 28 28013         https://data.medicare.gov/resource/xubh-q36u/row-583j-immm~hxvr 251331 643806 2019-03-01 2018-09-30 25           25               25
661 BURNETT MEDICAL CENTER 257 W ST GEORGE AVE GRANTSBURG WI 54840 BURNETT (715) 463-5353 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.7755460 -92.6871820 0   13 55 55013         https://data.medicare.gov/resource/xubh-q36u/row-zayf~pj6y.5spk 521331 641418 2019-01-24 2018-09-30 25           25       50       75
704 VIDANT BERTIE HOSPITAL 1403 SOUTH KINGS STREET WINDSOR NC 27983 BERTIE (252) 794-6600 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.9893550 -76.9281830 0   15 37 37015         https://data.medicare.gov/resource/xubh-q36u/row-pwdr-dt5d-exsb 341304 644156 2019-02-28 2018-09-30 6           6               6
708 THE PHYSICIANS' HOSPITAL IN ANADARKO 1002 E CENTRAL BLVD ANADARKO OK 73005 CADDO (405) 247-8236 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.0722700 -98.2279900 0   15 40 40015         https://data.medicare.gov/resource/xubh-q36u/row-p7ys.d7q7.puqw 371314 644773 2019-03-01 2018-09-30 25           25               25
716 COPLEY HOSPITAL 528 WASHINGTON HIGHWAY MORRISVILLE VT 5661 LAMOILLE (802) 888-4231 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.5541860 -72.5912140 0   15 50 50015         https://data.medicare.gov/resource/xubh-q36u/row-ddkp~wcpj_r9te 471305 645509 2019-03-01 2018-09-30 25           25               25
774 CAPE FEAR VALLEY-BLADEN COUNTY HOSPITAL 501 SOUTH POPLAR STREET ELIZABETHTOWN NC 28337 BLADEN (910) 862-5100 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.6234740 -78.6082980 0   17 37 37017         https://data.medicare.gov/resource/xubh-q36u/row-t5uc~43ax~cbx3 341315 645438 2019-03-01 2018-09-30 21 4         25               25
791 BAPTIST MEMORIAL HOSPITAL - CARROLL COUNTY 631 RB WILSON DR HUNTINGDON TN 38344 CARROLL (731) 986-4461 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0230410 -88.4134920 0   17 47 47017         https://data.medicare.gov/resource/xubh-q36u/row-xcqt-svm2~s3iu 440016 644064 2019-02-26 2018-09-30 36   6       42 12             54
792 MULESHOE AREA MEDICAL CENTER 708 S 1ST ST MULESHOE TX 79347 BAILEY (806) 272-4524 Critical Access Hospitals Proprietary TRUE 34.2210290 -102.7284580 0   17 48 48017         https://data.medicare.gov/resource/xubh-q36u/row-2yhf.nyid~b2dz 451372 644191 2019-02-28 2018-09-30 25           25               25
835 NANTUCKET COTTAGE HOSPITAL 57 PROSPECT STREET NANTUCKET MA 2554 NANTUCKET (508) 228-1200 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2755420 -70.1002610 0   19 25 25019         https://data.medicare.gov/resource/xubh-q36u/row-txca.96ch~wc9s 220177 646153 2019-03-14 2018-09-30 19           19               19
838 CHOCTAW REGIONAL MEDICAL CENTER 8613 MS HWY 12 ACKERMAN MS 39735 CHOCTAW (662) 285-4400 Critical Access Hospitals Government - Local TRUE 33.3184650 -89.1823040 0   19 28 28019         https://data.medicare.gov/resource/xubh-q36u/row-9nt3~77et_z9mg 251334 643914 2019-03-01 2018-09-30 15           15         73     88

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