nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
6 rows where Rating Cycle 2 Number of Health Revisits = 0 and Special Focus Status = "SFF Candidate"
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, ownership, Continuing Care Retirement Community, Abuse Icon, Overall Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Staffing Rating, RN Staffing Rating, RN Staffing Rating 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 2 Health Deficiency Score, Rating Cycle 2 Total Health Score, Rating Cycle 3 Number of Standard Health Deficiencies, Rating Cycle 3 Number of Health Revisits, Rating Cycle 3 Health Revisit Score, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1248 | 1248 | 1904 PALMYRA ROAD ALBANY, GA 31702 | 31.603176 | -84.169078 | 0 | 115628 | PRUITTHEALTH - PALMYRA | 1904 PALMYRA ROAD | ALBANY | GA | 31702 | 2298830500 | 390 | Dougherty | For profit - Corporation | 250 | 214.4 | Medicare and Medicaid | false | PRUITTHEALTH - PALMYRA, LLC | 01/01/1997 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 4 | 4 | 3 | 3 | 3 | 2.16304 | 0.95911 | 0.50326 | 1.46237 | 3.62541 | 0.03991 | 2.06315 | 0.72075 | 0.3109 | 3.09481 | 2.17897 | 1.00061 | 0.60926 | 3.75645 | 12/06/2018 | 8 | 2 | 6 | 408 | 1 | 0 | 408 | 11/16/2017 | 1 | 0 | 1 | 8 | 0 | 0 | 8 | 2016-10-27 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 208 | 0 | 4 | 1 | 186564.00 | 0 | 1 | 1904 PALMYRA ROAD ALBANY, GA 31702 (31.603176, -84.169078) | 02/01/2020 | ||||||||||
6657 | 6657 | 2130 ANDERSON MILL RD AUSTELL, GA 30106 | 33.848821 | -84.615814 | 0 | 115145 | ANDERSON MILL HEALTH AND REHABILITATION CENTER | 2130 ANDERSON MILL RD | AUSTELL | GA | 30106 | 7709418813 | 290 | Cobb | For profit - Individual | 170 | 126.3 | Medicare and Medicaid | false | SSC AUSTELL OPERATING COMPANY LLC | 03/01/1976 | false | SFF Candidate | false | false | false | Resident | Yes | 1 | 1 | 2 | 2 | 3 | 2 | 2 | 2.07867 | 1.17806 | 0.45162 | 1.62968 | 3.70835 | 0.11552 | 2.05124 | 0.77083 | 0.39563 | 3.21771 | 2.10613 | 1.14918 | 0.42965 | 3.69562 | 09/27/2018 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 10/26/2017 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2016-01-20 | 17 | 10 | 7 | 2 | 654 | 327 | 981 | 167.5 | 0 | 8 | 1 | 13627.00 | 0 | 1 | 2130 ANDERSON MILL RD AUSTELL, GA 30106 (33.848821, -84.615814) | 02/01/2020 | ||||||||||
7968 | 7968 | 1600 S WOODLAWN BLVD WICHITA, KS 67218 | 37.664157 | -97.262146 | 0 | 175452 | ORCHARD GARDENS | 1600 S. WOODLAWN BLVD | WICHITA | KS | 67218 | 3166919999 | 860 | Sedgwick | For profit - Limited Liability company | 80 | 64.4 | Medicare and Medicaid | false | ORCHARD GARDENS,LLC | 03/11/2002 | true | SFF Candidate | false | false | true | Resident | Yes | 1 | 1 | 4 | 1 | 5 | 1 | 12 | 1 | 12 | 6 | 6 | 01/21/2020 | 27 | 19 | 8 | 256 | 0 | 0 | 256 | 01/10/2019 | 4 | 0 | 4 | 64 | 0 | 0 | 64 | 2018-07-03 | 55 | 5 | 50 | 1 | 754 | 0 | 754 | 275 | 4 | 13 | 3 | 47386.00 | 1 | 4 | 1600 S WOODLAWN BLVD WICHITA, KS 67218 (37.664157, -97.262146) | 02/01/2020 | ||||||||||||||||||||
8688 | 8688 | 3854 PARK OVERLOOKE DRIVE BEAVER CREEK, OH 45431 | 39.764829 | -84.074779 | 0 | 366400 | BEAVERCREEK HEALTH AND REHAB | 3854 PARK OVERLOOKE DRIVE | BEAVER CREEK | OH | 45431 | 9374299655 | 290 | Greene | For profit - Partnership | 90 | 71.7 | Medicare and Medicaid | false | CT OHIO BEAVERCREEK, LLC | 11/16/2012 | false | SFF Candidate | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 1.87922 | 1.0012 | 0.43275 | 1.43395 | 3.31317 | 0.07134 | 2.1112 | 0.84596 | 0.43181 | 3.38897 | 1.84996 | 0.88993 | 0.3772 | 3.13494 | 12/11/2018 | 32 | 27 | 15 | 240 | 2 | 120 | 360 | 10/19/2017 | 18 | 0 | 18 | 88 | 0 | 0 | 88 | 2016-07-14 | 8 | 2 | 6 | 1 | 311 | 0 | 311 | 261.167 | 0 | 20 | 3 | 90489.00 | 1 | 4 | 3854 PARK OVERLOOKE DRIVE BEAVER CREEK, OH 45431 (39.764829, -84.074779) | 02/01/2020 | ||||||||||
8889 | 8889 | 5000 Thayer Dr, Killeen, TX 76549, USA | 31.0894495 | -97.8038379 | 1 | ROOFTOP | 676438 | KILLEEN NURSING & REHABILITATION | 5000 THAYER DR | KILLEEN | TX | 76549 | 2542216380 | 120 | Bell | For profit - Corporation | 120 | 84.9 | Medicare and Medicaid | false | BELL NURSING OPERATIONS LLC | 01/25/2018 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 2 | 1 | 2 | 1 | 12 | 1 | 12 | 2.07072 | 1.1432 | 0.26245 | 1.40565 | 3.47637 | 0.10851 | 2.0262 | 0.8931 | 0.48469 | 3.40399 | 2.124 | 0.96251 | 0.20381 | 3.27485 | 01/30/2019 | 11 | 4 | 8 | 497 | 1 | 0 | 497 | 01/25/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | . | . | . | . | . | . | . | 298.2 | 0 | 4 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||
8973 | 8973 | 395 AMWELL ROAD HILLSBOROUGH, NJ 08844 | 40.501065 | -74.638434 | 0 | 315510 | BRIDGEWAY CARE AND REHAB CENTER AT HILLSBOROUGH | 395 AMWELL ROAD | HILLSBOROUGH | NJ | 8844 | 9082814400 | 350 | Somerset | For profit - Limited Liability company | 126 | 121.1 | Medicare and Medicaid | false | SENIOR LIVING SOLUTIONS, LLC | 05/10/2012 | false | SFF Candidate | false | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 5 | 5 | 5 | 2.89611 | 0.84091 | 1.11103 | 1.95195 | 4.84806 | 0.27891 | 2.19861 | 0.76044 | 0.36429 | 3.32334 | 2.73768 | 0.83151 | 1.14793 | 4.67784 | 05/06/2019 | 6 | 6 | 0 | 486 | 1 | 0 | 486 | 03/01/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2016-11-21 | 1 | 0 | 1 | 0 | 20 | 0 | 20 | 246.333 | 0 | 6 | 2 | 36170.00 | 0 | 2 | 395 AMWELL ROAD HILLSBOROUGH, NJ 08844 (40.501065, -74.638434) | 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 );