nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
23 rows where Number of Facility Reported Incidents = 17
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, prvdr_cnty_name, ownership, nmbr_beds, prvdr_type, Legal Business Name, Date First Approved to Provide Medicare and Medicaid services, Continuing Care Retirement Community, Special Focus Status, Abuse Icon, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, 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 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, Number of Substantiated Complaints, Number of Fines, Total Amount of Fines in Dollars, Number of Payment Denials, Total Number of Penalties, Location, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
572 | 572 | 2975 N ADAMS ROAD BLOOMFIELD HILLS, MI 48304 | 42.559837 | -83.206943 | 0 | 235217 | SKLD BLOOMFIELD HILLS | 2975 N ADAMS ROAD | BLOOMFIELD HILLS | MI | 48304 | 2486452900 | 620 | Oakland | For profit - Corporation | 159 | 138.4 | Medicare and Medicaid | false | BLOOMFIELD HILLS SNF LLC | 08/07/1972 | false | true | false | false | Resident | Yes | 1 | 1 | 4 | 4 | 4 | 3 | 3 | 2.27045 | 0.73012 | 0.57979 | 1.30991 | 3.58036 | 0.09897 | 1.89872 | 0.69505 | 0.3198 | 2.91357 | 2.48523 | 0.78989 | 0.68236 | 3.94053 | 03/28/2019 | 45 | 17 | 28 | 435 | 1 | 0 | 435 | 03/15/2018 | 24 | 18 | 6 | 136 | 1 | 0 | 136 | 2016-11-30 | 11 | 9 | 2 | 1 | 52 | 0 | 52 | 271.5 | 17 | 32 | 0 | 0.00 | 1 | 1 | 2975 N ADAMS ROAD BLOOMFIELD HILLS, MI 48304 (42.559837, -83.206943) | 02/01/2020 | |||||||||||
590 | 590 | 3320 BENSON AVENUE BALTIMORE, MD 21227 | 39.268871 | -76.669529 | 0 | 215044 | ST. ELIZABETH REHAB. & NSG. CE | 3320 BENSON AVENUE | BALTIMORE | MD | 21227 | 6676002600 | 30 | Baltimore City | Non profit - Church related | 162 | 153.1 | Medicare and Medicaid | false | JENKINS MEMORIAL NURSING HOME INC | 04/24/1967 | false | false | false | false | Both | Yes | 4 | 3 | 5 | 5 | 5 | 3 | 2 | 2.96176 | 0.95817 | 0.43489 | 1.39307 | 4.35483 | 0.1533 | 2.07943 | 0.74585 | 0.37047 | 3.19575 | 2.9602 | 0.966 | 0.44183 | 4.36969 | 10/31/2019 | 4 | 2 | 2 | 8 | 1 | 0 | 8 | 06/08/2018 | 5 | 2 | 3 | 16 | 1 | 0 | 16 | 2017-03-02 | 25 | 14 | 11 | 1 | 237 | 0 | 237 | 48.833 | 17 | 5 | 2 | 607621.00 | 0 | 2 | 3320 BENSON AVENUE BALTIMORE, MD 21227 (39.268871, -76.669529) | 02/01/2020 | |||||||||||
1363 | 1363 | 1524 PORTABELLA RD MOUNT PLEASANT, MI 48858 | 43.591988 | -84.753823 | 0 | 235490 | MEDILODGE OF MT PLEASANT | 1524 PORTABELLA RD | MOUNT PLEASANT | MI | 48858 | 9897722967 | 360 | Isabella | For profit - Corporation | 104 | 63.6 | Medicare and Medicaid | false | MT PLEASANT OPCO LLC | 05/01/1989 | false | true | false | false | Resident | Yes | 3 | 2 | 3 | 3 | 4 | 4 | 4 | 2.48309 | 0.5109 | 0.97679 | 1.48769 | 3.97078 | 0.04245 | 1.96611 | 0.71621 | 0.35828 | 3.0406 | 2.62482 | 0.53639 | 1.02616 | 4.18764 | 04/18/2019 | 22 | 14 | 8 | 199 | 1 | 0 | 199 | 04/03/2018 | 16 | 11 | 5 | 108 | 1 | 0 | 108 | 2017-05-19 | 7 | 4 | 4 | 1 | 40 | 0 | 40 | 142.167 | 17 | 16 | 2 | 84195.00 | 1 | 3 | 1524 PORTABELLA RD MOUNT PLEASANT, MI 48858 (43.591988, -84.753823) | 02/01/2020 | |||||||||||
1816 | 1816 | 4735 RANGER RD PERRINTON, MI 48871 | 43.154341 | -84.696005 | 0 | 235513 | LAURELS OF FULTON,THE | 4735 RANGER RD | PERRINTON | MI | 48871 | 9892365433 | 280 | Gratiot | For profit - Corporation | 50 | 40.2 | Medicare and Medicaid | false | LAUREL HEALTH CARE COMPANY OF PERRINTON | 12/26/1991 | false | false | false | false | Resident | Yes | 4 | 3 | 3 | 3 | 4 | 4 | 4 | 2.31269 | 0.515 | 0.70917 | 1.22417 | 3.53686 | 0.01702 | 2.06605 | 0.69844 | 0.31575 | 3.08024 | 2.32645 | 0.55445 | 0.84536 | 3.68203 | 08/08/2019 | 12 | 12 | 3 | 68 | 2 | 34 | 102 | 07/03/2018 | 12 | 11 | 2 | 116 | 1 | 0 | 116 | 2017-05-23 | 9 | 9 | 0 | 1 | 52 | 0 | 52 | 98.333 | 17 | 0 | 2 | 20126.00 | 0 | 2 | 4735 RANGER RD PERRINTON, MI 48871 (43.154341, -84.696005) | 02/01/2020 | |||||||||||
3363 | 3363 | 911 S 3RD ST NILES, MI 49120 | 41.819191 | -86.251737 | 0 | 235361 | CHALET OF NILES, LLC | 911 S 3RD ST | NILES | MI | 49120 | 2696844320 | 100 | Berrien | For profit - Individual | 100 | 54.6 | Medicare and Medicaid | false | CHALET OF NILES LLC | 07/01/1978 | false | false | false | false | Resident | Yes | 2 | 2 | 4 | 5 | 3 | 2 | 2 | 1.49935 | 0.84183 | 0.33979 | 1.18161 | 2.68097 | 0.02973 | 2.03126 | 0.70772 | 0.32533 | 3.06431 | 1.5341 | 0.89443 | 0.39311 | 2.80551 | 02/21/2019 | 17 | 10 | 7 | 88 | 2 | 44 | 132 | 09/13/2018 | 15 | 9 | 6 | 80 | 1 | 0 | 80 | 2018-03-30 | 28 | 19 | 15 | 1 | 342 | 0 | 342 | 149.667 | 17 | 35 | 2 | 406151.00 | 4 | 6 | 911 S 3RD ST NILES, MI 49120 (41.819191, -86.251737) | 02/01/2020 | |||||||||||
3387 | 3387 | 1183 LUTHER DRIVE HAGERSTOWN, MD 21740 | 39.616369 | -77.71617 | 0 | 215113 | RAVENWOOD NURSING CARE CENTER | 1183 LUTHER DRIVE | HAGERSTOWN | MD | 21740 | 3017901000 | 210 | Washington | Non profit - Corporation | 80 | 78.5 | Medicare and Medicaid | false | DIAKON LUTHERAN SENIOR LIVING - MARYLAND LLC | 04/03/1978 | true | SFF Candidate | true | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 5 | 3 | 4 | 1.85726 | 0.5615 | 0.80187 | 1.36337 | 3.22063 | 0.07984 | 2.2067 | 0.73812 | 0.35518 | 3.3 | 1.74922 | 0.57202 | 0.84974 | 3.12954 | 07/25/2019 | 31 | 28 | 10 | 227 | 2 | 114 | 341 | 02/05/2018 | 28 | 24 | 4 | 164 | 1 | 0 | 164 | 2016-11-01 | 36 | 24 | 12 | 2 | 216 | 108 | 324 | 279.167 | 17 | 7 | 0 | 0.00 | 1 | 1 | 1183 LUTHER DRIVE HAGERSTOWN, MD 21740 (39.616369, -77.71617) | 02/01/2020 | ||||||||||
3504 | 3504 | 3600 FULTON ST E GRAND RAPIDS, MI 49546 | 42.962238 | -85.580265 | 0 | 235310 | PORTER HILLS HEALTH CENTER | 3600 FULTON ST E | GRAND RAPIDS | MI | 49546 | 6169494971 | 400 | Kent | Non profit - Corporation | 81 | 68.5 | Medicare and Medicaid | false | PORTER HILLS PRESBYTERIAN VILLAGE, INC. | 07/01/1976 | true | false | false | false | Resident | Yes | 4 | 2 | 5 | 5 | 5 | 4 | 4 | 3.02801 | 1.03827 | 0.80521 | 1.84349 | 4.8715 | 0.04255 | 2.16073 | 0.71267 | 0.31287 | 3.18628 | 2.91254 | 1.09548 | 0.96868 | 4.90266 | 06/13/2019 | 8 | 5 | 6 | 214 | 1 | 0 | 214 | 04/26/2018 | 7 | 6 | 1 | 32 | 1 | 0 | 32 | 2017-03-16 | 18 | 14 | 4 | 2 | 120 | 60 | 180 | 147.667 | 17 | 6 | 1 | 17271.00 | 2 | 3 | 3600 FULTON ST E GRAND RAPIDS, MI 49546 (42.962238, -85.580265) | 02/01/2020 | |||||||||||
3799 | 3799 | 508 RANDOM LANE GAYLORD, MI 49735 | 45.037567 | -84.681404 | 0 | 235350 | MEDILODGE OF GAYLORD | 508 RANDOM LANE | GAYLORD | MI | 49735 | 9897323508 | 680 | Otsego | For profit - Corporation | 106 | 77.9 | Medicare and Medicaid | false | GAYLORD OPCO LLC | 03/06/1978 | false | false | false | false | Both | Yes | 4 | 4 | 4 | 5 | 4 | 3 | 3 | 2.75415 | 1.16326 | 0.87848 | 2.04174 | 4.7959 | 0.02819 | 2.15196 | 0.77436 | 0.61433 | 3.54066 | 2.65992 | 1.12959 | 0.53822 | 4.34349 | 11/20/2019 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 01/09/2019 | 9 | 6 | 4 | 48 | 1 | 0 | 48 | 2017-10-12 | 24 | 16 | 11 | 2 | 196 | 98 | 294 | 65 | 17 | 8 | 1 | 6500.00 | 0 | 1 | 508 RANDOM LANE GAYLORD, MI 49735 (45.037567, -84.681404) | 02/01/2020 | |||||||||||
4157 | 4157 | 3500 WEST SOUTH BLVD ROCHESTER HILLS, MI 48309 | 42.621188 | -83.200174 | 0 | 235477 | POMEROY LIVING ROCHESTER SKILLED REHABILITATION | 3500 WEST SOUTH BLVD | ROCHESTER HILLS | MI | 48309 | 2488527800 | 620 | Oakland | For profit - Limited Liability company | 186 | 124.6 | Medicare and Medicaid | false | SOUTH HILLS LLC | 01/01/1989 | true | true | false | false | Both | Yes | 2 | 1 | 4 | 4 | 4 | 4 | 4 | 1.92804 | 1.55074 | 0.61626 | 2.167 | 4.09504 | 0.04676 | 2.13052 | 0.7062 | 0.31577 | 3.1525 | 1.88081 | 1.65118 | 0.73455 | 4.1654 | 10/10/2019 | 26 | 17 | 9 | 219 | 1 | 0 | 219 | 08/29/2018 | 13 | 10 | 7 | 80 | 1 | 0 | 80 | 2017-06-22 | 15 | 10 | 5 | 1 | 100 | 0 | 100 | 152.833 | 17 | 24 | 3 | 28326.00 | 1 | 4 | 3500 WEST SOUTH BLVD ROCHESTER HILLS, MI 48309 (42.621188, -83.200174) | 02/01/2020 | |||||||||||
4484 | 4484 | 586 EASTERN BLVD CLARKSVILLE, IN 47129 | 38.298604 | -85.761273 | 0 | 155165 | RIVERVIEW VILLAGE | 586 EASTERN BLVD | CLARKSVILLE | IN | 47129 | 8122826663 | 90 | Clark | Non profit - Corporation | 130 | 106.1 | Medicare and Medicaid | false | THE HEALTH AND HOSPITAL CORPORATION OF MARION COUNTY | 03/31/1974 | false | false | false | false | Both | Yes | 1 | 1 | 3 | 5 | 1 | 1 | 1 | 2.1948 | 0.78769 | 0.35957 | 1.14727 | 3.34207 | 0.05719 | 2.25814 | 0.93511 | 0.54283 | 3.73608 | 2.02005 | 0.6334 | 0.24932 | 2.86848 | 10/11/2019 | 20 | 8 | 12 | 167 | 1 | 0 | 167 | 11/19/2018 | 9 | 8 | 4 | 40 | 1 | 0 | 40 | 2017-12-11 | 6 | 4 | 2 | 1 | 16 | 0 | 16 | 99.5 | 17 | 7 | 1 | 6633.00 | 0 | 1 | 586 EASTERN BLVD CLARKSVILLE, IN 47129 (38.298604, -85.761273) | 02/01/2020 | |||||||||||
5062 | 5062 | 1280 MARSHALL STREET CRESCENT CITY, CA 95531 | 41.768545 | -124.200366 | 0 | 56296 | CRESCENT CITY SKILLED NURSING | 1280 MARSHALL STREET | CRESCENT CITY | CA | 95531 | 7074646151 | 70 | Del Norte | For profit - Corporation | 99 | 82.9 | Medicare and Medicaid | false | CRESCENT CITY SKILLED NURSING LLC | 09/14/1971 | false | false | false | false | Resident | Yes | 2 | 2 | 3 | 3 | 3 | 2 | 2 | 2.25765 | 0.92526 | 0.3585 | 1.28376 | 3.54141 | 0.06606 | 1.78215 | 0.70636 | 0.35797 | 2.84647 | 2.63287 | 0.98496 | 0.37695 | 3.98954 | 10/23/2019 | 1 | 0 | 1 | 4 | 0 | 0 | 4 | 10/15/2018 | 15 | 10 | 5 | 116 | 1 | 0 | 116 | 2017-10-06 | 21 | 19 | 2 | 1 | 220 | 0 | 220 | 77.333 | 17 | 6 | 0 | 0.00 | 0 | 0 | 1280 MARSHALL STREET CRESCENT CITY, CA 95531 (41.768545, -124.200366) | 02/01/2020 | |||||||||||
5288 | 5288 | 750 UNION ST BANGOR, ME 04401 | 44.810747 | -68.797252 | 0 | 205105 | WESTGATE CENTER FOR REHAB & ALZHEIMERS CARE | 750 UNION ST | BANGOR | ME | 4401 | 2079427336 | 90 | Penobscot | For profit - Corporation | 65 | 64.1 | Medicare and Medicaid | false | WESTGATE CENTER FOR HEALTH AND REHABILITATION, LLC | 01/01/1993 | false | false | false | false | None | Yes | 4 | 4 | 4 | 4 | 5 | 4 | 4 | 2.64936 | 0.29623 | 0.9207 | 1.21692 | 3.86628 | 0.12845 | 2.24083 | 0.74416 | 0.37727 | 3.36225 | 2.45725 | 0.29932 | 0.91854 | 3.68737 | 12/05/2019 | 1 | 0 | 1 | 8 | 0 | 0 | 8 | 01/16/2019 | 5 | 4 | 1 | 12 | 1 | 0 | 12 | 2017-12-20 | 3 | 3 | 0 | 1 | 12 | 0 | 12 | 10 | 17 | 0 | 0 | 0.00 | 0 | 0 | 750 UNION ST BANGOR, ME 04401 (44.810747, -68.797252) | 02/01/2020 | |||||||||||
6154 | 6154 | 2030 N GAREY AVE POMONA, CA 91767 | 34.083709 | -117.752566 | 0 | 05A134 | LANDMARK MEDICAL CENTER | 2030 N. GAREY AVE. | POMONA | CA | 91767 | 9095932585 | 200 | Los Angeles | For profit - Corporation | 95 | 93.9 | Medicaid | false | Legal Business Name Not Available | 03/31/1974 | false | true | false | false | Resident | Yes | 3 | 2 | 5 | 5 | 2 | 2 | 1 | 2.03403 | 0.70375 | 0.09013 | 0.79388 | 2.82791 | 0 | 1.43196 | 0.52772 | 0.22824 | 2.18793 | 2.95217 | 1.00277 | 0.14862 | 4.14463 | 08/01/2019 | 11 | 8 | 3 | 52 | 1 | 0 | 52 | 07/17/2018 | 9 | 5 | 4 | 56 | 1 | 0 | 56 | 2017-07-28 | 16 | 10 | 7 | 1 | 80 | 0 | 80 | 58 | 17 | 0 | 0 | 0.00 | 0 | 0 | 2030 N GAREY AVE POMONA, CA 91767 (34.083709, -117.752566) | 02/01/2020 | |||||||||||
7303 | 7303 | 6950 FARMINGTON RD WEST BLOOMFIELD, MI 48322 | 42.536324 | -83.380032 | 0 | 235487 | SKLD WEST BLOOMFIELD | 6950 FARMINGTON RD | WEST BLOOMFIELD | MI | 48322 | 2486611700 | 620 | Oakland | For profit - Individual | 140 | 98.4 | Medicare and Medicaid | false | WEST BLOOMFIELD SNF LLC | 05/17/1989 | false | false | false | false | Resident | Yes | 3 | 2 | 4 | 4 | 4 | 4 | 4 | 2.32726 | 1.21588 | 0.78263 | 1.99851 | 4.32577 | 0.30821 | 2.21806 | 0.84909 | 0.40284 | 3.46999 | 2.18065 | 1.07677 | 0.73123 | 3.99749 | 02/27/2019 | 33 | 16 | 18 | 200 | 1 | 0 | 200 | 01/31/2018 | 12 | 10 | 3 | 72 | 1 | 0 | 72 | 2016-12-14 | 26 | 13 | 13 | 1 | 136 | 0 | 136 | 146.667 | 17 | 36 | 1 | 50960.00 | 0 | 1 | 6950 FARMINGTON RD WEST BLOOMFIELD, MI 48322 (42.536324, -83.380032) | 02/01/2020 | |||||||||||
7926 | 7926 | 117 BENNOCH RD ORONO, ME 04473 | 44.89356 | -68.678787 | 0 | 205031 | ORONO COMMONS | 117 BENNOCH RD | ORONO | ME | 4473 | 2078664914 | 90 | Penobscot | For profit - Corporation | 80 | 78.2 | Medicare and Medicaid | false | ORONO OPERATIONS, LLC | 07/01/1969 | false | SFF Candidate | false | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 5 | 3 | 3 | 2.50777 | 0.56153 | 0.64853 | 1.21005 | 3.71782 | 0.06873 | 2.16817 | 0.70888 | 0.34851 | 3.22556 | 2.40386 | 0.59564 | 0.70039 | 3.69604 | 10/09/2019 | 17 | 9 | 9 | 84 | 1 | 0 | 84 | 11/29/2018 | 14 | 10 | 6 | 143 | 1 | 0 | 143 | 2018-05-10 | 18 | 3 | 15 | 1 | 152 | 0 | 152 | 115 | 17 | 12 | 2 | 16024.00 | 0 | 2 | 117 BENNOCH RD ORONO, ME 04473 (44.89356, -68.678787) | 02/01/2020 | ||||||||||
8572 | 8572 | 5430 BOONE AVENUE NORTH NEW HOPE, MN 55428 | 45.051965 | -93.390637 | 0 | 245183 | NORTH RIDGE HEALTH AND REHAB | 5430 BOONE AVENUE NORTH | NEW HOPE | MN | 55428 | 7635923000 | 260 | Hennepin | For profit - Corporation | 320 | 252.9 | Medicare and Medicaid | false | NORTH RIDGE SKILLED, LLC | 05/01/1972 | false | SFF Candidate | false | false | false | Both | Yes | 2 | 1 | 3 | 3 | 3 | 5 | 5 | 2.30446 | 0.73751 | 1.25029 | 1.9878 | 4.29226 | 0.08289 | 2.1729 | 0.79938 | 0.42222 | 3.39449 | 2.20417 | 0.69375 | 1.11456 | 4.05475 | 11/08/2018 | 26 | 18 | 19 | 211 | 2 | 106 | 317 | 02/15/2018 | 30 | 21 | 12 | 204 | 2 | 102 | 306 | 2017-03-03 | 23 | 22 | 2 | 1 | 140 | 0 | 140 | 283.833 | 17 | 27 | 2 | 104083.00 | 2 | 4 | 5430 BOONE AVENUE NORTH NEW HOPE, MN 55428 (45.051965, -93.390637) | 02/01/2020 | ||||||||||
9775 | 9775 | 72201 Country Club Dr, Rancho Mirage, CA 92270, USA | 33.7566127 | -116.4047266 | 1 | ROOFTOP | 555775 | BROOKDALE RANCHO MIRAGE | 72-201 COUNTRY CLUB DRIVE | RANCHO MIRAGE | CA | 92270 | 7603405999 | 430 | Riverside | For profit - Limited Liability company | 45 | 50.4 | Medicare and Medicaid | false | SH OPCO RANCHO MIRAGE LLC | 07/19/2001 | true | false | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 4 | 3 | 3 | 2.04257 | 1.29241 | 0.86166 | 2.15407 | 4.19665 | 0.28972 | 2.28402 | 0.90853 | 0.52183 | 3.71438 | 1.85863 | 1.06966 | 0.6215 | 3.62301 | 04/25/2019 | 20 | 15 | 5 | 128 | 1 | 0 | 128 | 04/27/2018 | 23 | 8 | 17 | 112 | 1 | 0 | 112 | 2017-04-06 | 16 | 6 | 10 | 1 | 76 | 0 | 76 | 114 | 17 | 16 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
9849 | 9849 | 17231 MILL FOREST WEBSTER, TX 77598 | 29.545736 | -95.123383 | 0 | 675848 | FOCUSED CARE AT WEBSTER | 17231 MILL FOREST | WEBSTER | TX | 77598 | 2814885224 | 610 | Harris | For profit - Limited Liability company | 120 | 82 | Medicare and Medicaid | false | FPACP WEBSTER LLC | 10/31/2000 | false | false | false | true | Resident | Yes | 1 | 2 | 3 | 4 | 3 | 1 | 12 | 1 | 12 | 1.6675 | 0.96057 | 0.2577 | 1.21827 | 2.88577 | 0.01592 | 1.96123 | 0.78348 | 0.39352 | 3.13823 | 1.76707 | 0.9219 | 0.24648 | 2.9487 | 07/12/2019 | 17 | 4 | 13 | 100 | 1 | 0 | 100 | 08/24/2018 | 6 | 1 | 5 | 60 | 1 | 0 | 60 | 2017-07-28 | 5 | 2 | 3 | 1 | 28 | 0 | 28 | 74.667 | 17 | 11 | 0 | 0.00 | 2 | 2 | 17231 MILL FOREST WEBSTER, TX 77598 (29.545736, -95.123383) | 02/01/2020 | |||||||||
10826 | 10826 | 741 N MAIN STREET CEDARVILLE, CA 96104 | 41.531931 | -120.171899 | 0 | 555221 | SURPRISE VALLEY COMMUNITY HOSPITAL D/P SNF | 741 N. MAIN STREET | CEDARVILLE | CA | 96104 | 5302796111 | 350 | Modoc | Government - Hospital district | 22 | 16.9 | Medicare and Medicaid | false | Legal Business Name Not Available | 04/15/1986 | false | true | false | false | Resident | Yes | 1 | 1 | 2 | 2 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 07/17/2019 | 25 | 13 | 12 | 132 | 1 | 0 | 132 | 07/26/2018 | 16 | 11 | 5 | 108 | 1 | 0 | 108 | 2017-06-29 | 22 | 19 | 3 | 2 | 164 | 82 | 246 | 143 | 17 | 6 | 1 | 9984.00 | 1 | 2 | 741 N MAIN STREET CEDARVILLE, CA 96104 (41.531931, -120.171899) | 02/01/2020 | |||||||||||||||||||||
11983 | 11983 | 2600 SOUTH MAIN STREET CORONA, CA 92882 | 33.850211 | -117.570241 | 0 | 555566 | CORONA POST ACUTE | 2600 SOUTH MAIN STREET | CORONA | CA | 92882 | 9517364700 | 430 | Riverside | For profit - Limited Liability company | 176 | 166.6 | Medicare and Medicaid | false | CORONA POST ACUTE, LLC | 07/21/1993 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 3 | 4 | 2 | 2 | 2 | 2.35439 | 1.26196 | 0.29901 | 1.56097 | 3.91537 | 0.03959 | 2.09559 | 0.72389 | 0.33643 | 3.15591 | 2.335 | 1.31086 | 0.33452 | 3.97833 | 05/09/2019 | 33 | 10 | 23 | 196 | 1 | 0 | 196 | 05/18/2018 | 47 | 26 | 21 | 323 | 1 | 0 | 323 | 2017-05-01 | 64 | 17 | 54 | 2 | 622 | 311 | 933 | 361.167 | 17 | 49 | 2 | 152272.00 | 1 | 3 | 2600 SOUTH MAIN STREET CORONA, CA 92882 (33.850211, -117.570241) | 02/01/2020 | ||||||||||
12279 | 12279 | 15100 S Prairie Ave, Lawndale, CA 90260, USA | 33.894725 | -118.3433923 | 1 | RANGE_INTERPOLATED | 555816 | LAWNDALE HEALTHCARE & WELLNESS CENTRE LLC | 15100 S PRAIRIE | LAWNDALE | CA | 90260 | 3106793344 | 200 | Los Angeles | For profit - Corporation | 59 | 54.9 | Medicare and Medicaid | false | LAWNDALE HEALTHCARE & WELLNESS CENTRE, LLC | 02/08/2005 | false | false | false | false | Resident | Yes | 3 | 2 | 5 | 5 | 5 | 2 | 2 | 2.45906 | 1.01852 | 0.44162 | 1.46014 | 3.9192 | 0.10188 | 2.14471 | 0.83636 | 0.41511 | 3.39618 | 2.38296 | 0.91572 | 0.40042 | 3.7005 | 08/18/2019 | 11 | 9 | 2 | 52 | 1 | 0 | 52 | 08/29/2018 | 19 | 10 | 9 | 152 | 1 | 0 | 152 | 2017-10-30 | 17 | 10 | 7 | 1 | 88 | 0 | 88 | 91.333 | 17 | 16 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
13171 | 13171 | 81 PROFESSIONAL CENTER PARKWAY SAN RAFAEL, CA 94903 | 38.009888 | -122.538629 | 0 | 555214 | PROFESSIONAL POST ACUTE CENTER | 81 PROFESSIONAL CENTER PARKWAY | SAN RAFAEL | CA | 94903 | 4154795161 | 310 | Marin | For profit - Corporation | 99 | 92.5 | Medicare and Medicaid | false | CF SAN RAFAEL, LLC | 12/12/1985 | false | false | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 4 | 3 | 3 | 2.32249 | 0.75199 | 0.49653 | 1.24851 | 3.571 | 0.04229 | 1.93503 | 0.65958 | 0.28913 | 2.88374 | 2.49449 | 0.85729 | 0.64636 | 3.97088 | 05/01/2019 | 22 | 21 | 3 | 224 | 1 | 0 | 224 | 05/23/2018 | 15 | 8 | 7 | 116 | 1 | 0 | 116 | 2017-05-23 | 9 | 7 | 4 | 1 | 80 | 0 | 80 | 164 | 17 | 16 | 0 | 0.00 | 0 | 0 | 81 PROFESSIONAL CENTER PARKWAY SAN RAFAEL, CA 94903 (38.009888, -122.538629) | 02/01/2020 | |||||||||||
15318 | 15318 | 611 EAST HAMPTON STREET ANDERSON, SC 29624 | 34.495367 | -82.639848 | 0 | 425047 | ELLENBURG NURSING CENTER, INC | 611 EAST HAMPTON STREET | ANDERSON | SC | 29624 | 8642265054 | 30 | Anderson | For profit - Corporation | 181 | 149.9 | Medicare and Medicaid | false | ELLENBURG NURSING CENTER, INC. | 01/01/1970 | false | false | false | false | Both | Yes | 2 | 2 | 2 | 3 | 1 | 3 | 3 | 2.15504 | 1.10191 | 0.45044 | 1.55235 | 3.70739 | 0.01234 | 1.91975 | 0.62473 | 0.26031 | 2.8048 | 2.33306 | 1.32629 | 0.65129 | 4.23858 | 03/28/2019 | 12 | 12 | 4 | 64 | 1 | 0 | 64 | 03/29/2018 | 3 | 3 | 0 | 16 | 1 | 0 | 16 | 2017-01-13 | 4 | 0 | 4 | 0 | 80 | 0 | 80 | 50.667 | 17 | 0 | 2 | 170384.00 | 1 | 3 | 611 EAST HAMPTON STREET ANDERSON, SC 29624 (34.495367, -82.639848) | 02/01/2020 |
Advanced export
JSON shape: default, array, newline-delimited
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 );