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

17 rows where "filed_date" is on date 2019-02-28 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, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, coronary_beds, surg_icu_beds, oth_spec_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
186 186 MAGNOLIA REGIONAL HEALTH CENTER 611 ALCORN DRIVE CORINTH MS 38834 ALCORN (662) 293-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.9358670 -88.5586480 0   3 28 28003 18420   Central Alcorn County https://data.medicare.gov/resource/xubh-q36u/row-7e2c-erdj.3exa 250009 643795 2019-02-28 2018-09-30 139 24         163 19             182
395 395 UNIVERSITY OF VERMONT MEDICAL CENTER 111 COLCHESTER AVE BURLINGTON VT 5401 CHITTENDEN (802) 847-0000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.4809910 -73.1955180 0   7 50 50007 15540   Central Chittenden County https://data.medicare.gov/resource/xubh-q36u/row-sa3g~qvqf.2559 470003 643744 2019-02-28 2018-09-30 349 21     25   415   35           450
482 482 WILLIAM W BACKUS HOSPITAL 326 WASHINGTON ST NORWICH CT 6360 NEW LONDON (860) 889-8331 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.5434020 -72.0867470 0   11 9 9011 35980 Hartford-West Hartford, CT Central New London County https://data.medicare.gov/resource/xubh-q36u/row-x7iv~8mww_raqd 70024 645051 2019-02-28 2018-09-30 153 12         165 18             183
807 807 ST JOSEPH'S HOSPITAL 350 NORTH WILMOT ROAD TUCSON AZ 85711 PIMA (520) 873-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.2259460 -110.8578380 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-trzm-jqcs_wpf7 30011 644090 2019-02-28 2018-09-30 377 32       30 451 15 20           486
1084 1084 HEALTH ALLIANCE - CLINTON HOSPITAL 60 HOSPITAL ROAD LEOMINSTER MA 1453 WORCESTER (978) 466-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.5411930 -71.7630330 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-y6vw_ua5p.gsn5 220001 644639 2019-02-28 2018-09-30 120 10         130 20             150
1446 1446 JACKSON GENERAL HOSPITAL 122 PINNELL ST RIPLEY WV 25271 JACKSON (304) 372-2731 Critical Access Hospitals Voluntary non-profit - Other TRUE 38.8235410 -81.7283250 0   35 54 54035         https://data.medicare.gov/resource/xubh-q36u/row-qz6z~eyng~xsxm 511320 645206 2019-02-28 2018-09-30 25           25               25
1810 1810 COLUMBUS REGIONAL HEALTHCARE SYSTEM 500 JEFFERSON ST WHITEVILLE NC 28472 COLUMBUS (910) 642-8011 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.3386570 -78.6936440 0   47 37 37047         https://data.medicare.gov/resource/xubh-q36u/row-ucyn-b8wt_9jnp 340068 645347 2019-02-28 2018-09-30 144   10       154               154
1893 1893 HENDRY REGIONAL MEDICAL CENTER 524 W SAGAMORE AVE CLEWISTON FL 33440 HENDRY (863) 902-3033 Critical Access Hospitals Voluntary non-profit - Other TRUE 26.7532390 -80.9422760 0   51 12 12051 17500   Central Hendry County https://data.medicare.gov/resource/xubh-q36u/row-ati4-fhfd_57wb 101309 643695 2019-02-28 2018-09-30 22 3         25               25
2045 2045 FAYETTE MEDICAL CENTER 1653 TEMPLE AVENUE NORTH FAYETTE AL 35555 FAYETTE (205) 932-5966 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.7077080 -87.8237060 0   57 1 1057         https://data.medicare.gov/resource/xubh-q36u/row-f7kw.zhbj_gfwf 10045 644692 2019-02-28 2018-09-30 37 8         45       122       167
2513 2513 SCRIPPS GREEN HOSPITAL 10666 NORTH TORREY PINES ROAD LA JOLLA CA 92037 SAN DIEGO (858) 455-9100 Acute Care Hospitals Voluntary non-profit - Other FALSE 32.8971240 -117.2418540 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-k5xn~6853~5e64 50424 644216 2019-02-28 2018-09-30 100 24         150               150
2795 2795 KING'S DAUGHTERS MEDICAL CENTER-BROOKHAVEN P O BOX 948/427 HIGHWAY 51 NORTH BROOKHAVEN MS 39601 LINCOLN (601) 833-6011 Acute Care Hospitals Voluntary non-profit - Other TRUE 31.5892013 -90.4580392 1 ROOFTOP 85 28 28085 15020 Jackson-Vicksburg-Brookhaven, MS Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-5ntd-ntch~5mxf 250057 643905 2019-02-28 2018-09-30 85 5         90               90
2870 2870 UNION MEDICAL CENTER 322 WEST SOUTH STREET UNION SC 29379 UNION (864) 301-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.7114380 -81.6286680 0   87 45 45087 43900 Greenville-Spartanburg-Anderson, SC Outlying Union County https://data.medicare.gov/resource/xubh-q36u/row-a8su_cikk-4j4z 420108 645181 2019-02-28 2018-09-30 43 6         49               49
3459 3459 GULF BREEZE HOSPITAL 1110 GULF BREEZE PKWY GULF BREEZE FL 32561 SANTA ROSA (850) 934-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.3586490 -87.1568030 0   113 12 12113 37860   Central Santa Rosa County https://data.medicare.gov/resource/xubh-q36u/row-i236_mnds-pgjj 100266 646028 2019-02-28 2018-09-30 57 8         65               65
4082 4082 WEBSTER GENERAL HOSPITAL/ SWING BED 70 MEDICAL PLAZA EUPORA MS 39744 WEBSTER (662) 258-6221 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.5347360 -89.2669430 0   155 28 28155         https://data.medicare.gov/resource/xubh-q36u/row-a3qx_u9bd-sjek 250020 643797 2019-02-28 2018-09-30 38           38               38
4228 4228 TROUSDALE MEDICAL CENTER 500 CHURCH STREET HARTSVILLE TN 37074 TROUSDALE (615) 374-2221 Critical Access Hospitals Voluntary non-profit - Other TRUE 36.3881360 -86.1676920 0   169 47 47169 34980 Nashville-Davidson--Murfreesboro, TN Outlying Trousdale County https://data.medicare.gov/resource/xubh-q36u/row-b84v_4ggv_qpsn 441301 644183 2019-02-28 2018-09-30 25           25               25
4343 4343 WARREN MEMORIAL HOSPITAL 1000 NORTH SHENANDOAH AVE FRONT ROYAL VA 22630 WARREN (703) 636-0300 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9304150 -78.1989300 0   187 51 51187 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Outlying Warren County https://data.medicare.gov/resource/xubh-q36u/row-6zt4-iv48_jqpm 490033 645197 2019-02-28 2018-09-30 38 8         46       120       166
4406 4406 MISSOURI DELTA MEDICAL CENTER 1008 NORTH MAIN ST SIKESTON MO 63801 SCOTT (573) 471-1600 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.8890480 -89.5843460 0   201 29 29201 43460 Cape Girardeau-Sikeston, MO-IL Central Scott County https://data.medicare.gov/resource/xubh-q36u/row-gnum~mcff-uuan 260113 645121 2019-02-28 2018-09-30 98 12         110 12 11           133

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