nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
7 rows where Total Number of Penalties = 8
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, ownership, nmbr_beds, Continuing Care Retirement Community, Special Focus Status, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, 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, Rating Cycle 1 Total Number of 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 Standard Health Deficiencies, Rating Cycle 3 Total Number of Health Deficiencies, Rating Cycle 3 Number of Health Revisits, 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1409 | 1409 | 7501 KEYSTONE DRIVE OMAHA, NE 68134 | 41.299589 | -96.027754 | 0 | 285238 | KEYSTONE RIDGE POST ACUTE NURSING AND REHAB | 7501 KEYSTONE DRIVE | OMAHA | NE | 68134 | 4025725750 | 270 | Douglas | For profit - Individual | 100 | 40.1 | Medicare and Medicaid | false | GOOD HOPE HEALTHCARE INC | 05/08/2000 | true | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.78176 | 0.94858 | 0.83189 | 1.78047 | 4.56223 | 0.07308 | 1.91189 | 0.73248 | 0.35427 | 2.99864 | 3.02395 | 0.97377 | 0.88382 | 4.87872 | 04/22/2019 | 23 | 22 | 12 | 452 | 2 | 226 | 678 | 01/02/2018 | 47 | 26 | 35 | 489 | 1 | 0 | 489 | 2016-09-06 | 21 | 13 | 8 | 2 | 144 | 72 | 216 | 538 | 9 | 44 | 4 | 272276.00 | 4 | 8 | 7501 KEYSTONE DRIVE OMAHA, NE 68134 (41.299589, -96.027754) | 02/01/2020 | ||||||||||
6524 | 6524 | 535 N MAIN CLAWSON, MI 48017 | 42.537507 | -83.146513 | 0 | 235214 | CAMBRIDGE NORTH HEALTHCARE CENTER | 535 N MAIN | CLAWSON | MI | 48017 | 2484355200 | 620 | Oakland | For profit - Corporation | 120 | 94.8 | Medicare and Medicaid | false | SSC CLAWSON OPERATING COMPANY LLC | 10/08/1971 | false | false | false | false | Resident | Yes | 1 | 1 | 4 | 5 | 4 | 1 | 12 | 1 | 12 | 2.15528 | 1.17212 | 0.26557 | 1.43769 | 3.59297 | 0.08358 | 2.08638 | 0.73739 | 0.34536 | 3.16913 | 2.14697 | 1.19525 | 0.28943 | 3.63552 | 10/29/2018 | 27 | 18 | 12 | 400 | 1 | 0 | 400 | 08/10/2017 | 19 | 13 | 6 | 247 | 1 | 0 | 247 | 2016-07-20 | 23 | 12 | 11 | 2 | 227 | 114 | 341 | 339.167 | 10 | 30 | 7 | 295273.00 | 1 | 8 | 535 N MAIN CLAWSON, MI 48017 (42.537507, -83.146513) | 02/01/2020 | |||||||||
6828 | 6828 | 5211 W 103RD STREET OVERLAND PARK, KS 66207 | 38.942109 | -94.645372 | 0 | 175180 | OVERLAND PARK REHABILITATION AND HEALTHCARE | 5211 W 103RD STREET | OVERLAND PARK | KS | 66207 | 9133832569 | 450 | Johnson | For profit - Partnership | 165 | 82.3 | Medicare and Medicaid | false | LEISURE OPERATIONS LLC | 02/12/1989 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.73957 | 1.83296 | 1.10081 | 2.93377 | 5.67334 | 0.13951 | 2.06924 | 0.77908 | 0.40302 | 3.25133 | 2.75162 | 1.76911 | 1.02807 | 5.59539 | 07/11/2019 | 30 | 29 | 30 | 192 | 1 | 0 | 192 | 07/05/2018 | 64 | 13 | 64 | 1272 | 1 | 0 | 1272 | 2016-08-30 | 41 | 28 | 13 | 2 | 703 | 352 | 1055 | 695.833 | 14 | 81 | 4 | 210137.00 | 4 | 8 | 5211 W 103RD STREET OVERLAND PARK, KS 66207 (38.942109, -94.645372) | 02/01/2020 | ||||||||||
7288 | 7288 | 915 N RIVER RD SAGINAW, MI 48609 | 43.422068 | -84.052128 | 0 | 235249 | ST FRANCIS HOME | 915 N RIVER RD | SAGINAW | MI | 48609 | 9897813150 | 720 | Saginaw | Non profit - Church related | 94 | 74.3 | Medicare and Medicaid | false | ST. FRANCIS HOME OF SAGINAW | 09/01/1975 | false | false | false | false | Both | Yes | 2 | 1 | 5 | 4 | 5 | 4 | 3 | 3.21364 | 0.99462 | 0.65291 | 1.64753 | 4.86117 | 0.0586 | 2.2035 | 0.72612 | 0.35046 | 3.28008 | 3.0311 | 1.02999 | 0.7012 | 4.75236 | 05/03/2019 | 18 | 13 | 5 | 251 | 1 | 0 | 251 | 04/26/2018 | 16 | 11 | 5 | 156 | 1 | 0 | 156 | 2017-06-08 | 46 | 22 | 25 | 2 | 385 | 193 | 578 | 273.833 | 22 | 16 | 7 | 173591.00 | 1 | 8 | 915 N RIVER RD SAGINAW, MI 48609 (43.422068, -84.052128) | 02/01/2020 | |||||||||||
7651 | 7651 | 1800 INDIAN HILLS DRIVE SIOUX CITY, IA 51104 | 42.533789 | -96.388623 | 0 | 165161 | TOUCHSTONE HEALTHCARE COMMUNITY | 1800 INDIAN HILLS DRIVE | SIOUX CITY | IA | 51104 | 7122394582 | 960 | Woodbury | For profit - Corporation | 125 | 69.7 | Medicare and Medicaid | false | INDIAN HILLS HEALTH CARE OF SIOUX CITY LLC | 07/01/1991 | false | SFF | false | false | true | Both | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 1.86563 | 0.79857 | 0.48145 | 1.28001 | 3.14565 | 0.04084 | 2.06149 | 0.7361 | 0.36409 | 3.16168 | 1.88088 | 0.81575 | 0.49771 | 3.1904 | 09/19/2019 | 27 | 21 | 6 | 140 | 1 | 0 | 140 | 03/21/2019 | 19 | 13 | 8 | 132 | 1 | 0 | 132 | 2018-09-26 | 51 | 31 | 41 | 1 | 670 | 0 | 670 | 225.667 | 7 | 49 | 4 | 138811.00 | 4 | 8 | 1800 INDIAN HILLS DRIVE SIOUX CITY, IA 51104 (42.533789, -96.388623) | 02/01/2020 | ||||||||||
7731 | 7731 | 10040 HILLVIEW ROAD PENSACOLA, FL 32514 | 30.540282 | -87.217787 | 0 | 105445 | UNIVERSITY HILLS HEALTH AND REHABILITATION | 10040 HILLVIEW ROAD | PENSACOLA | FL | 32514 | 8504740570 | 160 | Escambia | For profit - Corporation | 120 | 110 | Medicare and Medicaid | false | 10040 HILLVIEW ROAD OPERATIONS LLC | 01/03/1984 | false | SFF Candidate | false | false | false | Both | Yes | 1 | 1 | 4 | 3 | 5 | 3 | 2 | 2.65994 | 0.92309 | 0.41513 | 1.33822 | 3.99816 | 0.04889 | 1.85148 | 0.67801 | 0.32229 | 2.85177 | 2.98586 | 1.02375 | 0.48481 | 4.49572 | 04/19/2019 | 22 | 10 | 12 | 200 | 2 | 100 | 300 | 04/27/2018 | 8 | 8 | 0 | 32 | 1 | 0 | 32 | 2017-05-11 | 14 | 4 | 10 | 1 | 140 | 0 | 140 | 184 | 1 | 19 | 5 | 236871.00 | 3 | 8 | 10040 HILLVIEW ROAD PENSACOLA, FL 32514 (30.540282, -87.217787) | 02/01/2020 | ||||||||||
14150 | 14150 | 1103 WEST CHEROKEE LINDSAY, OK 73052 | 34.837492 | -97.620786 | 0 | 375206 | LINDSAY NURSING & REHAB | 1103 WEST CHEROKEE | LINDSAY | OK | 73052 | 4057564334 | 240 | Garvin | For profit - Individual | 106 | 49.2 | Medicare and Medicaid | false | LINDSAY NURSING & REHABILITATION LLC | 02/01/1995 | false | false | false | false | Resident | Yes | 1 | 1 | 3 | 3 | 2 | 3 | 3 | 1.8332 | 0.8353 | 0.3904 | 1.22571 | 3.05891 | 0.00562 | 1.58452 | 0.61732 | 0.28879 | 2.49063 | 2.40452 | 1.01747 | 0.50882 | 3.93832 | 09/05/2019 | 6 | 6 | 0 | 56 | 1 | 0 | 56 | 06/27/2018 | 34 | 15 | 19 | 487 | 1 | 0 | 487 | 2017-05-01 | 14 | 3 | 11 | 1 | 140 | 0 | 140 | 213.667 | 1 | 16 | 5 | 142019.00 | 3 | 8 | 1103 WEST CHEROKEE LINDSAY, OK 73052 (34.837492, -97.620786) | 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 );