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

14 rows where "filed_date" is on date 2019-10-28 and hospital_ownership = "Proprietary"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: city, state, zip_code, county_name, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, coronary_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_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
585 585 SAN RAMON REGIONAL MEDICAL CENTER 6001 NORRIS CANYON ROAD SAN RAMON CA 94583 CONTRA COSTA (925) 275-9200 Acute Care Hospitals Proprietary TRUE 37.7759880 -121.9592740 0   13 6 6013 41860 San Jose-San Francisco-Oakland, CA Outlying Contra Costa County https://data.medicare.gov/resource/xubh-q36u/row-mpyd~xeiu_s72k 50689 655752 2019-10-28 2019-05-31 109 12       2 123               123
1453 1453 LAKEWOOD REGIONAL MEDICAL CENTER 3700 E SOUTH ST LAKEWOOD CA 90712 LOS ANGELES (562) 602-6751 Acute Care Hospitals Proprietary TRUE 33.8602230 -118.1487490 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-kkpc~5uz9~2td4 50581 655750 2019-10-28 2019-05-31 140 32         172               172
1573 1573 TRISTAR SOUTHERN HILLS MEDICAL CENTER 391 WALLACE RD NASHVILLE TN 37211 DAVIDSON (615) 781-4000 Acute Care Hospitals Proprietary TRUE 36.0778720 -86.7238140 0   37 47 47037 34980 Nashville-Davidson--Murfreesboro, TN Central Davidson County https://data.medicare.gov/resource/xubh-q36u/row-hyay~dct4~yy74 440197 655473 2019-10-28 2019-05-31 83 20         103   16           119
2109 2109 PLACENTIA LINDA HOSPITAL 1301 N ROSE DRIVE PLACENTIA CA 92870 ORANGE (714) 993-2000 Acute Care Hospitals Proprietary TRUE 33.8866120 -117.8420960 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-rjmd~3mmi-4rkc 50589 656051 2019-10-28 2019-05-31 106 8         114               114
2293 2293 JOHN F KENNEDY MEMORIAL HOSPITAL 47111 MONROE STREET INDIO CA 92201 RIVERSIDE (760) 347-6191 Acute Care Hospitals Proprietary TRUE 33.7063590 -116.2338810 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-5fp5.7ptj~7ga6 50534 655749 2019-10-28 2019-05-31 114 16         130               130
2639 2639 TWIN CITIES COMMUNITY HOSPITAL 1100 LAS TABLAS RD TEMPLETON CA 93465 SAN LUIS OBISPO (805) 434-3500 Acute Care Hospitals Proprietary TRUE 35.5543890 -120.7201300 0   79 6 6079 42020   Central San Luis Obispo County https://data.medicare.gov/resource/xubh-q36u/row-9pwz~hbhx_tz4b 50633 655751 2019-10-28 2019-05-31 104 18         122               122
2827 2827 HIALEAH HOSPITAL 651 E 25TH ST HIALEAH FL 33013 MIAMI-DADE (305) 693-6100 Acute Care Hospitals Proprietary TRUE 25.8449310 -80.2688810 0   86 12 12086 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Miami-Dade County https://data.medicare.gov/resource/xubh-q36u/row-q4nv.dfh5_bbrg 100053 655760 2019-10-28 2019-05-31 331 21       10 362               362
2836 2836 NORTH SHORE MEDICAL CENTER 1100 NW 95TH ST MIAMI FL 33150 MIAMI-DADE (305) 835-6000 Acute Care Hospitals Proprietary TRUE 25.8616580 -80.2146560 0   86 12 12086 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Miami-Dade County https://data.medicare.gov/resource/xubh-q36u/row-9ga8_euvm.dbmz 100029 655759 2019-10-28 2019-05-31 660 58       18 748               748
2977 2977 PIEDMONT MEDICAL CENTER 222 S HERLONG AVE ROCK HILL SC 29730 YORK (803) 329-1234 Acute Care Hospitals Proprietary TRUE 34.9551980 -81.0512500 0   91 45 45091 16740 Charlotte-Concord, NC-SC Outlying York County https://data.medicare.gov/resource/xubh-q36u/row-ut6b.7ida_ci73 420002 655837 2019-10-28 2019-05-31 244 24         268 20             288
3144 3144 GOOD SAMARITAN MEDICAL CENTER 1309 N FLAGLER DR WEST PALM BEACH FL 33401 PALM BEACH (561) 655-5511 Acute Care Hospitals Proprietary TRUE 26.7250620 -80.0499680 0   99 12 12099 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Palm Beach County https://data.medicare.gov/resource/xubh-q36u/row-kt9e~dq2e-y9e2 100287 655762 2019-10-28 2019-05-31 304 22       7 333               333
3926 3926 SIERRA MEDICAL CENTER 1625 MEDICAL CENTER DR EL PASO TX 79902 EL PASO (915) 747-4000 Acute Care Hospitals Proprietary TRUE 31.7786700 -106.4796500 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-af3f.cjxd.pdpu 450668 655844 2019-10-28 2019-05-31 196 23 7     1 234   24           258
3929 3929 THE HOSPITALS OF PROVIDENCE MEMORIAL CAMPUS 2001 N OREGON ST EL PASO TX 79902 EL PASO (915) 577-6011 Acute Care Hospitals Proprietary TRUE 31.7711610 -106.4993450 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-mwx3.k55z_dt4b 450002 655841 2019-10-28 2019-05-31 238 20       34 308 12             320
4105 4105 ST FRANCIS HOSPITAL 5959 PARK AVE MEMPHIS TN 38119 SHELBY (901) 765-1000 Acute Care Hospitals Proprietary TRUE 35.0999010 -89.8645160 0   157 47 47157 32820 Memphis-Forrest City, TN-MS-AR Central Shelby County https://data.medicare.gov/resource/xubh-q36u/row-i9be.s6u9_8ayy 440183 655839 2019-10-28 2019-05-31 278   37     10 325 39 29           393
4110 4110 SAINT FRANCIS BARTLETT MEDICAL CENTER 2986 KATE BOND RD BARTLETT TN 38133 SHELBY (901) 820-7050 Acute Care Hospitals Proprietary TRUE 35.2070340 -89.8023470 0   157 47 47157 32820 Memphis-Forrest City, TN-MS-AR Central Shelby County https://data.medicare.gov/resource/xubh-q36u/row-gj83-utqb_fg87 440228 655840 2019-10-28 2019-05-31 114 32       10 156               156

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