nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
6 rows where Physical Therapist Staffing Footnote = 6 and Rating Cycle 2 Number of Complaint Health Deficiencies = 8
This data as json, copyable, CSV (advanced)
Suggested facets: ownership, Special Focus Status, Provider Changed Ownership in Last 12 Months, 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, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Number of Health Revisits, Rating Cycle 2 Number of Health Revisits, Rating Cycle 2 Health Revisit Score, Rating Cycle 3 Number of Complaint Health Deficiencies, Rating Cycle 3 Number of Health Revisits, Rating Cycle 3 Health Revisit 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26 | 26 | 700 E 21ST AVE GARY, IN 46407 | 41.58031 | -87.327837 | 0 | 155845 | SIMMONS LOVING CARE HEALTH FACILITY | 700 E 21ST AVE | GARY | IN | 46407 | 2198822563 | 440 | Lake | Non profit - Corporation | 46 | 18.7 | Medicare and Medicaid | false | PULASKI MEMORIAL HOSPITAL | 04/26/2016 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 6 | 6 | 11/20/2019 | 34 | 27 | 7 | 321 | 0 | 0 | 321 | 03/28/2019 | 42 | 34 | 8 | 260 | 1 | 0 | 260 | 2018-06-14 | 38 | 27 | 11 | 2 | 264 | 132 | 396 | 313.167 | 0 | 27 | 1 | 13673.00 | 2 | 3 | 700 E 21ST AVE GARY, IN 46407 (41.58031, -87.327837) | 02/01/2020 | ||||||||||||||||||||||
108 | 108 | 1260 WILLIAMS WAY YUBA CITY, CA 95991 | 39.150861 | -121.632461 | 0 | 555430 | FOUNTAINS, THE | 1260 WILLIAMS WAY | YUBA CITY | CA | 95991 | 5307514888 | 610 | Sutter | Non profit - Corporation | 145 | 130.6 | Medicare and Medicaid | false | UNITED COM-SERVE | 08/20/1990 | false | false | false | false | Resident | Yes | 4 | 4 | 5 | 5 | 5 | 1 | 12 | 1 | 12 | 6 | 6 | 08/24/2019 | 5 | 4 | 1 | 36 | 1 | 0 | 36 | 07/13/2018 | 8 | 8 | 8 | 52 | 1 | 0 | 52 | 2017-06-30 | 10 | 10 | 0 | 1 | 52 | 0 | 52 | 44 | 1 | 1 | 0 | 0.00 | 0 | 0 | 1260 WILLIAMS WAY YUBA CITY, CA 95991 (39.150861, -121.632461) | 02/01/2020 | |||||||||||||||||||||
1985 | 1985 | 3910 RAINBOW BLVD KANSAS CITY, KS 66103 | 39.056897 | -94.611883 | 0 | 175544 | IGNITE MEDICAL RESORT A PTR OF THE UNIV OF KANSAS | 3910 RAINBOW BLVD, SUITE 400 | KANSAS CITY | KS | 66103 | 9139018462 | 986 | Wyandotte | For profit - Corporation | 96 | 63.6 | Medicare and Medicaid | false | IGNITE MEDICAL RESORT A PTR OF THE UNIV OF KANSAS HEALTH SYSTEM LLC | 06/17/2014 | false | false | false | true | Resident | Yes | 1 | 1 | 4 | 4 | 3 | 2 | 2 | 6 | 6 | 01/07/2019 | 12 | 12 | 10 | 84 | 1 | 0 | 84 | 05/15/2017 | 9 | 4 | 8 | 80 | 1 | 0 | 80 | 2015-10-07 | 19 | 17 | 2 | 1 | 203 | 0 | 203 | 102.5 | 2 | 8 | 3 | 32675.00 | 0 | 3 | 3910 RAINBOW BLVD KANSAS CITY, KS 66103 (39.056897, -94.611883) | 02/01/2020 | |||||||||||||||||||||||
4649 | 4649 | 1149 WEST MONROE RD SAINT LOUIS, MI 48880 | 43.407893 | -84.629322 | 0 | 235324 | RIVERSIDE HEALTHCARE CENTER | 1149 WEST MONROE RD | SAINT LOUIS | MI | 48880 | 9896813852 | 280 | Gratiot | For profit - Corporation | 39 | 12 | Medicare and Medicaid | false | RIVERSIDE HEALTHCARE CENTER LLC | 01/01/1977 | false | false | false | true | Resident | Yes | 2 | 2 | 4 | 4 | 2 | 2 | 2 | 6 | 6 | 04/25/2019 | 13 | 13 | 0 | 80 | 1 | 0 | 80 | 04/26/2018 | 17 | 9 | 8 | 96 | 1 | 0 | 96 | 2017-07-13 | 24 | 18 | 6 | 1 | 180 | 0 | 180 | 102 | 18 | 10 | 0 | 0.00 | 0 | 0 | 1149 WEST MONROE RD SAINT LOUIS, MI 48880 (43.407893, -84.629322) | 02/01/2020 | |||||||||||||||||||||||
7184 | 7184 | 2829 SOUTH CALIFORNIA BLVD CHICAGO, IL 60608 | 41.840642 | -87.694262 | 0 | 145625 | CALIFORNIA GARDENS N & REHAB C | 2829 SOUTH CALIFORNIA BLVD | CHICAGO | IL | 60608 | 7738478061 | 141 | Cook | For profit - Individual | 297 | 281 | Medicare and Medicaid | false | SYMPHONY OF CALIFORNIA GARDENS LLC | 06/09/1989 | false | false | false | true | Resident | Yes | 1 | 1 | 4 | 5 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 10/23/2019 | 26 | 24 | 2 | 176 | 1 | 0 | 176 | 09/13/2018 | 24 | 16 | 8 | 128 | 1 | 0 | 128 | 2017-08-11 | 9 | 5 | 4 | 1 | 68 | 0 | 68 | 142 | 0 | 13 | 1 | 12760.00 | 1 | 2 | 2829 SOUTH CALIFORNIA BLVD CHICAGO, IL 60608 (41.840642, -87.694262) | 02/01/2020 | |||||||||||||||||||||
10283 | 10283 | 2715 SOUTH ISLAND ROAD GEORGETOWN, SC 29440 | 33.331593 | -79.29852 | 0 | 425048 | BLUE RIDGE IN GEORGETOWN | 2715 SOUTH ISLAND ROAD | GEORGETOWN | SC | 29440 | 8435464123 | 210 | Georgetown | For profit - Corporation | 84 | 64.3 | Medicare and Medicaid | false | BLUE RIDGE IN GEORGETOWN LLC | 10/01/1974 | false | SFF Candidate | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 07/19/2019 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 10/16/2018 | 33 | 25 | 8 | 520 | 2 | 260 | 780 | 2017-03-30 | 11 | 11 | 0 | 1 | 56 | 0 | 56 | 269.333 | 4 | 0 | 2 | 43907.00 | 1 | 3 | 2715 SOUTH ISLAND ROAD GEORGETOWN, SC 29440 (33.331593, -79.29852) | 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 );