nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
6 rows where Abuse Icon = "true" and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-01-11
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, ownership, Continuing Care Retirement Community, 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 2 Total Number of Health Deficiencies, Rating Cycle 2 Number of Standard 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, Rating Cycle 3 Health Deficiency Score, Rating Cycle 3 Total Health 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2480 | 2480 | 10303 STATE ROAD MOKANE, MO 65059 | 38.681023 | -91.881396 | 0 | 265434 | RIVERVIEW NURSING CENTER | 10303 STATE ROAD C | MOKANE | MO | 65059 | 5736763136 | 130 | Callaway | For profit - Individual | 60 | 40 | Medicare and Medicaid | false | MOKANE NO 1 INC | 08/15/1990 | false | true | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 2 | 1 | 12 | 1 | 12 | 2.2617 | 0.74742 | 0.40282 | 1.15023 | 3.41193 | 0.03795 | 1.69027 | 0.60812 | 0.2812 | 2.57959 | 2.78096 | 0.92418 | 0.53916 | 4.24133 | 04/18/2019 | 12 | 11 | 1 | 80 | 1 | 0 | 80 | 03/16/2018 | 21 | 18 | 3 | 156 | 1 | 0 | 156 | 2017-01-11 | 9 | 7 | 2 | 1 | 52 | 0 | 52 | 100.667 | 3 | 5 | 0 | 0.00 | 0 | 0 | 10303 STATE ROAD MOKANE, MO 65059 (38.681023, -91.881396) | 02/01/2020 | |||||||||
2748 | 2748 | 100 KINGSTON ROAD SULPHUR, LA 70663 | 30.228871 | -93.328746 | 0 | 195431 | HOLLY HILL HOUSE | 100 KINGSTON ROAD | SULPHUR | LA | 70663 | 3376255843 | 90 | Calcasieu | For profit - Corporation | 200 | 97.1 | Medicare and Medicaid | false | HOLLY HILL HOUSE, LLC | 09/01/1997 | false | true | false | false | Resident | Yes | 1 | 1 | 1 | 2 | 1 | 2 | 2 | 2.34712 | 0.88301 | 0.31215 | 1.19516 | 3.54227 | 0.0567 | 1.90514 | 0.68678 | 0.281 | 2.87292 | 2.5605 | 0.96678 | 0.41811 | 3.95377 | 01/10/2019 | 9 | 0 | 9 | 265 | 1 | 0 | 265 | 02/28/2018 | 5 | 3 | 2 | 24 | 1 | 0 | 24 | 2017-01-11 | 7 | 2 | 5 | 1 | 40 | 0 | 40 | 147.167 | 8 | 4 | 1 | 39234.00 | 0 | 1 | 100 KINGSTON ROAD SULPHUR, LA 70663 (30.228871, -93.328746) | 02/01/2020 | |||||||||||
7874 | 7874 | 500 6TH STREET MENDOTA, IL 61342 | 41.547602 | -89.114541 | 0 | 146072 | MENDOTA LUTHERAN HOME | 500 6TH STREET | MENDOTA | IL | 61342 | 8155397439 | 580 | La Salle | Non profit - Corporation | 99 | 45.1 | Medicare and Medicaid | false | AMERICAN LUTHERAN CHURCH MENDOTA | 01/10/2005 | false | true | false | false | Resident | Yes | 3 | 2 | 4 | 3 | 5 | 4 | 4 | 2.67075 | 0.68631 | 0.73551 | 1.42183 | 4.09258 | 0.0327 | 2.29591 | 0.72728 | 0.29595 | 3.31913 | 2.41765 | 0.70959 | 0.93543 | 3.9539 | 03/22/2019 | 11 | 4 | 7 | 131 | 1 | 0 | 131 | 02/15/2018 | 4 | 4 | 0 | 20 | 1 | 0 | 20 | 2017-01-11 | 3 | 3 | 0 | 1 | 12 | 0 | 12 | 74.167 | 2 | 3 | 0 | 0.00 | 0 | 0 | 500 6TH STREET MENDOTA, IL 61342 (41.547602, -89.114541) | 02/01/2020 | |||||||||||
12269 | 12269 | 5790 Denlinger Rd, Dayton, OH 45426, USA | 39.8291741 | -84.2721832 | 1 | ROOFTOP | 365309 | FRIENDSHIP VILLAGE | 5790 DENLINGER ROAD | DAYTON | OH | 45426 | 9378375581 | 580 | Montgomery | Non profit - Corporation | 127 | 107.1 | Medicare and Medicaid | false | DAYTON SENIOR CARE LLC | 09/17/1974 | true | true | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 5 | 1 | 12 | 1 | 12 | 2.06032 | 1.65276 | 0.1531 | 1.80587 | 3.86618 | 0.0443 | 2.15041 | 0.81112 | 0.42243 | 3.38396 | 1.99126 | 1.53218 | 0.13642 | 3.66362 | 06/27/2019 | 15 | 11 | 8 | 229 | 1 | 0 | 229 | 03/22/2018 | 21 | 12 | 9 | 144 | 1 | 0 | 144 | 2017-01-11 | 8 | 5 | 3 | 1 | 44 | 0 | 44 | 169.833 | 2 | 11 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||
13819 | 13819 | 145 OLIVE ST AKRON, OH 44310 | 41.097119 | -81.510443 | 0 | 365259 | CANAL POINTE NURSING & REHAB CENTER | 145 OLIVE ST | AKRON | OH | 44310 | 3307620901 | 780 | Summit | For profit - Corporation | 120 | 99.5 | Medicare and Medicaid | false | OLIVE HEALTH CARE, INC. | 01/13/1971 | false | true | false | false | Both | Yes | 2 | 2 | 4 | 5 | 3 | 2 | 2 | 1.9394 | 0.88304 | 0.44663 | 1.32967 | 3.26907 | 0.01617 | 1.92472 | 0.79283 | 0.41221 | 3.12977 | 2.09419 | 0.83749 | 0.40781 | 3.34939 | 05/16/2019 | 3 | 1 | 2 | 32 | 1 | 0 | 32 | 04/05/2018 | 5 | 4 | 4 | 28 | 1 | 0 | 28 | 2017-01-11 | 10 | 5 | 5 | 1 | 44 | 0 | 44 | 32.667 | 2 | 4 | 0 | 0.00 | 0 | 0 | 145 OLIVE ST AKRON, OH 44310 (41.097119, -81.510443) | 02/01/2020 | |||||||||||
14963 | 14963 | 59 BLACKSTOCK ROAD INMAN, SC 29349 | 35.038462 | -82.090637 | 0 | 425303 | LAKE EMORY POST ACUTE CARE | 59 BLACKSTOCK ROAD | INMAN | SC | 29349 | 8644722028 | 410 | Spartanburg | For profit - Corporation | 88 | 80.2 | Medicare and Medicaid | false | THI OF SOUTH CAROLINA AT CAMP CARE, LLC | 02/15/1991 | false | true | false | false | Both | Yes | 1 | 1 | 2 | 3 | 1 | 3 | 3 | 2.00711 | 0.96425 | 0.45326 | 1.41751 | 3.42462 | 0.03594 | 2.10584 | 0.67886 | 0.29964 | 3.08433 | 1.9809 | 1.06805 | 0.56936 | 3.56044 | 04/25/2019 | 19 | 17 | 5 | 152 | 1 | 0 | 152 | 05/02/2018 | 8 | 8 | 0 | 40 | 1 | 0 | 40 | 2017-01-11 | 7 | 7 | 0 | 1 | 72 | 0 | 72 | 101.333 | 2 | 0 | 1 | 13905.00 | 0 | 1 | 59 BLACKSTOCK ROAD INMAN, SC 29349 (35.038462, -82.090637) | 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 );