hospital_data
Data source: Big Local News · About: big-local-datasette
17 rows where "fy_end_date" is on date 2017-12-31 sorted by csatitle
This data as json, copyable, CSV (advanced)
Suggested facets: hospital_name, state, hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, filed_date, acute_beds, icu_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
158 | 158 | SHRINERS HOSPITAL FOR CHILDREN | 1310 PUNAHOU STREET | HONOLULU | HI | 96826 | HONOLULU | (808) 941-4466 | Childrens | Voluntary non-profit - Private | FALSE | 21.3002330 | -157.8343650 | 0 | 3 | 15 | 15003 | 46520 | Central | Honolulu County | https://data.medicare.gov/resource/xubh-q36u/row-jcn3.53aq~rski | 123301 | 644976 | 2018-05-31 | 2017-12-31 | |||||||||||||||||
739 | 739 | SHRINERS HOSPITALS FOR CHILDREN | 3100 SAMFORD AVENUE | SHREVEPORT | LA | 71103 | CADDO | (318) 222-5704 | Childrens | Voluntary non-profit - Private | FALSE | 32.4812950 | -93.7566370 | 0 | 17 | 22 | 22017 | 43340 | Central | Caddo Parish | https://data.medicare.gov/resource/xubh-q36u/row-yvmb~28rx-rdcg | 193301 | 647125 | 2018-05-31 | 2017-12-31 | |||||||||||||||||
1055 | 1055 | SUMMIT MEDICAL CENTER | 6350 E 2ND STREET | CASPER | WY | 82609 | NATRONA | (307) 232-6600 | Acute Care Hospitals | Physician | FALSE | 42.8408460 | -106.2317960 | 0 | 25 | 56 | 56025 | 16220 | Central | Natrona County | https://data.medicare.gov/resource/xubh-q36u/row-8pwp.t3su_b96w | 530034 | 645740 | 2019-03-04 | 2017-12-31 | |||||||||||||||||
1578 | 1578 | ASPEN MOUNTAIN MEDICAL CENTER | 4401 COLLEGE DRIVE | ROCK SPRINGS | WY | 82901 | SWEETWATER | (307) 448-2758 | Acute Care Hospitals | Proprietary | FALSE | 41.6031870 | -109.2479170 | 0 | 37 | 56 | 56037 | 40540 | Central | Sweetwater County | https://data.medicare.gov/resource/xubh-q36u/row-x9bs.ynhd_upz4 | 530035 | 651148 | 2018-05-29 | 2017-12-31 | |||||||||||||||||
4579 | 4579 | LITTLE RIVER HEALTHCARE | 1700 BRAZOS | ROCKDALE | TX | 76567 | MILAM | (512) 446-4500 | Critical Access Hospitals | Proprietary | TRUE | 30.6503240 | -97.0201050 | 0 | 331 | 48 | 48331 | https://data.medicare.gov/resource/xubh-q36u/row-afvn-5pmv_graz | 451357 | 630239 | 2018-06-01 | 2017-12-31 | 25 | 25 | 25 | |||||||||||||||||
4620 | 4620 | CARE REGIONAL MEDICAL CENTER | 1711 W WHEELER AVENUE | ARANSAS PASS | TX | 78336 | SAN PATRICIO | (361) 758-8585 | Acute Care Hospitals | Proprietary | TRUE | 27.9159210 | -97.1618290 | 0 | 409 | 48 | 48409 | 18580 | Corpus Christi-Kingsville-Alice, TX | Central | San Patricio County | https://data.medicare.gov/resource/xubh-q36u/row-g7k6_vy64~c2bf | 450605 | 655598 | 2018-07-30 | 2017-12-31 | 63 | 63 | 12 | 75 | ||||||||||||
4432 | 4432 | SHRINERS HOSPITALS FOR CHILDREN | 6977 MAIN STREET | HOUSTON | TX | 77030 | HARRIS | (713) 797-1616 | Childrens | Voluntary non-profit - Other | FALSE | 29.7047380 | -95.4061740 | 0 | 201 | 48 | 48201 | 26420 | Houston-The Woodlands, TX | Central | Harris County | https://data.medicare.gov/resource/xubh-q36u/row-zk7z~jazy_wtka | 453312 | 651360 | 2018-07-12 | 2017-12-31 | ||||||||||||||||
191 | 191 | HARMON HOSPITAL | 2170 EAST HARMON AVENUE | LAS VEGAS | NV | 89119 | CLARK | (702) 794-0100 | Acute Care Hospitals | Voluntary non-profit - Private | FALSE | 36.1073690 | -115.1219920 | 0 | 3 | 32 | 32003 | 29820 | Las Vegas-Henderson, NV-AZ | Central | Clark County | https://data.medicare.gov/resource/xubh-q36u/row-qtzp-aczd_sysf | 290042 | 629833 | 2018-05-31 | 2017-12-31 | ||||||||||||||||
1501 | 1501 | SHRINERS HOSPITALS FOR CHILDREN | 3160 GENEVA STREET | LOS ANGELES | CA | 90020 | LOS ANGELES | (213) 388-3151 | Childrens | Voluntary non-profit - Private | FALSE | 34.0677080 | -118.2863870 | 0 | 37 | 6 | 6037 | 31080 | Los Angeles-Long Beach, CA | Central | Los Angeles County | https://data.medicare.gov/resource/xubh-q36u/row-zkfj-xhi2.ce89 | 53310 | 655536 | 2018-05-31 | 2017-12-31 | ||||||||||||||||
2296 | 2296 | DOCTORS HOSPITAL OF RIVERSIDE | 3865 JACKSON STREET | RIVERSIDE | CA | 92503 | RIVERSIDE | (951) 688-2211 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 33.9256970 | -117.4400520 | 0 | 65 | 6 | 6065 | 40140 | Los Angeles-Long Beach, CA | Central | Riverside County | https://data.medicare.gov/resource/xubh-q36u/row-sdgf-p94g_256s | 50102 | 654640 | 2018-05-31 | 2017-12-31 | 166 | 13 | 12 | 191 | 191 | |||||||||||
300 | 300 | WEISMAN CHILDRENS REHABILITATION HOSPITAL | 92 BRICK ROAD, 3RD FLOOR | MARLTON | NJ | 8053 | BURLINGTON | (856) 489-4520 | Childrens | Proprietary | TRUE | 39.8805880 | -74.9192090 | 0 | 5 | 34 | 34005 | 37980 | Philadelphia-Reading-Camden, PA-NJ-DE-MD | Central | Burlington County | https://data.medicare.gov/resource/xubh-q36u/row-9nkd_6jvc_38s2 | 313302 | 651476 | 2018-04-12 | 2017-12-31 | 18 | 18 | 18 | |||||||||||||
3238 | 3238 | SHRINERS HOSPITALS FOR CHILDREN - PHILADELPHIA | 3551 N BROAD STREET | PHILADELPHIA | PA | 19104 | PHILADELPHIA | (215) 430-4000 | Childrens | Voluntary non-profit - Other | FALSE | 40.0069680 | -75.1516990 | 0 | 101 | 42 | 42101 | 37980 | Philadelphia-Reading-Camden, PA-NJ-DE-MD | Central | Philadelphia County | https://data.medicare.gov/resource/xubh-q36u/row-iwpu.igc9.39y9 | 393309 | 629311 | 2018-05-30 | 2017-12-31 | ||||||||||||||||
1921 | 1921 | SHRINERS HOSPITAL FOR CHILDREN-PORTLAND | 3101 SW SAM JACKSON PARK ROAD | PORTLAND | OR | 97239 | MULTNOMAH | (971) 544-3312 | Childrens | Voluntary non-profit - Private | FALSE | 45.5001050 | -122.6846030 | 0 | 51 | 41 | 41051 | 38900 | Portland-Vancouver-Salem, OR-WA | Central | Multnomah County | https://data.medicare.gov/resource/xubh-q36u/row-3x85_ztpc_gwzg | 383300 | 645441 | 2018-05-31 | 2017-12-31 | ||||||||||||||||
2333 | 2333 | SHRINERS HOSPITALS FOR CHILDREN NORTHERN CALIF | 2425 STOCKTON BOULEVARD | SACRAMENTO | CA | 95817 | SACRAMENTO | (916) 453-2000 | Childrens | Voluntary non-profit - Private | FALSE | 38.5529930 | -121.4562690 | 0 | 67 | 6 | 6067 | 40900 | Sacramento-Roseville, CA | Central | Sacramento County | https://data.medicare.gov/resource/xubh-q36u/row-pctf.xrmj_v2ef | 53311 | 655537 | 2018-05-31 | 2017-12-31 | ||||||||||||||||
1441 | 1441 | SHRINERS HOSPITALS FOR CHILDREN - SALT LAKE CITY | 1275 EAST FAIRFAX ROAD | SALT LAKE CITY | UT | 84103 | SALT LAKE | (801) 536-3500 | Childrens | Voluntary non-profit - Private | FALSE | 40.7767640 | -111.8511170 | 0 | 35 | 49 | 49035 | 41620 | Salt Lake City-Provo-Orem, UT | Central | Salt Lake County | https://data.medicare.gov/resource/xubh-q36u/row-z268_bq8t.wgx8 | 463302 | 651875 | 2018-05-31 | 2017-12-31 | ||||||||||||||||
1979 | 1979 | MARY BRIDGE CHILDREN'S HOSPITAL | 317 MARTIN LUTHER KING JR W BOX 5299 | TACOMA | WA | 98415 | PIERCE | (253) 403-1400 | Childrens | Voluntary non-profit - Other | TRUE | 47.2587434 | -122.4527167 | 1 | ROOFTOP | 53 | 53 | 53053 | 42660 | Seattle-Tacoma, WA | Central | Pierce County | https://data.medicare.gov/resource/xubh-q36u/row-8c85~gidq~gevc | 503301 | 645385 | 2018-06-05 | 2017-12-31 | |||||||||||||||
2274 | 2274 | SHRINERS HOSPITAL FOR CHILDREN | 911 WEST 5TH AVENUE | SPOKANE | WA | 99204 | SPOKANE | (509) 623-0422 | Childrens | Voluntary non-profit - Private | FALSE | 47.6513980 | -117.4259570 | 0 | 63 | 53 | 53063 | 44060 | Spokane-Spokane Valley-Coeur d'Alene, WA-ID | Central | Spokane County | https://data.medicare.gov/resource/xubh-q36u/row-mctz_2czz-inqw | 503302 | 645453 | 2018-05-31 | 2017-12-31 |
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 );