nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
8 rows where Rating Cycle 2 Health Revisit Score = 60
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, prvdr_cnty_name, ownership, prvdr_type, Continuing Care Retirement Community, Special Focus Status, Abuse Icon, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, Overall Rating, Health Inspection 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 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 2 Number of Complaint 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, Number of Facility Reported Incidents, Number of Fines, Total Amount of Fines in Dollars, Number of Payment Denials, Total Number of Penalties, Location, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
505 | 505 | 2500 S ROSLYN ST DENVER, CO 80231 | 39.668975 | -104.901132 | 0 | 65362 | MONTAGE HILLS | 2500 S ROSLYN ST | DENVER | CO | 80231 | 3036712500 | 20 | Arapahoe | For profit - Corporation | 45 | 31.1 | Medicare | false | Legal Business Name Not Available | 09/17/1997 | true | false | false | false | Both | Yes | 2 | 1 | 5 | 4 | 5 | 5 | 5 | 2.09738 | 0.95681 | 1.42356 | 2.38037 | 4.47775 | 0.10323 | 2.2214 | 0.75741 | 0.35427 | 3.33308 | 1.9623 | 0.9499 | 1.5124 | 4.30791 | 03/05/2019 | 10 | 8 | 2 | 68 | 1 | 0 | 68 | 09/05/2017 | 21 | 20 | 1 | 120 | 2 | 60 | 180 | 2016-07-01 | 7 | 2 | 5 | 1 | 28 | 0 | 28 | 98.667 | 0 | 16 | 0 | 0.00 | 0 | 0 | 2500 S ROSLYN ST DENVER, CO 80231 (39.668975, -104.901132) | 02/01/2020 | |||||||||||
2714 | 2714 | 9480 M-21, Ovid, MI 48866, USA | 43.0001852 | -84.3781073 | 1 | ROOFTOP | 235569 | OVID HEALTHCARE CENTER | 9480 E M-21 | OVID | MI | 48866 | 9898342228 | 180 | Clinton | For profit - Corporation | 94 | 66.2 | Medicare and Medicaid | false | OVID HEALTHCARE, LLC | 10/07/1996 | false | false | false | false | Resident | Yes | 2 | 1 | 3 | 3 | 3 | 4 | 4 | 2.29549 | 0.54588 | 0.65928 | 1.20516 | 3.50066 | 0.00671 | 1.99319 | 0.68182 | 0.32084 | 2.99585 | 2.39356 | 0.60203 | 0.77342 | 3.747 | 05/21/2019 | 18 | 17 | 1 | 124 | 2 | 62 | 186 | 09/14/2018 | 19 | 19 | 1 | 120 | 2 | 60 | 180 | 2017-07-20 | 24 | 15 | 9 | 2 | 263 | 132 | 395 | 218.833 | 5 | 7 | 1 | 44369.00 | 1 | 2 | 02/01/2020 | |||||||||||
3502 | 3502 | 24 8TH STREET NORTHWEST ROCHESTER, MN 55901 | 44.031347 | -92.464272 | 0 | 245530 | SAMARITAN BETHANY HOME ON EIGHTH | 24 - 8TH STREET NORTHWEST | ROCHESTER | MN | 55901 | 5072894031 | 540 | Olmsted | Non profit - Corporation | 155 | 144.4 | Medicare and Medicaid | false | SAMARITAN BETHANY INC | 05/01/1988 | false | SFF Candidate | true | false | false | Both | Yes | 2 | 1 | 3 | 2 | 5 | 4 | 4 | 3.74676 | 0.725 | 0.83505 | 1.56005 | 5.30681 | 0 | 1.92691 | 0.67711 | 0.31281 | 2.91682 | 4.0412 | 0.80513 | 1.00477 | 5.83414 | 04/15/2019 | 24 | 20 | 11 | 215 | 2 | 108 | 323 | 03/16/2018 | 21 | 17 | 4 | 120 | 2 | 60 | 180 | 2016-12-29 | 1 | 1 | 0 | 1 | 4 | 0 | 4 | 222.167 | 3 | 5 | 3 | 117343.00 | 2 | 5 | 24 8TH STREET NORTHWEST ROCHESTER, MN 55901 (44.031347, -92.464272) | 02/01/2020 | ||||||||||
4553 | 4553 | 1101 S SCOTT RD SAINT JOHNS, MI 48879 | 42.991346 | -84.54271 | 0 | 235602 | HAZEL I FINDLAY COUNTRY MANOR | 1101 S SCOTT RD | SAINT JOHNS | MI | 48879 | 9892248936 | 180 | Clinton | Non profit - Corporation | 157 | 111.9 | Medicare and Medicaid | false | CLINTON AREA CARE CENTER, INC | 03/01/2002 | false | false | false | false | Resident | Yes | 4 | 2 | 5 | 5 | 5 | 5 | 5 | 3.76681 | 0.62326 | 1.06651 | 1.68977 | 5.45658 | 0.04708 | 2.2405 | 0.69327 | 0.30749 | 3.24126 | 3.49416 | 0.67601 | 1.30546 | 5.39833 | 02/14/2019 | 10 | 10 | 0 | 60 | 1 | 0 | 60 | 01/25/2018 | 21 | 17 | 4 | 120 | 2 | 60 | 180 | 2016-12-14 | 12 | 12 | 0 | 1 | 68 | 0 | 68 | 101.333 | 0 | 4 | 0 | 0.00 | 0 | 0 | 1101 S SCOTT RD SAINT JOHNS, MI 48879 (42.991346, -84.54271) | 02/01/2020 | |||||||||||
4555 | 4555 | 150 WATER STREET HAVERHILL, MA 01830 | 42.774748 | -71.071882 | 0 | 225376 | PENACOOK PLACE, INC | 150 WATER STREET | HAVERHILL | MA | 1830 | 9783740707 | 40 | Essex | Non profit - Corporation | 160 | 120.8 | Medicare and Medicaid | false | PENACOOK PLACE, INC. | 07/01/1990 | false | false | false | false | Resident | Yes | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2.2417 | 0.94129 | 0.47237 | 1.41366 | 3.65536 | 0.0444 | 2.24634 | 0.66927 | 0.30827 | 3.22389 | 2.07404 | 1.05756 | 0.57673 | 3.63582 | 05/09/2019 | 5 | 4 | 1 | 24 | 1 | 0 | 24 | 03/27/2018 | 16 | 16 | 0 | 120 | 2 | 60 | 180 | 2017-02-15 | 5 | 5 | 0 | 1 | 36 | 0 | 36 | 78 | 1 | 0 | 0 | 0.00 | 0 | 0 | 150 WATER STREET HAVERHILL, MA 01830 (42.774748, -71.071882) | 02/01/2020 | |||||||||||
4826 | 4826 | 4330 WASHINGTON KANSAS CITY, MO 64111 | 39.048353 | -94.592068 | 0 | 265199 | GRAND PAVILION AT THE PLAZA | 4330 WASHINGTON | KANSAS CITY | MO | 64111 | 8167536800 | 470 | Jackson | For profit - Individual | 154 | 67 | Medicare and Medicaid | false | GRAND PAVILION LLC | 08/04/1983 | false | SFF Candidate | false | false | true | Resident | Yes | 1 | 1 | 2 | 2 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 03/14/2019 | 25 | 22 | 3 | 271 | 2 | 136 | 407 | 04/30/2018 | 13 | 11 | 4 | 120 | 2 | 60 | 180 | 2017-05-31 | 15 | 15 | 0 | 1 | 84 | 0 | 84 | 277.5 | 1 | 8 | 0 | 0.00 | 1 | 1 | 4330 WASHINGTON KANSAS CITY, MO 64111 (39.048353, -94.592068) | 02/01/2020 | ||||||||||||||||||||
6525 | 6525 | 433 County Rd 30 SE, Delano, MN 55328, USA | 45.0494006 | -93.78329049999999 | 1 | ROOFTOP | 245336 | THE ESTATES AT DELANO LLC | 433 COUNTY ROAD 30 | DELANO | MN | 55328 | 7639722987 | 850 | Wright | For profit - Corporation | 46 | 35.2 | Medicare and Medicaid | false | ESTATES AT DELANO LLC | 07/01/1986 | false | false | false | false | Both | Yes | 2 | 1 | 2 | 4 | 1 | 4 | 5 | 1.89024 | 0.45408 | 1.14235 | 1.59643 | 3.48667 | 0.03123 | 2.05009 | 0.70104 | 0.32157 | 3.0727 | 1.91629 | 0.48704 | 1.33708 | 3.63869 | 09/12/2019 | 17 | 15 | 4 | 96 | 1 | 0 | 96 | 08/16/2018 | 16 | 16 | 3 | 120 | 2 | 60 | 180 | 2017-06-02 | 16 | 16 | 0 | 1 | 140 | 0 | 140 | 131.333 | 2 | 13 | 1 | 57630.00 | 0 | 1 | 02/01/2020 | |||||||||||
10552 | 10552 | 200 SECOND AVENUE KINGSTON, PA 18704 | 41.257013 | -75.883465 | 0 | 395397 | MANORCARE HEALTH SERVICES-KINGSTON | 200 SECOND AVENUE | KINGSTON | PA | 18704 | 5702889315 | 480 | Luzerne | Non profit - Other | 176 | 136 | Medicare and Medicaid | false | MANOR CARE OF KINGSTON PA LLC | 12/01/1977 | false | true | false | false | Resident | Yes | 1 | 1 | 3 | 3 | 2 | 3 | 3 | 1.95772 | 0.86864 | 0.51898 | 1.38761 | 3.34533 | 0.08077 | 2.11214 | 0.75195 | 0.37317 | 3.23727 | 1.92639 | 0.86862 | 0.52344 | 3.3137 | 11/19/2018 | 24 | 11 | 13 | 176 | 1 | 0 | 176 | 12/22/2017 | 20 | 7 | 13 | 120 | 2 | 60 | 180 | 2016-11-18 | 22 | 14 | 8 | 1 | 140 | 0 | 140 | 171.333 | 2 | 33 | 2 | 61988.00 | 2 | 4 | 200 SECOND AVENUE KINGSTON, PA 18704 (41.257013, -75.883465) | 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 );