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-03-04 and hospital_ownership = "Government - Hospital District or Authority"

✎ 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, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, skilled_nursing_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
889 889 MEDICAL CENTER, NAVICENT HEALTH (THE) 777 HEMLOCK STREET MACON GA 31201 BIBB (478) 633-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.8332020 -83.6365530 0   21 13 13021 31420 Macon-Warner Robins, GA Central Bibb County https://data.medicare.gov/resource/xubh-q36u/row-qa2j~4dhx.y2zw 110107 645712 2019-03-04 2018-09-30 453 77       64 594 16             610
901 901 MAYO REGIONAL HOSPITAL 897 WEST MAIN STREET DOVER FOXCROFT ME 4426 PISCATAQUIS (207) 564-4251 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.1865560 -69.2377980 0   21 23 23021         https://data.medicare.gov/resource/xubh-q36u/row-zhbf-zz89~t9dz 201309 645562 2019-03-04 2018-09-30 25           25               25
2536 2536 JOHNSON MEMORIAL HOSPITAL 1282 WALNUT STREET DAWSON MN 56232 LAC QUI PARLE (320) 769-4323 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.9309710 -96.0670630 0   73 27 27073         https://data.medicare.gov/resource/xubh-q36u/row-aiqt_9tq3~e2sg 241314 643711 2019-03-04 2018-09-30 20           20       56       76
2767 2767 CASCADE MEDICAL CENTER 402 LAKE CASCADE PARKWAY CASCADE ID 83611 VALLEY (208) 382-4242 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.5179210 -116.0489380 0   85 16 16085         https://data.medicare.gov/resource/xubh-q36u/row-8r6g.s3au-3yid 131308 644833 2019-03-04 2018-09-30 8           8               8
2935 2935 BRYAN W. WHITFIELD MEMORIAL HOSPITAL 105 HIGHWAY 80 EAST DEMOPOLIS AL 36732 MARENGO (334) 289-4000 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.5036760 -87.8367440 0   91 1 1091         https://data.medicare.gov/resource/xubh-q36u/row-eqeg.jsdy-rvpp 10112 645707 2019-03-04 2018-09-30 32 5         37 20             57
3068 3068 CONCHO COUNTY HOSPITAL 614 EAKER STREET EDEN TX 76837 CONCHO (915) 869-5911 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.2208850 -99.8478320 0   95 48 48095         https://data.medicare.gov/resource/xubh-q36u/row-gyb7_xqfh_6ezj 451325 643976 2019-03-04 2018-09-30 16           16               16
3145 3145 LAKESIDE MEDICAL CENTER 39200 HOOKER HWY BELLE GLADE FL 33430 PALM BEACH (561) 996-6571 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.7256840 -80.6700790 0   99 12 12099 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Palm Beach County https://data.medicare.gov/resource/xubh-q36u/row-vcv9~uwnp_a6fi 100130 644242 2019-03-04 2018-09-30 48 6         54               54
4236 4236 NORTHERN HOSPITAL OF SURRY COUNTY 830 ROCKFORD ST MOUNT AIRY NC 27030 SURRY (336) 719-7000 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.4884180 -80.6111810 0   171 37 37171 34340 Greensboro--Winston-Salem--High Point, NC Central Surry County https://data.medicare.gov/resource/xubh-q36u/row-t67h_ck7x_3fsi 340003 645130 2019-03-04 2018-09-30 90 10         100       33       133
4452 4452 MONROE COUNTY HOSPITAL 88 MARTIN LUTHER KING JR DRIVE FORSYTH GA 31029 MONROE (478) 994-2521 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.0319810 -83.9464940 0   207 13 13207 31420 Macon-Warner Robins, GA Outlying Monroe County https://data.medicare.gov/resource/xubh-q36u/row-8ub4_vxra.n6a3 111318 645067 2019-03-04 2018-09-30 25           25               25
4491 4491 MEDICAL CENTER OF PEACH COUNTY, NAVICENT HEALTH 1960 HIGHWAY 247 CONNECTOR BYRON GA 31008 PEACH (478) 654-2000 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.6065680 -83.7584490 0   225 13 13225 47580 Macon-Warner Robins, GA Outlying Peach County https://data.medicare.gov/resource/xubh-q36u/row-diiq-qiab_fezm 111310 645065 2019-03-04 2018-09-30 25           25               25
4505 4505 PUTNAM GENERAL HOSPITAL 101 LAKE OCONEE PARKWAY EATONTON GA 31024 PUTNAM (706) 485-2711 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.3355190 -83.3708440 0   237 13 13237         https://data.medicare.gov/resource/xubh-q36u/row-dznu-rxmb.4s2q 111313 645066 2019-03-04 2018-09-30 25           25               25
4549 4549 LIBERTY DAYTON REGIONAL MEDICAL CENTER 1353 N TRAVIS ST LIBERTY TX 77575 LIBERTY (936) 336-7316 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.0685150 -94.7978880 0   291 48 48291 26420 Houston-The Woodlands, TX Outlying Liberty County https://data.medicare.gov/resource/xubh-q36u/row-mqxs.73v9-quxd 451375 651358 2019-03-04 2018-09-30 25           25               25
4615 4615 BALLINGER MEMORIAL HOSPITAL 608 AVENUE B BALLINGER TX 76821 RUNNELS (325) 365-2531 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.7498220 -99.9623020 0   399 48 48399         https://data.medicare.gov/resource/xubh-q36u/row-nqcy_n2re.zwit 451310 643973 2019-03-04 2018-09-30 16           16               16
4680 4680 RANKIN HOSPITAL MEDICAL CLINIC 1611 SPUR 576 RANKIN TX 79778 UPTON (432) 693-2443 Critical Access Hospitals Government - Hospital District or Authority FALSE 31.2335480 -101.9361780 1 ROOFTOP 461 48 48461         https://data.medicare.gov/resource/xubh-q36u/row-k6d6.95dp.xxq5 451329 643977 2019-03-04 2018-09-30 15           15               15

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