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

46 rows where geocode_flag = 1 and ownership = "Government - County"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: geocode_accuracy, prvdr_state, prvdr_type, With a Resident and Family Council, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Staffing Rating, RN Staffing Rating, Reported Staffing Footnote, 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 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, 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, 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
21 21 3405 N Campbell St, Valparaiso, IN 46383, USA 41.499378 -87.0668752 1 ROOFTOP 155331 LIFE CARE CENTER OF VALPARAISO 3405 N CAMPBELL RD VALPARAISO IN 46385 2194621023 630 Porter Government - County 110 98.2 Medicare and Medicaid false HENDRICKS COUNTY HOSPITAL 03/27/1989 false   false false false None Yes 4   3   5   4   5   2   2       1.8583 1.08454 0.41678 1.50132 3.35962 0.13436 2.1578 0.82395 0.39962 3.38137 1.78987 0.98976 0.39254 3.18603 03/14/2019 4 4 0 28 1 0 28 02/16/2018 9 9 0 44 1 0 44 2017-01-23 4 4 0 1 20 0 20 32 0 0 0 0.00 0 0   02/01/2020
298 298 281 S Co Rd 200 E, Connersville, IN 47331, USA 39.6394526 -85.1018153 1 ROOFTOP 155332 HERITAGE HOUSE REHABILITATION & HEALTH CARE CENTER 281 S COUNTY ROAD 200 EAST CONNERSVILLE IN 47331 7658252148 200 Fayette Government - County 98 90.8 Medicare and Medicaid false THE HEALTH AND HOSPITAL CORPORATION OF MARION COUNTY 04/26/1989 false   false false false Resident Yes 4   4   5   5   5   1   1       2.28675 0.78225 0.35062 1.13287 3.41962 0.05106 2.26664 0.84519 0.46013 3.57195 2.09678 0.69595 0.2868 3.06991 07/19/2019 5 5 0 20 1 0 20 07/23/2018 9 9 0 36 1 0 36 2017-06-05 3 3 0 1 16 0 16 24.667 0 0 0 0.00 0 0   02/01/2020
1007 1007 6051 US 49, Hattiesburg, MS 39401, USA 31.3185784 -89.32952639999999 1 ROOFTOP 255335 FORREST GENERAL HOSPITAL SKILLED NURSING UNIT 6051 US HIGHWAY 49 SOUTH HATTIESBURG MS 39401 6012887000 170 Forrest Government - County 20 17.8 Medicare true FORREST COUNTY GENERAL HOSPITAL 05/10/2012 false   false false false None Yes 5   5   5     2 5   5   5       3.88102 1.26569 4.67885 5.94455 9.82556 0.42185 2.30367 0.89895 0.53855 3.74117 3.5014 1.0587 3.26996 8.42176 06/13/2019 2 2 0 8 1 0 8 07/19/2018 0 0 0 0 0 0 0 2017-06-28 0 0 0 0 0 0 0 4 0 0 0 0.00 0 0   02/01/2020
1384 1384 6050 S 800 E-92, Fort Wayne, IN 46814, USA 41.0770319 -85.33785879999999 1 ROOFTOP 155322 MAJESTIC CARE OF WEST ALLEN 6050 S CR 800 E 92 FORT WAYNE IN 46814 2606253545 10 Allen Government - County 96 50.4 Medicare and Medicaid false PULASKI MEMORIAL HOSPITAL 08/15/1988 false   false false false Resident Yes 4   4   4   3   5   2   2       1.83037 0.84113 0.48292 1.32404 3.15441 0.0181 2.3301 0.80552 0.42308 3.5587 1.6326 0.78518 0.42962 2.84237 09/05/2019 6 5 1 28 1 0 28 07/27/2018 6 6 0 32 1 0 32 2017-08-24 5 3 2 1 20 0 20 28 0 4 0 0.00 0 0   02/01/2020
1950 1950 205 Prospect St, Pilot Grove, MO 65276, USA 38.8701909 -92.9177319 1 ROOFTOP 265801 KATY MANOR 205 PROSPECT, PO BOX 8 PILOT GROVE MO 65276 6608343111 260 Cooper Government - County 60 52.3 Medicare and Medicaid false COOPER COUNTY NURSING HOME DISTRICT NO 1 03/15/2006 false   false false false Resident Yes 4   4   3   2   4   2   2       2.34366 0.72119 0.2841 1.00529 3.34895 0.05264 1.96873 0.65179 0.29339 2.91391 2.47414 0.832 0.36447 3.68541 02/20/2019 5 5 0 40 1 0 40 01/25/2018 3 3 0 12 1 0 12 2017-02-10 5 5 0 1 40 0 40 30.667 0 0 1 8041.00 1 2   02/01/2020
2101 2101 710 Sunrise Drive, Ferdinand, IN 47532, USA 38.2216355 -86.8516228 1 ROOFTOP 155493 SCENIC HILLS AT THE MONASTERY 710 SUNRISE DRIVE FERDINAND IN 47532 8125042048 180 Dubois Government - County 88 76.7 Medicare and Medicaid false GOOD SAMARITAN HOSPITAL 07/21/1993 false   false false false Resident Yes 5   4   5   5   5   3   4       1.61559 0.58092 0.71493 1.29585 2.91144 0.05867 2.33188 0.73653 0.33511 3.40352 1.43993 0.59307 0.80299 2.74304 08/28/2019 2 1 1 12 1 0 12 08/16/2018 5 5 0 24 1 0 24 2017-09-15 2 2 0 1 16 0 16 16.667 0 2 0 0.00 0 0   02/01/2020
2248 2248 139 US-64, McCrory, AR 72101, USA 35.2679735 -91.2039791 1 ROOFTOP 45222 WOODRUFF COUNTY HEALTH CENTER 139 WEST HIGHWAY 64 MCCRORY AR 72101 8707312543 730 Woodruff Government - County 120 95.1 Medicare and Medicaid false WOODRUFF COUNTY HEALTH CENTER 11/19/1993 false   false false false Resident Yes 4   4   3   2   5   2   2       2.38271 0.82153 0.38526 1.20679 3.58949 0.01082 1.95684 0.6588 0.30918 2.92482 2.53065 0.93768 0.46899 3.93538 03/15/2019 4 2 2 24 1 0 24 05/25/2018 2 2 0 20 1 0 20 2017-03-31 5 5 0 1 32 0 32 24 0 3 0 0.00 0 0   02/01/2020
2778 2778 1760 County Rd J, Wahoo, NE 68066, USA 41.19339189999999 -96.6356701 1 ROOFTOP 285296 SAUNDERS MEDICAL CENTER 1760 COUNTY RD J WAHOO NE 68066 4024434685 770 Saunders Government - County 60 55.8 Medicare and Medicaid true SAUNDERS MEDICAL CENTER 09/08/2016 false   false false false Resident Yes 4   4   2   2     2 4   4       2.78396 0.50199 0.78095 1.28294 4.0669 0.00944 2.04874 0.65444 0.29998 3.00317 2.82418 0.57678 0.97984 4.34247 04/10/2018 4 4 1 28 1 0 28 02/14/2017 1 1 1 8 1 0 8 2015-11-30 4 4 0 1 20 0 20 20 2 0 0 0.00 1 1   02/01/2020
2894 2894 162 AR-32 #2A, Ashdown, AR 71822, USA 33.6599358 -94.1122829 1 ROOFTOP 45244 LITTLE RIVER NURSING & REHAB 162 HWY 32-2A ASHDOWN AR 71822 8708985101 400 Little River Government - County 85 78.2 Medicare and Medicaid false LITTLE RIVER NURSING HOME 09/01/1994 false   false false false Resident Yes 3   4   1   1   3   4   4       2.79088 0.75913 0.59381 1.35295 4.14382 0.024 1.85776 0.65609 0.30448 2.81832 3.12226 0.87004 0.73405 4.7148 03/15/2019 7 7 0 48 1 0 48 04/06/2018 5 5 0 24 1 0 24 2017-02-23 3 2 1 1 12 0 12 34 0 1 0 0.00 0 0   02/01/2020
3239 3239 1523 US-2, Crystal Falls, MI 49920, USA 46.093956 -88.378106 1 ROOFTOP 235257 IRON CO MEDICAL CARE FACILITY 1523 U S HIGHWAY 2 CRYSTAL FALLS MI 49920 9068756671 350 Iron Government - County 200 173.6 Medicare and Medicaid false IRON COUNTY MEDICAL CARE FACILITY 05/01/1976 false   true false false Both Yes 3   2   3   3   3   5   5       2.87235 0.27144 0.95421 1.22565 4.098 0.03409 2.04802 0.6291 0.28781 2.96493 2.91487 0.32444 1.24787 4.43211 11/29/2018 17 10 7 108 1 0 108 08/11/2017 26 19 7 152 2 76 228 2016-10-06 14 8 6 1 64 0 64 140.667 27 2 0 0.00 0 0   02/01/2020
3389 3389 1306 US Hwy 63, Queen City, MO 63561, USA 40.42196690000001 -92.56819329999999 1 ROOFTOP 265816 SCHUYLER COUNTY NURSING HOME 1306 US HIGHWAY 63 QUEEN CITY MO 63561 6607662291 980 Schuyler Government - County 60 34.8 Medicare and Medicaid false SCHUYLER COUNTY NURSING HOME DISTRICT 07/16/2007 false   false false false Resident Yes 2   2   2   1   4   3   3       2.35825 1.09413 0.46603 1.56016 3.91842 0.01992 1.98817 0.61802 0.29547 2.90166 2.4652 1.33123 0.59366 4.3303 04/12/2019 10 10 0 80 1 0 80 05/03/2018 5 5 0 20 1 0 20 2017-05-18 16 14 2 1 108 0 108 64.667 0 1 1 12500.00 1 2   02/01/2020
3456 3456 Akron, CO 80720, USA 40.1605373 -103.2143843 1 APPROXIMATE 65309 WASHINGTON COUNTY NURSING HOME 676 W GREENHOUSE DR AKRON CO 80720 9703452211 600 Washington Government - County 40 39.7 Medicare and Medicaid false WASHINGTON COUNTY NURSING HOME 04/01/1993 false   false false false Resident Yes 3   2   3   3     2 4   4       3.70808 0.89949 0.65139 1.55088 5.25895 0.00014 1.91737 0.64025 0.27405 2.83167 4.01938 1.05641 0.89462 5.95539 11/21/2019 12 12 3 120 1 0 120 11/29/2018 1 1 0 4 1 0 4 2017-06-29 1 1 0 1 4 0 4 62 0 2 0 0.00 0 0   02/01/2020
3639 3639 W 1st St & A St, Hawthorne, NV 89415, USA 38.51818189999999 -118.6283412 1 GEOMETRIC_CENTER 295001 LEFA SERAN SNF 1ST AND A ST/ PO BOX 1510 HAWTHORNE NV 89415 7759452461 100 Mineral Government - County 24 22.7 Medicare and Medicaid true MT GRANT GENERAL HOSPITAL 01/01/1967 false   false false false Resident Yes 3   2   3   3     2 5   5       2.97022 0.59406 0.91778 1.51185 4.48206 0.01304 1.89967 0.66216 0.27783 2.83966 3.24957 0.67462 1.24335 5.06133 10/16/2019 16 16 0 76 1 0 76 01/10/2019 12 11 1 60 1 0 60 2017-10-12 14 14 0 1 96 0 96 74 0 1 0 0.00 0 0   02/01/2020
3950 3950 Winchester, IL 62694, USA 39.62976889999999 -90.45623549999999 1 APPROXIMATE 146106 SCOTT COUNTY NURSING CENTER RURAL ROUTE 2 WINCHESTER IL 62694 2177423101 940 Scott Government - County 49 43.8 Medicare and Medicaid false SCOTT COUNTY NURSING CENTER 10/16/2006 false   false false false Both Yes 5   5   2   3   1   3   3       2.08607 0.97667 0.40467 1.38134 3.46741 0.05799 1.95998 0.64845 0.27168 2.88011 2.21204 1.13254 0.56062 3.86055 12/20/2018 0 0 0 0 0 0 0 02/01/2018 3 3 0 12 1 0 12 2016-12-08 5 5 0 1 16 0 16 6.667 0 0 0 0.00 0 0   02/01/2020
4278 4278 12498 MO-116, Braymer, MO 64624, USA 39.5861783 -93.8054511 1 ROOFTOP 265718 GOLDEN AGE NURSING HOME 12498 SE HIGHWAY 116 BRAYMER MO 64624 6606452243 120 Caldwell Government - County 83 32.3 Medicare and Medicaid false GOLDEN AGE NURSING HOME DISTRICT 05/23/2001 false   false false false Resident Yes 4   3   3   2   4   4   4       2.15374 0.5644 0.6504 1.2148 3.36854 0.02192 2.01382 0.59767 0.27838 2.88987 2.22274 0.71008 0.87939 3.73781 11/15/2018 6 6 0 60 1 0 60 10/06/2017 1 1 0 4 1 0 4 2016-10-26 5 5 0 1 36 0 36 37.333 0 0 0 0.00 0 0   02/01/2020
4564 4564 445 S County Rd 525 E, Avon, IN 46123, USA 39.7557839 -86.4324512 1 ROOFTOP 155338 MAJESTIC CARE OF AVON 445 S COUNTY ROAD 525 E AVON IN 46123 3177452522 310 Hendricks Government - County 140 59.7 Medicare and Medicaid false HENDRICKS COUNTY HOSPITAL 08/07/1989 false   true false false Resident Yes 1   1   4   2   5   1 12 1 12     2.34759 0.93073 0.46855 1.39928 3.74687 0.08921 2.104 0.85479 0.46983 3.42862 2.31895 0.81875 0.37536 3.50431 07/25/2019 22 17 12 321 1 0 321 08/20/2018 10 10 0 40 1 0 40 2017-09-15 7 7 0 1 32 0 32 179.167 0 11 0 0.00 0 0   02/01/2020
4647 4647 3623 IN-16, Brook, IN 47922, USA 40.8647489 -87.3231998 1 ROOFTOP 155719 GEORGE ADE MEMORIAL HEALTH CARE CENTER 3623 IN-16 BROOK IN 47922 2192752531 550 Newton Government - County 70 46.3 Medicare and Medicaid false BOARD OF COMMISSIONERS OF NEWTON COUNTY 02/04/2003 false   false false false Resident Yes 2   2   2   4   1   2   2       2.32411 0.866 0.43378 1.29979 3.62389 0.11386 2.17162 0.74493 0.34016 3.25671 2.22427 0.87415 0.47998 3.5682 06/21/2019 7 6 1 36 1 0 36 04/16/2018 10 10 0 44 1 0 44 2017-02-17 14 14 3 1 88 0 88 47.333 0 3 1 2406.00 0 1   02/01/2020
6020 6020 16561 US-10, Lake Park, MN 56554, USA 46.876029 -96.058263 1 ROOFTOP 245597 SUNNYSIDE CARE CENTER 16561 US HIGHWAY 10 LAKE PARK MN 56554 2182385944 20 Becker Government - County 30 26.8 Medicare and Medicaid false SUNNYSIDE NURSING HOME 02/01/1992 false   false false false Resident Yes 5   5   5   5     2 5   5       3.17814 0.87429 0.996 1.87029 5.04843 0.1002 2.03001 0.64878 0.30797 2.98676 3.2538 1.01331 1.21726 5.42012 07/24/2019 3 3 0 12 1 0 12 09/13/2018 2 2 0 20 1 0 20 2017-07-13 3 3 0 1 8 0 8 14 0 0 0 0.00 0 0   02/01/2020
6457 6457 140 W Mechanic Rd, Hillsdale, MI 49242, USA 41.9337272 -84.6457053 1 ROOFTOP 235197 HILLSDALE CO MEDICAL CARE FACI 140 W MECHANIC ST HILLSDALE MI 49242 5174399341 290 Hillsdale Government - County 170 166.3 Medicare and Medicaid false COUNTY OF HILLSDALE 04/06/1970 false   false false false Resident Yes 5   4   5   5   5   4   4       3.17873 0.8483 0.67011 1.51842 4.69714 0.02775 2.00508 0.63675 0.28418 2.926 3.29486 1.00177 0.88755 5.14768 04/18/2019 6 6 0 24 1 0 24 05/24/2018 9 9 0 68 1 0 68 2017-03-23 13 13 0 1 96 0 96 50.667 0 0 1 8250.00 0 1   02/01/2020
7297 7297 251 N 4th St, Oakland, MD 21550, USA 39.413393 -79.4010325 1 ROOFTOP 215310 GARRETT COUNTY SUBACUTE UNIT 251 NORTH FOURTH STREET OAKLAND MD 21550 3015334220 110 Garrett Government - County 10 7.8 Medicare and Medicaid true GARRETT COUNTY MEMORIAL HOSPITAL 08/06/1997 false   false false false Resident Yes 5   4   5     2 5   5   5       3.4391 0 3.96814 3.96814 7.40724 0.21029 2.09724 1.02242 0.59444 3.7141 3.4081 0 2.51252 6.39523 12/13/2018 5 5 0 24 1 0 24 09/05/2017 1 1 0 4 1 0 4 2016-09-26 5 5 0 1 24 0 24 17.333 0 0 0 0.00 0 0   02/01/2020
7344 7344 923 Hale Lake Pointe, Grand Rapids, MN 55744, USA 47.2483419 -93.5630388 1 ROOFTOP 245368 GRAND VILLAGE 923 HALE LAKE POINTE GRAND RAPIDS MN 55744 2183260543 300 Itasca Government - County 119 103 Medicare and Medicaid false ITASCA NURSING HOME 11/01/1986 false   false false false Both Yes 5   3   5   5   5   4   4       2.68627 1.45416 0.871 2.32516 5.01143 0.09403 2.10901 0.70468 0.32978 3.14347 2.6472 1.55169 0.99409 5.11217 04/19/2019 9 7 2 40 1 0 40 02/15/2018 7 2 5 32 1 0 32 2016-12-22 4 4 0 1 16 0 16 33.333 6 1 0 0.00 0 0   02/01/2020
7597 7597 621 Grand Valley Blvd, Martinsville, IN 46151, USA 39.4165163 -86.40596269999999 1 RANGE_INTERPOLATED 155605 GRAND VALLEY HEALTH & REHAB 621 GRAND VALLEY BOULEVARD MARTINSVILLE IN 46151 7653427114 540 Morgan Government - County 100 72.1 Medicare and Medicaid false WITHAM MEMORIAL HOSPITAL 12/01/1996 false   false false false Resident Yes 3   3   4   3   4   2   2       1.44922 0.71043 0.44624 1.15667 2.60589 0.04916 2.05219 0.83188 0.39922 3.28329 1.46768 0.64216 0.42072 2.54507 06/10/2019 9 6 5 36 1 0 36 03/09/2018 7 7 0 36 1 0 36 2017-02-15 4 2 2 1 24 0 24 34 0 3 0 0.00 0 0   02/01/2020
8557 8557 500 Camp Rd, Pocahontas, AR 72455, USA 36.2906574 -90.997922 1 ROOFTOP 45443 RANDOLPH COUNTY NURSING HOME 500 CAMP ROAD POCAHONTAS AR 72455 8708925214 600 Randolph Government - County 140 134.1 Medicare and Medicaid false RANDOLPH COUNTY NURSING HOME 07/14/2011 false   false false false Resident Yes 4   4   4   4   4   3   2       3.28894 0.67883 0.35195 1.03079 4.31973 0.05005 2.10837 0.66753 0.30945 3.08535 3.24209 0.76468 0.42808 4.48958 12/13/2019 7 7 0 52 1 0 52 10/26/2018 1 1 0 16 1 0 16 2017-08-31 1 1 0 1 8 0 8 32.667 0 0 0 0.00 0 0   02/01/2020
8870 8870 14345 Co Hwy B, Sparta, WI 54656, USA 43.966054 -90.813682 1 ROOFTOP 525430 ROLLING HILLS REHAB CTR 14345 CTY HWY B SPARTA WI 54656 6082698800 400 Monroe Government - County 80 71 Medicare and Medicaid false COUNTY OF MONROE 08/01/1989 false   false false false Resident Yes 3   2   4   5   3   4   4       2.80487 0.72287 0.77597 1.49884 4.30371 0.03177 2.01031 0.73449 0.32001 3.0648 2.89979 0.74005 0.91266 4.50291 06/19/2019 7 5 2 64 1 0 64 04/05/2018 8 8 2 60 1 0 60 2017-02-06 5 4 1 1 32 0 32 57.333 0 2 0 0.00 0 0   02/01/2020
9060 9060 W4266 County Hwy X, Owen, WI 54460, USA 44.9451287 -90.5242188 1 ROOFTOP 525403 CLARK COUNTY REHABILITATION & LIVING CENTER W4266 COUNTY HIGHWAY X OWEN WI 54460 7152292172 90 Clark Government - County 172 141.3 Medicare and Medicaid false CLARK COUNTY 01/01/1987 false   false false false Resident Yes 5   4   3   2   4   5   5       3.66568 0.28018 1.01568 1.29586 4.96154 0.03165 2.04974 0.66921 0.27889 2.99784 3.71683 0.31482 1.37072 5.30716 05/23/2019 4 4 0 20 1 0 20 03/15/2018 3 3 0 12 1 0 12 2017-03-01 2 2 1 1 8 0 8 15.333 1 1 0 0.00 0 0   02/01/2020
9311 9311 8180 W State Rte 163, Oak Harbor, OH 43449, USA 41.5070846 -83.0906341 1 ROOFTOP 365498 OTTAWA CO RIVERVIEW NURSING HO 8180 W STATE RT 163 OAK HARBOR OH 43449 4198982851 630 Ottawa Government - County 174 87.3 Medicare and Medicaid false COUNTY OF OTTAWA 06/27/1980 false   false false false Resident Yes 5   4   5   5   5   3   3       2.41765 0.85716 0.62039 1.47755 3.8952 0.03921 2.04449 0.81206 0.42669 3.28324 2.45768 0.7937 0.54725 3.80435 11/29/2018 0 0 0 0 0 0 0 09/14/2017 4 4 0 20 1 0 20 2016-11-03 5 5 0 1 36 0 36 12.667 0 0 0 0.00 0 0   02/01/2020
9349 9349 198 County Rd D F, Juneau, WI 53039, USA 43.414556 -88.6987043 1 ROOFTOP 525453 CLEARVIEW 198 COUNTY DF JUNEAU WI 53039 9203863400 130 Dodge Government - County 120 101.9 Medicare and Medicaid false MARSH COUNTRY HEALTH ALLIANCE 12/01/1989 false   false false false Resident Yes 2   3   4   2   5   1 12 1 12 6 6                             02/26/2019 1 1 0 20 1 0 20 11/09/2017 1 1 0 20 1 0 20 2016-10-20 3 1 2 1 20 0 20 20 0 1 2 14839.00 0 2   02/01/2020
9673 9673 Howison Cir, Menomonie, WI 54751, USA 44.888394 -91.891125 1 GEOMETRIC_CENTER 525713 NEIGHBORS - EAST NEIGHBORHOOD (THE) 658 HOWISON CIRCLE MENOMONIE WI 54751 7152322661 160 Dunn Government - County 46 44.7 Medicare and Medicaid false COUNTY OF DUNN 10/01/2013 false   false false false Resident Yes 5   3   5   5     2 5   5       2.95315 0.34189 0.8322 1.17409 4.12724 0.0033 1.97615 0.62033 0.26354 2.86003 3.10586 0.41443 1.18852 4.62746 06/12/2019 5 5 0 24 1 0 24 04/19/2018 0 0 0 0 0 0 0 2017-06-07 8 5 3 1 52 0 52 20.667 0 1 1 23230.00 0 1   02/01/2020
9876 9876 9822 NY-16, Machias, NY 14101, USA 42.425069 -78.48740699999999 1 ROOFTOP 335578 THE PINES HEALTHCARE & REHAB CTRS MACHIAS CAMPUS 9822 ROUTE 16 MACHIAS NY 14101 7163538516 40 Cattaraugus Government - County 115 113.1 Medicare and Medicaid false COUNTY OF CATTARAUGUS 09/01/1977 false   false false false Both Yes 5   4   5   4   5   3   3       2.51316 1.06514 0.5245 1.58963 4.10279 0.06464 2.0909 0.69674 0.33688 3.12453 2.49806 1.14952 0.586 4.21064 12/11/2018 2 2 0 16 1 0 16 07/18/2017 3 3 0 8 1 0 8 2016-05-04 4 4 0 1 16 0 16 13.333 0 0 0 0.00 0 0   02/01/2020
10050 10050 3400 N County Rd F, Janesville, WI 53545, USA 42.7228203 -89.0285024 1 ROOFTOP 525390 ROCK HAVEN 3400 N CTY TRK HWY F PO BOX 920 JANESVILLE WI 53547 6087575076 520 Rock Government - County 128 120.1 Medicare and Medicaid false COUNTY OF ROCK COUNTY CLERK 07/01/1985 false   false false false Resident Yes 1   1   3   2   4   1 12 1 12 6 6                             04/04/2019 7 7 0 60 1 0 60 02/22/2018 9 6 4 177 1 0 177 2016-12-08 6 4 2 1 24 0 24 93 2 2 2 41653.00 0 2   02/01/2020
10135 10135 W20410 WI-121, Whitehall, WI 54773, USA 44.3728632 -91.3543136 1 ROOFTOP 52A407 TREMPEALEAU CTY HCC IMD W20410 STATE RD 121 WHITEHALL WI 54773 7155384312 600 Trempealeau Government - County 34 32.5 Medicaid false Legal Business Name Not Available 11/30/1988 false   false false false Resident Yes 4   5   4   4     2 1 12 1 12 6 6                             07/16/2019 0 0 0 0 0 0 0 06/13/2018 0 0 0 0 0 0 0 2017-05-18 2 2 0 1 20 0 20 3.333 0 0 0 0.00 0 0   02/01/2020
10184 10184 725 Butler Ave, Oshkosh, WI 54901, USA 44.0761289 -88.52971610000002 1 ROOFTOP 525638 PARK VIEW HEALTH CENTER 725 BUTLER AVE OSHKOSH WI 54901 9202376300 690 Winnebago Government - County 168 159.3 Medicare and Medicaid false COUNTY OF WINNEBAGO 11/01/1997 false   false false false Both Yes 5   5   5   5   5   5   5       3.04148 0.27021 1.18006 1.45028 4.49176 0.03462 2.06215 0.73187 0.30365 3.09767 3.06536 0.27762 1.46274 4.6498 05/14/2019 0 0 0 0 0 0 0 04/11/2018 0 0 0 0 0 0 0 2017-02-09 4 4 0 1 16 0 16 2.667 0 0 0 0.00 0 0   02/01/2020
10493 10493 2739 Co Rd 91, Bellefontaine, OH 43311, USA 40.39712240000001 -83.8014687 1 ROOFTOP 365768 LOGAN ACRES 2739 COUNTY ROAD 91 BELLEFONTAINE OH 43311 9375922901 470 Logan Government - County 95 90.1 Medicare and Medicaid false COUNTY OF LOGAN OFFICE OF AUDITOR 08/03/1989 false   false false false Resident Yes 5   4   5   4   5   3   3       1.79933 1.00306 0.59336 1.59642 3.39575 0.02781 2.11315 0.76169 0.37111 3.24595 1.76968 0.99022 0.60179 3.35464 10/17/2019 0 0 0 0 0 0 0 08/29/2018 9 9 0 72 1 0 72 2017-06-15 0 0 0 0 0 0 0 24 0 0 0 0.00 0 0   02/01/2020
10800 10800 20881 PA-198, Saegertown, PA 16433, USA 41.7041223 -80.1251496 1 ROOFTOP 395853 CRAWFORD COUNTY CARE CENTER 20881 STATE HIGHWAY 198 SAEGERTOWN PA 16433 8147632445 260 Crawford Government - County 157 126.6 Medicare and Medicaid false CRAWFORD COUNTY COMMISSIONERS 06/01/1991 false   false false false Resident Yes 4   3   5   5   5   3   3       2.44711 0.58758 0.59372 1.18131 3.62841 0.05169 2.01899 0.81023 0.42273 3.25195 2.51903 0.54531 0.52864 3.57788 12/14/2018 7 7 0 28 1 0 28 01/11/2018 3 3 0 20 1 0 20 2017-06-23 14 12 2 1 68 0 68 32 0 1 0 0.00 0 0   02/01/2020
11040 11040 103 Ave H, Ozona, TX 76943, USA 30.7215563 -101.2056703 1 RANGE_INTERPOLATED inf CROCKETT COUNTY CARE CENTER 103 N AVE H OZONA TX 76943 3253923096 361 Crockett Government - County 54 31.1 Medicaid false Legal Business Name Not Available 04/02/1985 false   false false false Resident Yes 3   2   4   4     2 4   4       4.45096 1.34776 0.71739 2.06514 6.5161 0 2.19079 0.65982 0.28742 3.13802 4.22249 1.53593 0.93945 6.65863 04/17/2019 3 3 0 20 1 0 20 05/16/2018 2 0 2 250 0 0 250 2017-04-05 2 2 0 1 24 0 24 97.333 0 1 0 0.00 0 0   02/01/2020
11920 11920 15900 US-6, Troy, PA 16947, USA 41.7760508 -76.62281399999999 1 ROOFTOP 395586 BRADFORD COUNTY MANOR 15900 ROUTE 6 TROY PA 16947 5702974111 130 Bradford Government - County 200 138.9 Medicare and Medicaid false BRADFORD COUNTY COMMISSIONERS 09/01/1983 false   false false false Resident Yes 1   2   1   1   3   2   2       2.35354 1.01575 0.44396 1.45971 3.81324 0.03927 2.29662 0.78717 0.4173 3.50109 2.12984 0.97029 0.40043 3.49256 05/10/2019 15 11 4 72 1 0 72 06/15/2018 12 12 0 48 1 0 48 2017-05-05 7 4 3 1 40 0 40 58.667 0 10 0 0.00 0 0   02/01/2020
12143 12143 8800 US-61, Lancaster, WI 53813, USA 42.82266509999999 -90.68583 1 ROOFTOP 525290 ORCHARD MANOR 8800 HWY 61 LANCASTER WI 53813 6087232113 210 Grant Government - County 125 79.1 Medicare and Medicaid false COUNTY OF GRANT 07/01/1978 false   false false false Resident Yes 2   1   4   3   4   4   4       3.63909 0.41786 0.69627 1.11413 4.75322 0.02092 2.12809 0.67067 0.28228 3.08104 3.55401 0.4685 0.92837 4.94702 11/08/2018 3 2 1 83 1 0 83 08/10/2017 4 4 1 162 1 0 162 2016-07-25 10 9 1 1 127 0 127 116.667 0 3 2 32691.00 0 2   02/01/2020
12312 12312 7830 OH-199, Upper Sandusky, OH 43351, USA 40.8780526 -83.321436 1 ROOFTOP 366269 WYANDOT COUNTY SKILLED NURSING AND REHABILITATION 7830 N ST HWY 199 RR2 UPPER SANDUSKY OH 43351 4192941714 890 Wyandot Government - County 90 59 Medicare and Medicaid false WYANDOT COUNTY OFFICE OF AUDITOR 04/29/2003 false   false false false Resident Yes 3   3   4   4   4   3   3       2.23918 0.59711 0.6811 1.27821 3.5174 0.02775 2.12563 0.78483 0.41338 3.32384 2.18937 0.57209 0.62014 3.39339 06/06/2019 6 6 0 36 1 0 36 05/23/2018 7 5 2 36 1 0 36 2017-03-30 9 9 0 1 84 0 84 44 0 1 1 16562.00 0 1   02/01/2020
13672 13672 2590 TX-337 Loop, New Braunfels, TX 78130, USA 29.71460489999999 -98.15540779999999 1 ROOFTOP 455732 KIRKWOOD MANOR 2590 LOOP 337 N NEW BRAUNFELS TX 78130 8306200509 320 Comal Government - County 162 145.5 Medicare and Medicaid false UVALDE COUNTY HOSPITAL AUTHORITY 02/05/1988 false   false false false Resident Yes 3   3   5   5   5   1   1       2.138 0.94611 0.31012 1.25624 3.39424 0.03891 2.12921 0.83191 0.43861 3.39974 2.08691 0.85517 0.26612 3.20148 03/01/2019 9 6 4 52 1 0 52 03/02/2018 6 6 0 48 1 0 48 2017-02-24 7 6 1 1 52 0 52 50.667 1 3 0 0.00 0 0   02/01/2020
13954 13954 Corinthian Ave & W Girard Ave, Philadelphia, PA 19130, USA 39.9728636 -75.1703364 1 GEOMETRIC_CENTER 395478 PHILADELPHIA NURSING HOME GIRARD AND CORINTHIAN AVE PHILADELPHIA PA 19130 2156850800 620 Philadelphia Government - County 402 305.4 Medicare and Medicaid false CITY OF PHILADELPHIA 03/20/1980 false   false false false Resident Yes 3   2   2   2   2   4   4       2.29588 0.73782 0.7212 1.45902 3.7549 0.02925 1.9216 0.69792 0.33433 2.95385 2.48315 0.79493 0.81193 4.07628 10/29/2019 10 10 0 64 1 0 64 09/21/2018 5 5 0 32 1 0 32 2017-10-02 16 12 4 1 160 0 160 69.333 1 3 1 8778.00 0 1   02/01/2020
14305 14305 962 Garland St E, West Salem, WI 54669, USA 43.8990788 -91.06827439999999 1 ROOFTOP 525726 LAKEVIEW HEALTH CENTER 962 E GARLAND ST E WEST SALEM WI 54669 6087861400 310 La Crosse Government - County 50 49.6 Medicare and Medicaid false MISSISSIPPI VALLEY HEALTH SERVICES COMMISSION 01/01/2018 false   false false false Resident Yes 5   4   3   3     2 5   5       4.01968 0.81579 1.055 1.87079 5.89048 0.03183 2.23523 0.66832 0.28771 3.19126 3.73753 0.91786 1.38018 5.91891 11/28/2018 1 1 0 4 1 0 4 08/10/2017 5 5 0 24 1 0 24   . . . . . . . 12 0 0 0 0.00 0 0   02/01/2020
14559 14559 8300 W Ridge Rd, Fairview, PA 16415, USA 42.0220383 -80.27376930000001 1 ROOFTOP 395361 PLEASANT RIDGE MANOR EAST/WEST 8300 WEST RIDGE ROAD GIRARD PA 16417 8144745521 320 Erie Government - County 300 250.1 Medicare and Medicaid false PLEASANT RIDGE MANOR 07/01/1986 false   false false false Both Yes 3   4   1   3   1   3   3       2.37018 0.7249 0.53927 1.26417 3.63435 0.04409 2.14187 0.68735 0.31803 3.14725 2.29987 0.79302 0.63822 3.70295 02/28/2019 3 3 0 4 1 0 4 03/30/2018 5 4 1 36 1 0 36 2017-02-10 7 7 0 1 36 0 36 20 1 1 1 7153.00 0 1   02/01/2020
14641 14641 47045 Moore Ridge Rd, Woodsfield, OH 43793, USA 39.7771267 -81.11199859999999 1 ROOFTOP 366448 MONROE COUNTY CARE CENTER 47045 MOORE RIDGE ROAD WOODSFIELD OH 43793 7404720144 570 Monroe Government - County 49 26.1 Medicare and Medicaid false MONROE COUNTY AUDITOR 02/10/2017 false   false false false Resident Yes 5   4   3   3   3   5   5       2.51015 1.71796 1.62865 3.34661 5.85676 0 2.08682 0.74955 0.3934 3.22977 2.49994 1.72345 1.55821 5.81486 02/21/2019 7 6 1 32 1 0 32 01/05/2018 2 2 0 8 1 0 8 2016-11-22 2 0 2 0 4 0 4 19.333 0 1 0 0.00 0 0   02/01/2020
14707 14707 Howison Cir, Menomonie, WI 54751, USA 44.888394 -91.891125 1 GEOMETRIC_CENTER 525714 NEIGHBORS - WEST NEIGHBORHOOD (THE) 651 HOWISON CIRCLE MENOMONIE WI 54751 7152322661 160 Dunn Government - County 46 43.4 Medicare and Medicaid false COUNTY OF DUNN 09/27/2013 false   false false false Resident Yes 5   5   4   4     2 4   4       2.95427 0.53382 0.55199 1.08581 4.04008 0.00618 2.05479 0.66449 0.25493 2.97421 2.98812 0.60407 0.81498 4.35584 09/05/2019 0 0 0 0 0 0 0 10/31/2018 1 1 0 8 1 0 8 2017-09-13 0 0 0 0 0 0 0 2.667 0 0 0 0.00 0 0   02/01/2020
14824 14824 N3150 WI-81, Monroe, WI 53566, USA 42.6224459 -89.65704149999999 1 ROOFTOP 525643 PLEASANT VIEW NURSING HOME N3150 HWY 81 PO BOX 768 MONROE WI 53566 6083252171 220 Green Government - County 110 97 Medicare and Medicaid false COUNTY OF GREEN 05/01/1998 false   false false false Both Yes 4   3   4   4   4   5   5       3.36261 0.33393 0.96712 1.30105 4.66366 0.07625 2.16031 0.73573 0.32073 3.21676 3.23501 0.34129 1.13495 4.64902 10/10/2019 4 4 0 16 1 0 16 07/26/2018 1 1 0 4 1 0 4 2017-05-02 6 4 4 1 141 0 141 32.833 0 1 1 6318.00 0 1   02/01/2020
15182 15182 198 County Rd D F, Juneau, WI 53039, USA 43.414556 -88.6987043 1 ROOFTOP 52A461 CLEARVIEW BRAIN INJURY CENTER 198 COUNTY DF JUNEAU WI 53039 9203863400 130 Dodge Government - County 30 16.9 Medicaid false Legal Business Name Not Available 01/20/2011 false   false false false Resident Yes 5   5   5   5     2 1 12 1 12 6 6                             02/13/2019 2 2 0 8 1 0 8 11/09/2017 1 1 1 8 1 0 8 2016-10-19 1 0 1 0 4 0 4 7.333 0 3 0 0.00 0 0   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
);