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-05-30 and hospital_ownership = "Voluntary non-profit - Other"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, coronary_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
8 8 ADVOCATE TRINITY HOSPITAL 2320 E 93RD ST CHICAGO IL 60617 COOK (773) 967-5002 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.7262110 -87.5672500 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-wz9w.j9tr_sabj 140048 650686 2019-05-30 2018-12-31 177 24         201               201
219 219 LIMA MEMORIAL HEALTH SYSTEM 1001 BELLEFONTAINE AVENUE LIMA OH 45804 ALLEN (419) 226-3335 Acute Care Hospitals Voluntary non-profit - Other FALSE 40.7356020 -84.0877130 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-p8qs-v8mw~whtd 360009 648963 2019-05-30 2018-12-31 123 16 16       155   17           172
290 290 ALLEGAN GENERAL HOSPITAL 555 LINN STREET ALLEGAN MI 49010 ALLEGAN (269) 686-4101 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.5202590 -85.8569390 0   5 26 26005 26090 Grand Rapids-Wyoming-Muskegon, MI Central Allegan County https://data.medicare.gov/resource/xubh-q36u/row-9kac~4r3i~rk7m 231328 649266 2019-05-30 2018-12-31 25           25               25
590 590 JOHN MUIR MEDICAL CENTER - WALNUT CREEK CAMPUS 1601 YGNACIO VALLEY RD WALNUT CREEK CA 94598 CONTRA COSTA (925) 939-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.9142970 -122.0420710 0   13 6 6013 41860 San Jose-San Francisco-Oakland, CA Outlying Contra Costa County https://data.medicare.gov/resource/xubh-q36u/row-uuns~9ybk_k8ca 50180 650563 2019-05-30 2018-12-31 391 55       60 506   48           554
631 631 SAINT BARNABAS MEDICAL CENTER 94 OLD SHORT HILLS ROAD LIVINGSTON NJ 7039 ESSEX (973) 322-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.7640450 -74.3023340 0   13 34 34013 35620 New York-Newark, NY-NJ-CT-PA Central Essex County https://data.medicare.gov/resource/xubh-q36u/row-wmjt.uit8.jq23 310076 649051 2019-05-30 2018-12-31 440 46 10     56 552               552
1415 1415 METROHEALTH SYSTEM 2500 METROHEALTH DRIVE CLEVELAND OH 44109 CUYAHOGA (216) 778-7089 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.4622390 -81.6979280 0   35 39 39035 17460 Cleveland-Akron-Canton, OH Central Cuyahoga County https://data.medicare.gov/resource/xubh-q36u/row-tmz3-anq4-3mgv 360059 648966 2019-05-30 2018-12-31 400 28 16 14     528 20 67   4       619
1754 1754 CROZER CHESTER MEDICAL CENTER ONE MEDICAL CENTER BOULEVARD UPLAND PA 19013 DELAWARE (610) 447-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.8559248 -75.3692897 1 ROOFTOP 45 42 42045 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Delaware County https://data.medicare.gov/resource/xubh-q36u/row-n43i.tyzh.5v4t 390180 649488 2019-05-30 2018-12-31 287 25 15 14   18 359 52 38       10   459
1897 1897 FAYETTE COUNTY HOSPITAL 7TH AND TAYLOR VANDALIA IL 62471 FAYETTE (618) 283-1231 Critical Access Hospitals Voluntary non-profit - Other TRUE 38.9706410 -89.0988780 1 GEOMETRIC_CENTER 51 17 17051         https://data.medicare.gov/resource/xubh-q36u/row-3m36-npvv-f9tn 141346 648907 2019-05-30 2018-12-31 25 4         29       85       114
2054 2054 SHRINERS HOSPITALS FOR CHILDREN-TAMPA 12502 USF PINE DR TAMPA FL 33612 HILLSBOROUGH (813) 972-2250 Childrens Voluntary non-profit - Other FALSE 28.0603710 -82.4229680 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-u3s8~6bbc_882j 103303 659465 2019-05-30 2018-12-31                              
2495 2495 HOLY FAMILY MEMORIAL 2300 WESTERN AVE MANITOWOC WI 54221 MANITOWOC (920) 320-2011 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.0944100 -87.6768650 0   71 55 55071 31820   Central Manitowoc County https://data.medicare.gov/resource/xubh-q36u/row-3t2y-xqgp.yeuz 520107 650622 2019-05-30 2018-12-31 48 10         58               58
3257 3257 ADVENTHEALTH NORTH PINELLAS 1395 S PINELLAS AVE TARPON SPRINGS FL 34689 PINELLAS (727) 942-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 28.1331400 -82.7585760 0   103 12 12103 45300   Central Pinellas County https://data.medicare.gov/resource/xubh-q36u/row-fea3-vbec-qidb 100055 649410 2019-05-30 2018-12-31 123 13         136       32       168
3331 3331 SSM HEALTH ST MARY'S HOSPITAL - JANESVILLE 3400 EAST RACINE STREET JANESVILLE WI 53546 ROCK (608) 373-8000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.6709820 -88.9760750 0   105 55 55105 27500 Madison-Janesville-Beloit, WI Central Rock County https://data.medicare.gov/resource/xubh-q36u/row-ded9.rse4~fbnh 520208 650625 2019-05-30 2018-12-31 44 6         50               50
4059 4059 LAKEWOOD HEALTH SYSTEM 49725 COUNTY ROAD 83 STAPLES MN 56479 TODD (218) 894-1515 Critical Access Hospitals Voluntary non-profit - Other TRUE 46.3508690 -94.7483930 0   153 27 27153         https://data.medicare.gov/resource/xubh-q36u/row-vn9e~m7ke-5ysu 241329 650720 2019-05-30 2018-12-31 22 3         25 10     100       135
4189 4189 MAYO CLINIC HEALTH SYSTEM - ST JAMES 1101 MOULTON AND PARSONS DRIVE ST JAMES MN 56081 WATONWAN (507) 375-8601 Critical Access Hospitals Voluntary non-profit - Other FALSE 43.9694900 -94.6215150 0   165 27 27165         https://data.medicare.gov/resource/xubh-q36u/row-iach_4kbz_5xj2 241333 649779 2019-05-30 2018-12-31 25           25               25
4552 4552 UPSON REGIONAL MEDICAL CENTER 801 W GORDON STREET THOMASTON GA 30286 UPSON (706) 647-8111 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.8872520 -84.3361090 0   293 13 13293 45580 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Upson County https://data.medicare.gov/resource/xubh-q36u/row-f57v_e6uf_3ezw 110002 651193 2019-05-30 2018-12-31 59 28         87 18             105

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