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

34 rows where "filed_date" is on date 2019-12-02 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, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, 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, skilled_nursing_beds, nursing_fac_beds, oth_longterm_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
71 71 HOWARD UNIVERSITY HOSPITAL 2041 GEORGIA AVE NW WASHINGTON DC 20060 THE DISTRICT (202) 745-6100 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9170110 -77.0218960 0   1 11 11001 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central District of Columbia https://data.medicare.gov/resource/xubh-q36u/row-8v26.mgb3_zc6i 90003 660921 2019-12-02 2019-06-30 164 36         200               200
163 163 KAHUKU MEDICAL CENTER 56-117 PUALALEA STREET KAHUKU HI 96731 HONOLULU (808) 293-9221 Critical Access Hospitals Voluntary non-profit - Other TRUE 21.6764400 -157.9522110 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-gwji.69dv_68xy 121304 661306 2019-12-02 2019-06-30 15           15       6       21
180 180 UMD BALTIMORE WASHINGTON MEDICAL CENTER 301 HOSPITAL DRIVE GLEN BURNIE MD 21061 ANNE ARUNDEL (410) 595-1967 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.1387840 -76.6222470 0   3 24 24003 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Anne Arundel County https://data.medicare.gov/resource/xubh-q36u/row-ny53_dgkn_gitj 210043 659804 2019-12-02 2019-06-30 242 30         272               272
183 183 BERKSHIRE MEDICAL CENTER INC - 1 725 NORTH STREET PITTSFIELD MA 1201 BERKSHIRE (413) 447-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.4587480 -73.2490040 0   3 25 25003 38340   Central Berkshire County https://data.medicare.gov/resource/xubh-q36u/row-58b2-r4te.ddyn 220046 661336 2019-12-02 2018-09-30 201 20         221 40 14           275
224 224 ALLEGHENY VALLEY HOSPITAL 1301 CARLISLE ST NATRONA PA 15065 ALLEGHENY (412) 224-5100 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.6173780 -79.7371060 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-4dpd~v2eh.sr63 390032 660011 2019-12-02 2019-06-30 127 16         143 40 17           200
1004 1004 UMD UPPER CHESAPEAKE MEDICAL CENTER 500 UPPER CHESAPEAKE DRIVE BEL AIR MD 21014 HARFORD (443) 643-3303 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.5194690 -76.3483540 0   25 24 24025 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Outlying Harford County https://data.medicare.gov/resource/xubh-q36u/row-j67j_pem6-zmdu 210049 661904 2019-12-02 2019-06-30 135 14         149               149
1227 1227 WEST SUBURBAN MEDICAL CENTER 3 ERIE COURT OAK PARK IL 60302 COOK (708) 383-6200 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.8918400 -87.7774710 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-inku-rcmb~ijb5 140049 662038 2019-12-02 2019-04-30 114 21         135       39       174
1352 1352 PENN HIGHLANDS DUBOIS 100 HOSPITAL AVENUE DUBOIS PA 15801 CLEARFIELD (814) 371-2200 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.1143490 -78.7757360 0   33 42 42033 20180 State College-DuBois, PA Central Clearfield County https://data.medicare.gov/resource/xubh-q36u/row-sdwi.9s2j~tfd8 390086 661632 2019-12-02 2019-06-30 158 15 12     16 201   15           216
1353 1353 PENN HIGHLANDS CLEARFIELD 809 TURNPIKE AVE CLEARFIELD PA 16830 CLEARFIELD (814) 768-2497 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.0330120 -78.4499990 0   33 42 42033 20180 State College-DuBois, PA Central Clearfield County https://data.medicare.gov/resource/xubh-q36u/row-qnyy~yhz4~b6dj 390052 660292 2019-12-02 2019-06-30 40           40 10             50
1403 1403 CATAWBA VALLEY MEDICAL CENTER 810 FAIRGROVE CHURCH RD HICKORY NC 28602 CATAWBA (828) 326-3809 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.7111950 -81.2647790 0   35 37 37035 25860 Hickory-Lenoir, NC Central Catawba County https://data.medicare.gov/resource/xubh-q36u/row-yi2j.csdp-b8zf 340143 661370 2019-12-02 2019-06-30 172 28         200 38 20           258
1655 1655 ST LUKE'S WARREN HOSPITAL 185 ROSEBERRY ST PHILLIPSBURG NJ 8865 WARREN (908) 847-6700 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.7016280 -75.1796080 0   41 34 34041 10900 New York-Newark, NY-NJ-CT-PA Central Warren County https://data.medicare.gov/resource/xubh-q36u/row-vn4g.2enr-g87r 310060 660263 2019-12-02 2019-06-30 80 12         92               92
1706 1706 PINNACLE HEALTH HOSPITALS 409 SOUTH SECOND STREET HARRISBURG PA 17105 DAUPHIN (717) 782-5181 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.2562580 -76.8753290 0   43 42 42043 25420 Harrisburg-York-Lebanon, PA Central Dauphin County https://data.medicare.gov/resource/xubh-q36u/row-ciar-qnzv_q7gb 390067 660439 2019-12-02 2019-06-30 433 20 11     29 493               493
1779 1779 CRAWFORD COUNTY MEMORIAL HOSPITAL 100 MEDICAL PARKWAY DENISON IA 51442 CRAWFORD (712) 265-2500 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.0232570 -95.3770860 0   47 19 19047         https://data.medicare.gov/resource/xubh-q36u/row-9ydn-ts52-gjkc 161369 660986 2019-12-02 2019-06-30 25           25               25
1815 1815 SALEM HOSPITAL 890 OAK STREET, SE SALEM OR 97301 MARION (503) 561-5200 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.9328870 -123.0331460 0   47 41 41047 41420 Portland-Vancouver-Salem, OR-WA Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-gawf~xgxy_ivy2 380051 662068 2019-12-02 2019-06-30 334 60       27 421 25 24           470
1827 1827 FULTON COUNTY HOSPITAL 679 NORTH MAIN STREET SALEM AR 72576 FULTON (870) 895-2691 Critical Access Hospitals Voluntary non-profit - Other TRUE 36.3833590 -91.8112030 0   49 5 5049         https://data.medicare.gov/resource/xubh-q36u/row-9b6n-wd2m.b7tm 41322 660913 2019-12-02 2019-06-30 25           25               25
1836 1836 DALLAS COUNTY HOSPITAL 610 TENTH STREET PERRY IA 50220 DALLAS (515) 465-3547 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.8339590 -94.0944690 0   49 19 19049 19780 Des Moines-Ames-West Des Moines, IA Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-5ca8_jqfe~mw9b 161322 660961 2019-12-02 2019-06-30 25           25               25
1927 1927 UNIONTOWN HOSPITAL 500 WEST BERKELEY STREET UNIONTOWN PA 15401 FAYETTE (724) 430-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.9019960 -79.7376190 0   51 42 42051 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Outlying Fayette County https://data.medicare.gov/resource/xubh-q36u/row-4jjp-v8ik-skbv 390041 660291 2019-12-02 2019-06-30 134 15         149   11           160
2119 2119 CHILDREN'S HOSPITAL OF ORANGE COUNTY 1201 W LA VETA AVE ORANGE CA 92868 ORANGE (714) 997-3000 Childrens Voluntary non-profit - Other FALSE 33.7803300 -117.8649600 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-tabq.iupn-ad4g 53304 661466 2019-12-02 2019-06-30 176 24         334               334
2240 2240 SENECA DISTRICT HOSPITAL 130 BRENTWOOD DRIVE CHESTER CA 96020 PLUMAS (530) 258-2121 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.3053020 -121.2340180 0   63 6 6063         https://data.medicare.gov/resource/xubh-q36u/row-6rw5.c6e6.9puv 51327 661143 2019-12-02 2019-06-30 10           10       16       26
2335 2335 UNIVERSITY OF CALIFORNIA DAVIS MEDICAL CENTER 2315 STOCKTON BOULEVARD SACRAMENTO CA 95817 SACRAMENTO (916) 734-2011 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.5543750 -121.4575350 0   67 6 6067 40900 Sacramento-Roseville, CA Central Sacramento County https://data.medicare.gov/resource/xubh-q36u/row-xgsz_gz6f-5jxx 50599 662166 2019-12-02 2019-06-30 441 34   12 28 24 598   19           617
2512 2512 RADY CHILDREN'S HOSPITAL - SAN DIEGO 3020 CHILDRENS WAY SAN DIEGO CA 92123 SAN DIEGO (858) 576-1700 Childrens Voluntary non-profit - Other FALSE 32.7982600 -117.1508210 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-g946~ee4n.abkv 53303 660172 2019-12-02 2019-06-30 193 54       24 401         24 19   444
3225 3225 KENSINGTON HOSPITAL 136 W DIAMOND STREET PHILADELPHIA PA 19122 PHILADELPHIA (215) 426-8100 Acute Care Hospitals Voluntary non-profit - Other FALSE 39.9817591 -75.1347791 1 ROOFTOP 101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-jdjh_ypv5.y5gj 390025 660289 2019-12-02 2019-06-30 14           14               14
3327 3327 UPMC COLE 1001 EAST SECOND STREET COUDERSPORT PA 16915 POTTER (814) 274-9301 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.7706670 -77.9797410 0   105 42 42105         https://data.medicare.gov/resource/xubh-q36u/row-addx-8ax4.us6v 391313 662251 2019-12-02 2019-06-30 21 4         25       44       69
3435 3435 MIDMICHIGAN MEDICAL CENTER-MIDLAND 4000 WELLNESS DRIVE MIDLAND MI 48670 MIDLAND (989) 839-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 43.6356170 -84.2616890 0   111 26 26111 33220 Saginaw-Midland-Bay City, MI Central Midland County https://data.medicare.gov/resource/xubh-q36u/row-qvu6.ywex~sy5d 230222 661016 2019-12-02 2019-06-30 298 26         324               324
3552 3552 LUCAS COUNTY HEALTH CENTER 1200 NORTH 7TH STREET CHARITON IA 50049 LUCAS (641) 774-3000 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.0276930 -93.3034210 0   117 19 19117         https://data.medicare.gov/resource/xubh-q36u/row-6kae-djtk-d35x 161341 660973 2019-12-02 2019-06-30 25           25               25
3653 3653 MCALESTER REGIONAL HEALTH CENTER ONE CLARK BASS BOULEVARD MCALESTER OK 74501 PITTSBURG (918) 426-1800 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.9363612 -95.7502026 1 ROOFTOP 121 40 40121 32540   Central Pittsburg County https://data.medicare.gov/resource/xubh-q36u/row-rfbs~zrj2.pxw4 370034 660846 2019-12-02 2019-06-30 102 15         117 14 22           153
3668 3668 CENTRAL PENINSULA GENERAL HOSPITAL 250 HOSPITAL PLACE SOLDOTNA AK 99669 KENAI PENINSULA (907) 262-4404 Acute Care Hospitals Voluntary non-profit - Other TRUE 60.4938650 -151.0776580 0   122 2 2122         https://data.medicare.gov/resource/xubh-q36u/row-kgwk-j25h-z8m3 20024 661276 2019-12-02 2019-06-30 43 6         49       60       109
3775 3775 ASOCIACION HOSPITAL DEL MAESTRO, INC SERGIO CUEVAS BUSTAMANTE STREET 550 SAN JUAN PR 936 SAN JUAN (787) 758-6420 Acute Care Hospitals Voluntary non-profit - Other TRUE 18.4137095 -66.0682476 1 RANGE_INTERPOLATED 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-eyz9.wmk9~prcw 400004 660875 2019-12-02 2019-06-30 115 11         126               126
3854 3854 MONROE COUNTY HOSPITAL 6580 165TH STREET ALBIA IA 52531 MONROE (641) 932-2134 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.0448380 -92.7964750 0   135 19 19135         https://data.medicare.gov/resource/xubh-q36u/row-wtqj-qihw~wgcb 161342 660974 2019-12-02 2019-06-30 25           25               25
3972 3972 CLARINDA REGIONAL HEALTH CENTER 220 ESSIE DAVISON DRIVE CLARINDA IA 51632 PAGE (712) 542-2176 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.7231160 -95.0414060 0   145 19 19145         https://data.medicare.gov/resource/xubh-q36u/row-e24e-jv8q.avua 161352 661182 2019-12-02 2019-06-30 25           25               25
3987 3987 COMMUNITY HOSPITAL P O BOX 1328, 1301 EAST H ST MCCOOK NE 69001 RED WILLOW (308) 344-2650 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.2004042 -100.6317977 1 ROOFTOP 145 31 31145         https://data.medicare.gov/resource/xubh-q36u/row-b3ww-n6dr.gmwh 281363 661048 2019-12-02 2019-06-30 25           25               25
4186 4186 MYRTUE MEDICAL CENTER 1213 GARFIELD AVENUE HARLAN IA 51537 SHELBY (712) 755-5161 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.6474730 -95.3262020 0   165 19 19165         https://data.medicare.gov/resource/xubh-q36u/row-cvsd.wj8m_w54b 161374 660988 2019-12-02 2019-06-30 25           25               25
4582 4582 ST LUKES LAKESIDE HOSPITAL 17400 ST LUKES WAY THE WOODLANDS TX 77384 MONTGOMERY (936) 266-4055 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.2031320 -95.4594820 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-4i3k-4nqm~yxpg 670059 661450 2019-12-02 2019-06-30 30           30               30
4712 4712 UNIVERSITY OF MD MEDICAL CENTER MIDTOWN CAMPUS 827 LINDEN AVENUE BALTIMORE MD 21201 BALTIMORE CITY (410) 225-8996 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.3003890 -76.6208600 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-s44d_natn~6svq 210038 660393 2019-12-02 2019-06-30 165 12         177               177

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