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

30 rows where "fy_end_date" is on date 2018-07-31

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: city, state, county_name, hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, filed_date, acute_beds, icu_beds, coronary_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, nursing_fac_beds, oth_longterm_beds, all_beds, filed_date (date)

fy_end_date (date) ✖

  • 2018-07-31 · 30 ✖
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
197 197 MESA VIEW REGIONAL HOSPITAL 1299 BERTHA HOWE AVENUE MESQUITE NV 89027 CLARK (702) 346-8040 Critical Access Hospitals Proprietary TRUE 36.8088590 -114.1144560 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-8rk4-cq3s_fa8n 291307 640239 2018-12-18 2018-07-31 21 4         25               25
560 560 HACIENDA CHILDREN'S HOSPITAL, INC. 610 WEST JEROME AVENUE MESA AZ 85210 MARICOPA (602) 243-4231 Childrens Proprietary FALSE 33.3811280 -111.8448920 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-r4wv.uiyn_d6cn 33303 654954 2018-11-26 2018-07-31                              
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
1654 1654 CALLAWAY DISTRICT HOSPITAL P O BOX 100, 211 E KIMBALL CALLAWAY NE 68825 CUSTER (308) 836-2228 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.2909887 -99.9242095 1 ROOFTOP 41 31 31041         https://data.medicare.gov/resource/xubh-q36u/row-nfg8_ccxm-ja7t 281335 660412 2019-01-02 2018-07-31 12           12               12
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
3185 3185 CORYELL MEMORIAL HEALTHCARE SYSTEM 1507 W MAIN STREET GATESVILLE TX 76528 CORYELL (254) 865-8251 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.4331520 -97.7788220 0   99 48 48099 28660   Central Coryell County https://data.medicare.gov/resource/xubh-q36u/row-ndki.wivs~b55z 451379 640181 2019-01-02 2018-07-31 21 4         25               25
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
3550 3550 CARLINVILLE AREA HOSPITAL 20733 N BROAD STREET CARLINVILLE IL 62626 MACOUPIN (217) 854-3141 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.2996420 -89.8816300 0   117 17 17117 41180 St. Louis-St. Charles-Farmington, MO-IL Outlying Macoupin County https://data.medicare.gov/resource/xubh-q36u/row-pxfs~3ysx~txi8 141347 640505 2019-01-07 2018-07-31 25           25               25
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
4004 4004 COMMUNITY MEDICAL CENTER, INC P O BOX 399, 3307 BARADA ST FALLS CITY NE 68355 RICHARDSON (402) 245-2428 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.0778770 -95.6075970 1 ROOFTOP 147 31 31147         https://data.medicare.gov/resource/xubh-q36u/row-xcna_pb8z-kjhc 281352 640654 2018-12-28 2018-07-31 24           24               24
4130 4130 RIVERVIEW REGIONAL MEDICAL CENTER 158 HOSPITAL DRIVE CARTHAGE TN 37030 SMITH (615) 735-9815 Critical Access Hospitals Proprietary TRUE 36.2636070 -85.9485560 0   159 47 47159 34980 Nashville-Davidson--Murfreesboro, TN Outlying Smith County https://data.medicare.gov/resource/xubh-q36u/row-rt2i~krrj-iike 441307 641882 2019-01-02 2018-07-31 23 2         25 10             35
4205 4205 RUSSELL REGIONAL HOSPITAL 200 S MAIN STREET RUSSELL KS 67665 RUSSELL (785) 483-3131 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.8832620 -98.8598360 0   167 20 20167         https://data.medicare.gov/resource/xubh-q36u/row-jqcp-w49x~7w2h 171350 640712 2019-01-03 2018-07-31 19           19           22   41
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
4257 4257 SWAIN COUNTY HOSPITAL 45 PLATEAU STREET BRYSON CITY NC 28713 SWAIN (828) 488-2155 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.4351230 -83.4446880 0   173 37 37173         https://data.medicare.gov/resource/xubh-q36u/row-xctq~5kw9.id78 341305 640115 2018-12-27 2018-07-31 24           24               24
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
4451 4451 COON MEMORIAL HOSPITAL 1411 DENVER AVENUE DALHART TX 79022 DALLAM (806) 244-4571 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.0515690 -102.5219060 0   205 48 48205         https://data.medicare.gov/resource/xubh-q36u/row-8mcz-n3gr~ux5g 451331 646182 2019-03-19 2018-07-31 21           21               21
4510 4510 SOUTHWEST GEORGIA REGIONAL MEDICAL CENTER 361 RANDOLPH STREET CUTHBERT GA 39840 RANDOLPH (229) 732-2181 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.7748230 -84.7936060 0   243 13 13243         https://data.medicare.gov/resource/xubh-q36u/row-9bkz.mqd7-hbvn 111300 641801 2019-01-02 2018-07-31 25           25       80       105
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
4573 4573 PHOEBE WORTH MEDICAL CENTER 807 SOUTH ISABELLA STREET SYLVESTER GA 31791 WORTH (229) 777-3851 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.5123850 -83.8406730 0   321 13 13321 10500   Outlying Worth County https://data.medicare.gov/resource/xubh-q36u/row-kvdr-2fup-rgie 111328 641024 2018-12-28 2018-07-31 25           25               25
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
);