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 2016-10-13
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, nmbr_beds, Special Focus Status, With a Resident and Family Council, Overall Rating, Health Inspection 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 Number of Complaint Health Deficiencies, Rating Cycle 1 Number of Health Revisits, Rating Cycle 1 Health Revisit Score, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 3 Total Number of Health Deficiencies, Rating Cycle 3 Number of Standard Health Deficiencies, Rating Cycle 3 Number of Complaint Health Deficiencies, Number of Facility Reported Incidents, Number of Substantiated Complaints, Number of Fines, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4203 | 4203 | 1010 VARNUM AVENUE LOWELL, MA 01854 | 42.643744 | -71.365962 | 0 | 225298 | NORTHWOOD REHABILITATION & HEALTHCARE CENTER | 1010 VARNUM AVENUE | LOWELL | MA | 1854 | 9784588773 | 90 | Middlesex | For profit - Corporation | 123 | 115.6 | Medicare and Medicaid | false | NORTHWOOD MA SNF LLC | 02/17/1987 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 4 | 4 | 4 | 2 | 2 | 2.47232 | 0.87884 | 0.45843 | 1.33727 | 3.80959 | 0.14221 | 2.08245 | 0.72888 | 0.35342 | 3.16475 | 2.46743 | 0.90665 | 0.48821 | 3.86004 | 02/07/2019 | 10 | 7 | 3 | 80 | 1 | 0 | 80 | 12/07/2017 | 13 | 8 | 5 | 589 | 1 | 0 | 589 | 2016-10-13 | 4 | 2 | 2 | 1 | 20 | 0 | 20 | 239.667 | 3 | 0 | 3 | 128136.00 | 0 | 3 | 1010 VARNUM AVENUE LOWELL, MA 01854 (42.643744, -71.365962) | 02/01/2020 | ||||||||||
5496 | 5496 | 400 SOUTH CRAPO ST MOUNT PLEASANT, MI 48858 | 43.601259 | -84.757615 | 0 | 235385 | LAURELS OF MT. PLEASANT (THE) | 400 SOUTH CRAPO ST | MOUNT PLEASANT | MI | 48858 | 9897735918 | 360 | Isabella | For profit - Corporation | 112 | 84.1 | Medicare and Medicaid | false | LAUREL HEALTH CARE COMPANY OF MT PLEASANT | 01/01/1979 | false | true | false | false | Resident | Yes | 1 | 1 | 4 | 4 | 5 | 3 | 3 | 2.03163 | 0.64305 | 0.65263 | 1.29568 | 3.32731 | 0.0665 | 2.07899 | 0.76802 | 0.37395 | 3.22097 | 2.03099 | 0.62958 | 0.65687 | 3.31254 | 12/20/2018 | 43 | 11 | 35 | 264 | 1 | 0 | 264 | 10/05/2017 | 20 | 6 | 15 | 104 | 1 | 0 | 104 | 2016-10-13 | 8 | 5 | 4 | 1 | 147 | 0 | 147 | 191.167 | 49 | 19 | 2 | 120886.00 | 1 | 3 | 400 SOUTH CRAPO ST MOUNT PLEASANT, MI 48858 (43.601259, -84.757615) | 02/01/2020 | |||||||||||
9074 | 9074 | 8 NORTH TEXAS AVENUE GREENVILLE, SC 29611 | 34.836764 | -82.4401 | 0 | 425102 | POINSETT REHABILITATION AND HEALTHCARE CENTER | 8 NORTH TEXAS AVENUE | GREENVILLE | SC | 29611 | 8642951331 | 220 | Greenville | For profit - Corporation | 132 | 122.5 | Medicare and Medicaid | false | Legal Business Name Not Available | 09/02/1975 | false | true | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 3 | 3 | 2.52566 | 0.9754 | 0.45709 | 1.43249 | 3.95815 | 0.0184 | 1.95156 | 0.68125 | 0.31184 | 2.94464 | 2.68973 | 1.07662 | 0.55171 | 4.31035 | 02/14/2019 | 8 | 8 | 0 | 100 | 2 | 50 | 150 | 02/01/2018 | 10 | 9 | 1 | 44 | 1 | 0 | 44 | 2016-10-13 | 8 | 8 | 0 | 1 | 44 | 0 | 44 | 97 | 0 | 1 | 3 | 35321.00 | 1 | 4 | 8 NORTH TEXAS AVENUE GREENVILLE, SC 29611 (34.836764, -82.4401) | 02/01/2020 | |||||||||||
10917 | 10917 | 401 WITSELL STREET WALTERBORO, SC 29488 | 32.908717 | -80.657955 | 0 | 425053 | PRUITTHEALTH-WALTERBORO | 401 WITSELL STREET | WALTERBORO | SC | 29488 | 8435495546 | 140 | Colleton | For profit - Corporation | 132 | 120.5 | Medicare and Medicaid | false | PRUITTHEALTH-WALTERBORO LLC | 01/01/1981 | false | true | false | false | Resident | Yes | 2 | 2 | 3 | 1 | 4 | 2 | 2 | 2.27071 | 0.73309 | 0.3932 | 1.12629 | 3.397 | 0.02912 | 2.08032 | 0.70618 | 0.31334 | 3.09983 | 2.26855 | 0.7806 | 0.47232 | 3.51407 | 01/11/2019 | 14 | 14 | 0 | 60 | 1 | 0 | 60 | 11/02/2017 | 21 | 21 | 0 | 112 | 1 | 0 | 112 | 2016-10-13 | 4 | 2 | 2 | 1 | 16 | 0 | 16 | 70 | 0 | 0 | 0 | 0.00 | 0 | 0 | 401 WITSELL STREET WALTERBORO, SC 29488 (32.908717, -80.657955) | 02/01/2020 | |||||||||||
11485 | 11485 | 959 SOUTHWEST 107TH STREET OKLAHOMA CITY, OK 73139 | 35.359806 | -97.532177 | 0 | 375256 | MEADOWLAKE ESTATES | 959 SOUTHWEST 107TH STREET | OKLAHOMA CITY | OK | 73139 | 4057033400 | 130 | Cleveland | For profit - Corporation | 124 | 105.1 | Medicare and Medicaid | false | CITY OF PAULS VALLEY | 04/26/1996 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 2 | 3 | 1 | 2 | 1 | 2.14567 | 0.96977 | 0.25102 | 1.22079 | 3.36646 | 0.01241 | 1.86119 | 0.67885 | 0.32418 | 2.86422 | 2.39601 | 1.07418 | 0.29145 | 3.76896 | 03/06/2019 | 41 | 16 | 25 | 364 | 1 | 0 | 364 | 01/24/2018 | 18 | 5 | 17 | 160 | 1 | 0 | 160 | 2016-10-13 | 9 | 7 | 2 | 1 | 60 | 0 | 60 | 245.333 | 0 | 41 | 2 | 24053.00 | 3 | 5 | 959 SOUTHWEST 107TH STREET OKLAHOMA CITY, OK 73139 (35.359806, -97.532177) | 02/01/2020 | ||||||||||
15236 | 15236 | 2044 PAGELAND HWY LANCASTER, SC 29720 | 34.721319 | -80.719445 | 0 | 425155 | LANCASTER CONVALESCENT CENTER | 2044 PAGELAND HWY | LANCASTER | SC | 29720 | 8032857907 | 280 | Lancaster | For profit - Corporation | 142 | 136.9 | Medicare and Medicaid | false | LANCASTER HEALTH CARE LLC | 02/24/1986 | false | true | false | false | Both | Yes | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2.237 | 0.87937 | 0.41723 | 1.2966 | 3.5336 | 0.05154 | 2.08015 | 0.69311 | 0.30793 | 3.08119 | 2.23505 | 0.95401 | 0.50999 | 3.6775 | 02/01/2019 | 8 | 8 | 0 | 88 | 1 | 0 | 88 | 01/13/2018 | 12 | 12 | 0 | 56 | 1 | 0 | 56 | 2016-10-13 | 11 | 11 | 0 | 1 | 56 | 0 | 56 | 72 | 0 | 0 | 1 | 13905.00 | 0 | 1 | 2044 PAGELAND HWY LANCASTER, SC 29720 (34.721319, -80.719445) | 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 );