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

18 rows where fy_end_date = "2018-07-31" and hospital_type = "Acute Care Hospitals"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_ownership, geocode_flag, geocode_accuracy, countyfips, statefips, csatitle, centraloutlyingcounty, filed_date, icu_beds, coronary_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)

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
697 697 PARKLAND MEDICAL CENTER 1 PARKLAND DRIVE DERRY NH 3038 ROCKINGHAM (603) 421-2100 Acute Care Hospitals Proprietary TRUE 42.8758250 -71.3175780 0   15 33 33015 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Rockingham County https://data.medicare.gov/resource/xubh-q36u/row-m9nh.dqhg_kjyp 300017 659515 2019-11-07 2018-07-31 60 8         68 18             86
731 731 DORMINY MEDICAL CENTER 200 PERRY HOUSE ROAD, BOX 1447 FITZGERALD GA 31750 BEN HILL (229) 424-7100 Acute Care Hospitals Government - Local TRUE 31.6979180 -83.2609750 0   17 13 13017 22340   Central Ben Hill County https://data.medicare.gov/resource/xubh-q36u/row-x5tq.yugi-ym8v 110073 658241 2019-01-02 2018-07-31 43 5         48 12             60
823 823 CLARK MEMORIAL HEALTH 1220 MISSOURI AVE JEFFERSONVILLE IN 47130 CLARK (812) 283-2147 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.2827840 -85.7492480 0   19 18 18019 31140 Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-99py-itd8.dhfq 150009 656628 2019-05-09 2018-07-31 128 22 3       153 15             168
2530 2530 FRANKFORT REGIONAL MEDICAL CENTER 299 KINGS DAUGHTERS DRIVE FRANKFORT KY 40601 FRANKLIN (502) 875-5240 Acute Care Hospitals Proprietary TRUE 38.1597740 -84.9057530 0   73 21 21073 23180 Lexington-Fayette--Richmond--Frankfort, KY Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-iiuj~fp2r_ghys 180127 657103 2019-06-24 2018-07-31 102 10       4 116 12             128
2741 2741 ADVENTHEALTH OCALA 1500 SW 1ST AVE OCALA FL 34474 MARION (352) 351-7200 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.1742360 -82.1378340 0   83 12 12083 36100   Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-5mfq.kkk3.z2w9 100062 644236 2019-01-29 2018-07-31 369 44         413               413
2844 2844 WATSONVILLE COMMUNITY HOSPITAL 75 NIELSON STREET WATSONVILLE CA 95076 SANTA CRUZ (831) 724-4741 Acute Care Hospitals Proprietary TRUE 36.9282800 -121.7937210 0   87 6 6087 42100 San Jose-San Francisco-Oakland, CA Central Santa Cruz County https://data.medicare.gov/resource/xubh-q36u/row-wbga.ap2u-4y8h 50194 656871 2019-08-22 2018-07-31 90 6         106               106
2866 2866 HAYWOOD REGIONAL MEDICAL CENTER 262 LEROY GEORGE DRIVE CLYDE NC 28721 HAYWOOD (828) 456-7311 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.5278560 -82.9454370 0   87 37 37087 11700 Asheville-Brevard, NC Central Haywood County https://data.medicare.gov/resource/xubh-q36u/row-va55-s4tn.af57 340184 658543 2019-05-09 2018-07-31 110 12         122 16             138
2907 2907 ST CHARLES PARISH HOSPITAL 1057 PAUL MAILLARD ROAD LULING LA 70070 ST. CHARLES (985) 785-3644 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.9245130 -90.3717510 0   89 22 22089 35380 New Orleans-Metairie-Hammond, LA-MS Central St. Charles Parish https://data.medicare.gov/resource/xubh-q36u/row-jwzr_ckt6~ux2m 190079 661901 2018-12-21 2018-07-31 31 8         39 20             59
3033 3033 PHOEBE PUTNEY MEMORIAL HOSPITAL 417 THIRD AVENUE ALBANY GA 31703 DOUGHERTY (229) 312-4068 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.5902290 -84.1562670 0   95 13 13095 10500   Central Dougherty County https://data.medicare.gov/resource/xubh-q36u/row-97aw-8gyu-wg2w 110007 658211 2019-07-05 2018-07-31 332 50       27 409 15 25           461
3172 3172 HARRIS REGIONAL HOSPITAL 68 HOSPITAL RD SYLVA NC 28779 JACKSON (828) 586-7000 Acute Care Hospitals Proprietary TRUE 35.3839230 -83.2027900 0   99 37 37099 19000   Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-xxmc~xtb8_wjsz 340016 658527 2019-05-09 2018-07-31 73 9         82               82
3533 3533 BYRD REGIONAL HOSPITAL 1020 FERTITTA BLVD LEESVILLE LA 71446 VERNON (337) 239-9041 Acute Care Hospitals Proprietary TRUE 31.1373240 -93.2687910 0   115 22 22115 22860 DeRidder-Fort Polk South, LA Central Vernon Parish https://data.medicare.gov/resource/xubh-q36u/row-strz-rejf.3ijm 190164 643212 2019-02-11 2018-07-31 45 7         52               52
3595 3595 MINDEN MEDICAL CENTER NO 1 MEDICAL PLAZA MINDEN LA 71055 WEBSTER (318) 377-2321 Acute Care Hospitals Proprietary TRUE 32.6172391 -93.2863556 1 ROOFTOP 119 22 22119 43340   Outlying Webster Parish https://data.medicare.gov/resource/xubh-q36u/row-zn8k~yqhx.sjt5 190144 657128 2019-01-03 2018-07-31 113 10         125 20 12           157
3625 3625 COOSA VALLEY MEDICAL CENTER 315 W HICKORY ST SYLACAUGA AL 35150 TALLADEGA (256) 249-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.1646660 -86.2545980 0   121 1 1121 45180 Birmingham-Hoover-Talladega, AL Central Talladega County https://data.medicare.gov/resource/xubh-q36u/row-uqj6-bzwc~56ip 10164 659174 2018-12-26 2018-07-31 114 8         122 15     35 50     222
3928 3928 LAS PALMAS MEDICAL CENTER 1801 NORTH OREGON STREET EL PASO TX 79902 EL PASO (915) 521-1200 Acute Care Hospitals Proprietary TRUE 31.7704830 -106.4987530 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-ay4n-jgmd_mzpr 450107 662079 2019-08-29 2018-07-31 377 64       55 496   63           559
4249 4249 ASCENSION VIA CHRISTI HOSPITAL ST. TERESA, INC. 14800 WEST ST TERESA WICHITA KS 67235 SEDGWICK (316) 796-7800 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.7250450 -97.5137860 0   173 20 20173 48620 Wichita-Arkansas City-Winfield, KS Central Sedgwick County https://data.medicare.gov/resource/xubh-q36u/row-8pe2-i236~vmyi 170200 657087 2019-01-02 2018-07-31 33 6         39   18           57
4421 4421 PARK PLAZA HOSPITAL 1313 HERMANN DR HOUSTON TX 77004 HARRIS (713) 527-5019 Acute Care Hospitals Proprietary TRUE 29.7223750 -95.3880450 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-dstj_s4k4.df5s 450659 657538 2019-08-26 2018-07-31 119 14         133               133
4531 4531 PHOEBE SUMTER MEDICAL CENTER 126 HIGHWAY 280 W AMERICUS GA 31719 SUMTER (229) 931-1280 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.0642500 -84.2553760 0   261 13 13261 11140   Central Sumter County https://data.medicare.gov/resource/xubh-q36u/row-vsiw~isbg~xz6s 110044 658233 2018-12-28 2018-07-31 44   10       54               54
4601 4601 UT HEALTH EAST TEXAS CARTHAGE HOSPITAL 409 COTTAGE RD CARTHAGE TX 75633 PANOLA (093) 693-3841 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.1671260 -94.3460390 0   365 48 48365         https://data.medicare.gov/resource/xubh-q36u/row-tyuw-zwkq.zq2r 450210 640322 2018-12-28 2018-07-31 42           42               42

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