nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
8 rows where Abuse Icon = "true" and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-05-11
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, ownership, nmbr_beds, With a Resident and Family Council, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, 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 Standard Health Deficiencies, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Health Deficiency 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 Total Health Score, 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1460 | 1460 | 403 15TH STREET PORT ALLEN, LA 70767 | 30.45496 | -91.21808 | 0 | 195599 | LEGACY NURSING AND REHABILITATION OF PORT ALLEN | 403 15TH STREET | PORT ALLEN | LA | 70767 | 2253468815 | 600 | W. Baton Rouge | For profit - Limited Liability company | 125 | 114 | Medicare and Medicaid | false | PORT ALLEN CARE CENTER, LLC | 06/17/2004 | false | true | false | false | Resident | Yes | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1.59034 | 0.74221 | 0.28026 | 1.02247 | 2.61281 | 0.00774 | 1.75068 | 0.69353 | 0.34109 | 2.7853 | 1.88799 | 0.80472 | 0.30926 | 3.00808 | 04/04/2019 | 7 | 6 | 3 | 80 | 1 | 0 | 80 | 04/19/2018 | 7 | 4 | 3 | 76 | 1 | 0 | 76 | 2017-05-11 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 65.333 | 4 | 0 | 3 | 59367.00 | 0 | 3 | 403 15TH STREET PORT ALLEN, LA 70767 (30.45496, -91.21808) | 02/01/2020 | |||||||||||
1805 | 1805 | 3270 PRATT LAKE RD GLADWIN, MI 48624 | 44.00892 | -84.497743 | 0 | 235335 | GLADWIN NURSING AND REHABILITATION COMMUNITY | 3270 PRATT LAKE RD | GLADWIN | MI | 48624 | 9894267275 | 250 | Gladwin | For profit - Corporation | 60 | 33.8 | Medicare and Medicaid | false | ATRIUM GLADWIN, INC. | 05/12/1977 | false | true | false | false | Resident | Yes | 3 | 2 | 3 | 4 | 2 | 4 | 4 | 2.14267 | 0.85781 | 0.73138 | 1.58919 | 3.73187 | 0.31547 | 2.03095 | 0.73465 | 0.36924 | 3.13484 | 2.19267 | 0.87801 | 0.74552 | 3.81737 | 09/12/2019 | 19 | 18 | 4 | 152 | 1 | 0 | 152 | 07/25/2018 | 12 | 8 | 6 | 155 | 1 | 0 | 155 | 2017-05-11 | 8 | 5 | 3 | 1 | 48 | 0 | 48 | 135.667 | 7 | 6 | 1 | 13325.00 | 1 | 2 | 3270 PRATT LAKE RD GLADWIN, MI 48624 (44.00892, -84.497743) | 02/01/2020 | |||||||||||
2060 | 2060 | 1150 E MICHIGAN AVE BATTLE CREEK, MI 49014 | 42.310464 | -85.126433 | 0 | 235237 | CALHOUN COUNTY MEDICAL CARE FACILITY | 1150 E MICHIGAN AVE | BATTLE CREEK | MI | 49014 | 2699625458 | 120 | Calhoun | Government - County | 120 | 113.2 | Medicare and Medicaid | false | CALHOUN COUNTY MEDICAL CARE FACILITY | 11/01/1974 | false | true | false | false | Both | Yes | 3 | 2 | 4 | 4 | 4 | 4 | 4 | 2.76318 | 0.74395 | 0.68612 | 1.43007 | 4.19325 | 0.04134 | 2.01974 | 0.65938 | 0.29356 | 2.97268 | 2.84335 | 0.84838 | 0.87971 | 4.52331 | 08/07/2019 | 10 | 3 | 7 | 68 | 1 | 0 | 68 | 07/20/2018 | 8 | 6 | 3 | 36 | 1 | 0 | 36 | 2017-05-11 | 15 | 13 | 7 | 3 | 124 | 87 | 211 | 81.167 | 9 | 3 | 1 | 12500.00 | 1 | 2 | 1150 E MICHIGAN AVE BATTLE CREEK, MI 49014 (42.310464, -85.126433) | 02/01/2020 | |||||||||||
4396 | 4396 | 700 MANOR DRIVE PRESCOTT, AR 71857 | 33.787601 | -93.380341 | 0 | 45181 | PRESCOTT MANOR NURSING CENTER | 700 MANOR DRIVE | PRESCOTT | AR | 71857 | 8708876639 | 490 | Nevada | For profit - Limited Liability company | 111 | 56.5 | Medicare and Medicaid | false | KSJ, LLC | 12/09/1991 | false | true | false | false | Resident | Yes | 1 | 1 | 4 | 4 | 2 | 1 | 12 | 1 | 12 | 1.18861 | 0.57739 | 0.07239 | 0.64978 | 1.83839 | 0.02143 | 1.69242 | 0.61918 | 0.33457 | 2.64618 | 1.45965 | 0.70119 | 0.08143 | 2.22778 | 05/03/2019 | 11 | 6 | 5 | 423 | 1 | 0 | 423 | 07/13/2018 | 8 | 7 | 1 | 68 | 1 | 0 | 68 | 2017-05-11 | 3 | 3 | 0 | 1 | 12 | 0 | 12 | 236.167 | 1 | 3 | 0 | 0.00 | 0 | 0 | 700 MANOR DRIVE PRESCOTT, AR 71857 (33.787601, -93.380341) | 02/01/2020 | |||||||||
4450 | 4450 | 6975 BURLINGTON PIKE FLORENCE, KY 41042 | 39.007611 | -84.630606 | 0 | 185174 | FLORENCE PARK CARE CENTER | 6975 BURLINGTON PIKE | FLORENCE | KY | 41042 | 5136055000 | 70 | Boone | For profit - Corporation | 150 | 125.1 | Medicare and Medicaid | false | EVAN GRAY, LLC | 06/25/1984 | false | true | false | false | Resident | Yes | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 1.89638 | 1.39974 | 0.21146 | 1.6112 | 3.50758 | 0.04709 | 2.20231 | 0.82881 | 0.44203 | 3.47315 | 1.78963 | 1.26992 | 0.18005 | 3.23845 | 07/25/2019 | 7 | 1 | 6 | 80 | 1 | 0 | 80 | 06/14/2018 | 5 | 5 | 2 | 20 | 1 | 0 | 20 | 2017-05-11 | 4 | 4 | 0 | 1 | 24 | 0 | 24 | 50.667 | 1 | 1 | 1 | 8099.00 | 0 | 1 | 6975 BURLINGTON PIKE FLORENCE, KY 41042 (39.007611, -84.630606) | 02/01/2020 | |||||||||||
7534 | 7534 | 107 EAST LONE PINE DRIVE PAYSON, AZ 85541 | 34.231411 | -111.323154 | 0 | 35117 | PAYSON CARE CENTER | 107 EAST LONE PINE DRIVE | PAYSON | AZ | 85541 | 9284746896 | 30 | Gila | For profit - Limited Liability company | 163 | 85.3 | Medicare and Medicaid | false | PAYSON UNITED MEDICAL INVESTORS LLC | 11/25/1985 | false | true | false | false | Resident | Yes | 1 | 1 | 4 | 5 | 3 | 3 | 4 | 1.79482 | 0.91844 | 0.69411 | 1.61255 | 3.40737 | 0.06129 | 2.05231 | 0.68454 | 0.32235 | 3.0592 | 1.81758 | 1.00888 | 0.81046 | 3.57162 | 09/19/2019 | 10 | 10 | 1 | 76 | 1 | 0 | 76 | 07/13/2018 | 6 | 6 | 1 | 44 | 1 | 0 | 44 | 2017-05-11 | 6 | 6 | 1 | 1 | 24 | 0 | 24 | 56.667 | 5 | 1 | 1 | 99788.00 | 0 | 1 | 107 EAST LONE PINE DRIVE PAYSON, AZ 85541 (34.231411, -111.323154) | 02/01/2020 | |||||||||||
10967 | 10967 | 411 S LASALLE STREET DURHAM, NC 27705 | 36.013274 | -78.948142 | 0 | 345070 | DURHAM NURSING & REHABILITATION CENTER | 411 S LASALLE STREET | DURHAM | NC | 27705 | 9193835521 | 310 | Durham | For profit - Corporation | 126 | 92.8 | Medicare and Medicaid | false | DURHAM REHAB OPERATIONS LLC | 09/01/1973 | false | true | false | false | Resident | Yes | 1 | 2 | 1 | 2 | 1 | 2 | 2 | 1.78209 | 0.75867 | 0.56336 | 1.32203 | 3.10412 | 0.12137 | 2.01769 | 0.79998 | 0.42905 | 3.24672 | 1.83566 | 0.71311 | 0.4942 | 3.06582 | 06/06/2019 | 7 | 6 | 1 | 52 | 1 | 0 | 52 | 05/17/2018 | 2 | 2 | 1 | 32 | 1 | 0 | 32 | 2017-05-11 | 1 | 1 | 1 | 1 | 8 | 0 | 8 | 38 | 2 | 1 | 1 | 11047.00 | 0 | 1 | 411 S LASALLE STREET DURHAM, NC 27705 (36.013274, -78.948142) | 02/01/2020 | |||||||||||
14076 | 14076 | 804 SOUTH LONG DRIVE ROCKINGHAM, NC 28379 | 34.931562 | -79.75119 | 0 | 345378 | PRUITTHEALTH-ROCKINGHAM | 804 SOUTH LONG DRIVE | ROCKINGHAM | NC | 28379 | 9109974493 | 760 | Richmond | For profit - Corporation | 120 | 88.2 | Medicare and Medicaid | false | PRUITTHEALTH ROCKINGHAM LLC | 06/21/1991 | false | true | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 4 | 3 | 3 | 1.75394 | 0.93159 | 0.52438 | 1.45597 | 3.20991 | 0.13049 | 2.08835 | 0.72076 | 0.32821 | 3.13732 | 1.74553 | 0.97189 | 0.60136 | 3.28086 | 08/29/2019 | 16 | 8 | 8 | 226 | 1 | 0 | 226 | 06/21/2018 | 16 | 16 | 2 | 68 | 1 | 0 | 68 | 2017-05-11 | 11 | 11 | 10 | 1 | 52 | 0 | 52 | 144.333 | 1 | 4 | 1 | 224199.00 | 0 | 1 | 804 SOUTH LONG DRIVE ROCKINGHAM, NC 28379 (34.931562, -79.75119) | 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 );