hospital_data
Data source: Big Local News · About: big-local-datasette
40 rows where hospital_ownership = "Government - Federal" sorted by county_name
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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | ||||||||||||||||
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 | |||||||||||||
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 | |||||||||||||||||
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 | ||||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||||
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 | ||||||||||||
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 | ||||||||||||||||
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 | |||||||||||||
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 | ||||||||||||||||
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 | |||||||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||||||
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 | |||||||||||||
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 | ||||||||||||||
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 | |||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||||
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 | ||||||||||||
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 | |||||||||||||||||
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 | |||||||||||||
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 | ||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||||
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 | ||||||||||||
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 | |||||||||||||
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 | ||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | ||||||||||||||||
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 | ||||||||||||||||
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 | |||||||||||||||||
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 |
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 );