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

37 rows where "filed_date" is on date 2019-06-03 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, icu_beds, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, oth_longterm_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
30 30 SOUTHSIDE COMMUNITY HOSPITAL, INC 800 OAK STREET FARMVILLE VA 23901 PRINCE EDWARD (434) 392-8811 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.3033170 -78.4030580 0   147 51 51147         https://data.medicare.gov/resource/xubh-q36u/row-5efz.zpme_8ei2 490090 650408 2019-06-03 2018-12-31 78 8         86               86
46 46 EDEN MEDICAL CENTER 20103 LAKE CHABOT ROAD CASTRO VALLEY CA 94546 ALAMEDA (510) 537-1234 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.6982685 -122.0903131 1 ROOFTOP 1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-qpf5_ajfv~drq5 50488 650953 2019-06-03 2018-12-31 106 24         130               130
310 310 UNIVERSITY HOSPITALS SAMARITAN MEDICAL CENTER 1025 CENTER ST ASHLAND OH 44805 ASHLAND (419) 289-0491 Acute Care Hospitals Voluntary non-profit - Other FALSE 40.8587020 -82.3104130 0   5 39 39005 11740 Mansfield-Ashland-Bucyrus, OH Central Ashland County https://data.medicare.gov/resource/xubh-q36u/row-suim.pydj-jawn 360002 649303 2019-06-03 2018-12-31 33 6         39               39
334 334 HOSP COMUNITARIO BUEN SAMARITANO CARR.2 KM.1.4 AVE. SEVERIANO CUEVAS #18 AGUADILLA PR 603 AGUADILLA (787) 658-0000 Acute Care Hospitals Voluntary non-profit - Other TRUE 18.4257212 -67.1508997 1 GEOMETRIC_CENTER 5 72 72005 10380   Central Aguadilla Municipio https://data.medicare.gov/resource/xubh-q36u/row-8tsm_vegi.8z9v 400079 649495 2019-06-03 2018-12-31 116 8         124               124
337 337 BANNER PAYSON MEDICAL CENTER 807 SOUTH PONDEROSA DRIVE PAYSON AZ 85541 GILA (928) 474-3222 Critical Access Hospitals Voluntary non-profit - Other FALSE 34.2313510 -111.3213610 0   7 4 4007 37740   Central Gila County https://data.medicare.gov/resource/xubh-q36u/row-2gy2.vxfy~pkyq 31318 649532 2019-06-03 2018-12-31 21 4         25               25
378 378 UNIVERSITY HOSPITALS CONNEAUT MEDICAL CENTER 158 WEST MAIN ROAD CONNEAUT OH 44030 ASHTABULA (440) 593-1131 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.9369200 -80.5864590 0   7 39 39007 11780 Cleveland-Akron-Canton, OH Central Ashtabula County https://data.medicare.gov/resource/xubh-q36u/row-j92a_zjx7-y5bm 361308 649653 2019-06-03 2018-12-31 20 5         25               25
392 392 BENNETT COUNTY HOSPITAL AND NURSING HOME - CAH 102 MAJOR ALLEN POST OFFICE BOX 70D MARTIN SD 57551 BENNETT (605) 685-6622 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.1691630 -101.7266636 1 RANGE_INTERPOLATED 7 46 46007         https://data.medicare.gov/resource/xubh-q36u/row-q2mg~bq2u~fi2w 431314 649823 2019-06-03 2018-12-31 14           14           48   62
553 553 BANNER - UNIVERSITY MEDICAL CENTER PHOENIX 1111 EAST MCDOWELL ROAD PHOENIX AZ 85006 MARICOPA (602) 239-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.4657240 -112.0581270 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-f67j.fyep_c3zs 30002 648882 2019-06-03 2018-12-31 455 46 28       622 22 68           712
571 571 BANNER GATEWAY MEDICAL CENTER 1900 NORTH HIGLEY ROAD GILBERT AZ 85234 MARICOPA (480) 543-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.3842250 -111.7196340 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-wvqy.pesc-7dbf 30122 649068 2019-06-03 2018-12-31 141 24         165               165
640 640 EAST OHIO REGIONAL HOSPITAL 90 NORTH FOURTH STREET MARTINS FERRY OH 43935 BELMONT (740) 633-4205 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.0986440 -80.7208890 0   13 39 39013 48540   Central Belmont County https://data.medicare.gov/resource/xubh-q36u/row-h333-qu75_kcna 360080 649318 2019-06-03 2018-12-31 74 10         84       50       134
881 881 BANNER CASA GRANDE MEDICAL CENTER 1800 EAST FLORENCE BOULEVARD CASA GRANDE AZ 85122 PINAL (520) 381-6300 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.8796080 -111.7092530 0   21 4 4021 38060   Central Pinal County https://data.medicare.gov/resource/xubh-q36u/row-iqqv.u75b-cmsi 30016 651166 2019-06-03 2018-12-31 119 22         141               141
960 960 H C WATKINS MEMORIAL HOSPITAL INC 605 SOUTH ARCHUSA AVENUE QUITMAN MS 39355 CLARKE (601) 776-6925 Critical Access Hospitals Voluntary non-profit - Other TRUE 32.0312590 -88.7279550 0   23 28 28023 32940   Outlying Clarke County https://data.medicare.gov/resource/xubh-q36u/row-7ipq~zmm9-gyn8 251316 650283 2019-06-03 2018-12-31 25           25               25
1347 1347 ADIRONDACK MEDICAL CENTER - SARANAC LAKE 2233 STATE ROUTE 86, PO BOX 471 SARANAC LAKE NY 12983 FRANKLIN (518) 891-4141 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.3445480 -74.1445970 0   33 36 36033 31660   Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-7ubk-sp7w.3hyq 330079 651024 2019-06-03 2018-12-31 75 8         83 12     60       155
1591 1591 SAVOY MEDICAL CENTER 801 POINCIANA AVENUE MAMOU LA 70554 EVANGELINE (337) 468-5261 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.6410320 -92.4176050 0   39 22 22039         https://data.medicare.gov/resource/xubh-q36u/row-53wc.63uu-ebuh 190025 650138 2019-06-03 2018-12-31 118 10         128 38 10           176
1635 1635 NOVATO COMMUNITY HOSPITAL 180 ROWLAND WAY NOVATO CA 94945 MARIN (415) 209-1300 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.0980770 -122.5596600 0   41 6 6041 41860 San Jose-San Francisco-Oakland, CA Central Marin County https://data.medicare.gov/resource/xubh-q36u/row-cbru_uws8_9g6e 50131 650646 2019-06-03 2018-12-31 39 8         47               47
1741 1741 HAYES GREEN BEACH MEMORIAL HOSPITAL 321 E HARRIS STREET CHARLOTTE MI 48813 EATON (517) 543-1050 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.5649280 -84.8318260 0   45 26 26045 29620 Lansing-East Lansing-Owosso, MI Central Eaton County https://data.medicare.gov/resource/xubh-q36u/row-ty8n~pfwz_x66j 231327 649907 2019-06-03 2018-12-31 25           25               25
1821 1821 NOVANT HEALTH UVA HEALTH SYSTEM CULPEPER MED CENTE 501 SUNSET LANE CULPEPER VA 22701 CULPEPER (540) 829-4100 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.4548480 -78.0113050 0   47 51 51047 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Outlying Culpeper County https://data.medicare.gov/resource/xubh-q36u/row-mbvh-ne84~5vxg 490019 650389 2019-06-03 2018-12-31 64 6         70               70
1895 1895 MEMORIAL HEALTH UNIVERSITY MEDICAL CENTER 4700 WATERS AVENUE SAVANNAH GA 31404 CHATHAM (912) 350-3691 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.0317850 -81.0918270 0   51 13 13051 42340 Savannah-Hinesville-Statesboro, GA Central Chatham County https://data.medicare.gov/resource/xubh-q36u/row-amaq_j44a_mqc4 110036 651266 2019-06-03 2018-12-31 381 20       10 525 10             535
1964 1964 COOPER COUNTY COMMUNITY HOSPITAL 17651 B HWY BOONVILLE MO 65233 COOPER (660) 882-4100 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9435330 -92.7420750 0   53 29 29053         https://data.medicare.gov/resource/xubh-q36u/row-b8m2_fqek~vure 260004 649916 2019-06-03 2018-12-31 46           46           19   65
2027 2027 MONROE COMMUNITY HOSPITAL 435 EAST HENRIETTA ROAD ROCHESTER NY 14620 MONROE (585) 760-6500 Acute Care Hospitals Voluntary non-profit - Other FALSE 43.1118560 -77.6160780 0   55 36 36055 40380 Rochester-Batavia-Seneca Falls, NY Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-5bf3_hk4u~74wb 330403 651037 2019-06-03 2018-12-31 5           5       566       571
2308 2308 EDWARD W SPARROW HOSPITAL 1215 E MICHIGAN AVENUE LANSING MI 48912 INGHAM (517) 364-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.7336090 -84.5348160 0   65 26 26065 29620 Lansing-East Lansing-Owosso, MI Central Ingham County https://data.medicare.gov/resource/xubh-q36u/row-9z74.56x8-gaaq 230230 650161 2019-06-03 2018-12-31 297 99 104     33 533 59 40           632
2387 2387 BANNER FORT COLLINS MEDICAL CENTER 4700 LADY MOON DRIVE FORT COLLINS CO 80528 LARIMER (970) 821-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.5211170 -105.0108850 0   69 8 8069 22660   Central Larimer County https://data.medicare.gov/resource/xubh-q36u/row-t2c3_t3mg_dfjd 60126 652186 2019-06-03 2018-12-31 23           23               23
2474 2474 ST LUKE'S CORNWALL HOSPITAL 70 DUBOIS STREET NEWBURGH NY 12550 ORANGE (845) 561-4400 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.5037440 -74.0151760 0   71 36 36071 35620 New York-Newark, NY-NJ-CT-PA Outlying Orange County https://data.medicare.gov/resource/xubh-q36u/row-4y2a-p7ka_jmg6 330264 651032 2019-06-03 2018-12-31 165 18       10 193               193
2522 2522 LINCOLN COMMUNITY HOSPITAL 111 6TH ST HUGO CO 80821 LINCOLN (719) 743-2421 Critical Access Hospitals Voluntary non-profit - Other TRUE 39.1376600 -103.4731590 0   73 8 8073         https://data.medicare.gov/resource/xubh-q36u/row-ur8w~xce7~5xe9 61306 651191 2019-06-03 2018-12-31 15           15       35       50
2543 2543 HOCKING VALLEY COMMUNITY HOSPITAL 601 STATE ROUTE 664N LOGAN OH 43138 HOCKING (740) 380-8227 Critical Access Hospitals Voluntary non-profit - Other TRUE 39.5475040 -82.4285180 0   73 39 39073 18140 Columbus-Marion-Zanesville, OH Outlying Hocking County https://data.medicare.gov/resource/xubh-q36u/row-4idp_5ask.rtvw 361330 649656 2019-06-03 2018-12-31 21       4   25 10             35
2565 2565 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP 601 DUBOCE AVENUE SAN FRANCISCO CA 94117 SAN FRANCISCO (415) 600-6000 Acute Care Hospitals Voluntary non-profit - Other FALSE 37.7691140 -122.4346960 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-6wq8_65ym~23y8 50008 651170 2019-06-03 2018-12-31 129 8         137   48   38       223
2573 2573 HENRY FORD ALLEGIANCE HEALTH 205 N EAST AVE JACKSON MI 49201 JACKSON (517) 788-4800 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.2503560 -84.3936030 0   75 26 26075 27100   Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-3qhp-255z.2v6t 230092 650158 2019-06-03 2018-12-31 262 34 17       313 40             353
2863 2863 NYACK HOSPITAL 160 NORTH MIDLAND AVENUE NYACK NY 10960 ROCKLAND (845) 348-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.0952510 -73.9252530 0   87 36 36087 35620 New York-Newark, NY-NJ-CT-PA Central Rockland County https://data.medicare.gov/resource/xubh-q36u/row-5nre.azih-h35v 330104 650863 2019-06-03 2018-12-31 199         10 209 26             235
3079 3079 SUTTER SANTA ROSA REGIONAL HOSPITAL 30 MARK WEST SPRINGS ROAD SANTA ROSA CA 95403 SONOMA (707) 576-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.4963060 -122.7507070 0   97 6 6097 42220 San Jose-San Francisco-Oakland, CA Central Sonoma County https://data.medicare.gov/resource/xubh-q36u/row-cm5t.k3eb~48rb 50291 650648 2019-06-03 2018-12-31 60 12       12 84               84
3574 3574 HILL HOSPITAL OF SUMTER COUNTY 751 DERBY DRIVE YORK AL 36925 SUMTER (205) 392-5263 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.4918250 -88.2960810 0   119 1 1119         https://data.medicare.gov/resource/xubh-q36u/row-hxjd.ga7s.xmvj 10138 651158 2019-06-03 2018-12-31 33           33               33
4045 4045 AULTMAN HOSPITAL 2600 SIXTH STREET SW CANTON OH 44710 STARK (330) 363-6352 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.7968520 -81.4035750 0   151 39 39151 15940 Cleveland-Akron-Canton, OH Central Stark County https://data.medicare.gov/resource/xubh-q36u/row-skwz~ncuf-62nj 360084 649319 2019-06-03 2018-12-31 333 20 26   18   422   30   60       512
4047 4047 ALLIANCE COMMUNITY HOSPITAL 200 EAST STATE STREET ALLIANCE OH 44601 STARK (330) 596-7018 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.9016790 -81.1027360 0   151 39 39151 15940 Cleveland-Akron-Canton, OH Central Stark County https://data.medicare.gov/resource/xubh-q36u/row-9pb7.6hrh_xxpz 360131 649642 2019-06-03 2018-12-31 43 12         55 12     78       145
4394 4394 WARM SPRINGS MEDICAL CENTER 5995 SPRING STREET WARM SPRINGS GA 31830 MERIWETHER (706) 655-9351 Critical Access Hospitals Voluntary non-profit - Other TRUE 32.8906520 -84.6829110 0   199 13 13199 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Meriwether County https://data.medicare.gov/resource/xubh-q36u/row-zkjq-ab6q-8vh9 111316 651203 2019-06-03 2018-12-31 25           25       79       104
4472 4472 TEXAS COUNTY MEMORIAL HOSPITAL 1333 SAM HOUSTON BOULEVARD HOUSTON MO 65483 TEXAS (417) 967-3311 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.3157560 -91.9595590 0   215 29 29215         https://data.medicare.gov/resource/xubh-q36u/row-f27e-vv7h.kacf 260024 649919 2019-06-03 2018-12-31 43 4         47               47
4728 4728 BARNES JEWISH HOSPITAL ONE BARNES-JEWISH HOSPITAL PLAZA SAINT LOUIS MO 63110 ST. LOUIS CITY (314) 747-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.6352633 -90.2650260 1 ROOFTOP 510 29 29510 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Louis city https://data.medicare.gov/resource/xubh-q36u/row-xqm2.gcb3.jvqi 260032 650284 2019-06-03 2018-12-31 1106 65 15   36   1272 96             1368
4749 4749 SENTARA NORFOLK GENERAL HOSPITAL 600 GRESHAM DR NORFOLK VA 23507 NORFOLK CITY (757) 388-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.8597280 -76.3048200 0   710 51 51710 47260 Virginia Beach-Norfolk, VA-NC Central Norfolk city https://data.medicare.gov/resource/xubh-q36u/row-r5z9-wxad_tcc7 490007 650916 2019-06-03 2018-12-31 381 44 10 16   20 471 34 22           527
4764 4764 SENTARA VIRGINIA BEACH GENERAL HOSPITAL 1060 FIRST COLONIAL ROAD VIRGINIA BEACH VA 23454 VIRGINIA BEACH CITY (757) 395-8000 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.8641580 -76.0283420 0   810 51 51810 47260 Virginia Beach-Norfolk, VA-NC Central Virginia Beach city https://data.medicare.gov/resource/xubh-q36u/row-sn9p~qwkm_5xtk 490057 650618 2019-06-03 2018-12-31 190 22 12     3 227 24 8           259

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