nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
6 rows where Abuse Icon = "true" and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-05-25
This data as json, copyable, CSV (advanced)
Suggested facets: ownership, Special Focus Status, 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 Number of Standard Health Deficiencies, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Number of Health Revisits, Rating Cycle 1 Health Revisit Score, Rating Cycle 2 Total Number of Health Deficiencies, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 3 Number of Complaint Health Deficiencies, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
655 | 655 | 1000 DIANA ST LUDINGTON, MI 49431 | 43.95773 | -86.4313 | 0 | 235072 | OAKVIEW MEDICAL CARE FACILITY | 1000 DIANA ST | LUDINGTON | MI | 49431 | 2318455185 | 520 | Mason | Government - County | 96 | 92.4 | Medicare and Medicaid | false | OAKVIEW MEDICAL CARE FACILITY | 01/04/1967 | false | true | false | false | Resident | Yes | 2 | 1 | 3 | 2 | 5 | 5 | 5 | 2.60113 | 0.41127 | 1.19605 | 1.60732 | 4.20845 | 0.05315 | 1.97662 | 0.62117 | 0.27912 | 2.8769 | 2.73498 | 0.49785 | 1.61287 | 4.69083 | 09/27/2019 | 16 | 9 | 7 | 392 | 1 | 0 | 392 | 07/17/2018 | 15 | 11 | 4 | 92 | 1 | 0 | 92 | 2017-05-25 | 13 | 13 | 0 | 1 | 80 | 0 | 80 | 240 | 20 | 0 | 3 | 106524.00 | 1 | 4 | 1000 DIANA ST LUDINGTON, MI 49431 (43.95773, -86.4313) | 02/01/2020 | |||||||||||
6039 | 6039 | 3311 S MICHIGAN AVE CHICAGO, IL 60616 | 41.834371 | -87.623323 | 0 | 146161 | SOUTHVIEW MANOR | 3311 S. MICHIGAN AVE. | CHICAGO | IL | 60616 | 3123269101 | 141 | Cook | For profit - Individual | 200 | 186.6 | Medicare and Medicaid | false | Legal Business Name Not Available | 06/02/2013 | false | true | false | false | Resident | Yes | 2 | 2 | 5 | 5 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 04/18/2019 | 6 | 1 | 6 | 115 | 1 | 0 | 115 | 06/21/2018 | 11 | 7 | 5 | 64 | 1 | 0 | 64 | 2017-05-25 | 12 | 7 | 7 | 1 | 88 | 0 | 88 | 93.5 | 2 | 37 | 0 | 0.00 | 0 | 0 | 3311 S MICHIGAN AVE CHICAGO, IL 60616 (41.834371, -87.623323) | 02/01/2020 | |||||||||||||||||||||
8977 | 8977 | 2400 SAMISH WAY BELLINGHAM, WA 98225 | 48.709579 | -122.464023 | 0 | 505140 | HIGHLAND HEALTH AND REHABILITATION | 2400 SAMISH WAY | BELLINGHAM | WA | 98225 | 3607344800 | 360 | Whatcom | For profit - Limited Liability company | 44 | 40.5 | Medicare and Medicaid | false | EMPRES HIGHLAND CARE LLC | 05/31/1972 | false | true | false | false | Resident | Yes | 2 | 1 | 3 | 3 | 4 | 4 | 4 | 2.08657 | 0.66463 | 0.80762 | 1.47225 | 3.55883 | 0.01722 | 2.03686 | 0.68135 | 0.30734 | 3.02555 | 2.12906 | 0.73349 | 0.98906 | 3.77185 | 09/16/2019 | 29 | 22 | 9 | 176 | 1 | 0 | 176 | 07/31/2018 | 28 | 15 | 15 | 297 | 1 | 0 | 297 | 2017-05-25 | 28 | 25 | 24 | 1 | 618 | 0 | 618 | 290 | 18 | 7 | 3 | 169260.00 | 0 | 3 | 2400 SAMISH WAY BELLINGHAM, WA 98225 (48.709579, -122.464023) | 02/01/2020 | |||||||||||
12466 | 12466 | 5225 SOUTH J ST OXNARD, CA 93033 | 34.152845 | -119.186144 | 0 | 555163 | SHORELINE CARE CENTER | 5225 SOUTH J ST | OXNARD | CA | 93033 | 8054883696 | 660 | Ventura | For profit - Corporation | 193 | 169.3 | Medicare and Medicaid | false | COVENANT CARE CALIFORNIA, LLC | 01/30/1984 | false | true | false | false | Resident | Yes | 4 | 2 | 5 | 5 | 4 | 4 | 4 | 2.37045 | 0.60417 | 0.68661 | 1.29078 | 3.66122 | 0.03019 | 2.06459 | 0.65544 | 0.27458 | 2.99461 | 2.38623 | 0.69312 | 0.94117 | 3.92047 | 05/09/2019 | 10 | 3 | 7 | 56 | 1 | 0 | 56 | 05/09/2018 | 11 | 8 | 3 | 44 | 1 | 0 | 44 | 2017-05-25 | 6 | 5 | 1 | 1 | 28 | 0 | 28 | 47.333 | 3 | 8 | 0 | 0.00 | 0 | 0 | 5225 SOUTH J ST OXNARD, CA 93033 (34.152845, -119.186144) | 02/01/2020 | |||||||||||
14215 | 14215 | 457 N MAIN ST LA GRANGE, TX 78945 | 29.907875 | -96.881058 | 0 | 675277 | CARE INN OF LA GRANGE | 457 N MAIN ST | LA GRANGE | TX | 78945 | 9799685865 | 511 | Fayette | For profit - Limited Liability company | 98 | 51.8 | Medicare and Medicaid | false | OAKBEND MEDICAL CENTER | 02/14/1994 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 4 | 3 | 5 | 2 | 2 | 1.91796 | 0.9516 | 0.40208 | 1.35368 | 3.27164 | 0.10568 | 1.89181 | 0.8325 | 0.44374 | 3.16805 | 2.10707 | 0.85952 | 0.34105 | 3.31151 | 08/05/2019 | 23 | 22 | 1 | 361 | 2 | 181 | 542 | 06/29/2018 | 10 | 10 | 10 | 52 | 1 | 0 | 52 | 2017-05-25 | 3 | 2 | 1 | 1 | 16 | 0 | 16 | 291 | 0 | 1 | 0 | 0.00 | 1 | 1 | 457 N MAIN ST LA GRANGE, TX 78945 (29.907875, -96.881058) | 02/01/2020 | ||||||||||
14912 | 14912 | 349 VOTECH DRIVE JOHNSTOWN, PA 15904 | 40.277516 | -78.834838 | 0 | 395610 | RICHLAND HEALTHCARE AND REHABILITATION CENTER | 349 VOTECH DRIVE | JOHNSTOWN | PA | 15904 | 8142669702 | 160 | Cambria | For profit - Corporation | 97 | 85.7 | Medicare and Medicaid | false | GUARDIAN ELDER CARE AT JOHNSTOWN LLC | 10/03/1983 | false | true | false | false | Resident | Yes | 2 | 2 | 3 | 3 | 3 | 2 | 3 | 1.87972 | 0.70214 | 0.66627 | 1.36841 | 3.24813 | 0.11316 | 2.38296 | 0.86512 | 0.44712 | 3.6952 | 1.63943 | 0.61028 | 0.56087 | 2.8187 | 05/17/2019 | 12 | 9 | 3 | 72 | 1 | 0 | 72 | 04/27/2018 | 14 | 9 | 5 | 68 | 1 | 0 | 68 | 2017-05-25 | 9 | 9 | 0 | 1 | 52 | 0 | 52 | 67.333 | 1 | 3 | 0 | 0.00 | 0 | 0 | 349 VOTECH DRIVE JOHNSTOWN, PA 15904 (40.277516, -78.834838) | 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 );