nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
6 rows where "Rating Cycle 3 Standard Health Survey Date" is on date 2017-05-26 and Reported Staffing Footnote = 6
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, prvdr_cnty_name, prvdr_type, Special Focus Status, Abuse Icon, With a Resident and Family Council, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Long-Stay QM Rating Footnote, Short-Stay QM Rating, Short-Stay QM Rating Footnote, 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 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7703 | 7703 | 1101 WEST OUTER 21 ROAD ARNOLD, MO 63010 | 38.458431 | -90.439408 | 0 | 265509 | SOUTH COUNTY NURSING HOME INC | 1101 WEST OUTER 21 ROAD | ARNOLD | MO | 63010 | 6362965455 | 490 | Jefferson | For profit - Corporation | 153 | 74.8 | Medicare and Medicaid | false | SOUTH COUNTY NURSING HOME, INC. | 10/12/1992 | false | false | false | false | Both | Yes | 2 | 3 | 3 | 3 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 06/06/2019 | 9 | 8 | 3 | 40 | 1 | 0 | 40 | 06/15/2018 | 8 | 5 | 3 | 32 | 1 | 0 | 32 | 2017-05-26 | 12 | 12 | 1 | 1 | 72 | 0 | 72 | 42.667 | 1 | 6 | 0 | 0.00 | 0 | 0 | 1101 WEST OUTER 21 ROAD ARNOLD, MO 63010 (38.458431, -90.439408) | 02/01/2020 | |||||||||||||||||||||
7770 | 7770 | 815 SOUTH PRAIRIE STREET BETHALTO, IL 62010 | 38.897668 | -90.04048 | 0 | inf | BETHALTO CARE CENTER | 815 SOUTH PRAIRIE STREET | BETHALTO | IL | 62010 | 6183772144 | 680 | Madison | For profit - Corporation | 98 | 43.5 | Medicaid | false | Legal Business Name Not Available | 09/15/1975 | false | false | false | false | Resident | Yes | 4 | 4 | 5 | 5 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 07/18/2019 | 2 | 2 | 0 | 16 | 0 | 0 | 16 | 06/11/2018 | 6 | 6 | 0 | 24 | 1 | 0 | 24 | 2017-05-26 | 9 | 9 | 0 | 1 | 64 | 0 | 64 | 26.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 815 SOUTH PRAIRIE STREET BETHALTO, IL 62010 (38.897668, -90.04048) | 02/01/2020 | |||||||||||||||||||||
9338 | 9338 | San Lucas, Calle San Cosme, San Juan, 00926, Puerto Rico | 18.3442773 | -66.0857003 | 1 | GEOMETRIC_CENTER | 405030 | MILLENNIUM INSTITUTE FOR ADVANCE NURSING CARE INC | CALLE COSME REPARTO SAN LUCAS ENTRADA SECTOR CANEJ | RIO PIEDRAS | PR | 926 | 7877080138 | 640 | San Juan | For profit - Corporation | 35 | Medicare | false | MILLENNIUM INSTITUTE FOR ADVANCE NURSING CARE INC. | 02/12/2015 | false | false | false | false | None | Yes | 2 | 3 | 4 | 2 | 4 | 1 | 12 | 1 | 12 | 6 | 6 | 03/13/2019 | 10 | 10 | 0 | 104 | 1 | 0 | 104 | 08/24/2018 | 2 | 2 | 0 | 16 | 1 | 0 | 16 | 2017-05-26 | 12 | 12 | 0 | 1 | 136 | 0 | 136 | 80 | 0 | 0 | 1 | 5551.00 | 0 | 1 | 02/01/2020 | ||||||||||||||||||||||
11091 | 11091 | 26303 WESTERN AVE LOMITA, CA 90717 | 33.783405 | -118.310013 | 0 | 555028 | PALOS VERDES HEALTH CARE CENTER | 26303 WESTERN AVE. | LOMITA | CA | 90717 | 3107845440 | 200 | Los Angeles | For profit - Corporation | 48 | 47.4 | Medicare and Medicaid | false | ALLELO & ASSOCIATES | 10/01/1976 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 4 | 4 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 03/26/2019 | 26 | 22 | 4 | 574 | 1 | 0 | 574 | 04/15/2018 | 23 | 20 | 3 | 148 | 1 | 0 | 148 | 2017-05-26 | 16 | 14 | 2 | 1 | 96 | 0 | 96 | 352.333 | 1 | 8 | 1 | 6633.00 | 0 | 1 | 26303 WESTERN AVE LOMITA, CA 90717 (33.783405, -118.310013) | 02/01/2020 | ||||||||||||||||||||
12711 | 12711 | 4515 HUNTINGTON DRIVE SOUTH LOS ANGELES, CA 90032 | 34.084027 | -118.188188 | 0 | 555865 | HUNTINGTON HEALTHCARE CENTER | 4515 HUNTINGTON DRIVE SOUTH | LOS ANGELES | CA | 90032 | 3232255991 | 200 | Los Angeles | For profit - Corporation | 99 | 95.2 | Medicare and Medicaid | false | LA HUNTINGTON HEALTHCARE LLC | 02/19/2010 | false | false | false | false | None | Yes | 1 | 2 | 4 | 5 | 1 | 1 | 12 | 1 | 12 | 6 | 6 | 06/20/2019 | 7 | 7 | 0 | 40 | 1 | 0 | 40 | 05/31/2018 | 10 | 9 | 1 | 60 | 1 | 0 | 60 | 2017-05-26 | 27 | 15 | 12 | 1 | 224 | 0 | 224 | 77.333 | 1 | 11 | 1 | 48168.00 | 0 | 1 | 4515 HUNTINGTON DRIVE SOUTH LOS ANGELES, CA 90032 (34.084027, -118.188188) | 02/01/2020 | |||||||||||||||||||||
14002 | 14002 | 1201 CLARKS DR ABILENE, TX 79602 | 32.439629 | -99.704298 | 0 | 676416 | BRIGHTPOINTE AT LYTLE LAKE | 1201 CLARKS DR | ABILENE | TX | 79602 | 3256709293 | 911 | Taylor | For profit - Corporation | 120 | 84.2 | Medicare and Medicaid | false | MPD OPERATORS ABILENE LLC | 02/17/2017 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 12 | 1 | 12 | 6 | 6 | 09/25/2019 | 8 | 2 | 6 | 96 | 1 | 0 | 96 | 08/15/2018 | 6 | 4 | 2 | 52 | 1 | 0 | 52 | 2017-05-26 | 18 | 18 | 7 | 1 | 790 | 0 | 790 | 197 | 2 | 5 | 3 | 94171.00 | 0 | 3 | 1201 CLARKS DR ABILENE, TX 79602 (32.439629, -99.704298) | 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 );