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

212 rows where "filed_date" is on date 2019-11-26 sorted by cbsacode

✎ 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, skilled_nursing_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-11-26 · 212 ✖
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
25 25 ESSENTIA HEALTH ADA 201 9TH STREET WEST ADA MN 56510 NORMAN (218) 784-5000 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.2960910 -96.5301900 0   107 27 27107         https://data.medicare.gov/resource/xubh-q36u/row-z63y_de5x~9s9u 241313 660607 2019-11-26 2019-06-30 14           14               14
218 218 CHI MERCY HEALTH 570 CHAUTAUQUA BLVD VALLEY CITY ND 58072 BARNES (701) 845-6400 Critical Access Hospitals Voluntary non-profit - Church TRUE 46.9284920 -97.9949080 0   3 38 38003         https://data.medicare.gov/resource/xubh-q36u/row-pmhy~szku-z7nc 351324 662240 2019-11-26 2019-06-30 25           25               25
270 270 BACON COUNTY HOSPITAL 302 SOUTH WAYNE STREET ALMA GA 31510 BACON (912) 632-8961 Critical Access Hospitals Voluntary non-profit - Other TRUE 31.5391100 -82.4596870 0   5 13 13005         https://data.medicare.gov/resource/xubh-q36u/row-fsgt~f6fy~f5qx 111327 659492 2019-11-26 2019-06-30 21 4         25       88       113
291 291 ESSENTIA HEALTH ST MARYS - DETROIT LAKES 1027 WASHINGTON AVE DETROIT LAKES MN 56501 BECKER (218) 847-0888 Acute Care Hospitals Voluntary non-profit - Church FALSE 46.8153070 -95.8454530 0   5 27 27005         https://data.medicare.gov/resource/xubh-q36u/row-my2b~zwif~njdr 240101 660605 2019-11-26 2019-06-30 28 8         36       96       132
293 293 COMMUNITY HOSPITAL ASSOCIATION 26136 US HIGHWAY 59, PO BOX 107 FAIRFAX MO 64446 ATCHISON (660) 686-2211 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.3482150 -95.3973230 0   5 29 29005         https://data.medicare.gov/resource/xubh-q36u/row-kkzi.c85k.9msb 261303 660249 2019-11-26 2019-06-30 16           16               16
447 447 MERCY HOSPITAL CASSVILLE 94 MAIN STREET CASSVILLE MO 65625 BARRY (417) 847-6065 Critical Access Hospitals Voluntary non-profit - Church TRUE 36.6740770 -93.8718860 0   9 29 29009         https://data.medicare.gov/resource/xubh-q36u/row-wswc_mpwv.fwbj 261317 660251 2019-11-26 2019-06-30 18           18               18
461 461 UPMC BEDFORD MEMORIAL 10455 LINCOLN HIGHWAY EVERETT PA 15537 BEDFORD (814) 623-6161 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0247210 -78.4332550 0   9 42 42009         https://data.medicare.gov/resource/xubh-q36u/row-a7tx_6h63.ijq9 390117 659869 2019-11-26 2019-06-30 36 4         40               40
465 465 LANDMANN-JUNGMAN MEMORIAL HOSPITAL - CAH 600 BILLARS ST SCOTLAND SD 57059 BON HOMME (605) 583-2226 Critical Access Hospitals Government - Local TRUE 43.1494940 -97.7281040 0   9 46 46009         https://data.medicare.gov/resource/xubh-q36u/row-h5nm-t8q8-ubs6 431317 662141 2019-11-26 2019-06-30 25           25               25
921 921 CHI OAKES HOSPITAL 1200 N 7TH ST OAKES ND 58474 DICKEY (701) 742-3291 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1507960 -98.0904330 0   21 38 38021         https://data.medicare.gov/resource/xubh-q36u/row-b2w7_uuc8~i52v 351315 659999 2019-11-26 2019-06-30 20           20               20
1295 1295 CARRINGTON HEALTH CENTER PO BOX 461 CARRINGTON ND 58421 FOSTER (701) 652-3141 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.4497201 -99.1262234 1 APPROXIMATE 31 38 38031         https://data.medicare.gov/resource/xubh-q36u/row-inkg_zfig.5z7t 351318 662239 2019-11-26 2019-06-30 25           25               25
1386 1386 CLEARWATER VALLEY HOSPITAL & CLINICS 301 CEDAR STREET OROFINO ID 83544 CLEARWATER (208) 476-4555 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4873150 -116.2599160 0   35 16 16035         https://data.medicare.gov/resource/xubh-q36u/row-4jwp-mz4f-k7tn 131320 659779 2019-11-26 2019-06-30 23           23               23
1538 1538 MERCY MEDICAL CENTER-NEW HAMPTON 308 NORTH MAPLE AVENUE NEW HAMPTON IA 50659 CHICKASAW (641) 394-4121 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.0626770 -92.3204250 0   37 19 19037         https://data.medicare.gov/resource/xubh-q36u/row-xkj8-v8qa.w84a 161331 660217 2019-11-26 2019-06-30 8           8               8
1833 1833 ST MARY'S HOSPITAL 701 LEWISTON ST COTTONWOOD ID 83522 IDAHO (208) 962-3251 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.0503710 -116.3516450 0   49 16 16049         https://data.medicare.gov/resource/xubh-q36u/row-u7zv_7y6z_xg8a 131321 661307 2019-11-26 2019-06-30 25           25               25
1932 1932 MILBANK AREA HOSPITAL/AVERA HEALTH 301 FLYNN DRIVE MILBANK SD 57252 GRANT (605) 432-4538 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.2219130 -96.6175485 1 ROOFTOP 51 46 46051         https://data.medicare.gov/resource/xubh-q36u/row-y6xc~czq6~y94b 431326 660034 2019-11-26 2019-06-30 25           25               25
1954 1954 ASPIRUS IRONWOOD HOSPITAL N10561 GRAND VIEW LANE IRONWOOD MI 49938 GOGEBIC (906) 932-2525 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4781930 -90.1046890 0   53 26 26053         https://data.medicare.gov/resource/xubh-q36u/row-kai4_hwh9~ugv4 231333 660107 2019-11-26 2019-06-30 20 5         25               25
1974 1974 AVERA GREGORY HOSPITAL 400 PARK STREET POST OFFICE BOX 408 GREGORY SD 57533 GREGORY (605) 835-8394 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.2319878 -99.4304377 1 ROOFTOP 53 46 46053         https://data.medicare.gov/resource/xubh-q36u/row-sxnm~ansc_ejzf 431338 662257 2019-11-26 2019-06-30 25           25       55       80
2000 2000 FRANKLIN HOSPITAL 201 BAILEY LANE BENTON IL 62812 FRANKLIN (618) 439-3161 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.0091370 -88.9171420 0   55 17 17055         https://data.medicare.gov/resource/xubh-q36u/row-a634_xpuq_r7c9 141321 660523 2019-11-26 2019-06-30 25           25               25
2194 2194 DEER RIVER HEALTHCARE CENTER 115 10TH AVENUE NORTHEAST DEER RIVER MN 56636 ITASCA (218) 246-2900 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.3435030 -93.7912990 0   61 27 27061         https://data.medicare.gov/resource/xubh-q36u/row-run4_u2tc_i8qs 241360 660613 2019-11-26 2019-06-30 20           20       32       52
2320 2320 NELL J REDFIELD MEMORIAL HOSPITAL 150 NORTH 200 WEST MALAD ID 83252 ONEIDA (208) 766-2231 Critical Access Hospitals Government - Local TRUE 42.1896380 -112.2507590 0   71 16 16071         https://data.medicare.gov/resource/xubh-q36u/row-dtun.jgpu~2hmu 131303 662195 2019-11-26 2019-06-30 11           11       33       44
2322 2322 PENN HIGHLANDS BROOKVILLE 100 HOSPITAL ROAD BROOKVILLE PA 15825 JEFFERSON (814) 849-2312 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.1564730 -79.0928840 0   65 42 42065         https://data.medicare.gov/resource/xubh-q36u/row-5dtj-fqtw.9nmm 391312 660451 2019-11-26 2019-06-30 25           25 10             35
2351 2351 BOB WILSON MEMORIAL GRANT COUNTY HOSPITAL 415 N MAIN STREET ULYSSES KS 67880 GRANT (620) 356-1266 Acute Care Hospitals Proprietary TRUE 37.5839920 -101.3580130 0   67 20 20067         https://data.medicare.gov/resource/xubh-q36u/row-8mti_jcxr_myzi 170110 660091 2019-11-26 2019-06-30 26           26               26
2360 2360 LIVINGSTON HEALTHCARE 320 ALPENGLOW LANE LIVINGSTON MT 59047 PARK (406) 222-3541 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.6760430 -110.5254250 0   67 30 30067         https://data.medicare.gov/resource/xubh-q36u/row-ygth.6c69~3dyb 271317 659987 2019-11-26 2019-06-30 21 4         25               25
2467 2467 ASPIRUS IRON RIVER HOSPITAL & CLINICS, INC 1400 W ICE LAKE ROAD IRON RIVER MI 49935 IRON (906) 265-6121 Critical Access Hospitals Voluntary non-profit - Other TRUE 46.0997200 -88.6202810 0   71 26 26071         https://data.medicare.gov/resource/xubh-q36u/row-5hmu-6w8t_e66h 231318 660105 2019-11-26 2019-06-30 22 3         25               25
2542 2542 CHI LISBON HEALTH 905 MAIN ST LISBON ND 58054 RANSOM (701) 683-5241 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4370020 -97.6814270 0   73 38 38073         https://data.medicare.gov/resource/xubh-q36u/row-sifi~rypw~xg47 351311 662066 2019-11-26 2019-06-30 25           25               25
2700 2700 CHRISTUS COUSHATTA HEALTH CARE CENTER 1635 MARVEL STREET COUSHATTA LA 71019 RED RIVER (318) 932-2000 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.0216580 -93.3437340 0   81 22 22081         https://data.medicare.gov/resource/xubh-q36u/row-zmg8-cgqs~6zge 191312 659797 2019-11-26 2019-06-30 25           25               25
2911 2911 AVERA ST ANTHONY'S HOSPITAL 300 NORTH 2ND ST O' NEILL NE 68763 HOLT (402) 336-5131 Critical Access Hospitals Voluntary non-profit - Church TRUE 42.4603380 -98.6511180 0   89 31 31089         https://data.medicare.gov/resource/xubh-q36u/row-z9z2~5zkd.wkgh 281329 660645 2019-11-26 2019-06-30 25           25               25
2945 2945 HUMBOLDT COUNTY MEMORIAL HOSPITAL 1000 NORTH 15TH STREET HUMBOLDT IA 50548 HUMBOLDT (515) 332-4200 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.7318350 -94.2302160 0   91 19 19091         https://data.medicare.gov/resource/xubh-q36u/row-vk9h.9r4x-cbu7 161334 660218 2019-11-26 2019-06-30 17           17           28   45
2962 2962 SHERIDAN MEMORIAL HOSPTIAL 440 W LAUREL AVE PLENTYWOOD MT 59254 SHERIDAN (406) 765-3700 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.7786770 -104.5629980 0   91 30 30091         https://data.medicare.gov/resource/xubh-q36u/row-sdy5~7jt6~e9wj 271322 660411 2019-11-26 2019-06-30 19           19       45       64
3070 3070 ST CROIX REGIONAL MEDICAL CENTER 235 STATE STREET SAINT CROIX FALLS WI 54024 POLK (715) 483-0556 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.4091340 -92.6422180 0   95 55 55095         https://data.medicare.gov/resource/xubh-q36u/row-xrt7~5aku-syxq 521337 660736 2019-11-26 2019-06-30 22 3         25               25
3239 3239 AVERA FLANDREAU HOSPITAL - CAH 214 NORTH PRAIRIE STREET FLANDREAU SD 57028 MOODY (605) 997-2433 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0505680 -96.5909890 0   101 46 46101         https://data.medicare.gov/resource/xubh-q36u/row-2fiy.k67h.w2yb 431310 660033 2019-11-26 2019-06-30 18           18               18
3292 3292 LINCOLN MEDICAL CENTER 106 MEDICAL CENTER BLVD FAYETTEVILLE TN 37334 LINCOLN (931) 438-1100 Acute Care Hospitals Government - Local TRUE 35.1490050 -86.5573410 0   103 47 47103         https://data.medicare.gov/resource/xubh-q36u/row-cc2v~5skb_qq6b 440102 660708 2019-11-26 2019-06-30 43 6         49               49
3326 3326 JANE PHILLIPS NOWATA HOSPITAL, INC 237 SOUTH LOCUST STREET NOWATA OK 74048 NOWATA (918) 273-3102 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.6965140 -95.6305030 0   105 40 40105         https://data.medicare.gov/resource/xubh-q36u/row-rnwc~4b3z-5gvh 371305 660003 2019-11-26 2019-06-30 25           25               25
3378 3378 MERCY HOSPITAL AURORA 500 PORTER AVENUE AURORA MO 65605 LAWRENCE (417) 678-2122 Critical Access Hospitals Voluntary non-profit - Church TRUE 36.9705100 -93.7109620 0   109 29 29109         https://data.medicare.gov/resource/xubh-q36u/row-pmej_ahzh-su6w 261316 660250 2019-11-26 2019-06-30 25           25               25
3539 3539 BARNES-KASSON COUNTY HOSPITAL 2872 TURNPIKE STREET SUSQUEHANNA PA 18847 SUSQUEHANNA (570) 853-3135 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.9473720 -75.5940160 0   115 42 42115         https://data.medicare.gov/resource/xubh-q36u/row-jek6.26ef-dwbb 391309 659886 2019-11-26 2019-06-30 21 4         25       58       83
3810 3810 ASPIRUS ONTONAGON HOSPITAL, INC 601 S SEVENTH ST ONTONAGON MI 49953 ONTONAGON (906) 884-8000 Critical Access Hospitals Government - Local TRUE 46.8656350 -89.3029760 0   131 26 26131         https://data.medicare.gov/resource/xubh-q36u/row-zhnw-wptd-d4w4 231309 660103 2019-11-26 2019-06-30 25           25       46       71
4060 4060 CENTRACARE HEALTH SYSTEM - LONG PRAIRIE 50 CENTRACARE DRIVE LONG PRAIRIE MN 56347 TODD (320) 732-2141 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9733659 -94.8429923 1 ROOFTOP 153 27 27153         https://data.medicare.gov/resource/xubh-q36u/row-auf6_7hb8_cyed 241326 660609 2019-11-26 2019-06-30 14           14       70       84
4298 4298 WEBSTER COUNTY COMMUNITY HOSPITAL P O BOX 465, 621 N FRANKLIN ST RED CLOUD NE 68970 WEBSTER (402) 746-5600 Critical Access Hospitals Government - Local TRUE 40.0915582 -98.5280755 1 ROOFTOP 181 31 31181         https://data.medicare.gov/resource/xubh-q36u/row-2g3y_shvn~j8h3 281316 660132 2019-11-26 2019-06-30 13           13               13
4450 4450 ST CLAIRE REGIONAL MEDICAL CENTER 222 MEDICAL CIRCLE MOREHEAD KY 40351 ROWAN (606) 783-6502 Acute Care Hospitals Government - Federal TRUE 38.1800160 -83.4424540 0   205 21 21205         https://data.medicare.gov/resource/xubh-q36u/row-epvn~wthp~wxsz 180018 660556 2019-11-26 2019-06-30 76 14         90 20 10   7   3   130
4509 4509 CHRISTUS JASPER MEMORIAL HOSPITAL 1275 MARVIN HANCOCK DRIVE JASPER TX 75951 JASPER (409) 384-5461 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.9076390 -94.0085330 0   241 48 48241         https://data.medicare.gov/resource/xubh-q36u/row-3yge~3w33.2wyx 450573 659898 2019-11-26 2019-06-30 34 6         40               40
4708 4708 CHRISTUS MOTHER FRANCES HOSPITAL- WINNSBORO 719 WEST COKE ROAD WINNSBORO TX 75494 WOOD (903) 342-5227 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.9476430 -95.3062300 0   499 48 48499         https://data.medicare.gov/resource/xubh-q36u/row-sujf.kw2i-m7r8 451381 660335 2019-11-26 2019-06-30 23           23               23
110 110 UNM HOSPITAL 2211 LOMAS BOULEVARD NE ALBUQUERQUE NM 87106 BERNALILLO (505) 272-2111 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.0874830 -106.6181480 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-ntcm.qi4a~h9yr 320001 661059 2019-11-26 2019-06-30 345           473 82             555
2646 2646 CHRISTUS ST FRANCES CABRINI HOSPITAL 3330 MASONIC DRIVE ALEXANDRIA LA 71301 RAPIDES (318) 487-1122 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.2824010 -92.4608480 0   79 22 22079 10780   Central Rapides Parish https://data.medicare.gov/resource/xubh-q36u/row-tc25-kjhe-hnmq 190019 659683 2019-11-26 2019-06-30 230 26       20 276   25           301
4519 4519 CHRISTUS SPOHN HOSPITAL ALICE 2500 E MAIN STREET ALICE TX 78332 JIM WELLS (361) 661-8016 Acute Care Hospitals Voluntary non-profit - Private TRUE 27.7655080 -98.0437130 0   249 48 48249 10860 Corpus Christi-Kingsville-Alice, TX Central Jim Wells County https://data.medicare.gov/resource/xubh-q36u/row-b4k9_mqdr~hpfd 450828 660474 2019-11-26 2019-06-30 64 8         72               72
2623 2623 LEHIGH VALLEY HOSPITAL 1200 SOUTH CEDAR CREST BOULEVARD ALLENTOWN PA 18105 LEHIGH (610) 402-2273 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5667720 -75.5186720 0   77 42 42077 10900 New York-Newark, NY-NJ-CT-PA Central Lehigh County https://data.medicare.gov/resource/xubh-q36u/row-5fzf-faw4~6h9r 390133 659871 2019-11-26 2019-06-30 830 86 14 18 11 42 1023 52 62   52   10   1199
4220 4220 STORY COUNTY HOSPITAL 640 SOUTH 19TH STREET NEVADA IA 50201 STORY (515) 382-2111 Critical Access Hospitals Government - Local TRUE 42.0053340 -93.4349020 0   169 19 19169 11180 Des Moines-Ames-West Des Moines, IA Central Story County https://data.medicare.gov/resource/xubh-q36u/row-qdh4.4mty_76ab 161333 660968 2019-11-26 2019-06-30 17           17           80   97
4138 4138 UNIVERSITY OF MICHIGAN HEALTH SYSTEM 1500 E MEDICAL CENTER DRIVE, SPC 5474 ANN ARBOR MI 48109 WASHTENAW (734) 764-1505 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.2853400 -83.7290400 0   161 26 26161 11460 Detroit-Warren-Ann Arbor, MI Central Washtenaw County https://data.medicare.gov/resource/xubh-q36u/row-4jqn-utws_26e7 230046 659809 2019-11-26 2019-06-30 718 20 10 10     931 43 32           1006
4460 4460 SETON MEDICAL CENTER HAYS 6001 KYLE PKWY KYLE TX 78640 HAYS (512) 324-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.0077340 -97.8552800 0   209 48 48209 12420   Central Hays County https://data.medicare.gov/resource/xubh-q36u/row-2smr~t9jf_xa5x 670056 660903 2019-11-26 2019-06-30 106 32       4 142               142
4677 4677 SETON SOUTHWEST HOSPITAL 7900 FM 1826 AUSTIN TX 78737 HAYS (512) 324-9000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2269600 -97.8895100 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-vyb5.mka7-v5kk 450865 660054 2019-11-26 2019-06-30 28           28               28
285 285 MEDSTAR FRANKLIN SQUARE MEDICAL CENTER 9000 FRANKLIN SQUARE DRIVE BALTIMORE MD 21237 BALTIMORE (443) 777-7850 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.3503350 -76.4810120 0   5 24 24005 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore County https://data.medicare.gov/resource/xubh-q36u/row-qdqy_nadx.4qry 210015 660388 2019-11-26 2019-06-30 321 26         347               347
4713 4713 JOHNS HOPKINS BAYVIEW MEDICAL CENTER 4940 EASTERN AVENUE BALTIMORE MD 21224 BALTIMORE CITY (410) 550-0123 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.2872850 -76.5521340 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-tsuu-47er~ackm 210029 661192 2019-11-26 2019-06-30 332 22 12 10 10 25 411               411
4716 4716 MEDSTAR HARBOR HOSPITAL 3001 SOUTH HANOVER STREET BALTIMORE MD 21225 BALTIMORE CITY (410) 350-3201 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.2513490 -76.6150480 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-j3c9_gym3-5rw7 210034 659803 2019-11-26 2019-06-30 117 12         129               129
4717 4717 MEDSTAR UNION MEMORIAL HOSPITAL 201 EAST UNIVERSITY PARKWAY BALTIMORE MD 21218 BALTIMORE CITY (410) 554-2227 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.3303820 -76.6143800 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-azaj.edd6.262f 210024 660389 2019-11-26 2019-06-30 133 52         185               185
4724 4724 MEDSTAR GOOD SAMARITAN HOSPITAL 5601 LOCH RAVEN BOULEVARD BALTIMORE MD 21239 BALTIMORE CITY (443) 444-3902 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.3593010 -76.5886840 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-zvrw-pxqd~vwry 210056 659805 2019-11-26 2019-06-30 184 17         201               201
4517 4517 CHRISTUS SOUTHEAST TEXAS- ST ELIZABETH 2830 CALDER AVENUE BEAUMONT TX 77702 JEFFERSON (409) 892-7171 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.0855830 -94.1317020 0   245 48 48245 13140   Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-mj59_xjsi~hf8e 450034 659730 2019-11-26 2019-06-30 306 39       25 370               370
1041 1041 CHRISTUS SPOHN HOSPITAL BEEVILLE 1500 E HOUSTON HWY BEEVILLE TX 78102 BEE (361) 354-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 28.4083530 -97.7319250 0   25 48 48025 13300   Central Bee County https://data.medicare.gov/resource/xubh-q36u/row-i8xs~bawd_cyy5 450082 659895 2019-11-26 2019-06-30 32 8         40               40
1561 1561 BERWICK HOSPITAL CENTER 701 EAST 16TH STREET BERWICK PA 18603 COLUMBIA (570) 759-5020 Acute Care Hospitals Proprietary TRUE 41.0701590 -76.2308040 0   37 42 42037 14100 Bloomsburg-Berwick-Sunbury, PA Central Columbia County https://data.medicare.gov/resource/xubh-q36u/row-cn25-dn3w-iqqf 390072 660695 2019-11-26 2019-06-30 77 10         87 14     240       341
2042 2042 PRINCETON COMMUNITY HOSPITAL 122 12TH STREET PRINCETON WV 24740 MERCER (304) 487-7260 Acute Care Hospitals Government - Local TRUE 37.3624580 -81.1130970 0   55 54 54055 14140   Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-sk8g_82ie~wytp 510046 660726 2019-11-26 2019-06-30 78   11       89 64             153
2067 2067 GREAT RIVER MEDICAL CENTER 1221 SOUTH GEAR AVENUE WEST BURLINGTON IA 52655 DES MOINES (319) 768-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8073690 -91.1702780 0   57 19 19057 15460   Central Des Moines County https://data.medicare.gov/resource/xubh-q36u/row-8pkk_2khg-h2nd 160057 660081 2019-11-26 2019-06-30 124 12         136   11   160   6   313
1542 1542 MEDSTAR SAINT MARY'S HOSPITAL 25500 POINT LOOKOUT ROAD LEONARDTOWN MD 20650 ST. MARYS (301) 475-6001 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.2992390 -76.6403830 0   37 24 24037 15680 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central St. Mary's County https://data.medicare.gov/resource/xubh-q36u/row-hrp5-h6jf_ehik 210028 660390 2019-11-26 2019-06-30 84 12         96               96
701 701 ARTESIA GENERAL HOSPITAL 702 N 13TH STREET ARTESIA NM 88210 EDDY (575) 748-3333 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.8486030 -104.4127520 0   15 35 35015 16100   Central Eddy County https://data.medicare.gov/resource/xubh-q36u/row-t6vu-yth8.bk8u 320030 659993 2019-11-26 2019-06-30 34           34 15             49
1249 1249 INGALLS MEMORIAL HOSPITAL 1 INGALLS DRIVE HARVEY IL 60426 COOK (708) 333-2300 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.6063310 -87.6594840 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-vjp9-dpap-bkr6 140191 660514 2019-11-26 2019-06-30 243 25         268 16 42           326
1250 1250 SAINT ANTHONY HOSPITAL 2875 WEST 19TH STREET CHICAGO IL 60623 COOK (773) 521-1710 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8555380 -87.6982720 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-kqum-g8qm_qy52 140095 660928 2019-11-26 2019-06-30 94 15         109 42             151
778 778 MCCULLOUGH-HYDE MEMORIAL HOSPITAL 110 NORTH POPLAR STREET OXFORD OH 45056 BUTLER (513) 524-5640 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.5121800 -84.7408150 0   17 39 39017 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Butler County https://data.medicare.gov/resource/xubh-q36u/row-tm5u.6nm2.a733 360046 660666 2019-11-26 2019-06-30 41 4         45               45
1735 1735 MERCYONE CLINTON MEDICAL CENTER 1410 NORTH 4TH STREET CLINTON IA 52732 CLINTON (563) 244-5555 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8605430 -90.1881550 0   45 19 19045 17540 Davenport-Moline, IA-IL Central Clinton County https://data.medicare.gov/resource/xubh-q36u/row-2kgs.eg5q.xjrv 160080 660084 2019-11-26 2019-06-30 97 10         107               107
1638 1638 CENTURA HEALTH-PENROSE-ST FRANCIS HEALTH SERVICES 2222 NORTH NEVADA AVE COLORADO SPRINGS CO 80907 EL PASO (719) 776-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8655680 -104.8201230 0   41 8 8041 17820   Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-gqx3~746f~9uqw 60031 659763 2019-11-26 2019-06-30 354 45         445   23           468
1639 1639 UNIVERSITY COLO HEALTH MEMORIAL HOSPITAL CENTRAL 1400 E BOULDER ST COLORADO SPRINGS CO 80909 EL PASO (719) 365-5000 Acute Care Hospitals Government - Local TRUE 38.8388120 -104.7999510 0   41 8 8041 17820   Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-a2ae-uent-g89f 60022 659639 2019-11-26 2019-06-30 385 46         515   22           537
839 839 UNIVERSITY OF MISSOURI HEALTH CARE ONE HOSPITAL DRIVE COLUMBIA MO 65212 BOONE (573) 882-4141 Acute Care Hospitals Government - State TRUE 38.9386955 -92.3275514 1 ROOFTOP 19 29 29019 17860 Columbia-Moberly-Mexico, MO Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-63ac~57ef~2j52 260141 660405 2019-11-26 2019-06-30 372 82       58 530 61             591
1752 1752 DILEY RIDGE MEDICAL CENTER 7911 DILEY ROAD CANAL WINCHESTER OH 43110 FRANKLIN (614) 838-7910 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8500530 -82.7811000 0   45 39 39045 18140 Columbus-Marion-Zanesville, OH Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-82cy_fgw2.yjpg 360358 660675 2019-11-26 2019-06-30 10           10               10
1857 1857 MOUNT CARMEL NEW ALBANY SURGICAL HOSPITAL 7333 SMITH'S MILL ROAD NEW ALBANY OH 43054 FRANKLIN (614) 775-6600 Acute Care Hospitals Proprietary FALSE 40.0863030 -82.7887930 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-ywvf~p2gq~kk8u 360266 660674 2019-11-26 2019-06-30 60           60               60
1861 1861 MOUNT CARMEL WEST 793 WEST STATE STREET COLUMBUS OH 43222 FRANKLIN (614) 234-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9577820 -83.0208240 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-prgi-8b6s~4jgz 360035 660665 2019-11-26 2019-06-30 422 44 74       571 12             583
1864 1864 MOUNT CARMEL ST ANN'S 500 SOUTH CLEVELAND AVENUE WESTERVILLE OH 43081 FRANKLIN (614) 898-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.1143740 -82.9489090 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-zt85_iihf.a6ks 360012 660662 2019-11-26 2019-06-30 231 12 30   11   284               284
3924 3924 COOKEVILLE REGIONAL MEDICAL CENTER 1 MEDICAL CENTER BOULEVARD COOKEVILLE TN 38501 PUTNAM (931) 783-2000 Acute Care Hospitals Government - Local TRUE 36.1699600 -85.5093500 0   141 47 47141 18260   Central Putnam County https://data.medicare.gov/resource/xubh-q36u/row-huvy_sdvh_bsx2 440059 660310 2019-11-26 2019-06-30 173 38         211   20           231
528 528 SOUTHERN COOS HOSPITAL & HEALTH CENTER 900 11TH STREET SE BANDON OR 97411 COOS (541) 347-2426 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.1132440 -124.4024260 0   11 41 41011 18300   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-gr9r_ty5i_3jqt 381304 660285 2019-11-26 2019-06-30 19           19               19
4596 4596 CHRISTUS SPOHN HOSPITAL CORPUS CHRISTI 600 ELIZABETH STREET CORPUS CHRISTI TX 78404 NUECES (361) 902-4103 Acute Care Hospitals Voluntary non-profit - Private TRUE 27.7774890 -97.3951210 0   355 48 48355 18580 Corpus Christi-Kingsville-Alice, TX Central Nueces County https://data.medicare.gov/resource/xubh-q36u/row-jjnn-vsf2-rj2w 450046 659894 2019-11-26 2019-06-30 376 52 32       484 33 31   22       570
1680 1680 CULLMAN REGIONAL MEDICAL CENTER 1912 ALABAMA HIGHWAY 157 CULLMAN AL 35058 CULLMAN (256) 737-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.1985870 -86.8056410 0   43 1 1043 18980 Birmingham-Hoover-Talladega, AL Central Cullman County https://data.medicare.gov/resource/xubh-q36u/row-25az.bw5t.5dxy 10035 659467 2019-11-26 2019-06-30 133 12         145               145
3905 3905 BAYLOR SCOTT & WHITE MEDICAL CENTER- WAXAHACHIE 2400 N INTERSTATE HIGHWAY 35E WAXAHACHIE TX 75165 ELLIS (972) 923-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.4296220 -96.8597360 0   139 48 48139 19100 Dallas-Fort Worth, TX-OK Central Ellis County https://data.medicare.gov/resource/xubh-q36u/row-9ydz_89ap~3znh 450372 659897 2019-11-26 2019-06-30 94 12         106               106
57 57 ST ANTHONY NORTH HEALTH CAMPUS 14300 ORCHARD PKWY WESTMINSTER CO 80023 BROOMFIELD (720) 627-0000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9558100 -104.9936710 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-ids9.66gw~rrbq 60104 659640 2019-11-26 2019-06-30 72 20         92               92
665 665 UCHEALTH BROOMFIELD HOSPITAL 11820 DESTINATION DRIVE BROOMFIELD CO 80021 JEFFERSON (303) 460-6000 Acute Care Hospitals Proprietary TRUE 39.9105000 -105.0932070 0   14 8 8014 19740 Denver-Aurora, CO Central Broomfield County https://data.medicare.gov/resource/xubh-q36u/row-dvb6-rzzd_er2t 60129 661295 2019-11-26 2019-06-30 22           22               22
1380 1380 SKY RIDGE MEDICAL CENTER 10101 RIDGEGATE PARKWAY LONE TREE CO 80124 DOUGLAS (720) 225-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.5293230 -104.8702690 0   35 8 8035 19740 Denver-Aurora, CO Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-qr62~ugzc.jjbq 60112 659642 2019-11-26 2019-06-30 214 30         272               272
2129 2129 CENTURA HEALTH-ST ANTHONY HOSPITAL 11600 WEST 2ND PLC LAKEWOOD CO 80228 JEFFERSON (720) 321-0000 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.7179560 -105.1274940 0   59 8 8059 19740 Denver-Aurora, CO Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-hs5j-ymh4.6b3z 60015 659760 2019-11-26 2019-06-30 144 28     48   220   17           237
2131 2131 ORTHOCOLORADO HOSPITAL AT ST ANTHONY MED CAMPUS 11650 WEST 2ND PLACE LAKEWOOD CO 80228 JEFFERSON (720) 321-5000 Acute Care Hospitals Proprietary TRUE 39.7179520 -105.1284410 0   59 8 8059 19740 Denver-Aurora, CO Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-b3pw~3vk6_q65v 60124 659765 2019-11-26 2019-06-30 48           48               48
3711 3711 ST JOSEPH MERCY OAKLAND 44405 WOODWARD AVE PONTIAC MI 48341 OAKLAND (248) 858-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6149430 -83.2751000 0   125 26 26125 19820 Detroit-Warren-Ann Arbor, MI Central Oakland County https://data.medicare.gov/resource/xubh-q36u/row-nn4m.a4dt-xt98 230029 660576 2019-11-26 2019-06-30 287 32 32     29 380 33 30           443
2186 2186 MERCYONE DUBUQUE MEDICAL CENTER 250 MERCY DRIVE DUBUQUE IA 52001 DUBUQUE (563) 589-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.4931450 -90.6743500 0   61 19 19061 20220   Central Dubuque County https://data.medicare.gov/resource/xubh-q36u/row-852u.y47f-95x9 160069 660083 2019-11-26 2019-06-30 142 8         150   9   20       179
3879 3879 ESSENTIA HEALTH ST MARY'S MEDICAL CENTER 407 EAST THIRD STREET DULUTH MN 55805 ST. LOUIS (218) 786-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.7928430 -92.0963950 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-pkbs_kx6e_rts3 240002 660602 2019-11-26 2019-06-30 179 33 56   11   307               307
2924 2924 LEHIGH VALLEY HOSPITAL - POCONO 206 EAST BROWN STREET EAST STROUDSBURG PA 18301 MONROE (570) 421-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.9922840 -75.1743270 0   89 42 42089 20700 New York-Newark, NY-NJ-CT-PA Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-bken-695p_8igj 390201 660019 2019-11-26 2019-06-30 173 12 12 8     205 20 12           237
796 796 ST JOSEPHS HOSPITAL 2661 COUNTY HWY I CHIPPEWA FALLS WI 54729 CHIPPEWA (715) 717-7200 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.9516610 -91.3582170 0   17 55 55017 20740 Eau Claire-Menomonie, WI Central Chippewa County https://data.medicare.gov/resource/xubh-q36u/row-nahq.4tp8_ghi9 520017 661127 2019-11-26 2019-06-30 96 6         102               102
1447 1447 SACRED HEART HOSPITAL 900 W CLAIREMONT AVE EAU CLAIRE WI 54701 EAU CLAIRE (715) 717-4121 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.7934620 -91.5106560 0   35 55 55035 20740 Eau Claire-Menomonie, WI Central Eau Claire County https://data.medicare.gov/resource/xubh-q36u/row-4e2t_bcw7.5pgk 520013 660730 2019-11-26 2019-06-30 146 14     8   168   24           192
3886 3886 MEDICAL CENTER OF SOUTH ARKANSAS 700 WEST GROVE STREET EL DORADO AR 71730 UNION (870) 863-2000 Acute Care Hospitals Proprietary TRUE 33.2183780 -92.6710300 0   139 5 5139 20980   Central Union County https://data.medicare.gov/resource/xubh-q36u/row-rite-ah8v_bzij 40088 659753 2019-11-26 2019-06-30 95 16         111   20           131
943 943 ST JOSEPH HOSPITAL 2700 DOLBEER ST EUREKA CA 95501 HUMBOLDT (707) 445-8121 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7831030 -124.1420390 0   23 6 6023 21700   Central Humboldt County https://data.medicare.gov/resource/xubh-q36u/row-2tjd-xmnr-if78 50006 662153 2019-11-26 2019-06-30 117 12       5 134   15           149
2389 2389 MEDICAL CENTER OF THE ROCKIES 2500 ROCKY MOUNTAIN AVENUE LOVELAND CO 80538 LARIMER (970) 624-2500 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4151940 -105.0014510 0   69 8 8069 22660   Central Larimer County https://data.medicare.gov/resource/xubh-q36u/row-zpsq-figy~e5ag 60119 659764 2019-11-26 2019-06-30 142 20 12       174               174
2391 2391 POUDRE VALLEY HOSPITAL 1024 S LEMAY AVE FORT COLLINS CO 80524 LARIMER (970) 495-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5737240 -105.0578600 0   69 8 8069 22660   Central Larimer County https://data.medicare.gov/resource/xubh-q36u/row-hg6n.psiu_j6i6 60010 660356 2019-11-26 2019-06-30 188 12       25 225 41 14           280
2003 2003 ST CATHERINE HOSPITAL 401 EAST SPRUCE GARDEN CITY KS 67846 FINNEY (620) 272-2222 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.9688710 -100.8686150 0   55 20 20055 23780   Central Finney County https://data.medicare.gov/resource/xubh-q36u/row-33tn.4j7w~te3s 170023 660221 2019-11-26 2019-06-30 75 8       7 90   10           100
2994 2994 KEARNY COUNTY HOSPITAL 500 THORPE STREET LAKIN KS 67860 KEARNY (620) 355-7111 Critical Access Hospitals Government - Local TRUE 37.9459710 -101.2510360 0   93 20 20093 23780   Outlying Kearny County https://data.medicare.gov/resource/xubh-q36u/row-62du-eigp.wszj 171313 660224 2019-11-26 2019-06-30 25           25         40 35   100
120 120 GETTYSBURG HOSPITAL 147 GETTYS STREET GETTYSBURG PA 17325 ADAMS (717) 334-2121 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.8233170 -77.2340440 0   1 42 42001 23900 Harrisburg-York-Lebanon, PA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-493f.cvfq~sac8 390065 660855 2019-11-26 2019-06-30 68 8         76               76
3597 3597 ESSENTIA HEALTH FOSSTON 900 HILLIGOSS BOULEVARD SE FOSSTON MN 56542 POLK (218) 435-1133 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.5721490 -95.7406070 0   119 27 27119 24220   Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-93pp~c6zp.yfzi 241357 660612 2019-11-26 2019-06-30 24           24       50       74
2701 2701 SPECTRUM HEALTH - BUTTERWORTH CAMPUS 100 MICHIGAN ST NE GRAND RAPIDS MI 49503 KENT (616) 391-1774 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9705270 -85.6653190 0   81 26 26081 24340 Grand Rapids-Wyoming-Muskegon, MI Central Kent County https://data.medicare.gov/resource/xubh-q36u/row-wvf2~fzgf.ud23 230038 660580 2019-11-26 2019-06-30 897 94   8     1095   42   250       1387
2702 2702 METRO HEALTH HOSPITAL 5900 BYRON CENTER AVENUE, SW WYOMING MI 49519 KENT (616) 252-7200 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.8580670 -85.7229370 0   81 26 26081 24340 Grand Rapids-Wyoming-Muskegon, MI Central Kent County https://data.medicare.gov/resource/xubh-q36u/row-hjd9~97p4.t5d2 230236 661017 2019-11-26 2019-06-30 171 16         187           21   208
3558 3558 SPECTRUM HEALTH UNITED HOSPITAL 615 S BOWER STREET GREENVILLE MI 48838 MONTCALM (616) 754-4691 Acute Care Hospitals Voluntary non-profit - Other FALSE 43.1754690 -85.2687810 0   117 26 26117 24340 Grand Rapids-Wyoming-Muskegon, MI Outlying Montcalm County https://data.medicare.gov/resource/xubh-q36u/row-9sd4-nvyr_c2t3 230035 660578 2019-11-26 2019-06-30 41 8         49       39       88
3559 3559 SPECTRUM HEALTH KELSEY HOSPITAL 418 WASHINGTON LAKEVIEW MI 48850 MONTCALM (989) 352-7211 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.4411000 -85.2785160 0   117 26 26117 24340 Grand Rapids-Wyoming-Muskegon, MI Outlying Montcalm County https://data.medicare.gov/resource/xubh-q36u/row-7fqd_gq5t.eh9k 231317 660104 2019-11-26 2019-06-30 12           12       31       43
3893 3893 NORTH OTTAWA COMMUNITY HEALTH SYSTEM 1309 SHELDON RD GRAND HAVEN MI 49417 OTTAWA (616) 842-3600 Acute Care Hospitals Government - Hospital District or Authority TRUE 43.0516100 -86.2279630 0   139 26 26139 24340 Grand Rapids-Wyoming-Muskegon, MI Outlying Ottawa County https://data.medicare.gov/resource/xubh-q36u/row-s2h9-4cnt.tvzd 230174 660593 2019-11-26 2019-06-30 74 7         81               81

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