nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
7 rows where Overall Rating = 3 and Rating Cycle 2 Number of Complaint Health Deficiencies = 14
This data as json, copyable, CSV (advanced)
Suggested facets: ownership, Date First Approved to Provide Medicare and Medicaid services, Continuing Care Retirement Community, Abuse Icon, Most Recent Health Inspection More Than 2 Years Ago, With a Resident and Family Council, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Staffing Rating, RN Staffing Rating, Rating Cycle 1 Number of Standard Health Deficiencies, Rating Cycle 1 Number of Health Revisits, Rating Cycle 2 Total Number of Health Deficiencies, Rating Cycle 2 Health Deficiency Score, Rating Cycle 2 Total Health Score, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1165 | 1165 | 531 STEVENSON LANE TOWSON, MD 21286 | 39.384138 | -76.6037 | 0 | 215204 | HOLLY HILL HEALTHCARE CENTER | 531 STEVENSON LANE | TOWSON | MD | 21286 | 4108235310 | 20 | Baltimore | For profit - Corporation | 75 | 69.7 | Medicare and Medicaid | false | HOLLY HILL NURSING, LLC | 06/01/1989 | true | false | true | false | Both | Yes | 3 | 2 | 3 | 3 | 3 | 4 | 4 | 2.09463 | 0.83562 | 0.91426 | 1.74988 | 3.84452 | 0.07574 | 2.17655 | 0.807 | 0.42726 | 3.4108 | 2.00012 | 0.77861 | 0.80539 | 3.61441 | 12/13/2017 | 23 | 17 | 7 | 88 | 1 | 0 | 88 | 12/02/2016 | 23 | 9 | 14 | 144 | 1 | 0 | 144 | 2015-09-21 | 16 | 15 | 1 | 1 | 92 | 0 | 92 | 107.333 | 6 | 14 | 0 | 0.00 | 0 | 0 | 531 STEVENSON LANE TOWSON, MD 21286 (39.384138, -76.6037) | 02/01/2020 | |||||||||||
6772 | 6772 | 2400 PORTAGE ST KALAMAZOO, MI 49001 | 42.266639 | -85.56998 | 0 | 235050 | HAROLD AND GRACE UPJOHN COMMUNITY CARE CENTER | 2400 PORTAGE ST | KALAMAZOO | MI | 49001 | 2693814290 | 380 | Kalamazoo | Non profit - Corporation | 90 | 81.6 | Medicare and Medicaid | false | HAROLD AND GRACE UPJOHN COMMUNITY CARE CENTER | 01/01/1967 | true | true | false | false | Resident | Yes | 3 | 2 | 4 | 4 | 5 | 5 | 5 | 2.44436 | 0.82994 | 1.14888 | 1.97882 | 4.42318 | 0.10394 | 2.1954 | 0.71993 | 0.36918 | 3.28451 | 2.31402 | 0.86684 | 1.17131 | 4.31835 | 12/19/2019 | 15 | 12 | 3 | 100 | 0 | 0 | 100 | 09/28/2018 | 20 | 6 | 14 | 206 | 1 | 0 | 206 | 2017-08-30 | 18 | 12 | 6 | 1 | 116 | 0 | 116 | 138 | 26 | 35 | 1 | 75036.00 | 0 | 1 | 2400 PORTAGE ST KALAMAZOO, MI 49001 (42.266639, -85.56998) | 02/01/2020 | |||||||||||
7647 | 7647 | 210 NORTH SPRINGFIELD AVENUE JOLIET, IL 60435 | 41.525737 | -88.137606 | 0 | 145029 | PRESENCE VILLA FRANCISCAN | 210 NORTH SPRINGFIELD AVENUE | JOLIET | IL | 60435 | 8157253400 | 989 | Will | Non profit - Corporation | 154 | 105.6 | Medicare and Medicaid | false | PRESENCE LIFE CONNECTIONS | 01/01/1967 | false | false | false | false | Both | Yes | 3 | 2 | 2 | 2 | 3 | 4 | 5 | 2.12828 | 0.25645 | 1.74737 | 2.00382 | 4.13211 | 0.14117 | 2.13219 | 0.8449 | 0.43221 | 3.40931 | 2.07453 | 0.22823 | 1.52166 | 3.88649 | 09/18/2019 | 10 | 8 | 2 | 72 | 1 | 0 | 72 | 10/26/2018 | 22 | 8 | 14 | 148 | 1 | 0 | 148 | 2017-09-21 | 10 | 8 | 2 | 1 | 68 | 0 | 68 | 96.667 | 0 | 15 | 1 | 45546.00 | 1 | 2 | 210 NORTH SPRINGFIELD AVENUE JOLIET, IL 60435 (41.525737, -88.137606) | 02/01/2020 | |||||||||||
11055 | 11055 | 8643 NE BEECH STREET PORTLAND, OR 97220 | 45.549566 | -122.573689 | 0 | 385258 | PARK FOREST CARE CENTER | 8643 NE BEECH STREET | PORTLAND | OR | 97220 | 5032562151 | 250 | Multnomah | For profit - Partnership | 55 | 37.6 | Medicare and Medicaid | false | CARE CENTER (PARK FOREST), INC. | 06/01/1998 | false | false | false | false | Resident | Yes | 3 | 2 | 4 | 2 | 5 | 4 | 4 | 2.83562 | 0.61787 | 0.84511 | 1.46297 | 4.29859 | 0.07711 | 2.02294 | 0.7552 | 0.34706 | 3.1252 | 2.91328 | 0.6152 | 0.9165 | 4.41064 | 06/04/2019 | 18 | 17 | 18 | 96 | 1 | 0 | 96 | 10/23/2017 | 14 | 7 | 14 | 104 | 1 | 0 | 104 | 2016-09-02 | 14 | 14 | 0 | 1 | 92 | 0 | 92 | 98 | 2 | 3 | 1 | 18710.00 | 0 | 1 | 8643 NE BEECH STREET PORTLAND, OR 97220 (45.549566, -122.573689) | 02/01/2020 | |||||||||||
11355 | 11355 | 1081 NORTH CHINA LAKE BOULEVARD RIDGECREST, CA 93555 | 35.640802 | -117.669852 | 0 | 555877 | RIDGECREST REGIONAL TRANSITIONAL CARE AND REHABILI | 1081 NORTH CHINA LAKE BOULEVARD | RIDGECREST | CA | 93555 | 7604463551 | 140 | Kern | Non profit - Church related | 124 | 62.9 | Medicare and Medicaid | false | RIDGECREST REGIONAL HOSPITAL | 09/11/2012 | false | false | false | false | Resident | Yes | 3 | 2 | 4 | 4 | 5 | 4 | 4 | 2.1751 | 1.51062 | 0.72516 | 2.23578 | 4.41088 | 0.02791 | 1.93803 | 0.62404 | 0.28298 | 2.84505 | 2.33257 | 1.82025 | 0.96452 | 4.97152 | 02/14/2019 | 7 | 6 | 1 | 36 | 1 | 0 | 36 | 03/15/2018 | 27 | 13 | 14 | 156 | 1 | 0 | 156 | 2017-03-16 | 20 | 11 | 9 | 1 | 148 | 0 | 148 | 94.667 | 12 | 13 | 0 | 0.00 | 0 | 0 | 1081 NORTH CHINA LAKE BOULEVARD RIDGECREST, CA 93555 (35.640802, -117.669852) | 02/01/2020 | |||||||||||
14164 | 14164 | 835 EAST VINE STREET MURRAY, UT 84107 | 40.645038 | -111.86852 | 0 | 465125 | ROCKY MOUNTAIN CARE - COTTAGE ON VINE | 835 EAST VINE STREET | MURRAY | UT | 84107 | 8016933800 | 170 | Salt Lake | Non profit - Corporation | 61 | 52.4 | Medicare and Medicaid | false | BEAVER VALLEY HOSPITAL | 05/30/1991 | false | false | false | false | Resident | Yes | 3 | 2 | 3 | 5 | 1 | 4 | 5 | 2.37073 | 0.38286 | 0.90269 | 1.28555 | 3.65628 | 0.12873 | 2.14914 | 0.72024 | 0.32329 | 3.19267 | 2.29262 | 0.39971 | 1.05095 | 3.6723 | 12/20/2018 | 13 | 12 | 4 | 80 | 1 | 0 | 80 | 10/12/2017 | 14 | 12 | 14 | 104 | 1 | 0 | 104 | 2016-06-09 | 13 | 10 | 3 | 1 | 88 | 0 | 88 | 89.333 | 0 | 11 | 0 | 0.00 | 0 | 0 | 835 EAST VINE STREET MURRAY, UT 84107 (40.645038, -111.86852) | 02/01/2020 | |||||||||||
15336 | 15336 | 4545 N 92ND ST MILWAUKEE, WI 53225 | 43.101122 | -88.027673 | 0 | 525588 | LUTHER MANOR | 4545 N 92ND ST | MILWAUKEE | WI | 53225 | 4144643880 | 390 | Milwaukee | Non profit - Corporation | 165 | 143.3 | Medicare and Medicaid | false | UNITED LUTHERAN PROGRAM FOR THE AGING, INC | 05/01/1996 | true | false | false | false | Resident | Yes | 3 | 2 | 4 | 4 | 4 | 4 | 4 | 2.67112 | 0.82382 | 0.80101 | 1.62483 | 4.29595 | 0.0524 | 2.28829 | 0.69122 | 0.30899 | 3.28849 | 2.42604 | 0.89619 | 0.97573 | 4.18904 | 12/05/2019 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 09/06/2018 | 14 | 14 | 14 | 84 | 1 | 0 | 84 | 2017-06-21 | 6 | 6 | 0 | 1 | 120 | 0 | 120 | 48 | 0 | 1 | 2 | 78409.00 | 0 | 2 | 4545 N 92ND ST MILWAUKEE, WI 53225 (43.101122, -88.027673) | 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 );