hospital_data

Table actions
Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

325 rows where "filed_date" is on date 2019-06-03 sorted by icu_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, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_oth_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-06-03 · 325 ✖
Link rowid hospital_name address city state zip_code county_name phone_number hospital_type hospital_ownership emergency_services lat lng geocode_flag geocode_accuracy countyfips statefips statecountyfips cbsacode csatitle centraloutlyingcounty countyequivalent hosp_lookup_url PRVDR_NUM RPT_REC_NUM filed_date fy_end_date acute_beds icu_beds ▼ coronary_beds burn_beds surg_icu_beds oth_spec_beds subtotal_acute_beds subprovider_ipf_beds subprovider_irf_beds subprovider_oth_beds skilled_nursing_beds nursing_fac_beds oth_longterm_beds hospice_beds all_beds
21 21 HORN MEMORIAL HOSPITAL 701 E 2ND ST IDA GROVE IA 51445 IDA (712) 364-3311 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.3393030 -95.4589100 0   93 19 19093         https://data.medicare.gov/resource/xubh-q36u/row-ct62_kkw5_7j35 161354 649735 2019-06-03 2018-12-31 25           25               25
34 34 FRIO REGIONAL HOSPITAL 200 S IH 35 PEARSALL TX 78061 FRIO (830) 334-3617 Critical Access Hospitals Voluntary non-profit - Private TRUE 28.8970480 -99.1160130 0   163 48 48163         https://data.medicare.gov/resource/xubh-q36u/row-9gys.vgtu~2pyx 451391 650214 2019-06-03 2018-12-31 24           24               24
168 168 THE ORTHOPAEDIC HOSPITAL OF LUTHERAN HEALTH NETWOR 7952 W JEFFERSON BLVD FORT WAYNE IN 46804 ALLEN (260) 435-2999 Acute Care Hospitals Proprietary FALSE 41.0373520 -85.2459180 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-65sn_hsdz_dbbf 150168 649728 2019-06-03 2018-12-31 39           39               39
198 198 BOULDER CITY HOSPITAL 901 ADAMS BLVD BOULDER CITY NV 89005 CLARK (702) 293-4111 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.9683590 -114.8434860 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-m2cb.9j9h-qmdd 291309 651018 2019-06-03 2018-12-31 25           25 10     47       82
216 216 CUBA MEMORIAL HOSPITAL, INC 140 WEST MAIN STREET CUBA NY 14727 ALLEGANY (585) 961-2000 Critical Access Hospitals Voluntary non-profit - Private FALSE 42.2133410 -78.2881390 0   3 36 36003         https://data.medicare.gov/resource/xubh-q36u/row-2ir6~7udp_pyzv 331301 651038 2019-06-03 2018-12-31 20           20       61       81
221 221 INSTITUTE FOR ORTHOPAEDIC SURGERY 801 MEDICAL DRIVE, SUITE B LIMA OH 45804 ALLEN (419) 224-7586 Acute Care Hospitals Proprietary FALSE 40.6985860 -84.0864770 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-kbua_iifb.k5nj 360263 649649 2019-06-03 2018-12-31 12           12               12
249 249 TRI-STATE MEMORIAL HOSPITAL 1221 HIGHLAND AVENUE CLARKSTON WA 99403 ASOTIN (509) 758-5511 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4036380 -117.0545070 0   3 53 53003 30300   Central Asotin County https://data.medicare.gov/resource/xubh-q36u/row-i7hs.ad2c-g7gn 501332 649847 2019-06-03 2018-12-31 25           25               25
257 257 PAGE HOSPITAL 501 NORTH NAVAJO DRIVE PAGE AZ 86040 COCONINO (928) 645-2424 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.9169600 -111.4631860 0   5 4 4005 22380   Central Coconino County https://data.medicare.gov/resource/xubh-q36u/row-pwtm.vez8_t2h2 31304 649070 2019-06-03 2018-12-31 25           25               25
392 392 BENNETT COUNTY HOSPITAL AND NURSING HOME - CAH 102 MAJOR ALLEN POST OFFICE BOX 70D MARTIN SD 57551 BENNETT (605) 685-6622 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.1691630 -101.7266636 1 RANGE_INTERPOLATED 7 46 46007         https://data.medicare.gov/resource/xubh-q36u/row-q2mg~bq2u~fi2w 431314 649823 2019-06-03 2018-12-31 14           14           48   62
397 397 LAKE CHELAN COMMUNITY HOSPITAL 503 EAST HIGHLAND CHELAN WA 98816 CHELAN (509) 682-3300 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.8451390 -120.0105110 0   7 53 53007 48300   Central Chelan County https://data.medicare.gov/resource/xubh-q36u/row-a77p~uq78~jh3e 501334 651089 2019-06-03 2018-12-31 25           25               25
426 426 LANAI COMMUNITY HOSPITAL 628 7TH STREET LANAI CITY HI 96763 MAUI (808) 565-8450 Critical Access Hospitals Government - State TRUE 20.8267350 -156.9180020 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-keiy_dtd7_smny 121305 648608 2019-06-03 2018-12-31 4           4       10       14
427 427 KULA HOSPITAL 100 KEOKEA PLACE KULA HI 96790 MAUI (808) 878-1221 Critical Access Hospitals Government - State TRUE 20.7019940 -156.3570990 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-8svz_bunk-n2za 121308 648609 2019-06-03 2018-12-31 9           9       105       123
456 456 OLEAN GENERAL HOSPITAL 515 MAIN STREET OLEAN NY 14760 CATTARAUGUS (716) 373-2600 Acute Care Hospitals Proprietary TRUE 42.0894480 -78.4269770 0   9 36 36009 36460 Buffalo-Cheektowaga, NY Central Cattaraugus County https://data.medicare.gov/resource/xubh-q36u/row-hkii~eckc~6rgh 330103 650862 2019-06-03 2018-12-31 260           260 14     293       567
524 524 SOUTHWEST HEALTHCARE SERVICES 802 2ND ST NW BOWMAN ND 58623 BOWMAN (701) 523-5265 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1841910 -103.4067130 0   11 38 38011         https://data.medicare.gov/resource/xubh-q36u/row-wb88_am45~hjt8 351313 651048 2019-06-03 2018-12-31 23           23       40       63
572 572 BANNER HEART HOSPITAL 6750 EAST BAYWOOD AVENUE MESA AZ 85206 MARICOPA (480) 854-5050 Acute Care Hospitals Voluntary non-profit - Private FALSE 33.4103780 -111.6852730 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-tx6q_94yb.s344 30105 651582 2019-06-03 2018-12-31 67   44       111               111
573 573 WICKENBURG COMMUNITY HOSPITAL 520 ROSE LANE WICKENBURG AZ 85390 MARICOPA (928) 684-5421 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.9780560 -112.7388250 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-mqi4.ug34.a4ib 31300 649069 2019-06-03 2018-12-31 19           19               19
575 575 DIGNITY HEALTH - ARIZONA GENERAL HOSPITAL 7171 SOUTH 51ST AVENUE LAVEEN AZ 85339 MARICOPA (623) 584-5100 Acute Care Hospitals Proprietary FALSE 33.3806770 -112.1682330 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-6h9g-s46a~aiyi 30136 651169 2019-06-03 2018-12-31 16           16               16
576 576 CORE INSTITUTE SPECIALTY HOSPITAL, THE 6501 NORTH 19TH AVENUE PHOENIX AZ 85015 MARICOPA (602) 795-6020 Acute Care Hospitals Physician FALSE 33.5318370 -112.0996140 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-ymwb.kuwb~xe6j 30108 659179 2019-06-03 2018-12-31 32           32               32
607 607 BIENVILLE MEDICAL CENTER 1175 PINE STREET ARCADIA LA 71001 BIENVILLE (318) 263-4700 Critical Access Hospitals Proprietary TRUE 32.5530850 -92.9157770 0   13 22 22013         https://data.medicare.gov/resource/xubh-q36u/row-ui8b~9pic.2t2z 191320 650142 2019-06-03 2018-12-31 21           21               21
620 620 GREAT FALLS CLINIC HOSPITAL 3010 15TH AVENUE SOUTH GREAT FALLS MT 59405 CASCADE (406) 216-8000 Acute Care Hospitals Proprietary TRUE 47.4877370 -111.2545610 0   13 30 30013 24500   Central Cascade County https://data.medicare.gov/resource/xubh-q36u/row-zzvw_fvcf~g44t 270086 651217 2019-06-03 2018-12-31 20           20               20
643 643 ST CHARLES PRINEVILLE 384 SE COMBS FLAT ROAD PRINEVILLE OR 97754 CROOK (541) 447-6254 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.2980930 -120.8269680 0   13 41 41013 39260 Bend-Redmond-Prineville, OR Central Crook County https://data.medicare.gov/resource/xubh-q36u/row-yy7v_qhni~xpgc 381313 651052 2019-06-03 2018-12-31 16           16               16
656 656 HALQUIST MEMORIAL INPATIENT CENTER 4715 NORTH 15 STREET ARLINGTON VA 22205 ARLINGTON (703) 525-7070 Acute Care Hospitals Voluntary non-profit - Private FALSE 38.8879410 -77.1216690 0   13 51 51013 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Arlington County https://data.medicare.gov/resource/xubh-q36u/row-vmzf.p4zi.8e5f 490129 651083 2019-06-03 2018-12-31                         36   36
660 660 MINNIE HAMILTON HEALTH SYSTEM 186 HOSPITAL DRIVE GRANTSVILLE WV 26147 CALHOUN (304) 354-9244 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.9237960 -81.0918910 0   13 54 54013         https://data.medicare.gov/resource/xubh-q36u/row-2x87.vdzq_mgqw 511303 651093 2019-06-03 2018-12-31 25           25       24       49
691 691 SLEEPY EYE MUNICIPAL HOSPITAL 400 FOURTH AVENUE NORTHWEST SLEEPY EYE MN 56085 BROWN (507) 794-3571 Critical Access Hospitals Government - Local TRUE 44.2993190 -94.7273150 0   15 27 27015 35580 Mankato-New Ulm-North Mankato, MN Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-td5y_avnx_gs7p 241327 651011 2019-06-03 2018-12-31 16           16               16
720 720 COMMUNITY HOSPITAL 2000 CAMPBELL DRIVE TORRINGTON WY 82240 GOSHEN (307) 532-4181 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.0817650 -104.1915090 0   15 56 56015         https://data.medicare.gov/resource/xubh-q36u/row-cdm5.gqxc~vfiz 531307 649980 2019-06-03 2018-12-31 25           25               25
740 740 SPECIALISTS HOSPITAL SHREVEPORT 1500 LINE AVENUE SHREVEPORT LA 71101 CADDO (318) 213-3800 Acute Care Hospitals Physician FALSE 32.4969260 -93.7460460 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-kr9t-dd8q-wfhi 190278 649901 2019-06-03 2018-12-31 15           15               15
785 785 ROTHMAN ORTHOPAEDIC SPECIALTY HOSPITAL LLC 3300 TILLMAN DRIVE BENSALEM PA 19020 BUCKS (215) 244-7400 Acute Care Hospitals Proprietary FALSE 40.1143500 -74.9620930 0   17 42 42017 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Bucks County https://data.medicare.gov/resource/xubh-q36u/row-w5gs-9pze-8zau 390322 649490 2019-06-03 2018-12-31 24           24               24
868 868 MONTGOMERY GENERAL HOSPITAL, INC 401 SIXTH AVENUE MONTGOMERY WV 25136 FAYETTE (304) 442-5151 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.1828780 -81.3247080 0   19 54 54019 13220   Central Fayette County https://data.medicare.gov/resource/xubh-q36u/row-3eev_ya4k~dm4q 511318 651094 2019-06-03 2018-12-31 25           25       44       69
882 882 PIGGOTT COMMUNITY HOSPITAL 216 EAST MAIN STREET PIGGOTT AR 72454 CLAY (870) 598-3881 Critical Access Hospitals Government - Local TRUE 36.3820190 -90.1884430 0   21 5 5021         https://data.medicare.gov/resource/xubh-q36u/row-73yu_ywme-uu8m 41330 649163 2019-06-03 2018-12-31 25           25               25
940 940 CHOCTAW GENERAL HOSPITAL 401 VANITY FAIR LANE, PO BOX 618 BUTLER AL 36904 CHOCTAW (205) 459-9100 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.0937419 -88.2095888 1 ROOFTOP 23 1 1023         https://data.medicare.gov/resource/xubh-q36u/row-cm2u-i8id~q257 11304 651161 2019-06-03 2018-12-31 25           25               25
960 960 H C WATKINS MEMORIAL HOSPITAL INC 605 SOUTH ARCHUSA AVENUE QUITMAN MS 39355 CLARKE (601) 776-6925 Critical Access Hospitals Voluntary non-profit - Other TRUE 32.0312590 -88.7279550 0   23 28 28023 32940   Outlying Clarke County https://data.medicare.gov/resource/xubh-q36u/row-7ipq~zmm9-gyn8 251316 650283 2019-06-03 2018-12-31 25           25               25
989 989 JACKSON MEDICAL CENTER 220 HOSPITAL DRIVE JACKSON AL 36545 CLARKE (251) 246-9021 Acute Care Hospitals Proprietary TRUE 31.5304820 -87.8931800 0   25 1 1025         https://data.medicare.gov/resource/xubh-q36u/row-p276~rdhi_nmej 10128 651157 2019-06-03 2018-12-31 35           35               35
1034 1034 CIMARRON MEMORIAL HOSPITAL 100 SOUTH ELLIS BOISE CITY OK 73933 CIMARRON (580) 544-2501 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.7290550 -102.5175370 0   25 40 40025         https://data.medicare.gov/resource/xubh-q36u/row-9zte.pc9m_addj 371307 650201 2019-06-03 2018-12-31 25           25               25
1042 1042 KANE COUNTY HOSPITAL 355 NORTH MAIN STREET KANAB UT 84741 KANE (435) 644-5811 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.0543240 -112.5285900 0   25 49 49025         https://data.medicare.gov/resource/xubh-q36u/row-g8j5_itr8_6iiy 461309 649842 2019-06-03 2018-12-31 25           25               25
1072 1072 CLAY COUNTY MEDICAL CENTER 617 LIBERTY CLAY CENTER KS 67432 CLAY (785) 632-2144 Critical Access Hospitals Government - Local TRUE 39.3916810 -97.1241960 0   27 20 20027         https://data.medicare.gov/resource/xubh-q36u/row-5isq.mc8m-iybh 171371 650581 2019-06-03 2018-12-31 17           17               17
1087 1087 FULTON MEDICAL CENTER LLC 10 SOUTH HOSPITAL DRIVE FULTON MO 65251 CALLAWAY (573) 642-3376 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8422470 -91.9662020 0   27 29 29027 27620   Outlying Callaway County https://data.medicare.gov/resource/xubh-q36u/row-t6sk_pcec-yuyb 260209 650171 2019-06-03 2018-12-31 18           18 19             37
1130 1130 BAKERSFIELD HEART HOSPITAL 3001 SILLECT AVENUE BAKERSFIELD CA 93308 KERN (661) 316-6000 Acute Care Hospitals Proprietary TRUE 35.3861060 -119.0408470 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-e89i~sm2j_vijv 50724 651182 2019-06-03 2018-12-31 47           47               47
1155 1155 BERTRAND CHAFFEE HOSPITAL 224 EAST MAIN STREET SPRINGVILLE NY 14141 ERIE (716) 592-2871 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.5084840 -78.6592350 0   29 36 36029 15380 Buffalo-Cheektowaga, NY Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-kh2y-a8h3~k7jx 330111 650864 2019-06-03 2018-12-31 21   2       23       80       103
1190 1190 FOUNDATION SURGICAL HOSPITAL OF SAN ANTONIO 9522 HUEBNER ROAD SAN ANTONIO TX 78240 BEXAR (210) 478-5400 Acute Care Hospitals Proprietary TRUE 29.5310350 -98.5925540 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-pvs4~yydr-y7qv 670054 649387 2019-06-03 2018-12-31 20           20               20
1278 1278 SOUTHEASTHEALTH 1701 LACEY ST CAPE GIRARDEAU MO 63701 CAPE GIRARDEAU (573) 334-4822 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3112730 -89.5409360 0   31 29 29031 16020 Cape Girardeau-Sikeston, MO-IL Central Cape Girardeau County https://data.medicare.gov/resource/xubh-q36u/row-3xtx.vgkn~wt2v 260110 650168 2019-06-03 2018-12-31 155           181   13           194
1300 1300 ST CHARLES MADRAS 470 NE A STREET MADRAS OR 97741 JEFFERSON (541) 475-3882 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.6373620 -121.1213580 0   31 41 41031         https://data.medicare.gov/resource/xubh-q36u/row-c49r.t2un~9r3e 381324 651053 2019-06-03 2018-12-31 25           25               25
1305 1305 UNITY MEDICAL CENTER 481 INTERSTATE DRIVE MANCHESTER TN 37355 COFFEE (931) 728-6354 Acute Care Hospitals Physician TRUE 35.4979320 -86.0781410 0   31 47 47031 46100   Central Coffee County https://data.medicare.gov/resource/xubh-q36u/row-7ihq-cddj~pgik 440007 651231 2019-06-03 2018-12-31 49           49               49
1308 1308 PLATTE COUNTY MEMORIAL HOSPITAL 201 14TH STREET WHEATLAND WY 82201 PLATTE (307) 322-3636 Critical Access Hospitals Government - Local TRUE 42.0498100 -104.9602210 0   31 56 56031         https://data.medicare.gov/resource/xubh-q36u/row-xwas~nr7a-7yiz 531305 649858 2019-06-03 2018-12-31 25           25               25
1377 1377 EVERGREEN MEDICAL CENTER 101 CRESTVIEW AVENUE EVERGREEN AL 36401 CONECUH (251) 578-2480 Acute Care Hospitals Proprietary TRUE 31.4312600 -86.9420500 0   35 1 1035         https://data.medicare.gov/resource/xubh-q36u/row-f8ut-az4v~dn63 10148 651159 2019-06-03 2018-12-31 44           44               44
1469 1469 PACIFICA HOSPITAL OF THE VALLEY 9449 SAN FERNANDO RD SUN VALLEY CA 91352 LOS ANGELES (818) 767-3310 Acute Care Hospitals Proprietary TRUE 34.2411340 -118.3956690 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-dhg6-n9an_6w25 50378 650948 2019-06-03 2018-12-31 126   7       133       98       231
1530 1530 OLYMPIA MEDICAL CENTER 5900 WEST OLYMPIC BOULEVARD LOS ANGELES CA 90036 LOS ANGELES (310) 657-5900 Acute Care Hospitals Proprietary FALSE 34.0575270 -118.3598570 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-h6xu_zz9e_g4g4 50742 649703 2019-06-03 2018-12-31 192   12       204               204
1622 1622 KLICKITAT VALLEY HOSPITAL 310 SOUTH ROOSEVELT GOLDENDALE WA 98620 KLICKITAT (509) 773-4022 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.8202390 -120.8122990 0   39 53 53039         https://data.medicare.gov/resource/xubh-q36u/row-hemh_kxtf-bs6t 501316 649846 2019-06-03 2018-12-31 14           14               14
1646 1646 CARROLL COUNTY MEMORIAL HOSPITAL 309 ELEVENTH STREET CARROLLTON KY 41008 CARROLL (502) 732-4321 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.6799040 -85.1693140 0   41 21 21041         https://data.medicare.gov/resource/xubh-q36u/row-ttr6_yqtq-pq69 181310 649240 2019-06-03 2018-12-31 25           25               25
1719 1719 WASHAKIE MEDICAL CENTER 400 SOUTH 15TH STREET WORLAND WY 82401 WASHAKIE (307) 347-3221 Critical Access Hospitals Government - Local TRUE 44.0135560 -107.9484090 0   43 56 56043         https://data.medicare.gov/resource/xubh-q36u/row-wgjq-rwdt.3x58 531306 649859 2019-06-03 2018-12-31 18           18               18
1741 1741 HAYES GREEN BEACH MEMORIAL HOSPITAL 321 E HARRIS STREET CHARLOTTE MI 48813 EATON (517) 543-1050 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.5649280 -84.8318260 0   45 26 26045 29620 Lansing-East Lansing-Owosso, MI Central Eaton County https://data.medicare.gov/resource/xubh-q36u/row-ty8n~pfwz_x66j 231327 649907 2019-06-03 2018-12-31 25           25               25
1863 1863 WOODS AT PARKSIDE,THE 349 OLDE RIDENOUR ROAD COLUMBUS OH 43230 FRANKLIN (614) 471-2552 Acute Care Hospitals Proprietary FALSE 40.0268200 -82.8811560 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-4avu~kmf5~3quj 360247 649648 2019-06-03 2018-12-31 12         38 50               50
1881 1881 OCEAN BEACH HOSPITAL 174 FIRST AVENUE NORTH ILWACO WA 98624 PACIFIC (360) 642-3181 Critical Access Hospitals Government - State TRUE 46.3116960 -124.0433520 0   49 53 53049         https://data.medicare.gov/resource/xubh-q36u/row-6yj2-723x_f5cn 501314 649845 2019-06-03 2018-12-31 25           25               25
1905 1905 OMEGA HOSPITAL, LLC 2525 SEVERN AVENUE METAIRIE LA 70002 JEFFERSON (504) 849-4900 Acute Care Hospitals Proprietary FALSE 29.9991620 -90.1595830 0   51 22 22051 35380 New Orleans-Metairie-Hammond, LA-MS Central Jefferson Parish https://data.medicare.gov/resource/xubh-q36u/row-fybn~uix6_hmgd 190302 649030 2019-06-03 2018-12-31 16           16               16
1964 1964 COOPER COUNTY COMMUNITY HOSPITAL 17651 B HWY BOONVILLE MO 65233 COOPER (660) 882-4100 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9435330 -92.7420750 0   53 29 29053         https://data.medicare.gov/resource/xubh-q36u/row-b8m2_fqek~vure 260004 649916 2019-06-03 2018-12-31 46           46           19   65
1999 1999 NORTHWEST SPECIALTY HOSPITAL 1593 EAST POLSTON AVENUE POST FALLS ID 83854 KOOTENAI (208) 262-2466 Acute Care Hospitals Proprietary FALSE 47.7144100 -116.9244550 0   55 16 16055 17660 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Central Kootenai County https://data.medicare.gov/resource/xubh-q36u/row-68rq_3jru~i59y 130066 649721 2019-06-03 2018-12-31 34           34               34
2019 2019 BOYS TOWN NATIONAL RESEARCH HOSPITAL 555 NORTH 30TH ST OMAHA NE 68131 DOUGLAS (531) 355-6510 Childrens Voluntary non-profit - Private FALSE 41.2645120 -95.9565140 0   55 31 31055 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-i7r7~v26j~9e2t 283300 650175 2019-06-03 2018-12-31 61           61               61
2027 2027 MONROE COMMUNITY HOSPITAL 435 EAST HENRIETTA ROAD ROCHESTER NY 14620 MONROE (585) 760-6500 Acute Care Hospitals Voluntary non-profit - Other FALSE 43.1118560 -77.6160780 0   55 36 36055 40380 Rochester-Batavia-Seneca Falls, NY Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-5bf3_hk4u~74wb 330403 651037 2019-06-03 2018-12-31 5           5       566       571
2123 2123 COLLEGE HOSPITAL COSTA MESA 301 VICTORIA STREET COSTA MESA CA 92627 ORANGE (949) 642-2734 Acute Care Hospitals Proprietary FALSE 33.6526050 -117.9119650 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-3tfg-v7t4-p88q 50543 651370 2019-06-03 2018-12-31 122           122               122
2206 2206 HOSPITAL FOR SPECIAL SURGERY 535 EAST 70TH STREET NEW YORK NY 10021 NEW YORK (212) 606-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7648660 -73.9531280 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-mivw~shdd.xqp7 330270 650876 2019-06-03 2018-12-31 215           215               215
2242 2242 KIT CARSON COUNTY MEMORIAL HOSPITAL 286 16TH ST BURLINGTON CO 80807 KIT CARSON (719) 346-5311 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.3023780 -102.2707110 0   63 8 8063         https://data.medicare.gov/resource/xubh-q36u/row-xqzu-2pvu-xrfj 61313 648525 2019-06-03 2018-12-31 19           19               19
2314 2314 FAXTON-ST LUKE'S HEALTHCARE 1656 CHAMPLIN AVENUE UTICA NY 13503 ONEIDA (315) 798-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.0965919 -75.2761607 1 ROOFTOP 65 36 36065 46540   Central Oneida County https://data.medicare.gov/resource/xubh-q36u/row-r3tm-7qpb~9uvh 330044 650856 2019-06-03 2018-12-31 203   16     12 231   24           255
2387 2387 BANNER FORT COLLINS MEDICAL CENTER 4700 LADY MOON DRIVE FORT COLLINS CO 80528 LARIMER (970) 821-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.5211170 -105.0108850 0   69 8 8069 22660   Central Larimer County https://data.medicare.gov/resource/xubh-q36u/row-t2c3_t3mg_dfjd 60126 652186 2019-06-03 2018-12-31 23           23               23
2388 2388 ESTES PARK MEDICAL CENTER 555 PROSPECT AVE ESTES PARK CO 80517 LARIMER (970) 577-4470 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.3722590 -105.5140880 0   69 8 8069 22660   Central Larimer County https://data.medicare.gov/resource/xubh-q36u/row-3yeq~tw3h-6ggv 61312 649878 2019-06-03 2018-12-31 25           25       60   6   91
2404 2404 JOHN C STENNIS MEMORIAL HOSPITAL 14365 HIGHWAY 16 WEST DE KALB MS 39328 KEMPER (769) 486-1000 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.7768190 -88.6791220 0   69 28 28069 32940   Outlying Kemper County https://data.medicare.gov/resource/xubh-q36u/row-rjr3_kmd7~yci5 251335 650500 2019-06-03 2018-12-31 25           25               25
2464 2464 CHILDRENS HOSPITAL 200 HENRY CLAY AVE NEW ORLEANS LA 70118 ORLEANS (504) 899-9511 Childrens Voluntary non-profit - Private TRUE 29.9173960 -90.1271310 0   71 22 22071 35380 New Orleans-Metairie-Hammond, LA-MS Central Orleans Parish https://data.medicare.gov/resource/xubh-q36u/row-kxvy_6z7u_5sih 193300 650822 2019-06-03 2018-12-31 123           187 34             221
2503 2503 CHILDREN'S HOSPITAL OF ALABAMA 1600 SEVENTH AVENUE SOUTH BIRMINGHAM AL 35233 JEFFERSON (205) 939-9100 Childrens Voluntary non-profit - Private TRUE 33.5032220 -86.8053810 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-nh6w~rxvd~itst 13300 651162 2019-06-03 2018-12-31 193     6     341               341
2522 2522 LINCOLN COMMUNITY HOSPITAL 111 6TH ST HUGO CO 80821 LINCOLN (719) 743-2421 Critical Access Hospitals Voluntary non-profit - Other TRUE 39.1376600 -103.4731590 0   73 8 8073         https://data.medicare.gov/resource/xubh-q36u/row-ur8w~xce7~5xe9 61306 651191 2019-06-03 2018-12-31 15           15       35       50
2532 2532 MONROE SURGICAL HOSPITAL 2408 BROADMOOR BLVD MONROE LA 71201 OUACHITA (318) 410-0002 Acute Care Hospitals Physician FALSE 32.5367710 -92.1022040 0   73 22 22073 33740 Monroe-Ruston-Bastrop, LA Central Ouachita Parish https://data.medicare.gov/resource/xubh-q36u/row-2viy_tht4-abuk 190245 650140 2019-06-03 2018-12-31 10           10               10
2543 2543 HOCKING VALLEY COMMUNITY HOSPITAL 601 STATE ROUTE 664N LOGAN OH 43138 HOCKING (740) 380-8227 Critical Access Hospitals Voluntary non-profit - Other TRUE 39.5475040 -82.4285180 0   73 39 39073 18140 Columbus-Marion-Zanesville, OH Outlying Hocking County https://data.medicare.gov/resource/xubh-q36u/row-4idp_5ask.rtvw 361330 649656 2019-06-03 2018-12-31 21       4   25 10             35
2617 2617 AURELIA OSBORN FOX MEMORIAL HOSPITAL ONE NORTON AVENUE ONEONTA NY 13820 OTSEGO (607) 432-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.4578897 -75.0522916 1 ROOFTOP 77 36 36077 36580   Central Otsego County https://data.medicare.gov/resource/xubh-q36u/row-euch_fijk.5j49 330085 650859 2019-06-03 2018-12-31 60           60       131       191
2624 2624 SURGICAL SPECIALTY CENTER AT COORDINATED HEALTH 1503 CEDAR CREST BOULEVARD ALLENTOWN PA 18104 LEHIGH (610) 871-9110 Acute Care Hospitals Physician FALSE 40.6121900 -75.5327500 0   77 42 42077 10900 New York-Newark, NY-NJ-CT-PA Central Lehigh County https://data.medicare.gov/resource/xubh-q36u/row-ecs5-8dzv.54i7 390321 650522 2019-06-03 2018-12-31 20           20       12       32
2687 2687 MENLO PARK SURGICAL HOSPITAL 570 WILLOW ROAD MENLO PARK CA 94025 SAN MATEO (650) 324-8500 Acute Care Hospitals Voluntary non-profit - Private FALSE 37.4620430 -122.1595170 0   81 6 6081 41860 San Jose-San Francisco-Oakland, CA Central San Mateo County https://data.medicare.gov/resource/xubh-q36u/row-y26q.aad6_zuz4 50754 650662 2019-06-03 2018-12-31 16           16               16
2715 2715 FLUSHING HOSPITAL MEDICAL CENTER 45TH AVENUE AND PARSONS BOULEVARD FLUSHING NY 11355 QUEENS (718) 670-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7556360 -73.8156450 0   81 36 36081 35620 New York-Newark, NY-NJ-CT-PA Central Queens County https://data.medicare.gov/resource/xubh-q36u/row-w85w_2znh-a3jm 330193 650873 2019-06-03 2018-12-31 261         14 275 18     6       299
2772 2772 DAVIS MEDICAL CENTER 812 GORMAN AVENUE ELKINS WV 26241 RANDOLPH (304) 636-3300 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9281590 -79.8531540 0   83 54 54083 21180   Central Randolph County https://data.medicare.gov/resource/xubh-q36u/row-642f_ssk9_qpnt 510030 651091 2019-06-03 2018-12-31 90           90               90
2845 2845 SUTTER MATERNITY & SURGERY CENTER OF SANTA CRUZ 2900 CHANTICLEER AVENUE SANTA CRUZ CA 95065 SANTA CRUZ (831) 477-2200 Acute Care Hospitals Voluntary non-profit - Private FALSE 36.9878650 -121.9781800 0   87 6 6087 42100 San Jose-San Francisco-Oakland, CA Central Santa Cruz County https://data.medicare.gov/resource/xubh-q36u/row-m3f9-8jic~mqpk 50714 650660 2019-06-03 2018-12-31 30           30               30
2848 2848 EAST MORGAN COUNTY HOSPITAL 2400 WEST EDISON STREET BRUSH CO 80723 MORGAN (970) 842-6222 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.2547380 -103.6491780 0   87 8 8087 22820   Central Morgan County https://data.medicare.gov/resource/xubh-q36u/row-33cv-duhz_he5u 61303 649171 2019-06-03 2018-12-31 25           25               25
2856 2856 F W HUSTON MEDICAL CENTER 408 DELAWARE STREET WINCHESTER KS 66097 JEFFERSON (913) 774-4340 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3252310 -95.2704010 0   87 20 20087 45820   Outlying Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-ms4u_ppxf-axv2 171314 649589 2019-06-03 2018-12-31 25           25         38 6   69
2863 2863 NYACK HOSPITAL 160 NORTH MIDLAND AVENUE NYACK NY 10960 ROCKLAND (845) 348-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.0952510 -73.9252530 0   87 36 36087 35620 New York-Newark, NY-NJ-CT-PA Central Rockland County https://data.medicare.gov/resource/xubh-q36u/row-5nre.azih-h35v 330104 650863 2019-06-03 2018-12-31 199         10 209 26             235
2875 2875 THEDACARE MEDICAL CENTER NEW LONDON 1405 MILL ST NEW LONDON WI 54961 WAUPACA (920) 531-2000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3816680 -88.7331240 0   87 55 55087 11540 Appleton-Oshkosh-Neenah, WI Central Outagamie County https://data.medicare.gov/resource/xubh-q36u/row-3ckm-rirg.mkfx 521326 650927 2019-06-03 2018-12-31 25           25               25
2916 2916 CLIFTON FINE HOSPITAL 1014 OSWEGATCHIE TRAIL STAR LAKE NY 13690 ST. LAWRENCE (315) 848-3351 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.1629530 -75.0559640 0   89 36 36089 36300   Central St. Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-4e7w~nndx-wvba 331307 650877 2019-06-03 2018-12-31 20           20               20
2950 2950 MINIMALLY INVASIVE SURGERY HOSPITAL 11217 LAKEVIEW AVENUE LENEXA KS 66219 JOHNSON (913) 322-7401 Acute Care Hospitals Proprietary FALSE 38.9243760 -94.7697050 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-jnfx.rz75-i6pf 170199 649588 2019-06-03 2018-12-31 7       2   9               9
2965 2965 MARY RUTAN HOSPITAL 205 PALMER AVENUE BELLEFONTAINE OH 43311 LOGAN (937) 599-7002 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3689540 -83.7567030 0   91 39 39091 13340 Columbus-Marion-Zanesville, OH Central Logan County https://data.medicare.gov/resource/xubh-q36u/row-u8by-si54-g6yd 360197 649646 2019-06-03 2018-12-31 33   6       39               39
3066 3066 COORDINATED HEALTH ORTHOPEDIC HOSPITAL 2310 HIGHLAND AVENUE BETHLEHEM PA 18017 NORTHAMPTON (610) 691-4300 Acute Care Hospitals Physician FALSE 40.6737620 -75.3654010 0   95 42 42095 10900 New York-Newark, NY-NJ-CT-PA Central Northampton County https://data.medicare.gov/resource/xubh-q36u/row-sc4k-g4c8.mwqt 390314 651057 2019-06-03 2018-12-31 20           20               20
3156 3156 COMMUNITY HOSPITAL OF BREMEN INC 1020 HIGH RD BREMEN IN 46506 MARSHALL (574) 546-2211 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4569400 -86.1579220 0   99 18 18099 38500 South Bend-Elkhart-Mishawaka, IN-MI Central Marshall County https://data.medicare.gov/resource/xubh-q36u/row-q5gf_v2gt_2uuk 151300 649572 2019-06-03 2018-12-31 24           24               24
3165 3165 SOUTHEAST MICHIGAN SURGICAL HOSPITAL 21230 DEQUINDRE ROAD WARREN MI 48091 MACOMB (586) 427-1000 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.4513950 -83.0835600 0   99 26 26099 19820 Detroit-Warren-Ann Arbor, MI Central Macomb County https://data.medicare.gov/resource/xubh-q36u/row-n5cw~k8mz~eeh4 230264 650280 2019-06-03 2018-12-31 13           13               13
3191 3191 SUTTER SURGICAL HOSPITAL - NORTH VALLEY 455 PLUMAS BLVD YUBA CITY CA 95991 SUTTER (530) 749-5700 Acute Care Hospitals Physician FALSE 39.1321670 -121.6136030 0   101 6 6101 49700 Sacramento-Roseville, CA Central Sutter County https://data.medicare.gov/resource/xubh-q36u/row-rm5f.jnvd.d3k4 50766 651185 2019-06-03 2018-12-31 14           14               14
3208 3208 LAIRD HOSPITAL INC 25117 HIGHWAY 15 UNION MS 39365 NESHOBA (601) 774-8214 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.5592070 -89.1025610 0   101 28 28101         https://data.medicare.gov/resource/xubh-q36u/row-68dt.7k6k_jc9z 251322 649458 2019-06-03 2018-12-31 25           25               25
3209 3209 WESTERN MISSOURI MEDICAL CENTER 403 BURKARTH ROAD WARRENSBURG MO 64093 JOHNSON (660) 747-2500 Acute Care Hospitals Government - Hospital District or Authority TRUE 38.7664740 -93.7237010 0   101 29 29101 47660 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-74d6_q73a.h7xv 260097 650167 2019-06-03 2018-12-31 46           46 12             58
3211 3211 OGALLALA COMMUNITY HOSPITAL 2601 NORTH SPRUCE ST OGALLALA NE 69153 KEITH (308) 284-4011 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.1501770 -101.7204470 0   101 31 31101         https://data.medicare.gov/resource/xubh-q36u/row-g68g~zk9i.gtc5 281355 650174 2019-06-03 2018-12-31 18           18               18
3274 3274 RIVER'S EDGE HOSPITAL & CLINIC 1900 NORTH SUNRISE DRIVE ST PETER MN 56082 NICOLLET (507) 934-7602 Critical Access Hospitals Government - Local TRUE 44.3478460 -93.9708750 0   103 27 27103 31860 Mankato-New Ulm-North Mankato, MN Central Nicollet County https://data.medicare.gov/resource/xubh-q36u/row-83di-yjvp_x3zt 241334 649780 2019-06-03 2018-12-31 17           17               17
3349 3349 WHEATLAND MEMORIAL HOSPITAL 530 3RD ST NW HARLOWTON MT 59036 WHEATLAND (406) 632-4351 Critical Access Hospitals Government - Local TRUE 46.4370010 -109.8405050 0   107 30 30107         https://data.medicare.gov/resource/xubh-q36u/row-ttwx.8piz~nq2c 271321 651017 2019-06-03 2018-12-31 25           25               25
3368 3368 FRANCISCAN HEALTH MOORESVILLE 1201 HADLEY RD MOORESVILLE IN 46158 MORGAN (317) 831-1160 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.6093220 -86.3560980 0   109 18 18109 26900 Indianapolis-Carmel-Muncie, IN Central Morgan County https://data.medicare.gov/resource/xubh-q36u/row-9xhw-5asg~b2v8 150057 649894 2019-06-03 2018-12-31 73       10   83               83
3370 3370 LOGAN COUNTY HOSPITAL 211 CHERRY AVENUE OAKLEY KS 67748 LOGAN (785) 672-3211 Critical Access Hospitals Government - Local TRUE 39.1269150 -100.8622790 0   109 20 20109         https://data.medicare.gov/resource/xubh-q36u/row-wi6i-q2iz.xd59 171326 649592 2019-06-03 2018-12-31 25           25           45   70
3400 3400 SSM HEALTH ST ANTHONY HOSPITAL - OKLAHOMA CITY 1000 NORTH LEE AVENUE OKLAHOMA CITY OK 73101 OKLAHOMA (405) 272-7000 Acute Care Hospitals Voluntary non-profit - Church TRUE 35.4777860 -97.5242910 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-muxg_8sv2-fqgg 370037 651421 2019-06-03 2018-12-31 309   48       390 53 18 139         600
3401 3401 OKLAHOMA SPINE HOSPITAL 14101 PARKWAY COMMONS DRIVE OKLAHOMA CITY OK 73134 OKLAHOMA (405) 749-2700 Acute Care Hospitals Physician TRUE 35.6141370 -97.5821240 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-g6tz_y8sg_qryk 370206 648756 2019-06-03 2018-12-31 23           23               23
3454 3454 SAUK PRAIRIE HOSPITAL 260 26TH STREET PRAIRIE DU SAC WI 53578 SAUK (608) 643-3311 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.2877180 -89.7560720 0   111 55 55111 12660 Madison-Janesville-Beloit, WI Central Sauk County https://data.medicare.gov/resource/xubh-q36u/row-egsq~kcsf.jwct 520095 650924 2019-06-03 2018-12-31 36           36               36
3543 3543 THEDACARE MEDICAL CENTER - SHAWANO INC 100 COUNTY RD B SHAWANO WI 54166 SHAWANO (715) 526-2111 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.7616060 -88.6066140 0   115 55 55115 43020 Green Bay-Shawano, WI Central Shawano County https://data.medicare.gov/resource/xubh-q36u/row-qgrf.mty3-fgdf 521346 650929 2019-06-03 2018-12-31 25           25               25
3574 3574 HILL HOSPITAL OF SUMTER COUNTY 751 DERBY DRIVE YORK AL 36925 SUMTER (205) 392-5263 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.4918250 -88.2960810 0   119 1 1119         https://data.medicare.gov/resource/xubh-q36u/row-hxjd.ga7s.xmvj 10138 651158 2019-06-03 2018-12-31 33           33               33
3594 3594 MEADE DISTRICT HOSPITAL 510 EAST CARTHAGE MEADE KS 67864 MEADE (620) 873-2141 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.2854900 -100.3342670 0   119 20 20119         https://data.medicare.gov/resource/xubh-q36u/row-9yc7~mw74.3m9f 171321 649590 2019-06-03 2018-12-31 20           20           45   65
3611 3611 MONTEFIORE MOUNT VERNON HOSPITAL 12 NORTH 7TH AVENUE MOUNT VERNON NY 10550 WESTCHESTER (914) 664-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.9127540 -73.8400110 0   119 36 36119 35620 New York-Newark, NY-NJ-CT-PA Central Westchester County https://data.medicare.gov/resource/xubh-q36u/row-qugr_3mt3.hjg9 330086 650860 2019-06-03 2018-12-31 63           63 22             85

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