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

13 rows where "filed_date" is on date 2019-10-31 and hospital_ownership = "Proprietary"

View and edit SQL

Suggested facets: city, state, county_name, countyfips, statefips, statecountyfips, cbsacode, csatitle, countyequivalent, icu_beds, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, oth_longterm_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
26 CITY HOSPITAL AT WHITE ROCK 9440 POPPY DR DALLAS TX 75218 DALLAS (214) 324-6100 Acute Care Hospitals Proprietary TRUE 32.8355210 -96.7050010 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-5mze~mvpw.a56k 450678 655846 2019-10-31 2019-05-31 167 20         187               187
100 NORTHEAST REGIONAL MEDICAL CENTER 315 S OSTEOPATHY KIRKSVILLE MO 63501 ADAIR (660) 785-1000 Acute Care Hospitals Proprietary TRUE 40.1925230 -92.5908490 0   1 29 29001 28860   Central Adair County https://data.medicare.gov/resource/xubh-q36u/row-75xb~p5w7-egiy 260022 656302 2019-10-31 2019-05-31 41 10         51               51
167 ST JOSEPH HOSPITAL 700 BROADWAY FORT WAYNE IN 46802 ALLEN (260) 425-3000 Acute Care Hospitals Proprietary TRUE 41.0788910 -85.1488730 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-kr9f_9zxq-kk6p 150047 655893 2019-10-31 2019-05-31 76     12     88 19     20       127
557 ST LUKE'S MEDICAL CENTER 1800 EAST VAN BUREN STREET PHOENIX AZ 85006 MARICOPA (602) 251-8156 Acute Care Hospitals Proprietary TRUE 33.4514360 -112.0427670 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-uw3s~cbm4-5jyq 30037 655739 2019-10-31 2019-05-31 141 30         171 55 16           242
2089 OGDEN REGIONAL MEDICAL CENTER 5475 SOUTH 500 EAST OGDEN UT 84405 WEBER (801) 479-2111 Acute Care Hospitals Proprietary TRUE 41.1635020 -111.9686200 0   57 49 49057 36260 Salt Lake City-Provo-Orem, UT Central Weber County https://data.medicare.gov/resource/xubh-q36u/row-5jqt-h3ke-8iym 460005 656017 2019-10-31 2019-05-31 139 14       17 170           12   182
2671 RALEIGH GENERAL HOSPITAL 1710 HARPER ROAD BECKLEY WV 25801 RALEIGH (304) 256-4100 Acute Care Hospitals Proprietary TRUE 37.7864580 -81.2031030 0   81 54 54081 13220   Central Raleigh County https://data.medicare.gov/resource/xubh-q36u/row-imqm-cjnw~q5ww 510070 656810 2019-10-31 2019-05-31 268 16 16       300               300
2949 OVERLAND PARK REG MED CTR 10500 QUIVIRA ROAD OVERLAND PARK KS 66215 JOHNSON (913) 541-5000 Acute Care Hospitals Proprietary TRUE 38.9376130 -94.7237260 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-mp9r_9j7w~qbg7 170176 658984 2019-10-31 2019-05-31 182 25         270               270
2980 RESOLUTE HEALTH HOSPITAL 555 CREEKSIDE XING, NEW BRAUNFELS TX 78130 COMAL (469) 839-6778 Acute Care Hospitals Proprietary TRUE 29.7192100 -98.0712120 0   91 48 48091 41700   Central Comal County https://data.medicare.gov/resource/xubh-q36u/row-idje_46pq-7psy 670098 656215 2019-10-31 2019-05-31 80 16       16 112               112
3489 MEDICAL CITY DALLAS 7777 FOREST LANE DALLAS TX 75230 DALLAS (972) 566-6222 Acute Care Hospitals Proprietary TRUE 32.9094470 -96.7720890 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-3qng_3ekx.a9in 450647 656001 2019-10-31 2019-05-31 576 36 16   16 16 776   17           793
3547 CENTRAL FLORIDA REGIONAL HOSPITAL 1401 W SEMINOLE BLVD SANFORD FL 32771 SEMINOLE (407) 321-4500 Acute Care Hospitals Proprietary TRUE 28.8162020 -81.2835770 0   117 12 12117 36740 Orlando-Deltona-Daytona Beach, FL Central Seminole County https://data.medicare.gov/resource/xubh-q36u/row-ik5y.aie9-tk99 100161 658927 2019-10-31 2019-05-31 180 28         208   13           221
4614 BAYLOR SCOTT AND WHITE MEDICAL CENTER LAKE POINTE 6800 SCENIC DR ROWLETT TX 75088 DALLAS (972) 412-2273 Acute Care Hospitals Proprietary TRUE 32.9183510 -96.5095360 0   397 48 48397 19100 Dallas-Fort Worth, TX-OK Central Rockwall County https://data.medicare.gov/resource/xubh-q36u/row-x5ah.rt93-ynam 450742 655847 2019-10-31 2019-05-31 90 14       17 121               121
4637 MEDICAL CITY NORTH HILLS 4401 BOOTH CALLOWAY ROAD NORTH RICHLAND HILLS TX 76180 TARRANT (817) 255-1000 Acute Care Hospitals Proprietary TRUE 32.8294760 -97.2122340 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-wubf_54fb_7m6r 450087 655842 2019-10-31 2019-05-31 117 20         137 20             157
4655 MEDICAL CITY ARLINGTON 3301 MATLOCK ROAD ARLINGTON TX 76015 TARRANT (817) 465-3241 Acute Care Hospitals Proprietary TRUE 32.6917510 -97.1148000 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-vf2t.urzf.vx7i 450675 656370 2019-10-31 2019-05-31 248 45 6     36 335   16           351

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