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

17 rows where "filed_date" is on date 2019-11-27 and hospital_ownership = "Proprietary"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, county_name, hospital_type, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_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
33 33 RED BUD REGIONAL HOSPITAL 325 SPRING STREET RED BUD IL 62278 RANDOLPH (618) 282-3831 Critical Access Hospitals Proprietary TRUE 38.2096050 -89.9964080 0   157 17 17157         https://data.medicare.gov/resource/xubh-q36u/row-p29n.6wib~fbrj 141348 660526 2019-11-27 2019-06-30 25           25               25
366 366 NORTHEASTERN NEVADA REGIONAL HOSPITAL 2001 ERRECART BLVD ELKO NV 89801 ELKO (775) 738-5151 Acute Care Hospitals Proprietary TRUE 40.8225080 -115.7290260 0   7 32 32007 21220   Central Elko County https://data.medicare.gov/resource/xubh-q36u/row-q6r2~fn4e-z9r9 290008 662547 2019-11-27 2019-06-30 52 7         59               59
1164 1164 MARY HURLEY HOSPITAL 6 NORTH COVINGTON COALGATE OK 74538 COAL (580) 927-2327 Critical Access Hospitals Proprietary TRUE 34.5392220 -96.2242870 0   29 40 40029         https://data.medicare.gov/resource/xubh-q36u/row-vgqy-nnxi.ph5t 371319 661388 2019-11-27 2019-06-30 20           20               20
1171 1171 BRANDYWINE HOSPITAL 201 REECEVILLE ROAD COATESVILLE PA 19320 CHESTER (610) 383-8000 Acute Care Hospitals Proprietary TRUE 40.0095860 -75.7902630 0   29 42 42029 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Chester County https://data.medicare.gov/resource/xubh-q36u/row-3tb9_z7kw.8hjr 390076 660696 2019-11-27 2019-06-30 140 15         155 16             171
1172 1172 PHOENIXVILLE HOSPITAL 140 NUTT ROAD PHOENIXVILLE PA 19460 CHESTER (610) 983-1000 Acute Care Hospitals Proprietary TRUE 40.1333870 -75.5380530 0   29 42 42029 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Chester County https://data.medicare.gov/resource/xubh-q36u/row-y3he~wx68-j8cb 390127 660699 2019-11-27 2019-06-30 95 24         123   14           137
1439 1439 LONE PEAK HOSPITAL 11925 SOUTH STATE STREET DRAPER UT 84020 SALT LAKE (801) 545-8000 Acute Care Hospitals Proprietary TRUE 40.5352380 -111.8914640 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-3yfr.y4qy.386x 460060 662283 2019-11-27 2019-06-30 26 4         30               30
1776 1776 CHI MEMORIAL HOSPITAL- GEORGIA 100 GROSS CRESCENT CIRCLE FORT OGLETHORPE GA 30742 CATOOSA (770) 874-5400 Acute Care Hospitals Proprietary TRUE 34.9477700 -85.2627560 0   47 13 13047 16860 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Catoosa County https://data.medicare.gov/resource/xubh-q36u/row-a96y-gfhv_jnf7 110236 659941 2019-11-27 2019-06-30 36           36               36
2284 2284 EISENHOWER MEDICAL CENTER 39-000 BOB HOPE DRIVE RANCHO MIRAGE CA 92270 RIVERSIDE (760) 340-3911 Acute Care Hospitals Proprietary TRUE 33.7648520 -116.4080850 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-8rsp~gqw9-ukc2 50573 662165 2019-11-27 2019-06-30 311 34         345   23           368
2601 2601 SOUTHEASTERN REGIONAL MEDICAL CENTER 600 CELEBRATE LIFE PARKWAY NEWNAN GA 30265 COWETA (404) 844-8334 Acute Care Hospitals Proprietary FALSE 33.3863910 -84.7574190 0   77 13 13077 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Coweta County https://data.medicare.gov/resource/xubh-q36u/row-xjc6~cs4d.dgfj 110233 660205 2019-11-27 2019-06-30 45 5         50               50
2878 2878 CRESTWOOD MEDICAL CENTER ONE HOSPITAL DR SE HUNTSVILLE AL 35801 MADISON (256) 882-3100 Acute Care Hospitals Proprietary TRUE 34.6943814 -86.5720291 1 ROOFTOP 89 1 1089 26620 Huntsville-Decatur-Albertville, AL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-tkhv~u3mn_apnu 10131 659468 2019-11-27 2019-06-30 164 16         183               183
3147 3147 JFK MEDICAL CENTER 5301 S CONGRESS AVE ATLANTIS FL 33462 PALM BEACH (561) 965-7300 Acute Care Hospitals Proprietary TRUE 26.5985480 -80.0903100 0   99 12 12099 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Palm Beach County https://data.medicare.gov/resource/xubh-q36u/row-j4p6-7iw3.fhkt 100080 660497 2019-11-27 2019-06-30 551 72         623 92             715
3198 3198 MEDICAL CENTER OF TRINITY 9330 SR 54, STE 401 TRINITY FL 34655 PASCO (727) 834-4900 Acute Care Hospitals Proprietary TRUE 28.2060140 -82.6609640 0   101 12 12101 45300   Central Pasco County https://data.medicare.gov/resource/xubh-q36u/row-4d2n_cq7g-qn33 100191 660792 2019-11-27 2019-06-30 199 34       12 245 62             307
3234 3234 CHESTNUT HILL HOSPITAL 8835 GERMANTOWN AVE PHILADELPHIA PA 19118 PHILADELPHIA (215) 248-8200 Acute Care Hospitals Proprietary TRUE 40.0787910 -75.2127520 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-f7vd-4uzw~5mpg 390026 660694 2019-11-27 2019-06-30 114 14         128 20             148
3630 3630 WELLSTAR ATLANTA MEDICAL CENTER 303 PARKWAY DRIVE, NE ATLANTA GA 30312 FULTON (404) 265-4000 Acute Care Hospitals Proprietary TRUE 33.7632700 -84.3739860 0   121 13 13121 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Fulton County https://data.medicare.gov/resource/xubh-q36u/row-qjqh_i6pn~dht9 110115 660798 2019-11-27 2019-06-30 383 63       33 491 17 20           528
3633 3633 WELLSTAR NORTH FULTON HOSPITAL 3000 HOSPITAL BOULEVARD ROSWELL GA 30076 FULTON (770) 751-2500 Acute Care Hospitals Proprietary TRUE 34.0629890 -84.3224770 0   121 13 13121 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Fulton County https://data.medicare.gov/resource/xubh-q36u/row-bhvw-vh6x~dynd 110198 660370 2019-11-27 2019-06-30 141 28         169   33           202
4379 4379 TUG VALLEY ARH REGIONAL MEDICAL CENTER 260 HOSPITAL DRIVE SOUTH WILLIAMSON KY 41503 PIKE (606) 237-1700 Acute Care Hospitals Proprietary TRUE 37.6763730 -82.2965810 0   195 21 21195         https://data.medicare.gov/resource/xubh-q36u/row-nrkm~8dtb_x2ee 180069 662529 2019-11-27 2019-06-30 82 6         88       35       123
4525 4525 WELLSTAR SPALDING REGIONAL HOSPITAL 601 SOUTH 8TH STREET GRIFFIN GA 30223 SPALDING (770) 228-2721 Acute Care Hospitals Proprietary TRUE 33.2392150 -84.2656710 0   255 13 13255 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Spalding County https://data.medicare.gov/resource/xubh-q36u/row-i8c2-fhpr~cjn5 110031 660201 2019-11-27 2019-06-30 138 22         160               160

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