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 = "Government - Federal" and hospital_type = "Critical Access Hospitals"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, filed_date, fy_end_date, acute_beds, subtotal_acute_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
187 187 P H S INDIAN HOSPITAL CROW / NORTHERN CHEYENNE 1010 SOUTH 7650 EAST, POST OFFICE BOX 9 CROW AGENCY MT 59022 BIG HORN (406) 638-2626 Critical Access Hospitals Government - Federal TRUE 45.5821958 -107.4488586 1 ROOFTOP 3 30 30003         https://data.medicare.gov/resource/xubh-q36u/row-pgmt~4b42~eq7a 271339 646565 2019-03-26 2018-09-30 24           24               24
294 294 P H S INDIAN HOSPITAL-FT BELKNAP AT HARLEM - CAH 456 GROS VENTRE AVE, RR 1 HARLEM MT 59526 BLAINE (406) 353-3100 Critical Access Hospitals Government - Federal TRUE 48.4851890 -108.7670010 0   5 30 30005         https://data.medicare.gov/resource/xubh-q36u/row-sifm_y3g6.gq5p 271315 646038 2019-03-29 2018-09-30 6           6               6
546 546 PARKER INDIAN HEALTH CENTER 12033 AGENCY ROAD PARKER AZ 85344 LAPAZ (928) 669-2137 Critical Access Hospitals Government - Federal TRUE 34.1464940 -114.3013140 0   12 4 4012         https://data.medicare.gov/resource/xubh-q36u/row-942m-hgdi~yjfy 31307 645964 2019-04-01 2018-09-30 20           20               20
878 878 HUHU KAM MEMORIAL HOSPITAL 483 WEST SEED FARM ROAD SACATON AZ 85147 PINAL (520) 562-3321 Critical Access Hospitals Government - Federal TRUE 33.0741220 -111.7590800 0   21 4 4021 38060   Central Pinal County https://data.medicare.gov/resource/xubh-q36u/row-fpem.7xy6-nzbf 31308 645965 2019-03-28 2018-09-30 12           12               12
883 883 GLENN MEDICAL CENTER 1133 W SYCAMORE ST WILLOWS CA 95988 GLENN (530) 934-1818 Critical Access Hospitals Government - Federal TRUE 39.5204670 -122.2081200 0   21 6 6021         https://data.medicare.gov/resource/xubh-q36u/row-7nst_26uq.zcvx 51306 662484 2019-12-03 2019-06-30 15           15               15
909 909 CASS LAKE INDIAN HEALTH SERVICES HOSPITAL 425 7TH STREET NW CASS LAKE MN 56633 CASS (218) 335-3200 Critical Access Hospitals Government - Federal TRUE 47.3840940 -94.6095150 0   21 27 27021 14660   Outlying Cass County https://data.medicare.gov/resource/xubh-q36u/row-4suk.s9dt-ycv4 241358 646101 2019-03-29 2018-09-30 5           5               5
2957 2957 PROMEDICA HERRICK HOSPITAL 500 E POTTAWATAMIE STREET TECUMSEH MI 49286 LENAWEE (517) 424-3000 Critical Access Hospitals Government - Federal TRUE 42.0029090 -83.9375500 0   91 26 26091 10300 Detroit-Warren-Ann Arbor, MI Central Lenawee County https://data.medicare.gov/resource/xubh-q36u/row-qhbx.76b3_qikh 231334 648847 2019-05-29 2018-12-31 25           25               25
3321 3321 CATSKILL REGIONAL MEDICAL CENTER - G HERMANN SITE 8081 ROUTE 97 CALLICOON NY 12723 SULLIVAN (845) 887-5530 Critical Access Hospitals Government - Federal FALSE 41.7354523 -75.0429660 1 RANGE_INTERPOLATED 105 36 36105         https://data.medicare.gov/resource/xubh-q36u/row-exhc-5fn7-r9xs 331303 649479 2019-05-28 2018-12-31 15           15               15
4321 4321 SAMUEL SIMMONDS MEMORIAL HOSPITAL 7000 UULA ST BARROW AK 99723 NORTH SLOPE BOROUH (907) 852-4611 Critical Access Hospitals Government - Federal TRUE 71.2981350 -156.7273200 0   185 2 2185         https://data.medicare.gov/resource/xubh-q36u/row-5czr-fghi_bwfa 21312 646058 2019-03-29 2018-09-30 20           20               20

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