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

305 rows where "filed_date" is on date 2019-12-02

View and edit SQL

filed_date (date)

  • 2019-12-02 · 205
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
1273 SUBURBAN HOSPITAL 8600 OLD GEORGETOWN ROAD BETHESDA MD 20814 MONTGOMERY (301) 896-2576 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9972510 -77.1092200 0   31 24 24031 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-uvne-wnpr_kg8h 210022 661003 2019-12-02 2019-06-30 189 24 5       233               233
1274 HOLY CROSS HOSPITAL 1500 FOREST GLEN ROAD SILVER SPRING MD 20910 MONTGOMERY (301) 754-7000 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.0160550 -77.0341980 0   31 24 24031 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-nztz.3ybb.dqym 210004 659967 2019-12-02 2019-06-30 349 46       46 441               441
1283 INCLINE VILLAGE HEALTH CENTER 880 ALDER STREET INCLINE VILLAGE NV 89451 WASHOE (775) 833-4100 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2509450 -119.9538610 0   31 32 32031 39900 Reno-Carson City-Fernley, NV Central Washoe County https://data.medicare.gov/resource/xubh-q36u/row-xavt.4jau_b7jd 291301 660260 2019-12-02 2019-06-30 4           4               4
1297 COMANCHE COUNTY MEMORIAL HOSPITAL 3401 WEST GORE BLVD LAWTON OK 73505 COMANCHE (580) 355-8620 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6089690 -98.4344970 0   31 40 40031 30020   Central Comanche County https://data.medicare.gov/resource/xubh-q36u/row-wn8v~6wq8.gvxz 370056 660281 2019-12-02 2019-06-30 128 20 39       187 12 30           229
1324 OUR LADY OF THE LAKE REGIONAL MEDICAL CENTER 5000 HENNESSY BLVD BATON ROUGE LA 70808 E. BATON ROUGE (225) 765-6565 Acute Care Hospitals Voluntary non-profit - Church TRUE 30.4013180 -91.1115280 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-fxjt_dffw~6nnz 190064 661187 2019-12-02 2019-06-30 660 43     24   773 70 33           876
1332 UMD PRINCE GEORGE'S HOSPITAL CTR 3001 HOSPITAL DRIVE CHEVERLY MD 20785 PRINCE GEORGES (301) 618-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9309230 -76.9226380 0   33 24 24033 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Prince George's County https://data.medicare.gov/resource/xubh-q36u/row-prg3-xhqq-i78z 210003 661527 2019-12-02 2019-06-30 323 34 10     15 382               382
1352 PENN HIGHLANDS DUBOIS 100 HOSPITAL AVENUE DUBOIS PA 15801 CLEARFIELD (814) 371-2200 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.1143490 -78.7757360 0   33 42 42033 20180 State College-DuBois, PA Central Clearfield County https://data.medicare.gov/resource/xubh-q36u/row-sdwi.9s2j~tfd8 390086 661632 2019-12-02 2019-06-30 158 15 12     16 201   15           216
1353 PENN HIGHLANDS CLEARFIELD 809 TURNPIKE AVE CLEARFIELD PA 16830 CLEARFIELD (814) 768-2497 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.0330120 -78.4499990 0   33 42 42033 20180 State College-DuBois, PA Central Clearfield County https://data.medicare.gov/resource/xubh-q36u/row-qnyy~yhz4~b6dj 390052 660292 2019-12-02 2019-06-30 40           40 10             50
1376 SHERIDAN MEMORIAL HOSPITAL 1401 W 5TH ST SHERIDAN WY 82801 SHERIDAN (307) 672-1044 Acute Care Hospitals Government - Local TRUE 44.8074250 -106.9755700 0   33 56 56033 43260   Central Sheridan County https://data.medicare.gov/resource/xubh-q36u/row-kh7n.rjz9.bakb 530006 661690 2019-12-02 2019-06-30 60 11         71               71
1403 CATAWBA VALLEY MEDICAL CENTER 810 FAIRGROVE CHURCH RD HICKORY NC 28602 CATAWBA (828) 326-3809 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.7111950 -81.2647790 0   35 37 37035 25860 Hickory-Lenoir, NC Central Catawba County https://data.medicare.gov/resource/xubh-q36u/row-yi2j.csdp-b8zf 340143 661370 2019-12-02 2019-06-30 172 28         200 38 20           258
1516 USC VERDUGO HILLS HOSPITAL 1812 VERDUGO BLVD GLENDALE CA 91209 LOS ANGELES (818) 790-7100 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.2056140 -118.2160480 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-wr7c_jjf9_hfgj 50124 661285 2019-12-02 2019-06-30 104 12         123 24     18       165
1517 SAN GABRIEL VALLEY MEDICAL CENTER 438 W LAS TUNAS DRIVE SAN GABRIEL CA 91776 LOS ANGELES (626) 289-5454 Acute Care Hospitals Proprietary TRUE 34.1024610 -118.1055720 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-vsyy.e66v~akjm 50132 660490 2019-12-02 2019-06-30 156 19         187 42     44       273
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
1520 ANTELOPE VALLEY HOSPITAL 1600 W AVE J LANCASTER CA 93534 LOS ANGELES (661) 949-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6893710 -118.1584760 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-jtig~5whv~hgpp 50056 660914 2019-12-02 2019-06-30 345 21         393               393
1537 MEMORIAL HOSPITAL AND HEALTH CARE CENTER 800 W 9TH ST JASPER IN 47546 DUBOIS (812) 996-2345 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.3937430 -86.9412810 0   37 18 18037 27540   Central Dubois County https://data.medicare.gov/resource/xubh-q36u/row-znqj_58gv~pyf2 150115 660942 2019-12-02 2019-06-30 85 26         111 19 8   14       152
1549 CHI HEALTH SCHUYLER 104 WEST 17TH ST SCHUYLER NE 68661 COLFAX (402) 352-2441 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4545790 -97.0597250 0   37 31 31037         https://data.medicare.gov/resource/xubh-q36u/row-jpni~j9gv~awkb 281323 661039 2019-12-02 2019-06-30 25           25               25
1569 METRO NASHVILLE GENERAL HOSPITAL 1818 ALBION STREET NASHVILLE TN 37208 DAVIDSON (615) 341-4490 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.1661350 -86.8063270 0   37 47 47037 34980 Nashville-Davidson--Murfreesboro, TN Central Davidson County https://data.medicare.gov/resource/xubh-q36u/row-a69p-t6hu-kymt 440111 661105 2019-12-02 2019-06-30 82 22         114               114
1577 MEMORIAL HOSPITAL SWEETWATER COUNTY 1200 COLLEGE DRIVE ROCK SPRINGS WY 82901 SWEETWATER (307) 362-3711 Acute Care Hospitals Government - Local TRUE 41.5840600 -109.2335780 0   37 56 56037 40540   Central Sweetwater County https://data.medicare.gov/resource/xubh-q36u/row-x7m7_kvh5~qmi2 530011 661448 2019-12-02 2019-06-30 48 10         58               58
1584 FLORIDA STATE HOSPITAL UNIT 31 MED 100 N MAIN ST CHATTAHOOCHEE FL 32324 GADSDEN (850) 663-7536 Acute Care Hospitals Government - State FALSE 30.7068990 -84.8425840 0   39 12 12039 45220 Tallahassee-Bainbridge, FL-GA Outlying Gadsden County https://data.medicare.gov/resource/xubh-q36u/row-kyk8-9a3q-5siu 100298 660194 2019-12-02 2019-06-30 24           24 34         1172   1230
1608 PEACE HARBOR MEDICAL CENTER 400 9TH STREET FLORENCE OR 97439 LANE (541) 997-8412 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.9745890 -124.1174640 0   39 41 41039 21660   Central Lane County https://data.medicare.gov/resource/xubh-q36u/row-3bhj~d2nf.qxkv 381316 662244 2019-12-02 2019-06-30 21           21               21
1617 BRAZOSPORT REGIONAL HEALTH SYSTEM 100 MEDICAL DRIVE LAKE JACKSON TX 77566 BRAZORIA (979) 297-4411 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.0300910 -95.4513880 0   39 48 48039 26420 Houston-The Woodlands, TX Central Brazoria County https://data.medicare.gov/resource/xubh-q36u/row-nrnz.52dm-eixj 450072 662261 2019-12-02 2019-06-30 72 8         80   14           94
1648 UMD SHORE MEDICAL CENTER AT EASTON 219 SOUTH WASHINGTON STREET EASTON MD 21601 TALBOT (410) 822-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7696550 -76.0758250 0   41 24 24041 20660 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Talbot County https://data.medicare.gov/resource/xubh-q36u/row-hgge-45hm_jihc 210037 660392 2019-12-02 2019-06-30 146 16         162               162
1655 ST LUKE'S WARREN HOSPITAL 185 ROSEBERRY ST PHILLIPSBURG NJ 8865 WARREN (908) 847-6700 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.7016280 -75.1796080 0   41 34 34041 10900 New York-Newark, NY-NJ-CT-PA Central Warren County https://data.medicare.gov/resource/xubh-q36u/row-vn4g.2enr-g87r 310060 660263 2019-12-02 2019-06-30 80 12         92               92
1660 INTEGRIS GROVE HOSPITAL 1001 EAST 18TH STREET GROVE OK 74344 DELAWARE (918) 786-2243 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.5800860 -94.7572590 0   41 40 40041         https://data.medicare.gov/resource/xubh-q36u/row-sxxq.2snt_q3gw 370113 660140 2019-12-02 2019-06-30 52 6         58               58
1665 CARLISLE REGIONAL MEDICAL CENTER 361 ALEXANDER SPRING ROAD CARLISLE PA 17015 CUMBERLAND (717) 249-1212 Acute Care Hospitals Proprietary TRUE 40.1847670 -77.2230070 0   41 42 42041 25420 Harrisburg-York-Lebanon, PA Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-6ch7-p7nq-3tnd 390058 661966 2019-12-02 2019-06-30 56 10         66   14           80
1682 JOHN C FREMONT HEALTHCARE DISTRICT 5189 HOSPITAL ROAD MARIPOSA CA 95338 MARIPOSA (209) 966-3631 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.5005310 -119.9769480 0   43 6 6043         https://data.medicare.gov/resource/xubh-q36u/row-fty8~tgqe.f5tj 51304 661465 2019-12-02 2019-06-30 18           18       16   1   35
1686 ELMHURST MEMORIAL HOSPITAL 155 EAST BRUSH HILL ROAD ELMHURST IL 60126 DU PAGE (331) 221-0130 Acute Care Hospitals Proprietary TRUE 41.8616840 -87.9342950 0   43 17 17043 16980 Chicago-Naperville, IL-IN-WI Central DuPage County https://data.medicare.gov/resource/xubh-q36u/row-bbi9~mwsc~myn8 140200 661499 2019-12-02 2019-06-30 247 35         282               282
1687 EDWARD HOSPITAL 801 SOUTH WASHINGTON NAPERVILLE IL 60540 DU PAGE (630) 527-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7614260 -88.1492390 0   43 17 17043 16980 Chicago-Naperville, IL-IN-WI Central DuPage County https://data.medicare.gov/resource/xubh-q36u/row-vkfe~uqkg~c8wd 140231 661315 2019-12-02 2019-06-30 229 25 22     22 298               298
1693 GUTTENBERG MUNICIPAL HOSPITAL 200 MAIN STREET GUTTENBERG IA 52052 CLAYTON (563) 252-1121 Critical Access Hospitals Government - Local TRUE 42.7855480 -91.0999540 0   43 19 19043         https://data.medicare.gov/resource/xubh-q36u/row-9vtm.kuer.r3a9 161312 660958 2019-12-02 2019-06-30 25           25               25
1696 MERITUS MEDICAL CENTER 11116 MEDICAL CAMPUS ROAD HAGERSTOWN MD 21742 WASHINGTON (240) 313-9500 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.6237640 -77.6833440 0   43 24 24043 25180 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-p4kn~rbj2.3iii 210001 660817 2019-12-02 2019-06-30 237 17         254               254
1706 PINNACLE HEALTH HOSPITALS 409 SOUTH SECOND STREET HARRISBURG PA 17105 DAUPHIN (717) 782-5181 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.2562580 -76.8753290 0   43 42 42043 25420 Harrisburg-York-Lebanon, PA Central Dauphin County https://data.medicare.gov/resource/xubh-q36u/row-ciar-qnzv_q7gb 390067 660439 2019-12-02 2019-06-30 433 20 11     29 493               493
1725 MENDOCINO COAST DISTRICT HOSPITAL 700 RIVER DR FORT BRAGG CA 95437 MENDOCINO (707) 961-1234 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.4326130 -123.8007970 0   45 6 6045 46380   Central Mendocino County https://data.medicare.gov/resource/xubh-q36u/row-rw6t.w3x2~jyq9 51325 661292 2019-12-02 2019-06-30 21 4         25               25
1740 EATON RAPIDS MEDICAL CENTER 1500 S MAIN STREET EATON RAPIDS MI 48827 EATON (517) 663-2671 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.4960210 -84.6575390 0   45 26 26045 29620 Lansing-East Lansing-Owosso, MI Central Eaton County https://data.medicare.gov/resource/xubh-q36u/row-ezfk_mmvd_s7mp 231324 661021 2019-12-02 2019-06-30 20           20               20
1753 SAINT ALPHONSUS MEDICAL CENTER - ONTARIO, INC 351 SW 9TH STREET ONTARIO OR 97914 MALHEUR (541) 881-7000 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.0254480 -116.9751330 0   45 41 41045 36620 Boise City-Mountain Home-Ontario, ID-OR Central Malheur County https://data.medicare.gov/resource/xubh-q36u/row-pp3w.967e-e52h 380052 661085 2019-12-02 2019-06-30 36 8         44               44
1772 VAUGHAN REGIONAL MEDICAL CENTER PARKWAY CAMPUS 1015 MEDICAL CENTER PARKWAY SELMA AL 36701 DALLAS (334) 418-4100 Acute Care Hospitals Proprietary TRUE 32.4302480 -87.0551740 0   47 1 1047 42820   Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-yhen~7fx5~f9rk 10118 660350 2019-12-02 2019-06-30 86 23         109               109
1779 CRAWFORD COUNTY MEMORIAL HOSPITAL 100 MEDICAL PARKWAY DENISON IA 51442 CRAWFORD (712) 265-2500 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.0232570 -95.3770860 0   47 19 19047         https://data.medicare.gov/resource/xubh-q36u/row-9ydn-ts52-gjkc 161369 660986 2019-12-02 2019-06-30 25           25               25
1791 NORTH KANSAS CITY HOSPITAL 2800 CLAY EDWARDS DRIVE NORTH KANSAS CITY MO 64116 CLAY (816) 691-2000 Acute Care Hospitals Government - Local TRUE 39.1508100 -94.5518520 0   47 29 29047 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-jpk9.5ekq~fxuy 260096 661210 2019-12-02 2019-06-30 211 14 138       363   48           411
1794 GOTHENBURG MEMORIAL HOSPITAL 910 20TH ST GOTHENBURG NE 69138 DAWSON (308) 537-3661 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.9381320 -100.1533520 0   47 31 31047 30420   Central Dawson County https://data.medicare.gov/resource/xubh-q36u/row-dgzd-a44k.k83g 281313 661037 2019-12-02 2019-06-30 12           12               12
1815 SALEM HOSPITAL 890 OAK STREET, SE SALEM OR 97301 MARION (503) 561-5200 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.9328870 -123.0331460 0   47 41 41047 41420 Portland-Vancouver-Salem, OR-WA Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-gawf~xgxy_ivy2 380051 662068 2019-12-02 2019-06-30 334 60       27 421 25 24           470
1824 WELCH COMMUNITY HOSPITAL 454 MCDOWELL STREET WELCH WV 24801 MC DOWELL (304) 436-8461 Acute Care Hospitals Government - State TRUE 37.4388220 -81.5892950 0   47 54 54047         https://data.medicare.gov/resource/xubh-q36u/row-y7rn~73h2.fggs 510086 661439 2019-12-02 2019-06-30 42 7         49         59     108
1827 FULTON COUNTY HOSPITAL 679 NORTH MAIN STREET SALEM AR 72576 FULTON (870) 895-2691 Critical Access Hospitals Voluntary non-profit - Other TRUE 36.3833590 -91.8112030 0   49 5 5049         https://data.medicare.gov/resource/xubh-q36u/row-9b6n-wd2m.b7tm 41322 660913 2019-12-02 2019-06-30 25           25               25
1834 ST ANTHONYS MEMORIAL HOSPITAL 503 N MAPLE STREET EFFINGHAM IL 62401 EFFINGHAM (217) 342-2121 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.1244960 -88.5492740 0   49 17 17049 20820   Central Effingham County https://data.medicare.gov/resource/xubh-q36u/row-se8h.a4r7-s6mp 140032 661718 2019-12-02 2019-06-30 123 10         133               133
1836 DALLAS COUNTY HOSPITAL 610 TENTH STREET PERRY IA 50220 DALLAS (515) 465-3547 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.8339590 -94.0944690 0   49 19 19049 19780 Des Moines-Ames-West Des Moines, IA Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-5ca8_jqfe~mw9b 161322 660961 2019-12-02 2019-06-30 25           25               25
1869 SAINT VINCENT HOSPITAL 232 WEST 25TH STREET ERIE PA 16544 ERIE (814) 452-5111 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.1107080 -80.0799320 0   49 42 42049 21500 Erie-Meadville, PA Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-zzmm~9qqm.5743 390009 661964 2019-12-02 2019-06-30 237 20 20     21 298 10 22           330
1871 MILLCREEK COMMUNITY HOSPITAL 5515 PEACH STREET ERIE PA 16509 ERIE (814) 864-4031 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0741410 -80.0937350 0   49 42 42049 21500 Erie-Meadville, PA Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-7pay_34ik.2q7y 390198 660148 2019-12-02 2019-06-30 124 6         130 23 14           167
1872 LECOM HEALTH CORRY MEMORIAL HOSPITAL 965 SHAMROCK LANE CORRY PA 16407 ERIE (814) 664-4641 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.9353790 -79.6128910 0   49 42 42049 21500 Erie-Meadville, PA Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-pwex-5ih7_humz 391308 660305 2019-12-02 2019-06-30 20           20               20
1889 CHI ST. VINCENT HOSPITAL HOT SPRINGS 300 WERNER STREET HOT SPRINGS AR 71903 GARLAND (501) 622-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.4660350 -93.0663960 0   51 5 5051 26300 Hot Springs-Malvern, AR Central Garland County https://data.medicare.gov/resource/xubh-q36u/row-pyjq_z3nz-ckdj 40026 662146 2019-12-02 2019-06-30 204 25         229               229
1907 MIDMICHIGAN MEDICAL CENTER-GLADWIN 515 QUARTER STREET GLADWIN MI 48624 GLADWIN (989) 426-9286 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.9757310 -84.4953540 0   51 26 26051         https://data.medicare.gov/resource/xubh-q36u/row-mi7y.a5rw~xqzh 231325 661022 2019-12-02 2019-06-30 25           25               25
1911 CAPITAL REGION MEDICAL CENTER 1125 MADISON ST JEFFERSON CITY MO 65102 COLE (573) 632-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.5670180 -92.1815880 0   51 29 29051 27620   Central Cole County https://data.medicare.gov/resource/xubh-q36u/row-kiwj~2ugv_esmv 260047 661208 2019-12-02 2019-06-30 88 12         100   14           114
1917 ASHLEY MEDICAL CENTER 612 CENTER AVENUE N ASHLEY ND 58413 MCINTOSH (701) 288-3433 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.0401880 -99.3717150 0   51 38 38051         https://data.medicare.gov/resource/xubh-q36u/row-ecd4.9q4x_twgv 351322 661581 2019-12-02 2019-06-30 20           20       40       60
1927 UNIONTOWN HOSPITAL 500 WEST BERKELEY STREET UNIONTOWN PA 15401 FAYETTE (724) 430-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.9019960 -79.7376190 0   51 42 42051 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Outlying Fayette County https://data.medicare.gov/resource/xubh-q36u/row-4jjp-v8ik-skbv 390041 660291 2019-12-02 2019-06-30 134 15         149   11           160
1950 DECATUR COUNTY HOSPITAL 1405 NW CHURCH STREET LEON IA 50144 DECATUR (641) 446-4871 Critical Access Hospitals Government - Local TRUE 40.7503080 -93.7477890 0   53 19 19053         https://data.medicare.gov/resource/xubh-q36u/row-z8pk.dm9q_4faw 161340 660972 2019-12-02 2019-06-30 11           11               11
1971 SALEM HEALTH WEST VALLEY 525 SE WASHINGTON STREET DALLAS OR 97338 POLK (503) 623-8301 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9194040 -123.3103830 0   53 41 41053 41420 Portland-Vancouver-Salem, OR-WA Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-urpw.pi4k_vkp4 381308 660286 2019-12-02 2019-06-30 15           15               15
2023 CHI HEALTH LAKESIDE 16901 LAKESIDE HILLS CT OMAHA NE 68130 DOUGLAS (402) 717-8167 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.2390400 -96.1805320 0   55 31 31055 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-m36s-dsun.h9q7 280130 661035 2019-12-02 2019-06-30 92 16         108               108
2024 CHI HEALTH CREIGHTON UNIVERSITY MEDICAL CENTER - B 7500 MERCY RD OMAHA NE 68124 DOUGLAS (402) 398-6060 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2379040 -96.0287170 0   55 31 31055 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-8r2j-deyz-snt5 280060 661548 2019-12-02 2019-06-30 297 52         385               385
2043 BLUEFIELD REGIONAL MEDICAL CENTER 500 CHERRY ST BLUEFIELD WV 24701 MERCER (304) 327-1100 Acute Care Hospitals Proprietary TRUE 37.2575170 -81.2341290 0   55 54 54055 14140   Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-kbzt.t9ci.vaxk 510071 660728 2019-12-02 2019-06-30 40 17         57               57
2069 CUMBERLAND COUNTY HOSPITAL 299 GLASGOW ROAD BURKESVILLE KY 42717 CUMBERLAND (270) 864-2511 Critical Access Hospitals Government - Local TRUE 36.7968680 -85.3724400 0   57 21 21057         https://data.medicare.gov/resource/xubh-q36u/row-ptk2_m6d2-xzym 181317 661512 2019-12-02 2019-06-30 25           25               25
2085 HARMON MEMORIAL HOSPITAL 400 EAST CHESTNUT STREET HOLLIS OK 73550 HARMON (580) 688-3363 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.6915370 -99.9143660 0   57 40 40057         https://data.medicare.gov/resource/xubh-q36u/row-uie3-brwx.iwxd 371338 661083 2019-12-02 2019-06-30 22           22               22
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
2119 CHILDREN'S HOSPITAL OF ORANGE COUNTY 1201 W LA VETA AVE ORANGE CA 92868 ORANGE (714) 997-3000 Childrens Voluntary non-profit - Other FALSE 33.7803300 -117.8649600 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-tabq.iupn-ad4g 53304 661466 2019-12-02 2019-06-30 176 24         334               334
2142 HILLSDALE HOSPITAL 168 S HOWELL STREET HILLSDALE MI 49242 HILLSDALE (517) 437-4451 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9114370 -84.6317020 0   59 26 26059 25880   Central Hillsdale County https://data.medicare.gov/resource/xubh-q36u/row-y2ff~pdgn-kfin 230037 661007 2019-12-02 2019-06-30 40 4         44 10     39       93
2157 DAVIE MEDICAL CENTER 223 HOSPITAL STREET MOCKSVILLE NC 27028 DAVIE (336) 751-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.9000100 -80.5700970 0   59 37 37059 49180 Greensboro--Winston-Salem--High Point, NC Central Davie County https://data.medicare.gov/resource/xubh-q36u/row-6uy2-xp88~p8f2 340187 661371 2019-12-02 2019-06-30 18           18               18
2162 WASHINGTON HEALTH SYSTEM GREENE 350 BONAR AVENUE WAYNESBURG PA 15370 GREENE (724) 627-2602 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9006050 -80.1739290 0   59 42 42059         https://data.medicare.gov/resource/xubh-q36u/row-an6b-ia9u-kxvy 390150 662137 2019-12-02 2019-06-30 23           23               23
2220 CINCINNATI CHILDREN'S HOSPITAL MEDICAL CENTER 3333 BURNET AVENUE CINCINNATI OH 45229 HAMILTON (513) 636-3333 Childrens Voluntary non-profit - Private TRUE 39.1409470 -84.5003920 0   61 39 39061 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-jr9m~pzfs_k2mx 363300 661623 2019-12-02 2019-06-30 489 35 25       615               615
2235 MONONGALIA COUNTY GENERAL HOSPITAL 1200 JD ANDERSON DRIVE MORGANTOWN WV 26505 MONONGALIA (304) 598-1200 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.6626200 -79.9463900 0   61 54 54061 34060 Morgantown-Fairmont, WV Central Monongalia County https://data.medicare.gov/resource/xubh-q36u/row-ensb-bzkk_fjdn 510024 661437 2019-12-02 2019-06-30 163 26         189               189
2240 SENECA DISTRICT HOSPITAL 130 BRENTWOOD DRIVE CHESTER CA 96020 PLUMAS (530) 258-2121 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.3053020 -121.2340180 0   63 6 6063         https://data.medicare.gov/resource/xubh-q36u/row-6rw5.c6e6.9puv 51327 661143 2019-12-02 2019-06-30 10           10       16       26
2270 INDIANA REGIONAL MEDICAL CENTER 835 HOSPITAL ROAD INDIANA PA 15701 INDIANA (724) 357-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6086420 -79.1588910 0   63 42 42063 26860 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Indiana County https://data.medicare.gov/resource/xubh-q36u/row-i7nf_mfb9.95qu 390173 660864 2019-12-02 2019-06-30 122 12         134 16 16           166
2287 SAN GORGONIO MEMORIAL HOSPITAL 600 NORTH HIGHLAND SPRINGS AVENUE BANNING CA 92220 RIVERSIDE (951) 845-1121 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.9316874 -116.9461472 1 ROOFTOP 65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-v72w~xz4e~mtkk 50054 660165 2019-12-02 2019-06-30 55 6         61               61
2312 ROUNDUP MEMORIAL HEALTHCARE 1202 3RD ST W ROUNDUP MT 59072 MUSSELSHELL (406) 323-2301 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.4533500 -108.5463330 0   65 30 30065         https://data.medicare.gov/resource/xubh-q36u/row-4hiv-3ibs~jee7 271346 661357 2019-12-02 2019-06-30 25           25               25
2323 PUNXSUTAWNEY AREA HOSPITAL 81 HILLCREST DRIVE PUNXSUTAWNEY PA 15767 JEFFERSON (814) 938-1800 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.9601530 -79.0003590 0   65 42 42065         https://data.medicare.gov/resource/xubh-q36u/row-6q8y-is36.pc3n 390199 661098 2019-12-02 2019-06-30 39 5         44               44
2335 UNIVERSITY OF CALIFORNIA DAVIS MEDICAL CENTER 2315 STOCKTON BOULEVARD SACRAMENTO CA 95817 SACRAMENTO (916) 734-2011 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.5543750 -121.4575350 0   67 6 6067 40900 Sacramento-Roseville, CA Central Sacramento County https://data.medicare.gov/resource/xubh-q36u/row-xgsz_gz6f-5jxx 50599 662166 2019-12-02 2019-06-30 441 34   12 28 24 598   19           617
2365 NORTH CAROLINA BAPTIST HOSPITAL MEDICAL CENTER BOULEVARD WINSTON-SALEM NC 27157 FORSYTH (336) 716-2011 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0896734 -80.2713468 1 GEOMETRIC_CENTER 67 37 37067 49180 Greensboro--Winston-Salem--High Point, NC Central Forsyth County https://data.medicare.gov/resource/xubh-q36u/row-r4e3-jftf~8jdf 340047 661763 2019-12-02 2019-06-30 565 110 22 16     797 34 39           870
2370 JEFFERSON COUNTY HOSPITAL INTERSECTION HYWS 81 & 70 WAURIKA OK 73573 JEFFERSON (580) 228-2344 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1572807 -97.9795416 1 GEOMETRIC_CENTER 67 40 40067         https://data.medicare.gov/resource/xubh-q36u/row-ph4g-iebq.bzzs 371311 662416 2019-12-02 2019-06-30 25           25               25
2386 HAZEL HAWKINS MEMORIAL HOSPITAL 911 SUNSET DRIVE HOLLISTER CA 95023 SAN BENITO (831) 637-5711 Acute Care Hospitals Government - Hospital District or Authority FALSE 36.8351220 -121.3866200 0   69 6 6069 41940 San Jose-San Francisco-Oakland, CA Outlying San Benito County https://data.medicare.gov/resource/xubh-q36u/row-z5mt_ehjz~v7xh 50296 661288 2019-12-02 2019-06-30 41 8         49       119       168
2396 ST JOSEPH REGIONAL MEDICAL CENTER 415 SIXTH STREET LEWISTON ID 83501 NEZ PERCE (208) 799-5300 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.4171210 -117.0249970 0   69 16 16069 30300   Central Nez Perce County https://data.medicare.gov/resource/xubh-q36u/row-dyet_gevw~szfb 130003 662190 2019-12-02 2019-06-30 101 9         110 20             130
2459 HIGHLANDS REGIONAL MEDICAL CENTER 5000 KENTUCKY ROUTE 321 PRESTONSBURG KY 41653 FLOYD (606) 886-8511 Acute Care Hospitals Proprietary TRUE 37.7105400 -82.7702500 0   71 21 21071         https://data.medicare.gov/resource/xubh-q36u/row-iny2.6yju.g3qs 180005 662526 2019-12-02 2019-06-30 115 12         127 23             150
2478 CHI ST ALEXIUS HEALTH DEVILS LAKE 1031 7TH ST NE DEVILS LAKE ND 58301 RAMSEY (701) 662-2131 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1147740 -98.8503450 0   71 38 38071         https://data.medicare.gov/resource/xubh-q36u/row-i8ea.ub9b_eqnm 351333 662067 2019-12-02 2019-06-30 25           25               25
2486 UPMC LITITZ 1500 HIGHLANDS DRIVE LITITZ PA 17543 LANCASTER (717) 625-5670 Acute Care Hospitals Proprietary TRUE 40.1342570 -76.3094140 0   71 42 42071 29540   Central Lancaster County https://data.medicare.gov/resource/xubh-q36u/row-i9xj_phxc~h3r8 390068 661396 2019-12-02 2019-06-30 45 6         55               55
2489 HARDIN MEDICAL CENTER 935 WAYNE ROAD SAVANNAH TN 38372 HARDIN (731) 926-8121 Acute Care Hospitals Government - Local TRUE 35.2271300 -88.2303620 0   71 47 47071         https://data.medicare.gov/resource/xubh-q36u/row-2dfc~89p6~kqtc 440109 660709 2019-12-02 2019-06-30 49           49       73       122
2506 PALOMAR HEALTH DOWNTOWN CAMPUS 555 EAST VALLEY PARKWAY ESCONDIDO CA 92025 SAN DIEGO (760) 739-3000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.1259370 -117.0761860 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-75ug~bcqe_4ycp 50115 660353 2019-12-02 2019-06-30 238 48         286 25 18           329
2512 RADY CHILDREN'S HOSPITAL - SAN DIEGO 3020 CHILDRENS WAY SAN DIEGO CA 92123 SAN DIEGO (858) 576-1700 Childrens Voluntary non-profit - Other FALSE 32.7982600 -117.1508210 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-g946~ee4n.abkv 53303 660172 2019-12-02 2019-06-30 193 54       24 401         24 19   444
2518 POMERADO HOSPITAL 15615 POMERADO ROAD POWAY CA 92064 SAN DIEGO (858) 485-6511 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.9968020 -117.0578520 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-4898.b6y5.nvpq 50636 660919 2019-12-02 2019-06-30 79 12       4 95 12     129       236
2519 TRI-CITY MEDICAL CENTER 4002 VISTA WAY OCEANSIDE CA 92056 SAN DIEGO (760) 724-8411 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.1837830 -117.2909180 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-hngp~yjnr~dx2a 50128 662018 2019-12-02 2019-06-30 242 28       20 290 5 10           305
2528 GREENE COUNTY MEDICAL CENTER 1000 WEST LINCOLNWAY JEFFERSON IA 50129 GREENE (515) 386-2114 Critical Access Hospitals Government - Local TRUE 42.0152170 -94.3890600 0   73 19 19073         https://data.medicare.gov/resource/xubh-q36u/row-ekvn-6v3z_68bn 161325 660962 2019-12-02 2019-06-30 21   4       25               25
2557 LAGUNA HONDA HOSPITAL & REHABILITATION CENTER 375 LAGUNA HONDA BLVD SAN FRANCISCO CA 94116 SAN FRANCISCO (415) 759-2300 Acute Care Hospitals Government - Local FALSE 37.7478240 -122.4586360 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-tz44~vi64-ys8h 50668 662169 2019-12-02 2019-06-30 6           6   5   769       780
2589 NORTH ALABAMA MEDICAL CENTER 1701 VETERANS DRIVE FLORENCE AL 35630 LAUDERDALE (256) 768-8400 Acute Care Hospitals Proprietary TRUE 34.8027560 -87.6521910 0   77 1 1077 22520   Central Lauderdale County https://data.medicare.gov/resource/xubh-q36u/row-n9pr_q6au_cg3t 10006 660158 2019-12-02 2019-06-30 181 36 16       233               233
2594 SAN JOAQUIN GENERAL HOSPITAL 500 W HOSPITAL ROAD FRENCH CAMP CA 95231 SAN JOAQUIN (209) 468-6000 Acute Care Hospitals Government - Local TRUE 37.8864920 -121.2820610 0   77 6 6077 44700 San Jose-San Francisco-Oakland, CA Central San Joaquin County https://data.medicare.gov/resource/xubh-q36u/row-imza-7dfi-q9b9 50167 661140 2019-12-02 2019-06-30 155 16       25 196               196
2622 ST LUKE'S HOSPITAL BETHLEHEM 801 OSTRUM STREET BETHLEHEM PA 18015 NORTHAMPTON (610) 954-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6086970 -75.3925070 0   77 42 42077 10900 New York-Newark, NY-NJ-CT-PA Central Lehigh County https://data.medicare.gov/resource/xubh-q36u/row-zugg_buef.dyst 390049 660014 2019-12-02 2019-06-30 423 14 14       482 38 22           542
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
2643 ST VINCENT JENNINGS HOSPITAL INC 301 HENRY ST NORTH VERNON IN 47265 JENNINGS (812) 352-4200 Critical Access Hospitals Voluntary non-profit - Church TRUE 39.0112590 -85.6403740 0   79 18 18079 35860 Indianapolis-Carmel-Muncie, IN Central Jennings County https://data.medicare.gov/resource/xubh-q36u/row-pwb4.5pm6~qqy5 151303 660947 2019-12-02 2019-06-30 25           25               25
2652 PRAIRIE COMMUNITY HOSPITAL 312 S ADAMS TERRY MT 59349 PRAIRIE (406) 635-5511 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.7915060 -105.3159970 0   79 30 30079         https://data.medicare.gov/resource/xubh-q36u/row-cwxm-q75h-madz 271309 660253 2019-12-02 2019-06-30 22           22               22
2653 CHI HEALTH ST FRANCIS 2620 WEST FAIDLEY AVE GRAND ISLAND NE 68803 HALL (308) 384-4600 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.9242670 -98.3708870 0   79 31 31079 24260   Central Hall County https://data.medicare.gov/resource/xubh-q36u/row-rgs4_gs84~mfkz 280023 661547 2019-12-02 2019-06-30 115 16       9 140   12   34       186
2667 HENRY COUNTY MEDICAL CENTER 301 TYSON AV PARIS TN 38242 HENRY (731) 642-1220 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.2968020 -88.3112710 0   79 47 47079 37540   Central Henry County https://data.medicare.gov/resource/xubh-q36u/row-ru8t~pc2a_mnkm 440132 661107 2019-12-02 2019-06-30 55   9       64 22             86
2717 HIGH POINT REGIONAL HOSPITAL 601 N ELM ST HIGH POINT NC 27261 GUILFORD (336) 878-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.9624860 -80.0120270 0   81 37 37081 24660 Greensboro--Winston-Salem--High Point, NC Central Guilford County https://data.medicare.gov/resource/xubh-q36u/row-cqap_seaa~zbqk 340004 661368 2019-12-02 2019-06-30 256 24 8       288   16           304
2732 ATHENS LIMESTONE HOSPITAL 700 WEST MARKET STREET ATHENS AL 35611 LIMESTONE (256) 233-9292 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.8034990 -86.9778030 0   83 1 1083 26620 Huntsville-Decatur-Albertville, AL Outlying Limestone County https://data.medicare.gov/resource/xubh-q36u/row-nzdh.hdic_txkm 10079 660159 2019-12-02 2019-06-30 56 10         66               66
2738 LOMPOC VALLEY MEDICAL CENTER 1515 E OCEAN AVENUE LOMPOC CA 93436 SANTA BARBARA (805) 737-3300 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6406390 -120.4398990 0   83 6 6083 42200   Central Santa Barbara County https://data.medicare.gov/resource/xubh-q36u/row-9waa-2p9w-xqwe 50110 660915 2019-12-02 2019-06-30 54 6         60       110       170
2789 CHI HEALTH MISSOURI VALLEY 631 N 8TH ST MISSOURI VALLEY IA 51555 HARRISON (712) 642-2784 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.5629770 -95.8850960 0   85 19 19085 36540 Omaha-Council Bluffs-Fremont, NE-IA Outlying Harrison County https://data.medicare.gov/resource/xubh-q36u/row-nied-xbd5_n6bv 161309 661179 2019-12-02 2019-06-30 25           25               25
2879 HUNTSVILLE HOSPITAL 101 SIVLEY RD HUNTSVILLE AL 35801 MADISON (256) 265-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.7212260 -86.5815470 0   89 1 1089 26620 Huntsville-Decatur-Albertville, AL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-srfb_s9fq-erqf 10039 660063 2019-12-02 2019-06-30 713 42 20   25   877 35             912
2886 EMORY DECATUR HOSPITAL 2701 N DECATUR ROAD DECATUR GA 30033 DE KALB (404) 501-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.7921600 -84.2826790 0   89 13 13089 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central DeKalb County https://data.medicare.gov/resource/xubh-q36u/row-pp7m~b3m9-dt6m 110076 661305 2019-12-02 2019-06-30 318 32       42 392   30           422
2888 EMORY HILLANDALE HOSPITAL 2801 DEKALB MEDICAL PARKWAY LITHONIA GA 30058 DE KALB (404) 501-8040 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.7054880 -84.1469270 0   89 13 13089 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central DeKalb County https://data.medicare.gov/resource/xubh-q36u/row-mkqk.2abm~442s 110226 660924 2019-12-02 2019-06-30 82 8         90               90

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