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

17 rows where burn_beds = 10

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, hospital_ownership, geocode_flag, geocode_accuracy, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, filed_date, fy_end_date, icu_beds, coronary_beds, surg_icu_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, nursing_fac_beds, filed_date (date), fy_end_date (date)

burn_beds ✖

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
419 419 HOLMES REGIONAL MEDICAL CENTER 1350 S HICKORY ST MELBOURNE FL 32901 BREVARD (321) 434-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.0869100 -80.6135230 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-vfyd.d5k5.qxkg 100019 646066 2019-02-28 2018-09-30 450 54   10     514               514
741 741 OCHSNER LSU HEALTH SHREVEPORT 1541 KINGS HIGHWAY SHREVEPORT LA 71103 CADDO (318) 675-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.4817910 -93.7615900 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-mkra_a29f.kchy 190098 660383 2019-12-03 2019-06-30 285     10     369 37             406
815 815 COMMUNITY REGIONAL MEDICAL CENTER 2823 FRESNO STREET FRESNO CA 93721 FRESNO (559) 459-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.7425830 -119.7830230 0   19 6 6019 23420 Fresno-Madera, CA Central Fresno County https://data.medicare.gov/resource/xubh-q36u/row-xy9w-yfis_5dn2 50060 662313 2019-01-28 2018-08-31 577 78   10   84 749   32   58 48     887
1234 1234 LOYOLA UNIVERSITY MEDICAL CENTER 2160 S 1ST AVENUE MAYWOOD IL 60153 COOK (708) 216-9000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8587320 -87.8332100 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-tjbj~st8y~aaxx 140276 662522 2019-12-23 2019-06-30 345 76   10   50 515               515
1730 1730 TANNER MEDICAL CENTER - CARROLLTON 705 DIXIE STREET CARROLLTON GA 30117 CARROLL (770) 836-9580 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.5705550 -85.0724640 0   45 13 13045 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Carroll County https://data.medicare.gov/resource/xubh-q36u/row-7yah~3pv6~c65g 110011 660365 2019-12-03 2019-06-30 135 12   10     157               157
2156 2156 NASSAU UNIVERSITY MEDICAL CENTER 2201 HEMPSTEAD TURNPIKE EAST MEADOW NY 11554 NASSAU (516) 572-0123 Acute Care Hospitals Government - Local TRUE 40.7252980 -73.5544130 0   59 36 36059 35620 New York-Newark, NY-NJ-CT-PA Central Nassau County https://data.medicare.gov/resource/xubh-q36u/row-jkr2_ys4r-jt6b 330027 650855 2019-06-26 2018-12-31 295 33   10   28 372 133 25           530
2215 2215 UNIVERSITY OF CINCINNATI MEDICAL CENTER, LLC 234 GOODMAN STREET CINCINNATI OH 45219 HAMILTON (513) 584-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.1367280 -84.5025620 0   61 39 39061 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-rc7b_nuaq-8nt3 360003 661583 2019-12-03 2019-06-30 366     10 34   515 40             555
2799 2799 STATEN ISLAND UNIVERSITY HOSPITAL 475 SEAVIEW AVENUE STATEN ISLAND NY 10305 RICHMOND (418) 226-9761 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5840820 -74.0870130 0   85 36 36085 35620 New York-Newark, NY-NJ-CT-PA Central Richmond County https://data.medicare.gov/resource/xubh-q36u/row-z9rb.hyek_grbe 330160 650195 2019-06-18 2018-12-31 426 44 38 10   11 543 35 49           627
3098 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
3221 3221 TEMPLE UNIVERSITY HOSPITAL 3401 NORTH BROAD STREET PHILADELPHIA PA 19140 PHILADELPHIA (215) 707-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0046670 -75.1522000 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-zzyj_ydxk_mei6 390027 661088 2019-12-02 2019-06-30 473 43 18 10     598 118 16           732
3482 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
3583 3583 ARKANSAS CHILDREN'S HOSPITAL 1 CHILDREN'S WAY, SLOT 301 LITTLE ROCK AR 72202 PULASKI (501) 364-1100 Childrens Voluntary non-profit - Private TRUE 34.7428220 -92.2920060 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-p66z~xhi7.pxk4 43300 660352 2019-12-03 2019-06-30 153 26 30 10   104 336               336
3604 3604 WESTCHESTER MEDICAL CENTER 100 WOODS RD VALHALLA NY 10595 WESTCHESTER (914) 493-7000 Acute Care Hospitals Government - Hospital District or Authority TRUE 41.0876800 -73.8038970 0   119 36 36119 35620 New York-Newark, NY-NJ-CT-PA Central Westchester County https://data.medicare.gov/resource/xubh-q36u/row-xkhz-jkc9_u59t 330234 650318 2019-06-21 2018-12-31 550 66 15 10   49 708 141 36           885
3673 3673 NORTH COLORADO MEDICAL CENTER 1801 - 16TH ST GREELEY CO 80631 WELD (970) 810-4121 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4138340 -104.7094290 0   123 8 8123 24540 Denver-Aurora, CO Central Weld County https://data.medicare.gov/resource/xubh-q36u/row-b7wk~gizs_ie2f 60001 649545 2019-06-03 2018-12-31 199 16   10     225               225
4138 4138 UNIVERSITY OF MICHIGAN HEALTH SYSTEM 1500 E MEDICAL CENTER DRIVE, SPC 5474 ANN ARBOR MI 48109 WASHTENAW (734) 764-1505 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.2853400 -83.7290400 0   161 26 26161 11460 Detroit-Warren-Ann Arbor, MI Central Washtenaw County https://data.medicare.gov/resource/xubh-q36u/row-4jqn-utws_26e7 230046 659809 2019-11-26 2019-06-30 718 20 10 10     931 43 32           1006
4199 4199 MEMORIAL MEDICAL CENTER 701 N FIRST ST SPRINGFIELD IL 62702 SANGAMON (217) 788-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8087780 -89.6545860 0   167 17 17167 44100 Springfield-Jacksonville-Lincoln, IL Central Sangamon County https://data.medicare.gov/resource/xubh-q36u/row-pnue~2mxb_uc9u 140148 645540 2019-03-04 2018-09-30 352 38   10     400 36 30           466
4713 4713 JOHNS HOPKINS BAYVIEW MEDICAL CENTER 4940 EASTERN AVENUE BALTIMORE MD 21224 BALTIMORE CITY (410) 550-0123 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.2872850 -76.5521340 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-tsuu-47er~ackm 210029 661192 2019-11-26 2019-06-30 332 22 12 10 10 25 411               411

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