nh_gen_info_geocoded_final

Table actions
Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

8 rows where Short-Stay QM Rating Footnote = 18 and Total Number of Penalties = 6

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, ownership, Continuing Care Retirement Community, Abuse Icon, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, Reported Staffing Footnote, Physical Therapist Staffing Footnote, 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 3 Number of Standard Health Deficiencies, Rating Cycle 3 Number of Health Revisits, Rating Cycle 3 Health Revisit Score, Number of Facility Reported Incidents, Number of Fines, Number of Payment Denials, Location, Rating Cycle 3 Standard Health Survey Date (date)

Total Number of Penalties ✖

Short-Stay QM Rating Footnote ✖

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
726 726 555 WEST CARPENTER SPRINGFIELD, IL 62702 39.807588 -89.662793 0   145160 APERION CARE CAPITOL 555 WEST CARPENTER SPRINGFIELD IL 62702 2175251880 920 Sangamon For profit - Corporation 251 92.6 Medicare and Medicaid false APERION CARE CAPITOL LLC 05/23/1969 false SFF false false false Resident Yes   18   18   18   18   18   18   18     1.68655 0.86113 0.19506 1.05618 2.74274 0.0384 1.98797 0.83678 0.44386 3.26862 1.76321 0.77382 0.1654 2.69075 08/30/2019 39 18 33 248 1 0 248 04/12/2019 45 14 45 432 1 0 432 2018-07-16 16 12 4 1 96 0 96 284 2 48 6 229677.00 0 6 555 WEST CARPENTER SPRINGFIELD, IL 62702 (39.807588, -89.662793) 02/01/2020
1067 1067 11941 BELSAY RD GRAND BLANC, MI 48439 42.930115 -83.596686 0   235226 MEDILODGE OF GRAND BLANC 11941 BELSAY RD GRAND BLANC MI 48439 8106941970 240 Genesee For profit - Corporation 161 95.9 Medicare and Medicaid false GRAND BLANC OPCO, LLC 10/01/1973 false SFF false false false Resident Yes   18   18   18   18   18   18   18     3.49649 1.6363 0.9755 2.6118 6.10829 0.02216 2.26549 0.86337 0.89593 4.02479 3.20765 1.42511 0.40981 4.86665 11/08/2019 19 13 6 136 0 0 136 05/16/2019 36 15 22 264 1 0 264 2018-03-22 26 16 14 2 204 102 306 207 3 72 4 147766.00 2 6 11941 BELSAY RD GRAND BLANC, MI 48439 (42.930115, -83.596686) 02/01/2020
3052 3052 1561 COLD SPRING ROAD WILLIAMSTOWN, MA 01267 42.677742 -73.234834 0   225189 SWEET BROOK OF WILLIAMSTOWN REHABILITATION & N CTR 1561 COLD SPRING ROAD WILLIAMSTOWN MA 1267 4134588127 10 Berkshire For profit - Corporation 146 67.1 Medicare and Medicaid false SB OPERATING COMPANY LLC 07/29/1969 false SFF true false false Resident Yes   18   18   18   18   18   18   18     2.70451 0.83223 0.53277 1.365 4.0695 0.0463 1.85523 0.61098 0.27829 2.7445 3.02974 1.02423 0.72057 4.75478 06/18/2019 42 31 11 610 3 427 1037 03/15/2018 18 17 2 88 1 0 88 2017-02-01 29 11 18 1 618 0 618 650.833 6 8 3 359765.00 3 6 1561 COLD SPRING ROAD WILLIAMSTOWN, MA 01267 (42.677742, -73.234834) 02/01/2020
4164 4164 621 W 21st St, Andover, KS 67002, USA 37.72251 -97.1414099 1 ROOFTOP 175157 LIFE CARE CENTER OF ANDOVER 621 W 21ST, PO BOX 100 ANDOVER KS 67002 3167331349 70 Butler For profit - Corporation 154 76.8 Medicare and Medicaid false ANDOVER MEDICAL INVESTORS, LLC 10/31/1986 true SFF false false false Resident Yes   18   18   18   18   18   18   18     2.13408 0.98012 0.32956 1.30968 3.44377 0.14483 2.04491 0.73652 0.3436 3.12503 2.16897 1.00064 0.36101 3.53372 02/07/2019 41 26 22 434 2 217 651 03/06/2018 32 26 15 256 1 0 256 2016-09-06 36 27 9 2 364 182 546 501.833 3 28 5 350261.00 1 6   02/01/2020
6223 6223 563 KAUMANA DRIVE HILO, HI 96720 19.7042 -155.111039 0   125065 LEGACY HILO REHABILITATION & NURSING CENTER 563 KAUMANA DRIVE HILO HI 96720 8084980184 10 Hawaii For profit - Partnership 100 72.3 Medicare and Medicaid false KAUMANA DRIVE PARTNERS LLC 01/20/2016 false SFF true false false Both Yes   18   18   18   18   18   18   18 6 6                             08/09/2019 6 0 6 155 1 0 155 02/08/2019 22 10 12 144 1 0 144 2018-08-16 9 9 0 1 36 0 36 131.5 1 10 4 232031.00 2 6 563 KAUMANA DRIVE HILO, HI 96720 (19.7042, -155.111039) 02/01/2020
7049 7049 650 NORTH KINZIE BRADLEY, IL 60915 41.152212 -87.851103 0   146112 APERION CARE BRADLEY 650 NORTH KINZIE BRADLEY IL 60915 8159331666 540 Kankakee For profit - Corporation 120 68 Medicare and Medicaid false APERION CARE BRADLEY LLC 07/01/2007 false SFF false false true Resident Yes   18   18   18   18   18   18   18     1.55234 0.88539 0.35048 1.23587 2.78821 0.01014 2.20292 0.74243 0.33491 3.28025 1.46456 0.89673 0.39388 2.72566 10/10/2019 18 6 12 148 1 0 148 05/17/2019 33 13 20 276 1 0 276 2018-04-03 20 14 11 3 176 123 299 215.833 1 41 4 129109.00 2 6 650 NORTH KINZIE BRADLEY, IL 60915 (41.152212, -87.851103) 02/01/2020
13379 13379 5201 S WILLOW DR HOUSTON, TX 77035 29.655504 -95.470321 0   675612 THE WESTBURY PLACE 5201 S WILLOW DR HOUSTON TX 77035 7137210297 610 Harris For profit - Partnership 112 113.2 Medicare and Medicaid false OAKBEND MEDICAL CENTER 07/09/1996 false SFF true false false Resident Yes   18   18   18   18   18   18   18     2.0846 0.77902 0.56352 1.34254 3.42714 0.04765 2.16383 0.85954 0.45608 3.47946 2.00223 0.6815 0.46505 3.15845 07/12/2019 16 11 5 128 1 0 128 01/31/2019 10 6 4 48 1 0 48 2018-04-12 38 11 37 1 1371 0 1371 308.5 11 30 3 188064.00 3 6 5201 S WILLOW DR HOUSTON, TX 77035 (29.655504, -95.470321) 02/01/2020
15107 15107 NC-177, Hamlet, NC, USA 34.8920793 -79.7027708 1 GEOMETRIC_CENTER 345293 RICHMOND PINES HEALTHCARE AND REHABILITATION CENTE HIGHWAY 177 S BOX 1489 HAMLET NC 28345 9105820021 760 Richmond For profit - Corporation 105 88.5 Medicare and Medicaid false SPRUCE LTC GROUP, LLC 01/18/1989 false SFF false false false Both Yes   18   18   18   18   18   18   18     2.10043 0.82314 0.55654 1.37969 3.48012 0.0587 1.94029 0.73343 0.36447 3.03819 2.24987 0.84392 0.57474 3.6731 10/03/2019 15 15 1 72 1 0 72 04/04/2019 25 19 12 132 1 0 132 2018-10-18 34 22 15 1 355 0 355 139.167 1 44 4 133263.00 2 6   02/01/2020

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);