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

807 rows where "fy_end_date" is on date 2018-09-30 sorted by phone_number

✎ 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, surg_icu_beds, nursing_fac_beds, oth_longterm_beds, filed_date (date)

fy_end_date (date) ✖

  • 2018-09-30 · 807 ✖
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
1331 1331 UNITED MEDICAL CENTER 1310 SOUTHERN AVENUE SE WASHINGTON DC 20032 THE DISTRICT (202) 574-6611 Acute Care Hospitals Proprietary TRUE 38.8341550 -76.9846980 0   33 24 24033 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Prince George's County https://data.medicare.gov/resource/xubh-q36u/row-zng6.qzhh.7sfd 90008 645634 2019-03-01 2018-09-30 180 16         196               196
63 63 STAMFORD HOSPITAL ONE HOSPITAL PLAZA STAMFORD CT 6904 FAIRFIELD (203) 276-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0544448 -73.5522909 1 ROOFTOP 1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-z4bk-5sz6.bqpu 70006 644101 2019-03-04 2018-09-30 252 36         288   17           305
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
65 65 BRIDGEPORT HOSPITAL 267 GRANT STREET BRIDGEPORT CT 6610 FAIRFIELD (203) 384-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.1887760 -73.1660800 0   1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-i2q3_c2gu.vbzu 70010 644221 2019-02-27 2018-09-30 300 16     16   332 39             371
62 62 ST VINCENT'S MEDICAL CENTER 2800 MAIN ST BRIDGEPORT CT 6606 FAIRFIELD (203) 576-5551 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.2000830 -73.2024860 0   1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-fzpd_79fu~rdpp 70028 645052 2019-02-28 2018-09-30 186 14         200 88 10           298
415 415 MASONICARE HEALTH CENTER 22 MASONIC AVE WALLINGFORD CT 6492 NEW HAVEN (203) 679-5900 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.4606980 -72.8365860 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-qb4p-gu4j_xpz9 70039 645323 2019-02-28 2018-09-30 30           30 29     366   86   511
410 410 YALE-NEW HAVEN HOSPITAL 20 YORK ST NEW HAVEN CT 6504 NEW HAVEN (203) 688-4242 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.3042850 -72.9346890 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-vv7z~adrr_fj28 70022 644224 2019-02-27 2018-09-30 1020 50 30   38 19 1279 118 24   119       1540
411 411 MIDSTATE MEDICAL CENTER 435 LEWIS AVENUE MERIDEN CT 6450 NEW HAVEN (203) 694-8200 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.5500360 -72.8038780 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-zt5t~v5nn~ebtg 70017 645528 2019-03-14 2018-09-30 143           143               143
408 408 SAINT MARY'S HOSPITAL 56 FRANKLIN STEET WATERBURY CT 6706 NEW HAVEN (203) 709-6020 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.5525708 -73.0364301 1 ROOFTOP 9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-ir6v~snu4~uk6s 70016 644222 2019-02-28 2018-09-30 119 16 8       152 12             164
412 412 GRIFFIN HOSPITAL 130 DIVISION ST DERBY CT 6418 NEW HAVEN (203) 732-7500 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.3359780 -73.0886890 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-ikfk.swi4.hhft 70031 641347 2019-01-22 2018-09-30 87 14         101 16         2   119
64 64 DANBURY HOSPITAL 24 HOSPITAL AVE DANBURY CT 6810 FAIRFIELD (203) 739-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.4067760 -73.4443390 0   1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-ekru_jpam-gjnq 70033 644104 2019-02-27 2018-09-30 319 41         360 22 14           396
66 66 NORWALK HOSPITAL 24 STEVENS STREET NORWALK CT 6856 FAIRFIELD (203) 852-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.1104150 -73.4212290 0   1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-mbxe~tqkf~is4n 70034 644105 2019-03-05 2018-09-30 195 40       16 251 20             271
67 67 GREENWICH HOSPITAL ASSOCIATION - 5 PERRYRIDGE RD GREENWICH CT 6830 FAIRFIELD (203) 863-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0343950 -73.6296320 0   1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-z487-bxe7-a8jv 70018 644223 2019-02-27 2018-09-30 161 10       10 181               181
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
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
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
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
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
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
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
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
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
1361 1361 SEATTLE CHILDREN'S HOSPITAL 4800 SAND POINT WAY NE, PO BOX C-5371 SEATTLE WA 98105 KING (206) 987-2000 Childrens Voluntary non-profit - Private TRUE 47.6645040 -122.2831690 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-7um6_3ase-art7 503300 646369 2019-04-05 2018-09-30 270 91         361               361
438 438 NORTHERN LIGHT BLUE HILL MEMORIAL HOSPITAL 57 WATER STREET BLUE HILL ME 4614 HANCOCK (207) 374-2836 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4114200 -68.5862130 0   9 23 23009         https://data.medicare.gov/resource/xubh-q36u/row-ib5k-im2e_vk94 201300 645100 2019-02-28 2018-09-30 25           25               25
1002 1002 SEBASTICOOK VALLEY HEALTH 447 NORTH MAIN STREET PITTSFIELD ME 4967 SOMERSET (207) 487-5141 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.7908260 -69.3712690 0   25 23 23025         https://data.medicare.gov/resource/xubh-q36u/row-rjnr.evru~gjjd 201313 650156 2019-05-29 2018-09-30 25           25               25
179 179 HOULTON REGIONAL HOSPITAL 20 HARTFORD STREET HOULTON ME 4730 AROOSTOOK (207) 532-2900 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1329620 -67.8426440 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-tx6y-y4iu-nd9t 201308 645561 2019-03-04 2018-09-30 25           25               25
901 901 MAYO REGIONAL HOSPITAL 897 WEST MAIN STREET DOVER FOXCROFT ME 4426 PISCATAQUIS (207) 564-4251 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.1865560 -69.2377980 0   21 23 23021         https://data.medicare.gov/resource/xubh-q36u/row-zhbf-zz89~t9dz 201309 645562 2019-03-04 2018-09-30 25           25               25
278 278 MAINE MEDICAL CENTER 22 BRAMHALL ST PORTLAND ME 4102 CUMBERLAND (207) 662-0111 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.6521930 -70.2751040 0   5 23 23005 38860 Portland-Lewiston-South Portland, ME Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-94m6-7spt_ncnf 200009 646265 2019-03-27 2018-09-30 490 32 22       575 21             596
439 439 NORTHERN LIGHT MAINE COAST HOSPITAL 50 UNION STREET ELLSWORTH ME 4605 HANCOCK (207) 667-5311 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.5465740 -68.4155260 0   9 23 23009         https://data.medicare.gov/resource/xubh-q36u/row-4sb2~q3gq.pkmc 200050 651565 2019-06-26 2018-09-30 42 6         48               48
900 900 CHARLES A DEAN MEMORIAL HOSPITAL PO BOX 1129 GREENVILLE ME 4441 PISCATAQUIS (207) 695-5200 Critical Access Hospitals Voluntary non-profit - Private FALSE 45.4594923 -69.5906060 1 GEOMETRIC_CENTER 21 23 23021         https://data.medicare.gov/resource/xubh-q36u/row-e23p-cjiz~ui3t 201301 650155 2019-06-21 2018-09-30 25           25               25
280 280 MID COAST HOSPITAL 123 MEDICAL CENTER DRIVE BRUNSWICK ME 4011 CUMBERLAND (207) 729-0181 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.9056610 -69.8920060 0   5 23 23005 38860 Portland-Lewiston-South Portland, ME Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-aikj.qgnk-5idc 200021 643898 2019-02-26 2018-09-30 81 11         92               92
178 178 NORTHERN LIGHT A R GOULD HOSPITAL PO BOX 151 PRESQUE ISLE ME 4769 AROOSTOOK (207) 768-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.6751494 -67.9985861 1 ROOFTOP 3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-ihck.jhth~929r 200018 650152 2019-05-29 2018-09-30 43 6         49   5   14 50     118
177 177 NORTHERN MAINE MEDICAL CENTER 194 E MAIN STREET FORT KENT ME 4743 AROOSTOOK (207) 834-3195 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.2650680 -68.5911770 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-cr45-cm3b-wfye 200052 645099 2019-02-28 2018-09-30 43           43 6     45       94
507 507 NORTHERN LIGHT INLAND HOSPITAL 200 KENNEDY MEMORIAL DRIVE WATERVILLE ME 4901 KENNEBEC (207) 861-3000 Acute Care Hospitals Proprietary TRUE 44.5426900 -69.6614050 0   11 23 23011 12300   Central Kennebec County https://data.medicare.gov/resource/xubh-q36u/row-w24b~y2sj-qzhk 200041 650154 2019-05-29 2018-09-30 33           33               33
277 277 NORTHERN LIGHT HEALTH 144 STATE STREET PORTLAND ME 4101 CUMBERLAND (207) 879-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 43.6520880 -70.2652090 0   5 23 23005 38860 Portland-Lewiston-South Portland, ME Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-9h63~5c2i.9z4j 200008 650701 2019-05-30 2018-09-30 96 7         103               103
831 831 EASTERN MAINE MEDICAL CENTER PO BOX 404 BANGOR ME 4401 PENOBSCOT (207) 973-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.8080922 -68.7517371 1 ROOFTOP 19 23 23019 12620   Central Penobscot County https://data.medicare.gov/resource/xubh-q36u/row-2mv7_y4vm-bcwh 200033 650703 2019-05-30 2018-09-30 246 44         313   36           349
2602 2602 POWER COUNTY HOSPITAL DISTRICT 510 ROOSEVELT STREET AMERICAN FALLS ID 83211 POWER (208) 226-3200 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.7818580 -112.8490470 0   77 16 16077         https://data.medicare.gov/resource/xubh-q36u/row-jqyn~uieu.hqrg 131304 645328 2019-03-20 2018-09-30 10           10       16       26
950 950 LOST RIVERS MEDICAL CENTER 551 HIGHLAND DRIVE ARCO ID 83213 BUTTE (208) 252-7654 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.6405520 -113.2962530 0   23 16 16023 26820 Idaho Falls-Rexburg-Blackfoot, ID Outlying Butte County https://data.medicare.gov/resource/xubh-q36u/row-77px.m9qb~bsww 131324 640856 2019-01-08 2018-09-30 14           14               14
2693 2693 TETON VALLEY HOSPITAL 120 EAST HOWARD AVE DRIGGS ID 83422 TETON (208) 354-2383 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.7272850 -111.1086080 0   81 16 16081 27220   Outlying Teton County https://data.medicare.gov/resource/xubh-q36u/row-73s3-g6zw_arid 131313 643497 2019-02-27 2018-09-30 13           13               13
2299 2299 MADISON MEMORIAL HOSPITAL 450 EAST MAIN STREET REXBURG ID 83440 MADISON (208) 359-6900 Acute Care Hospitals Government - Local TRUE 43.8260510 -111.7731480 0   65 16 16065 39940 Idaho Falls-Rexburg-Blackfoot, ID Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-x7qh_3ndv.ii77 130025 643024 2019-02-05 2018-09-30 49 4         67               67
1731 1731 VALOR HEALTH 1202 EAST LOCUST STREET EMMETT ID 83617 GEM (208) 365-3561 Critical Access Hospitals Government - Local TRUE 43.8790780 -116.4852550 0   45 16 16045 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Gem County https://data.medicare.gov/resource/xubh-q36u/row-cch8-kmmd-nmhb 131318 644635 2019-02-28 2018-09-30 13           13               13
87 87 ST LUKE'S REGIONAL MEDICAL CENTER 190 EAST BANNOCK STREET BOISE ID 83712 ADA (208) 381-2222 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.6121570 -116.1922020 0   1 16 16001 14260 Boise City-Mountain Home-Ontario, ID-OR Central Ada County https://data.medicare.gov/resource/xubh-q36u/row-7i3s_c82d-yek7 130006 651557 2019-06-21 2018-09-30 410 46 17     73 559   19           578
2767 2767 CASCADE MEDICAL CENTER 402 LAKE CASCADE PARKWAY CASCADE ID 83611 VALLEY (208) 382-4242 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.5179210 -116.0489380 0   85 16 16085         https://data.medicare.gov/resource/xubh-q36u/row-8r6g.s3au-3yid 131308 644833 2019-03-04 2018-09-30 8           8               8
2345 2345 MINIDOKA MEMORIAL HOSPITAL 1224 8TH STREET RUPERT ID 83350 MINIDOKA (208) 436-0481 Critical Access Hospitals Government - Local TRUE 42.6196250 -113.6853620 0   67 16 16067 15420   Outlying Minidoka County https://data.medicare.gov/resource/xubh-q36u/row-m4t9~2798.xb46 131319 643405 2019-02-26 2018-09-30 16           16       46       62
1067 1067 WEST VALLEY MEDICAL CENTER 1717 ARLINGTON STREET CALDWELL ID 83605 CANYON (208) 459-4641 Acute Care Hospitals Proprietary TRUE 43.6542200 -116.6956400 0   27 16 16027 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Canyon County https://data.medicare.gov/resource/xubh-q36u/row-q3w9-74rj.ew8y 130014 645072 2019-02-28 2018-09-30 95 13       4 112               112
1065 1065 ST LUKE'S NAMPA MEDICAL CENTER 9850 W ST LUKES DRIVE STE 250 NAMPA ID 83687 CANYON (208) 505-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.6166180 -116.5907340 0   27 16 16027 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Canyon County https://data.medicare.gov/resource/xubh-q36u/row-tbp2_2gqm.s523 130071 651515 2019-06-21 2018-09-30 56 10       4 70               70
820 820 EASTERN IDAHO REGIONAL MEDICAL CENTER 3100 CHANNING WAY IDAHO FALLS ID 83404 BONNEVILLE (208) 529-6210 Acute Care Hospitals Proprietary TRUE 43.4702760 -111.9901590 0   19 16 16019 26820 Idaho Falls-Rexburg-Blackfoot, ID Central Bonneville County https://data.medicare.gov/resource/xubh-q36u/row-zu9m_rfwy-xxuk 130018 644978 2019-02-28 2018-09-30 165 35         226 28 17       10   310
1134 1134 CARIBOU MEMORIAL HOSPITAL 300 SOUTH 3RD WEST SODA SPRINGS ID 83276 CARIBOU (208) 547-3341 Critical Access Hospitals Government - Local TRUE 42.6522350 -111.6133540 0   29 16 16029         https://data.medicare.gov/resource/xubh-q36u/row-k69a-4kn6-dfne 131309 644028 2019-02-28 2018-09-30 25           25       30       55
1586 1586 ST LUKE'S ELMORE MEDICAL CENTER 895 NORTH 6TH EAST MOUNTAIN HOME ID 83647 ELMORE (208) 587-8401 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.1391990 -115.6924870 0   39 16 16039 34300 Boise City-Mountain Home-Ontario, ID-OR Central Elmore County https://data.medicare.gov/resource/xubh-q36u/row-642u_ypya~t5sn 131311 651827 2019-06-21 2018-09-30 21           21       38       59
2163 2163 ST LUKE'S MCCALL 1000 STATE STREET BURGDORF ID 83638 VALLEY (208) 630-2395 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9093540 -116.1097030 0   85 16 16085         https://data.medicare.gov/resource/xubh-q36u/row-au7a~xb54-snfz 131312 651560 2019-06-21 2018-09-30 15           15               15
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
2135 2135 STEELE MEMORIAL MEDICAL CENTER 203 SOUTH DAISY STREET SALMON ID 83467 LEMHI (208) 756-5600 Critical Access Hospitals Government - Local TRUE 45.1733110 -113.8909180 0   59 16 16059         https://data.medicare.gov/resource/xubh-q36u/row-frkw_jutq_kwk4 131305 645073 2019-03-05 2018-09-30 18           18               18
2743 2743 ST LUKE'S MAGIC VALLEY RMC 801 POLE LINE ROAD WEST TWIN FALLS ID 83301 TWIN FALLS (208) 814-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.5915950 -114.4969980 0   83 16 16083 46300   Central Twin Falls County https://data.medicare.gov/resource/xubh-q36u/row-4v7h~2u75~uyrf 130002 652427 2019-06-21 2018-09-30 124 30       18 172 28 14           214
1947 1947 ST LUKE'S JEROME 709 NORTH LINCOLN AVENUE JEROME ID 83338 JEROME (208) 814-9500 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.7302930 -114.5184900 0   53 16 16053 46300   Outlying Jerome County https://data.medicare.gov/resource/xubh-q36u/row-n7f6.zqym~9dzu 131310 651558 2019-06-21 2018-09-30 25           25               25
1641 1641 FRANKLIN COUNTY MEDICAL CENTER 44 NORTH FIRST EAST PRESTON ID 83263 FRANKLIN (208) 852-0137 Critical Access Hospitals Government - Local TRUE 42.0983790 -111.8754670 0   41 16 16041 30860   Outlying Franklin County https://data.medicare.gov/resource/xubh-q36u/row-9du2~qaxa~z8nm 131322 645243 2019-03-08 2018-09-30 20           20       35       55
1777 1777 NORTH CANYON MEDICAL CENTER 267 NORTH CANYON DR GOODING ID 83330 GOODING (208) 934-4433 Critical Access Hospitals Voluntary non-profit - Private FALSE 42.9218690 -114.7111280 0   47 16 16047         https://data.medicare.gov/resource/xubh-q36u/row-dagw~rfa6-2dqe 131302 642945 2019-02-06 2018-09-30 16           16               16
1832 1832 SYRINGA GENERAL HOSPITAL 607 W MAIN STREET GRANGEVILLE ID 83530 IDAHO (208) 983-1700 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.9267890 -116.1269940 0   49 16 16049         https://data.medicare.gov/resource/xubh-q36u/row-9the-4kgt.urhi 131315 642946 2019-02-08 2018-09-30 15           15               15
1183 1183 SOUTHWEST GENERAL HOSPITAL 7400 BARLITE BLVD SAN ANTONIO TX 78224 BEXAR (210) 921-2000 Acute Care Hospitals Physician TRUE 29.3529880 -98.5465890 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-yzdz.2e4a_mcwd 450697 644371 2019-02-28 2018-09-30 143 18       24 185 24 16           225
3508 3508 TEXAS SCOTTISH RITE HOSPITAL FOR CHILDREN 2222 WELBORN STREET DALLAS TX 75219 DALLAS (214) 559-5000 Childrens Voluntary non-profit - Private FALSE 32.8032510 -96.8133570 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-ks6w_wivi.sen3 453314 645801 2019-02-26 2018-09-30                              
3506 3506 PARKLAND HEALTH AND HOSPITAL SYSTEM 5200 HARRY HINES BLVD DALLAS TX 75235 DALLAS (214) 590-8000 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.8117980 -96.8369810 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-r83n-2jzv.t89y 450015 659727 2019-11-19 2018-09-30 621 35   9 17 77 771 18 18           807
2346 2346 BLESSING HOSPITAL BROADWAY ST & N 11TH ST QUINCY IL 62305 ADAMS (217) 223-1200 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3930840 -91.3440810 0   67 17 17067 22800   Outlying Hancock County https://data.medicare.gov/resource/xubh-q36u/row-pfrr.qnhm.x236 140015 645244 2019-02-27 2018-09-30 223 25         248 41 18   20       327
3869 3869 PASSAVANT AREA HOSPITAL 1600 W WALNUT ST JACKSONVILLE IL 62650 MORGAN (217) 245-9551 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7452680 -90.2599120 0   137 17 17137 27300 Springfield-Jacksonville-Lincoln, IL Central Morgan County https://data.medicare.gov/resource/xubh-q36u/row-s6nm~srnx_9kx5 140058 645330 2019-02-28 2018-09-30 84 9         93 10     15       118
4012 4012 ILLINI COMMUNITY HOSPITAL 640 W WASHINGTON PITTSFIELD IL 62363 PIKE (217) 285-2113 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.6067930 -90.8150550 0   149 17 17149         https://data.medicare.gov/resource/xubh-q36u/row-pujp_q5tr_5y4p 141315 645075 2019-02-28 2018-09-30 25           25 10             35
822 822 OSF HEART OF MARY MEDICAL CENTER 1400 WEST PARK AVENUE URBANA IL 61801 CHAMPAIGN (217) 337-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.1173910 -88.2271230 0   19 17 17019 16580   Central Champaign County https://data.medicare.gov/resource/xubh-q36u/row-mvbr_gjxz-rw36 140113 645247 2019-03-01 2018-09-30 156 13         169   25           194
4305 4305 OSF SACRED HEART MEDICAL CENTER 812 N LOGAN AVE DANVILLE IL 61832 VERMILION (217) 443-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.1361970 -87.6449080 0   183 17 17183 19180   Central Vermilion County https://data.medicare.gov/resource/xubh-q36u/row-dkxe~imc7_ebbc 140093 645245 2019-03-01 2018-09-30 145 12         157               157
3342 3342 ABRAHAM LINCOLN MEMORIAL HOSPITAL 200 STAHLHUT DRIVE LINCOLN IL 62656 LOGAN (217) 732-2161 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.1523730 -89.3886980 0   107 17 17107 30660 Springfield-Jacksonville-Lincoln, IL Central Logan County https://data.medicare.gov/resource/xubh-q36u/row-m2j2_9ezc_vv3r 141322 643406 2019-02-25 2018-09-30 25           25               25
1948 1948 GIBSON COMMUNITY HOSPITAL 1120 N MELVIN STREET GIBSON CITY IL 60936 FORD (217) 784-4251 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.4780720 -88.3707160 0   53 17 17053 16580   Outlying Ford County https://data.medicare.gov/resource/xubh-q36u/row-f8jw.6gex-n8ig 141317 645250 2019-03-01 2018-09-30 23 2         25       5   37   67
4199 4199 MEMORIAL MEDICAL CENTER 701 N FIRST ST SPRINGFIELD IL 62702 SANGAMON (217) 788-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8087780 -89.6545860 0   167 17 17167 44100 Springfield-Jacksonville-Lincoln, IL Central Sangamon County https://data.medicare.gov/resource/xubh-q36u/row-pnue~2mxb_uc9u 140148 645540 2019-03-04 2018-09-30 352 38   10     400 36 30           466
891 891 TAYLORVILLE MEMORIAL HOSPITAL 201 EAST PLEASANT STREET TAYLORVILLE IL 62568 CHRISTIAN (217) 824-3331 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.5537530 -89.2937540 0   21 17 17021 45380 Springfield-Jacksonville-Lincoln, IL Central Christian County https://data.medicare.gov/resource/xubh-q36u/row-vfba-cp55.36er 141339 643765 2019-02-26 2018-09-30 25           25               25
3528 3528 DECATUR MEMORIAL HOSPITAL 2300 NORTH EDWARD STREET DECATUR IL 62526 MACON (217) 876-8121 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.8664920 -88.9609120 0   115 17 17115 19500   Central Macon County https://data.medicare.gov/resource/xubh-q36u/row-4jiv~9ut8.2dsg 140135 640894 2018-12-24 2018-09-30 150 22 30       202 20             222
3598 3598 RIVERVIEW HOSPITAL 323 SOUTH MINNESOTA CROOKSTON MN 56716 POLK (218) 281-9200 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.7720830 -96.6181060 0   119 27 27119 24220   Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-9ugf.smjx.yquq 241320 644130 2019-02-28 2018-09-30 25 5         30       24       54
909 909 CASS LAKE INDIAN HEALTH SERVICES HOSPITAL 425 7TH STREET NW CASS LAKE MN 56633 CASS (218) 335-3200 Critical Access Hospitals Government - Federal TRUE 47.3840940 -94.6095150 0   21 27 27021 14660   Outlying Cass County https://data.medicare.gov/resource/xubh-q36u/row-4suk.s9dt-ycv4 241358 646101 2019-03-29 2018-09-30 5           5               5
3436 3436 PERHAM HEALTH 1000 CONEY STREET WEST PERHAM MN 56573 OTTER TAIL (218) 347-1301 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.5926850 -95.5951650 0   111 27 27111 22260   Central Otter Tail County https://data.medicare.gov/resource/xubh-q36u/row-zmw6~bp7u-2zf8 241373 643422 2019-02-22 2018-09-30 25           25       96       121
3876 3876 ELY BLOOMENSON COMMUNITY HOSPITAL 328 WEST CONAN STREET ELY MN 55731 ST. LOUIS (218) 365-3271 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.9007010 -91.8719710 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-tia7_tsch.3esn 241318 645476 2019-03-01 2018-09-30 16           16               16
3857 3857 LIFECARE MEDICAL CENTER 715 DELMORE DRIVE ROSEAU MN 56751 ROSEAU (218) 463-2500 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.8398220 -95.7599470 0   135 27 27135         https://data.medicare.gov/resource/xubh-q36u/row-k2tw.t9zs_excc 241344 645269 2019-02-27 2018-09-30 25           25       50       75
759 759 MERCY HOSPITAL 4572 COUNTY ROAD 61 MOOSE LAKE MN 55767 CARLTON (218) 485-4481 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.4425450 -92.7757250 0   17 27 27017 20260   Outlying Carlton County https://data.medicare.gov/resource/xubh-q36u/row-ank5~56fj_iw2s 241350 645270 2019-02-26 2018-09-30 23 2         25               25
362 362 RED LAKE HOSPITAL A PO BOX 497 REDLAKE MN 56671 BELTRAMI (218) 679-3912 Acute Care Hospitals Government - Federal FALSE 47.8763460 -95.0169401 1 GEOMETRIC_CENTER 7 27 27007 13420   Central Beltrami County https://data.medicare.gov/resource/xubh-q36u/row-jefe.tmy8.7dit 240206 649909 2019-06-18 2018-09-30 23           23               23
1908 1908 PRAIRIE RIDGE HOSPITAL AND HEALTH SERVICES 1411 HIGHWAY 793 E ELBOW LAKE MN 56531 GRANT (218) 685-7300 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9908032 -95.9578947 1 ROOFTOP 51 27 27051         https://data.medicare.gov/resource/xubh-q36u/row-is3f.7a5b~t9ju 241379 644131 2019-02-28 2018-09-30 10           10               10
3437 3437 LAKE REGION HEALTHCARE CORPORATION 712 SOUTH CASCADE FERGUS FALLS MN 56537 OTTER TAIL (218) 736-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.2771380 -96.0724070 0   111 27 27111 22260   Central Otter Tail County https://data.medicare.gov/resource/xubh-q36u/row-c4f3_9mxv.cwip 240052 645268 2019-02-27 2018-09-30 75 5         80 14 14           108
2403 2403 KITTSON MEMORIAL HOSPITAL 1010 SOUTH BIRCH HALLOCK MN 56728 KITTSON (218) 843-3612 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.7670580 -96.9404920 0   69 27 27069         https://data.medicare.gov/resource/xubh-q36u/row-6ca3.ddbe~k6m7 241336 651470 2019-06-24 2018-09-30 15           15       60       75
758 758 COMMUNITY MEMORIAL HOSPITAL 512 SKYLINE BOULEVARD CLOQUET MN 55720 CARLTON (218) 879-4641 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.7318440 -92.4624590 0   17 27 27017 20260   Outlying Carlton County https://data.medicare.gov/resource/xubh-q36u/row-wydg_i87y-v2ai 241364 645271 2019-02-27 2018-09-30 18   4       22       44       66
98 98 RIVERWOOD HEALTHCARE CENTER 200 BUNKER HILL DRIVE AITKIN MN 56431 AITKIN (218) 927-5501 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.5292020 -93.6968080 0   1 27 27001         https://data.medicare.gov/resource/xubh-q36u/row-ybgp~gnb5~d4ww 241305 655456 2019-10-08 2018-09-30 21 4         25               25
1329 1329 BATON ROUGE GENERAL MEDICAL CENTER 3600 FLORIDA BLVD BATON ROUGE LA 70806 E. BATON ROUGE (225) 387-7767 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4503360 -91.1546380 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-wzk2-7azq.gecu 190065 643777 2019-02-28 2018-09-30 212 24   8   9 253 50 8   54       365
1328 1328 OCHSNER MEDICAL CENTER - BATON ROUGE 17000 MEDICAL CENTER DR BATON ROUGE LA 70816 E. BATON ROUGE (225) 752-2470 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4409940 -91.0015130 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-gdgh.frpy~45nu 190202 645417 2019-03-01 2018-09-30 132 20       9 161               161
1330 1330 WOMANS HOSPITAL 100 WOMAN'S WAY BATON ROUGE LA 70817 E. BATON ROUGE (225) 927-1300 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4088600 -91.0310200 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-n9vu.wxmz_qfwr 190128 644733 2019-03-04 2018-09-30 140 4       84 228               228
1786 1786 MERIT HEALTH BILOXI 150 REYNOIR STREET BILOXI MS 39530 HARRISON (228) 436-1104 Acute Care Hospitals Proprietary TRUE 30.3961120 -88.8904380 0   47 28 28047 25060   Central Harrison County https://data.medicare.gov/resource/xubh-q36u/row-had8.h2gv_r2ex 250007 645573 2019-03-01 2018-09-30 147 18         165 12             177
1742 1742 OCHSNER MEDICAL CENTER-HANCOCK 149 DRINKWATER BLVD BAY SAINT LOUIS MS 39520 HANCOCK (228) 467-8600 Acute Care Hospitals Government - Local TRUE 30.3130400 -89.3556570 0   45 28 28045 25060   Central Hancock County https://data.medicare.gov/resource/xubh-q36u/row-8qr6~e2iu-2dck 250162 645723 2019-03-01 2018-09-30 41 6         47               47
2144 2144 SINGING RIVER HEALTH SYSTEM 2809 DENNY AV PASCAGOULA MS 39581 JACKSON (228) 809-5000 Acute Care Hospitals Government - Local TRUE 30.3748710 -88.5324040 0   59 28 28059 25060   Outlying Jackson County https://data.medicare.gov/resource/xubh-q36u/row-tcrr_p47m-6bi7 250040 645722 2019-03-01 2018-09-30 272 48         320 14 20   36       390
1788 1788 MEMORIAL HOSPITAL AT GULFPORT 4500 13TH STREET GULFPORT MS 39502 HARRISON (228) 867-4000 Acute Care Hospitals Government - Local TRUE 30.3669280 -89.1149070 0   47 28 28047 25060   Central Harrison County https://data.medicare.gov/resource/xubh-q36u/row-s5rd_v3j6.9dir 250019 640104 2018-12-26 2018-09-30 232 26         281               281
4537 4537 JOHN D ARCHBOLD MEMORIAL HOSPITAL 915 GORDON AVENUE & MIMOSA DRIVE THOMASVILLE GA 31792 THOMAS (229) 228-2880 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.8251841 -83.9720565 1 ROOFTOP 275 13 13275 45620   Central Thomas County https://data.medicare.gov/resource/xubh-q36u/row-28di.4fre~auew 110038 651993 2019-06-24 2018-09-30 191 35         226 18 20   64       328
4322 4322 SOUTH GEORGIA MEDICAL CENTER 2501 NORTH PATTERSON STREET, PO BOX 1727 VALDOSTA GA 31602 LOWNDES (229) 333-1020 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.8617500 -83.2888630 0   185 13 13185 46660   Central Lowndes County https://data.medicare.gov/resource/xubh-q36u/row-pihr~bnxt.5zgf 110122 644714 2019-03-01 2018-09-30 226 48         274   14           288
4447 4447 MITCHELL COUNTY HOSPITAL 90 STEPHENS STREET CAMILLA GA 31730 MITCHELL (229) 336-5284 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.2292770 -84.2050910 0   205 13 13205         https://data.medicare.gov/resource/xubh-q36u/row-wyam-jqj8.gyct 111331 644025 2019-02-25 2018-09-30 25           25       156       181
3803 3803 GRADY GENERAL HOSPITAL 1155 5TH STREET, SE CAIRO GA 39828 GRADY (229) 377-0251 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.8633930 -84.2002610 0   131 13 13131         https://data.medicare.gov/resource/xubh-q36u/row-axxf.dqez-4s36 110121 644023 2019-02-25 2018-09-30 42 4         46               46
4539 4539 TIFT REGIONAL MEDICAL CENTER 901 E 18TH STREET TIFTON GA 31793 TIFT (229) 382-7120 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.4704020 -83.4910760 0   277 13 13277 45700   Central Tift County https://data.medicare.gov/resource/xubh-q36u/row-ny4q-euja_bk5w 110095 644114 2019-02-28 2018-09-30 161 20         181               181
4243 4243 SGMC LANIER CAMPUS 116 WEST THIGPEN AVENUE LAKELAND GA 31635 LANIER (229) 482-8402 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.0415910 -83.0864540 0   173 13 13173 46660   Outlying Lanier County https://data.medicare.gov/resource/xubh-q36u/row-h8ie_42qb_3sdj 111326 644718 2019-03-01 2018-09-30 25           25       62       87
4 4 SGMC BERRIEN CAMPUS 1221 E MCPHERSON AVENUE NASHVILLE GA 31639 BERRIEN (229) 543-7100 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.2036290 -83.2383370 0   19 13 13019         https://data.medicare.gov/resource/xubh-q36u/row-nuhh.ufkh.cshr 110234 644717 2019-03-01 2018-09-30 51           51 12             63
3151 3151 LIFEBRITE COMMUNITY HOSPITAL OF EARLY 11740 COLUMBIA STREET BLAKELY GA 39823 EARLY (229) 723-4241 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.3743820 -84.9462450 0   99 13 13099         https://data.medicare.gov/resource/xubh-q36u/row-x8g6~hmy4~rqqp 111314 646292 2019-04-01 2018-09-30 15           15       127       142
2454 2454 COLQUITT REGIONAL MEDICAL CENTER 3131 THOMASVILLE HWY BOX 40 MOULTRIE GA 31768 COLQUITT (229) 985-3420 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.1267470 -83.7829180 0   71 13 13071 34220   Central Colquitt County https://data.medicare.gov/resource/xubh-q36u/row-cjar.baa5~jr3x 110105 645063 2019-03-01 2018-09-30 84 10         94           35   129
1783 1783 MCLAREN NORTHERN MICHIGAN 416 CONNABLE AVE PETOSKEY MI 49770 EMMET (231) 487-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 45.3734770 -84.9691520 0   47 26 26047         https://data.medicare.gov/resource/xubh-q36u/row-fcnu-j4f4.fztp 230105 648840 2019-05-28 2018-09-30 129 18 40       187   15           202
2452 2452 LEE MEMORIAL HOSPITAL 2776 CLEVELAND AVE FORT MYERS FL 33901 LEE (239) 332-1111 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.6269240 -81.8722950 0   71 12 12071 15980 Cape Coral-Fort Myers-Naples, FL Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-d9mq-v9vy_3733 100012 644229 2019-02-28 2018-09-30 539 75       32 743   60   15       818

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