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

50 rows where "filed_date" is on date 2019-06-04

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, statefips, csatitle, centraloutlyingcounty, fy_end_date, icu_beds, coronary_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-06-04 · 50 ✖
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
123 123 PALESTINE REGIONAL MEDICAL CENTER 2900 S LOOP 256 PALESTINE TX 75801 ANDERSON (903) 731-1000 Acute Care Hospitals Proprietary TRUE 31.7333740 -95.6253070 0   1 48 48001 37300   Central Anderson County https://data.medicare.gov/resource/xubh-q36u/row-ymbb~yh2p_i5c8 450747 649500 2019-06-04 2018-12-31 106 10         116 19 17           152
222 222 BLUFFTON HOSPITAL 139 GARAU STREET BLUFFTON OH 45817 ALLEN (419) 358-9010 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.8875780 -83.8981490 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-manx~srzz-7qqn 361322 650898 2019-06-04 2018-12-31 25           25               25
473 473 AURORA BAYCARE MEDICAL CTR 2845 GREENBRIER RD GREEN BAY WI 54311 BROWN (920) 288-8000 Acute Care Hospitals Proprietary TRUE 44.4733500 -87.9410910 0   9 55 55009 24580 Green Bay-Shawano, WI Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-ue2y_pbya.a2y6 520193 651107 2019-06-04 2018-12-31 119 24       18 161   6           167
478 478 GUAM REGIONAL MEDICAL CITY 133 ROUTE 3 DEDEDO GU 96929 GUAM (671) 645-5500 Acute Care Hospitals Voluntary non-profit - Private TRUE 13.5248362 144.8232653 1 ROOFTOP 10 66 66010         https://data.medicare.gov/resource/xubh-q36u/row-ikxi.yahy_8xvd 650003 651493 2019-06-04 2018-12-31 88 17         105               105
601 601 ALLEN HOSPITAL 1825 LOGAN AVENUE WATERLOO IA 50703 BLACK HAWK (319) 235-3941 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.5257530 -92.3377580 0   13 19 19013 47940   Central Black Hawk County https://data.medicare.gov/resource/xubh-q36u/row-ffm4.rxar_ycnb 160110 650262 2019-06-04 2018-12-31 168 12         187   12           199
683 683 SUSAN B ALLEN MEMORIAL HOSPITAL 720 W CENTRAL ST EL DORADO KS 67042 BUTLER (316) 321-3300 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.8174380 -96.8587950 0   15 20 20015 48620 Wichita-Arkansas City-Winfield, KS Outlying Butler County https://data.medicare.gov/resource/xubh-q36u/row-iaia-mbn5.zh8u 170017 650573 2019-06-04 2018-12-31 47 6         53               53
842 842 KEARNEY REGIONAL MEDICAL CENTER 804 22ND AVENUE KEARNEY NE 68845 BUFFALO (308) 455-3600 Acute Care Hospitals Proprietary TRUE 40.6975000 -99.0931000 0   19 31 31019 28260   Central Buffalo County https://data.medicare.gov/resource/xubh-q36u/row-3996-74wm-rsdj 280134 650297 2019-06-04 2018-12-31 68 18         94               94
1389 1389 WILLIAM NEWTON HOSPITAL 1300 EAST FIFTH AVENUE WINFIELD KS 67156 COWLEY (620) 221-2300 Critical Access Hospitals Government - Local TRUE 37.2446490 -96.9824700 0   35 20 20035 11680 Wichita-Arkansas City-Winfield, KS Central Cowley County https://data.medicare.gov/resource/xubh-q36u/row-m266-eq4z.krik 171383 650583 2019-06-04 2018-12-31 19 2         21               21
1413 1413 SOUTH POINTE HOSPITAL 20000 HARVARD ROAD WARRENSVILLE HEIGHTS OH 44122 CUYAHOGA (216) 491-6000 Acute Care Hospitals Voluntary non-profit - Other FALSE 41.4498650 -81.5378290 0   35 39 39035 17460 Cleveland-Akron-Canton, OH Central Cuyahoga County https://data.medicare.gov/resource/xubh-q36u/row-5zhv.iz5f~2jrw 360144 650892 2019-06-04 2018-12-31 106 25         131               131
1590 1590 DECATUR COUNTY HOSPITAL 810 W COLUMBIA STREET OBERLIN KS 67749 DECATUR (785) 475-2208 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.8162120 -100.5392500 0   39 20 20039         https://data.medicare.gov/resource/xubh-q36u/row-p5sz.djrg.x3gh 171352 650579 2019-06-04 2018-12-31 21           21               21
1691 1691 PHYSICIANS' MEDICAL CENTER LLC 4023 REAS LN NEW ALBANY IN 47150 FLOYD (812) 206-7660 Acute Care Hospitals Physician FALSE 38.3400320 -85.8270640 0   43 18 18043 31140 Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Central Floyd County https://data.medicare.gov/resource/xubh-q36u/row-bawj-eke8.ffq3 150172 650260 2019-06-04 2018-12-31 10           10               10
1701 1701 LITTLE FALLS HOSPITAL 140 BURWELL STREET LITTLE FALLS NY 13365 HERKIMER (315) 823-5261 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.0439460 -74.8477330 0   43 36 36043 46540   Outlying Herkimer County https://data.medicare.gov/resource/xubh-q36u/row-sshf~5es7_6ygm 331311 651039 2019-06-04 2018-12-31 25           25               25
1855 1855 LEWIS COUNTY GENERAL HOSPITAL 7785 NORTH STATE STREET LOWVILLE NY 13367 LEWIS (315) 376-5200 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.7958300 -75.4981520 0   49 36 36049         https://data.medicare.gov/resource/xubh-q36u/row-t9if.wi94~nbm4 331317 651041 2019-06-04 2018-12-31 19 6         25       160       185
1995 1995 SPANISH PEAKS REGIONAL HEALTH CENTER 23500 US HWY 160 WALSENBURG CO 81089 HUERFANO (719) 738-5100 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.6076880 -104.8197860 0   55 8 8055         https://data.medicare.gov/resource/xubh-q36u/row-d4uh.vzxr_8sf9 61316 650807 2019-06-04 2018-12-31 16           16         9 120   145
2017 2017 METHODIST HOSPITAL 8303 DODGE ST OMAHA NE 68114 DOUGLAS (402) 354-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2596820 -96.0417710 0   55 31 31055 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-bjff-fqke-u4jb 280040 650848 2019-06-04 2018-12-31 283 22         356   18           374
2174 2174 AURORA MEDICAL CTR KENOSHA 10400 75TH ST KENOSHA WI 53142 KENOSHA (262) 948-5600 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.5673550 -87.9338770 0   59 55 55059 16980 Chicago-Naperville, IL-IN-WI Outlying Kenosha County https://data.medicare.gov/resource/xubh-q36u/row-76qm-pbbm-jbbg 520189 651106 2019-06-04 2018-12-31 62 12         74               74
2185 2185 FINLEY HOSPITAL 350 NORTH GRANDVIEW AVENUE DUBUQUE IA 52001 DUBUQUE (563) 582-1881 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.4954130 -90.6875730 0   61 19 19061 20220   Central Dubuque County https://data.medicare.gov/resource/xubh-q36u/row-3qez.jxzt~cwbx 160117 650263 2019-06-04 2018-12-31 77 10         87 9 10           106
2266 2266 BLANCHARD VALLEY HOSPITAL 1900 SOUTH MAIN STREET FINDLAY OH 45840 HANCOCK (419) 423-4500 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.0172410 -83.6503390 0   63 39 39063 22300 Findlay-Tiffin, OH Central Hancock County https://data.medicare.gov/resource/xubh-q36u/row-yf9x_rfm3.dkgt 360095 650889 2019-06-04 2018-12-31 107   34       141 9             150
2494 2494 AURORA MEDICAL CTR MANITOWOC COUNTY 5000 MEMORIAL DRIVE TWO RIVERS WI 54241 MANITOWOC (920) 794-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.1258620 -87.6151370 0   71 55 55071 31820   Central Manitowoc County https://data.medicare.gov/resource/xubh-q36u/row-d4q3.v74j.a4it 520034 651098 2019-06-04 2018-12-31 63 6         69               69
2581 2581 POMERENE HOSPITAL 981 WOOSTER ROAD MILLERSBURG OH 44654 HOLMES (330) 674-1015 Acute Care Hospitals Government - Local TRUE 40.5643200 -81.9204920 0   75 39 39075         https://data.medicare.gov/resource/xubh-q36u/row-t7kd-h3yq_bv7v 360148 650893 2019-06-04 2018-12-31 37 4         41               41
2634 2634 ASTRIA TOPPENISH HOSPITAL 502 W FOURTH AVE TOPPENISH WA 98948 YAKIMA (509) 865-1520 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.3713500 -120.3166820 0   77 53 53077 49420   Central Yakima County https://data.medicare.gov/resource/xubh-q36u/row-pw49~vzsk_k73d 500037 650424 2019-06-04 2018-12-31 18 7         25               25
2669 2669 ORTHOPAEDIC HOSPITAL OF WISCONSIN 475 W RIVER WOODS PKWY GLENDALE WI 53212 MILWAUKEE (414) 961-6800 Acute Care Hospitals Voluntary non-profit - Other FALSE 43.0982700 -87.9135790 0   79 55 55079 33340 Milwaukee-Racine-Waukesha, WI Central Milwaukee County https://data.medicare.gov/resource/xubh-q36u/row-dfp2~v5qg_35t9 520194 651108 2019-06-04 2018-12-31 30           30               30
2675 2675 AURORA WEST ALLIS MEDICAL CENTER 8901 W LINCOLN AVE WEST ALLIS WI 53227 MILWAUKEE (414) 328-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.0027020 -88.0230650 0   79 55 55079 33340 Milwaukee-Racine-Waukesha, WI Central Milwaukee County https://data.medicare.gov/resource/xubh-q36u/row-ardn.kqdb-2fxn 520139 651104 2019-06-04 2018-12-31 220 16       41 277               277
2676 2676 AURORA ST LUKES MEDICAL CENTER 2900 W OKLAHOMA AVE MILWAUKEE WI 53215 MILWAUKEE (414) 649-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9886120 -87.9493460 0   79 55 55079 33340 Milwaukee-Racine-Waukesha, WI Central Milwaukee County https://data.medicare.gov/resource/xubh-q36u/row-qcnh-udu6_8sdp 520138 651103 2019-06-04 2018-12-31 675 84 66       868   65           933
2785 2785 MONTROSE MEMORIAL HOSPITAL 800 S 3RD ST MONTROSE CO 81401 MONTROSE (970) 249-2211 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.4808810 -107.8687690 0   85 8 8085 33940   Central Montrose County https://data.medicare.gov/resource/xubh-q36u/row-nuh2~q3ur~5yyi 60006 650963 2019-06-04 2018-12-31 42 8         50   10           60
2860 2860 MAHNOMEN HEALTH CENTER 414 W JEFFERSON PO BOX 396 MAHNOMEN MN 56557 MAHNOMEN (218) 935-2511 Critical Access Hospitals Government - Local TRUE 47.3117925 -95.9729278 1 ROOFTOP 87 27 27087         https://data.medicare.gov/resource/xubh-q36u/row-hmyn_2dwh_mr9t 241300 651009 2019-06-04 2018-12-31 10           10       32       42
2908 2908 NORTH VALLEY HEALTH CENTER 300 WEST GOOD SAMARITAN DRIVE WARREN MN 56762 MARSHALL (218) 745-4211 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1927360 -96.7743980 0   89 27 27089         https://data.medicare.gov/resource/xubh-q36u/row-5hr9-apeq-pgtf 241337 651012 2019-06-04 2018-12-31 12           12               12
2931 2931 AURORA MEDICAL CENTER 975 PORT WASHINGTON ROAD GRAFTON WI 53024 OZAUKEE (262) 329-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.3236103 -87.9283538 1 ROOFTOP 89 55 55089 33340 Milwaukee-Racine-Waukesha, WI Central Ozaukee County https://data.medicare.gov/resource/xubh-q36u/row-573w_skch-dcdu 520207 651111 2019-06-04 2018-12-31 102 14       10 126               126
2961 2961 OZARKS MEDICAL CENTER 1100 KENTUCKY AVE WEST PLAINS MO 65775 HOWELL (417) 256-9111 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.7379920 -91.8755520 0   91 29 29091 48460   Central Howell County https://data.medicare.gov/resource/xubh-q36u/row-55iu-4su4_aybs 260078 650595 2019-06-04 2018-12-31 91 12         103               103
3000 3000 ALLIANCE HEALTHCARE SYSTEM 1430 HIGHWAY 4 EAST / P O BOX 6000 HOLLY SPRINGS MS 38635 MARSHALL (662) 252-1212 Acute Care Hospitals Physician TRUE 34.7868350 -89.4150270 0   93 28 28093 32820 Memphis-Forrest City, TN-MS-AR Outlying Marshall County https://data.medicare.gov/resource/xubh-q36u/row-zg7w-9rxd.iyxq 250012 648706 2019-06-04 2018-12-31 27           27 13             40
3069 3069 SISTERSVILLE GENERAL HOSPITAL 314 SOUTH WELLS STREET SISTERSVILLE WV 26175 TYLER (304) 652-2611 Critical Access Hospitals Government - Local TRUE 39.5583390 -81.0040670 0   95 54 54095         https://data.medicare.gov/resource/xubh-q36u/row-2s4x~j49z-cdcm 511304 650921 2019-06-04 2018-12-31 25           25           10   35
3242 3242 AURORA MEDICAL CENTER BURLINGTON 252 MCHENRY ST BURLINGTON WI 53105 RACINE (262) 767-6545 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6735150 -88.2826480 0   101 55 55101 39540 Milwaukee-Racine-Waukesha, WI Central Racine County https://data.medicare.gov/resource/xubh-q36u/row-yeru_grmw.7t5q 520059 651101 2019-06-04 2018-12-31 45 10         55               55
3323 3323 CENTRAL CAROLINA HOSPITAL 1135 CARTHAGE ST SANFORD NC 27330 LEE (919) 774-2100 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.4690930 -79.1888000 0   105 37 37105 41820 Raleigh-Durham-Chapel Hill, NC Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-4ux9-ub5p.k2rs 340020 650334 2019-06-04 2018-12-31 118 8       1 127               127
3505 3505 CRESCENT MEDICAL CENTER LANCASTER 2600 WEST PLEASANT RUN ROAD LANCASTER TX 75146 DALLAS (972) 230-8888 Acute Care Hospitals Physician TRUE 32.6041280 -96.8144830 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-idy9.ih28~dnum 670090 649860 2019-06-04 2018-12-31 76 8         84               84
3572 3572 AURORA SHEBOYGAN MEMORIAL MEDICAL CTR 2629 N 7TH ST SHEBOYGAN WI 53083 SHEBOYGAN (920) 451-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.7725680 -87.7112060 0   117 55 55117 43100   Central Sheboygan County https://data.medicare.gov/resource/xubh-q36u/row-udhx~m49a.ksv4 520035 651099 2019-06-04 2018-12-31 124 6       6 136               136
3600 3600 FAITH REGIONAL HEALTH SERVICES 2700 WEST NORFOLK AVE NORFOLK NE 68701 MADISON (402) 371-4880 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.0325260 -97.4509420 0   119 31 31119 35740   Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-xkuw_ar84~23n7 280125 650296 2019-06-04 2018-12-31 98 24         122   7           129
3666 3666 GUNDERSEN TRI-COUNTY HOSPITAL AND CLINICS 18601 LINCOLN ST WHITEHALL WI 54773 TREMPEALEAU (715) 538-4361 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3648270 -91.3186480 0   121 55 55121         https://data.medicare.gov/resource/xubh-q36u/row-d2gk~p9pm.66ab 521316 651112 2019-06-04 2018-12-31 25           25       35       60
3763 3763 AURORA LAKELAND MEDICAL CENTER W3985 COUNTY ROAD NN ELKHORN WI 53121 WALWORTH (262) 741-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6626150 -88.4963220 0   127 55 55127 48580 Milwaukee-Racine-Waukesha, WI Central Walworth County https://data.medicare.gov/resource/xubh-q36u/row-4cr5_2avw.r57w 520102 651102 2019-06-04 2018-12-31 42 12         54   10           64
3807 3807 SABETHA COMMUNITY HOSPITAL 14TH & OREGON SABETHA KS 66534 NEMAHA (785) 284-2121 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.8997686 -95.8071090 1 GEOMETRIC_CENTER 131 20 20131         https://data.medicare.gov/resource/xubh-q36u/row-tatv-27qf.j7tk 171338 650576 2019-06-04 2018-12-31 17           17               17
3822 3822 AURORA MEDICAL CTR WASHINGTON COUNTY 1032 E SUMNER ST HARTFORD WI 53027 WASHINGTON (262) 673-2300 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.3176000 -88.3627340 0   131 55 55131 33340 Milwaukee-Racine-Waukesha, WI Outlying Washington County https://data.medicare.gov/resource/xubh-q36u/row-62iq-acbi.tjtb 520038 651100 2019-06-04 2018-12-31 29 6         35               35
3846 3846 AURORA MEDICAL CENTER SUMMIT 36500 AURORA DRIVE SUMMIT WI 53066 WAUKESHA (262) 434-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.0636110 -88.4677320 0   133 55 55133 33340 Milwaukee-Racine-Waukesha, WI Central Waukesha County https://data.medicare.gov/resource/xubh-q36u/row-8fh6.jgmq_tpak 520206 651110 2019-06-04 2018-12-31 62 14       7 83   8           91
3890 3890 LIVINGSTON HOSPITAL AND HEALTHCARE SERVICES, INC 131 HOSPITAL DRIVE SALEM KY 42078 LIVINGSTON (270) 988-2299 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.2633230 -88.2287530 0   139 21 21139 37140 Paducah-Mayfield, KY-IL Outlying Livingston County https://data.medicare.gov/resource/xubh-q36u/row-7ihk-25ja~yrpx 181320 650818 2019-06-04 2018-12-31 25           25               25
3909 3909 AURORA MEDICAL CTR OSHKOSH 855 N WESTHAVEN DRIVE OSHKOSH WI 54904 WINNEBAGO (920) 456-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.0275410 -88.5932910 0   139 55 55139 36780 Appleton-Oshkosh-Neenah, WI Central Winnebago County https://data.medicare.gov/resource/xubh-q36u/row-iuqr~6b9c.rjpw 520198 651109 2019-06-04 2018-12-31 60 12         72               72
4034 4034 GRINNELL REGIONAL MEDICAL CENTER 210 FOURTH AVENUE GRINNELL IA 50112 POWESHIEK (641) 236-7511 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7432780 -92.7347280 0   157 19 19157         https://data.medicare.gov/resource/xubh-q36u/row-a9wh-r9z4.fibh 160147 650265 2019-06-04 2018-12-31 44 5         49               49
4039 4039 SWIFT COUNTY BENSON HOSPITAL 1815 WISCONSIN AVENUE BENSON MN 56215 SWIFT (320) 843-4232 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.3147570 -95.6089520 0   151 27 27151         https://data.medicare.gov/resource/xubh-q36u/row-zvec-8b67_2ine 241365 651013 2019-06-04 2018-12-31 18           18               18
4075 4075 METHODIST JENNIE EDMUNDSON 933 EAST PIERCE STREET COUNCIL BLUFFS IA 51503 POTTAWATTAMIE (712) 396-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2683090 -95.8361280 0   155 19 19155 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Pottawattamie County https://data.medicare.gov/resource/xubh-q36u/row-ntfw_gx9q-dyir 160047 650569 2019-06-04 2018-12-31 97 13         110               110
4187 4187 RUSH COUNTY MEMORIAL HOSPITAL 801 LOCUST ST LA CROSSE KS 67548 RUSH (785) 222-2545 Critical Access Hospitals Government - Local FALSE 38.5305970 -99.3165720 0   165 20 20165         https://data.medicare.gov/resource/xubh-q36u/row-kzd7-vdnf-jix7 171342 650577 2019-06-04 2018-12-31 16           16               16
4413 4413 ALTUS BAYTOWN HOSPITAL 1404 W BAKER ROAD BAYTOWN TX 77521 HARRIS (281) 837-7600 Acute Care Hospitals Physician TRUE 29.7698160 -94.9801930 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-fa96~fa82_gfbn 670109 650629 2019-06-04 2018-12-31 14           14               14
4515 4515 BAPTIST BEAUMONT HOSPITAL 3080 COLLEGE STREET BEAUMONT TX 77701 JEFFERSON (409) 212-5012 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.0684730 -94.1202550 0   245 48 48245 13140   Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-nnpz-hcu6~mwg8 450346 662082 2019-06-04 2018-08-31 316 25         361 20 15           396
4696 4696 UNITED REGIONAL HEALTH CARE SYSTEM 1600 11TH STREET WICHITA FALLS TX 76301 WICHITA (940) 764-3055 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.9023120 -98.5014820 0   485 48 48485 48660   Central Wichita County https://data.medicare.gov/resource/xubh-q36u/row-6vnd-czde~6m9k 450010 649497 2019-06-04 2018-12-31 226 12 12       250               250

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