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

12 rows where "filed_date" is on date 2019-06-03 and hospital_ownership = "Physician"

View and edit SQL

Suggested facets: state, county_name, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, statecountyfips, cbsacode, csatitle, countyequivalent, acute_beds, icu_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_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
576 CORE INSTITUTE SPECIALTY HOSPITAL, THE 6501 NORTH 19TH AVENUE PHOENIX AZ 85015 MARICOPA (602) 795-6020 Acute Care Hospitals Physician FALSE 33.5318370 -112.0996140 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-ymwb.kuwb~xe6j 30108 659179 2019-06-03 2018-12-31 32           32               32
740 SPECIALISTS HOSPITAL SHREVEPORT 1500 LINE AVENUE SHREVEPORT LA 71101 CADDO (318) 213-3800 Acute Care Hospitals Physician FALSE 32.4969260 -93.7460460 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-kr9t-dd8q-wfhi 190278 649901 2019-06-03 2018-12-31 15           15               15
1305 UNITY MEDICAL CENTER 481 INTERSTATE DRIVE MANCHESTER TN 37355 COFFEE (931) 728-6354 Acute Care Hospitals Physician TRUE 35.4979320 -86.0781410 0   31 47 47031 46100   Central Coffee County https://data.medicare.gov/resource/xubh-q36u/row-7ihq-cddj~pgik 440007 651231 2019-06-03 2018-12-31 49           49               49
2282 MENIFEE GLOBAL MEDICAL CENTER 28400 MCCALL B0ULEVARD SUN CITY CA 92585 RIVERSIDE (951) 679-8888 Acute Care Hospitals Physician FALSE 33.7189772 -117.1681518 1 ROOFTOP 65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-rqjx-c4v4.2ewv 50684 651179 2019-06-03 2018-12-31 74 10         84               84
2285 HEMET VALLEY MEDICAL CENTER 1117 EAST DEVONSHIRE HEMET CA 92543 RIVERSIDE (951) 652-2811 Acute Care Hospitals Physician TRUE 33.7512200 -116.9598590 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-nd99_qqgq_fexi 50390 650949 2019-06-03 2018-12-31 286 18         304       113       417
2532 MONROE SURGICAL HOSPITAL 2408 BROADMOOR BLVD MONROE LA 71201 OUACHITA (318) 410-0002 Acute Care Hospitals Physician FALSE 32.5367710 -92.1022040 0   73 22 22073 33740 Monroe-Ruston-Bastrop, LA Central Ouachita Parish https://data.medicare.gov/resource/xubh-q36u/row-2viy_tht4-abuk 190245 650140 2019-06-03 2018-12-31 10           10               10
2624 SURGICAL SPECIALTY CENTER AT COORDINATED HEALTH 1503 CEDAR CREST BOULEVARD ALLENTOWN PA 18104 LEHIGH (610) 871-9110 Acute Care Hospitals Physician FALSE 40.6121900 -75.5327500 0   77 42 42077 10900 New York-Newark, NY-NJ-CT-PA Central Lehigh County https://data.medicare.gov/resource/xubh-q36u/row-ecs5-8dzv.54i7 390321 650522 2019-06-03 2018-12-31 20           20       12       32
3066 COORDINATED HEALTH ORTHOPEDIC HOSPITAL 2310 HIGHLAND AVENUE BETHLEHEM PA 18017 NORTHAMPTON (610) 691-4300 Acute Care Hospitals Physician FALSE 40.6737620 -75.3654010 0   95 42 42095 10900 New York-Newark, NY-NJ-CT-PA Central Northampton County https://data.medicare.gov/resource/xubh-q36u/row-sc4k-g4c8.mwqt 390314 651057 2019-06-03 2018-12-31 20           20               20
3191 SUTTER SURGICAL HOSPITAL - NORTH VALLEY 455 PLUMAS BLVD YUBA CITY CA 95991 SUTTER (530) 749-5700 Acute Care Hospitals Physician FALSE 39.1321670 -121.6136030 0   101 6 6101 49700 Sacramento-Roseville, CA Central Sutter County https://data.medicare.gov/resource/xubh-q36u/row-rm5f.jnvd.d3k4 50766 651185 2019-06-03 2018-12-31 14           14               14
3401 OKLAHOMA SPINE HOSPITAL 14101 PARKWAY COMMONS DRIVE OKLAHOMA CITY OK 73134 OKLAHOMA (405) 749-2700 Acute Care Hospitals Physician TRUE 35.6141370 -97.5821240 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-g6tz_y8sg_qryk 370206 648756 2019-06-03 2018-12-31 23           23               23
4475 DOCTORS HOSPITAL AT RENAISSANCE 5501 SOUTH MCCOLL EDINBURG TX 78539 HIDALGO (956) 362-8677 Acute Care Hospitals Physician TRUE 26.2524240 -98.2041090 0   215 48 48215 32580 McAllen-Edinburg, TX Central Hidalgo County https://data.medicare.gov/resource/xubh-q36u/row-ie54-gr3x-shm2 450869 649837 2019-06-03 2018-12-31 287 58         394 87 38           519
4625 BAYLOR SCOTT & WHITE TEXAS SPINE & JOINT HOSPITAL 1814 ROSELAND BOULEVARD TYLER TX 75701 SMITH (903) 525-3300 Acute Care Hospitals Physician TRUE 32.3292480 -95.2994670 0   423 48 48423 46340 Tyler-Jacksonville, TX Central Smith County https://data.medicare.gov/resource/xubh-q36u/row-id2a~8wab-iya8 450864 649358 2019-06-03 2018-12-31 20           20               20

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