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

9 rows where hospital_ownership = "Tribal"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, emergency_services, geocode_flag, geocode_accuracy, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, filed_date, subprovider_ipf_beds, skilled_nursing_beds, filed_date (date), fy_end_date (date)

hospital_ownership ✖

  • Tribal · 9 ✖
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
724 724 HOPI HEALTH CARE CENTER HIGHWAY 264, MILEPOST 388 POLACCA AZ 86042 NAVAJO (928) 737-6000 Critical Access Hospitals Tribal FALSE 35.8022226 -110.4260281 1 GEOMETRIC_CENTER 17 4 4017 43320   Central Navajo County https://data.medicare.gov/resource/xubh-q36u/row-6zw9_3xdm~7vqp 31305 646377 2019-03-28 2018-09-30 6           6               6
800 800 SELLS HOSPITAL HIGHWAY 86, AT TOPAWA ROAD SELLS AZ 85634 PIMA (520) 362-7003 Acute Care Hospitals Tribal TRUE 31.9183549 -111.8792747 1 GEOMETRIC_CENTER 19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-57e8_mqp9-5x9d 30074 651599 2019-07-10 2018-09-30 14           14               14
1885 1885 YUKON KUSKOKWIM DELTA REG HOSPITAL PO BOX 287 BETHEL AK 99559 BETHEL (907) 543-6300 Acute Care Hospitals Tribal TRUE 60.7922222 -161.7558334 1 GEOMETRIC_CENTER 50 2 2050         https://data.medicare.gov/resource/xubh-q36u/row-7gdx-n37w_5vx9 20018 651309 2019-07-02 2018-09-30 34           34               34
2621 2621 CHOCTAW NATION HEALTH SERVICES AUTHORITY 1 CHOCTAW WAY TALIHINA OK 74571 LATIMER (918) 567-7000 Acute Care Hospitals Tribal TRUE 34.7537210 -95.0819060 0   77 40 40077         https://data.medicare.gov/resource/xubh-q36u/row-32zv~xccv_piej 370172 651345 2019-07-02 2018-09-30 43           43               43
3353 3353 CREEK NATION COMMUNITY HOSPITAL 1800 E COPLIN OKEMAH OK 74859 OKFUSKEE (918) 623-1424 Critical Access Hospitals Tribal TRUE 35.4206670 -96.3042900 0   107 40 40107         https://data.medicare.gov/resource/xubh-q36u/row-eqjs.ws8m-7374 371333 644340 2019-03-01 2018-09-30 25           25               25
3447 3447 MUSCOGEE (CREEK) NATION MEDICAL CENTER 1401 MORRIS DRIVE OKMULGEE OK 74447 OKMULGEE (918) 756-4233 Acute Care Hospitals Tribal TRUE 35.6105230 -95.9525460 0   111 40 40111 46140 Tulsa-Muskogee-Bartlesville, OK Outlying Okmulgee County https://data.medicare.gov/resource/xubh-q36u/row-72m7-vfe8_yc8a 370057 648402 2019-03-01 2018-09-30 50           50 16             66
3817 3817 CLAREMORE INDIAN HOSPITAL 101 SOUTH MOORE AVE CLAREMORE OK 74017 ROGERS (918) 341-8430 Acute Care Hospitals Tribal TRUE 36.3156550 -95.6282620 0   131 40 40131 46140 Tulsa-Muskogee-Bartlesville, OK Outlying Rogers County https://data.medicare.gov/resource/xubh-q36u/row-id3u~kfpp-zah3 370173 647088 2019-04-29 2018-09-30 46           46               46
4294 4294 NORTON SOUND REGIONAL HOSPITAL 1000 GREG KRUSCHEK AVENUE (P O BOX 966) NOME AK 99762 NOME (907) 443-3311 Critical Access Hospitals Tribal TRUE 64.4992304 -165.3784042 1 ROOFTOP 180 2 2180         https://data.medicare.gov/resource/xubh-q36u/row-2xs3~z9eg.fia9 21308 646669 2019-04-15 2018-09-30 18           18       18       36
4344 4344 MANIILAQ HEALTH CENTER PO BOX 43 KOTZEBUE AK 99752 NORTHWEST ARTIC BOROUGH (907) 442-3321 Critical Access Hospitals Tribal TRUE 66.8961387 -162.5868698 1 ROOFTOP 188 2 2188         https://data.medicare.gov/resource/xubh-q36u/row-5pbr_yrqg~qkzd 21310 646530 2019-03-29 2018-09-30 17           17               17

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