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

15 rows where "filed_date" is on date 2019-03-04 and hospital_ownership = "Voluntary non-profit - Private"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, geocode_flag, geocode_accuracy, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, fy_end_date, acute_beds, icu_beds, burn_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, oth_longterm_beds, all_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
63 63 STAMFORD HOSPITAL ONE HOSPITAL PLAZA STAMFORD CT 6904 FAIRFIELD (203) 276-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0544448 -73.5522909 1 ROOFTOP 1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-z4bk-5sz6.bqpu 70006 644101 2019-03-04 2018-09-30 252 36         288   17           305
179 179 HOULTON REGIONAL HOSPITAL 20 HARTFORD STREET HOULTON ME 4730 AROOSTOOK (207) 532-2900 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1329620 -67.8426440 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-tx6y-y4iu-nd9t 201308 645561 2019-03-04 2018-09-30 25           25               25
309 309 ALLEGHANY COUNTY MEMORIAL HOSPITAL 617 DOCTORS STREET SPARTA NC 28675 ALLEGHANY (336) 372-5511 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.5095115 -81.1150447 1 RANGE_INTERPOLATED 5 37 37005         https://data.medicare.gov/resource/xubh-q36u/row-zjv8.p46n-e733 341320 645140 2019-03-04 2018-09-30 25           25               25
481 481 BRADLEY COUNTY MEDICAL CENTER 404 SOUTH BRADLEY STREET WARREN AR 71671 BRADLEY (870) 226-3731 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.6105380 -92.0586650 0   11 5 5011         https://data.medicare.gov/resource/xubh-q36u/row-ga7d-t3u8~gykp 41327 644212 2019-03-04 2018-09-30 25           25 10             35
865 865 NORTH COUNTRY HOSPITAL AND HEALTH CENTER 189 PROUTY DRIVE NEWPORT VT 5855 ORLEANS (802) 334-7331 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9546140 -72.2003390 0   19 50 50019         https://data.medicare.gov/resource/xubh-q36u/row-ipgf_5jyr.qb5v 471304 645803 2019-03-04 2018-09-30 20 5         25               25
1232 1232 METHODIST HOSPITAL OF CHICAGO 5025 N PAULINA STREET CHICAGO IL 60640 COOK (773) 271-9040 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9732620 -87.6711410 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-iv7k_hinv.nxvu 140197 645542 2019-03-04 2018-09-30 136 9         145               145
1330 1330 WOMANS HOSPITAL 100 WOMAN'S WAY BATON ROUGE LA 70817 E. BATON ROUGE (225) 927-1300 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4088600 -91.0310200 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-n9vu.wxmz_qfwr 190128 644733 2019-03-04 2018-09-30 140 4       84 228               228
2569 2569 IROQUOIS MEMORIAL HOSPITAL 200 FAIRMAN STREET WATSEKA IL 60970 IROQUOIS (815) 432-5201 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7655410 -87.7326660 0   75 17 17075         https://data.medicare.gov/resource/xubh-q36u/row-2e44.299n~22z8 140167 645541 2019-03-04 2018-09-30 25           25       35   1   61
2787 2787 MIDWEST MEDICAL CENTER 1 MEDICAL CENTER DRIVE GALENA IL 61036 JO DAVIESS (815) 777-1340 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.4466220 -90.4569720 0   85 17 17085         https://data.medicare.gov/resource/xubh-q36u/row-gqwe-keau_be9a 141302 645763 2019-03-04 2018-09-30 25           25       5   52   82
2925 2925 WILLIAMSBURG REGIONAL HOSPITAL 500 NELSON BOULEVARD KINGSTREE SC 29556 WILLIAMSBURG (843) 355-8888 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.6606660 -79.8202390 0   89 45 45089         https://data.medicare.gov/resource/xubh-q36u/row-7x78.i9ew-8k26 421303 645445 2019-03-04 2018-09-30 21 4         25               25
3043 3043 MILLE LACS HEALTH SYSTEM 200 NORTH ELM STREET ONAMIA MN 56359 MILLE LACS (320) 532-3154 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.0724670 -93.6618230 0   95 27 27095 33460 Minneapolis-St. Paul, MN-WI Outlying Mille Lacs County https://data.medicare.gov/resource/xubh-q36u/row-akw3_c4ae~5vtw 241356 645771 2019-03-04 2018-09-30 28           28 10     57       95
3452 3452 REEDSBURG AREA MEDICAL CENTER 2000 N DEWEY AVE REEDSBURG WI 53959 SAUK (608) 524-6487 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.5492870 -89.9945480 0   111 55 55111 12660 Madison-Janesville-Beloit, WI Central Sauk County https://data.medicare.gov/resource/xubh-q36u/row-ffr4.2rxx_5fnq 521351 645872 2019-03-04 2018-09-30 21 4         25               25
3485 3485 PAWHUSKA HOSPITAL, INC 1101 EAST 15TH STREET PAWHUSKA OK 74056 OSAGE (918) 287-3232 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.6728510 -96.3257580 0   113 40 40113 46140 Tulsa-Muskogee-Bartlesville, OK Central Osage County https://data.medicare.gov/resource/xubh-q36u/row-hgmu~bcvs-2zwc 371309 644172 2019-03-04 2018-09-30 25           25               25
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
4557 4557 BAYLOR SCOTT & WHITE MEDICAL CENTER - LLANO 200 W OLLIE LLANO TX 78643 LLANO (325) 247-5040 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.7433450 -98.6779960 0   299 48 48299         https://data.medicare.gov/resource/xubh-q36u/row-f5ig_zcze-hhqw 450219 657514 2019-03-04 2018-08-31 25           25               25

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