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

38 rows where geocode_flag = 1 and ownership = "Non profit - Other"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: geocode_accuracy, prvdr_state, prvdr_cnty, prvdr_type, Provider Resides in Hospital, Continuing Care Retirement Community, Special Focus Status, Abuse Icon, Most Recent Health Inspection More Than 2 Years Ago, With a Resident and Family Council, 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 Physical Therapist Staffing Hours per Resident Per Day, 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 Health Revisit Score, Rating Cycle 2 Total Health 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 Deficiency Score, Rating Cycle 3 Health Revisit 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
1 1 83825 AL-9, Ashland, AL 36251, USA 33.2771472 -85.82382199999999 1 ROOFTOP 15124 CLAY COUNTY NURSING HOME 83825 HIGHWAY 9 P O BOX 1270 ASHLAND AL 36251 2563542131 130 Clay Non profit - Other 83 75.9 Medicare and Medicaid true CLAY COUNTY HEALTHCARE AUTHORITY 12/01/1974 false   false false false Both Yes 5   3   5   5     2 4   4       2.26468 0.78644 0.54804 1.33448 3.59916 0.00014 1.79947 0.59241 0.25352 2.6454 2.61563 0.99823 0.81362 4.36276 05/16/2019 2 2 0 16 1 0 16 06/21/2018 4 4 0 28 1 0 28 2017-05-11 4 4 0 1 20 0 20 20.667 0 0 0 0.00 0 0   02/01/2020
54 54 Heritage Rd, Crow Agency, MT 59022, USA 45.5810378 -107.4506532 1 GEOMETRIC_CENTER 275153 AWE KUALAWAACHE CARE CENTER 10131 S HERITAGE RD CROW AGENCY MT 59022 4066389111 10 Big Horn Non profit - Other 40 26.5 Medicare and Medicaid false Legal Business Name Not Available 06/09/1998 false SFF Candidate false false false Resident Yes 2   1   5   5     2 1 12 1 12 6 6                             02/05/2019 7 7 0 56 1 0 56 09/06/2018 12 9 3 414 1 0 414 2017-05-04 22 22 0 2 244 122 366 227 0 2 0 0.00 2 2   02/01/2020
56 56 526 1st St, Crawford, NE 69339, USA 42.6827693 -103.4164667 1 RANGE_INTERPOLATED 285250 PONDEROSA VILLA P O BOX 526, FIRST & PADDOCK STREET CRAWFORD NE 69339 3086651224 220 Dawes Non profit - Other 35 27.5 Medicare and Medicaid false CITY OF CRAWFORD 06/01/2003 false   false false false Resident Yes 5   4   5   5   5   4   5       1.97008 0.27897 1.07372 1.35269 3.32277 0 2.15587 0.65238 0.28257 3.09082 1.89923 0.32154 1.4302 3.4473 02/19/2019 2 2 0 8 1 0 8 03/15/2018 5 4 1 48 1 0 48 2017-02-15 6 6 0 1 52 0 52 28.667 1 0 0 0.00 0 0   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
1323 1323 3340 Hospital Rd, Saginaw, MI 48603, USA 43.4551416 -84.0513038 1 ROOFTOP 235150 HEALTHSOURCE SAGINAW, INC 3340 HOSPITAL RD SAGINAW MI 48603 9897907700 720 Saginaw Non profit - Other 213 202.8 Medicare and Medicaid true HEALTHSOURCE SAGINAW INC 02/23/1968 false   false false false Resident Yes 2   1   4   4   5   4   4       2.6567 0.8195 0.67999 1.49949 4.15619 0.11139 2.02249 0.69892 0.34315 3.06457 2.73006 0.88166 0.74585 4.3489 05/30/2019 19 16 5 278 2 139 417 06/14/2018 9 8 1 64 1 0 64 2017-04-07 26 24 5 1 172 0 172 258.5 0 21 2 69261.00 1 3   02/01/2020
1399 1399 Anniston, AL 36207, USA 33.656468 -85.7461548 1 APPROXIMATE 15375 ANNISTON HEALTH AND REHAB SERVICES P.O. BOX 1825 ANNISTON AL 36207 2562364949 70 Calhoun Non profit - Other 85 41.9 Medicare and Medicaid false ANNISTON HEALTH AND REHAB SERVICES, LLC 01/20/1981 false   false false false Resident Yes 3   3   4   4     2 3   3       2.08171 0.85731 0.45133 1.30864 3.39036 0.00544 1.82024 0.60955 0.272 2.70179 2.37688 1.05757 0.62454 4.02389 06/27/2019 2 2 0 20 1 0 20 06/14/2018 0 0 0 0 0 0 0 2017-04-27 4 4 0 1 36 0 36 16 0 0 0 0.00 0 0   02/01/2020
1632 1632 290 US-1, Scarborough, ME 04074, USA 43.5872419 -70.3424486 1 ROOFTOP 205127 MAINE VETERANS HOME - SCARBOROUGH 290 US RT 1 SCARBOROUGH ME 4074 2078837184 20 Cumberland Non profit - Other 120 116 Medicare and Medicaid false MAINE VETERANS' HOME 01/01/1993 false   false false false Both Yes 5   4   4   5   4   5   5       2.66723 0.57609 1.08976 1.66585 4.33308 0.16045 2.21203 0.70221 0.29728 3.21152 2.50603 0.61688 1.37973 4.32652 07/18/2019 0 0 0 0 0 0 0 07/19/2018 10 10 2 36 1 0 36 2017-09-13 1 1 0 1 4 0 4 12.667 0 0 0 0.00 0 0   02/01/2020
2114 2114 10629 US-19, Thomasville, GA 31792, USA 30.800262 -83.937355 1 ROOFTOP 115480 GLENN-MOR NURSING HOME 10629 U.S. HIGHWAY 19 SOUTH THOMASVILLE GA 31792 2292268942 890 Thomas Non profit - Other 64 57.7 Medicare and Medicaid false JOHN D. ARCHBOLD MEMORIAL HOSPITAL, INC. 01/01/1990 false   false false false Resident Yes 4   4   2   4   1   4   4       1.97528 0.91694 0.59644 1.51338 3.48866 0.03219 1.96204 0.64758 0.27077 2.88039 2.09236 1.0647 0.82908 3.88383 12/05/2019 3 3 0 12 1 0 12 07/26/2018 2 2 0 8 1 0 8 2017-08-06 0 0 0 0 0 0 0 8.667 0 0 0 0.00 0 0   02/01/2020
2124 2124 8041 State Rd 52, Hudson, FL 34667, USA 28.3320245 -82.6813203 1 ROOFTOP 105393 BEAR CREEK NURSING CENTER 8041 STATE RD 52 HUDSON FL 34667 7278635488 500 Pasco Non profit - Other 120 107.9 Medicare and Medicaid false BEAR CREEK NURSING CENTER LLC 09/15/1981 false   false false false Resident Yes 4   3   5   5   5   3   3       2.63975 0.80943 0.65706 1.46649 4.10624 0.08796 2.20488 0.78238 0.36783 3.35509 2.48825 0.77794 0.67233 3.92459 12/20/2018 8 6 2 36 1 0 36 10/05/2017 0 0 0 0 0 0 0 2016-07-14 8 6 2 1 36 0 36 24 0 2 0 0.00 0 0   02/01/2020
2752 2752 Indian Hills Dr, Macy, NE 68039, USA 42.1187092 -96.35944669999999 1 GEOMETRIC_CENTER 28A065 CARL T CURTIS HEALTH EDUCATION CENTER NURSING HOME P O BOX 250 MACY NE 68039 4028375381 860 Thurston Non profit - Other 25 20.8 Medicaid false Legal Business Name Not Available 10/02/1990 false   false false false Resident Yes 2   3   2   2     2 1 12 1 12 6 6                             11/01/2018 1 1 0 16 1 0 16 10/16/2017 11 10 11 108 1 0 108 2016-07-06 1 1 0 1 4 0 4 44.667 2 0 0 0.00 0 0   02/01/2020
2772 2772 1850 E Howard Wayne Blvd, Terre Haute, IN 47802, USA 39.3809492 -87.3870489 1 ROOFTOP 155772 COBBLESTONE CROSSINGS HEALTH CAMPUS 1850 E HOWARD WAYNE DR TERRE HAUTE IN 47802 8122320406 830 Vigo Non profit - Other 60 50.2 Medicare and Medicaid false PUTNAM COUNTY HOSPITAL 10/10/2008 false   false false false Resident Yes 4   4   4   4   4   2   2       2.17338 1.56458 0.4955 2.06008 4.23347 0.09674 2.30151 0.86698 0.4265 3.59499 1.96263 1.35698 0.43728 3.77617 06/26/2019 3 3 0 8 1 0 8 07/03/2018 7 7 0 48 1 0 48 2017-07-21 9 9 0 1 40 0 40 26.667 0 0 0 0.00 0 0   02/01/2020
2829 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 UNLIMITED DEVELOPMENT, INC 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
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
4391 4391 11 St Anthony St, Chicopee, MA 01013, USA 42.1813154 -72.61497829999999 1 ROOFTOP 225249 WILLIMANSETT CENTER EAST 11 ST ANTHONY STREET CHICOPEE MA 1013 4135362540 70 Hampden Non profit - Other 85 78.2 Medicare and Medicaid false THE NORTHEAST HEALTH GROUP, INC 06/01/1976 false   false false false Resident Yes 4   4   4   5   2   3   3       1.91773 0.63994 0.62264 1.26258 3.18031 0.09083 2.03541 0.68644 0.33468 3.05653 1.95818 0.701 0.70022 3.33651 08/21/2019 7 7 0 32 1 0 32 09/25/2018 3 3 1 16 1 0 16 2017-07-25 3 3 0 1 12 0 12 23.333 0 1 0 0.00 0 0   02/01/2020
4624 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 BETHANY LUTHERAN HOME 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
4821 4821 Applewood Dr, Freehold Township, NJ 07728, USA 40.2484849 -74.3155446 1 GEOMETRIC_CENTER 315292 APPLEWOOD ESTATES APPLEWOOD DRIVE FREEHOLD NJ 7728 7327807370 290 Monmouth Non profit - Other 60 46.7 Medicare and Medicaid false CENTER FOR AGING, INC. 03/20/1990 true   false false false Resident Yes 5   5   5   5   5   4   4       2.37773 0.93561 0.93801 1.87362 4.25135 0.22305 2.11154 0.76676 0.3502 3.2285 2.34035 0.91752 1.00814 4.2226 12/20/2019 1 1 0 8 1 0 8 01/29/2019 0 0 0 0 0 0 0 2017-10-12 2 2 0 1 4 0 4 4.667 0 0 0 0.00 0 0   02/01/2020
5027 5027 1010 US Hwy 27 N, Avon Park, FL 33825, USA 27.5842556 -81.5150317 1 RANGE_INTERPOLATED 105780 OAKS AT AVON 1010 US 27 N AVON PARK FL 33825 8634535200 270 Highlands Non profit - Other 104 91.6 Medicare and Medicaid false FI-THE OAKS, LLC 01/06/1993 false   false false false Resident Yes 3   4   4   5   3   1 12 1 12 6 6                             03/07/2019 4 3 1 16 1 0 16 01/19/2018 4 2 2 12 1 0 12 2016-12-15 8 4 4 1 40 0 40 18.667 0 5 0 0.00 0 0   02/01/2020
5569 5569 275 S Lasalle St, Aurora, IL 60505, USA 41.751409 -88.3177809 1 ROOFTOP 14A539 JENNINGS TERRACE 275 SOUTH LASALLE AURORA IL 60505 6308976947 530 Kane Non profit - Other 60 14.5 Medicaid false Legal Business Name Not Available 09/18/2008 false   false false false Resident Yes 4   4   4   4     2   2   2 6 6                             12/12/2019 0 0 0 0 1 0 0 11/29/2018 5 4 1 32 1 0 32 2018-01-16 12 9 3 1 56 0 56 20 1 2 0 0.00 0 0   02/01/2020
5891 5891 302 Georgia 18 E, Gray, GA 31032, USA 32.9990521 -83.5291847 1 RANGE_INTERPOLATED 115466 AUTUMN LANE HEALTH AND REHABILITATION 302 GEORGIA 18 EAST GRAY GA 31032 4789863151 650 Jones Non profit - Other 85 59 Medicare and Medicaid false JONES COUNTY NURSING HOME LLC 11/27/1989 false   false false false Resident Yes 5   4   5   5     2 2   2       2.15901 1.01631 0.32068 1.33699 3.496 0.06472 2.10183 0.7308 0.35564 3.18827 2.13488 1.0457 0.33939 3.51616 09/06/2019 1 1 0 20 1 0 20 06/14/2018 0 0 0 0 0 0 0 2017-07-23 1 1 0 1 16 0 16 12.667 0 0 1 7963.00 0 1   02/01/2020
6046 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 KAHUKU MEDICAL CENTER 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
6101 6101 9000 Fathers Legacy, Ellicott City, MD 21042, USA 39.2717181 -76.84284989999999 1 ROOFTOP 215363 THE LUTHERAN VILLAGE AT MILLER'S GRANT 9000 FATHERS LEGACY ELLICOTT CITY MD 21042 4106966700 130 Howard Non profit - Other 12 12 Medicare and Medicaid false THE LUTHERAN VILLAGE AT MILLERS GRANT 04/18/2017 true   false false false Both Yes 4   5   4   4   4   1 12 1 12 6 6                             05/22/2019 0 0 0 0 0 0 0 01/30/2018 2 2 0 8 1 0 8 2017-03-13 3 3 0 1 12 0 12 4.667 0 0 0 0.00 0 0   02/01/2020
6133 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 SPARTA HEALTH CARE LLC 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
6419 6419 2053 S Sheridan Dr, Muskegon, MI 49442, USA 43.2150912 -86.18564119999999 1 ROOFTOP 235656 CHRISTIAN CARE NURSING CENTER 2053 S SHERIDAN DRIVE MUSKEGON MI 49442 2317227165 600 Muskegon Non profit - Other 49 43.8 Medicare and Medicaid false CHRISTIAN CARE 05/23/2012 false   false false false Resident Yes 5   5   5   5   5   4   4       3.07626 1.03949 0.7955 1.83499 4.91125 0.038 2.05659 0.65149 0.29577 3.00385 3.10878 1.19976 1.01233 5.24284 06/13/2019 1 1 1 4 1 0 4 07/11/2018 0 0 0 0 0 0 0 2017-05-04 10 10 0 1 80 0 80 15.333 0 0 0 0.00 0 0   02/01/2020
6512 6512 541 Historic Hwy #441-N, Demorest, GA 30535, USA 34.5810438 -83.53708859999999 1 ROOFTOP 115099 HABERSHAM HOME HIGHWAY 441 NORTH, BOX 37 DEMOREST GA 30535 7067543113 540 Habersham Non profit - Other 84 76 Medicare and Medicaid true THE HOSPITAL AUTHORITY OF HABERSHAM COUNTY 03/06/1969 false   false false false Resident Yes 1   1   3   4   3   2   2       2.08323 1.17353 0.26927 1.4428 3.52603 0 2.26045 0.66078 0.29369 3.21491 1.91539 1.33544 0.34509 3.51698 06/27/2019 8 6 8 60 1 0 60 05/02/2018 6 4 2 28 1 0 28 2017-05-18 7 7 7 1 36 0 36 45.333 0 3 1 18605.00 0 1   02/01/2020
6947 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 WILLOWOOD OF GREAT BARRINGTON INC 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
7475 7475 Chinle, AZ 86503, USA 36.1544483 -109.5526072 1 APPROXIMATE 35242 CHINLE NURSING HOME PO BOX 910 CHINLE AZ 86503 9286745216 0 Apache Non profit - Other 79 56.6 Medicare and Medicaid false NAVAJOLAND NURSING HOMES INC 07/10/1997 false SFF Candidate false true false Resident Yes 2   1   3   3     2 4   4       2.71606 0.40745 0.7381 1.14555 3.86161 0.03178 1.8047 0.60295 0.29618 2.70383 3.12789 0.50813 0.93796 4.57975 09/29/2017 25 21 14 317 2 159 476 08/25/2016 5 5 0 20 1 0 20 2014-11-21 31 30 1 2 403 202 605 345.5 8 2 0 0.00 2 2   02/01/2020
7885 7885 NW 11th St, Fairfield, IL 62837, USA 38.3809194 -88.3744583 1 GEOMETRIC_CENTER 145552 FAIRFIELD MEMORIAL HOSPITAL NORTH WEST 11TH STREET FAIRFIELD IL 62837 6188422611 986 Wayne Non profit - Other 30 20.7 Medicare false FAIRFIELD MEMORIAL HOSPITAL ASSOCIATION 03/26/1986 false   false false false Resident Yes 5   5   5   5   5   5   5       2.59882 0 2.32737 2.32737 4.92618 0.01246 1.96408 0.63099 0.30819 2.90326 2.74999 0 2.84237 5.44099 05/31/2019 1 1 0 4 1 0 4 04/05/2018 1 1 0 4 1 0 4 2017-06-08 0 0 0 0 0 0 0 3.333 0 0 0 0.00 0 0   02/01/2020
9071 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 UVMC NURSING CARE, INC 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
9159 9159 23600 Vía Esplendor, Cupertino, CA 95014, USA 37.3384112 -122.0889817 1 ROOFTOP 555524 HEALTH CARE CTR AT THE FORUM AT RANCHO SAN ANTONIO 23600 VIA ESPLENDOR CUPERTINO CA 95014 6509440200 530 Santa Clara Non profit - Other 48 42.6 Medicare false RANCHO SAN ANTONIO RETIREMENT SERVICES, INC. 09/01/1992 true   false false false Both Yes 5   5   5   5   5   5   5       2.9013 0.60533 1.31688 1.9222 4.8235 0.17266 2.20728 0.73808 0.34854 3.29391 2.73181 0.61669 1.42207 4.69574 05/03/2019 3 3 0 16 1 0 16 03/28/2018 5 5 0 28 1 0 28 2017-04-07 2 2 0 1 16 0 16 20 0 0 0 0.00 0 0   02/01/2020
10158 10158 Eagle Butte, SD 57625, USA 44.9886537 -101.2224805 1 APPROXIMATE 43A138 MEDICINE WHEEL VILLAGE 24266 AIRPORT ROAD PO BOX 880 EAGLE BUTTE SD 57625 6059648155 200 Dewey Non profit - Other 50 22.8 Medicaid false Legal Business Name Not Available 02/05/2019 false   false false false Resident Yes   1   1   1   1   1   1   1     4.00312 1.3967 1.38696 2.78366 6.78678 0 1.75731 0.62804 0.28224 2.66759         02/05/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   02/01/2020
12002 12002 74-350 Country Club Dr, Palm Desert, CA 92260, USA 33.7589916 -116.3676056 1 ROOFTOP 555339 MANORCARE HEALTH SERVICES-PALM DESERT 74-350 COUNTRY CLUB DRIVE PALM DESERT CA 92260 7603410261 430 Riverside Non profit - Other 178 140.8 Medicare and Medicaid false MANOR CARE OF PALM DESERT CA LLC 02/09/1989 false   true false false Resident Yes 2   1   4   4   4   4   3       2.41797 1.58735 0.66219 2.24955 4.66751 0.1841 2.07603 0.77127 0.37313 3.22043 2.42066 1.54757 0.66796 4.64755 02/05/2019 52 15 39 280 1 0 280 03/23/2018 13 6 7 56 1 0 56 2017-03-16 11 11 0 1 60 0 60 168.667 19 22 0 0.00 0 0   02/01/2020
12005 12005 1 Nolte Dr, Kittanning, PA 16201, USA 40.8085788 -79.56145769999999 1 ROOFTOP 395890 SNU ARMSTRONG CO MEMORIAL HOSP ONE NOLTE DRIVE KITTANNING PA 16201 7245438458 70 Armstrong Non profit - Other 17 8.9 Medicare true ARMSTRONG COUNTY MEMORIAL HOSPITAL 02/23/1993 false   false false false None Yes 5   5   5     2 5   1 12 1 12 6 6                             09/06/2019 0 0 0 0 0 0 0 08/13/2018 1 1 0 16 1 0 16 2017-08-30 1 1 0 1 4 0 4 6 0 0 0 0.00 0 0   02/01/2020
12080 12080 Lincoln Ave, Yeadon, PA 19050, USA 39.9330023 -75.2665748 1 GEOMETRIC_CENTER 395374 MANORCARE HEALTH SERVICES-YEADON LANSDOWNE AND LINCOLN AVE YEADON PA 19050 6106267700 290 Delaware Non profit - Other 198 179.7 Medicare and Medicaid false MANOR CARE OF YEADON PA LLC 08/01/1977 false   false false false Resident Yes 1   1   4   4   3   3   3       1.82765 0.76037 0.61129 1.37166 3.19931 0.07393 2.08201 0.71803 0.33691 3.13695 1.82442 0.79628 0.68292 3.27041 10/22/2019 23 21 2 108 1 0 108 09/28/2018 16 16 5 100 2 50 150 2017-10-23 13 9 4 1 76 0 76 116.667 2 11 0 0.00 0 0   02/01/2020
12943 12943 4988 NY-30, Amsterdam, NY 12010, USA 42.9590921 -74.1872746 1 ROOFTOP 335857 WILKINSON RESIDENTIAL HEALTH CARE FACILITY 4988 STATE HWY 30 AMSTERDAM NY 12010 5188413572 380 Montgomery Non profit - Other 160 152.1 Medicare and Medicaid true ST. MARY'S HEALTHCARE 06/17/2009 false   false false false Resident Yes 5   3   5   5   5   4   4       2.17353 0.99325 0.62194 1.61519 3.78872 0.01194 2.15937 0.67917 0.32043 3.15897 2.09196 1.09967 0.73055 3.84592 11/20/2018 3 3 1 16 1 0 16 02/02/2017 3 3 0 20 1 0 20 2015-11-06 4 2 2 1 20 0 20 18 1 3 0 0.00 0 0   02/01/2020
13457 13457 5001 OH-60, Marietta, OH 45750, USA 39.471109 -81.46797780000001 1 ROOFTOP 365780 HEARTLAND OF MARIETTA 5001 STATE ROUTE 60 MARIETTA OH 45750 7403738920 850 Washington Non profit - Other 99 77.8 Medicare and Medicaid false HEARTLAND OF MARIETTA OH, LLC 11/06/1989 false SFF Candidate false false false None Yes 1   1   4   4   3   3   3       1.97115 0.88193 0.65108 1.53301 3.50416 0.12874 2.01931 0.76555 0.37126 3.15612 2.02877 0.86625 0.66006 3.56028 01/31/2019 30 29 4 208 2 104 312 11/16/2017 26 16 10 164 1 0 164 2016-09-15 10 10 0 1 56 0 56 220 0 8 1 3318.00 1 2   02/01/2020
14482 14482 506 3rd Ave, Martin, SD 57551, USA 43.1756812 -101.7347328 1 ROOFTOP 43A075 BENNETT COUNTY HOSPITAL AND NURSING HOME 102 MAJOR ALLEN POST OFFICE BOX 70 MARTIN SD 57551 6056856586 30 Bennett Non profit - Other 48 32.4 Medicaid false Legal Business Name Not Available 09/01/1983 false   false false false Both Yes 3   3   1   1     2 4   4       2.41446 0.6422 0.60338 1.24558 3.66003 0 1.71998 0.59132 0.25656 2.56786 2.9175 0.81664 0.8852 4.57054 06/05/2019 4 4 0 16 1 0 16 02/28/2018 7 5 2 40 1 0 40 2016-12-07 4 4 0 1 28 0 28 26 0 0 0 0.00 0 0   02/01/2020
14789 14789 1 Hospital Way, Butler, PA 16001, USA 40.86727399999999 -79.8805124 1 ROOFTOP 395869 BUTLER MEMORIAL HOSP TCF ONE HOSPITAL WAY BUTLER PA 16001 7242844526 150 Butler Non profit - Other 25 20.8 Medicare false BUTLER HEALTH CARE PROVIDERS 11/26/1991 false   false false false None Yes 5   5   4     2 4   4   5       1.52394 1.21343 1.68003 2.89347 4.41741 0.5544 2.33189 0.96528 0.55665 3.85382 1.35824 0.94525 1.13598 3.67561 06/06/2019 0 0 0 0 0 0 0 07/19/2018 0 0 0 0 0 0 0 2017-06-15 1 1 0 1 8 0 8 1.333 0 0 0 0.00 0 0   02/01/2020
15341 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 MANOR CARE OF PARMA OH LLC 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
);