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

23 rows where "filed_date" is on date 2019-03-01 and hospital_ownership = "Proprietary"

✎ 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, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_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
133 133 SOUTH BALDWIN REGIONAL MEDICAL CENTER 1613 NORTH MCKENZIE STREET FOLEY AL 36535 BALDWIN (251) 949-3400 Acute Care Hospitals Proprietary TRUE 30.4261090 -87.6831870 0   3 1 1003 19300 Mobile-Daphne-Fairhope, AL Central Baldwin County https://data.medicare.gov/resource/xubh-q36u/row-pyt4.i3a3.r8cm 10083 645389 2019-03-01 2018-09-30 82 30         112               112
517 517 MONADNOCK COMMUNITY HOSPITAL 452 OLD STREET ROAD PETERBOROUGH NH 3458 HILLSBOROUGH (603) 924-7191 Critical Access Hospitals Proprietary TRUE 42.8934610 -71.9374710 0   11 33 33011 31700 Boston-Worcester-Providence, MA-RI-NH-CT Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-mhsm~xuaz.m9jn 301309 645432 2019-03-01 2018-09-30 25           25               25
548 548 REGIONAL MEDICAL CENTER OF CENTRAL ALABAMA 29 L V STABLER DRIVE GREENVILLE AL 36037 BUTLER (334) 382-2200 Acute Care Hospitals Proprietary TRUE 31.8294500 -86.6458600 0   13 1 1013         https://data.medicare.gov/resource/xubh-q36u/row-ca8j-ucpx~zp9d 10150 645390 2019-03-01 2018-09-30 37 7         44 13             57
599 599 NORTHEAST GEORGIA MEDICAL CENTER BARROW 316 NORTH BROAD STREET WINDER GA 30680 BARROW (770) 848-8611 Acute Care Hospitals Proprietary TRUE 34.0077010 -83.7067060 0   13 13 13013 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Barrow County https://data.medicare.gov/resource/xubh-q36u/row-hr24_ckbz~3ykf 110045 644713 2019-03-01 2018-09-30 50 6         56               56
634 634 MEMORIAL MEDICAL CENTER 2450 SOUTH TELSHOR BLVD LAS CRUCES NM 88011 DONA ANA (575) 522-8641 Acute Care Hospitals Proprietary TRUE 32.2919930 -106.7350180 0   13 35 35013 29740 El Paso-Las Cruces, TX-NM Central Doña Ana County https://data.medicare.gov/resource/xubh-q36u/row-ecy9~459r.3ez3 320018 646297 2019-03-01 2018-09-30 171 28         199               199
657 657 BAYFRONT HEALTH PUNTA GORDA 809 E MARION AVE PUNTA GORDA FL 33950 CHARLOTTE (941) 639-3131 Acute Care Hospitals Proprietary TRUE 26.9406820 -82.0417880 0   15 12 12015 39460 North Port-Sarasota, FL Central Charlotte County https://data.medicare.gov/resource/xubh-q36u/row-9zqr-j2tf~pweh 100047 645396 2019-03-01 2018-09-30 114 10         124 52             176
1083 1083 ADCARE HOSPITAL OF WORCESTER INC 107 LINCOLN STREET WORCESTER MA 1605 WORCESTER (508) 799-9000 Acute Care Hospitals Proprietary FALSE 42.2761820 -71.7955760 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-rnsb.iihy_fs75 220062 645423 2019-03-01 2018-09-30 114           114               114
1294 1294 CARTERET GENERAL HOSPITAL 3500 ARENDELL ST MOREHEAD CITY NC 28557 CARTERET (252) 808-6000 Acute Care Hospitals Proprietary TRUE 34.7248140 -76.7541300 0   31 37 37031 33980 New Bern-Morehead City, NC Central Carteret County https://data.medicare.gov/resource/xubh-q36u/row-uiyb~9g3i~mjnw 340142 645137 2019-03-01 2018-09-30 91 8         99               99
1331 1331 UNITED MEDICAL CENTER 1310 SOUTHERN AVENUE SE WASHINGTON DC 20032 THE DISTRICT (202) 574-6611 Acute Care Hospitals Proprietary TRUE 38.8341550 -76.9846980 0   33 24 24033 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Prince George's County https://data.medicare.gov/resource/xubh-q36u/row-zng6.qzhh.7sfd 90008 645634 2019-03-01 2018-09-30 180 16         196               196
1592 1592 MERCY REGIONAL MEDICAL CENTER 800 E MAIN VILLE PLATTE LA 70586 EVANGELINE (337) 363-5684 Acute Care Hospitals Proprietary TRUE 30.6849310 -92.2659730 0   39 22 22039         https://data.medicare.gov/resource/xubh-q36u/row-2sdk.fhzr.wwum 190167 645559 2019-03-01 2018-09-30 85 14         99   10           109
1642 1642 FAYETTE REGIONAL HEALTH SYSTEM 1941 VIRGINIA AVE CONNERSVILLE IN 47331 FAYETTE (765) 825-5131 Acute Care Hospitals Proprietary TRUE 39.6559200 -85.1319840 0   41 18 18041 18220 Richmond-Connersville, IN Central Fayette County https://data.medicare.gov/resource/xubh-q36u/row-eksi_yzpc.5837 150064 645404 2019-03-01 2018-09-30 25 20         45 12             57
1672 1672 COLLEGE STATION MEDICAL CENTER 1604 ROCK PRAIRIE ROAD COLLEGE STATION TX 77842 BRAZOS (979) 764-5151 Acute Care Hospitals Proprietary TRUE 30.5826260 -96.2910140 0   41 48 48041 17780   Central Brazos County https://data.medicare.gov/resource/xubh-q36u/row-kw5b_vp92-tdms 450299 645732 2019-03-01 2018-09-30 102 12         114               114
1786 1786 MERIT HEALTH BILOXI 150 REYNOIR STREET BILOXI MS 39530 HARRISON (228) 436-1104 Acute Care Hospitals Proprietary TRUE 30.3961120 -88.8904380 0   47 28 28047 25060   Central Harrison County https://data.medicare.gov/resource/xubh-q36u/row-had8.h2gv_r2ex 250007 645573 2019-03-01 2018-09-30 147 18         165 12             177
1875 1875 BROWNWOOD REGIONAL MEDICAL CENTER 1501 BURNET DR BROWNWOOD TX 76801 BROWN (325) 646-8541 Acute Care Hospitals Proprietary TRUE 31.6802110 -98.9881580 0   49 48 48049 15220   Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-mwhq-a826-mmad 450587 645612 2019-03-01 2018-09-30 65 12         77               77
2383 2383 FLOWERS HOSPITAL 4370 WEST MAIN STREET DOTHAN AL 36305 HOUSTON (334) 793-5000 Acute Care Hospitals Proprietary TRUE 31.2359910 -85.4579370 0   69 1 1069 20020 Dothan-Enterprise-Ozark, AL Central Houston County https://data.medicare.gov/resource/xubh-q36u/row-i7jd_zyzr.7uv6 10055 645037 2019-03-01 2018-09-30 203 26         235               235
3050 3050 LEE'S SUMMIT MEDICAL CENTER 2100 SE BLUE PARKWAY LEES SUMMIT MO 64063 JACKSON (816) 282-5000 Acute Care Hospitals Proprietary TRUE 38.9022850 -94.3321510 0   95 29 29095 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-4563.d7dj_x9m5 260190 645575 2019-03-01 2018-09-30 70 10         80               80
3348 3348 LAFAYETTE REGIONAL HEALTH CENTER 1500 STATE STREET LEXINGTON MO 64067 LAFAYETTE (660) 259-2203 Critical Access Hospitals Proprietary TRUE 39.1891460 -93.8770650 0   107 29 29107 28140 Kansas City-Overland Park-Kansas City, MO-KS Outlying Lafayette County https://data.medicare.gov/resource/xubh-q36u/row-sn6v-86t8~7h98 261320 645576 2019-03-01 2018-09-30 23 2         25               25
3412 3412 COMMONWEALTH HEALTH CENTER 1 LOWER NAVY HILL ROAD (PO BOX 409CK) GARAPAN MP 96950 SAIPAN (670) 234-8950 Acute Care Hospitals Proprietary TRUE 15.2086299 145.7303467 1 GEOMETRIC_CENTER 110 69 69110         https://data.medicare.gov/resource/xubh-q36u/row-z8uz.de7b_sx86 660001 644688 2019-03-01 2018-09-30 70 4         74               74
3662 3662 BAYLOR SCOTT AND WHITE MEDICAL CENTER CARROLLTON 4343 NORTH JOSEY LANE CARROLLTON TX 75010 DENTON (972) 394-2255 Acute Care Hospitals Proprietary FALSE 33.0289660 -96.8839500 0   121 48 48121 19100 Dallas-Fort Worth, TX-OK Outlying Denton County https://data.medicare.gov/resource/xubh-q36u/row-5qkb_cw98-y3cm 450730 644372 2019-03-01 2018-09-30 73 16         94               94
3801 3801 HEALTHMARK REGIONAL MEDICAL CENTER 4413 US HWY 331 S DEFUNIAK SPRINGS FL 32435 WALTON (850) 951-4500 Acute Care Hospitals Proprietary TRUE 30.6587420 -86.1191880 0   131 12 12131 18880   Central Walton County https://data.medicare.gov/resource/xubh-q36u/row-esxw~eejr-faw4 100081 644706 2019-03-01 2018-09-30 44 6         50               50
4285 4285 BLUFFTON REGIONAL MEDICAL CENTER 303 S MAIN ST BLUFFTON IN 46714 WELLS (260) 824-3210 Acute Care Hospitals Proprietary TRUE 40.7376450 -85.1714940 0   179 18 18179 23060 Fort Wayne-Huntington-Auburn, IN Outlying Wells County https://data.medicare.gov/resource/xubh-q36u/row-7d75-xz4v.txjj 150075 645405 2019-03-01 2018-09-30 55 7         62       13       75
4319 4319 LONGVIEW REGIONAL MEDICAL CENTER 2901 N FOURTH ST LONGVIEW TX 75605 GREGG (903) 758-1818 Acute Care Hospitals Proprietary TRUE 32.5322010 -94.7288140 0   183 48 48183 30980 Longview-Marshall, TX Central Gregg County https://data.medicare.gov/resource/xubh-q36u/row-ge6d~6trv.jdbj 450702 645613 2019-03-01 2018-09-30 179 24         224               224
4691 4691 LAREDO MEDICAL CENTER 1700 EAST SAUNDERS LAREDO TX 78044 WEBB (956) 796-5000 Acute Care Hospitals Proprietary TRUE 27.5306000 -99.4785710 0   479 48 48479 29700   Central Webb County https://data.medicare.gov/resource/xubh-q36u/row-qxph_4v72_5xf8 450029 645610 2019-03-01 2018-09-30 235 32         284       18       302

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