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

286 rows where "filed_date" is on date 2019-11-27 sorted by skilled_nursing_beds

View and edit SQL

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_irf_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date)

  • 2019-11-27 · 286
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
12 CLARKE COUNTY HOSPITAL 800 S FILLMORE ST OSCEOLA IA 50213 CLARKE (641) 342-2184 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.0257100 -93.7675330 0   39 19 19039         https://data.medicare.gov/resource/xubh-q36u/row-xtat~vhgt.9ane 161348 660976 2019-11-27 2019-06-30 25           25               25
16 AVERA WESKOTA MEMORIAL MEDICAL CENTER - CAH 604 1ST ST NE WESSINGTON SPRINGS SD 57382 JERAULD (605) 539-1201 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0803940 -98.5636820 0   73 46 46073         https://data.medicare.gov/resource/xubh-q36u/row-pcwb-j3y8~f5au 431324 662583 2019-11-27 2019-06-30 16           16               16
19 ASCENSION ST MARYS HOSPITAL 2251 NORTH SHORE DR RHINELANDER WI 54501 ONEIDA (715) 361-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.6384820 -89.3111400 0   85 55 55085         https://data.medicare.gov/resource/xubh-q36u/row-zwaq-mmw6_zwbm 520019 661677 2019-11-27 2019-06-30 32 20         52 11             63
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
36 THAYER COUNTY HEALTH SERVICES 120 PARK AVE HEBRON NE 68370 THAYER (402) 768-6041 Critical Access Hospitals Government - Local TRUE 40.1601230 -97.5932670 0   169 31 31169         https://data.medicare.gov/resource/xubh-q36u/row-b26e~mfmy~67qg 281304 660643 2019-11-27 2019-06-30 19           19               19
70 MEDSTAR GEORGETOWN UNIVERSITY HOSPITAL 3800 RESERVOIR RD WASHINGTON DC 20007 THE DISTRICT (202) 784-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9125990 -77.0743880 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-5vf4.uxtf-sv5z 90004 661474 2019-11-27 2019-06-30 289 19     38   393               393
72 MEDSTAR WASHINGTON HOSPITAL CENTER 110 IRVING ST NW WASHINGTON DC 20010 THE DISTRICT (202) 877-7000 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9291570 -77.0122680 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-he3p~gtzx-x7j5 90011 660787 2019-11-27 2019-06-30 569 37 16   55   701 46             747
74 CHILDREN'S HOSPITAL NMC 111 MICHIGAN AVE, NW WASHINGTON DC 20010 THE DISTRICT (202) 476-5000 Childrens Voluntary non-profit - Private TRUE 38.9262730 -77.0138780 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-9kra.5epj-ue89 93300 661151 2019-11-27 2019-06-30 184 73         323               323
76 UF HEALTH SHANDS HOSPITAL 1600 SW ARCHER RD GAINESVILLE FL 32610 ALACHUA (352) 265-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.6392230 -82.3433250 0   1 12 12001 23540 Gainesville-Lake City, FL Central Alachua County https://data.medicare.gov/resource/xubh-q36u/row-6avt~6iq6-eksg 100113 661480 2019-11-27 2019-06-30 519 66 48 8 96   921 90 39           1050
101 BARRETT HOSPITAL & HEALTHCARE 600 MT HWY 91 S DILLON MT 59725 BEAVERHEAD (406) 683-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.2006540 -112.6460030 0   1 30 30001         https://data.medicare.gov/resource/xubh-q36u/row-2tkn_v7av-d2ep 271318 662223 2019-11-27 2019-06-30 18           18               18
112 ALBANY MEMORIAL HOSPITAL 600 NORTHERN BOULEVARD ALBANY NY 12204 ALBANY (518) 471-3490 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6746850 -73.7488610 0   1 36 36001 10580 Albany-Schenectady, NY Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-fbeu-trch-uemx 330003 661359 2019-11-27 2019-06-30 57 16         73               73
145 JOHN DEMPSEY HOSPITAL 263 FARMINGTON AVE FARMINGTON CT 6032 HARTFORD (860) 679-1145 Acute Care Hospitals Government - Local TRUE 41.7350900 -72.7958200 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-dhzf~ccfg~faa5 70036 661473 2019-11-27 2019-06-30 118 20         138 18             156
152 CHRISTIANA CARE HEALTH SERVICES, INC. 4755 OGLETOWN-STANTON ROAD NEWARK DE 19718 NEW CASTLE (302) 733-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.6899090 -75.6732280 0   3 10 10003 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central New Castle County https://data.medicare.gov/resource/xubh-q36u/row-4npa_3h9a~qmvr 80001 659768 2019-11-27 2019-06-30 920 73 35       1097 30 39           1166
231 OHIO VALLEY GENERAL HOSPITAL 25 HECKEL ROAD MCKEES ROCKS PA 15136 ALLEGHENY (412) 777-6161 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4724220 -80.0928730 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-fzb2.pi34_kuyu 390157 659873 2019-11-27 2019-06-30 60 27         87 21 16           124
232 ST CLAIR HOSPITAL 1000 BOWER HILL ROAD PITTSBURGH PA 15243 ALLEGHENY (412) 942-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3767750 -80.0669660 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-rf2f_7h7t~9hcu 390228 660445 2019-11-27 2019-06-30 264 12 16       303 26             329
255 FLAGSTAFF MEDICAL CENTER 1200 NORTH BEAVER STREET FLAGSTAFF AZ 86001 COCONINO (928) 779-3366 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.2095340 -111.6448350 0   5 4 4005 22380   Central Coconino County https://data.medicare.gov/resource/xubh-q36u/row-bzd3~hd4v-cg2f 30023 662010 2019-11-27 2019-06-30 183 41       18 242 22             264
321 CHI ST LUKES HEALTH MEMORIAL LUFKIN 1201 WEST FRANK STREET LUFKIN TX 75901 ANGELINA (936) 634-8111 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.3373240 -94.7424810 0   5 48 48005 31260   Central Angelina County https://data.medicare.gov/resource/xubh-q36u/row-rdm9.4ki2~5y5k 450211 660887 2019-11-27 2019-06-30 148 24         172   12           184
332 CUMBERLAND MEMORIAL HOSPITAL 1110 7TH AVENUE CUMBERLAND WI 54829 BARRON (715) 822-7500 Critical Access Hospitals Voluntary non-profit - Other TRUE 45.5309390 -92.0295920 0   5 55 55005         https://data.medicare.gov/resource/xubh-q36u/row-r4fu_4cy5~ir4d 521353 661689 2019-11-27 2019-06-30 25           25               25
356 ASSUMPTION COMMUNITY HOSPITAL 135 HIGHWAY 402 NAPOLEONVILLE LA 70390 ASSUMPTION (985) 369-3600 Critical Access Hospitals Voluntary non-profit - Private TRUE 29.9575850 -91.0338750 0   7 22 22007         https://data.medicare.gov/resource/xubh-q36u/row-smss_wf6g.wmww 191303 659796 2019-11-27 2019-06-30 15           15               15
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
452 SPEARE MEMORIAL HOSPITAL 16 HOSPITAL ROAD PLYMOUTH NH 3264 GRAFTON (603) 536-1120 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.7578860 -71.6948370 0   9 33 33009 17200   Central Grafton County https://data.medicare.gov/resource/xubh-q36u/row-tpyx~4vjq_mct4 301311 661929 2019-11-27 2019-06-30 25           25               25
460 GREAT PLAINS REGIONAL MEDICAL CENTER 1801 WEST 3RD STREET ELK CITY OK 73644 BECKHAM (580) 225-2511 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.4117210 -99.4256540 0   9 40 40009 21120   Central Beckham County https://data.medicare.gov/resource/xubh-q36u/row-ygr6~ifvk~u3j8 370019 660278 2019-11-27 2019-06-30 28 6         34 12 8           54
605 MIDDLESBORO APPALACHIAN REGIONAL HEALTHCARE HOSPIT 3600 WEST CUMBERLAND AVENUE MIDDLESBORO KY 40965 BELL (606) 242-1100 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.6051990 -83.7400560 0   13 21 21013 33180   Central Bell County https://data.medicare.gov/resource/xubh-q36u/row-ddm7.jenh~wuwk 180020 660557 2019-11-27 2019-06-30 39 7         46               46
645 UPMC ALTOONA 620 HOWARD AVENUE ALTOONA PA 16601 BLAIR (814) 889-2011 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5211420 -78.3981840 0   13 42 42013 11020   Central Blair County https://data.medicare.gov/resource/xubh-q36u/row-wkn5_wsma_rprd 390073 661248 2019-11-27 2019-06-30 303 33 8       344               344
670 KINGMAN REGIONAL MEDICAL CENTER 3269 STOCKTON HILL ROAD KINGMAN AZ 86409 MOHAVE (928) 757-2101 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.2199070 -114.0358130 0   15 4 4015 29420 Las Vegas-Henderson, NV-AZ Central Mohave County https://data.medicare.gov/resource/xubh-q36u/row-3ksp.3iej_8pd7 30055 660485 2019-11-27 2019-06-30 176 20         196   18       12   226
718 PEACEHEALTH ST JOHN MEDICAL CENTER 1615 DELAWARE STREET LONGVIEW WA 98632 COWLITZ (360) 414-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 46.1309920 -122.9411920 0   15 53 53015 31020 Portland-Vancouver-Salem, OR-WA Central Cowlitz County https://data.medicare.gov/resource/xubh-q36u/row-n4kt-b68h~5bhw 500041 662288 2019-11-27 2019-06-30 148 18         166               166
719 ASCENSION CALUMET HOSPITAL 614 MEMORIAL DRIVE CHILTON WI 53014 CALUMET (920) 849-2386 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0254390 -88.1543990 0   15 55 55015 11540 Appleton-Oshkosh-Neenah, WI Central Calumet County https://data.medicare.gov/resource/xubh-q36u/row-q97p-97ns_bxut 521317 661447 2019-11-27 2019-06-30 25           25               25
775 ESSENTIA HEALTH FARGO 3000 32ND AVE SOUTH FARGO ND 58104 CASS (701) 364-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.8325000 -96.8281060 0   17 38 38017 22020 Fargo-Wahpeton, ND-MN Central Cass County https://data.medicare.gov/resource/xubh-q36u/row-9tdc-2u7p-zr8f 350070 662238 2019-11-27 2019-06-30 89 44         133               133
781 INTEGRIS CANADIAN VALLEY HOSPITAL 1201 HEALTH CENTER PARKWAY YUKON OK 73099 CANADIAN (405) 717-6800 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.4836950 -97.7602420 0   17 40 40017 36420 Oklahoma City-Shawnee, OK Central Canadian County https://data.medicare.gov/resource/xubh-q36u/row-bfap-q9md_hknr 370211 660282 2019-11-27 2019-06-30 66 8         74               74
799 FLOYD CHEROKEE MEDICAL CENTER 400 NORTHWOOD DR CENTRE AL 35960 CHEROKEE (256) 927-5531 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1627610 -85.6514200 0   19 1 1019         https://data.medicare.gov/resource/xubh-q36u/row-wy8i.rrc6.c8zi 10022 660348 2019-11-27 2019-06-30 45           45               45
818 ORANGE PARK MEDICAL CENTER 2001 KINGSLEY AVE ORANGE PARK FL 32073 CLAY (904) 276-8500 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.1648070 -81.7385980 0   19 12 12019 27260 Jacksonville-St. Marys-Palatka, FL-GA Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-wsf2~ud7b_znaf 100226 660500 2019-11-27 2019-06-30 229 28         273 24 20           317
824 BUCHANAN COUNTY HEALTH CENTER 1600 FIRST ST EAST INDEPENDENCE IA 50644 BUCHANAN (319) 332-0999 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.4687870 -91.8750150 0   19 19 19019         https://data.medicare.gov/resource/xubh-q36u/row-cq2e.inyq-2gxf 161335 660969 2019-11-27 2019-06-30 25           25           39   64
870 ASCENSION OUR LADY OF VICTORY HOSPITAL 1120 PINE ST STANLEY WI 54768 CHIPPEWA (715) 644-5571 Critical Access Hospitals Voluntary non-profit - Other TRUE 44.9553110 -90.9205640 0   19 55 55019         https://data.medicare.gov/resource/xubh-q36u/row-xzzk-sbky-rj53 521311 661445 2019-11-27 2019-06-30 24           24               24
895 MERCY HOSPITAL COLUMBUS 220 N PENNSYLVANIA AVENUE COLUMBUS KS 66725 CHEROKEE (620) 429-2545 Critical Access Hospitals Voluntary non-profit - Church TRUE 37.1720640 -94.8438050 0   21 20 20021         https://data.medicare.gov/resource/xubh-q36u/row-sn95~jvt2.e2ep 171308 660551 2019-11-27 2019-06-30 10           10               10
913 MERCYONE OAKLAND MEDICAL CENTER 601 EAST SECOND ST OAKLAND NE 68045 BURT (402) 685-5601 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.8345710 -96.4591970 0   21 31 31021         https://data.medicare.gov/resource/xubh-q36u/row-bi44_haku_5d9v 281321 660644 2019-11-27 2019-06-30 16           16               16
923 NORTHEASTERN HEALTH SYSTEM 1400 EAST DOWNING STREET TAHLEQUAH OK 74465 CHEROKEE (918) 456-0641 Acute Care Hospitals Government - Local TRUE 35.9153260 -94.9505580 0   21 40 40021 45140 Tulsa-Muskogee-Bartlesville, OK Central Cherokee County https://data.medicare.gov/resource/xubh-q36u/row-y8w6~8rs4_b8fq 370089 660430 2019-11-27 2019-06-30 40 14 16       70 10 10           90
945 REDWOOD MEMORIAL HOSPITAL 3300 RENNER DRIVE FORTUNA CA 95540 HUMBOLDT (707) 445-8121 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.5830710 -124.1359420 0   23 6 6023 21700   Central Humboldt County https://data.medicare.gov/resource/xubh-q36u/row-npjr_8pdg.y2ky 51318 662486 2019-11-27 2019-06-30 21 4         25               25
967 PENN MEDICINE PRINCETON MEDICAL CENTER ONE - FIVE PLAINSBORO ROAD PLAINSBORO NJ 8536 MIDDLESEX (866) 460-4776 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3407758 -74.6232950 1 ROOFTOP 23 34 34023 35620 New York-Newark, NY-NJ-CT-PA Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-3x2p~qrhf~6abi 310010 661556 2019-11-27 2019-06-30 168 24         206 132 17           355
978 BLUE MOUNTAIN HOSPITAL 170 FORD ROAD JOHN DAY OR 97845 GRANT (541) 575-1311 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.4176510 -118.9592200 0   23 41 41023         https://data.medicare.gov/resource/xubh-q36u/row-svyy.cxkf.r4qf 381305 662576 2019-11-27 2019-06-30 14           14               14
991 VERDE VALLEY MEDICAL CENTER 269 SOUTH CANDY LANE COTTONWOOD AZ 86326 YAVAPAI (928) 773-2357 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7362010 -112.0317840 0   25 4 4025 39140   Central Yavapai County https://data.medicare.gov/resource/xubh-q36u/row-ijum~m4k2-ih8a 30007 661278 2019-11-27 2019-06-30 74 13         87 11             98
1054 WYOMING MEDICAL CENTER 1233 EAST 2ND ST CASPER WY 82601 NATRONA (307) 577-7201 Acute Care Hospitals Government - Local TRUE 42.8487180 -106.3087530 0   25 56 56025 16220   Central Natrona County https://data.medicare.gov/resource/xubh-q36u/row-sk2z.s7zk-vge8 530012 662631 2019-11-27 2019-06-30 198 14         212               212
1074 CLAIBORNE MEMORIAL MEDICAL CENTER 620 EAST COLLEGE STREET HOMER LA 71040 CLAIBORNE (318) 927-2024 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7943270 -93.0624690 0   27 22 22027         https://data.medicare.gov/resource/xubh-q36u/row-ncph.ugan.rj3n 190114 661188 2019-11-27 2019-06-30 33 4         37 10             47
1113 BUCHANAN GENERAL HOSPITAL 1535 SLATE CREEK ROAD GRUNDY VA 24614 BUCHANAN (276) 935-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.2855060 -82.0678170 0   27 51 51027         https://data.medicare.gov/resource/xubh-q36u/row-fxtx.a9g4-8ec6 490127 660724 2019-11-27 2019-06-30 37 12         49               49
1142 MUNSON HEALTHCARE CHARLEVOIX HOSPITAL 14700 LAKESHORE DRIVE CHARLEVOIX MI 49720 CHARLEVOIX (231) 547-4024 Critical Access Hospitals Voluntary non-profit - Other TRUE 45.3144980 -85.2748510 1 ROOFTOP 29 26 26029         https://data.medicare.gov/resource/xubh-q36u/row-cdsd.f9cx_c7j8 231322 660601 2019-11-27 2019-06-30 25           25               25
1164 MARY HURLEY HOSPITAL 6 NORTH COVINGTON COALGATE OK 74538 COAL (580) 927-2327 Critical Access Hospitals Proprietary TRUE 34.5392220 -96.2242870 0   29 40 40029         https://data.medicare.gov/resource/xubh-q36u/row-vgqy-nnxi.ph5t 371319 661388 2019-11-27 2019-06-30 20           20               20
1168 JENNERSVILLE HOSPITAL 1015 WEST BALTIMORE PIKE WEST GROVE PA 19390 CHESTER (610) 869-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.8227440 -75.8879180 0   29 42 42029 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Chester County https://data.medicare.gov/resource/xubh-q36u/row-gfcj_eve8~h6ap 390220 660700 2019-11-27 2019-06-30 43 10         53               53
1171 BRANDYWINE HOSPITAL 201 REECEVILLE ROAD COATESVILLE PA 19320 CHESTER (610) 383-8000 Acute Care Hospitals Proprietary TRUE 40.0095860 -75.7902630 0   29 42 42029 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Chester County https://data.medicare.gov/resource/xubh-q36u/row-3tb9_z7kw.8hjr 390076 660696 2019-11-27 2019-06-30 140 15         155 16             171
1172 PHOENIXVILLE HOSPITAL 140 NUTT ROAD PHOENIXVILLE PA 19460 CHESTER (610) 983-1000 Acute Care Hospitals Proprietary TRUE 40.1333870 -75.5380530 0   29 42 42029 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Chester County https://data.medicare.gov/resource/xubh-q36u/row-y3he~wx68-j8cb 390127 660699 2019-11-27 2019-06-30 95 24         123   14           137
1233 RUSH UNIVERSITY MEDICAL CENTER 1653 WEST CONGRESS PARKWAY CHICAGO IL 60612 COOK (312) 942-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8751660 -87.6685100 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-jhqf.rc36_fwc5 140119 661160 2019-11-27 2019-06-30 387       56 55 576 67 54           697
1236 ALEXIAN BROTHERS MEDICAL CENTER 1 800 W BIESTERFIELD RD ELK GROVE VILLAGE IL 60007 COOK (847) 437-5500 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.0037050 -88.0149960 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-22rs-enea-7d2m 140258 660521 2019-11-27 2019-06-30 221 36         257 25 72       16   370
1248 ST ALEXIUS MEDICAL CENTER 1555 N BARRINGTON RD HOFFMAN ESTATES IL 60169 COOK (847) 843-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.0524090 -88.1444450 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-b2zc_temi.u4ux 140290 660522 2019-11-27 2019-06-30 267 35         318               318
1315 ASCENSION SACRED HEART PENSACOLA 5151 N 9TH AVE PENSACOLA FL 32504 ESCAMBIA (850) 416-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4755880 -87.2109860 0   33 12 12033 37860   Central Escambia County https://data.medicare.gov/resource/xubh-q36u/row-cuin_8gyu.u6ry 100025 660788 2019-11-27 2019-06-30 419 34       26 561               561
1344 WILLIAM BEE RIRIE HOSPITAL 1500 AVENUE H ELY NV 89301 WHITE PINE (775) 289-3001 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2560650 -114.8600860 0   33 32 32033         https://data.medicare.gov/resource/xubh-q36u/row-xg87~7vrt.qaws 291302 662548 2019-11-27 2019-06-30 25           25               25
1369 ST FRANCIS COMMUNITY HOSPITAL 34515 9TH AVENUE SOUTH FEDERAL WAY WA 98003 KING (253) 944-8100 Acute Care Hospitals Voluntary non-profit - Church TRUE 47.2921060 -122.3229510 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-26c7~6xv9.c5tp 500141 662625 2019-11-27 2019-06-30 110 14         124               124
1370 HIGHLINE MEDICAL CENTER 16251 SYLVESTER ROAD SW BURIEN WA 98166 KING (206) 244-9970 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.4567780 -122.3414550 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-rruu~ixyd~6kv9 500011 662285 2019-11-27 2019-06-30 119 10         129               129
1371 ST ELIZABETH HOSPITAL 1450 BATTERSBY AVENUE ENUMCLAW WA 98022 KING (360) 825-2505 Critical Access Hospitals Voluntary non-profit - Church TRUE 47.2084170 -121.9881570 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-8kts.qr6u-cywi 501335 660477 2019-11-27 2019-06-30 25           25               25
1385 WELLSTAR SYLVAN GROVE HOSPITAL 1050 MCDONOUGH ROAD JACKSON GA 30233 BUTTS (770) 775-7861 Critical Access Hospitals Government - Hospital District or Authority FALSE 33.3030850 -83.9778230 0   35 13 13035 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Butts County https://data.medicare.gov/resource/xubh-q36u/row-uazj.s3pp-ngue 111319 660799 2019-11-27 2019-06-30 25           25               25
1393 MIDMICHIGAN MEDICAL CENTER-CLARE 703 N MCEWAN ST CLARE MI 48617 CLARE (989) 802-5000 Acute Care Hospitals Voluntary non-profit - Other FALSE 43.8207240 -84.7683490 0   35 26 26035         https://data.medicare.gov/resource/xubh-q36u/row-x95c-xq2z-tjc4 230180 661013 2019-11-27 2019-06-30 49           49               49
1425 SAINT FRANCIS HOSPITAL VINITA, INC 735 NORTH FOREMAN STREET VINITA OK 74301 CRAIG (918) 256-7551 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.6533720 -95.1556420 0   35 40 40035         https://data.medicare.gov/resource/xubh-q36u/row-bg5g~s52b_99xj 370237 659861 2019-11-27 2019-06-30 35           35 20             55
1431 GOODALL WITCHER HOSPITAL 101 POSEY AVENUE CLIFTON TX 76634 BOSQUE (254) 675-8322 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.7771530 -97.5884310 0   35 48 48035         https://data.medicare.gov/resource/xubh-q36u/row-xqqi.9yb9.h6f2 451385 660476 2019-11-27 2019-06-30 25           25               25
1439 LONE PEAK HOSPITAL 11925 SOUTH STATE STREET DRAPER UT 84020 SALT LAKE (801) 545-8000 Acute Care Hospitals Proprietary TRUE 40.5352380 -111.8914640 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-3yfr.y4qy.386x 460060 662283 2019-11-27 2019-06-30 26 4         30               30
1445 HARRISON MEMORIAL HOSPITAL 2520 CHERRY AVENUE BREMERTON WA 98310 KITSAP (360) 377-3911 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.5834290 -122.6260100 0   35 53 53035 14740 Seattle-Tacoma, WA Central Kitsap County https://data.medicare.gov/resource/xubh-q36u/row-8y88_q8xr.ka8g 500039 662287 2019-11-27 2019-06-30 278 20         298               298
1461 MEMORIAL CARE MILLER CHILDREN'S & WOMEN'S HOSP LB 2801 ATLANTIC AVENUE LONG BEACH CA 90806 LOS ANGELES (562) 933-8001 Childrens Voluntary non-profit - Other FALSE 33.8071070 -118.1850980 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-khay_hirb.gvkk 53309 662488 2019-11-27 2019-06-30 232 30       95 357               357
1553 CHATHAM HOSPITAL INC 475 PROGRESS BLVD SILER CITY NC 27344 CHATHAM (919) 799-4000 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.7235100 -79.4222610 0   37 37 37037 20500 Raleigh-Durham-Chapel Hill, NC Central Chatham County https://data.medicare.gov/resource/xubh-q36u/row-7ygq~q73i.83q4 341311 660655 2019-11-27 2019-06-30 21 4         25               25
1562 GEISINGER-BLOOMSBURG HOSPITAL 549 EAST FAIR STREET BLOOMSBURG PA 17815 COLUMBIA (570) 387-2100 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0084310 -76.4531930 0   37 42 42037 14100 Bloomsburg-Berwick-Sunbury, PA Central Columbia County https://data.medicare.gov/resource/xubh-q36u/row-86e6-ifiy~4gix 390003 661087 2019-11-27 2019-06-30 44 12         56 20             76
1601 MURPHY MEDICAL CENTER INC 3990 EAST US HIGHWAY 64 ALT MURPHY NC 28906 CHEROKEE (828) 837-8161 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.0731600 -83.9654240 0   39 37 37039         https://data.medicare.gov/resource/xubh-q36u/row-6u4n.7ur8_z37n 341328 660656 2019-11-27 2019-06-30 25           25               25
1609 SACRED HEART MEDICAL CENTER - RIVERBEND 3333 RIVERBEND DRIVE SPRINGFIELD OR 97477 LANE (541) 222-7300 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.0813120 -123.0286550 0   39 41 41039 21660   Central Lane County https://data.medicare.gov/resource/xubh-q36u/row-xqg2~c6as-x5em 380102 662575 2019-11-27 2019-06-30 301 46       36 383               383
1611 SACRED HEART UNIVERSITY DISTRICT 1255 HILYARD STREET EUGENE OR 97401 LANE (541) 686-7300 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.0460560 -123.0821050 0   39 41 41039 21660   Central Lane County https://data.medicare.gov/resource/xubh-q36u/row-g7vk_mpaz~eeix 380033 662243 2019-11-27 2019-06-30 40           40 35 18           93
1637 UCHEALTH GRANDVIEW HOSPITAL 5623 PULPIT PEAK VIEW COLORADO SPRINGS CO 80918 EL PASO (719) 272-3623 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9102620 -104.8164360 0   41 8 8041 17820   Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-6gec-fw6v-ugx7 60130 660178 2019-11-27 2019-06-30 22           22               22
1663 HOLY SPIRIT HOSPITAL 503 NORTH 21ST STREET CAMP HILL PA 17011 CUMBERLAND (717) 763-2100 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.2514100 -76.9234680 0   41 42 42041 25420 Harrisburg-York-Lebanon, PA Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-p38r_8hnx-xf4j 390004 660850 2019-11-27 2019-06-30 239 21 12       277 31             308
1668 LAKE CITY COMMUNITY HOSPITAL 258 N RON MCNAIR BLVD LAKE CITY SC 29560 FLORENCE (843) 374-2036 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.8803700 -79.7590890 0   41 45 45041 22500   Central Florence County https://data.medicare.gov/resource/xubh-q36u/row-cj23~5qzh.swv8 420066 661103 2019-11-27 2019-06-30 26           26               26
1699 UNIVERSITY OF MISSISSIPPI MEDICAL CENTER- GRENADA 960 AVENT DRIVE GRENADA MS 38901 GRENADA (662) 227-7000 Acute Care Hospitals Government - State TRUE 33.7633070 -89.8175320 0   43 28 28043 24980   Central Grenada County https://data.medicare.gov/resource/xubh-q36u/row-p3dc_vfsq.nigj 250168 659814 2019-11-27 2019-06-30 44   5       49               49
1700 UNM SANDOVAL REGIONAL MEDICAL CENTER 3001 BROADMOOR BLVD NE RIO RANCHO NM 87144 SANDOVAL (505) 994-7402 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.3073510 -106.6770030 0   43 35 35043 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Sandoval County https://data.medicare.gov/resource/xubh-q36u/row-nwre-fmi7-2c64 320089 660830 2019-11-27 2019-06-30 48           60               60
1707 MILTON S HERSHEY MEDICAL CENTER 500 UNIVERSITY DRIVE HERSHEY PA 17033 DAUPHIN (717) 531-8521 Acute Care Hospitals Voluntary non-profit - Private FALSE 40.2659320 -76.6745570 0   43 42 42043 25420 Harrisburg-York-Lebanon, PA Central Dauphin County https://data.medicare.gov/resource/xubh-q36u/row-wsnf.ibqp_dukp 390256 661640 2019-11-27 2019-06-30 421 16     61 50 548               548
1728 ASCENSION SACRED HEART GULF 3801 E HWY 98 PORT SAINT JOE FL 32456 GULF (850) 229-5600 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.7765620 -85.2876050 0   45 12 12045 37460   Outlying Gulf County https://data.medicare.gov/resource/xubh-q36u/row-2gve.rn5c.g9tq 100313 660196 2019-11-27 2019-06-30 19           19               19
1737 CASEY COUNTY HOSPITAL 187 WOLFORD AVENUE LIBERTY KY 42539 CASEY (606) 787-6275 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.3178090 -84.9317170 0   45 21 21045         https://data.medicare.gov/resource/xubh-q36u/row-aju2-kjdy-yhzq 181309 662532 2019-11-27 2019-06-30 24           24               24
1776 CHI MEMORIAL HOSPITAL- GEORGIA 100 GROSS CRESCENT CIRCLE FORT OGLETHORPE GA 30742 CATOOSA (770) 874-5400 Acute Care Hospitals Proprietary TRUE 34.9477700 -85.2627560 0   47 13 13047 16860 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Catoosa County https://data.medicare.gov/resource/xubh-q36u/row-a96y-gfhv_jnf7 110236 659941 2019-11-27 2019-06-30 36           36               36
1812 INTEGRIS BASS BAPTIST HEALTH CENTER 600 SOUTH MONROE ENID OK 73701 GARFIELD (580) 233-2300 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.3899070 -97.8864990 0   47 40 40047 21420   Central Garfield County https://data.medicare.gov/resource/xubh-q36u/row-utms_e679-iry4 370016 660424 2019-11-27 2019-06-30 114 19       4 183               183
1839 ASCENSION GENESYS HOSPITAL ONE GENESYS PARKWAY GRAND BLANC MI 48439 GENESEE (810) 606-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.8903226 -83.6367994 1 ROOFTOP 49 26 26049 22420 Detroit-Warren-Ann Arbor, MI Central Genesee County https://data.medicare.gov/resource/xubh-q36u/row-puhx-szv4~kvmj 230197 661015 2019-11-27 2019-06-30 305 45         350   20           370
1840 HURLEY MEDICAL CENTER ONE HURLEY PLAZA FLINT MI 48503 GENESEE (810) 257-9000 Acute Care Hospitals Voluntary non-profit - Other TRUE 43.0212629 -83.7046814 1 GEOMETRIC_CENTER 49 26 26049 22420 Detroit-Warren-Ann Arbor, MI Central Genesee County https://data.medicare.gov/resource/xubh-q36u/row-kud9-8wsb.pvu8 230132 661010 2019-11-27 2019-06-30 256 46 13 11   44 370 35 13           418
1847 UNIVERSITY OF MISSISSIPPI MED CENTER 2500 N STATE ST JACKSON MS 39216 HINDS (601) 984-4100 Acute Care Hospitals Government - State TRUE 32.3287830 -90.1755800 0   49 28 28049 27140 Jackson-Vicksburg-Brookhaven, MS Central Hinds County https://data.medicare.gov/resource/xubh-q36u/row-ckry~yqs7_czxf 250001 661025 2019-11-27 2019-06-30 486 20 20   20 30 698               698
1899 DAVIS COUNTY HOSPITAL 509 NORTH MADISON STREET BLOOMFIELD IA 52537 DAVIS (641) 664-2145 Critical Access Hospitals Government - Local TRUE 40.7592230 -92.4149870 0   51 19 19051 36900   Outlying Davis County https://data.medicare.gov/resource/xubh-q36u/row-m6yx_jbnt.5nnb 161327 660964 2019-11-27 2019-06-30 25           25               25
1909 HOLMES COUNTY HOSPITAL AND CLINICS 239 BOWLING GREEN ROAD LEXINGTON MS 39095 HOLMES (662) 834-1321 Critical Access Hospitals Government - State TRUE 33.1110770 -90.0297410 0   51 28 28051         https://data.medicare.gov/resource/xubh-q36u/row-bbwk_bsmz-qfyj 251319 660403 2019-11-27 2019-06-30 25           25               25
1912 LIBERTY MEDICAL CENTER 315 W MADISON AVE CHESTER MT 59522 LIBERTY (406) 759-5181 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.5104970 -110.9718340 0   51 30 30051         https://data.medicare.gov/resource/xubh-q36u/row-jg4d_ys9s~wecb 271334 662543 2019-11-27 2019-06-30 25           25               25
1949 MARION GENERAL HOSPITAL 441 N WABASH AVE MARION IN 46952 GRANT (765) 660-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5638530 -85.6651390 0   53 18 18053 31980   Central Grant County https://data.medicare.gov/resource/xubh-q36u/row-562w_32w4-3n42 150011 660936 2019-11-27 2019-06-30 87 19         106   18           124
1981 ST JOSEPH MEDICAL CENTER 1717 SOUTH J STREET TACOMA WA 98405 PIERCE (253) 627-4101 Acute Care Hospitals Voluntary non-profit - Church TRUE 47.2454690 -122.4487570 0   53 53 53053 42660 Seattle-Tacoma, WA Central Pierce County https://data.medicare.gov/resource/xubh-q36u/row-pud3~63vu~69st 500108 662624 2019-11-27 2019-06-30 292 82         374               374
1982 ST ANTHONY HOSPITAL 11567 CANTERWOOD BOULEVARD NW GIG HARBOR WA 98332 PIERCE (253) 530-2050 Acute Care Hospitals Voluntary non-profit - Church TRUE 47.3650330 -122.6150630 0   53 53 53053 42660 Seattle-Tacoma, WA Central Pierce County https://data.medicare.gov/resource/xubh-q36u/row-tej2.8itp~9z5w 500151 662293 2019-11-27 2019-06-30 96 16         112               112
1985 ST CLARE HOSPITAL 11315 BRIDGEPORT WAY S W LAKEWOOD WA 98499 PIERCE (253) 588-1711 Acute Care Hospitals Voluntary non-profit - Church TRUE 47.1542130 -122.5044950 0   53 53 53053 42660 Seattle-Tacoma, WA Central Pierce County https://data.medicare.gov/resource/xubh-q36u/row-dwu9_j2ug-7e7a 500021 662622 2019-11-27 2019-06-30 75 31         106               106
1994 QUEEN OF THE VALLEY MEDICAL CENTER 1000 TRANCAS ST NAPA CA 94558 NAPA (707) 252-4411 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.3235540 -122.2959680 0   55 6 6055 34900 San Jose-San Francisco-Oakland, CA Central Napa County https://data.medicare.gov/resource/xubh-q36u/row-tqw2_dtrw-avff 50009 662463 2019-11-27 2019-06-30 110 36       6 152   14           166
2006 OUR LADY OF LOURDES REGIONAL MEDICAL CENTER, INC 4801 AMBASSADOR CAFFERY PARKWAY LAFAYETTE LA 70508 LAFAYETTE (337) 470-2100 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.1500010 -92.0404470 0   55 22 22055 29180 Lafayette-Opelousas-Morgan City, LA Central Lafayette Parish https://data.medicare.gov/resource/xubh-q36u/row-ft5v-q2ab-kpdw 190102 660227 2019-11-27 2019-06-30 237 24   6   51 331   16           347
2012 MUNSON MEDICAL CENTER 1105 SIXTH STREET TRAVERSE CITY MI 49684 GRAND TRAVERSE (231) 935-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.7616450 -85.6415880 0   55 26 26055 45900   Central Grand Traverse County https://data.medicare.gov/resource/xubh-q36u/row-ytzp_khah~df5e 230097 660589 2019-11-27 2019-06-30 377 20         409 17 16           442
2064 ST VINCENT FISHERS HOSPITAL INC 13861 OLIO ROAD FISHERS IN 46037 HAMILTON (317) 415-9000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9888520 -85.9188440 0   57 18 18057 26900 Indianapolis-Carmel-Muncie, IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-a5mj~2uur-2exn 150181 660945 2019-11-27 2019-06-30 46           46               46
2122 ST JUDE MEDICAL CENTER 101 E VALENCIA MESA DRIVE FULLERTON CA 92835 ORANGE (714) 992-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.8935030 -117.9279520 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-fxj7-vaud_psma 50168 662471 2019-11-27 2019-06-30 225 51         290   30           320
2124 MISSION HOSPITAL REGIONAL MED CENTER 27700 MEDICAL CENTER RD MISSION VIEJO CA 92691 ORANGE (949) 364-1400 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5610153 -117.6653937 1 ROOFTOP 59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-dvr4-2vyx_23n4 50567 662478 2019-11-27 2019-06-30 392 73         465 36 22           523
2126 ST JOSEPH HOSPITAL 1100 WEST STEWART DR ORANGE CA 92868 ORANGE (714) 633-9111 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.7823990 -117.8660930 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-x65w~hu2t-xjdy 50069 661283 2019-11-27 2019-06-30 357 32 20       409 37             446
2147 UNION COUNTY GENERAL HOSPITAL 300 WILSON STREET CLAYTON NM 88415 UNION (575) 374-7001 Critical Access Hospitals Voluntary non-profit - Other TRUE 36.4551690 -103.1932600 0   59 35 35059         https://data.medicare.gov/resource/xubh-q36u/row-ai6a~bn84~9pvi 321304 660831 2019-11-27 2019-06-30 25           25               25
2160 GOOD SHEPHERD MEDICAL CENTER 610 NW 11TH STREET HERMISTON OR 97838 UMATILLA (541) 667-3400 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.8461350 -119.3109500 0   59 41 41059 25840   Central Umatilla County https://data.medicare.gov/resource/xubh-q36u/row-2f95~scvq.xeyd 381325 662577 2019-11-27 2019-06-30 22 3         25               25
2161 ST ANTHONY HOSPITAL 2801 ST ANTHONY WAY PENDLETON OR 97801 UMATILLA (541) 276-5121 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.6482496 -118.8124252 1 ROOFTOP 59 41 41059 25840   Central Umatilla County https://data.medicare.gov/resource/xubh-q36u/row-hwf6-ji7m-72j9 381319 660288 2019-11-27 2019-06-30 20 5         25               25
2165 AVERA HAND COUNTY MEMORIAL HOSPITAL AND CLINIC 300 W 5TH ST MILLER SD 57362 HAND (605) 853-2421 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.5206230 -98.9920440 0   59 46 46059         https://data.medicare.gov/resource/xubh-q36u/row-cen8-s23k_ktis 431337 662584 2019-11-27 2019-06-30 25           25               25
2184 MERCYONE DYERSVILLE MEDICAL CENTER 1111 3RD STREET SW DYERSVILLE IA 52040 DUBUQUE (563) 875-7101 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.4759240 -91.1296320 0   61 19 19061 20220   Central Dubuque County https://data.medicare.gov/resource/xubh-q36u/row-erwi.dcvk.sxse 161378 660547 2019-11-27 2019-06-30 20           20               20

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