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

3,280 rows where hospital_type = "Acute Care Hospitals" sorted by fy_end_date

View and edit SQL

Suggested facets: hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, fy_end_date, burn_beds, subprovider_oth_beds, nursing_fac_beds, filed_date (date), fy_end_date (date)

hospital_type

  • Acute Care Hospitals · 3,280
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
476 LBJ TROPICAL MEDICAL CENTER FAGAALU VILLAGE PAGO PAGO AS 96799 EASTERN DISTRICT (684) 633-4590 Acute Care Hospitals Government - Hospital District or Authority TRUE -14.2900610 -170.6847054 1 APPROXIMATE 10 60 60010         https://data.medicare.gov/resource/xubh-q36u/row-6iv4.yudm-sdek                                      
499 GROVE CREEK MEDICAL CENTER 350 NORTH MERIDIAN STREET BLACKFOOT ID 83221 BINGHAM (208) 782-2900 Acute Care Hospitals Voluntary non-profit - Private FALSE 43.1963010 -112.3561240 0   11 16 16011 13940 Idaho Falls-Rexburg-Blackfoot, ID Central Bingham County https://data.medicare.gov/resource/xubh-q36u/row-ej2j_mw5y_vys8                                      
537 LAYTON HOSPITAL 201 WEST LAYTON PARKWAY LAYTON UT 84041 DAVIS (801) 543-6703 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0544470 -111.9676100 0   11 49 49011 36260 Salt Lake City-Provo-Orem, UT Central Davis County https://data.medicare.gov/resource/xubh-q36u/row-vhte.3djc_gfvr                                      
562 DIGNITY HEALTH ARIZONA GENERAL HOSPITAL 9130 EAST ELLIOT ROAD MESA AZ 85212 MARICOPA (480) 410-4500 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.3504785 -111.6361588 1 ROOFTOP 13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-viy6-jrjj-hix3                                      
578 WESTERN REGIONAL MEDICAL CENTER 14200 WEST CELEBRATE LIFE WAY GOODYEAR AZ 85338 MARICOPA (623) 207-3518 Acute Care Hospitals Proprietary FALSE 33.4528040 -112.3625710 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-rhgj.utwd-n4qy                                      
1037 PALMERTON HOSPITAL 135 LAFAYETTE AVENUE PALMERTON PA 18071 CARBON (610) 826-3141 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.8023150 -75.6148510 0   25 42 42025 10900 New York-Newark, NY-NJ-CT-PA Central Carbon County https://data.medicare.gov/resource/xubh-q36u/row-b6sa~yemt.rcmf                                      
1181 TEXAS CENTER FOR INFECTIOUS DISEASE 2303 SE MILITARY DR P O BOX 23340 SAN ANTONIO TX 78223 BEXAR (210) 534-8857 Acute Care Hospitals Government - State FALSE 29.3519300 -98.4583770 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-suha~2mc2-p7yc                                      
1378 BAPTIST MEMORIAL HOSPITAL-CRITTENDEN, INC 2100 NORTH SEVENTH STREET WEST MEMPHIS AR 72301 CRITTENDEN (870) 394-7800 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.1679922 -90.1778757 1 ROOFTOP 35 5 5035 32820 Memphis-Forrest City, TN-MS-AR Central Crittenden County https://data.medicare.gov/resource/xubh-q36u/row-v5ug.qa38-7wwe                                      
1449 MARSHFIELD MEDICAL CENTER - EAU CLAIRE 2310 CRAIG RD EAU CLAIRE WI 54701 EAU CLAIRE (833) 883-3262 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.7933180 -91.5190830 0   35 55 55035 20740 Eau Claire-Menomonie, WI Central Eau Claire County https://data.medicare.gov/resource/xubh-q36u/row-3peb-cz4e.82m5                                      
2955 PINNACLE REGIONAL HOSPITAL, INC 12850 METCALF AVENUE OVERLAND PARK KS 66213 JOHNSON (913) 220-2866 Acute Care Hospitals Proprietary FALSE 38.8963010 -94.6678760 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-rddh~ajbk-yi9q                                      
3395 INTEGRIS COMMUNITY HOSPITAL - COUNCIL CROSSING 9417 N COUNCIL ROAD OKLAHOMA CITY OK 73162 OKLAHOMA (405) 550-3280 Acute Care Hospitals Proprietary TRUE 35.5653520 -97.6562570 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-g5rq~p6tq-qier                                      
4439 HUMBLE SURGICAL HOSPITAL, LLC 1475 FM 1960 BYPASS ROAD EAST HUMBLE TX 77338 HARRIS (281) 964-2100 Acute Care Hospitals Physician TRUE 30.0041830 -95.2529240 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-u2zv_k8rw_6una                                      
4586 EMIL J FREIREICH CANCER CENTER 9201 PINECROFT SHENANDOAH TX 77380 MONTGOMERY (855) 353-2201 Acute Care Hospitals Proprietary TRUE 30.1748330 -95.4562990 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-dgs8~kmnk_pu43                                      
4673 BAYLOR SCOTT & WHITE MEDICAL CENTER PFLUGERVILLE 2600 EAST PFLUGERVILLE PARKWAY PFLUGERVILLE TX 78660 TRAVIS (512) 654-6100 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4467390 -97.5844660 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-6zai.ayhx-f9rk                                      
4683 TEXAS GENERAL HOSPITAL- VZRMC LP 707 N WALDRIP ST GRAND SALINE TX 75140 VAN ZANDT (903) 962-5200 Acute Care Hospitals Proprietary TRUE 32.6791930 -95.7217370 0   467 48 48467         https://data.medicare.gov/resource/xubh-q36u/row-6c8j-ja3g-2qcb                                      
191 HARMON HOSPITAL 2170 EAST HARMON AVENUE LAS VEGAS NV 89119 CLARK (702) 794-0100 Acute Care Hospitals Voluntary non-profit - Private FALSE 36.1073690 -115.1219920 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-qtzp-aczd_sysf 290042 629833 2018-05-31 2017-12-31                              
1055 SUMMIT MEDICAL CENTER 6350 E 2ND STREET CASPER WY 82609 NATRONA (307) 232-6600 Acute Care Hospitals Physician FALSE 42.8408460 -106.2317960 0   25 56 56025 16220   Central Natrona County https://data.medicare.gov/resource/xubh-q36u/row-8pwp.t3su_b96w 530034 645740 2019-03-04 2017-12-31                              
1578 ASPEN MOUNTAIN MEDICAL CENTER 4401 COLLEGE DRIVE ROCK SPRINGS WY 82901 SWEETWATER (307) 448-2758 Acute Care Hospitals Proprietary FALSE 41.6031870 -109.2479170 0   37 56 56037 40540   Central Sweetwater County https://data.medicare.gov/resource/xubh-q36u/row-x9bs.ynhd_upz4 530035 651148 2018-05-29 2017-12-31                              
2296 DOCTORS HOSPITAL OF RIVERSIDE 3865 JACKSON STREET RIVERSIDE CA 92503 RIVERSIDE (951) 688-2211 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.9256970 -117.4400520 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-sdgf-p94g_256s 50102 654640 2018-05-31 2017-12-31 166 13       12 191               191
4620 CARE REGIONAL MEDICAL CENTER 1711 W WHEELER AVENUE ARANSAS PASS TX 78336 SAN PATRICIO (361) 758-8585 Acute Care Hospitals Proprietary TRUE 27.9159210 -97.1618290 0   409 48 48409 18580 Corpus Christi-Kingsville-Alice, TX Central San Patricio County https://data.medicare.gov/resource/xubh-q36u/row-g7k6_vy64~c2bf 450605 655598 2018-07-30 2017-12-31 63           63 12             75
3882 NORTH OAK REGIONAL MEDICAL CENTER 401 GETWELL DR SENATOBIA MS 38668 TATE (662) 562-3100 Acute Care Hospitals Proprietary TRUE 34.6246780 -89.9567440 0   137 28 28137 32820 Memphis-Forrest City, TN-MS-AR Outlying Tate County https://data.medicare.gov/resource/xubh-q36u/row-pcjm~cndq_ygq8 250126 655683 2018-10-10 2018-03-31 29           29 12             41
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
51 SAN LEANDRO HOSPITAL 13855 E 14TH STREET SAN LEANDRO CA 94578 ALAMEDA (510) 357-6500 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7146320 -122.1419730 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-whtt-wfgb.a9rb 50773 657702 2018-12-03 2018-06-30 39 6         45               45
80 HILO MEDICAL CENTER 1190 WAIANUENUE AVENUE HILO HI 96720 HAWAII (808) 932-3000 Acute Care Hospitals Government - State TRUE 19.7174670 -155.1135130 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-szpt~f525_222j 120005 657722 2018-12-03 2018-06-30 146 11         157       119       276
154 KUAKINI MEDICAL CENTER 347 NORTH KUAKINI STREET HONOLULU HI 96817 HONOLULU (808) 536-2236 Acute Care Hospitals Voluntary non-profit - Private TRUE 21.3222110 -157.8562110 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-haju_ivwx-iwr6 120007 656434 2018-12-26 2018-06-30 146 12 12       170       40 147     357
195 SAINT ROSE DOMINICAN HOSPITALS - SIENA CAMPUS 3001 ST ROSE PARKWAY HENDERSON NV 89052 CLARK (702) 616-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0045271 -115.1150581 1 ROOFTOP 3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-8dra~5wtd-jnuh 290045 662405 2018-11-30 2018-06-30 244 50         326               326
196 SAINT ROSE DOMINICAN HOSPITALS - ROSE DE LIMA 102 E LAKE MEAD DR HENDERSON NV 89015 CLARK (702) 616-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.0388290 -114.9831920 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-r9pq.jhhc.4qfi 290012 657913 2018-11-30 2018-06-30 72 10         82   28           110
333 CAMPBELL COUNTY MEMORIAL HOSPITAL 501 SOUTH BURMA AVENUE GILLETTE WY 82716 CAMPBELL (307) 688-1551 Acute Care Hospitals Government - Hospital District or Authority TRUE 44.2898460 -105.5195570 0   5 56 56005 23940   Central Campbell County https://data.medicare.gov/resource/xubh-q36u/row-ppek.rg99~yqr6 530002 658628 2018-11-29 2018-06-30 52 14         66 6     160       232
493 HOLY CROSS HOSPITAL 4725 N FEDERAL HWY FORT LAUDERDALE FL 33308 BROWARD (954) 771-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 26.1853780 -80.1176590 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-q8e2.rdpd.9cpi 100073 654519 2019-09-09 2018-06-30 256 44       9 309   48           357
564 VALLEYWISE HEALTH MEDICAL CENTER 2601 EAST ROOSEVELT STREET PHOENIX AZ 85008 MARICOPA (602) 344-5011 Acute Care Hospitals Government - Local TRUE 33.4585250 -112.0264300 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-c5qr_etcr-7dch 30022 661279 2018-12-03 2018-06-30 211 20   19 13   323 241             564
568 ST. JOSEPH'S HOSPITAL AND MEDICAL CENTER 350 WEST THOMAS ROAD PHOENIX AZ 85013 MARICOPA (602) 406-5001 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.4802940 -112.0792080 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-kyrc_3hbc_et9k 30024 658638 2019-10-10 2018-06-30 268   24   32   460   52           512
606 PINEVILLE COMMUNITY HEALTH CENTER, INC 850 RIVERVIEW AVENUE PINEVILLE KY 40977 BELL (606) 337-3051 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.7630770 -83.7085740 0   13 21 21013 33180   Central Bell County https://data.medicare.gov/resource/xubh-q36u/row-fc9h_t8d9~pcu3 180021 651620 2019-07-15 2018-06-30 41           41 12             53
655 UINTAH BASIN MEDICAL CENTER 250 WEST 300 NORTH ROOSEVELT UT 84066 DUCHESNE (435) 722-4691 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.3027550 -109.9970860 0   13 49 49013         https://data.medicare.gov/resource/xubh-q36u/row-qmgd.dczn~ghmv 460019 658598 2019-01-10 2018-06-30 31 4         35               35
810 COALINGA REGIONAL MEDICAL CENTER 1191 PHELPS AVENUE COALINGA CA 93210 FRESNO (559) 935-6400 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.1515170 -120.3420890 0   19 6 6019 23420 Fresno-Madera, CA Central Fresno County https://data.medicare.gov/resource/xubh-q36u/row-6rbr~b9je.7rdb 50397 656406 2018-12-03 2018-06-30 22           22       114       136
856 BUTLER MEMORIAL HOSPITAL ONE HOSPITAL WAY BUTLER PA 16001 BUTLER (724) 283-6666 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8672740 -79.8805124 1 ROOFTOP 19 42 42019 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Butler County https://data.medicare.gov/resource/xubh-q36u/row-3qh5.b2vu-gny9 390168 657465 2018-12-03 2018-06-30 232 35         267 21     25       313
858 MUSC MEDICAL CENTER 169 ASHLEY AVE CHARLESTON SC 29425 CHARLESTON (843) 792-2300 Acute Care Hospitals Government - State TRUE 32.7854000 -79.9465590 0   19 45 45019 16700   Central Charleston County https://data.medicare.gov/resource/xubh-q36u/row-yb9w~4mxa-yhfk 420004 662071 2019-08-30 2018-06-30 502 114       66 682 98             780
1357 UNIVERSITY OF WASHINGTON MEDICAL CTR 1959 NE PACIFIC ST BOX 356151 SEATTLE WA 98195 KING (206) 598-3300 Acute Care Hospitals Government - State TRUE 47.6505060 -122.3074820 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-gezf_iitw.mxe8 500008 661427 2018-11-29 2018-06-30 209 81       50 408 16 18           442
1358 OVERLAKE HOSPITAL MEDICAL CENTER 1035-116TH AVE NE BELLEVUE WA 98004 KING (425) 688-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 47.6208736 -122.1868731 1 GEOMETRIC_CENTER 33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-rzza-8dw4_494p 500051 658006 2019-01-09 2018-06-30 237 32         286 14             300
1459 TORRANCE MEMORIAL MEDICAL CENTER 3330 LOMITA BLVD TORRANCE CA 90509 LOS ANGELES (310) 325-9110 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.8126440 -118.3437500 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-cibe~cfxf_9r58 50351 640468 2018-11-30 2018-06-30 391 44   12   25 472       40       512
1471 CEDARS-SINAI MEDICAL CENTER 8700 BEVERLY BLVD LOS ANGELES CA 90048 LOS ANGELES (310) 423-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.0754960 -118.3801220 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-pkaz~e2ny_94bc 50625 662348 2018-11-21 2018-06-30 709 48 18   24 24 880               880
1474 MARTIN LUTHER KING, JR. COMMUNITY HOSPITAL 1680 EAST 120TH STREET LOS ANGELES CA 90059 LOS ANGELES (424) 835-6808 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.9243610 -118.2443310 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-wqas_evtp_8i7y 50779 662351 2018-11-29 2018-06-30 111 20         131               131
1479 WHITTIER HOSPITAL MEDICAL CENTER 9080 COLIMA RD WHITTIER CA 90605 LOS ANGELES (562) 945-3561 Acute Care Hospitals Proprietary TRUE 33.9507480 -118.0051140 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-4rmv_824x.pbwt 50735 657693 2018-12-03 2018-06-30 140 16         156       22       178
1483 LAC/RANCHO LOS AMIGOS NATIONAL REHABILITATION CTR 7601 EAST IMPERIAL HIGHWAY DOWNEY CA 90242 LOS ANGELES (562) 401-7022 Acute Care Hospitals Government - Local FALSE 33.9293317 -118.1585885 1 ROOFTOP 37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-rfj5_pyf7~7bni 50717 662350 2018-12-03 2018-06-30 89 12         101   109           210
1488 GLENDALE MEM HOSPITAL & HLTH CENTER 1420 S CENTRAL AVE GLENDALE CA 91204 LOS ANGELES (818) 502-1900 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1277890 -118.2577950 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-7nps-ge35~jh8j 50058 657613 2018-12-03 2018-06-30 204 24       13 241 49 14       30   334
1582 MADERA COMMUNITY HOSPITAL 1250 E ALMOND AVE MADERA CA 93637 MADERA (559) 675-5555 Acute Care Hospitals Voluntary non-profit - Other FALSE 36.9454270 -120.0454670 0   39 6 6039 31460 Fresno-Madera, CA Central Madera County https://data.medicare.gov/resource/xubh-q36u/row-zgse.huz6_3uyv 50568 656247 2018-12-12 2018-06-30 96 10         106               106
2127 FAIRVIEW DEVELOPMENTAL CENTER 2501 HARBOR BOULEVARD COSTA MESA CA 92626 ORANGE (714) 957-5000 Acute Care Hospitals Government - Local FALSE 33.6649120 -117.9192670 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-gyrb-ji8k_8vsj 50548 638176 2018-11-27 2018-06-30 30           30           1151   1181
2286 RIVERSIDE UNIVERSITY HEALTH SYSTEM-MEDICAL CENTER 26520 CACTUS AVENUE MORENO VALLEY CA 92555 RIVERSIDE (951) 486-4000 Acute Care Hospitals Government - Local TRUE 33.9100540 -117.1958240 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-h5qt.qee8.h53s 50292 662336 2018-12-28 2018-06-30 354 45       8 439               439
2288 PALO VERDE HOSPITAL 250 NORTH FIRST STREET BLYTHE CA 92225 RIVERSIDE (760) 922-4115 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.6124500 -114.5954790 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-ekup.vqie~g6zn 50423 658138 2018-11-28 2018-06-30 47 4         51               51
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
2332 METHODIST HOSPITAL OF SACRAMENTO 7500 HOSPITAL DRIVE SACRAMENTO CA 95823 SACRAMENTO (916) 423-6010 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.4642320 -121.4163330 0   67 6 6067 40900 Sacramento-Roseville, CA Central Sacramento County https://data.medicare.gov/resource/xubh-q36u/row-3qei-q8un_3r8f 50590 657683 2018-12-03 2018-06-30 126 20       12 158       171       329
2371 TUALITY COMMUNITY HOSPITAL 335 SE 8TH AVENUE HILLSBORO OR 97123 WASHINGTON (503) 681-1111 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5196230 -122.9773100 0   67 41 41067 38900 Portland-Vancouver-Salem, OR-WA Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-x4zr_f9jw.9qwd 380021 662242 2018-11-30 2018-06-30 165 29         194 21             215
2546 ELLWOOD CITY MEDICAL CENTER 724 PERSHING STREET ELLWOOD CITY PA 16117 LAWRENCE (724) 752-0081 Acute Care Hospitals Proprietary TRUE 40.8693490 -80.2744790 0   73 42 42073 35260 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-k638_yc9y~2hzs 390008 640799 2019-01-10 2018-06-30 46 6         52 10             62
2552 ST JOSEPH HOSPITAL 2901 SQUALICUM PARKWAY BELLINGHAM WA 98225 WHATCOM (360) 734-5400 Acute Care Hospitals Voluntary non-profit - Other TRUE 48.7722780 -122.4748780 0   73 53 53073 13380   Central Whatcom County https://data.medicare.gov/resource/xubh-q36u/row-xf7q~fgxx.c5xi 500030 662286 2018-11-30 2018-06-30 183 24         207 20 14           241
2683 SAN MATEO MEDICAL CENTER 222 W 39TH AVE SAN MATEO CA 94403 SAN MATEO (650) 573-2222 Acute Care Hospitals Government - Local TRUE 37.5301160 -122.2994060 0   81 6 6081 41860 San Jose-San Francisco-Oakland, CA Central San Mateo County https://data.medicare.gov/resource/xubh-q36u/row-n83i.z2gh_aca4 50113 660755 2018-12-03 2018-06-30 93 7         100 34     374       508
2759 SAMARITAN HOSPITAL-ST MARY'S CAMPUS 1300 MASSACHUSETTS AVENUE TROY NY 12180 RENSSELAER (518) 268-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.7439770 -73.6764150 0   83 36 36083 10580 Albany-Schenectady, NY Central Rensselaer County https://data.medicare.gov/resource/xubh-q36u/row-23ud-7iuq.i6ww 330232 660842 2019-11-18 2018-06-30 20           20               20
2769 AVERA HEART HOSPITAL OF SOUTH DAKOTA 4500 W 69TH ST SIOUX FALLS SD 57108 LINCOLN (605) 977-7000 Acute Care Hospitals Proprietary TRUE 43.4899220 -96.7809060 0   83 46 46083 43620   Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-rh7v_8wee~ws72 430095 658587 2018-12-03 2018-06-30 53           53               53
2776 EL CAMINO HOSPITAL 2500 GRANT ROAD MOUNTAIN VIEW CA 94040 SANTA CLARA (650) 940-7000 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.3693410 -122.0779330 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-pztm_52rg~xmku 50308 662338 2018-11-30 2018-06-30 303 39         388 25 30           443
2778 ST LOUISE REGIONAL HOSPITAL 9400 NO NAME UNO GILROY CA 95020 SANTA CLARA (408) 848-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.0351100 -121.5730380 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-bxa9-aaz9_2d3g 50688 658156 2018-11-29 2018-06-30 64 8         72               72
2783 O'CONNOR HOSPITAL 2105 FOREST AVENUE SAN JOSE CA 95128 SANTA CLARA (408) 947-2500 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3270540 -121.9371540 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-e67s~ymzp~sv3q 50153 656228 2018-11-29 2018-06-30 302 22         324       24       348
2882 MERCY MEDICAL CENTER REDDING 2175 ROSALINE AVE, CLAIRMONT HGTS REDDING CA 96001 SHASTA (530) 225-6102 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5719533 -122.3952328 1 ROOFTOP 89 6 6089 39820 Redding-Red Bluff, CA Central Shasta County https://data.medicare.gov/resource/xubh-q36u/row-y47u-62yf~3uib 50280 657650 2019-07-01 2018-06-30 202 44       16 262               262
2919 MARGARET R PARDEE MEMORIAL HOSPITAL 800 N JUSTICE ST HENDERSONVILLE NC 28791 HENDERSON (828) 696-1000 Acute Care Hospitals Government - Local TRUE 35.3208140 -82.4681530 0   89 37 37089 11700 Asheville-Brevard, NC Central Henderson County https://data.medicare.gov/resource/xubh-q36u/row-zt42_agis.ksd3 340017 658528 2018-11-29 2018-06-30 147 13         160               160
3080 SONOMA DEVELOPMENTAL CENTER 15000 ARNOLD DRIVE / P O BOX 1493 ELDRIDGE CA 95431 SONOMA (707) 938-6000 Acute Care Hospitals Government - State FALSE 38.3490270 -122.5169100 0   97 6 6097 42220 San Jose-San Francisco-Oakland, CA Central Sonoma County https://data.medicare.gov/resource/xubh-q36u/row-j6wx.73xx-wqrm 50547 638175 2018-11-27 2018-06-30 13           13           963   976
3192 PARKVIEW MEDICAL CENTER, INC 400 W 16TH ST PUEBLO CO 81003 PUEBLO (719) 584-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.2816780 -104.6121230 0   101 8 8101 39380 Pueblo-Cañon City, CO Central Pueblo County https://data.medicare.gov/resource/xubh-q36u/row-6kae.fdwt~txeq 60020 656879 2018-11-28 2018-06-30 233 12       11 276 35 15           326
3226 JEANES HOSPITAL 7600 CENTRAL AVENUE PHILADELPHIA PA 19111 PHILADELPHIA (215) 728-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0690710 -75.0865510 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-ffib_n7hw-d6uu 390080 657948 2018-12-03 2018-06-30 126 20         146               146
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
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
3338 PORTERVILLE DEVELOPMENTAL CENTER 26501 AVENUE 140 PORTERVILLE CA 93257 TULARE (559) 782-2222 Acute Care Hospitals Government - State FALSE 36.0439080 -118.9804830 0   107 6 6107 47300 Visalia-Porterville-Hanford, CA Central Tulare County https://data.medicare.gov/resource/xubh-q36u/row-8jhm_m9d6-frtp 50546 638174 2018-11-27 2018-06-30 44           44           1182   1226
3420 VENTURA COUNTY MEDICAL CENTER 300 HILLMONT AVENUE VENTURA CA 93003 VENTURA (805) 652-6075 Acute Care Hospitals Government - Local TRUE 34.2790550 -119.2543550 0   111 6 6111 37100 Los Angeles-Long Beach, CA Central Ventura County https://data.medicare.gov/resource/xubh-q36u/row-8hxa_nmwp_zdmb 50159 662323 2018-12-03 2018-06-30 196 52       24 272               272
3425 NORTHWESTERN MEDICINE MCHENRY HOSPITAL 4201 MEDICAL CENTER DRIVE MCHENRY IL 60050 MC HENRY (815) 344-5000 Acute Care Hospitals Voluntary non-profit - Other FALSE 42.3189000 -88.2797870 0   111 17 17111 16980 Chicago-Naperville, IL-IN-WI Central McHenry County https://data.medicare.gov/resource/xubh-q36u/row-kudg.ki8v.vy8u 140116 661720 2018-11-29 2018-06-30 234 30         264   22           286
3582 NORTH METRO MEDICAL CENTER 1400 BRADEN STREET JACKSONVILLE AR 72076 PULASKI (501) 985-7000 Acute Care Hospitals Proprietary TRUE 34.8723810 -92.1246970 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-fmp5~srts-kxcs 40074 656863 2018-12-06 2018-06-30 47           47 31             78
3778 CENTRO CARDIOVASCULAR AVENIDA AMERICO MIRANDA, ENTRADA PRINCIPAL CM RIO PIEDRAS PR 936 SAN JUAN (787) 754-8500 Acute Care Hospitals Government - State FALSE 18.3997905 -66.0681500 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-n57n_rm6c-sekq 400124 639357 2018-12-12 2018-06-30 114 50         164               164
3800 MERCY HOSPITAL FORT SMITH 7301 ROGERS AVE FORT SMITH AR 72903 SEBASTIAN (479) 314-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.3536470 -94.3529640 0   131 5 5131 22900   Central Sebastian County https://data.medicare.gov/resource/xubh-q36u/row-2a77_rb9f.j48w 40062 661700 2018-11-30 2018-06-30 280 38         343   42           400
3840 WELLSPAN SURGERY AND REHABILITATION HOSPITAL 55 MONUMENT ROAD YORK PA 17403 YORK (717) 812-6100 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.9232770 -76.7168980 0   133 42 42133 49620 Harrisburg-York-Lebanon, PA Central York County https://data.medicare.gov/resource/xubh-q36u/row-vz8h~6tdd.rzsw 390327 655835 2018-11-29 2018-06-30 25           25   48           73
3862 AVERA SACRED HEART HOSPITAL 501 SUMMIT ST YANKTON SD 57078 YANKTON (605) 668-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.8725730 -97.4069450 0   135 46 46135 49460   Central Yankton County https://data.medicare.gov/resource/xubh-q36u/row-p2ay-ses4.gzui 430012 656749 2018-11-30 2018-06-30 65 10         75       187       262
697 PARKLAND MEDICAL CENTER 1 PARKLAND DRIVE DERRY NH 3038 ROCKINGHAM (603) 421-2100 Acute Care Hospitals Proprietary TRUE 42.8758250 -71.3175780 0   15 33 33015 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Rockingham County https://data.medicare.gov/resource/xubh-q36u/row-m9nh.dqhg_kjyp 300017 659515 2019-11-07 2018-07-31 60 8         68 18             86
731 DORMINY MEDICAL CENTER 200 PERRY HOUSE ROAD, BOX 1447 FITZGERALD GA 31750 BEN HILL (229) 424-7100 Acute Care Hospitals Government - Local TRUE 31.6979180 -83.2609750 0   17 13 13017 22340   Central Ben Hill County https://data.medicare.gov/resource/xubh-q36u/row-x5tq.yugi-ym8v 110073 658241 2019-01-02 2018-07-31 43 5         48 12             60
823 CLARK MEMORIAL HEALTH 1220 MISSOURI AVE JEFFERSONVILLE IN 47130 CLARK (812) 283-2147 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.2827840 -85.7492480 0   19 18 18019 31140 Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-99py-itd8.dhfq 150009 656628 2019-05-09 2018-07-31 128 22 3       153 15             168
2530 FRANKFORT REGIONAL MEDICAL CENTER 299 KINGS DAUGHTERS DRIVE FRANKFORT KY 40601 FRANKLIN (502) 875-5240 Acute Care Hospitals Proprietary TRUE 38.1597740 -84.9057530 0   73 21 21073 23180 Lexington-Fayette--Richmond--Frankfort, KY Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-iiuj~fp2r_ghys 180127 657103 2019-06-24 2018-07-31 102 10       4 116 12             128
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
2844 WATSONVILLE COMMUNITY HOSPITAL 75 NIELSON STREET WATSONVILLE CA 95076 SANTA CRUZ (831) 724-4741 Acute Care Hospitals Proprietary TRUE 36.9282800 -121.7937210 0   87 6 6087 42100 San Jose-San Francisco-Oakland, CA Central Santa Cruz County https://data.medicare.gov/resource/xubh-q36u/row-wbga.ap2u-4y8h 50194 656871 2019-08-22 2018-07-31 90 6         106               106
2866 HAYWOOD REGIONAL MEDICAL CENTER 262 LEROY GEORGE DRIVE CLYDE NC 28721 HAYWOOD (828) 456-7311 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.5278560 -82.9454370 0   87 37 37087 11700 Asheville-Brevard, NC Central Haywood County https://data.medicare.gov/resource/xubh-q36u/row-va55-s4tn.af57 340184 658543 2019-05-09 2018-07-31 110 12         122 16             138
2907 ST CHARLES PARISH HOSPITAL 1057 PAUL MAILLARD ROAD LULING LA 70070 ST. CHARLES (985) 785-3644 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.9245130 -90.3717510 0   89 22 22089 35380 New Orleans-Metairie-Hammond, LA-MS Central St. Charles Parish https://data.medicare.gov/resource/xubh-q36u/row-jwzr_ckt6~ux2m 190079 661901 2018-12-21 2018-07-31 31 8         39 20             59
3033 PHOEBE PUTNEY MEMORIAL HOSPITAL 417 THIRD AVENUE ALBANY GA 31703 DOUGHERTY (229) 312-4068 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.5902290 -84.1562670 0   95 13 13095 10500   Central Dougherty County https://data.medicare.gov/resource/xubh-q36u/row-97aw-8gyu-wg2w 110007 658211 2019-07-05 2018-07-31 332 50       27 409 15 25           461
3172 HARRIS REGIONAL HOSPITAL 68 HOSPITAL RD SYLVA NC 28779 JACKSON (828) 586-7000 Acute Care Hospitals Proprietary TRUE 35.3839230 -83.2027900 0   99 37 37099 19000   Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-xxmc~xtb8_wjsz 340016 658527 2019-05-09 2018-07-31 73 9         82               82
3533 BYRD REGIONAL HOSPITAL 1020 FERTITTA BLVD LEESVILLE LA 71446 VERNON (337) 239-9041 Acute Care Hospitals Proprietary TRUE 31.1373240 -93.2687910 0   115 22 22115 22860 DeRidder-Fort Polk South, LA Central Vernon Parish https://data.medicare.gov/resource/xubh-q36u/row-strz-rejf.3ijm 190164 643212 2019-02-11 2018-07-31 45 7         52               52
3595 MINDEN MEDICAL CENTER NO 1 MEDICAL PLAZA MINDEN LA 71055 WEBSTER (318) 377-2321 Acute Care Hospitals Proprietary TRUE 32.6172391 -93.2863556 1 ROOFTOP 119 22 22119 43340   Outlying Webster Parish https://data.medicare.gov/resource/xubh-q36u/row-zn8k~yqhx.sjt5 190144 657128 2019-01-03 2018-07-31 113 10         125 20 12           157
3625 COOSA VALLEY MEDICAL CENTER 315 W HICKORY ST SYLACAUGA AL 35150 TALLADEGA (256) 249-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.1646660 -86.2545980 0   121 1 1121 45180 Birmingham-Hoover-Talladega, AL Central Talladega County https://data.medicare.gov/resource/xubh-q36u/row-uqj6-bzwc~56ip 10164 659174 2018-12-26 2018-07-31 114 8         122 15     35 50     222
3928 LAS PALMAS MEDICAL CENTER 1801 NORTH OREGON STREET EL PASO TX 79902 EL PASO (915) 521-1200 Acute Care Hospitals Proprietary TRUE 31.7704830 -106.4987530 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-ay4n-jgmd_mzpr 450107 662079 2019-08-29 2018-07-31 377 64       55 496   63           559
4249 ASCENSION VIA CHRISTI HOSPITAL ST. TERESA, INC. 14800 WEST ST TERESA WICHITA KS 67235 SEDGWICK (316) 796-7800 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.7250450 -97.5137860 0   173 20 20173 48620 Wichita-Arkansas City-Winfield, KS Central Sedgwick County https://data.medicare.gov/resource/xubh-q36u/row-8pe2-i236~vmyi 170200 657087 2019-01-02 2018-07-31 33 6         39   18           57
4421 PARK PLAZA HOSPITAL 1313 HERMANN DR HOUSTON TX 77004 HARRIS (713) 527-5019 Acute Care Hospitals Proprietary TRUE 29.7223750 -95.3880450 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-dstj_s4k4.df5s 450659 657538 2019-08-26 2018-07-31 119 14         133               133
4531 PHOEBE SUMTER MEDICAL CENTER 126 HIGHWAY 280 W AMERICUS GA 31719 SUMTER (229) 931-1280 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.0642500 -84.2553760 0   261 13 13261 11140   Central Sumter County https://data.medicare.gov/resource/xubh-q36u/row-vsiw~isbg~xz6s 110044 658233 2018-12-28 2018-07-31 44   10       54               54
4601 UT HEALTH EAST TEXAS CARTHAGE HOSPITAL 409 COTTAGE RD CARTHAGE TX 75633 PANOLA (093) 693-3841 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.1671260 -94.3460390 0   365 48 48365         https://data.medicare.gov/resource/xubh-q36u/row-tyuw-zwkq.zq2r 450210 640322 2018-12-28 2018-07-31 42           42               42
44 STANFORD HEALTH CARE - VALLEYCARE 5555 WEST LAS POSITAS BOULEVARD PLEASANTON CA 94588 ALAMEDA (925) 447-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.6921330 -121.8800270 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-i8ak.uv35.9uup 50283 656398 2019-01-31 2018-08-31 144 23         167 14     26       207
78 APPLING HOSPITAL 163 E TOLLISON STREET BAXLEY GA 31513 APPLING (912) 367-9841 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.7687680 -82.3493510 0   1 13 13001         https://data.medicare.gov/resource/xubh-q36u/row-j4qq-twpw~u8jw 110071 658240 2019-03-29 2018-08-31 31 3         34 30     101       165
245 BRIGHAM CITY COMMUNITY HOSPITAL 950 SOUTH MEDICAL DRIVE BRIGHAM CITY UT 84302 BOX ELDER (435) 734-9471 Acute Care Hospitals Proprietary TRUE 41.4910700 -112.0244410 0   3 49 49003 36260 Salt Lake City-Provo-Orem, UT Central Box Elder County https://data.medicare.gov/resource/xubh-q36u/row-nuu9~e5qc.3jxf 460017 657558 2019-01-17 2018-08-31 40           40               40
490 PLANTATION GENERAL HOSPITAL 401 NW 42ND AVE PLANTATION FL 33317 BROWARD (954) 587-5010 Acute Care Hospitals Voluntary non-profit - Private TRUE 26.1264610 -80.2041700 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-k3qn_68yj.yfxn 100167 661481 2019-12-04 2018-08-31 477 61       37 589 56 15           660
535 TENNOVA HEALTHCARE-CLEVELAND 2305 CHAMBLISS AVE NW CLEVELAND TN 37311 BRADLEY (423) 339-4132 Acute Care Hospitals Proprietary TRUE 35.1767430 -84.8685910 0   11 47 47011 17420 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Bradley County https://data.medicare.gov/resource/xubh-q36u/row-yct2-mv92~dmuc 440185 657498 2019-01-29 2018-08-31 156 27         183               183
668 WESTERN ARIZONA REGIONAL MEDICAL CENTER 2735 SILVER CREEK ROAD BULLHEAD CITY AZ 86442 MOHAVE (928) 763-2273 Acute Care Hospitals Proprietary TRUE 35.1098530 -114.5551460 0   15 4 4015 29420 Las Vegas-Henderson, NV-AZ Central Mohave County https://data.medicare.gov/resource/xubh-q36u/row-95sy-y45e~48d6 30101 656846 2019-01-31 2018-08-31 107 32         139               139
669 HAVASU REGIONAL MEDICAL CENTER 101 CIVIC CENTER LANE LAKE HAVASU CITY AZ 86403 MOHAVE (928) 855-8185 Acute Care Hospitals Proprietary TRUE 34.4799800 -114.3385370 0   15 4 4015 29420 Las Vegas-Henderson, NV-AZ Central Mohave County https://data.medicare.gov/resource/xubh-q36u/row-kbv6-rmcu~b79y 30069 661849 2019-02-04 2018-08-31 128 16         144       19       163
700 CARLSBAD MEDICAL CENTER 2430 WEST PIERCE STREET CARLSBAD NM 88220 EDDY (575) 887-4570 Acute Care Hospitals Proprietary FALSE 32.4418400 -104.2586420 0   15 35 35015 16100   Central Eddy County https://data.medicare.gov/resource/xubh-q36u/row-5km2_nhcx~29i4 320063 655571 2019-02-27 2018-08-31 84 12         96   10   15       121

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