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

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

4,766 rows sorted by hospital_name

View and edit SQL

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, 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
1104 (CLOSED) CUMBERLAND RIVER HOSPITAL 100 OLD JEFFERSON ST CELINA TN 38551 CLAY (931) 243-3581 Critical Access Hospitals Physician TRUE 36.5447360 -85.5011730 0   27 47 47027         https://data.medicare.gov/resource/xubh-q36u/row-ejr4.nfrj.jxid 441319 655653 2019-10-28 2019-03-01 25           25 8             33
4741 1st Medical Group (Langley AFB) 633 MDG 77 Nealy Ave Langley VA 23665 HAMPTON CITY (757) 225-7630 Acute Care - Department of Defense Department of Defense TRUE 37.0738311 -76.3580187 1 ROOFTOP 650 51 51650 47260 Virginia Beach-Norfolk, VA-NC Central Hampton city https://data.medicare.gov/resource/xubh-q36u/row-7sn4-kumh~7wv5                                      
3025 60th Medical Group (Travis AFB) 103 Bodin Circle Fairfield Fairfield CA 94533 SOLANO (707) 423-7300 Acute Care - Department of Defense Department of Defense TRUE 38.2679340 -121.9606640 0   95 6 6095 46700 San Jose-San Francisco-Oakland, CA Central Solano County https://data.medicare.gov/resource/xubh-q36u/row-wsxb-mk9r~mdjd                                      
875 673rd Medical Group (Joint Base Elmendorf-Richardson) 673 MDG 5955 Zeamer Ave JBER AK 99506 ANCHORAGE (907) 384-1110 Acute Care - Department of Defense Department of Defense TRUE 61.2348208 -149.7449348 1 ROOFTOP 20 2 2020 11260   Central Anchorage Municipality https://data.medicare.gov/resource/xubh-q36u/row-pmg3~gpys_qbnx                                      
1787 81st Medical Group (Keesler AFB) 81 MDG 301 Fisher St. Suite 109 Biloxi MS 39530 HARRISON (228) 377-6393 Acute Care - Department of Defense Department of Defense TRUE 30.4123007 -88.9109802 1 ROOFTOP 47 28 28047 25060   Central Harrison County https://data.medicare.gov/resource/xubh-q36u/row-a8uk.gq75_wykp                                      
2082 88th Medical Group (Wright-Patterson AFB) 88 MDG 4881 Sugar Maple Dr. Wright-Patterson AFB OH 45433 GREENE (937) 257-9926 Acute Care - Department of Defense Department of Defense TRUE 39.8052276 -84.0370421 1 ROOFTOP 57 39 39057 19380 Dayton-Springfield-Sidney, OH Central Greene County https://data.medicare.gov/resource/xubh-q36u/row-a32h-jkdv-qubw                                      
2937 96th Medical Group (Eglin AFB) 96 MDG 307 Boatner Rd Suite 114 Eglin AFB FL 32542 OKALOOSA (850) 883-8600 Acute Care - Department of Defense Department of Defense TRUE 30.4505460 -86.5433477 1 ROOFTOP 91 12 12091 18880   Central Okaloosa County https://data.medicare.gov/resource/xubh-q36u/row-4zpw_rzxt_qkvv                                      
190 99th Medical Group (Nellis AFB) 99 MDG 4700 Las Vegas Blvd Nellis AFB NV 89191 CLARK (702) 653-2273 Acute Care - Department of Defense Department of Defense TRUE 36.2457836 -115.0497641 1 ROOFTOP 3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-dmy4.2nr3_wdjy                                      
121 ABBEVILLE AREA MEDICAL CENTER 420 THOMSON CIRCLE ABBEVILLE SC 29620 ABBEVILLE (864) 366-5011 Critical Access Hospitals Government - Local TRUE 34.1561250 -82.3801740 0   1 45 45001 24940 Greenville-Spartanburg-Anderson, SC Outlying Abbeville County https://data.medicare.gov/resource/xubh-q36u/row-v8xu.2huz_ubxe 421301 645182 2019-02-25 2018-09-30 19 6         25               25
3472 ABBEVILLE GENERAL HOSPITAL 118 N HOSPITAL DR ABBEVILLE LA 70510 VERMILION (337) 893-5466 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.9732500 -92.1069860 0   113 22 22113 29180 Lafayette-Opelousas-Morgan City, LA Outlying Vermilion Parish https://data.medicare.gov/resource/xubh-q36u/row-b6fd-eygy.vwqx 190034 649244 2019-05-31 2018-12-31 38 6         44 16             60
1955 ABBOTT NORTHWESTERN HOSPITAL 800 EAST 28TH STREET MINNEAPOLIS MN 55407 HENNEPIN (612) 863-4457 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.9519540 -93.2622480 0   53 27 27053 33460 Minneapolis-St. Paul, MN-WI Central Hennepin County https://data.medicare.gov/resource/xubh-q36u/row-hjfu-wxhn.rudj 240057 649761 2019-05-23 2018-12-31 537 30         599   39   48       686
4659 ABILENE REGIONAL MEDICAL CENTER 6250 HWY 83/84 ABILENE TX 79606 TAYLOR (325) 428-1000 Acute Care Hospitals Proprietary TRUE 32.3740060 -99.7425950 0   441 48 48441 10180   Central Taylor County https://data.medicare.gov/resource/xubh-q36u/row-rque_a7mi~an5d 450558 657529 2019-04-12 2018-08-31 160 20         196               196
2968 ABINGTON MEMORIAL HOSPITAL 1200 OLD YORK ROAD ABINGTON PA 19001 MONTGOMERY (215) 481-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.1189450 -75.1193820 0   91 42 42091 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-yqgf~xkux~zsam 390231 661639 2019-12-03 2019-06-30 503 33     22   592 23 23           638
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
566 ABRAZO ARROWHEAD CAMPUS 18701 NORTH 67TH AVENUE GLENDALE AZ 85308 MARICOPA (623) 561-1000 Acute Care Hospitals Proprietary TRUE 33.6550420 -112.2028890 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-mbqg~urbx.9rm7 30094 654000 2019-08-29 2019-03-31 224 38         262               262
565 ABRAZO CENTRAL CAMPUS 2000 WEST BETHANY HOME ROAD PHOENIX AZ 85015 MARICOPA (602) 249-0212 Acute Care Hospitals Physician TRUE 33.5241160 -112.1019340 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-apke-ic6r-dws7 30030 654065 2019-08-30 2019-03-31 116 28         144   16           160
549 ABRAZO SCOTTSDALE CAMPUS 3929 EAST BELL ROAD PHOENIX AZ 85032 MARICOPA (602) 923-5000 Acute Care Hospitals Proprietary TRUE 33.6406030 -111.9976920 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-3yrx.bcen.wd4a 30083 644698 2019-02-28 2018-09-30 113 14         127               127
577 ABRAZO WEST CAMPUS 13677 WEST MCDOWELL ROAD GOODYEAR AZ 85395 MARICOPA (623) 882-1970 Acute Care Hospitals Proprietary TRUE 33.4642830 -112.3540240 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-6kds~arrq.mhdd 30110 654825 2019-09-26 2019-04-30 159 20         179               179
3471 ABROM KAPLAN MEMORIAL HOSPITAL 1310 WEST SEVENTH STREET KAPLAN LA 70548 VERMILION (337) 643-8300 Critical Access Hospitals Voluntary non-profit - Private TRUE 30.0075910 -92.2973370 0   113 22 22113 29180 Lafayette-Opelousas-Morgan City, LA Outlying Vermilion Parish https://data.medicare.gov/resource/xubh-q36u/row-hk2u-qsne-eka8 191322 643895 2019-03-01 2018-09-30 25           25 10             35
92 ACADIA GENERAL HOSPITAL 1305 CROWLEY RAYNE HIGHWAY CROWLEY LA 70526 ACADIA (337) 783-3222 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2263270 -92.3625430 0   1 22 22001 29180 Lafayette-Opelousas-Morgan City, LA Outlying Acadia Parish https://data.medicare.gov/resource/xubh-q36u/row-uxyh.5msh~3m79 190044 643888 2019-03-01 2018-09-30 136 4         140               140
91 ACADIA ST LANDRY 810 SOUTH BROADWAY STREET CHURCH POINT LA 70525 ACADIA (337) 684-5435 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.3950170 -92.2118330 0   1 22 22001 29180 Lafayette-Opelousas-Morgan City, LA Outlying Acadia Parish https://data.medicare.gov/resource/xubh-q36u/row-mqb2~y9xg-useh 191319 661189 2019-12-05 2019-06-30 15           15 10             25
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
4424 AD HOSPITAL EAST, LLC 12950 EAST FREEWAY, SUITE 100 HOUSTON TX 77015 HARRIS (713) 330-3897 Acute Care Hospitals Proprietary TRUE 29.7711360 -95.2007820 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-g9pj_7cms.hams 670102 649155 2019-05-30 2018-12-31 4           4               4
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
117 ADAMS COUNTY REGIONAL MEDICAL CENTER 230 MEDICAL CENTER DRIVE SEAMAN OH 45679 ADAMS (937) 386-3400 Critical Access Hospitals Government - Local TRUE 38.9338480 -83.5856120 0   1 39 39001         https://data.medicare.gov/resource/xubh-q36u/row-wb9j-jzwz-2xmu 361326 649329 2019-05-30 2018-12-31 25           25               25
88 ADAMS MEMORIAL HOSPITAL 1100 MERCER AVE DECATUR IN 46733 ADAMS (260) 724-2145 Critical Access Hospitals Government - Local TRUE 40.8179660 -84.9125350 0   1 18 18001 19540 Fort Wayne-Huntington-Auburn, IN Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-vdys.bcxa-gdh7 151330 649100 2019-05-30 2018-12-31 21 4         25               25
1083 ADCARE HOSPITAL OF WORCESTER INC 107 LINCOLN STREET WORCESTER MA 1605 WORCESTER (508) 799-9000 Acute Care Hospitals Proprietary FALSE 42.2761820 -71.7955760 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-rnsb.iihy_fs75 220062 645423 2019-03-01 2018-09-30 114           114               114
3816 ADENA PIKE MEDICAL CENTER 100 DAWN LANE WAVERLY OH 45690 PIKE (740) 947-2186 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1165050 -83.0058270 0   131 39 39131         https://data.medicare.gov/resource/xubh-q36u/row-zm47~vagh-p87t 361334 649331 2019-05-31 2018-12-31 25           25               25
3923 ADENA REGIONAL MEDICAL CENTER 272 HOSPITAL ROAD CHILLICOTHE OH 45601 ROSS (740) 779-7500 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.3945930 -82.9697810 0   141 39 39141 17060 Columbus-Marion-Zanesville, OH Central Ross County https://data.medicare.gov/resource/xubh-q36u/row-t8uy_6z9h-f7fq 360159 648968 2019-05-30 2018-12-31 177 12         189               189
1347 ADIRONDACK MEDICAL CENTER - SARANAC LAKE 2233 STATE ROUTE 86, PO BOX 471 SARANAC LAKE NY 12983 FRANKLIN (518) 891-4141 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.3445480 -74.1445970 0   33 36 36033 31660   Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-7ubk-sp7w.3hyq 330079 651024 2019-06-03 2018-12-31 75 8         83 12     60       155
3765 ADMIN DE SERVICIOS MEDICOS PUERTO RIC BO MONACILLO CARR NUM 22 SAN JUAN PR 935 SAN JUAN (787) 777-3535 Acute Care Hospitals Government - Local TRUE 18.4500000 -66.0600000 1 APPROXIMATE 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-gchu_zjdy_292t 400127 660877 2019-11-27 2019-06-30   68         68               68
3730 ADVANCED SURGICAL HOSPITAL 100 TRICH DRIVE WASHINGTON PA 15301 WASHINGTON (724) 884-0710 Acute Care Hospitals Physician FALSE 40.1567230 -80.2805360 0   125 42 42125 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-ni2v.da26_jxgn 390323 648978 2019-05-29 2018-12-31 14           14               14
2053 ADVENTHEALTH CARROLLWOOD 7171 N DALE MABRY HWY TAMPA FL 33614 HILLSBOROUGH (813) 932-2222 Acute Care Hospitals Voluntary non-profit - Church TRUE 28.0131020 -82.5049540 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-22he-y9u8_3jua 100069 649181 2019-05-31 2018-12-31 95 8         103               103
1107 ADVENTHEALTH CENTRAL TEXAS 2201 S CLEAR CREEK ROAD KILLEEN TX 76542 BELL (254) 526-7523 Acute Care Hospitals Voluntary non-profit - Church TRUE 31.1133500 -97.7995190 0   27 48 48027 28660   Central Bell County https://data.medicare.gov/resource/xubh-q36u/row-d3a2-awra.pykq 450152 656365 2019-10-17 2018-09-30 194 10       4 208               208
3196 ADVENTHEALTH DADE CITY 13100 FT KING RD DADE CITY FL 33525 PASCO (352) 568-3174 Acute Care Hospitals Proprietary TRUE 28.3485870 -82.2016850 0   101 12 12101 45300   Central Pasco County https://data.medicare.gov/resource/xubh-q36u/row-w886-maw8~uhkt 100211 644709 2019-02-28 2018-09-30 108 12         120               120
3739 ADVENTHEALTH DAYTONA BEACH 301 MEMORIAL MEDICAL PARKWAY DAYTONA BEACH FL 32117 VOLUSIA (386) 676-6000 Acute Care Hospitals Voluntary non-profit - Church FALSE 29.2427500 -81.1093000 0   127 12 12127 19660 Orlando-Deltona-Daytona Beach, FL Central Volusia County https://data.medicare.gov/resource/xubh-q36u/row-7r9b.2c85_ysjw 100068 656267 2019-10-21 2018-12-31 233 46         295   32           327
3742 ADVENTHEALTH DELAND 701 W PLYMOUTH AVE DELAND FL 32720 VOLUSIA (386) 943-4772 Acute Care Hospitals Voluntary non-profit - Church TRUE 29.0426130 -81.3172050 0   127 12 12127 19660 Orlando-Deltona-Daytona Beach, FL Central Volusia County https://data.medicare.gov/resource/xubh-q36u/row-vm7w-sguw.j5as 100045 650676 2019-05-31 2018-12-31 130 24         154 10             164
2982 ADVENTHEALTH DURAND 1220 3RD AVE W DURAND WI 54736 PEPIN (715) 672-4211 Critical Access Hospitals Voluntary non-profit - Church TRUE 44.6203090 -91.9635000 0   91 55 55091         https://data.medicare.gov/resource/xubh-q36u/row-qzeb.agub~nfph 521307 650794 2019-05-30 2018-12-31 25           25               25
3741 ADVENTHEALTH FISH MEMORIAL 1055 SAXON BLVD ORANGE CITY FL 32763 VOLUSIA (386) 917-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 28.9112900 -81.2841220 0   127 12 12127 19660 Orlando-Deltona-Daytona Beach, FL Central Volusia County https://data.medicare.gov/resource/xubh-q36u/row-ieux~5sp5~x27i 100072 654643 2019-09-24 2018-12-31 158 21         179               179
3783 ADVENTHEALTH GORDON 1035 RED BUD ROAD CALHOUN GA 30701 GORDON (706) 629-2895 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.5118780 -84.9253700 0   129 13 13129 15660 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Gordon County https://data.medicare.gov/resource/xubh-q36u/row-jbx7.hnkp.i7n7 110023 649429 2019-05-30 2018-12-31 61 8         69               69
3302 ADVENTHEALTH HEART OF FLORIDA 40100 HWY 27 DAVENPORT FL 33837 POLK (863) 422-4971 Acute Care Hospitals Proprietary TRUE 28.1803340 -81.6399540 0   105 12 12105 29460   Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-febs~ded9_jd7n 100137 656903 2018-12-03 2018-06-30 178 15         193               193
3303 ADVENTHEALTH LAKE WALES 410 S 11TH ST LAKE WALES FL 33853 POLK (863) 676-1433 Acute Care Hospitals Proprietary TRUE 27.8965330 -81.5646660 0   105 12 12105 29460   Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-qtf7.zzcz~qpg5 100099 649186 2019-06-03 2018-12-31 85 8         93 38             131
1901 ADVENTHEALTH MANCHESTER 210 MARIE LANGDON DRIVE MANCHESTER KY 40962 CLAY (606) 598-5104 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.1621540 -83.7613560 0   51 21 21051         https://data.medicare.gov/resource/xubh-q36u/row-vicy-u46v-q8em 180043 644277 2019-03-01 2018-09-30 43 6         49               49
4465 ADVENTHEALTH MURRAY 707 OLD DALTON ELLIJAY ROAD, PO BOX 1406 CHATSWORTH GA 30705 MURRAY (706) 517-2031 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7799510 -84.7821250 0   213 13 13213 19140 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Murray County https://data.medicare.gov/resource/xubh-q36u/row-6we3.tc54~eygq 110050 651268 2019-06-07 2018-12-31 29           29               29
3743 ADVENTHEALTH NEW SMYRNA BEACH 401 PALMETTO ST NEW SMYRNA BEACH FL 32170 VOLUSIA (386) 424-5100 Acute Care Hospitals Voluntary non-profit - Church TRUE 29.0211740 -80.9229030 0   127 12 12127 19660 Orlando-Deltona-Daytona Beach, FL Central Volusia County https://data.medicare.gov/resource/xubh-q36u/row-6zn7-6yd4.hxia 100014 649178 2019-05-30 2018-12-31 98 14         112               112
3257 ADVENTHEALTH NORTH PINELLAS 1395 S PINELLAS AVE TARPON SPRINGS FL 34689 PINELLAS (727) 942-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 28.1331400 -82.7585760 0   103 12 12103 45300   Central Pinellas County https://data.medicare.gov/resource/xubh-q36u/row-fea3-vbec-qidb 100055 649410 2019-05-30 2018-12-31 123 13         136       32       168
2741 ADVENTHEALTH OCALA 1500 SW 1ST AVE OCALA FL 34474 MARION (352) 351-7200 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.1742360 -82.1378340 0   83 12 12083 36100   Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-5mfq.kkk3.z2w9 100062 644236 2019-01-29 2018-07-31 369 44         413               413
3032 ADVENTHEALTH ORLANDO 601 E ROLLINS ST ORLANDO FL 32803 ORANGE (407) 303-1976 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.5734570 -81.3703280 0   95 12 12095 36740 Orlando-Deltona-Daytona Beach, FL Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-4fra_j2em.99x3 100007 648798 2019-05-22 2018-12-31 2256 221 40       2753 43 30           2826
2138 ADVENTHEALTH OTTAWA 1301 S MAIN STREET OTTAWA KS 66067 FRANKLIN (785) 229-8200 Acute Care Hospitals Government - Local FALSE 38.5972850 -95.2687590 0   59 20 20059 36840 Kansas City-Overland Park-Kansas City, MO-KS Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-kk74.krt5~vw4m 170014 654922 2019-10-01 2019-04-30 42 5         47               47
1383 ADVENTHEALTH PALM COAST 60 MEMORIAL MEDICAL PKWY PALM COAST FL 32164 FLAGLER (386) 586-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 29.4789870 -81.1900890 0   35 12 12035 19660 Orlando-Deltona-Daytona Beach, FL Central Flagler County https://data.medicare.gov/resource/xubh-q36u/row-zkit_irst-fsuv 100118 649415 2019-05-30 2018-12-31 81 18         99           32   131
4544 ADVENTHEALTH ROLLINS BROOK 608 NORTH KEY AVENUE LAMPASAS TX 76550 LAMPASAS (512) 556-3682 Critical Access Hospitals Voluntary non-profit - Church TRUE 31.0723300 -98.1856440 0   281 48 48281 28660   Outlying Lampasas County https://data.medicare.gov/resource/xubh-q36u/row-9tad_9sfa.xgc8 451323 644374 2019-03-01 2018-09-30 25           25               25
1996 ADVENTHEALTH SEBRING 4200 SUN N LAKE BLVD SEBRING FL 33871 HIGHLANDS (863) 314-4466 Acute Care Hospitals Voluntary non-profit - Church FALSE 27.5384550 -81.5068810 0   55 12 12055 42700   Central Highlands County https://data.medicare.gov/resource/xubh-q36u/row-kk9t~8fs5~ksmj 100109 661479 2019-11-26 2018-12-31 158 22         180 17             197
2954 ADVENTHEALTH SHAWNEE MISSION 9100 W 74TH STREET SHAWNEE MISSION KS 66204 JOHNSON (913) 676-2152 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.9951370 -94.6920400 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-uk59_btiw.yapj 170104 650698 2019-05-30 2018-12-31 259 28         323 42             365
2051 ADVENTHEALTH TAMPA 3100 E FLETCHER AVE TAMPA FL 33613 HILLSBOROUGH (813) 615-7200 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.0692260 -82.4245250 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-zdje.si2f_dc2y 100173 656268 2019-10-28 2018-12-31 420 58         506   30           536
2394 ADVENTHEALTH WATERMAN 1000 WATERMAN WAY TAVARES FL 32778 LAKE (352) 253-3300 Acute Care Hospitals Voluntary non-profit - Church FALSE 28.8223510 -81.7102100 0   69 12 12069 36740 Orlando-Deltona-Daytona Beach, FL Outlying Lake County https://data.medicare.gov/resource/xubh-q36u/row-mktc_ayyy_878g 100057 650249 2019-05-31 2018-12-31 229   40       269               269
1831 ADVENTHEALTH WAUCHULA 735 S 5TH AVE WAUCHULA FL 33873 HARDEE (863) 773-0216 Critical Access Hospitals Voluntary non-profit - Private TRUE 27.5394213 -81.8072774 1 ROOFTOP 49 12 12049 48100   Central Hardee County https://data.medicare.gov/resource/xubh-q36u/row-ev8e.32dq-kwq8 101300 649888 2019-05-30 2018-12-31 25           25               25
3195 ADVENTHEALTH WESLEY CHAPEL 2600 BRUCE B DOWNS BLVD WESLEY CHAPEL FL 33544 PASCO (813) 929-5490 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.1937180 -82.3534020 0   101 12 12101 45300   Central Pasco County https://data.medicare.gov/resource/xubh-q36u/row-sagk_8pbp_32tr 100319 649426 2019-05-30 2018-12-31 121 24         145               145
3194 ADVENTHEALTH ZEPHYRHILLS 7050 GALL BLVD ZEPHYRHILLS FL 33541 PASCO (813) 788-0411 Acute Care Hospitals Voluntary non-profit - Church TRUE 28.2609370 -82.1880410 0   101 12 12101 45300   Central Pasco County https://data.medicare.gov/resource/xubh-q36u/row-5w9q_uu4q-aya6 100046 649408 2019-05-31 2018-12-31 135 14         149               149
4386 ADVENTIST BOLINGBROOK HOSPITAL 500 REMINGTON BOULEVARD BOLINGBROOK IL 60440 WILL (630) 312-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.6793880 -88.0838830 0   197 17 17197 16980 Chicago-Naperville, IL-IN-WI Central Will County https://data.medicare.gov/resource/xubh-q36u/row-ymrs-ahsd~teyh 140304 649434 2019-05-31 2018-12-31 98 12         110 24             134
1688 ADVENTIST GLENOAKS 701 WINTHROP AVENUE GLENDALE HEIGHTS IL 60139 DU PAGE (630) 545-8000 Acute Care Hospitals Voluntary non-profit - Other FALSE 41.9151660 -88.0585970 0   43 17 17043 16980 Chicago-Naperville, IL-IN-WI Central DuPage County https://data.medicare.gov/resource/xubh-q36u/row-x625-ypig_3gjv 140292 650258 2019-05-31 2018-12-31 112 10         122 16             138
3519 ADVENTIST HEALTH AND RIDEOUT 726 4TH ST MARYSVILLE CA 95901 YUBA (530) 749-4300 Acute Care Hospitals Government - Federal TRUE 39.1388320 -121.5936220 0   115 6 6115 49700 Sacramento-Roseville, CA Central Yuba County https://data.medicare.gov/resource/xubh-q36u/row-ena2_rmjt-rgun 50133 660916 2019-11-27 2019-06-30 179 24         209               209
1124 ADVENTIST HEALTH BAKERSFIELD 2615 CHESTER AVENUE BAKERSFIELD CA 93301 KERN (661) 395-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.3830560 -119.0188570 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-siqs~heps~67ia 50455 649164 2019-05-31 2018-12-31 211 34         254               254
161 ADVENTIST HEALTH CASTLE 640 ULUKAHIKI ST KAILUA HI 96734 HONOLULU (808) 263-5500 Acute Care Hospitals Voluntary non-profit - Church TRUE 21.3815020 -157.7572290 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-5zcn.p8qz~eqqf 120006 655891 2019-10-07 2018-12-31 152 8         160               160
1314 ADVENTIST HEALTH CLEARLAKE 15630 18TH AVE - HWY 53 CLEARLAKE CA 95422 LAKE (707) 994-6486 Critical Access Hospitals Voluntary non-profit - Church TRUE 38.9353458 -122.6200816 1 ROOFTOP 33 6 6033 17340   Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-hud3~fp2e-cmcb 51317 648600 2019-05-31 2018-12-31 21 4         25               25
342 ADVENTIST HEALTH FEATHER RIVER 5974 PENTZ ROAD PARADISE CA 95969 BUTTE (530) 877-9361 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.7561610 -121.5723050 0   7 6 6007 17020   Central Butte County https://data.medicare.gov/resource/xubh-q36u/row-dx3c~3bgg.9vjq 50225 659201 2019-05-31 2018-12-31                              
1200 ADVENTIST HEALTH HANFORD 115 MALL DRIVE HANFORD CA 93230 KINGS (209) 410-7200 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.3238770 -119.6690050 0   31 6 6031 25260 Visalia-Porterville-Hanford, CA Central Kings County https://data.medicare.gov/resource/xubh-q36u/row-gskm_spqc_qqn6 50121 649537 2019-05-31 2018-12-31 208 22         230               230
1723 ADVENTIST HEALTH HOWARD MEMORIAL 1 MARCELA DR WILLITS CA 95490 MENDOCINO (707) 456-3031 Critical Access Hospitals Voluntary non-profit - Church TRUE 39.3897770 -123.3399710 0   45 6 6045 46380   Central Mendocino County https://data.medicare.gov/resource/xubh-q36u/row-ecr7.pfkq_ummb 51310 648599 2019-05-29 2018-12-31 21 4         25               25
2595 ADVENTIST HEALTH LODI MEMORIAL 975 S FAIRMONT AVENUE LODI CA 95240 SAN JOAQUIN (209) 334-3411 Acute Care Hospitals Voluntary non-profit - Other FALSE 38.1216340 -121.2857870 0   77 6 6077 44700 San Jose-San Francisco-Oakland, CA Central San Joaquin County https://data.medicare.gov/resource/xubh-q36u/row-ewtc_9ynj_9n73 50336 652390 2019-05-31 2018-12-31 172 10         182   8           190
1920 ADVENTIST HEALTH PORTLAND 10123 SE MARKET STREET PORTLAND OR 97216 MULTNOMAH (503) 257-2500 Acute Care Hospitals Voluntary non-profit - Church TRUE 45.5115370 -122.5590930 0   51 41 41051 38900 Portland-Vancouver-Salem, OR-WA Central Multnomah County https://data.medicare.gov/resource/xubh-q36u/row-zb4z~fv5p-q8sy 380060 649341 2019-05-30 2018-12-31 156 12         168 43             211
816 ADVENTIST HEALTH REEDLEY 372 W CYPRESS AVE REEDLEY CA 93654 FRESNO (559) 638-8155 Acute Care Hospitals Voluntary non-profit - Private FALSE 36.6078120 -119.4516950 0   19 6 6019 23420 Fresno-Madera, CA Central Fresno County https://data.medicare.gov/resource/xubh-q36u/row-re3j_d2jv_jrs3 50192 659200 2019-05-31 2018-12-31 49           49               49
3417 ADVENTIST HEALTH SIMI VALLEY 2975 N SYCAMORE DR SIMI VALLEY CA 93065 VENTURA (805) 955-6000 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.2888370 -118.7439600 0   111 6 6111 37100 Los Angeles-Long Beach, CA Central Ventura County https://data.medicare.gov/resource/xubh-q36u/row-dj8u_rx6h_z8s8 50236 659202 2019-05-31 2018-12-31 112 24       8 144               144
3364 ADVENTIST HEALTH SONORA 1000 GREENLEY ROAD SONORA CA 95370 TUOLUMNE (209) 536-5000 Acute Care Hospitals Voluntary non-profit - Church FALSE 37.9767280 -120.3694420 0   109 6 6109 43760   Central Tuolumne County https://data.medicare.gov/resource/xubh-q36u/row-7tcs_nvgu-e2ik 50335 652417 2019-05-31 2018-12-31 78 6         84       68       152
1993 ADVENTIST HEALTH ST HELENA 10 WOODLAND ROAD SAINT HELENA CA 94574 NAPA (707) 963-3611 Acute Care Hospitals Voluntary non-profit - Private FALSE 38.5419600 -122.4753440 0   55 6 6055 34900 San Jose-San Francisco-Oakland, CA Central Napa County https://data.medicare.gov/resource/xubh-q36u/row-v9r8~wyzg.agw4 50013 649700 2019-06-03 2018-12-31 105 12         117 13             130
1126 ADVENTIST HEALTH TEHACHAPI VALLEY 1100 MAGELLAN TEHACHAPI CA 93561 KERN (661) 823-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.1474419 -118.4504364 1 ROOFTOP 29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-xx6n.a25c~74jx 51301 648598 2019-05-31 2018-12-31 16 4         20               20
2065 ADVENTIST HEALTH TILLAMOOK 1000 THIRD STREET TILLAMOOK OR 97141 TILLAMOOK (503) 842-4444 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.4563220 -123.8549510 0   57 41 41057         https://data.medicare.gov/resource/xubh-q36u/row-hny7~x5jj.a66t 381317 648758 2019-05-28 2018-12-31 21 4         25               25
3337 ADVENTIST HEALTH TULARE 869 NORTH CHERRY STREET TULARE CA 93274 TULARE (559) 688-0821 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.2202830 -119.3376690 0   107 6 6107 47300 Visalia-Porterville-Hanford, CA Central Tulare County https://data.medicare.gov/resource/xubh-q36u/row-tgyx_3sgg-28ve 50784 655533 2019-10-17 2019-03-14 94 14         108               108
1724 ADVENTIST HEALTH UKIAH VALLEY 275 HOSPITAL DRIVE UKIAH CA 95482 MENDOCINO (707) 462-3111 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.1530190 -123.2038000 0   45 6 6045 46380   Central Mendocino County https://data.medicare.gov/resource/xubh-q36u/row-5xip-9esx.8u6b 50301 649538 2019-05-31 2018-12-31 42 6       2 50               50
1269 ADVENTIST HEALTHCARE SHADY GROVE MEDICAL CENTER 9901 MEDICAL CENTER DRIVE ROCKVILLE MD 20850 MONTGOMERY (240) 826-6527 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0980460 -77.2010270 0   31 24 24031 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-z5ai-uwvz~ja8i 210057 649038 2019-05-31 2018-12-31 280 27         338               338
1275 ADVENTIST HEALTHCARE WHITE OAK MEDICAL CENTER 12100 PLUM ORCHARD DRIVE SILVER SPRING MD 20904 MONTGOMERY (301) 891-5651 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0522630 -76.9582320 0   31 24 24031 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-tb4c-cc68.vyas 210016 649036 2019-05-31 2018-12-31 172 26         198               198
1690 ADVENTIST HINSDALE HOSPITAL 120 NORTH OAK ST HINSDALE IL 60521 DU PAGE (630) 856-9000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8053290 -87.9200620 0   43 17 17043 16980 Chicago-Naperville, IL-IN-WI Central DuPage County https://data.medicare.gov/resource/xubh-q36u/row-phw9~utfn-hiet 140122 649893 2019-05-30 2018-12-31 186 58         244 17             261
1263 ADVENTIST LA GRANGE MEMORIAL HOSPITAL 5101 S WILLOW SPRINGS RD LA GRANGE IL 60525 COOK (708) 352-1200 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.7973820 -87.8884070 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-7py8-axpr_w3jk 140065 649432 2019-05-30 2018-12-31 132 27         159   17           176
3464 ADVOCATE BROMENN MEDICAL CENTER 1304 FRANKLIN AVENUE NORMAL IL 61761 MC LEAN (309) 454-1400 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.4963320 -88.9909600 0   113 17 17113 14010 Bloomington-Pontiac, IL Central McLean County https://data.medicare.gov/resource/xubh-q36u/row-yyk7.wts2-z6re 140127 650688 2019-05-30 2018-12-31 176 30         206   15           221
1262 ADVOCATE CHRIST HOSPITAL & MEDICAL CENTER 4440 W 95TH STREET OAK LAWN IL 60453 COOK (708) 684-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.7203160 -87.7323640 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-q7d7-qtfa_384z 140208 650691 2019-05-30 2018-12-31 524 123         706 34 37           777
3090 ADVOCATE CONDELL MEDICAL CENTER 801 S MILWAUKEE AVE LIBERTYVILLE IL 60048 LAKE (847) 362-2900 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.2745630 -87.9516500 0   97 17 17097 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-ggn7-qxdn_2hfk 140202 650690 2019-05-30 2018-12-31 256 17         273               273
4444 ADVOCATE EUREKA HOSPITAL 101 S MAJOR ST EUREKA IL 61530 WOODFORD (309) 467-2371 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.7214050 -89.2716610 0   203 17 17203 37900 Peoria-Canton, IL Central Woodford County https://data.medicare.gov/resource/xubh-q36u/row-4ygy~3sdv-kmqs 141309 649725 2019-05-30 2018-12-31 25           25               25
1685 ADVOCATE GOOD SAMARITAN HOSPITAL 3815 HIGHLAND AVENUE DOWNERS GROVE IL 60515 DU PAGE (630) 275-5900 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.8191370 -88.0102200 0   43 17 17043 16980 Chicago-Naperville, IL-IN-WI Central DuPage County https://data.medicare.gov/resource/xubh-q36u/row-sbtc.2xfq-guy4 140288 649433 2019-06-11 2018-12-31 188 55         243 41             284
3091 ADVOCATE GOOD SHEPHERD HOSPITAL 450 WEST HIGHWAY 22 BARRINGTON IL 60010 LAKE (847) 381-9600 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.1934150 -88.1779590 0   97 17 17097 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-89k4.jid2~5ddd 140291 649723 2019-05-30 2018-12-31 144 32         176               176
1257 ADVOCATE ILLINOIS MASONIC MEDICAL CENTER 836 WEST WELLINGTON AVENUE CHICAGO IL 60657 COOK (773) 975-1600 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9363150 -87.6515540 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-f4m5.ndmq~4y5c 140182 650124 2019-05-31 2018-12-31 137 74 43       254 35 22           311
1260 ADVOCATE LUTHERAN GENERAL HOSPITAL 1775 DEMPSTER ST PARK RIDGE IL 60068 COOK (847) 723-2210 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.0397480 -87.8481460 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-d64d-m4ex~7p9f 140223 650693 2019-05-30 2018-12-31 415 33 32       534 50 45           629
1264 ADVOCATE SOUTH SUBURBAN HOSPITAL 17800 S KEDZIE AVE HAZEL CREST IL 60429 COOK (708) 799-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.5669220 -87.6943990 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-qvb6.mvan.67p8 140250 650695 2019-05-30 2018-12-31 213 20         233               233
8 ADVOCATE TRINITY HOSPITAL 2320 E 93RD ST CHICAGO IL 60617 COOK (773) 967-5002 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.7262110 -87.5672500 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-wz9w.j9tr_sabj 140048 650686 2019-05-30 2018-12-31 177 24         201               201
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
242 AIKEN REGIONAL MEDICAL CENTER 302 UNIVERSITY PARKWAY AIKEN SC 29801 AIKEN (803) 641-5900 Acute Care Hospitals Proprietary TRUE 33.5698900 -81.7650710 0   3 45 45003 12260   Central Aiken County https://data.medicare.gov/resource/xubh-q36u/row-2jsk_ph6i-gvkj 420082 648759 2019-05-29 2018-12-31 169 35         204 48 14           266
4066 AKRON CHILDREN'S HOSPITAL 1 PERKINS SQUARE AKRON OH 44308 SUMMIT (330) 543-1000 Childrens Voluntary non-profit - Private FALSE 41.0784210 -81.5267890 0   153 39 39153 10420 Cleveland-Akron-Canton, OH Central Summit County https://data.medicare.gov/resource/xubh-q36u/row-g6bs.ki8j-vwqu 363303 649334 2019-05-31 2018-12-31 303 23   12     402               402
4064 AKRON GENERAL MEDICAL CENTER 1 AKRON GENERAL AVENUE AKRON OH 44307 SUMMIT (330) 344-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0778590 -81.5327870 0   153 39 39153 10420 Cleveland-Akron-Canton, OH Central Summit County https://data.medicare.gov/resource/xubh-q36u/row-fwyk~yqdc~my3b 360027 660664 2019-11-25 2018-12-31 315 34 34       383 53             436
115 ALAMANCE REGIONAL MEDICAL CENTER 1240 HUFFMAN MILL RD BURLINGTON NC 27216 ALAMANCE (336) 538-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0637490 -79.5025280 0   1 37 37001 15500 Greensboro--Winston-Salem--High Point, NC Central Alamance County https://data.medicare.gov/resource/xubh-q36u/row-x8vw.bx9c.7dbj 340070 643428 2019-02-27 2018-09-30 144 20         176 36             212
49 ALAMEDA HOSPITAL 2070 CLINTON AVENUE ALAMEDA CA 94501 ALAMEDA (510) 522-3700 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7632300 -122.2535410 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-aten_zvra_dnju 50211 662328 2018-12-03 2018-06-30 29   5       34       181       215
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
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
114 ALBANY MEDICAL CENTER HOSPITAL 43 NEW SCOTLAND AVENUE, MAIL CODE 34 ALBANY NY 12208 ALBANY (518) 262-2400 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6532540 -73.7738600 0   1 36 36001 10580 Albany-Schenectady, NY Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-sggw.e236~c5a3 330013 649473 2019-05-29 2018-12-31 585 65 17     60 747 26 20           793

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