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

4,766 rows sorted by address

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, burn_beds, subprovider_oth_beds, filed_date (date), fy_end_date (date)

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
3701 3701 SALINE MEMORIAL HOSPITAL #1 MEDICAL PARK DRIVE BENTON AR 72015 SALINE (501) 776-6000 Acute Care Hospitals Proprietary TRUE 34.5735520 -92.5844050 0   125 5 5125 30780 Little Rock-North Little Rock, AR Central Saline County https://data.medicare.gov/resource/xubh-q36u/row-yg8k~yizr-mxhg 40084 660068 2019-12-04 2019-06-30 114 16         130 19 12       16   177
3295 3295 WETZEL COUNTY HOSPITAL #3 EAST BENJAMIN DRIVE NEW MARTINSVILLE WV 26155 WETZEL (304) 455-8000 Acute Care Hospitals Government - Local TRUE 39.6810712 -80.8501977 1 ROOFTOP 103 54 54103         https://data.medicare.gov/resource/xubh-q36u/row-v7h8~v92p-92tq 510072 661438 2019-12-02 2019-06-30 43 5         48               48
1122 1122 CHI ST VINCENT MORRILTON #4 HOSPITAL DRIVE MORRILTON AR 72110 CONWAY (501) 977-2300 Critical Access Hospitals Voluntary non-profit - Church TRUE 35.1699700 -92.7217020 0   29 5 5029         https://data.medicare.gov/resource/xubh-q36u/row-jajp~f47n.nife 41324 660162 2019-12-02 2019-06-30 25           25               25
479 479 GOV JUAN F LUIS HOSPITAL & MEDICAL CTR #4007 EST DIAMOND RUBY, CHRISTIANSTED ST CROIX VI 820 SAINT CROIX ISLAND (340) 778-6311 Acute Care Hospitals Government - State TRUE 17.7336768 -64.7515758 1 ROOFTOP 10 78 78010         https://data.medicare.gov/resource/xubh-q36u/row-bs2s~9p8n_k2e3 480002 644383 2019-02-28 2018-09-30 66 11         77               77
148 148 HEBREW HOME AND HOSPITAL INC 1 ABRAHMS BOULEVARD WEST HARTFORD CT 6117 HARTFORD (860) 523-3800 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.8027740 -72.7289310 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-eqjh_iqnh-wsnp 70040 645324 2019-02-28 2018-09-30 23           23 22             45
4064 4064 AKRON GENERAL MEDICAL CENTER 1 AKRON GENERAL AVENUE AKRON OH 44307 SUMMIT (330) 344-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0778590 -81.5327870 0   153 39 39153 10420 Cleveland-Akron-Canton, OH Central Summit County https://data.medicare.gov/resource/xubh-q36u/row-fwyk~yqdc~my3b 360027 660664 2019-11-25 2018-12-31 315 34 34       383 53             436
3127 3127 ST JOSEPH'S HOSPITAL 1 AMALIA DRIVE BUCKHANNON WV 26201 UPSHUR (304) 472-2000 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.9912750 -80.2368240 0   97 54 54097         https://data.medicare.gov/resource/xubh-q36u/row-dwxq.ey9z_ufif 511321 649690 2019-05-24 2018-12-31 21 4         25       10 16     51
1007 1007 BOSTON MEDICAL CENTER CORPORATION- 1 BOSTON MEDICAL CENTER PLACE BOSTON MA 2118 SUFFOLK (617) 638-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3348100 -71.0744800 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-mqjp.wiw7.7ber 220031 645656 2019-03-01 2018-09-30 361 71         432               432
1809 1809 BROOKDALE HOSPITAL MEDICAL CENTER 1 BROOKDALE PLAZA BROOKLYN NY 11212 KINGS (718) 240-5966 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6545000 -73.9127500 0   47 36 36047 35620 New York-Newark, NY-NJ-CT-PA Central Kings County https://data.medicare.gov/resource/xubh-q36u/row-ht7t~c2ha~ruvx 330233 650317 2019-06-21 2018-12-31 223 29 6     30 288 61     448       797
1444 1444 NH Bremerton 1 Boone Road Bremerton Bremerton WA 98312 KITSAP (360) 475-4232 Acute Care - Department of Defense Department of Defense FALSE 47.5935710 -122.6929400 0   35 53 53035 14740 Seattle-Tacoma, WA Central Kitsap County https://data.medicare.gov/resource/xubh-q36u/row-u4p2.49ji-8aqj                                      
3583 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
2621 2621 CHOCTAW NATION HEALTH SERVICES AUTHORITY 1 CHOCTAW WAY TALIHINA OK 74571 LATIMER (918) 567-7000 Acute Care Hospitals Tribal TRUE 34.7537210 -95.0819060 0   77 40 40077         https://data.medicare.gov/resource/xubh-q36u/row-32zv~xccv_piej 370172 651345 2019-07-02 2018-09-30 43           43               43
372 372 COOPER UNIVERSITY HOSPITAL 1 COOPER PLAZA CAMDEN NJ 8103 CAMDEN (856) 342-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9408020 -75.1157570 0   7 34 34007 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Camden County https://data.medicare.gov/resource/xubh-q36u/row-nkr7.hdmt_ja2d 310014 649466 2019-05-31 2018-12-31 483 30 12       574               574
516 516 ELLIOT HOSPITAL 1 ELLIOT WAY MANCHESTER NH 3103 HILLSBOROUGH (603) 669-5300 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9827950 -71.4357390 0   11 33 33011 31700 Boston-Worcester-Providence, MA-RI-NH-CT Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-eaev.u4vg~83e6 300012 661552 2019-12-03 2019-06-30 183 16         199 41             240
2694 2694 GOOD SAMARITAN REGIONAL HLTH CENTER 1 GOOD SAMARITAN WAY MOUNT VERNON IL 62864 JEFFERSON (618) 899-1469 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.3149000 -88.9300000 0   81 17 17081 34500   Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-qn23_km7w-v4im 140046 650987 2019-06-05 2018-12-31 109 15         124   10           134
3212 3212 CORNING HOSPITAL 1 GUTHRIE DRIVE CORNING NY 14830 STEUBEN (607) 937-7200 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.1361070 -76.9698410 0   101 36 36101 18500 Elmira-Corning, NY Central Steuben County https://data.medicare.gov/resource/xubh-q36u/row-vtnd.wrz6_d7zv 330277 662233 2019-12-02 2019-06-30 57 8         65               65
4743 4743 CARILION STONEWALL JACKSON HOSPITAL 1 HEALTH CIRCLE LEXINGTON VA 24450 LEXINGTON CITY (540) 458-3503 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.7784550 -79.4420490 0   678 51 51678         https://data.medicare.gov/resource/xubh-q36u/row-3ya6.eex3~uuep 491304 652554 2019-07-25 2018-09-30 25           25               25
130 130 BROADDUS HOSPITAL ASSOCIATION, INC 1 HEALTHCARE DRIVE MANSFIELD HILL PHILIPPI WV 26416 BARBOUR (304) 457-1760 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1528870 -80.0440910 0   1 54 54001         https://data.medicare.gov/resource/xubh-q36u/row-njqv~ij6d.yec2 511300 650429 2019-05-31 2018-12-31 12           12       60       72
2330 2330 WAR MEMORIAL HOSPITAL INC 1 HEALTHY WAY BERKELEY SPRINGS WV 25411 MORGAN (304) 258-1234 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.6409230 -78.1998700 0   65 54 54065         https://data.medicare.gov/resource/xubh-q36u/row-z76q-7r93.w77s 511309 648370 2019-05-09 2018-12-31 25           25         16     41
2914 2914 MASSENA MEMORIAL HOSPITAL 1 HOSPITAL DRIVE MASSENA NY 13662 ST. LAWRENCE (315) 764-1711 Acute Care Hospitals Government - Local TRUE 44.9363440 -74.9078280 0   89 36 36089 36300   Central St. Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-ysnc_8hd4_9yyh 330223 659330 2019-11-07 2018-12-31 46 4         50               50
2981 2981 GRAFTON CITY HOSPITAL 1 HOSPITAL PLAZA GRAFTON WV 26354 TAYLOR (304) 265-0400 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3440370 -80.0244130 0   91 54 54091 17220   Outlying Taylor County https://data.medicare.gov/resource/xubh-q36u/row-hp88-6y9g.r8fy 511307 661124 2019-11-27 2019-06-30 25           25               25
1249 1249 INGALLS MEMORIAL HOSPITAL 1 INGALLS DRIVE HARVEY IL 60426 COOK (708) 333-2300 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.6063310 -87.6594840 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-vjp9-dpap-bkr6 140191 660514 2019-11-26 2019-06-30 243 25         268 16 42           326
159 159 Tripler AMC (FT Shafter) 1 Jarrett White Rd Honolulu HI 96859 HONOLULU (808) 433-2778 Acute Care - Department of Defense Department of Defense TRUE 21.3588670 -157.8887690 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-xb5h~t6w7_qec8                                      
84 84 KAU HOSPITAL 1 KAMANI STREET PAHALA HI 96777 HAWAII (808) 928-8331 Critical Access Hospitals Government - State TRUE 19.2005710 -155.4720970 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-jcnf-fhnk_q5i3 121301 662188 2019-12-02 2019-06-30 6           6               6
1536 1536 KISHWAUKEE COMMUNITY HOSPITAL 1 KISH HOSPITAL DRIVE DEKALB IL 60115 DE KALB (815) 756-1521 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9618800 -88.7222600 0   37 17 17037 16980 Chicago-Naperville, IL-IN-WI Outlying DeKalb County https://data.medicare.gov/resource/xubh-q36u/row-hrvn~xgi9.izzd 140286 657818 2019-02-04 2018-08-31 86 12         98               98
3412 3412 COMMONWEALTH HEALTH CENTER 1 LOWER NAVY HILL ROAD (PO BOX 409CK) GARAPAN MP 96950 SAIPAN (670) 234-8950 Acute Care Hospitals Proprietary TRUE 15.2086299 145.7303467 1 GEOMETRIC_CENTER 110 69 69110         https://data.medicare.gov/resource/xubh-q36u/row-z8uz.de7b_sx86 660001 644688 2019-03-01 2018-09-30 70 4         74               74
1723 1723 ADVENTIST HEALTH HOWARD MEMORIAL 1 MARCELA DR WILLITS CA 95490 MENDOCINO (707) 456-3031 Critical Access Hospitals Voluntary non-profit - Church TRUE 39.3897770 -123.3399710 0   45 6 6045 46380   Central Mendocino County https://data.medicare.gov/resource/xubh-q36u/row-ecr7.pfkq_ummb 51310 648599 2019-05-29 2018-12-31 21 4         25               25
3924 3924 COOKEVILLE REGIONAL MEDICAL CENTER 1 MEDICAL CENTER BOULEVARD COOKEVILLE TN 38501 PUTNAM (931) 783-2000 Acute Care Hospitals Government - Local TRUE 36.1699600 -85.5093500 0   141 47 47141 18260   Central Putnam County https://data.medicare.gov/resource/xubh-q36u/row-huvy_sdvh_bsx2 440059 660310 2019-11-26 2019-06-30 173 38         211   20           231
849 849 NOVANT HEALTH BRUNSWICK MEDICAL CENTER 1 MEDICAL CENTER DR PO BOX 139 SUPPLY NC 28462 BRUNSWICK (910) 755-8121 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.0090920 -78.2899230 0   19 37 37019 34820 Myrtle Beach-Conway, SC-NC Central Brunswick County https://data.medicare.gov/resource/xubh-q36u/row-6hdf-qvep.ppy9 340158 650348 2019-05-31 2018-12-31 42 19         61               61
450 450 MARY HITCHCOCK MEMORIAL HOSPITAL 1 MEDICAL CENTER DRIVE LEBANON NH 3756 GRAFTON (603) 650-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.6779700 -72.2737460 0   9 33 33009 17200   Central Grafton County https://data.medicare.gov/resource/xubh-q36u/row-vy5p~59uc_9gzu 300003 661551 2019-12-02 2019-06-30 311 48 12     30 401 21             422
1268 1268 SOUTHERN MAINE HEALTH CARE 1 MEDICAL CENTER DRIVE BIDDEFORD ME 4005 YORK (207) 283-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.4784360 -70.4921740 0   31 23 23031 38860 Portland-Lewiston-South Portland, ME Central York County https://data.medicare.gov/resource/xubh-q36u/row-am4g_dvue_z9bw 200019 649741 2019-05-30 2018-12-31 131 9         140 12     74   38   264
2787 2787 MIDWEST MEDICAL CENTER 1 MEDICAL CENTER DRIVE GALENA IL 61036 JO DAVIESS (815) 777-1340 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.4466220 -90.4569720 0   85 17 17085         https://data.medicare.gov/resource/xubh-q36u/row-gqwe-keau_be9a 141302 645763 2019-03-04 2018-09-30 25           25       5   52   82
2417 2417 WHEELING HOSPITAL 1 MEDICAL PARK WHEELING WV 26003 OHIO (304) 243-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.0600740 -80.6840220 0   69 54 54069 48540   Central Ohio County https://data.medicare.gov/resource/xubh-q36u/row-s497_dubq_q36x 510050 645204 2019-02-28 2018-09-30 201 22         223       125       348
979 979 MUSC HEALTH CHESTER MEDICAL CENTER 1 MEDICAL PARK DRIVE CHESTER SC 29706 CHESTER (803) 581-3151 Acute Care Hospitals Proprietary TRUE 34.6834290 -81.1845510 0   23 45 45023 16740 Charlotte-Concord, NC-SC Outlying Chester County https://data.medicare.gov/resource/xubh-q36u/row-uikk_hqcf-3s3p 420019 655231 2019-10-10 2019-06-30 36 6         42       80       122
4502 4502 PAMPA REGIONAL MEDICAL CENTER 1 MEDICAL PLAZA PAMPA TX 79065 GRAY (806) 665-3721 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.6569910 -101.4079640 0   233 48 48233 14420 Amarillo-Borger, TX Central Hutchinson County https://data.medicare.gov/resource/xubh-q36u/row-vnbp-jjs8.azu9 450099 662430 2019-12-23 2018-12-31 89 8         97 13             110
3554 3554 ST ELIZABETH MEDICAL CENTER NORTH 1 MEDICAL VILLAGE DRIVE EDGEWOOD KY 41017 KENTON (859) 301-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.0146830 -84.5618420 0   117 21 21117 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Kenton County https://data.medicare.gov/resource/xubh-q36u/row-p4sw.qxxk.8aju 180035 645554 2019-03-15 2018-12-31 380 46 8     25 459           16   475
1540 1540 VIA CHRISTI HOSPITAL PITTSBURG INC 1 MT CARMEL WAY PITTSBURG KS 66762 CRAWFORD (620) 231-6100 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3815300 -94.6838500 0   37 20 20037 38260   Central Crawford County https://data.medicare.gov/resource/xubh-q36u/row-vkqa-3pn8_khmc 170006 654017 2019-08-29 2019-03-31 54 12         66   12           78
4455 4455 HASKELL MEMORIAL HOSPITAL 1 NORTH AVENUE N PO BOX 1117 HASKELL TX 79521 HASKELL (940) 864-2621 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.1572901 -99.7446581 1 ROOFTOP 207 48 48207         https://data.medicare.gov/resource/xubh-q36u/row-66f3~mect.vjwe 451341 644375 2019-03-01 2018-09-30 25           25               25
697 697 PARKLAND MEDICAL CENTER 1 PARKLAND DRIVE DERRY NH 3038 ROCKINGHAM (603) 421-2100 Acute Care Hospitals Proprietary TRUE 42.8758250 -71.3175780 0   15 33 33015 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Rockingham County https://data.medicare.gov/resource/xubh-q36u/row-m9nh.dqhg_kjyp 300017 659515 2019-11-07 2018-07-31 60 8         68 18             86
4066 4066 AKRON CHILDREN'S HOSPITAL 1 PERKINS SQUARE AKRON OH 44308 SUMMIT (330) 543-1000 Childrens Voluntary non-profit - Private FALSE 41.0784210 -81.5267890 0   153 39 39153 10420 Cleveland-Akron-Canton, OH Central Summit County https://data.medicare.gov/resource/xubh-q36u/row-g6bs.ki8j-vwqu 363303 649334 2019-05-31 2018-12-31 303 23   12     402               402
647 647 NH Beaufort 1 Pinckney Blvd Beaufort SC 29902 BEAUFORT (843) 228-5600 Acute Care - Department of Defense Department of Defense FALSE 32.3889769 -80.6825821 1 ROOFTOP 13 45 45013 25940   Central Beaufort County https://data.medicare.gov/resource/xubh-q36u/row-uc4x_u34w~fpt9                                      
3026 3026 KAISER FOUNDATION HOSPITAL - VACAVILLE 1 QUALITY DRIVE VACAVILLE CA 95688 SOLANO (707) 624-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.3900730 -121.9367760 0   95 6 6095 46700 San Jose-San Francisco-Oakland, CA Central Solano County https://data.medicare.gov/resource/xubh-q36u/row-iv5d~mht4.m24m 50767 649704 2019-06-06 2018-12-31 124 16         140               140
1208 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
2049 2049 TAMPA GENERAL HOSPITAL 1 TAMPA GENERAL CIR TAMPA FL 33606 HILLSBOROUGH (813) 844-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 27.9372720 -82.4591280 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-wsdc~nyp9_puqz 100128 644241 2019-02-27 2018-09-30 698 77 30 6 18 9 920   59           979
1031 1031 DELAWARE VALLEY HOSPITAL, INC 1 TITUS PLACE WALTON NY 13856 DELAWARE (607) 865-2188 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1655220 -75.1280870 0   25 36 36025         https://data.medicare.gov/resource/xubh-q36u/row-uc93-ncuj~cmjn 331312 649637 2019-06-13 2018-12-31 25           25               25
2034 2034 MANGUM REGIONAL MEDICAL CENTER 1 WICKERSHAM DRIVE MANGUM OK 73554 GREER (580) 782-3353 Critical Access Hospitals Proprietary TRUE 34.8918230 -99.5023410 0   55 40 40055         https://data.medicare.gov/resource/xubh-q36u/row-irnc.n45b.ecpm 371330 649816 2019-05-31 2018-12-31 18           18               18
3644 3644 GLACIAL RIDGE HOSPITAL 10 4TH AVENUE SOUTHEAST GLENWOOD MN 56334 POPE (320) 634-4521 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.6467570 -95.3898700 0   121 27 27121         https://data.medicare.gov/resource/xubh-q36u/row-ip3d~zsv9-xzxg 241376 644297 2019-03-11 2018-09-30 19           19               19
451 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
1102 1102 MCLEOD HEALTH CLARENDON 10 EAST HOSPITAL STREET MANNING SC 29102 CLARENDON (803) 435-8463 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6878660 -80.2117670 0   27 45 45027         https://data.medicare.gov/resource/xubh-q36u/row-vf43_k4z3~k3q8 420109 645363 2019-03-01 2018-09-30 43 6         49               49
3444 3444 ELLENVILLE REGIONAL HOSPITAL 10 HEALTHY WAY ELLENVILLE NY 12428 ULSTER (845) 647-6400 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.7323510 -74.3806240 0   111 36 36111 28740 New York-Newark, NY-NJ-CT-PA Central Ulster County https://data.medicare.gov/resource/xubh-q36u/row-yusu_wb8x.4xxv 331310 655468 2019-10-07 2018-12-31 15           15               15
4310 4310 BARNES-JEWISH ST PETERS HOSPITAL 10 HOSPITAL DR SAINT PETERS MO 63376 ST. CHARLES (636) 916-9000 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.7927190 -90.5793770 0   183 29 29183 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Charles County https://data.medicare.gov/resource/xubh-q36u/row-gxh6-ch3x~ctn8 260191 654455 2019-05-31 2018-12-31 97 16         113               113
279 279 BRIDGTON HOSPITAL 10 HOSPITAL DRIVE BRIDGTON ME 4009 CUMBERLAND (207) 647-6000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0472490 -70.7127770 0   5 23 23005 38860 Portland-Lewiston-South Portland, ME Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-xeqw-dspw~ebr9 201310 662214 2019-12-02 2019-06-30 25           25               25
4218 4218 PARKVIEW WABASH HOSPITAL, INC 10 JOHN KISSINGER DRIVE WABASH IN 46992 WABASH (260) 563-3131 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.8187700 -85.8291260 0   169 18 18169 47340   Central Wabash County https://data.medicare.gov/resource/xubh-q36u/row-dnku-8krd-rp9e 151310 652350 2019-07-10 2018-12-31 18           18               18
2910 2910 CLARK FORK VALLEY HOSPITAL 10 KRUGER RD PLAINS MT 59859 SANDERS (406) 826-4800 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.4695390 -114.8919080 0   89 30 30089         https://data.medicare.gov/resource/xubh-q36u/row-325u_sses_9br7 271323 649796 2019-05-24 2018-12-31 16           16       28       44
1715 1715 LINCOLN HOSPITAL 10 NICHOLS STREET DAVENPORT WA 99122 LINCOLN (509) 725-7101 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.6571949 -118.1462384 1 RANGE_INTERPOLATED 43 53 53043         https://data.medicare.gov/resource/xubh-q36u/row-3c5v_e33f-mmva 501305 647597 2019-05-13 2018-12-31 25           25               25
2802 2802 STANDING ROCK INDIAN HEALTH SERVICE HOSPITAL 10 NORTH RIVER ROAD FORT YATES ND 58538 SIOUX (701) 854-3831 Acute Care Hospitals Government - Federal TRUE 46.0952325 -100.6281136 1 ROOFTOP 85 38 38085 13900   Outlying Sioux County https://data.medicare.gov/resource/xubh-q36u/row-a84q-rj3h~6yed 350064 651228 2019-06-18 2018-09-30 12           12               12
3877 3877 COOK HOSPITAL 10 SE FIFTH ST COOK MN 55723 ST. LOUIS (218) 666-5945 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.8534680 -92.6800320 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-buxd.3b5c~u3h4 241312 649042 2019-05-21 2018-12-31 14           14       28       42
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
437 437 MOUNT DESERT ISLAND HOSPITAL 10 WAYMAN LANE, PO BOX 8 BAR HARBOR ME 4609 HANCOCK (207) 288-5081 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3843690 -68.2023310 0   9 23 23009         https://data.medicare.gov/resource/xubh-q36u/row-egex~7j5d.98hj 201304 654844 2019-09-30 2019-04-30 25           25               25
1993 1993 ADVENTIST HEALTH ST HELENA 10 WOODLAND ROAD SAINT HELENA CA 94574 NAPA (707) 963-3611 Acute Care Hospitals Voluntary non-profit - Private FALSE 38.5419600 -122.4753440 0   55 6 6055 34900 San Jose-San Francisco-Oakland, CA Central Napa County https://data.medicare.gov/resource/xubh-q36u/row-v9r8~wyzg.agw4 50013 649700 2019-06-03 2018-12-31 105 12         117 13             130
374 374 UNITED HEALTH SERVICES HOSPITALS, INC 10-42 MITCHELL AVENUE BINGHAMTON NY 13903 BROOME (607) 763-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0880970 -75.9141660 0   7 36 36007 13780   Central Broome County https://data.medicare.gov/resource/xubh-q36u/row-4qmi-bk4h.k68x 330394 649636 2019-05-29 2018-12-31 322 37       14 373 56 22   23       474
4752 4752 NORTON COMMUNITY HOSPITAL 100 15TH NW STREET NORTON VA 24273 NORTON CITY (276) 439-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.9320310 -82.6433800 0   720 51 51720 13720   Central Norton city https://data.medicare.gov/resource/xubh-q36u/row-z9rr.uwbu~pseu 490001 643467 2019-02-22 2018-09-30 54 11         65   13           78
2227 2227 VALLEY REGIONAL MEDICAL CENTER 100 A ALTON GLOOR BROWNSVILLE TX 78526 CAMERON (956) 350-7000 Acute Care Hospitals Proprietary TRUE 25.9780246 -97.5146344 1 ROOFTOP 61 48 48061 15180 Brownsville-Harlingen-Raymondville, TX Central Cameron County https://data.medicare.gov/resource/xubh-q36u/row-8upk-rgcf.533w 450662 653217 2019-08-28 2019-03-31 186 18       10 214               214
3351 3351 UNC LENOIR HEALTH CARE 100 AIRPORT RD KINSTON NC 28501 LENOIR (252) 522-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.2909550 -77.5814070 0   107 37 37107 28820   Central Lenoir County https://data.medicare.gov/resource/xubh-q36u/row-i39f~xti3.gs6h 340027 659710 2019-11-26 2019-06-30 1072   14       1086   17           1103
371 371 VIRTUA WEST JERSEY HOSPITALS VOORHEES 100 BOWMAN DRIVE VOORHEES NJ 8043 CAMDEN (856) 247-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8423270 -74.9278920 0   7 34 34007 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Camden County https://data.medicare.gov/resource/xubh-q36u/row-gtsh-gq9y.2jxt 310022 648552 2019-05-23 2018-12-31 463 48       30 587               587
1141 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
3835 3835 NMC Camp Lejeune 100 Brewster Boulevard Camp Lejeune NC 28547 ONSLOW (910) 450-4300 Acute Care - Department of Defense Department of Defense TRUE 34.7167710 -77.3570760 0   133 37 37133 27340   Central Onslow County https://data.medicare.gov/resource/xubh-q36u/row-tu4z~ui2b-p93g                                      
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
2905 2905 JEWELL COUNTY HOSPITAL 100 CRESTVUE AVE MANKATO KS 66956 JEWELL (785) 378-3137 Critical Access Hospitals Government - Local TRUE 39.7870540 -98.2012980 0   89 20 20089         https://data.medicare.gov/resource/xubh-q36u/row-gu6a_d9d9-pvcm 171309 648112 2019-05-23 2018-12-31 24           24               24
3816 3816 ADENA PIKE MEDICAL CENTER 100 DAWN LANE WAVERLY OH 45690 PIKE (740) 947-2186 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1165050 -83.0058270 0   131 39 39131         https://data.medicare.gov/resource/xubh-q36u/row-zm47~vagh-p87t 361334 649331 2019-05-31 2018-12-31 25           25               25
4184 4184 HARRISBURG MEDICAL CENTER 100 DOCTOR WARREN TUTTLE DR HARRISBURG IL 62946 SALINE (618) 253-7671 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.7310271 -88.5248600 1 ROOFTOP 165 17 17165         https://data.medicare.gov/resource/xubh-q36u/row-8u5r_n3xt~tnqf 140210 660516 2019-11-27 2019-06-30 40           40 30             70
414 414 CONNECTICUT HOSPICE INC,THE 100 DOUBLE BEACH ROAD BRANFORD CT 6405 NEW HAVEN (203) 315-7500 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.2563050 -72.8333670 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-9pw4-ddrr.eyyi 70038 645241 2019-03-01 2018-09-30 6           6           46   52
4371 4371 CITIZENS MEDICAL CENTER 100 E COLLEGE DRIVE COLBY KS 67701 THOMAS (785) 462-7511 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3797550 -101.0450490 0   193 20 20193         https://data.medicare.gov/resource/xubh-q36u/row-j79a-8e2n-6khj 171362 647619 2019-05-06 2018-12-31 20 1         21       57       78
1645 1645 HERINGTON MUNICIPAL HOSPITAL 100 E HELEN STREET HERINGTON KS 67449 DICKINSON (785) 258-2207 Critical Access Hospitals Voluntary non-profit - Other TRUE 38.6795610 -96.9422740 0   41 20 20041         https://data.medicare.gov/resource/xubh-q36u/row-sgwx~evd5.tciy 171340 661326 2019-12-03 2019-06-30 15           15               15
2966 2966 EAGLEVILLE HOSPITAL 100 EAGLEVILLE RD EAGLEVILLE PA 19408 MONTGOMERY (215) 539-6000 Acute Care Hospitals Voluntary non-profit - Private FALSE 40.1558800 -75.4119200 0   91 42 42091 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-zvfs.t6e9.gp6r 390278 660447 2019-12-03 2019-06-30 49           49 34             83
2204 2204 LENOX HILL HOSPITAL 100 EAST 77TH STREET NEW YORK NY 10021 NEW YORK (212) 439-2345 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7739640 -73.9606110 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-bw8f_jei6~sfm5 330119 650194 2019-05-30 2018-12-31 348 24 22     28 422 27             449
1739 1739 PENINSULA REGIONAL MEDICAL CENTER 100 EAST CARROLL AVENUE SALISBURY MD 21801 WICOMICO (410) 543-7111 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.3630680 -75.5994890 0   45 24 24045 41540   Central Wicomico County https://data.medicare.gov/resource/xubh-q36u/row-62af-vb87-gfug 210019 659801 2019-11-26 2019-06-30 264 24         288               288
4376 4376 CGH MEDICAL CENTER 100 EAST LEFEVRE ROAD STERLING IL 61081 WHITESIDE (815) 625-0400 Acute Care Hospitals Government - Local TRUE 41.8015640 -89.6967330 0   195 17 17195 44580 Dixon-Sterling, IL Central Whiteside County https://data.medicare.gov/resource/xubh-q36u/row-r8ij~7z4w-xsmp 140043 654428 2019-09-25 2019-04-30 87 9         96               96
3654 3654 UPMC NORTHWEST 100 FAIRFIELD DRIVE SENECA PA 16346 VENANGO (814) 676-7600 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.3600260 -79.7079260 0   121 42 42121 36340   Central Venango County https://data.medicare.gov/resource/xubh-q36u/row-tp8h_cf6h_y9en 390091 661096 2019-11-26 2019-06-30 110 8         118 28 9   16       171
4737 4737 SOUTHAMPTON MEMORIAL HOSPITAL 100 FAIRVIEW DRIVE - PO BOX 817 FRANKLIN VA 23851 FRANKLIN CITY (757) 569-6100 Acute Care Hospitals Proprietary TRUE 36.6911710 -76.9349420 0   620 51 51620         https://data.medicare.gov/resource/xubh-q36u/row-f6hb_is78~t7qx 490092 649152 2019-05-29 2018-12-31 67 8         75       13 116     204
1468 1468 CATALINA ISLAND MEDICAL CENTER 100 FALLS CANYON ROAD AVALON CA 90704 LOS ANGELES (310) 510-0700 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.3390790 -118.3304770 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-8vi9~ashp_y9rx 51307 638364 2018-11-29 2018-06-30 8           8       4       12
3752 3752 CARRIS HEALTH - REDWOOD, LLC 100 FALLWOOD ROAD REDWOOD FALLS MN 56283 REDWOOD (507) 637-4500 Critical Access Hospitals Government - Local TRUE 44.5370300 -95.1072680 0   127 27 27127         https://data.medicare.gov/resource/xubh-q36u/row-nr7s_ak8r_x54m 241351 661207 2019-11-27 2019-06-30 25           25           4   29
4469 4469 PIEDMONT COLUMBUS REGIONAL NORTHSIDE 100 FRIST COURT COLUMBUS GA 31909 MUSCOGEE (706) 494-2101 Acute Care Hospitals Proprietary FALSE 32.5358800 -84.9543830 0   215 13 13215 17980 Columbus-Auburn-Opelika, GA-AL Central Muscogee County https://data.medicare.gov/resource/xubh-q36u/row-47ty.e7ix~4f7m 110200 659661 2019-11-15 2019-06-30 53 5         58   29           87
146 146 HOSPITAL OF CENTRAL CONNECTICUT, THE 100 GRAND STREET NEW BRITAIN CT 6050 HARTFORD (860) 224-5011 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.6620150 -72.7877990 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-wbxc-gjw3~i99u 70035 645240 2019-03-01 2018-09-30 222 24         246 32             278
1776 1776 CHI MEMORIAL HOSPITAL- GEORGIA 100 GROSS CRESCENT CIRCLE FORT OGLETHORPE GA 30742 CATOOSA (770) 874-5400 Acute Care Hospitals Proprietary TRUE 34.9477700 -85.2627560 0   47 13 13047 16860 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Catoosa County https://data.medicare.gov/resource/xubh-q36u/row-a96y-gfhv_jnf7 110236 659941 2019-11-27 2019-06-30 36           36               36
592 592 CENTURA HEALTH-AVISTA ADVENTIST HOSPITAL 100 HEALTH PARK DR LOUISVILLE CO 80027 BOULDER (303) 673-1280 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.9508470 -105.1491540 0   13 8 8013 14500 Denver-Aurora, CO Central Boulder County https://data.medicare.gov/resource/xubh-q36u/row-mqpm_6h4w_if8p 60103 649709 2019-06-03 2018-12-31 74 8         108               108
3785 3785 RENVILLE COUNTY HOSPITAL AND CLINICS 100 HEALTHY WAY OLIVIA MN 56277 RENVILLE (320) 523-1261 Critical Access Hospitals Government - Local TRUE 44.7747296 -94.9724885 1 ROOFTOP 129 27 27129         https://data.medicare.gov/resource/xubh-q36u/row-9bry_ub3h~y6xn 241306 652484 2019-07-29 2018-12-31 16           16           16   32
1158 1158 KALEIDA HEALTH 100 HIGH STREET BUFFALO NY 14210 ERIE (716) 859-8620 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9003290 -78.8649370 0   29 36 36029 15380 Buffalo-Cheektowaga, NY Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-xn8m_fv8h.at49 330005 650732 2019-05-31 2018-12-31 750 70 29   31 74 954   34   80       1068
4567 4567 BAYLOR SCOTT & WHITE MEDICAL CENTER HILLCREST 100 HILLCREST MEDICAL BLVD WACO TX 76712 MC LENNAN (254) 202-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.4892120 -97.1568040 0   309 48 48309 47380   Central McLennan County https://data.medicare.gov/resource/xubh-q36u/row-akp7_94sn-823t 450101 660713 2019-01-30 2018-08-31 158 12 12     30 212   24           236
1352 1352 PENN HIGHLANDS DUBOIS 100 HOSPITAL AVENUE DUBOIS PA 15801 CLEARFIELD (814) 371-2200 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.1143490 -78.7757360 0   33 42 42033 20180 State College-DuBois, PA Central Clearfield County https://data.medicare.gov/resource/xubh-q36u/row-sdwi.9s2j~tfd8 390086 661632 2019-12-02 2019-06-30 158 15 12     16 201   15           216
247 247 SOUTHWESTERN VERMONT MEDICAL CENTER 100 HOSPITAL DRIVE BENNINGTON VT 5201 BENNINGTON (802) 442-6361 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.8739110 -73.2043430 0   3 50 50003 13540   Central Bennington County https://data.medicare.gov/resource/xubh-q36u/row-jv4q-u445-esay 470012 644194 2019-02-28 2018-09-30 68 10         78               78
600 600 ST LUKE'S WOOD RIVER MEDICAL CENTER 100 HOSPITAL DRIVE KETCHUM ID 83340 BLAINE (208) 727-8800 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.6484730 -114.3490180 0   13 16 16013 25200   Central Blaine County https://data.medicare.gov/resource/xubh-q36u/row-pewx.ysiv~gtnq 131323 651610 2019-06-21 2018-09-30 25           25               25
2918 2918 PARK RIDGE HEALTH 100 HOSPITAL DRIVE HENDERSONVILLE NC 28792 HENDERSON (828) 684-8501 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.3919070 -82.4880560 0   89 37 37089 11700 Asheville-Brevard, NC Central Henderson County https://data.medicare.gov/resource/xubh-q36u/row-vee9-e3bs~tdmz 340023 650763 2019-05-31 2018-12-31 59 14         73 25             98
3318 3318 MERCY HOSPITAL LEBANON 100 HOSPITAL DRIVE LEBANON MO 65536 LACLEDE (417) 533-6100 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.6814370 -92.6358750 0   105 29 29105 30060   Central Laclede County https://data.medicare.gov/resource/xubh-q36u/row-rqaa-p66y~a4xf 260059 661028 2019-11-27 2019-06-30 39 4         43               43
3540 3540 ENDLESS MOUNTAINS HEALTH SYSTEMS 100 HOSPITAL DRIVE MONTROSE PA 18801 SUSQUEHANNA (570) 278-3801 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.8357300 -75.8369780 0   115 42 42115         https://data.medicare.gov/resource/xubh-q36u/row-h7jz~8upv_p2yw 391306 650204 2019-05-31 2018-12-31 25           25               25
3562 3562 BAPTIST MEMORIAL HOSPITAL BOONEVILLE 100 HOSPITAL DRIVE BOONEVILLE MS 38829 PRENTISS (662) 720-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.6563370 -88.5657630 0   117 28 28117         https://data.medicare.gov/resource/xubh-q36u/row-yxvp-p3fk_sfj3 250044 644040 2019-02-26 2018-09-30 28   11       39 15             54
4002 4002 WALTHALL COUNTY GENERAL HOSPITAL CAH 100 HOSPITAL DRIVE TYLERTOWN MS 39667 WALTHALL (601) 876-2122 Critical Access Hospitals Government - Local TRUE 31.1195830 -90.1556180 0   147 28 28147         https://data.medicare.gov/resource/xubh-q36u/row-zr2m~67zx~8i4c 251324 652148 2019-07-29 2018-09-30 25           25               25
440 440 CALVERTHEALTH MEDICAL CENTER 100 HOSPITAL ROAD PRINCE FREDERICK MD 20678 CALVERT (410) 535-8240 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.5586010 -76.5977880 0   9 24 24009 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Outlying Calvert County https://data.medicare.gov/resource/xubh-q36u/row-drgp~v466-b8rt 210039 658674 2019-11-12 2019-06-30 64 4         68               68
2322 2322 PENN HIGHLANDS BROOKVILLE 100 HOSPITAL ROAD BROOKVILLE PA 15825 JEFFERSON (814) 849-2312 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.1564730 -79.0928840 0   65 42 42065         https://data.medicare.gov/resource/xubh-q36u/row-5dtj-fqtw.9nmm 391312 660451 2019-11-26 2019-06-30 25           25 10             35
400 400 BRAXTON COUNTY MEMORIAL HOSPITAL 100 HOYLMAN DRIVE GASSAWAY WV 26624 BRAXTON (304) 364-5156 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.6601260 -80.7483340 0   7 54 54007         https://data.medicare.gov/resource/xubh-q36u/row-4gv3_6ku8_c448 511308 648873 2019-05-21 2018-12-31 25           25               25

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