nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
9 rows where Rating Cycle 1 Health Revisit Score = 56
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, ownership, Continuing Care Retirement Community, Special Focus Status, 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, Reported Staffing Footnote, Physical Therapist Staffing 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 Number of Health Revisits, 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 Complaint Health Deficiencies, Rating Cycle 2 Number of Health Revisits, Rating Cycle 2 Health Revisit Score, 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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
651 | 651 | 111 HUNTOON MEMORIAL HIGHWAY ROCHDALE, MA 01542 | 42.201333 | -71.899974 | 0 | 225668 | MEADOWS OF CENTRAL MASSACHUSETTS (THE) | 111 HUNTOON MEMORIAL HIGHWAY | ROCHDALE | MA | 1542 | 5088926808 | 170 | Worcester | For profit - Corporation | 135 | 62.2 | Medicare and Medicaid | false | VIBRA HOSPITAL OF WESTERN MASSACHUSETTS LLC | 03/16/1995 | false | false | false | false | Resident | Yes | 1 | 1 | 3 | 5 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 09/26/2019 | 21 | 21 | 0 | 112 | 2 | 56 | 168 | 08/10/2018 | 9 | 9 | 0 | 40 | 1 | 0 | 40 | 2017-05-11 | 9 | 7 | 2 | 1 | 76 | 0 | 76 | 110 | 1 | 0 | 1 | 5807.00 | 0 | 1 | 111 HUNTOON MEMORIAL HIGHWAY ROCHDALE, MA 01542 (42.201333, -71.899974) | 02/01/2020 | |||||||||||||||||||||
2019 | 2019 | 800 ESSEX STREET LAWRENCE, MA 01841 | 42.701912 | -71.175629 | 0 | 225505 | ROYAL WOOD MILL CENTER | 800 ESSEX STREET | LAWRENCE | MA | 1841 | 9786862994 | 40 | Essex | For profit - Corporation | 94 | 81.1 | Medicare and Medicaid | false | LOWN ACQUISITION LLC | 07/01/1990 | false | false | false | false | Resident | Yes | 1 | 1 | 3 | 1 | 5 | 3 | 3 | 1.88558 | 0.8683 | 0.50385 | 1.37214 | 3.25772 | 0.01311 | 1.85522 | 0.58893 | 0.26723 | 2.71138 | 2.11234 | 1.10864 | 0.70965 | 3.85281 | 05/24/2019 | 13 | 13 | 0 | 80 | 3 | 56 | 136 | 05/03/2018 | 18 | 15 | 3 | 112 | 1 | 0 | 112 | 2017-03-02 | 8 | 8 | 0 | 1 | 32 | 0 | 32 | 110.667 | 0 | 1 | 2 | 26687.00 | 0 | 2 | 800 ESSEX STREET LAWRENCE, MA 01841 (42.701912, -71.175629) | 02/01/2020 | |||||||||||
4133 | 4133 | 5335 LAUREL CANYON BLVD NORTH HOLLYWOOD, CA 91607 | 34.167743 | -118.39651 | 0 | 55932 | FOUR SEASONS HEALTHCARE & WELLNESS CENTER, LP | 5335 LAUREL CANYON BLVD. | NORTH HOLLYWOOD | CA | 91607 | 8189851814 | 200 | Los Angeles | For profit - Corporation | 201 | 185.3 | Medicare and Medicaid | false | FOUR SEASONS HEALTHCARE & WELLNESS CENTER, LP | 05/22/1968 | false | false | false | false | Both | Yes | 1 | 1 | 4 | 5 | 2 | 2 | 2 | 2.36221 | 1.01006 | 0.39686 | 1.40692 | 3.76913 | 0.10273 | 1.93486 | 0.75117 | 0.36346 | 3.04949 | 2.53739 | 1.01109 | 0.41097 | 3.9634 | 02/26/2019 | 16 | 14 | 7 | 112 | 2 | 56 | 168 | 03/12/2018 | 38 | 33 | 7 | 192 | 1 | 0 | 192 | 2017-03-21 | 22 | 13 | 9 | 1 | 96 | 0 | 96 | 164 | 7 | 23 | 2 | 9597.00 | 0 | 2 | 5335 LAUREL CANYON BLVD NORTH HOLLYWOOD, CA 91607 (34.167743, -118.39651) | 02/01/2020 | |||||||||||
4524 | 4524 | 80 FERN DR TORRINGTON, CT 06790 | 41.81049 | -73.109 | 0 | 75105 | REGALCARE AT TORRINGTON | 80 FERN DR | TORRINGTON | CT | 6790 | 8602947300 | 20 | Litchfield | For profit - Corporation | 75 | 72.6 | Medicare and Medicaid | false | REGALCARE AT TORRINGTON LLC | 09/01/1971 | false | false | false | false | Resident | Yes | 1 | 1 | 3 | 1 | 4 | 3 | 3 | 2.04438 | 0.91891 | 0.60625 | 1.52516 | 3.56955 | 0.08628 | 1.85113 | 0.6888 | 0.3374 | 2.87734 | 2.2953 | 1.00314 | 0.67629 | 3.97809 | 09/19/2019 | 24 | 15 | 9 | 112 | 2 | 56 | 168 | 07/20/2018 | 8 | 8 | 2 | 52 | 1 | 0 | 52 | 2017-08-03 | 18 | 16 | 18 | 1 | 132 | 0 | 132 | 123.333 | 1 | 10 | 2 | 14625.00 | 0 | 2 | 80 FERN DR TORRINGTON, CT 06790 (41.81049, -73.109) | 02/01/2020 | |||||||||||
7709 | 7709 | 1313 SOUTH 25TH ST BETHANY, MO 64424 | 40.256602 | -94.026919 | 0 | 265807 | CRESTVIEW HOME | 1313 SOUTH 25TH ST, PO BOX 430 | BETHANY | MO | 64424 | 6604253128 | 400 | Harrison | For profit - Corporation | 92 | 69.3 | Medicare and Medicaid | false | N & R OF CRESTVIEW LLC | 12/13/2006 | false | SFF Candidate | false | false | false | Resident | Yes | 1 | 1 | 4 | 4 | 2 | 3 | 3 | 2.02871 | 0.29902 | 0.37294 | 0.67196 | 2.70067 | 0.02972 | 1.71894 | 0.60913 | 0.27644 | 2.60451 | 2.45287 | 0.36913 | 0.50778 | 3.32506 | 05/23/2019 | 21 | 9 | 12 | 112 | 2 | 56 | 168 | 05/03/2018 | 18 | 10 | 8 | 242 | 3 | 169 | 411 | 2017-05-05 | 10 | 7 | 4 | 1 | 76 | 0 | 76 | 233.667 | 0 | 21 | 1 | 50567.00 | 1 | 2 | 1313 SOUTH 25TH ST BETHANY, MO 64424 (40.256602, -94.026919) | 02/01/2020 | ||||||||||
9133 | 9133 | 2580 PRUDEN BOULEVARD SUFFOLK, VA 23434 | 36.764914 | -76.598308 | 0 | 495258 | AUTUMN CARE OF SUFFOLK | 2580 PRUDEN BOULEVARD | SUFFOLK | VA | 23434 | 7579342363 | 892 | Suffolk City | For profit - Corporation | 120 | 107.8 | Medicare and Medicaid | false | AUTUMN CORPORATION | 10/15/1991 | false | false | false | false | Resident | Yes | 1 | 1 | 3 | 3 | 4 | 1 | 1 | 1.74866 | 0.93138 | 0.25055 | 1.18194 | 2.9306 | 0.04197 | 2.21229 | 0.74991 | 0.37875 | 3.34095 | 1.64279 | 0.9339 | 0.24899 | 2.81281 | 07/26/2019 | 16 | 15 | 10 | 112 | 2 | 56 | 168 | 01/26/2018 | 16 | 16 | 3 | 104 | 2 | 52 | 156 | 2016-11-03 | 15 | 5 | 10 | 1 | 247 | 0 | 247 | 177.167 | 0 | 16 | 2 | 127637.00 | 0 | 2 | 2580 PRUDEN BOULEVARD SUFFOLK, VA 23434 (36.764914, -76.598308) | 02/01/2020 | |||||||||||
10551 | 10551 | 12441 SE STARK STREET PORTLAND, OR 97233 | 45.519044 | -122.534792 | 0 | 385228 | PORTLAND HEALTH & REHABILITATION CENTER | 12441 SE STARK STREET | PORTLAND | OR | 97233 | 5032557040 | 250 | Multnomah | For profit - Corporation | 105 | 48.9 | Medicare and Medicaid | false | EVERGREEN OREGON HEALTHCARE PORTLAND, L.L.C. | 01/01/1992 | false | false | false | false | Resident | Yes | 3 | 2 | 2 | 1 | 2 | 5 | 5 | 2.94742 | 0.2291 | 0.98794 | 1.21704 | 4.16446 | 0.08373 | 2.10639 | 0.72202 | 0.34674 | 3.17516 | 2.90816 | 0.2386 | 1.07239 | 4.20578 | 03/13/2019 | 25 | 18 | 25 | 112 | 2 | 56 | 168 | 06/25/2018 | 18 | 13 | 7 | 84 | 1 | 0 | 84 | 2017-04-25 | 17 | 9 | 17 | 1 | 96 | 0 | 96 | 128 | 7 | 15 | 1 | 6500.00 | 0 | 1 | 12441 SE STARK STREET PORTLAND, OR 97233 (45.519044, -122.534792) | 02/01/2020 | |||||||||||
11018 | 11018 | 74 MIZPAH ROAD LOCUST HILL, VA 23092 | 37.60883 | -76.508263 | 0 | 495422 | DOCKSIDE HEALTH & REHAB CENTER | 74 MIZPAH ROAD | LOCUST HILL | VA | 23092 | 8047585260 | 590 | Middlesex | For profit - Corporation | 64 | 70.1 | Medicare and Medicaid | false | MIZPAH HEALTHCARE GROUP LLC | 05/19/2016 | false | false | false | false | Resident | Yes | 1 | 2 | 3 | 4 | 3 | 1 | 1 | 1.6909 | 1.03685 | 0.26387 | 1.30072 | 2.99162 | 0.04981 | 1.85293 | 0.70843 | 0.34435 | 2.90572 | 1.89659 | 1.10053 | 0.28842 | 3.30146 | 07/13/2018 | 18 | 18 | 3 | 112 | 2 | 56 | 168 | 06/22/2017 | 5 | 5 | 2 | 20 | 1 | 0 | 20 | 2016-05-05 | 2 | 2 | 0 | 1 | 12 | 0 | 12 | 92.667 | 0 | 5 | 1 | 60548.00 | 0 | 1 | 74 MIZPAH ROAD LOCUST HILL, VA 23092 (37.60883, -76.508263) | 02/01/2020 | |||||||||||
13204 | 13204 | 2990 CARLISLE PK NEW OXFORD, PA 17350 | 39.869047 | -77.025977 | 0 | 395108 | CROSS KEYS VILLAGE-BRETHREN HOME COMMUNITY, THE | BOX 128, 2990 CARLISLE PK | NEW OXFORD | PA | 17350 | 7176242161 | 0 | Adams | Non profit - Church related | 270 | 163 | Medicare and Medicaid | false | THE BRETHREN HOME COMMUNITY | 01/01/1967 | true | false | false | false | Resident | Yes | 1 | 1 | 4 | 5 | 3 | 3 | 3 | 2.63123 | 1.49517 | 0.59686 | 2.09202 | 4.72325 | 0.085 | 2.30369 | 0.77935 | 0.39125 | 3.47429 | 2.37383 | 1.44259 | 0.57418 | 4.35941 | 08/08/2019 | 21 | 6 | 15 | 112 | 2 | 56 | 168 | 08/09/2018 | 18 | 18 | 3 | 96 | 1 | 0 | 96 | 2017-09-21 | 19 | 18 | 1 | 1 | 112 | 0 | 112 | 134.667 | 6 | 9 | 0 | 0.00 | 1 | 1 | 2990 CARLISLE PK NEW OXFORD, PA 17350 (39.869047, -77.025977) | 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 );