hospital_data

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

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

4,766 rows sorted by hosp_lookup_url

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
4460 4460 SETON MEDICAL CENTER HAYS 6001 KYLE PKWY KYLE TX 78640 HAYS (512) 324-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.0077340 -97.8552800 0   209 48 48209 12420   Central Hays County https://data.medicare.gov/resource/xubh-q36u/row-2smr~t9jf_xa5x 670056 660903 2019-11-26 2019-06-30 106 32       4 142               142
1220 1220 JOHN H STROGER JR HOSPITAL 1901 W HARRISON ST CHICAGO IL 60612 COOK (312) 864-6000 Acute Care Hospitals Government - Local TRUE 41.8740410 -87.6743110 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-2ss5~bvsp.bpf4 140124 659251 2019-11-07 2018-11-30 310 32   8 14   448               448
3761 3761 CUMBERLAND HOSPITAL LLC 9407 CUMBERLAND ROAD NEW KENT VA 23124 NEW KENT (804) 966-2242 Childrens Proprietary FALSE 37.5455310 -76.9792200 0   127 51 51127 40060   Outlying New Kent County https://data.medicare.gov/resource/xubh-q36u/row-2t5p~njzu.inug                                      
1495 1495 PROVIDENCE HOLY CROSS MEDICAL CENTER 15031 RINALDI ST MISSION HILLS CA 91346 LOS ANGELES (818) 365-8051 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.2790130 -118.4594850 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-2tfx_s99b_nbix 50278 648594 2019-05-24 2018-12-31 280 24       12 316   13   48       377
943 943 ST JOSEPH HOSPITAL 2700 DOLBEER ST EUREKA CA 95501 HUMBOLDT (707) 445-8121 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7831030 -124.1420390 0   23 6 6023 21700   Central Humboldt County https://data.medicare.gov/resource/xubh-q36u/row-2tjd-xmnr-if78 50006 662153 2019-11-26 2019-06-30 117 12       5 134   15           149
101 101 BARRETT HOSPITAL & HEALTHCARE 600 MT HWY 91 S DILLON MT 59725 BEAVERHEAD (406) 683-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.2006540 -112.6460030 0   1 30 30001         https://data.medicare.gov/resource/xubh-q36u/row-2tkn_v7av-d2ep 271318 662223 2019-11-27 2019-06-30 18           18               18
2063 2063 RIVERVIEW HEALTH 395 WESTFIELD RD NOBLESVILLE IN 46060 HAMILTON (317) 773-0760 Acute Care Hospitals Government - Local TRUE 40.0470260 -86.0240810 0   57 18 18057 26900 Indianapolis-Carmel-Muncie, IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-2tme-mzbr.en9s 150059 659262 2019-05-30 2018-12-31 94 15         109   24   25       158
4558 4558 WASHINGTON COUNTY REGIONAL MEDICAL CENTER 610 SPARTA ROAD SANDERSVILLE GA 31082 WASHINGTON (478) 240-2100 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.9968170 -82.8050420 0   303 13 13303         https://data.medicare.gov/resource/xubh-q36u/row-2tqu-phgw~rfp2 110086 658248 2019-02-01 2018-08-31 56           56       60       116
667 667 STRINGFELLOW MEMORIAL HOSPITAL 301 EAST 18TH ST ANNISTON AL 36201 CALHOUN (256) 235-8900 Acute Care Hospitals Proprietary TRUE 33.6677010 -85.8250250 0   15 1 1015 11500   Central Calhoun County https://data.medicare.gov/resource/xubh-q36u/row-2tt8-gqrt.8qr7 10038 644691 2019-02-28 2018-09-30 119 6         125               125
320 320 WOODLAND HEIGHTS MEDICAL CENTER 505 SOUTH JOHN REDDITT DRIVE LUFKIN TX 75904 ANGELINA (936) 634-8311 Acute Care Hospitals Proprietary TRUE 31.3277370 -94.7561390 0   5 48 48005 31260   Central Angelina County https://data.medicare.gov/resource/xubh-q36u/row-2twc-7b9d-f8nh 450484 649671 2019-05-31 2018-12-31 115 15         145               145
1924 1924 PROVIDENCE PORTLAND MEDICAL CENTER 4805 NE GLISAN STREET PORTLAND OR 97213 MULTNOMAH (503) 215-1111 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5265180 -122.6140580 0   51 41 41051 38900 Portland-Vancouver-Salem, OR-WA Central Multnomah County https://data.medicare.gov/resource/xubh-q36u/row-2u8n.htw2.4ypj 380061 647934 2019-05-16 2018-12-31 289 36       17 342 31 18           391
150 150 ST FRANCIS HOSPITAL 7TH AND CLAYTON STS WILMINGTON DE 19805 NEW CASTLE (302) 421-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7498827 -75.5665813 1 ROOFTOP 3 10 10003 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central New Castle County https://data.medicare.gov/resource/xubh-q36u/row-2uda_n6xn~szp8 80003 660361 2019-12-03 2019-06-30 154 20         180               180
2228 2228 VALLEY BAPTIST MEDICAL CENTER- BROWNSVILLE 1040 W JEFFERSON ST BROWNSVILLE TX 78520 CAMERON (956) 544-1400 Acute Care Hospitals Proprietary TRUE 25.9179310 -97.5119980 0   61 48 48061 15180 Brownsville-Harlingen-Raymondville, TX Central Cameron County https://data.medicare.gov/resource/xubh-q36u/row-2uxr-b9vz.7eni 450028 654696 2019-09-26 2019-04-30 183 24       36 243               243
3230 3230 HOSPITAL OF UNIV OF PENNSYLVANIA 34TH & SPRUCE STS PHILADELPHIA PA 19104 PHILADELPHIA (215) 662-3227 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9504425 -75.1925902 1 GEOMETRIC_CENTER 101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-2v8t-hvbn_kbi7 390111 661968 2019-11-26 2019-06-30 587 32 12   78 2 748   58           806
3359 3359 STONESPRINGS HOSPITAL CENTER 24440 STONE SPRINGS BOULEVARD DULLES VA 20166 LOUDOUN (571) 349-4000 Acute Care Hospitals Proprietary TRUE 38.9411850 -77.5443010 0   107 51 51107 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Loudoun County https://data.medicare.gov/resource/xubh-q36u/row-2vb9~tm4j.az4x 490145 646054 2019-04-01 2018-10-31 114 10         124               124
2532 2532 MONROE SURGICAL HOSPITAL 2408 BROADMOOR BLVD MONROE LA 71201 OUACHITA (318) 410-0002 Acute Care Hospitals Physician FALSE 32.5367710 -92.1022040 0   73 22 22073 33740 Monroe-Ruston-Bastrop, LA Central Ouachita Parish https://data.medicare.gov/resource/xubh-q36u/row-2viy_tht4-abuk 190245 650140 2019-06-03 2018-12-31 10           10               10
156 156 KAPIOLANI MEDICAL CENTER FOR WOMEN & CHILDREN 1319 PUNAHOU STREET HONOLULU HI 96826 HONOLULU (808) 983-6000 Childrens Voluntary non-profit - Private TRUE 21.3003960 -157.8342460 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-2vss_bgb6-b6d4 123300 659778 2019-11-26 2019-06-30 156 3         253               253
584 584 JOHN MUIR MEDICAL CENTER - CONCORD CAMPUS 2540 EAST ST CONCORD CA 94520 CONTRA COSTA (925) 682-8200 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.9829600 -122.0342360 0   13 6 6013 41860 San Jose-San Francisco-Oakland, CA Outlying Contra Costa County https://data.medicare.gov/resource/xubh-q36u/row-2wap.qtva-9eaj 50496 650803 2019-05-30 2018-12-31 208 36         244               244
2295 2295 LOMA LINDA UNIVERSITY MEDICAL CENTER-MURRIETA 28062 BAXTER ROAD MURRIETA CA 92563 RIVERSIDE (951) 290-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6134350 -117.1689230 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-2wpb~hess-t7nh 50770 657700 2019-01-18 2018-06-30 94 12       6 112               112
1543 1543 SPARROW CLINTON HOSPITAL 805 S OAKLAND SAINT JOHNS MI 48879 CLINTON (989) 224-6881 Critical Access Hospitals Proprietary TRUE 42.9934350 -84.5558080 0   37 26 26037 29620 Lansing-East Lansing-Owosso, MI Central Clinton County https://data.medicare.gov/resource/xubh-q36u/row-2x5u-xt8b.6eqd 231326 649611 2019-05-31 2018-12-31 23 2         25               25
660 660 MINNIE HAMILTON HEALTH SYSTEM 186 HOSPITAL DRIVE GRANTSVILLE WV 26147 CALHOUN (304) 354-9244 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.9237960 -81.0918910 0   13 54 54013         https://data.medicare.gov/resource/xubh-q36u/row-2x87.vdzq_mgqw 511303 651093 2019-06-03 2018-12-31 25           25       24       49
4308 4308 SMITH COUNTY MEMORIAL HOSPITAL 921 E. HIGHWAY 36 SMITH CENTER KS 66967 SMITH (785) 282-6845 Critical Access Hospitals Government - Local TRUE 39.7852490 -98.7727680 0   183 20 20183         https://data.medicare.gov/resource/xubh-q36u/row-2xcp~xm86-a2da 171377 654020 2019-08-29 2019-03-31 16           16               16
722 722 SUMMIT HEALTHCARE REGIONAL MEDICAL CENTER 2200 EAST SHOW LOW LAKE ROAD SHOW LOW AZ 85901 NAVAJO (928) 537-6399 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.2019670 -110.0183900 0   17 4 4017 43320   Central Navajo County https://data.medicare.gov/resource/xubh-q36u/row-2xk7_cqaa~gdmz 30062 651168 2019-06-03 2018-12-31 77 12         89               89
4294 4294 NORTON SOUND REGIONAL HOSPITAL 1000 GREG KRUSCHEK AVENUE (P O BOX 966) NOME AK 99762 NOME (907) 443-3311 Critical Access Hospitals Tribal TRUE 64.4992304 -165.3784042 1 ROOFTOP 180 2 2180         https://data.medicare.gov/resource/xubh-q36u/row-2xs3~z9eg.fia9 21308 646669 2019-04-15 2018-09-30 18           18       18       36
1198 1198 NEA BAPTIST MEMORIAL HOSPITAL 4800 EAST JOHNSON AVENUE JONESBORO AR 72401 CRAIGHEAD (870) 972-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.8642040 -90.6391070 0   31 5 5031 27860 Jonesboro-Paragould, AR Central Craighead County https://data.medicare.gov/resource/xubh-q36u/row-2xtp-iu4z.fhj9 40118 640739 2018-12-28 2018-09-30 144 36         180   24           204
103 103 BANNER CHURCHILL COMMUNITY HOSPITAL 801 EAST WILLIAMS AVENUE FALLON NV 89406 CHURCHILL (775) 423-3151 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.4748760 -118.7651800 0   1 32 32001 21980   Central Churchill County https://data.medicare.gov/resource/xubh-q36u/row-2y58~2j5s~r7uz 291313 654684 2019-09-18 2018-12-31 25           25               25
4529 4529 PROVIDENCE VALDEZ MEDICAL CENTER PO BOX 550 VALDEZ AK 99686 VALDEZ-CORDOVA (907) 835-2249 Critical Access Hospitals Government - Local TRUE 61.1364781 -146.3458866 1 ROOFTOP 261 2 2261         https://data.medicare.gov/resource/xubh-q36u/row-2ygw.872k~d2en 21301 652057 2019-05-30 2018-12-31 11           11       10       21
792 792 MULESHOE AREA MEDICAL CENTER 708 S 1ST ST MULESHOE TX 79347 BAILEY (806) 272-4524 Critical Access Hospitals Proprietary TRUE 34.2210290 -102.7284580 0   17 48 48017         https://data.medicare.gov/resource/xubh-q36u/row-2yhf.nyid~b2dz 451372 644191 2019-02-28 2018-09-30 25           25               25
1319 1319 CRAWFORD MEMORIAL HOSPITAL 1000 NORTH ALLEN STREET ROBINSON IL 62454 CRAWFORD (618) 544-3131 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.0136680 -87.7489990 0   33 17 17033         https://data.medicare.gov/resource/xubh-q36u/row-2yid-zac4-j637 141343 654840 2019-10-01 2019-04-30 25           25       35       60
3113 3113 MERCY HOSPITAL CARTHAGE 3125 DR RUSSELL SMITH WAY CARTHAGE MO 64836 JASPER (417) 358-8121 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.1367000 -94.3208720 0   97 29 29097 27900 Joplin-Miami, MO-OK Central Jasper County https://data.medicare.gov/resource/xubh-q36u/row-2yux-b6bx-99ya 261338 660634 2019-11-27 2019-06-30 25           25               25
3289 3289 REGIONAL HEALTH RAPID CITY HOSPITAL 353 FAIRMONT BLVD POST OFFICE BOX 6000 RAPID CITY SD 57701 PENNINGTON (605) 755-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.0586100 -103.2249640 0   103 46 46103 39660 Rapid City-Spearfish, SD Central Pennington County https://data.medicare.gov/resource/xubh-q36u/row-2zks_fxav-k73q 430077 658789 2018-11-27 2018-06-30 305 38         371   16           387
4666 4666 DELL CHILDREN'S MEDICAL CENTER OF CENTRAL TEXAS 4900 MUELLER BLVD AUSTIN TX 78723 TRAVIS (512) 324-0000 Childrens Voluntary non-profit - Private TRUE 30.3025490 -97.7049570 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-2zt9_yffw~gyhs 453310 661423 2019-11-25 2019-06-30 127         76 203               203
4496 4496 TRISTAR GREENVIEW REGIONAL HOSPITAL 1801 ASHLEY CIRCLE BOWLING GREEN KY 42104 WARREN (270) 793-1000 Acute Care Hospitals Proprietary TRUE 36.9656720 -86.4355990 0   227 21 21227 14540 Bowling Green-Glasgow, KY Central Warren County https://data.medicare.gov/resource/xubh-q36u/row-2zzw_pa4z_rrd4 180124 655448 2019-10-18 2018-09-30 146 16         162               162
2910 2910 CLARK FORK VALLEY HOSPITAL 10 KRUGER RD PLAINS MT 59859 SANDERS (406) 826-4800 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.4695390 -114.8919080 0   89 30 30089         https://data.medicare.gov/resource/xubh-q36u/row-325u_sses_9br7 271323 649796 2019-05-24 2018-12-31 16           16       28       44
3638 3638 SSM HEALTH ST MARY'S HOSPITAL -CENTRALIA 400 NORTH PLEASANT AVENUE CENTRALIA IL 62801 MARION (618) 436-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.5308090 -89.1159990 0   121 17 17121 16460 St. Louis-St. Charles-Farmington, MO-IL Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-328q~u4tz_dprn 140034 649431 2019-05-29 2018-12-31 73 9         82 24             106
1178 1178 METHODIST STONE OAK HOSPITAL 1139 E SONTERRA BLVD, STE 535 SAN ANTONIO TX 78258 BEXAR (210) 638-2100 Acute Care Hospitals Proprietary TRUE 29.6144940 -98.4754590 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-32ag-t8fj-9ybq 670055 652855 2019-07-31 2019-02-28 175 28       24 227   15           242
3010 3010 MERCY HEALTH-LORAIN HOSPITAL 3700 KOLBE ROAD LORAIN OH 44053 LORAIN (440) 960-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.4360020 -82.2352120 0   93 39 39093 17460 Cleveland-Akron-Canton, OH Outlying Lorain County https://data.medicare.gov/resource/xubh-q36u/row-32k3_ajz8.6apg 360172 648303 2019-05-21 2018-12-31 155 16         171 25 30       13   239
2720 2720 STROUD REGIONAL MEDICAL CENTER 2308 HIGHWAY 66 WEST STROUD OK 74079 LINCOLN (918) 968-3571 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.7500350 -96.6832260 0   81 40 40081 36420 Oklahoma City-Shawnee, OK Outlying Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-32s4-f67h_3c7q 371316 643835 2019-03-01 2018-09-30 25           25               25
2621 2621 CHOCTAW NATION HEALTH SERVICES AUTHORITY 1 CHOCTAW WAY TALIHINA OK 74571 LATIMER (918) 567-7000 Acute Care Hospitals Tribal TRUE 34.7537210 -95.0819060 0   77 40 40077         https://data.medicare.gov/resource/xubh-q36u/row-32zv~xccv_piej 370172 651345 2019-07-02 2018-09-30 43           43               43
1187 1187 CHRISTUS SANTA ROSA MEDICAL CENTER 2827 BABCOCK ROAD SAN ANTONIO TX 78229 BEXAR (210) 704-3342 Acute Care Hospitals Voluntary non-profit - Church TRUE 29.5129090 -98.5915570 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-332s~bezr_i5q2 450237 660052 2019-11-26 2019-06-30 323 49       5 377               377
4494 4494 PIEDMONT MOUNTAINSIDE HOSPITAL INC 1266 HIGHWAY 515 SOUTH JASPER GA 30143 PICKENS (706) 301-5269 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.4474660 -84.4465610 0   227 13 13227 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Pickens County https://data.medicare.gov/resource/xubh-q36u/row-3378.2eh9-tse8 110225 659235 2019-11-22 2019-06-30 46 6         52               52
2848 2848 EAST MORGAN COUNTY HOSPITAL 2400 WEST EDISON STREET BRUSH CO 80723 MORGAN (970) 842-6222 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.2547380 -103.6491780 0   87 8 8087 22820   Central Morgan County https://data.medicare.gov/resource/xubh-q36u/row-33cv-duhz_he5u 61303 649171 2019-06-03 2018-12-31 25           25               25
2390 2390 MCKEE MEDICAL CENTER 2000 BOISE AVE LOVELAND CO 80538 LARIMER (970) 669-4640 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4136790 -105.0535990 0   69 8 8069 22660   Central Larimer County https://data.medicare.gov/resource/xubh-q36u/row-33js.ddiw.t8wg 60030 649547 2019-06-03 2018-12-31 104 11         115               115
2003 2003 ST CATHERINE HOSPITAL 401 EAST SPRUCE GARDEN CITY KS 67846 FINNEY (620) 272-2222 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.9688710 -100.8686150 0   55 20 20055 23780   Central Finney County https://data.medicare.gov/resource/xubh-q36u/row-33tn.4j7w~te3s 170023 660221 2019-11-26 2019-06-30 75 8       7 90   10           100
694 694 NIOBRARA VALLEY HOSPITAL P O BOX 118, 401 SOUTH 5TH STREET LYNCH NE 68746 BOYD (402) 569-2451 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.8245631 -98.4684820 1 ROOFTOP 15 31 31015         https://data.medicare.gov/resource/xubh-q36u/row-34qy.5xrg_j9e4 281303 658942 2018-11-19 2018-08-31 20           20               20
3047 3047 TRUMAN MEDICAL CENTER HOSPITAL HILL 2301 HOLMES STREET KANSAS CITY MO 64108 JACKSON (816) 404-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0848150 -94.5757990 0   95 29 29095 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-34yq.yjtb-buxd 260048 661350 2019-12-03 2019-06-30 189 41         238               238
3961 3961 SOUTHWESTERN REGIONAL MEDICAL CENTER, INC 10109 EAST 79TH STREET TULSA OK 74133 TULSA (918) 286-5000 Acute Care Hospitals Proprietary TRUE 36.0463390 -95.8642110 0   143 40 40143 46140 Tulsa-Muskogee-Bartlesville, OK Central Tulsa County https://data.medicare.gov/resource/xubh-q36u/row-34zt~qq9g_7fzk 370190 661242 2019-12-02 2019-06-30 27 13         40               40
2192 2192 BIGFORK VALLEY HOSPITAL 258 PINE TREE DRIVE PO BOX 258 BIGFORK MN 56628 ITASCA (218) 743-3177 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.7468850 -93.6468220 0   61 27 27061         https://data.medicare.gov/resource/xubh-q36u/row-356c-64uf.kf5r 241316 650718 2019-05-31 2018-12-31 20           20       47       67
3956 3956 SAINT FRANCIS HOSPITAL, INC 6161 SOUTH YALE TULSA OK 74136 TULSA (918) 494-2200 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0734420 -95.9221180 0   143 40 40143 46140 Tulsa-Muskogee-Bartlesville, OK Central Tulsa County https://data.medicare.gov/resource/xubh-q36u/row-35hh.tmvt-ja6e 370091 660847 2019-11-27 2019-06-30 665 100 18     20 861   22           883
4590 4590 MEMORIAL HOSPITAL 224 E SECOND STREET DUMAS TX 79029 MOORE (806) 935-7171 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.8642640 -101.9710060 0   341 48 48341 20300   Central Moore County https://data.medicare.gov/resource/xubh-q36u/row-35k5-7dip~y499 451386 659901 2019-11-25 2019-06-30 16 3         19               19
994 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
2092 2092 SKAGIT VALLEY HOSPITAL 1415 KINCAID STREET MOUNT VERNON WA 98274 SKAGIT (360) 424-4111 Acute Care Hospitals Government - Hospital District or Authority TRUE 48.4174220 -122.3243350 0   57 53 53057 34580 Seattle-Tacoma, WA Central Skagit County https://data.medicare.gov/resource/xubh-q36u/row-35tt.efdg~xsq2 500003 650919 2019-05-30 2018-12-31 125   12       137               137
99 99 MERIT HEALTH NATCHEZ 52 SERGEANT PRENTISS DRIVE NATCHEZ MS 39120 ADAMS (601) 443-2100 Acute Care Hospitals Proprietary TRUE 31.5279831 -91.3884516 1 RANGE_INTERPOLATED 1 28 28001 35020   Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-36cp~uwxv-3duz 250084 643800 2019-02-27 2018-09-30 132 15         147 12 20           179
795 795 BATH COMMUNITY HOSPITAL 106 PARK DRIVE- PO DRAWER Z HOT SPRINGS VA 24445 BATH (540) 839-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9938900 -79.8309590 0   17 51 51017         https://data.medicare.gov/resource/xubh-q36u/row-36k3~dwrj~zvyd 491300 650420 2019-05-31 2018-12-31 14           14               14
3253 3253 MORTON PLANT HOSPITAL 300 PINELLAS ST CLEARWATER FL 33756 PINELLAS (727) 462-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 27.9519120 -82.8038740 0   103 12 12103 45300   Central Pinellas County https://data.medicare.gov/resource/xubh-q36u/row-36n2_2uji~u53k 100127 650680 2019-05-31 2018-12-31 516 38 21     15 590       120       710
3589 3589 ANDERSON HOSPITAL 6800 STATE ROUTE 162 MARYVILLE IL 62062 MADISON (618) 288-5711 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7381270 -89.9464220 0   119 17 17119 41180 St. Louis-St. Charles-Farmington, MO-IL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-36x2~e4v5.43qg 140289 650994 2019-06-03 2018-12-31 106 24         130   24           154
3682 3682 REGIONS HOSPITAL 640 JACKSON STREET SAINT PAUL MN 55101 RAMSEY (651) 254-1616 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.9553380 -93.0962770 0   123 27 27123 33460 Minneapolis-St. Paul, MN-WI Central Ramsey County https://data.medicare.gov/resource/xubh-q36u/row-36zs~9stm-xa4i 240106 649268 2019-05-24 2018-12-31 375 16 12   18 10 431   21           452
1792 1792 PROVIDENCE ST JOSEPH MEDICAL CENTER 6 13TH AVE E POLSON MT 59860 LAKE (406) 883-5377 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.6833440 -114.1633270 0   47 30 30047         https://data.medicare.gov/resource/xubh-q36u/row-374m.kmb6-3786 271343 648712 2019-05-29 2018-12-31 22           22               22
4358 4358 MERCY HOSPITAL ST LOUIS 615 NEW BALLAS ROAD SAINT LOUIS MO 63141 ST. LOUIS (314) 569-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.6439938 -90.4465938 1 ROOFTOP 189 29 29189 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-37f8.hd52.bkvb 260020 661026 2019-11-27 2019-06-30 654 66 16 9   98 843 16             859
129 129 EAST ADAMS RURAL HOSPITAL 903 SOUTH ADAMS RITZVILLE WA 99169 ADAMS (509) 659-1200 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.1209590 -118.3722580 0   1 53 53001 36830 Moses Lake-Othello, WA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-37up~x54g-vsqq 501311 653086 2019-05-31 2018-12-31 12           12               12
1565 1565 VANDERBILT UNIVERSITY MEDICAL CENTER 1211 MEDICAL CENTER DRIVE NASHVILLE TN 37232 DAVIDSON (615) 322-3454 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.1428320 -86.8001740 0   37 47 47037 34980 Nashville-Davidson--Murfreesboro, TN Central Davidson County https://data.medicare.gov/resource/xubh-q36u/row-37w9.8wm5-8dja 440039 654753 2019-10-04 2019-06-30 473 111 79 25 62   954 92             1046
1862 1862 RIVERSIDE METHODIST HOSPITAL 3535 OLENTANGY RIVER RD COLUMBUS OH 43214 FRANKLIN (614) 566-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0319620 -83.0312940 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-3863-kqrj_7sqc 360006 659832 2019-11-21 2019-06-30 577 88 30       695 39             734
2750 2750 RICHARDSON MEDICAL CENTER 254 HIGHWAY 3048 RAYVILLE LA 71269 RICHLAND (318) 728-4181 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.4639730 -91.7478790 0   83 22 22083         https://data.medicare.gov/resource/xubh-q36u/row-387x~nsyb.i8m2 190151 646337 2019-04-05 2018-09-30 36 2         38               38
1003 1003 UNIVERSITY OF MD HARFORD MEMORIAL HOSPITAL 501 SOUTH UNION AVENUE HAVRE DE GRACE MD 21078 HARFORD (443) 643-3303 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.5434800 -76.0915280 0   25 24 24025 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Outlying Harford County https://data.medicare.gov/resource/xubh-q36u/row-388e~htvc_kuq3 210006 659968 2019-12-02 2019-06-30 77 5         82               82
842 842 KEARNEY REGIONAL MEDICAL CENTER 804 22ND AVENUE KEARNEY NE 68845 BUFFALO (308) 455-3600 Acute Care Hospitals Proprietary TRUE 40.6975000 -99.0931000 0   19 31 31019 28260   Central Buffalo County https://data.medicare.gov/resource/xubh-q36u/row-3996-74wm-rsdj 280134 650297 2019-06-04 2018-12-31 68 18         94               94
3878 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
2890 2890 RUSH COPLEY MEDICAL CENTER 2000 OGDEN AVENUE AURORA IL 60504 KANE (630) 978-6200 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7277220 -88.2684150 0   89 17 17089 16980 Chicago-Naperville, IL-IN-WI Central Kane County https://data.medicare.gov/resource/xubh-q36u/row-39d4~37w6~ivsi 140029 659945 2019-11-25 2019-06-30 157 22         192   18           210
4347 4347 STEVENS COUNTY HOSPITAL 1006 S JACKSON HUGOTON KS 67951 STEVENS (620) 544-8511 Critical Access Hospitals Government - Local TRUE 37.1708080 -101.3497550 0   189 20 20189         https://data.medicare.gov/resource/xubh-q36u/row-39kr.3u54-pmuw 171335 649737 2019-06-03 2018-12-31 17           17           83   100
1229 1229 NORTHWEST COMMUNITY HOSPITAL 1 800 W CENTRAL ROAD ARLINGTON HEIGHTS IL 60005 COOK (847) 618-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0666040 -87.9929510 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-39t4.gcrd_v8y9 140252 644983 2019-02-28 2018-09-30 328 60       8 396 52 33           481
509 509 ASCENSION STANDISH HOSPITAL 805 W CEDAR ST STANDISH MI 48658 ARENAC (517) 846-4521 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.9828300 -83.9693520 0   11 26 26011         https://data.medicare.gov/resource/xubh-q36u/row-3a56-bznt.bz29 231305 639965 2018-12-12 2018-06-30 20 5         25       29       54
533 533 SURGICAL INSTITUTE OF READING 2752 CENTURY BOULEVARD WYOMISSING PA 19610 BERKS (717) 999-9999 Acute Care Hospitals Proprietary FALSE 40.3579510 -75.9875770 0   11 42 42011 39740 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Berks County https://data.medicare.gov/resource/xubh-q36u/row-3aqm~vs6z.7ify 390316 651482 2019-06-25 2018-12-31 15           15               15
4281 4281 LIBERTY REGIONAL MEDICAL CENTER 462 E G MILES PARKWAY HINESVILLE GA 31310 LIBERTY (912) 369-9438 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.8394772 -81.6009755 1 ROOFTOP 179 13 13179 25980 Savannah-Hinesville-Statesboro, GA Central Liberty County https://data.medicare.gov/resource/xubh-q36u/row-3b9g_44yp.xw63 111335 647248 2019-05-01 2018-11-30 25           25       108       133
1608 1608 PEACE HARBOR MEDICAL CENTER 400 9TH STREET FLORENCE OR 97439 LANE (541) 997-8412 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.9745890 -124.1174640 0   39 41 41039 21660   Central Lane County https://data.medicare.gov/resource/xubh-q36u/row-3bhj~d2nf.qxkv 381316 662244 2019-12-02 2019-06-30 21           21               21
365 365 BROADWATER HEALTH CENTER 110 N OAK ST TOWNSEND MT 59644 BROADWATER (406) 266-3186 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.3213540 -111.5164280 0   7 30 30007         https://data.medicare.gov/resource/xubh-q36u/row-3bqc_c9ze~3cij 271333 662052 2019-12-03 2019-06-30 25           25               25
4361 4361 COVENANT HOSPITAL PLAINVIEW 2601 DIMMITT RD PLAINVIEW TX 79072 HALE (806) 296-5531 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.2072140 -101.7316260 0   189 48 48189 38380   Central Hale County https://data.medicare.gov/resource/xubh-q36u/row-3bv3~8kd2-nnfr 450539 661663 2019-12-03 2019-06-30 44 5         49               49
4446 4446 ROCKCASTLE REGIONAL HOSPITAL & RESPIRATORY CARE CT 145 NEWCOMB AVENUE MOUNT VERNON KY 40456 ROCKCASTLE (606) 256-2195 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3580060 -84.3370010 0   203 21 21203 40080 Lexington-Fayette--Richmond--Frankfort, KY Outlying Rockcastle County https://data.medicare.gov/resource/xubh-q36u/row-3bvu-6res-7u6h 180115 646683 2019-04-17 2018-10-31 20           20       127       147
3712 3712 MCLAREN OAKLAND 50 N PERRY ST PONTIAC MI 48342 OAKLAND (248) 338-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6383940 -83.2910950 0   125 26 26125 19820 Detroit-Warren-Ann Arbor, MI Central Oakland County https://data.medicare.gov/resource/xubh-q36u/row-3bzu-t8bq_ne8q 230207 644748 2019-02-27 2018-09-30 99 9         108 27 16           151
1715 1715 LINCOLN HOSPITAL 10 NICHOLS STREET DAVENPORT WA 99122 LINCOLN (509) 725-7101 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.6571949 -118.1462384 1 RANGE_INTERPOLATED 43 53 53043         https://data.medicare.gov/resource/xubh-q36u/row-3c5v_e33f-mmva 501305 647597 2019-05-13 2018-12-31 25           25               25
2875 2875 THEDACARE MEDICAL CENTER NEW LONDON 1405 MILL ST NEW LONDON WI 54961 WAUPACA (920) 531-2000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3816680 -88.7331240 0   87 55 55087 11540 Appleton-Oshkosh-Neenah, WI Central Outagamie County https://data.medicare.gov/resource/xubh-q36u/row-3ckm-rirg.mkfx 521326 650927 2019-06-03 2018-12-31 25           25               25
359 359 MIDMICHIGAN MEDICAL CENTER - ALPENA 1501 W CHISHOLM ST ALPENA MI 49707 ALPENA (989) 356-7390 Acute Care Hospitals Proprietary TRUE 45.0768570 -83.4506720 0   7 26 26007 10980   Central Alpena County https://data.medicare.gov/resource/xubh-q36u/row-3cst~3hfe~ssf7 230036 660579 2019-11-25 2019-06-30 119 9         128   11           139
4196 4196 MEMORIAL HOSPITAL 209 NORTHWEST 8TH STREET SEMINOLE TX 79360 GAINES (432) 758-4854 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.7213190 -102.6537290 0   165 48 48165         https://data.medicare.gov/resource/xubh-q36u/row-3czq_q5xj.bax4 451358 643854 2019-03-01 2018-09-30 25           25               25
3663 3663 LEWISGALE HOSPITAL MONTGOMERY 3700 SOUTH MAIN STREET BLACKSBURG VA 24060 MONTGOMERY (540) 951-1111 Acute Care Hospitals Proprietary TRUE 37.1856210 -80.4086120 0   121 51 51121 13980   Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-3des-4erp_ke8h 490110 654901 2019-10-01 2018-09-30 78 10         88               88
3474 3474 BEACHAM MEMORIAL HOSPITAL 205 N CHERRY STREET MAGNOLIA MS 39652 PIKE (601) 783-2353 Acute Care Hospitals Proprietary FALSE 31.1456260 -90.4592900 0   113 28 28113 32620   Central Pike County https://data.medicare.gov/resource/xubh-q36u/row-3dmz-gqww~dtyc 250049 660400 2019-12-03 2019-06-30 17           17 14             31
176 176 CARY MEDICAL CENTER 163 VAN BUREN RD, SUITE 1 CARIBOU ME 4736 AROOSTOOK (207) 498-3111 Acute Care Hospitals Government - Local TRUE 46.8782370 -68.0096390 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-3dpx.x267~9y3n 200031 650153 2019-05-31 2018-12-31 43 6         49               49
69 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
1487 1487 LAC/OLIVE VIEW-UCLA MEDICAL CENTER 14445 OLIVE VIEW DRIVE SYLMAR CA 91342 LOS ANGELES (818) 364-1555 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.3259120 -118.4455130 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-3dym-zkj6.4ich 50040 660489 2019-12-03 2019-06-30 238 18         270 34             304
3966 3966 TEXAS HEALTH HARRIS METHODIST HOSPITAL STEPHENVILL 411 N BELKNAP ST STEPHENVILLE TX 76401 ERATH (254) 965-1500 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.2231630 -98.2048710 0   143 48 48143 44500   Central Erath County https://data.medicare.gov/resource/xubh-q36u/row-3e4m_j29y-qggx 450351 643850 2019-02-28 2018-09-30 45 5         50               50
4553 4553 LIMESTONE MEDICAL CENTER 701 MCCLINTIC DRIVE GROESBECK TX 76642 LIMESTONE (254) 729-3281 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.5319230 -96.5296210 0   293 48 48293         https://data.medicare.gov/resource/xubh-q36u/row-3e5u-tjfa_7eb2 451303 643539 2019-02-22 2018-09-30 20           20               20
1801 1801 KINGS COUNTY HOSPITAL CENTER 451 CLARKSON AVENUE BROOKLYN NY 11203 KINGS (718) 245-3901 Acute Care Hospitals Government - Local TRUE 40.6557730 -73.9440390 0   47 36 36047 35620 New York-Newark, NY-NJ-CT-PA Central Kings County https://data.medicare.gov/resource/xubh-q36u/row-3ead-5d6n-7ch8 330202 661941 2019-12-03 2019-06-30 329 32 8     30 406 205 23           634
868 868 MONTGOMERY GENERAL HOSPITAL, INC 401 SIXTH AVENUE MONTGOMERY WV 25136 FAYETTE (304) 442-5151 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.1828780 -81.3247080 0   19 54 54019 13220   Central Fayette County https://data.medicare.gov/resource/xubh-q36u/row-3eev_ya4k~dm4q 511318 651094 2019-06-03 2018-12-31 25           25       44       69
869 869 PLATEAU MEDICAL CENTER 430 MAIN STREET, WEST OAK HILL WV 25901 FAYETTE (304) 469-8600 Critical Access Hospitals Proprietary TRUE 37.9746800 -81.1441700 0   19 54 54019 13220   Central Fayette County https://data.medicare.gov/resource/xubh-q36u/row-3eu5_8zzh~m57x 511317 651684 2019-06-24 2018-12-31 22 3         25               25
1705 1705 SAMARITAN ALBANY GENERAL HOSPITAL 1046 6TH AVENUE SW ALBANY OR 97321 LINN (541) 812-4000 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.6320670 -123.1167710 0   43 41 41043 10540 Portland-Vancouver-Salem, OR-WA Central Linn County https://data.medicare.gov/resource/xubh-q36u/row-3f45~84ie_23rn 380022 650903 2019-05-28 2018-12-31 56 11         67               67
4608 4608 QUAIL CREEK SURGICAL HOSPITAL 6819 PLUM CREEK AMARILLO TX 79124 POTTER (806) 354-6100 Acute Care Hospitals Proprietary TRUE 35.2106750 -101.9135680 0   375 48 48375 11100 Amarillo-Borger, TX Central Potter County https://data.medicare.gov/resource/xubh-q36u/row-3fht_yhjz.yec5 450875 648767 2019-05-24 2018-12-31 32           32               32
4610 4610 REAGAN MEMORIAL HOSPITAL 1300 N MAIN AVENUE BIG LAKE TX 76932 REAGAN (325) 844-2561 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.2016510 -101.4615870 0   383 48 48383         https://data.medicare.gov/resource/xubh-q36u/row-3fmb~j2vv~wgtn 451301 651298 2019-03-05 2018-09-30 7           7               7
341 341 MERCY HOSPITAL NORTHWEST ARKANSAS 2710 SOUTH RIFE MEDICAL LANE ROGERS AR 72758 BENTON (479) 338-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.3095620 -94.1847090 0   7 5 5007 22220   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-3g3b-cs9n_qbhj 40010 660742 2019-12-04 2019-06-30 174 24         206               206
1714 1714 ODESSA MEMORIAL HEALTHCARE CENTER 502 E AMENDE DRIVE ODESSA WA 99159 LINCOLN (509) 982-2611 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.3315920 -118.6821000 0   43 53 53043         https://data.medicare.gov/resource/xubh-q36u/row-3g78.g9dg.38qw 501307 646279 2019-04-10 2018-12-31 25           25           12   37
4080 4080 MEMORIAL HEALTHCARE 826 WEST KING STREET OWOSSO MI 48867 SHIAWASSEE (989) 723-5211 Acute Care Hospitals Voluntary non-profit - Other FALSE 43.0050750 -84.1820760 0   155 26 26155 37020 Lansing-East Lansing-Owosso, MI Central Shiawassee County https://data.medicare.gov/resource/xubh-q36u/row-3gmb~kzum~86xp 230121 649608 2019-05-31 2018-12-31 104 7         111       7 32     150
303 303 ST BARNABAS HOSPITAL 4422 THIRD AVENUE BRONX NY 10457 BRONX (212) 960-9000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8527700 -73.8921680 0   5 36 36005 35620 New York-Newark, NY-NJ-CT-PA Central Bronx County https://data.medicare.gov/resource/xubh-q36u/row-3gvt~bki7.kjpu 330399 649478 2019-06-11 2018-12-31 242 26       15 283 49             332
2149 2149 NORTH SHORE UNIVERSITY HOSPITAL 300 COMMUNITY DRIVE MANHASSET NY 11030 NASSAU (516) 562-0100 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7792690 -73.7030290 0   59 36 36059 35620 New York-Newark, NY-NJ-CT-PA Central Nassau County https://data.medicare.gov/resource/xubh-q36u/row-3gzb.wswz~b9sd 330106 650193 2019-05-30 2018-12-31 611 47 15   40 51 764 20     256       1040
3064 3064 MERCY ST ANNE HOSPITAL 3404 SYLVANIA AVENUE TOLEDO OH 43623 LUCAS (419) 407-2663 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.6917450 -83.6251760 0   95 39 39095 45780 Toledo-Port Clinton, OH Central Lucas County https://data.medicare.gov/resource/xubh-q36u/row-3hht~5n55~wmny 360262 648305 2019-05-20 2018-12-31 94 29         123               123

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