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

97 rows where "fy_end_date" is on date 2018-06-30

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, statefips, csatitle, centraloutlyingcounty, filed_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, filed_date (date)

fy_end_date (date) ✖

  • 2018-06-30 · 97 ✖
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
15 15 GARRISON MEMORIAL HOSPITAL 407 3RD AVE SE GARRISON ND 58540 MCLEAN (701) 463-2275 Critical Access Hospitals Voluntary non-profit - Church TRUE 47.6483420 -101.4113010 0   55 38 38055         https://data.medicare.gov/resource/xubh-q36u/row-e4ej.ybr6_ritz 351303 640250 2018-12-03 2018-06-30 22           22       28       50
18 18 HOUSTON COUNTY COMMUNITY HOSPITAL 5001 EAST MAIN STREET ERIN TN 37061 HOUSTON (931) 289-4211 Critical Access Hospitals Government - Local TRUE 36.3195160 -87.6891930 0   83 47 47083         https://data.medicare.gov/resource/xubh-q36u/row-dt3z.s9ya.age2 441322 639931 2018-12-03 2018-06-30 25           25               25
49 49 ALAMEDA HOSPITAL 2070 CLINTON AVENUE ALAMEDA CA 94501 ALAMEDA (510) 522-3700 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7632300 -122.2535410 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-aten_zvra_dnju 50211 662328 2018-12-03 2018-06-30 29   5       34       181       215
51 51 SAN LEANDRO HOSPITAL 13855 E 14TH STREET SAN LEANDRO CA 94578 ALAMEDA (510) 357-6500 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7146320 -122.1419730 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-whtt-wfgb.a9rb 50773 657702 2018-12-03 2018-06-30 39 6         45               45
80 80 HILO MEDICAL CENTER 1190 WAIANUENUE AVENUE HILO HI 96720 HAWAII (808) 932-3000 Acute Care Hospitals Government - State TRUE 19.7174670 -155.1135130 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-szpt~f525_222j 120005 657722 2018-12-03 2018-06-30 146 11         157       119       276
81 81 HALE HO'OLA HAMAKUA 45-547 PLUMERIA STREET HONOKAA HI 96727 HAWAII (808) 932-4100 Critical Access Hospitals Government - State TRUE 20.0762710 -155.4705950 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-z9jm-2idi-sq3z 121307 640366 2018-12-03 2018-06-30 11           11       66       77
147 147 BIG HORN HOSPITAL 17 N MILES HARDIN MT 59034 BIG HORN (406) 665-2310 Critical Access Hospitals Government - Local TRUE 45.7288560 -107.6170100 0   3 30 30003         https://data.medicare.gov/resource/xubh-q36u/row-2cgz.f5s8-gu8f 271338 652087 2018-11-27 2018-06-30 25           25               25
154 154 KUAKINI MEDICAL CENTER 347 NORTH KUAKINI STREET HONOLULU HI 96817 HONOLULU (808) 536-2236 Acute Care Hospitals Voluntary non-profit - Private TRUE 21.3222110 -157.8562110 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-haju_ivwx-iwr6 120007 656434 2018-12-26 2018-06-30 146 12 12       170       40 147     357
195 195 SAINT ROSE DOMINICAN HOSPITALS - SIENA CAMPUS 3001 ST ROSE PARKWAY HENDERSON NV 89052 CLARK (702) 616-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0045271 -115.1150581 1 ROOFTOP 3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-8dra~5wtd-jnuh 290045 662405 2018-11-30 2018-06-30 244 50         326               326
196 196 SAINT ROSE DOMINICAN HOSPITALS - ROSE DE LIMA 102 E LAKE MEAD DR HENDERSON NV 89015 CLARK (702) 616-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.0388290 -114.9831920 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-r9pq.jhhc.4qfi 290012 657913 2018-11-30 2018-06-30 72 10         82   28           110
333 333 CAMPBELL COUNTY MEMORIAL HOSPITAL 501 SOUTH BURMA AVENUE GILLETTE WY 82716 CAMPBELL (307) 688-1551 Acute Care Hospitals Government - Hospital District or Authority TRUE 44.2898460 -105.5195570 0   5 56 56005 23940   Central Campbell County https://data.medicare.gov/resource/xubh-q36u/row-ppek.rg99~yqr6 530002 658628 2018-11-29 2018-06-30 52 14         66 6     160       232
344 344 ORCHARD HOSPITAL 240 SPRUCE STREET GRIDLEY CA 95948 BUTTE (530) 846-5671 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3669740 -121.6897170 0   7 6 6007 17020   Central Butte County https://data.medicare.gov/resource/xubh-q36u/row-kvk2_zuau.b3ab 51311 640345 2018-12-03 2018-06-30 24           24       52       76
350 350 KAUAI VETERANS MEMORIAL HOSPITAL 4643 WAIMEA CANYON DRIVE WAIMEA HI 96796 KAUAI (808) 338-9431 Critical Access Hospitals Government - State TRUE 21.9600790 -159.6700550 0   7 15 15007 28180   Central Kauai County https://data.medicare.gov/resource/xubh-q36u/row-ddrn-xkz9.2xji 121300 655051 2019-09-20 2018-06-30 23 2         25       20       45
351 351 SAMUEL MAHELONA MEMORIAL HOSPITAL 4800 KAWAIHAU ROAD KAPAA HI 96746 KAUAI (808) 822-4961 Critical Access Hospitals Government - State TRUE 22.0876190 -159.3142040 0   7 15 15007 28180   Central Kauai County https://data.medicare.gov/resource/xubh-q36u/row-ysve.ycbm-b3qy 121306 640504 2018-11-30 2018-06-30 5           5 9     66       80
448 448 BEARTOOTH BILLINGS CLINIC 2525 N BROADWAY RED LODGE MT 59068 CARBON (406) 446-2345 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.2116970 -109.2430450 0   9 30 30009 13740   Outlying Carbon County https://data.medicare.gov/resource/xubh-q36u/row-i4we~7hxf.sxbf 271326 640232 2018-12-03 2018-06-30 10           10               10
493 493 HOLY CROSS HOSPITAL 4725 N FEDERAL HWY FORT LAUDERDALE FL 33308 BROWARD (954) 771-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 26.1853780 -80.1176590 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-q8e2.rdpd.9cpi 100073 654519 2019-09-09 2018-06-30 256 44       9 309   48           357
509 509 ASCENSION STANDISH HOSPITAL 805 W CEDAR ST STANDISH MI 48658 ARENAC (517) 846-4521 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.9828300 -83.9693520 0   11 26 26011         https://data.medicare.gov/resource/xubh-q36u/row-3a56-bznt.bz29 231305 639965 2018-12-12 2018-06-30 20 5         25       29       54
545 545 CROOK COUNTY HOSPITAL 713 OAK STREET SUNDANCE WY 82729 CROOK (307) 283-3501 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.4088300 -104.3735960 0   11 56 56011         https://data.medicare.gov/resource/xubh-q36u/row-ikyx-7gnq-abzi 531311 640303 2018-12-04 2018-06-30 16           16       32       48
564 564 VALLEYWISE HEALTH MEDICAL CENTER 2601 EAST ROOSEVELT STREET PHOENIX AZ 85008 MARICOPA (602) 344-5011 Acute Care Hospitals Government - Local TRUE 33.4585250 -112.0264300 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-c5qr_etcr-7dch 30022 661279 2018-12-03 2018-06-30 211 20   19 13   323 241             564
568 568 ST. JOSEPH'S HOSPITAL AND MEDICAL CENTER 350 WEST THOMAS ROAD PHOENIX AZ 85013 MARICOPA (602) 406-5001 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.4802940 -112.0792080 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-kyrc_3hbc_et9k 30024 658638 2019-10-10 2018-06-30 268   24   32   460   52           512
606 606 PINEVILLE COMMUNITY HEALTH CENTER, INC 850 RIVERVIEW AVENUE PINEVILLE KY 40977 BELL (606) 337-3051 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.7630770 -83.7085740 0   13 21 21013 33180   Central Bell County https://data.medicare.gov/resource/xubh-q36u/row-fc9h_t8d9~pcu3 180021 651620 2019-07-15 2018-06-30 41           41 12             53
623 623 HUMBOLDT GENERAL HOSPITAL 118 EAST HASKELL STREET WINNEMUCCA NV 89445 HUMBOLDT (775) 623-5222 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.9715810 -117.7285340 0   13 32 32013 49080   Central Humboldt County https://data.medicare.gov/resource/xubh-q36u/row-ca7p_4a94-fjt7 291308 641600 2018-11-30 2018-06-30 22 3         25       42       67
655 655 UINTAH BASIN MEDICAL CENTER 250 WEST 300 NORTH ROOSEVELT UT 84066 DUCHESNE (435) 722-4691 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.3027550 -109.9970860 0   13 49 49013         https://data.medicare.gov/resource/xubh-q36u/row-qmgd.dczn~ghmv 460019 658598 2019-01-10 2018-06-30 31 4         35               35
763 763 GROVER C DILS MEDICAL CENTER 700 N SPRING ST, BOX 1010-C-ADM BLDG CALIENTE NV 89008 LINCOLN (775) 726-3171 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.6222810 -114.5118240 0   17 32 32017         https://data.medicare.gov/resource/xubh-q36u/row-5bun~jms2_227p 291312 654895 2018-12-03 2018-06-30 4           4       16       20
798 798 HOT SPRINGS COUNTY MEMORIAL HOSPITAL 150 EAST ARAPAHOE THERMOPOLIS WY 82443 HOT SPRINGS (307) 864-3121 Critical Access Hospitals Government - Local TRUE 43.6474320 -108.1995900 0   17 56 56017         https://data.medicare.gov/resource/xubh-q36u/row-ktb5~jtkf~b2ae 531304 640300 2018-11-30 2018-06-30 25           25               25
810 810 COALINGA REGIONAL MEDICAL CENTER 1191 PHELPS AVENUE COALINGA CA 93210 FRESNO (559) 935-6400 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.1515170 -120.3420890 0   19 6 6019 23420 Fresno-Madera, CA Central Fresno County https://data.medicare.gov/resource/xubh-q36u/row-6rbr~b9je.7rdb 50397 656406 2018-12-03 2018-06-30 22           22       114       136
851 851 CAVALIER COUNTY MEMORIAL HOSPITAL ASSOCIATION 909 2ND ST LANGDON ND 58249 CAVALIER (701) 256-6100 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.7612430 -98.3666610 0   19 38 38019         https://data.medicare.gov/resource/xubh-q36u/row-m8nv.tvsx-unkm 351323 638003 2018-11-28 2018-06-30 20           20               20
856 856 BUTLER MEMORIAL HOSPITAL ONE HOSPITAL WAY BUTLER PA 16001 BUTLER (724) 283-6666 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8672740 -79.8805124 1 ROOFTOP 19 42 42019 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Butler County https://data.medicare.gov/resource/xubh-q36u/row-3qh5.b2vu-gny9 390168 657465 2018-12-03 2018-06-30 232 35         267 21     25       313
858 858 MUSC MEDICAL CENTER 169 ASHLEY AVE CHARLESTON SC 29425 CHARLESTON (843) 792-2300 Acute Care Hospitals Government - State TRUE 32.7854000 -79.9465590 0   19 45 45019 16700   Central Charleston County https://data.medicare.gov/resource/xubh-q36u/row-yb9w~4mxa-yhfk 420004 662071 2019-08-30 2018-06-30 502 114       66 682 98             780
912 912 GLENDIVE MEDICAL CENTER 202 PROSPECT DR GLENDIVE MT 59330 DAWSON (406) 345-3306 Critical Access Hospitals Voluntary non-profit - Other TRUE 47.1172260 -104.7049530 0   21 30 30021         https://data.medicare.gov/resource/xubh-q36u/row-x469.qqvr~n68h 271332 642881 2019-02-07 2018-06-30 22 3         25       56       81
914 914 MOUNT GRANT GENERAL HOSPITAL 200 SOUTH A ST HAWTHORNE NV 89415 MINERAL (702) 945-2461 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.5166320 -118.6284520 0   21 32 32021         https://data.medicare.gov/resource/xubh-q36u/row-dzph~qsgj~bgaf 291300 652888 2018-12-04 2018-06-30 11           11       24       35
974 974 ST LUKE'S HOSPITAL 702 1ST ST SW CROSBY ND 58730 DIVIDE (701) 965-6384 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.9067080 -103.2982300 0   23 38 38023         https://data.medicare.gov/resource/xubh-q36u/row-pn67~uvq9.k3y8 351325 638546 2018-11-26 2018-06-30 15           15       40       55
982 982 CENTRAL VALLEY MEDICAL CENTER - CAH 48 WEST 1500 NORTH NEPHI UT 84648 JUAB (435) 623-3000 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.7305870 -111.8372150 0   23 49 49023 39340 Salt Lake City-Provo-Orem, UT Outlying Juab County https://data.medicare.gov/resource/xubh-q36u/row-chs9.w8rs-dsc2 461304 637950 2018-11-21 2018-06-30 25           25               25
1120 1120 NIOBRARA HEALTH & LIFE CENTER 921 SOUTH BALLANCEE AVENUE LUSK WY 82225 NIOBRARA (307) 334-4000 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.7532780 -104.4460830 0   27 56 56027         https://data.medicare.gov/resource/xubh-q36u/row-ee9k~358g.gwyk 531314 640304 2018-12-03 2018-06-30 24           24               24
1131 1131 KERN VALLEY HEALTHCARE DISTRICT 6412 LAUREL AVE LAKE ISABELLA CA 93240 KERN (760) 379-2681 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.6353510 -118.4063000 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-vmmb-dmgx.ncbv 51314 652738 2018-12-04 2018-06-30 24           24       74       98
1195 1195 CODY REGIONAL HEALTH 707 SHERIDAN AVENUE CODY WY 82414 PARK (307) 578-2488 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.5260710 -109.0735760 0   29 56 56029         https://data.medicare.gov/resource/xubh-q36u/row-hbhj.vs4q~3zsw 531312 638925 2018-12-03 2018-06-30 21 4         25       94       119
1357 1357 UNIVERSITY OF WASHINGTON MEDICAL CTR 1959 NE PACIFIC ST BOX 356151 SEATTLE WA 98195 KING (206) 598-3300 Acute Care Hospitals Government - State TRUE 47.6505060 -122.3074820 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-gezf_iitw.mxe8 500008 661427 2018-11-29 2018-06-30 209 81       50 408 16 18           442
1358 1358 OVERLAKE HOSPITAL MEDICAL CENTER 1035-116TH AVE NE BELLEVUE WA 98004 KING (425) 688-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 47.6208736 -122.1868731 1 GEOMETRIC_CENTER 33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-rzza-8dw4_494p 500051 658006 2019-01-09 2018-06-30 237 32         286 14             300
1459 1459 TORRANCE MEMORIAL MEDICAL CENTER 3330 LOMITA BLVD TORRANCE CA 90509 LOS ANGELES (310) 325-9110 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.8126440 -118.3437500 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-cibe~cfxf_9r58 50351 640468 2018-11-30 2018-06-30 391 44   12   25 472       40       512
1468 1468 CATALINA ISLAND MEDICAL CENTER 100 FALLS CANYON ROAD AVALON CA 90704 LOS ANGELES (310) 510-0700 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.3390790 -118.3304770 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-8vi9~ashp_y9rx 51307 638364 2018-11-29 2018-06-30 8           8       4       12
1471 1471 CEDARS-SINAI MEDICAL CENTER 8700 BEVERLY BLVD LOS ANGELES CA 90048 LOS ANGELES (310) 423-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.0754960 -118.3801220 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-pkaz~e2ny_94bc 50625 662348 2018-11-21 2018-06-30 709 48 18   24 24 880               880
1474 1474 MARTIN LUTHER KING, JR. COMMUNITY HOSPITAL 1680 EAST 120TH STREET LOS ANGELES CA 90059 LOS ANGELES (424) 835-6808 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.9243610 -118.2443310 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-wqas_evtp_8i7y 50779 662351 2018-11-29 2018-06-30 111 20         131               131
1479 1479 WHITTIER HOSPITAL MEDICAL CENTER 9080 COLIMA RD WHITTIER CA 90605 LOS ANGELES (562) 945-3561 Acute Care Hospitals Proprietary TRUE 33.9507480 -118.0051140 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-4rmv_824x.pbwt 50735 657693 2018-12-03 2018-06-30 140 16         156       22       178
1483 1483 LAC/RANCHO LOS AMIGOS NATIONAL REHABILITATION CTR 7601 EAST IMPERIAL HIGHWAY DOWNEY CA 90242 LOS ANGELES (562) 401-7022 Acute Care Hospitals Government - Local FALSE 33.9293317 -118.1585885 1 ROOFTOP 37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-rfj5_pyf7~7bni 50717 662350 2018-12-03 2018-06-30 89 12         101   109           210
1488 1488 GLENDALE MEM HOSPITAL & HLTH CENTER 1420 S CENTRAL AVE GLENDALE CA 91204 LOS ANGELES (818) 502-1900 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1277890 -118.2577950 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-7nps-ge35~jh8j 50058 657613 2018-12-03 2018-06-30 204 24       13 241 49 14       30   334
1560 1560 LAKE DISTRICT HOSPITAL 700 SOUTH J STREET LAKEVIEW OR 97630 LAKE (541) 947-2114 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.1815830 -120.3514370 0   37 41 41037         https://data.medicare.gov/resource/xubh-q36u/row-2rpx~hmxp~n924 381309 640591 2018-12-10 2018-06-30 24           24               24
1582 1582 MADERA COMMUNITY HOSPITAL 1250 E ALMOND AVE MADERA CA 93637 MADERA (559) 675-5555 Acute Care Hospitals Voluntary non-profit - Other FALSE 36.9454270 -120.0454670 0   39 6 6039 31460 Fresno-Madera, CA Central Madera County https://data.medicare.gov/resource/xubh-q36u/row-zgse.huz6_3uyv 50568 656247 2018-12-12 2018-06-30 96 10         106               106
1595 1595 GRANITE COUNTY MEDICAL CENTER 310 SANSOME ST PHILIPSBURG MT 59858 GRANITE (406) 859-3271 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.3327550 -113.2942070 0   39 30 30039         https://data.medicare.gov/resource/xubh-q36u/row-wazi~b6n6_xzju 271303 640231 2018-12-03 2018-06-30 25           25               25
1612 1612 PEACEHEALTH COTTAGE GROVE COMMUNITY MEDICAL CENTER 1515 VILLAGE DRIVE COTTAGE GROVE OR 97424 LANE (541) 767-5202 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.8038370 -123.0386760 0   39 41 41039 21660   Central Lane County https://data.medicare.gov/resource/xubh-q36u/row-6buq_rs3k.th8r 381301 640536 2018-11-30 2018-06-30 14           14               14
1764 1764 BOWDLE HOSPITAL - CAH 8001 W 5TH POST OFFICE BOX 556 BOWDLE SD 57428 EDMUNDS (605) 285-6146 Critical Access Hospitals Government - Local TRUE 45.4480531 -99.6609364 1 ROOFTOP 45 46 46045 10100   Outlying Edmunds County https://data.medicare.gov/resource/xubh-q36u/row-q6h5.bajv_fkde 431318 637935 2018-11-26 2018-06-30 12           12       34       46
1770 1770 WESTON COUNTY HEALTH SERVICES 1124 WASHINGTON BOULEVARD NEWCASTLE WY 82701 WESTON (307) 746-4491 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.8487470 -104.1887560 0   45 56 56045         https://data.medicare.gov/resource/xubh-q36u/row-jibn-3jkh~ba9g 531303 640299 2018-12-03 2018-06-30 12           12       58       70
1969 1969 MCKENZIE COUNTY HEALTHCARE SYSTEMS INC 709 4TH AVE NE WATFORD CITY ND 58854 MCKENZIE (701) 842-3000 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.8046820 -103.2713580 0   53 38 38053         https://data.medicare.gov/resource/xubh-q36u/row-ph32.gcyn.yevx 351302 652530 2018-12-03 2018-06-30 24           24       47       71
2032 2032 CHI ST ALEXIUS HEALTH TURTLE LAKE 220 5TH AVE W TURTLE LAKE ND 58575 MCLEAN (701) 448-2331 Critical Access Hospitals Voluntary non-profit - Church TRUE 47.5179250 -100.8944420 0   55 38 38055         https://data.medicare.gov/resource/xubh-q36u/row-w8fb-47fy-9nzg 351304 640251 2018-12-03 2018-06-30 25           25               25
2041 2041 PEACEHEALTH PEACE ISLAND MEDICAL CENTER 1117 SPRING STREET FRIDAY HARBOR WA 98250 SAN JUAN (360) 378-2141 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.5298570 -123.0281710 0   55 53 53055         https://data.medicare.gov/resource/xubh-q36u/row-tq94~fpij_9q58 501340 640562 2018-11-30 2018-06-30 10           10               10
2093 2093 PEACEHEALTH UNITED GENERAL MEDICAL CENTER 2000 HOSPITAL DRIVE SEDRO WOOLLEY WA 98284 SKAGIT (360) 856-6021 Critical Access Hospitals Government - Hospital District or Authority TRUE 48.4955160 -122.2752870 0   57 53 53057 34580 Seattle-Tacoma, WA Central Skagit County https://data.medicare.gov/resource/xubh-q36u/row-bxir_c4z7.hk8y 501329 640561 2018-11-30 2018-06-30 25           25               25
2113 2113 CHILDREN'S HOSPITAL AT MISSION 27700 MEDICAL CENTER RD, 5TH FLOOR MISSION VIEJO CA 92691 ORANGE (949) 365-2408 Childrens Voluntary non-profit - Private TRUE 33.5610153 -117.6653937 1 ROOFTOP 59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-ux4n.c7cr-d5uw 53306 659086 2018-11-30 2018-06-30                              
2127 2127 FAIRVIEW DEVELOPMENTAL CENTER 2501 HARBOR BOULEVARD COSTA MESA CA 92626 ORANGE (714) 957-5000 Acute Care Hospitals Government - Local FALSE 33.6649120 -117.9192670 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-gyrb-ji8k_8vsj 50548 638176 2018-11-27 2018-06-30 30           30           1151   1181
2241 2241 PLUMAS DISTRICT HOSPITAL 1065 BUCKS LAKE ROAD QUINCY CA 95971 PLUMAS (530) 283-2121 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.9347670 -120.9192510 0   63 6 6063         https://data.medicare.gov/resource/xubh-q36u/row-k6tt~sk6g~887z 51326 640492 2018-12-13 2018-06-30 23           23               23
2265 2265 NELSON COUNTY HEALTH SYSTEM 200 N MAIN ST MCVILLE ND 58254 NELSON (701) 322-4328 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.7656260 -98.1773140 0   63 38 38063         https://data.medicare.gov/resource/xubh-q36u/row-mxe5_p48x_qufq 351308 640252 2018-11-29 2018-06-30 19           19       39       58
2286 2286 RIVERSIDE UNIVERSITY HEALTH SYSTEM-MEDICAL CENTER 26520 CACTUS AVENUE MORENO VALLEY CA 92555 RIVERSIDE (951) 486-4000 Acute Care Hospitals Government - Local TRUE 33.9100540 -117.1958240 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-h5qt.qee8.h53s 50292 662336 2018-12-28 2018-06-30 354 45       8 439               439
2288 2288 PALO VERDE HOSPITAL 250 NORTH FIRST STREET BLYTHE CA 92225 RIVERSIDE (760) 922-4115 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.6124500 -114.5954790 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-ekup.vqie~g6zn 50423 658138 2018-11-28 2018-06-30 47 4         51               51
2295 2295 LOMA LINDA UNIVERSITY MEDICAL CENTER-MURRIETA 28062 BAXTER ROAD MURRIETA CA 92563 RIVERSIDE (951) 290-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6134350 -117.1689230 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-2wpb~hess-t7nh 50770 657700 2019-01-18 2018-06-30 94 12       6 112               112
2332 2332 METHODIST HOSPITAL OF SACRAMENTO 7500 HOSPITAL DRIVE SACRAMENTO CA 95823 SACRAMENTO (916) 423-6010 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.4642320 -121.4163330 0   67 6 6067 40900 Sacramento-Roseville, CA Central Sacramento County https://data.medicare.gov/resource/xubh-q36u/row-3qei-q8un_3r8f 50590 657683 2018-12-03 2018-06-30 126 20       12 158       171       329
2371 2371 TUALITY COMMUNITY HOSPITAL 335 SE 8TH AVENUE HILLSBORO OR 97123 WASHINGTON (503) 681-1111 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5196230 -122.9773100 0   67 41 41067 38900 Portland-Vancouver-Salem, OR-WA Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-x4zr_f9jw.9qwd 380021 662242 2018-11-30 2018-06-30 165 29         194 21             215
2434 2434 MOUNTAINS COMMUNITY HOSPITAL 29101 HOSPITAL ROAD LAKE ARROWHEAD CA 92352 SAN BERNARDINO (909) 336-3651 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.2659000 -117.1670920 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-z5bb_6v2j.847b 51312 659479 2019-01-07 2018-06-30 17           17       20       37
2546 2546 ELLWOOD CITY MEDICAL CENTER 724 PERSHING STREET ELLWOOD CITY PA 16117 LAWRENCE (724) 752-0081 Acute Care Hospitals Proprietary TRUE 40.8693490 -80.2744790 0   73 42 42073 35260 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-k638_yc9y~2hzs 390008 640799 2019-01-10 2018-06-30 46 6         52 10             62
2552 2552 ST JOSEPH HOSPITAL 2901 SQUALICUM PARKWAY BELLINGHAM WA 98225 WHATCOM (360) 734-5400 Acute Care Hospitals Voluntary non-profit - Other TRUE 48.7722780 -122.4748780 0   73 53 53073 13380   Central Whatcom County https://data.medicare.gov/resource/xubh-q36u/row-xf7q~fgxx.c5xi 500030 662286 2018-11-30 2018-06-30 183 24         207 20 14           241
2683 2683 SAN MATEO MEDICAL CENTER 222 W 39TH AVE SAN MATEO CA 94403 SAN MATEO (650) 573-2222 Acute Care Hospitals Government - Local TRUE 37.5301160 -122.2994060 0   81 6 6081 41860 San Jose-San Francisco-Oakland, CA Central San Mateo County https://data.medicare.gov/resource/xubh-q36u/row-n83i.z2gh_aca4 50113 660755 2018-12-03 2018-06-30 93 7         100 34     374       508
2708 2708 MARCUS DALY MEMORIAL HOSPITAL - CAH 1200 WESTWOOD DR HAMILTON MT 59840 RAVALLI (406) 375-4408 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.2471580 -114.1713650 0   81 30 30081         https://data.medicare.gov/resource/xubh-q36u/row-r262~sb7s_y9sk 271340 640517 2018-12-04 2018-06-30 20 5         25               31
2759 2759 SAMARITAN HOSPITAL-ST MARY'S CAMPUS 1300 MASSACHUSETTS AVENUE TROY NY 12180 RENSSELAER (518) 268-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.7439770 -73.6764150 0   83 36 36083 10580 Albany-Schenectady, NY Central Rensselaer County https://data.medicare.gov/resource/xubh-q36u/row-23ud-7iuq.i6ww 330232 660842 2019-11-18 2018-06-30 20           20               20
2769 2769 AVERA HEART HOSPITAL OF SOUTH DAKOTA 4500 W 69TH ST SIOUX FALLS SD 57108 LINCOLN (605) 977-7000 Acute Care Hospitals Proprietary TRUE 43.4899220 -96.7809060 0   83 46 46083 43620   Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-rh7v_8wee~ws72 430095 658587 2018-12-03 2018-06-30 53           53               53
2776 2776 EL CAMINO HOSPITAL 2500 GRANT ROAD MOUNTAIN VIEW CA 94040 SANTA CLARA (650) 940-7000 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.3693410 -122.0779330 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-pztm_52rg~xmku 50308 662338 2018-11-30 2018-06-30 303 39         388 25 30           443
2778 2778 ST LOUISE REGIONAL HOSPITAL 9400 NO NAME UNO GILROY CA 95020 SANTA CLARA (408) 848-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.0351100 -121.5730380 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-bxa9-aaz9_2d3g 50688 658156 2018-11-29 2018-06-30 64 8         72               72
2783 2783 O'CONNOR HOSPITAL 2105 FOREST AVENUE SAN JOSE CA 95128 SANTA CLARA (408) 947-2500 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3270540 -121.9371540 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-e67s~ymzp~sv3q 50153 656228 2018-11-29 2018-06-30 302 22         324       24       348
2882 2882 MERCY MEDICAL CENTER REDDING 2175 ROSALINE AVE, CLAIRMONT HGTS REDDING CA 96001 SHASTA (530) 225-6102 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5719533 -122.3952328 1 ROOFTOP 89 6 6089 39820 Redding-Red Bluff, CA Central Shasta County https://data.medicare.gov/resource/xubh-q36u/row-y47u-62yf~3uib 50280 657650 2019-07-01 2018-06-30 202 44       16 262               262
2919 2919 MARGARET R PARDEE MEMORIAL HOSPITAL 800 N JUSTICE ST HENDERSONVILLE NC 28791 HENDERSON (828) 696-1000 Acute Care Hospitals Government - Local TRUE 35.3208140 -82.4681530 0   89 37 37089 11700 Asheville-Brevard, NC Central Henderson County https://data.medicare.gov/resource/xubh-q36u/row-zt42_agis.ksd3 340017 658528 2018-11-29 2018-06-30 147 13         160               160
3058 3058 TOWNER COUNTY MEDICAL CENTER HWY 281 N CANDO ND 58324 TOWNER (701) 968-4411 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.4931522 -99.2110430 1 ROOFTOP 95 38 38095         https://data.medicare.gov/resource/xubh-q36u/row-8pd6_eppf-kx3r 351331 638004 2018-11-28 2018-06-30 20           20       30   5   55
3080 3080 SONOMA DEVELOPMENTAL CENTER 15000 ARNOLD DRIVE / P O BOX 1493 ELDRIDGE CA 95431 SONOMA (707) 938-6000 Acute Care Hospitals Government - State FALSE 38.3490270 -122.5169100 0   97 6 6097 42220 San Jose-San Francisco-Oakland, CA Central Sonoma County https://data.medicare.gov/resource/xubh-q36u/row-j6wx.73xx-wqrm 50547 638175 2018-11-27 2018-06-30 13           13           963   976
3114 3114 PIONEER MEDICAL CENTER 301 W 7TH AVE BIG TIMBER MT 59011 SWEET GRASS (406) 932-4603 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.8284800 -109.9524270 0   97 30 30097         https://data.medicare.gov/resource/xubh-q36u/row-y6u6-i6dq_6uh8 271313 639315 2018-12-03 2018-06-30 25           25               25
3180 3180 LIFESCAPE 2501 W 26TH ST SIOUX FALLS SD 57105 MINNEHAHA (605) 444-9500 Childrens Voluntary non-profit - Private FALSE 43.5294580 -96.7562080 0   99 46 46099 43620   Central Minnehaha County https://data.medicare.gov/resource/xubh-q36u/row-iuzk-vbys_y5he 433300 654864 2018-11-19 2018-06-30                              
3192 3192 PARKVIEW MEDICAL CENTER, INC 400 W 16TH ST PUEBLO CO 81003 PUEBLO (719) 584-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.2816780 -104.6121230 0   101 8 8101 39380 Pueblo-Cañon City, CO Central Pueblo County https://data.medicare.gov/resource/xubh-q36u/row-6kae.fdwt~txeq 60020 656879 2018-11-28 2018-06-30 233 12       11 276 35 15           326
3226 3226 JEANES HOSPITAL 7600 CENTRAL AVENUE PHILADELPHIA PA 19111 PHILADELPHIA (215) 728-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0690710 -75.0865510 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-ffib_n7hw-d6uu 390080 657948 2018-12-03 2018-06-30 126 20         146               146
3289 3289 REGIONAL HEALTH RAPID CITY HOSPITAL 353 FAIRMONT BLVD POST OFFICE BOX 6000 RAPID CITY SD 57701 PENNINGTON (605) 755-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.0586100 -103.2249640 0   103 46 46103 39660 Rapid City-Spearfish, SD Central Pennington County https://data.medicare.gov/resource/xubh-q36u/row-2zks_fxav-k73q 430077 658789 2018-11-27 2018-06-30 305 38         371   16           387
3302 3302 ADVENTHEALTH HEART OF FLORIDA 40100 HWY 27 DAVENPORT FL 33837 POLK (863) 422-4971 Acute Care Hospitals Proprietary TRUE 28.1803340 -81.6399540 0   105 12 12105 29460   Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-febs~ded9_jd7n 100137 656903 2018-12-03 2018-06-30 178 15         193               193
3338 3338 PORTERVILLE DEVELOPMENTAL CENTER 26501 AVENUE 140 PORTERVILLE CA 93257 TULARE (559) 782-2222 Acute Care Hospitals Government - State FALSE 36.0439080 -118.9804830 0   107 6 6107 47300 Visalia-Porterville-Hanford, CA Central Tulare County https://data.medicare.gov/resource/xubh-q36u/row-8jhm_m9d6-frtp 50546 638174 2018-11-27 2018-06-30 44           44           1182   1226
3420 3420 VENTURA COUNTY MEDICAL CENTER 300 HILLMONT AVENUE VENTURA CA 93003 VENTURA (805) 652-6075 Acute Care Hospitals Government - Local TRUE 34.2790550 -119.2543550 0   111 6 6111 37100 Los Angeles-Long Beach, CA Central Ventura County https://data.medicare.gov/resource/xubh-q36u/row-8hxa_nmwp_zdmb 50159 662323 2018-12-03 2018-06-30 196 52       24 272               272
3425 3425 NORTHWESTERN MEDICINE MCHENRY HOSPITAL 4201 MEDICAL CENTER DRIVE MCHENRY IL 60050 MC HENRY (815) 344-5000 Acute Care Hospitals Voluntary non-profit - Other FALSE 42.3189000 -88.2797870 0   111 17 17111 16980 Chicago-Naperville, IL-IN-WI Central McHenry County https://data.medicare.gov/resource/xubh-q36u/row-kudg.ki8v.vy8u 140116 661720 2018-11-29 2018-06-30 234 30         264   22           286
3480 3480 DAYTON CHILDREN'S HOSPITAL ONE CHILDRENS PLAZA DAYTON OH 45404 MONTGOMERY (937) 641-3450 Childrens Voluntary non-profit - Private TRUE 39.7742909 -84.1676062 1 ROOFTOP 113 39 39113 19380 Dayton-Springfield-Sidney, OH Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-m72e~a4zq_2h8h 363306 655032 2018-12-04 2018-06-30 109 34       34 177               177
3582 3582 NORTH METRO MEDICAL CENTER 1400 BRADEN STREET JACKSONVILLE AR 72076 PULASKI (501) 985-7000 Acute Care Hospitals Proprietary TRUE 34.8723810 -92.1246970 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-fmp5~srts-kxcs 40074 656863 2018-12-06 2018-06-30 47           47 31             78
3766 3766 UNIVERSITY PEDIATRIC HOSPITAL PUERTO RICO MEDICAL CENTER IN RIO PIEDRAS SAN JUAN PR 935 SAN JUAN (787) 777-3232 Childrens Government - State TRUE 18.3958646 -66.0736306 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-aat9~yvnm_fjvd 403301 640173 2018-11-30 2018-06-30                              
3778 3778 CENTRO CARDIOVASCULAR AVENIDA AMERICO MIRANDA, ENTRADA PRINCIPAL CM RIO PIEDRAS PR 936 SAN JUAN (787) 754-8500 Acute Care Hospitals Government - State FALSE 18.3997905 -66.0681500 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-n57n_rm6c-sekq 400124 639357 2018-12-12 2018-06-30 114 50         164               164
3800 3800 MERCY HOSPITAL FORT SMITH 7301 ROGERS AVE FORT SMITH AR 72903 SEBASTIAN (479) 314-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.3536470 -94.3529640 0   131 5 5131 22900   Central Sebastian County https://data.medicare.gov/resource/xubh-q36u/row-2a77_rb9f.j48w 40062 661700 2018-11-30 2018-06-30 280 38         343   42           400
3840 3840 WELLSPAN SURGERY AND REHABILITATION HOSPITAL 55 MONUMENT ROAD YORK PA 17403 YORK (717) 812-6100 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.9232770 -76.7168980 0   133 42 42133 49620 Harrisburg-York-Lebanon, PA Central York County https://data.medicare.gov/resource/xubh-q36u/row-vz8h~6tdd.rzsw 390327 655835 2018-11-29 2018-06-30 25           25   48           73
3862 3862 AVERA SACRED HEART HOSPITAL 501 SUMMIT ST YANKTON SD 57078 YANKTON (605) 668-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.8725730 -97.4069450 0   135 46 46135 49460   Central Yankton County https://data.medicare.gov/resource/xubh-q36u/row-p2ay-ses4.gzui 430012 656749 2018-11-30 2018-06-30 65 10         75       187       262
4011 4011 DARDANELLE HOSPITAL 200 NORTH THIRD STREET DARDANELLE AR 72834 YELL (479) 229-4677 Critical Access Hospitals Proprietary TRUE 35.2209170 -93.1569870 0   149 5 5149 40780   Outlying Yell County https://data.medicare.gov/resource/xubh-q36u/row-u9x6_diim.h7v6 41302 639835 2018-12-26 2018-06-30 25           25 10             35
4204 4204 HEGG MEMORIAL HEALTH CENTER 1202 21ST AVENUE ROCK VALLEY IA 51247 SIOUX (712) 476-8000 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.2016930 -96.2850860 0   167 19 19167         https://data.medicare.gov/resource/xubh-q36u/row-5p5r_j23k-rsrv 161336 639251 2018-12-03 2018-06-30 25           25           60   85
4484 4484 SITKA COMMUNITY HOSPITAL 209 MOLLER DRIVE SITKA AK 99835 SITKA BOROUGH (907) 747-3241 Critical Access Hospitals Government - Local TRUE 57.0589920 -135.3459290 0   220 2 2220         https://data.medicare.gov/resource/xubh-q36u/row-asew~ba2y_nt2p 21303 638783 2018-12-03 2018-06-30 12           12       15       27

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