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

6 rows where Health Inspection Rating = 5 and QM Rating Footnote = 2

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, ownership, prvdr_type, Provider Resides in Hospital, Continuing Care Retirement Community, With a Resident and Family Council, Overall Rating, 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 Total Number of Health Deficiencies, Rating Cycle 1 Number of Standard 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 Standard Health Deficiencies, Rating Cycle 2 Health Deficiency Score, Rating Cycle 2 Number of Health Revisits, Rating Cycle 2 Total Health Score, 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, 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
718 718 67 CUMMINGS ROAD HANOVER, NH 03755 43.64336 -72.123439 0   305042 KENDAL AT HANOVER 67 CUMMINGS ROAD HANOVER NH 3755 6036438900 40 Grafton Non profit - Corporation 1 1.1 Medicare false KENDAL AT HANOVER I 04/13/1992 true   false false false Both Yes 5   5     2   2   2   2   2 6 6                             08/06/2019 0 0 0 0 0 0 0 08/08/2018 0 0 0 0 0 0 0 2017-06-12 3 3 0 1 0 0 0 0 0 0 0 0.00 0 0 67 CUMMINGS ROAD HANOVER, NH 03755 (43.64336, -72.123439) 02/01/2020
824 824 Eldridge, CA 95431, USA 38.3634225 -122.5279928 1 APPROXIMATE 05A213 SONOMA DEVELOPMENTAL CENTER D/P SNF P.O. BOX 1493 ELDRIDGE CA 95431 7079386000 590 Sonoma Government - State 427   Medicaid true Legal Business Name Not Available 09/01/1974 false   false false false Both Yes 4   5     2   2   2 1 12 1 12 6 6                             07/26/2018 3 3 0 20 1 0 20 08/31/2017 3 3 0 12 1 0 12 2016-09-16 7 5 2 1 44 0 44 21.333 3 0 0 0.00 0 0   02/01/2020
2680 2680 1962 VANDOLAH RD WAUCHULA, FL 33873 27.545127 -81.921193 0   106054 LAKESIDE NEUROLOGIC 1962 VANDOLAH RD WAUCHULA FL 33873 8637732857 240 Hardee For profit - Limited Liability company 25 4.8 Medicare and Medicaid false SF III FNH LLC 07/16/2003 false   false false false Family Yes 5   5     2   2   2 5   5       4.80862 1.13424 6.02948 7.16372 11.97234 0.04195 2.55266 1.01504 0.89383 4.46153 3.9151 0.84024 2.53895 8.60494 06/13/2019 0 0 0 0 0 0 0 03/29/2018 3 3 0 28 1 0 28 2017-04-27 3 3 0 1 12 0 12 11.333 0 0 0 0.00 0 0 1962 VANDOLAH RD WAUCHULA, FL 33873 (27.545127, -81.921193) 02/01/2020
3891 3891 4080 W AIRLINE HWY RESERVE, LA 70084 30.076814 -90.573517 0   195625 SOUTHEAST LOUISIANA WAR VETERANS HOME 4080 W AIRLINE HWY RESERVE LA 70084 9854794080 470 St. John Baptist Government - State 12 9.7 Medicare false SOUTHEAST LOUISIANA WAR VETERANS HOME 08/07/2007 false   false false false Resident Yes 5   5     2   2   2   2   2 6 6                             10/30/2019 0 0 0 0 0 0 0 09/27/2018 1 1 0 8 1 0 8 2017-10-26 1 1 0 1 8 0 8 4 0 0 0 0.00 0 0 4080 W AIRLINE HWY RESERVE, LA 70084 (30.076814, -90.573517) 02/01/2020
4617 4617 4739 LA-10, Jackson, LA 70748, USA 30.8259277 -91.1650719 1 ROOFTOP 195629 LOUISIANA WAR VETERANS HOME 4739 HIGHWAY 10 JACKSON LA 70748 2253428998 180 East Feliciana Government - State 10 14.3 Medicare false LOUISIANA WAR VETERANS HOME 02/20/2009 false   false false false Resident Yes 4   5     2   2   2 1 12 1 12 6 6                             06/05/2019 1 1 0 8 1 0 8 05/16/2018 0 0 0 0 0 0 0 2017-05-10 2 2 0 1 8 0 8 5.333 0 0 0 0.00 0 0   02/01/2020
10536 10536 3700 TAYLOR GLEN LANE CONCORD, NC 28027 35.382563 -80.673692 0   345525 THE GARDENS OF TAYLOR GLEN RET COM 3700 TAYLOR GLEN LANE CONCORD NC 28027 7047886510 120 Cabarrus Non profit - Church related 8 4.2 Medicare false BAPTIST RETIREMENT HOMES OF NORTH CAROLINA INCORPORATED 03/11/2003 true   false false false Resident Yes 4   5     2   2   2 1 12 1 12     1.79499 0.7037 1.84769 2.55139 4.34638 0.27437 2.0508 0.93233 0.52598 3.50911 1.81909 0.56755 1.32218 3.97176 02/27/2019 0 0 0 0 0 0 0 01/10/2018 0 0 0 0 0 0 0 2017-01-25 1 1 0 1 4 0 4 0.667 0 0 0 0.00 0 0 3700 TAYLOR GLEN LANE CONCORD, NC 28027 (35.382563, -80.673692) 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
);