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-11-27 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_accuracy, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, coronary_beds, burn_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_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
12 12 CLARKE COUNTY HOSPITAL 800 S FILLMORE ST OSCEOLA IA 50213 CLARKE (641) 342-2184 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.0257100 -93.7675330 0   39 19 19039         https://data.medicare.gov/resource/xubh-q36u/row-xtat~vhgt.9ane 161348 660976 2019-11-27 2019-06-30 25           25               25
72 72 MEDSTAR WASHINGTON HOSPITAL CENTER 110 IRVING ST NW WASHINGTON DC 20010 THE DISTRICT (202) 877-7000 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9291570 -77.0122680 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-he3p~gtzx-x7j5 90011 660787 2019-11-27 2019-06-30 569 37 16   55   701 46             747
73 73 SIBLEY MEMORIAL HOSPITAL 5255 LOUGHBORO RD NW WASHINGTON DC 20016 THE DISTRICT (202) 537-4680 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9357470 -77.1098890 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-yqpq-7pu8-v5vj 90005 660786 2019-11-27 2019-06-30 150   25   14   189 21     45       255
227 227 MAGEE WOMENS HOSPITAL OF UPMC HEALTH SYSTEM 300 HALKET STREET PITTSBURGH PA 15213 ALLEGHENY (412) 641-4010 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.4370770 -79.9595460 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-tusn~f4sz~kzrq 390114 660858 2019-11-27 2019-06-30 220 18         315       20       335
332 332 CUMBERLAND MEMORIAL HOSPITAL 1110 7TH AVENUE CUMBERLAND WI 54829 BARRON (715) 822-7500 Critical Access Hospitals Voluntary non-profit - Other TRUE 45.5309390 -92.0295920 0   5 55 55005         https://data.medicare.gov/resource/xubh-q36u/row-r4fu_4cy5~ir4d 521353 661689 2019-11-27 2019-06-30 25           25               25
532 532 READING HOSPITAL 420 S 5TH AVENUE WEST READING PA 19611 BERKS (610) 988-8000 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.3298630 -75.9480590 0   11 42 42011 39740 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Berks County https://data.medicare.gov/resource/xubh-q36u/row-rf2n_5umm~j8bk 390044 659867 2019-11-27 2019-06-30 491 20     21 30 562 50 62   50       724
818 818 ORANGE PARK MEDICAL CENTER 2001 KINGSLEY AVE ORANGE PARK FL 32073 CLAY (904) 276-8500 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.1648070 -81.7385980 0   19 12 12019 27260 Jacksonville-St. Marys-Palatka, FL-GA Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-wsf2~ud7b_znaf 100226 660500 2019-11-27 2019-06-30 229 28         273 24 20           317
824 824 BUCHANAN COUNTY HEALTH CENTER 1600 FIRST ST EAST INDEPENDENCE IA 50644 BUCHANAN (319) 332-0999 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.4687870 -91.8750150 0   19 19 19019         https://data.medicare.gov/resource/xubh-q36u/row-cq2e.inyq-2gxf 161335 660969 2019-11-27 2019-06-30 25           25           39   64
870 870 ASCENSION OUR LADY OF VICTORY HOSPITAL 1120 PINE ST STANLEY WI 54768 CHIPPEWA (715) 644-5571 Critical Access Hospitals Voluntary non-profit - Other TRUE 44.9553110 -90.9205640 0   19 55 55019         https://data.medicare.gov/resource/xubh-q36u/row-xzzk-sbky-rj53 521311 661445 2019-11-27 2019-06-30 24           24               24
1142 1142 MUNSON HEALTHCARE CHARLEVOIX HOSPITAL 14700 LAKESHORE DRIVE CHARLEVOIX MI 49720 CHARLEVOIX (231) 547-4024 Critical Access Hospitals Voluntary non-profit - Other TRUE 45.3144980 -85.2748510 1 ROOFTOP 29 26 26029         https://data.medicare.gov/resource/xubh-q36u/row-cdsd.f9cx_c7j8 231322 660601 2019-11-27 2019-06-30 25           25               25
1168 1168 JENNERSVILLE HOSPITAL 1015 WEST BALTIMORE PIKE WEST GROVE PA 19390 CHESTER (610) 869-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.8227440 -75.8879180 0   29 42 42029 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Chester County https://data.medicare.gov/resource/xubh-q36u/row-gfcj_eve8~h6ap 390220 660700 2019-11-27 2019-06-30 43 10         53               53
1393 1393 MIDMICHIGAN MEDICAL CENTER-CLARE 703 N MCEWAN ST CLARE MI 48617 CLARE (989) 802-5000 Acute Care Hospitals Voluntary non-profit - Other FALSE 43.8207240 -84.7683490 0   35 26 26035         https://data.medicare.gov/resource/xubh-q36u/row-x95c-xq2z-tjc4 230180 661013 2019-11-27 2019-06-30 49           49               49
1461 1461 MEMORIAL CARE MILLER CHILDREN'S & WOMEN'S HOSP LB 2801 ATLANTIC AVENUE LONG BEACH CA 90806 LOS ANGELES (562) 933-8001 Childrens Voluntary non-profit - Other FALSE 33.8071070 -118.1850980 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-khay_hirb.gvkk 53309 662488 2019-11-27 2019-06-30 232 30       95 357               357
1509 1509 LONG BEACH MEMORIAL MEDICAL CENTER 2801 ATLANTIC AVE LONG BEACH CA 90806 LOS ANGELES (562) 933-2000 Acute Care Hospitals Voluntary non-profit - Other FALSE 33.8071070 -118.1850980 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-t622~cs4c.w4nt 50485 662164 2019-11-27 2019-06-30 309 60         369   42   42       453
1840 1840 HURLEY MEDICAL CENTER ONE HURLEY PLAZA FLINT MI 48503 GENESEE (810) 257-9000 Acute Care Hospitals Voluntary non-profit - Other TRUE 43.0212629 -83.7046814 1 GEOMETRIC_CENTER 49 26 26049 22420 Detroit-Warren-Ann Arbor, MI Central Genesee County https://data.medicare.gov/resource/xubh-q36u/row-kud9-8wsb.pvu8 230132 661010 2019-11-27 2019-06-30 256 46 13 11   44 370 35 13           418
1894 1894 CANDLER HOSPITAL 5353 REYNOLDS STREET SAVANNAH GA 31412 CHATHAM (912) 819-6000 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.0273610 -81.1017310 0   51 13 13051 42340 Savannah-Hinesville-Statesboro, GA Central Chatham County https://data.medicare.gov/resource/xubh-q36u/row-cmu8.t2da.4a2c 110024 659932 2019-11-27 2019-06-30 192 20         212   23   11       246
2012 2012 MUNSON MEDICAL CENTER 1105 SIXTH STREET TRAVERSE CITY MI 49684 GRAND TRAVERSE (231) 935-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.7616450 -85.6415880 0   55 26 26055 45900   Central Grand Traverse County https://data.medicare.gov/resource/xubh-q36u/row-ytzp_khah~df5e 230097 660589 2019-11-27 2019-06-30 377 20         409 17 16           442
2147 2147 UNION COUNTY GENERAL HOSPITAL 300 WILSON STREET CLAYTON NM 88415 UNION (575) 374-7001 Critical Access Hospitals Voluntary non-profit - Other TRUE 36.4551690 -103.1932600 0   59 35 35059         https://data.medicare.gov/resource/xubh-q36u/row-ai6a~bn84~9pvi 321304 660831 2019-11-27 2019-06-30 25           25               25
2350 2350 FLOYD COUNTY MEDICAL CENTER 800 11TH ST CHARLES CITY IA 50616 FLOYD (641) 228-6830 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.0526670 -92.6825050 0   67 19 19067         https://data.medicare.gov/resource/xubh-q36u/row-wh9h~5vd4_p9gh 161347 660975 2019-11-27 2019-06-30 25           25               25
2510 2510 UC SAN DIEGO HEALTH HILLCREST - HILLCREST MED CTR 200 WEST ARBOR DRIVE SAN DIEGO CA 92103 SAN DIEGO (619) 543-6222 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.7537170 -117.1659140 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-2d2j.kc8f_hnd2 50025 662154 2019-11-27 2019-06-30 513   46 8 50 52 669 32             701
2558 2558 UCSF MEDICAL CENTER 505 PARNASSUS AVE, BOX 0296 SAN FRANCISCO CA 94143 SAN FRANCISCO (415) 353-2733 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.7635530 -122.4576540 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-cmdw-2w9d~vag6 50454 662027 2019-11-27 2019-06-30 579 106 26     16 785               785
2791 2791 TWIN LAKES REGIONAL MEDICAL CENTER 910 WALLACE AVENUE LEITCHFIELD KY 42754 GRAYSON (270) 259-9400 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.4719470 -86.2870380 0   85 21 21085         https://data.medicare.gov/resource/xubh-q36u/row-me6k_7rgh~hwhf 180070 660561 2019-11-27 2019-06-30 69 6         75               75
2997 2997 SAINT JOSEPH MERCY LIVINGSTON HOSPITAL 620 BYRON RD HOWELL MI 48843 LIVINGSTON (517) 545-6000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.6153720 -83.9393550 0   93 26 26093 19820 Detroit-Warren-Ann Arbor, MI Outlying Livingston County https://data.medicare.gov/resource/xubh-q36u/row-ij59~ym6m-2dbe 230069 660584 2019-11-27 2019-06-30 35 8         43               43
3041 3041 HARLAN ARH HOSPITAL 81 BALL PARK ROAD HARLAN KY 40831 HARLAN (606) 573-8100 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.8101830 -83.3131050 0   95 21 21095         https://data.medicare.gov/resource/xubh-q36u/row-yegj_y2j5.e33p 180050 660559 2019-11-27 2019-06-30 74 7         81 30             111
3081 3081 PETALUMA VALLEY HOSPITAL 400 N MCDOWELL BLVD PETALUMA CA 94954 SONOMA (707) 778-1111 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.2531830 -122.6328600 0   97 6 6097 42220 San Jose-San Francisco-Oakland, CA Central Sonoma County https://data.medicare.gov/resource/xubh-q36u/row-bfnf_4u5r~hdm4 50136 662019 2019-11-27 2019-06-30 71 9         80               80
3206 3206 MUNSON HEALTHCARE MANISTEE HOSPITAL 1465 E PARKDALE AVE MANISTEE MI 49660 MANISTEE (231) 398-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.2723550 -86.2734390 0   101 26 26101         https://data.medicare.gov/resource/xubh-q36u/row-yvaj-xucr.6ih7 230303 660597 2019-11-27 2019-06-30 45           45               45
3538 3538 INTEGRIS MIAMI HOSPITAL 200 SECOND AVENUE SOUTHWEST MIAMI OK 74355 OTTAWA (918) 542-6611 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.8721540 -94.8797720 0   115 40 40115 33060 Joplin-Miami, MO-OK Central Ottawa County https://data.medicare.gov/resource/xubh-q36u/row-juye_fwj7_x4b6 370004 660423 2019-11-27 2019-06-30 85 9         94 20             114
3622 3622 EVANGELICAL COMMUNITY HOSPITAL ONE HOSPITAL DRIVE LEWISBURG PA 17837 UNION (570) 522-2200 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.9793187 -76.8875496 1 ROOFTOP 119 42 42119 30260 Bloomsburg-Berwick-Sunbury, PA Central Union County https://data.medicare.gov/resource/xubh-q36u/row-mc97-igzf~6yka 390013 660009 2019-11-27 2019-06-30 111 12         123   9           132
3802 3802 SACRED HEART HOSPITAL ON THE EMERALD COAST 7800 US HWY 98 W MIRAMAR BEACH FL 32550 WALTON (850) 278-3600 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.3768190 -86.3068230 0   131 12 12131 18880   Central Walton County https://data.medicare.gov/resource/xubh-q36u/row-ucsd-9wwf_zg78 100292 660193 2019-11-27 2019-06-30 40 22         62               62
3990 3990 SOUTHERN OHIO MEDICAL CENTER 1805 27TH STREET PORTSMOUTH OH 45662 SCIOTO (740) 356-5000 Acute Care Hospitals Voluntary non-profit - Other FALSE 38.7539130 -82.9778320 0   145 39 39145 39020 Charleston-Huntington-Ashland, WV-OH-KY Central Scioto County https://data.medicare.gov/resource/xubh-q36u/row-52pr_re6y~4mrz 360008 660661 2019-11-27 2019-06-30 176 16         192   21       12   225
4184 4184 HARRISBURG MEDICAL CENTER 100 DOCTOR WARREN TUTTLE DR HARRISBURG IL 62946 SALINE (618) 253-7671 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.7310271 -88.5248600 1 ROOFTOP 165 17 17165         https://data.medicare.gov/resource/xubh-q36u/row-8u5r_n3xt~tnqf 140210 660516 2019-11-27 2019-06-30 40           40 30             70
4300 4300 WAYNE MEDICAL CENTER 103 J V MANGUBAT DR WAYNESBORO TN 38485 WAYNE (931) 722-5411 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.3253550 -87.7575330 0   181 47 47181         https://data.medicare.gov/resource/xubh-q36u/row-283m~szqb.wyui 440010 660038 2019-11-27 2019-06-30 30           30               30
4489 4489 WELLSTAR PAULDING HOSPITAL 2518 JIMMY LEE SMITH PARKWAY HIRAM GA 30141 PAULDING (470) 644-7000 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.9024290 -84.7827270 0   223 13 13223 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Paulding County https://data.medicare.gov/resource/xubh-q36u/row-e36y~9j3e~pmmm 110042 659934 2019-11-27 2019-06-30 104 8         112       182       294
4685 4685 CITIZENS MEDICAL CENTER 2701 HOSPITAL DRIVE VICTORIA TX 77901 VICTORIA (361) 573-9181 Acute Care Hospitals Voluntary non-profit - Other TRUE 28.8131570 -96.9767590 0   469 48 48469 47020 Victoria-Port Lavaca, TX Central Victoria County https://data.medicare.gov/resource/xubh-q36u/row-qzne~ijre-g2v9 450023 659729 2019-11-27 2019-06-30 285 14     8   307       20       327

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