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

7 rows where Number of Facility Reported Incidents = 11 and Total Number of Penalties = 3

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, ownership, Continuing Care Retirement Community, Special Focus Status, Abuse Icon, With a Resident and Family Council, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, RN Staffing Rating, 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 3 Number of Standard Health Deficiencies, Rating Cycle 3 Number of Health Revisits, Rating Cycle 3 Health Revisit Score, Number of Substantiated Complaints, Number of Fines, Number of Payment Denials, 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
991 991 6800 WEST MAPLE WEST BLOOMFIELD, MI 48322 42.541518 -83.409635 0   235288 MARVIN & BETTY DANTO FAMILY HEALTH CARE CENTER 6800 WEST MAPLE WEST BLOOMFIELD MI 48322 2487885300 620 Oakland Non profit - Corporation 155 113.1 Medicare and Medicaid false HEALTH CARE AND RETIREMENT CORPORATION OF AMERICA LLC 03/01/1976 false   false false false Resident Yes 1   1   2   1   4   3   3       2.12369 1.4392 0.67796 2.11716 4.24085 0.1792 2.22982 0.75934 0.35724 3.3464 1.97941 1.42518 0.71428 4.06376 09/25/2019 26 18 12 164 1 0 164 08/02/2018 28 21 7 231 1 0 231 2017-06-09 15 13 3 1 88 0 88 173.667 11 41 2 114830.00 1 3 6800 WEST MAPLE WEST BLOOMFIELD, MI 48322 (42.541518, -83.409635) 02/01/2020
1487 1487 9935 RED ARROW HWY BRIDGMAN, MI 49106 41.938831 -86.566105 0   235625 WEST WOODS OF BRIDGMAN 9935 RED ARROW HWY BRIDGMAN MI 49106 2694653017 100 Berrien For profit - Corporation 92 69.5 Medicare and Medicaid false BRIDGMAN CARE OPERATING, LLC 11/28/2006 false   false false false Resident Yes 3   3   4   4   4   2   2       2.14381 0.85967 0.32968 1.18936 3.33316 0.07511 1.94361 0.69014 0.32617 2.95991 2.29241 0.93666 0.38044 3.61103 01/10/2020 17 9 8 144 0 0 144 10/11/2018 5 5 0 44 1 0 44 2017-09-13 10 9 4 1 76 0 76 99.333 11 3 2 16157.00 1 3 9935 RED ARROW HWY BRIDGMAN, MI 49106 (41.938831, -86.566105) 02/01/2020
2768 2768 2786 56th St SW, Wyoming, MI 49418, USA 42.8619265 -85.73239199999999 1 ROOFTOP 235630 MEDILODGE OF WYOMING 2786 56 STREET, SW WYOMING MI 49418 6162613960 400 Kent For profit - Corporation 80 77.6 Medicare and Medicaid false WYOMING OPCO LLC 06/26/2007 false   false false false Both Yes 1   1   4   5   4   3   3       2.40131 1.07908 0.50036 1.57944 3.98075 0.05721 2.09757 0.66717 0.29717 3.06192 2.37929 1.21618 0.63373 4.16892 11/28/2018 5 4 1 20 1 0 20 08/24/2017 22 9 13 239 1 0 239 2016-08-10 34 20 14 2 355 178 533 178.5 11 19 3 130772.00 0 3   02/01/2020
3829 3829 1501 OFFICE PARK ROAD WEST DES MOINES, IA 50265 41.592115 -93.724901 0   165350 FOUNTAIN WEST HEALTH CENTER 1501 OFFICE PARK ROAD WEST DES MOINES IA 50265 5152231223 760 Polk For profit - Corporation 140 72.6 Medicare and Medicaid false FOUNTAIN HEALTH CENTERS INC 07/22/1997 true SFF Candidate false false false Resident Yes 1   1   4   4   5   3   2       3.27134 0.91286 0.41774 1.3306 4.60194 0.06058 1.93617 0.693 0.31091 2.94007 3.51154 0.99051 0.50572 5.01922 06/27/2019 13 8 5 60 1 0 60 03/22/2018 25 15 11 156 1 0 156 2017-01-24 31 20 11 1 345 0 345 139.5 11 20 3 47700.00 0 3 1501 OFFICE PARK ROAD WEST DES MOINES, IA 50265 (41.592115, -93.724901) 02/01/2020
9253 9253 1110 TX-135, Overton, TX 75684, USA 32.2658879 -94.98140459999999 1 ROOFTOP 675408 OVERTON HEALTHCARE CENTER 1110 HWY 135 S OVERTON TX 75684 9038346166 881 Rusk For profit - Corporation 100 50.2 Medicare and Medicaid false SLP OVERTON LLC 11/14/1994 false   false false false Resident Yes 1   2   3   3     2 1   1       1.9067 1.13501 0.20221 1.33722 3.24391 0.01218 2.00581 0.80947 0.43167 3.24695 1.97564 1.05434 0.17631 3.20366 04/04/2019 8 4 6 72 1 0 72 05/18/2018 9 5 8 112 1 0 112 2017-04-20 19 16 12 1 252 0 252 115.333 11 8 3 28775.00 0 3   02/01/2020
12300 12300 17 EAST 8TH AVENUE SPOKANE, WA 99202 47.648118 -117.409068 0   505414 PROVIDENCE ST JOSEPH CARE CENTER 17 EAST 8TH AVENUE SPOKANE WA 99202 5094745678 310 Spokane Non profit - Corporation 162 100.5 Medicare and Medicaid false PROVIDENCE HEALTH & SERVICES - WASHINGTON 06/06/1992 false   true false false Resident Yes 3   2   3   2   3   4   5       1.97282 0.55071 1.35155 1.90226 3.87508 0.29679 2.03617 0.79963 0.43142 3.26722 2.01368 0.51786 1.17913 3.80325 02/21/2019 36 25 11 224 1 0 224 12/21/2017 22 16 6 132 1 0 132 2017-02-13 24 19 5 1 255 0 255 198.5 11 8 3 135271.00 0 3 17 EAST 8TH AVENUE SPOKANE, WA 99202 (47.648118, -117.409068) 02/01/2020
12888 12888 3309 45TH STREET COURT NORTHWEST GIG HARBOR, WA 98335 47.299604 -122.583235 0   505436 MANOR CARE OF GIG HARBOR WA, LLC 3309 45TH STREET COURT NORTHWEST GIG HARBOR WA 98335 2538588688 260 Pierce Non profit - Corporation 120 82.6 Medicare and Medicaid false MANOR CARE OF GIG HARBOR WA LLC 01/01/1992 false   false false false Resident Yes 2   1   4   4   5   4   4       2.38947 0.80156 0.66711 1.46867 3.85814 0.04087 2.06495 0.69723 0.31786 3.08004 2.40496 0.86446 0.78994 4.01675 10/03/2019 16 15 1 80 2 40 120 07/23/2018 40 23 17 393 1 0 393 2017-09-01 17 16 1 1 132 0 132 213 11 13 3 60879.00 0 3 3309 45TH STREET COURT NORTHWEST GIG HARBOR, WA 98335 (47.299604, -122.583235) 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
);