nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
7 rows where Rating Cycle 2 Health Revisit Score = 66
This data as json, copyable, CSV (advanced)
Suggested facets: ownership, nmbr_beds, Abuse Icon, 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, Rating Cycle 1 Standard Survey Health Date, Rating Cycle 1 Number of Standard Health Deficiencies, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 2 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
387 | 387 | 611 S 13TH ST FORT PIERCE, FL 34950 | 27.441933 | -80.337175 | 0 | 105257 | FORT PIERCE HEALTH CARE | 611 S 13TH ST | FORT PIERCE | FL | 34950 | 7724645262 | 550 | St. Lucie | For profit - Corporation | 171 | 140.8 | Medicare and Medicaid | false | 611 SOUTH 13TH STREET OPERATIONS LLC | 09/09/1972 | false | false | false | false | Both | Yes | 2 | 1 | 2 | 3 | 1 | 5 | 5 | 2.57066 | 0.44008 | 0.94458 | 1.38467 | 3.95533 | 0.01366 | 1.99301 | 0.69064 | 0.31502 | 2.99867 | 2.68071 | 0.47915 | 1.12859 | 4.22968 | 09/20/2019 | 26 | 16 | 11 | 152 | 1 | 0 | 152 | 07/27/2018 | 18 | 14 | 4 | 132 | 2 | 66 | 198 | 2017-06-02 | 19 | 13 | 6 | 1 | 112 | 0 | 112 | 160.667 | 1 | 15 | 3 | 11069.00 | 0 | 3 | 611 S 13TH ST FORT PIERCE, FL 34950 (27.441933, -80.337175) | 02/01/2020 | |||||||||||
1948 | 1948 | 410 WEST 1ST NORTH REXBURG, ID 83440 | 43.828209 | -111.796039 | 0 | 135140 | MADISON CARRIAGE COVE SHORT STAY REHABILITATION | 410 WEST 1ST NORTH | REXBURG | ID | 83440 | 2083597676 | 320 | Madison | For profit - Corporation | 35 | 35.8 | Medicare and Medicaid | false | TANABELL HEALTH SERVICES, INC. | 04/23/2015 | false | false | false | false | Resident | Yes | 3 | 2 | 4 | 4 | 5 | 4 | 5 | 2.2014 | 0.42049 | 1.43382 | 1.85431 | 4.05571 | 0 | 1.98142 | 0.87637 | 0.45859 | 3.31638 | 2.30907 | 0.36079 | 1.1768 | 3.92153 | 10/12/2018 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 04/21/2017 | 17 | 17 | 15 | 132 | 2 | 66 | 198 | 2016-10-05 | 16 | 3 | 13 | 1 | 92 | 0 | 92 | 85.333 | 0 | 12 | 0 | 0.00 | 0 | 0 | 410 WEST 1ST NORTH REXBURG, ID 83440 (43.828209, -111.796039) | 02/01/2020 | |||||||||||
2881 | 2881 | 8411 SOUTH 28TH STREET FORT SMITH, AR 72908 | 35.303899 | -94.405288 | 0 | 45354 | FIANNA HILLS NURSING AND REHABILITATION CENTER | 8411 SOUTH 28TH STREET | FORT SMITH | AR | 72908 | 4796489600 | 650 | Sebastian | For profit - Limited Liability company | 102 | 91.1 | Medicare and Medicaid | false | KMJ ENTERPRISES FIANNA HILLS LLC | 01/25/2000 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 2.64373 | 1.10063 | 0.15696 | 1.25758 | 3.90131 | 0.02302 | 2.18295 | 0.73478 | 0.33549 | 3.25322 | 2.51703 | 1.12634 | 0.17609 | 3.84548 | 01/29/2019 | 9 | 8 | 1 | 80 | 1 | 0 | 80 | 03/23/2018 | 16 | 16 | 0 | 132 | 2 | 66 | 198 | 2017-02-16 | 9 | 8 | 1 | 1 | 185 | 0 | 185 | 136.833 | 2 | 0 | 3 | 36096.00 | 1 | 4 | 8411 SOUTH 28TH STREET FORT SMITH, AR 72908 (35.303899, -94.405288) | 02/01/2020 | |||||||||||
5184 | 5184 | 48 TARN TERRACE FROSTBURG, MD 21532 | 39.660536 | -78.927868 | 0 | 215277 | WEST MD HEALTH SYST FROSTBURG NRSG AND REHAB CTR | 48 TARN TERRACE | FROSTBURG | MD | 21532 | 3016891391 | 0 | Allegany | Non profit - Corporation | 88 | 66.1 | Medicare and Medicaid | false | WESTERN MARYLAND HEALTH SYSTEM CORPORATION | 08/17/1995 | false | true | false | false | Resident | Yes | 2 | 2 | 2 | 1 | 4 | 2 | 2 | 2.68638 | 0.6879 | 0.30799 | 0.99589 | 3.68227 | 0.04141 | 2.19178 | 0.70476 | 0.34318 | 3.23972 | 2.54734 | 0.73395 | 0.33778 | 3.6447 | 09/20/2019 | 6 | 6 | 1 | 24 | 1 | 0 | 24 | 03/09/2018 | 22 | 19 | 3 | 132 | 2 | 66 | 198 | 2016-12-15 | 13 | 12 | 1 | 1 | 92 | 0 | 92 | 93.333 | 6 | 4 | 1 | 10273.00 | 0 | 1 | 48 TARN TERRACE FROSTBURG, MD 21532 (39.660536, -78.927868) | 02/01/2020 | |||||||||||
6527 | 6527 | 128 NORTH HARDESTY KANSAS CITY, MO 64123 | 39.113991 | -94.51859 | 0 | 265463 | PARKVIEW HEALTHCARE | 128 NORTH HARDESTY | KANSAS CITY | MO | 64123 | 8162412020 | 470 | Jackson | For profit - Corporation | 120 | 73.1 | Medicare and Medicaid | false | GLENNON PLACE MANAGEMENT LLC | 09/01/1991 | false | false | false | false | Resident | Yes | 1 | 1 | 4 | 4 | 4 | 1 | 12 | 1 | 12 | 1.56858 | 0.53652 | 0.2693 | 0.80582 | 2.3744 | 0.00673 | 1.57748 | 0.59969 | 0.2645 | 2.44167 | 2.06661 | 0.67274 | 0.38322 | 3.11832 | 06/03/2019 | 18 | 18 | 2 | 128 | 1 | 0 | 128 | 04/13/2018 | 15 | 13 | 2 | 132 | 2 | 66 | 198 | 2017-05-16 | 22 | 22 | 0 | 1 | 156 | 0 | 156 | 156 | 2 | 5 | 0 | 0.00 | 1 | 1 | 128 NORTH HARDESTY KANSAS CITY, MO 64123 (39.113991, -94.51859) | 02/01/2020 | |||||||||
7117 | 7117 | 2300 GREAT LAKES DR DYER, IN 46311 | 41.490745 | -87.501955 | 0 | 155218 | GREAT LAKES HEALTHCARE CENTER | 2300 GREAT LAKES DR | DYER | IN | 46311 | 2193223555 | 440 | Lake | For profit - Corporation | 134 | 124.1 | Medicare and Medicaid | false | HANCOCK REGIONAL HOSPITAL | 08/10/1983 | false | false | false | false | Resident | Yes | 1 | 1 | 4 | 4 | 4 | 2 | 3 | 2.03618 | 0.79056 | 0.70407 | 1.49463 | 3.53081 | 0.04525 | 2.34146 | 0.87781 | 0.48648 | 3.70575 | 1.80736 | 0.6772 | 0.54474 | 3.05529 | 04/29/2019 | 33 | 18 | 15 | 148 | 1 | 0 | 148 | 03/08/2018 | 26 | 19 | 9 | 132 | 2 | 66 | 198 | 2017-01-24 | 37 | 21 | 16 | 1 | 176 | 0 | 176 | 169.333 | 0 | 68 | 0 | 0.00 | 0 | 0 | 2300 GREAT LAKES DR DYER, IN 46311 (41.490745, -87.501955) | 02/01/2020 | |||||||||||
13801 | 13801 | 200 WEAVER AVENUE EMPORIA, VA 23847 | 36.698976 | -77.538298 | 0 | 495375 | ACCORDIUS HEALTH AT EMPORIA | 200 WEAVER AVENUE | EMPORIA | VA | 23847 | 4346346581 | 270 | Emporia City | For profit - Corporation | 120 | 96.9 | Medicare and Medicaid | false | Legal Business Name Not Available | 03/30/2004 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 3 | 1 | 2 | 2 | 1.92373 | 0.97806 | 0.34086 | 1.31892 | 3.24265 | 0.03683 | 2.06756 | 0.74799 | 0.36099 | 3.17654 | 1.93376 | 0.98322 | 0.3554 | 3.2734 | 04/18/2019 | 19 | 19 | 0 | 84 | 1 | 0 | 84 | 01/29/2018 | 25 | 19 | 6 | 132 | 2 | 66 | 198 | 2016-12-08 | 25 | 25 | 0 | 2 | 132 | 66 | 198 | 141 | 0 | 2 | 1 | 50635.00 | 0 | 1 | 200 WEAVER AVENUE EMPORIA, VA 23847 (36.698976, -77.538298) | 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 );