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

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

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

View and edit SQL

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

filed_date (date)

  • 2019-12-02 · 305
Link rowid hospital_name ▼ address city state zip_code county_name phone_number hospital_type hospital_ownership emergency_services lat lng geocode_flag geocode_accuracy countyfips statefips statecountyfips cbsacode csatitle centraloutlyingcounty countyequivalent hosp_lookup_url PRVDR_NUM RPT_REC_NUM filed_date fy_end_date acute_beds icu_beds coronary_beds burn_beds surg_icu_beds oth_spec_beds subtotal_acute_beds subprovider_ipf_beds subprovider_irf_beds subprovider_oth_beds skilled_nursing_beds nursing_fac_beds oth_longterm_beds hospice_beds all_beds
315 ACMH HOSPITAL ONE NOLTE DRIVE KITTANNING PA 16201 ARMSTRONG (724) 543-8500 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8085788 -79.5614577 1 ROOFTOP 5 42 42005 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Outlying Armstrong County https://data.medicare.gov/resource/xubh-q36u/row-nu27~a8n8_t6km 390163 660863 2019-12-02 2019-06-30 119 12         131   16   17       164
69 ADAIR COUNTY MEMORIAL HOSPITAL 609 SE KENT GREENFIELD IA 50849 ADAIR (641) 743-2123 Critical Access Hospitals Government - Local TRUE 41.3031030 -94.4519270 0   1 19 19001         https://data.medicare.gov/resource/xubh-q36u/row-3dt7_nstz~yhhy 161310 660956 2019-12-02 2019-06-30 25           25               25
2102 AHMC ANAHEIM REGIONAL MEDICAL CENTER 1111 W LA PALMA AVENUE ANAHEIM CA 92801 ORANGE (714) 774-1450 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.8471380 -117.9339340 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-r3zf-f22h~mx8e 50226 661286 2019-12-02 2019-06-30 180 32         223               223
1518 ALHAMBRA HOSPITAL MEDICAL CENTER 100 S RAYMOND AVE ALHAMBRA CA 91801 LOS ANGELES (626) 570-1606 Acute Care Hospitals Proprietary FALSE 34.0901560 -118.1450170 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-75jx-8uav_n2er 50281 660918 2019-12-02 2019-06-30 88 13         101   17   26       144
235 ALLEGHENY GENERAL HOSPITAL 320 EAST NORTH AVENUE PITTSBURGH PA 15212 ALLEGHENY (412) 359-3131 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4561490 -80.0032490 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-8eek-ck8y_3ey7 390050 661092 2019-12-02 2019-06-30 430 28 24   24 24 552               552
224 ALLEGHENY VALLEY HOSPITAL 1301 CARLISLE ST NATRONA PA 15065 ALLEGHENY (412) 224-5100 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.6173780 -79.7371060 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-4dpd~v2eh.sr63 390032 660011 2019-12-02 2019-06-30 127 16         143 40 17           200
174 ALLEN PARISH HOSPITAL 108 6TH AVENUE KINDER LA 70648 ALLEN (337) 738-2527 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.4914530 -92.8556480 0   3 22 22003         https://data.medicare.gov/resource/xubh-q36u/row-572u~e5cv~bbuy 190133 659958 2019-12-02 2019-06-30 25           25 24             49
188 ANTELOPE MEMORIAL HOSPITAL P O BOX 229, 102 WEST 9TH ST NELIGH NE 68756 ANTELOPE (402) 887-4151 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1336539 -98.0299847 1 ROOFTOP 3 31 31003         https://data.medicare.gov/resource/xubh-q36u/row-uv86-cr3r-pfws 281326 661040 2019-12-02 2019-06-30 23           23               23
1520 ANTELOPE VALLEY HOSPITAL 1600 W AVE J LANCASTER CA 93534 LOS ANGELES (661) 949-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6893710 -118.1584760 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-jtig~5whv~hgpp 50056 660914 2019-12-02 2019-06-30 345 21         393               393
817 ASCENSION ST VINCENT'S CLAY COUNTY 1670 ST VINCENTS WAY MIDDLEBURG FL 32068 CLAY (904) 602-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.1111350 -81.8312980 0   19 12 12019 27260 Jacksonville-St. Marys-Palatka, FL-GA Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-twtd-d5g9-nqdi 100321 660793 2019-12-02 2019-06-30 98 8         106               106
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
1213 ASCENSION ST VINCENT'S SOUTHSIDE 4201 BELFORT RD JACKSONVILLE FL 32216 DUVAL (904) 296-3700 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2530960 -81.5841260 0   31 12 12031 27260 Jacksonville-St. Marys-Palatka, FL-GA Central Duval County https://data.medicare.gov/resource/xubh-q36u/row-wzcx_jtb2.mgyj 100307 660195 2019-12-02 2019-06-30 233 17       10 260               260
1917 ASHLEY MEDICAL CENTER 612 CENTER AVENUE N ASHLEY ND 58413 MCINTOSH (701) 288-3433 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.0401880 -99.3717150 0   51 38 38051         https://data.medicare.gov/resource/xubh-q36u/row-ecd4.9q4x_twgv 351322 661581 2019-12-02 2019-06-30 20           20       40       60
3775 ASOCIACION HOSPITAL DEL MAESTRO, INC SERGIO CUEVAS BUSTAMANTE STREET 550 SAN JUAN PR 936 SAN JUAN (787) 758-6420 Acute Care Hospitals Voluntary non-profit - Other TRUE 18.4137095 -66.0682476 1 RANGE_INTERPOLATED 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-eyz9.wmk9~prcw 400004 660875 2019-12-02 2019-06-30 115 11         126               126
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
3356 AVERA GETTYSBURG HOSPITAL 606 EAST GARFIELD GETTYSBURG SD 57442 POTTER (605) 765-2480 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.0135510 -99.9481280 0   107 46 46107         https://data.medicare.gov/resource/xubh-q36u/row-5ptc-f9a4-vq7p 431302 660878 2019-12-02 2019-06-30 10           10           50   60
529 BAY AREA HOSPITAL 1775 THOMPSON ROAD COOS BAY OR 97420 COOS (541) 269-8124 Acute Care Hospitals Government - Hospital District or Authority TRUE 43.3858540 -124.2324630 0   11 41 41011 18300   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-nb96_ahiz~7tng 380090 662069 2019-12-02 2019-06-30 118 12         130               130
265 BEEBE MEDICAL CENTER 424 SAVANNAH RD LEWES DE 19958 SUSSEX (302) 645-3300 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7774130 -75.1358600 0   5 10 10005 41540   Central Sussex County https://data.medicare.gov/resource/xubh-q36u/row-h6ng.bwzj-5t95 80007 659769 2019-12-02 2019-06-30 175   20       195               195
183 BERKSHIRE MEDICAL CENTER INC - 1 725 NORTH STREET PITTSFIELD MA 1201 BERKSHIRE (413) 447-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.4587480 -73.2490040 0   3 25 25003 38340   Central Berkshire County https://data.medicare.gov/resource/xubh-q36u/row-58b2-r4te.ddyn 220046 661336 2019-12-02 2018-09-30 201 20         221 40 14           275
2043 BLUEFIELD REGIONAL MEDICAL CENTER 500 CHERRY ST BLUEFIELD WV 24701 MERCER (304) 327-1100 Acute Care Hospitals Proprietary TRUE 37.2575170 -81.2341290 0   55 54 54055 14140   Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-kbzt.t9ci.vaxk 510071 660728 2019-12-02 2019-06-30 40 17         57               57
681 BOONE COUNTY HOSPITAL 1015 UNION STREET BOONE IA 50036 BOONE (515) 432-3140 Critical Access Hospitals Government - Local TRUE 42.0555830 -93.8770370 0   15 19 19015 14340 Des Moines-Ames-West Des Moines, IA Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-6zpe~cgwm_xs5p 161372 660987 2019-12-02 2019-06-30 25           25               25
329 BOONE MEMORIAL HOSPITAL 701 MADISON AVENUE MADISON WV 25130 BOONE (304) 369-1230 Critical Access Hospitals Government - Local TRUE 38.0486360 -81.8065320 0   5 54 54005 16620 Charleston-Huntington-Ashland, WV-OH-KY Outlying Boone County https://data.medicare.gov/resource/xubh-q36u/row-r4j3~ibqd.28ff 511313 661267 2019-12-02 2019-06-30 25           25               25
622 BOX BUTTE GENERAL HOSPITAL P O BOX 810, 2101 BOX BUTTE AVE ALLIANCE NE 69301 BOX BUTTE (308) 762-6660 Critical Access Hospitals Government - Local TRUE 42.0984344 -102.8703880 1 ROOFTOP 13 31 31013         https://data.medicare.gov/resource/xubh-q36u/row-gsu6_furw.wta3 281360 661047 2019-12-02 2019-06-30 25           25               25
1617 BRAZOSPORT REGIONAL HEALTH SYSTEM 100 MEDICAL DRIVE LAKE JACKSON TX 77566 BRAZORIA (979) 297-4411 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.0300910 -95.4513880 0   39 48 48039 26420 Houston-The Woodlands, TX Central Brazoria County https://data.medicare.gov/resource/xubh-q36u/row-nrnz.52dm-eixj 450072 662261 2019-12-02 2019-06-30 72 8         80   14           94
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
3827 BURGESS HEALTH CENTER 1600 DIAMOND STREET ONAWA IA 51040 MONONA (712) 423-2311 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.0257390 -96.1055860 0   133 19 19133         https://data.medicare.gov/resource/xubh-q36u/row-hw7j.7dfu.cqug 161359 660983 2019-12-02 2019-06-30 25           25               25
964 BUTLER COUNTY HEALTH CARE CENTER 372 SOUTH 9TH ST DAVID CITY NE 68632 BUTLER (402) 367-1200 Critical Access Hospitals Government - Local TRUE 41.2464710 -97.1230380 0   23 31 31023         https://data.medicare.gov/resource/xubh-q36u/row-u7xr~dyr4.b4xb 281332 661041 2019-12-02 2019-06-30 20           20               20
752 CAMBRIDGE HEALTH ALLIANCE 1493 CAMBRIDGE STREET CAMBRIDGE MA 2138 MIDDLESEX (617) 665-2300 Acute Care Hospitals Government - Local TRUE 42.3741860 -71.1044550 0   17 25 25017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-gyrk~893u_u5y7 220011 662215 2019-12-02 2019-06-30 182 18         200 62             262
3729 CANONSBURG GENERAL HOSPITAL 100 MEDICAL BOULEVARD CANONSBURG PA 15317 WASHINGTON (724) 873-5892 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.2484770 -80.1904340 0   125 42 42125 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-fkp5~6qh6_vgzx 390160 660862 2019-12-02 2019-06-30 80 8         88   16           104
1911 CAPITAL REGION MEDICAL CENTER 1125 MADISON ST JEFFERSON CITY MO 65102 COLE (573) 632-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.5670180 -92.1815880 0   51 29 29051 27620   Central Cole County https://data.medicare.gov/resource/xubh-q36u/row-kiwj~2ugv_esmv 260047 661208 2019-12-02 2019-06-30 88 12         100   14           114
1665 CARLISLE REGIONAL MEDICAL CENTER 361 ALEXANDER SPRING ROAD CARLISLE PA 17015 CUMBERLAND (717) 249-1212 Acute Care Hospitals Proprietary TRUE 40.1847670 -77.2230070 0   41 42 42041 25420 Harrisburg-York-Lebanon, PA Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-6ch7-p7nq-3tnd 390058 661966 2019-12-02 2019-06-30 56 10         66   14           80
609 CARROLL HOSPITAL CENTER 200 MEMORIAL AVENUE WESTMINSTER MD 21157 CARROLL (410) 848-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.5561350 -76.9916550 0   13 24 24013 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Outlying Carroll County https://data.medicare.gov/resource/xubh-q36u/row-7ctx.mcs5~ru72 210033 659802 2019-12-02 2019-06-30 141 12         153               153
1403 CATAWBA VALLEY MEDICAL CENTER 810 FAIRGROVE CHURCH RD HICKORY NC 28602 CATAWBA (828) 326-3809 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.7111950 -81.2647790 0   35 37 37035 25860 Hickory-Lenoir, NC Central Catawba County https://data.medicare.gov/resource/xubh-q36u/row-yi2j.csdp-b8zf 340143 661370 2019-12-02 2019-06-30 172 28         200 38 20           258
6 CENTRAL MONTANA MEDICAL CENTER 408 WENDELL AVE LEWISTOWN MT 59457 FERGUS (406) 535-7711 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.0584640 -109.4422430 0   27 30 30027         https://data.medicare.gov/resource/xubh-q36u/row-hefc~6xn5~i2c7 271345 661545 2019-12-02 2019-06-30 23           23               23
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
171 CHI HEALTH - MERCY CORNING 603 ROSARY DRIVE CORNING IA 50841 ADAMS (641) 322-3121 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.9883750 -94.7479140 0   3 19 19003         https://data.medicare.gov/resource/xubh-q36u/row-bgwm_q3kt_uw3g 161304 661177 2019-12-02 2019-06-30 22           22               22
2024 CHI HEALTH CREIGHTON UNIVERSITY MEDICAL CENTER - B 7500 MERCY RD OMAHA NE 68124 DOUGLAS (402) 398-6060 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2379040 -96.0287170 0   55 31 31055 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-8r2j-deyz-snt5 280060 661548 2019-12-02 2019-06-30 297 52         385               385
843 CHI HEALTH GOOD SAMARITAN P O BOX 1990, 10 EAST 31ST ST KEARNEY NE 68848 BUFFALO (308) 865-7100 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.7076254 -99.0818136 1 ROOFTOP 19 31 31019 28260   Central Buffalo County https://data.medicare.gov/resource/xubh-q36u/row-k4e3_xakc.p7ct 280009 661546 2019-12-02 2019-06-30 201 16       10 227   12           239
2023 CHI HEALTH LAKESIDE 16901 LAKESIDE HILLS CT OMAHA NE 68130 DOUGLAS (402) 717-8167 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.2390400 -96.1805320 0   55 31 31055 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-m36s-dsun.h9q7 280130 661035 2019-12-02 2019-06-30 92 16         108               108
4076 CHI HEALTH MERCY COUNCIL BLUFFS 800 MERCY DRIVE COUNCIL BLUFFS IA 51503 POTTAWATTAMIE (712) 328-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2696360 -95.8382010 0   155 19 19155 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Pottawattamie County https://data.medicare.gov/resource/xubh-q36u/row-abwm_b2ah-p5iq 160028 661174 2019-12-02 2019-06-30 129 16         145               145
4062 CHI HEALTH MIDLANDS 11111 SOUTH 84TH ST PAPILLION NE 68046 SARPY (402) 593-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.1368660 -96.0428250 0   153 31 31153 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Sarpy County https://data.medicare.gov/resource/xubh-q36u/row-kx48-5ytk-a4rz 280105 661550 2019-12-02 2019-06-30 28           28               28
2789 CHI HEALTH MISSOURI VALLEY 631 N 8TH ST MISSOURI VALLEY IA 51555 HARRISON (712) 642-2784 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.5629770 -95.8850960 0   85 19 19085 36540 Omaha-Council Bluffs-Fremont, NE-IA Outlying Harrison County https://data.medicare.gov/resource/xubh-q36u/row-nied-xbd5_n6bv 161309 661179 2019-12-02 2019-06-30 25           25               25
3382 CHI HEALTH NEBRASKA HEART 7500 SOUTH 91ST ST LINCOLN NE 68526 LANCASTER (402) 327-2700 Acute Care Hospitals Voluntary non-profit - Private FALSE 40.7354760 -96.5946070 0   109 31 31109 30700 Lincoln-Beatrice, NE Central Lancaster County https://data.medicare.gov/resource/xubh-q36u/row-67wg.v8ba~v3dn 280128 661034 2019-12-02 2019-06-30 54           54               54
3897 CHI HEALTH PLAINVIEW P O BOX 489, 704 NORTH THIRD ST PLAINVIEW NE 68769 PIERCE (402) 582-4245 Critical Access Hospitals Voluntary non-profit - Church TRUE 42.3587128 -97.7857721 1 ROOFTOP 139 31 31139 35740   Outlying Pierce County https://data.medicare.gov/resource/xubh-q36u/row-dyfy-rvq7~3hjd 281346 661043 2019-12-02 2019-06-30 15           15               15
1549 CHI HEALTH SCHUYLER 104 WEST 17TH ST SCHUYLER NE 68661 COLFAX (402) 352-2441 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4545790 -97.0597250 0   37 31 31037         https://data.medicare.gov/resource/xubh-q36u/row-jpni~j9gv~awkb 281323 661039 2019-12-02 2019-06-30 25           25               25
3381 CHI HEALTH ST ELIZABETH 555 SOUTH 70TH ST LINCOLN NE 68510 LANCASTER (402) 219-7700 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8076090 -96.6251790 0   109 31 31109 30700 Lincoln-Beatrice, NE Central Lancaster County https://data.medicare.gov/resource/xubh-q36u/row-dwnv_q2vi_cf6s 280020 659989 2019-12-02 2019-06-30 176 16   16   27 235               235
2653 CHI HEALTH ST FRANCIS 2620 WEST FAIDLEY AVE GRAND ISLAND NE 68803 HALL (308) 384-4600 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.9242670 -98.3708870 0   79 31 31079 24260   Central Hall County https://data.medicare.gov/resource/xubh-q36u/row-rgs4_gs84~mfkz 280023 661547 2019-12-02 2019-06-30 115 16       9 140   12   34       186
3814 CHI HEALTH ST MARY'S 1301 GRUNDMAN BLVD NEBRASKA CITY NE 68410 OTOE (402) 873-3321 Critical Access Hospitals Voluntary non-profit - Church TRUE 40.6581520 -95.8621090 0   131 31 31131         https://data.medicare.gov/resource/xubh-q36u/row-6z57~cf6y.zams 281342 661042 2019-12-02 2019-06-30 18           18               18
2478 CHI ST ALEXIUS HEALTH DEVILS LAKE 1031 7TH ST NE DEVILS LAKE ND 58301 RAMSEY (701) 662-2131 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1147740 -98.8503450 0   71 38 38071         https://data.medicare.gov/resource/xubh-q36u/row-i8ea.ub9b_eqnm 351333 662067 2019-12-02 2019-06-30 25           25               25
3324 CHI ST ALEXIUS HEALTH WILLISTON 1301 15TH AVE W WILLISTON ND 58801 WILLIAMS (701) 774-7400 Critical Access Hospitals Voluntary non-profit - Church TRUE 48.1543320 -103.6454370 0   105 38 38105 48780   Central Williams County https://data.medicare.gov/resource/xubh-q36u/row-2m99~vhsx_qu32 351334 662569 2019-12-02 2019-06-30 25           25               25
4425 CHI ST LUKE'S HEALTH BAYLOR COLLEGE OF MEDICINE ME 7200 CAMBRIDGE, 11TH FLOOR HOUSTON TX 77030 HARRIS (832) 355-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 29.6988180 -95.3938620 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-77i8-gn8q~45g2 450193 661413 2019-12-02 2019-06-30 475 144 18       637   24           661
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
1889 CHI ST. VINCENT HOSPITAL HOT SPRINGS 300 WERNER STREET HOT SPRINGS AR 71903 GARLAND (501) 622-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.4660350 -93.0663960 0   51 5 5051 26300 Hot Springs-Malvern, AR Central Garland County https://data.medicare.gov/resource/xubh-q36u/row-pyjq_z3nz-ckdj 40026 662146 2019-12-02 2019-06-30 204 25         229               229
3579 CHI-ST VINCENT INFIRMARY TWO ST VINCENT CIRCLE LITTLE ROCK AR 72205 PULASKI (501) 552-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7502877 -92.3393435 1 ROOFTOP 119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-rvvz~qyi8_5qyq 40007 660911 2019-12-02 2019-06-30 330 23 20     20 393               393
55 CHILDREN'S HOSPITAL & RESEARCH CENTER OAKLAND 747 52ND STREET OAKLAND CA 94609 ALAMEDA (510) 428-3000 Childrens Voluntary non-profit - Private TRUE 37.8373260 -122.2677410 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-n7ad_497y.9ize 53301 661145 2019-12-02 2019-06-30 123 23       44 190               190
2119 CHILDREN'S HOSPITAL OF ORANGE COUNTY 1201 W LA VETA AVE ORANGE CA 92868 ORANGE (714) 997-3000 Childrens Voluntary non-profit - Other FALSE 33.7803300 -117.8649600 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-tabq.iupn-ad4g 53304 661466 2019-12-02 2019-06-30 176 24         334               334
4320 CHRISTUS GOOD SHEPHERD MEDICAL CENTER 700 E MARSHALL AVE LONGVIEW TX 75601 GREGG (903) 927-6712 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.5014480 -94.7314710 0   183 48 48183 30980 Longview-Marshall, TX Central Gregg County https://data.medicare.gov/resource/xubh-q36u/row-k8vu.r683~api3 450032 662427 2019-12-02 2019-06-30 263 42         336   25           361
2220 CINCINNATI CHILDREN'S HOSPITAL MEDICAL CENTER 3333 BURNET AVENUE CINCINNATI OH 45229 HAMILTON (513) 636-3333 Childrens Voluntary non-profit - Private TRUE 39.1409470 -84.5003920 0   61 39 39061 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-jr9m~pzfs_k2mx 363300 661623 2019-12-02 2019-06-30 489 35 25       615               615
3972 CLARINDA REGIONAL HEALTH CENTER 220 ESSIE DAVISON DRIVE CLARINDA IA 51632 PAGE (712) 542-2176 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.7231160 -95.0414060 0   145 19 19145         https://data.medicare.gov/resource/xubh-q36u/row-e24e-jv8q.avua 161352 661182 2019-12-02 2019-06-30 25           25               25
1297 COMANCHE COUNTY MEMORIAL HOSPITAL 3401 WEST GORE BLVD LAWTON OK 73505 COMANCHE (580) 355-8620 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6089690 -98.4344970 0   31 40 40031 30020   Central Comanche County https://data.medicare.gov/resource/xubh-q36u/row-wn8v~6wq8.gvxz 370056 660281 2019-12-02 2019-06-30 128 20 39       187 12 30           229
3987 COMMUNITY HOSPITAL P O BOX 1328, 1301 EAST H ST MCCOOK NE 69001 RED WILLOW (308) 344-2650 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.2004042 -100.6317977 1 ROOFTOP 145 31 31145         https://data.medicare.gov/resource/xubh-q36u/row-b3ww-n6dr.gmwh 281363 661048 2019-12-02 2019-06-30 25           25               25
926 CONEMAUGH MINERS MEDICAL CENTER 290 HAIDA AVENUE HASTINGS PA 16646 CAMBRIA (814) 247-3100 Acute Care Hospitals Proprietary TRUE 40.6589130 -78.7057990 0   21 42 42021 27780 Johnstown-Somerset, PA Central Cambria County https://data.medicare.gov/resource/xubh-q36u/row-atm6_mxu4.8ec2 390130 660860 2019-12-02 2019-06-30 25 5         30               30
587 CONTRA COSTA REGIONAL MEDICAL CENTER 2500 ALHAMBRA AVENUE MARTINEZ CA 94553 CONTRA COSTA (925) 370-5000 Acute Care Hospitals Government - Local TRUE 38.0064670 -122.1308910 0   13 6 6013 41860 San Jose-San Francisco-Oakland, CA Outlying Contra Costa County https://data.medicare.gov/resource/xubh-q36u/row-iuri_7t24.rw23 50276 660491 2019-12-02 2019-06-30 110 8       6 124 23             147
530 COQUILLE VALLEY HOSPITAL DISTRICT 940 EAST 5TH STREET COQUILLE OR 97423 COOS (541) 396-3101 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.1789820 -124.1791430 0   11 41 41011 18300   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-qh6s~rn9z.ntit 381312 660287 2019-12-02 2019-06-30 17           17               17
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
1779 CRAWFORD COUNTY MEMORIAL HOSPITAL 100 MEDICAL PARKWAY DENISON IA 51442 CRAWFORD (712) 265-2500 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.0232570 -95.3770860 0   47 19 19047         https://data.medicare.gov/resource/xubh-q36u/row-9ydn-ts52-gjkc 161369 660986 2019-12-02 2019-06-30 25           25               25
2069 CUMBERLAND COUNTY HOSPITAL 299 GLASGOW ROAD BURKESVILLE KY 42717 CUMBERLAND (270) 864-2511 Critical Access Hospitals Government - Local TRUE 36.7968680 -85.3724400 0   57 21 21057         https://data.medicare.gov/resource/xubh-q36u/row-ptk2_m6d2-xzym 181317 661512 2019-12-02 2019-06-30 25           25               25
1836 DALLAS COUNTY HOSPITAL 610 TENTH STREET PERRY IA 50220 DALLAS (515) 465-3547 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.8339590 -94.0944690 0   49 19 19049 19780 Des Moines-Ames-West Des Moines, IA Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-5ca8_jqfe~mw9b 161322 660961 2019-12-02 2019-06-30 25           25               25
2157 DAVIE MEDICAL CENTER 223 HOSPITAL STREET MOCKSVILLE NC 27028 DAVIE (336) 751-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.9000100 -80.5700970 0   59 37 37059 49180 Greensboro--Winston-Salem--High Point, NC Central Davie County https://data.medicare.gov/resource/xubh-q36u/row-6uy2-xp88~p8f2 340187 661371 2019-12-02 2019-06-30 18           18               18
1950 DECATUR COUNTY HOSPITAL 1405 NW CHURCH STREET LEON IA 50144 DECATUR (641) 446-4871 Critical Access Hospitals Government - Local TRUE 40.7503080 -93.7477890 0   53 19 19053         https://data.medicare.gov/resource/xubh-q36u/row-z8pk.dm9q_4faw 161340 660972 2019-12-02 2019-06-30 11           11               11
789 DOYLESTOWN HOSPITAL 595 WEST STATE ST DOYLESTOWN PA 18901 BUCKS (215) 345-2200 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3025430 -75.1494490 0   17 42 42017 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Bucks County https://data.medicare.gov/resource/xubh-q36u/row-ij4a.sr9y_m66v 390203 660299 2019-12-02 2019-06-30 192 14     7   217               217
3844 EASTLAND MEMORIAL HOSPITAL 304 S DAUGHERTY EASTLAND TX 76448 EASTLAND (254) 629-2601 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.4004390 -98.8216360 0   133 48 48133         https://data.medicare.gov/resource/xubh-q36u/row-uts8~dkzz-h488 450411 660325 2019-12-02 2019-06-30 36           36               36
1740 EATON RAPIDS MEDICAL CENTER 1500 S MAIN STREET EATON RAPIDS MI 48827 EATON (517) 663-2671 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.4960210 -84.6575390 0   45 26 26045 29620 Lansing-East Lansing-Owosso, MI Central Eaton County https://data.medicare.gov/resource/xubh-q36u/row-ezfk_mmvd_s7mp 231324 661021 2019-12-02 2019-06-30 20           20               20
1687 EDWARD HOSPITAL 801 SOUTH WASHINGTON NAPERVILLE IL 60540 DU PAGE (630) 527-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7614260 -88.1492390 0   43 17 17043 16980 Chicago-Naperville, IL-IN-WI Central DuPage County https://data.medicare.gov/resource/xubh-q36u/row-vkfe~uqkg~c8wd 140231 661315 2019-12-02 2019-06-30 229 25 22     22 298               298
994 EL CENTRO REGIONAL MEDICAL CENTER 1415 ROSS AVENUE EL CENTRO CA 92243 IMPERIAL (760) 339-7100 Acute Care Hospitals Government - Local TRUE 32.7814980 -115.5686200 0   25 6 6025 20940   Central Imperial County https://data.medicare.gov/resource/xubh-q36u/row-35st~i7ay-x3eh 50045 660164 2019-12-02 2019-06-30 141 20         161               161
1686 ELMHURST MEMORIAL HOSPITAL 155 EAST BRUSH HILL ROAD ELMHURST IL 60126 DU PAGE (331) 221-0130 Acute Care Hospitals Proprietary TRUE 41.8616840 -87.9342950 0   43 17 17043 16980 Chicago-Naperville, IL-IN-WI Central DuPage County https://data.medicare.gov/resource/xubh-q36u/row-bbi9~mwsc~myn8 140200 661499 2019-12-02 2019-06-30 247 35         282               282
2886 EMORY DECATUR HOSPITAL 2701 N DECATUR ROAD DECATUR GA 30033 DE KALB (404) 501-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.7921600 -84.2826790 0   89 13 13089 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central DeKalb County https://data.medicare.gov/resource/xubh-q36u/row-pp7m~b3m9-dt6m 110076 661305 2019-12-02 2019-06-30 318 32       42 392   30           422
2888 EMORY HILLANDALE HOSPITAL 2801 DEKALB MEDICAL PARKWAY LITHONIA GA 30058 DE KALB (404) 501-8040 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.7054880 -84.1469270 0   89 13 13089 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central DeKalb County https://data.medicare.gov/resource/xubh-q36u/row-mkqk.2abm~442s 110226 660924 2019-12-02 2019-06-30 82 8         90               90
3878 ESSENTIA HEALTH VIRGINIA 901 9TH STREET NORTH VIRGINIA MN 55792 ST. LOUIS (218) 741-3340 Acute Care Hospitals Government - Local FALSE 47.5307110 -92.5487970 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-39c9_62zv_e3w4 240084 662217 2019-12-02 2019-06-30 40 8         48   16   77       141
3101 FAIRBANKS 8102 CLEARVISTA PARKWAY INDIANAPOLIS IN 46256 MARION (317) 849-8222 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.9028140 -86.0392840 0   97 18 18097 26900 Indianapolis-Carmel-Muncie, IN Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-74bs~yakd.ww2f 150179 660944 2019-12-02 2019-06-30 86           86               86
3186 FLAMBEAU HOSPITAL 98 SHERRY AVE PARK FALLS WI 54552 PRICE (715) 762-7500 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9310980 -90.4419720 0   99 55 55099         https://data.medicare.gov/resource/xubh-q36u/row-mtm9~rxnu.g2qc 521325 662628 2019-12-02 2019-06-30 20 4         24           1   25
1584 FLORIDA STATE HOSPITAL UNIT 31 MED 100 N MAIN ST CHATTAHOOCHEE FL 32324 GADSDEN (850) 663-7536 Acute Care Hospitals Government - State FALSE 30.7068990 -84.8425840 0   39 12 12039 45220 Tallahassee-Bainbridge, FL-GA Outlying Gadsden County https://data.medicare.gov/resource/xubh-q36u/row-kyk8-9a3q-5siu 100298 660194 2019-12-02 2019-06-30 24           24 34         1172   1230
230 FORBES HOSPITAL 2570 HAYMAKER ROAD MONROEVILLE PA 15146 ALLEGHENY (412) 858-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4284250 -79.7512540 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-f279_i43n~yjz2 390267 659882 2019-12-02 2019-06-30 166 56         234 37 20           291
1827 FULTON COUNTY HOSPITAL 679 NORTH MAIN STREET SALEM AR 72576 FULTON (870) 895-2691 Critical Access Hospitals Voluntary non-profit - Other TRUE 36.3833590 -91.8112030 0   49 5 5049         https://data.medicare.gov/resource/xubh-q36u/row-9b6n-wd2m.b7tm 41322 660913 2019-12-02 2019-06-30 25           25               25
954 GARRETT COUNTY MEMORIAL HOSPITAL 251 NORTH FOURTH STREET OAKLAND MD 21550 GARRETT (301) 533-4173 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.4133250 -79.4027300 0   23 24 24023         https://data.medicare.gov/resource/xubh-q36u/row-t8h3.7jnz_zwmx 210017 660818 2019-12-02 2019-06-30 25 2         27       10       37
1794 GOTHENBURG MEMORIAL HOSPITAL 910 20TH ST GOTHENBURG NE 69138 DAWSON (308) 537-3661 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.9381320 -100.1533520 0   47 31 31047 30420   Central Dawson County https://data.medicare.gov/resource/xubh-q36u/row-dgzd-a44k.k83g 281313 661037 2019-12-02 2019-06-30 12           12               12
2528 GREENE COUNTY MEDICAL CENTER 1000 WEST LINCOLNWAY JEFFERSON IA 50129 GREENE (515) 386-2114 Critical Access Hospitals Government - Local TRUE 42.0152170 -94.3890600 0   73 19 19073         https://data.medicare.gov/resource/xubh-q36u/row-ekvn-6v3z_68bn 161325 660962 2019-12-02 2019-06-30 21   4       25               25
272 GREENVILLE REGIONAL HOSPITAL 200 HEALTH CARE DR GREENVILLE IL 62246 BOND (618) 664-1230 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9018800 -89.4086770 0   5 17 17005 41180 St. Louis-St. Charles-Farmington, MO-IL Outlying Bond County https://data.medicare.gov/resource/xubh-q36u/row-byrn_qvzg.2pup 140137 660929 2019-12-02 2019-06-30 32           32 10             42
710 GUTHRIE TOWANDA MEMORIAL HOSPITAL 91 HOSPITAL DRIVE TOWANDA PA 18848 BRADFORD (570) 265-2191 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7837960 -76.4486020 0   15 42 42015 42380   Central Bradford County https://data.medicare.gov/resource/xubh-q36u/row-p45f.b6p6~45xq 390236 660868 2019-12-02 2019-06-30 31 4         35       68       103
1693 GUTTENBERG MUNICIPAL HOSPITAL 200 MAIN STREET GUTTENBERG IA 52052 CLAYTON (563) 252-1121 Critical Access Hospitals Government - Local TRUE 42.7855480 -91.0999540 0   43 19 19043         https://data.medicare.gov/resource/xubh-q36u/row-9vtm.kuer.r3a9 161312 660958 2019-12-02 2019-06-30 25           25               25
2489 HARDIN MEDICAL CENTER 935 WAYNE ROAD SAVANNAH TN 38372 HARDIN (731) 926-8121 Acute Care Hospitals Government - Local TRUE 35.2271300 -88.2303620 0   71 47 47071         https://data.medicare.gov/resource/xubh-q36u/row-2dfc~89p6~kqtc 440109 660709 2019-12-02 2019-06-30 49           49       73       122
2085 HARMON MEMORIAL HOSPITAL 400 EAST CHESTNUT STREET HOLLIS OK 73550 HARMON (580) 688-3363 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.6915370 -99.9143660 0   57 40 40057         https://data.medicare.gov/resource/xubh-q36u/row-uie3-brwx.iwxd 371338 661083 2019-12-02 2019-06-30 22           22               22
35 HAWARDEN REGIONAL HEALTHCARE 1111 11TH STREET HAWARDEN IA 51023 SIOUX (712) 551-3100 Critical Access Hospitals Government - Local TRUE 42.9980080 -96.4794270 0   167 19 19167         https://data.medicare.gov/resource/xubh-q36u/row-i52u~xknc.njpg 161311 660957 2019-12-02 2019-06-30 25           25               25
2386 HAZEL HAWKINS MEMORIAL HOSPITAL 911 SUNSET DRIVE HOLLISTER CA 95023 SAN BENITO (831) 637-5711 Acute Care Hospitals Government - Hospital District or Authority FALSE 36.8351220 -121.3866200 0   69 6 6069 41940 San Jose-San Francisco-Oakland, CA Outlying San Benito County https://data.medicare.gov/resource/xubh-q36u/row-z5mt_ehjz~v7xh 50296 661288 2019-12-02 2019-06-30 41 8         49       119       168
2667 HENRY COUNTY MEDICAL CENTER 301 TYSON AV PARIS TN 38242 HENRY (731) 642-1220 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.2968020 -88.3112710 0   79 47 47079 37540   Central Henry County https://data.medicare.gov/resource/xubh-q36u/row-ru8t~pc2a_mnkm 440132 661107 2019-12-02 2019-06-30 55   9       64 22             86
384 HERITAGE VALLEY BEAVER 1000 DUTCH RIDGE ROAD BEAVER PA 15009 BEAVER (412) 728-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7103450 -80.3243520 0   7 42 42007 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Beaver County https://data.medicare.gov/resource/xubh-q36u/row-qcxm.vfmt_it7p 390036 661089 2019-12-02 2019-06-30 174 20         194 28             222
226 HERITAGE VALLEY SEWICKLEY 720 BLACKBURN ROAD SEWICKLEY PA 15143 ALLEGHENY (412) 741-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5435230 -80.1787560 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-b5j5.fw3x_aya4 390037 659866 2019-12-02 2019-06-30 104 12         116 14             130
3943 HIGGINS GENERAL HOSPITAL 200 ALLEN MEMORIAL DRIVE BREMEN GA 30110 HARALSON (770) 812-2000 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.7163430 -85.1446230 0   143 13 13143 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Haralson County https://data.medicare.gov/resource/xubh-q36u/row-rd44_uqxz.t5yc 111320 660206 2019-12-02 2019-06-30 15           15               15
2717 HIGH POINT REGIONAL HOSPITAL 601 N ELM ST HIGH POINT NC 27261 GUILFORD (336) 878-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.9624860 -80.0120270 0   81 37 37081 24660 Greensboro--Winston-Salem--High Point, NC Central Guilford County https://data.medicare.gov/resource/xubh-q36u/row-cqap_seaa~zbqk 340004 661368 2019-12-02 2019-06-30 256 24 8       288   16           304
2459 HIGHLANDS REGIONAL MEDICAL CENTER 5000 KENTUCKY ROUTE 321 PRESTONSBURG KY 41653 FLOYD (606) 886-8511 Acute Care Hospitals Proprietary TRUE 37.7105400 -82.7702500 0   71 21 21071         https://data.medicare.gov/resource/xubh-q36u/row-iny2.6yju.g3qs 180005 662526 2019-12-02 2019-06-30 115 12         127 23             150

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