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

25 rows where "filed_date" is on date 2019-11-26 and hospital_ownership = "Proprietary"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: city, state, county_name, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, fy_end_date, acute_beds, icu_beds, coronary_beds, burn_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, filed_date (date), fy_end_date (date)

Link rowid ▼ hospital_name address city state zip_code county_name phone_number hospital_type hospital_ownership emergency_services lat lng geocode_flag geocode_accuracy countyfips statefips statecountyfips cbsacode csatitle centraloutlyingcounty countyequivalent hosp_lookup_url PRVDR_NUM RPT_REC_NUM filed_date fy_end_date acute_beds icu_beds coronary_beds burn_beds surg_icu_beds oth_spec_beds subtotal_acute_beds subprovider_ipf_beds subprovider_irf_beds subprovider_oth_beds skilled_nursing_beds nursing_fac_beds oth_longterm_beds hospice_beds all_beds
155 155 PALI MOMI MEDICAL CENTER 98-1079 MOANALUA ROAD AIEA HI 96701 HONOLULU (808) 486-6000 Acute Care Hospitals Proprietary TRUE 21.3839880 -157.9376750 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-gvhj-d3a6.ypz3 120026 659776 2019-11-26 2019-06-30 110 8         118               118
162 162 STRAUB CLINIC AND HOSPITAL 888 SO KING STREET HONOLULU HI 96813 HONOLULU (808) 522-4000 Acute Care Hospitals Proprietary TRUE 21.3022680 -157.8509210 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-j69k-r5cq-9v28 120022 659775 2019-11-26 2019-06-30 140 16   3     159               159
431 431 UNIVERSITY OF KS HLTH SYSTEM GREAT BEND CAMPUS 514 CLEVELAND STREET GREAT BEND KS 67530 BARTON (620) 792-8833 Acute Care Hospitals Proprietary TRUE 38.3562000 -98.7916190 0   9 20 20009 24460   Central Barton County https://data.medicare.gov/resource/xubh-q36u/row-ezt6_4fjw-kpxn 170191 660092 2019-11-26 2019-06-30 29 4         33               33
654 654 METHODIST HOSPITAL SOUTH 1905 HWY 97 EAST JOURDANTON TX 78026 ATASCOSA (830) 769-3515 Acute Care Hospitals Proprietary TRUE 28.9331124 -98.5260352 1 ROOFTOP 13 48 48013 41700   Outlying Atascosa County https://data.medicare.gov/resource/xubh-q36u/row-5vk8_ecmw.2bzr 450165 660714 2019-11-26 2019-06-30 61 6         67               67
665 665 UCHEALTH BROOMFIELD HOSPITAL 11820 DESTINATION DRIVE BROOMFIELD CO 80021 JEFFERSON (303) 460-6000 Acute Care Hospitals Proprietary TRUE 39.9105000 -105.0932070 0   14 8 8014 19740 Denver-Aurora, CO Central Broomfield County https://data.medicare.gov/resource/xubh-q36u/row-dvb6-rzzd_er2t 60129 661295 2019-11-26 2019-06-30 22           22               22
887 887 COLISEUM NORTHSIDE HOSPITAL 400 CHARTER BOULEVARD MACON GA 31210 BIBB (478) 757-8200 Acute Care Hospitals Proprietary TRUE 32.8698610 -83.6943610 0   21 13 13021 31420 Macon-Warner Robins, GA Central Bibb County https://data.medicare.gov/resource/xubh-q36u/row-qnzt.yc4b~gnii 110201 660371 2019-11-26 2019-06-30 75 10         85               85
1179 1179 BAPTIST MEDICAL CENTER 111 DALLAS STREET SAN ANTONIO TX 78205 BEXAR (210) 297-8256 Acute Care Hospitals Proprietary TRUE 29.4328770 -98.4927730 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-9jbx_v3az~nwzz 450058 660466 2019-11-26 2019-06-30 1166 151         1457 38 72           1567
1309 1309 HOSPITAL UPR, DR FEDERICO TRILLA CARR 3 KM 8 3 AVE 65TH INFANTERIA BOX 6021 CAROLINA PR 984 CAROLINA (787) 757-1800 Acute Care Hospitals Proprietary FALSE 18.3808638 -65.9632825 1 RANGE_INTERPOLATED 31 72 72031 41980 San Juan-Carolina, PR Central Carolina Municipio https://data.medicare.gov/resource/xubh-q36u/row-xbn3-25u3~b8g7 400112 660876 2019-11-26 2019-06-30 210 8         233               233
1523 1523 CEDAR-SINAI MARINA DEL REY HOSPITAL 4650 LINCOLN BLVD MARINA DEL REY CA 90291 LOS ANGELES (310) 823-8911 Acute Care Hospitals Proprietary FALSE 33.9817320 -118.4401540 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-izeb-yvf9_zc9q 50740 660492 2019-11-26 2019-06-30 91 12         103               103
1561 1561 BERWICK HOSPITAL CENTER 701 EAST 16TH STREET BERWICK PA 18603 COLUMBIA (570) 759-5020 Acute Care Hospitals Proprietary TRUE 41.0701590 -76.2308040 0   37 42 42037 14100 Bloomsburg-Berwick-Sunbury, PA Central Columbia County https://data.medicare.gov/resource/xubh-q36u/row-cn25-dn3w-iqqf 390072 660695 2019-11-26 2019-06-30 77 10         87 14     240       341
1785 1785 GARDEN PARK MEDICAL CENTER 15200 COMMUNITY ROAD GULFPORT MS 39503 HARRISON (228) 575-7000 Acute Care Hospitals Proprietary TRUE 30.4420100 -89.0927660 0   47 28 28047 25060   Central Harrison County https://data.medicare.gov/resource/xubh-q36u/row-mqi3~42hr_6pv9 250123 660823 2019-11-26 2018-12-31 87 13         100 21             121
1857 1857 MOUNT CARMEL NEW ALBANY SURGICAL HOSPITAL 7333 SMITH'S MILL ROAD NEW ALBANY OH 43054 FRANKLIN (614) 775-6600 Acute Care Hospitals Proprietary FALSE 40.0863030 -82.7887930 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-ywvf~p2gq~kk8u 360266 660674 2019-11-26 2019-06-30 60           60               60
2128 2128 MEMORIALCARE ORANGE COAST MEDICAL CENTER 9920 TALBERT AVENUE FOUNTAIN VALLEY CA 92708 ORANGE (714) 378-7406 Acute Care Hospitals Proprietary TRUE 33.7016590 -117.9561070 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-pc9c.ve2t.j5x8 50678 662101 2019-11-26 2019-06-30 185 21       12 218               218
2131 2131 ORTHOCOLORADO HOSPITAL AT ST ANTHONY MED CAMPUS 11650 WEST 2ND PLACE LAKEWOOD CO 80228 JEFFERSON (720) 321-5000 Acute Care Hospitals Proprietary TRUE 39.7179520 -105.1284410 0   59 8 8059 19740 Denver-Aurora, CO Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-b3pw~3vk6_q65v 60124 659765 2019-11-26 2019-06-30 48           48               48
2351 2351 BOB WILSON MEMORIAL GRANT COUNTY HOSPITAL 415 N MAIN STREET ULYSSES KS 67880 GRANT (620) 356-1266 Acute Care Hospitals Proprietary TRUE 37.5839920 -101.3580130 0   67 20 20067         https://data.medicare.gov/resource/xubh-q36u/row-8mti_jcxr_myzi 170110 660091 2019-11-26 2019-06-30 26           26               26
2413 2413 MOSES TAYLOR HOSPITAL 700 QUINCY AVENUE SCRANTON PA 18510 LACKAWANNA (570) 340-2100 Acute Care Hospitals Proprietary TRUE 41.4106750 -75.6508140 0   69 42 42069 42540   Central Lackawanna County https://data.medicare.gov/resource/xubh-q36u/row-tst5_pes9_4qs5 390119 660859 2019-11-26 2019-06-30 135 11         161 22             183
2414 2414 REGIONAL HOSPITAL OF SCRANTON 746 JEFFERSON AVENUE SCRANTON PA 18501 LACKAWANNA (570) 348-7100 Acute Care Hospitals Proprietary TRUE 41.4128270 -75.6540710 0   69 42 42069 42540   Central Lackawanna County https://data.medicare.gov/resource/xubh-q36u/row-mbuk.tbtv~6dq9 390237 661099 2019-11-26 2019-06-30 130 24         154               154
3389 3389 ALLIANCEHEALTH MIDWEST 2825 PARKLAWN DRIVE MIDWEST CITY OK 73110 OKLAHOMA (405) 610-8585 Acute Care Hospitals Proprietary TRUE 35.4665270 -97.3929250 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-sxg9_cifn-7qv9 370094 660692 2019-11-26 2019-06-30 212 24         236 19             255
3819 3819 TYLER MEMORIAL HOSPITAL 5950 STATE ROUTE 6 WEST TUNKHANNOCK PA 18657 WYOMING (570) 836-2161 Acute Care Hospitals Proprietary TRUE 41.5766510 -75.9698250 0   131 42 42131 42540   Outlying Wyoming County https://data.medicare.gov/resource/xubh-q36u/row-h68k-9niq.fgct 390192 659877 2019-11-26 2019-06-30 38 6         44               44
3886 3886 MEDICAL CENTER OF SOUTH ARKANSAS 700 WEST GROVE STREET EL DORADO AR 71730 UNION (870) 863-2000 Acute Care Hospitals Proprietary TRUE 33.2183780 -92.6710300 0   139 5 5139 20980   Central Union County https://data.medicare.gov/resource/xubh-q36u/row-rite-ah8v_bzij 40088 659753 2019-11-26 2019-06-30 95 16         111   20           131
3957 3957 HILLCREST MEDICAL CENTER 1120 SOUTH UTICA AVENUE TULSA OK 74104 TULSA (918) 579-1000 Acute Care Hospitals Proprietary TRUE 36.1471640 -95.9671410 0   143 40 40143 46140 Tulsa-Muskogee-Bartlesville, OK Central Tulsa County https://data.medicare.gov/resource/xubh-q36u/row-u9va-2kpb~97hh 370001 660845 2019-11-26 2019-06-30 319 30 44 13   42 448   32           480
4020 4020 MERIT HEALTH RIVER REGION 2100 HWY 61 N VICKSBURG MS 39183 WARREN (601) 883-5000 Acute Care Hospitals Proprietary TRUE 32.3748020 -90.8274970 0   149 28 28149 46980 Jackson-Vicksburg-Brookhaven, MS Central Warren County https://data.medicare.gov/resource/xubh-q36u/row-ad3b-7igw_vnnn 250031 660109 2019-11-26 2019-06-30 279 22         301 20             321
4078 4078 HUTCHINSON REGIONAL MEDICAL CENTER INC 1701 E 23RD AVENUE HUTCHINSON KS 67502 RENO (620) 665-2001 Acute Care Hospitals Proprietary TRUE 38.0794850 -97.8922750 0   155 20 20155 26740   Central Reno County https://data.medicare.gov/resource/xubh-q36u/row-pvdz.9ewv~qj4w 170020 660089 2019-11-26 2019-06-30 109 18         127 14 11           152
4490 4490 CHRISTUS MOTHER FRANCES HOSPITAL SULPHUR SPRINGS 115 AIRPORT RD SULPHUR SPRINGS TX 75482 HOPKINS (903) 885-7671 Acute Care Hospitals Proprietary TRUE 33.1562200 -95.5996480 0   223 48 48223 44860 Dallas-Fort Worth, TX-OK Central Hopkins County https://data.medicare.gov/resource/xubh-q36u/row-k5xf.mj66.grqz 450236 660051 2019-11-26 2019-06-30 42 14         56   6           62
4540 4540 PARIS REGIONAL MEDICAL CENTER 820 CLARKSVILLE ST PARIS TX 75460 LAMAR (903) 785-4521 Acute Care Hospitals Proprietary TRUE 33.6603900 -95.5474780 0   277 48 48277 37580   Central Lamar County https://data.medicare.gov/resource/xubh-q36u/row-n8ke~e8ak.enhb 450196 660886 2019-11-26 2019-06-30 210 20         230   23           253

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