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

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

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

View and edit SQL

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

filed_date (date)

  • 2019-12-02 · 305
Link rowid hospital_name address city state zip_code county_name phone_number hospital_type hospital_ownership emergency_services lat lng geocode_flag geocode_accuracy countyfips statefips statecountyfips cbsacode csatitle centraloutlyingcounty countyequivalent hosp_lookup_url ▼ PRVDR_NUM RPT_REC_NUM filed_date fy_end_date acute_beds icu_beds coronary_beds burn_beds surg_icu_beds oth_spec_beds subtotal_acute_beds subprovider_ipf_beds subprovider_irf_beds subprovider_oth_beds skilled_nursing_beds nursing_fac_beds oth_longterm_beds hospice_beds all_beds
4141 ST JOSEPH MERCY CHELSEA 775 S MAIN ST CHELSEA MI 48118 WASHTENAW (734) 475-3911 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3105940 -84.0165710 0   161 26 26161 11460 Detroit-Warren-Ann Arbor, MI Central Washtenaw County https://data.medicare.gov/resource/xubh-q36u/row-28wr-24ws-jf4t 230259 661019 2019-12-02 2019-06-30 91 6         97 30 6           133
3834 PAWNEE COUNTY MEMORIAL HOSPITAL P O BOX 433, 600 I ST PAWNEE CITY NE 68420 PAWNEE (402) 852-2231 Critical Access Hospitals Proprietary TRUE 40.1098396 -96.1532422 1 ROOFTOP 133 31 31133         https://data.medicare.gov/resource/xubh-q36u/row-2ahw-y3eh_6phq 281302 661036 2019-12-02 2019-06-30 17           17               17
4140 ST JOSEPH MERCY HOSPITAL 5301 E HURON RIVER DR ANN ARBOR MI 48106 WASHTENAW (734) 712-3456 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.2618030 -83.6598190 0   161 26 26161 11460 Detroit-Warren-Ann Arbor, MI Central Washtenaw County https://data.medicare.gov/resource/xubh-q36u/row-2ct6~hcva-wfxq 230156 661012 2019-12-02 2019-06-30 389 20 6   20 15 450 24 33           507
2489 HARDIN MEDICAL CENTER 935 WAYNE ROAD SAVANNAH TN 38372 HARDIN (731) 926-8121 Acute Care Hospitals Government - Local TRUE 35.2271300 -88.2303620 0   71 47 47071         https://data.medicare.gov/resource/xubh-q36u/row-2dfc~89p6~kqtc 440109 660709 2019-12-02 2019-06-30 49           49       73       122
3324 CHI ST ALEXIUS HEALTH WILLISTON 1301 15TH AVE W WILLISTON ND 58801 WILLIAMS (701) 774-7400 Critical Access Hospitals Voluntary non-profit - Church TRUE 48.1543320 -103.6454370 0   105 38 38105 48780   Central Williams County https://data.medicare.gov/resource/xubh-q36u/row-2m99~vhsx_qu32 351334 662569 2019-12-02 2019-06-30 25           25               25
3961 SOUTHWESTERN REGIONAL MEDICAL CENTER, INC 10109 EAST 79TH STREET TULSA OK 74133 TULSA (918) 286-5000 Acute Care Hospitals Proprietary TRUE 36.0463390 -95.8642110 0   143 40 40143 46140 Tulsa-Muskogee-Bartlesville, OK Central Tulsa County https://data.medicare.gov/resource/xubh-q36u/row-34zt~qq9g_7fzk 370190 661242 2019-12-02 2019-06-30 27 13         40               40
994 EL CENTRO REGIONAL MEDICAL CENTER 1415 ROSS AVENUE EL CENTRO CA 92243 IMPERIAL (760) 339-7100 Acute Care Hospitals Government - Local TRUE 32.7814980 -115.5686200 0   25 6 6025 20940   Central Imperial County https://data.medicare.gov/resource/xubh-q36u/row-35st~i7ay-x3eh 50045 660164 2019-12-02 2019-06-30 141 20         161               161
1003 UNIVERSITY OF MD HARFORD MEMORIAL HOSPITAL 501 SOUTH UNION AVENUE HAVRE DE GRACE MD 21078 HARFORD (443) 643-3303 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.5434800 -76.0915280 0   25 24 24025 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Outlying Harford County https://data.medicare.gov/resource/xubh-q36u/row-388e~htvc_kuq3 210006 659968 2019-12-02 2019-06-30 77 5         82               82
3878 ESSENTIA HEALTH VIRGINIA 901 9TH STREET NORTH VIRGINIA MN 55792 ST. LOUIS (218) 741-3340 Acute Care Hospitals Government - Local FALSE 47.5307110 -92.5487970 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-39c9_62zv_e3w4 240084 662217 2019-12-02 2019-06-30 40 8         48   16   77       141
1608 PEACE HARBOR MEDICAL CENTER 400 9TH STREET FLORENCE OR 97439 LANE (541) 997-8412 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.9745890 -124.1174640 0   39 41 41039 21660   Central Lane County https://data.medicare.gov/resource/xubh-q36u/row-3bhj~d2nf.qxkv 381316 662244 2019-12-02 2019-06-30 21           21               21
69 ADAIR COUNTY MEMORIAL HOSPITAL 609 SE KENT GREENFIELD IA 50849 ADAIR (641) 743-2123 Critical Access Hospitals Government - Local TRUE 41.3031030 -94.4519270 0   1 19 19001         https://data.medicare.gov/resource/xubh-q36u/row-3dt7_nstz~yhhy 161310 660956 2019-12-02 2019-06-30 25           25               25
3910 OZARK HEALTH 2500 HIGHWAY 65 SOUTH CLINTON AR 72031 VAN BUREN (501) 745-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.5593750 -92.4499130 0   141 5 5141         https://data.medicare.gov/resource/xubh-q36u/row-3ppd-9bg7~xqjh 41313 661137 2019-12-02 2019-06-30 25           25       118       143
2923 ST LUKE'S HOSPITAL - MONROE CAMPUS 100 ST LUKE'S LANE STROUDSBURG PA 18360 MONROE (272) 212-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.9979660 -75.2617860 0   89 42 42089 20700 New York-Newark, NY-NJ-CT-PA Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-3ugy~jvc3-8cge 390330 660303 2019-12-02 2019-06-30 78 12         90               90
4532 PETERSON REGIONAL MEDICAL CENTER 551 HILL COUNTRY DRIVE KERRVILLE TX 78028 KERR (830) 896-4200 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.0449440 -99.1518570 0   265 48 48265 28500   Central Kerr County https://data.medicare.gov/resource/xubh-q36u/row-3z7r_z2w3~jek6 450007 662258 2019-12-02 2019-06-30 72 12         84   26           110
348 SHANDS STARKE REGIONAL MEDICAL CENTER 922 E CALL ST STARKE FL 32091 BRADFORD (904) 368-2300 Critical Access Hospitals Proprietary TRUE 29.9419070 -82.1016500 0   7 12 12007         https://data.medicare.gov/resource/xubh-q36u/row-463i.u2z5-p3cq 101310 660199 2019-12-02 2019-06-30 25           25               25
2518 POMERADO HOSPITAL 15615 POMERADO ROAD POWAY CA 92064 SAN DIEGO (858) 485-6511 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.9968020 -117.0578520 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-4898.b6y5.nvpq 50636 660919 2019-12-02 2019-06-30 79 12       4 95 12     129       236
224 ALLEGHENY VALLEY HOSPITAL 1301 CARLISLE ST NATRONA PA 15065 ALLEGHENY (412) 224-5100 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.6173780 -79.7371060 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-4dpd~v2eh.sr63 390032 660011 2019-12-02 2019-06-30 127 16         143 40 17           200
2312 ROUNDUP MEMORIAL HEALTHCARE 1202 3RD ST W ROUNDUP MT 59072 MUSSELSHELL (406) 323-2301 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.4533500 -108.5463330 0   65 30 30065         https://data.medicare.gov/resource/xubh-q36u/row-4hiv-3ibs~jee7 271346 661357 2019-12-02 2019-06-30 25           25               25
4582 ST LUKES LAKESIDE HOSPITAL 17400 ST LUKES WAY THE WOODLANDS TX 77384 MONTGOMERY (936) 266-4055 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.2031320 -95.4594820 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-4i3k-4nqm~yxpg 670059 661450 2019-12-02 2019-06-30 30           30               30
1927 UNIONTOWN HOSPITAL 500 WEST BERKELEY STREET UNIONTOWN PA 15401 FAYETTE (724) 430-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.9019960 -79.7376190 0   51 42 42051 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Outlying Fayette County https://data.medicare.gov/resource/xubh-q36u/row-4jjp-v8ik-skbv 390041 660291 2019-12-02 2019-06-30 134 15         149   11           160
174 ALLEN PARISH HOSPITAL 108 6TH AVENUE KINDER LA 70648 ALLEN (337) 738-2527 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.4914530 -92.8556480 0   3 22 22003         https://data.medicare.gov/resource/xubh-q36u/row-572u~e5cv~bbuy 190133 659958 2019-12-02 2019-06-30 25           25 24             49
4723 UNIVERSITY OF MARYLAND MEDICAL CENTER 22 SOUTH GREENE STREET BALTIMORE MD 21201 BALTIMORE CITY (410) 328-8667 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.2874700 -76.6235770 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-582q-qwn8.masy 210002 659966 2019-12-02 2019-06-30 482 115 46     19 829               829
183 BERKSHIRE MEDICAL CENTER INC - 1 725 NORTH STREET PITTSFIELD MA 1201 BERKSHIRE (413) 447-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.4587480 -73.2490040 0   3 25 25003 38340   Central Berkshire County https://data.medicare.gov/resource/xubh-q36u/row-58b2-r4te.ddyn 220046 661336 2019-12-02 2018-09-30 201 20         221 40 14           275
281 UNIVERSITY OF MD ST JOSEPH MEDICAL CENTER 7601 OSLER DRIVE TOWSON MD 21204 BALTIMORE (410) 337-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.3881230 -76.6132780 0   5 24 24005 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore County https://data.medicare.gov/resource/xubh-q36u/row-59yk_i6nr~wdpv 210063 660231 2019-12-02 2019-06-30 181 28 9     20 238               238
3731 MONONGAHELA VALLEY HOSPITAL 1163 COUNTRY CLUB ROAD MONONGAHELA PA 15063 WASHINGTON (724) 258-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.1815780 -79.9162760 0   125 42 42125 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-5a5f~iiza.885p 390147 660017 2019-12-02 2019-06-30 116 8 8       132 20 15           167
1836 DALLAS COUNTY HOSPITAL 610 TENTH STREET PERRY IA 50220 DALLAS (515) 465-3547 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.8339590 -94.0944690 0   49 19 19049 19780 Des Moines-Ames-West Des Moines, IA Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-5ca8_jqfe~mw9b 161322 660961 2019-12-02 2019-06-30 25           25               25
1245 PRESENCE SAINT JOSEPH HOSPITAL - CHICAGO 2900 NORTH LAKE SHORE DRIVE CHICAGO IL 60657 COOK (773) 665-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.9339280 -87.6364180 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-5jgf-ct8j~vsky 140224 661871 2019-12-02 2019-06-30 258 19         277   10   26       313
4634 TEXAS HEALTH HARRIS METHODIST FORT WORTH 1301 PENNSYLVANIA AVENUE FORT WORTH TX 76104 TARRANT (817) 250-2100 Acute Care Hospitals Voluntary non-profit - Church TRUE 32.7384800 -97.3393130 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-5nda.skwh.p2ty 450135 661412 2019-12-02 2018-09-30 500 22 12       662               662
4349 ST LUKE'S DES PERES HOSPITAL 2345 DOUGHERTY FERRY ROAD SAINT LOUIS MO 63122 ST. LOUIS (314) 966-9100 Acute Care Hospitals Proprietary TRUE 38.5810810 -90.4504080 0   189 29 29189 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-5nye-gh7e~2ki5 260176 660117 2019-12-02 2019-06-30 78 10         88               88
3356 AVERA GETTYSBURG HOSPITAL 606 EAST GARFIELD GETTYSBURG SD 57442 POTTER (605) 765-2480 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.0135510 -99.9481280 0   107 46 46107         https://data.medicare.gov/resource/xubh-q36u/row-5ptc-f9a4-vq7p 431302 660878 2019-12-02 2019-06-30 10           10           50   60
3382 CHI HEALTH NEBRASKA HEART 7500 SOUTH 91ST ST LINCOLN NE 68526 LANCASTER (402) 327-2700 Acute Care Hospitals Voluntary non-profit - Private FALSE 40.7354760 -96.5946070 0   109 31 31109 30700 Lincoln-Beatrice, NE Central Lancaster County https://data.medicare.gov/resource/xubh-q36u/row-67wg.v8ba~v3dn 280128 661034 2019-12-02 2019-06-30 54           54               54
1665 CARLISLE REGIONAL MEDICAL CENTER 361 ALEXANDER SPRING ROAD CARLISLE PA 17015 CUMBERLAND (717) 249-1212 Acute Care Hospitals Proprietary TRUE 40.1847670 -77.2230070 0   41 42 42041 25420 Harrisburg-York-Lebanon, PA Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-6ch7-p7nq-3tnd 390058 661966 2019-12-02 2019-06-30 56 10         66   14           80
3706 KNOXVILLE HOSPITAL & CLINICS 1002 SOUTH LINCOLN STREET KNOXVILLE IA 50138 MARION (641) 842-2151 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.3109860 -93.1095110 0   125 19 19125         https://data.medicare.gov/resource/xubh-q36u/row-6isd~id7e-3xdw 161355 660980 2019-12-02 2019-06-30 25           25               25
3552 LUCAS COUNTY HEALTH CENTER 1200 NORTH 7TH STREET CHARITON IA 50049 LUCAS (641) 774-3000 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.0276930 -93.3034210 0   117 19 19117         https://data.medicare.gov/resource/xubh-q36u/row-6kae-djtk-d35x 161341 660973 2019-12-02 2019-06-30 25           25               25
2323 PUNXSUTAWNEY AREA HOSPITAL 81 HILLCREST DRIVE PUNXSUTAWNEY PA 15767 JEFFERSON (814) 938-1800 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.9601530 -79.0003590 0   65 42 42065         https://data.medicare.gov/resource/xubh-q36u/row-6q8y-is36.pc3n 390199 661098 2019-12-02 2019-06-30 39 5         44               44
2240 SENECA DISTRICT HOSPITAL 130 BRENTWOOD DRIVE CHESTER CA 96020 PLUMAS (530) 258-2121 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.3053020 -121.2340180 0   63 6 6063         https://data.medicare.gov/resource/xubh-q36u/row-6rw5.c6e6.9puv 51327 661143 2019-12-02 2019-06-30 10           10       16       26
2157 DAVIE MEDICAL CENTER 223 HOSPITAL STREET MOCKSVILLE NC 27028 DAVIE (336) 751-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.9000100 -80.5700970 0   59 37 37059 49180 Greensboro--Winston-Salem--High Point, NC Central Davie County https://data.medicare.gov/resource/xubh-q36u/row-6uy2-xp88~p8f2 340187 661371 2019-12-02 2019-06-30 18           18               18
1208 ASCENSION ST VINCENT'S RIVERSIDE 1 SHIRCLIFF WAY JACKSONVILLE FL 32204 DUVAL (904) 308-7300 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.3078910 -81.6891540 0   31 12 12031 27260 Jacksonville-St. Marys-Palatka, FL-GA Central Duval County https://data.medicare.gov/resource/xubh-q36u/row-6ygg.pivg~t9br 100040 660790 2019-12-02 2019-06-30 418 29 14   8 10 479               479
3814 CHI HEALTH ST MARY'S 1301 GRUNDMAN BLVD NEBRASKA CITY NE 68410 OTOE (402) 873-3321 Critical Access Hospitals Voluntary non-profit - Church TRUE 40.6581520 -95.8621090 0   131 31 31131         https://data.medicare.gov/resource/xubh-q36u/row-6z57~cf6y.zams 281342 661042 2019-12-02 2019-06-30 18           18               18
681 BOONE COUNTY HOSPITAL 1015 UNION STREET BOONE IA 50036 BOONE (515) 432-3140 Critical Access Hospitals Government - Local TRUE 42.0555830 -93.8770370 0   15 19 19015 14340 Des Moines-Ames-West Des Moines, IA Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-6zpe~cgwm_xs5p 161372 660987 2019-12-02 2019-06-30 25           25               25
3101 FAIRBANKS 8102 CLEARVISTA PARKWAY INDIANAPOLIS IN 46256 MARION (317) 849-8222 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.9028140 -86.0392840 0   97 18 18097 26900 Indianapolis-Carmel-Muncie, IN Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-74bs~yakd.ww2f 150179 660944 2019-12-02 2019-06-30 86           86               86
1518 ALHAMBRA HOSPITAL MEDICAL CENTER 100 S RAYMOND AVE ALHAMBRA CA 91801 LOS ANGELES (626) 570-1606 Acute Care Hospitals Proprietary FALSE 34.0901560 -118.1450170 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-75jx-8uav_n2er 50281 660918 2019-12-02 2019-06-30 88 13         101   17   26       144
2506 PALOMAR HEALTH DOWNTOWN CAMPUS 555 EAST VALLEY PARKWAY ESCONDIDO CA 92025 SAN DIEGO (760) 739-3000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.1259370 -117.0761860 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-75ug~bcqe_4ycp 50115 660353 2019-12-02 2019-06-30 238 48         286 25 18           329
3354 ST LUKE'S MINERS MEMORIAL HOSPITAL 360 W RUDDLE STREET COALDALE PA 18218 SCHUYLKILL (570) 645-2131 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8216190 -75.9141520 0   107 42 42107 39060   Central Schuylkill County https://data.medicare.gov/resource/xubh-q36u/row-76b8.z6ge.sdg4 390183 660297 2019-12-02 2019-06-30 43 6         49       48       97
4425 CHI ST LUKE'S HEALTH BAYLOR COLLEGE OF MEDICINE ME 7200 CAMBRIDGE, 11TH FLOOR HOUSTON TX 77030 HARRIS (832) 355-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 29.6988180 -95.3938620 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-77i8-gn8q~45g2 450193 661413 2019-12-02 2019-06-30 475 144 18       637   24           661
118 MEMORIAL HOSPITAL 1401 WEST LOCUST STILWELL OK 74960 ADAIR (918) 696-3101 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.8085290 -94.6430100 0   1 40 40001         https://data.medicare.gov/resource/xubh-q36u/row-7atr.sncy~icbf 370178 660001 2019-12-02 2019-06-30 30           30 10             40
609 CARROLL HOSPITAL CENTER 200 MEMORIAL AVENUE WESTMINSTER MD 21157 CARROLL (410) 848-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.5561350 -76.9916550 0   13 24 24013 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Outlying Carroll County https://data.medicare.gov/resource/xubh-q36u/row-7ctx.mcs5~ru72 210033 659802 2019-12-02 2019-06-30 141 12         153               153
1871 MILLCREEK COMMUNITY HOSPITAL 5515 PEACH STREET ERIE PA 16509 ERIE (814) 864-4031 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0741410 -80.0937350 0   49 42 42049 21500 Erie-Meadville, PA Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-7pay_34ik.2q7y 390198 660148 2019-12-02 2019-06-30 124 6         130 23 14           167
17 VAN DIEST MEDICAL CENTER 2350 HOSPITAL DRIVE WEBSTER CITY IA 50595 HAMILTON (515) 832-9400 Critical Access Hospitals Government - Local TRUE 42.4529630 -93.8134850 0   79 19 19079         https://data.medicare.gov/resource/xubh-q36u/row-89tb_yu6c_zwc4 161361 660984 2019-12-02 2019-06-30 25           25               25
4106 ST JUDE CHILDRENS RESEARCH HOSPITAL 262 DANNY THOMAS PLACE MEMPHIS TN 38105 SHELBY (901) 495-3300 Childrens Voluntary non-profit - Private FALSE 35.1545600 -90.0425300 0   157 47 47157 32820 Memphis-Forrest City, TN-MS-AR Central Shelby County https://data.medicare.gov/resource/xubh-q36u/row-8bmc~acqt~mywf 443302 662074 2019-12-02 2019-06-30                              
235 ALLEGHENY GENERAL HOSPITAL 320 EAST NORTH AVENUE PITTSBURGH PA 15212 ALLEGHENY (412) 359-3131 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4561490 -80.0032490 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-8eek-ck8y_3ey7 390050 661092 2019-12-02 2019-06-30 430 28 24   24 24 552               552
2024 CHI HEALTH CREIGHTON UNIVERSITY MEDICAL CENTER - B 7500 MERCY RD OMAHA NE 68124 DOUGLAS (402) 398-6060 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2379040 -96.0287170 0   55 31 31055 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-8r2j-deyz-snt5 280060 661548 2019-12-02 2019-06-30 297 52         385               385
71 HOWARD UNIVERSITY HOSPITAL 2041 GEORGIA AVE NW WASHINGTON DC 20060 THE DISTRICT (202) 745-6100 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9170110 -77.0218960 0   1 11 11001 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central District of Columbia https://data.medicare.gov/resource/xubh-q36u/row-8v26.mgb3_zc6i 90003 660921 2019-12-02 2019-06-30 164 36         200               200
744 RUMFORD HOSPITAL 420 FRANKLIN STREET RUMFORD ME 4276 OXFORD (207) 369-1000 Critical Access Hospitals Proprietary TRUE 44.5517210 -70.5571710 0   17 23 23017         https://data.medicare.gov/resource/xubh-q36u/row-923a_kexq.nxfx 201306 662536 2019-12-02 2019-06-30 25           25               25
3578 ST VINCENT MEDICAL CENTER/NORTH 2215 WILDWOOD AVENUE SHERWOOD AR 72120 PULASKI (501) 552-7100 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.8143780 -92.2075140 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-92it.v7ju~ja3t 40137 659915 2019-12-02 2019-06-30 45 14         59               59
1827 FULTON COUNTY HOSPITAL 679 NORTH MAIN STREET SALEM AR 72576 FULTON (870) 895-2691 Critical Access Hospitals Voluntary non-profit - Other TRUE 36.3833590 -91.8112030 0   49 5 5049         https://data.medicare.gov/resource/xubh-q36u/row-9b6n-wd2m.b7tm 41322 660913 2019-12-02 2019-06-30 25           25               25
1141 UMD SHORE MEDICAL CTR AT CHESTERTOWN 100 BROWN STREET CHESTERTOWN MD 21620 KENT (410) 778-7668 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.2168450 -76.0644920 0   29 24 24029         https://data.medicare.gov/resource/xubh-q36u/row-9gun.f2aw-guni 210030 660229 2019-12-02 2019-06-30 15 6         21               21
995 PIONEERS MEMORIAL HEALTHCARE DISTRICT 207 WEST LEGION ROAD BRAWLEY CA 92227 IMPERIAL (760) 351-3333 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.9599470 -115.5527230 0   25 6 6025 20940   Central Imperial County https://data.medicare.gov/resource/xubh-q36u/row-9jqy.yukk~78kt 50342 662026 2019-12-02 2019-06-30 99 8         107               107
3588 ST JOSEPH'S HOSPITAL 12866 TROXLER AVENUE HIGHLAND IL 62249 MADISON (618) 651-2600 Critical Access Hospitals Voluntary non-profit - Church TRUE 38.7570770 -89.6673580 0   119 17 17119 41180 St. Louis-St. Charles-Farmington, MO-IL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-9pm4-6ca4.6gzh 141336 661881 2019-12-02 2019-06-30 25           25               25
283 NORTHWEST HOSPITAL CENTER 5401 OLD COURT ROAD RANDALLSTOWN MD 21133 BALTIMORE (410) 521-2200 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.3592080 -76.7829440 0   5 24 24005 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore County https://data.medicare.gov/resource/xubh-q36u/row-9r5m~8jqt~yezb 210040 661193 2019-12-02 2019-06-30 173 16         189       39       228
504 VIRGINIA GAY HOSPITAL 502 NORTH 9TH AVENUE VINTON IA 52349 BENTON (319) 472-6200 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1736740 -92.0133850 0   11 19 19011 16300 Cedar Rapids-Iowa City, IA Outlying Benton County https://data.medicare.gov/resource/xubh-q36u/row-9sfp.7tdh~i4z3 161349 660977 2019-12-02 2019-06-30 25           25           40   65
1693 GUTTENBERG MUNICIPAL HOSPITAL 200 MAIN STREET GUTTENBERG IA 52052 CLAYTON (563) 252-1121 Critical Access Hospitals Government - Local TRUE 42.7855480 -91.0999540 0   43 19 19043         https://data.medicare.gov/resource/xubh-q36u/row-9vtm.kuer.r3a9 161312 660958 2019-12-02 2019-06-30 25           25               25
2738 LOMPOC VALLEY MEDICAL CENTER 1515 E OCEAN AVENUE LOMPOC CA 93436 SANTA BARBARA (805) 737-3300 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6406390 -120.4398990 0   83 6 6083 42200   Central Santa Barbara County https://data.medicare.gov/resource/xubh-q36u/row-9waa-2p9w-xqwe 50110 660915 2019-12-02 2019-06-30 54 6         60       110       170
1779 CRAWFORD COUNTY MEMORIAL HOSPITAL 100 MEDICAL PARKWAY DENISON IA 51442 CRAWFORD (712) 265-2500 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.0232570 -95.3770860 0   47 19 19047         https://data.medicare.gov/resource/xubh-q36u/row-9ydn-ts52-gjkc 161369 660986 2019-12-02 2019-06-30 25           25               25
1101 MOUNT NITTANY MEDICAL CENTER 1800 EAST PARK AVE STATE COLLEGE PA 16803 CENTRE (814) 231-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8204750 -77.8481010 0   27 42 42027 44300 State College-DuBois, PA Central Centre County https://data.medicare.gov/resource/xubh-q36u/row-a5fc.bvy3-y467 390268 661255 2019-12-02 2019-06-30 248           248 12             260
1569 METRO NASHVILLE GENERAL HOSPITAL 1818 ALBION STREET NASHVILLE TN 37208 DAVIDSON (615) 341-4490 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.1661350 -86.8063270 0   37 47 47037 34980 Nashville-Davidson--Murfreesboro, TN Central Davidson County https://data.medicare.gov/resource/xubh-q36u/row-a69p-t6hu-kymt 440111 661105 2019-12-02 2019-06-30 82 22         114               114
4076 CHI HEALTH MERCY COUNCIL BLUFFS 800 MERCY DRIVE COUNCIL BLUFFS IA 51503 POTTAWATTAMIE (712) 328-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2696360 -95.8382010 0   155 19 19155 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Pottawattamie County https://data.medicare.gov/resource/xubh-q36u/row-abwm_b2ah-p5iq 160028 661174 2019-12-02 2019-06-30 129 16         145               145
3327 UPMC COLE 1001 EAST SECOND STREET COUDERSPORT PA 16915 POTTER (814) 274-9301 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.7706670 -77.9797410 0   105 42 42105         https://data.medicare.gov/resource/xubh-q36u/row-addx-8ax4.us6v 391313 662251 2019-12-02 2019-06-30 21 4         25       44       69
4720 SINAI HOSPITAL OF BALTIMORE 2401 WEST BELVEDERE AVENUE BALTIMORE MD 21215 BALTIMORE CITY (410) 601-5131 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.3546450 -76.6623300 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-ajbq.evsh~bhm9 210012 661002 2019-12-02 2019-06-30 362 35       15 418               418
2162 WASHINGTON HEALTH SYSTEM GREENE 350 BONAR AVENUE WAYNESBURG PA 15370 GREENE (724) 627-2602 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9006050 -80.1739290 0   59 42 42059         https://data.medicare.gov/resource/xubh-q36u/row-an6b-ia9u-kxvy 390150 662137 2019-12-02 2019-06-30 23           23               23
926 CONEMAUGH MINERS MEDICAL CENTER 290 HAIDA AVENUE HASTINGS PA 16646 CAMBRIA (814) 247-3100 Acute Care Hospitals Proprietary TRUE 40.6589130 -78.7057990 0   21 42 42021 27780 Johnstown-Somerset, PA Central Cambria County https://data.medicare.gov/resource/xubh-q36u/row-atm6_mxu4.8ec2 390130 660860 2019-12-02 2019-06-30 25 5         30               30
3987 COMMUNITY HOSPITAL P O BOX 1328, 1301 EAST H ST MCCOOK NE 69001 RED WILLOW (308) 344-2650 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.2004042 -100.6317977 1 ROOFTOP 145 31 31145         https://data.medicare.gov/resource/xubh-q36u/row-b3ww-n6dr.gmwh 281363 661048 2019-12-02 2019-06-30 25           25               25
226 HERITAGE VALLEY SEWICKLEY 720 BLACKBURN ROAD SEWICKLEY PA 15143 ALLEGHENY (412) 741-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5435230 -80.1787560 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-b5j5.fw3x_aya4 390037 659866 2019-12-02 2019-06-30 104 12         116 14             130
632 UNIVERSITY HOSPITAL 150 BERGEN ST NEWARK NJ 7101 ESSEX (973) 972-5658 Acute Care Hospitals Government - State TRUE 40.7409500 -74.1921300 0   13 34 34013 35620 New York-Newark, NY-NJ-CT-PA Central Essex County https://data.medicare.gov/resource/xubh-q36u/row-b5qq_ap3x-6s92 310119 661058 2019-12-02 2019-06-30 266 41 6       355               355
1686 ELMHURST MEMORIAL HOSPITAL 155 EAST BRUSH HILL ROAD ELMHURST IL 60126 DU PAGE (331) 221-0130 Acute Care Hospitals Proprietary TRUE 41.8616840 -87.9342950 0   43 17 17043 16980 Chicago-Naperville, IL-IN-WI Central DuPage County https://data.medicare.gov/resource/xubh-q36u/row-bbi9~mwsc~myn8 140200 661499 2019-12-02 2019-06-30 247 35         282               282
171 CHI HEALTH - MERCY CORNING 603 ROSARY DRIVE CORNING IA 50841 ADAMS (641) 322-3121 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.9883750 -94.7479140 0   3 19 19003         https://data.medicare.gov/resource/xubh-q36u/row-bgwm_q3kt_uw3g 161304 661177 2019-12-02 2019-06-30 22           22               22
272 GREENVILLE REGIONAL HOSPITAL 200 HEALTH CARE DR GREENVILLE IL 62246 BOND (618) 664-1230 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9018800 -89.4086770 0   5 17 17005 41180 St. Louis-St. Charles-Farmington, MO-IL Outlying Bond County https://data.medicare.gov/resource/xubh-q36u/row-byrn_qvzg.2pup 140137 660929 2019-12-02 2019-06-30 32           32 10             42
2904 REGIONAL HEALTH SERVICES OF HOWARD COUNTY 235 8TH AVENUE WEST CRESCO IA 52136 HOWARD (563) 547-2101 Critical Access Hospitals Government - Local TRUE 43.3818910 -92.1177640 0   89 19 19089         https://data.medicare.gov/resource/xubh-q36u/row-cg3w~i3hb_y7gu 161328 660965 2019-12-02 2019-06-30 18           18           1   19
1706 PINNACLE HEALTH HOSPITALS 409 SOUTH SECOND STREET HARRISBURG PA 17105 DAUPHIN (717) 782-5181 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.2562580 -76.8753290 0   43 42 42043 25420 Harrisburg-York-Lebanon, PA Central Dauphin County https://data.medicare.gov/resource/xubh-q36u/row-ciar-qnzv_q7gb 390067 660439 2019-12-02 2019-06-30 433 20 11     29 493               493
3201 JEFFERSON COUNTY HEALTH CENTER 2000 S MAIN FAIRFIELD IA 52556 JEFFERSON (641) 472-4111 Critical Access Hospitals Government - Local TRUE 40.9856350 -91.9631180 0   101 19 19101 21840   Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-cksn~64fu_7y3h 161364 660985 2019-12-02 2019-06-30 25           25               25
711 ROBERT PACKER HOSPITAL ONE GUTHRIE SQUARE SAYRE PA 18840 BRADFORD (570) 888-6666 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9800398 -76.5206811 1 ROOFTOP 15 42 42015 42380   Central Bradford County https://data.medicare.gov/resource/xubh-q36u/row-cnez.nadf_i4pk 390079 661095 2019-12-02 2019-06-30 212 38         250               250
2717 HIGH POINT REGIONAL HOSPITAL 601 N ELM ST HIGH POINT NC 27261 GUILFORD (336) 878-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.9624860 -80.0120270 0   81 37 37081 24660 Greensboro--Winston-Salem--High Point, NC Central Guilford County https://data.medicare.gov/resource/xubh-q36u/row-cqap_seaa~zbqk 340004 661368 2019-12-02 2019-06-30 256 24 8       288   16           304
3106 JACKSON COUNTY REGIONAL HEALTH CENTER 700 W GROVE ST MAQUOKETA IA 52060 JACKSON (563) 652-2474 Critical Access Hospitals Government - Local TRUE 42.0737150 -90.6731320 0   97 19 19097         https://data.medicare.gov/resource/xubh-q36u/row-cqwp_hqw2.ikei 161329 660966 2019-12-02 2019-06-30 25           25               25
240 UPMC MERCY 1400 LOCUST STREET PITTSBURGH PA 15219 ALLEGHENY (412) 232-8111 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4368310 -79.9856230 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-csxe~5v2n_c3hc 390028 660436 2019-12-02 2019-06-30 307 20       24 369   76           445
4186 MYRTUE MEDICAL CENTER 1213 GARFIELD AVENUE HARLAN IA 51537 SHELBY (712) 755-5161 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.6474730 -95.3262020 0   165 19 19165         https://data.medicare.gov/resource/xubh-q36u/row-cvsd.wj8m_w54b 161374 660988 2019-12-02 2019-06-30 25           25               25
2652 PRAIRIE COMMUNITY HOSPITAL 312 S ADAMS TERRY MT 59349 PRAIRIE (406) 635-5511 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.7915060 -105.3159970 0   79 30 30079         https://data.medicare.gov/resource/xubh-q36u/row-cwxm-q75h-madz 271309 660253 2019-12-02 2019-06-30 22           22               22
266 NANTICOKE MEMORIAL HOSPITAL 801 MIDDLEFORD RD SEAFORD DE 19973 SUSSEX (302) 629-6611 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.6423320 -75.6053250 0   5 10 10005 41540   Central Sussex County https://data.medicare.gov/resource/xubh-q36u/row-daqn-dq9w~qe8k 80006 659920 2019-12-02 2019-06-30 85 9         94               94
4564 WAYNE MEMORIAL HOSPITAL 865 SOUTH FIRST STREET JESUP GA 31545 WAYNE (912) 530-3302 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.6029520 -81.8990940 0   305 13 13305 27700   Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-de2e.7sgx-hidy 110124 660369 2019-12-02 2019-06-30 76 12         88               88
1794 GOTHENBURG MEMORIAL HOSPITAL 910 20TH ST GOTHENBURG NE 69138 DAWSON (308) 537-3661 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.9381320 -100.1533520 0   47 31 31047 30420   Central Dawson County https://data.medicare.gov/resource/xubh-q36u/row-dgzd-a44k.k83g 281313 661037 2019-12-02 2019-06-30 12           12               12
542 PEACEHEALTH SOUTHWEST MEDICAL CENTER 400 NE MOTHER JOSEPH PLACE VANCOUVER WA 98668 CLARK (360) 256-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.6234860 -122.5806360 0   11 53 53011 38900 Portland-Vancouver-Salem, OR-WA Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-dpuj-5ndk.kv2i 500050 662623 2019-12-02 2019-06-30 356 80         436   14           450
3381 CHI HEALTH ST ELIZABETH 555 SOUTH 70TH ST LINCOLN NE 68510 LANCASTER (402) 219-7700 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8076090 -96.6251790 0   109 31 31109 30700 Lincoln-Beatrice, NE Central Lancaster County https://data.medicare.gov/resource/xubh-q36u/row-dwnv_q2vi_cf6s 280020 659989 2019-12-02 2019-06-30 176 16   16   27 235               235
3758 WAYNE MEMORIAL HOSPITAL 601 PARK STREET HONESDALE PA 18431 WAYNE (570) 253-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.5762840 -75.2597960 0   127 42 42127         https://data.medicare.gov/resource/xubh-q36u/row-dwrj-acy3.k8c3 390125 661251 2019-12-02 2019-06-30 68 8         76   14           90
2396 ST JOSEPH REGIONAL MEDICAL CENTER 415 SIXTH STREET LEWISTON ID 83501 NEZ PERCE (208) 799-5300 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.4171210 -117.0249970 0   69 16 16069 30300   Central Nez Perce County https://data.medicare.gov/resource/xubh-q36u/row-dyet_gevw~szfb 130003 662190 2019-12-02 2019-06-30 101 9         110 20             130
3897 CHI HEALTH PLAINVIEW P O BOX 489, 704 NORTH THIRD ST PLAINVIEW NE 68769 PIERCE (402) 582-4245 Critical Access Hospitals Voluntary non-profit - Church TRUE 42.3587128 -97.7857721 1 ROOFTOP 139 31 31139 35740   Outlying Pierce County https://data.medicare.gov/resource/xubh-q36u/row-dyfy-rvq7~3hjd 281346 661043 2019-12-02 2019-06-30 15           15               15
3972 CLARINDA REGIONAL HEALTH CENTER 220 ESSIE DAVISON DRIVE CLARINDA IA 51632 PAGE (712) 542-2176 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.7231160 -95.0414060 0   145 19 19145         https://data.medicare.gov/resource/xubh-q36u/row-e24e-jv8q.avua 161352 661182 2019-12-02 2019-06-30 25           25               25
3842 UPMC PINNACLE HANOVER 300 HIGHLAND AVE HANOVER PA 17331 YORK (717) 637-3711 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8079810 -76.9837310 0   133 42 42133 49620 Harrisburg-York-Lebanon, PA Central York County https://data.medicare.gov/resource/xubh-q36u/row-e6wa_fe6d.4weu 390233 660867 2019-12-02 2019-06-30 72           81               81
1917 ASHLEY MEDICAL CENTER 612 CENTER AVENUE N ASHLEY ND 58413 MCINTOSH (701) 288-3433 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.0401880 -99.3717150 0   51 38 38051         https://data.medicare.gov/resource/xubh-q36u/row-ecd4.9q4x_twgv 351322 661581 2019-12-02 2019-06-30 20           20       40       60
3137 OAK VALLEY HOSPITAL DISTRICT 350 S OAK AVE OAKDALE CA 95361 STANISLAUS (209) 847-3011 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7580980 -120.8603630 0   99 6 6099 33700 Modesto-Merced, CA Central Stanislaus County https://data.medicare.gov/resource/xubh-q36u/row-ehek_q3if-kskp 50067 660166 2019-12-02 2019-06-30 30 5         35       115       150
1066 SAINT ALPHONSUS MEDICAL CENTER - NAMPA 4300 E FLAMINGO AVE NAMPA ID 83687 CANYON (208) 205-0050 Acute Care Hospitals Voluntary non-profit - Church TRUE 43.5963320 -116.5191740 0   27 16 16027 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Canyon County https://data.medicare.gov/resource/xubh-q36u/row-ei4u.dihn_gvat 130013 660927 2019-12-02 2019-06-30 74 18       4 96               96
4725 JOHNS HOPKINS HOSPITAL, THE 600 NORTH WOLFE STREET BALTIMORE MD 21287 BALTIMORE CITY (410) 955-9540 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.2975020 -76.5908070 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-ejw3-q2eu.s7zr 210009 660097 2019-12-02 2019-06-30 822 66 12   24   1003               1003

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