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

51 rows where "filed_date" is on date 2019-05-24

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

filed_date (date) ✖

  • 2019-05-24 · 51 ✖
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
102 102 MARY LANNING HEALTHCARE 715 N ST JOSEPH AVE HASTINGS NE 68901 ADAMS (402) 461-5108 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.5924160 -98.3874740 0   1 31 31001 25580   Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-6nbf.h76f_85sy 280032 648632 2019-05-24 2018-12-31 87 10         97 26 9   11       143
172 172 ANDERSON COUNTY HOSPITAL 421 S MAPLE GARNETT KS 66032 ANDERSON (785) 204-4000 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.2801200 -95.2493000 0   3 20 20003         https://data.medicare.gov/resource/xubh-q36u/row-3ktx.x5ze~zgrj 171316 648620 2019-05-24 2018-12-31 12           12           36   48
428 428 BENEWAH COMMUNITY HOSPITAL 229 SOUTH 7TH STREET ST MARIES ID 83861 BENEWAH (208) 245-5551 Critical Access Hospitals Government - Local TRUE 47.3146130 -116.5666780 0   9 16 16009         https://data.medicare.gov/resource/xubh-q36u/row-3wfv~5stn~5t7d 131317 652074 2019-05-24 2018-12-31 19           19               19
598 598 CALHOUN-LIBERTY HOSPITAL 20370 NE BURNS AVE BLOUNTSTOWN FL 32424 CALHOUN (850) 674-3493 Critical Access Hospitals Voluntary non-profit - Private TRUE 30.4581280 -85.0495870 0   13 12 12013         https://data.medicare.gov/resource/xubh-q36u/row-sxhi~5k5k~4igt 101304 651800 2019-05-24 2018-12-31 15           15               15
621 621 BENEFIS HOSPITALS INC 1101 26TH ST S GREAT FALLS MT 59405 CASCADE (406) 455-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.4918480 -111.2626150 0   13 30 30013 24500   Central Cascade County https://data.medicare.gov/resource/xubh-q36u/row-hf5d-meey.a7xt 270012 649795 2019-05-24 2018-12-31 268 20         312   20   146   20   498
684 684 ST ELIZABETH FLORENCE 4900 HOUSTON ROAD FLORENCE KY 41042 BOONE (859) 212-5220 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0176150 -84.6327900 0   15 21 21015 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-udck-fezy-tei6 180045 648693 2019-05-24 2018-12-31 108 18         126       16       142
734 734 COMMUNITY MEMORIAL HOSPITAL MEDICAL CENTER 909 WEST FIRST STREET SUMNER IA 50674 BREMER (563) 578-3275 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.8474220 -92.1096910 0   17 19 19017 47940   Outlying Bremer County https://data.medicare.gov/resource/xubh-q36u/row-c7f9.r33q_65gq 161320 649106 2019-05-24 2018-12-31 16           16               16
805 805 TUCSON MEDICAL CENTER 5301 EAST GRANT ROAD TUCSON AZ 85712 PIMA (520) 327-5461 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.2507490 -110.8801690 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-5nrs.x5vc.rfrt 30006 652130 2019-05-24 2018-12-31 351 36       42 441 16         16   473
986 986 CROSSING RIVERS HEALTH MEDICAL CENTER 37868 US HWY 18 PRAIRIE DU CHIEN WI 53821 CRAWFORD (608) 357-2000 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.0139990 -91.0945020 0   23 55 55023         https://data.medicare.gov/resource/xubh-q36u/row-43cp~si3w~xt56 521330 649381 2019-05-24 2018-12-31 24           24           1   25
1024 1024 CENTRASTATE MEDICAL CENTER 901 WEST MAIN STREET FREEHOLD NJ 7728 MONMOUTH (732) 431-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.2356600 -74.3120250 0   25 34 34025 35620 New York-Newark, NY-NJ-CT-PA Central Monmouth County https://data.medicare.gov/resource/xubh-q36u/row-eqm2_fpdf~v3xp 310111 648642 2019-05-24 2018-12-31 239 25         264               264
1166 1166 PROVIDENCE MEDFORD MEDICAL CENTER 1111 CRATER LAKE AVENUE MEDFORD OR 97504 JACKSON (541) 732-5050 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.3399710 -122.8610000 0   29 41 41029 32780 Medford-Grants Pass, OR Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-wq37.tzys-wnax 380075 648649 2019-05-24 2018-12-31 111 15         126   12           138
1173 1173 COLLETON MEDICAL CENTER 501 ROBERTSON BOULEVARD WALTERBORO SC 29488 COLLETON (843) 782-2000 Acute Care Hospitals Proprietary TRUE 32.9218550 -80.6708800 0   29 45 45029         https://data.medicare.gov/resource/xubh-q36u/row-429y~gw6b~pgj2 420030 648315 2019-05-24 2018-12-31 94 8         102 19 14           135
1197 1197 MEDICAL CENTER ENTERPRISE 400 N EDWARDS STREET ENTERPRISE AL 36330 COFFEE (334) 347-0584 Acute Care Hospitals Proprietary TRUE 31.3181910 -85.8553080 0   31 1 1031 21460 Dothan-Enterprise-Ozark, AL Central Coffee County https://data.medicare.gov/resource/xubh-q36u/row-m58x_64pa.z9zi 10049 648587 2019-05-24 2018-12-31 92 7         99               99
1205 1205 ROSE MEDICAL CENTER 4567 E 9TH AVE DENVER CO 80220 DENVER (303) 320-2121 Acute Care Hospitals Proprietary TRUE 39.7310760 -104.9340110 0   31 8 8031 19740 Denver-Aurora, CO Central Denver County https://data.medicare.gov/resource/xubh-q36u/row-d89y.4k32_5asy 60032 649400 2019-05-24 2018-12-31 167 35       24 226               226
1334 1334 FORT WASHINGTON HOSPITAL 11711 LIVINGSTON ROAD FORT WASHINGTON MD 20744 PRINCE GEORGES (301) 292-7000 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.7288130 -76.9915880 0   33 24 24033 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Prince George's County https://data.medicare.gov/resource/xubh-q36u/row-wn97~mjiu~6g79 210060 648938 2019-05-24 2018-12-31 25 4         29               29
1418 1418 UH ST JOHN MEDICAL CENTER 29000 CENTER RIDGE ROAD WESTLAKE OH 44145 CUYAHOGA (440) 835-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.4358540 -81.9407040 0   35 39 39035 17460 Cleveland-Akron-Canton, OH Central Cuyahoga County https://data.medicare.gov/resource/xubh-q36u/row-fi9g-zaf9.bctx 360123 648738 2019-05-24 2018-12-31 134 36         170               170
1495 1495 PROVIDENCE HOLY CROSS MEDICAL CENTER 15031 RINALDI ST MISSION HILLS CA 91346 LOS ANGELES (818) 365-8051 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.2790130 -118.4594850 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-2tfx_s99b_nbix 50278 648594 2019-05-24 2018-12-31 280 24       12 316   13   48       377
1499 1499 PROVIDENCE SAINT JOHN'S HEALTH CENTER 2121 SANTA MONICA BLVD SANTA MONICA CA 90404 LOS ANGELES (310) 829-5511 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.0300700 -118.4783050 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-i5rc_6v5d~trdh 50290 648595 2019-05-24 2018-12-31 225 23       18 266               266
1503 1503 VALLEY PRESBYTERIAN HOSPITAL 15107 VANOWEN ST VAN NUYS CA 91406 LOS ANGELES (818) 782-6600 Acute Care Hospitals Voluntary non-profit - Other FALSE 34.1939170 -118.4632710 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-k5i4-nbwt~csaa 50126 648666 2019-05-24 2018-12-31 271 20       32 333   17           350
1541 1541 ST ELIZABETH FT THOMAS 85 NORTH GRAND AVENUE FORT THOMAS KY 41075 CAMPBELL (859) 572-3100 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0782810 -84.4646540 0   37 21 21037 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Campbell County https://data.medicare.gov/resource/xubh-q36u/row-c5tu~ywst-jxv8 180001 648692 2019-05-24 2018-12-31 102 21         123       26       149
1644 1644 MEMORIAL HOSPITAL 511 NE 10TH ST ABILENE KS 67410 DICKINSON (785) 263-6610 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.9249610 -97.2064830 0   41 20 20041         https://data.medicare.gov/resource/xubh-q36u/row-7wyc-bxfb~aagq 171381 648690 2019-05-24 2018-12-31 19           19 10     74       103
1888 1888 LEVI HOSPITAL 300 PROSPECT AVE HOT SPRINGS AR 71901 GARLAND (501) 624-1281 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5099450 -93.0566490 0   51 5 5051 26300 Hot Springs-Malvern, AR Central Garland County https://data.medicare.gov/resource/xubh-q36u/row-assk.a57a-njvy 40132 649865 2019-05-24 2018-12-31 1           1 52             53
1987 1987 BLACK RIVER MEMORIAL HOSPITAL 711 W ADAMS ST BLACK RIVER FALLS WI 54615 JACKSON (715) 284-5361 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3023860 -90.8557340 0   53 55 55053         https://data.medicare.gov/resource/xubh-q36u/row-jsyv-sp4j-2ajp 521333 649382 2019-05-24 2018-12-31 25           25               25
2250 2250 GOVE COUNTY MEDICAL CENTER 520 WEST 5TH STREET QUINTER KS 67752 GOVE (785) 754-3341 Critical Access Hospitals Voluntary non-profit - Other TRUE 39.0671610 -100.2413110 0   63 20 20063         https://data.medicare.gov/resource/xubh-q36u/row-yfic-b2ck-cmkm 171367 648622 2019-05-24 2018-12-31 21           21           42   63
2253 2253 HARBOR BEACH COMMUNITY HOSPITAL 210 S FIRST ST HARBOR BEACH MI 48441 HURON (989) 479-3201 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.8424290 -82.6525270 0   63 26 26063         https://data.medicare.gov/resource/xubh-q36u/row-urdm~wdap~hbdt 231313 648275 2019-05-24 2018-12-31 15           15       30       45
2699 2699 ST ELIZABETH GRANT 238 BARNES ROAD WILLIAMSTOWN KY 41097 GRANT (859) 824-8105 Critical Access Hospitals Voluntary non-profit - Church TRUE 38.6478620 -84.5782640 0   81 21 21081 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Outlying Grant County https://data.medicare.gov/resource/xubh-q36u/row-z5ru.drf8.yem5 181311 648696 2019-05-24 2018-12-31 15           15               15
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
2793 2793 GLENCOE REGIONAL HEALTH SERVICES 1805 HENNEPIN AVENUE NORTH GLENCOE MN 55336 MC LEOD (320) 864-3121 Critical Access Hospitals Voluntary non-profit - Other TRUE 44.7775500 -94.1517140 0   85 27 27085 26780 Minneapolis-St. Paul, MN-WI Central McLeod County https://data.medicare.gov/resource/xubh-q36u/row-j3nk_h3k3_6mv6 241355 649274 2019-05-24 2018-12-31 25           25       99       124
2910 2910 CLARK FORK VALLEY HOSPITAL 10 KRUGER RD PLAINS MT 59859 SANDERS (406) 826-4800 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.4695390 -114.8919080 0   89 30 30089         https://data.medicare.gov/resource/xubh-q36u/row-325u_sses_9br7 271323 649796 2019-05-24 2018-12-31 16           16       28       44
3071 3071 AMERY HOSPITAL & CLINIC 265 GRIFFIN STREET EAST AMERY WI 54001 POLK (715) 268-0300 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.2959460 -92.3606700 0   95 55 55095         https://data.medicare.gov/resource/xubh-q36u/row-nbii-jcut-5ka3 521308 649379 2019-05-24 2018-12-31 25           25 10             35
3127 3127 ST JOSEPH'S HOSPITAL 1 AMALIA DRIVE BUCKHANNON WV 26201 UPSHUR (304) 472-2000 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.9912750 -80.2368240 0   97 54 54097         https://data.medicare.gov/resource/xubh-q36u/row-dwxq.ey9z_ufif 511321 649690 2019-05-24 2018-12-31 21 4         25       10 16     51
3264 3264 SAINT LUKE'S CUSHING HOSPITAL 711 MARSHALL STREET LEAVENWORTH KS 66048 LEAVENWORTH (913) 684-1100 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.3077730 -94.9183550 0   103 20 20103 28140 Kansas City-Overland Park-Kansas City, MO-KS Outlying Leavenworth County https://data.medicare.gov/resource/xubh-q36u/row-ydtv.9qfe.iqxb 170133 648617 2019-05-24 2018-12-31 20 4         24               24
3270 3270 ST TAMMANY PARISH HOSPITAL 1202 S TYLER STREET COVINGTON LA 70433 ST. TAMMANY (985) 898-4000 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.4689550 -90.1139350 0   103 22 22103 35380 New Orleans-Metairie-Hammond, LA-MS Outlying St. Tammany Parish https://data.medicare.gov/resource/xubh-q36u/row-g77w.u6w7-nqad 190045 648263 2019-05-24 2018-12-31 149 24         188   12           200
3314 3314 CYPRESS POINTE SURGICAL HOSPITAL 42570 SOUTH AIRPORT RD HAMMOND LA 70403 TANGIPAHOA (985) 510-6200 Acute Care Hospitals Physician FALSE 30.4770420 -90.4142640 0   105 22 22105 25220 New Orleans-Metairie-Hammond, LA-MS Central Tangipahoa Parish https://data.medicare.gov/resource/xubh-q36u/row-hpin~yhn8-9yzq 190303 648698 2019-05-24 2018-12-31 30           30               30
3332 3332 BELOIT MEMORIAL HOSPITAL 1969 W HART RD BELOIT WI 53511 ROCK (608) 364-5011 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.5467660 -89.0076160 0   105 55 55105 27500 Madison-Janesville-Beloit, WI Central Rock County https://data.medicare.gov/resource/xubh-q36u/row-jfqs_633q~b3um 520100 649378 2019-05-24 2018-12-31 91 12         103               103
3407 3407 WESTFIELDS HOSPITAL AND CLINIC 535 HOSPITAL RD NEW RICHMOND WI 54017 ST. CROIX (715) 243-2600 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.1174600 -92.5532140 0   109 55 55109 33460 Minneapolis-St. Paul, MN-WI Outlying St. Croix County https://data.medicare.gov/resource/xubh-q36u/row-v45z.6njd_wida 521345 649384 2019-05-24 2018-12-31 25           25               25
3410 3410 HUDSON HOSPITAL & CLINIC 405 STAGELINE ROAD HUDSON WI 54016 ST. CROIX (715) 531-6000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9622890 -92.7188390 0   109 55 55109 33460 Minneapolis-St. Paul, MN-WI Outlying St. Croix County https://data.medicare.gov/resource/xubh-q36u/row-sjw8_yf3z~m67j 521335 649383 2019-05-24 2018-12-31 25           25               25
3503 3503 PINE CREEK MEDICAL CENTER LLP 9032 HARRY HINES BLVD DALLAS TX 75235 DALLAS (214) 231-2273 Acute Care Hospitals Proprietary TRUE 32.8401610 -96.8688350 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-yjax~idz9_awg3 450894 648768 2019-05-24 2018-12-31 15           15               15
3521 3521 DOCTORS HOSPITAL OF SARASOTA 5731 BEE RIDGE RD SARASOTA FL 34233 SARASOTA (941) 342-1100 Acute Care Hospitals Proprietary TRUE 27.2989750 -82.4548480 0   115 12 12115 35840 North Port-Sarasota, FL Central Sarasota County https://data.medicare.gov/resource/xubh-q36u/row-5phw~tq29_truf 100166 651508 2019-05-24 2018-12-31 123 16         139 16             155
3648 3648 MERIT HEALTH RANKIN 350 CROSSGATES BLVD BRANDON MS 39042 RANKIN (601) 825-2811 Acute Care Hospitals Proprietary TRUE 32.2862140 -90.0359600 0   121 28 28121 27140 Jackson-Vicksburg-Brookhaven, MS Central Rankin County https://data.medicare.gov/resource/xubh-q36u/row-cu6y_iea7.rvw5 250096 648279 2019-05-24 2018-12-31 106 8         114 20             134
3682 3682 REGIONS HOSPITAL 640 JACKSON STREET SAINT PAUL MN 55101 RAMSEY (651) 254-1616 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.9553380 -93.0962770 0   123 27 27123 33460 Minneapolis-St. Paul, MN-WI Central Ramsey County https://data.medicare.gov/resource/xubh-q36u/row-36zs~9stm-xa4i 240106 649268 2019-05-24 2018-12-31 375 16 12   18 10 431   21           452
3889 3889 TRINITY MUSCATINE 1518 MULBERRY AVENUE MUSCATINE IA 52761 MUSCATINE (563) 264-9100 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.4341730 -91.0527270 0   139 19 19139 34700 Davenport-Moline, IA-IL Central Muscatine County https://data.medicare.gov/resource/xubh-q36u/row-cv94-yyca.ev4v 160013 648246 2019-05-24 2018-12-31 40 5         45               45
4133 4133 TRINITY ROCK ISLAND 2701 17TH ST ROCK ISLAND IL 61201 ROCK ISLAND (309) 779-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.4836490 -90.5727990 0   161 17 17161 19340 Davenport-Moline, IA-IL Central Rock Island County https://data.medicare.gov/resource/xubh-q36u/row-93v6_urpw.vbnn 140280 648241 2019-05-24 2018-12-31 237 20 31       297   22   29       348
4135 4135 MANHATTAN SURGICAL HOSPITAL LLC 1829 COLLEGE AVENUE MANHATTAN KS 66502 RILEY (785) 776-5100 Acute Care Hospitals Physician FALSE 39.2028260 -96.5981830 0   161 20 20161 31740 Manhattan-Junction City, KS Central Riley County https://data.medicare.gov/resource/xubh-q36u/row-5vw9~wxt5.eejp 170190 648618 2019-05-24 2018-12-31 13           13               13
4157 4157 TRINITY BETTENDORF 4500 UTICA RIDGE ROAD BETTENDORF IA 52722 SCOTT (563) 742-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.5661050 -90.5173600 0   163 19 19163 19340 Davenport-Moline, IA-IL Central Scott County https://data.medicare.gov/resource/xubh-q36u/row-nhf5_m4te.4x9j 160104 648247 2019-05-24 2018-12-31 71 10         87               87
4175 4175 LAKEVIEW MEMORIAL HOSPITAL 927 WEST CHURCHILL STREET STILLWATER MN 55082 WASHINGTON (651) 430-5330 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.0481260 -92.8184890 0   163 27 27163 33460 Minneapolis-St. Paul, MN-WI Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-wues-hzji_9g79 240066 649267 2019-05-24 2018-12-31 55 13         68               68
4246 4246 WOMEN'S HOSPITAL THE 4199 GATEWAY BLVD NEWBURGH IN 47630 WARRICK (812) 842-4200 Acute Care Hospitals Proprietary TRUE 37.9735480 -87.4491090 0   173 18 18173 21780   Central Warrick County https://data.medicare.gov/resource/xubh-q36u/row-rn9t.t87t.eat4 150149 648611 2019-05-24 2018-12-31 50 24         74               74
4251 4251 KANSAS SPINE & SPECIALTY HOSPITAL, LLC 3333 NORTH WEBB ROAD WICHITA KS 67226 SEDGWICK (316) 462-5326 Acute Care Hospitals Physician FALSE 37.7439660 -97.2263260 0   173 20 20173 48620 Wichita-Arkansas City-Winfield, KS Central Sedgwick County https://data.medicare.gov/resource/xubh-q36u/row-qfsa.vac4~t9rr 170196 648689 2019-05-24 2018-12-31 36           36               36
4391 4391 HARDEMAN COUNTY MEMORIAL HOSPITAL 402 MERCER ST QUANAH TX 79252 HARDEMAN (940) 663-2795 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.2965660 -99.7410560 0   197 48 48197         https://data.medicare.gov/resource/xubh-q36u/row-u2zf.mvvx_urz7 451352 648770 2019-05-24 2018-12-31 24           24               24
4608 4608 QUAIL CREEK SURGICAL HOSPITAL 6819 PLUM CREEK AMARILLO TX 79124 POTTER (806) 354-6100 Acute Care Hospitals Proprietary TRUE 35.2106750 -101.9135680 0   375 48 48375 11100 Amarillo-Borger, TX Central Potter County https://data.medicare.gov/resource/xubh-q36u/row-3fht_yhjz.yec5 450875 648767 2019-05-24 2018-12-31 32           32               32
4687 4687 WARD MEMORIAL HOSPITAL 406 SOUTH GARY ST MONAHANS TX 79756 WARD (432) 943-2511 Critical Access Hospitals Government - Local TRUE 31.5939700 -102.8845830 0   475 48 48475         https://data.medicare.gov/resource/xubh-q36u/row-sujn~5cdz-gz6m 451373 648492 2019-05-24 2018-12-31 21           21               21

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