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

22 rows where "fy_end_date" is on date 2018-11-30

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

fy_end_date (date) ✖

  • 2018-11-30 · 22 ✖
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
345 345 OROVILLE HOSPITAL 2767 OLIVE HIGHWAY OROVILLE CA 95966 BUTTE (530) 533-8500 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.5045350 -121.5421060 0   7 6 6007 17020   Central Butte County https://data.medicare.gov/resource/xubh-q36u/row-zach-cczm-89ek 50030 647860 2019-05-15 2018-11-30 123 10         133               133
671 671 VALLEY VIEW MEDICAL CENTER 5330 SOUTH HIGHWAY 95 FORT MOHAVE AZ 86426 MOHAVE (928) 788-2273 Acute Care Hospitals Proprietary TRUE 35.0023630 -114.5979540 0   15 4 4015 29420 Las Vegas-Henderson, NV-AZ Central Mohave County https://data.medicare.gov/resource/xubh-q36u/row-8tpg-vtcr.3uy5 30117 652034 2019-05-02 2018-11-30 60 12         72   12           84
1220 1220 JOHN H STROGER JR HOSPITAL 1901 W HARRISON ST CHICAGO IL 60612 COOK (312) 864-6000 Acute Care Hospitals Government - Local TRUE 41.8740410 -87.6743110 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-2ss5~bvsp.bpf4 140124 659251 2019-11-07 2018-11-30 310 32   8 14   448               448
1225 1225 PROVIDENT HOSPITAL OF CHICAGO 500 E 51ST ST CHICAGO IL 60615 COOK (312) 572-2000 Acute Care Hospitals Government - Local TRUE 41.8021580 -87.6141930 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-knkg_mg7f-2emf 140300 659411 2019-11-05 2018-11-30 25           25               25
1568 1568 TRISTAR SKYLINE MEDICAL CENTER 3441 DICKERSON PIKE NASHVILLE TN 37207 DAVIDSON (615) 769-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.2453010 -86.7564630 0   37 47 47037 34980 Nashville-Davidson--Murfreesboro, TN Central Davidson County https://data.medicare.gov/resource/xubh-q36u/row-t6tv~93h2_x5ai 440006 647057 2019-04-25 2018-11-30 253 45         298 14 41           353
1953 1953 JENNINGS AMERICAN LEGION HOSPITAL 1634 ELTON ROAD JENNINGS LA 70546 JEFFRSON DAVIS (337) 616-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2392150 -92.6634450 0   53 22 22053         https://data.medicare.gov/resource/xubh-q36u/row-xvdw_xhgm-htky 190053 647257 2019-05-01 2018-11-30 44 5         49               49
2190 2190 UP HEALTH SYSTEM PORTAGE 500 CAMPUS DRIVE HANCOCK MI 49930 HOUGHTON (906) 483-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 47.1413460 -88.5856430 0   61 26 26061 26340   Central Houghton County https://data.medicare.gov/resource/xubh-q36u/row-6hq7.pe78-x3td 230108 647558 2019-05-01 2018-11-30 36           36       60       96
2273 2273 UT HEALTH EAST TEXAS PITTSBURG HOSPITAL 2701 US HWY 271 N PITTSBURG TX 75686 CAMP (903) 856-4520 Critical Access Hospitals Voluntary non-profit - Other TRUE 33.0284300 -94.9629660 0   63 48 48063         https://data.medicare.gov/resource/xubh-q36u/row-5mqj~n356~t4cq 451367 650536 2019-06-20 2018-11-30 25           25               25
2642 2642 SHOSHONE MEDICAL CENTER 25 JACOBS GULCH ROAD KELLOGG ID 83837 SHOSHONE (208) 784-1221 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.5471230 -116.1314090 0   79 16 16079         https://data.medicare.gov/resource/xubh-q36u/row-5s2d-murc_kv83 131314 647887 2019-05-02 2018-11-30 21           21               21
3094 3094 VISTA MEDICAL CENTER EAST 1324 NORTH SHERIDAN ROAD WAUKEGAN IL 60085 LAKE (847) 360-3000 Acute Care Hospitals Voluntary non-profit - Other FALSE 42.3782640 -87.8309640 0   97 17 17097 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-z8h2_y3pv-w7sx 140084 653883 2019-08-27 2018-11-30 167 23         190               190
3125 3125 NORTH TEXAS MEDICAL CENTER 1900 HOSPITAL BLVD GAINESVILLE TX 76240 COOKE (940) 612-8600 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.6453560 -97.1619760 0   97 48 48097 23620 Dallas-Fort Worth, TX-OK Central Cooke County https://data.medicare.gov/resource/xubh-q36u/row-7rqh-yn3d_yfnr 450090 650373 2019-06-10 2018-11-30 31 5         36               36
3184 3184 SOUTHERN TENNESSEE REGIONAL HEALTH SYSTEM LAWRENCE HWY 43 S BOX 847 LAWRENCEBURG TN 38464 LAWRENCE (931) 762-6571 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.1400446 -87.3699788 1 GEOMETRIC_CENTER 99 47 47099 29980 Nashville-Davidson--Murfreesboro, TN Central Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-ghnd-6g8c~yazk 440175 647058 2019-04-29 2018-11-30 83 6         89   10           99
3446 3446 HILLCREST HOSPITAL HENRYETTA 2401 W MAIN HENRYETTA OK 74437 OKMULGEE (918) 650-1511 Acute Care Hospitals Proprietary TRUE 35.4397380 -96.0154960 0   111 40 40111 46140 Tulsa-Muskogee-Bartlesville, OK Outlying Okmulgee County https://data.medicare.gov/resource/xubh-q36u/row-222q_tbcj-2m5z 370183 646973 2019-04-26 2018-11-30 27           27 14             41
3500 3500 METHODIST HOSPITAL FOR SURGERY 17101 DALLAS PARKWAY ADDISON TX 75001 DALLAS (469) 248-3900 Acute Care Hospitals Proprietary TRUE 32.9851310 -96.8288180 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-ge4u~ywgg~r953 670073 647316 2019-04-29 2018-11-30 28 4         32               32
3621 3621 HILLCREST HOSPITAL CUSHING 1027 EAST CHERRY STREET CUSHING OK 74023 PAYNE (918) 225-2915 Acute Care Hospitals Proprietary TRUE 35.9789420 -96.7574730 0   119 40 40119 44660   Central Payne County https://data.medicare.gov/resource/xubh-q36u/row-97eh~dcvw_6tpa 370099 646972 2019-04-26 2018-11-30 70 4         74 21             95
4074 4074 IRWIN COUNTY HOSPITAL 710 N IRWIN AVENUE OCILLA GA 31774 IRWIN (229) 468-3845 Acute Care Hospitals Government - Hospital District or Authority FALSE 31.6027970 -83.2503310 0   155 13 13155         https://data.medicare.gov/resource/xubh-q36u/row-x4wh~4hz8~nrk6 110130 647117 2019-04-30 2018-11-30 34           34       30       64
4137 4137 MEADOWVIEW REGIONAL MEDICAL CENTER 989 MEDICAL PARK DRIVE MAYSVILLE KY 41056 MASON (606) 759-5311 Acute Care Hospitals Proprietary TRUE 38.6395720 -83.8088040 0   161 21 21161 32500 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Mason County https://data.medicare.gov/resource/xubh-q36u/row-cj45_n7yj~tj2z 180019 647176 2019-04-30 2018-11-30 95 5         100               100
4281 4281 LIBERTY REGIONAL MEDICAL CENTER 462 E G MILES PARKWAY HINESVILLE GA 31310 LIBERTY (912) 369-9438 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.8394772 -81.6009755 1 ROOFTOP 179 13 13179 25980 Savannah-Hinesville-Statesboro, GA Central Liberty County https://data.medicare.gov/resource/xubh-q36u/row-3b9g_44yp.xw63 111335 647248 2019-05-01 2018-11-30 25           25       108       133
4332 4332 CLINCH VALLEY MEDICAL CENTER 6801 GOVERNOR GC PERRY HIGHWAY RICHLANDS VA 24641 TAZEWELL (276) 596-6000 Acute Care Hospitals Proprietary TRUE 37.0939780 -81.8194440 0   185 51 51185 14140   Central Tazewell County https://data.medicare.gov/resource/xubh-q36u/row-x352_282g.42tv 490060 648023 2019-05-02 2018-11-30 139 12         151       19       170
4488 4488 LAKE GRANBURY MEDICAL CENTER 1310 PALUXY RD GRANBURY TX 76048 HOOD (817) 573-2683 Acute Care Hospitals Proprietary TRUE 32.4318450 -97.8027290 0   221 48 48221 19100 Dallas-Fort Worth, TX-OK Outlying Hood County https://data.medicare.gov/resource/xubh-q36u/row-prqs_guzc_3igk 450596 647586 2019-04-30 2018-11-30 36 12         48               48
4516 4516 THE MEDICAL CENTER OF SOUTHEAST TEXAS 2555 JIMMY JOHNSON BLVD PORT ARTHUR TX 77640 JEFFERSON (409) 853-5900 Acute Care Hospitals Physician TRUE 29.9349520 -93.9850070 0   245 48 48245 13140   Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-adz2.98gm-mm6a 450518 647059 2019-04-26 2018-11-30 151 24       10 185 20 11           216
4701 4701 CEDAR PARK REGIONAL MEDICAL CENTER 1401 MEDICAL PARKWAY CEDAR PARK TX 78613 WILLIAMSON (512) 528-7000 Acute Care Hospitals Proprietary TRUE 30.5311240 -97.8128240 0   491 48 48491 12420   Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-rn6p~5mhb.xk3w 670043 647207 2019-04-30 2018-11-30 73 12         93               93

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