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

28 rows where Health Inspection Rating = 3 and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-09-21

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, prvdr_cnty_name, ownership, nmbr_beds, prvdr_type, Legal Business Name, Continuing Care Retirement Community, 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 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 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 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, 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
15 15 1225 S Ewing Dr, Pontiac, IL 61764, USA 40.8676787 -88.6782973 1 ROOFTOP 145930 GOOD SAMARITAN - PONTIAC 1225 SOUTH EWING DRIVE PONTIAC IL 61764 8158445121 610 Livingston Non profit - Corporation 90 49.5 Medicare and Medicaid false GOOD SAMARITAN - PONTIAC 08/01/1997 false   false false false Resident Yes 3   3   3   2   3   3   3       2.17865 0.86809 0.50154 1.36962 3.54828 0.09466 1.96838 0.71658 0.32533 3.0103 2.30036 0.91092 0.58023 3.77973 09/12/2019 5 4 1 32 1 0 32 10/11/2018 8 4 4 32 1 0 32 2017-09-21 13 13 0 1 84 0 84 40.667 1 2 0 0.00 0 0   02/01/2020
1112 1112 4360 JOHNSON FERRY PLACE MARIETTA, GA 30068 33.981232 -84.422466 0   115283 MANOR CARE REHABILITATION CENTER - MARIETTA 4360 JOHNSON FERRY PLACE MARIETTA GA 30068 7709715870 290 Cobb Non profit - Other 117 109.6 Medicare and Medicaid false MANOR CARE OF MARIETTA GA LLC 10/15/1981 false   false false false Resident Yes 3   3   4   5   4   3   3       1.9681 0.96249 0.6699 1.63239 3.60049 0.23759 2.13279 0.82002 0.4011 3.35391 1.91786 0.88258 0.62862 3.44241 08/29/2019 3 3 0 12 1 0 12 06/07/2018 4 4 0 20 1 0 20 2017-09-21 3 3 0 1 12 0 12 14.667 0 0 0 0.00 0 0 4360 JOHNSON FERRY PLACE MARIETTA, GA 30068 (33.981232, -84.422466) 02/01/2020
1870 1870 347 Ballenger Center Dr, Frederick, MD 21703, USA 39.3966332 -77.4297631 1 ROOFTOP 215001 BALLENGER CREEK CENTER 347 BALLENGER DRIVE FREDERICK MD 21701 3016635181 100 Frederick For profit - Corporation 143 111.5 Medicare and Medicaid false 700 TOLL HOUSE AVENUE OPERATIONS LLC 12/05/1969 false   false false false Both Yes 3   3   4   4   4   3   3       2.21368 1.10248 0.78548 1.88796 4.10164 0.06264 2.2432 0.83462 0.41788 3.4957 2.05098 0.99327 0.70748 3.7625 11/19/2018 10 10 0 48 1 0 48 04/18/2018 15 15 2 88 1 0 88 2017-09-21 11 9 3 1 60 0 60 63.333 1 3 0 0.00 0 0   02/01/2020
2094 2094 2355 ROYAL BOULEVARD ELGIN, IL 60123 42.05241 -88.338902 0   145821 ROSEWOOD CARE CENTER OF ELGIN 2355 ROYAL BOULEVARD ELGIN IL 60123 8478889585 530 Kane For profit - Limited Liability company 139 102.7 Medicare and Medicaid false BRAVO CARE OF ELGIN INC 12/07/1994 false   false false false None Yes 5   3   5   4   5   4   5       1.964 0.61965 1.2432 1.86285 3.82685 0.05679 2.18385 0.77128 0.34211 3.29724 1.86911 0.60411 1.36776 3.72172 08/28/2019 7 6 1 32 1 0 32 07/13/2018 9 8 1 64 1 0 64 2017-09-21 8 8 0 1 48 0 48 45.333 0 3 0 0.00 0 0 2355 ROYAL BOULEVARD ELGIN, IL 60123 (42.05241, -88.338902) 02/01/2020
3469 3469 29 MAURICE DRIVE BRUNSWICK, ME 04011 43.896802 -69.980531 0   205085 HORIZONS LIVING AND REHAB CENTER 29 MAURICE DRIVE BRUNSWICK ME 4011 2077257495 20 Cumberland For profit - Corporation 65 63.8 Medicare and Medicaid false HORIZONS LIVING AND REHAB CENTER, INC 01/01/1993 false   false false false Resident Yes 5   3   5   5   5   5   5       2.69723 0.99686 0.87744 1.8743 4.57153 0.07906 2.19011 0.71631 0.30795 3.21437 2.55957 1.04646 1.07244 4.56057 10/24/2019 3 3 0 4 1 0 4 10/03/2018 6 5 1 36 1 0 36 2017-09-21 4 4 3 1 16 0 16 16.667 1 1 0 0.00 0 0 29 MAURICE DRIVE BRUNSWICK, ME 04011 (43.896802, -69.980531) 02/01/2020
3981 3981 249 HIGH STREET NEWTON, NJ 07860 41.054021 -74.768016 0   315137 BARN HILL CARE CENTER 249 HIGH STREET NEWTON NJ 7860 9733835600 360 Sussex For profit - Individual 154 131.4 Medicare and Medicaid false BARN HILL CARE CENTER INC 05/07/1972 false   false false false Both Yes 4   3   5   5   5   3   3       1.85214 1.16748 0.58067 1.74814 3.60028 0.09615 2.02005 0.70336 0.33397 3.05738 1.90557 1.24812 0.65442 3.77607 11/20/2019 2 2 0 8 1 0 8 12/06/2018 6 6 0 20 1 0 20 2017-09-21 4 4 0 1 36 0 36 16.667 0 0 1 3900.00 0 1 249 HIGH STREET NEWTON, NJ 07860 (41.054021, -74.768016) 02/01/2020
5075 5075 308 AMELIA STREET RAYNE, LA 70578 30.224873 -92.267525 0   195464 ELLINGTON ( THE ) 308 AMELIA STREET RAYNE LA 70578 3373345111 0 Acadia For profit - Corporation 120 113.3 Medicare and Medicaid false RAYNE GUEST HOME INC 06/01/1998 false   false false false Resident Yes 3   3   3   2   3   2   1       2.41353 1.06525 0.20648 1.27174 3.68526 0.08875 1.93029 0.74174 0.364 3.03603 2.59863 1.0799 0.21351 3.89238 08/29/2019 6 6 0 28 1 0 28 08/23/2018 2 2 0 8 1 0 8 2017-09-21 1 1 0 1 8 0 8 18 0 0 1 6893.00 0 1 308 AMELIA STREET RAYNE, LA 70578 (30.224873, -92.267525) 02/01/2020
5105 5105 1599 KEOKUK STREET HAMILTON, IL 62341 40.396422 -91.335985 0   145471 MONTEBELLO HEALTHCARE CENTER 1599 KEOKUK STREET HAMILTON IL 62341 2178473931 420 Hancock For profit - Corporation 139 52.4 Medicare and Medicaid false SSC HAMILTON OPERATING COMPANY LLC 08/16/1983 false   false false false Resident Yes 3   3   3   2   4   3   3       2.17565 0.86005 0.55067 1.41073 3.58637 0.10087 1.97118 0.75405 0.3829 3.10813 2.29392 0.85765 0.54131 3.70007 08/21/2019 9 6 3 40 1 0 40 10/25/2018 11 11 0 44 1 0 44 2017-09-21 20 8 14 1 84 0 84 48.667 3 13 0 0.00 0 0 1599 KEOKUK STREET HAMILTON, IL 62341 (40.396422, -91.335985) 02/01/2020
5642 5642 275 CALEDONIA DRIVE OWOSSO, MI 48867 42.999193 -84.125816 0   235067 PLEASANT VIEW SHIAWASSEE COUNTY MED CARE FAC 275 CALEDONIA DRIVE OWOSSO MI 48867 9897433491 770 Shiawassee Government - County 136 128.8 Medicare and Medicaid false SHIAWASSEE COUNTY MEDICAL CARE FACILITY 01/01/1967 false   false false false Resident Yes 5   3   5   4   5   5   5       3.44231 0.37854 1.3941 1.77264 5.21495 0.04636 2.06793 0.71198 0.33074 3.11065 3.45963 0.39978 1.5865 5.37592 10/30/2019 3 3 0 40 1 0 40 01/10/2019 21 20 4 108 2 54 162 2017-09-21 11 10 3 1 92 0 92 89.333 9 2 1 9100.00 0 1 275 CALEDONIA DRIVE OWOSSO, MI 48867 (42.999193, -84.125816) 02/01/2020
6262 6262 9105 OXFORD PLACE DRIVE BATON ROUGE, LA 70809 30.419489 -91.080394 0   195494 LANDMARK OF BATON ROUGE 9105 OXFORD PLACE DRIVE BATON ROUGE LA 70809 2252931003 160 E. Baton Rouge For profit - Corporation 144 114.7 Medicare and Medicaid false LANDMARK HERITAGE, LLC 06/02/2000 false   false false false Both Yes 2   3   2   3   2   1   1       2.02966 1.19754 0.2163 1.41383 3.44349 0.05651 2.12858 0.76408 0.36316 3.25582 1.98176 1.17851 0.22417 3.3915 11/21/2019 3 3 0 12 1 0 12 10/11/2018 2 0 2 24 0 0 24 2017-09-21 4 0 4 0 48 0 48 22 0 5 2 12196.00 0 2 9105 OXFORD PLACE DRIVE BATON ROUGE, LA 70809 (30.419489, -91.080394) 02/01/2020
7423 7423 13301 SOUTH CENTRAL AVENUE CRESTWOOD, IL 60445 41.650008 -87.757704 0   1.4e+178 CRESTWOOD TERRACE 13301 SOUTH CENTRAL AVENUE CRESTWOOD IL 60445 7085975251 141 Cook For profit - Corporation 126 111.1 Medicaid false Legal Business Name Not Available 04/11/1975 false   false false false Resident Yes 2   3   3   3     2 1 12 1 12 6 6                             08/01/2019 5 4 3 52 1 0 52 08/23/2018 9 8 1 72 1 0 72 2017-09-21 5 5 0 1 44 0 44 57.333 1 6 0 0.00 0 0 13301 SOUTH CENTRAL AVENUE CRESTWOOD, IL 60445 (41.650008, -87.757704) 02/01/2020
8751 8751 400 29TH STREET NORTHEAST PUYALLUP, WA 98373 47.193695 -122.255734 0   505485 LINDEN GROVE HEALTH CARE CENTER 400 - 29TH STREET NORTHEAST PUYALLUP WA 98373 2538404400 260 Pierce For profit - Corporation 130 105.2 Medicare and Medicaid false 400 29TH STREET NORTHEAST OPERATIONS LLC 08/04/1993 false   false false false Resident Yes 4   3   5   5   5   2   2       2.05439 1.06179 0.44578 1.50757 3.56196 0.08702 2.09181 0.76095 0.36795 3.22071 2.04116 1.04922 0.456 3.54642 11/08/2019 20 20 0 112 1 0 112 11/15/2018 18 18 0 80 1 0 80 2017-09-21 13 13 3 1 96 0 96 98.667 1 0 1 52650.00 0 1 400 29TH STREET NORTHEAST PUYALLUP, WA 98373 (47.193695, -122.255734) 02/01/2020
8769 8769 604 STOKES STREET EAST AHOSKIE, NC 27910 36.277434 -76.983905 0   345359 ACCORDIUS HEALTH AT CREEKSIDE CARE 604 STOKES STREET EAST AHOSKIE NC 27910 2523322126 450 Hertford For profit - Limited Liability company 151 131.1 Medicare and Medicaid false ACCORDIUS HEALTH AT CREEKSIDE CARE, LLC 04/04/1991 false   false false false Resident Yes 1   3   1   1   2   1   1       2.06234 0.95513 0.29783 1.25297 3.3153 0.04587 2.05471 0.78994 0.40793 3.25258 2.08605 0.90919 0.2748 3.2685 08/22/2019 4 4 0 16 1 0 16 08/24/2018 8 7 1 44 1 0 44 2017-09-21 1 0 1 0 4 0 4 23.333 0 1 1 12678.00 0 1 604 STOKES STREET EAST AHOSKIE, NC 27910 (36.277434, -76.983905) 02/01/2020
9200 9200 13500 BRETON RIDGE HOUSTON, TX 77070 29.968813 -95.54296 0   676236 BROOKDALE PLACE WILLOWBROOK 13500 BRETON RIDGE HOUSTON TX 77070 2818074744 610 Harris For profit - Corporation 98 72.2 Medicare and Medicaid false ARC WILLOWBROOK, LLC 09/15/2009 true   false false false Resident Yes 4   3   4   3   5   4   4       1.89134 1.31728 1.25581 2.57309 4.46443 0.193 2.18757 0.87721 0.46465 3.52943 1.7969 1.12917 1.01726 4.05616 08/15/2019 9 4 5 60 1 0 60 09/13/2018 8 4 4 44 1 0 44 2017-09-21 7 5 2 1 72 0 72 56.667 1 5 0 0.00 0 0 13500 BRETON RIDGE HOUSTON, TX 77070 (29.968813, -95.54296) 02/01/2020
9321 9321 635 HARKLE ROAD SANTA FE, NM 87505 35.659306 -105.952829 0   325030 SANTA FE CARE CENTER 635 HARKLE ROAD SANTA FE NM 87505 5059822574 240 Santa Fe For profit - Corporation 120 104.4 Medicare and Medicaid false DIAMOND CARE SANTA FE LLC 09/04/1980 false   false false false Resident Yes 3   3   2   2   1   2   2       2.16595 0.45262 0.42983 0.88245 3.0484 0.07308 1.95017 0.70724 0.32389 2.9813 2.3083 0.48122 0.4995 3.27884 07/19/2019 21 20 1 172 1 0 172 10/28/2018 11 11 0 108 1 0 108 2017-09-21 8 8 0 1 56 0 56 131.333 0 1 0 0.00 0 0 635 HARKLE ROAD SANTA FE, NM 87505 (35.659306, -105.952829) 02/01/2020
9853 9853 107 N MEDINA LOCKHART, TX 78644 29.884513 -97.684546 0   675053 CHISOLM TRAIL NURSING AND REHABILITATION CENTER 107 N MEDINA LOCKHART TX 78644 5123985213 223 Caldwell For profit - Corporation 96 69.4 Medicare and Medicaid false DIVERSICARE CHISOLM, LLC 06/26/1992 false   false false false Resident Yes 3   3   4   3   4   2   2       1.68575 0.73768 0.41143 1.14911 2.83485 0 1.90315 0.70807 0.34235 2.95357 1.84092 0.78338 0.45233 3.07777 09/13/2019 4 4 0 20 1 0 20 09/14/2018 10 9 5 68 1 0 68 2017-09-21 18 16 2 1 120 0 120 52.667 1 0 0 0.00 0 0 107 N MEDINA LOCKHART, TX 78644 (29.884513, -97.684546) 02/01/2020
11322 11322 224 W PLEASANT RUN RD CEDAR HILL, TX 75104 32.604369 -96.947304 0   676112 CRESTVIEW COURT 224 W PLEASANT RUN RD CEDAR HILL TX 75104 9722915977 390 Dallas For profit - Corporation 125 90.4 Medicare and Medicaid false DALLAS COUNTY HOSPITAL DISTRICT 08/31/2006 false   false false false Resident Yes 4   3   5   4   5   2   2       1.89413 0.9736 0.48287 1.45646 3.35059 0.12236 2.17231 0.83308 0.46211 3.4675 1.81219 0.87877 0.39329 3.09854 09/27/2019 0 0 0 0 0 0 0 09/15/2018 1 1 1 75 1 0 75 2017-09-21 6 2 6 1 104 0 104 42.333 0 3 2 12990.00 0 2 224 W PLEASANT RUN RD CEDAR HILL, TX 75104 (32.604369, -96.947304) 02/01/2020
11343 11343 551 KENT STREET ANDREWS, NC 28901 35.194591 -83.841981 0   345426 VALLEY VIEW CARE & REHAB CENTER 551 KENT STREET ANDREWS NC 28901 8283213075 190 Cherokee For profit - Corporation 76 55.4 Medicare and Medicaid false VALLEY VIEW HEALTHCARE, LLC 10/15/1992 false   false false false Resident Yes 3   3   3   3   3   3   4       1.54127 0.70829 0.80004 1.50833 3.0496 0.06329 1.81885 0.7191 0.35649 2.89444 1.76116 0.74063 0.84468 3.37856 09/11/2019 2 2 0 8 1 0 8 09/14/2018 0 0 0 0 0 0 0 2017-09-21 14 7 9 2 84 42 126 25 0 10 1 11102.00 0 1 551 KENT STREET ANDREWS, NC 28901 (35.194591, -83.841981) 02/01/2020
11469 11469 17040 ARNOLD DR RIVERSIDE, CA 92518 33.872711 -117.293243 0   555404 AFVW HEALTH CENTER 17040 ARNOLD DR. RIVERSIDE CA 92518 9512386803 430 Riverside Non profit - Corporation 59 51.5 Medicare false Legal Business Name Not Available 01/05/1990 true   false false false Resident Yes 3   3   5   5   5   1 12 1 12     2.12648 1.18442 0.40682 1.59124 3.71772 0.04169 2.24118 0.8284 0.42028 3.48987 1.97197 1.0751 0.36433 3.41603 08/09/2019 9 8 1 52 1 0 52 09/13/2018 12 8 4 52 1 0 52 2017-09-21 12 8 4 1 44 0 44 50.667 4 3 0 0.00 0 0 17040 ARNOLD DR RIVERSIDE, CA 92518 (33.872711, -117.293243) 02/01/2020
11875 11875 70 HARRISON AVENUE NEWPORT, RI 02840 41.471447 -71.322583 0   415074 VILLAGE HOUSE NURSING & REHABILITATION CENTER 70 HARRISON AVENUE NEWPORT RI 2840 4018495222 20 Newport For profit - Corporation 95 73.4 Medicare and Medicaid false VILLAGE HOUSE CONVALESCENT HOME INC 03/19/1980 false   false false false Resident Yes 5   3   5   5   5   4   5       2.19113 0.17628 0.9659 1.14218 3.33331 0.08044 2.13378 0.71184 0.33087 3.17649 2.1342 0.18621 1.09876 3.36497 10/11/2019 1 1 1 8 1 0 8 10/18/2018 1 1 1 4 1 0 4 2017-09-21 1 1 0 1 8 0 8 6.667 3 0 0 0.00 0 0 70 HARRISON AVENUE NEWPORT, RI 02840 (41.471447, -71.322583) 02/01/2020
12134 12134 2120 BENTON DRIVE REDDING, CA 96003 40.598582 -122.399847 0   555356 QUARTZ HILL POST ACUTE 2120 BENTON DRIVE REDDING CA 96003 5302436317 550 Shasta For profit - Limited Liability company 115 105.5 Medicare and Medicaid false HONOLUA BAY HOLDINGS LLC 04/10/1989 false   false false false Resident Yes 4   3   5   5   5   3   1       2.69294 1.69675 0.3324 2.02915 4.72209 0.10373 2.07659 0.79653 0.41591 3.28903 2.6952 1.60177 0.30081 4.60383 09/05/2019 2 2 0 8 1 0 8 09/27/2018 21 16 8 80 1 0 80 2017-09-21 28 12 16 1 216 0 216 66.667 12 15 3 62773.00 1 4 2120 BENTON DRIVE REDDING, CA 96003 (40.598582, -122.399847) 02/01/2020
12253 12253 1505 ORRIN RD PRESCOTT, WI 54021 44.760879 -92.785849 0   525398 PRESCOTT NURSING AND REHAB COMMUNITY 1505 ORRIN RD PRESCOTT WI 54021 7152625661 460 Pierce For profit - Corporation 65 36.3 Medicare and Medicaid false ORION PRESCOTT LLC 08/01/1985 false   false false false Resident Yes 3   3   4   4   5   3   4       2.02589 0.55764 0.9453 1.50294 3.52882 0.11193 2.12548 0.7417 0.3863 3.25347 1.98095 0.56534 0.92104 3.47805 10/16/2019 8 7 1 60 1 0 60 11/08/2018 1 0 1 4 0 0 4 2017-09-21 8 6 2 1 40 0 40 38 1 2 0 0.00 0 0 1505 ORRIN RD PRESCOTT, WI 54021 (44.760879, -92.785849) 02/01/2020
12712 12712 1000 WESLEY PINES ROAD LUMBERTON, NC 28358 34.655565 -78.993879 0   345180 WESLEY PINES RETIREMENT COMM 1000 WESLEY PINES ROAD LUMBERTON NC 28358 9107389691 770 Robeson Non profit - Church related 62 54.1 Medicare and Medicaid false THE UNITED METHODIST RETIREMENT HOMES, INCORPORATED 12/01/1980 true   false false false Both Yes 3   3   3   1   5   3   2       2.98482 0.95965 0.41537 1.37502 4.35984 0.08328 2.10538 0.72502 0.34344 3.17384 2.94647 0.99529 0.45521 4.40492 09/19/2019 5 5 1 28 1 0 28 08/23/2018 2 2 0 36 1 0 36 2017-09-21 1 1 0 1 8 0 8 27.333 0 1 1 8518.00 1 2 1000 WESLEY PINES ROAD LUMBERTON, NC 28358 (34.655565, -78.993879) 02/01/2020
13881 13881 110 WEST WISSAHICKON AVE FLOURTOWN, PA 19031 40.097493 -75.218923 0   395278 SAINT JOSEPH VILLA 110 WEST WISSAHICKON AVE FLOURTOWN PA 19031 2158364179 560 Montgomery Non profit - Church related 106 98.8 Medicare and Medicaid false SAINT JOSEPH VILLA 02/11/1970 false   false false false Resident Yes 5   3   5   5   4   5   5       2.84228 0.21194 1.46516 1.67711 4.51939 0.16764 2.14876 0.90054 0.4984 3.54769 2.74913 0.17697 1.10647 4.08495 05/09/2019 12 12 0 72 1 0 72 07/19/2018 2 2 0 12 1 0 12 2017-09-21 7 7 0 1 52 0 52 48.667 0 0 1 9363.00 0 1 110 WEST WISSAHICKON AVE FLOURTOWN, PA 19031 (40.097493, -75.218923) 02/01/2020
14925 14925 1521 WEST 54TH STREET ERIE, PA 16509 42.075862 -80.088798 0   395262 WESTERN RESERVE HEALTHCAREANDREHABILITATION CENTER 1521 WEST 54TH STREET ERIE PA 16509 8148640671 320 Erie For profit - Corporation 133 89 Medicare and Medicaid false GUARDIAN ELDER CARE AT ERIE I LLC 10/01/1979 false   false false false Both Yes 3   3   4   4   4   2   3       1.78132 0.7265 0.6478 1.3743 3.15562 0.0985 2.0928 0.80375 0.42195 3.3185 1.76901 0.67967 0.57785 3.04927 10/31/2019 7 6 1 36 1 0 36 09/07/2018 12 8 12 52 1 0 52 2017-09-21 15 13 3 1 92 0 92 50.667 0 8 0 0.00 0 0 1521 WEST 54TH STREET ERIE, PA 16509 (42.075862, -80.088798) 02/01/2020
14969 14969 N8114 Co Rd WW, Mt Calvary, WI 53057, USA 43.8353759 -88.244348 1 ROOFTOP 525621 VILLA LORETTO NURSING HOME N8114 COUNTY WW MOUNT CALVARY WI 53057 9207533211 190 Fond Du Lac Non profit - Corporation 50 43.6 Medicare and Medicaid false SSCK INC 07/01/1997 false   false false false Both Yes 5   3   5   5     2 5   5       2.39641 0.38457 1.09175 1.47632 3.87273 0.01106 2.03032 0.66628 0.30095 2.99755 2.45308 0.43401 1.36542 4.14289 11/25/2019 8 4 4 40 1 0 40 11/29/2018 1 1 0 4 1 0 4 2017-09-21 2 2 0 1 20 0 20 24.667 1 0 0 0.00 0 0   02/01/2020
14974 14974 14900 PRIVATE DR EAST CLEVELAND, OH 44112 41.531606 -81.572477 0   366350 GARDENS OF MCGREGOR AND AMASA STONE 14900 PRIVATE DR EAST CLEVELAND OH 44112 2168518200 170 Cuyahoga Non profit - Corporation 148 137.2 Medicare and Medicaid false THE MCGREGOR FOUNDATION 06/08/2007 true   false false false Resident Yes 3   3   4   4   4   3   3       2.25051 0.97687 0.71308 1.68995 3.94046 0.07733 2.08326 0.76868 0.37547 3.22741 2.24519 0.9556 0.7148 3.91512 12/12/2019 2 1 1 8 0 0 8 11/01/2018 11 8 3 68 1 0 68 2017-09-21 8 5 3 1 80 0 80 40 0 8 3 28245.00 0 3 14900 PRIVATE DR EAST CLEVELAND, OH 44112 (41.531606, -81.572477) 02/01/2020
15054 15054 5819 PECAN VALLEY DR SAN ANTONIO, TX 78223 29.368259 -98.43707 0   inf HIGHLAND NURSING CENTER 5819 PECAN VALLEY DR SAN ANTONIO TX 78223 2105321911 130 Bexar For profit - Corporation 59 45.8 Medicaid false Legal Business Name Not Available 09/30/1979 false   false false false Both Yes 2   3   1   1     2 2   2       2.33658 0.79628 0.37978 1.17606 3.51265 0.00854 1.96945 0.64162 0.30274 2.91381 2.46577 0.93319 0.47217 3.86568 09/20/2019 11 10 1 72 1 0 72 09/13/2018 7 7 1 40 1 0 40 2017-09-21 6 6 0 1 48 0 48 57.333 4 0 0 0.00 0 0 5819 PECAN VALLEY DR SAN ANTONIO, TX 78223 (29.368259, -98.43707) 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
);