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

24 rows where "filed_date" is on date 2019-09-30

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, county_name, hospital_type, hospital_ownership, geocode_flag, geocode_accuracy, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, fy_end_date, acute_beds, icu_beds, burn_beds, surg_icu_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, oth_longterm_beds, all_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-09-30 · 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
138 138 CANYON VISTA MEDICAL CENTER 5700 EAST HIGHWAY 90 SIERRA VISTA AZ 85635 COCHISE (520) 263-3001 Acute Care Hospitals Voluntary non-profit - Other TRUE 31.5546350 -110.2307260 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-ghfv-yx8h~hkgn 30043 654824 2019-09-30 2019-04-30 63 12         75 19             94
437 437 MOUNT DESERT ISLAND HOSPITAL 10 WAYMAN LANE, PO BOX 8 BAR HARBOR ME 4609 HANCOCK (207) 288-5081 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3843690 -68.2023310 0   9 23 23009         https://data.medicare.gov/resource/xubh-q36u/row-egex~7j5d.98hj 201304 654844 2019-09-30 2019-04-30 25           25               25
488 488 MEMORIAL HOSPITAL PEMBROKE 7800 SHERIDAN ST PEMBROKE PINES FL 33024 BROWARD (954) 962-9650 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.0309290 -80.2461200 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-qfg8-j8yz-crbc 100230 658928 2019-09-30 2019-04-30 277 24         301               301
491 491 UNIVERSITY HOSPITAL AND MEDICAL CENTER 7201 N UNIVERSITY DR TAMARAC FL 33321 BROWARD (954) 721-2200 Acute Care Hospitals Proprietary TRUE 26.2113850 -80.2525430 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-qbz6.9rz8_v3uh 100224 654910 2019-09-30 2019-04-30 230 15         245 60             305
495 495 MEMORIAL HOSPITAL MIRAMAR 1901 SW 172ND AVE MIRAMAR FL 33029 BROWARD (954) 538-4810 Acute Care Hospitals Government - Hospital District or Authority TRUE 25.9910870 -80.3760050 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-7am8-6328_i4i2 100285 654991 2019-09-30 2019-04-30 144 18       16 178               178
502 502 PERRY MEMORIAL HOSPITAL 530 PARK AVENUE EAST PRINCETON IL 61356 BUREAU (815) 875-2811 Critical Access Hospitals Government - Local TRUE 41.3680100 -89.4559580 0   11 17 17011 36860 Chicago-Naperville, IL-IN-WI Central Bureau County https://data.medicare.gov/resource/xubh-q36u/row-93jr-f3xy_p6h2 141337 654839 2019-09-30 2019-04-30 22 3         25               25
768 768 HUDSON REGIONAL HOSPITAL 55 MEADOWLANDS PKWY SECAUCUS NJ 7094 HUDSON (201) 392-3200 Acute Care Hospitals Proprietary TRUE 40.7918050 -74.0720990 0   17 34 34017 35620 New York-Newark, NY-NJ-CT-PA Central Hudson County https://data.medicare.gov/resource/xubh-q36u/row-ndru~dizp-vj9e 310118 654744 2019-09-30 2018-12-31 88 14         102   4           106
1837 1837 CLARK REGIONAL MEDICAL CENTER 175 HOSPITAL DRIVE WINCHESTER KY 40391 CLARK (859) 737-8559 Acute Care Hospitals Proprietary TRUE 38.0105110 -84.2145900 0   49 21 21049 30460 Lexington-Fayette--Richmond--Frankfort, KY Outlying Clark County https://data.medicare.gov/resource/xubh-q36u/row-6qnq-q4j6-cjcb 180092 655000 2019-09-30 2019-04-30 46 8         54       25       79
2021 2021 THE NEBRASKA MEDICAL CENTER 987400 NEBRASKA MEDICAL CENTER OMAHA NE 68198 DOUGLAS (402) 552-2040 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2575141 -96.0049478 1 ROOFTOP 55 31 31055 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-rj72.yueh.kiv4 280013 654934 2019-09-30 2019-06-30 433 61     12   548 10             558
2224 2224 GRANDE RONDE HOSPITAL 900 SUNSET DRIVE LA GRANDE OR 97850 UNION (541) 963-8421 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.3194640 -118.1048280 0   61 41 41061 29260   Central Union County https://data.medicare.gov/resource/xubh-q36u/row-k86m-d2cq~y5ce 381321 655414 2019-09-30 2019-04-30 21 4         25               25
2344 2344 WELLSTAR COBB HOSPITAL 3950 AUSTELL RD AUSTELL GA 30106 COBB (770) 732-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.8567010 -84.6015610 0   67 13 13067 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Cobb County https://data.medicare.gov/resource/xubh-q36u/row-9x86.sqzq-hgnz 110143 654421 2019-09-30 2019-06-30 308 26   8   25 367   20           387
2689 2689 BLAKE MEDICAL CENTER 2020 59TH ST W BRADENTON FL 34209 MANATEE (941) 792-6611 Acute Care Hospitals Proprietary TRUE 27.4821760 -82.6204680 0   81 12 12081 35840 North Port-Sarasota, FL Central Manatee County https://data.medicare.gov/resource/xubh-q36u/row-u4hx_qmug-pkiw 100213 654646 2019-09-30 2019-04-30 312 43         355   28           383
2991 2991 RAULERSON HOSPITAL 1796 HWY 441 NORTH OKEECHOBEE FL 34972 OKEECHOBEE (863) 763-2151 Acute Care Hospitals Proprietary TRUE 27.2605370 -80.8298750 0   93 12 12093 36380 Miami-Fort Lauderdale-Port St. Lucie, FL Central Okeechobee County https://data.medicare.gov/resource/xubh-q36u/row-vc8e_g3z6_7i2k 100252 654911 2019-09-30 2019-04-30 92 8         100               100
3035 3035 GALESBURG COTTAGE HOSPITAL 695 N KELLOGG ST GALESBURG IL 61401 KNOX (309) 343-8131 Acute Care Hospitals Proprietary TRUE 40.9554830 -90.3661990 0   95 17 17095 23660   Central Knox County https://data.medicare.gov/resource/xubh-q36u/row-yqg9.hnf4.susd 140040 654913 2019-09-30 2019-04-30 84 12         96 16             112
3256 3256 ST PETERSBURG GENERAL HOSPITAL 6500 38TH AVE N SAINT PETERSBURG FL 33710 PINELLAS (727) 384-1414 Acute Care Hospitals Proprietary TRUE 27.8062990 -82.7272970 0   103 12 12103 45300   Central Pinellas County https://data.medicare.gov/resource/xubh-q36u/row-3jhj_fk97_piqx 100180 654909 2019-09-30 2019-04-30 147 21         168               168
3659 3659 TEXAS HEALTH PRESBYTERIAN HOSPITAL DENTON 3000 N I-35 DENTON TX 76201 DENTON (940) 898-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.2158990 -97.1684090 0   121 48 48121 19100 Dallas-Fort Worth, TX-OK Outlying Denton County https://data.medicare.gov/resource/xubh-q36u/row-zgka~geeq~8cey 450743 654761 2019-09-30 2019-04-30 166 20       10 196               196
3884 3884 DUNCAN REGIONAL HOSPITAL, INC 1407 WHISENANT DRIVE DUNCAN OK 73533 STEPHENS (580) 252-5300 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5200140 -97.9749780 0   137 40 40137 20340   Central Stephens County https://data.medicare.gov/resource/xubh-q36u/row-dpp7.xywm-n53y 370023 654693 2019-09-30 2019-06-30 77 9         86 12 12           110
3921 3921 COLUMBUS COMMUNITY HOSPITAL 4600 38TH ST COLUMBUS NE 68601 PLATTE (402) 562-3351 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.4532730 -97.3849000 0   141 31 31141 18100   Central Platte County https://data.medicare.gov/resource/xubh-q36u/row-bffi-hycr-hipw 280111 654935 2019-09-30 2019-04-30 42 5         47           4   51
3969 3969 PINCKNEYVILLE COMMUNITY HOSPITAL 5383 STATE ROUTE 154 PINCKNEYVILLE IL 62274 PERRY (618) 357-2187 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.0802300 -89.3686310 0   145 17 17145         https://data.medicare.gov/resource/xubh-q36u/row-dga8~impq_xpvi 141307 654837 2019-09-30 2019-04-30 17           17               17
4121 4121 HOSPITAL DISTRICT #1 OF RICE COUNTY 619 SOUTH CLARK AVENUE LYONS KS 67554 RICE (620) 257-5173 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.3416700 -98.2161460 0   159 20 20159         https://data.medicare.gov/resource/xubh-q36u/row-pqa8~iuy6-awei 171330 654925 2019-09-30 2019-04-30 25           25               25
4262 4262 FAIRVIEW PARK HOSPITAL 200 INDUSTRIAL BOULEVARD DUBLIN GA 31021 LAURENS (478) 274-3100 Acute Care Hospitals Proprietary TRUE 32.5342900 -82.9505710 0   175 13 13175 20140   Central Laurens County https://data.medicare.gov/resource/xubh-q36u/row-hhiu.9x9h.7ym6 110125 654912 2019-09-30 2019-04-30 129 16         145   15           160
4326 4326 BAPTIST HEALTH LA GRANGE 1025 NEW MOODY LANE LA GRANGE KY 40031 OLDHAM (502) 222-5388 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.3962380 -85.3759270 0   185 21 21185 31140 Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Central Oldham County https://data.medicare.gov/resource/xubh-q36u/row-eznz.mv36_3xzu 180138 656281 2019-09-30 2018-08-31 82 8         90       30       120
4341 4341 WILLIAMSON MEDICAL CENTER 4321 CAROTHERS PARKWAY FRANKLIN TN 37067 WILLIAMSON (615) 435-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.9166840 -86.8170470 0   187 47 47187 34980 Nashville-Davidson--Murfreesboro, TN Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-56fd~fukj-xja8 440029 654600 2019-09-30 2019-06-30 157 28         185               185
4456 4456 UNIVERSITY OF KANSAS HOSPITAL 4000 CAMBRIDGE STREET KANSAS CITY KS 66160 WYANDOTTE (913) 588-7332 Acute Care Hospitals Government - Hospital District or Authority TRUE 39.0553950 -94.6082290 0   209 20 20209 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Wyandotte County https://data.medicare.gov/resource/xubh-q36u/row-eypu_w27y~gqr6 170040 654923 2019-09-30 2019-06-30 704 106       32 848 15 29           892

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