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-12-01
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, ownership, Special Focus Status, Provider Changed Ownership in Last 12 Months, Overall Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, 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 Number of Standard 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 Complaint Health Deficiencies, Number of Facility Reported Incidents, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2498 | 2498 | 1005 E CENTENNIAL DRIVE PITTSBURG, KS 66762 | 37.381788 | -94.688739 | 0 | 175208 | PITTSBURG OPERATOR LLC | 1005 E CENTENNIAL DRIVE | PITTSBURG | KS | 66762 | 6202311120 | 180 | Crawford | Government - State | 86 | 63.2 | Medicare and Medicaid | false | PITTSBURG OPERATOR, LLC | 05/15/1991 | false | true | false | true | Resident | Yes | 1 | 1 | 3 | 2 | 5 | 3 | 3 | 2.59714 | 0.4351 | 0.64413 | 1.07922 | 3.67636 | 0 | 1.85742 | 0.69344 | 0.33425 | 2.88511 | 2.90603 | 0.47181 | 0.72532 | 4.08611 | 08/05/2019 | 20 | 15 | 19 | 160 | 1 | 0 | 160 | 09/27/2018 | 28 | 22 | 13 | 192 | 1 | 0 | 192 | 2016-12-01 | 14 | 13 | 1 | 1 | 390 | 0 | 390 | 209 | 2 | 11 | 3 | 79057.00 | 1 | 4 | 1005 E CENTENNIAL DRIVE PITTSBURG, KS 66762 (37.381788, -94.688739) | 02/01/2020 | |||||||||||
3551 | 3551 | 5901 LEMON HILL AVE SACRAMENTO, CA 95824 | 38.515906 | -121.436572 | 0 | 55956 | BRIARWOOD POST ACUTE | 5901 LEMON HILL AVE | SACRAMENTO | CA | 95824 | 9163832741 | 440 | Sacramento | For profit - Individual | 49 | 44.4 | Medicare and Medicaid | false | BRIARWOOD POST ACUTE LLC | 11/01/1969 | false | true | false | false | Resident | Yes | 1 | 1 | 2 | 4 | 1 | 1 | 12 | 1 | 12 | 2.74326 | 1.56068 | 0.22022 | 1.7809 | 4.52416 | 0.15756 | 1.8413 | 0.71835 | 0.33565 | 2.89529 | 3.09641 | 1.63367 | 0.24694 | 5.0107 | 11/13/2018 | 40 | 31 | 13 | 232 | 1 | 0 | 232 | 12/18/2017 | 22 | 19 | 3 | 104 | 1 | 0 | 104 | 2016-12-01 | 13 | 9 | 4 | 1 | 68 | 0 | 68 | 162 | 9 | 23 | 0 | 0.00 | 0 | 0 | 5901 LEMON HILL AVE SACRAMENTO, CA 95824 (38.515906, -121.436572) | 02/01/2020 | |||||||||
10281 | 10281 | 1007 N KING ST COLUMBIA, SC 29223 | 34.082451 | -80.934375 | 0 | 425287 | MAGNOLIA MANOR - COLUMBIA | 1007 N KING ST | COLUMBIA | SC | 29223 | 8036994111 | 390 | Richland | For profit - Corporation | 88 | 83 | Medicare and Medicaid | false | THI OF SOUTH CAROLINA AT COLUMBIA, LLC | 08/08/1988 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 2 | 4 | 1 | 2 | 2 | 1.9336 | 1.18468 | 0.46112 | 1.6458 | 3.57941 | 0.06197 | 2.03656 | 0.7876 | 0.46669 | 3.29085 | 1.97327 | 1.13105 | 0.37189 | 3.48784 | 02/03/2019 | 25 | 25 | 0 | 375 | 2 | 188 | 563 | 02/09/2018 | 17 | 16 | 1 | 120 | 1 | 0 | 120 | 2016-12-01 | 1 | 1 | 0 | 1 | 4 | 0 | 4 | 322.167 | 0 | 1 | 2 | 119343.00 | 0 | 2 | 1007 N KING ST COLUMBIA, SC 29223 (34.082451, -80.934375) | 02/01/2020 | ||||||||||
10658 | 10658 | 33426 OLD SALISBURY ROAD ALBEMARLE, NC 28002 | 35.391085 | -80.222097 | 0 | 345146 | BETHANY WOODS NURSING AND REHABILITATION CENTER | 33426 OLD SALISBURY ROAD BOX 1250 | ALBEMARLE | NC | 28002 | 7049831195 | 830 | Stanly | For profit - Corporation | 180 | 147.3 | Medicare and Medicaid | false | SPRUCE LTC GROUP, LLC | 03/19/1975 | false | true | false | false | Resident | Yes | 1 | 1 | 3 | 2 | 3 | 3 | 3 | 1.86462 | 0.71213 | 0.52476 | 1.23689 | 3.10151 | 0.03524 | 1.91687 | 0.7459 | 0.37112 | 3.0339 | 2.02168 | 0.71789 | 0.5322 | 3.27812 | 11/16/2018 | 28 | 20 | 8 | 243 | 1 | 0 | 243 | 11/02/2017 | 9 | 8 | 1 | 40 | 1 | 0 | 40 | 2016-12-01 | 14 | 14 | 0 | 1 | 64 | 0 | 64 | 145.5 | 0 | 8 | 0 | 0.00 | 0 | 0 | 33426 OLD SALISBURY ROAD ALBEMARLE, NC 28002 (35.391085, -80.222097) | 02/01/2020 | |||||||||||
11398 | 11398 | 7777 COOPER ROAD CINCINNATI, OH 45242 | 39.226769 | -84.357466 | 0 | 365327 | MONTGOMERY CARE CENTER | 7777 COOPER ROAD | CINCINNATI | OH | 45242 | 5137935092 | 310 | Hamilton | For profit - Corporation | 102 | 73.9 | Medicare and Medicaid | false | MONTGOMERY AT CARECORE LLC | 07/25/1975 | false | true | false | false | Resident | Yes | 1 | 1 | 3 | 4 | 2 | 2 | 1 | 1.97625 | 1.41374 | 0.37713 | 1.79087 | 3.76712 | 0.07508 | 2.0423 | 0.84614 | 0.4569 | 3.34533 | 2.01112 | 1.25635 | 0.31068 | 3.61096 | 03/12/2019 | 18 | 11 | 7 | 104 | 1 | 0 | 104 | 02/01/2018 | 29 | 12 | 18 | 156 | 1 | 0 | 156 | 2016-12-01 | 8 | 4 | 4 | 1 | 44 | 0 | 44 | 111.333 | 2 | 15 | 0 | 0.00 | 2 | 2 | 7777 COOPER ROAD CINCINNATI, OH 45242 (39.226769, -84.357466) | 02/01/2020 | |||||||||||
12727 | 12727 | 335 Township Rd 1026, South Point, OH 45680, USA | 38.4097766 | -82.5368649 | 1 | ROOFTOP | 366265 | RIVER'S BEND HEALTH CARE LLC | 335 TOWNSHIP ROAD 1026 | SOUTH POINT | OH | 45680 | 7408943476 | 450 | Lawrence | For profit - Corporation | 80 | 36.9 | Medicare and Medicaid | false | RIVER'S BEND HEALTH CARE, LLC | 04/24/2003 | false | SFF Candidate | true | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 4 | 1 | 12 | 1 | 12 | 6 | 6 | 11/16/2018 | 30 | 20 | 10 | 1464 | 1 | 0 | 1464 | 09/22/2017 | 15 | 15 | 0 | 124 | 1 | 0 | 124 | 2016-12-01 | 6 | 6 | 0 | 1 | 32 | 0 | 32 | 778.667 | 0 | 3 | 2 | 35464.00 | 2 | 4 | 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 );