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

383 rows where "filed_date" is on date 2019-05-31 sorted by RPT_REC_NUM

View and edit SQL

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

filed_date (date)

  • 2019-05-31 · 383
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
3930 THE HOSPITALS OF PROVIDENCE EAST CAMPUS 3280 JOE BATTLE BLVD EL PASO TX 79938 EL PASO (915) 856-7349 Acute Care Hospitals Proprietary TRUE 31.7904350 -106.2676440 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-5s8k_vnib_7trn 670047 648514 2019-05-31 2018-12-31 146 24       12 182               182
2100 BAPTIST HEALTH MEDICAL CENTER-HOT SPRINGS COUNTY 1001 SCHNEIDER DRIVE MALVERN AR 72104 HOT SPRING (501) 332-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.3589130 -92.7864180 0   59 5 5059 31680 Hot Springs-Malvern, AR Central Hot Spring County https://data.medicare.gov/resource/xubh-q36u/row-ua4e~kvad.yq4u 40076 648522 2019-05-31 2018-12-31 58 6         64               64
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
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
2736 SANTA YNEZ VALLEY COTTAGE HOSPITAL 2050 VIBORG RD SOLVANG CA 93463 SANTA BARBARA (805) 688-6431 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.6024650 -120.1266430 0   83 6 6083 42200   Central Santa Barbara County https://data.medicare.gov/resource/xubh-q36u/row-crjd-giis~8ixz 51331 648601 2019-05-31 2018-12-31 11           11               11
58 PLATTE VALLEY MEDICAL CENTER 1600 PRAIRIE CENTER PKWY BRIGHTON CO 80601 ADAMS (303) 498-1601 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9654410 -104.7709240 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-nf6e_r5cw.zmhy 60004 648669 2019-05-31 2018-12-31 65 8         89               89
3178 ARBUCKLE MEMORIAL HOSPITAL AUTHORITY 2011 WEST BROADWAY SULPHUR OK 73086 MURRAY (580) 622-2161 Critical Access Hospitals Government - Local TRUE 34.5063330 -96.9960050 0   99 40 40099         https://data.medicare.gov/resource/xubh-q36u/row-k94n_jt84~krmu 371328 648757 2019-05-31 2018-12-31 25           25               25
2816 TEXAS HEALTH PRESBYTERIAN HOSPITAL ALLEN 1105 CENTRAL EXPRESSWAY NORTH ALLEN TX 75013 COLLIN (972) 747-6197 Acute Care Hospitals Government - Federal TRUE 33.1154330 -96.6715040 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-v7tw~68xq-fbxm 450840 648765 2019-05-31 2018-12-31 30 8         44               44
4676 ARISE AUSTIN MEDICAL CENTER 3003 BEE CAVES ROAD AUSTIN TX 78746 TRAVIS (512) 347-9888 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.2716640 -97.7954690 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-npkw~aqm5~fref 450871 648766 2019-05-31 2018-12-31 21           21               21
663 HOSPITAL DR SUSONI INC 55 PALM ST ARECIBO PR 614 ARECIBO (787) 650-1031 Acute Care Hospitals Voluntary non-profit - Private TRUE 18.4726154 -66.7164601 1 APPROXIMATE 13 72 72013 11640 San Juan-Carolina, PR Central Arecibo Municipio https://data.medicare.gov/resource/xubh-q36u/row-sxrh-3iek~wydv 400117 648863 2019-05-31 2018-12-31 114 6         120               120
260 MEDICAL CENTER OF AURORA, THE 1501 S POTOMAC ST AURORA CO 80012 ARAPAHOE (303) 873-5511 Acute Care Hospitals Proprietary TRUE 39.6893460 -104.8311500 0   5 8 8005 19740 Denver-Aurora, CO Central Arapahoe County https://data.medicare.gov/resource/xubh-q36u/row-b8kj.p6xy-3gvh 60100 648892 2019-05-31 2018-12-31 250 45       14 309 20             329
2830 AVENTURA HOSPITAL AND MEDICAL CENTER 20900 BISCAYNE BLVD AVENTURA FL 33180 MIAMI-DADE (305) 682-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 25.9698590 -80.1442570 0   86 12 12086 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Miami-Dade County https://data.medicare.gov/resource/xubh-q36u/row-9tkf.7x6a-t5kq 100131 648895 2019-05-31 2018-12-31 274 77         351 56             407
3143 PALM BEACH GARDENS MEDICAL CENTER 3360 BURNS RD PALM BEACH GARDENS FL 33410 PALM BEACH (561) 622-1411 Acute Care Hospitals Proprietary TRUE 26.8306850 -80.0853880 0   99 12 12099 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Palm Beach County https://data.medicare.gov/resource/xubh-q36u/row-rhsb~ydnx_nk73 100176 648896 2019-05-31 2018-12-31 155 44         199               199
1326 SURGICAL SPECIALTY CENTER OF BATON ROUGE 8080 BLUEBONNET BLVD BATON ROUGE LA 70810 E. BATON ROUGE (225) 408-8080 Acute Care Hospitals Physician FALSE 30.3765650 -91.0993330 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-vta2_xzya~pwww 190251 648928 2019-05-31 2018-12-31 16           16               16
862 EAST COOPER MEDICAL CENTER 2000 HOSPITAL DR MOUNT PLEASANT SC 29464 CHARLESTON (843) 881-0100 Acute Care Hospitals Proprietary TRUE 32.8209970 -79.8496130 0   19 45 45019 16700   Central Charleston County https://data.medicare.gov/resource/xubh-q36u/row-a8up_sjrm.scy3 420089 648981 2019-05-31 2018-12-31 118 12         130               130
2820 TEXAS HEALTH PRESBYTERIAN HOSPITAL PLANO 6200 W PARKER RD PLANO TX 75093 COLLIN (972) 981-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.0451250 -96.8370730 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-sbv6-pg38-p2uu 450771 648990 2019-05-31 2018-12-31 250 26         321 48             369
3656 THE HEART HOSPITAL BAYLOR DENTON 2801 SOUTH MAYHILL ROAD DENTON TX 76208 DENTON (940) 220-0600 Acute Care Hospitals Physician TRUE 33.1769700 -97.0881990 0   121 48 48121 19100 Dallas-Fort Worth, TX-OK Outlying Denton County https://data.medicare.gov/resource/xubh-q36u/row-rbda~a4ni-iua9 450893 648994 2019-05-31 2018-12-31 22           22               22
4654 USMD HOSPITAL AT FORT WORTH LP 5900 ALTAMESA BLVD FORT WORTH TX 76132 TARRANT (817) 433-9100 Acute Care Hospitals Proprietary TRUE 32.6455920 -97.4181400 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-dprz_9mav_2zjv 670046 649011 2019-05-31 2018-12-31 8           8               8
3584 BAPTIST HEALTH MEDICAL CENTER NORTH LITTLE ROCK 3333 SPRINGHILL DRIVE NORTH LITTLE ROCK AR 72117 PULASKI (501) 202-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7840750 -92.2186330 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-kf3z.y9gr-2kzx 40036 649019 2019-05-31 2018-12-31 143 17 17       177   16   12       205
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
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
918 CAPITAL HEALTH MEDICAL CENTER - HOPEWELL ONE CAPITAL WAY PENNINGTON NJ 8534 MERCER (609) 303-4000 Acute Care Hospitals Voluntary non-profit - Private FALSE 40.2918008 -74.8041257 1 ROOFTOP 21 34 34021 45940 New York-Newark, NY-NJ-CT-PA Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-57bi.fjhf.mmkn 310044 649048 2019-05-31 2018-12-31 129 16         145               145
1312 SPARKS MEDICAL CENTER - VAN BUREN 211 CRAWFORD MEMORIAL DRIVE VAN BUREN AR 72956 CRAWFORD (479) 474-3401 Acute Care Hospitals Proprietary TRUE 35.4341750 -94.3394510 0   33 5 5033 22900   Central Crawford County https://data.medicare.gov/resource/xubh-q36u/row-w5xt~zwtc_2chf 40018 649071 2019-05-31 2018-12-31 31 8         39               39
3576 ARKANSAS SURGICAL HOSPITAL 5201 NORTH SHORE DRIVE NO LITTLE ROCK AR 72118 PULASKI (501) 748-8000 Acute Care Hospitals Proprietary TRUE 34.8014580 -92.3476870 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-y6hc~2xha_rqkj 40147 649072 2019-05-31 2018-12-31 49           49               49
3300 BARTOW REGIONAL MEDICAL CENTER 2200 OSPREY BLVD BARTOW FL 33831 POLK (863) 533-8111 Acute Care Hospitals Proprietary TRUE 27.9191460 -81.8462540 0   105 12 12105 29460   Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-nvqh.b66k~itmm 100121 649078 2019-05-31 2018-12-31 66 6         72               72
2829 KENDALL REGIONAL MEDICAL CENTER 11750 BIRD RD MIAMI FL 33175 MIAMI-DADE (305) 223-3000 Acute Care Hospitals Proprietary TRUE 25.7319314 -80.3857679 1 ROOFTOP 86 12 12086 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Miami-Dade County https://data.medicare.gov/resource/xubh-q36u/row-dsci.kfbc_pykp 100209 649079 2019-05-31 2018-12-31 322 52       13 394 23             417
2181 STEWARD SEBASTIAN RIVER MEDICAL CENTER 13695 US HWY 1 SEBASTIAN FL 32978 INDIAN RIVER (772) 589-3187 Acute Care Hospitals Proprietary TRUE 27.8443590 -80.4881280 0   61 12 12061 42680 Miami-Fort Lauderdale-Port St. Lucie, FL Central Indian River County https://data.medicare.gov/resource/xubh-q36u/row-xt6g-3hfq-6me4 100217 649080 2019-05-31 2018-12-31 105 16         121       33       154
2055 BRANDON REGIONAL HOSPITAL 119 OAKFIELD DR BRANDON FL 33511 HILLSBOROUGH (813) 681-5551 Acute Care Hospitals Proprietary TRUE 27.9340020 -82.2883030 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-utgt-8wzg.stgk 100243 649081 2019-05-31 2018-12-31 317 54       22 393 25             418
4119 INDIANA UNIVERSITY HEALTH TIPTON HOSPITAL INC 1000 S MAIN ST TIPTON IN 46072 TIPTON (765) 675-8500 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.2722160 -86.0411020 0   159 18 18159         https://data.medicare.gov/resource/xubh-q36u/row-ftnn_v67c-ywr5 151311 649095 2019-05-31 2018-12-31 25           25               25
1835 WOODLAWN HOSPITAL 1400 E 9TH ST ROCHESTER IN 46975 FULTON (574) 223-3141 Critical Access Hospitals Government - Local TRUE 41.0617280 -86.1969730 0   49 18 18049         https://data.medicare.gov/resource/xubh-q36u/row-2dgz-xb34_49d2 151313 649096 2019-05-31 2018-12-31 21 4         25               25
3675 PERRY COUNTY MEMORIAL HOSPITAL 8885 SR 237 TELL CITY IN 47586 PERRY (812) 547-7011 Critical Access Hospitals Voluntary non-profit - Other TRUE 37.9686500 -86.7295610 0   123 18 18123         https://data.medicare.gov/resource/xubh-q36u/row-pe53_e9y4-bfgv 151322 649098 2019-05-31 2018-12-31 21 4         25               25
1265 DECATUR COUNTY MEMORIAL HOSPITAL 720 N LINCOLN ST GREENSBURG IN 47240 DECATUR (812) 663-4331 Critical Access Hospitals Government - Local TRUE 39.3441160 -85.4794040 0   31 18 18031 24700 Indianapolis-Carmel-Muncie, IN Central Decatur County https://data.medicare.gov/resource/xubh-q36u/row-hqis.arxf_g2ap 151332 649101 2019-05-31 2018-12-31 25           25               25
4442 HEALTHBRIDGE CHILDRENS'S HOSPITAL OF HOUSTON 2929 WOODLAND PARK DRIVE HOUSTON TX 77082 HARRIS (281) 293-7774 Childrens Proprietary FALSE 29.7323170 -95.5805930 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-nwq8.dchf-ph6y 453309 649148 2019-05-31 2018-12-31 40           40               40
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
1498 WEST HILLS HOSPITAL & MEDICAL CENTER 7300 MEDICAL CENTER DR WEST HILLS CA 91307 LOS ANGELES (818) 676-4100 Acute Care Hospitals Proprietary FALSE 34.2029310 -118.6285980 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-iyjd_idr8.tn3h 50481 649165 2019-05-31 2018-12-31 192 25       11 228               228
1521 SAN DIMAS COMMUNITY HOSPITAL 1350 W COVINA BLVD SAN DIMAS CA 91773 LOS ANGELES (909) 599-6811 Acute Care Hospitals Proprietary TRUE 34.0994230 -117.8350060 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-8cu2-sqr5-vidq 50588 649167 2019-05-31 2018-12-31 87 8         95               95
3028 HAXTUN HOSPITAL DISTRICT 235 W FLETCHER ST HAXTUN CO 80731 PHILLIPS (970) 774-6123 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.6413860 -102.6308660 0   95 8 8095         https://data.medicare.gov/resource/xubh-q36u/row-amj6-3hms~eqap 61304 649172 2019-05-31 2018-12-31 25           25               25
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
2696 JOHNSON MEMORIAL HOSPITAL 1125 W JEFFERSON ST FRANKLIN IN 46131 JOHNSON (317) 736-3300 Acute Care Hospitals Government - Local TRUE 39.4805980 -86.0766630 0   81 18 18081 26900 Indianapolis-Carmel-Muncie, IN Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-gz4n-xn3z~kiqn 150001 649201 2019-05-31 2018-12-31 77 6         83   11           94
2246 HENDRICKS REGIONAL HEALTH 1000 E MAIN ST DANVILLE IN 46122 HENDRICKS (317) 745-4451 Acute Care Hospitals Government - Local TRUE 39.7607100 -86.5009950 0   63 18 18063 26900 Indianapolis-Carmel-Muncie, IN Central Hendricks County https://data.medicare.gov/resource/xubh-q36u/row-7pz3-j79y~ybxb 150005 649202 2019-05-31 2018-12-31 121 12         133               133
2944 LA PORTE HOSPITAL 1007 LINCOLNWAY LA PORTE IN 46350 LA PORTE (219) 326-1234 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.6098380 -86.7238550 0   91 18 18091 33140 Chicago-Naperville, IL-IN-WI Central LaPorte County https://data.medicare.gov/resource/xubh-q36u/row-3wgw-wdyr.5afh 150006 649203 2019-05-31 2018-12-31 109 20         129               129
2136 HANCOCK REGIONAL HOSPITAL 801 N STATE ST GREENFIELD IN 46140 HANCOCK (317) 462-5544 Acute Care Hospitals Government - Local TRUE 39.7949520 -85.7696040 0   59 18 18059 26900 Indianapolis-Carmel-Muncie, IN Central Hancock County https://data.medicare.gov/resource/xubh-q36u/row-9wnz_ckw6~khmk 150037 649205 2019-05-31 2018-12-31 37 24         61 10         7   78
2745 GOOD SAMARITAN HOSPITAL 520 S 7TH ST VINCENNES IN 47591 KNOX (812) 882-5220 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.6729200 -87.5342130 0   83 18 18083 47180   Central Knox County https://data.medicare.gov/resource/xubh-q36u/row-f56v.t8ru-iadr 150042 649206 2019-05-31 2018-12-31 69 30         99 20 25           144
3098 INDIANA UNIVERSITY HEALTH 1701 N SENATE BLVD INDIANAPOLIS IN 46202 MARION (317) 962-5900 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7905710 -86.1652590 0   97 18 18097 26900 Indianapolis-Carmel-Muncie, IN Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-eimw.p9j2.8uyj 150056 649207 2019-05-31 2018-12-31 914 66 64 10     1226 26 10           1262
503 WITHAM HEALTH SERVICES 2605 N LEBANON ST LEBANON IN 46052 BOONE (765) 485-8000 Acute Care Hospitals Government - Local TRUE 40.0769090 -86.4752090 0   11 18 18011 26900 Indianapolis-Carmel-Muncie, IN Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-gfq5-5jsq-rtmb 150104 649208 2019-05-31 2018-12-31 60 8         68 10     18       96
273 COLUMBUS REGIONAL HOSPITAL 2400 E 17TH ST COLUMBUS IN 47201 BARTHOLOMEW (812) 379-4441 Acute Care Hospitals Government - Local TRUE 39.2158720 -85.8968540 0   5 18 18005 18020 Indianapolis-Carmel-Muncie, IN Central Bartholomew County https://data.medicare.gov/resource/xubh-q36u/row-u4i5.cqhh_8kd8 150112 649209 2019-05-31 2018-12-31 194 17         211   18           229
2248 IU HEALTH WEST HOSPITAL 1111 N RONALD REAGAN PKWY AVON IN 46123 HENDRICKS (317) 217-3000 Acute Care Hospitals Proprietary TRUE 39.7825680 -86.3437310 0   63 18 18063 26900 Indianapolis-Carmel-Muncie, IN Central Hendricks County https://data.medicare.gov/resource/xubh-q36u/row-q2c6-s486-rbqx 150158 649210 2019-05-31 2018-12-31 100 16 11       127               127
2062 INDIANA UNIVERSITY HEALTH NORTH HOSPITAL 11700 N MERIDIAN ST CARMEL IN 46032 HAMILTON (317) 688-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9592750 -86.1623560 0   57 18 18057 26900 Indianapolis-Carmel-Muncie, IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-z9gu_7wpc_cdy7 150161 649211 2019-05-31 2018-12-31 120           149               149
2900 PINNACLE HOSPITAL 9301 CONNECTICUT DR CROWN POINT IN 46307 LAKE (219) 756-2100 Acute Care Hospitals Physician FALSE 41.4491180 -87.3300690 0   89 18 18089 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-eygb~yded_6pv4 150166 649212 2019-05-31 2018-12-31 16 2         18               18
3427 UNITYPOINT HEALTH - KEOKUK 1600 MORGAN STREET KEOKUK IA 52632 LEE (319) 524-7150 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4069520 -91.3881160 0   111 19 19111 22800   Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-72az-u8ry-v8xn 160008 649217 2019-05-31 2018-12-31 42   7       49               49
2953 OLATHE MEDICAL CENTER 20333 WEST 151ST STREET OLATHE KS 66061 JOHNSON (913) 791-4200 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8545240 -94.8236730 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-yvea.ybd3_rygq 170049 649223 2019-05-31 2018-12-31 223 20 11       254           11   265
3708 COFFEYVILLE REGIONAL MEDICAL CENTER, INC 1400 W 4TH ST COFFEYVILLE KS 67337 MONTGOMERY (620) 251-1200 Acute Care Hospitals Government - Local TRUE 37.0403990 -95.6383460 0   125 20 20125 17700   Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-jtf8.u9rb_44p3 170145 649224 2019-05-31 2018-12-31 40 7         47       20       67
2947 KANSAS CITY ORTHOPAEDIC INSTITUTE 3651 COLLEGE BLVD LEAWOOD KS 66211 JOHNSON (913) 319-7633 Acute Care Hospitals Physician FALSE 38.9275490 -94.6282350 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-s6dg~iufq_ybuc 170188 649225 2019-05-31 2018-12-31 12           12               12
2572 HAMILTON COUNTY HOSPITAL 700 NORTH HUSER SYRACUSE KS 67878 HAMILTON (620) 384-7461 Critical Access Hospitals Government - Local TRUE 37.9846055 -101.7426286 1 ROOFTOP 75 20 20075         https://data.medicare.gov/resource/xubh-q36u/row-aubk-tw4u-vx2j 171322 649228 2019-05-31 2018-12-31 25           25               25
4404 HANOVER HOSPITAL 205 S HANOVER STREET HANOVER KS 66945 WASHINGTON (785) 337-2214 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.8910470 -96.8747710 0   201 20 20201         https://data.medicare.gov/resource/xubh-q36u/row-8nv9.9895.yp5i 171365 649230 2019-05-31 2018-12-31 25           25               25
3828 NEOSHO MEMORIAL REGIONAL MEDICAL CENTER 629 SOUTH PLUMMER CHANUTE KS 66720 NEOSHO (620) 431-4000 Critical Access Hospitals Government - Local TRUE 37.6751800 -95.4708960 0   133 20 20133         https://data.medicare.gov/resource/xubh-q36u/row-bqsi.4ak9-dfb2 171380 649232 2019-05-31 2018-12-31 17 5         22               22
1781 JENNIE STUART MEDICAL CENTER 320 WEST 18TH STREET HOPKINSVILLE KY 42240 CHRISTIAN (270) 887-0100 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.8604430 -87.4956680 0   47 21 21047 17300   Outlying Christian County https://data.medicare.gov/resource/xubh-q36u/row-ej5h.uz4s.tihd 180051 649237 2019-05-31 2018-12-31 111 18         133               133
4397 LAKE CUMBERLAND REGIONAL HOSPITAL 305 LANGDON STREET SOMERSET KY 42503 PULASKI (606) 679-7441 Acute Care Hospitals Proprietary TRUE 37.0865760 -84.6179560 0   199 21 21199 43700   Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-nvm6_dpu6-uvmh 180132 649238 2019-05-31 2018-12-31 192 38         230 7 18   12       267
2645 RAPIDES REGIONAL MEDICAL CENTER 211 4TH STREET ALEXANDRIA LA 71301 RAPIDES (318) 769-3000 Acute Care Hospitals Proprietary TRUE 31.3150210 -92.4504810 0   79 22 22079 10780   Central Rapides Parish https://data.medicare.gov/resource/xubh-q36u/row-73ux~awri.sd3h 190026 649243 2019-05-31 2018-12-31 322         29 357               357
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
1697 DICKINSON COUNTY MEMORIAL HOSPITAL 1721 S STEPHENSON AVE IRON MOUNTAIN MI 49801 DICKINSON (906) 774-1313 Acute Care Hospitals Government - Local TRUE 45.8085720 -88.0442680 0   43 26 26043 27020   Central Dickinson County https://data.medicare.gov/resource/xubh-q36u/row-ss3t.epsm-biyy 230055 649262 2019-05-31 2018-12-31 33 6         39               39
4160 HARPER UNIVERSITY HOSPITAL 3990 JOHN R STREET DETROIT MI 48201 WAYNE (313) 745-6211 Acute Care Hospitals Proprietary TRUE 42.3513750 -83.0578920 0   163 26 26163 19820 Detroit-Warren-Ann Arbor, MI Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-tr5m.wdwu~nzdr 230104 649263 2019-05-31 2018-12-31 302 34       32 368               368
3753 MAGEE GENERAL HOSPITAL 300 3RD AVE SE MAGEE MS 39111 SIMPSON (601) 849-5070 Acute Care Hospitals Government - Local TRUE 31.8705850 -89.7283890 0   127 28 28127 27140 Jackson-Vicksburg-Brookhaven, MS Outlying Simpson County https://data.medicare.gov/resource/xubh-q36u/row-ncai-7t3m_ee8c 250124 649278 2019-05-31 2018-12-31 44           44               44
840 BOONE HOSPITAL CENTER 1600 E BROADWAY COLUMBIA MO 65201 BOONE (573) 815-8000 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9506690 -92.3170390 0   19 29 29019 17860 Columbia-Moberly-Mexico, MO Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-f55k.gvub.hupa 260068 649281 2019-05-31 2018-12-31 282 32       21 335   15           350
4277 MEMORIAL COMMUNITY HOSPITAL MCH & HEALTH SYSTEM 810 NORTH 22ND ST BLAIR NE 68008 WASHINGTON (402) 426-1502 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.5511520 -96.1455190 0   177 31 31177 36540 Omaha-Council Bluffs-Fremont, NE-IA Outlying Washington County https://data.medicare.gov/resource/xubh-q36u/row-76h9-y4cn_piec 281359 649292 2019-05-31 2018-12-31 21           21               21
2016 CHILDREN'S HOSPITAL & MEDICAL CENTER 8200 DODGE ST OMAHA NE 68114 DOUGLAS (402) 955-5400 Childrens Voluntary non-profit - Private TRUE 41.2596810 -96.0408680 0   55 31 31055 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-kme5.spnq~gd4h 283301 649293 2019-05-31 2018-12-31 81 59         140               140
4103 UNION HOSPITAL 659 BOULEVARD DOVER OH 44622 TUSCARAWAS (330) 343-3311 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.5138790 -81.4565830 0   157 39 39157 35420 Cleveland-Akron-Canton, OH Central Tuscarawas County https://data.medicare.gov/resource/xubh-q36u/row-k3uw~uhgd_nmkh 360010 649304 2019-05-31 2018-12-31 90 10 28       128   10           138
525 GRAND LAKE HEALTH SYSTEM 200 SAINT CLAIR STREET SAINT MARYS OH 45885 AUGLAIZE (419) 394-3335 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5451390 -84.3698360 0   11 39 39011 47540 Lima-Van Wert-Celina, OH Central Auglaize County https://data.medicare.gov/resource/xubh-q36u/row-98z6_ymvq~u2mi 360032 649307 2019-05-31 2018-12-31 30 6         36 12 4   15       67
3619 GENESIS HOSPITAL 2951 MAPLE AVENUE ZANESVILLE OH 43701 MUSKINGUM (740) 454-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9757310 -82.0142450 0   119 39 39119 49780 Columbus-Marion-Zanesville, OH Central Muskingum County https://data.medicare.gov/resource/xubh-q36u/row-p28m~2s52~jwnm 360039 649309 2019-05-31 2018-12-31 234 24 24       282           7   289
3482 MIAMI VALLEY HOSPITAL ONE WYOMING STREET DAYTON OH 45409 MONTGOMERY (937) 208-3023 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7454533 -84.1856087 1 ROOFTOP 113 39 39113 19380 Dayton-Springfield-Sidney, OH Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-as44_ad35~hctr 360051 649310 2019-05-31 2018-12-31 574 103   10     753 32 40           825
2620 FISHER-TITUS HOSPITAL 272 BENEDICT AVENUE NORWALK OH 44857 HURON (419) 668-8101 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2260340 -82.6020080 0   77 39 39077 35940 Cleveland-Akron-Canton, OH Central Huron County https://data.medicare.gov/resource/xubh-q36u/row-k8y3~5cmj-9fh2 360065 649312 2019-05-31 2018-12-31 68 10         78       69       147
4147 VAN WERT COUNTY HOSPITAL 1250 S WASHINGTON STREET VAN WERT OH 45891 VAN WERT (419) 238-8627 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8503140 -84.5813670 0   161 39 39161 46780 Lima-Van Wert-Celina, OH Central Van Wert County https://data.medicare.gov/resource/xubh-q36u/row-8msa.r7ce.sywe 360071 649313 2019-05-31 2018-12-31 56 5         61               61
1751 FAIRFIELD MEDICAL CENTER 401 NORTH EWING STREET LANCASTER OH 43130 FAIRFIELD (740) 687-8009 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.7171970 -82.5766530 0   45 39 39045 18140 Columbus-Marion-Zanesville, OH Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-nznm_8tdx~h2f2 360072 649314 2019-05-31 2018-12-31 193 20         213               213
4193 ATRIUM MEDICAL CENTER ONE MEDICAL CENTER DRIVE FRANKLIN OH 45005 WARREN (513) 420-5102 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.4985347 -84.3148178 1 ROOFTOP 165 39 39165 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Warren County https://data.medicare.gov/resource/xubh-q36u/row-hkrb_6v8h-iir7 360076 649316 2019-05-31 2018-12-31 160 16 41       217 30 20           267
4129 MEMORIAL HOSPITAL 500 LONDON AVENUE MARYSVILLE OH 43040 UNION (937) 578-2289 Acute Care Hospitals Government - Local TRUE 40.2312910 -83.3688410 0   159 39 39159 18140 Columbus-Marion-Zanesville, OH Outlying Union County https://data.medicare.gov/resource/xubh-q36u/row-ic8f_vxye-c7cu 360092 649320 2019-05-31 2018-12-31 53 7         60               60
1296 COSHOCTON REGIONAL MEDICAL CENTER 1460 ORANGE STREET COSHOCTON OH 43812 COSHOCTON (740) 623-4144 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.2704420 -81.8475770 0   31 39 39031 18740   Central Coshocton County https://data.medicare.gov/resource/xubh-q36u/row-kfzq~stzn~vtav 360109 649322 2019-05-31 2018-12-31 49 7         56               56
3385 UPPER VALLEY MEDICAL CENTER 3130 NORTH COUNTY ROAD 25A TROY OH 45373 MIAMI (937) 440-7853 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0877890 -84.2235370 0   109 39 39109 19380 Dayton-Springfield-Sidney, OH Central Miami County https://data.medicare.gov/resource/xubh-q36u/row-uajg-2jap_5cbb 360174 649323 2019-05-31 2018-12-31 109 10         119 21 11           151
3286 LODI COMMUNITY HOSPITAL 225 ELYRIA STREET LODI OH 44254 MEDINA (330) 948-1222 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.0360870 -82.0135160 0   103 39 39103 17460 Cleveland-Akron-Canton, OH Central Medina County https://data.medicare.gov/resource/xubh-q36u/row-48yc_8wc9.28w8 361303 649324 2019-05-31 2018-12-31 20           20               20
2479 GREENFIELD AREA MEDICAL CENTER 550 MIRABEAU STREET GREENFIELD OH 45123 HIGHLAND (937) 981-9400 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3493150 -83.3880080 0   71 39 39071         https://data.medicare.gov/resource/xubh-q36u/row-nrr2~cens-ua4p 361304 649325 2019-05-31 2018-12-31 25           25               25
2369 HARRISON COMMUNITY HOSPITAL 951 EAST MARKET STREET CADIZ OH 43907 HARRISON (740) 942-4631 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.2572950 -80.9786400 0   67 39 39067         https://data.medicare.gov/resource/xubh-q36u/row-mhu5~ezn4.9tdn 361311 649326 2019-05-31 2018-12-31 25           25               25
3691 MAGRUDER HOSPITAL 615 FULTON ST PORT CLINTON OH 43452 OTTAWA (419) 734-3131 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.5055710 -82.9337880 0   123 39 39123 38840 Toledo-Port Clinton, OH Central Ottawa County https://data.medicare.gov/resource/xubh-q36u/row-ikr8~ybw5-9tcj 361314 649327 2019-05-31 2018-12-31 21 4         25               25
4226 AULTMAN ORRVILLE HOSPITAL 832 SOUTH MAIN STREET ORRVILLE OH 44667 WAYNE (330) 682-3010 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.8320810 -81.7645780 0   169 39 39169 49300   Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-9tpy-nftf.5byd 361323 649328 2019-05-31 2018-12-31 25           25               25
1604 DEFIANCE REGIONAL MEDICAL CENTER 1200 RALSTON AVENUE DEFIANCE OH 43512 DEFIANCE (419) 783-6955 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.2993920 -84.3734690 0   39 39 39039 19580   Central Defiance County https://data.medicare.gov/resource/xubh-q36u/row-29rw.zsfv.ixin 361328 649330 2019-05-31 2018-12-31 17 8         25 10             35
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
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
1057 HIMA SAN PABLO-CAGUAS AVE LUIS MUNOZ MARIN CAGUAS PR 725 CAGUAS (787) 653-3434 Acute Care Hospitals Proprietary TRUE 18.2270107 -66.0273180 1 GEOMETRIC_CENTER 25 72 72025 41980 San Juan-Carolina, PR Central Caguas Municipio https://data.medicare.gov/resource/xubh-q36u/row-7siz.yb89_3gij 400120 649347 2019-05-31 2018-12-31 394 46         440               440
4563 GRACE MEDICAL CENTER 2412 50TH ST LUBBOCK TX 79412 LUBBOCK (806) 788-4100 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.5487860 -101.8690980 0   303 48 48303 31180 Lubbock-Levelland, TX Central Lubbock County https://data.medicare.gov/resource/xubh-q36u/row-yk9u_mrt4.dz5d 450162 649351 2019-05-31 2018-12-31 85 7         92               92
3135 EMANUEL MEDICAL CENTER 825 DELBON AVE TURLOCK CA 95382 STANISLAUS (209) 667-4200 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.5104870 -120.8374910 0   99 6 6099 33700 Modesto-Merced, CA Central Stanislaus County https://data.medicare.gov/resource/xubh-q36u/row-rimp~9bpy.6vfc 50179 649396 2019-05-31 2018-12-31 191 12       6 209               209
1463 GLENDALE ADVENTIST MEDICAL CENTER 1509 E WILSON TERRACE GLENDALE CA 91206 LOS ANGELES (818) 409-8202 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1491610 -118.2303540 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-9sbg-4wtr.teeu 50239 649399 2019-05-31 2018-12-31 277   20   12 14 323 60 28   40       451
61 NORTH SUBURBAN MEDICAL CENTER 9191 GRANT ST THORNTON CO 80229 ADAMS (303) 451-7800 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8643800 -104.9847830 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-tvxk_43rk.h2qn 60065 649402 2019-05-31 2018-12-31 111 16         127               127
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
3197 MORTON PLANT NORTH BAY HOSPITAL 6600 MADISON ST NEW PORT RICHEY FL 34652 PASCO (727) 842-8468 Acute Care Hospitals Voluntary non-profit - Private FALSE 28.2539330 -82.7154780 0   101 12 12101 45300   Central Pasco County https://data.medicare.gov/resource/xubh-q36u/row-zigd-ajc4_xtbp 100063 649411 2019-05-31 2018-12-31 165 22         187   30           217
416 STEWARD ROCKLEDGE HOSPITAL 110 LONGWOOD AVE ROCKLEDGE FL 32955 BREVARD (321) 637-2603 Acute Care Hospitals Proprietary TRUE 28.3345400 -80.7231330 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-tbme~t6bb.jqha 100092 649413 2019-05-31 2018-12-31 243 31         274 24             298
486 NORTHWEST MEDICAL CENTER 2801 N STATE RD 7 MARGATE FL 33063 BROWARD (954) 974-0400 Acute Care Hospitals Proprietary TRUE 26.2629030 -80.2019050 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-e825~y5d2-68se 100189 649421 2019-05-31 2018-12-31 193 24       11 228               228
3255 MEASE COUNTRYSIDE HOSPITAL 3231 MCMULLEN BOOTH RD SAFETY HARBOR FL 34695 PINELLAS (727) 734-6950 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.0403260 -82.7089710 0   103 12 12103 45300   Central Pinellas County https://data.medicare.gov/resource/xubh-q36u/row-6t3v_74au.jwgt 100265 649423 2019-05-31 2018-12-31 275 26       10 311               311
417 STEWARD MELBOURNE HOSPITAL 250 NORTH WICKHAM ROAD MELBOURNE FL 32935 BREVARD (321) 752-1200 Acute Care Hospitals Proprietary TRUE 28.1098040 -80.6726100 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-fnh8.cjxx_ncpd 100291 649425 2019-05-31 2018-12-31 101 12         113               113
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
1845 ST DOMINIC-JACKSON MEMORIAL HOSPITAL 969 LAKELAND DR JACKSON MS 39216 HINDS (601) 200-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 32.3336910 -90.1651030 0   49 28 28049 27140 Jackson-Vicksburg-Brookhaven, MS Central Hinds County https://data.medicare.gov/resource/xubh-q36u/row-4dka-j7fc_8qjv 250048 649456 2019-05-31 2018-12-31 469 56         545 26             571
372 COOPER UNIVERSITY HOSPITAL 1 COOPER PLAZA CAMDEN NJ 8103 CAMDEN (856) 342-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9408020 -75.1157570 0   7 34 34007 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Camden County https://data.medicare.gov/resource/xubh-q36u/row-nkr7.hdmt_ja2d 310014 649466 2019-05-31 2018-12-31 483 30 12       574               574
2970 SUBURBAN COMMUNITY HOSPITAL 2701 DEKALB PIKE NORRISTOWN PA 19401 MONTGOMERY (215) 278-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.1389610 -75.3152890 0   91 42 42091 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-bfff_icmq.tyhy 390116 649487 2019-05-31 2018-12-31 99 12         111 15             126

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