nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
11 rows where Rating Cycle 1 Health Revisit Score = 40
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_cnty, ownership, nmbr_beds, Continuing Care Retirement Community, 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, Reported Physical Therapist Staffing Hours per Resident Per Day, 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 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 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, 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
82 | 82 | 410 NORTH 30TH STREET ENID, OK 73701 | 36.400323 | -97.836807 | 0 | 375182 | ENID SENIOR CARE | 410 NORTH 30TH STREET | ENID | OK | 73701 | 5802371973 | 230 | Garfield | For profit - Individual | 102 | 53.4 | Medicare and Medicaid | false | SENIOR NH LLC | 08/01/1994 | false | false | false | false | Resident | Yes | 2 | 2 | 5 | 5 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 04/04/2019 | 10 | 10 | 0 | 80 | 2 | 40 | 120 | 05/21/2018 | 7 | 7 | 0 | 48 | 1 | 0 | 48 | 2017-06-23 | 11 | 11 | 0 | 1 | 64 | 0 | 64 | 86.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 410 NORTH 30TH STREET ENID, OK 73701 (36.400323, -97.836807) | 02/01/2020 | |||||||||||||||||||||
1455 | 1455 | 10801 JOHNSON BLVD SEMINOLE, FL 33772 | 27.841996 | -82.790155 | 0 | 106042 | FREEDOM SQUARE REHABILITATION & NURSING SERVICES | 10801 JOHNSON BLVD | SEMINOLE | FL | 33772 | 7273980379 | 510 | Pinellas | For profit - Corporation | 116 | 101.8 | Medicare and Medicaid | false | CCRC OPCO FREEDOM SQUARE LLC | 02/19/2002 | true | false | false | false | Resident | Yes | 2 | 1 | 5 | 4 | 5 | 3 | 3 | 2.70004 | 1.04227 | 0.74628 | 1.78855 | 4.48859 | 0.138 | 2.14994 | 0.77177 | 0.39762 | 3.31934 | 2.61011 | 1.01549 | 0.70641 | 4.33622 | 10/05/2018 | 15 | 15 | 2 | 80 | 2 | 40 | 120 | 09/29/2017 | 12 | 8 | 4 | 48 | 1 | 0 | 48 | 2017-01-06 | 7 | 7 | 0 | 1 | 32 | 0 | 32 | 81.333 | 0 | 3 | 1 | 13878.00 | 0 | 1 | 10801 JOHNSON BLVD SEMINOLE, FL 33772 (27.841996, -82.790155) | 02/01/2020 | |||||||||||
4561 | 4561 | 9191 N AMBASSADOR DRIVE KANSAS CITY, MO 64154 | 39.262192 | -94.649476 | 0 | 265863 | TIFFANY SPRINGS REHABILITATION & HEALTH CARE CENTE | 9191 N AMBASSADOR DRIVE | KANSAS CITY | MO | 64154 | 8167415570 | 820 | Platte | For profit - Corporation | 120 | 100.4 | Medicare and Medicaid | false | TIFFANY SPRINGS REHABILITATION & HEALTH CARE CENTER LLC | 10/16/2017 | true | false | false | false | Resident | Yes | 2 | 1 | 4 | 3 | 5 | 4 | 4 | 2.32324 | 0.60252 | 0.84551 | 1.44802 | 3.77127 | 0 | 1.91925 | 0.69235 | 0.30734 | 2.91894 | 2.51581 | 0.65437 | 1.03545 | 4.143 | 07/15/2019 | 13 | 12 | 1 | 80 | 2 | 40 | 120 | 12/04/2018 | 23 | 17 | 8 | 227 | 1 | 0 | 227 | 2017-10-16 | 1 | 0 | 1 | 0 | 4 | 0 | 4 | 136.333 | 2 | 8 | 1 | 11278.00 | 1 | 2 | 9191 N AMBASSADOR DRIVE KANSAS CITY, MO 64154 (39.262192, -94.649476) | 02/01/2020 | |||||||||||
9244 | 9244 | 637 ASH STREET MYRTLE POINT, OR 97458 | 43.065556 | -124.139867 | 0 | 385254 | MYRTLE POINT CARE CENTER | 637 ASH STREET | MYRTLE POINT | OR | 97458 | 5415722066 | 50 | Coos | For profit - Partnership | 35 | 25.4 | Medicare and Medicaid | false | CARE CENTERS MANAGEMENT, INC. | 06/12/1997 | true | false | false | false | Resident | Yes | 1 | 2 | 1 | 2 | 1 | 3 | 2 | 3.02892 | 0.87328 | 0.46688 | 1.34016 | 4.36909 | 0 | 2.11679 | 0.72847 | 0.37422 | 3.21948 | 2.9739 | 0.90142 | 0.46959 | 4.35169 | 10/31/2018 | 13 | 11 | 12 | 80 | 2 | 40 | 120 | 07/14/2017 | 14 | 14 | 0 | 76 | 2 | 38 | 114 | 2016-06-17 | 9 | 8 | 1 | 1 | 44 | 0 | 44 | 105.333 | 2 | 4 | 0 | 0.00 | 1 | 1 | 637 ASH STREET MYRTLE POINT, OR 97458 (43.065556, -124.139867) | 02/01/2020 | |||||||||||
10185 | 10185 | 1883 SHUMWAY HILL ROAD WELLSBORO, PA 16901 | 41.742176 | -77.270164 | 0 | 395352 | BROAD ACRES HEALTH AND REHAB | 1883 SHUMWAY HILL ROAD | WELLSBORO | PA | 16901 | 5707243559 | 710 | Tioga | Non profit - Corporation | 120 | 109.3 | Medicare and Medicaid | false | BROAD ACRES NURSING HOME ASSOCIATION | 11/01/1978 | false | false | false | false | Resident | Yes | 1 | 1 | 3 | 2 | 4 | 2 | 2 | 2.1703 | 0.85844 | 0.47212 | 1.33057 | 3.50087 | 0.08987 | 2.22279 | 0.84645 | 0.4455 | 3.51474 | 2.02926 | 0.76259 | 0.39888 | 3.194 | 05/17/2019 | 15 | 15 | 0 | 80 | 2 | 40 | 120 | 06/08/2018 | 22 | 22 | 1 | 104 | 1 | 0 | 104 | 2017-07-20 | 15 | 12 | 3 | 2 | 76 | 38 | 114 | 113.667 | 0 | 3 | 0 | 0.00 | 0 | 0 | 1883 SHUMWAY HILL ROAD WELLSBORO, PA 16901 (41.742176, -77.270164) | 02/01/2020 | |||||||||||
11675 | 11675 | 13700 NORTH GAYTON ROAD RICHMOND, VA 23233 | 37.654951 | -77.635362 | 0 | 495311 | OUR LADY OF HOPE HEALTH CENTER | 13700 NORTH GAYTON ROAD | RICHMOND | VA | 23233 | 8043601960 | 430 | Henrico | Non profit - Church related | 75 | 71 | Medicare and Medicaid | false | OUR LADY OF HOPE HEALTH CENTER, INC | 08/01/1996 | false | false | false | false | Resident | Yes | 2 | 2 | 5 | 5 | 5 | 1 | 12 | 1 | 12 | 0.89553 | 0.54001 | 0.44596 | 0.98598 | 1.88151 | 0.11288 | 2.14902 | 0.76361 | 0.36981 | 3.28244 | 0.86608 | 0.53176 | 0.45389 | 1.83807 | 12/20/2018 | 11 | 11 | 0 | 80 | 2 | 40 | 120 | 10/19/2017 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 2016-10-13 | 15 | 15 | 0 | 1 | 68 | 0 | 68 | 72.667 | 0 | 0 | 1 | 13806.00 | 0 | 1 | 13700 NORTH GAYTON ROAD RICHMOND, VA 23233 (37.654951, -77.635362) | 02/01/2020 | |||||||||
12007 | 12007 | 22 ROBERT R KASIN WAY BEACON, NY 12508 | 41.521247 | -73.972839 | 0 | 335750 | FISHKILL CENTER FOR REHABILITATION AND NURSING | 22 ROBERT R. KASIN WAY | BEACON | NY | 12508 | 8458318704 | 230 | Dutchess | For profit - Corporation | 160 | 151.4 | Medicare and Medicaid | false | YERTLE OPERATIONS LLC | 10/25/1991 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2.08314 | 1.03619 | 0.36605 | 1.40223 | 3.48537 | 0.08944 | 1.99665 | 0.8325 | 0.43745 | 3.2666 | 2.16837 | 0.93592 | 0.31495 | 3.42142 | 06/06/2018 | 18 | 18 | 9 | 80 | 2 | 40 | 120 | 02/16/2017 | 6 | 6 | 0 | 32 | 1 | 0 | 32 | 2015-12-21 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 72 | 5 | 7 | 0 | 0.00 | 0 | 0 | 22 ROBERT R KASIN WAY BEACON, NY 12508 (41.521247, -73.972839) | 02/01/2020 | |||||||||||
12888 | 12888 | 3309 45TH STREET COURT NORTHWEST GIG HARBOR, WA 98335 | 47.299604 | -122.583235 | 0 | 505436 | MANOR CARE OF GIG HARBOR WA, LLC | 3309 45TH STREET COURT NORTHWEST | GIG HARBOR | WA | 98335 | 2538588688 | 260 | Pierce | Non profit - Corporation | 120 | 82.6 | Medicare and Medicaid | false | MANOR CARE OF GIG HARBOR WA LLC | 01/01/1992 | false | false | false | false | Resident | Yes | 2 | 1 | 4 | 4 | 5 | 4 | 4 | 2.38947 | 0.80156 | 0.66711 | 1.46867 | 3.85814 | 0.04087 | 2.06495 | 0.69723 | 0.31786 | 3.08004 | 2.40496 | 0.86446 | 0.78994 | 4.01675 | 10/03/2019 | 16 | 15 | 1 | 80 | 2 | 40 | 120 | 07/23/2018 | 40 | 23 | 17 | 393 | 1 | 0 | 393 | 2017-09-01 | 17 | 16 | 1 | 1 | 132 | 0 | 132 | 213 | 11 | 13 | 3 | 60879.00 | 0 | 3 | 3309 45TH STREET COURT NORTHWEST GIG HARBOR, WA 98335 (47.299604, -122.583235) | 02/01/2020 | |||||||||||
15097 | 15097 | 55 LOGAN MINGO MENTAL HEALTH CENTER ROAD LOGAN, WV 25601 | 37.82741 | -81.944952 | 0 | 515175 | LOGAN CENTER | 55 LOGAN MINGO MENTAL HEALTH CENTER ROAD | LOGAN | WV | 25601 | 3047522273 | 220 | Logan | For profit - Partnership | 66 | 64.4 | Medicare and Medicaid | false | THREE MILE CURVE OPERATIONS LLC | 09/10/2001 | false | false | false | false | Resident | Yes | 2 | 2 | 3 | 2 | 4 | 2 | 2 | 1.81772 | 1.02098 | 0.48383 | 1.50482 | 3.32253 | 0.00791 | 2.19583 | 0.77678 | 0.37062 | 3.34322 | 1.72046 | 0.98834 | 0.49136 | 3.18682 | 09/19/2018 | 14 | 13 | 1 | 80 | 2 | 40 | 120 | 09/28/2017 | 16 | 16 | 3 | 72 | 1 | 0 | 72 | 2016-07-21 | 7 | 1 | 6 | 1 | 36 | 0 | 36 | 90 | 0 | 5 | 1 | 8648.00 | 0 | 1 | 55 LOGAN MINGO MENTAL HEALTH CENTER ROAD LOGAN, WV 25601 (37.82741, -81.944952) | 02/01/2020 | |||||||||||
15230 | 15230 | 255 MIDLAND PARKWAY SUMMERVILLE, SC 29485 | 32.965085 | -80.160579 | 0 | 425326 | HALLMARK HEALTHCARE CENTER | 255 MIDLAND PARKWAY | SUMMERVILLE | SC | 29485 | 8438215005 | 170 | Dorchester | For profit - Corporation | 88 | 80.9 | Medicare and Medicaid | false | Legal Business Name Not Available | 11/13/1992 | false | false | false | false | Resident | Yes | 2 | 1 | 4 | 3 | 5 | 4 | 4 | 2.0098 | 0.88724 | 0.68589 | 1.57313 | 3.58294 | 0.06285 | 2.06286 | 0.72459 | 0.33818 | 3.12563 | 2.02488 | 0.92073 | 0.76338 | 3.67582 | 11/02/2018 | 16 | 16 | 0 | 80 | 2 | 40 | 120 | 08/18/2017 | 19 | 19 | 0 | 100 | 1 | 0 | 100 | 2016-09-22 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 94.667 | 0 | 0 | 1 | 18223.00 | 0 | 1 | 255 MIDLAND PARKWAY SUMMERVILLE, SC 29485 (32.965085, -80.160579) | 02/01/2020 | |||||||||||
15300 | 15300 | 2031 POTTERY AVENUE PORT ORCHARD, WA 98366 | 47.51691 | -122.652379 | 0 | 505210 | LIFE CARE CENTER OF PORT ORCHARD | 2031 POTTERY AVENUE | PORT ORCHARD | WA | 98366 | 3608768035 | 170 | Kitsap | For profit - Corporation | 125 | 87.4 | Medicare and Medicaid | false | PORT ORCHARD OPERATIONS, LLC | 08/01/1979 | false | false | false | false | Resident | Yes | 2 | 2 | 4 | 5 | 4 | 3 | 3 | 2.01163 | 1.2122 | 0.4618 | 1.674 | 3.68563 | 0.11933 | 2.00505 | 0.69844 | 0.32017 | 3.02366 | 2.08516 | 1.30506 | 0.54288 | 3.9087 | 01/30/2019 | 15 | 15 | 3 | 80 | 2 | 40 | 120 | 11/20/2017 | 5 | 5 | 0 | 24 | 1 | 0 | 24 | 2016-10-12 | 19 | 19 | 0 | 1 | 633 | 0 | 633 | 173.5 | 1 | 0 | 0 | 0.00 | 0 | 0 | 2031 POTTERY AVENUE PORT ORCHARD, WA 98366 (47.51691, -122.652379) | 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 );