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

25 rows where "filed_date" is on date 2019-05-20

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: city, state, county_name, hospital_type, hospital_ownership, emergency_services, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, fy_end_date, acute_beds, icu_beds, coronary_beds, surg_icu_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, oth_longterm_beds, all_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-05-20 · 25 ✖
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
220 220 MERCY HEALTH-ST RITA'S MEDICAL CENTER 730 WEST MARKET STREET LIMA OH 45801 ALLEN (419) 227-3361 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7399980 -84.1174500 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-ewvf-fmc3-mgzs 360066 648298 2019-05-20 2018-12-31 281 18 12       311   18   18   10   357
1343 1343 SIDNEY REGIONAL MEDICAL CENTER 1000 POLE CREEK CROSSING SIDNEY NE 69162 CHEYENNE (308) 254-5825 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.1307540 -102.9801900 0   33 31 31033         https://data.medicare.gov/resource/xubh-q36u/row-ctm9.mndn-bc8y 281357 648132 2019-05-20 2018-12-31 15 4         19       61       80
1374 1374 UNITED HOSPITAL CENTER 327 MEDICAL PARK DRIVE BRIDGEPORT WV 26330 HARRISON (681) 342-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.3305780 -80.2407960 0   33 54 54033 17220   Central Harrison County https://data.medicare.gov/resource/xubh-q36u/row-vn6s.ab8b_i2q2 510006 648870 2019-05-20 2018-12-31 212 20         232       32       264
1567 1567 TRISTAR SUMMIT MEDICAL CENTER 5655 FRIST BLVD HERMITAGE TN 37076 DAVIDSON (615) 316-3000 Acute Care Hospitals Proprietary TRUE 36.1779990 -86.6060150 0   37 47 47037 34980 Nashville-Davidson--Murfreesboro, TN Central Davidson County https://data.medicare.gov/resource/xubh-q36u/row-mycx-5xbi.6asf 440150 648211 2019-05-20 2018-12-31 146 12 12       170   20           190
1605 1605 MERCY HEALTH - DEFIANCE HOSPITAL 1404 EAST SECOND STREET DEFIANCE OH 43512 DEFIANCE (419) 782-8444 Acute Care Hospitals Proprietary TRUE 41.2826940 -84.3396250 0   39 39 39039 19580   Central Defiance County https://data.medicare.gov/resource/xubh-q36u/row-r5dc.qhdq-xnen 360270 648745 2019-05-20 2018-12-31 23           23               23
1918 1918 WISHEK COMMUNITY HOSPITAL 1007 4TH AVE S WISHEK ND 58495 MCINTOSH (701) 452-2326 Critical Access Hospitals Government - Local TRUE 46.2551230 -99.5515380 0   51 38 38051         https://data.medicare.gov/resource/xubh-q36u/row-zinj~5aa6.fhse 351321 648453 2019-05-20 2018-12-31 24           24               24
2218 2218 MERCY HEALTH-ANDERSON HOSPITAL 7500 STATE ROAD CINCINNATI OH 45255 HAMILTON (513) 624-4006 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0843760 -84.3492430 0   61 39 39061 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-erxz-eww5.cv5s 360001 648295 2019-05-20 2018-12-31 220 37         257   25           282
2586 2586 PULLMAN REGIONAL HOSPITAL 835 S BISHOP BLVD PULLMAN WA 99163 WHITMAN (509) 332-2541 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.7134620 -117.1698460 0   75 53 53075 39420 Pullman-Moscow, WA-ID Central Whitman County https://data.medicare.gov/resource/xubh-q36u/row-r8f3-95u9.2qf7 501331 648169 2019-05-20 2018-12-31 19 6         25               25
2619 2619 MERCY HEALTH - WILLARD HOSPITAL 1100 NEAL ZICK ROAD WILLARD OH 44890 HURON (419) 964-5000 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.0485890 -82.7240000 0   77 39 39077 35940 Cleveland-Akron-Canton, OH Central Huron County https://data.medicare.gov/resource/xubh-q36u/row-2gzj.rp2x-kr88 361310 648306 2019-05-20 2018-12-31 18 2         20               20
2834 2834 MOUNT SINAI MEDICAL CENTER 4300 ALTON RD MIAMI BEACH FL 33140 MIAMI-DADE (305) 674-2121 Acute Care Hospitals Voluntary non-profit - Private TRUE 25.8150450 -80.1379390 0   86 12 12086 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Miami-Dade County https://data.medicare.gov/resource/xubh-q36u/row-garf.6fug~riih 100034 648799 2019-05-20 2018-12-31 401 72         473 70 46           589
3008 3008 MERCY HEALTH-ALLEN HOSPITAL 200 WEST LORAIN STREET OBERLIN OH 44074 LORAIN (440) 775-1211 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.2942190 -82.2243840 0   93 39 39093 17460 Cleveland-Akron-Canton, OH Outlying Lorain County https://data.medicare.gov/resource/xubh-q36u/row-zexn~9nmw.e8zr 361306 648463 2019-05-20 2018-12-31 25           25               25
3059 3059 MERCY HEALTH - ST CHARLES HOSPITAL 2600 NAVARRE AVENUE OREGON OH 43616 LUCAS (419) 696-7200 Acute Care Hospitals Voluntary non-profit - Church FALSE 41.6366690 -83.4865890 0   95 39 39095 45780 Toledo-Port Clinton, OH Central Lucas County https://data.medicare.gov/resource/xubh-q36u/row-n8a7.nywz-pm75 360081 648299 2019-05-20 2018-12-31 115 10         125 90 20           235
3060 3060 MERCY HEALTH ST VINCENT MEDICAL CENTER 2213 CHERRY STREET TOLEDO OH 43608 LUCAS (419) 251-3232 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.6684930 -83.5417250 0   95 39 39095 45780 Toledo-Port Clinton, OH Central Lucas County https://data.medicare.gov/resource/xubh-q36u/row-mu98_s2ip~h4cb 360112 648301 2019-05-20 2018-12-31 157 38 72       313               313
3064 3064 MERCY ST ANNE HOSPITAL 3404 SYLVANIA AVENUE TOLEDO OH 43623 LUCAS (419) 407-2663 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.6917450 -83.6251760 0   95 39 39095 45780 Toledo-Port Clinton, OH Central Lucas County https://data.medicare.gov/resource/xubh-q36u/row-3hht~5n55~wmny 360262 648305 2019-05-20 2018-12-31 94 29         123               123
3119 3119 SANFORD MEDICAL CENTER MAYVILLE 42 6TH AVENUE SE MAYVILLE ND 58257 TRAILL (701) 786-3800 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.5006840 -97.3173680 0   97 38 38097         https://data.medicare.gov/resource/xubh-q36u/row-nc3d_d4k5_3c6s 351309 652094 2019-05-20 2018-12-31 25           25               25
3176 3176 MH ST ELIZABETH YOUNGSTOWN HOSPITAL 1044 BELMONT AVENUE YOUNGSTOWN OH 44501 MAHONING (330) 480-3962 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.1143210 -80.6557100 0   99 39 39099 49660 Youngstown-Warren, OH-PA Central Mahoning County https://data.medicare.gov/resource/xubh-q36u/row-wapa_iiqs_cijz 360064 648297 2019-05-20 2018-12-31 251 20 9   20   300 38 26           364
3375 3375 MAYO CLINIC HOSPITAL ROCHESTER 1216 SECOND STREET SOUTHWEST ROCHESTER MN 55902 OLMSTED (507) 255-1991 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.0216430 -92.4813550 0   109 27 27109 40340 Rochester-Austin, MN Central Olmsted County https://data.medicare.gov/resource/xubh-q36u/row-mjb7-tzch~v2xj 240010 649117 2019-05-20 2018-12-31 903 212         1115 73 32           1220
3394 3394 SUMMIT MEDICAL CENTER, LLC 1800 SOUTH RENAISSANCE BOULEVARD EDMOND OK 73013 OKLAHOMA (405) 359-2400 Acute Care Hospitals Physician TRUE 35.6355210 -97.4994350 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-4vbg.5jhj-wsm8 370225 648353 2019-05-20 2018-12-31 9           9               9
3486 3486 FAIRFAX COMMUNITY HOSPITAL 40 HOSPITAL ROAD FAIRFAX OK 74637 OSAGE (918) 642-3291 Critical Access Hospitals Voluntary non-profit - Other TRUE 36.5636190 -96.7052620 0   113 40 40113 46140 Tulsa-Muskogee-Bartlesville, OK Central Osage County https://data.medicare.gov/resource/xubh-q36u/row-4i8h_qx3c-d2aw 371318 648066 2019-05-20 2018-09-30 15           15               15
3567 3567 CLEVELAND AREA HOSPITAL 1401 WEST PAWNEE CLEVELAND OK 74020 PAWNEE (918) 358-2501 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.3098820 -96.4811210 0   117 40 40117 46140 Tulsa-Muskogee-Bartlesville, OK Outlying Pawnee County https://data.medicare.gov/resource/xubh-q36u/row-mn7t-r33n-bhn9 371320 647932 2019-05-20 2018-12-31 14           14               14
3953 3953 BAILEY MEDICAL CENTER, LLC 10502 NORTH 110TH EAST AVENUE OWASSO OK 74055 TULSA (918) 376-8000 Acute Care Hospitals Proprietary TRUE 36.3047170 -95.8516840 0   143 40 40143 46140 Tulsa-Muskogee-Bartlesville, OK Central Tulsa County https://data.medicare.gov/resource/xubh-q36u/row-kg4e-zyz8_rkj7 370228 648646 2019-05-20 2018-12-31 67 6         73               73
3958 3958 HILLCREST HOSPITAL SOUTH 8801 SOUTH 101ST EAST AVENUE TULSA OK 74133 TULSA (918) 294-4000 Acute Care Hospitals Proprietary TRUE 36.0362190 -95.8646510 0   143 40 40143 46140 Tulsa-Muskogee-Bartlesville, OK Central Tulsa County https://data.medicare.gov/resource/xubh-q36u/row-9pfm.itw9.gsgs 370202 648202 2019-05-20 2018-12-31 149 15         164               164
4006 4006 MERCY HEALTH - TIFFIN HOSPITAL 45 ST LAWRENCE DRIVE TIFFIN OH 44883 SENECA (419) 455-7000 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.1051380 -83.2170940 0   147 39 39147 45660 Findlay-Tiffin, OH Central Seneca County https://data.medicare.gov/resource/xubh-q36u/row-nev8_jm8r-xgdk 360089 648300 2019-05-20 2018-12-31 40 5         45               45
4096 4096 MARSHALL COUNTY HOSPITAL 615 OLD SYMSONIA ROAD BENTON KY 42025 MARSHALL (270) 527-4800 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.8681820 -88.3680720 0   157 21 21157         https://data.medicare.gov/resource/xubh-q36u/row-3q24_p54p~4rj7 181327 648260 2019-05-20 2018-12-31 21 4         25               25
4222 4222 SALINA SURGICAL HOSPITAL 401 SOUTH SANTA FE AVENUE SALINA KS 67401 SALINE (785) 827-0610 Acute Care Hospitals Physician FALSE 38.8343460 -97.6091620 0   169 20 20169 41460   Central Saline County https://data.medicare.gov/resource/xubh-q36u/row-a8k6_5z4m~icmv 170187 648111 2019-05-20 2018-12-31 16           16               16

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