nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
11 rows where Health Inspection Rating = 5 and Rating Cycle 3 Health Deficiency Score = 60
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, ownership, Provider Resides in Hospital, Legal Business Name, Continuing Care Retirement Community, With a Resident and Family Council, 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, 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 2 Health Deficiency Score, Rating Cycle 2 Number of Health Revisits, 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, Total Weighted Health Survey Score, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
220 | 220 | 395 W ANN ARBOR TRAIL PLYMOUTH, MI 48170 | 42.36899 | -83.464413 | 0 | 235507 | MEDILODGE OF PLYMOUTH | 395 W ANN ARBOR TRAIL | PLYMOUTH | MI | 48170 | 7344533983 | 810 | Wayne | For profit - Corporation | 39 | 33.6 | Medicare and Medicaid | false | PLYMOUTH OPCO LLC | 06/05/1991 | false | false | false | false | Resident | Yes | 5 | 5 | 4 | 4 | 3 | 5 | 5 | 2.11406 | 1.13038 | 1.32623 | 2.45661 | 4.57067 | 0.10392 | 2.07058 | 0.67712 | 0.29336 | 3.04106 | 2.12198 | 1.25529 | 1.70155 | 4.81957 | 07/11/2019 | 3 | 3 | 1 | 8 | 0 | 0 | 8 | 05/16/2018 | 6 | 5 | 1 | 56 | 1 | 0 | 56 | 2017-06-07 | 8 | 8 | 3 | 1 | 60 | 0 | 60 | 32.667 | 2 | 2 | 0 | 0.00 | 0 | 0 | 395 W ANN ARBOR TRAIL PLYMOUTH, MI 48170 (42.36899, -83.464413) | 02/01/2020 | |||||||||||
972 | 972 | 908 WEST ARGYLE STREET CHICAGO, IL 60640 | 41.973292 | -87.653243 | 0 | 146009 | SELFHELP HOME OF CHICAGO | 908 WEST ARGYLE STREET | CHICAGO | IL | 60640 | 7732710300 | 141 | Cook | Non profit - Corporation | 72 | 58.9 | Medicare and Medicaid | false | THE SELFHELP HOME INC | 10/03/2001 | true | false | false | false | Resident | Yes | 5 | 5 | 4 | 4 | 5 | 5 | 5 | 3.32747 | 0.36983 | 1.44831 | 1.81814 | 5.14561 | 0.11435 | 2.0976 | 0.71581 | 0.3496 | 3.16301 | 3.29691 | 0.38849 | 1.55926 | 5.21661 | 05/08/2019 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 07/12/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-06-14 | 9 | 9 | 0 | 1 | 60 | 0 | 60 | 12 | 0 | 0 | 0 | 0.00 | 0 | 0 | 908 WEST ARGYLE STREET CHICAGO, IL 60640 (41.973292, -87.653243) | 02/01/2020 | |||||||||||
2567 | 2567 | 1236 S MONROE ST MONROE, MI 48161 | 41.90522 | -83.407162 | 0 | 235274 | WELLSPRING LUTHERAN NURSING AND REHAB SERVICES | 1236 S MONROE ST | MONROE | MI | 48161 | 7342419533 | 570 | Monroe | Non profit - Corporation | 122 | 102.6 | Medicare and Medicaid | false | Legal Business Name Not Available | 04/01/1976 | false | false | false | false | Resident | Yes | 5 | 5 | 4 | 4 | 5 | 4 | 3 | 3.05129 | 1.14368 | 0.48273 | 1.6264 | 4.6777 | 0.07355 | 2.21357 | 0.70534 | 0.33453 | 3.25344 | 2.86488 | 1.21924 | 0.54313 | 4.61044 | 06/13/2019 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 07/18/2018 | 7 | 7 | 0 | 52 | 1 | 0 | 52 | 2017-05-25 | 8 | 8 | 0 | 1 | 60 | 0 | 60 | 31.333 | 0 | 0 | 1 | 8125.00 | 0 | 1 | 1236 S MONROE ST MONROE, MI 48161 (41.90522, -83.407162) | 02/01/2020 | |||||||||||
3148 | 3148 | 3280 WASHINGTON STREET PLACERVILLE, CA 95667 | 38.722854 | -120.788961 | 0 | 56243 | WESTERN SLOPE HEALTH CENTER | 3280 WASHINGTON STREET | PLACERVILLE | CA | 95667 | 5306226842 | 80 | El Dorado | For profit - Corporation | 99 | 91.2 | Medicare and Medicaid | false | ROSEBUD HOLDINGS, LLC | 07/01/1973 | false | false | false | false | Both | Yes | 5 | 5 | 3 | 4 | 2 | 4 | 3 | 2.72942 | 1.051 | 0.52156 | 1.57256 | 4.30198 | 0.21774 | 1.8973 | 0.7341 | 0.3685 | 2.9999 | 2.98985 | 1.07654 | 0.53272 | 4.59848 | 05/09/2019 | 3 | 3 | 0 | 16 | 1 | 0 | 16 | 07/19/2018 | 2 | 1 | 1 | 12 | 1 | 0 | 12 | 2017-06-23 | 13 | 13 | 0 | 1 | 60 | 0 | 60 | 22 | 0 | 2 | 0 | 0.00 | 0 | 0 | 3280 WASHINGTON STREET PLACERVILLE, CA 95667 (38.722854, -120.788961) | 02/01/2020 | |||||||||||
3693 | 3693 | 1800 EAST 13TH STREET CRETE, NE 68333 | 40.625219 | -96.941139 | 0 | 285283 | TABITHA NURSING CENTER AT CRETE | 1800 EAST 13TH STREET | CRETE | NE | 68333 | 4028266800 | 750 | Saline | For profit - Corporation | 44 | 33 | Medicare and Medicaid | false | TABITHA, INC. | 10/01/2009 | false | false | false | false | Resident | Yes | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 2.68464 | 0.76389 | 1.19546 | 1.95936 | 4.644 | 0.05343 | 2.01371 | 0.64455 | 0.28778 | 2.94604 | 2.77081 | 0.89116 | 1.56353 | 5.05483 | 07/09/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 06/27/2017 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2016-03-03 | 7 | 7 | 0 | 1 | 60 | 0 | 60 | 10 | 0 | 0 | 0 | 0.00 | 0 | 0 | 1800 EAST 13TH STREET CRETE, NE 68333 (40.625219, -96.941139) | 02/01/2020 | |||||||||||
5927 | 5927 | 37700 HARPER AVENUE CLINTON TOWNSHIP, MI 48036 | 42.573959 | -82.871417 | 0 | 235547 | LAKEPOINTE SENIOR CARE AND REHAB CENTER, L L C | 37700 HARPER AVENUE | CLINTON TOWNSHIP | MI | 48036 | 5864680827 | 490 | Macomb | For profit - Corporation | 134 | 131.1 | Medicare and Medicaid | false | LAKEPOINTE SENIOR CARE AND REHAB CENTER, LLC | 12/22/1993 | false | false | false | false | Resident | Yes | 5 | 5 | 4 | 4 | 5 | 3 | 3 | 1.96188 | 0.87809 | 0.46718 | 1.34527 | 3.30715 | 0.02992 | 1.94063 | 0.69333 | 0.30769 | 2.94165 | 2.10109 | 0.95232 | 0.57149 | 3.60509 | 09/18/2019 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 08/23/2018 | 9 | 9 | 0 | 48 | 1 | 0 | 48 | 2017-06-28 | 11 | 9 | 2 | 1 | 60 | 0 | 60 | 28 | 0 | 2 | 0 | 0.00 | 0 | 0 | 37700 HARPER AVENUE CLINTON TOWNSHIP, MI 48036 (42.573959, -82.871417) | 02/01/2020 | |||||||||||
6915 | 6915 | 210 EAST COLLEGE ENERGY, IL 62933 | 37.773915 | -89.023648 | 0 | 146045 | HELIA HEALTHCARE OF ENERGY | 210 EAST COLLEGE, PO BOX 519 | ENERGY | IL | 62933 | 6189427014 | 990 | Williamson | For profit - Corporation | 91 | 54.1 | Medicare and Medicaid | false | HELIA HEALTHCARE OF ENERGY LLC | 02/14/2003 | false | false | false | false | Family | Yes | 5 | 5 | 5 | 5 | 5 | 3 | 4 | 2.06474 | 0.4472 | 1.02135 | 1.46855 | 3.53329 | 0.08857 | 2.41715 | 0.84777 | 0.39897 | 3.66389 | 1.77533 | 0.39665 | 0.96354 | 3.09236 | 12/13/2018 | 1 | 1 | 0 | 8 | 1 | 0 | 8 | 11/17/2017 | 3 | 3 | 0 | 8 | 1 | 0 | 8 | 2016-12-16 | 11 | 9 | 2 | 1 | 60 | 0 | 60 | 16.667 | 0 | 2 | 0 | 0.00 | 0 | 0 | 210 EAST COLLEGE ENERGY, IL 62933 (37.773915, -89.023648) | 02/01/2020 | |||||||||||
8514 | 8514 | 440 STATE STREET LITTLE RIVER, KS 67457 | 38.399094 | -98.016839 | 0 | 175509 | SANDSTONE HEIGHTS | 440 STATE STREET, PO BOX 50A | LITTLE RIVER | KS | 67457 | 6208976266 | 790 | Rice | Non profit - Other | 36 | 27.1 | Medicare and Medicaid | false | RICE COUNTY HOSPITAL DISTRICT NO 2 | 10/01/2008 | true | false | false | false | Resident | Yes | 5 | 5 | 5 | 5 | 2 | 4 | 4 | 3.27825 | 1.03624 | 0.76082 | 1.79706 | 5.07531 | 0.01038 | 1.88674 | 0.69093 | 0.31592 | 2.89359 | 3.61115 | 1.12775 | 0.90643 | 5.62444 | 01/13/2020 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12/27/2018 | 1 | 0 | 1 | 4 | 0 | 0 | 4 | 2017-05-24 | 6 | 6 | 0 | 1 | 60 | 0 | 60 | 11.333 | 1 | 1 | 1 | 9298.00 | 0 | 1 | 440 STATE STREET LITTLE RIVER, KS 67457 (38.399094, -98.016839) | 02/01/2020 | |||||||||||
8827 | 8827 | 225 SOUTHWEST 35TH STREET OKLAHOMA CITY, OK 73109 | 35.429295 | -97.517744 | 0 | 375452 | SOUTH PARK EAST | 225 SOUTHWEST 35TH STREET | OKLAHOMA CITY | OK | 73109 | 4056317444 | 540 | Oklahoma | For profit - Limited Liability company | 47 | 44.6 | Medicare and Medicaid | false | PHOENIX HEALTHCARE LLC | 02/19/2004 | false | false | false | false | Resident | Yes | 5 | 5 | 2 | 2 | 2 | 2 | 2 | 2.50719 | 0.79713 | 0.20353 | 1.00066 | 3.50785 | 0.00525 | 2.19709 | 0.62873 | 0.20804 | 3.03386 | 2.37168 | 0.95334 | 0.36821 | 3.70764 | 09/11/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 08/01/2018 | 3 | 3 | 0 | 20 | 1 | 0 | 20 | 2017-06-05 | 8 | 8 | 0 | 1 | 60 | 0 | 60 | 16.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 225 SOUTHWEST 35TH STREET OKLAHOMA CITY, OK 73109 (35.429295, -97.517744) | 02/01/2020 | |||||||||||
9790 | 9790 | 1375 UNIVERSITY AVENUE HEALDSBURG, CA 95448 | 38.626583 | -122.863741 | 0 | 555590 | HEALDSBURG DISTRICT HOSPITAL DP/SNF | 1375 UNIVERSITY AVENUE | HEALDSBURG | CA | 95448 | 7074316500 | 590 | Sonoma | Government - Hospital district | 17 | 15.8 | Medicare and Medicaid | true | Legal Business Name Not Available | 03/22/1994 | false | false | false | false | None | Yes | 5 | 5 | 5 | 5 | 2 | 1 | 12 | 1 | 12 | 4.44624 | 3.39241 | 2.50248 | 5.8949 | 10.34114 | 0.01178 | 2.47972 | 1.14502 | 1.51083 | 5.13557 | 3.72654 | 2.22782 | 0.62343 | 6.45703 | 12/14/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 12/08/2017 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2016-11-10 | 6 | 6 | 0 | 1 | 60 | 0 | 60 | 16 | 0 | 0 | 0 | 0.00 | 0 | 0 | 1375 UNIVERSITY AVENUE HEALDSBURG, CA 95448 (38.626583, -122.863741) | 02/01/2020 | |||||||||
14327 | 14327 | 542 16TH STREET RAWLINS, WY 82301 | 41.789356 | -107.254294 | 0 | 535036 | RAWLINS REHABILITATION AND WELLNESS | 542 16TH STREET | RAWLINS | WY | 82301 | 3073242759 | 30 | Carbon | For profit - Corporation | 62 | 44.8 | Medicare and Medicaid | false | EMPRES AT RAWLINS LLC | 08/01/1989 | false | false | false | false | Resident | Yes | 5 | 5 | 4 | 4 | 4 | 3 | 4 | 1.91871 | 0.33026 | 0.82243 | 1.15269 | 3.0714 | 0.12432 | 1.87939 | 0.73446 | 0.34276 | 2.9566 | 2.12182 | 0.33812 | 0.90312 | 3.33117 | 05/23/2019 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 04/19/2018 | 4 | 3 | 1 | 16 | 1 | 0 | 16 | 2017-05-24 | 14 | 14 | 7 | 1 | 60 | 0 | 60 | 17.333 | 0 | 2 | 0 | 0.00 | 0 | 0 | 542 16TH STREET RAWLINS, WY 82301 (41.789356, -107.254294) | 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 );