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

4,766 rows sorted by emergency_services

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, burn_beds, subprovider_oth_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
39 39 SAGE MEMORIAL HOSPITAL STATE ROUTE 264 SOUTH 191 GANADO AZ 86505 APACHE (928) 755-4541 Critical Access Hospitals Voluntary non-profit - Private FALSE 35.7108602 -109.5423597 1 ROOFTOP 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-vmgp-erfi.puty 31309 652060 2019-05-06 2018-09-30 25           25               25
85 85 TREASURE VALLEY HOSPITAL 8800 WEST EMERALD STREET BOISE ID 83704 ADA (208) 373-5000 Acute Care Hospitals Proprietary FALSE 43.6112890 -116.2903320 0   1 16 16001 14260 Boise City-Mountain Home-Ontario, ID-OR Central Ada County https://data.medicare.gov/resource/xubh-q36u/row-egh2.u29a~s2jf 130063 650684 2019-05-31 2018-12-31 9           9               9
125 125 MILFORD VALLEY MEMORIAL HOSPITAL 850 NORTH MAIN STREET MILFORD UT 84751 BEAVER (435) 387-2411 Critical Access Hospitals Government - Hospital District or Authority FALSE 38.4073080 -113.0095430 0   1 49 49001         https://data.medicare.gov/resource/xubh-q36u/row-iet4.f5zs.batz 461305 648782 2019-05-29 2018-12-31 5           5           18   23
148 148 HEBREW HOME AND HOSPITAL INC 1 ABRAHMS BOULEVARD WEST HARTFORD CT 6117 HARTFORD (860) 523-3800 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.8027740 -72.7289310 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-eqjh_iqnh-wsnp 70040 645324 2019-02-28 2018-09-30 23           23 22             45
158 158 SHRINERS HOSPITAL FOR CHILDREN 1310 PUNAHOU STREET HONOLULU HI 96826 HONOLULU (808) 941-4466 Childrens Voluntary non-profit - Private FALSE 21.3002330 -157.8343650 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-jcn3.53aq~rski 123301 644976 2018-05-31 2017-12-31                              
168 168 THE ORTHOPAEDIC HOSPITAL OF LUTHERAN HEALTH NETWOR 7952 W JEFFERSON BLVD FORT WAYNE IN 46804 ALLEN (260) 435-2999 Acute Care Hospitals Proprietary FALSE 41.0373520 -85.2459180 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-65sn_hsdz_dbbf 150168 649728 2019-06-03 2018-12-31 39           39               39
191 191 HARMON HOSPITAL 2170 EAST HARMON AVENUE LAS VEGAS NV 89119 CLARK (702) 794-0100 Acute Care Hospitals Voluntary non-profit - Private FALSE 36.1073690 -115.1219920 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-qtzp-aczd_sysf 290042 629833 2018-05-31 2017-12-31                              
205 205 ORTHOPEDIC SPECIALTY HOSPITAL OF NEVADA 8656 WEST PATRICK LANE LAS VEGAS NV 89148 CLARK (702) 777-7100 Acute Care Hospitals Voluntary non-profit - Private FALSE 36.0778110 -115.2810360 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-zknv_98at.vvbk 290056 645924 2019-03-28 2018-10-31 130           130               130
216 216 CUBA MEMORIAL HOSPITAL, INC 140 WEST MAIN STREET CUBA NY 14727 ALLEGANY (585) 961-2000 Critical Access Hospitals Voluntary non-profit - Private FALSE 42.2133410 -78.2881390 0   3 36 36003         https://data.medicare.gov/resource/xubh-q36u/row-2ir6~7udp_pyzv 331301 651038 2019-06-03 2018-12-31 20           20       61       81
219 219 LIMA MEMORIAL HEALTH SYSTEM 1001 BELLEFONTAINE AVENUE LIMA OH 45804 ALLEN (419) 226-3335 Acute Care Hospitals Voluntary non-profit - Other FALSE 40.7356020 -84.0877130 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-p8qs-v8mw~whtd 360009 648963 2019-05-30 2018-12-31 123 16 16       155   17           172
221 221 INSTITUTE FOR ORTHOPAEDIC SURGERY 801 MEDICAL DRIVE, SUITE B LIMA OH 45804 ALLEN (419) 224-7586 Acute Care Hospitals Proprietary FALSE 40.6985860 -84.0864770 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-kbua_iifb.k5nj 360263 649649 2019-06-03 2018-12-31 12           12               12
234 234 CHILDREN'S HOME OF PITTSBURGH 5324 PENN AVENUE PITTSBURGH PA 15224 ALLEGHENY (412) 441-4884 Childrens Voluntary non-profit - Private FALSE 40.4646370 -79.9376420 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-7vky_uvyh~58pt 393304 659723 2019-10-01 2019-06-30                              
256 256 TUBA CITY REGIONAL HEALTH CARE CORPORATION PO BOX 600 TUBA CITY AZ 86045 COCONINO (928) 283-2501 Acute Care Hospitals Voluntary non-profit - Other FALSE 36.1279296 -111.2249984 1 ROOFTOP 5 4 4005 22380   Central Coconino County https://data.medicare.gov/resource/xubh-q36u/row-hne8.hg7p.2gfd 30073 651368 2019-07-01 2018-09-30 73           73               73
282 282 UMD REHABILITATION & ORTHOPAEDIC INSTITUTE 2200 KERNAN DRIVE BALTIMORE MD 21207 BALTIMORE (410) 448-6701 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.3128640 -76.7117120 0   5 24 24005 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore County https://data.medicare.gov/resource/xubh-q36u/row-nphg_serw~vzg7 210058 660819 2019-12-02 2019-06-30 137           137               137
291 291 ESSENTIA HEALTH ST MARYS - DETROIT LAKES 1027 WASHINGTON AVE DETROIT LAKES MN 56501 BECKER (218) 847-0888 Acute Care Hospitals Voluntary non-profit - Church FALSE 46.8153070 -95.8454530 0   5 27 27005         https://data.medicare.gov/resource/xubh-q36u/row-my2b~zwif~njdr 240101 660605 2019-11-26 2019-06-30 28 8         36       96       132
297 297 VIRTUA MEMORIAL HOSPITAL OF BURLINGTON COUNTY 175 MADISON AVE MOUNT HOLLY NJ 8060 BURLINGTON (609) 267-0700 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.9856980 -74.7958320 0   5 34 34005 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Burlington County https://data.medicare.gov/resource/xubh-q36u/row-w3rd~k8u3.pry2 310057 648553 2019-05-23 2018-12-31 279 38         317 22             339
298 298 DEBORAH HEART AND LUNG CENTER 200 TRENTON ROAD BROWNS MILLS NJ 8015 BURLINGTON (609) 893-6611 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.9772740 -74.5862100 0   5 34 34005 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Burlington County https://data.medicare.gov/resource/xubh-q36u/row-c4uq~iz68.dyj7 310031 651342 2019-07-01 2018-12-31 62 24         86               86
310 310 UNIVERSITY HOSPITALS SAMARITAN MEDICAL CENTER 1025 CENTER ST ASHLAND OH 44805 ASHLAND (419) 289-0491 Acute Care Hospitals Voluntary non-profit - Other FALSE 40.8587020 -82.3104130 0   5 39 39005 11740 Mansfield-Ashland-Bucyrus, OH Central Ashland County https://data.medicare.gov/resource/xubh-q36u/row-suim.pydj-jawn 360002 649303 2019-06-03 2018-12-31 33 6         39               39
314 314 PROVIDENCE MILWAUKIE HOSPITAL 10150 SE 32ND AVENUE MILWAUKIE OR 97222 CLACKAMAS (503) 513-8336 Acute Care Hospitals Voluntary non-profit - Church FALSE 45.4497140 -122.6297910 0   5 41 41005 38900 Portland-Vancouver-Salem, OR-WA Central Clackamas County https://data.medicare.gov/resource/xubh-q36u/row-enfi.92yw~y8ym 380082 647935 2019-05-16 2018-12-31 34 6         40 19             59
337 337 BANNER PAYSON MEDICAL CENTER 807 SOUTH PONDEROSA DRIVE PAYSON AZ 85541 GILA (928) 474-3222 Critical Access Hospitals Voluntary non-profit - Other FALSE 34.2313510 -111.3213610 0   7 4 4007 37740   Central Gila County https://data.medicare.gov/resource/xubh-q36u/row-2gy2.vxfy~pkyq 31318 649532 2019-06-03 2018-12-31 21 4         25               25
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
377 377 GLENBEIGH HEALTH SOURCES 2863 STATE ROUTE 45 ROCK CREEK OH 44084 ASHTABULA (440) 563-3400 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.6724460 -80.8567230 0   7 39 39007 11780 Cleveland-Akron-Canton, OH Central Ashtabula County https://data.medicare.gov/resource/xubh-q36u/row-sbjb.gyph-ssjq 360245 648742 2019-05-29 2018-12-31 114           114               114
396 396 CONFLUENCE HEALTH- WENATCHEE VALLEY HOSP & CLINICS 820 NORTH CHELAN AVENUE WENATCHEE WA 98801 CHELAN (509) 663-8711 Acute Care Hospitals Voluntary non-profit - Private FALSE 47.4335660 -120.3219830 0   7 53 53007 48300   Central Chelan County https://data.medicare.gov/resource/xubh-q36u/row-aiqi_mn7n_vecf 500148 650791 2019-05-31 2018-12-31 11           11   9           20
402 402 ST VINCENTS BLOUNT 150 GILBREATH DRIVE ONEONTA AL 35121 BLOUNT (205) 274-3000 Critical Access Hospitals Voluntary non-profit - Private FALSE 33.9325370 -86.4930590 0   9 1 1009 13820 Birmingham-Hoover-Talladega, AL Outlying Blount County https://data.medicare.gov/resource/xubh-q36u/row-nhvc-v4py.tnm6 11305 659402 2019-11-22 2019-06-30 19 6         25               25
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
406 406 MARK TWAIN MEDICAL CENTER 768 MOUNTAIN RANCH RD SAN ANDREAS CA 95249 CALAVERAS (209) 754-2515 Critical Access Hospitals Voluntary non-profit - Other FALSE 38.1909730 -120.6706610 0   9 6 6009         https://data.medicare.gov/resource/xubh-q36u/row-vzvr.d5an~vpec 51332 660493 2019-12-03 2019-06-30 25           25               25
414 414 CONNECTICUT HOSPICE INC,THE 100 DOUBLE BEACH ROAD BRANFORD CT 6405 NEW HAVEN (203) 315-7500 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.2563050 -72.8333670 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-9pw4-ddrr.eyyi 70038 645241 2019-03-01 2018-09-30 6           6           46   52
415 415 MASONICARE HEALTH CENTER 22 MASONIC AVE WALLINGFORD CT 6492 NEW HAVEN (203) 679-5900 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.4606980 -72.8365860 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-qb4p-gu4j_xpz9 70039 645323 2019-02-28 2018-09-30 30           30 29     366   86   511
425 425 MAUI MEMORIAL MEDICAL CENTER 221 MAHALANI STREET WAILUKU HI 96793 MAUI (808) 442-5101 Acute Care Hospitals Government - State FALSE 20.8844550 -156.4880870 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-66fd~zrmp.8s5u 120002 649892 2019-06-03 2018-12-31 199 20         219               219
487 487 MEMORIAL REGIONAL HOSPITAL 3501 JOHNSON ST HOLLYWOOD FL 33021 BROWARD (954) 265-5814 Acute Care Hospitals Government - Hospital District or Authority FALSE 26.0182620 -80.1788650 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-4ubz~aqu5.47ug 100038 654989 2019-10-01 2019-04-30 694 92       84 870 54 89           1013
489 489 BROWARD HEALTH IMPERIAL POINT 6401 N FEDERAL HWY FORT LAUDERDALE FL 33308 BROWARD (954) 776-8500 Acute Care Hospitals Government - Hospital District or Authority FALSE 26.2068810 -80.1080570 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-bdjf.gjbn-c4jh 100200 661482 2019-12-03 2019-06-30 72 10         129 45             174
494 494 WESTSIDE REGIONAL MEDICAL CENTER 8201 W BROWARD BLVD PLANTATION FL 33324 BROWARD (954) 473-6600 Acute Care Hospitals Proprietary FALSE 26.1208820 -80.2584290 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-nnuu-rs8x~9yxs 100228 651509 2019-06-28 2019-01-31 192 32         224               224
499 499 GROVE CREEK MEDICAL CENTER 350 NORTH MERIDIAN STREET BLACKFOOT ID 83221 BINGHAM (208) 782-2900 Acute Care Hospitals Voluntary non-profit - Private FALSE 43.1963010 -112.3561240 0   11 16 16011 13940 Idaho Falls-Rexburg-Blackfoot, ID Central Bingham County https://data.medicare.gov/resource/xubh-q36u/row-ej2j_mw5y_vys8                                      
533 533 SURGICAL INSTITUTE OF READING 2752 CENTURY BOULEVARD WYOMISSING PA 19610 BERKS (717) 999-9999 Acute Care Hospitals Proprietary FALSE 40.3579510 -75.9875770 0   11 42 42011 39740 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Berks County https://data.medicare.gov/resource/xubh-q36u/row-3aqm~vs6z.7ify 390316 651482 2019-06-25 2018-12-31 15           15               15
539 539 PHOENIX CHILDREN'S HOSPITAL 1919 EAST THOMAS ROAD PHOENIX AZ 85016 MARICOPA (602) 933-1000 Childrens Voluntary non-profit - Private FALSE 33.4802160 -112.0411930 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-feed_vt9a~9ie7 33302 650636 2019-05-31 2018-12-31 352           433               433
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
556 556 ARIZONA SPECIALTY HOSPITAL 2905 WEST WARNER ROAD, SUITE 1 CHANDLER AZ 85224 MARICOPA (480) 603-9000 Acute Care Hospitals Proprietary FALSE 33.3348400 -111.8911330 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-z5xq-7gkm.mjtq 30112 649698 2019-05-22 2018-12-31 24           24               24
560 560 HACIENDA CHILDREN'S HOSPITAL, INC. 610 WEST JEROME AVENUE MESA AZ 85210 MARICOPA (602) 243-4231 Childrens Proprietary FALSE 33.3811280 -111.8448920 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-r4wv.uiyn_d6cn 33303 654954 2018-11-26 2018-07-31                              
572 572 BANNER HEART HOSPITAL 6750 EAST BAYWOOD AVENUE MESA AZ 85206 MARICOPA (480) 854-5050 Acute Care Hospitals Voluntary non-profit - Private FALSE 33.4103780 -111.6852730 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-tx6q_94yb.s344 30105 651582 2019-06-03 2018-12-31 67   44       111               111
575 575 DIGNITY HEALTH - ARIZONA GENERAL HOSPITAL 7171 SOUTH 51ST AVENUE LAVEEN AZ 85339 MARICOPA (623) 584-5100 Acute Care Hospitals Proprietary FALSE 33.3806770 -112.1682330 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-6h9g-s46a~aiyi 30136 651169 2019-06-03 2018-12-31 16           16               16
576 576 CORE INSTITUTE SPECIALTY HOSPITAL, THE 6501 NORTH 19TH AVENUE PHOENIX AZ 85015 MARICOPA (602) 795-6020 Acute Care Hospitals Physician FALSE 33.5318370 -112.0996140 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-ymwb.kuwb~xe6j 30108 659179 2019-06-03 2018-12-31 32           32               32
578 578 WESTERN REGIONAL MEDICAL CENTER 14200 WEST CELEBRATE LIFE WAY GOODYEAR AZ 85338 MARICOPA (623) 207-3518 Acute Care Hospitals Proprietary FALSE 33.4528040 -112.3625710 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-rhgj.utwd-n4qy                                      
579 579 O.A.S.I.S. HOSPITAL 750 NORTH 40TH STREET PHOENIX AZ 85008 MARICOPA (602) 797-7700 Acute Care Hospitals Voluntary non-profit - Private FALSE 33.4567200 -111.9952100 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-ca9p~mgu7-kv2v 30131 650634 2019-05-29 2018-12-31 60 4         64               64
581 581 ARIZONA SPINE AND JOINT HOSPITAL 4620 EAST BASELINE ROAD MESA AZ 85206 MARICOPA (480) 832-4770 Acute Care Hospitals Physician FALSE 33.3792060 -111.7346950 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-ijxi~2kwd~swq9 30107 650233 2019-05-29 2018-12-31 23           23               23
582 582 BANNER BAYWOOD MEDICAL CENTER 6644 EAST BAYWOOD AVENUE MESA AZ 85206 MARICOPA (480) 321-2000 Acute Care Hospitals Voluntary non-profit - Private FALSE 33.4104650 -111.6880450 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-xp3v_96ea.bqwa 30088 649064 2019-06-03 2018-12-31 292 26         318   22           340
612 612 SHRINERS' HOSPITAL FOR CHILDREN (THE) 516 CAREW STREET SPRINGFIELD MA 1104 HAMPDEN (413) 787-2000 Childrens Voluntary non-profit - Private FALSE 42.1205580 -72.5915680 0   13 25 25013 44140 Springfield-Greenfield Town, MA Central Hampden County https://data.medicare.gov/resource/xubh-q36u/row-xahc-ecbk~n8v6 223303 652750 2019-05-30 2018-12-31                              
628 628 SAINT MICHAEL'S MEDICAL CENTER 111 CENTRAL AVENUE NEWARK NJ 7102 ESSEX (973) 877-5350 Acute Care Hospitals Voluntary non-profit - Private FALSE 40.7430340 -74.1745030 0   13 34 34013 35620 New York-Newark, NY-NJ-CT-PA Central Essex County https://data.medicare.gov/resource/xubh-q36u/row-dg26.pigt.8gmu 310096 649296 2019-05-30 2018-12-31 117 30         147               147
647 647 NH Beaufort 1 Pinckney Blvd Beaufort SC 29902 BEAUFORT (843) 228-5600 Acute Care - Department of Defense Department of Defense FALSE 32.3889769 -80.6825821 1 ROOFTOP 13 45 45013 25940   Central Beaufort County https://data.medicare.gov/resource/xubh-q36u/row-uc4x_u34w~fpt9                                      
656 656 HALQUIST MEMORIAL INPATIENT CENTER 4715 NORTH 15 STREET ARLINGTON VA 22205 ARLINGTON (703) 525-7070 Acute Care Hospitals Voluntary non-profit - Private FALSE 38.8879410 -77.1216690 0   13 51 51013 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Arlington County https://data.medicare.gov/resource/xubh-q36u/row-vmzf.p4zi.8e5f 490129 651083 2019-06-03 2018-12-31                         36   36
659 659 DAYTON GENERAL HOSPITAL 1012 SOUTH 3RD STREET DAYTON WA 99328 COLUMBIA (509) 382-2531 Critical Access Hospitals Government - Hospital District or Authority FALSE 46.3125640 -117.9688720 0   13 53 53013 47460   Outlying Columbia County https://data.medicare.gov/resource/xubh-q36u/row-28j5-9jsv-a9rd 501302 648506 2019-05-23 2018-12-31 25           25         23     48
686 686 UNION HOSPITAL OF CECIL COUNTY 106 BOW STREET ELKTON MD 21921 CECIL (410) 392-7009 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.6080100 -75.8310280 0   15 24 24015 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Cecil County https://data.medicare.gov/resource/xubh-q36u/row-pkde-hn33.kiax 210032 660230 2019-11-25 2019-06-30 91 5         96               96
700 700 CARLSBAD MEDICAL CENTER 2430 WEST PIERCE STREET CARLSBAD NM 88220 EDDY (575) 887-4570 Acute Care Hospitals Proprietary FALSE 32.4418400 -104.2586420 0   15 35 35015 16100   Central Eddy County https://data.medicare.gov/resource/xubh-q36u/row-5km2_nhcx~29i4 320063 655571 2019-02-27 2018-08-31 84 12         96   10   15       121
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
724 724 HOPI HEALTH CARE CENTER HIGHWAY 264, MILEPOST 388 POLACCA AZ 86042 NAVAJO (928) 737-6000 Critical Access Hospitals Tribal FALSE 35.8022226 -110.4260281 1 GEOMETRIC_CENTER 17 4 4017 43320   Central Navajo County https://data.medicare.gov/resource/xubh-q36u/row-6zw9_3xdm~7vqp 31305 646377 2019-03-28 2018-09-30 6           6               6
739 739 SHRINERS HOSPITALS FOR CHILDREN 3100 SAMFORD AVENUE SHREVEPORT LA 71103 CADDO (318) 222-5704 Childrens Voluntary non-profit - Private FALSE 32.4812950 -93.7566370 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-yvmb~28rx-rdcg 193301 647125 2018-05-31 2017-12-31                              
740 740 SPECIALISTS HOSPITAL SHREVEPORT 1500 LINE AVENUE SHREVEPORT LA 71101 CADDO (318) 213-3800 Acute Care Hospitals Physician FALSE 32.4969260 -93.7460460 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-kr9t-dd8q-wfhi 190278 649901 2019-06-03 2018-12-31 15           15               15
760 760 TRACE REGIONAL HOSP AND SWING BED 1002 EAST MADISON STREET HOUSTON MS 38851 CHICKASAW (662) 456-3700 Acute Care Hospitals Proprietary FALSE 33.8947900 -88.9850850 0   17 28 28017         https://data.medicare.gov/resource/xubh-q36u/row-kmgr_friv-daby 250017 659509 2019-11-22 2019-06-30 39           39 15     66       120
785 785 ROTHMAN ORTHOPAEDIC SPECIALTY HOSPITAL LLC 3300 TILLMAN DRIVE BENSALEM PA 19020 BUCKS (215) 244-7400 Acute Care Hospitals Proprietary FALSE 40.1143500 -74.9620930 0   17 42 42017 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Bucks County https://data.medicare.gov/resource/xubh-q36u/row-w5gs-9pze-8zau 390322 649490 2019-06-03 2018-12-31 24           24               24
787 787 BARIX CLINICS OF PENNSYLVANIA 280 MIDDLETOWN ROAD LANGHORNE PA 19047 BUCKS (267) 572-3100 Acute Care Hospitals Proprietary FALSE 40.1818010 -74.8845420 0   17 42 42017 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Bucks County https://data.medicare.gov/resource/xubh-q36u/row-bu4h.v5rj.beuc 390302 651664 2019-07-03 2018-12-31 23           23               23
813 813 FRESNO SURGICAL HOSPITAL 6125 NORTH FRESNO ST FRESNO CA 93710 FRESNO (559) 431-8000 Acute Care Hospitals Proprietary FALSE 36.8246440 -119.7814160 0   19 6 6019 23420 Fresno-Madera, CA Central Fresno County https://data.medicare.gov/resource/xubh-q36u/row-dnq2~ysu6.fk9q 50708 646604 2019-04-15 2018-12-31 27           27               27
816 816 ADVENTIST HEALTH REEDLEY 372 W CYPRESS AVE REEDLEY CA 93654 FRESNO (559) 638-8155 Acute Care Hospitals Voluntary non-profit - Private FALSE 36.6078120 -119.4516950 0   19 6 6019 23420 Fresno-Madera, CA Central Fresno County https://data.medicare.gov/resource/xubh-q36u/row-re3j_d2jv_jrs3 50192 659200 2019-05-31 2018-12-31 49           49               49
819 819 MOUNTAIN VIEW HOSPITAL 2325 CORONADO STREET IDAHO FALLS ID 83404 BONNEVILLE (208) 557-2700 Acute Care Hospitals Physician FALSE 43.4725240 -111.9887170 0   19 16 16019 26820 Idaho Falls-Rexburg-Blackfoot, ID Central Bonneville County https://data.medicare.gov/resource/xubh-q36u/row-4xx8-2i4p-wi9n 130065 649556 2019-05-31 2018-12-31 41           41               41
896 896 PREMIER SURGICAL INSTITUTE 1619 K 66 GALENA KS 66739 CHEROKEE (620) 783-1732 Acute Care Hospitals Government - Local FALSE 37.0766240 -94.6218020 0   21 20 20021         https://data.medicare.gov/resource/xubh-q36u/row-rere_4r4a~kxmn 170203 648913 2019-05-28 2018-12-31 36           36               36
899 899 CALDWELL MEMORIAL HOSPITAL, INC 411 MAIN STREET COLUMBIA LA 71418 CALDWELL (318) 649-6111 Acute Care Hospitals Voluntary non-profit - Private FALSE 32.1041420 -92.0761550 0   21 22 22021         https://data.medicare.gov/resource/xubh-q36u/row-tzge.ni5n-rwic 190190 649740 2019-05-30 2018-12-31 37           37   10           47
900 900 CHARLES A DEAN MEMORIAL HOSPITAL PO BOX 1129 GREENVILLE ME 4441 PISCATAQUIS (207) 695-5200 Critical Access Hospitals Voluntary non-profit - Private FALSE 45.4594923 -69.5906060 1 GEOMETRIC_CENTER 21 23 23021         https://data.medicare.gov/resource/xubh-q36u/row-e23p-cjiz~ui3t 201301 650155 2019-06-21 2018-09-30 25           25               25
907 907 LAKELAND HOSPITAL WATERVLIET 400 MEDICAL PARK DR WATERVLIET MI 49098 BERRIEN (269) 463-3111 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.1848660 -86.2507600 0   21 26 26021 35660 South Bend-Elkhart-Mishawaka, IN-MI Central Berrien County https://data.medicare.gov/resource/xubh-q36u/row-7efk~hcgi~rsxw 230078 645339 2019-02-28 2018-09-30 26           26   18           44
910 910 CLAIBORNE COUNTY HOSPITAL 123 MCCOMB AVENUE PORT GIBSON MS 39150 CLAIBORNE (601) 437-5141 Critical Access Hospitals Government - Local FALSE 31.9459920 -90.9853950 0   21 28 28021 46980 Jackson-Vicksburg-Brookhaven, MS Outlying Claiborne County https://data.medicare.gov/resource/xubh-q36u/row-wz4r-hvew~et2i 251320 650593 2019-05-31 2018-12-31 22           22 10             32
918 918 CAPITAL HEALTH MEDICAL CENTER - HOPEWELL ONE CAPITAL WAY PENNINGTON NJ 8534 MERCER (609) 303-4000 Acute Care Hospitals Voluntary non-profit - Private FALSE 40.2918008 -74.8041257 1 ROOFTOP 21 34 34021 45940 New York-Newark, NY-NJ-CT-PA Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-57bi.fjhf.mmkn 310044 649048 2019-05-31 2018-12-31 129 16         145               145
966 966 CHILDREN'S SPECIALIZED HOSPITAL 200 SOMERSET STREET NEW BRUNSWICK NJ 8901 MIDDLESEX (732) 258-7050 Childrens Voluntary non-profit - Private FALSE 40.4952200 -74.4515090 0   23 34 34023 35620 New York-Newark, NY-NJ-CT-PA Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-q3gw~cqak.nu9s 313300 649806 2019-05-28 2018-12-31 68           68       46       114
975 975 OHIO VALLEY SURGICAL HOSPITAL 100 WEST MAIN STREET SPRINGFIELD OH 45502 CLARK (937) 521-3900 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.9247160 -83.8121950 0   23 39 39023 44220 Dayton-Springfield-Sidney, OH Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-3sf3.vggh-imzf 360355 648747 2019-05-29 2018-12-31 24           24               24
1008 1008 NEW ENGLAND BAPTIST HOSPITAL 125 PARKER HILL AVENUE BOSTON MA 2120 SUFFOLK (617) 754-5800 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.3300980 -71.1065660 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-t8hc.ugzb~bfsj 220088 645719 2019-03-27 2018-09-30 88 10         98               98
1011 1011 SHRINERS' HOSPITAL FOR CHILDREN - BOSTON, THE 51 BLOSSOM STREET BOSTON MA 2114 SUFFOLK (617) 722-3000 Childrens Proprietary FALSE 42.3630790 -71.0669040 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-pfzw.md7z-rufe 223304 652751 2019-05-30 2018-12-31                              
1014 1014 FRANCISCAN CHILDREN'S HOSPITAL & REHAB CENTER 30 WARREN STREET BRIGHTON MA 2135 SUFFOLK (617) 254-3800 Childrens Voluntary non-profit - Private FALSE 42.3497560 -71.1444470 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-eupv.vp85.xfse 223300 645912 2019-03-06 2018-09-30 112           112               112
1033 1033 MERCY HEALTH - CLERMONT HOSPITAL 3000 HOSPITAL DRIVE BATAVIA OH 45103 CLERMONT (513) 732-8590 Acute Care Hospitals Voluntary non-profit - Church FALSE 39.0783090 -84.1449860 0   25 39 39025 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Clermont County https://data.medicare.gov/resource/xubh-q36u/row-xva7-c5j9.zf8c 360236 648460 2019-05-21 2018-12-31 131 16         147               147
1055 1055 SUMMIT MEDICAL CENTER 6350 E 2ND STREET CASPER WY 82609 NATRONA (307) 232-6600 Acute Care Hospitals Physician FALSE 42.8408460 -106.2317960 0   25 56 56025 16220   Central Natrona County https://data.medicare.gov/resource/xubh-q36u/row-8pwp.t3su_b96w 530034 645740 2019-03-04 2017-12-31                              
1083 1083 ADCARE HOSPITAL OF WORCESTER INC 107 LINCOLN STREET WORCESTER MA 1605 WORCESTER (508) 799-9000 Acute Care Hospitals Proprietary FALSE 42.2761820 -71.7955760 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-rnsb.iihy_fs75 220062 645423 2019-03-01 2018-09-30 114           114               114
1097 1097 J D MCCARTY CENTER FOR CHILDREN 2002 EAST ROBINSON NORMAN OK 73071 CLEVELAND (405) 307-2800 Childrens Government - State FALSE 35.2327430 -97.4100160 0   27 40 40027 36420 Oklahoma City-Shawnee, OK Central Cleveland County https://data.medicare.gov/resource/xubh-q36u/row-whuu_e32b-w4sk 373300 655813 2019-10-07 2019-06-30                              
1110 1110 FILLMORE COMMUNITY HOSPITAL 674 SOUTH HIGHWAY 99 FILLMORE UT 84631 MILLARD (435) 743-5591 Critical Access Hospitals Voluntary non-profit - Private FALSE 38.9541610 -112.3394550 0   27 49 49027         https://data.medicare.gov/resource/xubh-q36u/row-qrf9_kxm9-tj3a 461301 648497 2019-05-22 2018-12-31 19           19               19
1129 1129 GOOD SAMARITAN HOSPITAL 901 OLIVE DRIVE BAKERSFIELD CA 93308 KERN (661) 399-4461 Acute Care Hospitals Proprietary FALSE 35.4122580 -119.0394980 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-zy4z.wua9.kcip 50257 651798 2019-07-02 2018-12-31 39 4         43 21             64
1146 1146 THE HEALTHCENTER 320 SUNNYVIEW LANE KALISPELL MT 59901 FLATHEAD (406) 756-4720 Acute Care Hospitals Proprietary FALSE 48.2162080 -114.3240470 0   29 30 30029 28060   Central Flathead County https://data.medicare.gov/resource/xubh-q36u/row-q8tk.6pjn~75zu 270087 653252 2019-08-26 2019-03-31 17           17   10           27
1181 1181 TEXAS CENTER FOR INFECTIOUS DISEASE 2303 SE MILITARY DR P O BOX 23340 SAN ANTONIO TX 78223 BEXAR (210) 534-8857 Acute Care Hospitals Government - State FALSE 29.3519300 -98.4583770 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-suha~2mc2-p7yc                                      
1191 1191 NH Oak Harbor 3475 North Saratoga Street Oak Harbor WA 98277 ISLAND (360) 257-9500 Acute Care - Department of Defense Department of Defense FALSE 48.3368750 -122.6801420 0   29 53 53029 36020 Seattle-Tacoma, WA Central Island County https://data.medicare.gov/resource/xubh-q36u/row-9p9c~5ra9_8krv                                      
1221 1221 LARABIDA CHILDRENS HOSPITAL I E 65TH ST AT LAKE MICHIGAN CHICAGO IL 60649 COOK (773) 363-6700 Childrens Voluntary non-profit - Private FALSE 41.7768110 -87.6015927 1 GEOMETRIC_CENTER 31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-cnjg.zfnx-s5dn 143301 659950 2019-11-25 2019-06-30 49           49               49
1223 1223 SHRINERS HOSPITAL FOR CHILDREN 2211 NORTH OAK PARK AVE CHICAGO IL 60707 COOK (773) 622-5400 Childrens Voluntary non-profit - Private FALSE 41.9167660 -87.7949900 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-4p3m.ksch.3kbj 143302 652647 2019-05-30 2018-12-31                              
1303 1303 MCLEOD MEDICAL CENTER - DARLINGTON 701 CASHUA FERRY ROAD DARLINGTON SC 29540 DARLINGTON (843) 777-1100 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.3129880 -79.8382530 0   31 45 45031 22500   Outlying Darlington County https://data.medicare.gov/resource/xubh-q36u/row-6zdq_e43i.3ag8 420057 645359 2019-03-01 2018-09-30 36           36 23             59
1309 1309 HOSPITAL UPR, DR FEDERICO TRILLA CARR 3 KM 8 3 AVE 65TH INFANTERIA BOX 6021 CAROLINA PR 984 CAROLINA (787) 757-1800 Acute Care Hospitals Proprietary FALSE 18.3808638 -65.9632825 1 RANGE_INTERPOLATED 31 72 72031 41980 San Juan-Carolina, PR Central Carolina Municipio https://data.medicare.gov/resource/xubh-q36u/row-xbn3-25u3~b8g7 400112 660876 2019-11-26 2019-06-30 210 8         233               233
1325 1325 THE SPINE HOSPITAL OF LOUISIANA 10105 PARK ROW CIRCLE, SUITE 250 BATON ROUGE LA 70810 E. BATON ROUGE (225) 763-9900 Acute Care Hospitals Voluntary non-profit - Private FALSE 30.3803040 -91.0944530 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-tmb2.vpzg_7bvf 190266 649247 2019-05-30 2018-12-31 23           23               23
1326 1326 SURGICAL SPECIALTY CENTER OF BATON ROUGE 8080 BLUEBONNET BLVD BATON ROUGE LA 70810 E. BATON ROUGE (225) 408-8080 Acute Care Hospitals Physician FALSE 30.3765650 -91.0993330 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-vta2_xzya~pwww 190251 648928 2019-05-31 2018-12-31 16           16               16
1340 1340 BAPTIST MEMORIAL HOSPITAL DESOTO 7601 SOUTHCREST PARKWAY SOUTHAVEN MS 38671 DE SOTO (662) 772-4000 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.9683480 -89.9955350 0   33 28 28033 32820 Memphis-Forrest City, TN-MS-AR Central DeSoto County https://data.medicare.gov/resource/xubh-q36u/row-p6mp~9htx.zd8z 250141 644306 2019-02-27 2018-09-30 273   36       309   30           339
1349 1349 GALION COMMUNITY HOSPITAL 269 PORTLAND WAY SOUTH GALION OH 44833 CRAWFORD (419) 468-4841 Critical Access Hospitals Voluntary non-profit - Church FALSE 40.7311430 -82.8032960 0   33 39 39033 15340 Mansfield-Ashland-Bucyrus, OH Central Crawford County https://data.medicare.gov/resource/xubh-q36u/row-5krw_yxr7-22n8 361325 661619 2019-12-03 2019-06-30 22 3         25   10           35
1385 1385 WELLSTAR SYLVAN GROVE HOSPITAL 1050 MCDONOUGH ROAD JACKSON GA 30233 BUTTS (770) 775-7861 Critical Access Hospitals Government - Hospital District or Authority FALSE 33.3030850 -83.9778230 0   35 13 13035 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Butts County https://data.medicare.gov/resource/xubh-q36u/row-uazj.s3pp-ngue 111319 660799 2019-11-27 2019-06-30 25           25               25
1393 1393 MIDMICHIGAN MEDICAL CENTER-CLARE 703 N MCEWAN ST CLARE MI 48617 CLARE (989) 802-5000 Acute Care Hospitals Voluntary non-profit - Other FALSE 43.8207240 -84.7683490 0   35 26 26035         https://data.medicare.gov/resource/xubh-q36u/row-x95c-xq2z-tjc4 230180 661013 2019-11-27 2019-06-30 49           49               49
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
1409 1409 CLEVELAND CLINIC CHILDREN'S HOSPITAL FOR REHAB 2801 MARTIN LUTHER KING, JR DRIVE CLEVELAND OH 44104 CUYAHOGA (216) 721-6400 Childrens Voluntary non-profit - Private FALSE 41.4827760 -81.6092520 0   35 39 39035 17460 Cleveland-Akron-Canton, OH Central Cuyahoga County https://data.medicare.gov/resource/xubh-q36u/row-hdmr_eyjs_ypqz 363304 651134 2019-05-29 2018-12-31                              
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
1422 1422 EUCLID HOSPITAL 18901 LAKE SHORE BOULEVARD EUCLID OH 44119 CUYAHOGA (216) 531-9000 Acute Care Hospitals Voluntary non-profit - Other FALSE 41.5967340 -81.5474210 0   35 39 39035 17460 Cleveland-Akron-Canton, OH Central Cuyahoga County https://data.medicare.gov/resource/xubh-q36u/row-cmpf.r9xq-srhj 360082 648734 2019-05-21 2018-12-31 98 12         110 15     40       165
1423 1423 PARMA COMMUNITY GENERAL HOSPITAL 7007 POWERS BOULEVARD PARMA OH 44129 CUYAHOGA (440) 743-3000 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.3827620 -81.7314760 0   35 39 39035 17460 Cleveland-Akron-Canton, OH Central Cuyahoga County https://data.medicare.gov/resource/xubh-q36u/row-taje-fzub~tnzc 360041 648296 2019-05-21 2018-12-31 200 16 14       230 14 29           273
1433 1433 THE ORTHOPEDIC SPECIALTY HOSPITAL 5848 SOUTH 300 EAST MURRAY UT 84107 SALT LAKE (801) 314-4100 Acute Care Hospitals Voluntary non-profit - Private FALSE 40.6441568 -111.8834631 1 ROOFTOP 35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-q8pf_69d4-hzq3 460049 648660 2019-05-22 2018-12-31 40           40               40
1441 1441 SHRINERS HOSPITALS FOR CHILDREN - SALT LAKE CITY 1275 EAST FAIRFAX ROAD SALT LAKE CITY UT 84103 SALT LAKE (801) 536-3500 Childrens Voluntary non-profit - Private FALSE 40.7767640 -111.8511170 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-z268_bq8t.wgx8 463302 651875 2018-05-31 2017-12-31                              
1444 1444 NH Bremerton 1 Boone Road Bremerton Bremerton WA 98312 KITSAP (360) 475-4232 Acute Care - Department of Defense Department of Defense FALSE 47.5935710 -122.6929400 0   35 53 53035 14740 Seattle-Tacoma, WA Central Kitsap County https://data.medicare.gov/resource/xubh-q36u/row-u4p2.49ji-8aqj                                      

Next page

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