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-08-02
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, prvdr_cnty, ownership, Provider Resides in Hospital, 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, RN Staffing Rating, Rating Cycle 1 Total Number of Health Deficiencies, Rating Cycle 1 Number of Health Revisits, 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 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, Total Weighted Health Survey Score, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1962 | 1962 | 521 LOREL WAY YUBA CITY, CA 95991 | 39.155087 | -121.620613 | 0 | 56346 | BRIDGEVIEW POST ACUTE | 521 LOREL WAY | YUBA CITY | CA | 95991 | 5306749140 | 610 | Sutter | For profit - Limited Liability company | 130 | 105.8 | Medicare and Medicaid | false | HANALEI HOLDINGS LLC | 08/31/1972 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 4 | 5 | 3 | 3 | 3 | 2.437 | 0.73353 | 0.52445 | 1.25798 | 3.69497 | 0.09003 | 1.95085 | 0.70678 | 0.31623 | 2.97386 | 2.59626 | 0.7804 | 0.62421 | 3.98423 | 10/16/2019 | 13 | 8 | 5 | 52 | 1 | 0 | 52 | 09/05/2018 | 32 | 27 | 11 | 426 | 2 | 213 | 639 | 2017-08-02 | 18 | 11 | 7 | 1 | 88 | 0 | 88 | 253.667 | 25 | 5 | 0 | 0.00 | 1 | 1 | 521 LOREL WAY YUBA CITY, CA 95991 (39.155087, -121.620613) | 02/01/2020 | ||||||||||
2664 | 2664 | 920 S CHELTON RD COLORADO SPRINGS, CO 80910 | 38.819187 | -104.767812 | 0 | 65246 | LAUREL MANOR CARE CENTER, INC | 920 S CHELTON RD | COLORADO SPRINGS | CO | 80910 | 7194737780 | 200 | El Paso | Non profit - Corporation | 81 | 71.8 | Medicare and Medicaid | false | VOLUNTEERS OF AMERICA CARE FACILITIES | 03/01/1989 | false | true | false | false | Resident | Yes | 3 | 2 | 3 | 3 | 2 | 5 | 5 | 2.31499 | 0.82941 | 0.88765 | 1.71706 | 4.03205 | 0.02549 | 2.09865 | 0.66149 | 0.28799 | 3.04813 | 2.29258 | 0.94282 | 1.16011 | 4.24176 | 12/19/2019 | 9 | 6 | 3 | 92 | 0 | 0 | 92 | 01/10/2019 | 11 | 11 | 1 | 64 | 1 | 0 | 64 | 2017-08-02 | 5 | 5 | 0 | 1 | 32 | 0 | 32 | 72.667 | 0 | 2 | 1 | 7433.00 | 0 | 1 | 920 S CHELTON RD COLORADO SPRINGS, CO 80910 (38.819187, -104.767812) | 02/01/2020 | |||||||||||
4163 | 4163 | 18525 WOODLAND RIDGE DRIVE SPRING LAKE, MI 49456 | 43.093319 | -86.239029 | 0 | 235373 | NORTH OTTAWA CARE CENTER | 18525 WOODLAND RIDGE DRIVE | SPRING LAKE | MI | 49456 | 6168420770 | 690 | Ottawa | Non profit - Corporation | 84 | 67.2 | Medicare and Medicaid | true | NORTH OTTAWA CARE CENTER INC | 08/01/1978 | false | true | false | false | Resident | Yes | 2 | 1 | 3 | 2 | 4 | 4 | 3 | 2.95184 | 0.79332 | 0.52288 | 1.31619 | 4.26804 | 0.05068 | 2.07204 | 0.69536 | 0.30424 | 3.07164 | 2.96082 | 0.85787 | 0.64686 | 4.45565 | 10/24/2019 | 16 | 7 | 9 | 505 | 1 | 0 | 505 | 10/10/2018 | 11 | 10 | 1 | 60 | 1 | 0 | 60 | 2017-08-02 | 9 | 9 | 0 | 1 | 76 | 0 | 76 | 285.167 | 9 | 4 | 1 | 8775.00 | 1 | 2 | 18525 WOODLAND RIDGE DRIVE SPRING LAKE, MI 49456 (43.093319, -86.239029) | 02/01/2020 | |||||||||||
5458 | 5458 | 9500 GRAND RIVER AVE DETROIT, MI 48204 | 42.366698 | -83.134 | 0 | 235234 | HERITAGE MANOR NURSING AND REHAB CENTER | 9500 GRAND RIVER AVE | DETROIT | MI | 48204 | 3134917920 | 810 | Wayne | For profit - Corporation | 122 | 90.4 | Medicare and Medicaid | false | HERITAGE MANOR NURSING & REHAB CENTER | 10/01/1974 | false | true | false | false | Resident | Yes | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 1.67816 | 1.0695 | 0.26037 | 1.32987 | 3.00803 | 0.03713 | 1.72021 | 0.62567 | 0.27584 | 2.62173 | 2.02752 | 1.28534 | 0.35527 | 3.67915 | 09/20/2019 | 29 | 24 | 6 | 465 | 1 | 0 | 465 | 10/24/2018 | 13 | 10 | 3 | 84 | 1 | 0 | 84 | 2017-08-02 | 19 | 16 | 7 | 2 | 120 | 60 | 180 | 290.5 | 4 | 16 | 0 | 0.00 | 1 | 1 | 9500 GRAND RIVER AVE DETROIT, MI 48204 (42.366698, -83.134) | 02/01/2020 | |||||||||||
6379 | 6379 | 4465 W 48TH ST FREMONT, MI 49412 | 43.467021 | -85.911905 | 0 | 235076 | NEWAYGO CO MEDICAL CARE FACILI | 4465 W 48TH ST | FREMONT | MI | 49412 | 2319242020 | 610 | Newaygo | Government - County | 116 | 91.7 | Medicare and Medicaid | false | NEWAYGO MEDICAL CARE FACILITY | 01/01/1967 | false | true | false | false | Resident | Yes | 4 | 2 | 5 | 5 | 5 | 5 | 5 | 2.71943 | 0.55328 | 0.89172 | 1.44501 | 4.16444 | 0.01443 | 2.11457 | 0.67052 | 0.295 | 3.08009 | 2.67283 | 0.62047 | 1.13773 | 4.33556 | 10/18/2019 | 13 | 12 | 1 | 104 | 1 | 0 | 104 | 08/29/2018 | 4 | 4 | 0 | 44 | 1 | 0 | 44 | 2017-08-02 | 7 | 7 | 0 | 1 | 36 | 0 | 36 | 72.667 | 1 | 0 | 0 | 0.00 | 0 | 0 | 4465 W 48TH ST FREMONT, MI 49412 (43.467021, -85.911905) | 02/01/2020 | |||||||||||
10905 | 10905 | 21400 72ND AVENUE WEST EDMONDS, WA 98026 | 47.804558 | -122.330144 | 0 | 505236 | ALDERCREST HEALTH & REHAB CENTER | 21400 72ND AVENUE WEST | EDMONDS | WA | 98026 | 4257751961 | 300 | Snohomish | For profit - Corporation | 128 | 86 | Medicare and Medicaid | false | ALDERCREST HEALTH - EDMONDS, LLC | 08/01/1977 | false | true | false | false | Resident | Yes | 1 | 1 | 2 | 2 | 2 | 3 | 3 | 1.59608 | 1.16099 | 0.63838 | 1.79937 | 3.39545 | 0.02935 | 2.1984 | 0.75566 | 0.36009 | 3.31415 | 1.50891 | 1.15528 | 0.66726 | 3.28532 | 09/13/2019 | 40 | 25 | 16 | 280 | 1 | 0 | 280 | 07/19/2018 | 27 | 20 | 9 | 180 | 2 | 90 | 270 | 2017-08-02 | 26 | 16 | 13 | 1 | 208 | 0 | 208 | 264.667 | 14 | 37 | 5 | 130469.00 | 0 | 5 | 21400 72ND AVENUE WEST EDMONDS, WA 98026 (47.804558, -122.330144) | 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 );