nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
5 rows where Abuse Icon = "true" and "Rating Cycle 3 Standard Health Survey Date" is on date 2016-09-22
This data as json, copyable, CSV (advanced)
Suggested facets: ownership, nmbr_beds, Special Focus Status, With a Resident and Family Council, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Staffing Rating, RN Staffing Rating, Rating Cycle 1 Total Number of Health Deficiencies, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 2 Number of Standard Health Deficiencies, 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, Rating Cycle 3 Health Deficiency Score, Rating Cycle 3 Total Health 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1712 | 1712 | 431 WEST RACE STREET ROLLING FORK, MS 39159 | 32.905796 | -90.88511 | 0 | 255220 | SHARKEY-ISSAQUENA NURSING HOME | 431 WEST RACE STREET | ROLLING FORK | MS | 39159 | 6628735182 | 620 | Sharkey | Government - County | 54 | 45.6 | Medicare and Medicaid | false | SHARKEY-ISSAQUENA COMMUNITY HOSPITAL | 01/01/1996 | false | true | false | false | Both | Yes | 1 | 1 | 1 | 1 | 1 | 3 | 2 | 3.14847 | 0.95231 | 0.33772 | 1.29003 | 4.4385 | 0.00804 | 1.94311 | 0.59609 | 0.27636 | 2.81556 | 3.36758 | 1.20129 | 0.45995 | 5.05503 | 10/11/2018 | 6 | 1 | 5 | 88 | 1 | 0 | 88 | 07/14/2017 | 3 | 2 | 1 | 16 | 1 | 0 | 16 | 2016-09-22 | 4 | 4 | 0 | 1 | 24 | 0 | 24 | 53.333 | 1 | 1 | 1 | 8099.00 | 0 | 1 | 431 WEST RACE STREET ROLLING FORK, MS 39159 (32.905796, -90.88511) | 02/01/2020 | |||||||||||
5318 | 5318 | 3293 NORTH DRINKWATER BOULEVARD SCOTTSDALE, AZ 85251 | 33.48566 | -111.923896 | 0 | 35059 | HAVEN OF SCOTTSDALE | 3293 NORTH DRINKWATER BOULEVARD | SCOTTSDALE | AZ | 85251 | 4809477443 | 60 | Maricopa | For profit - Corporation | 90 | 47.2 | Medicare and Medicaid | false | HAVEN OF SCOTTSDALE LLC | 11/16/1978 | false | true | false | false | Resident | Yes | 3 | 2 | 5 | 5 | 4 | 2 | 3 | 1.84634 | 0.80016 | 0.70324 | 1.5034 | 3.34974 | 0.1716 | 2.24932 | 0.83631 | 0.4192 | 3.50482 | 1.70599 | 0.71944 | 0.63142 | 3.06478 | 01/25/2019 | 5 | 5 | 1 | 40 | 1 | 0 | 40 | 10/25/2017 | 4 | 4 | 3 | 20 | 1 | 0 | 20 | 2016-09-22 | 6 | 6 | 0 | 1 | 24 | 0 | 24 | 30.667 | 1 | 1 | 1 | 6633.00 | 0 | 1 | 3293 NORTH DRINKWATER BOULEVARD SCOTTSDALE, AZ 85251 (33.48566, -111.923896) | 02/01/2020 | |||||||||||
5731 | 5731 | 680 COLE STREET CARLISLE, IA 50047 | 41.495666 | -93.493113 | 0 | 165255 | CARLISLE CENTER FOR WELLNESS AND REHAB | 680 COLE STREET | CARLISLE | IA | 50047 | 5159890871 | 900 | Warren | For profit - Partnership | 101 | 63.1 | Medicare and Medicaid | false | PACIFICA HEALTH SERVICES LLC | 06/01/1995 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 3 | 2 | 5 | 3 | 3 | 1.99772 | 0.79937 | 0.4717 | 1.27107 | 3.26879 | 0.01606 | 1.91643 | 0.68179 | 0.31153 | 2.90975 | 2.16649 | 0.88162 | 0.56989 | 3.60233 | 03/07/2019 | 20 | 17 | 10 | 354 | 1 | 0 | 354 | 10/26/2017 | 7 | 7 | 1 | 36 | 1 | 0 | 36 | 2016-09-22 | 11 | 10 | 1 | 1 | 76 | 0 | 76 | 201.667 | 5 | 5 | 2 | 40740.00 | 1 | 3 | 680 COLE STREET CARLISLE, IA 50047 (41.495666, -93.493113) | 02/01/2020 | ||||||||||
7847 | 7847 | 3001 N HURSTBOURNE PARKWAY LOUISVILLE, KY 40241 | 38.292995 | -85.575383 | 0 | 185305 | SPRINGHURST HEALTH AND REHAB | 3001 N. HURSTBOURNE PARKWAY | LOUISVILLE | KY | 40241 | 5024265531 | 550 | Jefferson | Non profit - Church related | 90 | 56.7 | Medicare and Medicaid | false | BAPTIST HOMES, INC. | 12/01/1991 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 2 | 4 | 4 | 2.14569 | 1.15285 | 0.883 | 2.03584 | 4.18153 | 0 | 2.25319 | 0.74021 | 0.39509 | 3.38849 | 1.97918 | 1.17112 | 0.84118 | 3.95714 | 01/18/2019 | 20 | 10 | 10 | 839 | 1 | 0 | 839 | 11/09/2017 | 16 | 3 | 13 | 764 | 1 | 0 | 764 | 2016-09-22 | 17 | 6 | 11 | 1 | 128 | 0 | 128 | 695.5 | 3 | 3 | 4 | 358693.00 | 3 | 7 | 3001 N HURSTBOURNE PARKWAY LOUISVILLE, KY 40241 (38.292995, -85.575383) | 02/01/2020 | ||||||||||
9011 | 9011 | 63 BLACKSTOCK ROAD INMAN, SC 29349 | 35.03671 | -82.090405 | 0 | 425032 | MAGNOLIA MANOR - INMAN | 63 BLACKSTOCK ROAD | INMAN | SC | 29349 | 8644729055 | 410 | Spartanburg | For profit - Corporation | 176 | 161.5 | Medicare and Medicaid | false | THI OF SOUTH CAROLINA AT MAGNOLIA MANORINMAN, LLC | 01/01/1967 | false | true | false | false | Resident | Yes | 1 | 1 | 2 | 1 | 3 | 1 | 1 | 1.88192 | 1.06955 | 0.22834 | 1.29789 | 3.17982 | 0.03622 | 1.9639 | 0.65794 | 0.2998 | 2.92165 | 1.99158 | 1.22235 | 0.28667 | 3.49001 | 12/20/2018 | 22 | 13 | 11 | 152 | 1 | 0 | 152 | 10/05/2017 | 10 | 7 | 3 | 88 | 1 | 0 | 88 | 2016-09-22 | 11 | 11 | 0 | 1 | 80 | 0 | 80 | 118.667 | 5 | 0 | 3 | 105382.00 | 1 | 4 | 63 BLACKSTOCK ROAD INMAN, SC 29349 (35.03671, -82.090405) | 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 );