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

35 rows where "fy_end_date" is on date 2018-10-31

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, filed_date, acute_beds, icu_beds, coronary_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, nursing_fac_beds, oth_longterm_beds, all_beds, filed_date (date)

fy_end_date (date) ✖

  • 2018-10-31 · 35 ✖
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
205 205 ORTHOPEDIC SPECIALTY HOSPITAL OF NEVADA 8656 WEST PATRICK LANE LAS VEGAS NV 89148 CLARK (702) 777-7100 Acute Care Hospitals Voluntary non-profit - Private FALSE 36.0778110 -115.2810360 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-zknv_98at.vvbk 290056 645924 2019-03-28 2018-10-31 130           130               130
505 505 BEAUREGARD MEMORIAL HOSPITAL 600 S PINE STREET DERIDDER LA 70634 BEAUREGARD (337) 462-7100 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.8419500 -93.2890560 0   11 22 22011 19760 DeRidder-Fort Polk South, LA Central Beauregard Parish https://data.medicare.gov/resource/xubh-q36u/row-wmc2_46c7-nnig 190050 646211 2019-04-05 2018-10-31 39 6       4 49               49
727 727 MARSHALL MEDICAL CENTER 1100 MARSHALL WAY PLACERVILLE CA 95667 EL DORADO (530) 622-1441 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7244830 -120.7906430 0   17 6 6017 40900 Sacramento-Roseville, CA Central El Dorado County https://data.medicare.gov/resource/xubh-q36u/row-7ka9-s7nn.458s 50254 645817 2019-04-01 2018-10-31 90 20         110       14       124
729 729 CITRUS MEMORIAL HOSPITAL 502 W HIGHLAND BLVD INVERNESS FL 34452 CITRUS (352) 726-1551 Acute Care Hospitals Government - Hospital District or Authority TRUE 28.8322420 -82.3353350 0   17 12 12017 26140   Central Citrus County https://data.medicare.gov/resource/xubh-q36u/row-dqwb_air4_xzeb 100023 656266 2019-10-23 2018-10-31 180 24         204               204
948 948 LAKE CITY MEDICAL CENTER 340 NW COMMERCE DR LAKE CITY FL 32055 COLUMBIA (386) 719-9000 Acute Care Hospitals Proprietary TRUE 30.1839800 -82.6862700 0   23 12 12023 29380 Gainesville-Lake City, FL Central Columbia County https://data.medicare.gov/resource/xubh-q36u/row-wa96.mnqq-ekzm 100156 646025 2019-04-01 2018-10-31 73 18         91               91
1299 1299 SOUTHWESTERN MEDICAL CENTER 5602 SOUTHWEST LEE BOULEVARD LAWTON OK 73505 COMANCHE (580) 531-4700 Acute Care Hospitals Proprietary TRUE 34.5943840 -98.4616920 0   31 40 40031 30020   Central Comanche County https://data.medicare.gov/resource/xubh-q36u/row-ug5c.7srv-ty4g 370097 645946 2019-03-29 2018-10-31 118 8         126   14       59   199
1532 1532 VAIL HEALTH HOSPITAL 181 W MEADOW DR VAIL CO 81657 EAGLE (970) 476-2451 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.6429490 -106.3828660 0   37 8 8037 20780 Edwards-Glenwood Springs, CO Central Eagle County https://data.medicare.gov/resource/xubh-q36u/row-8xv5~bebi.wqgh 60096 646197 2019-04-01 2018-10-31 51 5         56               56
1997 1997 HIGHLANDS REGIONAL MEDICAL CENTER 3600 S HIGHLANDS AVE SEBRING FL 33870 HIGHLANDS (863) 385-6101 Acute Care Hospitals Proprietary TRUE 27.4650450 -81.4337610 0   55 12 12055 42700   Central Highlands County https://data.medicare.gov/resource/xubh-q36u/row-6vfw.6x85-pap2 100049 646319 2019-04-01 2018-10-31 94 16         110               110
2050 2050 MEMORIAL HOSPITAL OF TAMPA 2901 W SWANN AVE TAMPA FL 33609 HILLSBOROUGH (813) 873-6400 Acute Care Hospitals Proprietary TRUE 27.9374430 -82.4898160 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-zzzr_828w.hedr 100206 659646 2019-11-12 2018-10-31 135 12         147 36             183
2076 2076 RUBY VALLEY MEDICAL CENTER 321 MADISON ST SHERIDAN MT 59749 MADISON (406) 842-5453 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.4525850 -112.1914530 0   57 30 30057         https://data.medicare.gov/resource/xubh-q36u/row-w73r_tdsp_m6z4 271319 647382 2019-04-29 2018-10-31 10           10               10
2230 2230 FAUQUIER HOSPITAL 500 HOSPITAL DRIVE WARRENTON VA 20186 FAUQUIER (540) 316-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7148580 -77.8083060 0   61 51 51061 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Fauquier County https://data.medicare.gov/resource/xubh-q36u/row-mwz4~6ryv~pd4v 490023 645868 2019-04-02 2018-10-31 89 8         97               97
2410 2410 HENRY COUNTY HOSPITAL, INC 1600 EAST RIVERVIEW AVENUE NAPOLEON OH 43545 HENRY (419) 592-4015 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4101620 -84.0882890 0   69 39 39069         https://data.medicare.gov/resource/xubh-q36u/row-4mh3_c94u-9wvc 361309 646232 2019-04-01 2018-10-31 20 5         25               25
2549 2549 UT HEALTH EAST TEXAS JACKSONVILLE HOSPITAL 501 S RAGSDALE JACKSONVILLE TX 75766 CHEROKEE (903) 541-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.9614180 -95.2705470 0   73 48 48073 27380 Tyler-Jacksonville, TX Central Cherokee County https://data.medicare.gov/resource/xubh-q36u/row-pg2x-3dzk~tz3s 450194 645998 2019-04-01 2018-10-31 32           32               32
2608 2608 POINTE COUPEE GENERAL HOSPITAL 2202 FALSE RIVER DRIVE NEW ROADS LA 70760 POINTE COUPEE (225) 368-6386 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.6825160 -91.4613720 0   77 22 22077 12940   Outlying Pointe Coupee Parish https://data.medicare.gov/resource/xubh-q36u/row-xvrh.yvqv~4kd5 191316 650821 2019-06-24 2018-10-31 25           25               25
2847 2847 COLORADO PLAINS MEDICAL CENTER 1000 LINCOLN ST FORT MORGAN CO 80701 MORGAN (970) 867-3391 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.2593440 -103.7962100 0   87 8 8087 22820   Central Morgan County https://data.medicare.gov/resource/xubh-q36u/row-nm37-j9mi~bfvp 60044 645885 2019-03-28 2018-10-31 30 6         36 14             50
2956 2956 ST HELENA PARISH HOSPITAL 16874 HIGHWAY 43 GREENSBURG LA 70441 ST. HELENA (225) 222-6111 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.8312500 -90.6670020 0   91 22 22091 12940   Outlying St. Helena Parish https://data.medicare.gov/resource/xubh-q36u/row-b8tn_kspp-zsgy 191300 646033 2019-04-01 2018-10-31 25           25               25
2967 2967 PHYSICIAN'S CARE SURGICAL HOSPITAL 454 ENTERPRISE DRIVE ROYERSFORD PA 19468 MONTGOMERY (610) 495-4793 Acute Care Hospitals Physician FALSE 40.2167860 -75.5537070 0   91 42 42091 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-xf95-5spw~uirp 390324 646044 2019-04-01 2018-10-31 12           12               12
3359 3359 STONESPRINGS HOSPITAL CENTER 24440 STONE SPRINGS BOULEVARD DULLES VA 20166 LOUDOUN (571) 349-4000 Acute Care Hospitals Proprietary TRUE 38.9411850 -77.5443010 0   107 51 51107 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Loudoun County https://data.medicare.gov/resource/xubh-q36u/row-2vb9~tm4j.az4x 490145 646054 2019-04-01 2018-10-31 114 10         124               124
3710 3710 WEST FELICIANA PARISH HOSPITAL 5266 COMMERCE STREET, BUILDING B SAINT FRANCISVILLE LA 70775 WEST FELICIANA (225) 635-3811 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.7836100 -91.3656960 0   125 22 22125 12940   Outlying West Feliciana Parish https://data.medicare.gov/resource/xubh-q36u/row-2auk~kxvq-q4u4 191306 660809 2019-11-20 2018-10-31 25           25               25
3716 3716 HURON VALLEY-SINAI HOSPITAL ONE WILLIAM CARLS DRIVE COMMERCE TOWNSHIP MI 48382 OAKLAND (248) 937-3370 Acute Care Hospitals Proprietary TRUE 42.5925502 -83.4988560 1 ROOFTOP 125 26 26125 19820 Detroit-Warren-Ann Arbor, MI Central Oakland County https://data.medicare.gov/resource/xubh-q36u/row-wtwz.wnac-edau 230277 646341 2019-03-21 2018-10-31 118 12         130               130
3717 3717 STRAITH HOSPITAL FOR SPECIAL SURGERY 23901 LAHSER SOUTHFIELD MI 48033 OAKLAND (248) 357-3360 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.4643320 -83.2603940 0   125 26 26125 19820 Detroit-Warren-Ann Arbor, MI Central Oakland County https://data.medicare.gov/resource/xubh-q36u/row-d7p2~k82s-2c2v 230071 646398 2019-03-28 2018-10-31 34           34               34
3818 3818 HILLCREST HOSPITAL CLAREMORE 1202 N MUSKOGEE PLACE CLAREMORE OK 74017 ROGERS (918) 341-2556 Acute Care Hospitals Proprietary TRUE 36.3225300 -95.6053360 0   131 40 40131 46140 Tulsa-Muskogee-Bartlesville, OK Outlying Rogers County https://data.medicare.gov/resource/xubh-q36u/row-cp8p~srz7~x9a2 370039 646404 2019-03-26 2018-10-31 48 6         54 11             65
3941 3941 NORTHWEST MEDICAL CENTER-SPRINGDALE 609 WEST MAPLE AVENUE SPRINGDALE AR 72764 WASHINGTON (479) 751-5711 Acute Care Hospitals Proprietary TRUE 36.1813940 -94.1364640 0   143 5 5143 22220   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-atff~z7gw_d5cc 40022 646013 2019-03-29 2018-10-31 254 21         275   25           300
4267 4267 MOBERLY REGIONAL MEDICAL CENTER 1515 UNION AVE MOBERLY MO 65270 RANDOLPH (660) 263-8400 Acute Care Hospitals Proprietary TRUE 39.4238790 -92.4142160 0   175 29 29175 33620 Columbia-Moberly-Mexico, MO Central Randolph County https://data.medicare.gov/resource/xubh-q36u/row-jgx5~792f~m59u 260074 646562 2019-04-02 2018-10-31 25 8         33 18             51
4276 4276 RAY COUNTY MEMORIAL HOSPITAL 904 WOLLARD BOULEVARD RICHMOND MO 64085 RAY (816) 470-5432 Critical Access Hospitals Government - Local TRUE 39.2643940 -93.9561730 0   177 29 29177 28140 Kansas City-Overland Park-Kansas City, MO-KS Outlying Ray County https://data.medicare.gov/resource/xubh-q36u/row-mqv3.5d72~fjx6 261327 644761 2019-02-27 2018-10-31 25           25               25
4299 4299 MARIA PARHAM MEDICAL CENTER PO BOX 59 HENDERSON NC 27536 VANCE (252) 431-3708 Acute Care Hospitals Proprietary TRUE 36.3338756 -78.3955986 1 APPROXIMATE 181 37 37181 25780 Raleigh-Durham-Chapel Hill, NC Central Vance County https://data.medicare.gov/resource/xubh-q36u/row-cv45-zcn2-4te2 340132 646039 2019-04-02 2018-10-31 71 20         91   11           102
4360 4360 TENNOVA HEALTHCARE-LEBANON 1411 BADDOUR PARKWAY LEBANON TN 37087 WILSON (615) 444-8262 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.2191730 -86.3283180 0   189 47 47189 34980 Nashville-Davidson--Murfreesboro, TN Central Wilson County https://data.medicare.gov/resource/xubh-q36u/row-ktrn_ki3w-2r7d 440193 646359 2019-03-20 2018-10-31 158 12         170 49 26           245
4393 4393 WYTHE COUNTY COMMUNITY HOSPITAL 600 WEST RIDGE ROAD WYTHEVILLE VA 24382 WYTHE (276) 228-0200 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.9532970 -81.0950690 0   197 51 51197         https://data.medicare.gov/resource/xubh-q36u/row-2f6p~evdq~actr 490111 645869 2019-04-02 2018-10-31 86 6         92       8       100
4411 4411 ST JOSEPH MEDICAL CENTER 1401 ST. JOSEPH PARKWAY HOUSTON TX 77002 HARRIS (713) 757-1000 Acute Care Hospitals Proprietary TRUE 29.7478980 -95.3663900 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-rx3w_mhdd-ztnk 450035 646180 2019-03-29 2018-10-31 189 24       35 248 99 13   18       378
4446 4446 ROCKCASTLE REGIONAL HOSPITAL & RESPIRATORY CARE CT 145 NEWCOMB AVENUE MOUNT VERNON KY 40456 ROCKCASTLE (606) 256-2195 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3580060 -84.3370010 0   203 21 21203 40080 Lexington-Fayette--Richmond--Frankfort, KY Outlying Rockcastle County https://data.medicare.gov/resource/xubh-q36u/row-3bvu-6res-7u6h 180115 646683 2019-04-17 2018-10-31 20           20       127       147
4463 4463 SULLIVAN COUNTY MEMORIAL HOSPITAL 630 WEST THIRD STREET MILAN MO 63556 SULLIVAN (660) 265-4212 Critical Access Hospitals Government - Local TRUE 40.2021740 -93.1311360 0   211 29 29211         https://data.medicare.gov/resource/xubh-q36u/row-puyt~jfux-w58a 261306 659511 2019-02-26 2018-10-31 17           17         9     26
4498 4498 WAYNE COUNTY HOSPITAL 166 HOSPITAL STREET MONTICELLO KY 42633 WAYNE (606) 348-9343 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.8200460 -84.8668210 0   231 21 21231         https://data.medicare.gov/resource/xubh-q36u/row-dqvi_ts99-8324 181321 646210 2019-03-29 2018-10-31 25           25               25
4536 4536 SEARHC WRANGELL MEDICAL CENTER-CAH 310 BENNETT STREET PO BOX 1081 WRANGELL AK 99929 WRANGELL CITY AND BOROUGH (907) 874-7000 Critical Access Hospitals Government - Local FALSE 56.4716460 -132.3764140 0   275 2 2275         https://data.medicare.gov/resource/xubh-q36u/row-n33k~as59_upeg 21305 645317 2019-03-18 2018-10-31 8           8       14       22
4623 4623 UT HEALTH EAST TEXAS TYLER REGIONAL HOSPITAL 1000 SOUTH BECKHAM AVE TYLER TX 75701 SMITH (903) 597-0351 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.3381020 -95.2918620 0   423 48 48423 46340 Tyler-Jacksonville, TX Central Smith County https://data.medicare.gov/resource/xubh-q36u/row-in8p-wss8_dwt9 450083 646360 2019-04-01 2018-10-31 285 54         339               339
4672 4672 ST DAVID'S SOUTH AUSTIN MEDICAL CENTER 901 WEST BEN WHITE BLVD AUSTIN TX 78704 TRAVIS (512) 448-7107 Acute Care Hospitals Proprietary TRUE 30.2273080 -97.7739440 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-rayk~bjtr.nfad 450713 654760 2019-10-03 2018-10-31 252 30 8     9 299               299

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