nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
7 rows where Rating Cycle 1 Health Revisit Score = 64
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, ownership, Date First Approved to Provide Medicare and Medicaid services, Special Focus Status, Abuse Icon, With a Resident and Family Council, 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, 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 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 Health Deficiency 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
543 | 543 | 725 SECOND AVENUE SOUTH HOPKINS, MN 55343 | 44.911789 | -93.403405 | 0 | 245293 | HOPKINS HEALTH SERVICES | 725 SECOND AVENUE SOUTH | HOPKINS | MN | 55343 | 9529353338 | 260 | Hennepin | For profit - Corporation | 118 | 82.4 | Medicare and Medicaid | false | NSH HOPKINS LLC | 10/01/1985 | false | false | false | false | Resident | Yes | 2 | 1 | 4 | 3 | 5 | 4 | 5 | 1.82154 | 0.84248 | 1.0123 | 1.85478 | 3.67632 | 0.1003 | 2.02185 | 0.7228 | 0.35065 | 3.0953 | 1.87242 | 0.87645 | 1.08658 | 3.80858 | 03/21/2019 | 24 | 20 | 6 | 128 | 2 | 64 | 192 | 01/11/2018 | 11 | 9 | 2 | 44 | 1 | 0 | 44 | 2016-11-03 | 13 | 13 | 0 | 1 | 60 | 0 | 60 | 120.667 | 2 | 3 | 0 | 0.00 | 0 | 0 | 725 SECOND AVENUE SOUTH HOPKINS, MN 55343 (44.911789, -93.403405) | 02/01/2020 | |||||||||||
568 | 568 | 505 GREENBANK ROAD WILMINGTON, DE 19808 | 39.739856 | -75.633112 | 0 | 85004 | BRANDYWINE NURSING & REHABILITATION CENTER | 505 GREENBANK ROAD | WILMINGTON | DE | 19808 | 3029980101 | 10 | New Castle | For profit - Corporation | 169 | 165.9 | Medicare and Medicaid | false | BRANDYWINE NURSING AND REHABILITATION INC | 01/01/1967 | false | SFF | true | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.19941 | 0.99744 | 0.5479 | 1.54534 | 3.74476 | 0.03344 | 2.00194 | 0.65736 | 0.28438 | 2.94369 | 2.28335 | 1.14095 | 0.72515 | 4.07929 | 10/25/2018 | 20 | 20 | 19 | 128 | 2 | 64 | 192 | 07/19/2017 | 32 | 16 | 32 | 208 | 1 | 0 | 208 | 2016-08-01 | 9 | 9 | 0 | 1 | 44 | 0 | 44 | 172.667 | 4 | 16 | 3 | 98946.00 | 1 | 4 | 505 GREENBANK ROAD WILMINGTON, DE 19808 (39.739856, -75.633112) | 02/01/2020 | ||||||||||
1432 | 1432 | 3615 E IMPERIAL HIWY LYNWOOD, CA 90262 | 33.930954 | -118.203977 | 0 | 55052 | CALIFORNIA POST-ACUTE CARE | 3615 E. IMPERIAL HIWY | LYNWOOD | CA | 90262 | 3106394623 | 200 | Los Angeles | For profit - Limited Liability company | 130 | 120.2 | Medicare and Medicaid | false | CALIFORNIA POST-ACUTE CARE LLC | 01/01/1967 | false | false | false | false | None | Yes | 2 | 1 | 5 | 5 | 5 | 1 | 12 | 1 | 12 | 6 | 6 | 09/23/2019 | 18 | 16 | 2 | 128 | 2 | 64 | 192 | 09/13/2018 | 36 | 25 | 11 | 304 | 1 | 0 | 304 | 2017-10-12 | 23 | 14 | 9 | 1 | 128 | 0 | 128 | 218.667 | 16 | 11 | 1 | 48000.00 | 0 | 1 | 3615 E IMPERIAL HIWY LYNWOOD, CA 90262 (33.930954, -118.203977) | 02/01/2020 | |||||||||||||||||||||
3225 | 3225 | 66 BROAD STREET WESTFIELD, MA 01085 | 42.116474 | -72.747914 | 0 | 225313 | GOVERNORS CENTER | 66 BROAD STREET | WESTFIELD | MA | 1085 | 4135625464 | 70 | Hampden | Non profit - Corporation | 100 | 86 | Medicare and Medicaid | false | THE NORTHEAST HEALTH GROUP, INC | 07/11/1988 | false | false | false | false | Resident | Yes | 1 | 1 | 4 | 3 | 5 | 2 | 2 | 1.75657 | 0.84064 | 0.31274 | 1.15339 | 2.90996 | 0.11927 | 2.03535 | 0.68335 | 0.33201 | 3.0507 | 1.79367 | 0.92503 | 0.35455 | 3.05872 | 08/02/2019 | 17 | 17 | 0 | 128 | 2 | 64 | 192 | 04/05/2018 | 19 | 12 | 7 | 120 | 1 | 0 | 120 | 2016-12-28 | 2 | 2 | 0 | 1 | 40 | 0 | 40 | 142.667 | 0 | 2 | 2 | 128261.00 | 0 | 2 | 66 BROAD STREET WESTFIELD, MA 01085 (42.116474, -72.747914) | 02/01/2020 | |||||||||||
7808 | 7808 | 1616 WEISENBORN ROAD SAINT JOSEPH, MO 64507 | 39.752035 | -94.771709 | 0 | 265827 | RIVERSIDE PLACE | 1616 WEISENBORN ROAD | SAINT JOSEPH | MO | 64507 | 8162329874 | 100 | Buchanan | For profit - Corporation | 90 | 64.5 | Medicare and Medicaid | false | DIVERSICARE OF RIVERSIDE, LLC. | 04/01/2009 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 4 | 3 | 2.45941 | 0.93726 | 0.53991 | 1.47718 | 3.93659 | 0.07914 | 1.83847 | 0.66802 | 0.31235 | 2.81884 | 2.7803 | 1.055 | 0.6506 | 4.47819 | 04/05/2019 | 17 | 14 | 4 | 128 | 2 | 64 | 192 | 06/22/2018 | 10 | 10 | 0 | 72 | 1 | 0 | 72 | 2017-06-22 | 10 | 5 | 5 | 1 | 44 | 0 | 44 | 127.333 | 0 | 17 | 0 | 0.00 | 1 | 1 | 1616 WEISENBORN ROAD SAINT JOSEPH, MO 64507 (39.752035, -94.771709) | 02/01/2020 | |||||||||||
8996 | 8996 | 1315 S UNIVERSITY DR FARGO, ND 58103 | 46.860822 | -96.798404 | 0 | 355024 | THE MEADOWS ON UNIVERSITY | 1315 S UNIVERSITY DR | FARGO | ND | 58103 | 7012373030 | 80 | Cass | For profit - Corporation | 110 | 59.9 | Medicare and Medicaid | false | FARGO NURSING AND REHAB CENTER LLC | 03/21/1967 | false | SFF Candidate | false | false | false | Resident | Yes | 2 | 1 | 3 | 1 | 4 | 4 | 4 | 2.78784 | 1.34827 | 0.85151 | 2.19977 | 4.98761 | 0.26828 | 2.0838 | 0.8193 | 0.4153 | 3.31839 | 2.78054 | 1.23742 | 0.77172 | 4.81968 | 05/16/2019 | 20 | 20 | 19 | 128 | 2 | 64 | 192 | 06/28/2018 | 18 | 11 | 10 | 96 | 1 | 0 | 96 | 2017-05-10 | 8 | 8 | 8 | 1 | 36 | 0 | 36 | 134 | 0 | 10 | 1 | 68621.00 | 0 | 1 | 1315 S UNIVERSITY DR FARGO, ND 58103 (46.860822, -96.798404) | 02/01/2020 | ||||||||||
11214 | 11214 | 31741 RANCHO VIEJO ROAD SAN JUAN CAPISTRANO, CA 92675 | 33.501717 | -117.65365 | 0 | 555763 | BROOKDALE SAN JUAN CAPISTRANO | 31741 RANCHO VIEJO ROAD | SAN JUAN CAPISTRANO | CA | 92675 | 9492488855 | 400 | Orange | For profit - Limited Liability company | 45 | 40.1 | Medicare and Medicaid | false | S-H OPCO SAN JUAN CAPISTRANO LLC | 08/31/2000 | false | false | false | false | Resident | Yes | 1 | 1 | 4 | 2 | 4 | 3 | 2 | 2.9688 | 1.52645 | 0.72124 | 2.24769 | 5.21649 | 0.24925 | 2.33331 | 1.01159 | 0.54458 | 3.88947 | 2.64439 | 1.13465 | 0.49849 | 4.30072 | 09/10/2019 | 23 | 19 | 6 | 128 | 2 | 64 | 192 | 10/16/2018 | 20 | 14 | 6 | 84 | 1 | 0 | 84 | 2017-10-19 | 9 | 9 | 0 | 1 | 36 | 0 | 36 | 130 | 0 | 6 | 0 | 0.00 | 0 | 0 | 31741 RANCHO VIEJO ROAD SAN JUAN CAPISTRANO, CA 92675 (33.501717, -117.65365) | 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 );