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

325 rows where "filed_date" is on date 2019-06-03 sorted by all_beds

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_oth_beds, nursing_fac_beds, oth_longterm_beds

filed_date (date) ✖

  • 2019-06-03 · 325 ✖
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 ▼
2950 2950 MINIMALLY INVASIVE SURGERY HOSPITAL 11217 LAKEVIEW AVENUE LENEXA KS 66219 JOHNSON (913) 322-7401 Acute Care Hospitals Proprietary FALSE 38.9243760 -94.7697050 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-jnfx.rz75-i6pf 170199 649588 2019-06-03 2018-12-31 7       2   9               9
2532 2532 MONROE SURGICAL HOSPITAL 2408 BROADMOOR BLVD MONROE LA 71201 OUACHITA (318) 410-0002 Acute Care Hospitals Physician FALSE 32.5367710 -92.1022040 0   73 22 22073 33740 Monroe-Ruston-Bastrop, LA Central Ouachita Parish https://data.medicare.gov/resource/xubh-q36u/row-2viy_tht4-abuk 190245 650140 2019-06-03 2018-12-31 10           10               10
221 221 INSTITUTE FOR ORTHOPAEDIC SURGERY 801 MEDICAL DRIVE, SUITE B LIMA OH 45804 ALLEN (419) 224-7586 Acute Care Hospitals Proprietary FALSE 40.6985860 -84.0864770 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-kbua_iifb.k5nj 360263 649649 2019-06-03 2018-12-31 12           12               12
3165 3165 SOUTHEAST MICHIGAN SURGICAL HOSPITAL 21230 DEQUINDRE ROAD WARREN MI 48091 MACOMB (586) 427-1000 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.4513950 -83.0835600 0   99 26 26099 19820 Detroit-Warren-Ann Arbor, MI Central Macomb County https://data.medicare.gov/resource/xubh-q36u/row-n5cw~k8mz~eeh4 230264 650280 2019-06-03 2018-12-31 13           13               13
426 426 LANAI COMMUNITY HOSPITAL 628 7TH STREET LANAI CITY HI 96763 MAUI (808) 565-8450 Critical Access Hospitals Government - State TRUE 20.8267350 -156.9180020 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-keiy_dtd7_smny 121305 648608 2019-06-03 2018-12-31 4           4       10       14
1622 1622 KLICKITAT VALLEY HOSPITAL 310 SOUTH ROOSEVELT GOLDENDALE WA 98620 KLICKITAT (509) 773-4022 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.8202390 -120.8122990 0   39 53 53039         https://data.medicare.gov/resource/xubh-q36u/row-hemh_kxtf-bs6t 501316 649846 2019-06-03 2018-12-31 14           14               14
3191 3191 SUTTER SURGICAL HOSPITAL - NORTH VALLEY 455 PLUMAS BLVD YUBA CITY CA 95991 SUTTER (530) 749-5700 Acute Care Hospitals Physician FALSE 39.1321670 -121.6136030 0   101 6 6101 49700 Sacramento-Roseville, CA Central Sutter County https://data.medicare.gov/resource/xubh-q36u/row-rm5f.jnvd.d3k4 50766 651185 2019-06-03 2018-12-31 14           14               14
740 740 SPECIALISTS HOSPITAL SHREVEPORT 1500 LINE AVENUE SHREVEPORT LA 71101 CADDO (318) 213-3800 Acute Care Hospitals Physician FALSE 32.4969260 -93.7460460 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-kr9t-dd8q-wfhi 190278 649901 2019-06-03 2018-12-31 15           15               15
4013 4013 STARKE HOSPITAL 102 E CULVER RD KNOX IN 46534 STARKE (574) 772-1102 Acute Care Hospitals Proprietary TRUE 41.2880640 -86.6219370 0   149 18 18149         https://data.medicare.gov/resource/xubh-q36u/row-4bwp-v7bt.62f6 150102 649569 2019-06-03 2018-12-31 14 1         15               15
4182 4182 JENKINS COUNTY HOSPITAL 931 EAST WINTHROPE AVENUE MILLEN GA 30442 JENKINS (478) 982-4221 Critical Access Hospitals Proprietary TRUE 32.8036780 -81.9340740 0   165 13 13165         https://data.medicare.gov/resource/xubh-q36u/row-wabu-mgcf_ujg3 111311 651201 2019-06-03 2018-12-31 15           15               15
575 575 DIGNITY HEALTH - ARIZONA GENERAL HOSPITAL 7171 SOUTH 51ST AVENUE LAVEEN AZ 85339 MARICOPA (623) 584-5100 Acute Care Hospitals Proprietary FALSE 33.3806770 -112.1682330 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-6h9g-s46a~aiyi 30136 651169 2019-06-03 2018-12-31 16           16               16
643 643 ST CHARLES PRINEVILLE 384 SE COMBS FLAT ROAD PRINEVILLE OR 97754 CROOK (541) 447-6254 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.2980930 -120.8269680 0   13 41 41013 39260 Bend-Redmond-Prineville, OR Central Crook County https://data.medicare.gov/resource/xubh-q36u/row-yy7v_qhni~xpgc 381313 651052 2019-06-03 2018-12-31 16           16               16
691 691 SLEEPY EYE MUNICIPAL HOSPITAL 400 FOURTH AVENUE NORTHWEST SLEEPY EYE MN 56085 BROWN (507) 794-3571 Critical Access Hospitals Government - Local TRUE 44.2993190 -94.7273150 0   15 27 27015 35580 Mankato-New Ulm-North Mankato, MN Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-td5y_avnx_gs7p 241327 651011 2019-06-03 2018-12-31 16           16               16
1905 1905 OMEGA HOSPITAL, LLC 2525 SEVERN AVENUE METAIRIE LA 70002 JEFFERSON (504) 849-4900 Acute Care Hospitals Proprietary FALSE 29.9991620 -90.1595830 0   51 22 22051 35380 New Orleans-Metairie-Hammond, LA-MS Central Jefferson Parish https://data.medicare.gov/resource/xubh-q36u/row-fybn~uix6_hmgd 190302 649030 2019-06-03 2018-12-31 16           16               16
2687 2687 MENLO PARK SURGICAL HOSPITAL 570 WILLOW ROAD MENLO PARK CA 94025 SAN MATEO (650) 324-8500 Acute Care Hospitals Voluntary non-profit - Private FALSE 37.4620430 -122.1595170 0   81 6 6081 41860 San Jose-San Francisco-Oakland, CA Central San Mateo County https://data.medicare.gov/resource/xubh-q36u/row-y26q.aad6_zuz4 50754 650662 2019-06-03 2018-12-31 16           16               16
3703 3703 WRAY COMMUNITY DISTRICT HOSPITAL 1017 WEST 7TH ST WRAY CO 80758 YUMA (970) 332-4811 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.0754050 -102.2346600 0   125 8 8125         https://data.medicare.gov/resource/xubh-q36u/row-jpdk~yrgm-qq54 61309 649710 2019-06-03 2018-12-31 16           16               16
3949 3949 RIDGEVIEW SIBLEY MEDICAL CENTER 601 WEST CHANDLER ARLINGTON MN 55307 SIBLEY (507) 964-8415 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.6097820 -94.0846310 0   143 27 27143 33460 Minneapolis-St. Paul, MN-WI Outlying Sibley County https://data.medicare.gov/resource/xubh-q36u/row-udbf-4pka.q8zs 241311 651010 2019-06-03 2018-12-31 16           16               16
4337 4337 STANTON COUNTY HOSPITAL 404 N CHESTNUT JOHNSON KS 67855 STANTON (620) 492-6250 Critical Access Hospitals Government - Local TRUE 37.5741650 -101.7494100 0   187 20 20187         https://data.medicare.gov/resource/xubh-q36u/row-nbvv-b265_tdp8 171343 649594 2019-06-03 2018-12-31 16           16               16
4551 4551 CLEVELAND EMERGENCY HOSPITAL 1017 S TRAVIS AVE CLEVELAND TX 77327 LIBERTY (281) 592-5400 Acute Care Hospitals Proprietary TRUE 30.3294340 -95.0960570 0   291 48 48291 26420 Houston-The Woodlands, TX Outlying Liberty County https://data.medicare.gov/resource/xubh-q36u/row-3yf9_ucey-48hx 670115 650933 2019-06-03 2018-12-31 16           16               16
1072 1072 CLAY COUNTY MEDICAL CENTER 617 LIBERTY CLAY CENTER KS 67432 CLAY (785) 632-2144 Critical Access Hospitals Government - Local TRUE 39.3916810 -97.1241960 0   27 20 20027         https://data.medicare.gov/resource/xubh-q36u/row-5isq.mc8m-iybh 171371 650581 2019-06-03 2018-12-31 17           17               17
3274 3274 RIVER'S EDGE HOSPITAL & CLINIC 1900 NORTH SUNRISE DRIVE ST PETER MN 56082 NICOLLET (507) 934-7602 Critical Access Hospitals Government - Local TRUE 44.3478460 -93.9708750 0   103 27 27103 31860 Mankato-New Ulm-North Mankato, MN Central Nicollet County https://data.medicare.gov/resource/xubh-q36u/row-83di-yjvp_x3zt 241334 649780 2019-06-03 2018-12-31 17           17               17
4574 4574 PALACIOS COMMUNITY MEDICAL CENTER 311 GREEN AVENUE PALACIOS TX 77465 MATAGORDA (361) 972-2511 Critical Access Hospitals Voluntary non-profit - Private TRUE 28.7174570 -96.2127670 0   321 48 48321 13060 Houston-The Woodlands, TX Central Matagorda County https://data.medicare.gov/resource/xubh-q36u/row-e88j_uxba~jujd 451332 650379 2019-06-03 2018-12-31 17           17               17
1719 1719 WASHAKIE MEDICAL CENTER 400 SOUTH 15TH STREET WORLAND WY 82401 WASHAKIE (307) 347-3221 Critical Access Hospitals Government - Local TRUE 44.0135560 -107.9484090 0   43 56 56043         https://data.medicare.gov/resource/xubh-q36u/row-wgjq-rwdt.3x58 531306 649859 2019-06-03 2018-12-31 18           18               18
3211 3211 OGALLALA COMMUNITY HOSPITAL 2601 NORTH SPRUCE ST OGALLALA NE 69153 KEITH (308) 284-4011 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.1501770 -101.7204470 0   101 31 31101         https://data.medicare.gov/resource/xubh-q36u/row-g68g~zk9i.gtc5 281355 650174 2019-06-03 2018-12-31 18           18               18
573 573 WICKENBURG COMMUNITY HOSPITAL 520 ROSE LANE WICKENBURG AZ 85390 MARICOPA (928) 684-5421 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.9780560 -112.7388250 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-mqi4.ug34.a4ib 31300 649069 2019-06-03 2018-12-31 19           19               19
2242 2242 KIT CARSON COUNTY MEMORIAL HOSPITAL 286 16TH ST BURLINGTON CO 80807 KIT CARSON (719) 346-5311 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.3023780 -102.2707110 0   63 8 8063         https://data.medicare.gov/resource/xubh-q36u/row-xqzu-2pvu-xrfj 61313 648525 2019-06-03 2018-12-31 19           19               19
620 620 GREAT FALLS CLINIC HOSPITAL 3010 15TH AVENUE SOUTH GREAT FALLS MT 59405 CASCADE (406) 216-8000 Acute Care Hospitals Proprietary TRUE 47.4877370 -111.2545610 0   13 30 30013 24500   Central Cascade County https://data.medicare.gov/resource/xubh-q36u/row-zzvw_fvcf~g44t 270086 651217 2019-06-03 2018-12-31 20           20               20
1190 1190 FOUNDATION SURGICAL HOSPITAL OF SAN ANTONIO 9522 HUEBNER ROAD SAN ANTONIO TX 78240 BEXAR (210) 478-5400 Acute Care Hospitals Proprietary TRUE 29.5310350 -98.5925540 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-pvs4~yydr-y7qv 670054 649387 2019-06-03 2018-12-31 20           20               20
2916 2916 CLIFTON FINE HOSPITAL 1014 OSWEGATCHIE TRAIL STAR LAKE NY 13690 ST. LAWRENCE (315) 848-3351 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.1629530 -75.0559640 0   89 36 36089 36300   Central St. Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-4e7w~nndx-wvba 331307 650877 2019-06-03 2018-12-31 20           20               20
3066 3066 COORDINATED HEALTH ORTHOPEDIC HOSPITAL 2310 HIGHLAND AVENUE BETHLEHEM PA 18017 NORTHAMPTON (610) 691-4300 Acute Care Hospitals Physician FALSE 40.6737620 -75.3654010 0   95 42 42095 10900 New York-Newark, NY-NJ-CT-PA Central Northampton County https://data.medicare.gov/resource/xubh-q36u/row-sc4k-g4c8.mwqt 390314 651057 2019-06-03 2018-12-31 20           20               20
3650 3650 MERRICK MEDICAL CENTER 1715 26TH ST CENTRAL CITY NE 68826 MERRICK (308) 946-3015 Critical Access Hospitals Government - Local TRUE 41.1066100 -98.0026520 0   121 31 31121 24260   Outlying Merrick County https://data.medicare.gov/resource/xubh-q36u/row-tf8v-t66v_jxv4 281328 649920 2019-06-03 2018-12-31 20           20               20
3939 3939 NORTHWEST HEALTH PHYSICIANS SPECIALTY HOSPITAL 3873 NORTH PARKVIEW DRIVE FAYETTEVILLE AR 72703 WASHINGTON (479) 571-7002 Acute Care Hospitals Proprietary TRUE 36.1213300 -94.1337300 0   143 5 5143 22220   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-dtfa_7iaz.thv8 40152 650236 2019-06-03 2018-12-31 20           20               20
4625 4625 BAYLOR SCOTT & WHITE TEXAS SPINE & JOINT HOSPITAL 1814 ROSELAND BOULEVARD TYLER TX 75701 SMITH (903) 525-3300 Acute Care Hospitals Physician TRUE 32.3292480 -95.2994670 0   423 48 48423 46340 Tyler-Jacksonville, TX Central Smith County https://data.medicare.gov/resource/xubh-q36u/row-id2a~8wab-iya8 450864 649358 2019-06-03 2018-12-31 20           20               20
607 607 BIENVILLE MEDICAL CENTER 1175 PINE STREET ARCADIA LA 71001 BIENVILLE (318) 263-4700 Critical Access Hospitals Proprietary TRUE 32.5530850 -92.9157770 0   13 22 22013         https://data.medicare.gov/resource/xubh-q36u/row-ui8b~9pic.2t2z 191320 650142 2019-06-03 2018-12-31 21           21               21
4297 4297 GOODLAND REGIONAL MEDICAL CENTER 220 WEST SECOND STREET GOODLAND KS 67735 SHERMAN (785) 890-3625 Critical Access Hospitals Government - Local TRUE 39.3575900 -101.7132560 0   181 20 20181         https://data.medicare.gov/resource/xubh-q36u/row-5axd_6ykz-azjm 171370 650580 2019-06-03 2018-12-31 21           21               21
2387 2387 BANNER FORT COLLINS MEDICAL CENTER 4700 LADY MOON DRIVE FORT COLLINS CO 80528 LARIMER (970) 821-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.5211170 -105.0108850 0   69 8 8069 22660   Central Larimer County https://data.medicare.gov/resource/xubh-q36u/row-t2c3_t3mg_dfjd 60126 652186 2019-06-03 2018-12-31 23           23               23
3401 3401 OKLAHOMA SPINE HOSPITAL 14101 PARKWAY COMMONS DRIVE OKLAHOMA CITY OK 73134 OKLAHOMA (405) 749-2700 Acute Care Hospitals Physician TRUE 35.6141370 -97.5821240 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-g6tz_y8sg_qryk 370206 648756 2019-06-03 2018-12-31 23           23               23
34 34 FRIO REGIONAL HOSPITAL 200 S IH 35 PEARSALL TX 78061 FRIO (830) 334-3617 Critical Access Hospitals Voluntary non-profit - Private TRUE 28.8970480 -99.1160130 0   163 48 48163         https://data.medicare.gov/resource/xubh-q36u/row-9gys.vgtu~2pyx 451391 650214 2019-06-03 2018-12-31 24           24               24
785 785 ROTHMAN ORTHOPAEDIC SPECIALTY HOSPITAL LLC 3300 TILLMAN DRIVE BENSALEM PA 19020 BUCKS (215) 244-7400 Acute Care Hospitals Proprietary FALSE 40.1143500 -74.9620930 0   17 42 42017 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Bucks County https://data.medicare.gov/resource/xubh-q36u/row-w5gs-9pze-8zau 390322 649490 2019-06-03 2018-12-31 24           24               24
3156 3156 COMMUNITY HOSPITAL OF BREMEN INC 1020 HIGH RD BREMEN IN 46506 MARSHALL (574) 546-2211 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4569400 -86.1579220 0   99 18 18099 38500 South Bend-Elkhart-Mishawaka, IN-MI Central Marshall County https://data.medicare.gov/resource/xubh-q36u/row-q5gf_v2gt_2uuk 151300 649572 2019-06-03 2018-12-31 24           24               24
4043 4043 CRETE AREA MEDICAL CENTER P O BOX 220, 2910 BETTEN DR CRETE NE 68333 SALINE (402) 826-2101 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.6407290 -96.9377207 1 ROOFTOP 151 31 31151         https://data.medicare.gov/resource/xubh-q36u/row-r9d7_ysji.sjzi 281354 649921 2019-06-03 2018-12-31 24           24               24
4270 4270 WYANDOT MEMORIAL HOSPITAL 885 NORTH SANDUSKY AVENUE UPPER SANDUSKY OH 43351 WYANDOT (419) 294-4991 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.8418840 -83.2807200 0   175 39 39175         https://data.medicare.gov/resource/xubh-q36u/row-7m8m~3eqa_t4vr 361329 649655 2019-06-03 2018-12-31 19   5       24               24
21 21 HORN MEMORIAL HOSPITAL 701 E 2ND ST IDA GROVE IA 51445 IDA (712) 364-3311 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.3393030 -95.4589100 0   93 19 19093         https://data.medicare.gov/resource/xubh-q36u/row-ct62_kkw5_7j35 161354 649735 2019-06-03 2018-12-31 25           25               25
249 249 TRI-STATE MEMORIAL HOSPITAL 1221 HIGHLAND AVENUE CLARKSTON WA 99403 ASOTIN (509) 758-5511 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4036380 -117.0545070 0   3 53 53003 30300   Central Asotin County https://data.medicare.gov/resource/xubh-q36u/row-i7hs.ad2c-g7gn 501332 649847 2019-06-03 2018-12-31 25           25               25
257 257 PAGE HOSPITAL 501 NORTH NAVAJO DRIVE PAGE AZ 86040 COCONINO (928) 645-2424 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.9169600 -111.4631860 0   5 4 4005 22380   Central Coconino County https://data.medicare.gov/resource/xubh-q36u/row-pwtm.vez8_t2h2 31304 649070 2019-06-03 2018-12-31 25           25               25
337 337 BANNER PAYSON MEDICAL CENTER 807 SOUTH PONDEROSA DRIVE PAYSON AZ 85541 GILA (928) 474-3222 Critical Access Hospitals Voluntary non-profit - Other FALSE 34.2313510 -111.3213610 0   7 4 4007 37740   Central Gila County https://data.medicare.gov/resource/xubh-q36u/row-2gy2.vxfy~pkyq 31318 649532 2019-06-03 2018-12-31 21 4         25               25
378 378 UNIVERSITY HOSPITALS CONNEAUT MEDICAL CENTER 158 WEST MAIN ROAD CONNEAUT OH 44030 ASHTABULA (440) 593-1131 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.9369200 -80.5864590 0   7 39 39007 11780 Cleveland-Akron-Canton, OH Central Ashtabula County https://data.medicare.gov/resource/xubh-q36u/row-j92a_zjx7-y5bm 361308 649653 2019-06-03 2018-12-31 20 5         25               25
379 379 UHHS MEMORIAL HOSPITAL OF GENEVA 870 WEST MAIN STREET GENEVA OH 44041 ASHTABULA (440) 466-1141 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.8002330 -80.9622770 0   7 39 39007 11780 Cleveland-Akron-Canton, OH Central Ashtabula County https://data.medicare.gov/resource/xubh-q36u/row-f7rd~3d3q.5pjc 361307 649652 2019-06-03 2018-12-31 20 5         25               25
397 397 LAKE CHELAN COMMUNITY HOSPITAL 503 EAST HIGHLAND CHELAN WA 98816 CHELAN (509) 682-3300 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.8451390 -120.0105110 0   7 53 53007 48300   Central Chelan County https://data.medicare.gov/resource/xubh-q36u/row-a77p~uq78~jh3e 501334 651089 2019-06-03 2018-12-31 25           25               25
720 720 COMMUNITY HOSPITAL 2000 CAMPBELL DRIVE TORRINGTON WY 82240 GOSHEN (307) 532-4181 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.0817650 -104.1915090 0   15 56 56015         https://data.medicare.gov/resource/xubh-q36u/row-cdm5.gqxc~vfiz 531307 649980 2019-06-03 2018-12-31 25           25               25
882 882 PIGGOTT COMMUNITY HOSPITAL 216 EAST MAIN STREET PIGGOTT AR 72454 CLAY (870) 598-3881 Critical Access Hospitals Government - Local TRUE 36.3820190 -90.1884430 0   21 5 5021         https://data.medicare.gov/resource/xubh-q36u/row-73yu_ywme-uu8m 41330 649163 2019-06-03 2018-12-31 25           25               25
940 940 CHOCTAW GENERAL HOSPITAL 401 VANITY FAIR LANE, PO BOX 618 BUTLER AL 36904 CHOCTAW (205) 459-9100 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.0937419 -88.2095888 1 ROOFTOP 23 1 1023         https://data.medicare.gov/resource/xubh-q36u/row-cm2u-i8id~q257 11304 651161 2019-06-03 2018-12-31 25           25               25
960 960 H C WATKINS MEMORIAL HOSPITAL INC 605 SOUTH ARCHUSA AVENUE QUITMAN MS 39355 CLARKE (601) 776-6925 Critical Access Hospitals Voluntary non-profit - Other TRUE 32.0312590 -88.7279550 0   23 28 28023 32940   Outlying Clarke County https://data.medicare.gov/resource/xubh-q36u/row-7ipq~zmm9-gyn8 251316 650283 2019-06-03 2018-12-31 25           25               25
1034 1034 CIMARRON MEMORIAL HOSPITAL 100 SOUTH ELLIS BOISE CITY OK 73933 CIMARRON (580) 544-2501 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.7290550 -102.5175370 0   25 40 40025         https://data.medicare.gov/resource/xubh-q36u/row-9zte.pc9m_addj 371307 650201 2019-06-03 2018-12-31 25           25               25
1042 1042 KANE COUNTY HOSPITAL 355 NORTH MAIN STREET KANAB UT 84741 KANE (435) 644-5811 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.0543240 -112.5285900 0   25 49 49025         https://data.medicare.gov/resource/xubh-q36u/row-g8j5_itr8_6iiy 461309 649842 2019-06-03 2018-12-31 25           25               25
1300 1300 ST CHARLES MADRAS 470 NE A STREET MADRAS OR 97741 JEFFERSON (541) 475-3882 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.6373620 -121.1213580 0   31 41 41031         https://data.medicare.gov/resource/xubh-q36u/row-c49r.t2un~9r3e 381324 651053 2019-06-03 2018-12-31 25           25               25
1308 1308 PLATTE COUNTY MEMORIAL HOSPITAL 201 14TH STREET WHEATLAND WY 82201 PLATTE (307) 322-3636 Critical Access Hospitals Government - Local TRUE 42.0498100 -104.9602210 0   31 56 56031         https://data.medicare.gov/resource/xubh-q36u/row-xwas~nr7a-7yiz 531305 649858 2019-06-03 2018-12-31 25           25               25
1313 1313 SUTTER LAKESIDE HOSPITAL 5176 HILL ROAD EAST LAKEPORT CA 95453 LAKE (707) 262-5000 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1051750 -122.9082380 0   33 6 6033 17340   Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-eiws_bxxs~n9dn 51329 650960 2019-06-03 2018-12-31 21 4         25               25
1646 1646 CARROLL COUNTY MEMORIAL HOSPITAL 309 ELEVENTH STREET CARROLLTON KY 41008 CARROLL (502) 732-4321 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.6799040 -85.1693140 0   41 21 21041         https://data.medicare.gov/resource/xubh-q36u/row-ttr6_yqtq-pq69 181310 649240 2019-06-03 2018-12-31 25           25               25
1741 1741 HAYES GREEN BEACH MEMORIAL HOSPITAL 321 E HARRIS STREET CHARLOTTE MI 48813 EATON (517) 543-1050 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.5649280 -84.8318260 0   45 26 26045 29620 Lansing-East Lansing-Owosso, MI Central Eaton County https://data.medicare.gov/resource/xubh-q36u/row-ty8n~pfwz_x66j 231327 649907 2019-06-03 2018-12-31 25           25               25
1778 1778 MARGARET MARY HEALTH 321 MITCHELL AVE BATESVILLE IN 47006 FRANKLIN (812) 934-6624 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3061410 -85.2227030 0   47 18 18047         https://data.medicare.gov/resource/xubh-q36u/row-dzet~b6y3_gi2k 151329 649577 2019-06-03 2018-12-31 18 7         25               25
1881 1881 OCEAN BEACH HOSPITAL 174 FIRST AVENUE NORTH ILWACO WA 98624 PACIFIC (360) 642-3181 Critical Access Hospitals Government - State TRUE 46.3116960 -124.0433520 0   49 53 53049         https://data.medicare.gov/resource/xubh-q36u/row-6yj2-723x_f5cn 501314 649845 2019-06-03 2018-12-31 25           25               25
2059 2059 GRITMAN MEDICAL CENTER 700 SOUTH MAIN STREET MOSCOW ID 83843 LATAH (208) 882-4511 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.7287040 -117.0014060 0   57 16 16057 34140 Pullman-Moscow, WA-ID Central Latah County https://data.medicare.gov/resource/xubh-q36u/row-x6ja_wsrd-c6wh 131327 659244 2019-06-03 2018-12-31 22 3         25               25
2404 2404 JOHN C STENNIS MEMORIAL HOSPITAL 14365 HIGHWAY 16 WEST DE KALB MS 39328 KEMPER (769) 486-1000 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.7768190 -88.6791220 0   69 28 28069 32940   Outlying Kemper County https://data.medicare.gov/resource/xubh-q36u/row-rjr3_kmd7~yci5 251335 650500 2019-06-03 2018-12-31 25           25               25
2527 2527 FRANCISCAN HEALTH RENSSELAER, INC 1104 E GRACE ST RENSSELAER IN 47978 JASPER (219) 866-5141 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.9336000 -87.1383570 0   73 18 18073 16980 Chicago-Naperville, IL-IN-WI Outlying Jasper County https://data.medicare.gov/resource/xubh-q36u/row-agmh.b8j2-sp7x 151324 649574 2019-06-03 2018-12-31 21 4         25               25
2566 2566 STERLING REGIONAL MEDCENTER 615 FAIRHURST ST STERLING CO 80751 LOGAN (970) 522-0122 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6136840 -103.2205240 0   75 8 8075 44540   Central Logan County https://data.medicare.gov/resource/xubh-q36u/row-9a6c-t2v5_2d88 60076 652859 2019-06-03 2018-12-31 21 4         25               25
2848 2848 EAST MORGAN COUNTY HOSPITAL 2400 WEST EDISON STREET BRUSH CO 80723 MORGAN (970) 842-6222 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.2547380 -103.6491780 0   87 8 8087 22820   Central Morgan County https://data.medicare.gov/resource/xubh-q36u/row-33cv-duhz_he5u 61303 649171 2019-06-03 2018-12-31 25           25               25
2875 2875 THEDACARE MEDICAL CENTER NEW LONDON 1405 MILL ST NEW LONDON WI 54961 WAUPACA (920) 531-2000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3816680 -88.7331240 0   87 55 55087 11540 Appleton-Oshkosh-Neenah, WI Central Outagamie County https://data.medicare.gov/resource/xubh-q36u/row-3ckm-rirg.mkfx 521326 650927 2019-06-03 2018-12-31 25           25               25
3208 3208 LAIRD HOSPITAL INC 25117 HIGHWAY 15 UNION MS 39365 NESHOBA (601) 774-8214 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.5592070 -89.1025610 0   101 28 28101         https://data.medicare.gov/resource/xubh-q36u/row-68dt.7k6k_jc9z 251322 649458 2019-06-03 2018-12-31 25           25               25
3349 3349 WHEATLAND MEMORIAL HOSPITAL 530 3RD ST NW HARLOWTON MT 59036 WHEATLAND (406) 632-4351 Critical Access Hospitals Government - Local TRUE 46.4370010 -109.8405050 0   107 30 30107         https://data.medicare.gov/resource/xubh-q36u/row-ttwx.8piz~nq2c 271321 651017 2019-06-03 2018-12-31 25           25               25
3543 3543 THEDACARE MEDICAL CENTER - SHAWANO INC 100 COUNTY RD B SHAWANO WI 54166 SHAWANO (715) 526-2111 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.7616060 -88.6066140 0   115 55 55115 43020 Green Bay-Shawano, WI Central Shawano County https://data.medicare.gov/resource/xubh-q36u/row-qgrf.mty3-fgdf 521346 650929 2019-06-03 2018-12-31 25           25               25
3555 3555 RIVERSIDE MEDICAL CENTER 1900 SOUTH MAIN ST FRANKLINTON LA 70438 WASHINGTON (985) 795-4431 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.8351320 -90.1519790 0   117 22 22117 14220 New Orleans-Metairie-Hammond, LA-MS Central Washington Parish https://data.medicare.gov/resource/xubh-q36u/row-biqu.ctdj-naqx 191313 649031 2019-06-03 2018-12-31 20 5         25               25
3686 3686 SCOTT REGIONAL HOSPITAL CAH 317 HIGHWAY 13 SOUTH MORTON MS 39117 SCOTT (601) 732-6301 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.3446250 -89.6712950 0   123 28 28123         https://data.medicare.gov/resource/xubh-q36u/row-irvg-pnep~z7t3 251323 649459 2019-06-03 2018-12-31 25           25               25
3726 3726 PAULDING COUNTY HOSPITAL 1035 WEST WAYNE ST. PAULDING OH 45879 PAULDING (419) 399-1103 Critical Access Hospitals Government - Local TRUE 41.1352900 -84.6004940 0   125 39 39125         https://data.medicare.gov/resource/xubh-q36u/row-2ara~5qbu_gakf 361300 649651 2019-06-03 2018-12-31 25           25               25
3866 3866 THEDACARE MEDICAL CENTER - WAUPACA INC 800 RIVERSIDE DRIVE WAUPACA WI 54981 WAUPACA (715) 258-1000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3453330 -89.0758250 0   135 55 55135         https://data.medicare.gov/resource/xubh-q36u/row-yqc8_g9mu.8fdk 521334 650928 2019-06-03 2018-12-31 21 4         25               25
3885 3885 THEDACARE MEDICAL CENTER - WILD ROSE INC 601 GROVE AVE WILD ROSE WI 54984 WAUSHARA (920) 622-3257 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.1831430 -89.2457040 0   137 55 55137         https://data.medicare.gov/resource/xubh-q36u/row-8xiv-23ba.frav 521303 650926 2019-06-03 2018-12-31 25           25               25
3888 3888 RUSH MEMORIAL HOSPITAL 1300 N MAIN ST RUSHVILLE IN 46173 RUSH (765) 932-7513 Critical Access Hospitals Government - Local TRUE 39.6214420 -85.4447920 0   139 18 18139         https://data.medicare.gov/resource/xubh-q36u/row-bit2.6ykr-x2sd 151304 649573 2019-06-03 2018-12-31 25           25               25
3947 3947 SCOTT MEMORIAL HEALTH 1451 N GARDNER ST SCOTTSBURG IN 47170 SCOTT (812) 752-3456 Critical Access Hospitals Proprietary TRUE 38.7055250 -85.7852000 0   143 18 18143 31140 Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Outlying Scott County https://data.medicare.gov/resource/xubh-q36u/row-w3qq-86eu-wbzv 151334 649730 2019-06-03 2018-12-31 21 4         25               25
4185 4185 UNION HOSPITAL CLINTON 801 S MAIN ST CLINTON IN 47842 VERMILLION (765) 832-1234 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.6529260 -87.3982130 0   165 18 18165 45460   Outlying Vermillion County https://data.medicare.gov/resource/xubh-q36u/row-uuvc-paad_wdyp 151326 649575 2019-06-03 2018-12-31 19 6         25               25
4325 4325 STAFFORD COUNTY HOSPITAL 502 S BUCKEYE STAFFORD KS 67578 STAFFORD (620) 234-5221 Critical Access Hospitals Government - Local TRUE 37.9568590 -98.5961510 0   185 20 20185         https://data.medicare.gov/resource/xubh-q36u/row-e2nn-qquj.hgq6 171323 649591 2019-06-03 2018-12-31 25           25               25
4364 4364 SUMNER COUNTY HOSPITAL DISTRICT NO 1 601 SOUTH OSAGE STREET CALDWELL KS 67022 SUMNER (620) 845-6492 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.0262800 -97.6096160 0   191 20 20191 48620 Wichita-Arkansas City-Winfield, KS Outlying Sumner County https://data.medicare.gov/resource/xubh-q36u/row-9v8g_4uhf~am74 171329 649593 2019-06-03 2018-12-31 25           25               25
4405 4405 WASHINGTON COUNTY HOSPITAL 304 E 3RD STREET WASHINGTON KS 66968 WASHINGTON (785) 325-2211 Critical Access Hospitals Government - Local TRUE 39.8174780 -97.0455720 0   201 20 20201         https://data.medicare.gov/resource/xubh-q36u/row-hks4_sdgj_3m95 171351 649595 2019-06-03 2018-12-31 25           25               25
1575 1575 KITTITAS VALLEY COMMUNITY HOSPITAL 603 SOUTH CHESTNUT ELLENSBURG WA 98926 KITTITAS (509) 962-9841 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.9876880 -120.5367610 0   37 53 53037 21260   Central Kittitas County https://data.medicare.gov/resource/xubh-q36u/row-c8za_geg7~y7ap 501333 651088 2019-06-03 2018-12-31 19 6         25           1   26
2232 2232 EVERGREENHEALTH MONROE 14701 179TH SE MONROE WA 98272 SNOHOMISH (360) 794-7497 Acute Care Hospitals Government - Hospital District or Authority TRUE 47.8637270 -121.9906240 0   61 53 53061 42660 Seattle-Tacoma, WA Central Snohomish County https://data.medicare.gov/resource/xubh-q36u/row-usdb-25x2~srt8 500084 651085 2019-06-03 2018-12-31 23 4         27               27
1289 1289 REHOBOTH MCKINLEY CHRISTIAN HEALTH CARE SERVICES 1901 RED ROCK DRIVE GALLUP NM 87301 MCKINLEY (505) 863-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.5075000 -108.7272480 0   31 35 35031 23700   Central McKinley County https://data.medicare.gov/resource/xubh-q36u/row-6hnr~wbbc-hgrg 320038 649809 2019-06-03 2018-12-31 23 5         28           1   29
3786 3786 PATIENTS CHOICE MEDICAL CENTER 347 MAGNOLIA DRIVE RALEIGH MS 39153 SMITH (601) 782-9997 Acute Care Hospitals Proprietary FALSE 32.0009980 -89.5206670 0   129 28 28129         https://data.medicare.gov/resource/xubh-q36u/row-xqvg.aa4c-5mrs 250163 650165 2019-06-03 2018-12-31 19           19 10             29
2845 2845 SUTTER MATERNITY & SURGERY CENTER OF SANTA CRUZ 2900 CHANTICLEER AVENUE SANTA CRUZ CA 95065 SANTA CRUZ (831) 477-2200 Acute Care Hospitals Voluntary non-profit - Private FALSE 36.9878650 -121.9781800 0   87 6 6087 42100 San Jose-San Francisco-Oakland, CA Central Santa Cruz County https://data.medicare.gov/resource/xubh-q36u/row-m3f9-8jic~mqpk 50714 650660 2019-06-03 2018-12-31 30           30               30
3678 3678 WEST CARROLL MEMORIAL HOSPITAL 706 ROSS STREET OAK GROVE LA 71263 WEST CARROLL (318) 428-3237 Acute Care Hospitals Proprietary TRUE 32.8678130 -91.3831960 0   123 22 22123         https://data.medicare.gov/resource/xubh-q36u/row-nqc6-kae8-uxge 190081 649437 2019-06-03 2018-12-31 30           30               30
576 576 CORE INSTITUTE SPECIALTY HOSPITAL, THE 6501 NORTH 19TH AVENUE PHOENIX AZ 85015 MARICOPA (602) 795-6020 Acute Care Hospitals Physician FALSE 33.5318370 -112.0996140 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-ymwb.kuwb~xe6j 30108 659179 2019-06-03 2018-12-31 32           32               32
2624 2624 SURGICAL SPECIALTY CENTER AT COORDINATED HEALTH 1503 CEDAR CREST BOULEVARD ALLENTOWN PA 18104 LEHIGH (610) 871-9110 Acute Care Hospitals Physician FALSE 40.6121900 -75.5327500 0   77 42 42077 10900 New York-Newark, NY-NJ-CT-PA Central Lehigh County https://data.medicare.gov/resource/xubh-q36u/row-ecs5-8dzv.54i7 390321 650522 2019-06-03 2018-12-31 20           20       12       32
3574 3574 HILL HOSPITAL OF SUMTER COUNTY 751 DERBY DRIVE YORK AL 36925 SUMTER (205) 392-5263 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.4918250 -88.2960810 0   119 1 1119         https://data.medicare.gov/resource/xubh-q36u/row-hxjd.ga7s.xmvj 10138 651158 2019-06-03 2018-12-31 33           33               33
1999 1999 NORTHWEST SPECIALTY HOSPITAL 1593 EAST POLSTON AVENUE POST FALLS ID 83854 KOOTENAI (208) 262-2466 Acute Care Hospitals Proprietary FALSE 47.7144100 -116.9244550 0   55 16 16055 17660 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Central Kootenai County https://data.medicare.gov/resource/xubh-q36u/row-68rq_3jru~i59y 130066 649721 2019-06-03 2018-12-31 34           34               34
989 989 JACKSON MEDICAL CENTER 220 HOSPITAL DRIVE JACKSON AL 36545 CLARKE (251) 246-9021 Acute Care Hospitals Proprietary TRUE 31.5304820 -87.8931800 0   25 1 1025         https://data.medicare.gov/resource/xubh-q36u/row-p276~rdhi_nmej 10128 651157 2019-06-03 2018-12-31 35           35               35
2543 2543 HOCKING VALLEY COMMUNITY HOSPITAL 601 STATE ROUTE 664N LOGAN OH 43138 HOCKING (740) 380-8227 Critical Access Hospitals Voluntary non-profit - Other TRUE 39.5475040 -82.4285180 0   73 39 39073 18140 Columbus-Marion-Zanesville, OH Outlying Hocking County https://data.medicare.gov/resource/xubh-q36u/row-4idp_5ask.rtvw 361330 649656 2019-06-03 2018-12-31 21       4   25 10             35
3754 3754 SIMPSON GENERAL HOSPITAL CAH 1842 SIMPSON HIGHWAY 149 MENDENHALL MS 39114 SIMPSON (601) 847-2221 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.9680940 -89.8869960 0   127 28 28127 27140 Jackson-Vicksburg-Brookhaven, MS Outlying Simpson County https://data.medicare.gov/resource/xubh-q36u/row-garg.yvze~zuuk 251317 650844 2019-06-03 2018-12-31 25           25 10             35
656 656 HALQUIST MEMORIAL INPATIENT CENTER 4715 NORTH 15 STREET ARLINGTON VA 22205 ARLINGTON (703) 525-7070 Acute Care Hospitals Voluntary non-profit - Private FALSE 38.8879410 -77.1216690 0   13 51 51013 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Arlington County https://data.medicare.gov/resource/xubh-q36u/row-vmzf.p4zi.8e5f 490129 651083 2019-06-03 2018-12-31                         36   36
3454 3454 SAUK PRAIRIE HOSPITAL 260 26TH STREET PRAIRIE DU SAC WI 53578 SAUK (608) 643-3311 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.2877180 -89.7560720 0   111 55 55111 12660 Madison-Janesville-Beloit, WI Central Sauk County https://data.medicare.gov/resource/xubh-q36u/row-egsq~kcsf.jwct 520095 650924 2019-06-03 2018-12-31 36           36               36
1087 1087 FULTON MEDICAL CENTER LLC 10 SOUTH HOSPITAL DRIVE FULTON MO 65251 CALLAWAY (573) 642-3376 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8422470 -91.9662020 0   27 29 29027 27620   Outlying Callaway County https://data.medicare.gov/resource/xubh-q36u/row-t6sk_pcec-yuyb 260209 650171 2019-06-03 2018-12-31 18           18 19             37
168 168 THE ORTHOPAEDIC HOSPITAL OF LUTHERAN HEALTH NETWOR 7952 W JEFFERSON BLVD FORT WAYNE IN 46804 ALLEN (260) 435-2999 Acute Care Hospitals Proprietary FALSE 41.0373520 -85.2459180 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-65sn_hsdz_dbbf 150168 649728 2019-06-03 2018-12-31 39           39               39
310 310 UNIVERSITY HOSPITALS SAMARITAN MEDICAL CENTER 1025 CENTER ST ASHLAND OH 44805 ASHLAND (419) 289-0491 Acute Care Hospitals Voluntary non-profit - Other FALSE 40.8587020 -82.3104130 0   5 39 39005 11740 Mansfield-Ashland-Bucyrus, OH Central Ashland County https://data.medicare.gov/resource/xubh-q36u/row-suim.pydj-jawn 360002 649303 2019-06-03 2018-12-31 33 6         39               39

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