hospital_data
Data source: Big Local News · About: big-local-datasette
36 rows where "filed_date" is on date 2019-12-02 and hospital_ownership = "Government - Local"
This data as json, copyable, CSV (advanced)
Suggested facets: state, hospital_type, emergency_services, geocode_flag, geocode_accuracy, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17 | 17 | VAN DIEST MEDICAL CENTER | 2350 HOSPITAL DRIVE | WEBSTER CITY | IA | 50595 | HAMILTON | (515) 832-9400 | Critical Access Hospitals | Government - Local | TRUE | 42.4529630 | -93.8134850 | 0 | 79 | 19 | 19079 | https://data.medicare.gov/resource/xubh-q36u/row-89tb_yu6c_zwc4 | 161361 | 660984 | 2019-12-02 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||||||
35 | 35 | HAWARDEN REGIONAL HEALTHCARE | 1111 11TH STREET | HAWARDEN | IA | 51023 | SIOUX | (712) 551-3100 | Critical Access Hospitals | Government - Local | TRUE | 42.9980080 | -96.4794270 | 0 | 167 | 19 | 19167 | https://data.medicare.gov/resource/xubh-q36u/row-i52u~xknc.njpg | 161311 | 660957 | 2019-12-02 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||||||
69 | 69 | ADAIR COUNTY MEMORIAL HOSPITAL | 609 SE KENT | GREENFIELD | IA | 50849 | ADAIR | (641) 743-2123 | Critical Access Hospitals | Government - Local | TRUE | 41.3031030 | -94.4519270 | 0 | 1 | 19 | 19001 | https://data.medicare.gov/resource/xubh-q36u/row-3dt7_nstz~yhhy | 161310 | 660956 | 2019-12-02 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||||||
274 | 274 | VETERANS MEMORIAL HOSPITAL | 40 1ST STREET SE | WAUKON | IA | 52172 | ALLAMAKEE | (563) 568-3411 | Critical Access Hospitals | Government - Local | TRUE | 43.2680920 | -91.4744460 | 0 | 5 | 19 | 19005 | https://data.medicare.gov/resource/xubh-q36u/row-kmrq-g36y.pe5i | 161318 | 660959 | 2019-12-02 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||||||
329 | 329 | BOONE MEMORIAL HOSPITAL | 701 MADISON AVENUE | MADISON | WV | 25130 | BOONE | (304) 369-1230 | Critical Access Hospitals | Government - Local | TRUE | 38.0486360 | -81.8065320 | 0 | 5 | 54 | 54005 | 16620 | Charleston-Huntington-Ashland, WV-OH-KY | Outlying | Boone County | https://data.medicare.gov/resource/xubh-q36u/row-r4j3~ibqd.28ff | 511313 | 661267 | 2019-12-02 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||
469 | 469 | WEIRTON MEDICAL CENTER | 601 COLLIERS WAY | WEIRTON | WV | 26062 | HANCOCK | (304) 797-6000 | Acute Care Hospitals | Government - Local | TRUE | 40.3937260 | -80.5297390 | 0 | 9 | 54 | 54009 | 48260 | Pittsburgh-New Castle-Weirton, PA-OH-WV | Central | Brooke County | https://data.medicare.gov/resource/xubh-q36u/row-kane-jbhj.6jim | 510023 | 661436 | 2019-12-02 | 2019-06-30 | 117 | 10 | 127 | 7 | 33 | 167 | ||||||||||
587 | 587 | CONTRA COSTA REGIONAL MEDICAL CENTER | 2500 ALHAMBRA AVENUE | MARTINEZ | CA | 94553 | CONTRA COSTA | (925) 370-5000 | Acute Care Hospitals | Government - Local | TRUE | 38.0064670 | -122.1308910 | 0 | 13 | 6 | 6013 | 41860 | San Jose-San Francisco-Oakland, CA | Outlying | Contra Costa County | https://data.medicare.gov/resource/xubh-q36u/row-iuri_7t24.rw23 | 50276 | 660491 | 2019-12-02 | 2019-06-30 | 110 | 8 | 6 | 124 | 23 | 147 | ||||||||||
622 | 622 | BOX BUTTE GENERAL HOSPITAL | P O BOX 810, 2101 BOX BUTTE AVE | ALLIANCE | NE | 69301 | BOX BUTTE | (308) 762-6660 | Critical Access Hospitals | Government - Local | TRUE | 42.0984344 | -102.8703880 | 1 | ROOFTOP | 13 | 31 | 31013 | https://data.medicare.gov/resource/xubh-q36u/row-gsu6_furw.wta3 | 281360 | 661047 | 2019-12-02 | 2019-06-30 | 25 | 25 | 25 | ||||||||||||||||
681 | 681 | BOONE COUNTY HOSPITAL | 1015 UNION STREET | BOONE | IA | 50036 | BOONE | (515) 432-3140 | Critical Access Hospitals | Government - Local | TRUE | 42.0555830 | -93.8770370 | 0 | 15 | 19 | 19015 | 14340 | Des Moines-Ames-West Des Moines, IA | Central | Boone County | https://data.medicare.gov/resource/xubh-q36u/row-6zpe~cgwm_xs5p | 161372 | 660987 | 2019-12-02 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||
752 | 752 | CAMBRIDGE HEALTH ALLIANCE | 1493 CAMBRIDGE STREET | CAMBRIDGE | MA | 2138 | MIDDLESEX | (617) 665-2300 | Acute Care Hospitals | Government - Local | TRUE | 42.3741860 | -71.1044550 | 0 | 17 | 25 | 25017 | 14460 | Boston-Worcester-Providence, MA-RI-NH-CT | Central | Middlesex County | https://data.medicare.gov/resource/xubh-q36u/row-gyrk~893u_u5y7 | 220011 | 662215 | 2019-12-02 | 2019-06-30 | 182 | 18 | 200 | 62 | 262 | |||||||||||
964 | 964 | BUTLER COUNTY HEALTH CARE CENTER | 372 SOUTH 9TH ST | DAVID CITY | NE | 68632 | BUTLER | (402) 367-1200 | Critical Access Hospitals | Government - Local | TRUE | 41.2464710 | -97.1230380 | 0 | 23 | 31 | 31023 | https://data.medicare.gov/resource/xubh-q36u/row-u7xr~dyr4.b4xb | 281332 | 661041 | 2019-12-02 | 2019-06-30 | 20 | 20 | 20 | |||||||||||||||||
994 | 994 | EL CENTRO REGIONAL MEDICAL CENTER | 1415 ROSS AVENUE | EL CENTRO | CA | 92243 | IMPERIAL | (760) 339-7100 | Acute Care Hospitals | Government - Local | TRUE | 32.7814980 | -115.5686200 | 0 | 25 | 6 | 6025 | 20940 | Central | Imperial County | https://data.medicare.gov/resource/xubh-q36u/row-35st~i7ay-x3eh | 50045 | 660164 | 2019-12-02 | 2019-06-30 | 141 | 20 | 161 | 161 | |||||||||||||
1376 | 1376 | SHERIDAN MEMORIAL HOSPITAL | 1401 W 5TH ST | SHERIDAN | WY | 82801 | SHERIDAN | (307) 672-1044 | Acute Care Hospitals | Government - Local | TRUE | 44.8074250 | -106.9755700 | 0 | 33 | 56 | 56033 | 43260 | Central | Sheridan County | https://data.medicare.gov/resource/xubh-q36u/row-kh7n.rjz9.bakb | 530006 | 661690 | 2019-12-02 | 2019-06-30 | 60 | 11 | 71 | 71 | |||||||||||||
1577 | 1577 | MEMORIAL HOSPITAL SWEETWATER COUNTY | 1200 COLLEGE DRIVE | ROCK SPRINGS | WY | 82901 | SWEETWATER | (307) 362-3711 | Acute Care Hospitals | Government - Local | TRUE | 41.5840600 | -109.2335780 | 0 | 37 | 56 | 56037 | 40540 | Central | Sweetwater County | https://data.medicare.gov/resource/xubh-q36u/row-x7m7_kvh5~qmi2 | 530011 | 661448 | 2019-12-02 | 2019-06-30 | 48 | 10 | 58 | 58 | |||||||||||||
1693 | 1693 | GUTTENBERG MUNICIPAL HOSPITAL | 200 MAIN STREET | GUTTENBERG | IA | 52052 | CLAYTON | (563) 252-1121 | Critical Access Hospitals | Government - Local | TRUE | 42.7855480 | -91.0999540 | 0 | 43 | 19 | 19043 | https://data.medicare.gov/resource/xubh-q36u/row-9vtm.kuer.r3a9 | 161312 | 660958 | 2019-12-02 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||||||
1791 | 1791 | NORTH KANSAS CITY HOSPITAL | 2800 CLAY EDWARDS DRIVE | NORTH KANSAS CITY | MO | 64116 | CLAY | (816) 691-2000 | Acute Care Hospitals | Government - Local | TRUE | 39.1508100 | -94.5518520 | 0 | 47 | 29 | 29047 | 28140 | Kansas City-Overland Park-Kansas City, MO-KS | Central | Clay County | https://data.medicare.gov/resource/xubh-q36u/row-jpk9.5ekq~fxuy | 260096 | 661210 | 2019-12-02 | 2019-06-30 | 211 | 14 | 138 | 363 | 48 | 411 | ||||||||||
1950 | 1950 | DECATUR COUNTY HOSPITAL | 1405 NW CHURCH STREET | LEON | IA | 50144 | DECATUR | (641) 446-4871 | Critical Access Hospitals | Government - Local | TRUE | 40.7503080 | -93.7477890 | 0 | 53 | 19 | 19053 | https://data.medicare.gov/resource/xubh-q36u/row-z8pk.dm9q_4faw | 161340 | 660972 | 2019-12-02 | 2019-06-30 | 11 | 11 | 11 | |||||||||||||||||
2069 | 2069 | CUMBERLAND COUNTY HOSPITAL | 299 GLASGOW ROAD | BURKESVILLE | KY | 42717 | CUMBERLAND | (270) 864-2511 | Critical Access Hospitals | Government - Local | TRUE | 36.7968680 | -85.3724400 | 0 | 57 | 21 | 21057 | https://data.medicare.gov/resource/xubh-q36u/row-ptk2_m6d2-xzym | 181317 | 661512 | 2019-12-02 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||||||
2489 | 2489 | HARDIN MEDICAL CENTER | 935 WAYNE ROAD | SAVANNAH | TN | 38372 | HARDIN | (731) 926-8121 | Acute Care Hospitals | Government - Local | TRUE | 35.2271300 | -88.2303620 | 0 | 71 | 47 | 47071 | https://data.medicare.gov/resource/xubh-q36u/row-2dfc~89p6~kqtc | 440109 | 660709 | 2019-12-02 | 2019-06-30 | 49 | 49 | 73 | 122 | ||||||||||||||||
2528 | 2528 | GREENE COUNTY MEDICAL CENTER | 1000 WEST LINCOLNWAY | JEFFERSON | IA | 50129 | GREENE | (515) 386-2114 | Critical Access Hospitals | Government - Local | TRUE | 42.0152170 | -94.3890600 | 0 | 73 | 19 | 19073 | https://data.medicare.gov/resource/xubh-q36u/row-ekvn-6v3z_68bn | 161325 | 660962 | 2019-12-02 | 2019-06-30 | 21 | 4 | 25 | 25 | ||||||||||||||||
2557 | 2557 | LAGUNA HONDA HOSPITAL & REHABILITATION CENTER | 375 LAGUNA HONDA BLVD | SAN FRANCISCO | CA | 94116 | SAN FRANCISCO | (415) 759-2300 | Acute Care Hospitals | Government - Local | FALSE | 37.7478240 | -122.4586360 | 0 | 75 | 6 | 6075 | 41860 | San Jose-San Francisco-Oakland, CA | Central | San Francisco County | https://data.medicare.gov/resource/xubh-q36u/row-tz44~vi64-ys8h | 50668 | 662169 | 2019-12-02 | 2019-06-30 | 6 | 6 | 5 | 769 | 780 | |||||||||||
2594 | 2594 | SAN JOAQUIN GENERAL HOSPITAL | 500 W HOSPITAL ROAD | FRENCH CAMP | CA | 95231 | SAN JOAQUIN | (209) 468-6000 | Acute Care Hospitals | Government - Local | TRUE | 37.8864920 | -121.2820610 | 0 | 77 | 6 | 6077 | 44700 | San Jose-San Francisco-Oakland, CA | Central | San Joaquin County | https://data.medicare.gov/resource/xubh-q36u/row-imza-7dfi-q9b9 | 50167 | 661140 | 2019-12-02 | 2019-06-30 | 155 | 16 | 25 | 196 | 196 | |||||||||||
2904 | 2904 | REGIONAL HEALTH SERVICES OF HOWARD COUNTY | 235 8TH AVENUE WEST | CRESCO | IA | 52136 | HOWARD | (563) 547-2101 | Critical Access Hospitals | Government - Local | TRUE | 43.3818910 | -92.1177640 | 0 | 89 | 19 | 19089 | https://data.medicare.gov/resource/xubh-q36u/row-cg3w~i3hb_y7gu | 161328 | 660965 | 2019-12-02 | 2019-06-30 | 18 | 18 | 1 | 19 | ||||||||||||||||
3106 | 3106 | JACKSON COUNTY REGIONAL HEALTH CENTER | 700 W GROVE ST | MAQUOKETA | IA | 52060 | JACKSON | (563) 652-2474 | Critical Access Hospitals | Government - Local | TRUE | 42.0737150 | -90.6731320 | 0 | 97 | 19 | 19097 | https://data.medicare.gov/resource/xubh-q36u/row-cqwp_hqw2.ikei | 161329 | 660966 | 2019-12-02 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||||||
3201 | 3201 | JEFFERSON COUNTY HEALTH CENTER | 2000 S MAIN | FAIRFIELD | IA | 52556 | JEFFERSON | (641) 472-4111 | Critical Access Hospitals | Government - Local | TRUE | 40.9856350 | -91.9631180 | 0 | 101 | 19 | 19101 | 21840 | Central | Jefferson County | https://data.medicare.gov/resource/xubh-q36u/row-cksn~64fu_7y3h | 161364 | 660985 | 2019-12-02 | 2019-06-30 | 25 | 25 | 25 | ||||||||||||||
3240 | 3240 | WEBSTER COUNTY MEMORIAL HOSPITAL | 324 MILLER MOUNTAIN DRIVE | WEBSTER SPRINGS | WV | 26288 | WEBSTER | (304) 847-5682 | Critical Access Hospitals | Government - Local | TRUE | 38.4818680 | -80.4098110 | 0 | 101 | 54 | 54101 | https://data.medicare.gov/resource/xubh-q36u/row-stvk~jdqs~5m5u | 511301 | 661266 | 2019-12-02 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||||||
3295 | 3295 | WETZEL COUNTY HOSPITAL | #3 EAST BENJAMIN DRIVE | NEW MARTINSVILLE | WV | 26155 | WETZEL | (304) 455-8000 | Acute Care Hospitals | Government - Local | TRUE | 39.6810712 | -80.8501977 | 1 | ROOFTOP | 103 | 54 | 54103 | https://data.medicare.gov/resource/xubh-q36u/row-v7h8~v92p-92tq | 510072 | 661438 | 2019-12-02 | 2019-06-30 | 43 | 5 | 48 | 48 | |||||||||||||||
3676 | 3676 | MAHASKA HEALTH PARTNERSHIP | 1229 C AVENUE EAST | OSKALOOSA | IA | 52577 | MAHASKA | (641) 672-3100 | Critical Access Hospitals | Government - Local | TRUE | 41.2985620 | -92.6301310 | 0 | 123 | 19 | 19123 | 36820 | Central | Mahaska County | https://data.medicare.gov/resource/xubh-q36u/row-r6q8.mtiy.cvna | 161379 | 660990 | 2019-12-02 | 2019-06-30 | 25 | 25 | 1 | 26 | |||||||||||||
3688 | 3688 | MORRILL COUNTY COMMUNITY HOSPITAL | 1313 S STREET | BRIDGEPORT | NE | 69336 | MORRILL | (308) 262-1616 | Critical Access Hospitals | Government - Local | TRUE | 41.6618900 | -103.0913740 | 0 | 123 | 31 | 31123 | https://data.medicare.gov/resource/xubh-q36u/row-zd5w.8rx8_6yzu | 281318 | 661038 | 2019-12-02 | 2019-06-30 | 20 | 20 | 20 | |||||||||||||||||
3784 | 3784 | MIDMICHIGAN MEDICAL CENTER - WEST BRANCH | 2463 SOUTH M-30 | WEST BRANCH | MI | 48661 | OGEMAW | (989) 345-6366 | Acute Care Hospitals | Government - Local | TRUE | 44.2628300 | -84.2462300 | 0 | 129 | 26 | 26129 | https://data.medicare.gov/resource/xubh-q36u/row-fszi_3g9m-qsjn | 230095 | 661008 | 2019-12-02 | 2019-06-30 | 78 | 10 | 88 | 88 | ||||||||||||||||
3878 | 3878 | ESSENTIA HEALTH VIRGINIA | 901 9TH STREET NORTH | VIRGINIA | MN | 55792 | ST. LOUIS | (218) 741-3340 | Acute Care Hospitals | Government - Local | FALSE | 47.5307110 | -92.5487970 | 0 | 137 | 27 | 27137 | 20260 | Central | St. Louis County | https://data.medicare.gov/resource/xubh-q36u/row-39c9_62zv_e3w4 | 240084 | 662217 | 2019-12-02 | 2019-06-30 | 40 | 8 | 48 | 16 | 77 | 141 | |||||||||||
4235 | 4235 | PUTNAM COUNTY MEMORIAL HOSPITAL | 1926 OAK STREET, PO BOX 389 | UNIONVILLE | MO | 63565 | PUTNAM | (660) 947-2411 | Critical Access Hospitals | Government - Local | TRUE | 40.4820250 | -93.0059870 | 0 | 171 | 29 | 29171 | https://data.medicare.gov/resource/xubh-q36u/row-ygkd_dijw_ng7v | 261305 | 661212 | 2019-12-02 | 2019-06-30 | 15 | 15 | 15 | |||||||||||||||||
4268 | 4268 | VALLEY COUNTY HEALTH SYSTEM | 2707 L STREET | ORD | NE | 68862 | VALLEY | (308) 728-4200 | Critical Access Hospitals | Government - Local | TRUE | 41.6032130 | -98.9426760 | 0 | 175 | 31 | 31175 | https://data.medicare.gov/resource/xubh-q36u/row-y2qv_7x4q_v7xu | 281353 | 661044 | 2019-12-02 | 2019-06-30 | 16 | 16 | 16 | |||||||||||||||||
4373 | 4373 | WILKES REGIONAL MEDICAL CENTER | 1370 WEST D ST | NORTH WILKESBORO | NC | 28659 | WILKES | (336) 651-8100 | Acute Care Hospitals | Government - Local | TRUE | 36.1584650 | -81.1570130 | 0 | 193 | 37 | 37193 | 35900 | Central | Wilkes County | https://data.medicare.gov/resource/xubh-q36u/row-mugx~rcjs~9jqq | 340064 | 661369 | 2019-12-02 | 2019-06-30 | 85 | 8 | 93 | 10 | 103 | ||||||||||||
4375 | 4375 | PETERSBURG MEDICAL CENTER | PO BOX 589 | PETERSBURG | AK | 99833 | PETERSBURG BOROUGH | (907) 772-4291 | Critical Access Hospitals | Government - Local | TRUE | 56.8128691 | -132.9554619 | 1 | ROOFTOP | 195 | 2 | 2195 | https://data.medicare.gov/resource/xubh-q36u/row-ky7y_b72j_698p | 21304 | 660160 | 2019-12-02 | 2019-06-30 | 12 | 12 | 15 | 27 | |||||||||||||||
4390 | 4390 | IOWA SPECIALTY HOSPITAL-CLARION | 1316 SOUTH MAIN STREET | CLARION | IA | 50525 | WRIGHT | (515) 532-2811 | Critical Access Hospitals | Government - Local | TRUE | 42.7216250 | -93.7326280 | 0 | 197 | 19 | 19197 | https://data.medicare.gov/resource/xubh-q36u/row-qm5h-kjf7~8unb | 161302 | 661176 | 2019-12-02 | 2019-06-30 | 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 );