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

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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

filed_date (date) ✖

  • 2019-12-02 · 305 ✖
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
139 139 NORTHERN COCHISE COMMUNITY HOSPITAL, INC. 901 WEST REX ALLEN DRIVE WILLCOX AZ 85643 COCHISE (520) 384-3541 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.2642680 -109.8376130 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-ydad~45b6.8t7t 31302 660487 2019-12-02 2019-06-30 24           24       24       48
174 174 ALLEN PARISH HOSPITAL 108 6TH AVENUE KINDER LA 70648 ALLEN (337) 738-2527 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.4914530 -92.8556480 0   3 22 22003         https://data.medicare.gov/resource/xubh-q36u/row-572u~e5cv~bbuy 190133 659958 2019-12-02 2019-06-30 25           25 24             49
529 529 BAY AREA HOSPITAL 1775 THOMPSON ROAD COOS BAY OR 97420 COOS (541) 269-8124 Acute Care Hospitals Government - Hospital District or Authority TRUE 43.3858540 -124.2324630 0   11 41 41011 18300   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-nb96_ahiz~7tng 380090 662069 2019-12-02 2019-06-30 118 12         130               130
530 530 COQUILLE VALLEY HOSPITAL DISTRICT 940 EAST 5TH STREET COQUILLE OR 97423 COOS (541) 396-3101 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.1789820 -124.1791430 0   11 41 41011 18300   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-qh6s~rn9z.ntit 381312 660287 2019-12-02 2019-06-30 17           17               17
995 995 PIONEERS MEMORIAL HEALTHCARE DISTRICT 207 WEST LEGION ROAD BRAWLEY CA 92227 IMPERIAL (760) 351-3333 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.9599470 -115.5527230 0   25 6 6025 20940   Central Imperial County https://data.medicare.gov/resource/xubh-q36u/row-9jqy.yukk~78kt 50342 662026 2019-12-02 2019-06-30 99 8         107               107
1061 1061 NORTHERN INYO HOSPITAL 150 PIONEER LANE BISHOP CA 93514 INYO (760) 873-5811 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.3621080 -118.4073620 0   27 6 6027         https://data.medicare.gov/resource/xubh-q36u/row-mi4n-bdvc~nrpd 51324 661291 2019-12-02 2019-06-30 21 4         25               25
1062 1062 SOUTHERN INYO HOSPITAL 501 EAST LOCUST STREET LONE PINE CA 93545 INYO (760) 876-5501 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.6083740 -118.0581590 0   27 6 6027         https://data.medicare.gov/resource/xubh-q36u/row-wcp4_jkw5.du53 51302 659919 2019-12-02 2019-06-30 4           4       33       37
1099 1099 NORMAN REGIONAL 901 N PORTER NORMAN OK 73070 CLEVELAND (405) 307-1050 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.2302570 -97.4411170 0   27 40 40027 36420 Oklahoma City-Shawnee, OK Central Cleveland County https://data.medicare.gov/resource/xubh-q36u/row-z4m8-r75w.my3r 370008 660139 2019-12-02 2019-06-30 254 52 25       331 20 30           381
1127 1127 KERN MEDICAL CENTER 1700 MOUNT VERNON AVENUE BAKERSFIELD CA 93306 KERN (661) 326-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.3809640 -118.9675460 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-jv3w_f89d_ies4 50315 662025 2019-12-02 2019-06-30 182 12       28 222               222
1283 1283 INCLINE VILLAGE HEALTH CENTER 880 ALDER STREET INCLINE VILLAGE NV 89451 WASHOE (775) 833-4100 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2509450 -119.9538610 0   31 32 32031 39900 Reno-Carson City-Fernley, NV Central Washoe County https://data.medicare.gov/resource/xubh-q36u/row-xavt.4jau_b7jd 291301 660260 2019-12-02 2019-06-30 4           4               4
1297 1297 COMANCHE COUNTY MEMORIAL HOSPITAL 3401 WEST GORE BLVD LAWTON OK 73505 COMANCHE (580) 355-8620 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6089690 -98.4344970 0   31 40 40031 30020   Central Comanche County https://data.medicare.gov/resource/xubh-q36u/row-wn8v~6wq8.gvxz 370056 660281 2019-12-02 2019-06-30 128 20 39       187 12 30           229
1520 1520 ANTELOPE VALLEY HOSPITAL 1600 W AVE J LANCASTER CA 93534 LOS ANGELES (661) 949-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6893710 -118.1584760 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-jtig~5whv~hgpp 50056 660914 2019-12-02 2019-06-30 345 21         393               393
1569 1569 METRO NASHVILLE GENERAL HOSPITAL 1818 ALBION STREET NASHVILLE TN 37208 DAVIDSON (615) 341-4490 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.1661350 -86.8063270 0   37 47 47037 34980 Nashville-Davidson--Murfreesboro, TN Central Davidson County https://data.medicare.gov/resource/xubh-q36u/row-a69p-t6hu-kymt 440111 661105 2019-12-02 2019-06-30 82 22         114               114
1682 1682 JOHN C FREMONT HEALTHCARE DISTRICT 5189 HOSPITAL ROAD MARIPOSA CA 95338 MARIPOSA (209) 966-3631 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.5005310 -119.9769480 0   43 6 6043         https://data.medicare.gov/resource/xubh-q36u/row-fty8~tgqe.f5tj 51304 661465 2019-12-02 2019-06-30 18           18       16   1   35
1725 1725 MENDOCINO COAST DISTRICT HOSPITAL 700 RIVER DR FORT BRAGG CA 95437 MENDOCINO (707) 961-1234 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.4326130 -123.8007970 0   45 6 6045 46380   Central Mendocino County https://data.medicare.gov/resource/xubh-q36u/row-rw6t.w3x2~jyq9 51325 661292 2019-12-02 2019-06-30 21 4         25               25
1794 1794 GOTHENBURG MEMORIAL HOSPITAL 910 20TH ST GOTHENBURG NE 69138 DAWSON (308) 537-3661 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.9381320 -100.1533520 0   47 31 31047 30420   Central Dawson County https://data.medicare.gov/resource/xubh-q36u/row-dgzd-a44k.k83g 281313 661037 2019-12-02 2019-06-30 12           12               12
1872 1872 LECOM HEALTH CORRY MEMORIAL HOSPITAL 965 SHAMROCK LANE CORRY PA 16407 ERIE (814) 664-4641 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.9353790 -79.6128910 0   49 42 42049 21500 Erie-Meadville, PA Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-pwex-5ih7_humz 391308 660305 2019-12-02 2019-06-30 20           20               20
2085 2085 HARMON MEMORIAL HOSPITAL 400 EAST CHESTNUT STREET HOLLIS OK 73550 HARMON (580) 688-3363 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.6915370 -99.9143660 0   57 40 40057         https://data.medicare.gov/resource/xubh-q36u/row-uie3-brwx.iwxd 371338 661083 2019-12-02 2019-06-30 22           22               22
2287 2287 SAN GORGONIO MEMORIAL HOSPITAL 600 NORTH HIGHLAND SPRINGS AVENUE BANNING CA 92220 RIVERSIDE (951) 845-1121 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.9316874 -116.9461472 1 ROOFTOP 65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-v72w~xz4e~mtkk 50054 660165 2019-12-02 2019-06-30 55 6         61               61
2312 2312 ROUNDUP MEMORIAL HEALTHCARE 1202 3RD ST W ROUNDUP MT 59072 MUSSELSHELL (406) 323-2301 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.4533500 -108.5463330 0   65 30 30065         https://data.medicare.gov/resource/xubh-q36u/row-4hiv-3ibs~jee7 271346 661357 2019-12-02 2019-06-30 25           25               25
2386 2386 HAZEL HAWKINS MEMORIAL HOSPITAL 911 SUNSET DRIVE HOLLISTER CA 95023 SAN BENITO (831) 637-5711 Acute Care Hospitals Government - Hospital District or Authority FALSE 36.8351220 -121.3866200 0   69 6 6069 41940 San Jose-San Francisco-Oakland, CA Outlying San Benito County https://data.medicare.gov/resource/xubh-q36u/row-z5mt_ehjz~v7xh 50296 661288 2019-12-02 2019-06-30 41 8         49       119       168
2506 2506 PALOMAR HEALTH DOWNTOWN CAMPUS 555 EAST VALLEY PARKWAY ESCONDIDO CA 92025 SAN DIEGO (760) 739-3000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.1259370 -117.0761860 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-75ug~bcqe_4ycp 50115 660353 2019-12-02 2019-06-30 238 48         286 25 18           329
2518 2518 POMERADO HOSPITAL 15615 POMERADO ROAD POWAY CA 92064 SAN DIEGO (858) 485-6511 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.9968020 -117.0578520 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-4898.b6y5.nvpq 50636 660919 2019-12-02 2019-06-30 79 12       4 95 12     129       236
2519 2519 TRI-CITY MEDICAL CENTER 4002 VISTA WAY OCEANSIDE CA 92056 SAN DIEGO (760) 724-8411 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.1837830 -117.2909180 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-hngp~yjnr~dx2a 50128 662018 2019-12-02 2019-06-30 242 28       20 290 5 10           305
2652 2652 PRAIRIE COMMUNITY HOSPITAL 312 S ADAMS TERRY MT 59349 PRAIRIE (406) 635-5511 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.7915060 -105.3159970 0   79 30 30079         https://data.medicare.gov/resource/xubh-q36u/row-cwxm-q75h-madz 271309 660253 2019-12-02 2019-06-30 22           22               22
2667 2667 HENRY COUNTY MEDICAL CENTER 301 TYSON AV PARIS TN 38242 HENRY (731) 642-1220 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.2968020 -88.3112710 0   79 47 47079 37540   Central Henry County https://data.medicare.gov/resource/xubh-q36u/row-ru8t~pc2a_mnkm 440132 661107 2019-12-02 2019-06-30 55   9       64 22             86
2732 2732 ATHENS LIMESTONE HOSPITAL 700 WEST MARKET STREET ATHENS AL 35611 LIMESTONE (256) 233-9292 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.8034990 -86.9778030 0   83 1 1083 26620 Huntsville-Decatur-Albertville, AL Outlying Limestone County https://data.medicare.gov/resource/xubh-q36u/row-nzdh.hdic_txkm 10079 660159 2019-12-02 2019-06-30 56 10         66               66
2738 2738 LOMPOC VALLEY MEDICAL CENTER 1515 E OCEAN AVENUE LOMPOC CA 93436 SANTA BARBARA (805) 737-3300 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6406390 -120.4398990 0   83 6 6083 42200   Central Santa Barbara County https://data.medicare.gov/resource/xubh-q36u/row-9waa-2p9w-xqwe 50110 660915 2019-12-02 2019-06-30 54 6         60       110       170
2879 2879 HUNTSVILLE HOSPITAL 101 SIVLEY RD HUNTSVILLE AL 35801 MADISON (256) 265-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.7212260 -86.5815470 0   89 1 1089 26620 Huntsville-Decatur-Albertville, AL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-srfb_s9fq-erqf 10039 660063 2019-12-02 2019-06-30 713 42 20   25   877 35             912
2888 2888 EMORY HILLANDALE HOSPITAL 2801 DEKALB MEDICAL PARKWAY LITHONIA GA 30058 DE KALB (404) 501-8040 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.7054880 -84.1469270 0   89 13 13089 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central DeKalb County https://data.medicare.gov/resource/xubh-q36u/row-mkqk.2abm~442s 110226 660924 2019-12-02 2019-06-30 82 8         90               90
3078 3078 SONOMA VALLEY HOSPITAL 347 ANDRIEUX ST SONOMA CA 95476 SONOMA (707) 935-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 38.2885640 -122.4658500 0   97 6 6097 42220 San Jose-San Francisco-Oakland, CA Central Sonoma County https://data.medicare.gov/resource/xubh-q36u/row-qdpm~37ez~79pv 50090 662015 2019-12-02 2019-06-30 42 6         48       27       75
3126 3126 MUENSTER MEMORIAL HOSPITAL 605 N MAPLE STREET MUENSTER TX 76252 COOKE (940) 759-2271 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.6538650 -97.3798350 0   97 48 48097 23620 Dallas-Fort Worth, TX-OK Central Cooke County https://data.medicare.gov/resource/xubh-q36u/row-tkmv_gjc7.fa5r 451335 660475 2019-12-02 2019-06-30 18           18               18
3137 3137 OAK VALLEY HOSPITAL DISTRICT 350 S OAK AVE OAKDALE CA 95361 STANISLAUS (209) 847-3011 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7580980 -120.8603630 0   99 6 6099 33700 Modesto-Merced, CA Central Stanislaus County https://data.medicare.gov/resource/xubh-q36u/row-ehek_q3if-kskp 50067 660166 2019-12-02 2019-06-30 30 5         35       115       150
3844 3844 EASTLAND MEMORIAL HOSPITAL 304 S DAUGHERTY EASTLAND TX 76448 EASTLAND (254) 629-2601 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.4004390 -98.8216360 0   133 48 48133         https://data.medicare.gov/resource/xubh-q36u/row-uts8~dkzz-h488 450411 660325 2019-12-02 2019-06-30 36           36               36
3859 3859 PERKINS COUNTY HEALTH SERVICES 900 LINCOLN AVE GRANT NE 69140 PERKINS (308) 352-7200 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.8482680 -101.7271820 0   135 31 31135         https://data.medicare.gov/resource/xubh-q36u/row-g4pp~ymgi-thrv 281356 661045 2019-12-02 2019-06-30 20           20           50   70
3943 3943 HIGGINS GENERAL HOSPITAL 200 ALLEN MEMORIAL DRIVE BREMEN GA 30110 HARALSON (770) 812-2000 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.7163430 -85.1446230 0   143 13 13143 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Haralson County https://data.medicare.gov/resource/xubh-q36u/row-rd44_uqxz.t5yc 111320 660206 2019-12-02 2019-06-30 15           15               15
4256 4256 PENDER COMMUNITY HOSPITAL P O BOX 100, 100 HOSPITAL DRIVE PENDER NE 68047 THURSTON (402) 385-3083 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.1055877 -96.7110334 1 ROOFTOP 173 31 31173         https://data.medicare.gov/resource/xubh-q36u/row-iane_yp36_h5j2 281349 661213 2019-12-02 2019-06-30 21           21               21
4564 4564 WAYNE MEMORIAL HOSPITAL 865 SOUTH FIRST STREET JESUP GA 31545 WAYNE (912) 530-3302 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.6029520 -81.8990940 0   305 13 13305 27700   Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-de2e.7sgx-hidy 110124 660369 2019-12-02 2019-06-30 76 12         88               88
17 17 VAN DIEST MEDICAL CENTER 2350 HOSPITAL DRIVE WEBSTER CITY IA 50595 HAMILTON (515) 832-9400 Critical Access Hospitals Government - Local TRUE 42.4529630 -93.8134850 0   79 19 19079         https://data.medicare.gov/resource/xubh-q36u/row-89tb_yu6c_zwc4 161361 660984 2019-12-02 2019-06-30 25           25               25
35 35 HAWARDEN REGIONAL HEALTHCARE 1111 11TH STREET HAWARDEN IA 51023 SIOUX (712) 551-3100 Critical Access Hospitals Government - Local TRUE 42.9980080 -96.4794270 0   167 19 19167         https://data.medicare.gov/resource/xubh-q36u/row-i52u~xknc.njpg 161311 660957 2019-12-02 2019-06-30 25           25               25
69 69 ADAIR COUNTY MEMORIAL HOSPITAL 609 SE KENT GREENFIELD IA 50849 ADAIR (641) 743-2123 Critical Access Hospitals Government - Local TRUE 41.3031030 -94.4519270 0   1 19 19001         https://data.medicare.gov/resource/xubh-q36u/row-3dt7_nstz~yhhy 161310 660956 2019-12-02 2019-06-30 25           25               25
274 274 VETERANS MEMORIAL HOSPITAL 40 1ST STREET SE WAUKON IA 52172 ALLAMAKEE (563) 568-3411 Critical Access Hospitals Government - Local TRUE 43.2680920 -91.4744460 0   5 19 19005         https://data.medicare.gov/resource/xubh-q36u/row-kmrq-g36y.pe5i 161318 660959 2019-12-02 2019-06-30 25           25               25
329 329 BOONE MEMORIAL HOSPITAL 701 MADISON AVENUE MADISON WV 25130 BOONE (304) 369-1230 Critical Access Hospitals Government - Local TRUE 38.0486360 -81.8065320 0   5 54 54005 16620 Charleston-Huntington-Ashland, WV-OH-KY Outlying Boone County https://data.medicare.gov/resource/xubh-q36u/row-r4j3~ibqd.28ff 511313 661267 2019-12-02 2019-06-30 25           25               25
469 469 WEIRTON MEDICAL CENTER 601 COLLIERS WAY WEIRTON WV 26062 HANCOCK (304) 797-6000 Acute Care Hospitals Government - Local TRUE 40.3937260 -80.5297390 0   9 54 54009 48260 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Brooke County https://data.medicare.gov/resource/xubh-q36u/row-kane-jbhj.6jim 510023 661436 2019-12-02 2019-06-30 117 10         127   7   33       167
587 587 CONTRA COSTA REGIONAL MEDICAL CENTER 2500 ALHAMBRA AVENUE MARTINEZ CA 94553 CONTRA COSTA (925) 370-5000 Acute Care Hospitals Government - Local TRUE 38.0064670 -122.1308910 0   13 6 6013 41860 San Jose-San Francisco-Oakland, CA Outlying Contra Costa County https://data.medicare.gov/resource/xubh-q36u/row-iuri_7t24.rw23 50276 660491 2019-12-02 2019-06-30 110 8       6 124 23             147
622 622 BOX BUTTE GENERAL HOSPITAL P O BOX 810, 2101 BOX BUTTE AVE ALLIANCE NE 69301 BOX BUTTE (308) 762-6660 Critical Access Hospitals Government - Local TRUE 42.0984344 -102.8703880 1 ROOFTOP 13 31 31013         https://data.medicare.gov/resource/xubh-q36u/row-gsu6_furw.wta3 281360 661047 2019-12-02 2019-06-30 25           25               25
681 681 BOONE COUNTY HOSPITAL 1015 UNION STREET BOONE IA 50036 BOONE (515) 432-3140 Critical Access Hospitals Government - Local TRUE 42.0555830 -93.8770370 0   15 19 19015 14340 Des Moines-Ames-West Des Moines, IA Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-6zpe~cgwm_xs5p 161372 660987 2019-12-02 2019-06-30 25           25               25
752 752 CAMBRIDGE HEALTH ALLIANCE 1493 CAMBRIDGE STREET CAMBRIDGE MA 2138 MIDDLESEX (617) 665-2300 Acute Care Hospitals Government - Local TRUE 42.3741860 -71.1044550 0   17 25 25017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-gyrk~893u_u5y7 220011 662215 2019-12-02 2019-06-30 182 18         200 62             262
964 964 BUTLER COUNTY HEALTH CARE CENTER 372 SOUTH 9TH ST DAVID CITY NE 68632 BUTLER (402) 367-1200 Critical Access Hospitals Government - Local TRUE 41.2464710 -97.1230380 0   23 31 31023         https://data.medicare.gov/resource/xubh-q36u/row-u7xr~dyr4.b4xb 281332 661041 2019-12-02 2019-06-30 20           20               20
994 994 EL CENTRO REGIONAL MEDICAL CENTER 1415 ROSS AVENUE EL CENTRO CA 92243 IMPERIAL (760) 339-7100 Acute Care Hospitals Government - Local TRUE 32.7814980 -115.5686200 0   25 6 6025 20940   Central Imperial County https://data.medicare.gov/resource/xubh-q36u/row-35st~i7ay-x3eh 50045 660164 2019-12-02 2019-06-30 141 20         161               161
1376 1376 SHERIDAN MEMORIAL HOSPITAL 1401 W 5TH ST SHERIDAN WY 82801 SHERIDAN (307) 672-1044 Acute Care Hospitals Government - Local TRUE 44.8074250 -106.9755700 0   33 56 56033 43260   Central Sheridan County https://data.medicare.gov/resource/xubh-q36u/row-kh7n.rjz9.bakb 530006 661690 2019-12-02 2019-06-30 60 11         71               71
1577 1577 MEMORIAL HOSPITAL SWEETWATER COUNTY 1200 COLLEGE DRIVE ROCK SPRINGS WY 82901 SWEETWATER (307) 362-3711 Acute Care Hospitals Government - Local TRUE 41.5840600 -109.2335780 0   37 56 56037 40540   Central Sweetwater County https://data.medicare.gov/resource/xubh-q36u/row-x7m7_kvh5~qmi2 530011 661448 2019-12-02 2019-06-30 48 10         58               58
1693 1693 GUTTENBERG MUNICIPAL HOSPITAL 200 MAIN STREET GUTTENBERG IA 52052 CLAYTON (563) 252-1121 Critical Access Hospitals Government - Local TRUE 42.7855480 -91.0999540 0   43 19 19043         https://data.medicare.gov/resource/xubh-q36u/row-9vtm.kuer.r3a9 161312 660958 2019-12-02 2019-06-30 25           25               25
1791 1791 NORTH KANSAS CITY HOSPITAL 2800 CLAY EDWARDS DRIVE NORTH KANSAS CITY MO 64116 CLAY (816) 691-2000 Acute Care Hospitals Government - Local TRUE 39.1508100 -94.5518520 0   47 29 29047 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-jpk9.5ekq~fxuy 260096 661210 2019-12-02 2019-06-30 211 14 138       363   48           411
1950 1950 DECATUR COUNTY HOSPITAL 1405 NW CHURCH STREET LEON IA 50144 DECATUR (641) 446-4871 Critical Access Hospitals Government - Local TRUE 40.7503080 -93.7477890 0   53 19 19053         https://data.medicare.gov/resource/xubh-q36u/row-z8pk.dm9q_4faw 161340 660972 2019-12-02 2019-06-30 11           11               11
2069 2069 CUMBERLAND COUNTY HOSPITAL 299 GLASGOW ROAD BURKESVILLE KY 42717 CUMBERLAND (270) 864-2511 Critical Access Hospitals Government - Local TRUE 36.7968680 -85.3724400 0   57 21 21057         https://data.medicare.gov/resource/xubh-q36u/row-ptk2_m6d2-xzym 181317 661512 2019-12-02 2019-06-30 25           25               25
2489 2489 HARDIN MEDICAL CENTER 935 WAYNE ROAD SAVANNAH TN 38372 HARDIN (731) 926-8121 Acute Care Hospitals Government - Local TRUE 35.2271300 -88.2303620 0   71 47 47071         https://data.medicare.gov/resource/xubh-q36u/row-2dfc~89p6~kqtc 440109 660709 2019-12-02 2019-06-30 49           49       73       122
2528 2528 GREENE COUNTY MEDICAL CENTER 1000 WEST LINCOLNWAY JEFFERSON IA 50129 GREENE (515) 386-2114 Critical Access Hospitals Government - Local TRUE 42.0152170 -94.3890600 0   73 19 19073         https://data.medicare.gov/resource/xubh-q36u/row-ekvn-6v3z_68bn 161325 660962 2019-12-02 2019-06-30 21   4       25               25
2557 2557 LAGUNA HONDA HOSPITAL & REHABILITATION CENTER 375 LAGUNA HONDA BLVD SAN FRANCISCO CA 94116 SAN FRANCISCO (415) 759-2300 Acute Care Hospitals Government - Local FALSE 37.7478240 -122.4586360 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-tz44~vi64-ys8h 50668 662169 2019-12-02 2019-06-30 6           6   5   769       780
2594 2594 SAN JOAQUIN GENERAL HOSPITAL 500 W HOSPITAL ROAD FRENCH CAMP CA 95231 SAN JOAQUIN (209) 468-6000 Acute Care Hospitals Government - Local TRUE 37.8864920 -121.2820610 0   77 6 6077 44700 San Jose-San Francisco-Oakland, CA Central San Joaquin County https://data.medicare.gov/resource/xubh-q36u/row-imza-7dfi-q9b9 50167 661140 2019-12-02 2019-06-30 155 16       25 196               196
2904 2904 REGIONAL HEALTH SERVICES OF HOWARD COUNTY 235 8TH AVENUE WEST CRESCO IA 52136 HOWARD (563) 547-2101 Critical Access Hospitals Government - Local TRUE 43.3818910 -92.1177640 0   89 19 19089         https://data.medicare.gov/resource/xubh-q36u/row-cg3w~i3hb_y7gu 161328 660965 2019-12-02 2019-06-30 18           18           1   19
3106 3106 JACKSON COUNTY REGIONAL HEALTH CENTER 700 W GROVE ST MAQUOKETA IA 52060 JACKSON (563) 652-2474 Critical Access Hospitals Government - Local TRUE 42.0737150 -90.6731320 0   97 19 19097         https://data.medicare.gov/resource/xubh-q36u/row-cqwp_hqw2.ikei 161329 660966 2019-12-02 2019-06-30 25           25               25
3201 3201 JEFFERSON COUNTY HEALTH CENTER 2000 S MAIN FAIRFIELD IA 52556 JEFFERSON (641) 472-4111 Critical Access Hospitals Government - Local TRUE 40.9856350 -91.9631180 0   101 19 19101 21840   Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-cksn~64fu_7y3h 161364 660985 2019-12-02 2019-06-30 25           25               25
3240 3240 WEBSTER COUNTY MEMORIAL HOSPITAL 324 MILLER MOUNTAIN DRIVE WEBSTER SPRINGS WV 26288 WEBSTER (304) 847-5682 Critical Access Hospitals Government - Local TRUE 38.4818680 -80.4098110 0   101 54 54101         https://data.medicare.gov/resource/xubh-q36u/row-stvk~jdqs~5m5u 511301 661266 2019-12-02 2019-06-30 25           25               25
3295 3295 WETZEL COUNTY HOSPITAL #3 EAST BENJAMIN DRIVE NEW MARTINSVILLE WV 26155 WETZEL (304) 455-8000 Acute Care Hospitals Government - Local TRUE 39.6810712 -80.8501977 1 ROOFTOP 103 54 54103         https://data.medicare.gov/resource/xubh-q36u/row-v7h8~v92p-92tq 510072 661438 2019-12-02 2019-06-30 43 5         48               48
3676 3676 MAHASKA HEALTH PARTNERSHIP 1229 C AVENUE EAST OSKALOOSA IA 52577 MAHASKA (641) 672-3100 Critical Access Hospitals Government - Local TRUE 41.2985620 -92.6301310 0   123 19 19123 36820   Central Mahaska County https://data.medicare.gov/resource/xubh-q36u/row-r6q8.mtiy.cvna 161379 660990 2019-12-02 2019-06-30 25           25           1   26
3688 3688 MORRILL COUNTY COMMUNITY HOSPITAL 1313 S STREET BRIDGEPORT NE 69336 MORRILL (308) 262-1616 Critical Access Hospitals Government - Local TRUE 41.6618900 -103.0913740 0   123 31 31123         https://data.medicare.gov/resource/xubh-q36u/row-zd5w.8rx8_6yzu 281318 661038 2019-12-02 2019-06-30 20           20               20
3784 3784 MIDMICHIGAN MEDICAL CENTER - WEST BRANCH 2463 SOUTH M-30 WEST BRANCH MI 48661 OGEMAW (989) 345-6366 Acute Care Hospitals Government - Local TRUE 44.2628300 -84.2462300 0   129 26 26129         https://data.medicare.gov/resource/xubh-q36u/row-fszi_3g9m-qsjn 230095 661008 2019-12-02 2019-06-30 78   10       88               88
3878 3878 ESSENTIA HEALTH VIRGINIA 901 9TH STREET NORTH VIRGINIA MN 55792 ST. LOUIS (218) 741-3340 Acute Care Hospitals Government - Local FALSE 47.5307110 -92.5487970 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-39c9_62zv_e3w4 240084 662217 2019-12-02 2019-06-30 40 8         48   16   77       141
4235 4235 PUTNAM COUNTY MEMORIAL HOSPITAL 1926 OAK STREET, PO BOX 389 UNIONVILLE MO 63565 PUTNAM (660) 947-2411 Critical Access Hospitals Government - Local TRUE 40.4820250 -93.0059870 0   171 29 29171         https://data.medicare.gov/resource/xubh-q36u/row-ygkd_dijw_ng7v 261305 661212 2019-12-02 2019-06-30 15           15               15
4268 4268 VALLEY COUNTY HEALTH SYSTEM 2707 L STREET ORD NE 68862 VALLEY (308) 728-4200 Critical Access Hospitals Government - Local TRUE 41.6032130 -98.9426760 0   175 31 31175         https://data.medicare.gov/resource/xubh-q36u/row-y2qv_7x4q_v7xu 281353 661044 2019-12-02 2019-06-30 16           16               16
4373 4373 WILKES REGIONAL MEDICAL CENTER 1370 WEST D ST NORTH WILKESBORO NC 28659 WILKES (336) 651-8100 Acute Care Hospitals Government - Local TRUE 36.1584650 -81.1570130 0   193 37 37193 35900   Central Wilkes County https://data.medicare.gov/resource/xubh-q36u/row-mugx~rcjs~9jqq 340064 661369 2019-12-02 2019-06-30 85 8         93       10       103
4375 4375 PETERSBURG MEDICAL CENTER PO BOX 589 PETERSBURG AK 99833 PETERSBURG BOROUGH (907) 772-4291 Critical Access Hospitals Government - Local TRUE 56.8128691 -132.9554619 1 ROOFTOP 195 2 2195         https://data.medicare.gov/resource/xubh-q36u/row-ky7y_b72j_698p 21304 660160 2019-12-02 2019-06-30 12           12       15       27
4390 4390 IOWA SPECIALTY HOSPITAL-CLARION 1316 SOUTH MAIN STREET CLARION IA 50525 WRIGHT (515) 532-2811 Critical Access Hospitals Government - Local TRUE 42.7216250 -93.7326280 0   197 19 19197         https://data.medicare.gov/resource/xubh-q36u/row-qm5h-kjf7~8unb 161302 661176 2019-12-02 2019-06-30 25           25               25
82 82 KONA COMMUNITY HOSPITAL 79-1019 HAUKAPILA STREET KEALAKEKUA HI 96750 HAWAII (808) 322-9311 Acute Care Hospitals Government - State TRUE 19.5192370 -155.9177190 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-j5zq.9y53_j6as 120019 662187 2019-12-02 2019-06-30 74 9         83 11             94
84 84 KAU HOSPITAL 1 KAMANI STREET PAHALA HI 96777 HAWAII (808) 928-8331 Critical Access Hospitals Government - State TRUE 19.2005710 -155.4720970 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-jcnf-fhnk_q5i3 121301 662188 2019-12-02 2019-06-30 6           6               6
632 632 UNIVERSITY HOSPITAL 150 BERGEN ST NEWARK NJ 7101 ESSEX (973) 972-5658 Acute Care Hospitals Government - State TRUE 40.7409500 -74.1921300 0   13 34 34013 35620 New York-Newark, NY-NJ-CT-PA Central Essex County https://data.medicare.gov/resource/xubh-q36u/row-b5qq_ap3x-6s92 310119 661058 2019-12-02 2019-06-30 266 41 6       355               355
1584 1584 FLORIDA STATE HOSPITAL UNIT 31 MED 100 N MAIN ST CHATTAHOOCHEE FL 32324 GADSDEN (850) 663-7536 Acute Care Hospitals Government - State FALSE 30.7068990 -84.8425840 0   39 12 12039 45220 Tallahassee-Bainbridge, FL-GA Outlying Gadsden County https://data.medicare.gov/resource/xubh-q36u/row-kyk8-9a3q-5siu 100298 660194 2019-12-02 2019-06-30 24           24 34         1172   1230
1824 1824 WELCH COMMUNITY HOSPITAL 454 MCDOWELL STREET WELCH WV 24801 MC DOWELL (304) 436-8461 Acute Care Hospitals Government - State TRUE 37.4388220 -81.5892950 0   47 54 54047         https://data.medicare.gov/resource/xubh-q36u/row-y7rn~73h2.fggs 510086 661439 2019-12-02 2019-06-30 42 7         49         59     108
3313 3313 LALLIE KEMP MEDICAL CENTER 52579 HIGHWAY 51 SOUTH INDEPENDENCE LA 70443 TANGIPAHOA (985) 878-9421 Critical Access Hospitals Government - State TRUE 30.6221940 -90.4969990 0   105 22 22105 25220 New Orleans-Metairie-Hammond, LA-MS Central Tangipahoa Parish https://data.medicare.gov/resource/xubh-q36u/row-iyxe~6sc2-ecgv 191321 662534 2019-12-02 2019-06-30 20 4         24               24
3645 3645 WHITFIELD MEDICAL SURGICAL HOSPITAL 3550 HWY 468 W, BLDG 60 WHITFIELD MS 39193 RANKIN (601) 351-8023 Acute Care Hospitals Government - State FALSE 32.2418381 -90.0709905 1 ROOFTOP 121 28 28121 27140 Jackson-Vicksburg-Brookhaven, MS Central Rankin County https://data.medicare.gov/resource/xubh-q36u/row-h6gx_kf5u~ce53 250134 660110 2019-12-02 2019-06-30 32           32               32
4412 4412 ST LUKE'S PATIENTS MEDICAL CENTER 4600 EAST SAM HOUSTON PARKWAY SOUTH PASADENA TX 77505 HARRIS (281) 487-0700 Acute Care Hospitals Physician TRUE 29.6402610 -95.1607140 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-mh9z-apzq_zueh 670031 660343 2019-12-02 2019-06-30 53 8         61               61
348 348 SHANDS STARKE REGIONAL MEDICAL CENTER 922 E CALL ST STARKE FL 32091 BRADFORD (904) 368-2300 Critical Access Hospitals Proprietary TRUE 29.9419070 -82.1016500 0   7 12 12007         https://data.medicare.gov/resource/xubh-q36u/row-463i.u2z5-p3cq 101310 660199 2019-12-02 2019-06-30 25           25               25
744 744 RUMFORD HOSPITAL 420 FRANKLIN STREET RUMFORD ME 4276 OXFORD (207) 369-1000 Critical Access Hospitals Proprietary TRUE 44.5517210 -70.5571710 0   17 23 23017         https://data.medicare.gov/resource/xubh-q36u/row-923a_kexq.nxfx 201306 662536 2019-12-02 2019-06-30 25           25               25
926 926 CONEMAUGH MINERS MEDICAL CENTER 290 HAIDA AVENUE HASTINGS PA 16646 CAMBRIA (814) 247-3100 Acute Care Hospitals Proprietary TRUE 40.6589130 -78.7057990 0   21 42 42021 27780 Johnstown-Somerset, PA Central Cambria County https://data.medicare.gov/resource/xubh-q36u/row-atm6_mxu4.8ec2 390130 660860 2019-12-02 2019-06-30 25 5         30               30
944 944 MAD RIVER COMMUNITY HOSPITAL 3800 JANES RD ARCATA CA 95521 HUMBOLDT (707) 822-3621 Acute Care Hospitals Proprietary TRUE 40.9033090 -124.0908470 0   23 6 6023 21700   Central Humboldt County https://data.medicare.gov/resource/xubh-q36u/row-qduv~9itb_454t 50028 661454 2019-12-02 2019-06-30 41 8         49               49
1001 1001 REDINGTON FAIRVIEW GENERAL HOSPITAL 46 FAIRVIEW AVE PO BOX 468 SKOWHEGAN ME 4976 SOMERSET (207) 474-5121 Critical Access Hospitals Proprietary TRUE 44.7583360 -69.7134950 0   25 23 23025         https://data.medicare.gov/resource/xubh-q36u/row-g9mx~aw3n.5hnn 201314 661526 2019-12-02 2019-06-30 21 4         25               25
1517 1517 SAN GABRIEL VALLEY MEDICAL CENTER 438 W LAS TUNAS DRIVE SAN GABRIEL CA 91776 LOS ANGELES (626) 289-5454 Acute Care Hospitals Proprietary TRUE 34.1024610 -118.1055720 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-vsyy.e66v~akjm 50132 660490 2019-12-02 2019-06-30 156 19         187 42     44       273
1518 1518 ALHAMBRA HOSPITAL MEDICAL CENTER 100 S RAYMOND AVE ALHAMBRA CA 91801 LOS ANGELES (626) 570-1606 Acute Care Hospitals Proprietary FALSE 34.0901560 -118.1450170 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-75jx-8uav_n2er 50281 660918 2019-12-02 2019-06-30 88 13         101   17   26       144
1665 1665 CARLISLE REGIONAL MEDICAL CENTER 361 ALEXANDER SPRING ROAD CARLISLE PA 17015 CUMBERLAND (717) 249-1212 Acute Care Hospitals Proprietary TRUE 40.1847670 -77.2230070 0   41 42 42041 25420 Harrisburg-York-Lebanon, PA Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-6ch7-p7nq-3tnd 390058 661966 2019-12-02 2019-06-30 56 10         66   14           80
1686 1686 ELMHURST MEMORIAL HOSPITAL 155 EAST BRUSH HILL ROAD ELMHURST IL 60126 DU PAGE (331) 221-0130 Acute Care Hospitals Proprietary TRUE 41.8616840 -87.9342950 0   43 17 17043 16980 Chicago-Naperville, IL-IN-WI Central DuPage County https://data.medicare.gov/resource/xubh-q36u/row-bbi9~mwsc~myn8 140200 661499 2019-12-02 2019-06-30 247 35         282               282
1772 1772 VAUGHAN REGIONAL MEDICAL CENTER PARKWAY CAMPUS 1015 MEDICAL CENTER PARKWAY SELMA AL 36701 DALLAS (334) 418-4100 Acute Care Hospitals Proprietary TRUE 32.4302480 -87.0551740 0   47 1 1047 42820   Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-yhen~7fx5~f9rk 10118 660350 2019-12-02 2019-06-30 86 23         109               109
2043 2043 BLUEFIELD REGIONAL MEDICAL CENTER 500 CHERRY ST BLUEFIELD WV 24701 MERCER (304) 327-1100 Acute Care Hospitals Proprietary TRUE 37.2575170 -81.2341290 0   55 54 54055 14140   Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-kbzt.t9ci.vaxk 510071 660728 2019-12-02 2019-06-30 40 17         57               57
2459 2459 HIGHLANDS REGIONAL MEDICAL CENTER 5000 KENTUCKY ROUTE 321 PRESTONSBURG KY 41653 FLOYD (606) 886-8511 Acute Care Hospitals Proprietary TRUE 37.7105400 -82.7702500 0   71 21 21071         https://data.medicare.gov/resource/xubh-q36u/row-iny2.6yju.g3qs 180005 662526 2019-12-02 2019-06-30 115 12         127 23             150
2486 2486 UPMC LITITZ 1500 HIGHLANDS DRIVE LITITZ PA 17543 LANCASTER (717) 625-5670 Acute Care Hospitals Proprietary TRUE 40.1342570 -76.3094140 0   71 42 42071 29540   Central Lancaster County https://data.medicare.gov/resource/xubh-q36u/row-i9xj_phxc~h3r8 390068 661396 2019-12-02 2019-06-30 45 6         55               55
2589 2589 NORTH ALABAMA MEDICAL CENTER 1701 VETERANS DRIVE FLORENCE AL 35630 LAUDERDALE (256) 768-8400 Acute Care Hospitals Proprietary TRUE 34.8027560 -87.6521910 0   77 1 1077 22520   Central Lauderdale County https://data.medicare.gov/resource/xubh-q36u/row-n9pr_q6au_cg3t 10006 660158 2019-12-02 2019-06-30 181 36 16       233               233
2973 2973 VALLEY FORGE MEDICAL CENTER AND HOSPITAL 1033 W GERMANTOWN PIKE NORRISTOWN PA 19401 MONTGOMERY (215) 539-8500 Acute Care Hospitals Proprietary FALSE 40.1564300 -75.3686840 0   91 42 42091 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-wedb-6d72.5wef 390272 661256 2019-12-02 2019-06-30 50           50               50
3096 3096 MIDWESTERN REGION MED CENTER 2520 ELISHA AVENUE ZION IL 60099 LAKE (847) 872-4561 Acute Care Hospitals Proprietary TRUE 42.4489700 -87.8268400 0   97 17 17097 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-wjcc_h9y8~99z6 140100 661493 2019-12-02 2019-06-30 49 24         73               73
3628 3628 SHANDS LIVE OAK REGIONAL MEDICAL CENTER 1100 SW 11TH ST LIVE OAK FL 32060 SUWANNEE (904) 362-1413 Critical Access Hospitals Proprietary TRUE 30.2917367 -83.0028124 1 ROOFTOP 121 12 12121         https://data.medicare.gov/resource/xubh-q36u/row-keij_wts9-t8jc 101301 660198 2019-12-02 2019-06-30 25           25               25
3834 3834 PAWNEE COUNTY MEMORIAL HOSPITAL P O BOX 433, 600 I ST PAWNEE CITY NE 68420 PAWNEE (402) 852-2231 Critical Access Hospitals Proprietary TRUE 40.1098396 -96.1532422 1 ROOFTOP 133 31 31133         https://data.medicare.gov/resource/xubh-q36u/row-2ahw-y3eh_6phq 281302 661036 2019-12-02 2019-06-30 17           17               17

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