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 city

✎ 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
121 121 ABBEVILLE AREA MEDICAL CENTER 420 THOMSON CIRCLE ABBEVILLE SC 29620 ABBEVILLE (864) 366-5011 Critical Access Hospitals Government - Local TRUE 34.1561250 -82.3801740 0   1 45 45001 24940 Greenville-Spartanburg-Anderson, SC Outlying Abbeville County https://data.medicare.gov/resource/xubh-q36u/row-v8xu.2huz_ubxe 421301 645182 2019-02-25 2018-09-30 19 6         25               25
3472 3472 ABBEVILLE GENERAL HOSPITAL 118 N HOSPITAL DR ABBEVILLE LA 70510 VERMILION (337) 893-5466 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.9732500 -92.1069860 0   113 22 22113 29180 Lafayette-Opelousas-Morgan City, LA Outlying Vermilion Parish https://data.medicare.gov/resource/xubh-q36u/row-b6fd-eygy.vwqx 190034 649244 2019-05-31 2018-12-31 38 6         44 16             60
650 650 AVERA ST LUKES 305 S STATE ST POST OFFICE BOX 4450 ABERDEEN SD 57401 BROWN (605) 622-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 45.4617950 -98.4793500 0   13 46 46013 10100   Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-pruy~fuxf-c6av 430014 662254 2019-11-27 2019-06-30 43 6         49 10     81 56     196
651 651 SANFORD ABERDEEN MEDICAL CENTER 2905 3RD AVE SE ABERDEEN SD 57402 BROWN (605) 626-4200 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.4621400 -98.4472370 0   13 46 46013 10100   Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-y434_ii38-mfbk 430097 648656 2019-05-23 2018-12-31 48           48               48
1115 1115 GRAYS HARBOR COMMUNITY HOSPITAL 915 ANDERSON DRIVE ABERDEEN WA 98520 GRAYS HARBOR (360) 532-8330 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.9796000 -123.8463870 0   27 53 53027 10140   Central Grays Harbor County https://data.medicare.gov/resource/xubh-q36u/row-qmdm-j995~rvv5 500031 659383 2019-06-03 2018-12-31 41 8         49               49
3045 3045 MONROE REGIONAL HOSPITAL 400 SOUTH CHESTNUT STREET ABERDEEN MS 39730 MONROE (662) 369-2455 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.8199420 -88.5410590 0   95 28 28095         https://data.medicare.gov/resource/xubh-q36u/row-fnzk-qpms.jxx9 251302 654098 2019-09-03 2018-12-31 25           25 10             35
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
4659 4659 ABILENE REGIONAL MEDICAL CENTER 6250 HWY 83/84 ABILENE TX 79606 TAYLOR (325) 428-1000 Acute Care Hospitals Proprietary TRUE 32.3740060 -99.7425950 0   441 48 48441 10180   Central Taylor County https://data.medicare.gov/resource/xubh-q36u/row-rque_a7mi~an5d 450558 657529 2019-04-12 2018-08-31 160 20         196               196
4660 4660 HENDRICK MEDICAL CENTER 1900 PINE ABILENE TX 79601 TAYLOR (325) 670-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.4715530 -99.7311800 0   441 48 48441 10180   Central Taylor County https://data.medicare.gov/resource/xubh-q36u/row-ewhh-9kze-g39u 450229 662437 2019-01-28 2018-08-31 220 46 44     25 335   31   20       386
4367 4367 JOHNSTON MEMORIAL HOSPITAL 16000 JOHNSTON MEMORIAL DRIVE ABINGDON VA 24211 WASHINGTON (276) 258-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.7206700 -81.9085600 0   191 51 51191 28700 Johnson City-Kingsport-Bristol, TN-VA Outlying Washington County https://data.medicare.gov/resource/xubh-q36u/row-ysbq~qbac~97nx 490053 660721 2019-11-25 2019-06-30 101 14         115               115
2968 2968 ABINGTON MEMORIAL HOSPITAL 1200 OLD YORK ROAD ABINGTON PA 19001 MONTGOMERY (215) 481-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.1189450 -75.1193820 0   91 42 42091 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-yqgf~xkux~zsam 390231 661639 2019-12-03 2019-06-30 503 33     22   592 23 23           638
838 838 CHOCTAW REGIONAL MEDICAL CENTER 8613 MS HWY 12 ACKERMAN MS 39735 CHOCTAW (662) 285-4400 Critical Access Hospitals Government - Local TRUE 33.3184650 -89.1823040 0   19 28 28019         https://data.medicare.gov/resource/xubh-q36u/row-9nt3~77et_z9mg 251334 643914 2019-03-01 2018-09-30 15           15         73     88
25 25 ESSENTIA HEALTH ADA 201 9TH STREET WEST ADA MN 56510 NORMAN (218) 784-5000 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.2960910 -96.5301900 0   107 27 27107         https://data.medicare.gov/resource/xubh-q36u/row-z63y_de5x~9s9u 241313 660607 2019-11-26 2019-06-30 14           14               14
3692 3692 MERCY HOSPITAL ADA 430 NORTH MONTE VISTA ADA OK 74820 PONTOTOC (580) 332-2323 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7780680 -96.6348130 0   123 40 40123 10220   Central Pontotoc County https://data.medicare.gov/resource/xubh-q36u/row-itqt-xmxc.8n32 370020 659524 2019-11-25 2019-06-30 96 12         108 20 20           148
3693 3693 CHICKASAW NATION MEDICAL CENTER 1921 STONECIPHER BLVD ADA OK 74820 PONTOTOC (580) 436-3980 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.7370500 -96.6470750 0   123 40 40123 10220   Central Pontotoc County https://data.medicare.gov/resource/xubh-q36u/row-ae6z_dxfe.np6w 370180 651346 2019-07-02 2018-09-30 72           72               72
3500 3500 METHODIST HOSPITAL FOR SURGERY 17101 DALLAS PARKWAY ADDISON TX 75001 DALLAS (469) 248-3900 Acute Care Hospitals Proprietary TRUE 32.9851310 -96.8288180 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-ge4u~ywgg~r953 670073 647316 2019-04-29 2018-11-30 28 4         32               32
2568 2568 SOUTHWELL MEDICAL, A CAMPUS OF TRMC 260 MJ TAYLOR ROAD ADEL GA 31620 COOK (229) 896-8077 Acute Care Hospitals Proprietary TRUE 31.1091810 -83.4263720 0   75 13 13075         https://data.medicare.gov/resource/xubh-q36u/row-9kgg_7cj7~n9m2 110101 660504 2019-12-03 2019-06-30 33           33 12     95       140
2958 2958 PROMEDICA BIXBY HOSPITAL 818 RIVERSIDE AVENUE ADRIAN MI 49221 LENAWEE (517) 265-0900 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9127130 -84.0495550 0   91 26 26091 10300 Detroit-Warren-Ann Arbor, MI Central Lenawee County https://data.medicare.gov/resource/xubh-q36u/row-j6wy-ry6d_k6pn 230005 659288 2019-05-29 2018-12-31 79 9         88               88
988 988 STAR VALLEY MEDICAL CENTER 901 ADAMS STREET AFTON WY 83110 LINCOLN (307) 885-5800 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.7172500 -110.9314610 0   23 56 56023         https://data.medicare.gov/resource/xubh-q36u/row-763v_wyb3.smi9 531313 658921 2019-11-15 2019-06-30 22           22           24   46
334 334 HOSP COMUNITARIO BUEN SAMARITANO CARR.2 KM.1.4 AVE. SEVERIANO CUEVAS #18 AGUADILLA PR 603 AGUADILLA (787) 658-0000 Acute Care Hospitals Voluntary non-profit - Other TRUE 18.4257212 -67.1508997 1 GEOMETRIC_CENTER 5 72 72005 10380   Central Aguadilla Municipio https://data.medicare.gov/resource/xubh-q36u/row-8tsm_vegi.8z9v 400079 649495 2019-06-03 2018-12-31 116 8         124               124
2964 2964 VIDANT ROANOKE CHOWAN HOSPITAL 500 S ACADEMY ST AHOSKIE NC 27910 HERTFORD (252) 209-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.2851490 -76.9939240 0   91 37 37091         https://data.medicare.gov/resource/xubh-q36u/row-n5pq~6e8d.jjva 340099 643925 2019-02-28 2018-09-30 60 10         70 28             98
475 475 MENNONITE GENERAL HOSPITAL INC CALLE JOSE C VASQUEZ BO. CAONILLAS AIBONITO PR 705 AIBONITO (787) 535-1001 Acute Care Hospitals Voluntary non-profit - Private TRUE 18.1437170 -66.2628471 1 GEOMETRIC_CENTER 9 72 72009 41980 San Juan-Carolina, PR Central Aibonito Municipio https://data.medicare.gov/resource/xubh-q36u/row-bj3m-c3jd~qtix 400018 658954 2019-11-05 2019-03-31 144 6         150               150
155 155 PALI MOMI MEDICAL CENTER 98-1079 MOANALUA ROAD AIEA HI 96701 HONOLULU (808) 486-6000 Acute Care Hospitals Proprietary TRUE 21.3839880 -157.9376750 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-gvhj-d3a6.ypz3 120026 659776 2019-11-26 2019-06-30 110 8         118               118
242 242 AIKEN REGIONAL MEDICAL CENTER 302 UNIVERSITY PARKWAY AIKEN SC 29801 AIKEN (803) 641-5900 Acute Care Hospitals Proprietary TRUE 33.5698900 -81.7650710 0   3 45 45003 12260   Central Aiken County https://data.medicare.gov/resource/xubh-q36u/row-2jsk_ph6i-gvkj 420082 648759 2019-05-29 2018-12-31 169 35         204 48 14           266
762 762 BROWN COUNTY HOSPITAL 945 EAST ZERO ST AINSWORTH NE 69210 BROWN (402) 387-2800 Critical Access Hospitals Government - Local TRUE 42.5449340 -99.8500450 0   17 31 31017         https://data.medicare.gov/resource/xubh-q36u/row-7ya9_7bjz.6vjk 281325 659704 2019-11-18 2019-06-30 23           23               23
98 98 RIVERWOOD HEALTHCARE CENTER 200 BUNKER HILL DRIVE AITKIN MN 56431 AITKIN (218) 927-5501 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.5292020 -93.6968080 0   1 27 27001         https://data.medicare.gov/resource/xubh-q36u/row-ybgp~gnb5~d4ww 241305 655456 2019-10-08 2018-09-30 21 4         25               25
4064 4064 AKRON GENERAL MEDICAL CENTER 1 AKRON GENERAL AVENUE AKRON OH 44307 SUMMIT (330) 344-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0778590 -81.5327870 0   153 39 39153 10420 Cleveland-Akron-Canton, OH Central Summit County https://data.medicare.gov/resource/xubh-q36u/row-fwyk~yqdc~my3b 360027 660664 2019-11-25 2018-12-31 315 34 34       383 53             436
4066 4066 AKRON CHILDREN'S HOSPITAL 1 PERKINS SQUARE AKRON OH 44308 SUMMIT (330) 543-1000 Childrens Voluntary non-profit - Private FALSE 41.0784210 -81.5267890 0   153 39 39153 10420 Cleveland-Akron-Canton, OH Central Summit County https://data.medicare.gov/resource/xubh-q36u/row-g6bs.ki8j-vwqu 363303 649334 2019-05-31 2018-12-31 303 23   12     402               402
4067 4067 SUMMA HEALTH SYSTEM 525 EAST MARKET STREET AKRON OH 44309 SUMMIT (330) 375-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0783350 -81.5000690 0   153 39 39153 10420 Cleveland-Akron-Canton, OH Central Summit County https://data.medicare.gov/resource/xubh-q36u/row-b25c.gku4-s7xk 360020 648964 2019-05-30 2018-12-31 494 64 26       584 69             653
4068 4068 CRYSTAL CLINIC ORTHOPAEDIC CENTER 444 NORTH MAIN STREET AKRON OH 44310 SUMMIT (330) 670-4118 Acute Care Hospitals Proprietary FALSE 41.0970700 -81.5121550 0   153 39 39153 10420 Cleveland-Akron-Canton, OH Central Summit County https://data.medicare.gov/resource/xubh-q36u/row-3zqn-by7u.cdf4 360351 648746 2019-05-29 2018-12-31 59           59               59
3544 3544 SHELBY BAPTIST MEDICAL CENTER 1000 FIRST STREET NORTH ALABASTER AL 35007 SHELBY (205) 620-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.2536790 -86.8142610 0   117 1 1117 13820 Birmingham-Hoover-Talladega, AL Central Shelby County https://data.medicare.gov/resource/xubh-q36u/row-j68e.5ee5_e79h 10016 651149 2019-05-31 2018-12-31 180 32         212 40             252
49 49 ALAMEDA HOSPITAL 2070 CLINTON AVENUE ALAMEDA CA 94501 ALAMEDA (510) 522-3700 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7632300 -122.2535410 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-aten_zvra_dnju 50211 662328 2018-12-03 2018-06-30 29   5       34       181       215
1400 1400 GERALD CHAMPION REGIONAL MEDICAL CENTER 2669 NORTH SCENIC DRIVE ALAMOGORDO NM 88310 OTERO (575) 443-6100 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.9268620 -105.9339170 0   35 35 35035 10460   Central Otero County https://data.medicare.gov/resource/xubh-q36u/row-jeb6-3eqs_s323 320004 659992 2019-12-03 2019-06-30 40 10         50 36 12           98
140 140 SAN LUIS VALLEY HEALTH 106 BLANCA AVE ALAMOSA CO 81101 ALAMOSA (719) 589-2511 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.4723600 -105.8837120 0   3 8 8003         https://data.medicare.gov/resource/xubh-q36u/row-bztx~k7ma~ri7p 60008 661701 2019-12-03 2019-06-30 43 6         49               49
112 112 ALBANY MEMORIAL HOSPITAL 600 NORTHERN BOULEVARD ALBANY NY 12204 ALBANY (518) 471-3490 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6746850 -73.7488610 0   1 36 36001 10580 Albany-Schenectady, NY Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-fbeu-trch-uemx 330003 661359 2019-11-27 2019-06-30 57 16         73               73
113 113 ST PETER'S HOSPITAL 315 SOUTH MANNING BOULEVARD ALBANY NY 12208 ALBANY (518) 525-1550 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6601760 -73.8023820 0   1 36 36001 10580 Albany-Schenectady, NY Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-sq59.k3z9-zynf 330057 662055 2019-12-18 2019-06-30 445   22     15 482               482
114 114 ALBANY MEDICAL CENTER HOSPITAL 43 NEW SCOTLAND AVENUE, MAIL CODE 34 ALBANY NY 12208 ALBANY (518) 262-2400 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6532540 -73.7738600 0   1 36 36001 10580 Albany-Schenectady, NY Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-sggw.e236~c5a3 330013 649473 2019-05-29 2018-12-31 585 65 17     60 747 26 20           793
1705 1705 SAMARITAN ALBANY GENERAL HOSPITAL 1046 6TH AVENUE SW ALBANY OR 97321 LINN (541) 812-4000 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.6320670 -123.1167710 0   43 41 41043 10540 Portland-Vancouver-Salem, OR-WA Central Linn County https://data.medicare.gov/resource/xubh-q36u/row-3f45~84ie_23rn 380022 650903 2019-05-28 2018-12-31 56 11         67               67
1952 1952 THE MEDICAL CENTER AT ALBANY 723 BURKESVILLE ROAD ALBANY KY 42602 CLINTON (606) 387-6421 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.6983350 -85.1465540 0   53 21 21053         https://data.medicare.gov/resource/xubh-q36u/row-py7x~3tmy.cdg5 180106 653670 2019-09-03 2019-03-31 38           38               38
2579 2579 MOSAIC MEDICAL CENTER ALBANY 705 N COLLEGE STREET ALBANY MO 64402 GENTRY (660) 726-3941 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.2521240 -94.3254760 0   75 29 29075         https://data.medicare.gov/resource/xubh-q36u/row-67e7_s6bv.9rwi 261328 662128 2019-12-04 2019-06-30 25           25               25
3033 3033 PHOEBE PUTNEY MEMORIAL HOSPITAL 417 THIRD AVENUE ALBANY GA 31703 DOUGHERTY (229) 312-4068 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.5902290 -84.1562670 0   95 13 13095 10500   Central Dougherty County https://data.medicare.gov/resource/xubh-q36u/row-97aw-8gyu-wg2w 110007 658211 2019-07-05 2018-07-31 332 50       27 409 15 25           461
4209 4209 ATRIUM HEALTH STANLY 301 YADKIN ST ALBEMARLE NC 28001 STANLY (704) 984-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.3626060 -80.1943980 0   167 37 37167 10620 Charlotte-Concord, NC-SC Central Stanly County https://data.medicare.gov/resource/xubh-q36u/row-fnau.z32z~nwib 340119 650344 2019-05-30 2018-12-31 87 10         97 12             109
1784 1784 MAYO CLINIC HEALTH SYSTEM - ALBERT LEA AND AUSTIN 404 WEST FOUNTAIN STREET ALBERT LEA MN 56007 FREEBORN (507) 377-6452 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.6515580 -93.3724690 0   47 27 27047 10660   Central Freeborn County https://data.medicare.gov/resource/xubh-q36u/row-mm4b.mgcr_k9aq 240043 649759 2019-05-30 2018-12-31 141 18         159           1   161
3854 3854 MONROE COUNTY HOSPITAL 6580 165TH STREET ALBIA IA 52531 MONROE (641) 932-2134 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.0448380 -92.7964750 0   135 19 19135         https://data.medicare.gov/resource/xubh-q36u/row-wtqj-qihw~wgcb 161342 660974 2019-12-02 2019-06-30 25           25               25
515 515 BOONE COUNTY HEALTH CENTER P O BOX 151, 723 WEST FAIRVIEW ST ALBION NE 68620 BOONE (402) 395-2191 Critical Access Hospitals Government - Local TRUE 41.6921113 -98.0002224 1 ROOFTOP 11 31 31011         https://data.medicare.gov/resource/xubh-q36u/row-3j5p_6aw6-77k2 281334 645125 2019-02-28 2018-09-30 25           25               25
107 107 LOVELACE WOMEN'S HOSPITAL 4701 MONTGOMERY BOULEVARD NE ALBUQUERQUE NM 87109 BERNALILLO (505) 727-7805 Acute Care Hospitals Government - State TRUE 35.1310050 -106.5910370 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-fycu~sc7u.8im7 320017 655223 2019-10-17 2019-04-30 112 8       42 162               162
108 108 LOVELACE MEDICAL CENTER 601 DR MARTIN LUTHER KING JR AVE NE ALBUQUERQUE NM 87102 BERNALILLO (505) 727-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0856220 -106.6397650 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-kci4.56nf~rfu7 320009 652759 2019-07-29 2019-02-28 245 48         293               293
109 109 LOVELACE WESTSIDE HOSPITAL 10501 GOLF COURSE ROAD NW ALBUQUERQUE NM 87114 BERNALILLO (505) 727-2001 Acute Care Hospitals Proprietary TRUE 35.2075080 -106.6759740 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-t6an-qbnd.nby8 320074 651222 2019-06-28 2019-01-31 62 8         70               70
110 110 UNM HOSPITAL 2211 LOMAS BOULEVARD NE ALBUQUERQUE NM 87106 BERNALILLO (505) 272-2111 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.0874830 -106.6181480 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-ntcm.qi4a~h9yr 320001 661059 2019-11-26 2019-06-30 345           473 82             555
111 111 PRESBYTERIAN HOSPITAL 1100 CENTRAL AVENUE SE ALBUQUERQUE NM 87106 BERNALILLO (505) 724-8386 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0822950 -106.6345300 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-6ve3~533u~8w78 320021 652598 2019-08-14 2018-12-31 538 47 21       671 45         10   726
3804 3804 GENESIS MEDICAL CENTER, ALEDO 409 NW 9TH AVENUE ALEDO IL 61231 MERCER (309) 582-9100 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.2050800 -90.7584850 0   131 17 17131 19340 Davenport-Moline, IA-IL Outlying Mercer County https://data.medicare.gov/resource/xubh-q36u/row-8mai.ym2c.wqaj 141304 659493 2019-11-19 2019-06-30 22           22               22
3671 3671 RUSSELL MEDICAL CENTER 3316 HIGHWAY 280 ALEXANDER CITY AL 35010 TALLAPOOSA (256) 329-7100 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.9310300 -85.9683940 0   123 1 1123         https://data.medicare.gov/resource/xubh-q36u/row-7ugw.v846~xcyn 10065 651308 2019-05-30 2018-12-31 28 6         34               34
1650 1650 ALOMERE HEALTH 111 17TH AVENUE EAST ALEXANDRIA MN 56308 DOUGLAS (320) 762-1511 Acute Care Hospitals Government - Local TRUE 45.8726690 -95.3763800 0   41 27 27041 10820   Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-psb9.f8hy_pu25 240030 649757 2019-05-30 2018-12-31 91 8         99               99
2168 2168 INOVA MOUNT VERNON HOSPITAL 2501 PARKERS LANE ALEXANDRIA VA 22306 FAIRFAX (703) 664-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7401840 -77.0747900 0   59 51 51059 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Fairfax County https://data.medicare.gov/resource/xubh-q36u/row-52ki_civp_r8hf 490122 650416 2019-06-10 2018-12-31 120 20         140 30 67           237
2645 2645 RAPIDES REGIONAL MEDICAL CENTER 211 4TH STREET ALEXANDRIA LA 71301 RAPIDES (318) 769-3000 Acute Care Hospitals Proprietary TRUE 31.3150210 -92.4504810 0   79 22 22079 10780   Central Rapides Parish https://data.medicare.gov/resource/xubh-q36u/row-73ux~awri.sd3h 190026 649243 2019-05-31 2018-12-31 322         29 357               357
2646 2646 CHRISTUS ST FRANCES CABRINI HOSPITAL 3330 MASONIC DRIVE ALEXANDRIA LA 71301 RAPIDES (318) 487-1122 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.2824010 -92.4608480 0   79 22 22079 10780   Central Rapides Parish https://data.medicare.gov/resource/xubh-q36u/row-tc25-kjhe-hnmq 190019 659683 2019-11-26 2019-06-30 230 26       20 276   25           301
2647 2647 CENTRAL LOUISIANA SURGICAL HOSPITAL 651 NORTH BOLTON AVE ALEXANDRIA LA 71301 RAPIDES (318) 449-6400 Acute Care Hospitals Physician FALSE 31.3152360 -92.4674780 0   79 22 22079 10780   Central Rapides Parish https://data.medicare.gov/resource/xubh-q36u/row-m9k4.j7wi.48hz 190298 655908 2019-10-31 2019-05-31 24           24               24
4732 4732 INOVA ALEXANDRIA HOSPITAL 4320 SEMINARY RD ALEXANDRIA VA 22304 ALEXANDRIA CITY (703) 504-3167 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8241280 -77.1044370 0   510 51 51510 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Alexandria city https://data.medicare.gov/resource/xubh-q36u/row-fzej-vy8h-2bar 490040 650394 2019-06-12 2018-12-31 278 40         334               334
1746 1746 RIVER HOSPITAL CLINICS 4 FULLER STREET ALEXANDRIA BAY NY 13607 JEFFERSON (315) 482-2511 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3372170 -75.9200220 0   45 36 36045 48060   Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-7zvs~rszm-n4ux 331309 650324 2019-05-31 2018-12-31 24           24               24
3369 3369 KOSSUTH REGIONAL HEALTH CENTER 1515 SOUTH PHILLIPS STREET ALGONA IA 50511 KOSSUTH (515) 295-2451 Critical Access Hospitals Government - Local TRUE 43.0568220 -94.2271240 0   109 19 19109         https://data.medicare.gov/resource/xubh-q36u/row-xb5y.qfar-cu3w 161353 660979 2019-11-29 2019-06-30 24           24           1   25
1518 1518 ALHAMBRA HOSPITAL MEDICAL CENTER 100 S RAYMOND AVE ALHAMBRA CA 91801 LOS ANGELES (626) 570-1606 Acute Care Hospitals Proprietary FALSE 34.0901560 -118.1450170 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-75jx-8uav_n2er 50281 660918 2019-12-02 2019-06-30 88 13         101   17   26       144
4519 4519 CHRISTUS SPOHN HOSPITAL ALICE 2500 E MAIN STREET ALICE TX 78332 JIM WELLS (361) 661-8016 Acute Care Hospitals Voluntary non-profit - Private TRUE 27.7655080 -98.0437130 0   249 48 48249 10860 Corpus Christi-Kingsville-Alice, TX Central Jim Wells County https://data.medicare.gov/resource/xubh-q36u/row-b4k9_mqdr~hpfd 450828 660474 2019-11-26 2019-06-30 64 8         72               72
290 290 ALLEGAN GENERAL HOSPITAL 555 LINN STREET ALLEGAN MI 49010 ALLEGAN (269) 686-4101 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.5202590 -85.8569390 0   5 26 26005 26090 Grand Rapids-Wyoming-Muskegon, MI Central Allegan County https://data.medicare.gov/resource/xubh-q36u/row-9kac~4r3i~rk7m 231328 649266 2019-05-30 2018-12-31 25           25               25
2816 2816 TEXAS HEALTH PRESBYTERIAN HOSPITAL ALLEN 1105 CENTRAL EXPRESSWAY NORTH ALLEN TX 75013 COLLIN (972) 747-6197 Acute Care Hospitals Government - Federal TRUE 33.1154330 -96.6715040 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-v7tw~68xq-fbxm 450840 648765 2019-05-31 2018-12-31 30 8         44               44
2821 2821 OUR CHILDRENS HOUSE 8 PRESTIGE CIRCLE 101 ALLEN TX 75002 COLLIN (214) 828-4747 Childrens Voluntary non-profit - Church FALSE 33.0920180 -96.6727380 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-4cvs-dhym.psr7 453308 649972 2019-05-31 2018-12-31 39           39               39
2623 2623 LEHIGH VALLEY HOSPITAL 1200 SOUTH CEDAR CREST BOULEVARD ALLENTOWN PA 18105 LEHIGH (610) 402-2273 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5667720 -75.5186720 0   77 42 42077 10900 New York-Newark, NY-NJ-CT-PA Central Lehigh County https://data.medicare.gov/resource/xubh-q36u/row-5fzf-faw4~6h9r 390133 659871 2019-11-26 2019-06-30 830 86 14 18 11 42 1023 52 62   52   10   1199
2624 2624 SURGICAL SPECIALTY CENTER AT COORDINATED HEALTH 1503 CEDAR CREST BOULEVARD ALLENTOWN PA 18104 LEHIGH (610) 871-9110 Acute Care Hospitals Physician FALSE 40.6121900 -75.5327500 0   77 42 42077 10900 New York-Newark, NY-NJ-CT-PA Central Lehigh County https://data.medicare.gov/resource/xubh-q36u/row-ecs5-8dzv.54i7 390321 650522 2019-06-03 2018-12-31 20           20       12       32
2625 2625 SACRED HEART HOSPITAL 421 CHEW STREET ALLENTOWN PA 18102 LEHIGH (610) 776-4900 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6079870 -75.4680450 0   77 42 42077 10900 New York-Newark, NY-NJ-CT-PA Central Lehigh County https://data.medicare.gov/resource/xubh-q36u/row-fni9_xrev~f329 390197 662579 2019-12-02 2019-06-30 117 12         129 16     22       167
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
4047 4047 ALLIANCE COMMUNITY HOSPITAL 200 EAST STATE STREET ALLIANCE OH 44601 STARK (330) 596-7018 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.9016790 -81.1027360 0   151 39 39151 15940 Cleveland-Akron-Canton, OH Central Stark County https://data.medicare.gov/resource/xubh-q36u/row-9pb7.6hrh_xxpz 360131 649642 2019-06-03 2018-12-31 43 12         55 12     78       145
270 270 BACON COUNTY HOSPITAL 302 SOUTH WAYNE STREET ALMA GA 31510 BACON (912) 632-8961 Critical Access Hospitals Voluntary non-profit - Other TRUE 31.5391100 -82.4596870 0   5 13 13005         https://data.medicare.gov/resource/xubh-q36u/row-fsgt~f6fy~f5qx 111327 659492 2019-11-26 2019-06-30 21 4         25       88       113
2073 2073 MIDMICHIGAN MEDICAL CENTER-GRATIOT 300 E WARWICK DR ALMA MI 48801 GRATIOT (989) 463-1101 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.3916800 -84.6622780 0   57 26 26057 10940 Mount Pleasant-Alma, MI Central Gratiot County https://data.medicare.gov/resource/xubh-q36u/row-7bpx_say8-8gij 230030 660577 2019-11-25 2019-06-30 49           49 30 18           97
2756 2756 HARLAN COUNTY HEALTH SYSTEM P O BOX 836, 717 NORTH BROWN ST ALMA NE 68920 HARLAN (308) 928-2151 Critical Access Hospitals Government - Local TRUE 40.0981797 -99.3631677 1 ROOFTOP 83 31 31083         https://data.medicare.gov/resource/xubh-q36u/row-yvs4.45jj.87ms 281300 647189 2019-04-23 2018-12-31 19           19               19
359 359 MIDMICHIGAN MEDICAL CENTER - ALPENA 1501 W CHISHOLM ST ALPENA MI 49707 ALPENA (989) 356-7390 Acute Care Hospitals Proprietary TRUE 45.0768570 -83.4506720 0   7 26 26007 10980   Central Alpena County https://data.medicare.gov/resource/xubh-q36u/row-3cst~3hfe~ssf7 230036 660579 2019-11-25 2019-06-30 119 9         128   11           139
1712 1712 BIG BEND REGIONAL MEDICAL CENTER 2600 HIGHWAY 118 NORTH ALPINE TX 79830 BREWSTER (432) 837-3447 Critical Access Hospitals Proprietary TRUE 30.3838110 -103.6721400 0   43 48 48043         https://data.medicare.gov/resource/xubh-q36u/row-snt8.6tvq~cxi3 451378 654056 2019-08-28 2018-09-30 22 3         25               25
2237 2237 PROFESSIONAL HOSPITAL GUAYNABO INC AVE LAS CUMBRES ST 199KM 1 2 ALT DE SANTA PR 969 GUAYNABO (787) 708-6560 Acute Care Hospitals Proprietary TRUE 18.3582970 -66.0726073 1 GEOMETRIC_CENTER 61 72 72061 41980 San Juan-Carolina, PR Central Guaynabo Municipio https://data.medicare.gov/resource/xubh-q36u/row-fwuh~bawf.93i3 400122 662581 2019-12-23 2019-06-30 49           49               49
3590 3590 OSF SAINT ANTHONY'S HEALTH CENTER ST ANTHONY'S WAY ALTON IL 62002 MADISON (618) 465-2571 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.9073839 -90.1718152 1 GEOMETRIC_CENTER 119 17 17119 41180 St. Louis-St. Charles-Farmington, MO-IL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-mu62-iiye-da97 140052 645329 2019-02-28 2018-09-30 68 10         78               78
3591 3591 ALTON MEMORIAL HOSPITAL ONE MEMORIAL DRIVE ALTON IL 62002 MADISON (618) 463-7300 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8995477 -90.1591567 1 ROOFTOP 119 17 17119 41180 St. Louis-St. Charles-Farmington, MO-IL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-45rg.3vzm_7irj 140002 648904 2019-05-30 2018-12-31 120 12         132 20             152
645 645 UPMC ALTOONA 620 HOWARD AVENUE ALTOONA PA 16601 BLAIR (814) 889-2011 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5211420 -78.3981840 0   13 42 42013 11020   Central Blair County https://data.medicare.gov/resource/xubh-q36u/row-wkn5_wsma_rprd 390073 661248 2019-11-27 2019-06-30 303 33 8       344               344
1450 1450 OAKLEAF SURGICAL HOSPITAL 1000 OAKLEAF WAY ALTOONA WI 54720 EAU CLAIRE (715) 831-8130 Acute Care Hospitals Physician FALSE 44.8150020 -91.4517640 0   35 55 55035 20740 Eau Claire-Menomonie, WI Central Eau Claire County https://data.medicare.gov/resource/xubh-q36u/row-4tiq~2hj5~t8xv 520196 650624 2019-05-30 2018-12-31 13           13               13
1828 1828 MODOC MEDICAL CENTER 228 W MCDOWELL AVE ALTURAS CA 96101 MODOC (530) 233-5131 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.4799490 -120.5455030 0   49 6 6049         https://data.medicare.gov/resource/xubh-q36u/row-kyq6~7b5b.wgww 51330 662175 2019-11-27 2019-06-30 16           16       71       87
2319 2319 JACKSON COUNTY MEMORIAL HOSPITAL AUTHORITY 1200 EAST PECAN ST ALTUS OK 73521 JACKSON (580) 379-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6352730 -99.3191190 0   65 40 40065 11060   Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-grzh.mrwf.u2yy 370022 660425 2019-11-27 2019-06-30 43 6         49               49
32 32 SHARE MEDICAL CENTER 800 SHARE DRIVE ALVA OK 73717 WOODS (580) 327-2800 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.7869690 -98.6700230 0   151 40 40151         https://data.medicare.gov/resource/xubh-q36u/row-gzmq-89k6~9n3d 371341 659863 2019-11-25 2019-06-30 25           25         80     105
4607 4607 NORTHWEST TEXAS HOSPITAL 1501 S COULTER ST AMARILLO TX 79106 POTTER (806) 354-1110 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.1997650 -101.9218810 0   375 48 48375 11100 Amarillo-Borger, TX Central Potter County https://data.medicare.gov/resource/xubh-q36u/row-n4qk-n2ds.jvw9 450209 649499 2019-05-28 2018-12-31 240 51         347 87 10           444
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
4609 4609 BAPTIST ST ANTHONY'S HOSPITAL 1600 WALLACE BLVD AMARILLO TX 79106 POTTER (806) 212-2000 Acute Care Hospitals Proprietary TRUE 35.1951150 -101.9188500 0   375 48 48375 11100 Amarillo-Borger, TX Central Potter County https://data.medicare.gov/resource/xubh-q36u/row-4rbc-ngk8.tb7q 450231 651243 2019-06-24 2018-12-31 282   48       354   24           378
2602 2602 POWER COUNTY HOSPITAL DISTRICT 510 ROOSEVELT STREET AMERICAN FALLS ID 83211 POWER (208) 226-3200 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.7818580 -112.8490470 0   77 16 16077         https://data.medicare.gov/resource/xubh-q36u/row-jqyn~uieu.hqrg 131304 645328 2019-03-20 2018-09-30 10           10       16       26
1879 1879 AMERICAN FORK HOSPITAL 170 NORTH 1100 EAST AMERICAN FORK UT 84003 UTAH (801) 855-3305 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3805060 -111.7690940 0   49 49 49049 39340 Salt Lake City-Provo-Orem, UT Central Utah County https://data.medicare.gov/resource/xubh-q36u/row-s7aj~ypv9~6tcc 460023 648658 2019-05-22 2018-12-31 73 18         91               91
4531 4531 PHOEBE SUMTER MEDICAL CENTER 126 HIGHWAY 280 W AMERICUS GA 31719 SUMTER (229) 931-1280 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.0642500 -84.2553760 0   261 13 13261 11140   Central Sumter County https://data.medicare.gov/resource/xubh-q36u/row-vsiw~isbg~xz6s 110044 658233 2018-12-28 2018-07-31 44   10       54               54
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
4219 4219 MARY GREELEY MEDICAL CENTER 1111 DUFF AVENUE AMES IA 50010 STORY (515) 239-2011 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0323910 -93.6106240 0   169 19 19169 11180 Des Moines-Ames-West Des Moines, IA Central Story County https://data.medicare.gov/resource/xubh-q36u/row-f3e5-ezht_qnay 160030 660544 2019-11-27 2019-06-30 144 14         158 20 17       12   207
3312 3312 HOOD MEMORIAL HOSPITAL 301 W WALNUT STREET AMITE LA 70422 TANGIPAHOA (985) 748-9485 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.7330720 -90.5123440 0   105 22 22105 25220 New Orleans-Metairie-Hammond, LA-MS Central Tangipahoa Parish https://data.medicare.gov/resource/xubh-q36u/row-5z99-s3dg~x38s 191309 652592 2019-08-05 2018-09-30 25           25               25
3044 3044 NORTH MISSISSIPPI MEDICAL CENTER-GILMORE AMORY 1105 EARL FRYE BLVD AMORY MS 38821 MONROE (662) 256-7111 Acute Care Hospitals Proprietary TRUE 33.9775510 -88.4776250 0   95 28 28095         https://data.medicare.gov/resource/xubh-q36u/row-mseb-a3c5-hfq8 250025 649915 2019-06-03 2018-12-31 80 9       6 95               95
2078 2078 ST MARY'S HEALTHCARE 427 GUY PARK AVENUE AMSTERDAM NY 12010 MONTGOMERY (518) 841-7101 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9536480 -74.2160410 0   57 36 36057 11220 Albany-Schenectady, NY Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-vppd.gmfx_gaq3 330047 661362 2019-11-27 2019-06-30 92 8         100 20 10   160       290
963 963 COMMUNITY HOSPITAL OF ANACONDA 401 W PENNSYLVANIA ANACONDA MT 59711 DEER LODGE (406) 563-8500 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1331110 -112.9561530 0   23 30 30023         https://data.medicare.gov/resource/xubh-q36u/row-pzua_d27v_2w94 271335 652086 2019-05-06 2018-12-31 25           25       62       87
2094 2094 ISLAND HOSPITAL 1211 24TH STREET ANACORTES WA 98221 SKAGIT (360) 299-1300 Acute Care Hospitals Government - Hospital District or Authority TRUE 48.5028830 -122.6158250 0   57 53 53057 34580 Seattle-Tacoma, WA Central Skagit County https://data.medicare.gov/resource/xubh-q36u/row-7mqw.zfgi.xhpw 500007 651429 2019-06-03 2018-12-31 37 6         43               43
708 708 THE PHYSICIANS' HOSPITAL IN ANADARKO 1002 E CENTRAL BLVD ANADARKO OK 73005 CADDO (405) 247-8236 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.0722700 -98.2279900 0   15 40 40015         https://data.medicare.gov/resource/xubh-q36u/row-p7ys.d7q7.puqw 371314 644773 2019-03-01 2018-09-30 25           25               25
2102 2102 AHMC ANAHEIM REGIONAL MEDICAL CENTER 1111 W LA PALMA AVENUE ANAHEIM CA 92801 ORANGE (714) 774-1450 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.8471380 -117.9339340 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-r3zf-f22h~mx8e 50226 661286 2019-12-02 2019-06-30 180 32         223               223
2110 2110 WEST ANAHEIM MEDICAL CENTER 3033 W ORANGE AVENUE ANAHEIM CA 92804 ORANGE (714) 827-3000 Acute Care Hospitals Proprietary TRUE 33.8247350 -117.9951150 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-8kya.7e8a~kd8g 50426 654904 2019-09-27 2018-12-31 147 20         167 30     22       219
2112 2112 KAISER FOUNDATION HOSPITAL - ORANGE COUNTY - ANAHE 3440 E LA PALMA AVE ANAHEIM CA 92806 ORANGE (714) 279-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.8544410 -117.8441100 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-s64m_nvmk-fqx3 50609 652227 2019-06-06 2018-12-31 398 60         484               484

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