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

124 rows where "filed_date" is on date 2019-11-25

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

filed_date (date) ✖

  • 2019-11-25 · 24 ✖
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
4036 4036 DECKERVILLE COMMUNITY HOSPITAL 3559 PINE ST DECKERVILLE MI 48427 SANILAC (810) 376-2835 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.5281610 -82.7337730 0   151 26 26151         https://data.medicare.gov/resource/xubh-q36u/row-kq5w_x6ix-cx98 231311 660599 2019-11-25 2019-06-30 15           15               15
4042 4042 WARREN MEMORIAL HOSPITAL 905 SECOND ST FRIEND NE 68359 SALINE (402) 947-2541 Critical Access Hospitals Government - Local TRUE 40.6536930 -97.2820520 0   151 31 31151         https://data.medicare.gov/resource/xubh-q36u/row-d3pt.4wwp-4k26 281330 660257 2019-11-25 2019-09-30 19           19               19
4057 4057 RAWLINS COUNTY HEALTH CENTER 707 GRANT ST ATWOOD KS 67730 RAWLINS (785) 626-3211 Critical Access Hospitals Voluntary non-profit - Other TRUE 39.8132640 -101.0385000 0   153 20 20153         https://data.medicare.gov/resource/xubh-q36u/row-aajh-f5t2_nat3 171307 659791 2019-11-25 2019-06-30 15           15               15
4064 4064 AKRON GENERAL MEDICAL CENTER 1 AKRON GENERAL AVENUE AKRON OH 44307 SUMMIT (330) 344-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0778590 -81.5327870 0   153 39 39153 10420 Cleveland-Akron-Canton, OH Central Summit County https://data.medicare.gov/resource/xubh-q36u/row-fwyk~yqdc~my3b 360027 660664 2019-11-25 2018-12-31 315 34 34       383 53             436
4202 4202 SIOUX CENTER HEALTH 1101 9TH STREET SE SIOUX CENTER IA 51250 SIOUX (712) 722-1271 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.0696850 -96.1592870 0   167 19 19167         https://data.medicare.gov/resource/xubh-q36u/row-69h8.g24x.naq3 161346 659789 2019-11-25 2019-06-30 19           19       69   1   89
4203 4203 ORANGE CITY AREA HEALTH SYSTEM 1000 LINCOLN CIRCLE SE ORANGE CITY IA 51041 SIOUX (712) 737-4984 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.9948780 -96.0457340 0   167 19 19167         https://data.medicare.gov/resource/xubh-q36u/row-j9vg.b9hy-cjqt 161360 659790 2019-11-25 2019-06-30 25           25               25
4278 4278 SAINT THOMAS RIVER PARK HOSPITAL 1559 SPARTA STREET MC MINNVILLE TN 37110 WARREN (931) 815-4101 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.6986940 -85.7423390 0   177 47 47177 32660   Central Warren County https://data.medicare.gov/resource/xubh-q36u/row-qm5q~p4wm-m3k7 440151 659458 2019-11-25 2019-06-30 92 8         100 10 15           125
4279 4279 MEMORIAL HOSPITAL 1110 NORTH SARAH DEWITT DRIVE GONZALES TX 78629 GONZALES (830) 672-7581 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.5158950 -97.4288680 0   177 48 48177         https://data.medicare.gov/resource/xubh-q36u/row-7g7y.b4hd-s8g5 450235 659735 2019-11-25 2019-06-30 34           34               34
4330 4330 SAINT THOMAS HIGHLANDS HOSPITAL 401 SEWELL DR SPARTA TN 38583 WHITE (931) 738-9211 Acute Care Hospitals Proprietary TRUE 35.9481200 -85.4770740 0   185 47 47185         https://data.medicare.gov/resource/xubh-q36u/row-kw75.zwj7_gsiz 440192 660314 2019-11-25 2019-06-30 28 4         32 14             46
4366 4366 WAYNE MEMORIAL HOSPITAL 2700 WAYNE MEMORIAL DR GOLDSBORO NC 27534 WAYNE (919) 736-1110 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.4008310 -77.9533420 0   191 37 37191 24140   Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-4zsd_c7iy.v8vj 340010 659334 2019-11-25 2019-06-30 245 16         261               261
4367 4367 JOHNSTON MEMORIAL HOSPITAL 16000 JOHNSTON MEMORIAL DRIVE ABINGDON VA 24211 WASHINGTON (276) 258-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.7206700 -81.9085600 0   191 51 51191 28700 Johnson City-Kingsport-Bristol, TN-VA Outlying Washington County https://data.medicare.gov/resource/xubh-q36u/row-ysbq~qbac~97nx 490053 660721 2019-11-25 2019-06-30 101 14         115               115
4417 4417 HCA HOUSTON HEALTHCARE TOMBALL 605 HOLDERRIETH TOMBALL TX 77375 HARRIS (281) 351-1623 Acute Care Hospitals Proprietary TRUE 30.0887030 -95.6239850 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-qwg3~p4ci.ubu8 450670 659543 2019-11-25 2019-06-30 167 20       7 194 21 26           241
4419 4419 MEMORIAL HERMANN HOSPITAL SYSTEM 1635 NORTH LOOP WEST HOUSTON TX 77008 HARRIS (713) 448-6796 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.8122660 -95.4308990 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-2kjx_z9h3~iiu7 450184 659537 2019-11-25 2019-06-30 1068 157       85 1310   78           1388
4431 4431 YOAKUM COUNTY HOSPITAL 412 MUSTANG AVENUE DENVER CITY TX 79323 YOAKUM (806) 592-2121 Critical Access Hospitals Government - Local TRUE 32.9683780 -102.8363910 0   501 48 48501         https://data.medicare.gov/resource/xubh-q36u/row-f6vr_y9ce-af6k 451308 659741 2019-11-25 2018-12-31 24           24               24
4436 4436 MEMORIAL HERMANN TEXAS MEDICAL CENTER 6411 FANNIN HOUSTON TX 77030 HARRIS (713) 704-3700 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.7136840 -95.3976270 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-dk5e-jq9i-qp7s 450068 659613 2019-11-25 2019-06-30 658 38 18     118 994   12   8       1014
4568 4568 PROVIDENCE HEALTH CENTER 6901 MEDICAL PARKWAY WACO TX 76712 MC LENNAN (254) 751-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.5132430 -97.1984310 0   309 48 48309 47380   Central McLennan County https://data.medicare.gov/resource/xubh-q36u/row-vgx2-viz4_yy8e 450042 659893 2019-11-25 2019-06-30 195 30         225 46             271
4590 4590 MEMORIAL HOSPITAL 224 E SECOND STREET DUMAS TX 79029 MOORE (806) 935-7171 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.8642640 -101.9710060 0   341 48 48341 20300   Central Moore County https://data.medicare.gov/resource/xubh-q36u/row-35k5-7dip~y499 451386 659901 2019-11-25 2019-06-30 16 3         19               19
4666 4666 DELL CHILDREN'S MEDICAL CENTER OF CENTRAL TEXAS 4900 MUELLER BLVD AUSTIN TX 78723 TRAVIS (512) 324-0000 Childrens Voluntary non-profit - Private TRUE 30.3025490 -97.7049570 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-2zt9_yffw~gyhs 453310 661423 2019-11-25 2019-06-30 127         76 203               203
4667 4667 DELL SETON MED CENTER AT THE UNIVERSITY OF TX 601 E 15TH STREET AUSTIN TX 78701 TRAVIS (512) 324-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2750550 -97.7329770 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-8gyh.j6jb.jjky 450124 660050 2019-11-25 2019-06-30 166 60         226               226
4674 4674 ASCENSION SETON MEDICAL CENTER AUSTIN 1201 W 38TH ST AUSTIN TX 78705 TRAVIS (512) 324-1000 Acute Care Hospitals Physician TRUE 30.3061540 -97.7452180 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-qf7b-dsjj.a9dv 450056 659731 2019-11-25 2019-06-30 304 83       43 430               430
4675 4675 ASCENSION SETON NORTHWEST 11113 RESEARCH BOULEVARD AUSTIN TX 78759 TRAVIS (512) 324-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4048200 -97.7450100 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-qudt_ghtb~xy35 450867 660331 2019-11-25 2019-06-30 77 16       13 106               106
4678 4678 TYLER COUNTY HOSPITAL 1100 WEST BLUFF WOODVILLE TX 75979 TYLER (409) 283-8141 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.7752870 -94.4282200 0   457 48 48457         https://data.medicare.gov/resource/xubh-q36u/row-xfu9.wq3c~xr3i 450460 660053 2019-11-25 2019-06-30 25           25               25
4702 4702 SETON MEDICAL CENTER WILLIAMSON 201 SETON PARKWAY ROUND ROCK TX 78664 WILLIAMSON (512) 324-0000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.5679440 -97.6527840 0   491 48 48491 12420   Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-rfq6_5szx.kb6y 670041 659749 2019-11-25 2019-06-30 93 26         119               119
4756 4756 MEDICAL COLLEGE OF VIRGINIA HOSPITALS BOX 980510 1250 EAST MARSHALL STREET RICHMOND VA 23298 RICHMOND CITY (804) 828-0938 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.5400695 -77.4299163 1 ROOFTOP 760 51 51760 40060   Central Richmond city https://data.medicare.gov/resource/xubh-q36u/row-p6wh~7aeu~ic6q 490032 659745 2019-11-25 2019-06-30 502 28 14 16 28   715 28 38           781

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