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

68 rows where Health Inspection Rating = 2 and ownership = "Non profit - Other"

View and edit SQL

Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_type, Provider Resides in Hospital, Continuing Care Retirement Community, Abuse Icon, 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, 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 Number of Health Revisits, Rating Cycle 2 Health Revisit Score, 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 Revisit Score, Number of Facility Reported Incidents, Number of Substantiated Complaints, Number of Fines, 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
309 545 COOK STREET ROYSTON, GA 30662 34.283793 -83.1175 0   115090 BROWN HEALTH AND REHABILITATION 545 COOK STREET ROYSTON GA 30662 7062451900 462 Franklin Non profit - Other 100 93 Medicare and Medicaid false 12/04/1968 false   false false false Resident Yes 2   2   4   3   5   3   4       2.08861 0.68433 0.67257 1.3569 3.44552 0.06583 2.12156 0.71303 0.3122 3.14679 2.04606 0.72168 0.81085 3.51107 08/09/2018 11 11 10 64 1 0 64 08/31/2017 0 0 0 0 0 0 0 2015-10-16 5 4 1 1 24 0 24 36 0 2 0 0.00 0 0 545 COOK STREET ROYSTON, GA 30662 (34.283793, -83.1175) 02/01/2020
658 1200 WHITLATCH WAY MILAN, IN 47031 39.134737 -85.133957 0   155730 RIPLEY CROSSING 1200 WHITLATCH WAY MILAN IN 47031 8126542231 680 Ripley Non profit - Other 100 88.7 Medicare and Medicaid false 05/05/2004 false   false false false Resident Yes 3   2   2   3   2   4   4       2.72 0.92946 0.81504 1.74449 4.4645 0.01844 2.24628 0.73081 0.34137 3.31845 2.51665 0.95634 0.89863 4.3141 12/06/2018 13 9 4 80 1 0 80 01/10/2018 6 4 2 32 1 0 32 2017-02-06 5 5 0 1 28 0 28 55.333 2 3 0 0.00 0 0 1200 WHITLATCH WAY MILAN, IN 47031 (39.134737, -85.133957) 02/01/2020
765 2701 MITCHELL STREET RUTHVEN, IA 51358 43.127299 -94.889129 0   165486 RUTHVEN COMMUNITY CARE CENTER 2701 MITCHELL STREET BOX 0 RUTHVEN IA 51358 7128375411 730 Palo Alto Non profit - Other 48 33.3 Medicare and Medicaid false 04/01/2003 false   false false false Resident Yes 3   2   4   5   4   4   4       1.94489 0.4398 0.83046 1.27026 3.21515 0.02542 1.90971 0.65843 0.30512 2.87326 2.11663 0.50227 1.02442 3.58823 01/16/2019 7 7 0 44 1 0 44 10/05/2017 3 3 2 12 1 0 12 2016-08-11 9 5 4 1 56 0 56 35.333 1 5 0 0.00 0 0 2701 MITCHELL STREET RUTHVEN, IA 51358 (43.127299, -94.889129) 02/01/2020
988 800 HOME STREET RUSHFORD, MN 55971 43.820061 -91.758953 0   245393 GOOD SHEPHERD LUTHERAN HOME 800 HOME STREET, BOX 747 RUSHFORD MN 55971 5078647714 220 Fillmore Non profit - Other 70 65.1 Medicare and Medicaid false 12/01/1986 false   false false false Both Yes 3   2   4   2   5   5   5       2.26694 0.52689 0.82199 1.34888 3.61583 0.00153 1.9272 0.62933 0.26896 2.8255 2.44472 0.62954 1.15029 4.10361 08/15/2019 6 6 0 48 1 0 48 09/27/2018 13 13 0 84 1 0 84 2017-07-20 1 1 0 1 8 0 8 53.333 0 0 0 0.00 0 0 800 HOME STREET RUSHFORD, MN 55971 (43.820061, -91.758953) 02/01/2020
1161 7850 WEST COLLEGE DRIVE PALOS HEIGHTS, IL 60463 41.674996 -87.812235 0   145607 MANORCARE OF PALOS HEIGHTS EAST 7850 WEST COLLEGE DRIVE PALOS HEIGHTS IL 60463 7083616990 141 Cook Non profit - Other 184 135 Medicare and Medicaid false 03/15/1989 false   false false false Resident Yes 3   2   4   3   4   4   5       1.98725 0.42922 1.43725 1.86646 3.85372 0.2307 2.13622 0.86383 0.44612 3.44616 1.93341 0.37362 1.21259 3.58589 11/07/2019 7 3 4 28 1 0 28 10/25/2018 14 7 7 116 1 0 116 2017-12-07 9 1 8 1 60 0 60 62.667 1 26 2 75740.00 0 2 7850 WEST COLLEGE DRIVE PALOS HEIGHTS, IL 60463 (41.674996, -87.812235) 02/01/2020
1188 600 WEST OGDEN AVENUE HINSDALE, IL 60521 41.811648 -87.941859 0   145246 MANORCARE OF HINSDALE 600 WEST OGDEN AVENUE HINSDALE IL 60521 6303259630 250 Du Page Non profit - Other 202 142.5 Medicare and Medicaid false 12/15/1972 false   false false false Resident Yes 3   2   3   2   3   4   5       2.18798 0.55821 1.41578 1.97399 4.16197 0.27116 2.1652 0.87971 0.45398 3.49889 2.10021 0.47714 1.17378 3.81436 09/25/2019 19 10 9 108 1 0 108 10/12/2018 11 7 4 60 1 0 60 2017-11-16 18 12 6 1 116 0 116 93.333 2 16 0 0.00 0 0 600 WEST OGDEN AVENUE HINSDALE, IL 60521 (41.811648, -87.941859) 02/01/2020
1356 38200 SCHOENHERR ROAD STERLING HEIGHTS, MI 48312 42.57578 -82.989357 0   235665 HEARTLAND HEALTH CARE CENTER - STERLING HEIGHTS 38200 SCHOENHERR ROAD STERLING HEIGHTS MI 48312 5862749044 490 Macomb Non profit - Other 120 157.1 Medicare and Medicaid false 07/12/2013 false   false false false None Yes 2   2   2   2   3   2   2       1.91812 1.47053 0.50285 1.97338 3.8915 0.38575 2.25281 0.89755 0.44954 3.5999 1.76957 1.23196 0.42101 3.46641 06/19/2019 21 13 10 156 1 0 156 04/19/2018 16 15 4 132 1 0 132 2017-06-14 10 8 2 1 68 0 68 133.333 5 29 3 46637.00 1 4 38200 SCHOENHERR ROAD STERLING HEIGHTS, MI 48312 (42.57578, -82.989357) 02/01/2020
1504 16200 JOG ROAD DELRAY BEACH, FL 33446 26.436214 -80.146473 0   106005 MANORCARE HEALTH SERVICES 16200 JOG ROAD DELRAY BEACH FL 33446 5616380000 490 Palm Beach Non profit - Other 120 107.9 Medicare and Medicaid false 02/19/1999 false   false false false Resident Yes 3   2   3   4   3   4   5       2.46989 0.13739 1.33957 1.47696 3.94685 0.13735 2.29446 0.79014 0.3853 3.46991 2.23723 0.13075 1.30857 3.64742 10/25/2019 4 4 0 16 1 0 16 08/09/2018 8 7 1 44 1 0 44 2017-06-29 12 12 0 1 80 0 80 36 0 1 0 0.00 0 0 16200 JOG ROAD DELRAY BEACH, FL 33446 (26.436214, -80.146473) 02/01/2020
1613 10 MARY SCANO DRIVE WORCESTER, MA 01605 42.274787 -71.777531 0   225385 CHRISTOPHER HOUSE OF WORCESTER 10 MARY SCANO DRIVE WORCESTER MA 1605 5087543800 170 Worcester Non profit - Other 156 139.3 Medicare and Medicaid false 07/01/1990 false   false false false Resident Yes 3   2   5   4   5   3   3       2.54459 1.17548 0.51918 1.69466 4.23925 0.1101 2.17644 0.66766 0.29117 3.13527 2.42989 1.32387 0.67112 4.33578 04/10/2019 3 3 0 28 1 0 28 01/11/2018 13 13 0 76 1 0 76 2016-11-22 5 4 1 1 28 0 28 44 0 1 1 8964.00 0 1 10 MARY SCANO DRIVE WORCESTER, MA 01605 (42.274787, -71.777531) 02/01/2020
1777 11812 NORTH 19TH AVE PHOENIX, AZ 85029 33.593708 -112.099637 0   35173 CHRISTIAN CARE NURSING CENTER 11812 NORTH 19TH AVE PHOENIX AZ 85029 6028613241 60 Maricopa Non profit - Other 68 44.6 Medicare and Medicaid false 06/13/1988 false   false false false Resident Yes 3   2   3   2   4   5   5       3.17807 1.0926 1.35002 2.44262 5.62069 0.04514 2.16843 0.69472 0.33747 3.20063 3.04602 1.1826 1.50567 5.63129 12/13/2018 9 9 1 52 1 0 52 09/08/2017 5 5 4 24 1 0 24 2016-09-08 0 0 0 0 0 0 0 34 2 1 0 0.00 0 0 11812 NORTH 19TH AVE PHOENIX, AZ 85029 (33.593708, -112.099637) 02/01/2020
1869 303 SEVENTH STREET SOUTH WHEATON, MN 56296 45.802288 -96.492697 0   245585 TRAVERSE CARE CENTER 303 SEVENTH STREET SOUTH WHEATON MN 56296 3205638124 770 Traverse Non profit - Other 49 43.1 Medicare and Medicaid false 10/01/1991 false   false false false Both Yes 3   2   3   2   4   4   4       2.24495 0.5407 0.63876 1.17945 3.42441 0.03426 1.97416 0.68699 0.32053 2.98169 2.36341 0.59182 0.75005 3.68278 04/18/2019 5 5 0 56 1 0 56 06/15/2018 5 5 0 28 1 0 28 2017-04-06 11 11 0 1 48 0 48 45.333 0 0 0 0.00 0 0 303 SEVENTH STREET SOUTH WHEATON, MN 56296 (45.802288, -96.492697) 02/01/2020
2188 210 WEST WALNUT STREET CANTON, IL 61520 40.553293 -90.038115 0   145572 GRAHAM HOSPITAL 210 WEST WALNUT STREET CANTON IL 61520 3096475240 370 Fulton Non profit - Other 47 26 Medicare and Medicaid false 07/02/1987 false   false false false Both Yes 3   2   4   3   5   5   5       3.10444 0.38818 2.74301 3.13119 6.23563 0.09344 2.11651 0.74612 0.35829 3.22092 3.04844 0.39121 2.88153 6.20802 05/30/2019 2 2 0 16 1 0 16 06/06/2018 0 0 0 0 0 0 0 2017-07-06 12 7 5 1 411 0 411 76.5 1 0 1 107502.00 0 1 210 WEST WALNUT STREET CANTON, IL 61520 (40.553293, -90.038115) 02/01/2020
2330 940 MAPLE AVENUE HOMEWOOD, IL 60430 41.567497 -87.640876 0   145684 MANORCARE OF HOMEWOOD 940 MAPLE AVENUE HOMEWOOD IL 60430 7087990244 141 Cook Non profit - Other 132 101.8 Medicare and Medicaid false 07/24/1990 false   false false false Resident Yes 2   2   3   3   3   3   4       1.69428 0.84207 1.04466 1.88673 3.58101 0.13694 2.18377 0.85842 0.41327 3.45546 1.61248 0.73762 0.95142 3.32317 03/06/2019 19 8 11 116 1 0 116 03/23/2018 15 13 2 64 1 0 64 2017-05-12 10 4 6 1 60 0 60 89.333 0 20 0 0.00 0 0 940 MAPLE AVENUE HOMEWOOD, IL 60430 (41.567497, -87.640876) 02/01/2020
2671 1201 FIFTH AVE CALVERT CITY, KY 42029 37.021792 -88.33534 0   185234 CALVERT CITY CONVALESCENT CENTER 1201 FIFTH AVE CALVERT CITY KY 42029 2703954124 780 Marshall Non profit - Other 95 78.5 Medicare and Medicaid false 01/03/1991 false   false false false Resident Yes 2   2   3   3   3   2   2       2.63353 0.83272 0.34837 1.18109 3.81462 0.05714 2.28296 0.77953 0.33703 3.39953 2.39748 0.80325 0.38905 3.5982 11/14/2019 4 4 0 16 1 0 16 08/23/2018 10 3 7 203 1 0 203 2017-06-08 4 2 3 1 16 0 16 78.333 1 2 1 42066.00 1 2 1201 FIFTH AVE CALVERT CITY, KY 42029 (37.021792, -88.33534) 02/01/2020
2683 6700 E 45TH STREET NORTH BEL AIRE, KS 67226 37.766825 -97.258846 0   175410 CATHOLIC CARE CENTER, INC 6700 E 45TH STREET NORTH BEL AIRE KS 67226 3167442020 860 Sedgwick Non profit - Other 176 149.8 Medicare and Medicaid false 03/04/1997 true   false false false Resident Yes 4   2   5   5   5   4   4       2.79086 1.04789 0.66372 1.71161 4.50247 0.09116 2.01554 0.71243 0.3287 3.05666 2.87782 1.106 0.76002 4.72342 09/09/2019 14 13 1 84 1 0 84 07/05/2018 11 8 4 48 1 0 48 2016-09-01 17 10 7 1 186 0 186 89 4 5 2 30228.00 1 3 6700 E 45TH STREET NORTH BEL AIRE, KS 67226 (37.766825, -97.258846) 02/01/2020
2804 510 WEST COLLEGE STREET DULUTH, MN 55811 46.814989 -92.090658 0   inf AFTENRO HOME 510 WEST COLLEGE STREET DULUTH MN 55811 2187286600 680 St. Louis Non profit - Other 54 51.4 Medicaid false 11/12/1981 false   false false false Both Yes 3   2   5   5     2 3   3       1.58102 0.33457 0.48863 0.8232 2.40422 0.00837 1.43275 0.59576 0.27928 2.30779 2.29342 0.42228 0.65853 3.34066 10/04/2018 11 8 3 60 1 0 60 02/08/2018 8 8 0 68 1 0 68 2017-04-27 9 9 3 1 72 0 72 64.667 0 3 0 0.00 0 0 510 WEST COLLEGE STREET DULUTH, MN 55811 (46.814989, -92.090658) 02/01/2020
2829 6955 IL-162, Maryville, IL 62062, USA 38.7408112 -89.9393262 1 ROOFTOP 145728 MANOR COURT OF MARYVILLE 6955 STATE ROUTE 162 MARYVILLE IL 62062 6182885999 680 Madison Non profit - Other 132 118.5 Medicare and Medicaid false 03/19/1992 false   false false false Resident Yes 2   2   4   3   4   2   2       2.65957 0.96119 0.35895 1.32014 3.97971 0.07925 2.0849 0.78025 0.36921 3.23437 2.6512 0.92631 0.36592 3.94562 08/29/2019 19 6 13 144 1 0 144 07/30/2018 6 6 0 40 1 0 40 2017-09-15 7 5 2 1 28 0 28 90 0 13 0 0.00 0 0   02/01/2020
2859 10466 POLLACK AVE NEWBURGH, IN 47630 37.947822 -87.440891 0   155354 NEWBURGH HEALTH CARE 10466 POLLACK AVE NEWBURGH IN 47630 8128532931 860 Warrick Non profit - Other 114 90.4 Medicare and Medicaid false 03/10/1990 false   false false false Resident Yes 3   2   4   4   4   4   4       2.55573 1.04983 0.79494 1.84477 4.4005 0.05311 2.26811 0.73741 0.31573 3.32125 2.34189 1.07052 0.94766 4.24867 04/17/2019 13 9 5 76 1 0 76 02/13/2018 9 3 6 68 1 0 68 2017-02-07 8 4 4 1 60 0 60 70.667 0 11 1 5102.00 0 1 10466 POLLACK AVE NEWBURGH, IN 47630 (37.947822, -87.440891) 02/01/2020
3027 621 CARONDELET DRIVE KANSAS CITY, MO 64114 38.934828 -94.601737 0   265303 CARONDELET MANOR 621 CARONDELET DRIVE KANSAS CITY MO 64114 8169411300 470 Jackson Non profit - Other 162 104.6 Medicare and Medicaid false 01/10/1986 false   false false false Resident Yes 3   2   4   5   3   4   4       2.53594 0.62817 0.5781 1.20626 3.74221 0.03691 1.95163 0.67408 0.29432 2.92003 2.70059 0.70073 0.73929 4.10955 08/23/2019 5 5 0 44 1 0 44 09/07/2018 13 12 1 76 1 0 76 2017-08-09 4 4 0 1 28 0 28 52 0 1 0 0.00 0 0 621 CARONDELET DRIVE KANSAS CITY, MO 64114 (38.934828, -94.601737) 02/01/2020
3507 150 NEW PROVIDENCE ROAD MOUNTAINSIDE, NJ 07092 40.668692 -74.353977 0   315239 CHILDRENS SPECIALIZED HOSPITAL MOUNTAINSIDE 150 NEW PROVIDENCE ROAD MOUNTAINSIDE NJ 7092 9082333720 370 Union Non profit - Other 46 44.7 Medicare and Medicaid true 10/06/1986 false   false false false Family Yes 4   2   5   5     2 4   4       2.7327 1.33287 2.41396 3.74683 6.47953 0.06525 2.41554 0.99556 1.19563 4.60673 2.35122 1.00671 0.75991 4.51028 10/22/2019 3 2 1 16 0 0 16 10/26/2018 6 5 1 40 1 0 40 2017-08-02 2 2 0 1 8 0 8 22.667 0 4 0 0.00 0 0 150 NEW PROVIDENCE ROAD MOUNTAINSIDE, NJ 07092 (40.668692, -74.353977) 02/01/2020
3536 306 ASH STREET WAKEFIELD, NE 68784 42.269158 -96.872372 0   285209 WAKEFIELD HEALTH CARE CENTER 306 ASH STREET WAKEFIELD NE 68784 4022872244 250 Dixon Non profit - Other 49 22.8 Medicare and Medicaid false 06/01/1997 false   false false false Resident Yes 3   2   2   2     2 4   4       2.98201 0.89644 0.67224 1.56868 4.55069 0.00645 2.31252 0.67493 0.3352 3.32264 2.68004 0.99873 0.75484 4.39185 07/02/2019 3 3 0 20 1 0 20 05/01/2018 12 6 6 189 1 0 189 2017-02-14 3 3 1 1 28 0 28 77.667 4 3 1 6633.00 1 2 306 ASH STREET WAKEFIELD, NE 68784 (42.269158, -96.872372) 02/01/2020
3674 325 S SEGRAVE STREET DAYTONA BEACH, FL 32114 29.205359 -81.021509 0   105651 GOOD SAMARITAN SOCIETY-DAYTONA 325 S SEGRAVE STREET DAYTONA BEACH FL 32114 3862536791 630 Volusia Non profit - Other 100 88.3 Medicare and Medicaid false 06/02/1989 false   false false false Resident Yes 3   2   4   5   3   4   3       2.795 1.01433 0.41059 1.42492 4.21993 0.06588 1.95264 0.65352 0.28675 2.89291 2.97492 1.1671 0.53894 4.6776 01/31/2019 8 8 0 56 1 0 56 03/01/2018 8 8 0 40 1 0 40 2017-01-26 8 5 3 1 32 0 32 46.667 0 0 0 0.00 0 0 325 S SEGRAVE STREET DAYTONA BEACH, FL 32114 (29.205359, -81.021509) 02/01/2020
3846 2325 S MILLER ST SHELBYVILLE, IN 46176 39.501488 -85.787506 0   15A011 ESPECIALLY KIDZ HEALTH & REHAB 2325 S MILLER ST SHELBYVILLE IN 46176 3173923287 720 Shelby Non profit - Other 130 124.7 Medicaid false 03/31/1974 false   false false false None Yes 2   2   5   5     2 1   1       2.27017 1.32248 0.16256 1.48505 3.75521 0.00248 2.42109 0.99108 0.7647 4.17687 1.94878 1.00338 0.08001 2.88294 08/27/2019 8 8 1 36 1 0 36 07/25/2018 8 6 2 36 1 0 36 2017-06-06 23 14 13 1 116 0 116 49.333 0 22 0 0.00 0 0 2325 S MILLER ST SHELBYVILLE, IN 46176 (39.501488, -85.787506) 02/01/2020
4189 0770 NORTH 075 EAST LAGRANGE, IN 46761 41.653016 -85.411868 0   155343 LIFE CARE CENTER OF LAGRANGE 0770 NORTH 075 EAST LAGRANGE IN 46761 2604637445 430 Lagrange Non profit - Other 100 55.5 Medicare and Medicaid false 11/13/1989 false   false false false Resident Yes 3   2   5   5   4   2   2       1.75763 0.60794 0.47178 1.07972 2.83735 0.03206 2.09931 0.79802 0.3997 3.29703 1.74007 0.57283 0.44426 2.75958 06/04/2019 10 8 2 76 1 0 76 05/03/2018 6 5 1 28 1 0 28 2017-05-04 11 1 10 1 88 0 88 62 4 13 2 19825.00 0 2 0770 NORTH 075 EAST LAGRANGE, IN 46761 (41.653016, -85.411868) 02/01/2020
4261 400 LINDEN PONDS WAY HINGHAM, MA 02043 42.196617 -70.917696 0   225773 LINDEN PONDS 400 LINDEN PONDS WAY HINGHAM MA 2043 7815347030 150 Plymouth Non profit - Other 66 63.7 Medicare and Medicaid false 03/12/2009 true   false false false Both Yes 3   2   4   3   5   5   5       2.73433 0.99253 1.04038 2.03291 4.76724 0.11259 2.3676 0.69568 0.34427 3.40755 2.40026 1.0728 1.13744 4.4862 08/13/2019 10 10 0 56 1 0 56 05/29/2018 10 10 0 64 1 0 64 2017-02-02 3 3 0 1 12 0 12 51.333 0 0 0 0.00 0 0 400 LINDEN PONDS WAY HINGHAM, MA 02043 (42.196617, -70.917696) 02/01/2020
4624 7 Elliott St, Council Bluffs, IA 51503, USA 41.278599 -95.836591 1 ROOFTOP 165524 BETHANY LUTHERAN HOME SEVEN ELLIOTT STREET COUNCIL BLUFFS IA 51503 7123289500 770 Pottawattamie Non profit - Other 121 108 Medicare and Medicaid false 11/01/2003 false   false false false Resident Yes 2   2   3   2   4   3   3       2.39094 0.75416 0.4218 1.17596 3.5669 0.05616 2.12734 0.64996 0.3019 3.0792 2.33587 0.87249 0.52587 3.71456 12/13/2018 7 7 0 24 1 0 24 08/24/2017 2 2 1 20 1 0 20 2016-08-04 5 3 2 1 56 0 56 28 1 1 2 15925.00 0 2   02/01/2020
4995 1225 GREENCROFT DR GOSHEN, IN 46527 41.561063 -85.817798 0   155205 GREENCROFT HEALTHCARE 1225 GREENCROFT DR GOSHEN IN 46527 5745374000 190 Elkhart Non profit - Other 233 173.2 Medicare and Medicaid false 06/18/1982 true   false false false Resident Yes 4   2   5   4   5   4   4       2.43202 0.49795 0.74421 1.24216 3.67418 0.03698 1.88462 0.66469 0.30291 2.85222 2.682 0.56332 0.92471 4.13076 02/19/2019 9 7 4 72 1 0 72 02/05/2018 10 7 3 56 1 0 56 2017-04-11 5 0 5 0 20 0 20 58 0 10 1 37180.00 0 1 1225 GREENCROFT DR GOSHEN, IN 46527 (41.561063, -85.817798) 02/01/2020
5100 804 WOLLARD BLVD RICHMOND, MO 64085 39.266087 -93.957234 0   265708 SHIRKEY NURSING AND REHABILITATION CENTER 804 WOLLARD BLVD RICHMOND MO 64085 8167765403 880 Ray Non profit - Other 197 136.3 Medicare and Medicaid false 10/01/2000 false   false false false Resident Yes 2   2   2   2   2   2   1       2.76887 0.85328 0.15693 1.01021 3.77907 0 1.86445 0.62987 0.28262 2.77694 3.0865 1.01865 0.20899 4.36386 03/06/2019 11 11 0 72 2 36 108 03/22/2018 9 9 0 56 1 0 56 2017-03-30 8 7 1 1 36 0 36 78.667 0 1 0 0.00 0 0 804 WOLLARD BLVD RICHMOND, MO 64085 (39.266087, -93.957234) 02/01/2020
5280 6630 KENTUCKY AVE NEW PORT RICHEY, FL 34653 28.257019 -82.7047 0   105343 HEATHER HILL HEALTHCARE CENTER 6630 KENTUCKY AVE NEW PORT RICHEY FL 34653 7278496939 500 Pasco Non profit - Other 105 88.3 Medicare and Medicaid false 05/01/1979 false   false false false Resident Yes 2   2   2   2   1   3   3       2.63945 0.93109 0.51108 1.44217 4.08162 0.06946 2.07672 0.69557 0.31656 3.08885 2.64151 1.00655 0.60767 4.2373 08/28/2019 3 3 0 16 0 0 16 05/10/2018 11 11 0 60 2 30 90 2017-06-15 9 6 3 1 56 0 56 47.333 0 7 1 14076.00 0 1 6630 KENTUCKY AVE NEW PORT RICHEY, FL 34653 (28.257019, -82.7047) 02/01/2020
5634 415 S MARKET STREET HAVRE DE GRACE, MD 21078 39.544142 -76.08792 0   215039 CITIZENS CARE CENTER 415 S. MARKET STREET HAVRE DE GRACE MD 21078 4109395500 120 Harford Non profit - Other 184 138 Medicare and Medicaid false 01/03/1967 false   false false false Resident Yes 2   2   3   4   2   3   3       2.18865 1.19767 0.5608 1.75847 3.94712 0.03495 2.18183 0.74749 0.35404 3.28336 2.08483 1.2048 0.5962 3.85492 05/02/2019 15 12 3 72 1 0 72 03/07/2018 15 15 0 84 1 0 84 2017-03-02 4 4 4 1 87 0 87 78.5 1 2 1 11053.00 0 1 415 S MARKET STREET HAVRE DE GRACE, MD 21078 (39.544142, -76.08792) 02/01/2020
6046 56-117 Pualalea St, Kahuku, HI 96731, USA 21.6763946 -157.9541328 1 ROOFTOP 125030 KAHUKU MEDICAL CENTER 56-117 PUALALEA STREET KAHUKU HI 96731 8082939221 20 Honolulu Non profit - Other 6 5.9 Medicare and Medicaid true 01/01/1977 false   false false false Resident Yes 1   2     2   2   2 1 12 1 12 6 6                             06/04/2019 6 6 0 28 1 0 28 07/06/2018 5 5 0 60 1 0 60 2017-07-14 10 10 0 2 119 60 179 63.833 0 0 1 19500.00 1 2   02/01/2020
6061 1861 NW 8TH AVENUE MIAMI, FL 33136 25.793475 -80.208971 0   106034 JACKSON PLAZA NURSING AND REHABILITATION CENTER 1861 NW 8TH AVENUE MIAMI FL 33136 3053473380 120 Miami-Dade Non profit - Other 120 116.5 Medicare and Medicaid false 01/26/2001 false   false false false Resident Yes 2   2   1   2   1   5   5       2.61242 0.67698 1.17697 1.85395 4.46636 0.06842 2.18141 0.68717 0.29709 3.16566 2.48898 0.74078 1.49112 4.5242 12/12/2019 6 0 6 24 0 0 24 08/23/2018 11 9 2 44 1 0 44 2017-08-10 13 13 0 1 52 0 52 35.333 1 3 1 9009.00 0 1 1861 NW 8TH AVENUE MIAMI, FL 33136 (25.793475, -80.208971) 02/01/2020
6133 11744 GA-22, Sparta, GA 31087, USA 33.3521154 -82.928769 1 RANGE_INTERPOLATED 115382 SPARTA HEALTH AND REHABILITATION 11744 HIGHWAY 22 E SPARTA GA 31087 7064446057 560 Hancock Non profit - Other 81 68.4 Medicare and Medicaid false 09/01/1989 false   false false false Resident Yes 1   2   4   4     2 1   1       1.95239 0.77381 0.21766 0.99146 2.94385 0.02026 1.89957 0.65702 0.3025 2.8591 2.13613 0.88559 0.27081 3.30172 08/23/2018 5 5 0 32 1 0 32 08/17/2017 3 3 0 24 1 0 24 2015-10-02 0 0 0 0 0 0 0 24 0 0 1 12688.00 0 1   02/01/2020
6171 163 EAST TOLLISON STREET BAXLEY, GA 31513 31.768768 -82.349351 0   115262 APPLING NURSING AND REHABILITATION PAVILION 163 EAST TOLLISON STREET BAXLEY GA 31513 9123679841 0 Appling Non profit - Other 101 100 Medicare and Medicaid true 01/01/1979 false   false false false Resident Yes 3   2   2   3   2   4   3       2.16574 1.29417 0.40128 1.69545 3.86119 0.00829 1.72265 0.6364 0.28741 2.64647 2.61291 1.52912 0.52551 4.67852 10/24/2019 7 7 0 36 1 0 36 07/12/2018 8 8 0 32 1 0 32 2017-06-22 2 2 0 1 16 0 16 31.333 0 0 0 0.00 0 0 163 EAST TOLLISON STREET BAXLEY, GA 31513 (31.768768, -82.349351) 02/01/2020
6389 4201 W NEW NOLTE ROAD SAINT CLOUD, FL 34772 28.228482 -81.315216 0   105734 SOLARIS HEALTHCARE OSCEOLA 4201 W NEW NOLTE ROAD SAINT CLOUD FL 34772 4079573341 480 Osceola Non profit - Other 120 114.8 Medicare and Medicaid false 06/26/1991 false   false false false Resident Yes 2   2   2   2   1   3   2       2.70532 1.08845 0.3455 1.43395 4.13927 0.08992 2.06822 0.72995 0.33382 3.13199 2.71855 1.12125 0.38955 4.23796 08/22/2019 1 1 0 4 1 0 4 01/31/2019 3 3 0 12 1 0 12 2018-06-28 9 5 4 1 249 0 249 47.5 2 0 1 269511.00 1 2 4201 W NEW NOLTE ROAD SAINT CLOUD, FL 34772 (28.228482, -81.315216) 02/01/2020
6477 200 WEST CONAN STREET ELY, MN 55731 47.90099 -91.871496 0   245138 BOUNDARY WATERS CARE CENTER 200 WEST CONAN STREET ELY MN 55731 2183658705 680 St. Louis Non profit - Other 42 35.4 Medicare and Medicaid false 07/24/1967 false   false false false Resident Yes 3   2   2   2   3   4   4       2.41875 0.43999 0.69903 1.13902 3.55778 0.0227 2.01492 0.69296 0.31888 3.02677 2.49488 0.47744 0.82508 3.76923 03/01/2019 12 11 1 64 1 0 64 12/14/2017 6 6 0 32 1 0 32 2017-01-26 7 7 0 1 36 0 36 48.667 0 0 0 0.00 0 0 200 WEST CONAN STREET ELY, MN 55731 (47.90099, -91.871496) 02/01/2020
6550 510 W MEDCALF ROAD DALE, IN 47523 38.169977 -86.997042 0   155270 CORE OF DALE 510 W MEDCALF ROAD DALE IN 47523 8129377073 730 Spencer Non profit - Other 60 42.6 Medicare and Medicaid false 10/15/1985 false   false false false Resident Yes 1   2   4   4     2 1 12 1 12     1.58515 0.7403 0.36495 1.10526 2.69041 0.00498 1.82684 0.65927 0.30331 2.78941 1.80337 0.84436 0.45288 3.09284 04/11/2019 11 10 1 40 2 20 60 03/07/2018 20 11 9 100 1 0 100 2017-01-11 12 4 8 1 80 0 80 76.667 0 15 1 8125.00 0 1 510 W MEDCALF ROAD DALE, IN 47523 (38.169977, -86.997042) 02/01/2020
6676 307 JONES MILL ROAD STATESBORO, GA 30458 32.443897 -81.759523 0   115597 HERITAGE INN HEALTH AND REHABILITATION 307 JONES MILL ROAD STATESBORO GA 30458 9127649011 140 Bulloch Non profit - Other 92 75.2 Medicare and Medicaid false 02/01/1996 false   false false false Resident Yes 2   2   2   2   2   2   2       1.5404 0.93716 0.33355 1.27072 2.81112 0.06182 2.0005 0.74854 0.36272 3.11176 1.60033 0.94142 0.34612 2.89685 02/14/2019 10 8 2 52 1 0 52 02/22/2018 0 0 0 0 0 0 0 2017-04-20 4 4 3 1 32 0 32 31.333 0 3 0 0.00 0 0 307 JONES MILL ROAD STATESBORO, GA 30458 (32.443897, -81.759523) 02/01/2020
6793 2221 NORTH ROSEMONT BOULEVARD TUCSON, AZ 85712 32.248704 -110.884074 0   35016 HANDMAKER HOME FOR THE AGING 2221 NORTH ROSEMONT BOULEVARD TUCSON AZ 85712 5208812323 90 Pima Non profit - Other 94 73.3 Medicare and Medicaid false 01/01/1967 false   false false false Resident Yes 2   2   4   5   4   3   3       2.44484 0.98535 0.63221 1.61756 4.0624 0.08788 2.08617 0.72456 0.34497 3.1557 2.43567 1.02259 0.68978 4.12801 01/08/2019 6 6 1 32 1 0 32 10/19/2017 7 5 3 52 1 0 52 2016-10-06 8 8 0 1 40 0 40 40 1 2 1 6500.00 0 1 2221 NORTH ROSEMONT BOULEVARD TUCSON, AZ 85712 (32.248704, -110.884074) 02/01/2020
6947 Christian Hill Rd, Great Barrington, MA 01230, USA 42.2136064 -73.3675653 1 GEOMETRIC_CENTER 225250 FAIRVIEW COMMONS NURSING & REHABILITATION CENTER CHRISTIAN HILL ROAD GREAT BARRINGTON MA 1230 4135284560 10 Berkshire Non profit - Other 180 117.8 Medicare and Medicaid false 06/22/1976 false   false false false Resident Yes 2   2   4   3   4   3   3       1.92457 1.13051 0.49165 1.62216 3.54673 0.04376 1.8959 0.67379 0.31127 2.88096 2.10977 1.26163 0.5945 3.9477 01/29/2019 17 16 1 84 2 42 126 10/17/2017 9 7 2 40 1 0 40 2016-09-07 5 5 0 1 24 0 24 80.333 1 0 1 48068.00 0 1   02/01/2020
7624 317 FIRST STREET NORTHWEST ULEN, MN 56585 47.083166 -96.258595 0   245559 VIKING MANOR NURSING HOME 317 FIRST STREET NORTHWEST ULEN MN 56585 2185968847 130 Clay Non profit - Other 45 43.5 Medicare and Medicaid false 06/01/1991 false   false false false Both Yes 2   2   4   4     2 3   3       2.4675 0.52325 0.48106 1.00431 3.47181 0.05131 1.91811 0.61058 0.26873 2.79742 2.67362 0.64439 0.67377 3.97971 06/27/2019 5 4 2 20 1 0 20 04/12/2018 5 1 4 133 1 0 133 2017-03-22 4 4 0 1 16 0 16 57 2 1 1 22556.00 0 1 317 FIRST STREET NORTHWEST ULEN, MN 56585 (47.083166, -96.258595) 02/01/2020
7738 4800 48TH STREET VALLEY, AL 36854 32.82397 -85.1702 0   15045 EAMC LANIER NURSING HOME 4800 48TH STREET VALLEY AL 36854 3347561401 80 Chambers Non profit - Other 103 93.7 Medicare and Medicaid false 05/01/1977 false   false false false Both Yes 2   2   5   5   5   1 12 1 12     2.27742 1.15619 0.26328 1.41947 3.69689 0 1.8822 0.62114 0.25028 2.75362 2.51475 1.39965 0.39593 4.30512 03/21/2019 5 5 0 20 1 0 20 03/22/2018 3 3 0 24 1 0 24 2017-02-02 4 4 1 1 44 0 44 25.333 0 1 0 0.00 0 0 4800 48TH STREET VALLEY, AL 36854 (32.82397, -85.1702) 02/01/2020
7801 325 ALLEN MEMORIAL DRIVE SW MILLEDGEVILLE, GA 31061 33.0553 -83.2435 0   115477 CHAPLINWOOD NURSING HOME 325 ALLEN MEMORIAL DRIVE SW MILLEDGEVILLE GA 31061 4784538514 30 Baldwin Non profit - Other 100 88.6 Medicare and Medicaid false 11/27/1989 false   false false false Resident Yes 1   2   2   2   2   1   1       2.17492 0.96232 0.25268 1.215 3.38992 0.0153 2.04013 0.67949 0.32524 3.04487 2.21564 1.06492 0.29241 3.57004 06/25/2019 5 5 0 56 1 0 56 04/19/2018 2 2 0 8 1 0 8 2017-04-28 2 2 2 1 8 0 8 32 0 0 1 8099.00 0 1 325 ALLEN MEMORIAL DRIVE SW MILLEDGEVILLE, GA 31061 (33.0553, -83.2435) 02/01/2020
7815 7465 MADISON AVE INDIANAPOLIS, IN 46227 39.658015 -86.124646 0   155780 MADISON HEALTH CARE CENTER 7465 MADISON AVE INDIANAPOLIS IN 46227 3177883000 480 Marion Non profit - Other 130 54.6 Medicare and Medicaid false 07/13/2010 false   false false false Resident Yes 1   2   1   1   1   2   2       2.30746 0.97563 0.4095 1.38513 3.69259 0.09856 2.15804 0.80989 0.39027 3.3582 2.22223 0.90582 0.39493 3.52596 02/20/2019 6 4 2 40 1 0 40 03/07/2018 10 10 0 60 1 0 60 2017-03-01 8 8 0 1 60 0 60 50 0 5 2 21279.00 0 2 7465 MADISON AVE INDIANAPOLIS, IN 46227 (39.658015, -86.124646) 02/01/2020
7825 801 S 3RD ST E MALTA, MT 59538 48.357436 -107.860356 0   275131 HI-LINE RETIREMENT CENTER 801 S 3RD ST E MALTA MT 59538 4066541190 350 Phillips Non profit - Other 56 48.9 Medicare and Medicaid false 07/01/1989 true   false false false Resident Yes 2   2   5   5     2 1 12 1 12     2.83706 0.45065 0.26868 0.71932 3.55639 0.00599 1.8312 0.61406 0.25932 2.70457 3.21995 0.55183 0.38997 4.21661 08/22/2019 12 12 1 80 1 0 80 07/12/2018 12 12 12 96 2 48 144 2017-03-23 12 12 0 1 96 0 96 104 0 5 0 0.00 1 1 801 S 3RD ST E MALTA, MT 59538 (48.357436, -107.860356) 02/01/2020
7826 925 W SOUTH BLVD TROY, MI 48085 42.622548 -83.149087 0   235626 HEARTLAND HEALTH CARE CENTER-OAKLAND 925 W SOUTH BLVD TROY MI 48085 2487294400 620 Oakland Non profit - Other 160 107.7 Medicare and Medicaid false 02/16/2007 false   true false false Resident Yes 3   2   4   4   4   4   4       2.05076 1.52209 1.02311 2.5452 4.59596 0.45052 2.24348 0.93294 0.49059 3.66701 1.8998 1.22678 0.78495 4.01899 08/14/2019 26 14 13 200 1 0 200 07/18/2018 15 9 8 76 1 0 76 2017-05-23 7 7 0 1 44 0 44 132.667 20 27 0 0.00 1 1 925 W SOUTH BLVD TROY, MI 48085 (42.622548, -83.149087) 02/01/2020
8038 700 FOULK ROAD WILMINGTON, DE 19803 39.788146 -75.534211 0   85028 MANORCARE HEALTH SERVICES - WILMINGTON 700 FOULK ROAD WILMINGTON DE 19803 3027640181 10 New Castle Non profit - Other 138 119.8 Medicare and Medicaid false 07/23/1984 false   false false false Resident Yes 4   2   5   4   5   4   4       1.90303 1.03001 0.77202 1.80203 3.70506 0.10631 2.10299 0.74344 0.34602 3.19245 1.88071 1.04179 0.83976 3.72155 11/25/2019 9 5 4 56 1 0 56 10/02/2018 24 18 6 241 1 0 241 2017-08-17 14 14 0 1 60 0 60 118.333 6 13 1 41662.00 0 1 700 FOULK ROAD WILMINGTON, DE 19803 (39.788146, -75.534211) 02/01/2020
8317 420 SOUTH KENYON ROAD FORT DODGE, IA 50501 42.485403 -94.205531 0   165291 FRIENDSHIP HAVEN, INC 420 SOUTH KENYON ROAD FORT DODGE IA 50501 5155732121 930 Webster Non profit - Other 155 115 Medicare and Medicaid false 09/01/1996 true   false false false Resident Yes 4   2   5   5   5   5   5       3.04043 0.67192 1.27777 1.94969 4.99012 0.01669 2.0166 0.64184 0.26976 2.9282 3.1335 0.78718 1.78283 5.46466 07/11/2019 11 10 1 52 1 0 52 03/29/2018 2 2 0 12 1 0 12 2017-02-02 1 1 0 1 4 0 4 30.667 0 0 0 0.00 0 0 420 SOUTH KENYON ROAD FORT DODGE, IA 50501 (42.485403, -94.205531) 02/01/2020
9071 3232 N County Rd 25A, Troy, OH 45373, USA 40.0890805 -84.2278132 1 ROOFTOP 365735 KOESTER PAVILION 3232 NORTH COUNTY ROAD 25A TROY OH 45373 9374407663 560 Miami Non profit - Other 135 118.3 Medicare and Medicaid false 05/08/1989 false   false false false Resident Yes 2   2   3   4   2   2   2       1.91856 0.91091 0.4836 1.39451 3.31306 0.03909 2.13888 0.83746 0.42683 3.40316 1.86425 0.81789 0.42644 3.12176 08/22/2019 9 8 1 52 1 0 52 07/19/2018 9 8 2 64 1 0 64 2017-05-18 5 4 1 1 44 0 44 54.667 0 2 1 23240.00 0 1   02/01/2020
9092 11680 WARNER AVENUE FOUNTAIN VALLEY, CA 92708 33.716278 -117.925243 0   555328 MANORCARE HEALTH SERVICES (FOUNTAIN VALLEY) 11680 WARNER AVENUE FOUNTAIN VALLEY CA 92708 7142419800 400 Orange Non profit - Other 151 133.8 Medicare and Medicaid false 01/30/1989 false   false false false Resident Yes 3   2   4   4   4   4   4       2.27697 1.19957 0.86642 2.06599 4.34296 0.32522 2.17576 0.80714 0.40375 3.38665 2.17502 1.11753 0.8077 4.11215 08/14/2019 22 17 5 100 1 0 100 09/25/2018 22 17 6 88 1 0 88 2017-09-07 27 17 10 1 116 0 116 98.667 1 13 0 0.00 0 0 11680 WARNER AVENUE FOUNTAIN VALLEY, CA 92708 (33.716278, -117.925243) 02/01/2020
9626 10540 FREMONT PIKE RD PERRYSBURG, OH 43551 41.54782 -83.597286 0   365535 HEARTLAND OF PERRYSBURG 10540 FREMONT PIKE RD PERRYSBURG OH 43551 4198743578 880 Wood Non profit - Other 122 110.2 Medicare and Medicaid false 09/01/1980 false   false false false Resident Yes 2   2   4   4   4   3   3       1.61856 1.03257 0.60505 1.63762 3.25617 0.08552 2.05284 0.75055 0.36458 3.16798 1.63866 1.03448 0.62463 3.29593 12/06/2018 6 6 0 40 1 0 40 10/05/2017 14 6 8 72 1 0 72 2016-07-21 5 2 3 1 20 0 20 47.333 0 9 1 16848.00 0 1 10540 FREMONT PIKE RD PERRYSBURG, OH 43551 (41.54782, -83.597286) 02/01/2020
9646 700 EAST BRIGHTON AVENUE SYRACUSE, NY 13205 43.00929 -76.132809 0   335136 LORETTO HEALTH AND REHABILITATION CENTER 700 EAST BRIGHTON AVENUE SYRACUSE NY 13205 3154695570 520 Onondaga Non profit - Other 583 563.5 Medicare and Medicaid false 01/01/1967 false   false false false Both Yes 2   2   3   2   3   3   3       2.52096 0.76953 0.63312 1.40265 3.92361 0.04977 2.22761 0.7806 0.40791 3.41612 2.35203 0.74128 0.58418 3.68303 01/08/2020 9 9 0 40 0 0 40 07/02/2018 5 5 2 20 1 0 20 2017-02-16 13 12 7 1 64 0 64 37.333 2 5 0 0.00 0 0 700 EAST BRIGHTON AVENUE SYRACUSE, NY 13205 (43.00929, -76.132809) 02/01/2020
9847 5601 S ORCHARD STREET TACOMA, WA 98409 47.205657 -122.50462 0   505289 MANOR CARE OF TACOMA WA, LLC 5601 S ORCHARD STREET TACOMA WA 98409 2534748421 260 Pierce Non profit - Other 124 86.5 Medicare and Medicaid false 07/01/1984 false   false false false Resident Yes 4   2   5   5   5   5   5       2.19652 0.76029 1.12867 1.88895 4.08547 0.10007 2.00853 0.73354 0.34181 3.08388 2.27286 0.77936 1.24283 4.24813 03/15/2019 31 16 15 192 1 0 192 01/12/2018 25 8 17 108 1 0 108 2017-01-24 13 7 6 1 68 0 68 143.333 6 38 2 81884.00 0 2 5601 S ORCHARD STREET TACOMA, WA 98409 (47.205657, -122.50462) 02/01/2020
9892 12019 VERHOEFF DRIVE HUNTERSVILLE, NC 28078 35.39321 -80.84206 0   345096 HUNTERSVILLE OAKS 12019 VERHOEFF DRIVE HUNTERSVILLE NC 28078 7048631000 590 Mecklenburg Non profit - Other 168 135.1 Medicare and Medicaid false 10/01/1973 false   false false false Resident Yes 3   2   3   3   4   4   4       2.13935 0.69065 0.72867 1.41932 3.55867 0.05478 2.03536 0.75821 0.37394 3.16752 2.18452 0.68493 0.73342 3.60264 09/27/2019 11 11 7 44 1 0 44 11/29/2018 2 2 0 8 1 0 8 2017-12-22 15 4 11 1 108 0 108 42.667 0 57 1 64666.00 1 2 12019 VERHOEFF DRIVE HUNTERSVILLE, NC 28078 (35.39321, -80.84206) 02/01/2020
10516 1548 SANS SOUCI PARKWAY WILKES BARRE, PA 18702 41.219761 -75.945193 0   395249 HAMPTON HOUSE 1548 SANS SOUCI PARKWAY WILKES BARRE PA 18702 5708258725 480 Luzerne Non profit - Other 104 88.8 Medicare and Medicaid false 10/17/1968 false   false false false Resident Yes 2   2   2   3   2   3   4       1.64787 0.71055 0.67189 1.38244 3.03032 0.02726 2.21767 0.75024 0.34081 3.30872 1.54434 0.71216 0.74203 2.93684 12/14/2018 9 9 2 68 2 34 102 01/16/2018 9 7 2 60 1 0 60 2016-12-15 10 5 5 1 80 0 80 84.333 2 10 2 18843.00 0 2 1548 SANS SOUCI PARKWAY WILKES BARRE, PA 18702 (41.219761, -75.945193) 02/01/2020
10681 901 COURT STREET SUNBURY, PA 17801 40.859146 -76.786702 0   395512 MANORCARE HEALTH SERVICES-SUNBURY 901 COURT STREET SUNBURY PA 17801 5702867121 600 Northumberlnd Non profit - Other 126 112.4 Medicare and Medicaid false 09/14/1981 false   false false false Resident Yes 2   2   4   4   4   2   2       1.81994 0.76434 0.47923 1.24357 3.06352 0.04632 2.22525 0.75469 0.36971 3.34965 1.69979 0.76156 0.48788 2.93274 01/18/2019 16 16 2 68 1 0 68 02/02/2018 13 13 0 80 1 0 80 2017-01-06 11 9 2 1 84 0 84 74.667 1 2 1 6893.00 0 1 901 COURT STREET SUNBURY, PA 17801 (40.859146, -76.786702) 02/01/2020
11181 214 PEACH ORCHARD ROAD MCCONNELLSBURG, PA 17233 39.936716 -78.009 0   395387 FULTON COUNTY MEDICAL CENTER 214 PEACH ORCHARD ROAD MCCONNELLSBURG PA 17233 7174853155 360 Fulton Non profit - Other 67 65.5 Medicare and Medicaid true 02/07/1977 false   false false false Both Yes 1   2   4   3   5   1 12 1 12 6 6                             09/05/2019 16 16 0 84 1 0 84 08/09/2018 10 10 0 56 1 0 56 2017-09-01 7 7 0 1 36 0 36 66.667 0 0 0 0.00 0 0 214 PEACH ORCHARD ROAD MCCONNELLSBURG, PA 17233 (39.936716, -78.009) 02/01/2020
11455 100 WEST QUEEN STREET DALLASTOWN, PA 17313 39.898535 -76.645111 0   395451 MANORCARE HEALTH SERVICES-DALLASTOWN 100 WEST QUEEN STREET DALLASTOWN PA 17313 7172461671 800 York Non profit - Other 202 169.8 Medicare and Medicaid false 10/17/1979 false   false false false Resident Yes 3   2   5   5   5   3   3       1.74117 0.80096 0.53064 1.3316 3.07276 0.03274 2.03908 0.73529 0.36717 3.14153 1.77469 0.8191 0.54395 3.13647 03/21/2019 11 7 5 48 1 0 48 04/12/2018 9 9 0 52 1 0 52 2017-03-09 12 10 2 1 64 0 64 52 1 4 0 0.00 0 0 100 WEST QUEEN STREET DALLASTOWN, PA 17313 (39.898535, -76.645111) 02/01/2020
11482 1206 N TRAVIS ST LIBERTY, TX 77575 30.067852 -94.797877 0   675540 LIBERTY HEALTH CARE CENTER 1206 N TRAVIS ST LIBERTY TX 77575 9363367247 757 Liberty Non profit - Other 118 78.1 Medicare and Medicaid false 11/27/1995 false   false false false Resident Yes 1   2   2   4   1   1   1       1.87795 1.14855 0.19113 1.33968 3.21763 0.07065 2.04803 0.8134 0.44028 3.30171 1.90574 1.06176 0.1634 3.125 03/20/2019 10 8 2 56 1 0 56 04/05/2018 6 5 1 52 1 0 52 2017-05-17 7 5 2 1 336 0 336 101.333 2 1 0 0.00 0 0 1206 N TRAVIS ST LIBERTY, TX 77575 (30.067852, -94.797877) 02/01/2020
12242 6801 MIDDLEBROOK PIKE KNOXVILLE, TN 37919 35.944935 -84.027748 0   445501 WEST HILLS HEALTH AND REHAB 6801 MIDDLEBROOK PIKE KNOXVILLE TN 37919 8655887661 460 Knox Non profit - Other 194 128.3 Medicare and Medicaid false 01/20/2011 false   true false false Resident Yes 3   2   3   3   3   4   5       2.07294 0.87665 1.00442 1.88106 3.954 0.04228 2.16373 0.73153 0.35818 3.25343 1.99113 0.90111 1.05548 3.89717 03/20/2019 5 4 3 52 1 0 52 03/28/2018 5 4 2 20 1 0 20 2017-02-23 4 3 1 1 28 0 28 37.333 3 1 1 13905.00 0 1 6801 MIDDLEBROOK PIKE KNOXVILLE, TN 37919 (35.944935, -84.027748) 02/01/2020
12361 807 WEST AVE ELYRIA, OH 44035 41.359962 -82.110498 0   365162 WESLEYAN VILLAGE 807 WEST AVE ELYRIA OH 44035 4402849000 480 Lorain Non profit - Other 99 73.7 Medicare and Medicaid false 05/01/1967 true   true false false Resident Yes 1   2   2   2   3   1 12 1 12 6 6                             05/09/2019 20 13 9 80 1 0 80 04/05/2018 7 3 5 40 1 0 40 2017-02-15 9 3 9 1 52 0 52 62 0 13 0 0.00 0 0 807 WEST AVE ELYRIA, OH 44035 (41.359962, -82.110498) 02/01/2020
13341 1451 GAMBIER ROAD MOUNT VERNON, OH 43050 40.38725 -82.449335 0   366076 OHIO EASTERN STAR HLTH CARE CTR THE 1451 GAMBIER ROAD MOUNT VERNON OH 43050 7403971706 430 Knox Non profit - Other 86 81 Medicare and Medicaid false 07/25/1996 true   false false false Resident Yes 1   2   4   3   4   1 12 1 12     3.14758 1.50589 0.44129 1.94717 5.09475 0.05688 2.03305 0.80005 0.40524 3.23833 3.2177 1.41534 0.40987 5.04493 11/18/2018 10 4 6 60 1 0 60 08/30/2017 2 2 0 20 1 0 20 2016-05-26 13 13 0 1 72 0 72 48.667 0 6 0 0.00 0 0 1451 GAMBIER ROAD MOUNT VERNON, OH 43050 (40.38725, -82.449335) 02/01/2020
13972 418 NORTH MAIN STREET PENN YAN, NY 14527 42.670468 -77.059591 0   335289 SOLDIERS AND SAILORS MEMORIAL HOSPITAL E C U 418 NORTH MAIN STREET PENN YAN NY 14527 3155312731 910 Yates Non profit - Other 152 127.8 Medicare and Medicaid true 06/15/1969 false   false false false Resident Yes 2   2   3   2   4   2   2       2.20284 0.85486 0.40914 1.264 3.46684 0 1.99668 0.69023 0.34504 3.03195 2.29293 0.93129 0.44631 3.66661 11/22/2019 6 6 0 24 1 0 24 04/06/2018 8 8 0 36 1 0 36 2017-01-20 6 6 0 1 28 0 28 28.667 0 0 0 0.00 0 0 418 NORTH MAIN STREET PENN YAN, NY 14527 (42.670468, -77.059591) 02/01/2020
14592 45 SIXTH STREET MALONE, NY 12953 44.860932 -74.289598 0   335127 ALICE HYDE MEDICAL CENTER 45 SIXTH STREET MALONE NY 12953 5184818000 270 Franklin Non profit - Other 135 126.4 Medicare and Medicaid true 01/01/1967 false   false false false Both Yes 2   2   3   4   2   3   3       2.45577 0.90318 0.56093 1.46411 3.91988 0.07977 2.21124 0.72216 0.34474 3.27815 2.30817 0.94042 0.61242 3.8344 11/30/2018 10 9 1 44 1 0 44 01/20/2017 2 2 0 12 1 0 12 2015-12-04 11 11 0 1 76 0 76 38.667 2 0 0 0.00 0 0 45 SIXTH STREET MALONE, NY 12953 (44.860932, -74.289598) 02/01/2020
14605 855 AARON DRIVE LYNDEN, WA 98264 48.962451 -122.437555 0   505406 CHRISTIAN HEALTH CARE CENTER 855 AARON DRIVE LYNDEN WA 98264 3603544434 360 Whatcom Non profit - Other 142 124.5 Medicare and Medicaid false 01/01/1992 false   false false false Resident Yes 4   2   5   5   4   4   4       2.44708 0.68428 0.8766 1.56087 4.00795 0.07558 2.43059 0.78783 0.34996 3.56839 2.09243 0.65311 0.94277 3.60167 06/07/2019 19 18 2 96 1 0 96 03/08/2018 21 18 3 237 1 0 237 2016-12-08 22 19 3 1 164 0 164 154.333 1 3 2 45543.00 0 2 855 AARON DRIVE LYNDEN, WA 98264 (48.962451, -122.437555) 02/01/2020
14695 3025 FERNBROOK LANE NASHVILLE, TN 37214 36.185351 -86.668792 0   445526 LAKESHORE HEARTLAND 3025 FERNBROOK LANE NASHVILLE TN 37214 6158852320 180 Davidson Non profit - Other 66 57.7 Medicare and Medicaid false 09/13/2016 false   false false false Both Yes 2   2   3   4   2   2   2       2.00787 0.81793 0.42854 1.24647 3.25434 0.02591 2.02021 0.74742 0.33107 3.09871 2.06564 0.82287 0.48719 3.36771 10/09/2019 4 4 0 32 1 0 32 08/08/2018 5 4 1 20 1 0 20 2017-06-27 2 2 0 1 8 0 8 24 1 0 1 14760.00 0 1 3025 FERNBROOK LANE NASHVILLE, TN 37214 (36.185351, -86.668792) 02/01/2020
15017 8551 DARROW ROAD TWINSBURG, OH 44087 41.298425 -81.440354 0   366419 HEARTLAND OF TWINSBURG 8551 DARROW ROAD TWINSBURG OH 44087 3304869402 780 Summit Non profit - Other 120 103 Medicare and Medicaid false 08/26/2014 false   false false false Resident Yes 2   2   4   5   3   3   4       1.71526 0.73218 1.06138 1.79356 3.50882 0.14187 2.0927 0.83297 0.42797 3.35365 1.70348 0.66095 0.93345 3.35503 04/04/2019 13 8 6 84 1 0 84 03/08/2018 13 7 6 72 1 0 72 2017-02-01 6 1 6 1 24 0 24 70 0 9 0 0.00 0 0 8551 DARROW ROAD TWINSBURG, OH 44087 (41.298425, -81.440354) 02/01/2020
15341 9055 W Sprague Rd, Parma, OH 44129, USA 41.3514395 -81.7493148 1 ROOFTOP 366343 MANORCARE HEALTH SERVICES - PARMA 9055 WEST SPRAGUE ROAD PARMA OH 44133 4408424967 170 Cuyahoga Non profit - Other 130 117.7 Medicare and Medicaid false 06/07/2007 false   false false false Resident Yes 3   2   5   5   5   3   4       1.52391 0.70162 0.79649 1.49811 3.02202 0.13694 2.18051 0.79899 0.38703 3.36653 1.45251 0.66031 0.77457 2.87852 05/14/2019 8 5 4 131 1 0 131 03/26/2018 0 0 0 0 0 0 0 2017-01-11 3 0 3 0 28 0 28 70.167 0 6 2 17115.00 0 2   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
);