nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
8 rows where Physical Therapist Staffing Footnote = 6 and Rating Cycle 2 Number of Complaint Health Deficiencies = 11
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, prvdr_cnty_name, ownership, prvdr_type, Legal Business Name, Abuse Icon, With a Resident and Family Council, Overall Rating, Health Inspection Rating, 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 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 2 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, Location, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
428 | 428 | 4809 REDMAN AVENUE OMAHA, NE 68104 | 41.310356 | -95.986244 | 0 | 285107 | SORENSEN CARE AND REHABILITATION CENTER, LLC | 4809 REDMAN AVENUE | OMAHA | NE | 68104 | 4024555025 | 270 | Douglas | For profit - Corporation | 74 | Medicare and Medicaid | false | Legal Business Name Not Available | 07/01/1991 | false | false | false | false | Resident | Yes | 1 | 1 | 2 | 2 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 08/30/2018 | 33 | 33 | 0 | 288 | 1 | 0 | 288 | 06/15/2017 | 11 | 11 | 11 | 84 | 1 | 0 | 84 | 2016-04-05 | 10 | 8 | 2 | 1 | 44 | 0 | 44 | 179.333 | 2 | 2 | 1 | 9100.00 | 1 | 2 | 4809 REDMAN AVENUE OMAHA, NE 68104 (41.310356, -95.986244) | 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 | |||||||||||||||||||||
2752 | 2752 | Indian Hills Dr, Macy, NE 68039, USA | 42.1187092 | -96.35944669999999 | 1 | GEOMETRIC_CENTER | 28A065 | CARL T CURTIS HEALTH EDUCATION CENTER NURSING HOME | P O BOX 250 | MACY | NE | 68039 | 4028375381 | 860 | Thurston | Non profit - Other | 25 | 20.8 | Medicaid | false | Legal Business Name Not Available | 10/02/1990 | false | false | false | false | Resident | Yes | 2 | 3 | 2 | 2 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 11/01/2018 | 1 | 1 | 0 | 16 | 1 | 0 | 16 | 10/16/2017 | 11 | 10 | 11 | 108 | 1 | 0 | 108 | 2016-07-06 | 1 | 1 | 0 | 1 | 4 | 0 | 4 | 44.667 | 2 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||
6023 | 6023 | 8001 SOUTH WESTERN AVENUE CHICAGO, IL 60620 | 41.747748 | -87.682719 | 0 | 145864 | BRIA OF FOREST EDGE | 8001 SOUTH WESTERN AVENUE | CHICAGO | IL | 60620 | 7734366600 | 141 | Cook | For profit - Corporation | 328 | 260.5 | Medicare and Medicaid | false | FOREST EDGE HEALTHCARE & REHABILITATION CENTER LLC | 03/01/1996 | false | false | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 3 | 1 | 12 | 1 | 12 | 6 | 6 | 09/18/2019 | 17 | 11 | 6 | 108 | 1 | 0 | 108 | 08/16/2018 | 29 | 18 | 11 | 192 | 1 | 0 | 192 | 2017-10-15 | 12 | 8 | 4 | 1 | 76 | 0 | 76 | 130.667 | 3 | 36 | 3 | 87301.00 | 1 | 4 | 8001 SOUTH WESTERN AVENUE CHICAGO, IL 60620 (41.747748, -87.682719) | 02/01/2020 | |||||||||||||||||||||
7060 | 7060 | 300 EAST HORNBECK STREET SENATH, MO 63876 | 36.126758 | -90.154429 | 0 | 265832 | SENATH SOUTH HEALTH CARE CENTER | 300 EAST HORNBECK STREET, PO BOX 940 | SENATH | MO | 63876 | 5737382627 | 340 | Dunklin | For profit - Limited Liability company | 30 | 24.2 | Medicare and Medicaid | false | SENATH SOUTH HEALTH CARE CENTER LLC | 01/25/2010 | false | false | false | false | Resident | Yes | 3 | 2 | 5 | 5 | 2 | 2 | 2 | 6 | 6 | 10/30/2019 | 13 | 12 | 1 | 48 | 1 | 0 | 48 | 12/12/2018 | 18 | 7 | 11 | 144 | 1 | 0 | 144 | 2017-11-02 | 7 | 5 | 2 | 1 | 28 | 0 | 28 | 76.667 | 1 | 9 | 1 | 11050.00 | 0 | 1 | 300 EAST HORNBECK STREET SENATH, MO 63876 (36.126758, -90.154429) | 02/01/2020 | |||||||||||||||||||||||
7737 | 7737 | 6800 Joliet Rd, Indian Head Park, IL 60525, USA | 41.7692481 | -87.8901817 | 1 | ROOFTOP | 145784 | BRIAR PLACE NURSING | 6800 WEST JOLIET | INDIAN HEAD PARK | IL | 60525 | 7082468500 | 141 | Cook | For profit - Corporation | 232 | 205.4 | Medicare and Medicaid | false | BRIAR PLACE NURSING LLC | 02/01/1994 | false | true | false | false | Resident | Yes | 1 | 1 | 1 | 2 | 1 | 2 | 2 | 6 | 6 | 08/21/2019 | 20 | 11 | 9 | 136 | 1 | 0 | 136 | 10/26/2018 | 16 | 5 | 11 | 112 | 1 | 0 | 112 | 2017-09-01 | 21 | 10 | 12 | 1 | 128 | 0 | 128 | 126.667 | 1 | 30 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||
8565 | 8565 | 200 S MAPLE STREET HAZEN, AR 72064 | 34.778946 | -91.56222 | 0 | 45228 | MAPLE HEALTHCARE | 200 S MAPLE STREET | HAZEN | AR | 72064 | 8702554323 | 580 | Prairie | For profit - Limited Liability company | 70 | 47.9 | Medicare and Medicaid | false | HAZEN SNF OPERATOR LLC | 01/01/1994 | false | false | false | false | Resident | Yes | 1 | 2 | 2 | 2 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 02/21/2019 | 5 | 5 | 0 | 56 | 1 | 0 | 56 | 05/03/2018 | 23 | 12 | 11 | 212 | 1 | 0 | 212 | 2017-02-03 | 15 | 15 | 0 | 1 | 148 | 0 | 148 | 123.333 | 0 | 14 | 1 | 10400.00 | 0 | 1 | 200 S MAPLE STREET HAZEN, AR 72064 (34.778946, -91.56222) | 02/01/2020 | |||||||||||||||||||||
9206 | 9206 | 1200 FERGUSON ST NACOGDOCHES, TX 75961 | 31.613332 | -94.65085 | 0 | 676324 | OAK MANOR NURSING HOME | 1200 FERGUSON ST | NACOGDOCHES | TX | 75961 | 9365647359 | 810 | Nacogdoches | For profit - Partnership | 60 | 2.9 | Medicare and Medicaid | false | OLD TOWN HEALTH CARE, LTD | 11/01/2012 | false | false | false | false | Resident | Yes | 1 | 1 | 2 | 2 | 3 | 1 | 12 | 1 | 12 | 6 | 6 | 09/06/2018 | 14 | 14 | 0 | 128 | 1 | 0 | 128 | 10/25/2017 | 17 | 6 | 11 | 446 | 1 | 0 | 446 | 2016-11-22 | 2 | 2 | 0 | 1 | 16 | 0 | 16 | 215.333 | 2 | 1 | 1 | 27254.00 | 0 | 1 | 1200 FERGUSON ST NACOGDOCHES, TX 75961 (31.613332, -94.65085) | 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 );