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

40 rows where hospital_ownership = "Government - Federal"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, filed_date, fy_end_date, acute_beds, icu_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)

hospital_ownership ✖

  • Government - Federal · 40 ✖
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
38 38 FORT DEFIANCE INDIAN HOSPITAL PO BOX 649 FORT DEFIANCE AZ 86504 APACHE (928) 729-8000 Acute Care Hospitals Government - Federal TRUE 35.7593170 -109.0483992 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-ss8d_atq6.7xb3 30071 651311 2019-07-02 2018-09-30 56           56               56
40 40 CHINLE COMPREHENSIVE HEALTH CARE FACILITY US HWY 191, HOSPITAL ROAD CHINLE AZ 86503 APACHE (928) 674-7001 Acute Care Hospitals Government - Federal TRUE 36.1575812 -109.6076963 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-u7kj_iqgg.38d9 30084 649393 2019-06-12 2018-09-30 60           60               60
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
349 349 WILCOX MEMORIAL HOSPITAL 3-3420 KUHIO HIGHWAY LIHUE HI 96766 KAUAI (808) 245-1103 Acute Care Hospitals Government - Federal TRUE 21.9870430 -159.3661980 0   7 15 15007 28180   Central Kauai County https://data.medicare.gov/resource/xubh-q36u/row-9k2j.d4pk.dvnd 120014 662037 2019-11-26 2019-06-30 65 7         72               72
362 362 RED LAKE HOSPITAL A PO BOX 497 REDLAKE MN 56671 BELTRAMI (218) 679-3912 Acute Care Hospitals Government - Federal FALSE 47.8763460 -95.0169401 1 GEOMETRIC_CENTER 7 27 27007 13420   Central Beltrami County https://data.medicare.gov/resource/xubh-q36u/row-jefe.tmy8.7dit 240206 649909 2019-06-18 2018-09-30 23           23               23
404 404 SAN CARLOS APACHE HEALTHCARE 103 MEDICINE WAY ROAD PERIDOT AZ 85542 GILA (928) 475-1200 Acute Care Hospitals Government - Federal FALSE 33.2956419 -110.4178011 1 ROOFTOP 9 4 4009 40940   Central Graham County https://data.medicare.gov/resource/xubh-q36u/row-9543-jpqy.dn76 30077 651688 2019-07-01 2018-09-30 8           8               8
455 455 PLAINS REGIONAL MEDICAL CENTER 2100 N MARTIN LUTHER KING, JR, BLVD CLOVIS NM 88101 CURRY (575) 769-7155 Acute Care Hospitals Government - Federal TRUE 34.4204900 -103.2317630 0   9 35 35009 17580 Clovis-Portales, NM Central Curry County https://data.medicare.gov/resource/xubh-q36u/row-dvw2.36gg-bpn9 320022 650185 2019-05-30 2018-12-31 98 8         106               106
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
554 554 PHOENIX INDIAN MEDICAL CENTER 4212 NORTH 16TH STREET PHOENIX AZ 85016 MARICOPA (602) 263-1200 Acute Care Hospitals Government - Federal FALSE 33.4970100 -112.0476130 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-gzm7-4h6v-chi5 30078 651313 2019-07-02 2018-09-30 133           133               133
723 723 WHITERIVER PHS INDIAN HOSPITAL 200 WEST HOSPITAL DRIVE (PO BOX 860) WHITERIVER AZ 85941 NAVAJO (928) 338-4911 Acute Care Hospitals Government - Federal FALSE 33.8759760 -109.9595280 0   17 4 4017 43320   Central Navajo County https://data.medicare.gov/resource/xubh-q36u/row-v5m3-a25g-4tei 30113 650108 2019-06-15 2018-09-30 40           40               40
873 873 ALASKA NATIVE MEDICAL CENTER 4315 DIPLOMACY DR ANCHORAGE AK 99508 ANCHORAGE (907) 729-3971 Acute Care Hospitals Government - Federal TRUE 61.1818900 -149.8005780 0   20 2 2020 11260   Central Anchorage Municipality https://data.medicare.gov/resource/xubh-q36u/row-5h7d.5evj.yxgq 20026 651310 2019-07-01 2018-09-30 173         1 174               174
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
903 903 BETH ISRAEL DEACONESS HOSPITAL-MILTON INC 199 REEDSDALE ROAD MILTON MA 2186 NORFOLK (617) 696-4600 Acute Care Hospitals Government - Federal TRUE 42.2523520 -71.0752130 0   21 25 25021 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Norfolk County https://data.medicare.gov/resource/xubh-q36u/row-igb2.542k_rxpc 220108 644741 2019-03-13 2018-09-30 94 8         102               102
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
1290 1290 GALLUP INDIAN MEDICAL CENTER 516 E NIZHONI BLVD GALLUP NM 87301 MCKINLEY (505) 722-1000 Acute Care Hospitals Government - Federal TRUE 35.5084440 -108.7302260 0   31 35 35031 23700   Central McKinley County https://data.medicare.gov/resource/xubh-q36u/row-6j78~q67u-hap6 320061 650186 2019-06-06 2018-09-30 74           74               74
1291 1291 CROWNPOINT HEALTHCARE FACILITY JUNCTION OF HWY 371 CROWNPOINT NM 87313 MCKINLEY (505) 786-5291 Acute Care Hospitals Government - Federal TRUE 35.6987639 -108.1396562 1 GEOMETRIC_CENTER 31 35 35031 23700   Central McKinley County https://data.medicare.gov/resource/xubh-q36u/row-fk7d.f3eh~sfri 320062 647264 2019-05-08 2018-09-30 19           19               19
1292 1292 ZUNI COMPREHENSIVE COMMUNITY HEALTH CENTER ROUTE 301 NORTH B STREET ZUNI NM 87327 MCKINLEY (505) 782-4431 Acute Care Hospitals Government - Federal TRUE 35.0785445 -108.8119284 1 GEOMETRIC_CENTER 31 35 35031 23700   Central McKinley County https://data.medicare.gov/resource/xubh-q36u/row-bm92~a2re_rnct 320060 647300 2019-05-08 2018-09-30 27           27               27
1298 1298 LAWTON INDIAN HOSPITAL 1515 LAWRIE TATUM ROAD LAWTON OK 73507 COMANCHE (580) 354-5000 Acute Care Hospitals Government - Federal TRUE 34.6274940 -98.3857180 0   31 40 40031 30020   Central Comanche County https://data.medicare.gov/resource/xubh-q36u/row-wxwg-zekm.zah6 370170 648308 2019-05-08 2018-09-30 38           38               38
1398 1398 P H S INDIAN HOSPITAL AT BROWNING - BLACKFEET 760 HOSPITAL CIRCLE, POST OFFICE BOX 760 BROWNING MT 59417 GLACIER (406) 338-6157 Acute Care Hospitals Government - Federal TRUE 48.5657292 -113.0197530 1 ROOFTOP 35 30 30035         https://data.medicare.gov/resource/xubh-q36u/row-6bdm_qidd_w2p9 270074 651216 2019-06-24 2018-09-30 26           26               26
1401 1401 MESCALERO PHS INDIAN HOSPITAL P O BOX 210 MESCALERO NM 88340 OTERO (505) 464-4441 Acute Care Hospitals Government - Federal FALSE 33.1587939 -105.7723979 1 ROOFTOP 35 35 35035 10460   Central Otero County https://data.medicare.gov/resource/xubh-q36u/row-vqii_apfk.3xws 320058 650730 2019-06-22 2018-09-30 6           6               6
1669 1669 PHS INDIAN HOSPITAL AT EAGLE BUTTE 24276 166TH AIRPORT ROAD EAGLE BUTTE SD 57625 DEWEY (605) 964-3005 Acute Care Hospitals Government - Federal TRUE 44.9935681 -101.2421234 1 GEOMETRIC_CENTER 41 46 46041         https://data.medicare.gov/resource/xubh-q36u/row-5fj3.qevg-rb9t 430083 650906 2019-06-24 2018-09-30 8           8               8
1745 1745 NORTHERN NAVAJO MEDICAL CENTER US HWY 491 NORTH SHIPROCK NM 87420 SAN JUAN (505) 368-6001 Acute Care Hospitals Government - Federal TRUE 36.8052353 -108.6914076 1 GEOMETRIC_CENTER 45 35 35045 22140   Central San Juan County https://data.medicare.gov/resource/xubh-q36u/row-92dv_6fd6_m5cs 320059 651387 2019-06-18 2018-09-30 60           60               60
1852 1852 SANTA FE PHS INDIAN HOSPITAL 1700 CERRILLOS ROAD SANTA FE NM 87501 SANTA FE (505) 988-9821 Acute Care Hospitals Government - Federal FALSE 35.6669500 -105.9696650 0   49 35 35049 42140 Albuquerque-Santa Fe-Las Vegas, NM Central Santa Fe County https://data.medicare.gov/resource/xubh-q36u/row-9cut.x6uq_hkie 320057 647086 2019-04-27 2018-09-30 4           4               4
1962 1962 PHILLIPS EYE INSTITUTE 2215 PARK AVENUE SOUTH MINNEAPOLIS MN 55404 HENNEPIN (612) 775-8751 Acute Care Hospitals Government - Federal FALSE 44.9604780 -93.2651060 0   53 27 27053 33460 Minneapolis-St. Paul, MN-WI Central Hennepin County https://data.medicare.gov/resource/xubh-q36u/row-6egw_a4dk~jkf6 240196 662388 2019-12-11 2019-07-31 8           8               8
2655 2655 P H S INDIAN HOSP AT BELCOURT-QUENTIN N BURDICK PO BOX 160 BELCOURT ND 58316 ROLETTE (701) 477-6111 Acute Care Hospitals Government - Federal TRUE 48.8434415 -99.7483567 1 ROOFTOP 79 38 38079         https://data.medicare.gov/resource/xubh-q36u/row-tdmb_245b_qx4d 350063 650356 2019-06-18 2018-09-30 27           27               27
2775 2775 REGIONAL MEDICAL CENTER OF SAN JOSE 225 N JACKSON AVENUE SAN JOSE CA 95116 SANTA CLARA (408) 259-5000 Acute Care Hospitals Government - Federal TRUE 37.3637870 -121.8488230 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-qe98-xids.qirm 50125 648592 2019-05-24 2018-12-31 218 34         258               258
2802 2802 STANDING ROCK INDIAN HEALTH SERVICE HOSPITAL 10 NORTH RIVER ROAD FORT YATES ND 58538 SIOUX (701) 854-3831 Acute Care Hospitals Government - Federal TRUE 46.0952325 -100.6281136 1 ROOFTOP 85 38 38085 13900   Outlying Sioux County https://data.medicare.gov/resource/xubh-q36u/row-a84q-rj3h~6yed 350064 651228 2019-06-18 2018-09-30 12           12               12
2816 2816 TEXAS HEALTH PRESBYTERIAN HOSPITAL ALLEN 1105 CENTRAL EXPRESSWAY NORTH ALLEN TX 75013 COLLIN (972) 747-6197 Acute Care Hospitals Government - Federal TRUE 33.1154330 -96.6715040 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-v7tw~68xq-fbxm 450840 648765 2019-05-31 2018-12-31 30 8         44               44
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
3167 3167 CHOCTAW HEALTH CENTER ROUTE 7 BOX R50 PHILADELPHIA MS 39350 NESHOBA (601) 656-2211 Acute Care Hospitals Government - Federal TRUE 32.7809947 -89.1834058 1 ROOFTOP 99 28 28099         https://data.medicare.gov/resource/xubh-q36u/row-5rfv.qyga.n666 250127 652147 2019-07-02 2018-09-30 20           20               20
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
3363 3363 TROY REGIONAL MEDICAL CENTER 1330 HIGHWAY 231 SOUTH TROY AL 36081 PIKE (334) 670-5000 Acute Care Hospitals Government - Federal TRUE 31.7803220 -85.9455290 0   109 1 1109 45980   Central Pike County https://data.medicare.gov/resource/xubh-q36u/row-5ter_pyex-x2fe 10126 654064 2019-08-30 2019-03-31 88 9         97 18             115
3519 3519 ADVENTIST HEALTH AND RIDEOUT 726 4TH ST MARYSVILLE CA 95901 YUBA (530) 749-4300 Acute Care Hospitals Government - Federal TRUE 39.1388320 -121.5936220 0   115 6 6115 49700 Sacramento-Roseville, CA Central Yuba County https://data.medicare.gov/resource/xubh-q36u/row-ena2_rmjt-rgun 50133 660916 2019-11-27 2019-06-30 179 24         209               209
3655 3655 PHS INDIAN HOSPITAL AT ROSEBUD 400 SOLDIER CREEK ROAD ROSEBUD SD 57570 TODD (605) 747-2231 Acute Care Hospitals Government - Federal TRUE 43.2553350 -100.8421210 0   121 46 46121         https://data.medicare.gov/resource/xubh-q36u/row-5qds~56wu-8q7x 430084 650907 2019-06-22 2018-09-30 35           35               35
4258 4258 CHEROKEE INDIAN HOSPITAL AUTHORITY CALLER BOX C268 CHEROKEE NC 28719 SWAIN (704) 497-9163 Acute Care Hospitals Government - Federal TRUE 35.4841903 -83.3232054 1 ROOFTOP 173 37 37173         https://data.medicare.gov/resource/xubh-q36u/row-k27i~9abs_tp2y 340156 649941 2019-06-18 2018-09-30 20           20               20
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
4450 4450 ST CLAIRE REGIONAL MEDICAL CENTER 222 MEDICAL CIRCLE MOREHEAD KY 40351 ROWAN (606) 783-6502 Acute Care Hospitals Government - Federal TRUE 38.1800160 -83.4424540 0   205 21 21205         https://data.medicare.gov/resource/xubh-q36u/row-epvn~wthp~wxsz 180018 660556 2019-11-26 2019-06-30 76 14         90 20 10   7   3   130
4606 4606 DHHS USPHS INDIAN HEALTH SERVICES EXIT #102 OFF I-40 1/2 MILE SOUTH SAN FIDEL NM 87049 CIBOLA (505) 552-5300 Acute Care Hospitals Government - Federal TRUE 35.1838274 -101.9279458 1 ROOFTOP 375 48 48375 11100 Amarillo-Borger, TX Central Potter County https://data.medicare.gov/resource/xubh-q36u/row-j82y-frp9~f9kp 320070 647921 2019-05-08 2018-09-30 6           6               6

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