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

757 rows where hospital_ownership = "Proprietary"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, fy_end_date, coronary_beds, burn_beds, surg_icu_beds, subprovider_oth_beds, nursing_fac_beds, oth_longterm_beds, filed_date (date), fy_end_date (date)

hospital_ownership ✖

  • Proprietary · 757 ✖
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
26 26 CITY HOSPITAL AT WHITE ROCK 9440 POPPY DR DALLAS TX 75218 DALLAS (214) 324-6100 Acute Care Hospitals Proprietary TRUE 32.8355210 -96.7050010 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-5mze~mvpw.a56k 450678 655846 2019-10-31 2019-05-31 167 20         187               187
33 33 RED BUD REGIONAL HOSPITAL 325 SPRING STREET RED BUD IL 62278 RANDOLPH (618) 282-3831 Critical Access Hospitals Proprietary TRUE 38.2096050 -89.9964080 0   157 17 17157         https://data.medicare.gov/resource/xubh-q36u/row-p29n.6wib~fbrj 141348 660526 2019-11-27 2019-06-30 25           25               25
75 75 GEORGE WASHINGTON UNIV HOSPITAL 900 23RD ST NW WASHINGTON DC 20037 THE DISTRICT (202) 716-4605 Acute Care Hospitals Proprietary TRUE 38.9011690 -77.0501190 0   1 11 11001 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central District of Columbia https://data.medicare.gov/resource/xubh-q36u/row-y2et_6xjz~rfau 90001 649550 2019-05-29 2018-12-31 255 56         329 20 16           365
77 77 NORTH FLORIDA REGIONAL MEDICAL CENTER 6500 NEWBERRY RD GAINESVILLE FL 32605 ALACHUA (352) 333-4100 Acute Care Hospitals Proprietary TRUE 29.6596990 -82.4115970 0   1 12 12001 23540 Gainesville-Lake City, FL Central Alachua County https://data.medicare.gov/resource/xubh-q36u/row-cu2v_edeq-29tz 100204 652641 2019-08-01 2019-02-28 321   48     12 381 33             414
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
99 99 MERIT HEALTH NATCHEZ 52 SERGEANT PRENTISS DRIVE NATCHEZ MS 39120 ADAMS (601) 443-2100 Acute Care Hospitals Proprietary TRUE 31.5279831 -91.3884516 1 RANGE_INTERPOLATED 1 28 28001 35020   Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-36cp~uwxv-3duz 250084 643800 2019-02-27 2018-09-30 132 15         147 12 20           179
100 100 NORTHEAST REGIONAL MEDICAL CENTER 315 S OSTEOPATHY KIRKSVILLE MO 63501 ADAIR (660) 785-1000 Acute Care Hospitals Proprietary TRUE 40.1925230 -92.5908490 0   1 29 29001 28860   Central Adair County https://data.medicare.gov/resource/xubh-q36u/row-75xb~p5w7-egiy 260022 656302 2019-10-31 2019-05-31 41 10         51               51
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
123 123 PALESTINE REGIONAL MEDICAL CENTER 2900 S LOOP 256 PALESTINE TX 75801 ANDERSON (903) 731-1000 Acute Care Hospitals Proprietary TRUE 31.7333740 -95.6253070 0   1 48 48001 37300   Central Anderson County https://data.medicare.gov/resource/xubh-q36u/row-ymbb~yh2p_i5c8 450747 649500 2019-06-04 2018-12-31 106 10         116 19 17           152
133 133 SOUTH BALDWIN REGIONAL MEDICAL CENTER 1613 NORTH MCKENZIE STREET FOLEY AL 36535 BALDWIN (251) 949-3400 Acute Care Hospitals Proprietary TRUE 30.4261090 -87.6831870 0   3 1 1003 19300 Mobile-Daphne-Fairhope, AL Central Baldwin County https://data.medicare.gov/resource/xubh-q36u/row-pyt4.i3a3.r8cm 10083 645389 2019-03-01 2018-09-30 82 30         112               112
144 144 MANCHESTER MEMORIAL HOSPITAL 71 HAYNES ST MANCHESTER CT 6040 HARTFORD (860) 647-4780 Acute Care Hospitals Proprietary TRUE 41.7810870 -72.5252210 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-shzd.8q5k_ybhg 70027 650673 2019-05-30 2018-12-31 108 32         140 31             171
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
162 162 STRAUB CLINIC AND HOSPITAL 888 SO KING STREET HONOLULU HI 96813 HONOLULU (808) 522-4000 Acute Care Hospitals Proprietary TRUE 21.3022680 -157.8509210 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-j69k-r5cq-9v28 120022 659775 2019-11-26 2019-06-30 140 16   3     159               159
165 165 LUTHERAN HOSPITAL OF INDIANA 7950 W JEFFERSON BLVD FORT WAYNE IN 46804 ALLEN (260) 435-7001 Acute Care Hospitals Proprietary TRUE 41.0373740 -85.2458850 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-22sz~6zvg.fbpc 150017 661886 2019-12-03 2019-06-30 254   24       396               396
166 166 DUPONT HOSPITAL LLC 2520 E DUPONT RD FORT WAYNE IN 46825 ALLEN (260) 416-3000 Acute Care Hospitals Proprietary TRUE 41.1786890 -85.1106030 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-q73v-xd2h_rmgd 150150 654122 2019-09-04 2019-03-31 92 10         131               131
167 167 ST JOSEPH HOSPITAL 700 BROADWAY FORT WAYNE IN 46802 ALLEN (260) 425-3000 Acute Care Hospitals Proprietary TRUE 41.0788910 -85.1488730 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-kr9f_9zxq-kk6p 150047 655893 2019-10-31 2019-05-31 76     12     88 19     20       127
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
175 175 OAKDALE COMMUNITY HOSPITAL 130 N HOSPITAL DR OAKDALE LA 71463 ALLEN (318) 335-3700 Acute Care Hospitals Proprietary TRUE 30.8162640 -92.6445450 0   3 22 22003         https://data.medicare.gov/resource/xubh-q36u/row-7xwr-vazc_74w6 190106 654443 2019-09-09 2019-03-31 46 3         49               49
189 189 VALLEY HOSPITAL MEDICAL CENTER 620 SHADOW LANE LAS VEGAS NV 89106 CLARK (702) 388-4000 Acute Care Hospitals Proprietary TRUE 36.1639140 -115.1654630 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-h9xh~nrzf.p42d 290021 649464 2019-05-29 2018-12-31 229 20 25       274   16           290
193 193 DESERT SPRINGS HOSPITAL 2075 EAST FLAMINGO ROAD LAS VEGAS NV 89119 CLARK (702) 369-7600 Acute Care Hospitals Proprietary TRUE 36.1145610 -115.1255480 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-h6f4_d5w8_jhfe 290022 649621 2019-05-29 2018-12-31 215 34         249 32 12           293
194 194 MOUNTAINVIEW HOSPITAL 3100 N TENAYA WAY LAS VEGAS NV 89128 CLARK (702) 255-5065 Acute Care Hospitals Proprietary TRUE 36.2156000 -115.2507950 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-ifwz~wzbs.p5xc 290039 650298 2019-05-28 2018-12-31 277 47       24 348   36           384
197 197 MESA VIEW REGIONAL HOSPITAL 1299 BERTHA HOWE AVENUE MESQUITE NV 89027 CLARK (702) 346-8040 Critical Access Hospitals Proprietary TRUE 36.8088590 -114.1144560 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-8rk4-cq3s_fa8n 291307 640239 2018-12-18 2018-07-31 21 4         25               25
200 200 DIGNITY HEALTH ST ROSE DOMINICAN N L V CAMPUS 1550 W CRAIG RANCH NORTH LAS VEGAS NV 89031 CLARK (702) 777-3615 Acute Care Hospitals Proprietary TRUE 36.2434428 -115.1500008 1 ROOFTOP 3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-u3b3_a37u-466v 290058 652436 2019-05-30 2018-12-31 32           32               32
201 201 HENDERSON HOSPITAL 1050 WEST GALLERIA DRIVE HENDERSON NV 89011 CLARK (318) 290-4395 Acute Care Hospitals Proprietary TRUE 36.0728432 -115.0304734 1 ROOFTOP 3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-duqr_nix9.a8cp 290057 648718 2019-05-29 2018-12-31 120 16         140               140
204 204 CENTENNIAL HILLS HOSPITAL MEDICAL CENTER 6900 N DURANGO DR LAS VEGAS NV 89149 CLARK (702) 835-9700 Acute Care Hospitals Proprietary TRUE 36.2860140 -115.2877300 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-mxjv~899t-ww8w 290054 648952 2019-05-30 2018-12-31 217 16         248               248
206 206 SUNRISE HOSPITAL AND MEDICAL CENTER 3186 S MARYLAND PKWY LAS VEGAS NV 89109 CLARK (702) 731-8000 Acute Care Hospitals Proprietary TRUE 36.1345860 -115.1368830 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-9gwr_6ph4-9w5i 290003 652435 2019-08-01 2019-01-31 376 64     20 72 554   42           596
207 207 SPRING VALLEY HOSPITAL MEDICAL CENTER 5400 SOUTH RAINBOW BLVD LAS VEGAS NV 89118 CLARK (702) 853-3000 Acute Care Hospitals Proprietary TRUE 36.0897140 -115.2428820 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-e224~h6nw_3cd4 290046 649465 2019-05-29 2018-12-31 279 28         337   22           359
208 208 SUMMERLIN HOSPITAL MEDICAL CENTER 657 TOWN CENTER DRIVE LAS VEGAS NV 89144 CLARK (702) 233-7500 Acute Care Hospitals Proprietary TRUE 36.1796380 -115.3157760 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-bs37~asjj.ux8i 290041 649924 2019-05-29 2018-12-31 248 59         370   31           401
215 215 HACKENSACK MERIDIAN HEALTH PASCACK VALLEY MEDICAL 250 OLD HOOK ROAD WESTWOOD NJ 7675 BERGEN (201) 383-1035 Acute Care Hospitals Proprietary TRUE 40.9836580 -74.0141950 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-kwcd-72qg_ygd9 310130 660416 2019-11-25 2019-06-30 64 9         78               78
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
241 241 KENT COUNTY MEMORIAL HOSPITAL 455 TOLL GATE RD WARWICK RI 2886 KENT (401) 737-7010 Acute Care Hospitals Proprietary TRUE 41.7044780 -71.4779020 0   3 44 44003 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Kent County https://data.medicare.gov/resource/xubh-q36u/row-cxmm.944u~3iqc 410009 644655 2019-02-28 2018-09-30 308 15         323   20           343
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
243 243 TENNOVA HEALTHCARE-SHELBYVILLE 2835 HWY 231 NORTH SHELBYVILLE TN 37160 BEDFORD (931) 685-5433 Acute Care Hospitals Proprietary TRUE 35.5632180 -86.4463720 0   3 47 47003 43180 Nashville-Davidson--Murfreesboro, TN Central Bedford County https://data.medicare.gov/resource/xubh-q36u/row-nnwj-ykm6~eviv 440137 654172 2019-09-04 2019-03-31 36 8         44               44
245 245 BRIGHAM CITY COMMUNITY HOSPITAL 950 SOUTH MEDICAL DRIVE BRIGHAM CITY UT 84302 BOX ELDER (435) 734-9471 Acute Care Hospitals Proprietary TRUE 41.4910700 -112.0244410 0   3 49 49003 36260 Salt Lake City-Provo-Orem, UT Central Box Elder County https://data.medicare.gov/resource/xubh-q36u/row-nuu9~e5qc.3jxf 460017 657558 2019-01-17 2018-08-31 40           40               40
260 260 MEDICAL CENTER OF AURORA, THE 1501 S POTOMAC ST AURORA CO 80012 ARAPAHOE (303) 873-5511 Acute Care Hospitals Proprietary TRUE 39.6893460 -104.8311500 0   5 8 8005 19740 Denver-Aurora, CO Central Arapahoe County https://data.medicare.gov/resource/xubh-q36u/row-b8kj.p6xy-3gvh 60100 648892 2019-05-31 2018-12-31 250 45       14 309 20             329
261 261 SWEDISH MEDICAL CENTER 501 E HAMPDEN AVE ENGLEWOOD CO 80113 ARAPAHOE (303) 788-5000 Acute Care Hospitals Proprietary TRUE 39.6531360 -104.9817100 0   5 8 8005 19740 Denver-Aurora, CO Central Arapahoe County https://data.medicare.gov/resource/xubh-q36u/row-3yvr.y5p2.2bay 60034 643574 2019-02-26 2018-09-30 281 58       17 356   16           372
263 263 SHARON HOSPITAL 50 HOSPITAL HILL ROAD SHARON CT 6069 LITCHFIELD (860) 364-4228 Acute Care Hospitals Proprietary TRUE 41.8796620 -73.4815720 0   5 9 9005 45860 New York-Newark, NY-NJ-CT-PA Central Litchfield County https://data.medicare.gov/resource/xubh-q36u/row-cvhr-qzru_z9ev 70004 658178 2019-02-28 2018-09-30 55 11         66 12             78
269 269 GULF COAST REGIONAL MEDICAL CENTER 449 W 23RD ST PANAMA CITY FL 32405 BAY (850) 769-8341 Acute Care Hospitals Proprietary TRUE 30.1896820 -85.6661240 0   5 12 12005 37460   Central Bay County https://data.medicare.gov/resource/xubh-q36u/row-7wyf_m6mi-z99k 100242 651510 2019-07-01 2019-01-31 170 20       28 222               222
271 271 PORTNEUF MEDICAL CENTER 777 HOSPITAL WAY POCATELLO ID 83201 BANNOCK (208) 239-1000 Acute Care Hospitals Proprietary TRUE 42.8726210 -112.4189000 0   5 16 16005 38540   Central Bannock County https://data.medicare.gov/resource/xubh-q36u/row-seur~dy2g.gabs 130028 653172 2019-08-07 2018-12-31 101 20         137 19 9           165
287 287 MORTON HOSPITAL 88 WASHINGTON STREET TAUNTON MA 2780 BRISTOL (508) 828-7000 Acute Care Hospitals Proprietary TRUE 41.9055830 -71.0943500 0   5 25 25005 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Bristol County https://data.medicare.gov/resource/xubh-q36u/row-648n_jcsm_qayn 220073 650488 2019-05-31 2018-12-31 81 12         93 19             112
289 289 SAINT ANNE'S HOSPITAL 795 MIDDLE STREET FALL RIVER MA 2721 BRISTOL (508) 674-5600 Acute Care Hospitals Proprietary TRUE 41.6933210 -71.1636420 0   5 25 25005 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Bristol County https://data.medicare.gov/resource/xubh-q36u/row-kxda_mnxm~imp3 220020 650486 2019-05-31 2018-12-31 163 12         175 31             206
300 300 WEISMAN CHILDRENS REHABILITATION HOSPITAL 92 BRICK ROAD, 3RD FLOOR MARLTON NJ 8053 BURLINGTON (856) 489-4520 Childrens Proprietary TRUE 39.8805880 -74.9192090 0   5 34 34005 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Burlington County https://data.medicare.gov/resource/xubh-q36u/row-9nkd_6jvc_38s2 313302 651476 2018-04-12 2017-12-31 18           18               18
301 301 EASTERN NEW MEXICO MEDICAL CENTER 405 W COUNTRY CLUB ROAD ROSWELL NM 88201 CHAVES (575) 624-8722 Acute Care Hospitals Proprietary TRUE 33.4233000 -104.5274050 0   5 35 35005 40740   Central Chaves County https://data.medicare.gov/resource/xubh-q36u/row-ddda_ex4p_75h9 320006 656469 2019-11-01 2019-05-31 142 20         162               162
307 307 BRONX-LEBANON HOSPITAL CENTER 1276 FULTON AVENUE BRONX NY 10456 BRONX (212) 588-7000 Acute Care Hospitals Proprietary TRUE 40.8317500 -73.9037560 0   5 36 36005 35620 New York-Newark, NY-NJ-CT-PA Central Bronx County https://data.medicare.gov/resource/xubh-q36u/row-ybqz_42sc_fi95 330009 650853 2019-06-27 2018-12-31 378 31 11     40 460 104             564
320 320 WOODLAND HEIGHTS MEDICAL CENTER 505 SOUTH JOHN REDDITT DRIVE LUFKIN TX 75904 ANGELINA (936) 634-8311 Acute Care Hospitals Proprietary TRUE 31.3277370 -94.7561390 0   5 48 48005 31260   Central Angelina County https://data.medicare.gov/resource/xubh-q36u/row-2twc-7b9d-f8nh 450484 649671 2019-05-31 2018-12-31 115 15         145               145
323 323 CACHE VALLEY HOSPITAL 2380 NORTH 400 EAST NORTH LOGAN UT 84341 CACHE (435) 713-9580 Acute Care Hospitals Proprietary TRUE 41.7757140 -111.8230920 0   5 49 49005 30860   Central Cache County https://data.medicare.gov/resource/xubh-q36u/row-quy7.rbde-cdcc 460054 653289 2019-08-22 2019-03-31 28           28               28
339 339 OZARKS COMMUNITY HOSPITAL OF GRAVETTE 1101 JACKSON STREET SW GRAVETTE AR 72736 BENTON (479) 787-5291 Critical Access Hospitals Proprietary TRUE 36.4085630 -94.4598700 0   7 5 5007 22220   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-snva.mem9_cs94 41331 651314 2019-05-30 2018-12-31 25           25               25
348 348 SHANDS STARKE REGIONAL MEDICAL CENTER 922 E CALL ST STARKE FL 32091 BRADFORD (904) 368-2300 Critical Access Hospitals Proprietary TRUE 29.9419070 -82.1016500 0   7 12 12007         https://data.medicare.gov/resource/xubh-q36u/row-463i.u2z5-p3cq 101310 660199 2019-12-02 2019-06-30 25           25               25
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
361 361 COLUSA MEDICAL CENTER 199 E WEBSTER STREET COLUSA CA 95932 COLUSA (530) 619-0800 Acute Care Hospitals Proprietary TRUE 39.2072860 -121.9999740 0   11 6 6011         https://data.medicare.gov/resource/xubh-q36u/row-gpbh.sehb~v3mr 50783 656264 2019-11-01 2018-12-31 36 6         42       6       48
366 366 NORTHEASTERN NEVADA REGIONAL HOSPITAL 2001 ERRECART BLVD ELKO NV 89801 ELKO (775) 738-5151 Acute Care Hospitals Proprietary TRUE 40.8225080 -115.7290260 0   7 32 32007 21220   Central Elko County https://data.medicare.gov/resource/xubh-q36u/row-q6r2~fn4e-z9r9 290008 662547 2019-11-27 2019-06-30 52 7         59               59
382 382 COLUMBIA MEMORIAL HOSPITAL 2111 EXCHANGE STREET ASTORIA OR 97103 CLATSOP (503) 325-4321 Critical Access Hospitals Proprietary TRUE 46.1885030 -123.8185020 0   7 41 41007 11820   Central Clatsop County https://data.medicare.gov/resource/xubh-q36u/row-qaiq-isb9.5jkp 381320 647151 2019-04-30 2018-12-31 21 4         25               25
385 385 OUR LADY OF FATIMA HOSPITAL 200 HIGH SERVICE AVENUE NORTH PROVIDENCE RI 2904 PROVIDENCE (401) 456-3000 Acute Care Hospitals Proprietary TRUE 41.8557960 -71.4584980 0   7 44 44007 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Providence County https://data.medicare.gov/resource/xubh-q36u/row-ya2z~83y5.tnki 410005 650779 2019-05-30 2018-12-31 148 15         163 124 25           312
386 386 ROGER WILLIAMS MEDICAL CENTER 825 CHALKSTONE AVENUE PROVIDENCE RI 2908 PROVIDENCE (401) 456-2025 Acute Care Hospitals Proprietary TRUE 41.8340150 -71.4345800 0   7 44 44007 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Providence County https://data.medicare.gov/resource/xubh-q36u/row-k87m-wjy5_7p2x 410004 650778 2019-05-30 2018-12-31 134       14   148 12             160
394 394 CASTLEVIEW HOSPITAL 300 NORTH HOSPITAL DRIVE PRICE UT 84501 CARBON (435) 637-4800 Acute Care Hospitals Proprietary TRUE 39.6054020 -110.8319110 0   7 49 49007 39220   Central Carbon County https://data.medicare.gov/resource/xubh-q36u/row-z6mk.zxuw_qeet 460011 651250 2019-06-03 2018-12-31 33 6         39               39
413 413 WATERBURY HOSPITAL 64 ROBBINS ST WATERBURY CT 6721 NEW HAVEN (203) 573-6000 Acute Care Hospitals Proprietary TRUE 41.5582690 -73.0586080 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-na88_kufh.6cuk 70005 650439 2019-05-30 2018-12-31 193 20         213 30             243
416 416 STEWARD ROCKLEDGE HOSPITAL 110 LONGWOOD AVE ROCKLEDGE FL 32955 BREVARD (321) 637-2603 Acute Care Hospitals Proprietary TRUE 28.3345400 -80.7231330 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-tbme~t6bb.jqha 100092 649413 2019-05-31 2018-12-31 243 31         274 24             298
417 417 STEWARD MELBOURNE HOSPITAL 250 NORTH WICKHAM ROAD MELBOURNE FL 32935 BREVARD (321) 752-1200 Acute Care Hospitals Proprietary TRUE 28.1098040 -80.6726100 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-fnh8.cjxx_ncpd 100291 649425 2019-05-31 2018-12-31 101 12         113               113
422 422 PALM BAY HOSPITAL 1425 MALABAR RD, NE PALM BAY FL 32907 BREVARD (321) 434-8000 Acute Care Hospitals Proprietary TRUE 27.9983300 -80.6120800 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-a9fd-uaut~kpyk 100316 646071 2019-02-27 2018-09-30 108 12         120 18             138
423 423 NAVICENT HEALTH BALDWIN 821 NORTH COBB STREET MILLEDGEVILLE GA 31061 BALDWIN (478) 454-3550 Acute Care Hospitals Proprietary TRUE 33.0884310 -83.2451450 0   9 13 13009 33300   Central Baldwin County https://data.medicare.gov/resource/xubh-q36u/row-4c5x-vuf4-z6uq 110150 655099 2019-10-10 2018-09-30 86 12         98       15       113
431 431 UNIVERSITY OF KS HLTH SYSTEM GREAT BEND CAMPUS 514 CLEVELAND STREET GREAT BEND KS 67530 BARTON (620) 792-8833 Acute Care Hospitals Proprietary TRUE 38.3562000 -98.7916190 0   9 20 20009 24460   Central Barton County https://data.medicare.gov/resource/xubh-q36u/row-ezt6_4fjw-kpxn 170191 660092 2019-11-26 2019-06-30 29 4         33               33
435 435 AVOYELLES HOSPITAL 4231 HIGHWAY 1192 MARKSVILLE LA 71351 AVOYELLES (318) 253-8611 Acute Care Hospitals Proprietary TRUE 31.1431270 -92.0644330 0   9 22 22009         https://data.medicare.gov/resource/xubh-q36u/row-yf6k.hf5w.97ar 190099 661332 2019-12-09 2019-06-30 47 2         49               49
445 445 HOLY FAMILY HOSPITAL 70 EAST STREET METHUEN MA 1844 ESSEX (978) 687-0156 Acute Care Hospitals Proprietary TRUE 42.7258290 -71.1696180 0   9 25 25009 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Essex County https://data.medicare.gov/resource/xubh-q36u/row-ur5a-crja_mqpg 220080 649443 2019-05-29 2018-12-31 301 29         330 17             347
456 456 OLEAN GENERAL HOSPITAL 515 MAIN STREET OLEAN NY 14760 CATTARAUGUS (716) 373-2600 Acute Care Hospitals Proprietary TRUE 42.0894480 -78.4269770 0   9 36 36009 36460 Buffalo-Cheektowaga, NY Central Cattaraugus County https://data.medicare.gov/resource/xubh-q36u/row-hkii~eckc~6rgh 330103 650862 2019-06-03 2018-12-31 260           260 14     293       567
473 473 AURORA BAYCARE MEDICAL CTR 2845 GREENBRIER RD GREEN BAY WI 54311 BROWN (920) 288-8000 Acute Care Hospitals Proprietary TRUE 44.4733500 -87.9410910 0   9 55 55009 24580 Green Bay-Shawano, WI Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-ue2y_pbya.a2y6 520193 651107 2019-06-04 2018-12-31 119 24       18 161   6           167
480 480 BULLOCK COUNTY HOSPITAL 102 WEST CONECUH AVENUE UNION SPRINGS AL 36089 BULLOCK (334) 738-2140 Acute Care Hospitals Proprietary TRUE 32.1461820 -85.7163800 0   11 1 1011         https://data.medicare.gov/resource/xubh-q36u/row-te44-k6fz_rhpp 10110 648174 2019-05-15 2018-12-31 30           30 24             54
486 486 NORTHWEST MEDICAL CENTER 2801 N STATE RD 7 MARGATE FL 33063 BROWARD (954) 974-0400 Acute Care Hospitals Proprietary TRUE 26.2629030 -80.2019050 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-e825~y5d2-68se 100189 649421 2019-05-31 2018-12-31 193 24       11 228               228
491 491 UNIVERSITY HOSPITAL AND MEDICAL CENTER 7201 N UNIVERSITY DR TAMARAC FL 33321 BROWARD (954) 721-2200 Acute Care Hospitals Proprietary TRUE 26.2113850 -80.2525430 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-qbz6.9rz8_v3uh 100224 654910 2019-09-30 2019-04-30 230 15         245 60             305
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
507 507 NORTHERN LIGHT INLAND HOSPITAL 200 KENNEDY MEMORIAL DRIVE WATERVILLE ME 4901 KENNEBEC (207) 861-3000 Acute Care Hospitals Proprietary TRUE 44.5426900 -69.6614050 0   11 23 23011 12300   Central Kennebec County https://data.medicare.gov/resource/xubh-q36u/row-w24b~y2sj-qzhk 200041 650154 2019-05-29 2018-09-30 33           33               33
512 512 BOLIVAR MEDICAL CENTER 901 E SUNFLOWER RD CLEVELAND MS 38732 BOLIVAR (662) 846-0061 Acute Care Hospitals Proprietary TRUE 33.7474710 -90.7081280 0   11 28 28011 17380 Cleveland-Indianola, MS Central Bolivar County https://data.medicare.gov/resource/xubh-q36u/row-6ymk.r4nx_mhwx 250093 653424 2019-09-03 2019-03-31 144 8         152 12         35   199
517 517 MONADNOCK COMMUNITY HOSPITAL 452 OLD STREET ROAD PETERBOROUGH NH 3458 HILLSBOROUGH (603) 924-7191 Critical Access Hospitals Proprietary TRUE 42.8934610 -71.9374710 0   11 33 33011 31700 Boston-Worcester-Providence, MA-RI-NH-CT Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-mhsm~xuaz.m9jn 301309 645432 2019-03-01 2018-09-30 25           25               25
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
535 535 TENNOVA HEALTHCARE-CLEVELAND 2305 CHAMBLISS AVE NW CLEVELAND TN 37311 BRADLEY (423) 339-4132 Acute Care Hospitals Proprietary TRUE 35.1767430 -84.8685910 0   11 47 47011 17420 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Bradley County https://data.medicare.gov/resource/xubh-q36u/row-yct2-mv92~dmuc 440185 657498 2019-01-29 2018-08-31 156 27         183               183
538 538 DAVIS HOSPITAL AND MEDICAL CENTER 1600 WEST ANTELOPE DRIVE LAYTON UT 84041 DAVIS (801) 807-7001 Acute Care Hospitals Proprietary TRUE 41.0892420 -111.9954710 0   11 49 49011 36260 Salt Lake City-Provo-Orem, UT Central Davis County https://data.medicare.gov/resource/xubh-q36u/row-wuqr~ebyx-f6ny 460041 653359 2019-08-30 2019-03-31 141 14       15 170 25 10           205
548 548 REGIONAL MEDICAL CENTER OF CENTRAL ALABAMA 29 L V STABLER DRIVE GREENVILLE AL 36037 BUTLER (334) 382-2200 Acute Care Hospitals Proprietary TRUE 31.8294500 -86.6458600 0   13 1 1013         https://data.medicare.gov/resource/xubh-q36u/row-ca8j-ucpx~zp9d 10150 645390 2019-03-01 2018-09-30 37 7         44 13             57
549 549 ABRAZO SCOTTSDALE CAMPUS 3929 EAST BELL ROAD PHOENIX AZ 85032 MARICOPA (602) 923-5000 Acute Care Hospitals Proprietary TRUE 33.6406030 -111.9976920 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-3yrx.bcen.wd4a 30083 644698 2019-02-28 2018-09-30 113 14         127               127
551 551 SCOTTSDALE THOMPSON PEAK MEDICAL CENTER 7400 EAST THOMPSON PEAK PARKWAY SCOTTSDALE AZ 85255 MARICOPA (480) 324-7001 Acute Care Hospitals Proprietary TRUE 33.6697770 -111.9218030 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-y7bn~8g49_tr6b 30123 650235 2019-05-31 2018-12-31 112 8         120               120
555 555 SCOTTSDALE OSBORN MEDICAL CENTER 7400 EAST OSBORN ROAD SCOTTSDALE AZ 85251 MARICOPA (480) 882-4004 Acute Care Hospitals Proprietary TRUE 33.4876390 -111.9227250 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-xncf.ukg7_66e2 30038 650230 2019-05-31 2018-12-31 268 59         327   14           341
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
557 557 ST LUKE'S MEDICAL CENTER 1800 EAST VAN BUREN STREET PHOENIX AZ 85006 MARICOPA (602) 251-8156 Acute Care Hospitals Proprietary TRUE 33.4514360 -112.0427670 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-uw3s~cbm4-5jyq 30037 655739 2019-10-31 2019-05-31 141 30         171 55 16           242
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                              
566 566 ABRAZO ARROWHEAD CAMPUS 18701 NORTH 67TH AVENUE GLENDALE AZ 85308 MARICOPA (623) 561-1000 Acute Care Hospitals Proprietary TRUE 33.6550420 -112.2028890 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-mbqg~urbx.9rm7 30094 654000 2019-08-29 2019-03-31 224 38         262               262
569 569 SCOTTSDALE SHEA MEDICAL CENTER 9003 EAST SHEA BOULEVARD SCOTTSDALE AZ 85260 MARICOPA (480) 323-3000 Acute Care Hospitals Proprietary TRUE 33.5824670 -111.8860320 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-zegy.nw3j~tfkb 30087 650231 2019-05-31 2018-12-31 378 25       24 427               427
570 570 MOUNTAIN VISTA MEDICAL CENTER, LP 1301 SOUTH CRISMON ROAD MESA AZ 85209 MARICOPA (480) 358-6100 Acute Care Hospitals Proprietary TRUE 33.3911000 -111.6153290 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-aus8~8k4g-9a4c 30121 659181 2019-11-21 2019-06-30 112 30         142 20             162
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
577 577 ABRAZO WEST CAMPUS 13677 WEST MCDOWELL ROAD GOODYEAR AZ 85395 MARICOPA (623) 882-1970 Acute Care Hospitals Proprietary TRUE 33.4642830 -112.3540240 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-6kds~arrq.mhdd 30110 654825 2019-09-26 2019-04-30 159 20         179               179
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                                      
585 585 SAN RAMON REGIONAL MEDICAL CENTER 6001 NORRIS CANYON ROAD SAN RAMON CA 94583 CONTRA COSTA (925) 275-9200 Acute Care Hospitals Proprietary TRUE 37.7759880 -121.9592740 0   13 6 6013 41860 San Jose-San Francisco-Oakland, CA Outlying Contra Costa County https://data.medicare.gov/resource/xubh-q36u/row-mpyd~xeiu_s72k 50689 655752 2019-10-28 2019-05-31 109 12       2 123               123
597 597 ROCKVILLE GENERAL HOSPITAL 31 UNION ST ROCKVILLE CT 6066 TOLLAND (860) 872-5160 Acute Care Hospitals Proprietary TRUE 41.8669620 -72.4509880 0   13 9 9013 25540 Hartford-West Hartford, CT Central Tolland County https://data.medicare.gov/resource/xubh-q36u/row-fjuu~c5fd_6w23 70012 650672 2019-05-30 2018-12-31 93 9         102       130       232
599 599 NORTHEAST GEORGIA MEDICAL CENTER BARROW 316 NORTH BROAD STREET WINDER GA 30680 BARROW (770) 848-8611 Acute Care Hospitals Proprietary TRUE 34.0077010 -83.7067060 0   13 13 13013 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Barrow County https://data.medicare.gov/resource/xubh-q36u/row-hr24_ckbz~3ykf 110045 644713 2019-03-01 2018-09-30 50 6         56               56
607 607 BIENVILLE MEDICAL CENTER 1175 PINE STREET ARCADIA LA 71001 BIENVILLE (318) 263-4700 Critical Access Hospitals Proprietary TRUE 32.5530850 -92.9157770 0   13 22 22013         https://data.medicare.gov/resource/xubh-q36u/row-ui8b~9pic.2t2z 191320 650142 2019-06-03 2018-12-31 21           21               21
620 620 GREAT FALLS CLINIC HOSPITAL 3010 15TH AVENUE SOUTH GREAT FALLS MT 59405 CASCADE (406) 216-8000 Acute Care Hospitals Proprietary TRUE 47.4877370 -111.2545610 0   13 30 30013 24500   Central Cascade County https://data.medicare.gov/resource/xubh-q36u/row-zzvw_fvcf~g44t 270086 651217 2019-06-03 2018-12-31 20           20               20
634 634 MEMORIAL MEDICAL CENTER 2450 SOUTH TELSHOR BLVD LAS CRUCES NM 88011 DONA ANA (575) 522-8641 Acute Care Hospitals Proprietary TRUE 32.2919930 -106.7350180 0   13 35 35013 29740 El Paso-Las Cruces, TX-NM Central Doña Ana County https://data.medicare.gov/resource/xubh-q36u/row-ecy9~459r.3ez3 320018 646297 2019-03-01 2018-09-30 171 28         199               199
635 635 MOUNTAIN VIEW REGIONAL MEDICAL CENTER 4311 EAST LOHMAN AVENUE LAS CRUCES NM 88011 DONA ANA (575) 556-7610 Acute Care Hospitals Proprietary TRUE 32.3226390 -106.7282970 0   13 35 35013 29740 El Paso-Las Cruces, TX-NM Central Doña Ana County https://data.medicare.gov/resource/xubh-q36u/row-6m6j-xb3y-q4ig 320085 654343 2019-08-30 2019-03-31 145 23         180               180
642 642 ALLIANCEHEALTH DURANT 1800 UNIVERSITY BOULEVARD DURANT OK 74702 BRYAN (405) 924-3080 Acute Care Hospitals Proprietary TRUE 34.0049030 -96.3950550 0   13 40 40013 20460 Dallas-Fort Worth, TX-OK Central Bryan County https://data.medicare.gov/resource/xubh-q36u/row-96gx.9gst_7qhe 370014 646932 2019-04-03 2018-09-30 132 8         140               140
648 648 HILTON HEAD REGIONAL MEDICAL CENTER 25 HOSPITAL CENTER BLVD HILTON HEAD ISLAND SC 29925 BEAUFORT (843) 681-6122 Acute Care Hospitals Proprietary TRUE 32.2193200 -80.7125000 0   13 45 45013 25940   Central Beaufort County https://data.medicare.gov/resource/xubh-q36u/row-twij.hnjd-wm9w 420080 651483 2019-05-31 2018-12-31 81 12         93               93
654 654 METHODIST HOSPITAL SOUTH 1905 HWY 97 EAST JOURDANTON TX 78026 ATASCOSA (830) 769-3515 Acute Care Hospitals Proprietary TRUE 28.9331124 -98.5260352 1 ROOFTOP 13 48 48013 41700   Outlying Atascosa County https://data.medicare.gov/resource/xubh-q36u/row-5vk8_ecmw.2bzr 450165 660714 2019-11-26 2019-06-30 61 6         67               67
657 657 BAYFRONT HEALTH PUNTA GORDA 809 E MARION AVE PUNTA GORDA FL 33950 CHARLOTTE (941) 639-3131 Acute Care Hospitals Proprietary TRUE 26.9406820 -82.0417880 0   15 12 12015 39460 North Port-Sarasota, FL Central Charlotte County https://data.medicare.gov/resource/xubh-q36u/row-9zqr-j2tf~pweh 100047 645396 2019-03-01 2018-09-30 114 10         124 52             176
662 662 SAGEWEST HEALTH CARE 2100 W SUNSET DR RIVERTON WY 82501 FREMONT (307) 856-4161 Acute Care Hospitals Proprietary TRUE 43.0336670 -108.4186540 0   13 56 56013 40180   Central Fremont County https://data.medicare.gov/resource/xubh-q36u/row-8cgp~ktku_un2q 530008 652129 2019-06-03 2018-12-31 121 12         133 13 8           154

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