hospital_data
Data source: Big Local News · About: big-local-datasette
25 rows where "filed_date" is on date 2019-06-03 and hospital_ownership = "Government - Hospital District or Authority"
This data as json, copyable, CSV (advanced)
Suggested facets: state, hospital_type, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, coronary_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, oth_longterm_beds, all_beds, filed_date (date), fy_end_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
257 | 257 | PAGE HOSPITAL | 501 NORTH NAVAJO DRIVE | PAGE | AZ | 86040 | COCONINO | (928) 645-2424 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 36.9169600 | -111.4631860 | 0 | 5 | 4 | 4005 | 22380 | Central | Coconino County | https://data.medicare.gov/resource/xubh-q36u/row-pwtm.vez8_t2h2 | 31304 | 649070 | 2019-06-03 | 2018-12-31 | 25 | 25 | 25 | ||||||||||||||
328 | 328 | TRIOS | 900 SOUTH AUBURN STREET | KENNEWICK | WA | 99336 | BENTON | (509) 586-6111 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 46.1988750 | -119.1184630 | 0 | 5 | 53 | 53005 | 28420 | Central | Benton County | https://data.medicare.gov/resource/xubh-q36u/row-hs4k~gp5j~yv74 | 500053 | 651430 | 2019-06-03 | 2018-12-31 | 87 | 14 | 10 | 111 | 111 | ||||||||||||
397 | 397 | LAKE CHELAN COMMUNITY HOSPITAL | 503 EAST HIGHLAND | CHELAN | WA | 98816 | CHELAN | (509) 682-3300 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 47.8451390 | -120.0105110 | 0 | 7 | 53 | 53007 | 48300 | Central | Chelan County | https://data.medicare.gov/resource/xubh-q36u/row-a77p~uq78~jh3e | 501334 | 651089 | 2019-06-03 | 2018-12-31 | 25 | 25 | 25 | ||||||||||||||
552 | 552 | BANNER THUNDERBIRD MEDICAL CENTER | 5555 WEST THUNDERBIRD ROAD | GLENDALE | AZ | 85306 | MARICOPA | (602) 865-4470 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 33.6107310 | -112.1786980 | 0 | 13 | 4 | 4013 | 38060 | Central | Maricopa County | https://data.medicare.gov/resource/xubh-q36u/row-fmq8_nzm3.7bhy | 30089 | 649065 | 2019-06-03 | 2018-12-31 | 407 | 40 | 18 | 499 | 56 | 555 | |||||||||||
674 | 674 | SUTTER COAST HOSPITAL | 800 E WASHINGTON BLVD | CRESCENT CITY | CA | 95531 | DEL NORTE | (707) 464-8880 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 41.7726980 | -124.1941440 | 0 | 15 | 6 | 6015 | 18860 | Central | Del Norte County | https://data.medicare.gov/resource/xubh-q36u/row-m7v2.npcd-rkyf | 50417 | 650951 | 2019-06-03 | 2018-12-31 | 33 | 6 | 39 | 10 | 49 | ||||||||||||
828 | 828 | WEST CALCASIEU CAMERON HOSPITAL | 701 EAST CYPRESS STREET | SULPHUR | LA | 70663 | CALCASIEU | (337) 527-7034 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 30.2310740 | -93.3692900 | 0 | 19 | 22 | 22019 | 29340 | Central | Calcasieu Parish | https://data.medicare.gov/resource/xubh-q36u/row-swji~irkf_eud2 | 190013 | 650585 | 2019-06-03 | 2018-12-31 | 95 | 12 | 107 | 107 | |||||||||||||
1034 | 1034 | CIMARRON MEMORIAL HOSPITAL | 100 SOUTH ELLIS | BOISE CITY | OK | 73933 | CIMARRON | (580) 544-2501 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 36.7290550 | -102.5175370 | 0 | 25 | 40 | 40025 | https://data.medicare.gov/resource/xubh-q36u/row-9zte.pc9m_addj | 371307 | 650201 | 2019-06-03 | 2018-12-31 | 25 | 25 | 25 | |||||||||||||||||
1042 | 1042 | KANE COUNTY HOSPITAL | 355 NORTH MAIN STREET | KANAB | UT | 84741 | KANE | (435) 644-5811 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 37.0543240 | -112.5285900 | 0 | 25 | 49 | 49025 | https://data.medicare.gov/resource/xubh-q36u/row-g8j5_itr8_6iiy | 461309 | 649842 | 2019-06-03 | 2018-12-31 | 25 | 25 | 25 | |||||||||||||||||
1047 | 1047 | SAMARITAN HOSPITAL | 801 EAST WHEELER ROAD | MOSES LAKE | WA | 98837 | GRANT | (509) 765-5606 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 47.1311150 | -119.2647350 | 0 | 25 | 53 | 53025 | 34180 | Moses Lake-Othello, WA | Central | Grant County | https://data.medicare.gov/resource/xubh-q36u/row-6jdp_7427-cpfp | 500033 | 659384 | 2019-06-03 | 2018-12-31 | 36 | 12 | 48 | 48 | ||||||||||||
1363 | 1363 | EVERGREENHEALTH MEDICAL CENTER | 12040 NE 128TH STREET | KIRKLAND | WA | 98034 | KING | (425) 899-1000 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 47.7148720 | -122.1785060 | 0 | 33 | 53 | 53033 | 42660 | Seattle-Tacoma, WA | Central | King County | https://data.medicare.gov/resource/xubh-q36u/row-czqf-dh5d_37vj | 500124 | 651252 | 2019-06-03 | 2018-12-31 | 241 | 20 | 304 | 14 | 15 | 333 | ||||||||||
1575 | 1575 | KITTITAS VALLEY COMMUNITY HOSPITAL | 603 SOUTH CHESTNUT | ELLENSBURG | WA | 98926 | KITTITAS | (509) 962-9841 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 46.9876880 | -120.5367610 | 0 | 37 | 53 | 53037 | 21260 | Central | Kittitas County | https://data.medicare.gov/resource/xubh-q36u/row-c8za_geg7~y7ap | 501333 | 651088 | 2019-06-03 | 2018-12-31 | 19 | 6 | 25 | 1 | 26 | ||||||||||||
1622 | 1622 | KLICKITAT VALLEY HOSPITAL | 310 SOUTH ROOSEVELT | GOLDENDALE | WA | 98620 | KLICKITAT | (509) 773-4022 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 45.8202390 | -120.8122990 | 0 | 39 | 53 | 53039 | https://data.medicare.gov/resource/xubh-q36u/row-hemh_kxtf-bs6t | 501316 | 649846 | 2019-06-03 | 2018-12-31 | 14 | 14 | 14 | |||||||||||||||||
2094 | 2094 | ISLAND HOSPITAL | 1211 24TH STREET | ANACORTES | WA | 98221 | SKAGIT | (360) 299-1300 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 48.5028830 | -122.6158250 | 0 | 57 | 53 | 53057 | 34580 | Seattle-Tacoma, WA | Central | Skagit County | https://data.medicare.gov/resource/xubh-q36u/row-7mqw.zfgi.xhpw | 500007 | 651429 | 2019-06-03 | 2018-12-31 | 37 | 6 | 43 | 43 | ||||||||||||
2232 | 2232 | EVERGREENHEALTH MONROE | 14701 179TH SE | MONROE | WA | 98272 | SNOHOMISH | (360) 794-7497 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 47.8637270 | -121.9906240 | 0 | 61 | 53 | 53061 | 42660 | Seattle-Tacoma, WA | Central | Snohomish County | https://data.medicare.gov/resource/xubh-q36u/row-usdb-25x2~srt8 | 500084 | 651085 | 2019-06-03 | 2018-12-31 | 23 | 4 | 27 | 27 | ||||||||||||
2242 | 2242 | KIT CARSON COUNTY MEMORIAL HOSPITAL | 286 16TH ST | BURLINGTON | CO | 80807 | KIT CARSON | (719) 346-5311 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 39.3023780 | -102.2707110 | 0 | 63 | 8 | 8063 | https://data.medicare.gov/resource/xubh-q36u/row-xqzu-2pvu-xrfj | 61313 | 648525 | 2019-06-03 | 2018-12-31 | 19 | 19 | 19 | |||||||||||||||||
2388 | 2388 | ESTES PARK MEDICAL CENTER | 555 PROSPECT AVE | ESTES PARK | CO | 80517 | LARIMER | (970) 577-4470 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 40.3722590 | -105.5140880 | 0 | 69 | 8 | 8069 | 22660 | Central | Larimer County | https://data.medicare.gov/resource/xubh-q36u/row-3yeq~tw3h-6ggv | 61312 | 649878 | 2019-06-03 | 2018-12-31 | 25 | 25 | 60 | 6 | 91 | ||||||||||||
2395 | 2395 | COFFEE REGIONAL MEDICAL CENTER, INC | 1101 OCILLA ROAD | DOUGLAS | GA | 31533 | COFFEE | (912) 383-5620 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 31.5095890 | -82.8634600 | 0 | 69 | 13 | 13069 | 20060 | Central | Coffee County | https://data.medicare.gov/resource/xubh-q36u/row-d473_ue4x.74tq | 110089 | 652866 | 2019-06-03 | 2018-12-31 | 76 | 10 | 86 | 86 | |||||||||||||
2848 | 2848 | EAST MORGAN COUNTY HOSPITAL | 2400 WEST EDISON STREET | BRUSH | CO | 80723 | MORGAN | (970) 842-6222 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 40.2547380 | -103.6491780 | 0 | 87 | 8 | 8087 | 22820 | Central | Morgan County | https://data.medicare.gov/resource/xubh-q36u/row-33cv-duhz_he5u | 61303 | 649171 | 2019-06-03 | 2018-12-31 | 25 | 25 | 25 | ||||||||||||||
3209 | 3209 | WESTERN MISSOURI MEDICAL CENTER | 403 BURKARTH ROAD | WARRENSBURG | MO | 64093 | JOHNSON | (660) 747-2500 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 38.7664740 | -93.7237010 | 0 | 101 | 29 | 29101 | 47660 | Kansas City-Overland Park-Kansas City, MO-KS | Central | Johnson County | https://data.medicare.gov/resource/xubh-q36u/row-74d6_q73a.h7xv | 260097 | 650167 | 2019-06-03 | 2018-12-31 | 46 | 46 | 12 | 58 | ||||||||||||
3211 | 3211 | OGALLALA COMMUNITY HOSPITAL | 2601 NORTH SPRUCE ST | OGALLALA | NE | 69153 | KEITH | (308) 284-4011 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 41.1501770 | -101.7204470 | 0 | 101 | 31 | 31101 | https://data.medicare.gov/resource/xubh-q36u/row-g68g~zk9i.gtc5 | 281355 | 650174 | 2019-06-03 | 2018-12-31 | 18 | 18 | 18 | |||||||||||||||||
3555 | 3555 | RIVERSIDE MEDICAL CENTER | 1900 SOUTH MAIN ST | FRANKLINTON | LA | 70438 | WASHINGTON | (985) 795-4431 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 30.8351320 | -90.1519790 | 0 | 117 | 22 | 22117 | 14220 | New Orleans-Metairie-Hammond, LA-MS | Central | Washington Parish | https://data.medicare.gov/resource/xubh-q36u/row-biqu.ctdj-naqx | 191313 | 649031 | 2019-06-03 | 2018-12-31 | 20 | 5 | 25 | 25 | ||||||||||||
3594 | 3594 | MEADE DISTRICT HOSPITAL | 510 EAST CARTHAGE | MEADE | KS | 67864 | MEADE | (620) 873-2141 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 37.2854900 | -100.3342670 | 0 | 119 | 20 | 20119 | https://data.medicare.gov/resource/xubh-q36u/row-9yc7~mw74.3m9f | 171321 | 649590 | 2019-06-03 | 2018-12-31 | 20 | 20 | 45 | 65 | ||||||||||||||||
3703 | 3703 | WRAY COMMUNITY DISTRICT HOSPITAL | 1017 WEST 7TH ST | WRAY | CO | 80758 | YUMA | (970) 332-4811 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 40.0754050 | -102.2346600 | 0 | 125 | 8 | 8125 | https://data.medicare.gov/resource/xubh-q36u/row-jpdk~yrgm-qq54 | 61309 | 649710 | 2019-06-03 | 2018-12-31 | 16 | 16 | 16 | |||||||||||||||||
4270 | 4270 | WYANDOT MEMORIAL HOSPITAL | 885 NORTH SANDUSKY AVENUE | UPPER SANDUSKY | OH | 43351 | WYANDOT | (419) 294-4991 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 40.8418840 | -83.2807200 | 0 | 175 | 39 | 39175 | https://data.medicare.gov/resource/xubh-q36u/row-7m8m~3eqa_t4vr | 361329 | 649655 | 2019-06-03 | 2018-12-31 | 19 | 5 | 24 | 24 | ||||||||||||||||
4364 | 4364 | SUMNER COUNTY HOSPITAL DISTRICT NO 1 | 601 SOUTH OSAGE STREET | CALDWELL | KS | 67022 | SUMNER | (620) 845-6492 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 37.0262800 | -97.6096160 | 0 | 191 | 20 | 20191 | 48620 | Wichita-Arkansas City-Winfield, KS | Outlying | Sumner County | https://data.medicare.gov/resource/xubh-q36u/row-9v8g_4uhf~am74 | 171329 | 649593 | 2019-06-03 | 2018-12-31 | 25 | 25 | 25 |
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 );