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

124 rows where "filed_date" is on date 2019-11-25 sorted by csatitle

✎ 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, skilled_nursing_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-11-25 · 124 ✖
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
2 2 HUGGINS HOSPITAL 240 SOUTH MAIN STREET WOLFEBORO NH 3894 CARROLL (603) 569-7500 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.5809440 -71.2015750 0   3 33 33003         https://data.medicare.gov/resource/xubh-q36u/row-u6j2-zv25.9ghd 301312 659991 2019-11-25 2018-09-30 21 4         25               25
32 32 SHARE MEDICAL CENTER 800 SHARE DRIVE ALVA OK 73717 WOODS (580) 327-2800 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.7869690 -98.6700230 0   151 40 40151         https://data.medicare.gov/resource/xubh-q36u/row-gzmq-89k6~9n3d 371341 659863 2019-11-25 2019-06-30 25           25         80     105
136 136 COPPER QUEEN COMMUNITY HOSPITAL 101 COLE AVENUE BISBEE AZ 85603 COCHISE (520) 432-6401 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.4172540 -109.8826000 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-3x2q~x9dv.fg6n 31312 659555 2019-11-25 2019-06-30 14           14               14
137 137 BENSON HOSPITAL 450 SOUTH OCOTILLO AVENUE BENSON AZ 85602 COCHISE (520) 586-2261 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.9648290 -110.3071230 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-bbyb-3jvj_e7ef 31301 660910 2019-11-25 2019-06-30 22           22               22
343 343 ENLOE MEDICAL CENTER 1531 ESPLANADE CHICO CA 95926 BUTTE (530) 332-7300 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7422840 -121.8491280 0   7 6 6007 17020   Central Butte County https://data.medicare.gov/resource/xubh-q36u/row-tmgf-6deh.hnij 50039 659472 2019-11-25 2019-06-30 259 33         298   40           338
359 359 MIDMICHIGAN MEDICAL CENTER - ALPENA 1501 W CHISHOLM ST ALPENA MI 49707 ALPENA (989) 356-7390 Acute Care Hospitals Proprietary TRUE 45.0768570 -83.4506720 0   7 26 26007 10980   Central Alpena County https://data.medicare.gov/resource/xubh-q36u/row-3cst~3hfe~ssf7 230036 660579 2019-11-25 2019-06-30 119 9         128   11           139
393 393 ERLANGER BLEDSOE HOSPITAL 71 WHEELERTOWN AVENUE PIKEVILLE TN 37367 BLEDSOE (423) 447-2112 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.6218300 -85.1883040 0   7 47 47007         https://data.medicare.gov/resource/xubh-q36u/row-86fw~zcvu.6xu7 441306 659536 2019-11-25 2019-06-30 25           25               25
430 430 AUDUBON COUNTY MEMORIAL HOSPITAL 515 PACIFIC AVENUE AUDUBON IA 50025 AUDUBON (712) 563-2611 Critical Access Hospitals Government - Local TRUE 41.7154230 -94.9370440 0   9 19 19009         https://data.medicare.gov/resource/xubh-q36u/row-7tp4_zwyw_2d9j 161330 659788 2019-11-25 2019-06-30 25           25               25
464 464 ST MICHAEL'S HOSPITAL - CAH 410 W 16TH AVE TYNDALL SD 57066 BON HOMME (605) 589-2100 Critical Access Hospitals Government - Local TRUE 42.9912530 -97.8678960 0   9 46 46009         https://data.medicare.gov/resource/xubh-q36u/row-sqz9_y3kz.mu4d 431327 659612 2019-11-25 2019-06-30 25           25               25
506 506 MAINEGENERAL MEDICAL CENTER 35 MEDICAL CENTER PARKWAY AUGUSTA ME 4330 KENNEBEC (207) 626-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.3608530 -69.7857180 0   11 23 23011 12300   Central Kennebec County https://data.medicare.gov/resource/xubh-q36u/row-k6q5-wdks.vqnn 200039 659964 2019-11-25 2019-06-30 156 16         172   20           192
527 527 MERCY HOSPITAL WATONGA, INC 500 NORTH CLARENCE NASH BOULEVARD WATONGA OK 73772 BLAINE (580) 623-7211 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.8494550 -98.4192480 0   11 40 40011         https://data.medicare.gov/resource/xubh-q36u/row-sccp_42z7.7ame 371302 659715 2019-11-25 2019-06-30 25           25               25
709 709 CURRY GENERAL HOSPITAL 94220 FOURTH STREET GOLD BEACH OR 97444 CURRY (541) 247-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.4116590 -124.4186580 0   15 41 41015 15060   Central Curry County https://data.medicare.gov/resource/xubh-q36u/row-9rud.6rf5~it7z 381322 659603 2019-11-25 2019-06-30 16           16               16
832 832 MILLINOCKET REGIONAL HOSPITAL 200 SOMERSET STREET MILLINOCKET ME 4462 PENOBSCOT (207) 723-5161 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.6527290 -68.7150760 0   19 23 23019 12620   Central Penobscot County https://data.medicare.gov/resource/xubh-q36u/row-j6pc.k4d7~avr8 201307 659965 2019-11-25 2019-06-30 25           25               25
852 852 MERCY HOSPITAL ARDMORE, INC 1011 FOURTEENTH AVENUE, NORTHWEST ARDMORE OK 73401 CARTER (580) 223-5400 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1884510 -97.1400180 0   19 40 40019 11620   Central Carter County https://data.medicare.gov/resource/xubh-q36u/row-vred.e6gv~ukx2 370047 659857 2019-11-25 2019-06-30 127 13         140 20 20           180
853 853 MERCY HOSPITAL HEALDTON, INC. 3462 HOSPITAL RD HEALDTON OK 73438 CARTER (580) 229-0701 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.2229910 -97.4921780 0   19 40 40019 11620   Central Carter County https://data.medicare.gov/resource/xubh-q36u/row-i6td_hvi7_qxjw 371310 659717 2019-11-25 2019-06-30 22           22               22
854 854 LOWER UMPQUA HOSPITAL DISTRICT 600 RANCH ROAD REEDSPORT OR 97467 DOUGLAS (541) 271-2171 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.6953240 -124.1355710 0   19 41 41019 40700   Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-nysc.rhhn_bb99 381311 659602 2019-11-25 2019-06-30 16           16               16
930 930 SETON SMITHVILLE REGIONAL HOSPITAL 1201 HILL RD SMITHVILLE TX 78957 BASTROP (512) 237-3214 Acute Care Hospitals Voluntary non-profit - Church TRUE 30.0039505 -97.1360218 1 ROOFTOP 21 48 48021 12420   Outlying Bastrop County https://data.medicare.gov/resource/xubh-q36u/row-d2dp~cvuc~gmre 450143 659733 2019-11-25 2019-06-30 8           8               8
1029 1029 NOR-LEA HOSPITAL DISTRICT 1600 NORTH MAIN AVE LOVINGTON NM 88260 LEA (575) 396-6611 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.9647900 -103.3486370 0   25 35 35025 26020   Central Lea County https://data.medicare.gov/resource/xubh-q36u/row-9cky_vw6p_hbsu 321305 659823 2019-11-25 2019-06-30 25           25               25
1301 1301 CLARION HOSPITAL ONE HOSPITAL DRIVE CLARION PA 16214 CLARION (814) 226-9500 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.1927583 -79.3976930 1 ROOFTOP 31 42 42031         https://data.medicare.gov/resource/xubh-q36u/row-5n3x.3zm2.8hqq 390093 660440 2019-11-25 2019-06-30 50 7         57   8           65
1307 1307 ESSENTIA HEALTH ST MARY'S HOSPITAL - SUPERIOR 3500 TOWER AVE SUPERIOR WI 54880 DOUGLAS (715) 817-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.6981950 -92.1040480 0   31 55 55031 20260   Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-e5mc~9gdv_htnc 521329 660735 2019-11-25 2019-06-30 25           25               25
1395 1395 ESSENTIA HEALTH ST JOSEPH'S MEDICAL CENTER 523 NORTH 3RD STREET BRAINERD MN 56401 CROW WING (218) 829-2861 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.3625090 -94.2051430 0   35 27 27035 14660   Central Crow Wing County https://data.medicare.gov/resource/xubh-q36u/row-qjsu~wksq.gb8w 240075 659977 2019-11-25 2019-06-30 117 10         127               127
1602 1602 COOPERSTOWN MEDICAL CENTER 1200 ROBERTS AVE NE COOPERSTOWN ND 58425 GRIGGS (701) 797-2221 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.4456240 -98.1185500 0   39 38 38039         https://data.medicare.gov/resource/xubh-q36u/row-qi2g~gwic_kc3w 351306 660659 2019-11-25 2019-06-30 18           18               18
1643 1643 SPENCER MUNICIPAL HOSPITAL 1200 1ST AVENUE EAST SPENCER IA 51301 CLAY (712) 264-8300 Acute Care Hospitals Government - Local TRUE 43.1500090 -95.1438420 0   41 19 19041 43980   Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-nipj.ewp3-j7u2 160112 660216 2019-11-25 2019-06-30 49           49 15             64
1670 1670 SAINT THOMAS DEKALB HOSPITAL 520 W MAIN ST SMITHVILLE TN 37166 DE KALB (615) 215-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 35.9594030 -85.8298410 0   41 47 47041         https://data.medicare.gov/resource/xubh-q36u/row-vj84-zvtf.4wg9 440148 659457 2019-11-25 2019-06-30 48 4         52               52
1678 1678 STONEWALL JACKSON MEMORIAL HOSPITAL 230 HOSPITAL PLAZA WESTON WV 26452 LEWIS (304) 269-8080 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0482850 -80.4927430 0   41 54 54041         https://data.medicare.gov/resource/xubh-q36u/row-2afu_zh5p.j9t2 510038 660725 2019-11-25 2019-06-30 64 6         70               70
1943 1943 NATIVIDAD MEDICAL CENTER 1441 CONSTITUTION BOULEVARD SALINAS CA 93906 MONTEREY (831) 755-4195 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.6954720 -121.6312400 0   53 6 6053 41500   Central Monterey County https://data.medicare.gov/resource/xubh-q36u/row-ye8m-fbff-nu37 50248 659560 2019-11-25 2019-06-30 123 10         148   24           172
1976 1976 SETON HIGHLAND LAKES HIGHWAY 281 SOUTH BURNET TX 78611 BURNET (512) 715-3000 Critical Access Hospitals Voluntary non-profit - Private TRUE 30.7113209 -98.2467221 1 GEOMETRIC_CENTER 53 48 48053         https://data.medicare.gov/resource/xubh-q36u/row-khw5~6jgp-v7pk 451365 659615 2019-11-25 2019-06-30 21 4         25               25
2002 2002 REGIONAL MEDICAL CENTER 709 W MAIN STREET MANCHESTER IA 52057 DELAWARE (563) 927-3232 Critical Access Hospitals Proprietary TRUE 42.4839030 -91.4666440 0   55 19 19055         https://data.medicare.gov/resource/xubh-q36u/row-znx9.yjf2.jpru 161343 660219 2019-11-25 2019-06-30 25           25           1   26
2040 2040 ASCENSION SETON EDGAR B DAVIS 130 HAYS STREET LULING TX 78648 CALDWELL (830) 875-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 29.6725300 -97.6542540 0   55 48 48055 12420   Outlying Caldwell County https://data.medicare.gov/resource/xubh-q36u/row-wn52-vdac_k6nj 451371 660154 2019-11-25 2019-06-30 23           23               23
2081 2081 SAKAKAWEA MEDICAL CENTER - CAH 510 8TH AVENUE NE HAZEN ND 58545 MERCER (701) 748-2225 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.2982860 -101.6115600 0   57 38 38057         https://data.medicare.gov/resource/xubh-q36u/row-772i_c662.4xam 351310 660272 2019-11-25 2019-06-30 13           13               13
2375 2375 MUSC HEALTH MARION MEDICAL CENTER 2829 E HWY 76 MULLINS SC 29574 MARION (843) 431-2000 Acute Care Hospitals Government - State TRUE 34.1892320 -79.3219450 0   67 45 45067         https://data.medicare.gov/resource/xubh-q36u/row-nueg_7h5n~iagx 420055 660703 2019-11-25 2019-06-30 84 10         94               94
2377 2377 AVERA ST BENEDICT HEALTH CENTER - CAH 401 WEST GLYNN DRIVE PARKSTON SD 57366 HUTCHINSON (605) 928-3311 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3989450 -97.9900610 0   67 46 46067         https://data.medicare.gov/resource/xubh-q36u/row-w4r3_dmvi-zsg5 431330 660035 2019-11-25 2019-06-30 25           25         49     74
2411 2411 MERCY HOSPITAL TISHOMINGO 1000 SOUTH BYRD TISHOMINGO OK 73460 JOHNSTON (580) 371-2327 Critical Access Hospitals Voluntary non-profit - Church TRUE 34.2224450 -96.6752940 0   69 40 40069         https://data.medicare.gov/resource/xubh-q36u/row-d4ji~yfmc.9fmx 371304 659716 2019-11-25 2019-06-30 25           25               25
2544 2544 MERCY HOSPITAL KINGFISHER, INC 1000 KINGFISHER HOSPITAL DRIVE KINGFISHER OK 73750 KINGFISHER (405) 375-3141 Critical Access Hospitals Voluntary non-profit - Church TRUE 35.8100746 -97.9449387 1 ROOFTOP 73 40 40073         https://data.medicare.gov/resource/xubh-q36u/row-h8q6~j6ue-y5ca 371313 660141 2019-11-25 2019-06-30 25           25               25
2582 2582 ELKVIEW GENERAL HOSPITAL 429 WEST ELM STREET HOBART OK 73651 KIOWA (580) 726-3324 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.0368290 -99.0983400 0   75 40 40075         https://data.medicare.gov/resource/xubh-q36u/row-gdd4_6kz4-h5ey 370153 659714 2019-11-25 2019-06-30 38           38               38
2660 2660 WILKES-BARRE GENERAL HOSPITAL 575 NORTH RIVER STREET WILKES-BARRE PA 18764 LUZERNE (570) 829-8111 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2582610 -75.8681650 0   79 42 42079 42540   Central Luzerne County https://data.medicare.gov/resource/xubh-q36u/row-jy6y.9gqv-dbyu 390137 659527 2019-11-25 2019-06-30 228 30         258   19           277
2666 2666 MADISON REGIONAL HEALTH SYSTEM 323 SW 10TH ST MADISON SD 57042 LAKE (605) 256-6551 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.9930210 -97.1197520 0   79 46 46079         https://data.medicare.gov/resource/xubh-q36u/row-j5pm.hb44_44j6 431300 659611 2019-11-25 2019-06-30 22           22               22
2796 2796 POPLAR COMMUNITY HOSPITAL 211 H ST E POPLAR MT 59255 ROOSEVELT (406) 768-6100 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1149570 -105.1921240 0   85 30 30085         https://data.medicare.gov/resource/xubh-q36u/row-ivpb.zvpr-3zj8 271300 660638 2019-11-25 2019-06-30 20           20               20
2797 2797 TRINITY HOSPITAL 315 KNAPP ST WOLF POINT MT 59201 ROOSEVELT (406) 653-6500 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1008930 -105.6411380 0   85 30 30085         https://data.medicare.gov/resource/xubh-q36u/row-8zsu~ksjh-u24d 271341 659988 2019-11-25 2019-06-30 22           22       60       82
2850 2850 FISHERMEN'S COMMUNITY HOSPITAL 3301 OVERSEAS HWY MARATHON FL 33050 MONROE (305) 743-5533 Critical Access Hospitals Voluntary non-profit - Private TRUE 24.7111300 -81.0947200 0   87 12 12087 28580   Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-3mjy.7a5u.ezdd 101312 659771 2019-11-25 2019-06-30 4 1         5               5
3214 3214 AVERA CREIGHTON HOSPITAL P O BOX 186, 1503 MAIN ST CREIGHTON NE 68729 KNOX (402) 358-5700 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.4664016 -97.9072475 1 ROOFTOP 107 31 31107         https://data.medicare.gov/resource/xubh-q36u/row-7tv3_vise~cn54 281331 660258 2019-11-25 2019-06-30 23           23       47       70
3217 3217 KENMARE COMMUNITY HOSPITAL PO BOX 697 KENMARE ND 58746 WARD (701) 385-4296 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.6742881 -102.0844703 1 ROOFTOP 101 38 38101 33500   Central Ward County https://data.medicare.gov/resource/xubh-q36u/row-tfzi_r3ee-4azt 351305 660271 2019-11-25 2019-06-30 25           25               25
3218 3218 TRINITY HOSPITALS 407 3RD ST SE MINOT ND 58701 WARD (701) 857-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 48.2324790 -101.2884520 0   101 38 38101 33500   Central Ward County https://data.medicare.gov/resource/xubh-q36u/row-7zuw.yviv_94dm 350006 661068 2019-11-25 2019-06-30 117 19         152 26 20   230   2   430
3315 3315 SPECTRUM HEALTH LUDINGTON HOSPITAL ONE N ATKINSON DRIVE LUDINGTON MI 49431 MASON (231) 843-2591 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.9582193 -86.4302207 1 ROOFTOP 105 26 26105 31220   Central Mason County https://data.medicare.gov/resource/xubh-q36u/row-4jbc-wihk_b6pr 230110 660590 2019-11-25 2019-06-30 39 6         45               45
3561 3561 PIPESTONE COUNTY MEDICAL CENTER 916 4TH AVENUE SOUTHWEST PIPESTONE MN 56164 PIPESTONE (507) 825-5811 Critical Access Hospitals Government - Local TRUE 43.9910820 -96.3221070 0   117 27 27117         https://data.medicare.gov/resource/xubh-q36u/row-pzdb_wxvr-4ugg 241374 659508 2019-11-25 2019-06-30 18           18               18
3571 3571 COMMUNITY MEMORIAL HOSPITAL 1755 NORTH MECKLENBURG AVENUE SOUTH HILL VA 23970 MECKLENBURG (434) 447-3151 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.7476560 -78.1041060 0   117 51 51117         https://data.medicare.gov/resource/xubh-q36u/row-k7c8~fbew_tsmb 490098 659747 2019-11-25 2019-06-30 56   10       66       140       206
3667 3667 SOUTH PENINSULA HOSPITAL 4300 BARTLETT ST HOMER AK 99603 KENAI PENINSULA (907) 235-8101 Critical Access Hospitals Voluntary non-profit - Private TRUE 59.6521330 -151.5502960 0   122 2 2122         https://data.medicare.gov/resource/xubh-q36u/row-cng5-kv9j-dmyn 21313 659751 2019-11-25 2019-06-30 21           21       28       49
3692 3692 MERCY HOSPITAL ADA 430 NORTH MONTE VISTA ADA OK 74820 PONTOTOC (580) 332-2323 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7780680 -96.6348130 0   123 40 40123 10220   Central Pontotoc County https://data.medicare.gov/resource/xubh-q36u/row-itqt-xmxc.8n32 370020 659524 2019-11-25 2019-06-30 96 12         108 20 20           148
3830 3830 SPECTRUM HEALTH REED CITY HOSPITAL 300 N PATTERSON, PO BOX 75 REED CITY MI 49677 OSCEOLA (231) 832-3271 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.8782450 -85.5211907 1 ROOFTOP 133 26 26133         https://data.medicare.gov/resource/xubh-q36u/row-hhgy~8j82.d9qv 231323 660106 2019-11-25 2019-06-30 21 4         25       50       75
3852 3852 HILLSBORO AREA HOSPITAL 1200 E TREMONT STREET HILLSBORO IL 62049 MONTGOMERY (217) 532-6111 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1536720 -89.4815080 0   135 17 17135         https://data.medicare.gov/resource/xubh-q36u/row-hr8s~ac96_26fy 141332 659949 2019-11-25 2019-06-30 25           25               25
3922 3922 PENDER MEMORIAL HOSPITAL 507 E FREMONT ST BURGAW NC 28425 PENDER (910) 300-4004 Critical Access Hospitals Government - Local TRUE 34.5512630 -77.9204230 0   141 37 37141 48900   Outlying Pender County https://data.medicare.gov/resource/xubh-q36u/row-7fvf-phgu_s8i7 341307 659598 2019-11-25 2018-09-30 25           25       43       68
4031 4031 POCAHONTAS COMMUNITY HOSPITAL 606 N W 7TH STREET POCAHONTAS IA 50574 POCAHONTAS (712) 335-3501 Critical Access Hospitals Government - Local TRUE 42.7408220 -94.6787780 0   151 19 19151         https://data.medicare.gov/resource/xubh-q36u/row-mhbi~vwku-j27n 161305 659787 2019-11-25 2019-06-30 25           25               25
4036 4036 DECKERVILLE COMMUNITY HOSPITAL 3559 PINE ST DECKERVILLE MI 48427 SANILAC (810) 376-2835 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.5281610 -82.7337730 0   151 26 26151         https://data.medicare.gov/resource/xubh-q36u/row-kq5w_x6ix-cx98 231311 660599 2019-11-25 2019-06-30 15           15               15
4042 4042 WARREN MEMORIAL HOSPITAL 905 SECOND ST FRIEND NE 68359 SALINE (402) 947-2541 Critical Access Hospitals Government - Local TRUE 40.6536930 -97.2820520 0   151 31 31151         https://data.medicare.gov/resource/xubh-q36u/row-d3pt.4wwp-4k26 281330 660257 2019-11-25 2019-09-30 19           19               19
4057 4057 RAWLINS COUNTY HEALTH CENTER 707 GRANT ST ATWOOD KS 67730 RAWLINS (785) 626-3211 Critical Access Hospitals Voluntary non-profit - Other TRUE 39.8132640 -101.0385000 0   153 20 20153         https://data.medicare.gov/resource/xubh-q36u/row-aajh-f5t2_nat3 171307 659791 2019-11-25 2019-06-30 15           15               15
4202 4202 SIOUX CENTER HEALTH 1101 9TH STREET SE SIOUX CENTER IA 51250 SIOUX (712) 722-1271 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.0696850 -96.1592870 0   167 19 19167         https://data.medicare.gov/resource/xubh-q36u/row-69h8.g24x.naq3 161346 659789 2019-11-25 2019-06-30 19           19       69   1   89
4203 4203 ORANGE CITY AREA HEALTH SYSTEM 1000 LINCOLN CIRCLE SE ORANGE CITY IA 51041 SIOUX (712) 737-4984 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.9948780 -96.0457340 0   167 19 19167         https://data.medicare.gov/resource/xubh-q36u/row-j9vg.b9hy-cjqt 161360 659790 2019-11-25 2019-06-30 25           25               25
4278 4278 SAINT THOMAS RIVER PARK HOSPITAL 1559 SPARTA STREET MC MINNVILLE TN 37110 WARREN (931) 815-4101 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.6986940 -85.7423390 0   177 47 47177 32660   Central Warren County https://data.medicare.gov/resource/xubh-q36u/row-qm5q~p4wm-m3k7 440151 659458 2019-11-25 2019-06-30 92 8         100 10 15           125
4279 4279 MEMORIAL HOSPITAL 1110 NORTH SARAH DEWITT DRIVE GONZALES TX 78629 GONZALES (830) 672-7581 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.5158950 -97.4288680 0   177 48 48177         https://data.medicare.gov/resource/xubh-q36u/row-7g7y.b4hd-s8g5 450235 659735 2019-11-25 2019-06-30 34           34               34
4330 4330 SAINT THOMAS HIGHLANDS HOSPITAL 401 SEWELL DR SPARTA TN 38583 WHITE (931) 738-9211 Acute Care Hospitals Proprietary TRUE 35.9481200 -85.4770740 0   185 47 47185         https://data.medicare.gov/resource/xubh-q36u/row-kw75.zwj7_gsiz 440192 660314 2019-11-25 2019-06-30 28 4         32 14             46
4366 4366 WAYNE MEMORIAL HOSPITAL 2700 WAYNE MEMORIAL DR GOLDSBORO NC 27534 WAYNE (919) 736-1110 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.4008310 -77.9533420 0   191 37 37191 24140   Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-4zsd_c7iy.v8vj 340010 659334 2019-11-25 2019-06-30 245 16         261               261
4431 4431 YOAKUM COUNTY HOSPITAL 412 MUSTANG AVENUE DENVER CITY TX 79323 YOAKUM (806) 592-2121 Critical Access Hospitals Government - Local TRUE 32.9683780 -102.8363910 0   501 48 48501         https://data.medicare.gov/resource/xubh-q36u/row-f6vr_y9ce-af6k 451308 659741 2019-11-25 2018-12-31 24           24               24
4568 4568 PROVIDENCE HEALTH CENTER 6901 MEDICAL PARKWAY WACO TX 76712 MC LENNAN (254) 751-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.5132430 -97.1984310 0   309 48 48309 47380   Central McLennan County https://data.medicare.gov/resource/xubh-q36u/row-vgx2-viz4_yy8e 450042 659893 2019-11-25 2019-06-30 195 30         225 46             271
4590 4590 MEMORIAL HOSPITAL 224 E SECOND STREET DUMAS TX 79029 MOORE (806) 935-7171 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.8642640 -101.9710060 0   341 48 48341 20300   Central Moore County https://data.medicare.gov/resource/xubh-q36u/row-35k5-7dip~y499 451386 659901 2019-11-25 2019-06-30 16 3         19               19
4666 4666 DELL CHILDREN'S MEDICAL CENTER OF CENTRAL TEXAS 4900 MUELLER BLVD AUSTIN TX 78723 TRAVIS (512) 324-0000 Childrens Voluntary non-profit - Private TRUE 30.3025490 -97.7049570 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-2zt9_yffw~gyhs 453310 661423 2019-11-25 2019-06-30 127         76 203               203
4667 4667 DELL SETON MED CENTER AT THE UNIVERSITY OF TX 601 E 15TH STREET AUSTIN TX 78701 TRAVIS (512) 324-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2750550 -97.7329770 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-8gyh.j6jb.jjky 450124 660050 2019-11-25 2019-06-30 166 60         226               226
4674 4674 ASCENSION SETON MEDICAL CENTER AUSTIN 1201 W 38TH ST AUSTIN TX 78705 TRAVIS (512) 324-1000 Acute Care Hospitals Physician TRUE 30.3061540 -97.7452180 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-qf7b-dsjj.a9dv 450056 659731 2019-11-25 2019-06-30 304 83       43 430               430
4675 4675 ASCENSION SETON NORTHWEST 11113 RESEARCH BOULEVARD AUSTIN TX 78759 TRAVIS (512) 324-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4048200 -97.7450100 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-qudt_ghtb~xy35 450867 660331 2019-11-25 2019-06-30 77 16       13 106               106
4678 4678 TYLER COUNTY HOSPITAL 1100 WEST BLUFF WOODVILLE TX 75979 TYLER (409) 283-8141 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.7752870 -94.4282200 0   457 48 48457         https://data.medicare.gov/resource/xubh-q36u/row-xfu9.wq3c~xr3i 450460 660053 2019-11-25 2019-06-30 25           25               25
4702 4702 SETON MEDICAL CENTER WILLIAMSON 201 SETON PARKWAY ROUND ROCK TX 78664 WILLIAMSON (512) 324-0000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.5679440 -97.6527840 0   491 48 48491 12420   Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-rfq6_5szx.kb6y 670041 659749 2019-11-25 2019-06-30 93 26         119               119
4756 4756 MEDICAL COLLEGE OF VIRGINIA HOSPITALS BOX 980510 1250 EAST MARSHALL STREET RICHMOND VA 23298 RICHMOND CITY (804) 828-0938 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.5400695 -77.4299163 1 ROOFTOP 760 51 51760 40060   Central Richmond city https://data.medicare.gov/resource/xubh-q36u/row-p6wh~7aeu~ic6q 490032 659745 2019-11-25 2019-06-30 502 28 14 16 28   715 28 38           781
2600 2600 PIEDMONT NEWNAN HOSPITAL, INC 745 POPLAR ROAD NEWNAN GA 30265 COWETA (770) 400-2300 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.3593630 -84.7540620 0   77 13 13077 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Coweta County https://data.medicare.gov/resource/xubh-q36u/row-nhqn.yikd_3ahg 110229 659491 2019-11-25 2019-06-30 122 18       10 150               150
3631 3631 PIEDMONT HOSPITAL 1968 PEACHTREE RD NW ATLANTA GA 30309 FULTON (404) 605-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.8088020 -84.3933690 0   121 13 13121 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Fulton County https://data.medicare.gov/resource/xubh-q36u/row-53ay_f9xi~a54p 110083 659489 2019-11-25 2019-06-30 407 56 20     29 512               512
4029 4029 PIEDMONT HENRY HOSPITAL 1133 EAGLE'S LANDING PARKWAY STOCKBRIDGE GA 30281 HENRY (678) 604-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.5089960 -84.2255610 0   151 13 13151 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Henry County https://data.medicare.gov/resource/xubh-q36u/row-vhdk-mf48~gr2g 110191 659490 2019-11-25 2019-06-30 196   40     16 252       89       341
2504 2504 GRANDVIEW MEDICAL CENTER 3690 GRANDVIEW PARKWAY BIRMINGHAM AL 35243 JEFFERSON (205) 971-1000 Acute Care Hospitals Proprietary TRUE 33.4343630 -86.7204830 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-pwut_di96_m4tu 10104 660349 2019-11-25 2019-06-30 289 72         373 12 17           402
518 518 SOUTHERN NH MEDICAL CENTER 8 PROSPECT STREET NASHUA NH 3060 HILLSBOROUGH (603) 577-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.7560610 -71.4612290 0   11 33 33011 31700 Boston-Worcester-Providence, MA-RI-NH-CT Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-z29g.nws7.yp8q 300020 659990 2019-11-25 2019-06-30 131 11         142 18             160
1277 1277 SAINT FRANCIS MEDICAL CENTER 211 ST FRANCIS DR CAPE GIRARDEAU MO 63703 CAPE GIRARDEAU (573) 331-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.3034070 -89.5712971 1 ROOFTOP 31 29 29031 16020 Cape Girardeau-Sikeston, MO-IL Central Cape Girardeau County https://data.medicare.gov/resource/xubh-q36u/row-2cqn~hh59_aitm 260183 660119 2019-11-25 2019-06-30 216 31         283   24           307
3263 3263 UNIVERSITY OF IOWA HOSPITAL & CLINICS 200 HAWKINS DRIVE IOWA CITY IA 52242 JOHNSON (319) 356-1616 Acute Care Hospitals Government - State TRUE 41.6612030 -91.5507590 0   103 19 19103 26980 Cedar Rapids-Iowa City, IA Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-cxgc_xna4~4mhi 160058 660215 2019-11-25 2019-06-30 497   24 17 36 88 716 73             789
1221 1221 LARABIDA CHILDRENS HOSPITAL I E 65TH ST AT LAKE MICHIGAN CHICAGO IL 60649 COOK (773) 363-6700 Childrens Voluntary non-profit - Private FALSE 41.7768110 -87.6015927 1 GEOMETRIC_CENTER 31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-cnjg.zfnx-s5dn 143301 659950 2019-11-25 2019-06-30 49           49               49
2890 2890 RUSH COPLEY MEDICAL CENTER 2000 OGDEN AVENUE AURORA IL 60504 KANE (630) 978-6200 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7277220 -88.2684150 0   89 17 17089 16980 Chicago-Naperville, IL-IN-WI Central Kane County https://data.medicare.gov/resource/xubh-q36u/row-39d4~37w6~ivsi 140029 659945 2019-11-25 2019-06-30 157 22         192   18           210
2943 2943 FRANCISCAN HEALTH MICHIGAN CITY 3500 FRANCISCAN WAY MICHIGAN CITY IN 46360 LA PORTE (219) 879-8511 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.6595891 -86.8986778 1 ROOFTOP 91 18 18091 33140 Chicago-Naperville, IL-IN-WI Central LaPorte County https://data.medicare.gov/resource/xubh-q36u/row-3sxf-2kxc.xexc 150015 660075 2019-11-25 2018-12-31 135 14         149 18 16           183
4064 4064 AKRON GENERAL MEDICAL CENTER 1 AKRON GENERAL AVENUE AKRON OH 44307 SUMMIT (330) 344-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0778590 -81.5327870 0   153 39 39153 10420 Cleveland-Akron-Canton, OH Central Summit County https://data.medicare.gov/resource/xubh-q36u/row-fwyk~yqdc~my3b 360027 660664 2019-11-25 2018-12-31 315 34 34       383 53             436
2488 2488 NEWBERRY COUNTY MEMORIAL HOSPITAL 2669 KINARD ST PO BOX 497 NEWBERRY SC 29108 NEWBERRY (803) 405-7145 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.2894330 -81.6049150 0   71 45 45071 35140 Columbia-Orangeburg-Newberry, SC Central Newberry County https://data.medicare.gov/resource/xubh-q36u/row-9ehy.xh96.39uz 420053 659725 2019-11-25 2019-06-30 41 7         48               48
1866 1866 OHIO STATE UNIVERSITY HOSPITALS 410 WEST 10TH AVENUE COLUMBUS OH 43210 FRANKLIN (614) 293-9700 Acute Care Hospitals Government - State TRUE 39.9948840 -83.0176860 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-fagn.mmer_2f8n 360085 660671 2019-11-25 2019-06-30 885 97         982 91 60           1133
60 60 UNIVERSITY OF COLORADO HOSPITAL AUTHORITY 12605 E 16TH AVE AURORA CO 80045 ADAMS (720) 848-0000 Acute Care Hospitals Government - Hospital District or Authority TRUE 39.7413640 -104.8412750 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-sx7w-4iik_kiyq 60024 659482 2019-11-25 2019-06-30 432 101   19 24 50 650   12           662
1202 1202 NATIONAL JEWISH HEALTH 1400 JACKSON ST DENVER CO 80206 DENVER (303) 388-4461 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7400190 -104.9428920 0   31 8 8031 19740 Denver-Aurora, CO Central Denver County https://data.medicare.gov/resource/xubh-q36u/row-7hr7.gg8i-chk4 60107 659641 2019-11-25 2019-06-30 24           24               24
688 688 SPECTRUM HEALTH PENNOCK 1009 W GREEN ST HASTINGS MI 49058 BARRY (269) 945-3451 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.6442000 -85.3021000 0   15 26 26015 24340 Grand Rapids-Wyoming-Muskegon, MI Outlying Barry County https://data.medicare.gov/resource/xubh-q36u/row-7m4u.pz7d~8678 231339 660108 2019-11-25 2019-06-30 19 6         25               25
3346 3346 SPECTRUM HEALTH BIG RAPIDS HOSPITAL 605 OAK STREET BIG RAPIDS MI 49307 MECOSTA (231) 796-8691 Acute Care Hospitals Government - Local TRUE 43.6931260 -85.4757630 0   107 26 26107 13660 Grand Rapids-Wyoming-Muskegon, MI Central Mecosta County https://data.medicare.gov/resource/xubh-q36u/row-6wsn~km5g_qqzq 230093 660588 2019-11-25 2019-06-30 45 4         49               49
471 471 ST MARYS HOSPITAL MEDICAL CTR 1726 SHAWANO AVE GREEN BAY WI 54303 BROWN (920) 498-4200 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.5321840 -88.0665610 0   9 55 55009 24580 Green Bay-Shawano, WI Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-kt4k-sbbe~w8n6 520097 660733 2019-11-25 2019-06-30 75 8         83               83
4417 4417 HCA HOUSTON HEALTHCARE TOMBALL 605 HOLDERRIETH TOMBALL TX 77375 HARRIS (281) 351-1623 Acute Care Hospitals Proprietary TRUE 30.0887030 -95.6239850 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-qwg3~p4ci.ubu8 450670 659543 2019-11-25 2019-06-30 167 20       7 194 21 26           241
4419 4419 MEMORIAL HERMANN HOSPITAL SYSTEM 1635 NORTH LOOP WEST HOUSTON TX 77008 HARRIS (713) 448-6796 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.8122660 -95.4308990 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-2kjx_z9h3~iiu7 450184 659537 2019-11-25 2019-06-30 1068 157       85 1310   78           1388
4436 4436 MEMORIAL HERMANN TEXAS MEDICAL CENTER 6411 FANNIN HOUSTON TX 77030 HARRIS (713) 704-3700 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.7136840 -95.3976270 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-dk5e-jq9i-qp7s 450068 659613 2019-11-25 2019-06-30 658 38 18     118 994   12   8       1014
3102 3102 ORTHOINDY HOSPITAL 8400 NORTHWEST BLVD INDIANAPOLIS IN 46278 MARION (317) 956-1000 Acute Care Hospitals Physician FALSE 39.9067020 -86.2662580 0   97 18 18097 26900 Indianapolis-Carmel-Muncie, IN Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-sa8x~jqdx_zkr2 150160 660543 2019-11-25 2018-12-31 38           38               38
4367 4367 JOHNSTON MEMORIAL HOSPITAL 16000 JOHNSTON MEMORIAL DRIVE ABINGDON VA 24211 WASHINGTON (276) 258-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.7206700 -81.9085600 0   191 51 51191 28700 Johnson City-Kingsport-Bristol, TN-VA Outlying Washington County https://data.medicare.gov/resource/xubh-q36u/row-ysbq~qbac~97nx 490053 660721 2019-11-25 2019-06-30 101 14         115               115
1789 1789 LIBERTY HOSPITAL 2525 GLENN HENDREN DR LIBERTY MO 64069 CLAY (816) 781-7200 Acute Care Hospitals Government - Hospital District or Authority TRUE 39.2767570 -94.4243430 0   47 29 29047 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-e8b7~a55p.dgyp 260177 660118 2019-11-25 2019-06-30 179 20         199               199
466 466 BLOUNT MEMORIAL HOSPITAL 907 E LAMAR ALEXANDER PARKWAY MARYVILLE TN 37804 BLOUNT (865) 983-7211 Acute Care Hospitals Government - Local TRUE 35.7549750 -83.9586020 0   9 47 47009 28940 Knoxville-Morristown-Sevierville, TN Central Blount County https://data.medicare.gov/resource/xubh-q36u/row-q2u9.xgek.22ux 440011 659450 2019-11-25 2019-06-30 177 8 8       193 10     76       279
2355 2355 BAPTIST HEALTH LEXINGTON 1740 NICHOLASVILLE ROAD LEXINGTON KY 40503 FAYETTE (859) 260-6104 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.0188420 -84.5139480 0   67 21 21067 30460 Lexington-Fayette--Richmond--Frankfort, KY Central Fayette County https://data.medicare.gov/resource/xubh-q36u/row-w47h-k353~ymyx 180103 660563 2019-11-25 2018-08-31 339 52         391               391
1496 1496 SAINT FRANCIS MEDICAL CENTER 3630 EAST IMPERIAL HIGHWAY LYNWOOD CA 90262 LOS ANGELES (310) 900-8900 Acute Care Hospitals Voluntary non-profit - Church FALSE 33.9310160 -118.2038340 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-dsew-en9m.iktv 50104 662017 2019-11-25 2019-06-30 279 36       29 344       30       374
1527 1527 SAINT VINCENT MEDICAL CENTER 2131 W 3RD ST LOS ANGELES CA 90057 LOS ANGELES (213) 484-7111 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.0631900 -118.2736650 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-eg7n_qzjr.u6rm 50502 660171 2019-11-25 2019-06-30 253 67         320   19   27       366
3981 3981 ST CLOUD HOSPITAL 1406 6TH AVE NORTH SAINT CLOUD MN 56303 STEARNS (320) 255-5661 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5753250 -94.1704500 0   145 27 27145 41060 Minneapolis-St. Paul, MN-WI Central Stearns County https://data.medicare.gov/resource/xubh-q36u/row-i2df-wytp-8ht6 240036 659976 2019-11-25 2019-06-30 385 42       30 457   20           477

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