nh_gen_info_geocoded_final

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

75 rows where Health Inspection Rating = 5 and Rating Cycle 3 Number of Standard Health Deficiencies = 5

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, ownership, prvdr_type, Provider Resides in Hospital, Continuing Care Retirement Community, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, Overall Rating, QM Rating, QM Rating Footnote, Long-Stay QM Rating, Long-Stay QM Rating Footnote, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, Staffing Rating Footnote, RN Staffing Rating, RN Staffing Rating Footnote, Reported Staffing Footnote, Physical Therapist Staffing Footnote, Rating Cycle 1 Total Number of Health Deficiencies, Rating Cycle 1 Number of Standard Health Deficiencies, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Health Deficiency Score, Rating Cycle 1 Number of Health Revisits, Rating Cycle 1 Health Revisit Score, Rating Cycle 1 Total Health Score, Rating Cycle 2 Total Number of Health Deficiencies, Rating Cycle 2 Number of Standard Health Deficiencies, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 2 Health Deficiency Score, Rating Cycle 2 Number of Health Revisits, Rating Cycle 2 Total Health Score, Rating Cycle 3 Total Number of Health Deficiencies, Rating Cycle 3 Number of Complaint Health Deficiencies, Rating Cycle 3 Health Deficiency Score, Rating Cycle 3 Total Health Score, Number of Facility Reported Incidents, Number of Substantiated Complaints, Number of Fines, Total Amount of Fines in Dollars, Number of Payment Denials, Total Number of Penalties, Rating Cycle 3 Standard Health Survey Date (date)

Link rowid ▼ address lat lng geocode_flag geocode_accuracy prvdr_nmbr prvdr_nm prvdr_add prvdr_city prvdr_state prvdr_zip prvdr_phn prvdr_cnty prvdr_cnty_name ownership nmbr_beds avg_residents prvdr_type Provider Resides in Hospital Legal Business Name Date First Approved to Provide Medicare and Medicaid services Continuing Care Retirement Community Special Focus Status Abuse Icon Most Recent Health Inspection More Than 2 Years Ago Provider Changed Ownership in Last 12 Months With a Resident and Family Council Automatic Sprinkler Systems in All Required Areas Overall Rating Overall Rating Footnote Health Inspection Rating Health Inspection Rating Footnote QM Rating QM Rating Footnote Long-Stay QM Rating Long-Stay QM Rating Footnote Short-Stay QM Rating Short-Stay QM Rating Footnote Staffing Rating Staffing Rating Footnote RN Staffing Rating RN Staffing Rating Footnote Reported Staffing Footnote Physical Therapist Staffing Footnote Reported Nurse Aide Staffing Hours per Resident per Day Reported LPN Staffing Hours per Resident per Day Reported RN Staffing Hours per Resident per Day Reported Licensed Staffing Hours per Resident per Day Reported Total Nurse Staffing Hours per Resident per Day Reported Physical Therapist Staffing Hours per Resident Per Day Case-Mix Nurse Aide Staffing Hours per Resident per Day Case-Mix LPN Staffing Hours per Resident per Day Case-Mix RN Staffing Hours per Resident per Day Case-Mix Total Nurse Staffing Hours per Resident per Day Adjusted Nurse Aide Staffing Hours per Resident per Day Adjusted LPN Staffing Hours per Resident per Day Adjusted RN Staffing Hours per Resident per Day Adjusted Total Nurse Staffing Hours per Resident per Day Rating Cycle 1 Standard Survey Health Date Rating Cycle 1 Total Number of Health Deficiencies Rating Cycle 1 Number of Standard Health Deficiencies Rating Cycle 1 Number of Complaint Health Deficiencies Rating Cycle 1 Health Deficiency Score Rating Cycle 1 Number of Health Revisits Rating Cycle 1 Health Revisit Score Rating Cycle 1 Total Health Score Rating Cycle 2 Standard Health Survey Date Rating Cycle 2 Total Number of Health Deficiencies Rating Cycle 2 Number of Standard Health Deficiencies Rating Cycle 2 Number of Complaint Health Deficiencies Rating Cycle 2 Health Deficiency Score Rating Cycle 2 Number of Health Revisits Rating Cycle 2 Health Revisit Score Rating Cycle 2 Total Health Score Rating Cycle 3 Standard Health Survey Date Rating Cycle 3 Total Number of Health Deficiencies Rating Cycle 3 Number of Standard Health Deficiencies Rating Cycle 3 Number of Complaint Health Deficiencies Rating Cycle 3 Number of Health Revisits Rating Cycle 3 Health Deficiency Score Rating Cycle 3 Health Revisit Score Rating Cycle 3 Total Health Score Total Weighted Health Survey Score Number of Facility Reported Incidents Number of Substantiated Complaints Number of Fines Total Amount of Fines in Dollars Number of Payment Denials Total Number of Penalties Location Processing Date
385 385 550 W MORSE BLVD WINTER PARK, FL 32789 28.597651 -81.356205 0   105785 THE GARDENS AT DEPUGH 550 W MORSE BLVD WINTER PARK FL 32789 4076446634 470 Orange Non profit - Corporation 40 37.2 Medicare and Medicaid false MARY LEE DEPUGH NURSING HOME ASSOCIATION, INC 03/01/1993 false   false false false Resident Yes 5   5   4   3   5   5   5       2.55323 0.39734 1.2097 1.60704 4.16027 0.00789 2.15161 0.66834 0.30235 3.1223 2.46627 0.44705 1.50591 4.27267 05/30/2019 0 0 0 0 0 0 0 03/15/2018 2 2 0 4 1 0 4 2016-12-14 5 5 0 1 20 0 20 4.667 0 0 0 0.00 0 0 550 W MORSE BLVD WINTER PARK, FL 32789 (28.597651, -81.356205) 02/01/2020
517 517 7025 N Lilley Rd, Canton, MI 48187, USA 42.3355013 -83.4602704 1 ROOFTOP 235618 HEARTLAND HEALTH CARE CENTER-CANTON 7025 LILLEY ROAD CANTON MI 48187 7343943100 810 Wayne Non profit - Other 150 124.5 Medicare and Medicaid false HEARTLAND OF CANTON MI LLC 10/07/2005 false   false false false Resident Yes 5   5   5   5   5   3   3       1.98604 1.36042 0.87096 2.23138 4.21743 0.47251 2.19555 0.90031 0.49141 3.58727 1.88001 1.13623 0.6671 3.76996 06/27/2019 6 2 4 40 1 0 40 08/08/2018 4 3 2 20 1 0 20 2017-06-22 5 5 0 1 20 0 20 30 1 9 0 0.00 0 0   02/01/2020
612 612 299 HURLEY AVENUE ROCKVILLE, MD 20850 39.088487 -77.178972 0   215092 COLLINGSWOOD REHABILITATION AND HEALTHCARE CENTER 299 HURLEY AVENUE ROCKVILLE MD 20850 3017628900 150 Montgomery For profit - Corporation 160 151.1 Medicare and Medicaid false COLLINGSWOOD OPERATOR LLC 06/12/1973 false   false false false Resident Yes 5   5   5   5   5   3   3       2.47945 0.80783 0.60952 1.41736 3.89681 0.0402 2.28256 0.80465 0.38718 3.47439 2.25762 0.75491 0.59252 3.59653 01/08/2019 5 4 1 12 1 0 12 02/02/2018 5 4 2 24 1 0 24 2017-02-03 5 5 5 1 12 0 12 16 3 2 0 0.00 0 0 299 HURLEY AVENUE ROCKVILLE, MD 20850 (39.088487, -77.178972) 02/01/2020
753 753 2625 WEST TOUHY AVENUE CHICAGO, IL 60645 42.012167 -87.696849 0   145285 BUCKINGHAM PAVILION 2625 WEST TOUHY AVENUE CHICAGO IL 60645 7739735333 141 Cook For profit - Corporation 235 95.3 Medicare and Medicaid false BUCKINGHAM PAVILION INC 04/14/1975 false   false false false Resident Yes 5   5   3   2   4   3   4       1.78885 0.20008 0.73403 0.93411 2.72296 0.05279 2.03234 0.69033 0.31837 3.04104 1.82934 0.21794 0.86778 2.87126 11/15/2018 1 1 0 16 1 0 16 01/05/2018 1 1 0 8 1 0 8 2016-12-22 5 5 0 1 32 0 32 16 0 1 0 0.00 0 0 2625 WEST TOUHY AVENUE CHICAGO, IL 60645 (42.012167, -87.696849) 02/01/2020
824 824 Eldridge, CA 95431, USA 38.3634225 -122.5279928 1 APPROXIMATE 05A213 SONOMA DEVELOPMENTAL CENTER D/P SNF P.O. BOX 1493 ELDRIDGE CA 95431 7079386000 590 Sonoma Government - State 427   Medicaid true Legal Business Name Not Available 09/01/1974 false   false false false Both Yes 4   5     2   2   2 1 12 1 12 6 6                             07/26/2018 3 3 0 20 1 0 20 08/31/2017 3 3 0 12 1 0 12 2016-09-16 7 5 2 1 44 0 44 21.333 3 0 0 0.00 0 0   02/01/2020
1050 1050 1401 S CALIFORNIA AVENUE CHICAGO, IL 60608 41.862606 -87.695794 0   145966 SCHWAB REHABILITATION CTR SNU 1401 S. CALIFORNIA AVENUE CHICAGO IL 60608 7735653014 141 Cook Non profit - Corporation 30 10.2 Medicare false SCHWAB REHABILITATION HOSPITAL AND CARE NETWORK 06/22/1998 false   false false false Resident Yes 5   5   5     2 5   5   5       2.29547 0.5475 2.78562 3.33312 5.62859 0.77551 1.90692 0.97862 0.60026 3.48581 2.50181 0.42068 1.74668 5.17785 05/15/2019 0 0 0 0 0 0 0 04/06/2018 3 3 0 24 1 0 24 2017-03-02 5 5 0 1 28 0 28 12.667 0 0 1 9848.00 0 1 1401 S CALIFORNIA AVENUE CHICAGO, IL 60608 (41.862606, -87.695794) 02/01/2020
1063 1063 3535 S NATIONAL AVE SPRINGFIELD, MO 65807 37.150262 -93.277881 0   265289 COX MEDICAL CENTERS MEYER ORTHOPEDIC AND REHAB 3535 S NATIONAL AVE SPRINGFIELD MO 65807 4172699982 380 Greene Non profit - Corporation 28 18.2 Medicare true LESTER E COX MEDICAL CENTERS 08/14/1985 false   false false false None Yes 5   5   5     2 5   5   5       2.52047 0.00279 5.14205 5.14484 7.66531 0 1.86357 0.88917 0.55613 3.30887 2.81093 0.00236 3.48007 7.42853 10/09/2019 0 0 0 0 0 0 0 08/31/2018 0 0 0 0 0 0 0 2017-07-27 5 5 0 1 16 0 16 2.667 0 0 0 0.00 0 0 3535 S NATIONAL AVE SPRINGFIELD, MO 65807 (37.150262, -93.277881) 02/01/2020
1110 1110 520 OSBORNE ROAD NORTHEAST FRIDLEY, MN 55432 45.107857 -93.257787 0   245623 INTERLUDE RESTORATIVE SUITES UNITY 520 OSBORNE ROAD NORTHEAST FRIDLEY MN 55432 7632303131 10 Anoka Non profit - Corporation 50 45.9 Medicare and Medicaid false PHS INTERLUDE FRIDLEY LLC 03/18/2015 false   false false false Both Yes 5   5   5     2 5   5   5       2.46469 0.22767 3.01762 3.24528 5.70997 1.12627 2.25534 1.04781 0.61952 3.92267 2.27126 0.16338 1.83333 4.66773 05/15/2019 1 1 0 4 1 0 4 03/15/2018 2 2 0 4 1 0 4 2017-05-24 5 5 0 1 16 0 16 6 0 1 0 0.00 0 0 520 OSBORNE ROAD NORTHEAST FRIDLEY, MN 55432 (45.107857, -93.257787) 02/01/2020
1411 1411 3022 45TH STREET SAN DIEGO, CA 92105 32.737223 -117.097778 0   55505 ARROYO VISTA NURSING CENTER 3022 45TH STREET SAN DIEGO CA 92105 6192835855 470 San Diego For profit - Corporation 53 46.9 Medicare and Medicaid false CITY HEIGHTS HEALTH ASSOCIATES LLC 01/01/1967 false   false false false Resident Yes 5   5   5   5   5   2   2       2.48833 1.02046 0.58616 1.60662 4.09495 0.23767 2.25482 0.87122 0.46075 3.58679 2.29357 0.88075 0.47883 3.66096 04/11/2019 5 2 3 28 0 0 28 04/06/2018 6 5 1 24 1 0 24 2017-01-20 5 5 0 1 16 0 16 24.667 1 3 0 0.00 0 0 3022 45TH STREET SAN DIEGO, CA 92105 (32.737223, -117.097778) 02/01/2020
1536 1536 145 NEWCOMB AVENUE MOUNT VERNON, KY 40456 37.358006 -84.337001 0   185157 ROCKCASTLE REGIONAL HOSPITAL AND RESPIRATORY CARE 145 NEWCOMB AVENUE MOUNT VERNON KY 40456 6062562195 974 Rockcastle Non profit - Corporation 143 121.8 Medicare and Medicaid true ROCKCASTLE COUNTY HOSPITAL, INC. 01/25/1980 false   false false false Resident Yes 5   5   5   5   5   2   2       2.36011 1.74614 2.44252 4.18866 6.54877 0.04711 2.47762 0.98082 2.01694 5.47538 1.97976 1.33867 0.4558 3.8353 10/11/2019 0 0 0 0 0 0 0 08/30/2018 2 1 1 8 1 0 8 2017-08-03 6 5 1 1 24 0 24 6.667 2 0 0 0.00 0 0 145 NEWCOMB AVENUE MOUNT VERNON, KY 40456 (37.358006, -84.337001) 02/01/2020
2322 2322 1827 Hwy B, Elsberry, MO 63343, USA 39.1449129 -90.8341741 1 ROOFTOP 265825 ELSBERRY MISSOURI HEALTH CARE CENTER 1827 HWY B ELSBERRY MO 63343 5738982880 560 Lincoln Non profit - Corporation 56 52.6 Medicare and Medicaid false ELSBERRY MISSOURI HEALTH CARE CENTER, INC. 01/01/2009 false   false false false Resident Yes 5   5   5   5     2 2   2       2.27396 0.54446 0.26697 0.81143 3.08539 0.01338 1.91973 0.62497 0.27866 2.82336 2.46184 0.65507 0.3606 3.50427 03/07/2019 1 1 0 8 1 0 8 04/06/2018 0 0 0 0 0 0 0 2017-02-23 5 5 0 1 44 0 44 11.333 0 0 0 0.00 0 0   02/01/2020
2581 2581 13328 SAN PABLO AVENUE SAN PABLO, CA 94806 37.954634 -122.334387 0   56359 SAN PABLO HEALTHCARE & WELLNESS CENTER 13328 SAN PABLO AVENUE SAN PABLO CA 94806 5102353720 60 Contra Costa For profit - Limited Liability company 108 100.5 Medicare and Medicaid false SAN PABLO HEALTHCARE & WELLNESS CENTER LLC 09/29/1972 false   false false false None Yes 5   5   3   4   3   4   4       2.22829 0.86114 0.64683 1.50797 3.73626 0.11161 1.90511 0.7017 0.3203 2.92711 2.43091 0.9228 0.76008 4.09309 05/09/2019 5 4 1 20 1 0 20 04/20/2018 4 4 0 12 1 0 12 2017-04-13 8 5 3 1 44 0 44 21.333 1 4 0 0.00 0 0 13328 SAN PABLO AVENUE SAN PABLO, CA 94806 (37.954634, -122.334387) 02/01/2020
2721 2721 4950 THUNDERBIRD DR BOULDER, CO 80303 39.995483 -105.232239 0   65324 FRASIER MEADOWS HEALTH CARE CENTER 4950 THUNDERBIRD DR BOULDER CO 80303 3034998412 60 Boulder Non profit - Church related 54 52.2 Medicare and Medicaid false FRASIER MEADOWS MANOR, INC. 06/01/1994 true   false false false Resident Yes 5   5   5   5   5   5   5       3.19834 0.42155 1.21401 1.63556 4.8339 0 2.08811 0.62338 0.27804 2.98953 3.18337 0.50849 1.64339 5.18499 08/06/2019 1 1 0 4 1 0 4 07/11/2018 2 2 0 12 1 0 12 2017-01-23 5 5 0 1 12 0 12 8 0 0 0 0.00 1 1 4950 THUNDERBIRD DR BOULDER, CO 80303 (39.995483, -105.232239) 02/01/2020
2753 2753 87 BRIARWOOD CIRCLE WORCESTER, MA 01606 42.318121 -71.773209 0   225016 KNOLLWOOD NURSING CENTER 87 BRIARWOOD CIRCLE WORCESTER MA 1606 5088536910 170 Worcester Non profit - Corporation 82 76.5 Medicare and Medicaid false SALEM COMMUNITY CORPORATION 01/07/1970 true   false false false Both Yes 5   5   5   5   5   5   5       2.26935 0.71244 0.83123 1.54367 3.81301 0.07633 2.09648 0.64185 0.27488 3.01321 2.24971 0.83464 1.13816 4.05782 07/02/2019 1 0 1 4 0 0 4 05/18/2018 0 0 0 0 0 0 0 2017-02-24 5 5 0 1 20 0 20 5.333 0 0 0 0.00 0 0 87 BRIARWOOD CIRCLE WORCESTER, MA 01606 (42.318121, -71.773209) 02/01/2020
3005 3005 130 TAMPICO WALNUT CREEK, CA 94598 37.910534 -122.045455 0   56213 TAMPICO TERRACE CARE CENTER 130 TAMPICO WALNUT CREEK CA 94598 9259337970 60 Contra Costa For profit - Corporation 128 81.6 Medicare and Medicaid false J3TFZ INC 07/09/1970 false   false false false Resident Yes 5   5   3   4   3   4   4       2.66459 1.13798 0.83381 1.97179 4.63637 0.08958 2.28186 0.74047 0.35257 3.3749 2.42693 1.1556 0.89012 4.40524 12/06/2018 3 3 0 16 1 0 16 01/05/2018 5 3 2 20 1 0 20 2017-01-26 6 5 1 1 36 0 36 20.667 1 2 0 0.00 0 0 130 TAMPICO WALNUT CREEK, CA 94598 (37.910534, -122.045455) 02/01/2020
3312 3312 34 MIDROCKS DRIVE NORWALK, CT 06851 41.142315 -73.415254 0   75387 AUTUMN LAKE HEALTHCARE AT NORWALK 34 MIDROCKS DRIVE NORWALK CT 6851 2038479686 0 Fairfield For profit - Corporation 150 136.3 Medicare and Medicaid false NORWALK OPERATIONS LLC 07/30/1993 false   false false false Resident Yes 5   5   5   5   5   4   4       2.07782 0.76908 0.77045 1.53953 3.61735 0.05534 2.12256 0.71292 0.33392 3.1694 2.03453 0.81117 0.86843 3.65988 05/31/2019 2 2 1 8 1 0 8 04/17/2018 3 3 0 16 1 0 16 2017-04-27 5 5 2 1 32 0 32 14.667 1 2 1 9692.00 0 1 34 MIDROCKS DRIVE NORWALK, CT 06851 (41.142315, -73.415254) 02/01/2020
3498 3498 1235 POTOMAC VALLEY ROAD ROCKVILLE, MD 20850 39.074165 -77.160128 0   215026 POTOMAC VALLEY REHABILITATION AND HEALTHCARE 1235 POTOMAC VALLEY ROAD ROCKVILLE MD 20850 3017620700 150 Montgomery For profit - Corporation 175 157.5 Medicare and Medicaid false POTOMAC VALLEY OPERATOR LLC 01/01/1967 false   false false false Both Yes 5   5   4   3   4   4   4       2.17726 0.58493 0.93668 1.52161 3.69886 0 2.16078 0.77445 0.37761 3.31284 2.09419 0.56793 0.93363 3.58032 11/15/2018 3 3 0 12 1 0 12 10/26/2017 4 4 0 12 1 0 12 2016-11-10 5 5 0 1 8 0 8 11.333 0 0 0 0.00 0 0 1235 POTOMAC VALLEY ROAD ROCKVILLE, MD 20850 (39.074165, -77.160128) 02/01/2020
3533 3533 6131 PARK RIDGE ROAD LOVES PARK, IL 61111 42.3183 -89.068089 0   146069 EAST BANK CENTER, LLC 6131 PARK RIDGE ROAD LOVES PARK IL 61111 8156336810 991 Winnebago For profit - Corporation 54 43.8 Medicare and Medicaid false EAST BANK CENTER LLC 08/30/2004 false   false false false None Yes 5   5   5     2 5   3   4       2.05222 0.54911 1.20101 1.75012 3.80234 0.28946 2.08554 1.01911 0.61059 3.71523 2.04513 0.40516 0.74034 3.28185 08/06/2019 0 0 0 0 0 0 0 07/19/2018 1 0 1 4 0 0 4 2017-06-29 6 5 1 1 52 0 52 10 0 3 0 0.00 0 0 6131 PARK RIDGE ROAD LOVES PARK, IL 61111 (42.3183, -89.068089) 02/01/2020
3662 3662 594 CHERRY DRIVE WACONIA, MN 55387 44.842684 -93.797842 0   245583 AUBURN HOME IN WACONIA 594 CHERRY DRIVE WACONIA MN 55387 9524422546 90 Carver Non profit - Church related 37 34.6 Medicare and Medicaid false MORAVIAN CARE HOUSING CORPORATION 11/01/1991 false   false false false Resident Yes 5   5   5   4   5   1 12 1 12     1.79127 0.31108 0.96549 1.27657 3.06785 0.07854 2.18125 0.68766 0.32906 3.19797 1.70676 0.34016 1.10435 3.07618 06/26/2019 1 1 0 4 1 0 4 05/31/2018 1 1 0 4 1 0 4 2017-04-20 5 5 0 1 20 0 20 6.667 0 0 0 0.00 0 0 594 CHERRY DRIVE WACONIA, MN 55387 (44.842684, -93.797842) 02/01/2020
3950 3950 Winchester, IL 62694, USA 39.62976889999999 -90.45623549999999 1 APPROXIMATE 146106 SCOTT COUNTY NURSING CENTER RURAL ROUTE 2 WINCHESTER IL 62694 2177423101 940 Scott Government - County 49 43.8 Medicare and Medicaid false SCOTT COUNTY NURSING CENTER 10/16/2006 false   false false false Both Yes 5   5   2   3   1   3   3       2.08607 0.97667 0.40467 1.38134 3.46741 0.05799 1.95998 0.64845 0.27168 2.88011 2.21204 1.13254 0.56062 3.86055 12/20/2018 0 0 0 0 0 0 0 02/01/2018 3 3 0 12 1 0 12 2016-12-08 5 5 0 1 16 0 16 6.667 0 0 0 0.00 0 0   02/01/2020
3954 3954 1180 US-22, Mountainside, NJ 07092, USA 40.6797291 -74.34545899999999 1 ROOFTOP 315259 MANOR CARE MOUNTAINSIDE 1180 ROUTE 22 WEST MOUNTAINSIDE NJ 7092 9086540020 370 Union Non profit - Other 151 127.9 Medicare and Medicaid false MANOR CARE OF MOUNTAINSIDE NJ LLC 05/19/1988 false   false false false Resident Yes 5   5   5   5   5   4   4       1.79811 1.08237 0.60509 1.68745 3.48556 0.07956 2.04155 0.69154 0.30109 3.03418 1.83051 1.17691 0.7564 3.68371 05/31/2019 0 0 0 0 0 0 0 04/12/2018 1 1 0 0 1 0 0 2017-02-23 5 5 0 1 32 0 32 5.333 0 0 1 5000.00 0 1   02/01/2020
4027 4027 5300 ZEBULON ROAD MACON, GA 31210 32.87956 -83.739583 0   115680 CARLYLE PLACE 5300 ZEBULON ROAD MACON GA 31210 4784054500 90 Bibb Non profit - Corporation 40 36.8 Medicare false CENTRAL GEORGIA SENIOR HEALTH, INC. 12/09/2002 true   false false false Resident Yes 5   5   4   4   3   4   3       2.41285 1.55391 0.53612 2.09003 4.50288 0.03108 2.21983 0.69363 0.32653 3.23999 2.25905 1.68456 0.61797 4.45657 06/27/2019 0 0 0 0 0 0 0 05/03/2018 0 0 0 0 0 0 0 2017-08-13 5 5 5 1 20 0 20 3.333 0 0 0 0.00 0 0 5300 ZEBULON ROAD MACON, GA 31210 (32.87956, -83.739583) 02/01/2020
4059 4059 4315 MEMORIAL DRIVE BELLEVILLE, IL 62226 38.5489 -90.019827 0   145102 MEMORIAL CARE CENTER 4315 MEMORIAL DRIVE BELLEVILLE IL 62226 6182575060 900 St. Clair For profit - Corporation 82 69.9 Medicare and Medicaid false PROTESTANT MEMORIAL MEDICAL CENTER, INC. 01/01/1967 false   false false false Resident Yes 5   5   5     2 5   5   5       2.9204 0.49868 2.19097 2.68965 5.61005 0.18638 2.04163 0.99055 0.56049 3.59267 2.9729 0.37856 1.4713 5.00729 12/11/2018 3 3 0 24 1 0 24 11/16/2017 2 2 0 8 1 0 8 2016-10-27 5 5 0 1 24 0 24 18.667 0 0 0 0.00 0 0 4315 MEMORIAL DRIVE BELLEVILLE, IL 62226 (38.5489, -90.019827) 02/01/2020
4105 4105 2000 S ANDREWS RD YORKTOWN, IN 47396 40.175349 -85.480764 0   155238 YORKTOWN MANOR 2000 S ANDREWS RD YORKTOWN IN 47396 7657597740 170 Delaware For profit - Corporation 100 66.8 Medicare and Medicaid false ADAMS COUNTY MEMORIAL HOSPITAL 09/20/1984 false   false false false Both Yes 4   5   3   3   4   1 12 1 12     1.83937 0.77942 0.23848 1.0179 2.85727 0.08068 1.99624 0.72983 0.33315 3.05922 1.91501 0.80303 0.26943 2.99498 10/24/2019 1 0 1 4 1 0 4 11/01/2018 2 1 1 8 1 0 8 2017-12-11 5 5 0 1 32 0 32 10 0 4 0 0.00 0 0 2000 S ANDREWS RD YORKTOWN, IN 47396 (40.175349, -85.480764) 02/01/2020
4129 4129 1991 RANDI DRIVE AURORA, IL 60504 41.737378 -88.269099 0   146182 ALDEN COURTS OF WATERFORD 1991 RANDI DRIVE AURORA IL 60504 6308511466 530 Kane For profit - Corporation 20 18.1 Medicare and Medicaid false ALDEN COURTS OF WATERFORD LLC 03/20/2017 false   false false false Family Yes 5   5   2   3   1   4   5       1.9854 0 1.43754 1.43754 3.42294 0.14739 2.20255 0.82994 0.35624 3.38873 1.87343 0 1.51884 3.23903 09/19/2019 1 1 0 4 1 0 4 10/12/2018 6 6 0 24 1 0 24 2017-12-07 5 5 0 1 20 0 20 13.333 0 0 0 0.00 0 0 1991 RANDI DRIVE AURORA, IL 60504 (41.737378, -88.269099) 02/01/2020
4190 4190 1704 HUNTINGTON VILLAGE CIRCLE DAYTONA BEACH, FL 32114 29.199645 -81.069252 0   105822 GARDENS HEALTH & REHABILITATION CENTER, THE 1704 HUNTINGTON VILLAGE CIRCLE DAYTONA BEACH FL 32114 3862556571 630 Volusia For profit - Corporation 108 104.6 Medicare and Medicaid false GARDENS HEALTH NH LLC 07/14/1993 false   false false false Resident Yes 5   5   4   4   3   3   2       2.67389 0.99131 0.46468 1.45599 4.12988 0.24529 2.07053 0.75861 0.35233 3.18147 2.68397 0.9826 0.4964 4.16258 10/25/2018 1 1 0 4 1 0 4 09/21/2017 4 4 0 16 1 0 16 2016-11-10 5 5 0 1 20 0 20 10.667 0 0 0 0.00 0 0 1704 HUNTINGTON VILLAGE CIRCLE DAYTONA BEACH, FL 32114 (29.199645, -81.069252) 02/01/2020
4253 4253 79 SPARROW LANE PRESTONSBURG, KY 41653 37.670496 -82.745121 0   185151 RIVERVIEW HEALTH CARE CENTER 79 SPARROW LANE PRESTONSBURG KY 41653 6068869178 350 Floyd For profit - Corporation 121 113.5 Medicare and Medicaid false LP PRESTONSBURG RIVERVIEW LLC 12/08/1978 false   false false false Resident Yes 4   5   1   2   1   3   4       2.26594 0.40132 0.94271 1.34403 3.60998 0.0509 2.30967 0.86051 0.44909 3.61927 2.03899 0.35068 0.79009 3.19842 10/03/2019 1 0 1 4 0 0 4 07/26/2018 0 0 0 0 0 0 0 2017-06-15 6 5 1 1 24 0 24 6 0 2 0 0.00 0 0 79 SPARROW LANE PRESTONSBURG, KY 41653 (37.670496, -82.745121) 02/01/2020
4277 4277 6000 EAST ILIFF AVE DENVER, CO 80222 39.674845 -104.919769 0   65124 HOLLY HEIGHTS CARE CENTER 6000 EAST ILIFF AVE DENVER CO 80222 3037575441 20 Arapahoe For profit - Corporation 133 121.4 Medicare and Medicaid false HOLLY HEIGHTS NURSING HOME INC. 10/01/1974 false   false false false Resident Yes 5   5   5   5     2 3   3       2.2393 0.9255 0.47476 1.40027 3.63957 0.0386 1.95362 0.64324 0.26811 2.86497 2.38225 1.08191 0.66649 4.07364 10/10/2019 1 0 1 4 1 0 4 09/13/2018 0 0 0 0 0 0 0 2017-05-17 5 5 0 1 24 0 24 6 0 2 0 0.00 0 0 6000 EAST ILIFF AVE DENVER, CO 80222 (39.674845, -104.919769) 02/01/2020
4506 4506 6701 NORTH CHARLES STREET BALTIMORE, MD 21204 39.393497 -76.628092 0   215314 GREATER BALTIMORE MEDICAL CENTER SUB ACUTE UNIT 6701 NORTH CHARLES STREET BALTIMORE MD 21204 4438492094 20 Baltimore Non profit - Corporation 27 26.2 Medicare and Medicaid true Legal Business Name Not Available 12/03/1997 false   false false false None Yes 5   5   5     2 5   5   5       2.05351 0.70856 2.58836 3.29692 5.35043 0.58474 1.90226 0.95389 0.53862 3.39477 2.24358 0.55855 1.80873 5.05396 09/14/2018 2 2 0 8 1 0 8 06/19/2017 1 1 0 16 1 0 16 2016-05-05 5 5 0 1 24 0 24 13.333 0 0 0 0.00 0 0 6701 NORTH CHARLES STREET BALTIMORE, MD 21204 (39.393497, -76.628092) 02/01/2020
4817 4817 5091 WILLOUGHBY ROAD HOLT, MI 48842 42.65482 -84.547218 0   235279 HOLT SENIOR CARE AND REHAB CENTER, L L C 5091 WILLOUGHBY ROAD HOLT MI 48842 5176942144 320 Ingham For profit - Corporation 101 88 Medicare and Medicaid false HOLT SENIOR CARE AND REHAB CENTER, LLC 01/01/1976 false   false false false Both Yes 5   5   5   5   5   4   4       2.47586 0.82115 0.84461 1.66576 4.14162 0.07941 2.15224 0.75054 0.34087 3.24365 2.39085 0.82268 0.9326 4.09439 09/11/2019 4 4 0 28 1 0 28 12/07/2018 6 5 1 24 1 0 24 2017-08-23 8 5 6 1 48 0 48 30 0 2 1 2357.00 0 1 5091 WILLOUGHBY ROAD HOLT, MI 48842 (42.65482, -84.547218) 02/01/2020
4828 4828 123 BAKEN STREET THIEF RIVER FALLS, MN 56701 48.102118 -96.182841 0   245592 OAKLAND PARK COMMUNITIES 123 BAKEN STREET THIEF RIVER FALLS MN 56701 2186811675 560 Pennington For profit - Corporation 35 31.3 Medicare and Medicaid false OAKLAND PARK COMMUNITIES, INC 12/01/1991 false   false false false Resident Yes 5   5   5   5     2 4   4       2.59088 0.94278 0.64142 1.58419 4.17508 0.01583 2.20375 0.69318 0.29532 3.19224 2.44344 1.0227 0.81749 4.19394 07/25/2019 0 0 0 0 0 0 0 09/13/2018 0 0 0 0 0 0 0 2017-08-03 5 5 0 1 32 0 32 5.333 0 0 0 0.00 0 0 123 BAKEN STREET THIEF RIVER FALLS, MN 56701 (48.102118, -96.182841) 02/01/2020
4908 4908 315 SOUTH TILLEY STREET ADVANCE, MO 63730 37.103395 -89.916599 0   265550 ADVANCE NURSING CENTER 315 SOUTH TILLEY STREET ADVANCE MO 63730 5737223440 985 Stoddard For profit - Corporation 70 25.2 Medicare and Medicaid false N & R OF ADVANCE, INC. 11/01/1993 false   false false false Resident Yes 5   5   4   3   4   3   3       2.12463 0.83371 0.57479 1.40851 3.53314 0.02778 1.99365 0.64628 0.318 2.95792 2.21489 0.97002 0.68033 3.83025 10/11/2019 4 4 0 16 1 0 16 08/17/2018 1 1 0 4 1 0 4 2017-07-07 5 5 0 1 28 0 28 14 0 0 0 0.00 0 0 315 SOUTH TILLEY STREET ADVANCE, MO 63730 (37.103395, -89.916599) 02/01/2020
5128 5128 550 ROSELAWN AVENUE EAST SAINT PAUL, MN 55117 44.999104 -93.077867 0   245221 GOOD SAMARITAN SOCIETY - MAPLEWOOD 550 ROSELAWN AVENUE EAST SAINT PAUL MN 55117 6517749765 610 Ramsey Non profit - Corporation 71 65.9 Medicare and Medicaid false THE EVANGELICAL LUTHERAN GOOD SAMARITAN SOCIETY 04/01/1978 false   false false false Both Yes 5   5   5   5   4   5   5       2.57089 0.6546 1.55042 2.20503 4.77591 0.14509 2.04817 0.79456 0.37085 3.21358 2.60875 0.61949 1.57355 4.76563 01/17/2019 4 4 0 8 1 0 8 03/22/2018 4 4 0 16 1 0 16 2017-04-13 5 5 0 1 20 0 20 12.667 0 0 0 0.00 0 0 550 ROSELAWN AVENUE EAST SAINT PAUL, MN 55117 (44.999104, -93.077867) 02/01/2020
5448 5448 4325 SOUTHPOINT BOULEVARD JACKSONVILLE, FL 32216 30.253474 -81.588045 0   106058 WOODLAND GROVE HEALTH & REHABILITATION CENTER 4325 SOUTHPOINT BOULEVARD JACKSONVILLE FL 32216 9042457620 150 Duval For profit - Limited Liability company 120 111.7 Medicare and Medicaid false WOODLAND GROVE NH LLC 02/20/2004 false   false false false Resident Yes 5   5   4   4   5   3   3       2.47229 0.84235 0.42658 1.26893 3.74122 0.03865 2.03531 0.67357 0.28792 2.9968 2.52456 0.94037 0.55764 4.00322 08/01/2019 2 2 0 8 1 0 8 04/12/2018 2 1 1 8 1 0 8 2017-02-16 5 5 0 1 24 0 24 10.667 0 1 0 0.00 0 0 4325 SOUTHPOINT BOULEVARD JACKSONVILLE, FL 32216 (30.253474, -81.588045) 02/01/2020
6000 6000 1227 WEST WHEELER PARKWAY AUGUSTA, GA 30909 33.479916 -82.098438 0   115147 KENTWOOD NURSING FACILITY 1227 WEST WHEELER PARKWAY AUGUSTA GA 30909 7068631188 840 Richmond Non profit - Corporation 100 91.4 Medicare and Medicaid false UNIVERSITY EXTENDED CARE INC 02/03/1976 false   false false false Resident Yes 5   5   4   3   5   4   3       2.41315 1.476 0.54858 2.02458 4.43773 0.10895 2.02368 0.74307 0.35945 3.12619 2.47833 1.49363 0.57443 4.55196 04/04/2019 0 0 0 0 0 0 0 02/15/2018 0 0 0 0 0 0 0 2017-02-16 5 5 5 1 24 0 24 4 0 0 0 0.00 0 0 1227 WEST WHEELER PARKWAY AUGUSTA, GA 30909 (33.479916, -82.098438) 02/01/2020
6164 6164 131 S 10TH ST MIDDLETOWN, IN 47356 40.053215 -85.542089 0   155486 MIDDLETOWN NURSING AND REHABILITATION CENTER 131 S 10TH ST MIDDLETOWN IN 47356 7653542223 320 Henry For profit - Corporation 45 30.1 Medicare and Medicaid false MOORE HEALTHCARE ENTERPRISES INC 05/01/1993 false   false false false Resident Yes 5   5   5   4   5   4   4       1.73088 1.054 0.88975 1.94376 3.67464 0.03871 2.06817 0.72861 0.32841 3.1252 1.73939 1.08775 1.01972 3.77043 11/04/2019 0 0 0 0 0 0 0 10/26/2018 4 3 1 16 1 0 16 2017-08-30 8 5 3 1 40 0 40 12 4 1 0 0.00 0 0 131 S 10TH ST MIDDLETOWN, IN 47356 (40.053215, -85.542089) 02/01/2020
6236 6236 111 WESTCOTT RD DANIELSON, CT 06239 41.809353 -71.873842 0   75423 DAVIS PLACE 111 WESTCOTT RD DANIELSON CT 6239 8607749540 70 Windham For profit - Limited Liability company 190 167.2 Medicare and Medicaid false JACC HEALTHCARE CENTER OF DANIELSON LLC 03/03/2000 false   false false false Resident Yes 5   5   3   2   4   3   3       2.18747 0.81535 0.53045 1.3458 3.53327 0.04026 1.93912 0.68903 0.31943 2.94759 2.34451 0.8898 0.62502 3.84383 08/01/2019 3 3 0 12 1 0 12 05/25/2018 5 5 2 12 1 0 12 2017-06-09 5 5 1 1 20 0 20 13.333 1 1 0 0.00 0 0 111 WESTCOTT RD DANIELSON, CT 06239 (41.809353, -71.873842) 02/01/2020
6777 6777 19333 WEST COUNTRY CLUB DRIVE AVENTURA, FL 33180 25.954537 -80.138608 0   106076 VI AT AVENTURA 19333 WEST COUNTRY CLUB DRIVE AVENTURA FL 33180 3056924700 120 Miami-Dade For profit - Corporation 40 30.3 Medicare false CC-AVENTURA, INC. 04/26/2007 true   false false false Resident Yes 5   5   2   2   3   5   5       3.65377 1.5487 1.49478 3.04348 6.69725 0.10034 2.36073 0.86578 0.45132 3.67784 3.2167 1.34506 1.24658 5.83924 09/20/2019 4 4 0 16 1 0 16 06/01/2018 0 0 0 0 0 0 0 2017-06-08 5 5 0 1 20 0 20 11.333 0 0 0 0.00 0 0 19333 WEST COUNTRY CLUB DRIVE AVENTURA, FL 33180 (25.954537, -80.138608) 02/01/2020
6940 6940 580 W 8TH STREET JACKSONVILLE, FL 32209 30.346418 -81.662896 0   105961 SHANDS JACKSONVILLE MEDICAL CENTER 580 W 8TH STREET JACKSONVILLE FL 32209 9042441812 150 Duval Non profit - Corporation 56 37.3 Medicare and Medicaid true SHANDS JACKSONVILLE MEDICAL CENTER INC 07/24/1997 false   false false false Resident Yes 5   5   5   5   5   5   5       3.2692 0.51936 3.48329 4.00266 7.27186 0.27288 1.90432 0.83131 0.45653 3.19215 3.56795 0.46978 2.87179 7.30491 11/21/2018 0 0 0 0 0 0 0 09/28/2017 0 0 0 0 0 0 0 2016-08-18 5 5 0 1 32 0 32 5.333 0 0 0 0.00 0 0 580 W 8TH STREET JACKSONVILLE, FL 32209 (30.346418, -81.662896) 02/01/2020
7226 7226 22444 US-431, Guntersville, AL 35976, USA 34.4226845 -86.26218659999999 1 ROOFTOP 15225 BARFIELD HEALTH CARE 22444 HIGHWAY 431 GUNTERSVILLE AL 35976 2565823112 470 Marshall For profit - Corporation 113 107.4 Medicare and Medicaid false BARFIELD HEALTH CARE ACQUISITION CORPORATION 02/20/1979 false   false false false Both Yes 5   5   2   2   1   4   3       3.37493 1.06525 0.49274 1.55798 4.93291 0.07931 2.07574 0.65441 0.30627 3.03642 3.37915 1.22401 0.60554 5.20948 10/31/2019 0 0 0 0 0 0 0 09/07/2018 1 1 0 4 1 0 4 2017-07-28 5 5 0 1 32 0 32 6.667 0 0 0 0.00 0 0   02/01/2020
7511 7511 28349 JOY RD WESTLAND, MI 48185 42.355012 -83.321233 0   235467 FOUR CHAPLAINS NRSG CARE CTR 28349 JOY RD WESTLAND MI 48185 7342619500 810 Wayne For profit - Corporation 103 94 Medicare and Medicaid false CHAPLAINS, INC. 04/10/1988 false   false false false Resident Yes 5   5   4   5   3   4   4       2.19882 1.03941 0.81598 1.8554 4.05422 0 2.25581 0.7307 0.31498 3.30149 2.02583 1.06963 0.97505 3.93777 03/27/2019 4 3 1 24 1 0 24 05/24/2018 5 5 0 36 1 0 36 2017-04-13 5 5 0 1 44 0 44 31.333 0 4 0 0.00 0 0 28349 JOY RD WESTLAND, MI 48185 (42.355012, -83.321233) 02/01/2020
7652 7652 2215 OAKMONT WAY WEST SACRAMENTO, CA 95691 38.575594 -121.539739 0   55887 RIVER BEND NURSING CENTER 2215 OAKMONT WAY WEST SACRAMENTO CA 95691 9163711890 670 Yolo For profit - Corporation 99 93.4 Medicare and Medicaid false RIVER BEND HOLDINGS, LLC 02/08/1968 false   false false false Resident Yes 5   5   5   5   5   2   1       2.83618 2.01686 0.54751 2.56437 5.40055 0 2.36175 0.94245 0.81454 4.11874 2.49583 1.60917 0.25299 4.20462 12/13/2018 4 2 2 16 1 0 16 12/07/2017 3 1 2 16 1 0 16 2016-12-08 6 5 1 1 20 0 20 16.667 0 6 0 0.00 0 0 2215 OAKMONT WAY WEST SACRAMENTO, CA 95691 (38.575594, -121.539739) 02/01/2020
7718 7718 602 EAST JACKSON DU QUOIN, IL 62832 38.001994 -89.22758 0   146032 FAIRVIEW REHAB & HEALTHCARE 602 EAST JACKSON DU QUOIN IL 62832 6185423441 810 Perry For profit - Limited Liability company 76 49.3 Medicare and Medicaid false FAIRVIEW REHABILITATION & HEALTHCARE LLC 08/15/2002 false   false false true Resident Yes 4   5   1   1   1   2   3       1.62714 0.5675 0.44501 1.0125 2.63965 0 1.95066 0.62255 0.28286 2.85607 1.73365 0.68545 0.59215 2.96368 07/18/2019 2 2 0 4 1 0 4 06/07/2018 2 1 1 4 0 0 4 2017-08-18 5 5 0 1 28 0 28 8 1 0 0 0.00 0 0 602 EAST JACKSON DU QUOIN, IL 62832 (38.001994, -89.22758) 02/01/2020
7948 7948 122 PALMERS HILL RD STAMFORD, CT 06902 41.059385 -73.565584 0   75421 EDGEHILL HEALTH CENTER 122 PALMERS HILL RD STAMFORD CT 6902 2033232323 0 Fairfield For profit - Corporation 46 38.3 Medicare false B-IX EDGEHILL SNF LLC 04/13/2000 true   false false false Resident Yes 5   5   4   5   3   5   5       2.7552 0.92437 1.36981 2.29418 5.04938 0.42245 2.19706 0.8568 0.43229 3.48615 2.60632 0.81124 1.19266 4.64457 07/11/2019 0 0 0 0 0 0 0 06/13/2018 5 5 1 20 1 0 20 2017-07-27 5 5 0 1 48 0 48 14.667 1 0 0 0.00 0 0 122 PALMERS HILL RD STAMFORD, CT 06902 (41.059385, -73.565584) 02/01/2020
7992 7992 731 KLEIN CIRCLE DERBY, KS 67037 37.550187 -97.238315 0   175514 DERBY HEALTH & REHABILITATION, LLC 731 KLEIN CIRCLE DERBY KS 67037 3167192400 860 Sedgwick For profit - Corporation 74 70 Medicare and Medicaid false DERBY HEALTH & REHABILITATION 02/16/2010 false   false false false Both Yes 5   5   5   5   5   4   4       2.99121 0.81247 0.99374 1.80621 4.79743 0.13414 2.09961 0.78859 0.37417 3.26237 2.96091 0.77472 0.99961 4.71551 08/12/2019 0 0 0 0 0 0 0 07/19/2018 0 0 0 0 0 0 0 2016-09-26 7 5 2 1 48 0 48 8 2 0 0 0.00 0 0 731 KLEIN CIRCLE DERBY, KS 67037 (37.550187, -97.238315) 02/01/2020
8013 8013 521 NORTH MAIN STREET ANNA, IL 62906 37.465383 -89.245021 0   14A453 UNION COUNTY HOSPITAL L T C 521 NORTH MAIN STREET ANNA IL 62906 6188334511 981 Union For profit - Corporation 10 8.9 Medicaid false Legal Business Name Not Available 10/01/1991 false   false false false Resident Yes 5   5   5   5     2 5   5       2.9188 1.79684 1.84793 3.64477 6.56356 0 2.51801 0.64992 0.30134 3.46927 2.40914 2.07889 2.30815 6.06674 08/09/2019 2 2 0 8 1 0 8 07/06/2018 0 0 0 0 0 0 0 2017-06-29 5 5 0 1 20 0 20 7.333 0 0 0 0.00 0 0 521 NORTH MAIN STREET ANNA, IL 62906 (37.465383, -89.245021) 02/01/2020
8709 8709 931 N Broadway St, Aspermont, TX 79502, USA 33.1481491 -100.2274452 1 RANGE_INTERPOLATED 676077 GIBSON CARE CENTER 931 N BROADWAY ASPERMONT TX 79502 9409893526 903 Stonewall For profit - Corporation 80 26.2 Medicare and Medicaid true STONEWALL MEMORIAL HOSPITAL 09/13/2005 false   false false false Both Yes 4   5   2   2     2 1 12 1 12 6 6                             03/25/2019 2 1 1 8 1 0 8 02/28/2018 0 0 0 0 0 0 0 2017-01-05 5 5 0 1 48 0 48 12 0 1 0 0.00 0 0   02/01/2020
8826 8826 310 WEST TAFT SAPULPA, OK 74066 35.988456 -96.117655 0   375284 ARBOR VILLAGE 310 WEST TAFT SAPULPA OK 74066 9182161811 180 Creek For profit - Corporation 142 81 Medicare and Medicaid false ARBOR VILLAGE NURSING LLC 11/04/1996 false   false false false Resident Yes 5   5   2   3   2   3   2       2.14333 1.20421 0.23836 1.44257 3.58591 0.01434 1.73652 0.63379 0.28107 2.65138 2.56522 1.42871 0.31919 4.3369 05/06/2019 2 2 0 16 1 0 16 03/29/2018 0 0 0 0 0 0 0 2016-12-19 7 5 2 1 44 0 44 15.333 1 0 0 0.00 0 0 310 WEST TAFT SAPULPA, OK 74066 (35.988456, -96.117655) 02/01/2020
8847 8847 1917 LOHMANS CROSSING RD LAKEWAY, TX 78734 30.34436 -97.974903 0   676131 BROOKDALE LAKEWAY 2 1917 LOHMANS CROSSING RD LAKEWAY TX 78734 5122613211 940 Travis For profit - Corporation 81 73.2 Medicare and Medicaid false ARC LAKEWAY SNF, LLC 03/20/2007 true   false false false Resident Yes 5   5   4   4   4   4   4       2.96628 1.23797 0.88074 2.1187 5.08498 0.17 2.08439 0.77975 0.40773 3.27187 2.95766 1.19382 0.81303 4.98364 12/19/2018 0 0 0 0 1 0 0 11/16/2017 4 3 1 32 1 0 32 2017-01-11 6 5 1 1 40 0 40 17.333 0 2 0 0.00 0 0 1917 LOHMANS CROSSING RD LAKEWAY, TX 78734 (30.34436, -97.974903) 02/01/2020
8993 8993 1761 BEALL AVENUE WOOSTER, OH 44691 40.820713 -81.934247 0   366405 WOOSTER COMMUNITY HOSPITAL SNF 1761 BEALL AVENUE WOOSTER OH 44691 3302638100 860 Wayne Government - City 22 19.9 Medicare false CITY OF WOOSTER 03/29/2013 false   false false false None Yes 5   5   5     2 5   5   5       2.95049 1.17806 2.78884 3.9669 6.9174 0.12527 2.40782 1.08826 0.6066 4.10268 2.54675 0.81399 1.73043 5.40665 01/04/2019 0 0 0 0 0 0 0 11/08/2017 0 0 0 0 0 0 0 2016-08-25 5 5 0 1 16 0 16 2.667 0 0 0 0.00 0 0 1761 BEALL AVENUE WOOSTER, OH 44691 (40.820713, -81.934247) 02/01/2020
9145 9145 900 MANCHESTER ROAD FAIRVIEW, PA 16415 42.069448 -80.228342 0   395572 FAIRVIEW MANOR 900 MANCHESTER ROAD FAIRVIEW PA 16415 8148384822 320 Erie For profit - Corporation 121 114.8 Medicare and Medicaid false HCF OF FAIRVIEW, INC. 05/11/1983 false   false false false Resident Yes 5   5   5   5   5   2   3       1.76686 0.81607 0.68893 1.505 3.27186 0.06116 2.19035 0.81248 0.42784 3.43067 1.6765 0.75526 0.60608 3.05823 01/25/2019 2 2 0 4 2 2 6 12/19/2017 2 1 1 8 1 0 8 2017-01-06 6 5 1 1 32 0 32 11 1 1 0 0.00 0 0 900 MANCHESTER ROAD FAIRVIEW, PA 16415 (42.069448, -80.228342) 02/01/2020
9346 9346 205 GRANADA ST CAMARILLO, CA 93010 34.214716 -119.053515 0   555770 CAMARILLO HEALTHCARE CENTER 205 GRANADA ST CAMARILLO CA 93010 8054829805 660 Ventura For profit - Corporation 114 103.3 Medicare and Medicaid false CAMARILLO COMMUNITY CARE INC 04/11/2001 false   false false false Resident Yes 5   5   5   5   5   3   3       2.59223 0.63941 0.61923 1.25864 3.85087 0.14846 2.07254 0.72565 0.33989 3.13807 2.59948 0.66258 0.68573 3.93504 01/24/2019 1 1 0 8 1 0 8 03/01/2018 10 7 3 48 1 0 48 2017-03-23 5 5 0 1 24 0 24 24 1 3 0 0.00 0 0 205 GRANADA ST CAMARILLO, CA 93010 (34.214716, -119.053515) 02/01/2020
9731 9731 336 DIABLO ROAD DANVILLE, CA 94526 37.822998 -121.996851 0   555376 DANVILLE POST-ACUTE REHAB 336 DIABLO ROAD DANVILLE CA 94526 9258374566 60 Contra Costa For profit - Corporation 54 46 Medicare and Medicaid false DANVILLE LONG-TERM CARE INC 05/01/1989 false   false false false Resident Yes 5   5   5   5   5   4   4       2.46039 0.75201 0.98748 1.73949 4.19988 0.51772 2.25204 0.8069 0.37934 3.43828 2.27062 0.70079 0.97979 3.91695 02/13/2019 1 1 0 8 1 0 8 03/15/2018 4 4 0 8 1 0 8 2017-03-02 6 5 1 1 40 0 40 13.333 1 0 0 0.00 0 0 336 DIABLO ROAD DANVILLE, CA 94526 (37.822998, -121.996851) 02/01/2020
10059 10059 1000 ORWIGSBURG MANOR DR ORWIGSBURG, PA 17961 40.660227 -76.101279 0   395878 ORWIGSBURG NURSING AND REHABILITATION CENTER 1000 ORWIGSBURG MANOR DR ORWIGSBURG PA 17961 5703662999 650 Schuylkill For profit - Partnership 130 109.8 Medicare and Medicaid false OC REHAB & NURSING CENTER LLC 08/27/1992 false   false false false Resident Yes 5   5   3   2   4   2   2       1.96504 0.82427 0.47957 1.30384 3.26888 0.04718 2.18715 0.83456 0.43651 3.45821 1.86728 0.74267 0.41351 3.0311 04/26/2019 2 2 0 12 1 0 12 05/25/2018 2 2 0 4 1 0 4 2017-04-21 5 5 0 1 20 0 20 10.667 0 0 0 0.00 0 0 1000 ORWIGSBURG MANOR DR ORWIGSBURG, PA 17961 (40.660227, -76.101279) 02/01/2020
10308 10308 505 NORTH 40TH AVENUE YAKIMA, WA 98908 46.6057 -120.561975 0   505085 CRESCENT HEALTH CARE, INC 505 NORTH 40TH AVENUE YAKIMA WA 98908 5092484446 380 Yakima For profit - Individual 85 69.3 Medicare and Medicaid false CRESCENT HEALTH CARE, INC. 01/01/1967 false   false false false Resident Yes 5   5   4   5   4   3   4       2.08141 0.52946 0.75773 1.28719 3.3686 0.03097 2.26984 0.7372 0.30386 3.3109 1.9058 0.54005 0.93857 3.26255 09/12/2019 5 4 1 28 1 0 28 07/13/2018 3 2 1 28 1 0 28 2017-09-15 11 5 7 1 68 0 68 34.667 3 7 2 13650.00 0 2 505 NORTH 40TH AVENUE YAKIMA, WA 98908 (46.6057, -120.561975) 02/01/2020
10648 10648 12640 SE BUSH PORTLAND, OR 97236 45.49447 -122.533263 0   3.8e+174 CORNERSTONE CARE OPTION 12640 SE BUSH PORTLAND OR 97236 5037616621 250 Multnomah For profit - Corporation 40 39.2 Medicaid false Legal Business Name Not Available 04/01/1976 false   false false false Resident Yes 5   5   5   5     2 4   5       2.55254 0 0.94731 0.94731 3.49985 0 2.24455 0.67479 0.28382 3.20317 2.36351 0 1.25626 3.50367 06/13/2019 3 3 0 24 1 0 24 12/05/2017 2 2 0 8 1 0 8 2016-11-04 5 5 0 1 20 0 20 18 0 0 0 0.00 0 0 12640 SE BUSH PORTLAND, OR 97236 (45.49447, -122.533263) 02/01/2020
11098 11098 406 WEST BROAD STREET IVA, SC 29655 34.309181 -82.668125 0   425317 IVA REHABILITATION AND HEALTHCARE CENTER 406 WEST BROAD STREET IVA SC 29655 8643487433 30 Anderson For profit - Corporation 60 52.7 Medicare and Medicaid false SC-GA2018 IVA REHABILITATION AND HEALTHCARE CENTER, LLC 10/09/1991 false   false false false Resident Yes 5   5   2   2   2   3   3       2.11144 0.9887 0.6063 1.595 3.70645 0.09514 2.15424 0.7465 0.34948 3.25022 2.03705 0.99591 0.65297 3.65677 05/16/2019 0 0 0 0 0 0 0 06/01/2018 0 0 0 0 0 0 0 2017-03-01 6 5 1 1 36 0 36 6 0 0 0 0.00 0 0 406 WEST BROAD STREET IVA, SC 29655 (34.309181, -82.668125) 02/01/2020
11136 11136 524 WEST MAIN STREET DECATURVILLE, TN 38329 35.581331 -88.128105 0   445449 AHC WESTWOOD 524 WEST MAIN STREET DECATURVILLE TN 38329 7318523591 190 Decatur For profit - Corporation 90 53.7 Medicare and Medicaid false WESTWOOD HEALTH CARE AND REHABILITATION CENTER INC 04/01/2002 false   false false false Both Yes 5   5   4   4   4   3   3       2.23175 0.94888 0.61474 1.56361 3.79536 0.05633 2.10546 0.72674 0.32333 3.15553 2.20299 0.98178 0.71561 3.85686 01/23/2020 0 0 0 0 0 0 0 03/12/2019 0 0 0 0 0 0 0 2018-05-09 5 5 0 1 24 0 24 4 1 0 0 0.00 0 0 524 WEST MAIN STREET DECATURVILLE, TN 38329 (35.581331, -88.128105) 02/01/2020
11438 11438 2644 BRISTOL ROAD WARRINGTON, PA 18976 40.255949 -75.14065 0   395194 FOX SUBACUTE CENTER 2644 BRISTOL ROAD WARRINGTON PA 18976 2153432700 140 Bucks For profit - Corporation 60 48.6 Medicare and Medicaid false FOX NURSING HOME CORP 10/01/1976 false   false false false Resident Yes 5   5   2   2   2   2   2       2.482 1.40673 1.60892 3.01566 5.49765 0.10697 2.50647 1.06237 1.88426 5.4531 2.05804 0.99568 0.32139 3.23286 09/06/2019 1 1 0 8 1 0 8 10/02/2018 2 1 1 8 1 0 8 2017-11-09 5 5 0 1 20 0 20 10 0 1 0 0.00 0 0 2644 BRISTOL ROAD WARRINGTON, PA 18976 (40.255949, -75.14065) 02/01/2020
11662 11662 10805 El Camino Real, Atascadero, CA 93422, USA 35.4571194 -120.6398085 1 ROOFTOP 555554 DANISH CARE CENTER 10805 EL CAMINO REAL ATASCADERO CA 93422 8054669254 500 San Luis Obispo For profit - Corporation 65 57.3 Medicare and Medicaid false COMPASS HEALTH INC 03/17/1993 false   false false false Resident Yes 5   5   5   5   5   4   3       3.44316 1.11575 0.46759 1.58334 5.0265 0.0818 2.29175 0.72967 0.33396 3.35537 3.12253 1.14981 0.527 4.80373 01/30/2019 3 3 0 20 1 0 20 01/16/2018 6 5 1 28 1 0 28 2017-01-12 5 5 0 1 28 0 28 24 0 1 0 0.00 0 0   02/01/2020
11939 11939 4365 NORTHERN PIKE MONROEVILLE, PA 15146 40.434289 -79.747401 0   396138 HARMONY PHYSICAL REHABILITATION 4365 NORTHERN PIKE MONROEVILLE PA 15146 7243521571 10 Allegheny Non profit - Corporation 25 22.6 Medicare false CONCORDIA LUTHERAN HEALTH AND HUMAN CARE 06/20/2015 false   false false false Resident Yes 5   5   3     2 3   4   4       1.79722 1.57432 1.40248 2.9768 4.77402 0.22259 2.24994 0.96138 0.52453 3.73585 1.66014 1.23136 1.00636 4.09777 12/28/2018 0 0 0 0 0 0 0 11/15/2017 2 2 0 20 1 0 20 2016-11-03 5 5 0 1 24 0 24 10.667 0 0 0 0.00 0 0 4365 NORTHERN PIKE MONROEVILLE, PA 15146 (40.434289, -79.747401) 02/01/2020
11974 11974 3026 MOUNT HOPE HOME ROAD MANHEIM, PA 17545 40.207566 -76.466114 0   396119 MT HOPE NAZARENE RETIREMENT COMMUNITY 3026 MOUNT HOPE HOME ROAD MANHEIM PA 17545 7176656365 440 Lancaster Non profit - Corporation 50 48.5 Medicare and Medicaid false MT. HOPE NAZARENE RETIREMENT COMMUNITY 07/01/2008 false   false false false Both Yes 5   5   5   5     2 3   3       2.37843 0.81662 0.77319 1.58981 3.96824 0.02909 1.98377 0.82759 0.44542 3.25678 2.49182 0.74197 0.65336 3.90718 12/07/2018 0 0 0 0 0 0 0 01/05/2018 0 0 0 0 0 0 0 2016-12-27 6 5 1 1 24 0 24 4 0 1 0 0.00 0 0 3026 MOUNT HOPE HOME ROAD MANHEIM, PA 17545 (40.207566, -76.466114) 02/01/2020
11997 11997 214 EAST 23RD STREET CHEYENNE, WY 82001 41.139789 -104.817036 0   535044 CHEYENNE REG MEDICAL CTR TRANSITIONAL CARE UNIT 214 EAST 23RD STREET CHEYENNE WY 82001 3076337365 100 Laramie Government - County 16 7.5 Medicare true MEMORIAL HOSPITAL OF LARAMIE COUNTY 02/07/1991 false   false false false Resident Yes 5   5   5     2 5   5   5       3.47566 0 7.60896 7.60896 11.08462 0.61836 1.97717 0.99943 0.5571 3.5337 3.6535 0 5.14073 10.05876 10/04/2018 1 1 0 4 1 0 4 11/15/2017 2 2 0 4 1 0 4 2016-11-23 5 5 0 1 36 0 36 9.333 0 0 0 0.00 0 0 214 EAST 23RD STREET CHEYENNE, WY 82001 (41.139789, -104.817036) 02/01/2020
12625 12625 3230 CARLSON BOULEVARD EL CERRITO, CA 94530 37.901387 -122.304135 0   555364 SHIELDS NURSING CENTER 3230 CARLSON BOULEVARD EL CERRITO CA 94530 5105253212 60 Contra Costa For profit - Corporation 45 32.1 Medicare and Medicaid false SHIELDS NURSING CENTERS INC 05/17/1989 false   false false false Resident Yes 5   5   5   5   5   5   5       2.60276 0.2666 1.36403 1.63063 4.2334 0.11774 2.14389 0.75154 0.35928 3.25471 2.52318 0.26675 1.42895 4.1709 04/17/2019 1 1 0 4 1 0 4 05/31/2018 4 4 0 16 1 0 16 2017-05-25 5 5 0 1 24 0 24 11.333 0 0 0 0.00 0 0 3230 CARLSON BOULEVARD EL CERRITO, CA 94530 (37.901387, -122.304135) 02/01/2020
12810 12810 503 MEADOW DRIVE WEST, TX 76691 31.817289 -97.093854 0   676386 WEST REST HAVEN INC 503 MEADOW DRIVE WEST TX 76691 2548265354 780 Mc Lennan For profit - Corporation 120 115.7 Medicare and Medicaid false WEST REST HAVEN INC 08/25/2015 false   false false false Resident Yes 4   5   3   2   5   1   1       2.08103 0.92075 0.31913 1.23988 3.32091 0.04032 1.96846 0.77363 0.39519 3.13728 2.19719 0.89494 0.30394 3.39435 11/06/2019 3 3 0 16 1 0 16 09/12/2018 0 0 0 0 0 0 0 2017-08-16 5 5 0 1 40 0 40 14.667 0 0 0 0.00 0 0 503 MEADOW DRIVE WEST, TX 76691 (31.817289, -97.093854) 02/01/2020
12957 12957 105 ATRIUM DRIVE FRANKLIN, OH 45005 39.501921 -84.309513 0   366376 OTTERBEIN MIDDLETOWN 105 ATRIUM DRIVE FRANKLIN OH 45005 5137274590 840 Warren Non profit - Corporation 50 46.8 Medicare and Medicaid false OTTERBEIN MIDDLETOWN LLC 06/08/2009 false   false false false None Yes 5   5   4   4   4   4   3       3.51923 0.67493 0.67831 1.35324 4.87247 0.09077 2.14455 0.88407 0.48313 3.51175 3.41058 0.57406 0.52844 4.44917 08/29/2019 1 1 0 4 1 0 4 07/03/2018 0 0 0 0 0 0 0 2017-09-08 6 5 1 1 40 0 40 8.667 0 1 1 2717.00 0 1 105 ATRIUM DRIVE FRANKLIN, OH 45005 (39.501921, -84.309513) 02/01/2020
13000 13000 950 LINDEN STREET OGDENSBURG, NY 13669 44.699777 -75.466212 0   335087 ST JOSEPHS HOME 950 LINDEN STREET OGDENSBURG NY 13669 3153933780 630 St. Lawrence Non profit - Corporation 82 82.7 Medicare and Medicaid false ST. JOSEPH'S HOME 01/01/1967 false   false false false Resident Yes 5   5   4   4     2 2   2       1.81126 0.54878 0.32693 0.87571 2.68697 0.01381 1.93976 0.65409 0.27495 2.8688 1.94066 0.63088 0.44754 3.00342 06/06/2019 1 1 0 4 1 0 4 12/01/2017 0 0 0 0 0 0 0 2016-08-11 5 5 0 1 20 0 20 5.333 0 0 0 0.00 0 0 950 LINDEN STREET OGDENSBURG, NY 13669 (44.699777, -75.466212) 02/01/2020
13100 13100 105 MEDFORD DRIVE DARLINGTON, SC 29532 34.31415 -79.870166 0   425176 MEDFORD NURSING CENTER 105 MEDFORD DRIVE DARLINGTON SC 29532 8433987000 150 Darlington For profit - Corporation 88 83.1 Medicare and Medicaid false MEDFORD NURSING CENTER LLC 10/06/1989 false   false false false Resident Yes 5   5   2   3   1   4   3       2.808 0.93297 0.46021 1.39318 4.20118 0.02222 2.03594 0.65597 0.26944 2.96135 2.86648 1.06946 0.64287 4.5492 11/16/2018 0 0 0 0 0 0 0 11/02/2017 0 0 0 0 0 0 0 2016-10-20 5 5 0 1 24 0 24 4 0 0 0 0.00 0 0 105 MEDFORD DRIVE DARLINGTON, SC 29532 (34.31415, -79.870166) 02/01/2020
13338 13338 3575 LONESOME PINE ROAD SAVANNAH, TN 38372 35.209934 -88.063936 0   445527 HARBERT HILLS ACADEMY N H 3575 LONESOME PINE ROAD SAVANNAH TN 38372 7319255495 350 Hardin Non profit - Corporation 49 48.3 Medicare and Medicaid false RURAL LIFE FOUNDATION INC. 08/18/2016 false   false false false Resident Yes 5   5   5   5     2 3   2       3.12989 1.15281 0.21293 1.36573 4.49563 0 2.1275 0.63086 0.21238 2.97073 3.05757 1.37407 0.37736 4.85266 05/30/2019 0 0 0 0 0 0 0 07/31/2018 0 0 0 0 0 0 0 2017-07-25 5 5 0 1 36 0 36 6 0 0 0 0.00 0 0 3575 LONESOME PINE ROAD SAVANNAH, TN 38372 (35.209934, -88.063936) 02/01/2020
14118 14118 15731 MAUBERT AVENUE SAN LEANDRO, CA 94578 37.704735 -122.118481 0   555879 ALL SAINT'S MAUBERT 15731 MAUBERT AVENUE SAN LEANDRO CA 94578 5104813200 0 Alameda For profit - Corporation 14 12.8 Medicare and Medicaid false MAUBERTIDENCE OPCO, LLC 02/21/2013 false   false false false None Yes 5   5   2     2 2   3   3       3.15659 1.46948 2.29703 3.76651 6.9231 0.40293 2.46763 1.41938 1.36356 5.25058 2.6586 0.77848 0.63405 4.22812 12/20/2018 0 0 0 0 1 0 0 01/18/2018 6 6 0 28 1 0 28 2017-01-19 6 5 1 1 28 0 28 14 0 1 0 0.00 0 0 15731 MAUBERT AVENUE SAN LEANDRO, CA 94578 (37.704735, -122.118481) 02/01/2020
14619 14619 1575 BISHOP STREET SAN LUIS OBISPO, CA 93401 35.275112 -120.64492 0   555592 SAN LUIS TRANSITIONAL CARE 1575 BISHOP STREET SAN LUIS OBISPO CA 93401 8055457575 500 San Luis Obispo For profit - Corporation 23 20.4 Medicare false COMPASS HEALTH INC 03/31/1994 false   false false false None Yes 5   5   5     2 5   4   4       2.5924 1.53008 1.16645 2.69653 5.28894 0.57339 2.16014 1.04052 0.58827 3.78892 2.49423 1.10573 0.74632 4.47617 10/02/2019 1 1 0 4 1 0 4 10/03/2018 1 1 0 4 1 0 4 2017-10-06 6 5 1 1 28 0 28 8 0 2 0 0.00 0 0 1575 BISHOP STREET SAN LUIS OBISPO, CA 93401 (35.275112, -120.64492) 02/01/2020
14666 14666 1510 S VAN BUREN ST AMARILLO, TX 79101 35.198626 -101.842679 0   45F402 WARE MEMORIAL CARE CENTER 1510 S. VAN BUREN ST. AMARILLO TX 79101 8063730471 860 Potter Non profit - Corporation 100 83 Medicaid false Legal Business Name Not Available 05/22/1998 true   false false false Resident Yes 5   5   4   4     2 4   3       2.84945 1.59443 0.47222 2.06665 4.9161 0 2.11757 0.61019 0.2671 2.99486 2.79665 1.96483 0.66543 5.26377 02/26/2019 1 1 1 16 1 0 16 12/22/2017 2 2 0 16 1 0 16 2017-02-16 5 5 1 1 24 0 24 17.333 1 1 0 0.00 0 0 1510 S VAN BUREN ST AMARILLO, TX 79101 (35.198626, -101.842679) 02/01/2020
14737 14737 325 E BREWSTER ST HARVEY, ND 58341 47.767687 -99.933089 0   355037 ST ALOISIUS MEDICAL CENTER NURSING HOME 325 E BREWSTER ST HARVEY ND 58341 7013244651 510 Wells Non profit - Church related 80 73 Medicare and Medicaid true ST ALOISIUS HOSPITAL INC 05/01/1978 false   false false false Resident Yes 5   5   5   5   5   4   4       3.14168 0.56513 0.72736 1.29249 4.43417 0.00395 2.0305 0.60464 0.26168 2.89683 3.21569 0.70279 1.04619 4.90843 09/25/2019 1 1 0 4 1 0 4 08/23/2018 1 1 0 4 1 0 4 2017-08-30 5 5 0 1 32 0 32 8.667 0 0 0 0.00 0 0 325 E BREWSTER ST HARVEY, ND 58341 (47.767687, -99.933089) 02/01/2020
15121 15121 2428 BAHAMA DR DALLAS, TX 75211 32.754617 -96.85938 0   455996 THE RENAISSANCE AT KESSLER PARK 2428 BAHAMA DR DALLAS TX 75211 2149483811 390 Dallas For profit - Limited Liability company 135 95.2 Medicare and Medicaid false RENAISSANCE SNF LLC 03/01/1992 false   false false false Resident Yes 5   5   3   5   2   2   2       1.89258 1.00283 0.31734 1.32018 3.21275 0.04902 1.889 0.71738 0.34364 2.95002 2.08227 1.05114 0.34758 3.49225 11/06/2019 0 0 0 0 0 0 0 12/21/2018 3 3 2 28 1 0 28 2018-01-19 5 5 0 1 40 0 40 16 0 7 0 0.00 0 0 2428 BAHAMA DR DALLAS, TX 75211 (32.754617, -96.85938) 02/01/2020
15196 15196 4367 CONCORD BOULEVARD CONCORD, CA 94521 37.975149 -121.984225 0   555421 STONEBROOK HEALTHCARE CENTER 4367 CONCORD BOULEVARD CONCORD CA 94521 9256897457 60 Contra Costa For profit - Corporation 120 103 Medicare and Medicaid false THE STONEBROOK CONVALESCENT CENTER, INC. 05/24/1990 false   false false false Resident Yes 5   5   5   5   5   4   3       2.65634 1.60412 0.72156 2.32569 4.98202 0.11901 2.06427 0.74758 0.39865 3.2105 2.67444 1.61347 0.68127 4.97606 05/09/2019 6 6 0 28 1 0 28 04/26/2018 4 2 2 24 1 0 24 2017-03-30 5 5 0 1 20 0 20 25.333 1 0 0 0.00 0 0 4367 CONCORD BOULEVARD CONCORD, CA 94521 (37.975149, -121.984225) 02/01/2020

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [nh_gen_info_geocoded_final] (
   [address] TEXT,
   [lat] TEXT,
   [lng] TEXT,
   [geocode_flag] INTEGER,
   [geocode_accuracy] TEXT,
   [prvdr_nmbr] INTEGER,
   [prvdr_nm] TEXT,
   [prvdr_add] TEXT,
   [prvdr_city] TEXT,
   [prvdr_state] TEXT,
   [prvdr_zip] INTEGER,
   [prvdr_phn] INTEGER,
   [prvdr_cnty] INTEGER,
   [prvdr_cnty_name] TEXT,
   [ownership] TEXT,
   [nmbr_beds] INTEGER,
   [avg_residents] TEXT,
   [prvdr_type] TEXT,
   [Provider Resides in Hospital] TEXT,
   [Legal Business Name] TEXT,
   [Date First Approved to Provide Medicare and Medicaid services] TEXT,
   [Continuing Care Retirement Community] TEXT,
   [Special Focus Status] TEXT,
   [Abuse Icon] TEXT,
   [Most Recent Health Inspection More Than 2 Years Ago] TEXT,
   [Provider Changed Ownership in Last 12 Months] TEXT,
   [With a Resident and Family Council] TEXT,
   [Automatic Sprinkler Systems in All Required Areas] TEXT,
   [Overall Rating] INTEGER,
   [Overall Rating Footnote] TEXT,
   [Health Inspection Rating] INTEGER,
   [Health Inspection Rating Footnote] TEXT,
   [QM Rating] INTEGER,
   [QM Rating Footnote] TEXT,
   [Long-Stay QM Rating] TEXT,
   [Long-Stay QM Rating Footnote] TEXT,
   [Short-Stay QM Rating] TEXT,
   [Short-Stay QM Rating Footnote] TEXT,
   [Staffing Rating] TEXT,
   [Staffing Rating Footnote] TEXT,
   [RN Staffing Rating] TEXT,
   [RN Staffing Rating Footnote] TEXT,
   [Reported Staffing Footnote] TEXT,
   [Physical Therapist Staffing Footnote] TEXT,
   [Reported Nurse Aide Staffing Hours per Resident per Day] TEXT,
   [Reported LPN Staffing Hours per Resident per Day] TEXT,
   [Reported RN Staffing Hours per Resident per Day] TEXT,
   [Reported Licensed Staffing Hours per Resident per Day] TEXT,
   [Reported Total Nurse Staffing Hours per Resident per Day] TEXT,
   [Reported Physical Therapist Staffing Hours per Resident Per Day] TEXT,
   [Case-Mix Nurse Aide Staffing Hours per Resident per Day] TEXT,
   [Case-Mix LPN Staffing Hours per Resident per Day] TEXT,
   [Case-Mix RN Staffing Hours per Resident per Day] TEXT,
   [Case-Mix Total Nurse Staffing Hours per Resident per Day] TEXT,
   [Adjusted Nurse Aide Staffing Hours per Resident per Day] TEXT,
   [Adjusted LPN Staffing Hours per Resident per Day] TEXT,
   [Adjusted RN Staffing Hours per Resident per Day] TEXT,
   [Adjusted Total Nurse Staffing Hours per Resident per Day] TEXT,
   [Rating Cycle 1 Standard Survey Health Date] TEXT,
   [Rating Cycle 1 Total Number of Health Deficiencies] INTEGER,
   [Rating Cycle 1 Number of Standard Health Deficiencies] INTEGER,
   [Rating Cycle 1 Number of Complaint Health Deficiencies] INTEGER,
   [Rating Cycle 1 Health Deficiency Score] INTEGER,
   [Rating Cycle 1 Number of Health Revisits] INTEGER,
   [Rating Cycle 1 Health Revisit Score] INTEGER,
   [Rating Cycle 1 Total Health Score] INTEGER,
   [Rating Cycle 2 Standard Health Survey Date] TEXT,
   [Rating Cycle 2 Total Number of Health Deficiencies] INTEGER,
   [Rating Cycle 2 Number of Standard Health Deficiencies] INTEGER,
   [Rating Cycle 2 Number of Complaint Health Deficiencies] INTEGER,
   [Rating Cycle 2 Health Deficiency Score] INTEGER,
   [Rating Cycle 2 Number of Health Revisits] INTEGER,
   [Rating Cycle 2 Health Revisit Score] INTEGER,
   [Rating Cycle 2 Total Health Score] INTEGER,
   [Rating Cycle 3 Standard Health Survey Date] TEXT,
   [Rating Cycle 3 Total Number of Health Deficiencies] INTEGER,
   [Rating Cycle 3 Number of Standard Health Deficiencies] INTEGER,
   [Rating Cycle 3 Number of Complaint Health Deficiencies] INTEGER,
   [Rating Cycle 3 Number of Health Revisits] INTEGER,
   [Rating Cycle 3 Health Deficiency Score] INTEGER,
   [Rating Cycle 3 Health Revisit Score] INTEGER,
   [Rating Cycle 3 Total Health Score] INTEGER,
   [Total Weighted Health Survey Score] TEXT,
   [Number of Facility Reported Incidents] INTEGER,
   [Number of Substantiated Complaints] INTEGER,
   [Number of Fines] INTEGER,
   [Total Amount of Fines in Dollars] TEXT,
   [Number of Payment Denials] INTEGER,
   [Total Number of Penalties] INTEGER,
   [Location] TEXT,
   [Processing Date] TEXT
);