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

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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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 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 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 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 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 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 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 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
73 73 SIBLEY MEMORIAL HOSPITAL 5255 LOUGHBORO RD NW WASHINGTON DC 20016 THE DISTRICT (202) 537-4680 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9357470 -77.1098890 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-yqpq-7pu8-v5vj 90005 660786 2019-11-27 2019-06-30 150   25   14   189 21     45       255
74 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
101 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 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 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
227 227 MAGEE WOMENS HOSPITAL OF UPMC HEALTH SYSTEM 300 HALKET STREET PITTSBURGH PA 15213 ALLEGHENY (412) 641-4010 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.4370770 -79.9595460 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-tusn~f4sz~kzrq 390114 660858 2019-11-27 2019-06-30 220 18         315       20       335
232 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
252 252 NORTH BIG HORN HOSPITAL DISTRICT 1115 LANE 12 LOVELL WY 82431 BIG HORN (307) 548-5200 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.8257990 -108.3906880 0   3 56 56003         https://data.medicare.gov/resource/xubh-q36u/row-s9vd~bscy-xn2k 531309 662633 2019-11-27 2019-06-30 12           12       85       97
255 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
332 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 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 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 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
511 511 ESSENTIA HEALTH HOLY TRINITY HOSPITAL 115 SECOND STREET WEST, BOX 157 GRACEVILLE MN 56240 BIG STONE (320) 748-8200 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.5624100 -96.4334520 0   11 27 27011         https://data.medicare.gov/resource/xubh-q36u/row-crzd_579y.ukdv 241321 660608 2019-11-27 2019-06-30 15           15       40       55
605 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 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
650 650 AVERA ST LUKES 305 S STATE ST POST OFFICE BOX 4450 ABERDEEN SD 57401 BROWN (605) 622-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 45.4617950 -98.4793500 0   13 46 46013 10100   Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-pruy~fuxf-c6av 430014 662254 2019-11-27 2019-06-30 43 6         49 10     81 56     196
718 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 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 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 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 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
824 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 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 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 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
945 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
978 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 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 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 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
1088 1088 PERSHING GENERAL HOSPITAL 855 6TH STREET/PO BOX 661 LOVELOCK NV 89419 PERSHING (775) 273-2621 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.1766240 -118.4820870 0   27 32 32027         https://data.medicare.gov/resource/xubh-q36u/row-9yyu.vv2v~izhm 291304 662550 2019-11-27 2019-06-30 13           13       25       38
1113 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 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 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 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 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
1194 1194 POWELL VALLEY HOSPITAL 777 AVENUE H POWELL WY 82435 PARK (307) 754-2267 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.7566220 -108.7705470 0   29 56 56029         https://data.medicare.gov/resource/xubh-q36u/row-gs73_h7cj.ibeh 531310 662634 2019-11-27 2019-06-30 25           25       100       125
1212 1212 UF HEALTH JACKSONVILLE 655 W 8TH ST JACKSONVILLE FL 32209 DUVAL (904) 244-0411 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.3467990 -81.6642280 0   31 12 12031 27260 Jacksonville-St. Marys-Palatka, FL-GA Central Duval County https://data.medicare.gov/resource/xubh-q36u/row-ku4k~xtjd~bra7 100001 661475 2019-11-27 2019-06-30 348 80 49     8 533       56       589
1247 1247 RUSH OAK PARK HOSPITAL 520 S MAPLE AVE OAK PARK IL 60304 COOK (708) 383-9300 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.8790260 -87.8038180 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-xnpc~27df_qfvd 140063 661156 2019-11-27 2019-06-30 151 14         165       36       201
1248 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 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 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 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 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 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 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 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 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
1427 1427 BUCKTAIL MEDICAL CENTER 1001 PINE STREET RENOVO PA 17764 CLINTON (570) 923-1000 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.3269380 -77.7374450 0   35 42 42035 30820 Williamsport-Lock Haven, PA Central Clinton County https://data.medicare.gov/resource/xubh-q36u/row-vesv-my7y~edhc 391304 660870 2019-11-27 2019-06-30 16           16       43       59
1431 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 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 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 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 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 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
1594 1594 MUNSON HEALTHCARE GRAYLING HOSPITAL 1100 E MICHIGAN AVE GRAYLING MI 49738 CRAWFORD (989) 348-5461 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.6672510 -84.7079390 0   39 26 26039         https://data.medicare.gov/resource/xubh-q36u/row-unnq.cpq3.chrb 230058 660583 2019-11-27 2019-06-30 43 6         49       39       88
1601 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 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
1637 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 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 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 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 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 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
1718 1718 SOUTHWEST HEALTH CENTER 1400 EAST SIDE RD PLATTEVILLE WI 53818 GRANT (608) 348-2331 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.7197810 -90.4557830 0   43 55 55043 38420   Central Grant County https://data.medicare.gov/resource/xubh-q36u/row-vwfv~jm7m_6m6b 521354 661836 2019-11-27 2019-06-30 25           25 10     78       113
1728 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 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 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 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
1828 1828 MODOC MEDICAL CENTER 228 W MCDOWELL AVE ALTURAS CA 96101 MODOC (530) 233-5131 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.4799490 -120.5455030 0   49 6 6049         https://data.medicare.gov/resource/xubh-q36u/row-kyq6~7b5b.wgww 51330 662175 2019-11-27 2019-06-30 16           16       71       87
1847 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 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 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 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
1978 1978 HIRAM W DAVIS MEDICAL CENTER P O BOX 4030 PETERSBURG VA 23803 PETERSBURG CITY (804) 524-7344 Acute Care Hospitals Government - State FALSE 37.2098658 -77.4509355 1 ROOFTOP 53 51 51053 40060   Central Dinwiddie County https://data.medicare.gov/resource/xubh-q36u/row-xvn2.38q5-2xg5 490104 661117 2019-11-27 2019-06-30 4           4       50 30 277   361
1981 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 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 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
2048 2048 TAHOE FOREST HOSPITAL 10121 PINE AVE TRUCKEE CA 96161 NEVADA (530) 587-6011 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.3251630 -120.2013440 0   57 6 6057 46020 Sacramento-Roseville, CA Central Nevada County https://data.medicare.gov/resource/xubh-q36u/row-n6zm-373j_a9uq 51328 661144 2019-11-27 2019-06-30 19 6         25       37       62
2064 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
2126 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 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 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 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 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 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
2221 2221 EASTERN PLUMAS HOSPITAL - PORTOLA CAMPUS 500 FIRST AVENUE PORTOLA CA 96122 PLUMAS (530) 832-4277 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.8061440 -120.4631290 0   63 6 6063         https://data.medicare.gov/resource/xubh-q36u/row-4uid-vtd8_6vsi 51300 662171 2019-11-27 2019-06-30 9           9       66       75
2249 2249 AVERA HOLY FAMILY HOSPITAL 826 NORTH 8TH STREET ESTHERVILLE IA 51334 EMMET (712) 362-2631 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.4105960 -94.8339560 0   63 19 19063         https://data.medicare.gov/resource/xubh-q36u/row-gfry-34vq-dsa9 161351 660978 2019-11-27 2019-06-30 22           22               22
2298 2298 CLINCH MEMORIAL HOSPITAL 1050 VALDOSTA HIGHWAY HOMERVILLE GA 31634 CLINCH (912) 487-5211 Critical Access Hospitals Government - Local TRUE 31.0326510 -82.7638580 0   65 13 13065         https://data.medicare.gov/resource/xubh-q36u/row-6x28-ujdc_jsi5 111308 659942 2019-11-27 2019-06-30 15           15               15
2319 2319 JACKSON COUNTY MEMORIAL HOSPITAL AUTHORITY 1200 EAST PECAN ST ALTUS OK 73521 JACKSON (580) 379-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6352730 -99.3191190 0   65 40 40065 11060   Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-grzh.mrwf.u2yy 370022 660425 2019-11-27 2019-06-30 43 6         49               49
2325 2325 MEMORIAL HEALTHCARE SYSTEM, INC 2525 DESALES AVE CHATTANOOGA TN 37404 HAMILTON (423) 495-2525 Acute Care Hospitals Voluntary non-profit - Church TRUE 35.0400370 -85.2611290 0   65 47 47065 16860 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-urkm~t32p-kn9t 440091 660456 2019-11-27 2019-06-30 363 34 14   12   423               423
2326 2326 ERLANGER MEDICAL CENTER 975 E 3RD ST CHATTANOOGA TN 37403 HAMILTON (423) 778-7000 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.0478990 -85.2908530 0   65 47 47065 16860 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-5dss-8gth.uas3 440104 660457 2019-11-27 2019-06-30 462 84 8   18 64 674               674

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