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 PRVDR_NUM

✎ 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
2384 2384 SOUTHEAST ALABAMA MEDICAL CENTER 1108 ROSS CLARK CIRCLE DOTHAN AL 36301 HOUSTON (334) 793-8701 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.2140580 -85.3617250 0   69 1 1069 20020 Dothan-Enterprise-Ozark, AL Central Houston County https://data.medicare.gov/resource/xubh-q36u/row-qib2_2qqh~zmw8 10001 644080 2019-03-01 2018-09-30 271 40       16 327               327
3021 3021 MARSHALL MEDICAL CENTERS SOUTH CAMPUS 2505 U S HIGHWAY 431 NORTH BOAZ AL 35957 MARSHALL (256) 593-8310 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.2216880 -86.1607098 1 ROOFTOP 95 1 1095 10700 Huntsville-Decatur-Albertville, AL Central Marshall County https://data.medicare.gov/resource/xubh-q36u/row-qhdt_aeut-3iwd 10005 644081 2019-02-28 2018-09-30 184 20         204               204
2589 2589 NORTH ALABAMA MEDICAL CENTER 1701 VETERANS DRIVE FLORENCE AL 35630 LAUDERDALE (256) 768-8400 Acute Care Hospitals Proprietary TRUE 34.8027560 -87.6521910 0   77 1 1077 22520   Central Lauderdale County https://data.medicare.gov/resource/xubh-q36u/row-n9pr_q6au_cg3t 10006 660158 2019-12-02 2019-06-30 181 36 16       233               233
1579 1579 MIZELL MEMORIAL HOSPITAL 702 N MAIN ST OPP AL 36467 COVINGTON (334) 493-3541 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.2919720 -86.2554150 0   39 1 1039         https://data.medicare.gov/resource/xubh-q36u/row-syeg~nab9~7ee4 10007 644003 2019-02-27 2018-09-30 40 5         45 14             59
1631 1631 CRENSHAW COMMUNITY HOSPITAL 101 HOSPITAL CIRCLE LUVERNE AL 36049 CRENSHAW (334) 335-3374 Acute Care Hospitals Proprietary TRUE 31.6925950 -86.2661560 0   41 1 1041         https://data.medicare.gov/resource/xubh-q36u/row-7kz6.2gr2.w3cp 10008 647847 2019-05-15 2018-12-31 29           29 20             49
2502 2502 ST VINCENT'S EAST 50 MEDICAL PARK EAST DRIVE BIRMINGHAM AL 35235 JEFFERSON (205) 838-3122 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5953510 -86.6651820 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-tfdr.ige8~3px7 10011 659397 2019-11-22 2019-06-30 209 30 56   14   309 20 20           349
1826 1826 DEKALB REGIONAL MEDICAL CENTER 200 MED CENTER DRIVE FORT PAYNE AL 35968 DE KALB (256) 845-3150 Acute Care Hospitals Proprietary TRUE 34.4419753 -85.7550138 1 ROOFTOP 49 1 1049         https://data.medicare.gov/resource/xubh-q36u/row-pt4k~hfcs.k9m2 10012 653737 2019-08-22 2019-03-31 85 12         97 18             115
3544 3544 SHELBY BAPTIST MEDICAL CENTER 1000 FIRST STREET NORTH ALABASTER AL 35007 SHELBY (205) 620-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.2536790 -86.8142610 0   117 1 1117 13820 Birmingham-Hoover-Talladega, AL Central Shelby County https://data.medicare.gov/resource/xubh-q36u/row-j68e.5ee5_e79h 10016 651149 2019-05-31 2018-12-31 180 32         212 40             252
2498 2498 UAB CALLAHAN EYE HOSPITAL AUTHORITY 1720 UNIVERSITY BLVD, SUITE 500 BIRMINGHAM AL 35233 JEFFERSON (205) 325-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5031370 -86.8024010 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-txeu_r7zi.ibaa 10018 644082 2019-03-01 2018-09-30 12           12               12
1310 1310 HELEN KELLER MEMORIAL HOSPITAL 1300 SOUTH MONTGOMERY AVENUE SHEFFIELD AL 35660 COLBERT (256) 386-4556 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.7482490 -87.6988660 0   33 1 1033 22520   Central Colbert County https://data.medicare.gov/resource/xubh-q36u/row-jy8a.vhn5.4yjk 10019 644083 2019-02-25 2018-09-30 166 12         178               178
1720 1720 DALE MEDICAL CENTER 126 HOSPITAL AVE OZARK AL 36360 DALE (334) 774-2601 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.4513450 -85.6309660 0   45 1 1045 37120 Dothan-Enterprise-Ozark, AL Central Dale County https://data.medicare.gov/resource/xubh-q36u/row-eeas~xsp4-ap8q 10021 644004 2019-02-20 2018-09-30 71 6         77 12             89
799 799 FLOYD CHEROKEE MEDICAL CENTER 400 NORTHWOOD DR CENTRE AL 35960 CHEROKEE (256) 927-5531 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1627610 -85.6514200 0   19 1 1019         https://data.medicare.gov/resource/xubh-q36u/row-wy8i.rrc6.c8zi 10022 660348 2019-11-27 2019-06-30 45           45               45
3189 3189 BAPTIST MEDICAL CENTER SOUTH 2105 EAST SOUTH BOULEVARD MONTGOMERY AL 36116 MONTGOMERY (334) 288-2100 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.3271440 -86.2767640 0   101 1 1101 33860   Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-fvig.i38a~3f75 10023 660904 2019-12-04 2019-06-30 222 12 18   14 40 320 60             380
3188 3188 JACKSON HOSPITAL & CLINIC INC 1725 PINE STREET MONTGOMERY AL 36106 MONTGOMERY (334) 293-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.3666060 -86.2851550 0   101 1 1101 33860   Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-q2hf.yb6r~vnhh 10024 648173 2019-05-17 2018-12-31 236 34         270               270
2679 2679 EAST ALABAMA MEDICAL CENTER 2000 PEPPERELL PARKWAY OPELIKA AL 36801 LEE (334) 749-3411 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.6380550 -85.4040030 0   81 1 1081 12220 Columbus-Auburn-Opelika, GA-AL Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-vb76-r6it-demb 10029 645461 2019-03-01 2018-09-30 344 20 8       372   17   126       515
2497 2497 UNIVERSITY OF ALABAMA HOSPITAL 619 SOUTH 19TH STREET BIRMINGHAM AL 35233 JEFFERSON (205) 934-4011 Acute Care Hospitals Government - State TRUE 33.5061290 -86.8019220 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-x229.ejr6_kvzz 10033 645809 2019-03-01 2018-09-30 772 37     48   1063 93 49           1205
1886 1886 COMMUNITY HOSPITAL INC 805 FRIENDSHIP ROAD TALLASSEE AL 36078 ELMORE (334) 283-6541 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.5352930 -85.9119960 0   51 1 1051 33860   Central Elmore County https://data.medicare.gov/resource/xubh-q36u/row-i5d8.v68e_q9u7 10034 644198 2019-03-01 2018-09-30 32 5         37 10             47
1680 1680 CULLMAN REGIONAL MEDICAL CENTER 1912 ALABAMA HIGHWAY 157 CULLMAN AL 35058 CULLMAN (256) 737-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.1985870 -86.8056410 0   43 1 1043 18980 Birmingham-Hoover-Talladega, AL Central Cullman County https://data.medicare.gov/resource/xubh-q36u/row-25az.bw5t.5dxy 10035 659467 2019-11-26 2019-06-30 133 12         145               145
1580 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
667 667 STRINGFELLOW MEMORIAL HOSPITAL 301 EAST 18TH ST ANNISTON AL 36201 CALHOUN (256) 235-8900 Acute Care Hospitals Proprietary TRUE 33.6677010 -85.8250250 0   15 1 1015 11500   Central Calhoun County https://data.medicare.gov/resource/xubh-q36u/row-2tt8-gqrt.8qr7 10038 644691 2019-02-28 2018-09-30 119 6         125               125
2879 2879 HUNTSVILLE HOSPITAL 101 SIVLEY RD HUNTSVILLE AL 35801 MADISON (256) 265-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.7212260 -86.5815470 0   89 1 1089 26620 Huntsville-Decatur-Albertville, AL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-srfb_s9fq-erqf 10039 660063 2019-12-02 2019-06-30 713 42 20   25   877 35             912
1990 1990 GADSDEN REGIONAL MEDICAL CENTER 1007 GOODYEAR AVENUE GADSDEN AL 35903 ETOWAH (256) 494-4000 Acute Care Hospitals Proprietary TRUE 34.0093890 -85.9675200 0   55 1 1055 23460   Central Etowah County https://data.medicare.gov/resource/xubh-q36u/row-bfqk~mdpt-2yrq 10040 644005 2019-02-27 2018-09-30 182 40         222 49             271
2985 2985 MARION REGIONAL MEDICAL CENTER 1256 MILITARY STREET SOUTH HAMILTON AL 35570 MARION (205) 921-6200 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1258520 -87.9898060 0   93 1 1093         https://data.medicare.gov/resource/xubh-q36u/row-ak6z-c9hr~7upb 10044 643754 2019-02-28 2018-09-30 32 4         36       79       115
2045 2045 FAYETTE MEDICAL CENTER 1653 TEMPLE AVENUE NORTH FAYETTE AL 35555 FAYETTE (205) 932-5966 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.7077080 -87.8237060 0   57 1 1057         https://data.medicare.gov/resource/xubh-q36u/row-f7kw.zhbj_gfwf 10045 644692 2019-02-28 2018-09-30 37 8         45       122       167
1991 1991 RIVERVIEW REGIONAL MEDICAL CENTER 600 SOUTH THIRD STREET GADSDEN AL 35901 ETOWAH (256) 543-5200 Acute Care Hospitals Proprietary TRUE 34.0038110 -86.0040860 0   55 1 1055 23460   Central Etowah County https://data.medicare.gov/resource/xubh-q36u/row-82ed.hku7_uzsa 10046 653738 2019-08-23 2018-12-31 240   16       256 25             281
1197 1197 MEDICAL CENTER ENTERPRISE 400 N EDWARDS STREET ENTERPRISE AL 36330 COFFEE (334) 347-0584 Acute Care Hospitals Proprietary TRUE 31.3181910 -85.8553080 0   31 1 1031 21460 Dothan-Enterprise-Ozark, AL Central Coffee County https://data.medicare.gov/resource/xubh-q36u/row-m58x_64pa.z9zi 10049 648587 2019-05-24 2018-12-31 92 7         99               99
2238 2238 GREENE COUNTY HOSPITAL 509 WILSON AVENUE EUTAW AL 35462 GREENE (205) 372-3388 Acute Care Hospitals Government - Local TRUE 32.8447440 -87.8893070 0   63 1 1063         https://data.medicare.gov/resource/xubh-q36u/row-dyit.ypt9~f4e7 10051 645036 2019-03-04 2018-09-30 20           20       72       92
3670 3670 LAKE MARTIN COMMUNITY HOSPITAL 201 MARIARDEN ROAD DADEVILLE AL 36853 TALLAPOOSA (256) 825-7821 Acute Care Hospitals Proprietary TRUE 32.8187000 -85.7417580 0   123 1 1123         https://data.medicare.gov/resource/xubh-q36u/row-7irr_xm4w_yyg3 10052 649861 2019-05-29 2018-12-31 46           46               46
2383 2383 FLOWERS HOSPITAL 4370 WEST MAIN STREET DOTHAN AL 36305 HOUSTON (334) 793-5000 Acute Care Hospitals Proprietary TRUE 31.2359910 -85.4579370 0   69 1 1069 20020 Dothan-Enterprise-Ozark, AL Central Houston County https://data.medicare.gov/resource/xubh-q36u/row-i7jd_zyzr.7uv6 10055 645037 2019-03-01 2018-09-30 203 26         235               235
2500 2500 ST VINCENT'S BIRMINGHAM 810 ST VINCENT'S DRIVE BIRMINGHAM AL 35205 JEFFERSON (205) 939-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5080150 -86.7887550 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-6naf-9cek~29rm 10056 659398 2019-11-22 2019-06-30 275 83 12     30 400               400
336 336 BIBB MEDICAL CENTER 208 PIERSON AVE CENTREVILLE AL 35042 BIBB (205) 926-4881 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.9511010 -87.1478650 0   7 1 1007 13820 Birmingham-Hoover-Talladega, AL Outlying Bibb County https://data.medicare.gov/resource/xubh-q36u/row-h96v_9sq6~aaj9 10058 644693 2019-03-01 2018-09-30 25           25       131       156
2637 2637 LAWRENCE MEDICAL CENTER 202 HOSPITAL STREET MOULTON AL 35650 LAWRENCE (256) 974-2200 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.4828840 -87.2860190 0   79 1 1079 19460 Huntsville-Decatur-Albertville, AL Outlying Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-vch8-q4mb_8uww 10059 644694 2019-02-26 2018-09-30 37 6         43               43
2425 2425 HIGHLANDS MEDICAL CENTER 380 WOODS COVE ROAD SCOTTSBORO AL 35768 JACKSON (256) 259-4444 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6612540 -86.0471160 0   71 1 1071 42460 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-pkzd.p7rm.i3y6 10061 644084 2019-02-27 2018-09-30 158 10         168       50       218
2175 2175 WIREGRASS MEDICAL CENTER 1200 W MAPLE AVENUE GENEVA AL 36340 GENEVA (334) 684-3655 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.0480630 -85.8908370 0   61 1 1061 20020 Dothan-Enterprise-Ozark, AL Outlying Geneva County https://data.medicare.gov/resource/xubh-q36u/row-6zer-5ewe_shgk 10062 644199 2019-03-01 2018-09-30 67 6         73 16     96       185
3671 3671 RUSSELL MEDICAL CENTER 3316 HIGHWAY 280 ALEXANDER CITY AL 35010 TALLAPOOSA (256) 329-7100 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.9310300 -85.9683940 0   123 1 1123         https://data.medicare.gov/resource/xubh-q36u/row-7ugw.v846~xcyn 10065 651308 2019-05-30 2018-12-31 28 6         34               34
254 254 MEDICAL CENTER BARBOUR 820 W WASHINGTON ST EUFAULA AL 36027 BARBOUR (334) 688-7271 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.8879800 -85.1566130 0   5 1 1005         https://data.medicare.gov/resource/xubh-q36u/row-b9cj~n2ap_7hxj 10069 651152 2019-05-30 2018-12-31 25 5         30 17             47
1058 1058 CLAY COUNTY HOSPITAL 83825 HIGHWAY 9 P O BOX 1270 ASHLAND AL 36251 CLAY (256) 354-2131 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.2765480 -85.8237890 0   27 1 1027         https://data.medicare.gov/resource/xubh-q36u/row-p2yh_2e24~5sth 10073 644085 2019-02-28 2018-09-30 42 4         46       83       129
666 666 NORTHEAST ALABAMA REGIONAL MEDICAL CENTER 400 EAST 10TH STREET ANNISTON AL 36207 CALHOUN (256) 235-5121 Acute Care Hospitals Government - Local TRUE 33.6571230 -85.8233530 0   15 1 1015 11500   Central Calhoun County https://data.medicare.gov/resource/xubh-q36u/row-ima9~p9t8~qh92 10078 644086 2019-02-28 2018-09-30 232 18         250 20             270
2732 2732 ATHENS LIMESTONE HOSPITAL 700 WEST MARKET STREET ATHENS AL 35611 LIMESTONE (256) 233-9292 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.8034990 -86.9778030 0   83 1 1083 26620 Huntsville-Decatur-Albertville, AL Outlying Limestone County https://data.medicare.gov/resource/xubh-q36u/row-nzdh.hdic_txkm 10079 660159 2019-12-02 2019-06-30 56 10         66               66
133 133 SOUTH BALDWIN REGIONAL MEDICAL CENTER 1613 NORTH MCKENZIE STREET FOLEY AL 36535 BALDWIN (251) 949-3400 Acute Care Hospitals Proprietary TRUE 30.4261090 -87.6831870 0   3 1 1003 19300 Mobile-Daphne-Fairhope, AL Central Baldwin County https://data.medicare.gov/resource/xubh-q36u/row-pyt4.i3a3.r8cm 10083 645389 2019-03-01 2018-09-30 82 30         112               112
3243 3243 DECATUR MORGAN HOSPITAL-DECATUR CAMPUS 1201 7TH STREET SE DECATUR AL 35601 MORGAN (256) 341-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.5911680 -86.9726210 0   103 1 1103 19460 Huntsville-Decatur-Albertville, AL Central Morgan County https://data.medicare.gov/resource/xubh-q36u/row-j3pt~7hw5~edsk 10085 653820 2019-09-03 2019-03-31 166 23 11       200 64             264
2986 2986 NORTHWEST MEDICAL CENTER 1530 U S HIGHWAY 43 WINFIELD AL 35594 FAYETTE (205) 487-7736 Acute Care Hospitals Proprietary TRUE 33.9293160 -87.8245070 0   93 1 1093         https://data.medicare.gov/resource/xubh-q36u/row-r4dk-tpsz_u57n 10086 651153 2019-06-03 2018-12-31 57 4         61 10             71
3074 3074 UNIVERSITY OF SOUTH ALABAMA MEDICAL CENTER 2451 FILLINGIM STREET MOBILE AL 36617 MOBILE (251) 471-7110 Acute Care Hospitals Government - State TRUE 30.7081210 -88.0994410 0   97 1 1097 33660 Mobile-Daphne-Fairhope, AL Central Mobile County https://data.medicare.gov/resource/xubh-q36u/row-cmzx-i3i2.bp42 10087 645038 2019-02-28 2018-09-30 117 9   7 16   149               149
3738 3738 WALKER BAPTIST MEDICAL CENTER 3400 HIGHWAY 78 EAST JASPER AL 35502 WALKER (205) 387-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.8411420 -87.2368790 0   127 1 1127 13820 Birmingham-Hoover-Talladega, AL Outlying Walker County https://data.medicare.gov/resource/xubh-q36u/row-kq57-46fi_25ps 10089 651154 2019-05-31 2018-12-31 195 12         207 52             259
3076 3076 PROVIDENCE HOSPITAL 6801 AIRPORT BOULEVARD MOBILE AL 36608 MOBILE (251) 633-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 30.6816900 -88.1983290 0   97 1 1097 33660 Mobile-Daphne-Fairhope, AL Central Mobile County https://data.medicare.gov/resource/xubh-q36u/row-e52k.abk5_gk2c 10090 659399 2019-11-25 2019-06-30 296 33 20       349               349
990 990 GROVE HILL MEMORIAL HOSPITAL 295 JACKSON HWY S GROVE HILL AL 36451 CLARKE (251) 275-3191 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.6942130 -87.7772310 0   25 1 1025         https://data.medicare.gov/resource/xubh-q36u/row-qwpn-mu4j-e76s 10091 660905 2019-12-04 2019-06-30 21           21 9             30
3700 3700 D C H REGIONAL MEDICAL CENTER 809 UNIVERSITY BOULEVARD EAST TUSCALOOSA AL 35401 TUSCALOOSA (205) 759-7111 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.2061300 -87.5251540 0   125 1 1125 46220   Central Tuscaloosa County https://data.medicare.gov/resource/xubh-q36u/row-zssi.q234-yq7y 10092 644695 2019-02-28 2018-09-30 362 52 32       497 54 42           593
1771 1771 HALE COUNTY HOSPITAL 508 GREEN STREET GREENSBORO AL 36744 HALE (334) 624-3024 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.4120980 -87.0186330 0   47 1 1047 42820   Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-s7ws-qt9j~ivrz 10095 644200 2019-03-01 2018-09-30 28           28               28
1887 1887 ELMORE COMMUNITY HOSPITAL 500 HOSPITAL DRIVE WETUMPKA AL 36092 ELMORE (334) 567-4311 Acute Care Hospitals Government - State TRUE 32.5519570 -86.1856430 0   51 1 1051 33860   Central Elmore County https://data.medicare.gov/resource/xubh-q36u/row-yfvr~ksbv.udvy 10097 651259 2019-05-29 2018-12-31 33           33               33
1938 1938 D W MCMILLAN MEMORIAL HOSPITAL 1301 BELLEVILLE AVENUE BREWTON AL 36426 ESCAMBIA (251) 867-8061 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.1271050 -87.0723780 0   53 1 1053         https://data.medicare.gov/resource/xubh-q36u/row-ug8v.qapr~xntq 10099 644201 2019-03-01 2018-09-30 38 8         46               46
134 134 THOMAS HOSPITAL 750 MORPHY AVENUE FAIRHOPE AL 36532 BALDWIN (251) 928-2375 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.5199990 -87.8903330 0   3 1 1003 19300 Mobile-Daphne-Fairhope, AL Central Baldwin County https://data.medicare.gov/resource/xubh-q36u/row-47ke~57kn.r69r 10100 653821 2019-08-30 2019-03-31 112 10     7   129   12           141
3626 3626 CITIZENS BAPTIST MEDICAL CENTER 604 STONE AVENUE TALLADEGA AL 35161 TALLADEGA (256) 761-4542 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.4398010 -86.0906410 0   121 1 1121 45180 Birmingham-Hoover-Talladega, AL Central Talladega County https://data.medicare.gov/resource/xubh-q36u/row-wfgi.6wxf-zx48 10101 651155 2019-05-30 2018-12-31 79 6         85 13             98
3798 3798 J PAUL JONES HOSPITAL 317 MCWILLIAMS AVENUE CAMDEN AL 36726 WILCOX (334) 682-4131 Acute Care Hospitals Voluntary non-profit - Other TRUE 31.9966110 -87.2994240 0   131 1 1131         https://data.medicare.gov/resource/xubh-q36u/row-xkym~x6ui_jjb9 10102 645039 2019-03-04 2018-09-30 21           21               21
2496 2496 PRINCETON BAPTIST MEDICAL CENTER 701 PRINCETON AVENUE SOUTHWEST BIRMINGHAM AL 35211 JEFFERSON (205) 783-3800 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.4991330 -86.8460160 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-hrc7-segv_vve4 10103 651156 2019-05-31 2018-12-31 222 12 12   21 12 279 30             309
2504 2504 GRANDVIEW MEDICAL CENTER 3690 GRANDVIEW PARKWAY BIRMINGHAM AL 35243 JEFFERSON (205) 971-1000 Acute Care Hospitals Proprietary TRUE 33.4343630 -86.7204830 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-pwut_di96_m4tu 10104 660349 2019-11-25 2019-06-30 289 72         373 12 17           402
37 37 PRATTVILLE BAPTIST HOSPITAL 124 S MEMORIAL DR PRATTVILLE AL 36067 AUTAUGA (334) 361-4267 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.4644230 -86.4509360 0   1 1 1001 33860   Central Autauga County https://data.medicare.gov/resource/xubh-q36u/row-62jx-izkm-znx2 10108 660906 2019-12-04 2019-06-30 49 6         55               55
3333 3333 PICKENS COUNTY MEDICAL CENTER 241 ROBERT K WILSON DRIVE CARROLLTON AL 35447 PICKENS (205) 367-8111 Acute Care Hospitals Government - Local TRUE 33.2748070 -88.0896730 0   107 1 1107 46220   Outlying Pickens County https://data.medicare.gov/resource/xubh-q36u/row-zn5h.i3rc.njwh 10109 644006 2019-03-01 2018-09-30 36 4         40 10             50
480 480 BULLOCK COUNTY HOSPITAL 102 WEST CONECUH AVENUE UNION SPRINGS AL 36089 BULLOCK (334) 738-2140 Acute Care Hospitals Proprietary TRUE 32.1461820 -85.7163800 0   11 1 1011         https://data.medicare.gov/resource/xubh-q36u/row-te44-k6fz_rhpp 10110 648174 2019-05-15 2018-12-31 30           30 24             54
2935 2935 BRYAN W. WHITFIELD MEMORIAL HOSPITAL 105 HIGHWAY 80 EAST DEMOPOLIS AL 36732 MARENGO (334) 289-4000 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.5036760 -87.8367440 0   91 1 1091         https://data.medicare.gov/resource/xubh-q36u/row-eqeg.jsdy-rvpp 10112 645707 2019-03-04 2018-09-30 32 5         37 20             57
3077 3077 MOBILE INFIRMARY MEDICAL CENTER 5 MOBILE INFIRMARY CIRCLE MOBILE AL 36652 MOBILE (251) 435-4700 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.6964430 -88.0810170 0   97 1 1097 33660 Mobile-Daphne-Fairhope, AL Central Mobile County https://data.medicare.gov/resource/xubh-q36u/row-5pcu_va59~2efz 10113 653822 2019-08-30 2019-03-31 547 14 14   24 12 611 17 41           669
2499 2499 MEDICAL WEST, AN AFFILIATE OF UAB HEALTH SYSTEM 995 9TH AVENUE SOUTHWEST BESSEMER AL 35021 JEFFERSON (205) 481-7000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.3730860 -86.9917090 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-4v9u.s38j~rrc7 10114 644202 2019-03-01 2018-09-30 119 21         187 25 19           231
1772 1772 VAUGHAN REGIONAL MEDICAL CENTER PARKWAY CAMPUS 1015 MEDICAL CENTER PARKWAY SELMA AL 36701 DALLAS (334) 418-4100 Acute Care Hospitals Proprietary TRUE 32.4302480 -87.0551740 0   47 1 1047 42820   Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-yhen~7fx5~f9rk 10118 660350 2019-12-02 2019-06-30 86 23         109               109
3132 3132 MONROE COUNTY HOSPITAL 2016 SOUTH ALABAMA AVENUE MONROEVILLE AL 36460 MONROE (251) 575-3111 Acute Care Hospitals Government - Local TRUE 31.4978390 -87.3194110 0   99 1 1099         https://data.medicare.gov/resource/xubh-q36u/row-4wyz~k8fh_i5ug 10120 645040 2019-03-13 2018-09-30 41 8         49               49
3823 3823 LAKELAND COMMUNITY HOSPITAL 42024 HIGHWAY 195 E HALEYVILLE AL 35565 WINSTON (205) 485-7117 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.2417180 -87.5898570 0   133 1 1133         https://data.medicare.gov/resource/xubh-q36u/row-qzez~be97-dgiz 10125 645811 2019-04-01 2018-12-31 45 4         49 9             58
3363 3363 TROY REGIONAL MEDICAL CENTER 1330 HIGHWAY 231 SOUTH TROY AL 36081 PIKE (334) 670-5000 Acute Care Hospitals Government - Federal TRUE 31.7803220 -85.9455290 0   109 1 1109 45980   Central Pike County https://data.medicare.gov/resource/xubh-q36u/row-5ter_pyex-x2fe 10126 654064 2019-08-30 2019-03-31 88 9         97 18             115
989 989 JACKSON MEDICAL CENTER 220 HOSPITAL DRIVE JACKSON AL 36545 CLARKE (251) 246-9021 Acute Care Hospitals Proprietary TRUE 31.5304820 -87.8931800 0   25 1 1025         https://data.medicare.gov/resource/xubh-q36u/row-p276~rdhi_nmej 10128 651157 2019-06-03 2018-12-31 35           35               35
135 135 NORTH BALDWIN INFIRMARY 1815 HAND AVENUE BAY MINETTE AL 36507 BALDWIN (251) 937-5521 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.9024920 -87.7833180 0   3 1 1003 19300 Mobile-Daphne-Fairhope, AL Central Baldwin County https://data.medicare.gov/resource/xubh-q36u/row-vac9~xsmg.2gg8 10129 653823 2019-08-30 2019-03-31 51 4         55 15             70
3517 3517 ST VINCENT'S ST CLAIR 7063 VETERANS PARKWAY PELL CITY AL 35125 ST. CLAIR (205) 338-3301 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6055680 -86.3023800 0   115 1 1115 13820 Birmingham-Hoover-Talladega, AL Outlying St. Clair County https://data.medicare.gov/resource/xubh-q36u/row-env7.dc7s_bwtg 10130 659400 2019-11-22 2019-06-30 34 6         40               40
2878 2878 CRESTWOOD MEDICAL CENTER ONE HOSPITAL DR SE HUNTSVILLE AL 35801 MADISON (256) 882-3100 Acute Care Hospitals Proprietary TRUE 34.6943814 -86.5720291 1 ROOFTOP 89 1 1089 26620 Huntsville-Decatur-Albertville, AL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-tkhv~u3mn_apnu 10131 659468 2019-11-27 2019-06-30 164 16         183               183
3574 3574 HILL HOSPITAL OF SUMTER COUNTY 751 DERBY DRIVE YORK AL 36925 SUMTER (205) 392-5263 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.4918250 -88.2960810 0   119 1 1119         https://data.medicare.gov/resource/xubh-q36u/row-hxjd.ga7s.xmvj 10138 651158 2019-06-03 2018-12-31 33           33               33
2501 2501 BROOKWOOD BAPTIST MEDICAL CENTER 2010 BROOKWOOD MEDICAL CENTER DRIVE BIRMINGHAM AL 35209 JEFFERSON (205) 877-1000 Acute Care Hospitals Proprietary TRUE 33.4629100 -86.7768500 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-6yzq-z9kd_9ua7 10139 650228 2019-05-31 2018-12-31 340 26 27     32 425 140 30           595
3075 3075 SPRINGHILL MEMORIAL HOSPITAL 3719 DAUPHIN STREET MOBILE AL 36608 MOBILE (251) 344-9630 Acute Care Hospitals Proprietary TRUE 30.6859460 -88.1317190 0   97 1 1097 33660 Mobile-Daphne-Fairhope, AL Central Mobile County https://data.medicare.gov/resource/xubh-q36u/row-qtdz-mr4h-ggd9 10144 648881 2019-05-29 2018-12-31 178 20         198   11           209
1377 1377 EVERGREEN MEDICAL CENTER 101 CRESTVIEW AVENUE EVERGREEN AL 36401 CONECUH (251) 578-2480 Acute Care Hospitals Proprietary TRUE 31.4312600 -86.9420500 0   35 1 1035         https://data.medicare.gov/resource/xubh-q36u/row-f8ut-az4v~dn63 10148 651159 2019-06-03 2018-12-31 44           44               44
3190 3190 BAPTIST MEDICAL CENTER EAST 400 TAYLOR ROAD MONTGOMERY AL 36117 MONTGOMERY (334) 244-8330 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.3768210 -86.1720950 0   101 1 1101 33860   Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-r8t9_nce5~hpyh 10149 660907 2019-12-04 2019-06-30 170 12       25 207               207
548 548 REGIONAL MEDICAL CENTER OF CENTRAL ALABAMA 29 L V STABLER DRIVE GREENVILLE AL 36037 BUTLER (334) 382-2200 Acute Care Hospitals Proprietary TRUE 31.8294500 -86.6458600 0   13 1 1013         https://data.medicare.gov/resource/xubh-q36u/row-ca8j-ucpx~zp9d 10150 645390 2019-03-01 2018-09-30 37 7         44 13             57
1311 1311 SHOALS HOSPITAL 201 WEST AVALON AVENUE MUSCLE SHOALS AL 35661 COLBERT (256) 386-1601 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.7449410 -87.6765110 0   33 1 1033 22520   Central Colbert County https://data.medicare.gov/resource/xubh-q36u/row-ks6f.h6du~x2iz 10157 653870 2019-09-04 2019-03-31 112 10         122 30 32           184
2099 2099 RUSSELLVILLE HOSPITAL 15155 HIGHWAY 43 RUSSELLVILLE AL 35653 FRANKLIN (256) 332-1611 Acute Care Hospitals Proprietary TRUE 34.5111650 -87.7175850 0   59 1 1059         https://data.medicare.gov/resource/xubh-q36u/row-gwv9.74md~fuic 10158 645962 2019-04-01 2018-12-31 42 7         49               49
3625 3625 COOSA VALLEY MEDICAL CENTER 315 W HICKORY ST SYLACAUGA AL 35150 TALLADEGA (256) 249-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.1646660 -86.2545980 0   121 1 1121 45180 Birmingham-Hoover-Talladega, AL Central Talladega County https://data.medicare.gov/resource/xubh-q36u/row-uqj6-bzwc~56ip 10164 659174 2018-12-26 2018-07-31 114 8         122 15     35 50     222
3455 3455 JACK HUGHSTON MEMORIAL HOSPITAL 4401 RIVER CHASE DRIVE PHENIX CITY AL 36867 RUSSELL (334) 732-3000 Acute Care Hospitals Government - State TRUE 32.5090450 -85.0056960 0   113 1 1113 17980 Columbus-Auburn-Opelika, GA-AL Central Russell County https://data.medicare.gov/resource/xubh-q36u/row-6v2c.qrez~vn8e 10168 651160 2019-05-31 2018-12-31 39 8         47               47
1939 1939 ATMORE COMMUNITY HOSPITAL 401 MEDICAL PARK DRIVE ATMORE AL 36502 ESCAMBIA (251) 368-2500 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.0165700 -87.4797350 0   53 1 1053         https://data.medicare.gov/resource/xubh-q36u/row-nw85.p2jc-cva6 10169 645521 2019-02-28 2018-09-30 43 6         49               49
877 877 ST VINCENT'S CHILTON 2030 LAY DAM ROAD CLANTON AL 35045 CHILTON (205) 258-4400 Acute Care Hospitals Voluntary non-profit - Church TRUE 32.8765850 -86.6235110 0   21 1 1021 13820 Birmingham-Hoover-Talladega, AL Outlying Chilton County https://data.medicare.gov/resource/xubh-q36u/row-7qdj~999i.xcfe 10173 659401 2019-11-22 2019-06-30 20 6         26               26
3782 3782 WASHINGTON COUNTY HOSPITAL 14600 ST. STEPHENS AVENUE CHATOM AL 36518 WASHINGTON (251) 847-2223 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.4602960 -88.2352910 0   129 1 1129         https://data.medicare.gov/resource/xubh-q36u/row-kzeh_fuyx-rvjh 11300 644204 2019-03-01 2018-09-30 15           15       88       103
2098 2098 RED BAY HOSPITAL 211 HOSPITAL ROAD RED BAY AL 35582 FRANKLIN (256) 356-9532 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.4574250 -88.1469340 0   59 1 1059         https://data.medicare.gov/resource/xubh-q36u/row-4dsc.86rj~64k4 11302 644088 2019-02-25 2018-09-30 25           25               25
940 940 CHOCTAW GENERAL HOSPITAL 401 VANITY FAIR LANE, PO BOX 618 BUTLER AL 36904 CHOCTAW (205) 459-9100 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.0937419 -88.2095888 1 ROOFTOP 23 1 1023         https://data.medicare.gov/resource/xubh-q36u/row-cm2u-i8id~q257 11304 651161 2019-06-03 2018-12-31 25           25               25
402 402 ST VINCENTS BLOUNT 150 GILBREATH DRIVE ONEONTA AL 35121 BLOUNT (205) 274-3000 Critical Access Hospitals Voluntary non-profit - Private FALSE 33.9325370 -86.4930590 0   9 1 1009 13820 Birmingham-Hoover-Talladega, AL Outlying Blount County https://data.medicare.gov/resource/xubh-q36u/row-nhvc-v4py.tnm6 11305 659402 2019-11-22 2019-06-30 19 6         25               25
3413 3413 TANNER MEDICAL CENTER-EAST ALABAMA 1032 MAIN STREET SOUTH WEDOWEE AL 36278 RANDOLPH (256) 357-2111 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.2966660 -85.4800280 0   111 1 1111         https://data.medicare.gov/resource/xubh-q36u/row-beeg-xgp7.fjvj 11306 659914 2019-11-27 2019-06-30 15           15               15
2503 2503 CHILDREN'S HOSPITAL OF ALABAMA 1600 SEVENTH AVENUE SOUTH BIRMINGHAM AL 35233 JEFFERSON (205) 939-9100 Childrens Voluntary non-profit - Private TRUE 33.5032220 -86.8053810 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-nh6w~rxvd~itst 13300 651162 2019-06-03 2018-12-31 193     6     341               341
3073 3073 USA HEALTH CHILDREN'S & WOMEN'S HOSPITAL 1700 CENTER STREET MOBILE AL 36604 MOBILE (251) 415-1000 Childrens Government - State TRUE 30.6960820 -88.0768830 0   97 1 1097 33660 Mobile-Daphne-Fairhope, AL Central Mobile County https://data.medicare.gov/resource/xubh-q36u/row-6w9n_e52x~7jkv 13301 652287 2019-07-17 2018-09-30 132           250               250
876 876 PROVIDENCE ALASKA MEDICAL CENTER 3200 PROVIDENCE DRIVE ANCHORAGE AK 99508 ANCHORAGE (907) 562-2211 Acute Care Hospitals Voluntary non-profit - Church TRUE 61.1897980 -149.8176220 0   20 2 2020 11260   Central Anchorage Municipality https://data.medicare.gov/resource/xubh-q36u/row-xgeq_psk8.kgkc 20001 650797 2019-05-30 2018-12-31 279 46       66 391   10           401
4229 4229 MAT-SU REGIONAL MEDICAL CENTER 2500 SOUTH WOODWORTH LOOP PALMER AK 99645 MATANUSKA-SUSITNA (907) 861-6000 Acute Care Hospitals Voluntary non-profit - Other TRUE 61.5612170 -149.2587180 0   170 2 2170 11260   Outlying Matanuska-Susitna Borough https://data.medicare.gov/resource/xubh-q36u/row-ehb8-yifz_k9ea 20006 648225 2019-05-23 2018-12-31 60 14         74               74
3411 3411 BARTLETT REGIONAL HOSPITAL 3260 HOSPITAL DR JUNEAU AK 99801 JUNEAU (907) 796-8900 Acute Care Hospitals Government - Local TRUE 58.3286960 -134.4668290 0   110 2 2110 27940   Central Juneau City and Borough https://data.medicare.gov/resource/xubh-q36u/row-ceet-msjy~uqhq 20008 659178 2019-11-21 2019-06-30 36 9         45 12             57
2934 2934 FAIRBANKS MEMORIAL HOSPITAL 1650 COWLES STREET FAIRBANKS AK 99701 FAIRBANKS NORTH STAR (907) 452-8181 Acute Care Hospitals Voluntary non-profit - Private TRUE 64.8314070 -147.7362540 0   90 2 2090 21820   Central Fairbanks North Star Borough https://data.medicare.gov/resource/xubh-q36u/row-e5th.n9ja~cin9 20012 648324 2019-05-28 2018-12-31 109 13         122       90       212
874 874 ALASKA REGIONAL HOSPITAL 2801 DEBARR ROAD ANCHORAGE AK 99508 ANCHORAGE (907) 276-1131 Acute Care Hospitals Proprietary TRUE 61.2097900 -149.8273790 0   20 2 2020 11260   Central Anchorage Municipality https://data.medicare.gov/resource/xubh-q36u/row-727e.rn52.9kni 20017 662304 2019-12-09 2018-12-31 127 14 13       164   10           174
1885 1885 YUKON KUSKOKWIM DELTA REG HOSPITAL PO BOX 287 BETHEL AK 99559 BETHEL (907) 543-6300 Acute Care Hospitals Tribal TRUE 60.7922222 -161.7558334 1 GEOMETRIC_CENTER 50 2 2050         https://data.medicare.gov/resource/xubh-q36u/row-7gdx-n37w_5vx9 20018 651309 2019-07-02 2018-09-30 34           34               34
3668 3668 CENTRAL PENINSULA GENERAL HOSPITAL 250 HOSPITAL PLACE SOLDOTNA AK 99669 KENAI PENINSULA (907) 262-4404 Acute Care Hospitals Voluntary non-profit - Other TRUE 60.4938650 -151.0776580 0   122 2 2122         https://data.medicare.gov/resource/xubh-q36u/row-kgwk-j25h-z8m3 20024 661276 2019-12-02 2019-06-30 43 6         49       60       109
873 873 ALASKA NATIVE MEDICAL CENTER 4315 DIPLOMACY DR ANCHORAGE AK 99508 ANCHORAGE (907) 729-3971 Acute Care Hospitals Government - Federal TRUE 61.1818900 -149.8005780 0   20 2 2020 11260   Central Anchorage Municipality https://data.medicare.gov/resource/xubh-q36u/row-5h7d.5evj.yxgq 20026 651310 2019-07-01 2018-09-30 173         1 174               174
4529 4529 PROVIDENCE VALDEZ MEDICAL CENTER PO BOX 550 VALDEZ AK 99686 VALDEZ-CORDOVA (907) 835-2249 Critical Access Hospitals Government - Local TRUE 61.1364781 -146.3458866 1 ROOFTOP 261 2 2261         https://data.medicare.gov/resource/xubh-q36u/row-2ygw.872k~d2en 21301 652057 2019-05-30 2018-12-31 11           11       10       21
3669 3669 PROVIDENCE SEWARD HOSPITAL 417 FIRST AVENUE, PO BOX 365 SEWARD AK 99664 KENAI PENINSULA (907) 224-5205 Critical Access Hospitals Government - Local TRUE 60.1050460 -149.4453830 0   122 2 2122         https://data.medicare.gov/resource/xubh-q36u/row-bjag~4kwr.8ihd 21302 652058 2019-05-30 2018-12-31 6           6       40       46
4484 4484 SITKA COMMUNITY HOSPITAL 209 MOLLER DRIVE SITKA AK 99835 SITKA BOROUGH (907) 747-3241 Critical Access Hospitals Government - Local TRUE 57.0589920 -135.3459290 0   220 2 2220         https://data.medicare.gov/resource/xubh-q36u/row-asew~ba2y_nt2p 21303 638783 2018-12-03 2018-06-30 12           12       15       27
4375 4375 PETERSBURG MEDICAL CENTER PO BOX 589 PETERSBURG AK 99833 PETERSBURG BOROUGH (907) 772-4291 Critical Access Hospitals Government - Local TRUE 56.8128691 -132.9554619 1 ROOFTOP 195 2 2195         https://data.medicare.gov/resource/xubh-q36u/row-ky7y_b72j_698p 21304 660160 2019-12-02 2019-06-30 12           12       15       27

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