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

38 rows where "filed_date" is on date 2019-11-21

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, hospital_ownership, geocode_flag, geocode_accuracy, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, fy_end_date, icu_beds, coronary_beds, surg_icu_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, nursing_fac_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-11-21 · 38 ✖
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
14 14 DICKENSON COMMUNITY HOSPITAL 312 HOSPITAL DRIVE CLINTWOOD VA 24228 DICKENSON (276) 926-0300 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.1598600 -82.4491020 0   51 51 51051 13720   Outlying Dickenson County https://data.medicare.gov/resource/xubh-q36u/row-gdzi~hhk4-fsm8 491303 659905 2019-11-21 2018-09-30 2           2 10             12
48 48 WASHINGTON HOSPITAL 2000 MOWRY AVE FREMONT CA 94538 ALAMEDA (510) 797-1111 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.5576530 -121.9808700 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-c4xt~2fw2_qi36 50195 659475 2019-11-21 2019-06-30 268 52         320               320
225 225 UPMC MCKEESPORT 1500 FIFTH AVENUE MC KEESPORT PA 15132 ALLEGHENY (412) 664-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3523000 -79.8492180 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-vm5i_92bf_4vwi 390002 659604 2019-11-21 2019-06-30 174   12       186   9   18       213
236 236 UPMC CHILDREN'S HOSPITAL OF PITTSBURGH ONE CHILDREN'S HOSPITAL DRIVE PITTSBURGH PA 15224 ALLEGHENY (412) 692-5325 Childrens Voluntary non-profit - Other TRUE 40.4664773 -79.9522935 1 GEOMETRIC_CENTER 3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-ifxe~erpm.ccc7 393302 659888 2019-11-21 2019-06-30 212 36 12       315               315
373 373 MINERS' COLFAX MEDICAL CENTER 203 HOSPITAL DRIVE RATON NM 87740 COLFAX (575) 445-3661 Critical Access Hospitals Government - State TRUE 36.8635480 -104.4431840 0   7 35 35007         https://data.medicare.gov/resource/xubh-q36u/row-52rb_2gq5.zmq9 321307 659824 2019-11-21 2019-06-30 21 4         25         37     62
459 459 OHIOHEALTH O'BLENESS HOSPITAL 55 HOSPITAL DRIVE ATHENS OH 45701 ATHENS (740) 593-5551 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.3277410 -82.1141890 0   9 39 39009 11900   Central Athens County https://data.medicare.gov/resource/xubh-q36u/row-25ei.cjhc~kvpd 360014 659834 2019-11-21 2019-06-30 64           64               64
514 514 DAHL MEMORIAL HEALTHCARE ASSOC 215 SANDY ST EKALAKA MT 59324 CARTER (406) 775-8739 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.8877240 -104.5487850 0   11 30 30011         https://data.medicare.gov/resource/xubh-q36u/row-i9vq~5cwz~mfp7 271302 659097 2019-11-21 2019-06-30 25           25               25
570 570 MOUNTAIN VISTA MEDICAL CENTER, LP 1301 SOUTH CRISMON ROAD MESA AZ 85209 MARICOPA (480) 358-6100 Acute Care Hospitals Proprietary TRUE 33.3911000 -111.6153290 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-aus8~8k4g-9a4c 30121 659181 2019-11-21 2019-06-30 112 30         142 20             162
602 602 MERCYONE WATERLOO MEDICAL CENTER 3421 WEST NINTH STREET WATERLOO IA 50702 BLACK HAWK (319) 272-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.4638670 -92.3457870 0   13 19 19013 47940   Central Black Hawk County https://data.medicare.gov/resource/xubh-q36u/row-9tqu-dd6x-rvxf 160067 659672 2019-11-21 2019-06-30 150 12         162   25           187
1095 1095 CALDWELL MEMORIAL HOSPITAL 321 MULBERRY ST SW LENOIR NC 28645 CALDWELL (828) 757-5100 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.9106330 -81.5362390 0   27 37 37027 25860 Hickory-Lenoir, NC Central Caldwell County https://data.medicare.gov/resource/xubh-q36u/row-8mub~vvxe.njee 340041 659522 2019-11-21 2019-06-30 98 12         110               110
1169 1169 PAOLI HOSPITAL 255 WEST LANCASTER AVENUE PAOLI PA 19301 CHESTER (610) 648-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0420980 -75.4998170 0   29 42 42029 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Chester County https://data.medicare.gov/resource/xubh-q36u/row-yasb-ch2s-d4ik 390153 659529 2019-11-21 2019-06-30 194 30         231               231
1193 1193 DOOR COUNTY MEDICAL CENTER 323 SOUTH 18TH AVENUE STURGEON BAY WI 54235 DOOR (920) 743-5566 Critical Access Hospitals Voluntary non-profit - Church TRUE 44.8327630 -87.3514180 0   29 55 55029         https://data.medicare.gov/resource/xubh-q36u/row-xy7a~agib-pkn6 521358 660156 2019-11-21 2019-06-30 21 4         25       30       55
1756 1756 RIDDLE MEMORIAL HOSPITAL 1068 WEST BALTIMORE PIKE MEDIA PA 19063 DELAWARE (610) 566-9400 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9143190 -75.4298890 0   45 42 42045 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Delaware County https://data.medicare.gov/resource/xubh-q36u/row-hsqa.aceg_26sn 390222 659531 2019-11-21 2019-06-30 182 14         204       23       227
1858 1858 GRANT MEDICAL CENTER 111 SOUTH GRANT AVENUE COLUMBUS OH 43215 FRANKLIN (614) 566-9000 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.9608660 -82.9906210 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-bzxi~qkhu.5nc9 360017 659835 2019-11-21 2019-06-30 399 35         434               434
1859 1859 DOCTORS HOSPITAL 5100 WEST BROAD STREET COLUMBUS OH 43228 FRANKLIN (614) 544-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.9519680 -83.1367090 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-sfy5_rn44.g253 360152 659841 2019-11-21 2019-06-30 154 18         172               172
1862 1862 RIVERSIDE METHODIST HOSPITAL 3535 OLENTANGY RIVER RD COLUMBUS OH 43214 FRANKLIN (614) 566-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0319620 -83.0312940 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-3863-kqrj_7sqc 360006 659832 2019-11-21 2019-06-30 577 88 30       695 39             734
1870 1870 UPMC HAMOT 201 STATE STREET ERIE PA 16550 ERIE (814) 877-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.1333310 -80.0878250 0   49 42 42049 21500 Erie-Meadville, PA Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-t94i.4mny~cqwk 390063 659435 2019-11-21 2019-06-30 355 14     28   421               421
1992 1992 ARKANSAS METHODIST MEDICAL CENTER 900 WEST KINGSHIGHWAY PARAGOULD AR 72450 GREENE (870) 239-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0525930 -90.4990510 0   55 5 5055 37500 Jonesboro-Paragould, AR Central Greene County https://data.medicare.gov/resource/xubh-q36u/row-r7jj_jnzg_y8it 40039 659557 2019-11-21 2019-06-30 106 8         114   15           129
2912 2912 WEST HOLT MEMORIAL HOSPITAL 406 W NEELY ST ATKINSON NE 68713 HOLT (402) 925-2811 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.5285300 -98.9823600 0   89 31 31089         https://data.medicare.gov/resource/xubh-q36u/row-4yu8_vi3f~x2qc 281343 659706 2019-11-21 2019-06-30 17           17               17
2969 2969 MAIN LINE HOSPITAL BRYN MAWR CAMPUS 130 SOUTH BRYN MAWR AVE BRYN MAWR PA 19010 MONTGOMERY (610) 526-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0185150 -75.3204820 0   91 42 42091 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-tcwp-46hd.dwps 390139 659720 2019-11-21 2019-06-30 213 30         267 20             287
2995 2995 HARDIN MEMORIAL HOSPITAL 913 NORTH DIXIE AVENUE ELIZABETHTOWN KY 42701 HARDIN (270) 737-1212 Acute Care Hospitals Government - Local TRUE 37.7099170 -85.8750480 0   93 21 21093 21060 Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Central Hardin County https://data.medicare.gov/resource/xubh-q36u/row-g22s~wmun-s6iz 180012 660555 2019-11-21 2019-06-30 250 10 10       270 15     15       300
3031 3031 ORLANDO HEALTH ORLANDO REGIONAL MEDICAL CENTER 52 W UNDERWOOD ST ORLANDO FL 32806 ORANGE (321) 843-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.5269250 -81.3782030 0   95 12 12095 36740 Orlando-Deltona-Daytona Beach, FL Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-jedz-a78s~x992 100006 661476 2019-11-21 2018-09-30 1196 71 42       1468 72 53           1593
3219 3219 MARION GENERAL HOSPITAL 1000 MCKINLEY PARK DRIVE MARION OH 43302 MARION (740) 383-8400 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5716020 -83.1280480 0   101 39 39101 32020 Columbus-Marion-Zanesville, OH Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-t485-ndzi-2p2z 360011 659833 2019-11-21 2019-06-30 159 15         174 24             198
3341 3341 EMANUEL MEDICAL CENTER 117 KITE ROAD SWAINSBORO GA 30401 EMANUEL (478) 289-1304 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.5932100 -82.3465520 0   107 13 13107         https://data.medicare.gov/resource/xubh-q36u/row-zwa9.bq43.jmum 110109 659232 2019-11-21 2019-06-30 37 8         45 15     49       109
3411 3411 BARTLETT REGIONAL HOSPITAL 3260 HOSPITAL DR JUNEAU AK 99801 JUNEAU (907) 796-8900 Acute Care Hospitals Government - Local TRUE 58.3286960 -134.4668290 0   110 2 2110 27940   Central Juneau City and Borough https://data.medicare.gov/resource/xubh-q36u/row-ceet-msjy~uqhq 20008 659178 2019-11-21 2019-06-30 36 9         45 12             57
3900 3900 OHIOHEALTH MANSFIELD HOSPITAL 335 GLESSNER AVENUE MANSFIELD OH 44903 RICHLAND (419) 526-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7533650 -82.5295170 0   139 39 39139 31900 Mansfield-Ashland-Bucyrus, OH Central Richland County https://data.medicare.gov/resource/xubh-q36u/row-b9k5_hm7x.wai8 360118 659839 2019-11-21 2019-06-30 198 30         228   9           237
3902 3902 OHIOHEALTH SHELBY HOSPITAL 199 WEST MAIN STREET SHELBY OH 44875 RICHLAND (419) 342-5015 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.8812140 -82.6740350 0   139 39 39139 31900 Mansfield-Ashland-Bucyrus, OH Central Richland County https://data.medicare.gov/resource/xubh-q36u/row-hibx-svpz.bscz 361324 659846 2019-11-21 2019-06-30 25           25               25
4102 4102 UNC ROCKINGHAM 117 E KINGS HIGHWAY EDEN NC 27288 ROCKINGHAM (336) 623-9711 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.4932100 -79.7401120 0   157 37 37157 24660 Greensboro--Winston-Salem--High Point, NC Outlying Rockingham County https://data.medicare.gov/resource/xubh-q36u/row-gcjs~fh4y~diu3 340060 659595 2019-11-21 2019-06-30 99 9         108       121       229
4134 4134 LORING HOSPITAL 211 HIGHLAND AVENUE PO BOX 217 SAC CITY IA 50583 SAC (712) 662-7105 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.4187060 -94.9779910 0   161 19 19161         https://data.medicare.gov/resource/xubh-q36u/row-u3kh-9p79.bc2v 161370 659676 2019-11-21 2019-06-30 25           25               25
4179 4179 HOLSTON VALLEY MEDICAL CENTER 130 WEST RAVINE ROAD KINGSPORT TN 37662 SULLIVAN (423) 224-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.5530050 -82.5542600 0   163 47 47163 28700 Johnson City-Kingsport-Bristol, TN-VA Central Sullivan County https://data.medicare.gov/resource/xubh-q36u/row-qkh8~tm4q-cxw9 440017 659452 2019-11-21 2019-06-30 237 36 23     20 316               316
4181 4181 BRISTOL REGIONAL MEDICAL CENTER ONE MEDICAL PARK BLVD BRISTOL TN 37620 SULLIVAN (423) 844-1121 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.5854658 -82.2568020 1 ROOFTOP 163 47 47163 28700 Johnson City-Kingsport-Bristol, TN-VA Central Sullivan County https://data.medicare.gov/resource/xubh-q36u/row-4mj3-zthj.zhkm 440012 659451 2019-11-21 2019-06-30 190 42         232 37             269
4261 4261 SMYTH COUNTY COMMUNITY HOSPITAL 245 MEDICAL PARK DRIVE MARION VA 24354 SMYTH (276) 378-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.8504660 -81.4898010 0   173 51 51173         https://data.medicare.gov/resource/xubh-q36u/row-fgpr.ymgj_dcvg 490038 659619 2019-11-21 2019-06-30 26 4         30   14   109       153
4291 4291 JOHNSON CITY MEDICAL CENTER 400 N STATE OF FRANKLIN RD JOHNSON CITY TN 37604 WASHINGTON (423) 431-6111 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.3082600 -82.3864900 0   179 47 47179 27740 Johnson City-Kingsport-Bristol, TN-VA Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-spbb_h24i-dank 440063 659455 2019-11-21 2019-06-30 419 56       39 514 14             528
4311 4311 PROGRESS WEST HOSPITAL 2 PROGRESS POINT PKWY O FALLON MO 63368 ST. CHARLES (636) 344-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7150970 -90.6965970 0   183 29 29183 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Charles County https://data.medicare.gov/resource/xubh-q36u/row-3pin-cjg2_7xkv 260219 659815 2019-11-21 2018-12-31 68           68               68
4385 4385 LONESOME PINE HOSPITAL 1990 HOLTON AVENUE EAST BIG STONE GAP VA 24219 WISE (276) 523-3111 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.8772840 -82.7556700 0   195 51 51195 13720   Central Wise County https://data.medicare.gov/resource/xubh-q36u/row-ftab_dza7~w44p 490114 661118 2019-11-21 2019-06-30 60 8         68       44       112
4522 4522 DONALSONVILLE HOSPITAL INC 102 HOSPITAL CIR DONALSONVILLE GA 39845 SEMINOLE (229) 524-5217 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.0507070 -84.8801230 0   253 13 13253         https://data.medicare.gov/resource/xubh-q36u/row-nrim~ztp2.rnen 110194 659233 2019-11-21 2019-06-30 45           45 20     75       140
4526 4526 OTTO KAISER MEMORIAL HOSPITAL 3349 S HIGHWAY 181 KENEDY TX 78119 KARNES (830) 583-3401 Critical Access Hospitals Government - Hospital District or Authority TRUE 28.8042500 -97.8566420 0   255 48 48255         https://data.medicare.gov/resource/xubh-q36u/row-4ahf_4ve9~n23g 451364 659545 2019-11-21 2019-06-30 25           25               25
4547 4547 YOAKUM COMMUNITY HOSPITAL 1200 CARL RAMERT DRIVE YOAKUM TX 77995 LAVACA (361) 293-2321 Critical Access Hospitals Voluntary non-profit - Private TRUE 29.3066200 -97.1303060 0   285 48 48285         https://data.medicare.gov/resource/xubh-q36u/row-fd62_5vyv.n9wj 451346 660056 2019-11-21 2019-06-30 22 3         25               25

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