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

14 rows where Overall Rating Footnote = 18 and Total Number of Penalties = 2

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: prvdr_state, ownership, nmbr_beds, Date First Approved to Provide Medicare and Medicaid services, Continuing Care Retirement Community, Abuse Icon, 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 Number of Health Revisits, Rating Cycle 1 Health Revisit Score, 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 Number of Health Revisits, Rating Cycle 2 Health Revisit 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 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, Rating Cycle 3 Standard Health Survey Date (date)

Total Number of Penalties ✖

Overall 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
1103 1103 2970 SCARLETT RD WINTER PARK, FL 32792 28.597153 -81.309049 0   105332 WINTER PARK CARE & REHABILITATION CENTER 2970 SCARLETT RD WINTER PARK FL 32792 4076718030 470 Orange For profit - Corporation 103 83.3 Medicare and Medicaid false LP WINTER PARK LLC 09/25/1978 false SFF false false false Resident Yes   18   18   18   18   18   18   18     2.65006 0.87989 0.72322 1.60312 4.25317 0.03557 1.97367 0.67882 0.30307 2.95556 2.79059 0.97468 0.89818 4.61452 09/26/2019 1 1 0 4 1 0 4 03/20/2019 7 7 0 36 1 0 36 2018-08-09 6 6 0 1 24 0 24 18 0 0 2 44116.00 0 2 2970 SCARLETT RD WINTER PARK, FL 32792 (28.597153, -81.309049) 02/01/2020
2601 2601 1221 EAST UNION STREET GREENVILLE, MS 38703 33.409939 -91.032864 0   255252 MS CARE CENTER OF GREENVILLE 1221 EAST UNION STREET GREENVILLE MS 38703 6623355811 750 Washington For profit - Corporation 116 101.5 Medicare and Medicaid false WASHINGTON COUNTY LTC, INC. 11/01/1997 false SFF false false false Resident Yes   18   18   18   18   18   18   18     2.3143 0.91958 0.51236 1.43195 3.74625 0.03427 2.00535 0.6684 0.28992 2.96367 2.39853 1.03452 0.66518 4.0534 09/26/2019 9 5 4 72 1 0 72 08/27/2018 10 10 0 545 1 0 545 2017-04-27 9 7 2 1 40 0 40 224.333 0 7 1 31225.00 1 2 1221 EAST UNION STREET GREENVILLE, MS 38703 (33.409939, -91.032864) 02/01/2020
6506 6506 2810 SECOND AVENUE NORTH MOORHEAD, MN 56560 46.876749 -96.735406 0   245052 MOORHEAD REHABILITATION & HEALTHCARE CENTER 2810 SECOND AVENUE NORTH MOORHEAD MN 56560 2182337578 130 Clay For profit - Corporation 78 51 Medicare and Medicaid false MOORHEAD OPERATIONS LLC 03/01/1979 false SFF false false false Resident Yes   18   18   18   18   18   18   18     2.57162 0.96551 0.73195 1.69745 4.26908 0.05614 1.92306 0.71537 0.33668 2.97511 2.77927 1.01486 0.81827 4.60134 11/07/2019 13 0 13 68 1 0 68 11/09/2018 18 11 14 211 2 106 317 2018-03-13 41 34 9 3 407 285 692 255 9 14 0 0.00 2 2 2810 SECOND AVENUE NORTH MOORHEAD, MN 56560 (46.876749, -96.735406) 02/01/2020
7305 7305 1244 TRAVIS BLVD FAIRFIELD, CA 94533 38.25822 -122.047987 0   56086 LA MARIPOSA CARE AND REHABILITATION CENTER 1244 TRAVIS BLVD FAIRFIELD CA 94533 7074227750 580 Solano For profit - Corporation 99 58.5 Medicare and Medicaid false SAGAR, INC. 08/11/1969 false SFF false false false Resident Yes   18   18   18   18   18   18   18     2.37046 1.05135 0.34796 1.39931 3.76977 0.06392 2.09609 0.7084 0.31827 3.12276 2.35038 1.11597 0.41149 3.87105 06/21/2019 11 11 0 60 1 0 60 06/15/2018 6 6 0 52 1 0 52 2018-02-20 5 4 1 1 24 0 24 51.333 0 2 2 16490.00 0 2 1244 TRAVIS BLVD FAIRFIELD, CA 94533 (38.25822, -122.047987) 02/01/2020
7523 7523 1515 N ALEXANDRIA AVE LOS ANGELES, CA 90027 34.098802 -118.298328 0   56113 ALEXANDRIA CARE CENTER 1515 N ALEXANDRIA AVE. LOS ANGELES CA 90027 3236601800 200 Los Angeles For profit - Limited Liability company 177 161.8 Medicare and Medicaid false ALEXANDRIA CARE CENTER LLC 09/17/1969 false SFF false false false Resident Yes   18   18   18   18   18   18   18     2.2025 1.09073 0.49025 1.58098 3.78348 0.06099 1.99215 0.72153 0.33509 3.04876 2.29779 1.1367 0.55067 3.97943 10/18/2019 25 16 9 128 1 0 128 04/09/2019 32 24 8 204 1 0 204 2018-10-05 38 24 21 2 371 186 557 224.833 25 39 1 43658.00 1 2 1515 N ALEXANDRIA AVE LOS ANGELES, CA 90027 (34.098802, -118.298328) 02/01/2020
8286 8286 919 OLD WINTER HAVEN RD AUBURNDALE, FL 33823 28.058697 -81.77095 0   105302 OAK HAVEN REHAB AND NURSING CENTER 919 OLD WINTER HAVEN RD AUBURNDALE FL 33823 8639674125 520 Polk For profit - Corporation 120 99.2 Medicare and Medicaid false AUBURNDALE OAKS CARE ACQUISITION, LLC 01/01/1977 false SFF true false false Resident Yes   18   18   18   18   18   18   18 6 6                             12/13/2018 15 13 9 394 2 197 591 09/22/2017 7 4 3 32 1 0 32 2016-07-28 9 7 2 1 44 0 44 313.5 0 16 1 147689.00 1 2 919 OLD WINTER HAVEN RD AUBURNDALE, FL 33823 (28.058697, -81.77095) 02/01/2020
9684 9684 6800 N 76TH STREET MILWAUKEE, WI 53223 43.142198 -88.005448 0   525529 BRIDGES OF MILWAUKEE REHAB AND CARE CENTER (THE) 6800 N 76TH STREET MILWAUKEE WI 53223 4143535000 390 Milwaukee For profit - Corporation 144 74.4 Medicare and Medicaid false JB MILWAUKEE HEALTHCARE LLC 04/01/1994 false SFF false false false Resident Yes   18   18   18   18   18   18   18 6 6                             07/23/2019 20 15 5 270 2 135 405 02/26/2019 34 24 19 319 1 0 319 2017-11-27 22 15 12 2 112 56 168 336.833 4 20 0 0.00 2 2 6800 N 76TH STREET MILWAUKEE, WI 53223 (43.142198, -88.005448) 02/01/2020
10030 10030 740 CANONBY PLACE COLUMBUS, OH 43223 39.945048 -83.021548 0   366313 SCIOTO POINTE 740 CANONBY PLACE COLUMBUS OH 43223 6142245738 250 Franklin For profit - Individual 99 88.3 Medicare and Medicaid false LONGTERM LODGING INC 04/25/2005 false SFF false false false Resident Yes   18   18   18   18   18   18   18     1.42998 0.97837 0.37638 1.35476 2.78474 0.02185 1.88899 0.81654 0.41796 3.12349 1.57332 0.90098 0.33894 2.85889 09/19/2019 9 8 1 40 1 0 40 11/13/2018 11 11 5 568 1 0 568 2017-09-21 20 14 6 1 361 0 361 269.5 2 3 2 166166.00 0 2 740 CANONBY PLACE COLUMBUS, OH 43223 (39.945048, -83.021548) 02/01/2020
10361 10361 1000 WEST PARK AVENUE LOGAN, WV 25601 37.84917 -81.98706 0   515140 TRINITY HEALTH CARE OF LOGAN 1000 WEST PARK AVENUE LOGAN WV 25601 3047528723 220 Logan For profit - Corporation 120 108.3 Medicare and Medicaid false TRINITY HEALTH CARE SERVICES OF LOGAN INC 01/19/1996 false SFF false false false Resident Yes   18   18   18   18   18   18   18     2.09129 1.41007 0.37681 1.78688 3.87816 0.08853 2.01166 0.74626 0.34875 3.10668 2.1606 1.4208 0.40666 4.00297 03/27/2019 8 8 0 28 1 0 28 06/12/2018 20 20 0 244 1 0 244 2017-04-11 25 25 0 1 426 0 426 166.333 0 0 2 483519.00 0 2 1000 WEST PARK AVENUE LOGAN, WV 25601 (37.84917, -81.98706) 02/01/2020
10813 10813 601 RED VILLAGE ROAD LYNDONVILLE, VT 05851 44.513187 -71.996037 0   475044 PINES REHAB & HEALTH CTR 601 RED VILLAGE ROAD LYNDONVILLE VT 5851 8026264304 20 Caledonia For profit - Partnership 60 51.2 Medicare and Medicaid false PINE KNOLL NURSING HOME, INC 04/01/1994 false SFF true false false Resident Yes   18   18   18   18   18   18   18     2.60587 0.72629 0.68496 1.41125 4.01712 0.06956 2.04606 0.77786 0.38306 3.20699 2.64698 0.70208 0.67302 4.01671 10/02/2019 21 9 12 508 1 0 508 04/17/2019 3 2 1 16 1 0 16 2018-10-10 16 2 14 1 132 0 132 281.333 7 18 2 22358.00 0 2 601 RED VILLAGE ROAD LYNDONVILLE, VT 05851 (44.513187, -71.996037) 02/01/2020
11269 11269 104 WATSON ROAD SPRINGFIELD, TN 37172 36.483703 -86.891395 0   445137 THE WATERS OF ROBERTSON, LLC 104 WATSON ROAD SPRINGFIELD TN 37172 6153849565 730 Robertson For profit - Limited Liability company 120 48.6 Medicare and Medicaid false THE WATERS OF ROBERTSON LLC 10/01/1980 false SFF false false false Resident Yes   18   18   18   18   18   18   18     1.71302 0.85863 0.66223 1.52086 3.23388 0.07801 2.45185 0.90975 0.46299 3.82458 1.45206 0.70969 0.53836 2.7114 03/26/2019 12 11 1 678 1 0 678 05/09/2018 3 3 0 12 1 0 12 2017-05-09 13 9 4 1 60 0 60 353 4 4 2 173903.00 0 2 104 WATSON ROAD SPRINGFIELD, TN 37172 (36.483703, -86.891395) 02/01/2020
11861 11861 149 BALLSTON AVENUE BALLSTON SPA, NY 12020 42.996735 -73.8538 0   335518 SARATOGA CENTER FOR REHAB & SKILLED NURSING CARE 149 BALLSTON AVENUE BALLSTON SPA NY 12020 5188852288 640 Saratoga For profit - Corporation 257 163.9 Medicare and Medicaid false SARATOGA CENTER FOR CARE LLC 07/01/1977 true SFF false false false Resident Yes   18   18   18   18   18   18   18     1.74562 1.93979 0.35398 2.29377 4.03939 0.07627 1.79704 0.64651 0.30147 2.74502 2.01887 2.25612 0.44195 4.71871 11/13/2019 11 8 3 48 1 0 48 05/13/2019 15 15 3 76 3 53 129 2018-04-25 33 13 20 1 541 0 541 157.167 3 25 2 158695.00 0 2 149 BALLSTON AVENUE BALLSTON SPA, NY 12020 (42.996735, -73.8538) 02/01/2020
12098 12098 1010 E WAUSAU AVE WAUSAU, WI 54403 44.973973 -89.614429 0   525405 BAY AT COLONIAL MANOR HEALTH AND REHAB (THE) 1010 E WAUSAU AVE WAUSAU WI 54403 7158422028 360 Marathon For profit - Partnership 116 51.5 Medicare and Medicaid false THE BAY AT COLONIAL MANOR HEALTH AND REHABILITATION LLC 01/01/1987 false SFF false false false Resident Yes   18   18   18   18   18   18   18     1.93104 0.78379 0.75606 1.53986 3.4709 0.0887 2.1494 0.81582 0.41725 3.38246 1.8672 0.72243 0.68202 3.2905 01/08/2020 13 5 8 159 0 0 159 03/21/2019 22 8 21 144 2 72 216 2018-01-25 19 13 6 1 238 0 238 191.167 3 16 1 27003.00 1 2 1010 E WAUSAU AVE WAUSAU, WI 54403 (44.973973, -89.614429) 02/01/2020
13380 13380 1618 LAUREL AVENUE REDLANDS, CA 92373 34.038455 -117.20323 0   555350 TERRACINA POST ACUTE 1618 LAUREL AVENUE REDLANDS CA 92373 9097926050 460 San Bernardino For profit - Corporation 243 233.5 Medicare and Medicaid false LAUREL AVENUE LLC 04/07/1989 false SFF false false false Resident Yes   18   18   18   18   18   18   18     2.18469 1.09963 0.17653 1.27616 3.46085 0.09152 2.08404 0.80361 0.57872 3.46636 2.17872 1.02893 0.11481 3.20156 11/18/2019 17 15 2 100 2 50 150 11/30/2018 14 9 5 430 2 215 645 2017-11-03 29 9 20 1 148 0 148 314.667 4 19 1 33099.00 1 2 1618 LAUREL AVENUE REDLANDS, CA 92373 (34.038455, -117.20323) 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
);