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

4,766 rows sorted by hospital_name

View and edit SQL

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
112 ALBANY MEMORIAL HOSPITAL 600 NORTHERN BOULEVARD ALBANY NY 12204 ALBANY (518) 471-3490 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6746850 -73.7488610 0   1 36 36001 10580 Albany-Schenectady, NY Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-fbeu-trch-uemx 330003 661359 2019-11-27 2019-06-30 57 16         73               73
3223 ALBERT EINSTEIN MEDICAL CENTER 5501 OLD YORK ROAD PHILADELPHIA PA 19141 PHILADELPHIA (215) 456-6090 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.0369270 -75.1446830 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-y25a_nm4t_83u2 390142 658762 2019-11-12 2019-06-30 336 32 16     23 407 47 199   44       697
1236 ALEXIAN BROTHERS MEDICAL CENTER 1 800 W BIESTERFIELD RD ELK GROVE VILLAGE IL 60007 COOK (847) 437-5500 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.0037050 -88.0149960 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-22rs-enea-7d2m 140258 660521 2019-11-27 2019-06-30 221 36         257 25 72       16   370
151 ALFRED I DUPONT HOSPITAL FOR CHILDREN 1600 ROCKLAND RD PO BOX 269 WILMINGTON DE 19899 NEW CASTLE (302) 651-4000 Childrens Voluntary non-profit - Private TRUE 39.7823370 -75.5552390 0   3 10 10003 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central New Castle County https://data.medicare.gov/resource/xubh-q36u/row-b9cf-cftg-3kpg 83300 659028 2019-11-13 2018-12-31 114         24 208               208
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
1348 ALICE HYDE MEDICAL CENTER 133 PARK STREET MALONE NY 12953 FRANKLIN (518) 483-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.8566580 -74.2919300 0   33 36 36033 31660   Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-493x~ftr5.jry8 330084 651569 2019-06-27 2018-09-30 43 5         48       135   30   213
451 ALICE PECK DAY MEMORIAL HOSPITAL 10 ALICE PECK DAY DRIVE LEBANON NH 3766 GRAFTON (603) 448-3121 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.6402930 -72.2643660 0   9 33 33009 17200   Central Grafton County https://data.medicare.gov/resource/xubh-q36u/row-t8xb_fse9~ukfj 301305 661743 2019-12-03 2019-06-30 24           24               24
290 ALLEGAN GENERAL HOSPITAL 555 LINN STREET ALLEGAN MI 49010 ALLEGAN (269) 686-4101 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.5202590 -85.8569390 0   5 26 26005 26090 Grand Rapids-Wyoming-Muskegon, MI Central Allegan County https://data.medicare.gov/resource/xubh-q36u/row-9kac~4r3i~rk7m 231328 649266 2019-05-30 2018-12-31 25           25               25
309 ALLEGHANY COUNTY MEMORIAL HOSPITAL 617 DOCTORS STREET SPARTA NC 28675 ALLEGHANY (336) 372-5511 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.5095115 -81.1150447 1 RANGE_INTERPOLATED 5 37 37005         https://data.medicare.gov/resource/xubh-q36u/row-zjv8.p46n-e733 341320 645140 2019-03-04 2018-09-30 25           25               25
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
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
89 ALLEN COUNTY REGIONAL HOSPITAL 3066 NORTH KENTUCKY STREET IOLA KS 66749 ALLEN (620) 365-1021 Critical Access Hospitals Government - State TRUE 37.9503420 -95.3906740 0   1 20 20001         https://data.medicare.gov/resource/xubh-q36u/row-gt8h_8a7x~t4kr 171373 648832 2019-05-29 2018-12-31 25           25               25
601 ALLEN HOSPITAL 1825 LOGAN AVENUE WATERLOO IA 50703 BLACK HAWK (319) 235-3941 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.5257530 -92.3377580 0   13 19 19013 47940   Central Black Hawk County https://data.medicare.gov/resource/xubh-q36u/row-ffm4.rxar_ycnb 160110 650262 2019-06-04 2018-12-31 168 12         187   12           199
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
317 ALLENDALE COUNTY HOSPITAL 1787 ALLENDALE FAIRFAX RD FAIRFAX SC 29827 ALLENDALE (803) 632-3311 Critical Access Hospitals Government - Local TRUE 32.9662250 -81.2477270 0   5 45 45005         https://data.medicare.gov/resource/xubh-q36u/row-bjdu~dq8g.u82d 421300 645444 2019-03-04 2018-09-30 25           25       44       69
4047 ALLIANCE COMMUNITY HOSPITAL 200 EAST STATE STREET ALLIANCE OH 44601 STARK (330) 596-7018 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.9016790 -81.1027360 0   151 39 39151 15940 Cleveland-Akron-Canton, OH Central Stark County https://data.medicare.gov/resource/xubh-q36u/row-9pb7.6hrh_xxpz 360131 649642 2019-06-03 2018-12-31 43 12         55 12     78       145
2576 ALLIANCE HEALTH CENTER 5000 HIGHWAY 39 NORTH MERIDIAN MS 39301 LAUDERDALE (601) 483-6211 Acute Care Hospitals Proprietary FALSE 32.4099880 -88.6788110 0   75 28 28075 32940   Central Lauderdale County https://data.medicare.gov/resource/xubh-q36u/row-u23i_wk6s_4s84 250151 649279 2019-05-29 2018-12-31 83           83 71         60   214
3000 ALLIANCE HEALTHCARE SYSTEM 1430 HIGHWAY 4 EAST / P O BOX 6000 HOLLY SPRINGS MS 38635 MARSHALL (662) 252-1212 Acute Care Hospitals Physician TRUE 34.7868350 -89.4150270 0   93 28 28093 32820 Memphis-Forrest City, TN-MS-AR Outlying Marshall County https://data.medicare.gov/resource/xubh-q36u/row-zg7w-9rxd.iyxq 250012 648706 2019-06-04 2018-12-31 27           27 13             40
1607 ALLIANCEHEALTH CLINTON 100 NORTH 30TH STREET CLINTON OK 73601 CUSTER (580) 323-2363 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.5147890 -98.9968790 0   39 40 40039 48220   Central Custer County https://data.medicare.gov/resource/xubh-q36u/row-dvix_7ap3~spry 370029 653451 2019-08-30 2019-03-31 41 4         45   11           56
642 ALLIANCEHEALTH DURANT 1800 UNIVERSITY BOULEVARD DURANT OK 74702 BRYAN (405) 924-3080 Acute Care Hospitals Proprietary TRUE 34.0049030 -96.3950550 0   13 40 40013 20460 Dallas-Fort Worth, TX-OK Central Bryan County https://data.medicare.gov/resource/xubh-q36u/row-96gx.9gst_7qhe 370014 646932 2019-04-03 2018-09-30 132 8         140               140
3065 ALLIANCEHEALTH MADILL 901 S 5TH AVE MADILL OK 73446 MARSHALL (580) 795-3384 Critical Access Hospitals Proprietary TRUE 34.0817380 -96.7784500 0   95 40 40095         https://data.medicare.gov/resource/xubh-q36u/row-b6vq_dbi2_tjfb 371326 653270 2019-08-30 2019-03-31 21           21               21
3389 ALLIANCEHEALTH MIDWEST 2825 PARKLAWN DRIVE MIDWEST CITY OK 73110 OKLAHOMA (405) 610-8585 Acute Care Hospitals Proprietary TRUE 35.4665270 -97.3929250 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-sxg9_cifn-7qv9 370094 660692 2019-11-26 2019-06-30 212 24         236 19             255
2482 ALLIANCEHEALTH PONCA CITY 1900 NORTH 14TH STREET PONCA CITY OK 74601 KAY (580) 765-3301 Acute Care Hospitals Proprietary TRUE 36.7240880 -97.0672810 0   71 40 40071 38620   Central Kay County https://data.medicare.gov/resource/xubh-q36u/row-t7iq-uqd6~3p36 370006 656720 2019-11-01 2019-05-31 38 10         48               48
3350 ALLIANCEHEALTH SEMINOLE 2401 WRANGLER BOULEVARD SEMINOLE OK 74868 SEMINOLE (405) 303-4050 Acute Care Hospitals Proprietary TRUE 35.2464640 -96.6990130 0   133 40 40133         https://data.medicare.gov/resource/xubh-q36u/row-t47q~8ahq-97c8 370229 654158 2019-09-13 2019-03-31 32           32               32
4069 ALLIANCEHEALTH WOODWARD 900 17TH STREET WOODWARD OK 73801 WOODWARD (580) 254-8492 Acute Care Hospitals Proprietary TRUE 36.4378610 -99.4009540 0   153 40 40153 49260   Central Woodward County https://data.medicare.gov/resource/xubh-q36u/row-xvc5-zx2v~yrxt 370002 659337 2019-11-07 2019-05-31 34 6         40               40
1650 ALOMERE HEALTH 111 17TH AVENUE EAST ALEXANDRIA MN 56308 DOUGLAS (320) 762-1511 Acute Care Hospitals Government - Local TRUE 45.8726690 -95.3763800 0   41 27 27041 10820   Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-psb9.f8hy_pu25 240030 649757 2019-05-30 2018-12-31 91 8         99               99
45 ALTA BATES SUMMIT MEDICAL CENTER 350 HAWTHORNE AVENUE OAKLAND CA 94609 ALAMEDA (510) 655-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.8207840 -122.2632800 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-8jij.khwv.ypce 50043 650562 2019-06-03 2018-12-31 260 36         296   58           354
56 ALTA BATES SUMMIT MEDICAL CENTER - ALTA BATES CAMP 2450 ASHBY AVENUE BERKELEY CA 94705 ALAMEDA (510) 204-4444 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.8564880 -122.2573290 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-x8am.fvn9.9rvh 50305 650649 2019-06-03 2018-12-31 252 30       55 337 64             401
1442 ALTA VIEW HOSPITAL 9660 SOUTH 1300 EAST SANDY UT 84094 SALT LAKE (801) 501-2600 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5773600 -111.8531910 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-pdbj~gdsf_6jmr 460044 648659 2019-05-17 2018-12-31 54 4         58               58
1797 ALTA VISTA REGIONAL HOSPITAL 104 LEGION DRIVE LAS VEGAS NM 87701 SAN MIGUEL (505) 426-3930 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.6221500 -105.2098510 0   47 35 35047 29780 Albuquerque-Santa Fe-Las Vegas, NM Central San Miguel County https://data.medicare.gov/resource/xubh-q36u/row-eqjk~u8wz_58xt 320003 657378 2019-08-22 2018-08-31 38 8         46               46
3591 ALTON MEMORIAL HOSPITAL ONE MEMORIAL DRIVE ALTON IL 62002 MADISON (618) 463-7300 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8995477 -90.1591567 1 ROOFTOP 119 17 17119 41180 St. Louis-St. Charles-Farmington, MO-IL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-45rg.3vzm_7irj 140002 648904 2019-05-30 2018-12-31 120 12         132 20             152
1406 ALTRU HOSPITAL 1200 S COLUMBIA RD GRAND FORKS ND 58201 GRAND FORKS (701) 780-5000 Acute Care Hospitals Government - Local TRUE 47.9105352 -97.0681107 1 ROOFTOP 35 38 38035 24220   Central Grand Forks County https://data.medicare.gov/resource/xubh-q36u/row-tfgh.9uft~bxhm 350019 650883 2019-06-03 2018-12-31 245 16     10   271   23           294
4413 ALTUS BAYTOWN HOSPITAL 1404 W BAKER ROAD BAYTOWN TX 77521 HARRIS (281) 837-7600 Acute Care Hospitals Physician TRUE 29.7698160 -94.9801930 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-fa96~fa82_gfbn 670109 650629 2019-06-04 2018-12-31 14           14               14
2517 ALVARADO HOSPITAL MEDICAL CENTER 6655 ALVARADO ROAD SAN DIEGO CA 92120 SAN DIEGO (619) 229-3172 Acute Care Hospitals Proprietary TRUE 32.7771360 -117.0566020 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-nt9q.cx94-9sbi 50757 648888 2019-05-30 2018-12-31 226 28         254   50           304
1879 AMERICAN FORK HOSPITAL 170 NORTH 1100 EAST AMERICAN FORK UT 84003 UTAH (801) 855-3305 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3805060 -111.7690940 0   49 49 49049 39340 Salt Lake City-Provo-Orem, UT Central Utah County https://data.medicare.gov/resource/xubh-q36u/row-s7aj~ypv9~6tcc 460023 648658 2019-05-22 2018-12-31 73 18         91               91
3071 AMERY HOSPITAL & CLINIC 265 GRIFFIN STREET EAST AMERY WI 54001 POLK (715) 268-0300 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.2959460 -92.3606700 0   95 55 55095         https://data.medicare.gov/resource/xubh-q36u/row-nbii-jcut-5ka3 521308 649379 2019-05-24 2018-12-31 25           25 10             35
2116 ANAHEIM GLOBAL MEDICAL CENTER 1025 S ANAHEIM BLVD ANAHEIM CA 92805 ORANGE (714) 533-6220 Acute Care Hospitals Proprietary FALSE 33.8205660 -117.9090020 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-nd9d.35tv~sptu 50744 658161 2019-02-01 2018-08-31 81 22         103 80             183
1580 ANDALUSIA HEALTH 849 SOUTH THREE NOTCH STREET ANDALUSIA AL 36420 COVINGTON (334) 222-8466 Acute Care Hospitals Proprietary TRUE 31.2974620 -86.4955990 0   39 1 1039         https://data.medicare.gov/resource/xubh-q36u/row-5sky_nfni.vnsr 10036 653819 2019-08-30 2019-03-31 75 8         83               83
172 ANDERSON COUNTY HOSPITAL 421 S MAPLE GARNETT KS 66032 ANDERSON (785) 204-4000 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.2801200 -95.2493000 0   3 20 20003         https://data.medicare.gov/resource/xubh-q36u/row-3ktx.x5ze~zgrj 171316 648620 2019-05-24 2018-12-31 12           12           36   48
3589 ANDERSON HOSPITAL 6800 STATE ROUTE 162 MARYVILLE IL 62062 MADISON (618) 288-5711 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7381270 -89.9464220 0   119 17 17119 41180 St. Louis-St. Charles-Farmington, MO-IL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-36x2~e4v5.43qg 140289 650994 2019-06-03 2018-12-31 106 24         130   24           154
2575 ANDERSON REGIONAL MEDICAL CTR 2124 14 ST MERIDIAN MS 39301 LAUDERDALE (601) 553-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.3707750 -88.6998580 0   75 28 28075 32940   Central Lauderdale County https://data.medicare.gov/resource/xubh-q36u/row-6bta-h82p-22h6 250104 643621 2019-02-25 2018-09-30 231 17 12       260               260
2578 ANDERSON RMC SOUTH 1102 CONSTITUTION AVENUE MERIDIAN MS 39301 LAUDERDALE (601) 484-3590 Acute Care Hospitals Proprietary TRUE 32.3677900 -88.6993150 0   75 28 28075 32940   Central Lauderdale County https://data.medicare.gov/resource/xubh-q36u/row-y3vi~3kii_r7dj 250081 644754 2019-02-21 2018-09-30 33           33 16 20           69
367 ANDROSCOGGIN VALLEY HOSPITAL 59 PAGE HILL ROAD BERLIN NH 3570 COOS (603) 752-2200 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4870990 -71.1565480 0   7 33 33007 13620   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-fdui.znjf.jm5w 301310 643921 2019-02-26 2018-09-30 25           25               25
3479 ANGEL MEDICAL CENTER 120 RIVERVIEW ST PO BOX 1209 FRANKLIN NC 28734 MACON (828) 524-8411 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.1846340 -83.3776400 0   113 37 37113         https://data.medicare.gov/resource/xubh-q36u/row-7yi7_miqw_9mna 341326 645352 2019-03-01 2018-09-30 20 5         25               25
2341 ANIMAS SURGICAL HOSPITAL, LLC 575 RIVERGATE LN DURANGO CO 81301 LA PLATA (970) 247-3537 Acute Care Hospitals Physician TRUE 37.2488890 -107.8707740 0   67 8 8067 20420   Central La Plata County https://data.medicare.gov/resource/xubh-q36u/row-twp9-b345.bypu 60117 650115 2019-05-31 2018-12-31 12           12               12
391 ANMED HEALTH 800 N FANT ST ANDERSON SC 29621 ANDERSON (864) 512-2830 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5110710 -82.6473550 0   7 45 45007 24860 Greenville-Spartanburg-Anderson, SC Outlying Anderson County https://data.medicare.gov/resource/xubh-q36u/row-7pgs~6cv2_uh8s 420027 650366 2019-05-31 2018-12-31 327 25 15       367 29             396
1226 ANN & ROBERT H LURIE CHILDRENS HOSPITAL OF CHICAGO 225 E CHICAGO AVE, BOX 140 CHICAGO IL 60611 COOK (312) 227-4000 Childrens Voluntary non-profit - Private TRUE 41.8967460 -87.6219060 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-apzm~334d~hd6g 143300 642330 2019-02-01 2018-08-31 168 40 44     60 312               312
444 ANNA JAQUES HOSPITAL 25 HIGHLAND AVENUE NEWBURYPORT MA 1950 ESSEX (978) 463-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.8143580 -70.8897830 0   9 25 25009 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Essex County https://data.medicare.gov/resource/xubh-q36u/row-rfgc.9n4j-t573 220029 644035 2019-03-05 2018-09-30 112 8         120 20             140
181 ANNE ARUNDEL MEDICAL CENTER 2001 MEDICAL PARKWAY ANNAPOLIS MD 21401 ANNE ARUNDEL (443) 481-1307 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9911150 -76.5360580 0   3 24 24003 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Anne Arundel County https://data.medicare.gov/resource/xubh-q36u/row-npuw_t7wm.mrix 210023 662537 2019-12-23 2019-06-30 329 20       30 379               379
3950 ANNIE JEFFREY MEMORIAL COUNTY HEALTH CENTER P O BOX 428, 531 BEEBE ST OSCEOLA NE 68651 POLK (402) 747-2031 Critical Access Hospitals Government - Local TRUE 41.1697878 -97.5490124 1 ROOFTOP 143 31 31143         https://data.medicare.gov/resource/xubh-q36u/row-tmyd~dpec-xnwq 281314 655636 2019-10-21 2019-06-30 16           16               16
4523 ANSON GENERAL HOSPITAL 101 AVENUE J ANSON TX 79501 JONES (325) 823-3231 Acute Care Hospitals Government - Local TRUE 32.7681010 -99.8955140 0   253 48 48253 10180   Outlying Jones County https://data.medicare.gov/resource/xubh-q36u/row-yt33_gjz7-gmyy 450078 653860 2019-09-03 2019-03-31 7           7           6   13
188 ANTELOPE MEMORIAL HOSPITAL P O BOX 229, 102 WEST 9TH ST NELIGH NE 68756 ANTELOPE (402) 887-4151 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1336539 -98.0299847 1 ROOFTOP 3 31 31003         https://data.medicare.gov/resource/xubh-q36u/row-uv86-cr3r-pfws 281326 661040 2019-12-02 2019-06-30 23           23               23
1520 ANTELOPE VALLEY HOSPITAL 1600 W AVE J LANCASTER CA 93534 LOS ANGELES (661) 949-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6893710 -118.1584760 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-jtig~5whv~hgpp 50056 660914 2019-12-02 2019-06-30 345 21         393               393
4040 APPLETON MUNICIPAL HOSPITAL 30 SOUTH BEHL STREET APPLETON MN 56208 SWIFT (320) 289-8508 Critical Access Hospitals Government - Local TRUE 45.1996580 -96.0092240 0   151 27 27151         https://data.medicare.gov/resource/xubh-q36u/row-egz5_fa7v_8upj 241341 656449 2019-10-21 2018-09-30 15           15       50       65
78 APPLING HOSPITAL 163 E TOLLISON STREET BAXLEY GA 31513 APPLING (912) 367-9841 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.7687680 -82.3493510 0   1 13 13001         https://data.medicare.gov/resource/xubh-q36u/row-j4qq-twpw~u8jw 110071 658240 2019-03-29 2018-08-31 31 3         34 30     101       165
1677 ARBOR HEALTH MORTON HOSPITAL 521 ADAMS STREET MORTON WA 98356 LEWIS (360) 496-5112 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.5559530 -122.2798780 0   41 53 53041 16500 Seattle-Tacoma, WA Central Lewis County https://data.medicare.gov/resource/xubh-q36u/row-rfdw-ekhk~ca8x 501319 648508 2019-05-23 2018-12-31 25           25               25
3178 ARBUCKLE MEMORIAL HOSPITAL AUTHORITY 2011 WEST BROADWAY SULPHUR OK 73086 MURRAY (580) 622-2161 Critical Access Hospitals Government - Local TRUE 34.5063330 -96.9960050 0   99 40 40099         https://data.medicare.gov/resource/xubh-q36u/row-k94n_jt84~krmu 371328 648757 2019-05-31 2018-12-31 25           25               25
2458 ARH OUR LADY OF THE WAY 11203 MAIN STREET MARTIN KY 41649 FLOYD (606) 285-6400 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.5791050 -82.7503510 0   71 21 21071         https://data.medicare.gov/resource/xubh-q36u/row-y85x_rrhk~w2dk 181305 660806 2019-11-27 2019-06-30 25           25               25
3232 ARIA HEALTH 10800 KNIGHTS ROAD PHILADELPHIA PA 19114 PHILADELPHIA (215) 612-4129 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0707880 -74.9814290 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-hak8.j8jv.xez2 390115 661634 2019-12-03 2019-06-30 383           450               450
4676 ARISE AUSTIN MEDICAL CENTER 3003 BEE CAVES ROAD AUSTIN TX 78746 TRAVIS (512) 347-9888 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.2716640 -97.7954690 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-npkw~aqm5~fref 450871 648766 2019-05-31 2018-12-31 21           21               21
556 ARIZONA SPECIALTY HOSPITAL 2905 WEST WARNER ROAD, SUITE 1 CHANDLER AZ 85224 MARICOPA (480) 603-9000 Acute Care Hospitals Proprietary FALSE 33.3348400 -111.8911330 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-z5xq-7gkm.mjtq 30112 649698 2019-05-22 2018-12-31 24           24               24
581 ARIZONA SPINE AND JOINT HOSPITAL 4620 EAST BASELINE ROAD MESA AZ 85206 MARICOPA (480) 832-4770 Acute Care Hospitals Physician FALSE 33.3792060 -111.7346950 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-ijxi~2kwd~swq9 30107 650233 2019-05-29 2018-12-31 23           23               23
3583 ARKANSAS CHILDREN'S HOSPITAL 1 CHILDREN'S WAY, SLOT 301 LITTLE ROCK AR 72202 PULASKI (501) 364-1100 Childrens Voluntary non-profit - Private TRUE 34.7428220 -92.2920060 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-p66z~xhi7.pxk4 43300 660352 2019-12-03 2019-06-30 153 26 30 10   104 336               336
3940 ARKANSAS CHILDREN'S NORTHWEST, INC 2601 GENE GEORGE BOULEVARD SPRINGDALE AR 72762 WASHINGTON (479) 725-6800 Childrens Voluntary non-profit - Private TRUE 36.1633250 -94.1926020 0   143 5 5143 22220   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-ancy_ajta_8yhj 43301 660747 2019-12-03 2019-06-30 24           24               24
3575 ARKANSAS HEART HOSPITAL, LLC 1701 S SHACKLEFORD ROAD LITTLE ROCK AR 72211 PULASKI (501) 219-7000 Acute Care Hospitals Proprietary TRUE 34.7391590 -92.3944210 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-jzxu~zre6.ev3c 40134 644703 2019-02-28 2018-09-30 112           112               112
1992 ARKANSAS METHODIST MEDICAL CENTER 900 WEST KINGSHIGHWAY PARAGOULD AR 72450 GREENE (870) 239-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0525930 -90.4990510 0   55 5 5055 37500 Jonesboro-Paragould, AR Central Greene County https://data.medicare.gov/resource/xubh-q36u/row-r7jj_jnzg_y8it 40039 659557 2019-11-21 2019-06-30 106 8         114   15           129
3576 ARKANSAS SURGICAL HOSPITAL 5201 NORTH SHORE DRIVE NO LITTLE ROCK AR 72118 PULASKI (501) 748-8000 Acute Care Hospitals Proprietary TRUE 34.8014580 -92.3476870 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-y6hc~2xha_rqkj 40147 649072 2019-05-31 2018-12-31 49           49               49
2884 ARKANSAS VALLEY REGIONAL MEDICAL CENTER 1100 CARSON AVENUE LA JUNTA CO 81050 OTERO (719) 383-6000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9769290 -103.5487420 0   89 8 8089         https://data.medicare.gov/resource/xubh-q36u/row-967u~ukgn_sq4q 61336 653832 2019-08-29 2019-03-31 16 506         522       30       552
702 ARNOT OGDEN MEDICAL CENTER 600 ROE AVENUE ELMIRA NY 14905 CHEMUNG (607) 737-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0992560 -76.8266680 0   15 36 36015 21300 Elmira-Corning, NY Central Chemung County https://data.medicare.gov/resource/xubh-q36u/row-mdzy-cpim.xunx 330090 646163 2019-04-04 2018-12-31 187 20       18 225               225
2427 ARROWHEAD REGIONAL MEDICAL CENTER 400 NORTH PEPPER AVENUE COLTON CA 92324 SAN BERNARDINO (909) 580-1000 Acute Care Hospitals Government - Local TRUE 34.0728840 -117.3528330 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-w78g-jnyb.b7ix 50245 662024 2019-11-27 2019-06-30 274 32   14 16 30 366 90             456
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
1165 ASANTE ASHLAND COMMUNITY HOSPITAL 280 MAPLE STREET ASHLAND OR 97520 JACKSON (541) 201-4017 Acute Care Hospitals Government - Local TRUE 42.2064450 -122.7251290 0   29 41 41029 32780 Medford-Grants Pass, OR Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-xsnr-xsme.wejp 380005 644057 2019-02-27 2018-09-30 34 4         38               38
1167 ASANTE ROGUE REGIONAL MEDICAL CENTER 2825 E BARNETT ROAD MEDFORD OR 97504 JACKSON (541) 789-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3164830 -122.8304430 0   29 41 41029 32780 Medford-Grants Pass, OR Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-9ft2-cyq3.jcug 380018 642898 2019-01-29 2018-09-30 238 15 16       301 21 15           337
1351 ASANTE THREE RIVERS MEDICAL CENTER 500 SW RAMSEY AVENUE GRANTS PASS OR 97527 JOSEPHINE (541) 472-7000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.4204370 -123.3414950 0   33 41 41033 24420 Medford-Grants Pass, OR Central Josephine County https://data.medicare.gov/resource/xubh-q36u/row-ybif~ftnq_236g 380002 642897 2019-01-29 2018-09-30 109 12         121               121
3241 ASCENSION ALL SAINTS HOSPITAL 3801 SPRING ST RACINE WI 53405 RACINE (262) 687-4011 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.7333460 -87.8251730 0   101 55 55101 39540 Milwaukee-Racine-Waukesha, WI Central Racine County https://data.medicare.gov/resource/xubh-q36u/row-jquv~ckuw_p6uc 520096 661683 2019-11-27 2019-06-30 208 23         249   14           263
2609 ASCENSION BORGESS HOSPITAL 1521 GULL ROAD KALAMAZOO MI 49048 KALAMAZOO (269) 226-7000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.3047590 -85.5614250 0   77 26 26077 28020 Kalamazoo-Battle Creek-Portage, MI Central Kalamazoo County https://data.medicare.gov/resource/xubh-q36u/row-e5a3_pdew_gq2m 230117 661341 2019-12-03 2019-06-30 276 15 15       306 50 15           371
1085 ASCENSION BORGESS LEE HOSPITAL 420 W HIGH ST DOWAGIAC MI 49047 CASS (269) 782-8681 Critical Access Hospitals Voluntary non-profit - Church TRUE 41.9826650 -86.1154990 0   27 26 26027 43780 South Bend-Elkhart-Mishawaka, IN-MI Central Cass County https://data.medicare.gov/resource/xubh-q36u/row-vqdi~vtd4.ymdx 231315 661020 2019-11-29 2019-06-30 25           25               25
2998 ASCENSION BRIGHTON CENTER FOR RECOVERY 12851 GRAND RIVER RD BRIGHTON MI 48116 LIVINGSTON (810) 227-1211 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.5176600 -83.6945230 0   93 26 26093 19820 Detroit-Warren-Ann Arbor, MI Outlying Livingston County https://data.medicare.gov/resource/xubh-q36u/row-qf5d-9hbt_ivvy 230279 661539 2019-12-03 2019-06-30 99           99               99
719 ASCENSION CALUMET HOSPITAL 614 MEMORIAL DRIVE CHILTON WI 53014 CALUMET (920) 849-2386 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0254390 -88.1543990 0   15 55 55015 11540 Appleton-Oshkosh-Neenah, WI Central Calumet County https://data.medicare.gov/resource/xubh-q36u/row-q97p-97ns_bxut 521317 661447 2019-11-27 2019-06-30 25           25               25
2670 ASCENSION COLUMBIA ST MARY'S HOSPITAL MILWAUKEE 2323 N LAKE DR MILWAUKEE WI 53211 MILWAUKEE (414) 585-1374 Acute Care Hospitals Voluntary non-profit - Church TRUE 43.0614110 -87.8791390 0   79 55 55079 33340 Milwaukee-Racine-Waukesha, WI Central Milwaukee County https://data.medicare.gov/resource/xubh-q36u/row-k5x2_2n3g-wddg 520051 661679 2019-11-27 2019-06-30 190 36   12   25 263               263
2932 ASCENSION COLUMBIA ST MARY'S HOSPITAL OZAUKEE 13111 N PORT WASHINGTON RD MEQUON WI 53097 OZAUKEE (414) 585-1374 Acute Care Hospitals Voluntary non-profit - Church TRUE 43.2561800 -87.9241500 0   89 55 55089 33340 Milwaukee-Racine-Waukesha, WI Central Ozaukee County https://data.medicare.gov/resource/xubh-q36u/row-kkhj.8pxm.v25f 520027 661440 2019-11-27 2019-06-30 88 32         120               120
3735 ASCENSION EAGLE RIVER HOSPITAL 201 HOSPITAL ROAD EAGLE RIVER WI 54521 VILAS (715) 479-7411 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9275180 -89.2516780 0   125 55 55125         https://data.medicare.gov/resource/xubh-q36u/row-unpa.6ptj.b2ji 521300 661443 2019-11-27 2019-06-30 14           14               14
1839 ASCENSION GENESYS HOSPITAL ONE GENESYS PARKWAY GRAND BLANC MI 48439 GENESEE (810) 606-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.8903226 -83.6367994 1 ROOFTOP 49 26 26049 22420 Detroit-Warren-Ann Arbor, MI Central Genesee County https://data.medicare.gov/resource/xubh-q36u/row-puhx-szv4~kvmj 230197 661015 2019-11-27 2019-06-30 305 45         350   20           370
2419 ASCENSION GOOD SAMARITAN HOSPITAL 601 S CENTER AVE MERRILL WI 54452 LINCOLN (715) 536-5511 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.1758580 -89.6830310 0   69 55 55069 32980 Wausau-Stevens Point-Wisconsin Rapids, WI Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-22bh-e9v4.hnpp 521339 661687 2019-11-27 2019-06-30 25           25               25
3166 ASCENSION MACOMB OAKLAND HOSP-WARREN CAMPUS 11800 EAST TWELVE MILE ROAD WARREN MI 48093 MACOMB (586) 573-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.5071780 -83.0035350 0   99 26 26099 19820 Detroit-Warren-Ann Arbor, MI Central Macomb County https://data.medicare.gov/resource/xubh-q36u/row-wse9-dqu9-85wr 230195 661014 2019-11-27 2019-06-30 388 41         429 54 24           507
2877 ASCENSION NE WISCONSIN - ST ELIZABETH CAMPUS 1506 S ONEIDA ST APPLETON WI 54915 OUTAGAMIE (920) 738-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.2487330 -88.4041350 0   87 55 55087 11540 Appleton-Oshkosh-Neenah, WI Central Outagamie County https://data.medicare.gov/resource/xubh-q36u/row-77yx~wvu7-95ti 520009 661676 2019-11-27 2019-06-30 237 42         294 8 6           308
870 ASCENSION OUR LADY OF VICTORY HOSPITAL 1120 PINE ST STANLEY WI 54768 CHIPPEWA (715) 644-5571 Critical Access Hospitals Voluntary non-profit - Other TRUE 44.9553110 -90.9205640 0   19 55 55019         https://data.medicare.gov/resource/xubh-q36u/row-xzzk-sbky-rj53 521311 661445 2019-11-27 2019-06-30 24           24               24
3720 ASCENSION PROVIDENCE HOSPITAL 16001 W NINE MILE RD SOUTHFIELD MI 48075 OAKLAND (248) 849-3011 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.4591960 -83.2051630 0   125 26 26125 19820 Detroit-Warren-Ann Arbor, MI Central Oakland County https://data.medicare.gov/resource/xubh-q36u/row-6smt_snvy_988f 230019 662125 2019-12-04 2019-06-30 459 34 34     15 542 25 16           583
3718 ASCENSION PROVIDENCE ROCHESTER HOSPITAL 1101 W UNIVERSITY DRIVE ROCHESTER MI 48307 OAKLAND (248) 652-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6808820 -83.1492280 0   125 26 26125 19820 Detroit-Warren-Ann Arbor, MI Central Oakland County https://data.medicare.gov/resource/xubh-q36u/row-jzqb.wres.23pz 230254 661018 2019-11-27 2019-06-30 154 18 8       180 20 24           224
3999 ASCENSION RIVER DISTRICT HOSPITAL 4100 RIVER RD EAST CHINA MI 48054 ST. CLAIR (810) 329-7111 Acute Care Hospitals Government - Hospital District or Authority FALSE 42.7865050 -82.4782080 0   147 26 26147 19820 Detroit-Warren-Ann Arbor, MI Outlying St. Clair County https://data.medicare.gov/resource/xubh-q36u/row-kcai_xx52-e2uf 230241 661538 2019-12-03 2019-06-30 62 3         65               65
268 ASCENSION SACRED HEART BAY 615 N BONITA AVE PANAMA CITY FL 32401 BAY (850) 769-1511 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.1596810 -85.6470670 0   5 12 12005 37460   Central Bay County https://data.medicare.gov/resource/xubh-q36u/row-sfb2_87vw-qbr7 100026 650248 2019-05-31 2018-12-31 236 57         293               293
1728 ASCENSION SACRED HEART GULF 3801 E HWY 98 PORT SAINT JOE FL 32456 GULF (850) 229-5600 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.7765620 -85.2876050 0   45 12 12045 37460   Outlying Gulf County https://data.medicare.gov/resource/xubh-q36u/row-2gve.rn5c.g9tq 100313 660196 2019-11-27 2019-06-30 19           19               19
2420 ASCENSION SACRED HEART HOSPITAL 401 W MOHAWK DR SUITE 100 TOMAHAWK WI 54487 LINCOLN (715) 453-7700 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.4890060 -89.7335960 0   69 55 55069 32980 Wausau-Stevens Point-Wisconsin Rapids, WI Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-zubv-e9fv-qs3r 521313 661446 2019-11-27 2019-06-30 15           15               15
1315 ASCENSION SACRED HEART PENSACOLA 5151 N 9TH AVE PENSACOLA FL 32504 ESCAMBIA (850) 416-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4755880 -87.2109860 0   33 12 12033 37860   Central Escambia County https://data.medicare.gov/resource/xubh-q36u/row-cuin_8gyu.u6ry 100025 660788 2019-11-27 2019-06-30 419 34       26 561               561
2672 ASCENSION SE WISCONSIN HOSPITAL - ST JOSEPH CAMPUS 5000 W CHAMBERS ST MILWAUKEE WI 53210 MILWAUKEE (414) 447-2130 Acute Care Hospitals Voluntary non-profit - Church TRUE 43.0734650 -87.9761000 0   79 55 55079 33340 Milwaukee-Racine-Waukesha, WI Central Milwaukee County https://data.medicare.gov/resource/xubh-q36u/row-i5tc-dt6s_7u6h 520136 661685 2019-11-27 2019-06-30 237 42         325   9           334
2040 ASCENSION SETON EDGAR B DAVIS 130 HAYS STREET LULING TX 78648 CALDWELL (830) 875-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 29.6725300 -97.6542540 0   55 48 48055 12420   Outlying Caldwell County https://data.medicare.gov/resource/xubh-q36u/row-wn52-vdac_k6nj 451371 660154 2019-11-25 2019-06-30 23           23               23
4674 ASCENSION SETON MEDICAL CENTER AUSTIN 1201 W 38TH ST AUSTIN TX 78705 TRAVIS (512) 324-1000 Acute Care Hospitals Physician TRUE 30.3061540 -97.7452180 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-qf7b-dsjj.a9dv 450056 659731 2019-11-25 2019-06-30 304 83       43 430               430
4675 ASCENSION SETON NORTHWEST 11113 RESEARCH BOULEVARD AUSTIN TX 78759 TRAVIS (512) 324-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4048200 -97.7450100 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-qudt_ghtb~xy35 450867 660331 2019-11-25 2019-06-30 77 16       13 106               106
2554 ASCENSION ST CLARES HOSPITAL 3400 MINISTRY PARKWAY WESTON WI 54476 MARATHON (715) 393-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.8896750 -89.5822140 0   73 55 55073 48140 Wausau-Stevens Point-Wisconsin Rapids, WI Central Marathon County https://data.medicare.gov/resource/xubh-q36u/row-uq8n.4i4x-8v99 520202 661442 2019-11-27 2019-06-30 75 24         99               99
2678 ASCENSION ST FRANCIS HOSPITAL 3237 S 16TH ST MILWAUKEE WI 53215 MILWAUKEE (414) 647-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9853600 -87.9338370 0   79 55 55079 33340 Milwaukee-Racine-Waukesha, WI Central Milwaukee County https://data.medicare.gov/resource/xubh-q36u/row-5ccw~urbi~62kt 520078 661680 2019-11-27 2019-06-30 133 20         153               153

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