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

95 rows where "fy_end_date" is on date 2018-08-31

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, statefips, csatitle, centraloutlyingcounty, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, nursing_fac_beds, filed_date (date)

fy_end_date (date) ✖

  • 2018-08-31 · 95 ✖
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
44 44 STANFORD HEALTH CARE - VALLEYCARE 5555 WEST LAS POSITAS BOULEVARD PLEASANTON CA 94588 ALAMEDA (925) 447-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.6921330 -121.8800270 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-i8ak.uv35.9uup 50283 656398 2019-01-31 2018-08-31 144 23         167 14     26       207
78 78 APPLING HOSPITAL 163 E TOLLISON STREET BAXLEY GA 31513 APPLING (912) 367-9841 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.7687680 -82.3493510 0   1 13 13001         https://data.medicare.gov/resource/xubh-q36u/row-j4qq-twpw~u8jw 110071 658240 2019-03-29 2018-08-31 31 3         34 30     101       165
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
276 276 PREVOST MEMORIAL HOSPITAL 301 MEMORIAL DR DONALDSONVILLE LA 70346 ASCENSION (225) 474-2133 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.0879510 -91.0029040 0   5 22 22005 12940   Central Ascension Parish https://data.medicare.gov/resource/xubh-q36u/row-e567~vwui.ed3h 191308 642472 2019-02-01 2018-08-31 25           25               25
490 490 PLANTATION GENERAL HOSPITAL 401 NW 42ND AVE PLANTATION FL 33317 BROWARD (954) 587-5010 Acute Care Hospitals Voluntary non-profit - Private TRUE 26.1264610 -80.2041700 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-k3qn_68yj.yfxn 100167 661481 2019-12-04 2018-08-31 477 61       37 589 56 15           660
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
668 668 WESTERN ARIZONA REGIONAL MEDICAL CENTER 2735 SILVER CREEK ROAD BULLHEAD CITY AZ 86442 MOHAVE (928) 763-2273 Acute Care Hospitals Proprietary TRUE 35.1098530 -114.5551460 0   15 4 4015 29420 Las Vegas-Henderson, NV-AZ Central Mohave County https://data.medicare.gov/resource/xubh-q36u/row-95sy-y45e~48d6 30101 656846 2019-01-31 2018-08-31 107 32         139               139
669 669 HAVASU REGIONAL MEDICAL CENTER 101 CIVIC CENTER LANE LAKE HAVASU CITY AZ 86403 MOHAVE (928) 855-8185 Acute Care Hospitals Proprietary TRUE 34.4799800 -114.3385370 0   15 4 4015 29420 Las Vegas-Henderson, NV-AZ Central Mohave County https://data.medicare.gov/resource/xubh-q36u/row-kbv6-rmcu~b79y 30069 661849 2019-02-04 2018-08-31 128 16         144       19       163
694 694 NIOBRARA VALLEY HOSPITAL P O BOX 118, 401 SOUTH 5TH STREET LYNCH NE 68746 BOYD (402) 569-2451 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.8245631 -98.4684820 1 ROOFTOP 15 31 31015         https://data.medicare.gov/resource/xubh-q36u/row-34qy.5xrg_j9e4 281303 658942 2018-11-19 2018-08-31 20           20               20
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
812 812 CLOVIS COMMUNITY MEDICAL CENTER 2755 HERNDON AVE CLOVIS CA 93611 FRESNO (559) 324-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.8374210 -119.6616260 0   19 6 6019 23420 Fresno-Madera, CA Central Fresno County https://data.medicare.gov/resource/xubh-q36u/row-sg86-et4h_ig4n 50492 660771 2019-01-28 2018-08-31 176 24       8 208               208
815 815 COMMUNITY REGIONAL MEDICAL CENTER 2823 FRESNO STREET FRESNO CA 93721 FRESNO (559) 459-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.7425830 -119.7830230 0   19 6 6019 23420 Fresno-Madera, CA Central Fresno County https://data.medicare.gov/resource/xubh-q36u/row-xy9w-yfis_5dn2 50060 662313 2019-01-28 2018-08-31 577 78   10   84 749   32   58 48     887
933 933 LOURDES MEDICAL CENTER 520 N FOURTH AVENUE PASCO WA 99301 FRANKLIN (509) 546-2278 Critical Access Hospitals Voluntary non-profit - Church TRUE 46.2350260 -119.0944360 0   21 53 53021 28420   Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-h47i.7rwx-7e8h 501337 642976 2019-02-04 2018-08-31 25           25   10           35
1000 1000 KENTUCKY RIVER MEDICAL CENTER 540 JETT DRIVE JACKSON KY 41339 BREATHITT (606) 666-6000 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.5654340 -83.3701110 0   25 21 21025         https://data.medicare.gov/resource/xubh-q36u/row-ewjp.xkmp_edhx 180139 657105 2019-08-21 2018-08-31 45 4         49               49
1105 1105 BAYLOR SCOTT & WHITE CLINIC - TEMPLE 2401 S 31ST ST TEMPLE TX 76508 BELL (254) 724-2111 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.0786930 -97.3659380 0   27 48 48027 28660   Central Bell County https://data.medicare.gov/resource/xubh-q36u/row-pkyb~vug2_qrtf 450054 661257 2019-02-01 2018-08-31 472 70         610 24             634
1118 1118 WATERTOWN REGIONAL MEDICAL CENTER 125 HOSPITAL DRIVE WATERTOWN WI 53098 DODGE (920) 261-4210 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.1999030 -88.6990140 0   27 55 55027 13180 Milwaukee-Racine-Waukesha, WI Central Dodge County https://data.medicare.gov/resource/xubh-q36u/row-3jmj~8w7i-jx4j 520116 658055 2019-01-31 2018-08-31 91 4         95               95
1186 1186 LEGENT ORTHOPEDIC + SPINE 5330 NORTH LOOP 1604 WEST SAN ANTONIO TX 78249 BEXAR (717) 620-2424 Acute Care Hospitals Proprietary TRUE 29.5914810 -98.5904380 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-gmp5~zjwe~7e5z 670112 656038 2019-01-30 2018-08-31 26           26               26
1206 1206 PRESBYTERIAN ST LUKES MEDICAL CENTER 1719 E 19TH AVE DENVER CO 80218 DENVER (303) 839-6000 Acute Care Hospitals Government - State TRUE 39.7460890 -104.9671750 0   31 8 8031 19740 Denver-Aurora, CO Central Denver County https://data.medicare.gov/resource/xubh-q36u/row-deb8~67qk~e2fi 60014 655884 2019-07-30 2018-08-31 224 71         337               337
1219 1219 NORTHWESTERN MEMORIAL HOSPITAL 251 E HURON ST CHICAGO IL 60611 COOK (312) 926-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8949950 -87.6213640 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-78ah.8t25-3qbx 140281 661318 2019-02-11 2018-08-31 691 106       86 883 29             912
1226 1226 ANN & ROBERT H LURIE CHILDRENS HOSPITAL OF CHICAGO 225 E CHICAGO AVE, BOX 140 CHICAGO IL 60611 COOK (312) 227-4000 Childrens Voluntary non-profit - Private TRUE 41.8967460 -87.6219060 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-apzm~334d~hd6g 143300 642330 2019-02-01 2018-08-31 168 40 44     60 312               312
1437 1437 SALT LAKE REGIONAL MEDICAL CENTER 1050 EAST SOUTH TEMPLE SALT LAKE CITY UT 84102 SALT LAKE (801) 350-4111 Acute Care Hospitals Proprietary TRUE 40.7693480 -111.8611750 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-4ivx_nzga-ke3c 460003 658871 2019-01-29 2018-08-31 87 20         107 20 16           143
1491 1491 GOOD SAMARITAN HOSPITAL 1225 WILSHIRE BOULEVARD LOS ANGELES CA 90017 LOS ANGELES (213) 977-2121 Acute Care Hospitals Proprietary FALSE 34.0532090 -118.2652920 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-bdi4_mszi_g3qn 50471 657674 2019-02-13 2018-08-31 248 39       23 310               310
1534 1534 VALLEY WEST COMMUNITY HOSPITAL 1301 NORTH MAIN STREET SANDWICH IL 60548 DE KALB (815) 786-8484 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.6571330 -88.6219200 0   37 17 17037 16980 Chicago-Naperville, IL-IN-WI Outlying DeKalb County https://data.medicare.gov/resource/xubh-q36u/row-hn6i_547d~phkm 141340 642794 2019-02-04 2018-08-31 21 4         25               25
1536 1536 KISHWAUKEE COMMUNITY HOSPITAL 1 KISH HOSPITAL DRIVE DEKALB IL 60115 DE KALB (815) 756-1521 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9618800 -88.7222600 0   37 17 17037 16980 Chicago-Naperville, IL-IN-WI Outlying DeKalb County https://data.medicare.gov/resource/xubh-q36u/row-hrvn~xgi9.izzd 140286 657818 2019-02-04 2018-08-31 86 12         98               98
1675 1675 BON SECOURS ST FRANCIS MEDICAL CENTER 13710 ST FRANCIS BOULEVARD MIDLOTHIAN VA 23114 CHESTERFIELD (804) 594-7400 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.4663980 -77.6590560 0   41 51 51041 40060   Central Chesterfield County https://data.medicare.gov/resource/xubh-q36u/row-tzv7~rut2-ttw4 490136 661426 2019-02-01 2018-08-31 114 16         130               130
1689 1689 CENTRAL DUPAGE HOSPITAL 25 NORTH WINFIELD ROAD WINFIELD IL 60190 DU PAGE (630) 682-1600 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8737650 -88.1580950 0   43 17 17043 16980 Chicago-Naperville, IL-IN-WI Central DuPage County https://data.medicare.gov/resource/xubh-q36u/row-uk94-fquw~zwsp 140242 661316 2019-02-04 2018-08-31 272 36 16     23 347 48             395
1692 1692 BAPTIST HEALTH FLOYD 1850 STATE ST NEW ALBANY IN 47150 FLOYD (812) 944-7701 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.3005060 -85.8350800 0   43 18 18043 31140 Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Central Floyd County https://data.medicare.gov/resource/xubh-q36u/row-5q6s.6iru_4xbh 150044 656644 2019-02-01 2018-08-31 209 16         225               225
1758 1758 ST FRANCIS-DOWNTOWN ONE ST FRANCIS DR GREENVILLE SC 29601 GREENVILLE (800) 805-5678 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.8405409 -82.4209903 1 ROOFTOP 45 45 45045 24860 Greenville-Spartanburg-Anderson, SC Central Greenville County https://data.medicare.gov/resource/xubh-q36u/row-rrk9~2g3j_mbbd 420023 657474 2019-01-30 2018-08-31 286 33         319   19           488
1797 1797 ALTA VISTA REGIONAL HOSPITAL 104 LEGION DRIVE LAS VEGAS NM 87701 SAN MIGUEL (505) 426-3930 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.6221500 -105.2098510 0   47 35 35047 29780 Albuquerque-Santa Fe-Las Vegas, NM Central San Miguel County https://data.medicare.gov/resource/xubh-q36u/row-eqjk~u8wz_58xt 320003 657378 2019-08-22 2018-08-31 38 8         46               46
1880 1880 MOUNTAIN VIEW HOSPITAL 1000 EAST 100 NORTH PAYSON UT 84651 UTAH (801) 465-7100 Acute Care Hospitals Proprietary TRUE 40.0446330 -111.7152570 0   49 49 49049 39340 Salt Lake City-Provo-Orem, UT Central Utah County https://data.medicare.gov/resource/xubh-q36u/row-gwva_dch9_3jcr 460013 657556 2019-01-29 2018-08-31 100 12       12 124               124
1890 1890 NATIONAL PARK MEDICAL CENTER 1910 MALVERN AVENUE HOT SPRINGS AR 71901 GARLAND (501) 321-1000 Acute Care Hospitals Proprietary TRUE 34.4862390 -93.0335540 0   51 5 5051 26300 Hot Springs-Malvern, AR Central Garland County https://data.medicare.gov/resource/xubh-q36u/row-ecgs.ugv2_gtfu 40078 656864 2019-02-14 2018-08-31 110 16         126 17 20           163
2056 2056 SOUTH BAY HOSPITAL 4016 SUN CITY CENTER BLVD SUN CITY CENTER FL 33573 HILLSBOROUGH (813) 634-3301 Acute Care Hospitals Proprietary TRUE 27.7123900 -82.3651680 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-t2n2.68x7~rif4 100259 642087 2019-01-25 2018-08-31 126 12         138               138
2101 2101 CHAPMAN GLOBAL MEDICAL CENTER 2601 E CHAPMAN AVE ORANGE CA 92869 ORANGE (714) 633-0011 Acute Care Hospitals Proprietary TRUE 33.7878780 -117.8270580 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-d6nk-icx9_sprw 50745 656258 2019-02-01 2018-08-31 63 12         75 12     27       114
2104 2104 ORANGE COUNTY GLOBAL MEDICAL CENTER 1001 NORTH TUSTIN AVENUE SANTA ANA CA 92705 ORANGE (714) 953-3610 Acute Care Hospitals Proprietary TRUE 33.7536360 -117.8342090 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-28hr-uc2x~4s2a 50746 660777 2019-02-01 2018-08-31 163 42   7   16 228               228
2105 2105 THOMAS H BOYD MEMORIAL HOSPITAL 800 SCHOOL ST CARROLLTON IL 62016 GREENE (217) 942-6946 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.2961700 -90.4123030 0   61 17 17061         https://data.medicare.gov/resource/xubh-q36u/row-vab7-2ww3-xwdi 141300 642094 2019-01-30 2018-08-31 25           25               25
2115 2115 SOUTH COAST GLOBAL MEDICAL CENTER 2701 S BRISTOL ST SANTA ANA CA 92704 ORANGE (714) 754-5454 Acute Care Hospitals Proprietary TRUE 33.7106920 -117.8854100 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-h474-fx88_e6is 50747 658163 2019-02-01 2018-08-31 100 9         109 23     46       178
2116 2116 ANAHEIM GLOBAL MEDICAL CENTER 1025 S ANAHEIM BLVD ANAHEIM CA 92805 ORANGE (714) 533-6220 Acute Care Hospitals Proprietary FALSE 33.8205660 -117.9090020 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-nd9d.35tv~sptu 50744 658161 2019-02-01 2018-08-31 81 22         103 80             183
2148 2148 NYU WINTHROP HOSPITAL 259 FIRST STREET MINEOLA NY 11501 NASSAU (516) 663-0333 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7416480 -73.6435320 0   59 36 36059 35620 New York-Newark, NY-NJ-CT-PA Central Nassau County https://data.medicare.gov/resource/xubh-q36u/row-8cdz_5xbm.wqa6 330167 661228 2019-11-12 2018-08-31 428 36 20     27 511               511
2226 2226 VHS HARLINGEN HOSPITAL COMPANY LLC 2101 PEASE ST HARLINGEN TX 78550 CAMERON (956) 389-1100 Acute Care Hospitals Proprietary TRUE 26.1734140 -97.6706660 0   61 48 48061 15180 Brownsville-Harlingen-Raymondville, TX Central Cameron County https://data.medicare.gov/resource/xubh-q36u/row-p8qk_8m5j~s6fq 450033 662428 2019-08-05 2018-08-31 294 40 8     32 374 12 18           404
2355 2355 BAPTIST HEALTH LEXINGTON 1740 NICHOLASVILLE ROAD LEXINGTON KY 40503 FAYETTE (859) 260-6104 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.0188420 -84.5139480 0   67 21 21067 30460 Lexington-Fayette--Richmond--Frankfort, KY Central Fayette County https://data.medicare.gov/resource/xubh-q36u/row-w47h-k353~ymyx 180103 660563 2019-11-25 2018-08-31 339 52         391               391
2567 2567 REGIONAL GENERAL HOSPITAL WILLISTON 125 SW 7TH ST WILLISTON FL 32696 LEVY (352) 528-2801 Acute Care Hospitals Proprietary TRUE 29.3843540 -82.4557930 0   75 12 12075         https://data.medicare.gov/resource/xubh-q36u/row-tm6t.5fgm.s5u5 100322 642986 2019-02-04 2018-08-31 20           20               20
2742 2742 OCALA REGIONAL MEDICAL CENTER 1431 SW 1ST AVE OCALA FL 34478 MARION (352) 401-1000 Acute Care Hospitals Proprietary TRUE 29.1747440 -82.1378390 0   83 12 12083 36100   Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-bsti-f9jn_qiab 100212 660499 2019-11-12 2018-08-31 294 66         360               360
2779 2779 LUCILE SALTER PACKARD CHILDREN'S HSP AT STANFORD 725 WELCH ROAD PALO ALTO CA 94304 SANTA CLARA (650) 497-8000 Childrens Voluntary non-profit - Private FALSE 37.4373820 -122.1750610 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-kerk.q8n2_pjvp 53305 644220 2019-02-28 2018-08-31 178         44 302               302
2781 2781 STANFORD HEALTH CARE 300 PASTEUR DRIVE STANFORD CA 94305 SANTA CLARA (650) 723-5708 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.4331380 -122.1766640 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-v6r4_6jzv~q6hb 50441 662344 2019-05-21 2018-08-31 380 59 8       447 30             477
2824 2824 MEDICAL CITY MCKINNEY 4500 MEDICAL CENTER DRIVE MCKINNEY TX 75069 COLLIN (972) 547-8000 Acute Care Hospitals Proprietary TRUE 33.1598420 -96.6355030 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-6zuh~kh9r.qkdr 450403 662606 2019-10-16 2018-08-31 133 16       7 156 63 15           234
2825 2825 BON SECOURS MEMORIAL REGIONAL MEDICAL CENTER 8260 ATLEE ROAD MECHANICSVILLE VA 23116 HANOVER (804) 764-6000 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.6293520 -77.3881020 0   85 51 51085 40060   Central Hanover County https://data.medicare.gov/resource/xubh-q36u/row-h5ac-vvhg_ak78 490069 660059 2019-05-14 2018-08-31 200 24         224               224
2873 2873 BON SECOURS ST MARYS HOSPITAL 5801 BREMO RD RICHMOND VA 23226 RICHMOND CITY (804) 285-2011 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.5844050 -77.5132620 0   87 51 51087 40060   Central Henrico County https://data.medicare.gov/resource/xubh-q36u/row-w7z5~9vmx.i87w 490059 659904 2019-01-30 2018-08-31 285 64 8     21 378 32             410
2889 2889 EMORY UNIVERSITY HOSPITAL 1364 CLIFTON ROAD, NE ATLANTA GA 30322 DE KALB (404) 686-8500 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.7918810 -84.3209770 0   89 13 13089 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central DeKalb County https://data.medicare.gov/resource/xubh-q36u/row-hinc~x4g8_wtfn 110010 662509 2019-06-07 2018-08-31 359 114 14       577 44 1           622
2891 2891 DELNOR COMMUNITY HOSPITAL 300 RANDALL RD GENEVA IL 60134 KANE (630) 208-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8863450 -88.3404140 0   89 17 17089 16980 Chicago-Naperville, IL-IN-WI Central Kane County https://data.medicare.gov/resource/xubh-q36u/row-2nnq_hi63-xbm2 140211 657805 2019-02-04 2018-08-31 124 20         144               144
2906 2906 OUR LADY OF BELLEFONTE HOSPITAL 1000 SAINT CHRISTOPHER DRIVE ASHLAND KY 41101 BOYD (606) 833-3600 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.5093030 -82.6930500 0   89 21 21089 26580 Charleston-Huntington-Ashland, WV-OH-KY Central Greenup County https://data.medicare.gov/resource/xubh-q36u/row-z22m~jns9.wzpj 180036 660996 2019-01-25 2018-08-31 123 12         135 16             151
3018 3018 PARKWEST MEDICAL CENTER 9352 PARK WEST BLVD KNOXVILLE TN 37923 KNOX (865) 970-9800 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.9178060 -84.1011500 0   93 47 47093 28940 Knoxville-Morristown-Sevierville, TN Central Knox County https://data.medicare.gov/resource/xubh-q36u/row-hsvd~t42h_656k 440173 658852 2019-01-28 2018-08-31 368 30         398 16             414
3093 3093 NORTHWESTERN LAKE FOREST HOSPITAL 1000 N WESTMORELAND ROAD LAKE FOREST IL 60045 LAKE (847) 234-5600 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.2591340 -87.8663270 0   97 17 17097 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-ggk4~2g65.vscr 140130 657773 2019-02-04 2018-08-31 102 12         114               114
3294 3294 RAPPAHANNOCK GENERAL HOSPITAL 101 HARRIS ROAD KILMARNOCK VA 22482 LANCASTER (804) 435-8000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.7002900 -76.3897780 0   103 51 51103         https://data.medicare.gov/resource/xubh-q36u/row-ft5v.4v76~xrcw 491308 642300 2019-01-31 2018-08-31 25           25 10             35
3340 3340 PUTNAM COMMUNITY MEDICAL CENTER 611 ZEAGLER DR PALATKA FL 32177 PUTNAM (386) 326-8500 Acute Care Hospitals Proprietary TRUE 29.6423780 -81.6935180 0   107 12 12107 37260 Jacksonville-St. Marys-Palatka, FL-GA Central Putnam County https://data.medicare.gov/resource/xubh-q36u/row-vwvn~hmhe~b5i4 100232 656921 2019-02-01 2018-08-31 89 10         99               99
3345 3345 BAPTIST HEALTH MADISONVILLE 900 HOSPITAL DRIVE MADISONVILLE KY 42431 HOPKINS (270) 825-5100 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3391770 -87.4938450 0   107 21 21107 31580   Central Hopkins County https://data.medicare.gov/resource/xubh-q36u/row-zhzt~n7d3_rubk 180093 655628 2019-10-16 2018-08-31 118 19       6 143 18 12           173
3362 3362 MARSHFIELD MEDICAL CENTER - LADYSMITH 900 COLLEGE AVE WEST LADYSMITH WI 54848 RUSK (715) 532-5561 Critical Access Hospitals Government - Local TRUE 45.4556050 -91.1111300 0   107 55 55107         https://data.medicare.gov/resource/xubh-q36u/row-bp7n_sbwx-c86k 521328 642554 2019-02-05 2018-08-31 21 4         25               25
3431 3431 BAPTIST HEALTH LOUISVILLE 4000 KRESGE WAY LOUISVILLE KY 40207 JEFFERSON (502) 897-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.2392350 -85.6390480 0   111 21 21111 31140 Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-437i-2gjr-ik7q 180130 655906 2019-10-07 2018-08-31 430 20 18       468 22 29           519
3492 3492 UT SOUTHWESTERN UNIVERSITY HOSPITAL-ZALE LIPSHY 5151 HARRY HINES BLVD DALLAS TX 75390 DALLAS (214) 879-3758 Acute Care Hospitals Government - State FALSE 32.8106928 -96.8368900 1 ROOFTOP 113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-x8yt-bzir~q2t5 450766 656547 2019-08-22 2018-08-31 74 20         94 18 36           148
3501 3501 UT SOUTHWESTERN UNIVERSITY HOSPITAL 6201 HARRY HINES BLVD DALLAS TX 75390 DALLAS (214) 633-5555 Acute Care Hospitals Government - State TRUE 32.8193657 -96.8488409 1 ROOFTOP 113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-8x4y~icku-nwfq 450044 662594 2019-08-22 2018-08-31 357 72         459               459
3518 3518 ST MARYS REGIONAL MEDICAL CENTER 1808 WEST MAIN STREET RUSSELLVILLE AR 72801 POPE (479) 968-2841 Acute Care Hospitals Proprietary TRUE 35.2828600 -93.1499080 0   115 5 5115 40780   Central Pope County https://data.medicare.gov/resource/xubh-q36u/row-wrry_g52x-fh3u 40041 656860 2019-02-14 2018-08-31 126 11         137   20           157
3629 3629 SAINT JOSEPH'S HOSPITAL OF ATLANTA, INC 5665 PEACHTREE DUNWOODY ROAD ATLANTA GA 30342 FULTON (678) 843-5720 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.9086340 -84.3518200 0   121 13 13121 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Fulton County https://data.medicare.gov/resource/xubh-q36u/row-3xrc.3s5k.ty9w 110082 658246 2019-01-30 2018-08-31 218 41 15       274               274
3636 3636 EMORY JOHNS CREEK HOSPITAL 6325 HOSPITAL PARKWAY JOHNS CREEK GA 30097 GWINNETT (678) 474-7000 Acute Care Hospitals Proprietary TRUE 34.0674660 -84.1751870 0   121 13 13121 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Fulton County https://data.medicare.gov/resource/xubh-q36u/row-g5cz~zdac~u2t5 110230 658280 2019-01-30 2018-08-31 96 14       8 118               118
3637 3637 EMORY UNIVERSITY HOSPITAL MIDTOWN 550 PEACHTREE STREET, NE ATLANTA GA 30308 FULTON (404) 686-4411 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.7695920 -84.3851880 0   121 13 13121 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Fulton County https://data.medicare.gov/resource/xubh-q36u/row-58b7~gq39.5cwh 110078 662365 2019-02-01 2018-08-31 346 47 12   36   475               475
3681 3681 HEALTHEAST ST JOHN'S HOSPITAL 1575 BEAM AVENUE MAPLEWOOD MN 55109 RAMSEY (651) 232-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.0281310 -93.0335080 0   123 27 27123 33460 Minneapolis-St. Paul, MN-WI Central Ramsey County https://data.medicare.gov/resource/xubh-q36u/row-n84j.x6u7~juxx 240210 657897 2019-02-04 2018-08-31 164 20         184               184
3683 3683 ST JOSEPH'S HOSPITAL 45 WEST 10TH STREET SAINT PAUL MN 55102 RAMSEY (651) 232-3000 Acute Care Hospitals Voluntary non-profit - Private FALSE 44.9490620 -93.1001270 0   123 27 27123 33460 Minneapolis-St. Paul, MN-WI Central Ramsey County https://data.medicare.gov/resource/xubh-q36u/row-jhqx~egjh~tdat 240063 657875 2019-02-04 2018-08-31 149 48         197 37             239
3849 3849 EASTSIDE MEDICAL CENTER 1700 MEDICAL WAY SNELLVILLE GA 30078 GWINNETT (770) 736-2498 Acute Care Hospitals Proprietary TRUE 33.8772590 -84.0196450 0   135 13 13135 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Gwinnett County https://data.medicare.gov/resource/xubh-q36u/row-4b4x~z63q.ucqr 110192 660204 2019-01-29 2018-08-31 164 24       18 206 61 20           287
3993 3993 FALLS COMMUNITY HOSPITAL AND CLINIC 322 COLEMAN STREET MARLIN TX 76661 FALLS (254) 803-3561 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.3074700 -96.8939010 0   145 48 48145 47380   Outlying Falls County https://data.medicare.gov/resource/xubh-q36u/row-jhri.rk8a-8ujz 450348 655427 2019-01-30 2018-08-31 36           36               36
4035 4035 BAPTIST HEALTH RICHMOND 801 EASTERN BYPASS RICHMOND KY 40475 MADISON (859) 623-3131 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7317600 -84.2930780 0   151 21 21151 40080 Lexington-Fayette--Richmond--Frankfort, KY Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-ktx4-xnp7~jn5v 180049 655626 2019-08-27 2018-08-31 52 8         60               60
4089 4089 LEWISGALE HOSPITAL PULASKI 2400 LEE HIGHWAY PULASKI VA 24301 PULASKI (540) 994-8100 Acute Care Hospitals Proprietary TRUE 37.0687440 -80.7588070 0   155 51 51155 13980   Outlying Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-kn6x.gevb~kfhb 490116 655700 2019-02-01 2018-08-31 84 8         92               92
4148 4148 FREESTONE MEDICAL CENTER 125 NEWMAN ST FAIRFIELD TX 75840 FREESTONE (903) 389-1612 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.7256440 -96.1696100 0   161 48 48161         https://data.medicare.gov/resource/xubh-q36u/row-7ffj_67x5_e9my 450658 657537 2019-01-31 2018-08-31 37           37               37
4174 4174 HEALTHEAST WOODWINDS HOSPITAL 1925 WOODWINDS DRIVE WOODBURY MN 55125 WASHINGTON (651) 232-0228 Acute Care Hospitals Voluntary non-profit - Private FALSE 44.9235100 -92.9753530 0   163 27 27163 33460 Minneapolis-St. Paul, MN-WI Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-4d9n_j9un-72qy 240213 657898 2019-02-01 2018-08-31 68 18         86               86
4195 4195 TRISTAR HENDERSONVILLE MEDICAL CENTER 355 NEW SHACKLE ISLAND RD HENDERSONVILLE TN 37075 SUMNER (615) 338-1000 Acute Care Hospitals Proprietary TRUE 36.3241560 -86.6201980 0   165 47 47165 34980 Nashville-Davidson--Murfreesboro, TN Central Sumner County https://data.medicare.gov/resource/xubh-q36u/row-9pfc.sfpa.n6zn 440194 658858 2019-02-01 2018-08-31 103 20       6 129               129
4201 4201 TERRE HAUTE REGIONAL HOSPITAL 3901 S SEVENTH ST TERRE HAUTE IN 47802 VIGO (812) 232-0021 Acute Care Hospitals Proprietary TRUE 39.4196240 -87.4068370 0   167 18 18167 45460   Central Vigo County https://data.medicare.gov/resource/xubh-q36u/row-q7vh~papa_4cqp 150046 656971 2019-01-31 2018-08-31 146 18         164 19 12           195
4215 4215 UNIVERSITY OF TEXAS MEDICAL BRANCH 301 UNIVERSITY BOULEVARD GALVESTON TX 77555 GALVESTON (409) 772-1011 Acute Care Hospitals Government - State TRUE 29.3114430 -94.7762610 0   167 48 48167 26420 Houston-The Woodlands, TX Central Galveston County https://data.medicare.gov/resource/xubh-q36u/row-yg6a~8grc.bxeb 450018 658590 2019-02-01 2018-08-31 399     6 20 16 561               561
4326 4326 BAPTIST HEALTH LA GRANGE 1025 NEW MOODY LANE LA GRANGE KY 40031 OLDHAM (502) 222-5388 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.3962380 -85.3759270 0   185 21 21185 31140 Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Central Oldham County https://data.medicare.gov/resource/xubh-q36u/row-eznz.mv36_3xzu 180138 656281 2019-09-30 2018-08-31 82 8         90       30       120
4441 4441 SURGERY SPECIALTY HOSPITALS OF AMERICA SE HOUSTON 4301 B VISTA PASADENA TX 77504 HARRIS (713) 378-3000 Acute Care Hospitals Proprietary TRUE 29.6587170 -95.1781610 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-kay2.vjuc_4mr7 450831 656004 2019-02-01 2018-08-31 37           37               37
4487 4487 WASHINGTON COUNTY MEMORIAL HOSPITAL 300 HEALTH WAY POTOSI MO 63664 WASHINGTON (573) 438-5451 Critical Access Hospitals Government - Local TRUE 37.9259900 -90.7731330 0   221 29 29221         https://data.medicare.gov/resource/xubh-q36u/row-f9yf_fkru~8ynh 261308 643043 2019-01-29 2018-08-31 25           25               25
4504 4504 BAPTIST HEALTH CORBIN ONE TRILLIUM WAY CORBIN KY 40701 WHITLEY (606) 528-1212 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.9230129 -84.1202609 1 ROOFTOP 235 21 21235 30940   Central Whitley County https://data.medicare.gov/resource/xubh-q36u/row-7vtx-iqza-7wsw 180080 656279 2019-09-26 2018-08-31 238   10       248   20           268
4515 4515 BAPTIST BEAUMONT HOSPITAL 3080 COLLEGE STREET BEAUMONT TX 77701 JEFFERSON (409) 212-5012 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.0684730 -94.1202550 0   245 48 48245 13140   Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-nnpz-hcu6~mwg8 450346 662082 2019-06-04 2018-08-31 316 25         361 20 15           396
4524 4524 HAMLIN MEMORIAL HOSPITAL 632 N W SECOND STREET HAMLIN TX 79520 JONES (325) 576-3646 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.8851680 -100.1346350 0   253 48 48253 10180   Outlying Jones County https://data.medicare.gov/resource/xubh-q36u/row-t33d_rkk5~cpm5 450243 657517 2019-03-15 2018-08-31 25           25               25
4557 4557 BAYLOR SCOTT & WHITE MEDICAL CENTER - LLANO 200 W OLLIE LLANO TX 78643 LLANO (325) 247-5040 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.7433450 -98.6779960 0   299 48 48299         https://data.medicare.gov/resource/xubh-q36u/row-f5ig_zcze-hhqw 450219 657514 2019-03-04 2018-08-31 25           25               25
4558 4558 WASHINGTON COUNTY REGIONAL MEDICAL CENTER 610 SPARTA ROAD SANDERSVILLE GA 31082 WASHINGTON (478) 240-2100 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.9968170 -82.8050420 0   303 13 13303         https://data.medicare.gov/resource/xubh-q36u/row-2tqu-phgw~rfp2 110086 658248 2019-02-01 2018-08-31 56           56       60       116
4567 4567 BAYLOR SCOTT & WHITE MEDICAL CENTER HILLCREST 100 HILLCREST MEDICAL BLVD WACO TX 76712 MC LENNAN (254) 202-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.4892120 -97.1568040 0   309 48 48309 47380   Central McLennan County https://data.medicare.gov/resource/xubh-q36u/row-akp7_94sn-823t 450101 660713 2019-01-30 2018-08-31 158 12 12     30 212   24           236
4597 4597 CORPUS CHRISTI MEDICAL CENTER,THE 6629 WOODRIDGE ROAD CORPUS CHRISTI TX 78414 NUECES (361) 761-1501 Acute Care Hospitals Proprietary FALSE 27.6816440 -97.3592840 0   355 48 48355 18580 Corpus Christi-Kingsville-Alice, TX Central Nueces County https://data.medicare.gov/resource/xubh-q36u/row-ucbp~a56a_ytw8 450788 662615 2019-08-08 2018-08-31 335 33       16 384 17 15           416
4598 4598 DRISCOLL CHILDRENS HOSPITAL 3533 S ALAMEDA BOX 6530 CORPUS CHRISTI TX 78411 NUECES (361) 739-4846 Childrens Voluntary non-profit - Private TRUE 27.7488804 -97.3863616 1 ROOFTOP 355 48 48355 18580 Corpus Christi-Kingsville-Alice, TX Central Nueces County https://data.medicare.gov/resource/xubh-q36u/row-q6ns-86wd.av5n 453301 650786 2019-06-25 2018-08-31 101 20       41 162               162
4626 4626 UNIVERSITY OF TEXAS HEALTH SCIENCE CENTER AT TYLER 11937 US HIGHWAY 271 TYLER TX 75708 SMITH (903) 877-7777 Acute Care Hospitals Government - State TRUE 32.4236900 -95.2092910 0   423 48 48423 46340 Tyler-Jacksonville, TX Central Smith County https://data.medicare.gov/resource/xubh-q36u/row-t9fk_pkzk_23zc 450690 662612 2019-02-01 2018-08-31 90 14         104 26             130
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
4665 4665 SAN ANGELO COMMUNITY MEDICAL CENTER 3501 KNICKERBOCKER ROAD SAN ANGELO TX 76904 TOM GREEN (325) 949-9511 Acute Care Hospitals Proprietary TRUE 31.4200760 -100.4701320 0   451 48 48451 41660   Central Tom Green County https://data.medicare.gov/resource/xubh-q36u/row-m9tt.p6fs.emne 450340 657988 2019-02-01 2018-08-31 113 12         131               131
4714 4714 BON SECOURS HOSPITAL 2000 W BALTIMORE STREET BALTIMORE MD 21223 BALTIMORE CITY (410) 362-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.2880270 -76.6486330 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-kez9_uu6c.6us7 210013 656441 2019-01-30 2018-08-31 61 8         69               69
4747 4747 MARY IMMACULATE HOSPITAL 2 BERNARDINE DRIVE NEWPORT NEWS VA 23602 NEWPORT NEWS CITY (757) 886-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.1430060 -76.5131200 0   700 51 51700 47260 Virginia Beach-Norfolk, VA-NC Central Newport News city https://data.medicare.gov/resource/xubh-q36u/row-2hzs_hzm9_tfgj 490041 655855 2019-01-30 2018-08-31 105 10         115       115       230
4748 4748 BON SECOURS DEPAUL MEDICAL CENTER 150 KINGSLEY LANE NORFOLK VA 23505 NORFOLK CITY (757) 889-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.8984300 -76.2816440 0   710 51 51710 47260 Virginia Beach-Norfolk, VA-NC Central Norfolk city https://data.medicare.gov/resource/xubh-q36u/row-ubea_vx6v~i87a 490011 660058 2019-01-30 2018-08-31 87 23         110       23       133
4755 4755 BON SECOURS MARYVIEW MEDICAL CENTER 3636 HIGH STREET PORTSMOUTH VA 23707 PORTSMOUTH CITY (757) 398-2200 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.8362110 -76.3483650 0   740 51 51740 47260 Virginia Beach-Norfolk, VA-NC Central Portsmouth city https://data.medicare.gov/resource/xubh-q36u/row-y6rs~xnvx.czh5 490017 661116 2019-01-30 2018-08-31 193 22         215   17   120       352
4757 4757 CJW MEDICAL CENTER 7101 JAHNKE ROAD RICHMOND VA 23235 CHESTERFIELD (804) 320-3911 Acute Care Hospitals Proprietary TRUE 37.5158320 -77.5248800 0   760 51 51760 40060   Central Richmond city https://data.medicare.gov/resource/xubh-q36u/row-56mf_jbhx~d74w 490112 659017 2019-02-01 2018-08-31 487 78 12     35 612 137 44           793
4758 4758 BON SECOURS RICHMOND COMMUNITY HOSPITAL 1500 N. 28TH STREET RICHMOND VA 23223 RICHMOND CITY (804) 225-1700 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.5402640 -77.4062710 0   760 51 51760 40060   Central Richmond city https://data.medicare.gov/resource/xubh-q36u/row-u4ut_ajsp~fisc 490094 655344 2019-01-15 2018-08-31 96 5         101               101

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