nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
10 rows where Overall Rating = 1 and ownership = "Government - City/county"
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, nmbr_beds, Legal Business Name, Continuing Care Retirement Community, Special Focus Status, Abuse Icon, With a Resident and Family Council, 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, Reported Staffing Footnote, Physical Therapist Staffing 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 Number of Health Revisits, Rating Cycle 1 Health Revisit Score, 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 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, 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2619 | 2619 | 1101 E COOLSPRING AVE MICHIGAN CITY, IN 46360 | 41.69472 | -86.878519 | 0 | 155156 | APERION CARE ARBORS MICHIGAN CITY | 1101 E COOLSPRING AVE | MICHIGAN CITY | IN | 46360 | 2198745211 | 450 | La Porte | Government - City/county | 180 | 133.9 | Medicare and Medicaid | false | MAJOR HOSPITAL | 04/01/1974 | false | SFF Candidate | false | false | false | Resident | Yes | 1 | 1 | 3 | 3 | 2 | 1 | 1 | 2.12826 | 0.88107 | 0.37259 | 1.25365 | 3.38191 | 0.06563 | 2.19605 | 0.84782 | 0.48072 | 3.52459 | 2.01418 | 0.78143 | 0.29172 | 3.07685 | 05/20/2019 | 40 | 23 | 24 | 212 | 3 | 148 | 360 | 11/20/2018 | 21 | 18 | 3 | 100 | 2 | 50 | 150 | 2017-12-18 | 20 | 8 | 12 | 1 | 229 | 0 | 229 | 268.167 | 0 | 64 | 2 | 37550.00 | 2 | 4 | 1101 E COOLSPRING AVE MICHIGAN CITY, IN 46360 (41.69472, -86.878519) | 02/01/2020 | ||||||||||
5308 | 5308 | 318 N 3RD STREET HAY SPRINGS, NE 69347 | 42.685767 | -102.687133 | 0 | 285212 | PIONEER MANOR NURSING HOME | P O BOX 310, 318 N 3RD STREET | HAY SPRINGS | NE | 69347 | 3086384483 | 800 | Sheridan | Government - City/county | 57 | 50 | Medicare and Medicaid | false | CITY OF HAY SPRINGS PIONEER MANOR NURSING HOME | 05/01/1997 | false | false | false | false | Both | Yes | 1 | 1 | 4 | 4 | 3 | 3 | 3 | 1.98516 | 0.85335 | 0.49795 | 1.35131 | 3.33647 | 0.01156 | 2.13358 | 0.641 | 0.29379 | 3.06837 | 1.93376 | 1.00105 | 0.63795 | 3.48685 | 11/06/2018 | 17 | 12 | 5 | 116 | 1 | 0 | 116 | 12/13/2017 | 11 | 8 | 3 | 100 | 1 | 0 | 100 | 2016-10-05 | 14 | 9 | 5 | 1 | 120 | 0 | 120 | 111.333 | 19 | 1 | 2 | 62024.00 | 2 | 4 | 318 N 3RD STREET HAY SPRINGS, NE 69347 (42.685767, -102.687133) | 02/01/2020 | |||||||||||
6001 | 6001 | 7150 MANOR ROAD COLUMBUS, GA 31906 | 32.49348 | -84.867984 | 0 | 115351 | MUSCOGEE MANOR & REHABILITATION CTR | 7150 MANOR ROAD | COLUMBUS | GA | 31906 | 7065613218 | 780 | Muscogee | Government - City/county | 170 | 114.7 | Medicare and Medicaid | false | HOSPITAL AUTHORITY OF COLUMBUS GA | 02/01/1989 | false | false | false | false | Both | Yes | 1 | 1 | 2 | 3 | 2 | 3 | 2 | 2.38647 | 1.24801 | 0.37811 | 1.62612 | 4.01259 | 0.03019 | 2.15831 | 0.71435 | 0.31177 | 3.18443 | 2.29804 | 1.31368 | 0.45647 | 4.0406 | 08/23/2018 | 9 | 7 | 2 | 68 | 1 | 0 | 68 | 08/17/2017 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 2016-05-26 | 6 | 4 | 2 | 1 | 28 | 0 | 28 | 41.333 | 0 | 2 | 1 | 8099.00 | 0 | 1 | 7150 MANOR ROAD COLUMBUS, GA 31906 (32.49348, -84.867984) | 02/01/2020 | |||||||||||
6333 | 6333 | 2350 TAFT ST GARY, IN 46404 | 41.576047 | -87.365831 | 0 | 155580 | APERION CARE TOLLESTON PARK | 2350 TAFT ST | GARY | IN | 46404 | 2199772600 | 440 | Lake | Government - City/county | 180 | 110.9 | Medicare and Medicaid | false | MAJOR HOSPITAL | 10/25/1995 | false | false | false | false | Both | Yes | 1 | 1 | 1 | 2 | 1 | 1 | 12 | 1 | 12 | 1.62014 | 1.05211 | 0.2156 | 1.26771 | 2.88785 | 0.04704 | 2.23465 | 0.8599 | 0.45628 | 3.55083 | 1.50681 | 0.92002 | 0.17785 | 2.60794 | 01/28/2019 | 36 | 31 | 8 | 176 | 1 | 0 | 176 | 04/17/2018 | 26 | 24 | 2 | 116 | 2 | 58 | 174 | 2017-03-17 | 24 | 12 | 12 | 3 | 132 | 92 | 224 | 183.333 | 0 | 38 | 0 | 0.00 | 1 | 1 | 2350 TAFT ST GARY, IN 46404 (41.576047, -87.365831) | 02/01/2020 | |||||||||
6438 | 6438 | 820 S DENISON STREET ST FRANCIS, KS 67756 | 39.766106 | -101.798918 | 0 | 175347 | CHEYENNE COUNTY VILLAGE INC | 820 S DENISON STREET | ST FRANCIS | KS | 67756 | 7853322531 | 110 | Cheyenne | Government - City/county | 30 | 27.8 | Medicare and Medicaid | false | CHEYENNE COUNTY VILLAGE INC | 06/01/1995 | true | false | false | false | Both | Yes | 1 | 1 | 1 | 1 | 2 | 4 | 4 | 3.73398 | 0.72684 | 0.76236 | 1.4892 | 5.22317 | 0.00253 | 1.99861 | 0.66819 | 0.3066 | 2.97339 | 3.88294 | 0.81794 | 0.93587 | 5.63294 | 08/15/2019 | 22 | 19 | 3 | 184 | 1 | 0 | 184 | 11/05/2018 | 7 | 7 | 7 | 56 | 1 | 0 | 56 | 2017-05-22 | 3 | 3 | 0 | 1 | 20 | 0 | 20 | 114 | 0 | 1 | 0 | 0.00 | 0 | 0 | 820 S DENISON STREET ST FRANCIS, KS 67756 (39.766106, -101.798918) | 02/01/2020 | |||||||||||
6957 | 6957 | 1236 LINCOLN AVE EVANSVILLE, IN 47714 | 37.969996 | -87.541783 | 0 | 155820 | UNIVERSITY NURSING AND REHABILITATION CENTER | 1236 LINCOLN AVE | EVANSVILLE | IN | 47714 | 8124643607 | 810 | Vanderburgh | Government - City/county | 47 | 45.3 | Medicare and Medicaid | false | DAVIESS COUNTY HOSPITAL | 05/28/2014 | false | false | false | false | Resident | Yes | 1 | 1 | 2 | 3 | 2 | 3 | 3 | 2.18187 | 0.88971 | 0.5943 | 1.48401 | 3.66589 | 0.10152 | 1.91227 | 0.79474 | 0.40521 | 3.11222 | 2.37135 | 0.8418 | 0.55203 | 3.77713 | 09/16/2019 | 18 | 17 | 8 | 104 | 1 | 0 | 104 | 07/26/2018 | 16 | 13 | 5 | 96 | 2 | 48 | 144 | 2017-06-15 | 15 | 12 | 3 | 2 | 92 | 46 | 138 | 123 | 0 | 9 | 1 | 8125.00 | 1 | 2 | 1236 LINCOLN AVE EVANSVILLE, IN 47714 (37.969996, -87.541783) | 02/01/2020 | |||||||||||
7612 | 7612 | 1302 N LESLEY AVE INDIANAPOLIS, IN 46219 | 39.785889 | -86.071375 | 0 | 155329 | ROSEWALK VILLAGE | 1302 N LESLEY AVE | INDIANAPOLIS | IN | 46219 | 3173538061 | 480 | Marion | Government - City/county | 161 | 125.6 | Medicare and Medicaid | false | THE HEALTH AND HOSPITAL CORPORATION OF MARION COUNTY | 04/10/1989 | false | false | false | false | Resident | Yes | 1 | 2 | 4 | 4 | 5 | 1 | 1 | 2.55936 | 1.16444 | 0.34114 | 1.50558 | 4.06494 | 0.08578 | 2.34303 | 0.93968 | 0.54671 | 3.82942 | 2.27023 | 0.9318 | 0.23486 | 3.40388 | 12/03/2018 | 15 | 12 | 4 | 60 | 1 | 0 | 60 | 11/01/2017 | 6 | 5 | 3 | 56 | 1 | 0 | 56 | 2016-09-15 | 18 | 3 | 15 | 1 | 76 | 0 | 76 | 61.333 | 0 | 33 | 0 | 0.00 | 0 | 0 | 1302 N LESLEY AVE INDIANAPOLIS, IN 46219 (39.785889, -86.071375) | 02/01/2020 | |||||||||||
11015 | 11015 | 594 ALBANY AVENUE BROOKLYN, NY 11203 | 40.659714 | -73.939693 | 0 | 335805 | DR SUSAN SMITH MCKINNEY NURSING AND REHAB CENTER | 594 ALBANY AVENUE | BROOKLYN | NY | 11203 | 7182457000 | 331 | Kings | Government - City/county | 320 | 313.8 | Medicare and Medicaid | false | NEW YORK CITY HEALTH AND HOSPITALS CORPORATION | 12/08/1997 | false | true | false | false | Both | Yes | 1 | 1 | 4 | 5 | 3 | 3 | 3 | 2.30257 | 0.57064 | 0.60272 | 1.17336 | 3.47593 | 0.05753 | 2.12074 | 0.72686 | 0.33537 | 3.18297 | 2.25654 | 0.59033 | 0.67642 | 3.5018 | 02/11/2019 | 9 | 9 | 0 | 84 | 1 | 0 | 84 | 04/06/2017 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2016-02-22 | 5 | 5 | 0 | 1 | 20 | 0 | 20 | 45.333 | 0 | 0 | 1 | 52390.00 | 0 | 1 | 594 ALBANY AVENUE BROOKLYN, NY 11203 (40.659714, -73.939693) | 02/01/2020 | |||||||||||
15114 | 15114 | 1800 PRINCETON ROAD HAMILTON, OH 45011 | 39.392561 | -84.536254 | 0 | 366182 | BUTLER COUNTY CARE FACILITY | 1800 PRINCETON ROAD | HAMILTON | OH | 45011 | 5138873728 | 80 | Butler | Government - City/county | 109 | 80.2 | Medicare and Medicaid | false | COUNTY OF BUTLER | 02/16/2000 | false | SFF Candidate | false | false | false | Resident | Yes | 1 | 1 | 2 | 2 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 02/14/2019 | 27 | 25 | 2 | 223 | 2 | 112 | 335 | 01/11/2018 | 23 | 11 | 13 | 112 | 1 | 0 | 112 | 2016-11-03 | 10 | 6 | 4 | 1 | 40 | 0 | 40 | 211.5 | 1 | 7 | 0 | 0.00 | 0 | 0 | 1800 PRINCETON ROAD HAMILTON, OH 45011 (39.392561, -84.536254) | 02/01/2020 | ||||||||||||||||||||
15405 | 15405 | 3301 FM3009, Schertz, TX 78154, USA | 29.5840208 | -98.26725619999999 | 1 | ROOFTOP | 676301 | AUTUMN WINDS LIVING & REHABILITATION | 3301 FM 3009 | SCHERTZ | TX | 78154 | 2106586338 | 581 | Guadalupe | Government - City/county | 96 | 77.8 | Medicare and Medicaid | false | GUADALUPE COUNTY HOSPITAL BOARD | 12/11/2011 | false | false | false | false | Resident | Yes | 1 | 2 | 2 | 3 | 1 | 1 | 1 | 2.25035 | 0.75346 | 0.25869 | 1.01215 | 3.2625 | 0.01397 | 1.989 | 0.86247 | 0.49553 | 3.34701 | 2.35142 | 0.6569 | 0.19649 | 3.1257 | 03/28/2019 | 20 | 18 | 2 | 152 | 1 | 0 | 152 | 03/23/2018 | 10 | 10 | 0 | 80 | 1 | 0 | 80 | 2017-02-17 | 8 | 5 | 3 | 1 | 72 | 0 | 72 | 114.667 | 0 | 5 | 0 | 0.00 | 0 | 0 | 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 );