nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
10 rows where Health Inspection Rating = 3 and Rating Cycle 1 Number of Complaint Health Deficiencies = 10
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, ownership, Continuing Care Retirement Community, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, Overall Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Staffing Rating, RN Staffing Rating, Rating Cycle 1 Total Number of Health Deficiencies, Rating Cycle 1 Number of Standard Health Deficiencies, Rating Cycle 1 Health Deficiency Score, Rating Cycle 1 Number of Health Revisits, 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 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 Health Deficiency 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
844 | 844 | 8170 MURRAY AVENUE GILROY, CA 95020 | 37.017884 | -121.567101 | 0 | 55797 | GILROY HEALTHCARE AND REHABILITATION CENTER | 8170 MURRAY AVENUE | GILROY | CA | 95020 | 4088429311 | 530 | Santa Clara | For profit - Corporation | 134 | 128.7 | Medicare and Medicaid | false | COVENANT CARE CALIFORNIA, LLC | 06/01/1969 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 5 | 5 | 3 | 3 | 2.54125 | 0.75083 | 0.46538 | 1.21621 | 3.75747 | 0.08782 | 2.04644 | 0.69202 | 0.32175 | 3.0602 | 2.58087 | 0.81585 | 0.5444 | 3.93729 | 11/15/2019 | 17 | 7 | 10 | 72 | 1 | 0 | 72 | 10/12/2018 | 11 | 9 | 2 | 68 | 1 | 0 | 68 | 2017-10-05 | 10 | 6 | 4 | 1 | 48 | 0 | 48 | 66.667 | 8 | 8 | 1 | 8125.00 | 0 | 1 | 8170 MURRAY AVENUE GILROY, CA 95020 (37.017884, -121.567101) | 02/01/2020 | |||||||||||
3155 | 3155 | 31830 RYAN RD WARREN, MI 48092 | 42.526367 | -83.068144 | 0 | 235408 | ST ANTHONY HEALTHCARE CENTER | 31830 RYAN RD | WARREN | MI | 48092 | 5869776700 | 490 | Macomb | For profit - Corporation | 142 | 138.9 | Medicare and Medicaid | false | ST ANTHONY ACQUISITION COMPANY INC | 08/01/1980 | false | false | false | false | Resident | Yes | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 2.25044 | 1.12494 | 0.5322 | 1.65714 | 3.90759 | 0.15646 | 2.13566 | 0.77816 | 0.38343 | 3.29725 | 2.19004 | 1.08704 | 0.52243 | 3.80023 | 03/13/2019 | 17 | 7 | 10 | 112 | 1 | 0 | 112 | 12/13/2017 | 12 | 12 | 0 | 72 | 1 | 0 | 72 | 2016-11-03 | 10 | 8 | 2 | 1 | 80 | 0 | 80 | 93.333 | 4 | 17 | 0 | 0.00 | 0 | 0 | 31830 RYAN RD WARREN, MI 48092 (42.526367, -83.068144) | 02/01/2020 | |||||||||||
8027 | 8027 | 14141 PENNSYLVANIA RIVERVIEW, MI 48193 | 42.184775 | -83.196206 | 0 | 235516 | RIVERGATE TERRACE | 14141 PENNSYLVANIA | RIVERVIEW | MI | 48193 | 7342848000 | 810 | Wayne | For profit - Corporation | 288 | 249.9 | Medicare and Medicaid | false | RIVERVIEW MEDICAL INVESTORS LIMITED PARTNERSHIP | 05/01/1992 | false | false | false | false | Resident | Yes | 3 | 3 | 4 | 4 | 3 | 2 | 2 | 1.87024 | 1.11817 | 0.36497 | 1.48315 | 3.35338 | 0.05824 | 2.03173 | 0.68205 | 0.30613 | 3.01991 | 1.91314 | 1.23276 | 0.44873 | 3.56076 | 09/26/2019 | 13 | 9 | 10 | 108 | 1 | 0 | 108 | 10/31/2018 | 6 | 6 | 1 | 60 | 1 | 0 | 60 | 2017-08-03 | 11 | 6 | 5 | 1 | 48 | 0 | 48 | 82 | 5 | 25 | 0 | 0.00 | 0 | 0 | 14141 PENNSYLVANIA RIVERVIEW, MI 48193 (42.184775, -83.196206) | 02/01/2020 | |||||||||||
9638 | 9638 | 148 HOOD STREET OREGON CITY, OR 97045 | 45.338895 | -122.603436 | 0 | 385245 | OREGON CITY HEALTH CARE CENTER | 148 HOOD STREET | OREGON CITY | OR | 97045 | 5036564035 | 20 | Clackamas | For profit - Corporation | 53 | 32.7 | Medicare and Medicaid | false | CARE CENTER (OREGON CITY), INC. | 06/22/1994 | false | false | false | false | Resident | Yes | 4 | 3 | 3 | 5 | 2 | 4 | 3 | 2.59361 | 1.23149 | 0.62691 | 1.8584 | 4.45201 | 0.02805 | 2.02939 | 0.71655 | 0.35029 | 3.09623 | 2.65616 | 1.29232 | 0.67362 | 4.6108 | 01/07/2020 | 11 | 1 | 10 | 44 | 0 | 0 | 44 | 03/30/2018 | 11 | 5 | 6 | 60 | 1 | 0 | 60 | 2017-02-13 | 13 | 12 | 13 | 1 | 72 | 0 | 72 | 54 | 1 | 9 | 0 | 0.00 | 0 | 0 | 148 HOOD STREET OREGON CITY, OR 97045 (45.338895, -122.603436) | 02/01/2020 | |||||||||||
10784 | 10784 | 401 W ARBROOK BLVD ARLINGTON, TX 76014 | 32.684773 | -97.111153 | 0 | 675930 | ARBROOK PLAZA | 401 W ARBROOK BLVD | ARLINGTON | TX | 76014 | 8174663094 | 910 | Tarrant | For profit - Corporation | 120 | 101.1 | Medicare and Medicaid | false | HAMILTON COUNTY HOSPITAL DISTRICT | 09/06/2002 | false | false | false | true | Resident | Yes | 3 | 3 | 5 | 5 | 5 | 1 | 1 | 1.69418 | 0.86621 | 0.28437 | 1.15059 | 2.84477 | 0.05837 | 1.99439 | 0.81729 | 0.42977 | 3.24144 | 1.76549 | 0.79696 | 0.24905 | 2.81424 | 02/14/2019 | 10 | 7 | 10 | 64 | 1 | 0 | 64 | 01/26/2018 | 4 | 0 | 4 | 20 | 0 | 0 | 20 | 2017-01-20 | 3 | 3 | 0 | 1 | 40 | 0 | 40 | 45.333 | 1 | 2 | 0 | 0.00 | 0 | 0 | 401 W ARBROOK BLVD ARLINGTON, TX 76014 (32.684773, -97.111153) | 02/01/2020 | |||||||||||
11023 | 11023 | 330 W CAMP WISDOM RD DUNCANVILLE, TX 75116 | 32.661735 | -96.913213 | 0 | 675806 | THE LAURENWOOD NURSING AND REHABILITATION | 330 W CAMP WISDOM RD | DUNCANVILLE | TX | 75116 | 9722983398 | 390 | Dallas | For profit - Corporation | 103 | 72.9 | Medicare and Medicaid | false | DUNCANVILLE NURSING, LTD | 08/26/1999 | false | false | false | false | Resident | Yes | 2 | 3 | 2 | 2 | 3 | 1 | 1 | 1.78952 | 1.17788 | 0.29265 | 1.47053 | 3.26004 | 0.15333 | 2.16785 | 0.82906 | 0.43229 | 3.4292 | 1.71563 | 1.06831 | 0.2548 | 3.04848 | 08/22/2019 | 10 | 7 | 10 | 52 | 1 | 0 | 52 | 10/05/2018 | 9 | 8 | 2 | 64 | 1 | 0 | 64 | 2017-09-14 | 4 | 3 | 1 | 1 | 44 | 0 | 44 | 54.667 | 2 | 3 | 1 | 3641.00 | 0 | 1 | 330 W CAMP WISDOM RD DUNCANVILLE, TX 75116 (32.661735, -96.913213) | 02/01/2020 | |||||||||||
11373 | 11373 | 4300 WEST HOUSTON BROKEN ARROW, OK 74012 | 36.046326 | -95.842854 | 0 | 375392 | FOREST HILLS CARE AND REHABILITATION CENTER | 4300 WEST HOUSTON | BROKEN ARROW | OK | 74012 | 9182545000 | 710 | Tulsa | For profit - Corporation | 159 | 88.6 | Medicare and Medicaid | false | FOREST HILLS HEALTH CARE | 02/20/2001 | false | false | false | false | Both | Yes | 3 | 3 | 4 | 4 | 4 | 2 | 1 | 2.50056 | 1.14011 | 0.21646 | 1.35657 | 3.85713 | 0.07323 | 2.10079 | 0.79887 | 0.41938 | 3.31904 | 2.47383 | 1.07313 | 0.19427 | 3.72653 | 08/14/2019 | 10 | 0 | 10 | 72 | 1 | 0 | 72 | 06/12/2018 | 1 | 1 | 0 | 8 | 1 | 0 | 8 | 2017-02-15 | 16 | 16 | 16 | 1 | 116 | 0 | 116 | 58 | 0 | 8 | 1 | 5278.00 | 0 | 1 | 4300 WEST HOUSTON BROKEN ARROW, OK 74012 (36.046326, -95.842854) | 02/01/2020 | |||||||||||
12853 | 12853 | 1 LONGSDORF WAY CARLISLE, PA 17013 | 40.177533 | -77.198015 | 0 | 395876 | CUMBERLAND CROSSINGS RETIREMENT COMMUNITY | 1 LONGSDORF WAY | CARLISLE | PA | 17013 | 7172459941 | 270 | Cumberland | Non profit - Corporation | 58 | 53.5 | Medicare and Medicaid | false | DIAKON LUTHERAN SOCIAL MINISTRIES | 05/08/1992 | true | false | false | false | Resident | Yes | 4 | 3 | 5 | 5 | 5 | 3 | 4 | 1.83952 | 0.7162 | 0.92578 | 1.64198 | 3.4815 | 0.11296 | 2.25242 | 0.8216 | 0.39655 | 3.47057 | 1.69735 | 0.65548 | 0.87869 | 3.21676 | 11/14/2019 | 10 | 7 | 10 | 44 | 1 | 0 | 44 | 12/06/2018 | 10 | 7 | 3 | 36 | 1 | 0 | 36 | 2017-11-09 | 6 | 5 | 1 | 1 | 28 | 0 | 28 | 38.667 | 0 | 3 | 0 | 0.00 | 0 | 0 | 1 LONGSDORF WAY CARLISLE, PA 17013 (40.177533, -77.198015) | 02/01/2020 | |||||||||||
15186 | 15186 | 745 NE 122ND AVENUE PORTLAND, OR 97230 | 45.527833 | -122.537726 | 0 | 385044 | PRESTIGE CARE AND REHABILITATION - MENLO PARK | 745 NE 122ND AVENUE | PORTLAND | OR | 97230 | 5032520241 | 250 | Multnomah | For profit - Corporation | 83 | 69.3 | Medicare and Medicaid | false | CARE CENTER MENLO PARK INC | 01/01/1967 | false | false | false | false | Resident | Yes | 4 | 3 | 4 | 4 | 4 | 4 | 3 | 2.32674 | 0.88834 | 0.59894 | 1.48728 | 3.81402 | 0.06588 | 1.73441 | 0.65757 | 0.31823 | 2.7102 | 2.78813 | 1.01583 | 0.7084 | 4.51268 | 07/01/2019 | 10 | 8 | 10 | 56 | 1 | 0 | 56 | 10/09/2017 | 22 | 9 | 22 | 96 | 1 | 0 | 96 | 2016-08-12 | 13 | 9 | 4 | 1 | 64 | 0 | 64 | 70.667 | 1 | 13 | 1 | 8775.00 | 0 | 1 | 745 NE 122ND AVENUE PORTLAND, OR 97230 (45.527833, -122.537726) | 02/01/2020 | |||||||||||
15290 | 15290 | 901 I-30, Royse City, TX 75189, USA | 32.9603544 | -96.34324170000001 | 1 | ROOFTOP | 676217 | ROYSE CITY MEDICAL LODGE | 901 W INTERSTATE 30 | ROYSE CITY | TX | 75189 | 9726369100 | 879 | Rockwall | For profit - Corporation | 124 | 102.9 | Medicare and Medicaid | false | PMG OPCO-ROYSE CITY LLC | 04/15/2009 | false | false | false | false | Resident | Yes | 2 | 3 | 3 | 5 | 2 | 1 | 1 | 1.92457 | 0.9651 | 0.18954 | 1.15464 | 3.0792 | 0.03111 | 2.28556 | 0.86331 | 0.43844 | 3.58731 | 1.75007 | 0.8406 | 0.16271 | 2.75247 | 04/04/2019 | 10 | 10 | 10 | 80 | 1 | 0 | 80 | 04/05/2018 | 6 | 6 | 1 | 32 | 1 | 0 | 32 | 2017-02-08 | 5 | 4 | 1 | 1 | 60 | 0 | 60 | 60.667 | 1 | 0 | 1 | 6893.00 | 0 | 1 | 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 );