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 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, 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
836 836 PAUL OLIVER MEMORIAL HOSPITAL 224 PARK AVENUE FRANKFORT MI 49635 BENZIE (231) 352-2200 Critical Access Hospitals Government - Local TRUE 44.6373760 -86.2429130 0   19 26 26019 45900   Outlying Benzie County https://data.medicare.gov/resource/xubh-q36u/row-cypk~xgkd.zsnp 231300 660598 2019-11-26 2019-06-30 8           8       36       44
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
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
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
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
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
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
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
424 424 MOLOKAI GENERAL HOSPITAL 280 HOME OLU PLACE KAUNAKAKAI HI 96748 MAUI (808) 553-5331 Critical Access Hospitals Voluntary non-profit - Private TRUE 21.0937600 -157.0179820 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-vd6b-yn49_x98y 121303 659777 2019-11-26 2019-06-30 15           15               15
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
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
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
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
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
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
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
3007 3007 JAMESTOWN REGIONAL MEDICAL CENTER 2422 20TH ST SW JAMESTOWN ND 58401 STUTSMAN (701) 252-1050 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.8879400 -98.7493770 0   93 38 38093 27420   Central Stutsman County https://data.medicare.gov/resource/xubh-q36u/row-592i~zkzj_6zsv 351335 660000 2019-11-26 2019-06-30 19 6         25               25
894 894 BUENA VISTA REGIONAL MEDICAL CENTER 1525 WEST 5TH STREET STORM LAKE IA 50588 BUENA VISTA (712) 732-4030 Critical Access Hospitals Government - Local TRUE 42.6443560 -95.2220080 0   21 19 19021 44740   Central Buena Vista County https://data.medicare.gov/resource/xubh-q36u/row-prcs~bkcs~7h4s 161375 660220 2019-11-26 2019-06-30 20   5       25 10             35
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
1657 1657 ROOSEVELT GENERAL HOSPITAL 42121 US HIGHWAY 70 PORTALES NM 88130 ROOSEVELT (575) 359-1800 Acute Care Hospitals Government - State TRUE 34.1656650 -103.3681990 0   41 35 35041 38780 Clovis-Portales, NM Central Roosevelt County https://data.medicare.gov/resource/xubh-q36u/row-kycr_dkfp.ev9b 320084 659709 2019-11-26 2019-06-30 20           20               20
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
2191 2191 ASPIRUS KEWEENAW HOSPITAL 205 OSCEOLA LAURIUM MI 49913 HOUGHTON (906) 337-6500 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.2375380 -88.4440380 0   61 26 26061 26340   Central Houghton County https://data.medicare.gov/resource/xubh-q36u/row-p9jg_yiuy~c7z4 231319 660600 2019-11-26 2019-06-30 20 5         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
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
2070 2070 LADY OF THE SEA GENERAL HOSPITAL 200 WEST 134TH PLACE CUT OFF LA 70345 LAFOURCHE (985) 632-6401 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.4567190 -90.3104300 0   57 22 22057 26380   Central Lafourche Parish https://data.medicare.gov/resource/xubh-q36u/row-gtsq-dc99_icfj 191325 659798 2019-11-26 2019-06-30 21 2         23               23
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
3181 3181 AVERA DELLS AREA HOSPITAL - CAH 909 N IOWA AVE DELL RAPIDS SD 57022 MINNEHAHA (605) 428-5431 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.8285880 -96.7153440 0   99 46 46099 43620   Central Minnehaha County https://data.medicare.gov/resource/xubh-q36u/row-9ckr.kcaf_sjek 431331 660036 2019-11-26 2019-06-30 21           21               21
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
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
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
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
4233 4233 CENTRACARE HEALTH - MONTICELLO 1013 HART BOULEVARD MONTICELLO MN 55362 WRIGHT (763) 295-2945 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.3001700 -93.7791070 0   171 27 27171 33460 Minneapolis-St. Paul, MN-WI Central Wright County https://data.medicare.gov/resource/xubh-q36u/row-8yik_ujc7-cau4 241362 660614 2019-11-26 2019-06-30 22 3         25 10     89       124
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
2550 2550 CHRISTUS MOTHER FRANCES HOSPITAL- JACKSONVILLE 2026 S JACKSON STREET JACKSONVILLE TX 75766 CHEROKEE (903) 541-4500 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.9379540 -95.2494290 0   73 48 48073 27380 Tyler-Jacksonville, TX Central Cherokee County https://data.medicare.gov/resource/xubh-q36u/row-g8ft-d3vt-ebpq 451319 659899 2019-11-26 2019-06-30 23           23               23
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
2657 2657 HOLZER MEDICAL CENTER JACKSON 500 BURLINGTON ROAD JACKSON OH 45640 JACKSON (740) 395-8500 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.0326610 -82.6381800 0   79 39 39079 27160   Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-uzg6.66qw~z7aa 361320 660677 2019-11-26 2019-06-30 24           24               24
2726 2726 REGIONAL HEALTH SPEARFISH HOSPITAL 1440 N MAIN ST SPEARFISH SD 57783 LAWRENCE (605) 644-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.4978870 -103.8611360 0   81 46 46081 43940 Rapid City-Spearfish, SD Central Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-nmym.gm8b~ekfn 430048 660032 2019-11-26 2019-06-30 24 3         27               27
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
3979 3979 CENTRACARE HEALTH SYSTEM - SAUK CENTRE 425 NORTH ELM STREET SAUK CENTRE MN 56378 STEARNS (320) 352-2221 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.7458900 -94.9545670 0   145 27 27145 41060 Minneapolis-St. Paul, MN-WI Central Stearns County https://data.medicare.gov/resource/xubh-q36u/row-u3rf_ytjj_n5bm 241368 660615 2019-11-26 2019-06-30 24           24       60       84
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
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
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
1464 1464 CASA COLINA HOSPITAL 255 E BONITA AVE POMONA CA 91767 LOS ANGELES (909) 596-7733 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.0962420 -117.7468610 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-rhgb.p6kp-nbju 50782 662170 2019-11-26 2019-03-31 25 6         31   68           99
1559 1559 ST JOHN SAPULPA, INC 1004 EAST BRYAN SAPULPA OK 74066 CREEK (918) 227-8601 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.9933610 -96.1001920 0   37 40 40037 46140 Tulsa-Muskogee-Bartlesville, OK Central Creek County https://data.medicare.gov/resource/xubh-q36u/row-wvjq.he32_w2jq 371312 659718 2019-11-26 2019-06-30 25           25               25
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
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
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
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
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
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
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
4377 4377 MORRISON COMMUNITY HOSPITAL 303 N JACKSON STREET MORRISON IL 61270 WHITESIDE (815) 772-4003 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.8091310 -89.9565740 0   195 17 17195 44580 Dixon-Sterling, IL Central Whiteside County https://data.medicare.gov/resource/xubh-q36u/row-4w6a~9jyq.qn3s 141329 659494 2019-11-26 2019-06-30 25           25               25
772 772 GILA REGIONAL MEDICAL CENTER 1313 E 32ND ST SILVER CITY NM 88061 GRANT (575) 538-4100 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7955240 -108.2609080 0   17 35 35017 43500   Central Grant County https://data.medicare.gov/resource/xubh-q36u/row-7frq_jm9p~bbxr 320016 659708 2019-11-26 2019-06-30 26 6         32 10             42
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
3794 3794 EXCELA HEALTH FRICK HOSPITAL 508 SOUTH CHURCH STREET MOUNT PLEASANT PA 15666 WESTMORELAND (724) 547-1500 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.1463690 -79.5482170 0   129 42 42129 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Westmoreland County https://data.medicare.gov/resource/xubh-q36u/row-duk2-m779~b9mf 390217 659878 2019-11-26 2019-06-30 27   6       33               33
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
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
431 431 UNIVERSITY OF KS HLTH SYSTEM GREAT BEND CAMPUS 514 CLEVELAND STREET GREAT BEND KS 67530 BARTON (620) 792-8833 Acute Care Hospitals Proprietary TRUE 38.3562000 -98.7916190 0   9 20 20009 24460   Central Barton County https://data.medicare.gov/resource/xubh-q36u/row-ezt6_4fjw-kpxn 170191 660092 2019-11-26 2019-06-30 29 4         33               33
715 715 BELLVILLE ST JOSEPH HEALTH CENTER 44 N CUMMINGS ST BELLVILLE TX 77418 AUSTIN (979) 865-3141 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.9522650 -96.2607470 0   15 48 48015 26420 Houston-The Woodlands, TX Outlying Austin County https://data.medicare.gov/resource/xubh-q36u/row-dtpr-rvr9.rhky 450253 662602 2019-11-26 2019-06-30 32           32               32
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
3962 3962 ST JOHN OWASSO 12451 EAST 100TH STREET NORTH OWASSO OK 74055 TULSA (918) 274-5100 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.2988030 -95.8350660 0   143 40 40143 46140 Tulsa-Muskogee-Bartlesville, OK Central Tulsa County https://data.medicare.gov/resource/xubh-q36u/row-2dqm_3zaf.66yg 370227 660002 2019-11-26 2019-06-30 32           32               32
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
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
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
3193 3193 CENTURA HEALTH-ST MARY CORWIN MEDICAL CENTER 1008 MINNEQUA AVE PUEBLO CO 81004 PUEBLO (719) 557-4000 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.2332110 -104.6227890 0   101 8 8101 39380 Pueblo-Cañon City, CO Central Pueblo County https://data.medicare.gov/resource/xubh-q36u/row-assn-vs45.2w8w 60012 659638 2019-11-26 2019-06-30 36 6         42               42
164 164 WAHIAWA GENERAL HOSPITAL 128 LEHUA STREET WAHIAWA HI 96786 HONOLULU (808) 621-8411 Acute Care Hospitals Voluntary non-profit - Private TRUE 21.4985110 -158.0272990 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-tmp7_2wk5_m9wr 120004 662186 2019-11-26 2019-06-30 37 6         43       107       150
934 934 DIVINE SAVIOR HEALTHCARE 2817 NEW PINERY ROAD PORTAGE WI 53901 COLUMBIA (608) 742-4131 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.5662780 -89.4694450 0   21 55 55021 31540 Madison-Janesville-Beloit, WI Outlying Columbia County https://data.medicare.gov/resource/xubh-q36u/row-qhad~azvf~jeqw 520041 661128 2019-11-26 2019-06-30 37 6         43       83   40   166
3819 3819 TYLER MEMORIAL HOSPITAL 5950 STATE ROUTE 6 WEST TUNKHANNOCK PA 18657 WYOMING (570) 836-2161 Acute Care Hospitals Proprietary TRUE 41.5766510 -75.9698250 0   131 42 42131 42540   Outlying Wyoming County https://data.medicare.gov/resource/xubh-q36u/row-h68k-9niq.fgct 390192 659877 2019-11-26 2019-06-30 38 6         44               44
4535 4535 CHRISTUS SPOHN HOSPITAL KLEBERG 1311 EAST GENERAL CAVAZOS BLVD KINGSVILLE TX 78363 KLEBERG (361) 595-1661 Acute Care Hospitals Voluntary non-profit - Private TRUE 27.4914160 -97.8498310 0   273 48 48273 28780 Corpus Christi-Kingsville-Alice, TX Central Kleberg County https://data.medicare.gov/resource/xubh-q36u/row-epm5-3z7h_ij8i 450163 659896 2019-11-26 2019-06-30 40 10         50               50
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
2137 2137 LAKES REGIONAL HEALTHCARE 2301 HIGHWAY 71 SPIRIT LAKE IA 51360 DICKINSON (712) 336-1230 Acute Care Hospitals Voluntary non-profit - Other TRUE 43.4183960 -95.1263120 0   59 19 19059 44020   Central Dickinson County https://data.medicare.gov/resource/xubh-q36u/row-afjd-chpt.x7ew 160124 660085 2019-11-26 2019-06-30 41   3       44               44
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
1429 1429 AVERA QUEEN OF PEACE 525 N FOSTER MITCHELL SD 57301 DAVISON (605) 995-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.7138420 -98.0073250 0   35 46 46035 33580   Central Davison County https://data.medicare.gov/resource/xubh-q36u/row-vs8d.p4rg.tbmc 430013 660030 2019-11-26 2019-06-30 42 8         50       84       134
2007 2007 UNIVERSITY HOSPITAL & CLINICS 2390 WEST CONGRESS LAFAYETTE LA 70506 LAFAYETTE (337) 261-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2157920 -92.0456750 0   55 22 22055 29180 Lafayette-Opelousas-Morgan City, LA Central Lafayette Parish https://data.medicare.gov/resource/xubh-q36u/row-4gs6.rn2t.zgkk 190006 659954 2019-11-26 2019-06-30 42 10         52               52
4490 4490 CHRISTUS MOTHER FRANCES HOSPITAL SULPHUR SPRINGS 115 AIRPORT RD SULPHUR SPRINGS TX 75482 HOPKINS (903) 885-7671 Acute Care Hospitals Proprietary TRUE 33.1562200 -95.5996480 0   223 48 48223 44860 Dallas-Fort Worth, TX-OK Central Hopkins County https://data.medicare.gov/resource/xubh-q36u/row-k5xf.mj66.grqz 450236 660051 2019-11-26 2019-06-30 42 14         56   6           62
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
2324 2324 AVERA ST MARY'S HOSPITAL 801 E SIOUX PIERRE SD 57501 HUGHES (605) 224-3100 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.3612680 -100.3422350 0   65 46 46065 38180   Central Hughes County https://data.medicare.gov/resource/xubh-q36u/row-y7ep-uymv.yumv 430015 660031 2019-11-26 2019-06-30 44 6         50       80       130
3954 3954 ST JOHN BROKEN ARROW, INC 1000 WEST BOISE CIRCLE BROKEN ARROW OK 74012 TULSA (918) 994-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0768430 -95.8015780 0   143 40 40143 46140 Tulsa-Muskogee-Bartlesville, OK Central Tulsa County https://data.medicare.gov/resource/xubh-q36u/row-adti-zksm.qudi 370235 659860 2019-11-26 2019-06-30 44           44               44
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
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
654 654 METHODIST HOSPITAL SOUTH 1905 HWY 97 EAST JOURDANTON TX 78026 ATASCOSA (830) 769-3515 Acute Care Hospitals Proprietary TRUE 28.9331124 -98.5260352 1 ROOFTOP 13 48 48013 41700   Outlying Atascosa County https://data.medicare.gov/resource/xubh-q36u/row-5vk8_ecmw.2bzr 450165 660714 2019-11-26 2019-06-30 61 6         67               67
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
349 349 WILCOX MEMORIAL HOSPITAL 3-3420 KUHIO HIGHWAY LIHUE HI 96766 KAUAI (808) 245-1103 Acute Care Hospitals Government - Federal TRUE 21.9870430 -159.3661980 0   7 15 15007 28180   Central Kauai County https://data.medicare.gov/resource/xubh-q36u/row-9k2j.d4pk.dvnd 120014 662037 2019-11-26 2019-06-30 65 7         72               72
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
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
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
887 887 COLISEUM NORTHSIDE HOSPITAL 400 CHARTER BOULEVARD MACON GA 31210 BIBB (478) 757-8200 Acute Care Hospitals Proprietary TRUE 32.8698610 -83.6943610 0   21 13 13021 31420 Macon-Warner Robins, GA Central Bibb County https://data.medicare.gov/resource/xubh-q36u/row-qnzt.yc4b~gnii 110201 660371 2019-11-26 2019-06-30 75 10         85               85
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
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
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
947 947 SHANDS LAKE SHORE REGIONAL MEDICAL CENTER 368 NE FRANKLIN ST LAKE CITY FL 32055 COLUMBIA (386) 292-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.1934860 -82.6327040 0   23 12 12023 29380 Gainesville-Lake City, FL Central Columbia County https://data.medicare.gov/resource/xubh-q36u/row-vfpa_f8gy-va3h 100102 660791 2019-11-26 2019-06-30 78 9         87               87
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
827 827 CHRISTUS OCHSNER LAKE AREA HOSPITAL 4200 NELSON ROAD LAKE CHARLES LA 70605 CALCASIEU (337) 474-6370 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.1820710 -93.2493480 0   19 22 22019 29340   Central Calcasieu Parish https://data.medicare.gov/resource/xubh-q36u/row-ziqv.tyfx-mhvz 190201 660808 2019-11-26 2019-06-30 80 8       20 108               108
826 826 CHRISTUS OCHSNER ST PATRICK HOSPITAL 524 DR MICHAEL DEBAKEY STREET LAKE CHARLES LA 70601 CALCASIEU (337) 436-2511 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2154370 -93.2276700 0   19 22 22019 29340   Central Calcasieu Parish https://data.medicare.gov/resource/xubh-q36u/row-574n_fdpb-emzy 190027 659956 2019-11-26 2019-06-30 83 17         100 25 23           148
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

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