hospital_data
Data source: Big Local News · About: big-local-datasette
35 rows where "fy_end_date" is on date 2018-10-31 sorted by state
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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||||
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 | ||||||||||||
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 | |||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | |||||||||||||||||
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 | |||||||||||
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 | ||||||||||||||
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 | ||||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | ||||||||||||||||
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 | |||||||||||||||||
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 | ||||||||||
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 | |||||||||||||
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 | ||||||||||||||||
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 | |||||||||||
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 | |||||||||||
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 | |||||||||||||
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 | ||||||||||
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 | |||||||||||||
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 | ||||||||
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 | |||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 |
Advanced export
JSON shape: default, array, newline-delimited
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 );