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

12 rows where Health Inspection Rating = 1 and ownership = "Government - City"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, prvdr_cnty_name, Provider Resides in Hospital, Legal Business Name, Date First Approved to Provide Medicare and Medicaid services, Special Focus Status, With a Resident and Family Council, Overall 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 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 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 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, Number of Payment Denials, Total Number of Penalties, 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
998 998 702 WEST GAINES ST DERMOTT, AR 71638 33.519137 -91.444469 0   45172 DERMOTT CITY NURSING HOME 702 WEST GAINES ST DERMOTT AR 71638 8705383241 80 Chicot Government - City 70 49.9 Medicare and Medicaid false DERMOTT CITY NURSING HOME 10/01/1991 false   false false false Both Yes 1   1   3   2   3   3   2       3.33231 0.84782 0.29358 1.14139 4.47371 0.09432 1.89953 0.69074 0.32354 2.91381 3.64599 0.92293 0.34153 4.92334 01/18/2019 7 6 1 123 2 62 185 01/12/2018 13 13 0 213 1 0 213 2016-12-02 4 1 3 1 40 0 40 170.167 0 4 1 13780.00 1 2 702 WEST GAINES ST DERMOTT, AR 71638 (33.519137, -91.444469) 02/01/2020
2509 2509 Countryside Dr, Milford, MA 01757, USA 42.1506351 -71.5540872 1 GEOMETRIC_CENTER 225463 COUNTRYSIDE HEALTH CARE OF MILFORD COUNTRYSIDE DRIVE MILFORD MA 1757 5084730435 170 Worcester Government - City 109 100.4 Medicare and Medicaid false GERIATRIC AUTHORITY OF MILFORD 07/01/1990 false   false false false Resident Yes 2   1   2   2   3   4   4       2.62486 1.35318 0.63496 1.98815 4.613 0 2.11148 0.66534 0.30054 3.07736 2.58365 1.52931 0.79521 4.80682 05/24/2019 8 8 0 56 1 0 56 02/20/2018 16 16 5 140 1 0 140 2016-11-14 3 1 2 1 44 0 44 82 3 2 3 74578.00 0 3   02/01/2020
3125 3125 71434 HWY 25 TRENTON, NE 69044 40.188311 -101.013164 0   285253 EL DORADO MANOR NURSING HOME 71434 HWY 25, BOX 97 TRENTON NE 69044 3083345241 430 Hitchcock Government - City 40 27.7 Medicare and Medicaid false TRENTON NURSING HOME - VILLAGE OF TRENTON 10/01/2004 false   false false false Resident Yes 2   1   4   4   4   4   4       2.40772 0.76902 0.72803 1.49705 3.90477 0.00712 2.13161 0.61826 0.26963 3.0195 2.34755 0.9353 1.01626 4.14681 10/25/2018 19 19 0 120 1 0 120 11/02/2017 17 17 2 104 1 0 104 2016-11-08 19 19 0 1 203 0 203 128.5 4 2 0 0.00 0 0 71434 HWY 25 TRENTON, NE 69044 (40.188311, -101.013164) 02/01/2020
4371 4371 106 EAST 13TH STREET BAYARD, NE 69334 41.764137 -103.321924 0   285260 CHIMNEY ROCK VILLA P O BOX A, 106 EAST 13TH STREET BAYARD NE 69334 3085861142 610 Morrill Government - City 49 30.5 Medicare and Medicaid false CHIMNEY ROCK VILLA 06/01/2004 false   false false false Resident Yes 2   1   5   5   5   4   4       2.52783 0.45662 0.7478 1.20441 3.73224 0.00671 1.90593 0.6331 0.27596 2.81498 2.7565 0.54234 1.01992 4.25155 01/08/2019 13 13 5 92 1 0 92 12/20/2017 12 6 6 76 1 0 76 2017-01-05 7 7 0 1 40 0 40 78 1 7 0 0.00 0 0 106 EAST 13TH STREET BAYARD, NE 69334 (41.764137, -103.321924) 02/01/2020
4685 4685 402 WEST FIRST STREET ADRIAN, MO 64720 38.394542 -94.359107 0   265780 ADRIAN MANOR HEALTH & REHABILITATION CENTER 402 WEST FIRST STREET ADRIAN MO 64720 8162972107 60 Bates Government - City 60 42.4 Medicare and Medicaid false CITY OF ADRIAN - ADRIAN MANOR HEALTH AND REHAB 02/19/2004 false   false false false Resident Yes 1   1   2   1   4   2   2       2.50125 0.63622 0.33634 0.97256 3.47381 0.01197 2.00003 0.65524 0.28216 2.93742 2.59918 0.73012 0.44866 3.79221 01/17/2019 19 19 0 179 1 0 179 04/19/2018 5 5 0 36 1 0 36 2017-03-02 7 6 1 1 40 0 40 108.167 0 1 1 42110.00 1 2 402 WEST FIRST STREET ADRIAN, MO 64720 (38.394542, -94.359107) 02/01/2020
6974 6974 1012 NORTH DIVISION STREET CLARA CITY, MN 56222 44.962575 -95.370873 0   245573 CLARA CITY CARE CENTER 1012 NORTH DIVISION STREET PO BOX 797 CLARA CITY MN 56222 3208472221 110 Chippewa Government - City 48 42.1 Medicare and Medicaid false CITY OF CLARA CITY 10/01/1991 false   false false false Resident Yes 2   1   3   2   4   5   5       2.31498 0.59525 0.84201 1.43726 3.75223 0.03086 2.0163 0.63854 0.26045 2.9153 2.3862 0.70096 1.21679 4.12724 09/12/2019 3 2 2 40 1 0 40 09/21/2018 22 22 0 257 1 0 257 2017-08-31 6 6 0 1 20 0 20 109 2 0 0 0.00 0 0 1012 NORTH DIVISION STREET CLARA CITY, MN 56222 (44.962575, -95.370873) 02/01/2020
9584 9584 3520 Highland Dr, Millcreek, UT 84106, USA 40.6949272 -111.849639 1 ROOFTOP 465185 MILLCREEK REHABILITATION AND NURSING, LLC 3520 SOUTH HIGHLAND DRIVE SALT LAKE CITY UT 84106 8014847638 170 Salt Lake Government - City 61 43.1 Medicare and Medicaid true BEAVER VALLEY HOSPITAL 04/04/2016 false SFF Candidate false false false Resident Yes 1   1   3   4   3   3   4       1.88533 0.14658 1.07926 1.22583 3.11116 0.00729 1.83421 0.8228 0.44572 3.10273 2.13626 0.13395 0.91136 3.21537 05/14/2019 38 30 8 377 1 0 377 08/15/2018 12 12 0 48 1 0 48 2017-05-10 6 3 3 1 44 0 44 211.833 0 10 1 38695.00 0 1   02/01/2020
11797 11797 1404 NORTH GARLAND ROAD ENID, OK 73703 36.409897 -97.943846 0   375527 GARLAND ROAD NURSING & REHAB CENTER 1404 NORTH GARLAND ROAD ENID OK 73703 5802342526 230 Garfield Government - City 118 86.8 Medicare and Medicaid false CITY OF PAULS VALLEY 09/01/2008 false   false false false Resident Yes 1   1   3   4   2   2   2       1.95036 0.43953 0.38111 0.82064 2.771 0.02367 1.85072 0.71046 0.34602 2.9072 2.19024 0.46519 0.41455 3.05644 07/15/2019 20 17 3 384 1 0 384 04/24/2018 11 6 5 104 1 0 104 2017-05-31 6 5 1 1 40 0 40 233.333 1 6 0 0.00 1 1 1404 NORTH GARLAND ROAD ENID, OK 73703 (36.409897, -97.943846) 02/01/2020
12278 12278 8001 W 5TH STREET BOWDLE, SD 57428 45.448546 -99.660939 0   435107 BOWDLE NURSING HOME 8001 W 5TH STREET POST OFFICE BOX 556 BOWDLE SD 57428 6052856146 220 Edmunds Government - City 38 33.1 Medicare and Medicaid false BOWDLE HOSPITAL 09/01/1997 false   false false false Resident Yes 1   1   1   1     2 5   5       2.71476 0.33166 0.92646 1.25812 3.97288 0.00443 2.05187 0.61498 0.29687 2.96372 2.74978 0.40552 1.17459 4.29854 04/03/2019 12 7 5 100 1 0 100 12/07/2017 2 2 0 12 1 0 12 2016-09-14 5 5 0 1 20 0 20 57.333 2 0 1 19246.00 0 1 8001 W 5TH STREET BOWDLE, SD 57428 (45.448546, -99.660939) 02/01/2020
12359 12359 1481 EAST 1450 SOUTH CLEARFIELD, UT 84015 41.092837 -111.997821 0   465067 ROCKY MOUNTAIN CARE - CLEARFIELD 1481 EAST 1450 SOUTH CLEARFIELD UT 84015 8017284300 50 Davis Government - City 168 124.4 Medicare and Medicaid true BEAVER VALLEY HOSPITAL 03/02/1981 false   false false false Resident Yes 2   1   4   3   5   4   4       2.53551 0.4928 1.01185 1.50465 4.04016 0.07575 2.19242 0.81411 0.45045 3.45698 2.40358 0.45517 0.84548 3.74762 01/10/2019 19 16 5 108 1 0 108 10/16/2017 21 14 20 128 1 0 128 2016-06-08 14 11 3 1 120 0 120 116.667 0 25 0 0.00 0 0 1481 EAST 1450 SOUTH CLEARFIELD, UT 84015 (41.092837, -111.997821) 02/01/2020
12760 12760 4090 WEST PIONEER PARKWAY WEST VALLEY CITY, UT 84120 40.69839 -111.988691 0   465075 ROCKY MOUNTAIN CARE - HUNTER HOLLOW 4090 WEST PIONEER PARKWAY WEST VALLEY CITY UT 84120 8013974400 170 Salt Lake Government - City 124 102 Medicare and Medicaid true BEAVER VALLEY HOSPITAL 08/01/1980 false SFF Candidate false false false Resident Yes 2   1   4   5   4   4   4       2.72464 0.34324 1.17263 1.51587 4.24051 0.14058 2.28149 0.85333 0.49432 3.62915 2.48203 0.30246 0.89286 3.74686 01/24/2019 8 7 1 40 1 0 40 12/12/2017 35 33 6 323 2 162 485 2016-12-01 28 28 0 1 287 0 287 229.5 0 8 2 129982.00 1 3 4090 WEST PIONEER PARKWAY WEST VALLEY CITY, UT 84120 (40.69839, -111.988691) 02/01/2020
13914 13914 730 SHARE DRIVE ALVA, OK 73717 36.786902 -98.669125 0   375550 SHARE MEDICAL CENTER 730 SHARE DRIVE ALVA OK 73717 5803272800 750 Woods Government - City 80 54.2 Medicare and Medicaid false ALVA HOSPITAL AUTHORITY 03/11/2012 false   false false false Resident Yes 1   1   1   1     2 1 12 1 12 6 6                             08/26/2019 16 14 2 128 1 0 128 10/16/2018 16 16 0 112 1 0 112 2017-08-28 11 11 0 1 76 0 76 114 0 0 0 0.00 0 0 730 SHARE DRIVE ALVA, OK 73717 (36.786902, -98.669125) 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
);