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

305 rows where "filed_date" is on date 2019-12-02 sorted by subtotal_acute_beds

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

filed_date (date) ✖

  • 2019-12-02 · 305 ✖
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
1062 1062 SOUTHERN INYO HOSPITAL 501 EAST LOCUST STREET LONE PINE CA 93545 INYO (760) 876-5501 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.6083740 -118.0581590 0   27 6 6027         https://data.medicare.gov/resource/xubh-q36u/row-wcp4_jkw5.du53 51302 659919 2019-12-02 2019-06-30 4           4       33       37
1283 1283 INCLINE VILLAGE HEALTH CENTER 880 ALDER STREET INCLINE VILLAGE NV 89451 WASHOE (775) 833-4100 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2509450 -119.9538610 0   31 32 32031 39900 Reno-Carson City-Fernley, NV Central Washoe County https://data.medicare.gov/resource/xubh-q36u/row-xavt.4jau_b7jd 291301 660260 2019-12-02 2019-06-30 4           4               4
84 84 KAU HOSPITAL 1 KAMANI STREET PAHALA HI 96777 HAWAII (808) 928-8331 Critical Access Hospitals Government - State TRUE 19.2005710 -155.4720970 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-jcnf-fhnk_q5i3 121301 662188 2019-12-02 2019-06-30 6           6               6
2557 2557 LAGUNA HONDA HOSPITAL & REHABILITATION CENTER 375 LAGUNA HONDA BLVD SAN FRANCISCO CA 94116 SAN FRANCISCO (415) 759-2300 Acute Care Hospitals Government - Local FALSE 37.7478240 -122.4586360 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-tz44~vi64-ys8h 50668 662169 2019-12-02 2019-06-30 6           6   5   769       780
2240 2240 SENECA DISTRICT HOSPITAL 130 BRENTWOOD DRIVE CHESTER CA 96020 PLUMAS (530) 258-2121 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.3053020 -121.2340180 0   63 6 6063         https://data.medicare.gov/resource/xubh-q36u/row-6rw5.c6e6.9puv 51327 661143 2019-12-02 2019-06-30 10           10       16       26
3356 3356 AVERA GETTYSBURG HOSPITAL 606 EAST GARFIELD GETTYSBURG SD 57442 POTTER (605) 765-2480 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.0135510 -99.9481280 0   107 46 46107         https://data.medicare.gov/resource/xubh-q36u/row-5ptc-f9a4-vq7p 431302 660878 2019-12-02 2019-06-30 10           10           50   60
1950 1950 DECATUR COUNTY HOSPITAL 1405 NW CHURCH STREET LEON IA 50144 DECATUR (641) 446-4871 Critical Access Hospitals Government - Local TRUE 40.7503080 -93.7477890 0   53 19 19053         https://data.medicare.gov/resource/xubh-q36u/row-z8pk.dm9q_4faw 161340 660972 2019-12-02 2019-06-30 11           11               11
1794 1794 GOTHENBURG MEMORIAL HOSPITAL 910 20TH ST GOTHENBURG NE 69138 DAWSON (308) 537-3661 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.9381320 -100.1533520 0   47 31 31047 30420   Central Dawson County https://data.medicare.gov/resource/xubh-q36u/row-dgzd-a44k.k83g 281313 661037 2019-12-02 2019-06-30 12           12               12
4375 4375 PETERSBURG MEDICAL CENTER PO BOX 589 PETERSBURG AK 99833 PETERSBURG BOROUGH (907) 772-4291 Critical Access Hospitals Government - Local TRUE 56.8128691 -132.9554619 1 ROOFTOP 195 2 2195         https://data.medicare.gov/resource/xubh-q36u/row-ky7y_b72j_698p 21304 660160 2019-12-02 2019-06-30 12           12       15       27
3225 3225 KENSINGTON HOSPITAL 136 W DIAMOND STREET PHILADELPHIA PA 19122 PHILADELPHIA (215) 426-8100 Acute Care Hospitals Voluntary non-profit - Other FALSE 39.9817591 -75.1347791 1 ROOFTOP 101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-jdjh_ypv5.y5gj 390025 660289 2019-12-02 2019-06-30 14           14               14
163 163 KAHUKU MEDICAL CENTER 56-117 PUALALEA STREET KAHUKU HI 96731 HONOLULU (808) 293-9221 Critical Access Hospitals Voluntary non-profit - Other TRUE 21.6764400 -157.9522110 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-gwji.69dv_68xy 121304 661306 2019-12-02 2019-06-30 15           15       6       21
1971 1971 SALEM HEALTH WEST VALLEY 525 SE WASHINGTON STREET DALLAS OR 97338 POLK (503) 623-8301 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9194040 -123.3103830 0   53 41 41053 41420 Portland-Vancouver-Salem, OR-WA Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-urpw.pi4k_vkp4 381308 660286 2019-12-02 2019-06-30 15           15               15
3897 3897 CHI HEALTH PLAINVIEW P O BOX 489, 704 NORTH THIRD ST PLAINVIEW NE 68769 PIERCE (402) 582-4245 Critical Access Hospitals Voluntary non-profit - Church TRUE 42.3587128 -97.7857721 1 ROOFTOP 139 31 31139 35740   Outlying Pierce County https://data.medicare.gov/resource/xubh-q36u/row-dyfy-rvq7~3hjd 281346 661043 2019-12-02 2019-06-30 15           15               15
3943 3943 HIGGINS GENERAL HOSPITAL 200 ALLEN MEMORIAL DRIVE BREMEN GA 30110 HARALSON (770) 812-2000 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.7163430 -85.1446230 0   143 13 13143 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Haralson County https://data.medicare.gov/resource/xubh-q36u/row-rd44_uqxz.t5yc 111320 660206 2019-12-02 2019-06-30 15           15               15
4235 4235 PUTNAM COUNTY MEMORIAL HOSPITAL 1926 OAK STREET, PO BOX 389 UNIONVILLE MO 63565 PUTNAM (660) 947-2411 Critical Access Hospitals Government - Local TRUE 40.4820250 -93.0059870 0   171 29 29171         https://data.medicare.gov/resource/xubh-q36u/row-ygkd_dijw_ng7v 261305 661212 2019-12-02 2019-06-30 15           15               15
4570 4570 MADISON ST JOSEPH HEALTH CENTER 100 WEST CROSS STREET MADISONVILLE TX 77864 MADISON (936) 348-2631 Critical Access Hospitals Voluntary non-profit - Church TRUE 30.9420460 -95.9099560 0   313 48 48313         https://data.medicare.gov/resource/xubh-q36u/row-nns8-bhuk_vxd6 451316 660055 2019-12-02 2019-06-30 15           15               15
4230 4230 ST VINCENT WILLIAMSPORT HOSPITAL INC 412 N MONROE ST WILLIAMSPORT IN 47993 WARREN (765) 762-4000 Critical Access Hospitals Voluntary non-profit - Church TRUE 40.2904700 -87.2958190 0   171 18 18171         https://data.medicare.gov/resource/xubh-q36u/row-hngk~n78p-82t8 151307 660948 2019-12-02 2019-06-30 16           16               16
4268 4268 VALLEY COUNTY HEALTH SYSTEM 2707 L STREET ORD NE 68862 VALLEY (308) 728-4200 Critical Access Hospitals Government - Local TRUE 41.6032130 -98.9426760 0   175 31 31175         https://data.medicare.gov/resource/xubh-q36u/row-y2qv_7x4q_v7xu 281353 661044 2019-12-02 2019-06-30 16           16               16
530 530 COQUILLE VALLEY HOSPITAL DISTRICT 940 EAST 5TH STREET COQUILLE OR 97423 COOS (541) 396-3101 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.1789820 -124.1791430 0   11 41 41011 18300   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-qh6s~rn9z.ntit 381312 660287 2019-12-02 2019-06-30 17           17               17
1070 1070 MANNING REGIONAL HEALTHCARE CENTER 1550 SIXTH STREET MANNING IA 51455 CARROLL (712) 655-2072 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.9066500 -95.0750130 0   27 19 19027         https://data.medicare.gov/resource/xubh-q36u/row-guzz_e3r6~bpt6 161332 660967 2019-12-02 2019-06-30 17           17           46   63
3834 3834 PAWNEE COUNTY MEMORIAL HOSPITAL P O BOX 433, 600 I ST PAWNEE CITY NE 68420 PAWNEE (402) 852-2231 Critical Access Hospitals Proprietary TRUE 40.1098396 -96.1532422 1 ROOFTOP 133 31 31133         https://data.medicare.gov/resource/xubh-q36u/row-2ahw-y3eh_6phq 281302 661036 2019-12-02 2019-06-30 17           17               17
1682 1682 JOHN C FREMONT HEALTHCARE DISTRICT 5189 HOSPITAL ROAD MARIPOSA CA 95338 MARIPOSA (209) 966-3631 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.5005310 -119.9769480 0   43 6 6043         https://data.medicare.gov/resource/xubh-q36u/row-fty8~tgqe.f5tj 51304 661465 2019-12-02 2019-06-30 18           18       16   1   35
2157 2157 DAVIE MEDICAL CENTER 223 HOSPITAL STREET MOCKSVILLE NC 27028 DAVIE (336) 751-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.9000100 -80.5700970 0   59 37 37059 49180 Greensboro--Winston-Salem--High Point, NC Central Davie County https://data.medicare.gov/resource/xubh-q36u/row-6uy2-xp88~p8f2 340187 661371 2019-12-02 2019-06-30 18           18               18
2904 2904 REGIONAL HEALTH SERVICES OF HOWARD COUNTY 235 8TH AVENUE WEST CRESCO IA 52136 HOWARD (563) 547-2101 Critical Access Hospitals Government - Local TRUE 43.3818910 -92.1177640 0   89 19 19089         https://data.medicare.gov/resource/xubh-q36u/row-cg3w~i3hb_y7gu 161328 660965 2019-12-02 2019-06-30 18           18           1   19
3126 3126 MUENSTER MEMORIAL HOSPITAL 605 N MAPLE STREET MUENSTER TX 76252 COOKE (940) 759-2271 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.6538650 -97.3798350 0   97 48 48097 23620 Dallas-Fort Worth, TX-OK Central Cooke County https://data.medicare.gov/resource/xubh-q36u/row-tkmv_gjc7.fa5r 451335 660475 2019-12-02 2019-06-30 18           18               18
3814 3814 CHI HEALTH ST MARY'S 1301 GRUNDMAN BLVD NEBRASKA CITY NE 68410 OTOE (402) 873-3321 Critical Access Hospitals Voluntary non-profit - Church TRUE 40.6581520 -95.8621090 0   131 31 31131         https://data.medicare.gov/resource/xubh-q36u/row-6z57~cf6y.zams 281342 661042 2019-12-02 2019-06-30 18           18               18
964 964 BUTLER COUNTY HEALTH CARE CENTER 372 SOUTH 9TH ST DAVID CITY NE 68632 BUTLER (402) 367-1200 Critical Access Hospitals Government - Local TRUE 41.2464710 -97.1230380 0   23 31 31023         https://data.medicare.gov/resource/xubh-q36u/row-u7xr~dyr4.b4xb 281332 661041 2019-12-02 2019-06-30 20           20               20
1740 1740 EATON RAPIDS MEDICAL CENTER 1500 S MAIN STREET EATON RAPIDS MI 48827 EATON (517) 663-2671 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.4960210 -84.6575390 0   45 26 26045 29620 Lansing-East Lansing-Owosso, MI Central Eaton County https://data.medicare.gov/resource/xubh-q36u/row-ezfk_mmvd_s7mp 231324 661021 2019-12-02 2019-06-30 20           20               20
1872 1872 LECOM HEALTH CORRY MEMORIAL HOSPITAL 965 SHAMROCK LANE CORRY PA 16407 ERIE (814) 664-4641 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.9353790 -79.6128910 0   49 42 42049 21500 Erie-Meadville, PA Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-pwex-5ih7_humz 391308 660305 2019-12-02 2019-06-30 20           20               20
1917 1917 ASHLEY MEDICAL CENTER 612 CENTER AVENUE N ASHLEY ND 58413 MCINTOSH (701) 288-3433 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.0401880 -99.3717150 0   51 38 38051         https://data.medicare.gov/resource/xubh-q36u/row-ecd4.9q4x_twgv 351322 661581 2019-12-02 2019-06-30 20           20       40       60
3688 3688 MORRILL COUNTY COMMUNITY HOSPITAL 1313 S STREET BRIDGEPORT NE 69336 MORRILL (308) 262-1616 Critical Access Hospitals Government - Local TRUE 41.6618900 -103.0913740 0   123 31 31123         https://data.medicare.gov/resource/xubh-q36u/row-zd5w.8rx8_6yzu 281318 661038 2019-12-02 2019-06-30 20           20               20
3859 3859 PERKINS COUNTY HEALTH SERVICES 900 LINCOLN AVE GRANT NE 69140 PERKINS (308) 352-7200 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.8482680 -101.7271820 0   135 31 31135         https://data.medicare.gov/resource/xubh-q36u/row-g4pp~ymgi-thrv 281356 661045 2019-12-02 2019-06-30 20           20           50   70
119 119 SAINT ALPHONSUS MEDICAL CENTER - BAKER CITY, INC 3325 POCAHONTAS ROAD BAKER CITY OR 97814 BAKER (541) 524-7744 Critical Access Hospitals Voluntary non-profit - Church TRUE 44.7961200 -117.8462850 0   1 41 41001         https://data.medicare.gov/resource/xubh-q36u/row-yt65-wbpr_7cai 381315 661086 2019-12-02 2019-06-30 19 2         21               21
1141 1141 UMD SHORE MEDICAL CTR AT CHESTERTOWN 100 BROWN STREET CHESTERTOWN MD 21620 KENT (410) 778-7668 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.2168450 -76.0644920 0   29 24 24029         https://data.medicare.gov/resource/xubh-q36u/row-9gun.f2aw-guni 210030 660229 2019-12-02 2019-06-30 15 6         21               21
1608 1608 PEACE HARBOR MEDICAL CENTER 400 9TH STREET FLORENCE OR 97439 LANE (541) 997-8412 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.9745890 -124.1174640 0   39 41 41039 21660   Central Lane County https://data.medicare.gov/resource/xubh-q36u/row-3bhj~d2nf.qxkv 381316 662244 2019-12-02 2019-06-30 21           21               21
4256 4256 PENDER COMMUNITY HOSPITAL P O BOX 100, 100 HOSPITAL DRIVE PENDER NE 68047 THURSTON (402) 385-3083 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.1055877 -96.7110334 1 ROOFTOP 173 31 31173         https://data.medicare.gov/resource/xubh-q36u/row-iane_yp36_h5j2 281349 661213 2019-12-02 2019-06-30 21           21               21
171 171 CHI HEALTH - MERCY CORNING 603 ROSARY DRIVE CORNING IA 50841 ADAMS (641) 322-3121 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.9883750 -94.7479140 0   3 19 19003         https://data.medicare.gov/resource/xubh-q36u/row-bgwm_q3kt_uw3g 161304 661177 2019-12-02 2019-06-30 22           22               22
2085 2085 HARMON MEMORIAL HOSPITAL 400 EAST CHESTNUT STREET HOLLIS OK 73550 HARMON (580) 688-3363 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.6915370 -99.9143660 0   57 40 40057         https://data.medicare.gov/resource/xubh-q36u/row-uie3-brwx.iwxd 371338 661083 2019-12-02 2019-06-30 22           22               22
2652 2652 PRAIRIE COMMUNITY HOSPITAL 312 S ADAMS TERRY MT 59349 PRAIRIE (406) 635-5511 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.7915060 -105.3159970 0   79 30 30079         https://data.medicare.gov/resource/xubh-q36u/row-cwxm-q75h-madz 271309 660253 2019-12-02 2019-06-30 22           22               22
6 6 CENTRAL MONTANA MEDICAL CENTER 408 WENDELL AVE LEWISTOWN MT 59457 FERGUS (406) 535-7711 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.0584640 -109.4422430 0   27 30 30027         https://data.medicare.gov/resource/xubh-q36u/row-hefc~6xn5~i2c7 271345 661545 2019-12-02 2019-06-30 23           23               23
188 188 ANTELOPE MEMORIAL HOSPITAL P O BOX 229, 102 WEST 9TH ST NELIGH NE 68756 ANTELOPE (402) 887-4151 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1336539 -98.0299847 1 ROOFTOP 3 31 31003         https://data.medicare.gov/resource/xubh-q36u/row-uv86-cr3r-pfws 281326 661040 2019-12-02 2019-06-30 23           23               23
2162 2162 WASHINGTON HEALTH SYSTEM GREENE 350 BONAR AVENUE WAYNESBURG PA 15370 GREENE (724) 627-2602 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9006050 -80.1739290 0   59 42 42059         https://data.medicare.gov/resource/xubh-q36u/row-an6b-ia9u-kxvy 390150 662137 2019-12-02 2019-06-30 23           23               23
139 139 NORTHERN COCHISE COMMUNITY HOSPITAL, INC. 901 WEST REX ALLEN DRIVE WILLCOX AZ 85643 COCHISE (520) 384-3541 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.2642680 -109.8376130 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-ydad~45b6.8t7t 31302 660487 2019-12-02 2019-06-30 24           24       24       48
1584 1584 FLORIDA STATE HOSPITAL UNIT 31 MED 100 N MAIN ST CHATTAHOOCHEE FL 32324 GADSDEN (850) 663-7536 Acute Care Hospitals Government - State FALSE 30.7068990 -84.8425840 0   39 12 12039 45220 Tallahassee-Bainbridge, FL-GA Outlying Gadsden County https://data.medicare.gov/resource/xubh-q36u/row-kyk8-9a3q-5siu 100298 660194 2019-12-02 2019-06-30 24           24 34         1172   1230
3186 3186 FLAMBEAU HOSPITAL 98 SHERRY AVE PARK FALLS WI 54552 PRICE (715) 762-7500 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9310980 -90.4419720 0   99 55 55099         https://data.medicare.gov/resource/xubh-q36u/row-mtm9~rxnu.g2qc 521325 662628 2019-12-02 2019-06-30 20 4         24           1   25
3313 3313 LALLIE KEMP MEDICAL CENTER 52579 HIGHWAY 51 SOUTH INDEPENDENCE LA 70443 TANGIPAHOA (985) 878-9421 Critical Access Hospitals Government - State TRUE 30.6221940 -90.4969990 0   105 22 22105 25220 New Orleans-Metairie-Hammond, LA-MS Central Tangipahoa Parish https://data.medicare.gov/resource/xubh-q36u/row-iyxe~6sc2-ecgv 191321 662534 2019-12-02 2019-06-30 20 4         24               24
17 17 VAN DIEST MEDICAL CENTER 2350 HOSPITAL DRIVE WEBSTER CITY IA 50595 HAMILTON (515) 832-9400 Critical Access Hospitals Government - Local TRUE 42.4529630 -93.8134850 0   79 19 19079         https://data.medicare.gov/resource/xubh-q36u/row-89tb_yu6c_zwc4 161361 660984 2019-12-02 2019-06-30 25           25               25
35 35 HAWARDEN REGIONAL HEALTHCARE 1111 11TH STREET HAWARDEN IA 51023 SIOUX (712) 551-3100 Critical Access Hospitals Government - Local TRUE 42.9980080 -96.4794270 0   167 19 19167         https://data.medicare.gov/resource/xubh-q36u/row-i52u~xknc.njpg 161311 660957 2019-12-02 2019-06-30 25           25               25
69 69 ADAIR COUNTY MEMORIAL HOSPITAL 609 SE KENT GREENFIELD IA 50849 ADAIR (641) 743-2123 Critical Access Hospitals Government - Local TRUE 41.3031030 -94.4519270 0   1 19 19001         https://data.medicare.gov/resource/xubh-q36u/row-3dt7_nstz~yhhy 161310 660956 2019-12-02 2019-06-30 25           25               25
174 174 ALLEN PARISH HOSPITAL 108 6TH AVENUE KINDER LA 70648 ALLEN (337) 738-2527 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.4914530 -92.8556480 0   3 22 22003         https://data.medicare.gov/resource/xubh-q36u/row-572u~e5cv~bbuy 190133 659958 2019-12-02 2019-06-30 25           25 24             49
274 274 VETERANS MEMORIAL HOSPITAL 40 1ST STREET SE WAUKON IA 52172 ALLAMAKEE (563) 568-3411 Critical Access Hospitals Government - Local TRUE 43.2680920 -91.4744460 0   5 19 19005         https://data.medicare.gov/resource/xubh-q36u/row-kmrq-g36y.pe5i 161318 660959 2019-12-02 2019-06-30 25           25               25
279 279 BRIDGTON HOSPITAL 10 HOSPITAL DRIVE BRIDGTON ME 4009 CUMBERLAND (207) 647-6000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0472490 -70.7127770 0   5 23 23005 38860 Portland-Lewiston-South Portland, ME Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-xeqw-dspw~ebr9 201310 662214 2019-12-02 2019-06-30 25           25               25
329 329 BOONE MEMORIAL HOSPITAL 701 MADISON AVENUE MADISON WV 25130 BOONE (304) 369-1230 Critical Access Hospitals Government - Local TRUE 38.0486360 -81.8065320 0   5 54 54005 16620 Charleston-Huntington-Ashland, WV-OH-KY Outlying Boone County https://data.medicare.gov/resource/xubh-q36u/row-r4j3~ibqd.28ff 511313 661267 2019-12-02 2019-06-30 25           25               25
348 348 SHANDS STARKE REGIONAL MEDICAL CENTER 922 E CALL ST STARKE FL 32091 BRADFORD (904) 368-2300 Critical Access Hospitals Proprietary TRUE 29.9419070 -82.1016500 0   7 12 12007         https://data.medicare.gov/resource/xubh-q36u/row-463i.u2z5-p3cq 101310 660199 2019-12-02 2019-06-30 25           25               25
353 353 MERCYONE CENTERVILLE MEDICAL CENTER ONE ST JOSEPH'S DRIVE CENTERVILLE IA 52544 APPANOOSE (641) 437-4111 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.7555228 -92.8568047 1 ROOFTOP 7 19 19007         https://data.medicare.gov/resource/xubh-q36u/row-quyx-h8pq.iqb9 161377 660989 2019-12-02 2019-06-30 22 3         25           19   44
504 504 VIRGINIA GAY HOSPITAL 502 NORTH 9TH AVENUE VINTON IA 52349 BENTON (319) 472-6200 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1736740 -92.0133850 0   11 19 19011 16300 Cedar Rapids-Iowa City, IA Outlying Benton County https://data.medicare.gov/resource/xubh-q36u/row-9sfp.7tdh~i4z3 161349 660977 2019-12-02 2019-06-30 25           25           40   65
622 622 BOX BUTTE GENERAL HOSPITAL P O BOX 810, 2101 BOX BUTTE AVE ALLIANCE NE 69301 BOX BUTTE (308) 762-6660 Critical Access Hospitals Government - Local TRUE 42.0984344 -102.8703880 1 ROOFTOP 13 31 31013         https://data.medicare.gov/resource/xubh-q36u/row-gsu6_furw.wta3 281360 661047 2019-12-02 2019-06-30 25           25               25
626 626 NEW LONDON HOSPITAL 273 COUNTY ROAD NEW LONDON NH 3257 MERRIMACK (603) 526-2911 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.4209290 -72.0014930 0   13 33 33013 18180 Boston-Worcester-Providence, MA-RI-NH-CT Central Merrimack County https://data.medicare.gov/resource/xubh-q36u/row-ziwd~85nn_5vv5 301304 661553 2019-12-02 2019-06-30 25           25               25
646 646 TYRONE REGIONAL HEALTH NETWORK 187 HOSPITAL DRIVE TYRONE PA 16686 BLAIR (814) 684-1255 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.6748430 -78.2523020 0   13 42 42013 11020   Central Blair County https://data.medicare.gov/resource/xubh-q36u/row-n5id.trqm.cz8t 391307 660150 2019-12-02 2019-06-30 20 5         25               25
681 681 BOONE COUNTY HOSPITAL 1015 UNION STREET BOONE IA 50036 BOONE (515) 432-3140 Critical Access Hospitals Government - Local TRUE 42.0555830 -93.8770370 0   15 19 19015 14340 Des Moines-Ames-West Des Moines, IA Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-6zpe~cgwm_xs5p 161372 660987 2019-12-02 2019-06-30 25           25               25
712 712 TROY COMMUNITY HOSPITAL 275 GUTHRIE DRIVE TROY PA 16947 BRADFORD (570) 297-2121 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.7929630 -76.7942220 0   15 42 42015 42380   Central Bradford County https://data.medicare.gov/resource/xubh-q36u/row-mkvg~6vmf~uuac 391305 660149 2019-12-02 2019-06-30 25           25               25
744 744 RUMFORD HOSPITAL 420 FRANKLIN STREET RUMFORD ME 4276 OXFORD (207) 369-1000 Critical Access Hospitals Proprietary TRUE 44.5517210 -70.5571710 0   17 23 23017         https://data.medicare.gov/resource/xubh-q36u/row-923a_kexq.nxfx 201306 662536 2019-12-02 2019-06-30 25           25               25
1001 1001 REDINGTON FAIRVIEW GENERAL HOSPITAL 46 FAIRVIEW AVE PO BOX 468 SKOWHEGAN ME 4976 SOMERSET (207) 474-5121 Critical Access Hospitals Proprietary TRUE 44.7583360 -69.7134950 0   25 23 23025         https://data.medicare.gov/resource/xubh-q36u/row-g9mx~aw3n.5hnn 201314 661526 2019-12-02 2019-06-30 21 4         25               25
1061 1061 NORTHERN INYO HOSPITAL 150 PIONEER LANE BISHOP CA 93514 INYO (760) 873-5811 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.3621080 -118.4073620 0   27 6 6027         https://data.medicare.gov/resource/xubh-q36u/row-mi4n-bdvc~nrpd 51324 661291 2019-12-02 2019-06-30 21 4         25               25
1122 1122 CHI ST VINCENT MORRILTON #4 HOSPITAL DRIVE MORRILTON AR 72110 CONWAY (501) 977-2300 Critical Access Hospitals Voluntary non-profit - Church TRUE 35.1699700 -92.7217020 0   29 5 5029         https://data.medicare.gov/resource/xubh-q36u/row-jajp~f47n.nife 41324 660162 2019-12-02 2019-06-30 25           25               25
1549 1549 CHI HEALTH SCHUYLER 104 WEST 17TH ST SCHUYLER NE 68661 COLFAX (402) 352-2441 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4545790 -97.0597250 0   37 31 31037         https://data.medicare.gov/resource/xubh-q36u/row-jpni~j9gv~awkb 281323 661039 2019-12-02 2019-06-30 25           25               25
1693 1693 GUTTENBERG MUNICIPAL HOSPITAL 200 MAIN STREET GUTTENBERG IA 52052 CLAYTON (563) 252-1121 Critical Access Hospitals Government - Local TRUE 42.7855480 -91.0999540 0   43 19 19043         https://data.medicare.gov/resource/xubh-q36u/row-9vtm.kuer.r3a9 161312 660958 2019-12-02 2019-06-30 25           25               25
1725 1725 MENDOCINO COAST DISTRICT HOSPITAL 700 RIVER DR FORT BRAGG CA 95437 MENDOCINO (707) 961-1234 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.4326130 -123.8007970 0   45 6 6045 46380   Central Mendocino County https://data.medicare.gov/resource/xubh-q36u/row-rw6t.w3x2~jyq9 51325 661292 2019-12-02 2019-06-30 21 4         25               25
1779 1779 CRAWFORD COUNTY MEMORIAL HOSPITAL 100 MEDICAL PARKWAY DENISON IA 51442 CRAWFORD (712) 265-2500 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.0232570 -95.3770860 0   47 19 19047         https://data.medicare.gov/resource/xubh-q36u/row-9ydn-ts52-gjkc 161369 660986 2019-12-02 2019-06-30 25           25               25
1827 1827 FULTON COUNTY HOSPITAL 679 NORTH MAIN STREET SALEM AR 72576 FULTON (870) 895-2691 Critical Access Hospitals Voluntary non-profit - Other TRUE 36.3833590 -91.8112030 0   49 5 5049         https://data.medicare.gov/resource/xubh-q36u/row-9b6n-wd2m.b7tm 41322 660913 2019-12-02 2019-06-30 25           25               25
1836 1836 DALLAS COUNTY HOSPITAL 610 TENTH STREET PERRY IA 50220 DALLAS (515) 465-3547 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.8339590 -94.0944690 0   49 19 19049 19780 Des Moines-Ames-West Des Moines, IA Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-5ca8_jqfe~mw9b 161322 660961 2019-12-02 2019-06-30 25           25               25
1907 1907 MIDMICHIGAN MEDICAL CENTER-GLADWIN 515 QUARTER STREET GLADWIN MI 48624 GLADWIN (989) 426-9286 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.9757310 -84.4953540 0   51 26 26051         https://data.medicare.gov/resource/xubh-q36u/row-mi7y.a5rw~xqzh 231325 661022 2019-12-02 2019-06-30 25           25               25
2069 2069 CUMBERLAND COUNTY HOSPITAL 299 GLASGOW ROAD BURKESVILLE KY 42717 CUMBERLAND (270) 864-2511 Critical Access Hospitals Government - Local TRUE 36.7968680 -85.3724400 0   57 21 21057         https://data.medicare.gov/resource/xubh-q36u/row-ptk2_m6d2-xzym 181317 661512 2019-12-02 2019-06-30 25           25               25
2312 2312 ROUNDUP MEMORIAL HEALTHCARE 1202 3RD ST W ROUNDUP MT 59072 MUSSELSHELL (406) 323-2301 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.4533500 -108.5463330 0   65 30 30065         https://data.medicare.gov/resource/xubh-q36u/row-4hiv-3ibs~jee7 271346 661357 2019-12-02 2019-06-30 25           25               25
2370 2370 JEFFERSON COUNTY HOSPITAL INTERSECTION HYWS 81 & 70 WAURIKA OK 73573 JEFFERSON (580) 228-2344 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1572807 -97.9795416 1 GEOMETRIC_CENTER 67 40 40067         https://data.medicare.gov/resource/xubh-q36u/row-ph4g-iebq.bzzs 371311 662416 2019-12-02 2019-06-30 25           25               25
2478 2478 CHI ST ALEXIUS HEALTH DEVILS LAKE 1031 7TH ST NE DEVILS LAKE ND 58301 RAMSEY (701) 662-2131 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1147740 -98.8503450 0   71 38 38071         https://data.medicare.gov/resource/xubh-q36u/row-i8ea.ub9b_eqnm 351333 662067 2019-12-02 2019-06-30 25           25               25
2528 2528 GREENE COUNTY MEDICAL CENTER 1000 WEST LINCOLNWAY JEFFERSON IA 50129 GREENE (515) 386-2114 Critical Access Hospitals Government - Local TRUE 42.0152170 -94.3890600 0   73 19 19073         https://data.medicare.gov/resource/xubh-q36u/row-ekvn-6v3z_68bn 161325 660962 2019-12-02 2019-06-30 21   4       25               25
2643 2643 ST VINCENT JENNINGS HOSPITAL INC 301 HENRY ST NORTH VERNON IN 47265 JENNINGS (812) 352-4200 Critical Access Hospitals Voluntary non-profit - Church TRUE 39.0112590 -85.6403740 0   79 18 18079 35860 Indianapolis-Carmel-Muncie, IN Central Jennings County https://data.medicare.gov/resource/xubh-q36u/row-pwb4.5pm6~qqy5 151303 660947 2019-12-02 2019-06-30 25           25               25
2789 2789 CHI HEALTH MISSOURI VALLEY 631 N 8TH ST MISSOURI VALLEY IA 51555 HARRISON (712) 642-2784 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.5629770 -95.8850960 0   85 19 19085 36540 Omaha-Council Bluffs-Fremont, NE-IA Outlying Harrison County https://data.medicare.gov/resource/xubh-q36u/row-nied-xbd5_n6bv 161309 661179 2019-12-02 2019-06-30 25           25               25
3038 3038 ST VINCENT MERCY HOSPITAL 1331 S A ST ELWOOD IN 46036 MADISON (765) 552-4743 Critical Access Hospitals Voluntary non-profit - Church TRUE 40.2760200 -85.8440050 0   95 18 18095 26900 Indianapolis-Carmel-Muncie, IN Outlying Madison County https://data.medicare.gov/resource/xubh-q36u/row-kkqs-e5m3-4c2r 151308 660949 2019-12-02 2019-06-30 25           25               25
3106 3106 JACKSON COUNTY REGIONAL HEALTH CENTER 700 W GROVE ST MAQUOKETA IA 52060 JACKSON (563) 652-2474 Critical Access Hospitals Government - Local TRUE 42.0737150 -90.6731320 0   97 19 19097         https://data.medicare.gov/resource/xubh-q36u/row-cqwp_hqw2.ikei 161329 660966 2019-12-02 2019-06-30 25           25               25
3111 3111 ST GABRIELS HOSPITAL 815 SOUTHEAST SECOND STREET LITTLE FALLS MN 56345 MORRISON (320) 632-5441 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9677110 -94.3626510 0   97 27 27097         https://data.medicare.gov/resource/xubh-q36u/row-u3qn-h44f-9as3 241370 661542 2019-12-02 2019-06-30 19   6       25               25
3200 3200 LAWRENCE COUNTY MEMORIAL HOSPITAL 2200 STATE ST LAWRENCEVILLE IL 62439 LAWRENCE (618) 943-1000 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.7295180 -87.6941500 0   101 17 17101         https://data.medicare.gov/resource/xubh-q36u/row-i6xv_c446~uej5 141344 660930 2019-12-02 2019-06-30 25           25               25
3201 3201 JEFFERSON COUNTY HEALTH CENTER 2000 S MAIN FAIRFIELD IA 52556 JEFFERSON (641) 472-4111 Critical Access Hospitals Government - Local TRUE 40.9856350 -91.9631180 0   101 19 19101 21840   Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-cksn~64fu_7y3h 161364 660985 2019-12-02 2019-06-30 25           25               25
3240 3240 WEBSTER COUNTY MEMORIAL HOSPITAL 324 MILLER MOUNTAIN DRIVE WEBSTER SPRINGS WV 26288 WEBSTER (304) 847-5682 Critical Access Hospitals Government - Local TRUE 38.4818680 -80.4098110 0   101 54 54101         https://data.medicare.gov/resource/xubh-q36u/row-stvk~jdqs~5m5u 511301 661266 2019-12-02 2019-06-30 25           25               25
3324 3324 CHI ST ALEXIUS HEALTH WILLISTON 1301 15TH AVE W WILLISTON ND 58801 WILLIAMS (701) 774-7400 Critical Access Hospitals Voluntary non-profit - Church TRUE 48.1543320 -103.6454370 0   105 38 38105 48780   Central Williams County https://data.medicare.gov/resource/xubh-q36u/row-2m99~vhsx_qu32 351334 662569 2019-12-02 2019-06-30 25           25               25
3327 3327 UPMC COLE 1001 EAST SECOND STREET COUDERSPORT PA 16915 POTTER (814) 274-9301 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.7706670 -77.9797410 0   105 42 42105         https://data.medicare.gov/resource/xubh-q36u/row-addx-8ax4.us6v 391313 662251 2019-12-02 2019-06-30 21 4         25       44       69
3552 3552 LUCAS COUNTY HEALTH CENTER 1200 NORTH 7TH STREET CHARITON IA 50049 LUCAS (641) 774-3000 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.0276930 -93.3034210 0   117 19 19117         https://data.medicare.gov/resource/xubh-q36u/row-6kae-djtk-d35x 161341 660973 2019-12-02 2019-06-30 25           25               25
3588 3588 ST JOSEPH'S HOSPITAL 12866 TROXLER AVENUE HIGHLAND IL 62249 MADISON (618) 651-2600 Critical Access Hospitals Voluntary non-profit - Church TRUE 38.7570770 -89.6673580 0   119 17 17119 41180 St. Louis-St. Charles-Farmington, MO-IL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-9pm4-6ca4.6gzh 141336 661881 2019-12-02 2019-06-30 25           25               25
3628 3628 SHANDS LIVE OAK REGIONAL MEDICAL CENTER 1100 SW 11TH ST LIVE OAK FL 32060 SUWANNEE (904) 362-1413 Critical Access Hospitals Proprietary TRUE 30.2917367 -83.0028124 1 ROOFTOP 121 12 12121         https://data.medicare.gov/resource/xubh-q36u/row-keij_wts9-t8jc 101301 660198 2019-12-02 2019-06-30 25           25               25
3676 3676 MAHASKA HEALTH PARTNERSHIP 1229 C AVENUE EAST OSKALOOSA IA 52577 MAHASKA (641) 672-3100 Critical Access Hospitals Government - Local TRUE 41.2985620 -92.6301310 0   123 19 19123 36820   Central Mahaska County https://data.medicare.gov/resource/xubh-q36u/row-r6q8.mtiy.cvna 161379 660990 2019-12-02 2019-06-30 25           25           1   26
3706 3706 KNOXVILLE HOSPITAL & CLINICS 1002 SOUTH LINCOLN STREET KNOXVILLE IA 50138 MARION (641) 842-2151 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.3109860 -93.1095110 0   125 19 19125         https://data.medicare.gov/resource/xubh-q36u/row-6isd~id7e-3xdw 161355 660980 2019-12-02 2019-06-30 25           25               25
3827 3827 BURGESS HEALTH CENTER 1600 DIAMOND STREET ONAWA IA 51040 MONONA (712) 423-2311 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.0257390 -96.1055860 0   133 19 19133         https://data.medicare.gov/resource/xubh-q36u/row-hw7j.7dfu.cqug 161359 660983 2019-12-02 2019-06-30 25           25               25
3853 3853 ST VINCENT RANDOLPH HOSPITAL INC 473 E GREENVILLE AVE WINCHESTER IN 47394 RANDOLPH (765) 584-0004 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.1678770 -84.9703940 0   135 18 18135         https://data.medicare.gov/resource/xubh-q36u/row-ziei~9dqq.tkpr 151301 660946 2019-12-02 2019-06-30 25           25               25
3854 3854 MONROE COUNTY HOSPITAL 6580 165TH STREET ALBIA IA 52531 MONROE (641) 932-2134 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.0448380 -92.7964750 0   135 19 19135         https://data.medicare.gov/resource/xubh-q36u/row-wtqj-qihw~wgcb 161342 660974 2019-12-02 2019-06-30 25           25               25
3910 3910 OZARK HEALTH 2500 HIGHWAY 65 SOUTH CLINTON AR 72031 VAN BUREN (501) 745-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.5593750 -92.4499130 0   141 5 5141         https://data.medicare.gov/resource/xubh-q36u/row-3ppd-9bg7~xqjh 41313 661137 2019-12-02 2019-06-30 25           25       118       143
3972 3972 CLARINDA REGIONAL HEALTH CENTER 220 ESSIE DAVISON DRIVE CLARINDA IA 51632 PAGE (712) 542-2176 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.7231160 -95.0414060 0   145 19 19145         https://data.medicare.gov/resource/xubh-q36u/row-e24e-jv8q.avua 161352 661182 2019-12-02 2019-06-30 25           25               25
3987 3987 COMMUNITY HOSPITAL P O BOX 1328, 1301 EAST H ST MCCOOK NE 69001 RED WILLOW (308) 344-2650 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.2004042 -100.6317977 1 ROOFTOP 145 31 31145         https://data.medicare.gov/resource/xubh-q36u/row-b3ww-n6dr.gmwh 281363 661048 2019-12-02 2019-06-30 25           25               25
4186 4186 MYRTUE MEDICAL CENTER 1213 GARFIELD AVENUE HARLAN IA 51537 SHELBY (712) 755-5161 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.6474730 -95.3262020 0   165 19 19165         https://data.medicare.gov/resource/xubh-q36u/row-cvsd.wj8m_w54b 161374 660988 2019-12-02 2019-06-30 25           25               25
4390 4390 IOWA SPECIALTY HOSPITAL-CLARION 1316 SOUTH MAIN STREET CLARION IA 50525 WRIGHT (515) 532-2811 Critical Access Hospitals Government - Local TRUE 42.7216250 -93.7326280 0   197 19 19197         https://data.medicare.gov/resource/xubh-q36u/row-qm5h-kjf7~8unb 161302 661176 2019-12-02 2019-06-30 25           25               25

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [hospital_data] (
   [hospital_name] TEXT,
   [address] TEXT,
   [city] TEXT,
   [state] TEXT,
   [zip_code] INTEGER,
   [county_name] TEXT,
   [phone_number] TEXT,
   [hospital_type] TEXT,
   [hospital_ownership] TEXT,
   [emergency_services] TEXT,
   [lat] TEXT,
   [lng] TEXT,
   [geocode_flag] INTEGER,
   [geocode_accuracy] TEXT,
   [countyfips] INTEGER,
   [statefips] INTEGER,
   [statecountyfips] INTEGER,
   [cbsacode] TEXT,
   [csatitle] TEXT,
   [centraloutlyingcounty] TEXT,
   [countyequivalent] TEXT,
   [hosp_lookup_url] TEXT,
   [PRVDR_NUM] INTEGER,
   [RPT_REC_NUM] INTEGER,
   [filed_date] TEXT,
   [fy_end_date] TEXT,
   [acute_beds] INTEGER,
   [icu_beds] TEXT,
   [coronary_beds] TEXT,
   [burn_beds] TEXT,
   [surg_icu_beds] TEXT,
   [oth_spec_beds] TEXT,
   [subtotal_acute_beds] INTEGER,
   [subprovider_ipf_beds] TEXT,
   [subprovider_irf_beds] TEXT,
   [subprovider_oth_beds] TEXT,
   [skilled_nursing_beds] TEXT,
   [nursing_fac_beds] TEXT,
   [oth_longterm_beds] TEXT,
   [hospice_beds] TEXT,
   [all_beds] INTEGER
);