hospital_data
Data source: Big Local News · About: big-local-datasette
22 rows where "fy_end_date" is on date 2018-11-30 sorted by nursing_fac_beds
This data as json, copyable, CSV (advanced)
Suggested facets: city, state, county_name, hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, filed_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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
345 | 345 | OROVILLE HOSPITAL | 2767 OLIVE HIGHWAY | OROVILLE | CA | 95966 | BUTTE | (530) 533-8500 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 39.5045350 | -121.5421060 | 0 | 7 | 6 | 6007 | 17020 | Central | Butte County | https://data.medicare.gov/resource/xubh-q36u/row-zach-cczm-89ek | 50030 | 647860 | 2019-05-15 | 2018-11-30 | 123 | 10 | 133 | 133 | |||||||||||||
671 | 671 | VALLEY VIEW MEDICAL CENTER | 5330 SOUTH HIGHWAY 95 | FORT MOHAVE | AZ | 86426 | MOHAVE | (928) 788-2273 | Acute Care Hospitals | Proprietary | TRUE | 35.0023630 | -114.5979540 | 0 | 15 | 4 | 4015 | 29420 | Las Vegas-Henderson, NV-AZ | Central | Mohave County | https://data.medicare.gov/resource/xubh-q36u/row-8tpg-vtcr.3uy5 | 30117 | 652034 | 2019-05-02 | 2018-11-30 | 60 | 12 | 72 | 12 | 84 | |||||||||||
1220 | 1220 | JOHN H STROGER JR HOSPITAL | 1901 W HARRISON ST | CHICAGO | IL | 60612 | COOK | (312) 864-6000 | Acute Care Hospitals | Government - Local | TRUE | 41.8740410 | -87.6743110 | 0 | 31 | 17 | 17031 | 16980 | Chicago-Naperville, IL-IN-WI | Central | Cook County | https://data.medicare.gov/resource/xubh-q36u/row-2ss5~bvsp.bpf4 | 140124 | 659251 | 2019-11-07 | 2018-11-30 | 310 | 32 | 8 | 14 | 448 | 448 | ||||||||||
1225 | 1225 | PROVIDENT HOSPITAL OF CHICAGO | 500 E 51ST ST | CHICAGO | IL | 60615 | COOK | (312) 572-2000 | Acute Care Hospitals | Government - Local | TRUE | 41.8021580 | -87.6141930 | 0 | 31 | 17 | 17031 | 16980 | Chicago-Naperville, IL-IN-WI | Central | Cook County | https://data.medicare.gov/resource/xubh-q36u/row-knkg_mg7f-2emf | 140300 | 659411 | 2019-11-05 | 2018-11-30 | 25 | 25 | 25 | |||||||||||||
1568 | 1568 | TRISTAR SKYLINE MEDICAL CENTER | 3441 DICKERSON PIKE | NASHVILLE | TN | 37207 | DAVIDSON | (615) 769-2000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 36.2453010 | -86.7564630 | 0 | 37 | 47 | 47037 | 34980 | Nashville-Davidson--Murfreesboro, TN | Central | Davidson County | https://data.medicare.gov/resource/xubh-q36u/row-t6tv~93h2_x5ai | 440006 | 647057 | 2019-04-25 | 2018-11-30 | 253 | 45 | 298 | 14 | 41 | 353 | ||||||||||
1953 | 1953 | JENNINGS AMERICAN LEGION HOSPITAL | 1634 ELTON ROAD | JENNINGS | LA | 70546 | JEFFRSON DAVIS | (337) 616-7000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 30.2392150 | -92.6634450 | 0 | 53 | 22 | 22053 | https://data.medicare.gov/resource/xubh-q36u/row-xvdw_xhgm-htky | 190053 | 647257 | 2019-05-01 | 2018-11-30 | 44 | 5 | 49 | 49 | ||||||||||||||||
2190 | 2190 | UP HEALTH SYSTEM PORTAGE | 500 CAMPUS DRIVE | HANCOCK | MI | 49930 | HOUGHTON | (906) 483-1000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 47.1413460 | -88.5856430 | 0 | 61 | 26 | 26061 | 26340 | Central | Houghton County | https://data.medicare.gov/resource/xubh-q36u/row-6hq7.pe78-x3td | 230108 | 647558 | 2019-05-01 | 2018-11-30 | 36 | 36 | 60 | 96 | |||||||||||||
2273 | 2273 | UT HEALTH EAST TEXAS PITTSBURG HOSPITAL | 2701 US HWY 271 N | PITTSBURG | TX | 75686 | CAMP | (903) 856-4520 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 33.0284300 | -94.9629660 | 0 | 63 | 48 | 48063 | https://data.medicare.gov/resource/xubh-q36u/row-5mqj~n356~t4cq | 451367 | 650536 | 2019-06-20 | 2018-11-30 | 25 | 25 | 25 | |||||||||||||||||
2642 | 2642 | SHOSHONE MEDICAL CENTER | 25 JACOBS GULCH ROAD | KELLOGG | ID | 83837 | SHOSHONE | (208) 784-1221 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 47.5471230 | -116.1314090 | 0 | 79 | 16 | 16079 | https://data.medicare.gov/resource/xubh-q36u/row-5s2d-murc_kv83 | 131314 | 647887 | 2019-05-02 | 2018-11-30 | 21 | 21 | 21 | |||||||||||||||||
3094 | 3094 | VISTA MEDICAL CENTER EAST | 1324 NORTH SHERIDAN ROAD | WAUKEGAN | IL | 60085 | LAKE | (847) 360-3000 | Acute Care Hospitals | Voluntary non-profit - Other | FALSE | 42.3782640 | -87.8309640 | 0 | 97 | 17 | 17097 | 16980 | Chicago-Naperville, IL-IN-WI | Central | Lake County | https://data.medicare.gov/resource/xubh-q36u/row-z8h2_y3pv-w7sx | 140084 | 653883 | 2019-08-27 | 2018-11-30 | 167 | 23 | 190 | 190 | ||||||||||||
3125 | 3125 | NORTH TEXAS MEDICAL CENTER | 1900 HOSPITAL BLVD | GAINESVILLE | TX | 76240 | COOKE | (940) 612-8600 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 33.6453560 | -97.1619760 | 0 | 97 | 48 | 48097 | 23620 | Dallas-Fort Worth, TX-OK | Central | Cooke County | https://data.medicare.gov/resource/xubh-q36u/row-7rqh-yn3d_yfnr | 450090 | 650373 | 2019-06-10 | 2018-11-30 | 31 | 5 | 36 | 36 | ||||||||||||
3184 | 3184 | SOUTHERN TENNESSEE REGIONAL HEALTH SYSTEM LAWRENCE | HWY 43 S BOX 847 | LAWRENCEBURG | TN | 38464 | LAWRENCE | (931) 762-6571 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 35.1400446 | -87.3699788 | 1 | GEOMETRIC_CENTER | 99 | 47 | 47099 | 29980 | Nashville-Davidson--Murfreesboro, TN | Central | Lawrence County | https://data.medicare.gov/resource/xubh-q36u/row-ghnd-6g8c~yazk | 440175 | 647058 | 2019-04-29 | 2018-11-30 | 83 | 6 | 89 | 10 | 99 | ||||||||||
3446 | 3446 | HILLCREST HOSPITAL HENRYETTA | 2401 W MAIN | HENRYETTA | OK | 74437 | OKMULGEE | (918) 650-1511 | Acute Care Hospitals | Proprietary | TRUE | 35.4397380 | -96.0154960 | 0 | 111 | 40 | 40111 | 46140 | Tulsa-Muskogee-Bartlesville, OK | Outlying | Okmulgee County | https://data.medicare.gov/resource/xubh-q36u/row-222q_tbcj-2m5z | 370183 | 646973 | 2019-04-26 | 2018-11-30 | 27 | 27 | 14 | 41 | ||||||||||||
3500 | 3500 | METHODIST HOSPITAL FOR SURGERY | 17101 DALLAS PARKWAY | ADDISON | TX | 75001 | DALLAS | (469) 248-3900 | Acute Care Hospitals | Proprietary | TRUE | 32.9851310 | -96.8288180 | 0 | 113 | 48 | 48113 | 19100 | Dallas-Fort Worth, TX-OK | Central | Dallas County | https://data.medicare.gov/resource/xubh-q36u/row-ge4u~ywgg~r953 | 670073 | 647316 | 2019-04-29 | 2018-11-30 | 28 | 4 | 32 | 32 | ||||||||||||
3621 | 3621 | HILLCREST HOSPITAL CUSHING | 1027 EAST CHERRY STREET | CUSHING | OK | 74023 | PAYNE | (918) 225-2915 | Acute Care Hospitals | Proprietary | TRUE | 35.9789420 | -96.7574730 | 0 | 119 | 40 | 40119 | 44660 | Central | Payne County | https://data.medicare.gov/resource/xubh-q36u/row-97eh~dcvw_6tpa | 370099 | 646972 | 2019-04-26 | 2018-11-30 | 70 | 4 | 74 | 21 | 95 | ||||||||||||
4074 | 4074 | IRWIN COUNTY HOSPITAL | 710 N IRWIN AVENUE | OCILLA | GA | 31774 | IRWIN | (229) 468-3845 | Acute Care Hospitals | Government - Hospital District or Authority | FALSE | 31.6027970 | -83.2503310 | 0 | 155 | 13 | 13155 | https://data.medicare.gov/resource/xubh-q36u/row-x4wh~4hz8~nrk6 | 110130 | 647117 | 2019-04-30 | 2018-11-30 | 34 | 34 | 30 | 64 | ||||||||||||||||
4137 | 4137 | MEADOWVIEW REGIONAL MEDICAL CENTER | 989 MEDICAL PARK DRIVE | MAYSVILLE | KY | 41056 | MASON | (606) 759-5311 | Acute Care Hospitals | Proprietary | TRUE | 38.6395720 | -83.8088040 | 0 | 161 | 21 | 21161 | 32500 | Cincinnati-Wilmington-Maysville, OH-KY-IN | Central | Mason County | https://data.medicare.gov/resource/xubh-q36u/row-cj45_n7yj~tj2z | 180019 | 647176 | 2019-04-30 | 2018-11-30 | 95 | 5 | 100 | 100 | ||||||||||||
4281 | 4281 | LIBERTY REGIONAL MEDICAL CENTER | 462 E G MILES PARKWAY | HINESVILLE | GA | 31310 | LIBERTY | (912) 369-9438 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 31.8394772 | -81.6009755 | 1 | ROOFTOP | 179 | 13 | 13179 | 25980 | Savannah-Hinesville-Statesboro, GA | Central | Liberty County | https://data.medicare.gov/resource/xubh-q36u/row-3b9g_44yp.xw63 | 111335 | 647248 | 2019-05-01 | 2018-11-30 | 25 | 25 | 108 | 133 | |||||||||||
4332 | 4332 | CLINCH VALLEY MEDICAL CENTER | 6801 GOVERNOR GC PERRY HIGHWAY | RICHLANDS | VA | 24641 | TAZEWELL | (276) 596-6000 | Acute Care Hospitals | Proprietary | TRUE | 37.0939780 | -81.8194440 | 0 | 185 | 51 | 51185 | 14140 | Central | Tazewell County | https://data.medicare.gov/resource/xubh-q36u/row-x352_282g.42tv | 490060 | 648023 | 2019-05-02 | 2018-11-30 | 139 | 12 | 151 | 19 | 170 | ||||||||||||
4488 | 4488 | LAKE GRANBURY MEDICAL CENTER | 1310 PALUXY RD | GRANBURY | TX | 76048 | HOOD | (817) 573-2683 | Acute Care Hospitals | Proprietary | TRUE | 32.4318450 | -97.8027290 | 0 | 221 | 48 | 48221 | 19100 | Dallas-Fort Worth, TX-OK | Outlying | Hood County | https://data.medicare.gov/resource/xubh-q36u/row-prqs_guzc_3igk | 450596 | 647586 | 2019-04-30 | 2018-11-30 | 36 | 12 | 48 | 48 | ||||||||||||
4516 | 4516 | THE MEDICAL CENTER OF SOUTHEAST TEXAS | 2555 JIMMY JOHNSON BLVD | PORT ARTHUR | TX | 77640 | JEFFERSON | (409) 853-5900 | Acute Care Hospitals | Physician | TRUE | 29.9349520 | -93.9850070 | 0 | 245 | 48 | 48245 | 13140 | Central | Jefferson County | https://data.medicare.gov/resource/xubh-q36u/row-adz2.98gm-mm6a | 450518 | 647059 | 2019-04-26 | 2018-11-30 | 151 | 24 | 10 | 185 | 20 | 11 | 216 | ||||||||||
4701 | 4701 | CEDAR PARK REGIONAL MEDICAL CENTER | 1401 MEDICAL PARKWAY | CEDAR PARK | TX | 78613 | WILLIAMSON | (512) 528-7000 | Acute Care Hospitals | Proprietary | TRUE | 30.5311240 | -97.8128240 | 0 | 491 | 48 | 48491 | 12420 | Central | Williamson County | https://data.medicare.gov/resource/xubh-q36u/row-rn6p~5mhb.xk3w | 670043 | 647207 | 2019-04-30 | 2018-11-30 | 73 | 12 | 93 | 93 |
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 );