nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
8 rows where Rating Cycle 2 Health Revisit Score = 18
This data as json, copyable, CSV (advanced)
Suggested facets: ownership, nmbr_beds, Continuing Care Retirement Community, With a Resident and Family Council, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Staffing Rating, RN Staffing Rating, 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 Total Health 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 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, Number of Facility Reported Incidents, Number of Substantiated Complaints, Number of Fines, Total Amount of Fines in Dollars, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2081 | 2081 | 1500 BROAD AVENUE GULFPORT, MS 39501 | 30.369971 | -89.119459 | 0 | 255290 | DRIFTWOOD NURSING CENTER | 1500 BROAD AVENUE | GULFPORT | MS | 39501 | 2288681314 | 230 | Harrison | Government - City/county | 151 | 118.1 | Medicare and Medicaid | false | MEMORIAL HOSPITAL AT GULFPORT | 09/01/2002 | false | false | false | false | Resident | Yes | 2 | 3 | 1 | 2 | 1 | 2 | 2 | 2.27373 | 1.09481 | 0.44103 | 1.53584 | 3.80957 | 0.04166 | 2.00314 | 0.72219 | 0.34011 | 3.06545 | 2.35909 | 1.13991 | 0.48806 | 3.98507 | 11/21/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 01/16/2019 | 6 | 6 | 0 | 36 | 2 | 18 | 54 | 2017-09-22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 0 | 0 | 1 | 16994.00 | 0 | 1 | 1500 BROAD AVENUE GULFPORT, MS 39501 (30.369971, -89.119459) | 02/01/2020 | |||||||||||
4045 | 4045 | 125 BROAD STREET WEYMOUTH, MA 02188 | 42.216904 | -70.960771 | 0 | 225059 | COLONIAL REHABILITATION AND NURSING CENTER | 125 BROAD STREET | WEYMOUTH | MA | 2188 | 7813373121 | 130 | Norfolk | For profit - Corporation | 205 | 152.5 | Medicare and Medicaid | false | BANE COLONIAL LLC | 01/01/1967 | false | false | false | false | Both | Yes | 4 | 3 | 3 | 2 | 3 | 5 | 5 | 2.22632 | 0.87889 | 0.84723 | 1.72612 | 3.95244 | 0.07353 | 2.17308 | 0.66356 | 0.2957 | 3.13234 | 2.12925 | 0.99596 | 1.07841 | 4.04622 | 05/16/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 01/10/2018 | 8 | 8 | 2 | 36 | 2 | 18 | 54 | 2016-10-13 | 9 | 9 | 0 | 1 | 68 | 0 | 68 | 29.333 | 2 | 0 | 0 | 0.00 | 0 | 0 | 125 BROAD STREET WEYMOUTH, MA 02188 (42.216904, -70.960771) | 02/01/2020 | |||||||||||
4667 | 4667 | 3325 W JERWAYNE LN LECANTO, FL 34461 | 28.871793 | -82.49068 | 0 | 105870 | LIFE CARE CENTER OF CITRUS COUNTY | 3325 W JERWAYNE LN | LECANTO | FL | 34461 | 3527464434 | 80 | Citrus | For profit - Corporation | 120 | 106.5 | Medicare and Medicaid | false | CITRUS COUNTY OPERATIONS LLC | 11/15/1994 | false | false | false | false | Resident | Yes | 2 | 1 | 4 | 3 | 5 | 4 | 4 | 2.54471 | 0.90792 | 0.66561 | 1.57353 | 4.11823 | 0.05348 | 2.12912 | 0.72528 | 0.34157 | 3.19597 | 2.48401 | 0.9413 | 0.73345 | 4.13202 | 02/06/2019 | 11 | 11 | 0 | 56 | 1 | 0 | 56 | 11/02/2017 | 7 | 5 | 2 | 36 | 2 | 18 | 54 | 2016-09-29 | 15 | 11 | 4 | 1 | 88 | 0 | 88 | 60.667 | 0 | 1 | 0 | 0.00 | 0 | 0 | 3325 W JERWAYNE LN LECANTO, FL 34461 (28.871793, -82.49068) | 02/01/2020 | |||||||||||
4939 | 4939 | 1159 GEORGIA AVE S E DAWSON, GA 39842 | 31.766109 | -84.432459 | 0 | 115483 | DAWSON HEALTH AND REHABILITATION | 1159 GEORGIA AVE. S.E. | DAWSON | GA | 39842 | 2299955016 | 885 | Terrell | Non profit - Other | 74 | 64.9 | Medicare and Medicaid | false | DAWSON MANOR NURSING HOME LLC | 10/31/1989 | false | false | false | false | Resident | Yes | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2.00684 | 0.90132 | 0.4926 | 1.39392 | 3.40076 | 0.08382 | 2.09161 | 0.7124 | 0.33109 | 3.1351 | 1.9941 | 0.95134 | 0.55999 | 3.47838 | 06/28/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 04/27/2018 | 3 | 3 | 0 | 36 | 2 | 18 | 54 | 2017-05-04 | 2 | 2 | 0 | 1 | 20 | 0 | 20 | 21.333 | 0 | 0 | 1 | 21850.00 | 0 | 1 | 1159 GEORGIA AVE S E DAWSON, GA 39842 (31.766109, -84.432459) | 02/01/2020 | |||||||||||
5267 | 5267 | 701 S OAK ST WINCHESTER, IN 47394 | 40.165957 | -84.97353 | 0 | 155231 | RANDOLPH NURSING HOME | 701 S OAK ST | WINCHESTER | IN | 47394 | 7655842201 | 670 | Randolph | Non profit - Corporation | 94 | 69.5 | Medicare and Medicaid | false | DECATUR COUNTY MEMORIAL HOSPITAL | 04/06/1984 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 5 | 4 | 2 | 2 | 2.02766 | 1.21549 | 0.38407 | 1.59955 | 3.62721 | 0.08223 | 2.16766 | 0.77241 | 0.39796 | 3.33803 | 1.94411 | 1.18327 | 0.36324 | 3.48446 | 06/28/2019 | 2 | 2 | 0 | 4 | 1 | 0 | 4 | 07/27/2018 | 9 | 8 | 1 | 36 | 2 | 18 | 54 | 2017-09-25 | 6 | 4 | 2 | 1 | 44 | 0 | 44 | 27.333 | 0 | 2 | 1 | 4499.00 | 0 | 1 | 701 S OAK ST WINCHESTER, IN 47394 (40.165957, -84.97353) | 02/01/2020 | |||||||||||
9023 | 9023 | 1031 MICHIGAN AVE BUFFALO, NY 14203 | 42.900981 | -78.8628 | 0 | 335834 | HIGHPOINTE ON MICHIGAN HEALTH CARE FACILITY | 1031 MICHIGAN AVE | BUFFALO | NY | 14203 | 7167483101 | 240 | Erie | Non profit - Corporation | 300 | 282.6 | Medicare and Medicaid | false | KALEIDA HEALTH | 12/05/2001 | false | false | false | false | Resident | Yes | 3 | 2 | 5 | 5 | 5 | 3 | 3 | 2.59692 | 0.83819 | 0.99533 | 1.83352 | 4.43044 | 0.10671 | 2.21451 | 0.85956 | 0.54188 | 3.61596 | 2.43723 | 0.73324 | 0.69134 | 3.92895 | 12/21/2018 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 08/30/2017 | 7 | 6 | 1 | 36 | 2 | 18 | 54 | 2016-07-21 | 13 | 13 | 0 | 1 | 60 | 0 | 60 | 36 | 0 | 1 | 0 | 0.00 | 0 | 0 | 1031 MICHIGAN AVE BUFFALO, NY 14203 (42.900981, -78.8628) | 02/01/2020 | |||||||||||
12826 | 12826 | 303 EAST CARVER STREET DURHAM, NC 27704 | 36.042186 | -78.893139 | 0 | 345434 | CARVER LIVING CENTER | 303 EAST CARVER STREET | DURHAM | NC | 27704 | 9194713558 | 310 | Durham | For profit - Corporation | 232 | 179.7 | Medicare and Medicaid | false | CARVER HEALTHCARE LLC | 04/12/1993 | false | false | false | false | Both | Yes | 2 | 2 | 3 | 3 | 4 | 2 | 1 | 1.98302 | 1.20299 | 0.31525 | 1.51824 | 3.50127 | 0.06722 | 1.95903 | 0.77256 | 0.39421 | 3.1258 | 2.10379 | 1.17088 | 0.301 | 3.59184 | 01/11/2019 | 12 | 11 | 4 | 72 | 1 | 0 | 72 | 02/09/2018 | 7 | 5 | 3 | 36 | 2 | 18 | 54 | 2017-03-09 | 6 | 6 | 5 | 1 | 32 | 0 | 32 | 59.333 | 0 | 8 | 1 | 8684.00 | 0 | 1 | 303 EAST CARVER STREET DURHAM, NC 27704 (36.042186, -78.893139) | 02/01/2020 | |||||||||||
14511 | 14511 | 100 DOGWOOD DRIVE PHILIPSBURG, PA 16866 | 40.905713 | -78.20542 | 0 | 395533 | WINDY HILL VILLAGE OF PRESBYTERIAN HOMES | 100 DOGWOOD DRIVE | PHILIPSBURG | PA | 16866 | 8143426090 | 200 | Centre | Non profit - Corporation | 120 | 110 | Medicare and Medicaid | false | PRESBYTERIAN HOMES IN THE PRESBYTERY OF HUNTINGDON | 08/01/1982 | true | false | false | false | Resident | Yes | 2 | 3 | 3 | 3 | 3 | 1 | 1 | 2.19974 | 0.91542 | 0.48476 | 1.40018 | 3.59992 | 0.09586 | 2.30923 | 0.92579 | 0.61826 | 3.85328 | 1.9798 | 0.74352 | 0.29511 | 2.99582 | 03/29/2019 | 4 | 3 | 4 | 40 | 1 | 0 | 40 | 04/13/2018 | 5 | 5 | 0 | 36 | 2 | 18 | 54 | 2017-03-17 | 9 | 9 | 0 | 1 | 56 | 0 | 56 | 47.333 | 1 | 1 | 1 | 9701.00 | 0 | 1 | 100 DOGWOOD DRIVE PHILIPSBURG, PA 16866 (40.905713, -78.20542) | 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 );