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

21 rows where "filed_date" is on date 2019-12-02 and geocode_accuracy = "ROOFTOP"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, hospital_ownership, emergency_services, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, coronary_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
31 31 ST MARKS MEDICAL CENTER ONE ST MARK'S PLACE LA GRANGE TX 78945 FAYETTE (979) 242-2200 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.9353227 -96.8763382 1 ROOFTOP 149 48 48149         https://data.medicare.gov/resource/xubh-q36u/row-sffi-gqgq~nh45 670004 660902 2019-12-02 2019-06-30 38           38               38
188 188 ANTELOPE MEMORIAL HOSPITAL P O BOX 229, 102 WEST 9TH ST NELIGH NE 68756 ANTELOPE (402) 887-4151 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1336539 -98.0299847 1 ROOFTOP 3 31 31003         https://data.medicare.gov/resource/xubh-q36u/row-uv86-cr3r-pfws 281326 661040 2019-12-02 2019-06-30 23           23               23
315 315 ACMH HOSPITAL ONE NOLTE DRIVE KITTANNING PA 16201 ARMSTRONG (724) 543-8500 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8085788 -79.5614577 1 ROOFTOP 5 42 42005 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Outlying Armstrong County https://data.medicare.gov/resource/xubh-q36u/row-nu27~a8n8_t6km 390163 660863 2019-12-02 2019-06-30 119 12         131   16   17       164
353 353 MERCYONE CENTERVILLE MEDICAL CENTER ONE ST JOSEPH'S DRIVE CENTERVILLE IA 52544 APPANOOSE (641) 437-4111 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.7555228 -92.8568047 1 ROOFTOP 7 19 19007         https://data.medicare.gov/resource/xubh-q36u/row-quyx-h8pq.iqb9 161377 660989 2019-12-02 2019-06-30 22 3         25           19   44
622 622 BOX BUTTE GENERAL HOSPITAL P O BOX 810, 2101 BOX BUTTE AVE ALLIANCE NE 69301 BOX BUTTE (308) 762-6660 Critical Access Hospitals Government - Local TRUE 42.0984344 -102.8703880 1 ROOFTOP 13 31 31013         https://data.medicare.gov/resource/xubh-q36u/row-gsu6_furw.wta3 281360 661047 2019-12-02 2019-06-30 25           25               25
711 711 ROBERT PACKER HOSPITAL ONE GUTHRIE SQUARE SAYRE PA 18840 BRADFORD (570) 888-6666 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9800398 -76.5206811 1 ROOFTOP 15 42 42015 42380   Central Bradford County https://data.medicare.gov/resource/xubh-q36u/row-cnez.nadf_i4pk 390079 661095 2019-12-02 2019-06-30 212 38         250               250
843 843 CHI HEALTH GOOD SAMARITAN P O BOX 1990, 10 EAST 31ST ST KEARNEY NE 68848 BUFFALO (308) 865-7100 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.7076254 -99.0818136 1 ROOFTOP 19 31 31019 28260   Central Buffalo County https://data.medicare.gov/resource/xubh-q36u/row-k4e3_xakc.p7ct 280009 661546 2019-12-02 2019-06-30 201 16       10 227   12           239
1258 1258 MT SINAI HOSPITAL MEDICAL CENTER 15TH STREET AT CALIFORNIA CHICAGO IL 60608 COOK (773) 542-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8612424 -87.6940679 1 ROOFTOP 31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-wcea_tcc2-qg4n 140018 661489 2019-12-02 2019-06-30 182 17 12       236 28             264
2287 2287 SAN GORGONIO MEMORIAL HOSPITAL 600 NORTH HIGHLAND SPRINGS AVENUE BANNING CA 92220 RIVERSIDE (951) 845-1121 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.9316874 -116.9461472 1 ROOFTOP 65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-v72w~xz4e~mtkk 50054 660165 2019-12-02 2019-06-30 55 6         61               61
3225 3225 KENSINGTON HOSPITAL 136 W DIAMOND STREET PHILADELPHIA PA 19122 PHILADELPHIA (215) 426-8100 Acute Care Hospitals Voluntary non-profit - Other FALSE 39.9817591 -75.1347791 1 ROOFTOP 101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-jdjh_ypv5.y5gj 390025 660289 2019-12-02 2019-06-30 14           14               14
3295 3295 WETZEL COUNTY HOSPITAL #3 EAST BENJAMIN DRIVE NEW MARTINSVILLE WV 26155 WETZEL (304) 455-8000 Acute Care Hospitals Government - Local TRUE 39.6810712 -80.8501977 1 ROOFTOP 103 54 54103         https://data.medicare.gov/resource/xubh-q36u/row-v7h8~v92p-92tq 510072 661438 2019-12-02 2019-06-30 43 5         48               48
3579 3579 CHI-ST VINCENT INFIRMARY TWO ST VINCENT CIRCLE LITTLE ROCK AR 72205 PULASKI (501) 552-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7502877 -92.3393435 1 ROOFTOP 119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-rvvz~qyi8_5qyq 40007 660911 2019-12-02 2019-06-30 330 23 20     20 393               393
3628 3628 SHANDS LIVE OAK REGIONAL MEDICAL CENTER 1100 SW 11TH ST LIVE OAK FL 32060 SUWANNEE (904) 362-1413 Critical Access Hospitals Proprietary TRUE 30.2917367 -83.0028124 1 ROOFTOP 121 12 12121         https://data.medicare.gov/resource/xubh-q36u/row-keij_wts9-t8jc 101301 660198 2019-12-02 2019-06-30 25           25               25
3645 3645 WHITFIELD MEDICAL SURGICAL HOSPITAL 3550 HWY 468 W, BLDG 60 WHITFIELD MS 39193 RANKIN (601) 351-8023 Acute Care Hospitals Government - State FALSE 32.2418381 -90.0709905 1 ROOFTOP 121 28 28121 27140 Jackson-Vicksburg-Brookhaven, MS Central Rankin County https://data.medicare.gov/resource/xubh-q36u/row-h6gx_kf5u~ce53 250134 660110 2019-12-02 2019-06-30 32           32               32
3653 3653 MCALESTER REGIONAL HEALTH CENTER ONE CLARK BASS BOULEVARD MCALESTER OK 74501 PITTSBURG (918) 426-1800 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.9363612 -95.7502026 1 ROOFTOP 121 40 40121 32540   Central Pittsburg County https://data.medicare.gov/resource/xubh-q36u/row-rfbs~zrj2.pxw4 370034 660846 2019-12-02 2019-06-30 102 15         117 14 22           153
3834 3834 PAWNEE COUNTY MEMORIAL HOSPITAL P O BOX 433, 600 I ST PAWNEE CITY NE 68420 PAWNEE (402) 852-2231 Critical Access Hospitals Proprietary TRUE 40.1098396 -96.1532422 1 ROOFTOP 133 31 31133         https://data.medicare.gov/resource/xubh-q36u/row-2ahw-y3eh_6phq 281302 661036 2019-12-02 2019-06-30 17           17               17
3839 3839 UPMC MEMORIAL 1701 INNOVATION DRIVE YORK PA 17408 YORK (717) 843-8623 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9815722 -76.7696680 1 ROOFTOP 133 42 42133 49620 Harrisburg-York-Lebanon, PA Central York County https://data.medicare.gov/resource/xubh-q36u/row-hmf5.dwfj.9dpf 390101 661097 2019-12-02 2019-06-30 50 10         60               60
3897 3897 CHI HEALTH PLAINVIEW P O BOX 489, 704 NORTH THIRD ST PLAINVIEW NE 68769 PIERCE (402) 582-4245 Critical Access Hospitals Voluntary non-profit - Church TRUE 42.3587128 -97.7857721 1 ROOFTOP 139 31 31139 35740   Outlying Pierce County https://data.medicare.gov/resource/xubh-q36u/row-dyfy-rvq7~3hjd 281346 661043 2019-12-02 2019-06-30 15           15               15
3987 3987 COMMUNITY HOSPITAL P O BOX 1328, 1301 EAST H ST MCCOOK NE 69001 RED WILLOW (308) 344-2650 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.2004042 -100.6317977 1 ROOFTOP 145 31 31145         https://data.medicare.gov/resource/xubh-q36u/row-b3ww-n6dr.gmwh 281363 661048 2019-12-02 2019-06-30 25           25               25
4256 4256 PENDER COMMUNITY HOSPITAL P O BOX 100, 100 HOSPITAL DRIVE PENDER NE 68047 THURSTON (402) 385-3083 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.1055877 -96.7110334 1 ROOFTOP 173 31 31173         https://data.medicare.gov/resource/xubh-q36u/row-iane_yp36_h5j2 281349 661213 2019-12-02 2019-06-30 21           21               21
4375 4375 PETERSBURG MEDICAL CENTER PO BOX 589 PETERSBURG AK 99833 PETERSBURG BOROUGH (907) 772-4291 Critical Access Hospitals Government - Local TRUE 56.8128691 -132.9554619 1 ROOFTOP 195 2 2195         https://data.medicare.gov/resource/xubh-q36u/row-ky7y_b72j_698p 21304 660160 2019-12-02 2019-06-30 12           12       15       27

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