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

1,309 rows where geocode_flag = 1 sorted by Reported Total Nurse Staffing Hours per Resident per Day

View and edit SQL

Suggested facets: geocode_accuracy, ownership, prvdr_type, Provider Resides in Hospital, 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, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Number of Health Revisits, Rating Cycle 1 Health Revisit Score, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 2 Number of Health Revisits, Rating Cycle 2 Health Revisit Score, Rating Cycle 3 Number of Complaint Health Deficiencies, Rating Cycle 3 Number of Health Revisits, Number of Facility Reported Incidents, Number of Fines, Number of Payment Denials, Total Number of Penalties, Rating Cycle 3 Standard Health Survey Date (date)

geocode_flag

  • 1 · 1,309
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
3 3115 Bowman Rd, Little Rock, AR 72211, USA 34.7245501 -92.4070758 1 RANGE_INTERPOLATED 45288 ALLAY HEALTH AND REHAB 3115 BOWMAN ROAD LITTLE ROCK AR 72211 5012284848 590 Pulaski For profit - Limited Liability company 70 14.4 Medicare and Medicaid false 06/30/1995 false   false false false None Yes 1   2   1     2 1     2   2 6 6                             09/06/2019 8 8 0 72 1 0 72 09/19/2018 8 8 0 52 1 0 52 2017-07-21 6 4 2 1 298 0 298 103 0 2 2 28096.00 0 2   02/01/2020
5 1569 AR-56, Calico Rock, AR 72519, USA 36.1329878 -92.1308851 1 ROOFTOP 45401 WHITE RIVER HEALTHCARE 1569 AR HIGHWAY 56 CALICO ROCK AR 72519 8702973719 320 Izard For profit - Corporation 70 61.8 Medicare and Medicaid false 07/20/2004 false   false false false Resident Yes 2   4   1   2   1   1 12 1 12 6 6                             11/16/2018 6 6 0 32 1 0 32 01/12/2018 10 10 0 84 1 0 84 2016-12-22 0 0 0 0 0 0 0 44 0 0 0 0.00 0 0   02/01/2020
43 US-14, Balaton, MN, USA 44.2371235 -95.871555 1 GEOMETRIC_CENTER 245552 COLONIAL MANOR OF BALATON HIGHWAY 14 EAST PO BOX 219 BALATON MN 56115 5077343511 410 Lyon For profit - Corporation 33 1 Medicare and Medicaid false 04/01/1991 false   false false false Resident Yes 2   2   5   5     2 1 12 1 12 6 6                             11/07/2018 1 1 0 16 2 8 24 10/20/2017 17 17 0 84 1 0 84 2016-11-03 13 13 0 1 76 0 76 52.667 0 0 0 0.00 0 0   02/01/2020
44 3550 MS-468, Pearl, MS 39208, USA 32.2419352 -90.07072869999999 1 ROOFTOP 25A403 JNH-ADAMS INN 3550 HIGHWAY 468 WEST PO BOX 207, BUILDING 31 WHITFIELD MS 39193 6013518015 600 Rankin Government - State 59 45 Medicaid false 06/25/2001 false   false false false Both Yes 1   1   4   4     2 1 12 1 12 6 6                             06/13/2019 8 8 0 40 1 0 40 06/28/2017 5 1 4 84 1 0 84 2016-04-15 4 4 0 1 20 0 20 51.333 1 0 0 0.00 0 0   02/01/2020
51 2555 Norterre Cir, Liberty, MO 64068, USA 39.2772588 -94.4212769 1 ROOFTOP 265867 NORTERRE 2555 NORTERRE CIRCLE LIBERTY MO 64068 8164794793 230 Clay For profit - Corporation 60 34 Medicare false 02/28/2018 true   false false false Resident Yes 2   1   5   5   4   1 12 1 12 6 6                             08/23/2019 9 7 2 44 1 0 44 12/13/2018 22 22 0 224 1 0 224 2018-02-28 0 0 0 0 0 0 0 96.667 0 3 1 33280.00 1 2   02/01/2020
54 Heritage Rd, Crow Agency, MT 59022, USA 45.5810378 -107.4506532 1 GEOMETRIC_CENTER 275153 AWE KUALAWAACHE CARE CENTER 10131 S HERITAGE RD CROW AGENCY MT 59022 4066389111 10 Big Horn Non profit - Other 40 26.5 Medicare and Medicaid false 06/09/1998 false SFF Candidate false false false Resident Yes 2   1   5   5     2 1 12 1 12 6 6                             02/05/2019 7 7 0 56 1 0 56 09/06/2018 12 9 3 414 1 0 414 2017-05-04 22 22 0 2 244 122 366 227 0 2 0 0.00 2 2   02/01/2020
69 921 Jr High School Rd, Scotland Neck, NC 27874, USA 36.1323341 -77.4291154 1 ROOFTOP 345431 BRYAN HEALTH AND REHAB 921 JUNIOR HIGH SCHOOL ROAD SCOTLAND NECK NC 27874 2528264144 410 Halifax Non profit - Corporation 60 50.4 Medicare and Medicaid false 03/11/1993 false   false false false Resident Yes 1   2   2   4   1   1 12 1 12 6 6                             07/17/2019 9 6 4 48 1 0 48 08/22/2018 6 6 0 40 1 0 40 2017-09-15 4 4 0 1 20 0 20 40.667 0 7 1 13905.00 0 1   02/01/2020
70 272 US-70, Sealevel, NC 28577, USA 34.888092 -76.3958435 1 ROOFTOP 345521 SNUG HARBOR ON NELSON BAY 272 HIGHWAY 70 SEALEVEL NC 28577 2522254411 150 Carteret For profit - Corporation 42 35.8 Medicare and Medicaid false 07/01/2002 false   false false false Resident Yes 3   4   2   2   2   1 12 1 12 6 6                             05/24/2019 6 4 2 16 1 0 16 04/13/2018 1 1 0 4 1 0 4 2017-06-01 1 1 0 1 4 0 4 10 1 1 1 9278.00 0 1   02/01/2020
88 Carretera #2 Km, Vega Baja, 00693, Puerto Rico 18.445622 -66.398985 1 GEOMETRIC_CENTER 405025 CENTRO MEDICO WILMA N VAZQUEZ SNF ROAD 2 KM 39 5 BO ALGARROBO VEGA BAJA PR 693 7878581580 730 Vega Baja For profit - Corporation 45 20 Medicare true 08/09/1989 false   false false false None Yes 4   4   5     2 5   1 12 1 12 6 6                             05/15/2019 12 12 0 72 1 0 72 08/20/2018 5 5 0 24 1 0 24 2017-05-25 5 5 0 1 48 0 48 52 0 0 1 8447.00 0 1   02/01/2020
91 60 Okatie Village Dr, Okatie, SC 29909, USA 32.2963223 -80.94367179999999 1 ROOFTOP 425415 SPRENGER HEALTHCARE OF BLUFFTON 60 OKATIE VILLAGE DRIVE BLUFFTON SC 29909 8332546634 260 Jasper For profit - Corporation 60 3.5 Medicare and Medicaid false 07/01/2019 true   false false false Resident Yes   1   1   1   1   1   1   1 6 6                             06/13/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   02/01/2020
106 40131 CA-49, Oakhurst, CA 93644, USA 37.335508 -119.660067 1 ROOFTOP 555115 OAKHURST HEALTHCARE CENTER 40131 HIGHWAY 49 OAKHURST CA 93644 5596832244 300 Madera For profit - Limited Liability company 66 62.8 Medicare and Medicaid false 08/06/1979 false   false false true Resident Yes 1   2   3   2   5   1 12 1 12 6 6                             08/30/2019 12 10 2 88 1 0 88 09/21/2018 15 15 2 88 1 0 88 2017-09-14 2 2 0 1 12 0 12 75.333 2 1 0 0.00 0 0   02/01/2020
204 707 Elm St E, Rockwell, IA 50469, USA 42.9880056 -93.18294759999999 1 ROOFTOP 165406 ROCKWELL COMMUNITY NURSING HOM 707 ELM STREET ROCKWELL IA 50469 6418223203 160 Cerro Gordo For profit - Corporation 46 20.5 Medicare and Medicaid false 01/01/1999 false   false false false Resident Yes 4   4   5   5   5   1 12 1 12 6 6                             07/02/2019 2 2 0 8 1 0 8 04/05/2018 0 0 0 0 0 0 0 2017-01-26 4 4 0 1 28 0 28 8.667 0 0 0 0.00 0 0   02/01/2020
555 1050 4 Mile Rd NW, Grand Rapids, MI 49544, USA 43.0266861 -85.6952764 1 ROOFTOP 235377 VALLEY VIEW CARE CENTER 1050 FOUR MILE NW GRAND RAPIDS MI 49544 6167840646 400 Kent Non profit - Corporation 139 123.8 Medicare and Medicaid false 10/01/1978 false   false false true Resident Yes 1   2   3   2   4   1 12 1 12 6 6                             07/24/2019 17 10 8 120 1 0 120 07/19/2018 6 6 0 48 1 0 48 2017-05-11 20 15 7 1 136 0 136 98.667 16 12 0 0.00 0 0   02/01/2020
824 Eldridge, CA 95431, USA 38.3634225 -122.5279928 1 APPROXIMATE 05A213 SONOMA DEVELOPMENTAL CENTER D/P SNF P.O. BOX 1493 ELDRIDGE CA 95431 7079386000 590 Sonoma Government - State 427   Medicaid true 09/01/1974 false   false false false Both Yes 4   5     2   2   2 1 12 1 12 6 6                             07/26/2018 3 3 0 20 1 0 20 08/31/2017 3 3 0 12 1 0 12 2016-09-16 7 5 2 1 44 0 44 21.333 3 0 0 0.00 0 0   02/01/2020
1769 517 33rd St, Meridian, MS 39305, USA 32.3914922 -88.6847813 1 ROOFTOP 255348 TREND HEALTH & REHAB OF MERIDIAN LLC 517 33RD STREET MERIDIAN MS 39305 6012821300 370 Lauderdale For profit - Individual 58   Medicare and Medicaid false 11/27/2019 false   false false false Resident Yes   1   1   1   1   1   1   1 6 6                             11/27/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   02/01/2020
2105 1027 E Hwy 98, Panama City, FL 32401, USA 30.15668359999999 -85.64594819999999 1 ROOFTOP 105775 GLENCOVE HEALTH AND REHABILITATION CENTER 1027 E HWY 98 PANAMA CITY FL 32401 8508721438 20 Bay For profit - Corporation 115   Medicare and Medicaid false 09/16/1992 false   false true false Resident Yes 5   4   5   5   5     2   2 6 6                             01/10/2018 4 4 0 16 1 0 16 03/10/2017 3 2 1 8 1 0 8 2015-12-04 2 2 0 1 8 0 8 12 0 1 0 0.00 0 0   02/01/2020
2370 6700 US-165, Monroe, LA 71203, USA 32.5898929 -92.066053 1 ROOFTOP 195628 NORTHEAST LA WAR VETERANS HOME 6700 HIGHWAY 165 NORTH MONROE LA 71211 3183624206 360 Ouachita Government - State 10 2.6 Medicare false 12/04/2008 false   false false false Resident Yes 3   4   1     2 1     2   2 6 6                             08/05/2019 0 0 0 0 1 0 0 07/17/2018 4 4 0 24 1 0 24 2017-07-06 2 1 1 1 8 0 8 9.333 0 1 0 0.00 0 0   02/01/2020
2389 14660 W Parkwood Dr, Surprise, AZ 85374, USA 33.6492867 -112.3760141 1 ROOFTOP 35297 SURPRISE HEALTH AND REHABILITATION CENTER 14660 W PARKWOOD DRIVE SURPRISE AZ 85374 6235465030 60 Maricopa For profit - Corporation 100   Medicare false 10/04/2019 false   false false false None Yes   1   1   1   1   1   1   1 6 6                             09/25/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   02/01/2020
2469 40 Smith St, Frankfort, IL 60423, USA 41.5007122 -87.8536518 1 ROOFTOP 1.4e+213 FRANKFORT TERRACE 40 NORTH SMITH FRANKFORT IL 60423 8154693156 989 Will For profit - Corporation 120 96.9 Medicaid false 04/14/1975 false   false false false Resident Yes 4   4   5   5     2 1 12 1 12 6 6                             06/05/2019 4 4 0 0 0 0 0 05/11/2018 7 6 1 60 1 0 60 2017-07-27 7 6 1 1 36 0 36 26 1 1 0 0.00 0 0   02/01/2020
2627 N 11th St & Broadway St, Quincy, IL 62301, USA 39.9356331 -91.3983503 1 GEOMETRIC_CENTER 145643 BLESSING HOSPITAL SNU BROADWAY AT 11TH STREET QUINCY IL 62301 2172238400 0 Adams Non profit - Corporation 20 15.1 Medicare false 06/20/1989 false   false false false None Yes 4   5   4     2 4   1 12 1 12 6 6                             02/28/2019 0 0 0 0 0 0 0 04/19/2018 3 3 0 32 1 0 32 2017-05-24 3 3 0 1 16 0 16 13.333 0 0 0 0.00 0 0   02/01/2020
2752 Indian Hills Dr, Macy, NE 68039, USA 42.1187092 -96.35944669999999 1 GEOMETRIC_CENTER 28A065 CARL T CURTIS HEALTH EDUCATION CENTER NURSING HOME P O BOX 250 MACY NE 68039 4028375381 860 Thurston Non profit - Other 25 20.8 Medicaid false 10/02/1990 false   false false false Resident Yes 2   3   2   2     2 1 12 1 12 6 6                             11/01/2018 1 1 0 16 1 0 16 10/16/2017 11 10 11 108 1 0 108 2016-07-06 1 1 0 1 4 0 4 44.667 2 0 0 0.00 0 0   02/01/2020
3123 210 Ponderosa Dr, Camden, AL 36726, USA 32.0053052 -87.304223 1 RANGE_INTERPOLATED 15374 CAMDEN NURSING FACILITY INC. 210 PONDEROSA DRIVE CAMDEN AL 36726 3346824231 650 Wilcox For profit - Corporation 95 67.8 Medicare and Medicaid false 10/24/1980 false   false false false Resident Yes 1   1   4   2   5   1 12 1 12 6 6                             01/31/2019 1 1 0 4 1 0 4 01/11/2018 0 0 0 0 0 0 0 2016-11-12 8 8 0 1 253 0 253 44.167 0 0 0 0.00 0 0   02/01/2020
3178 1305 US-6, Cambridge, NE 69022, USA 40.2804314 -100.180273 1 ROOFTOP 2.8e+196 CAMBRIDGE MANOR P O BOX 488, WEST HWY 6 & 34 CAMBRIDGE NE 69022 3086973329 320 Furnas Non profit - Corporation 34   Medicaid true 10/01/1980 false   false false false Resident Yes 2   3   4   4     2 1 12 1 12 6 6                             05/16/2018 6 6 0 24 1 0 24 06/22/2017 14 14 0 84 1 0 84 2016-05-19 2 2 0 1 12 0 12 42 0 0 0 0.00 0 0   02/01/2020
3355 3550 MS-468, Pearl, MS 39208, USA 32.2419352 -90.07072869999999 1 ROOFTOP 25A402 JNH-JEFFERSON INN 3550 HWY 468 WEST - PO BOX 207 BLDG 33 WHITFIELD MS 39193 6013518015 600 Rankin Government - State 89 73.5 Medicaid false 06/04/2001 false   false false false Both Yes 2   2   5   5     2 1 12 1 12 6 6                             07/26/2019 5 5 0 20 1 0 20 09/26/2018 6 6 0 24 1 0 24 2017-05-24 9 8 2 1 48 0 48 26 0 1 0 0.00 0 0   02/01/2020
3626 8000 Fellowship Rd, Basking Ridge, NJ 07920, USA 40.6570358 -74.5832331 1 ROOFTOP 315356 SKILLED NURSING AT FELLOWSHIP VILLAGE 8000 FELLOWSHIP DRIVE BASKING RIDGE NJ 7920 9085803800 350 Somerset Non profit - Corporation 54 49.2 Medicare false 07/01/1996 true   false false false Resident Yes 5   5   5   5   5   1 12 1 12 6 6                             09/11/2019 0 0 0 0 0 0 0 08/03/2018 0 0 0 0 0 0 0 2017-05-03 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0   02/01/2020
4311 35625 MO-72, Salem, MO 65560, USA 37.6591179 -91.5659881 1 ROOFTOP 26A381 SALEM MEMORIAL DISTRICT HOSPITAL PO BOX 774, 35629 HIGHWAY 72 SALEM MO 65560 5737296626 320 Dent Government - Hospital district 18 17.9 Medicaid true 06/25/1992 false   false false false Resident Yes 5   5   5   5     2 1 12 1 12 6 6                             11/06/2019 1 1 0 16 1 0 16 10/10/2018 0 0 0 0 0 0 0 2017-08-10 2 2 0 1 8 0 8 9.333 0 0 0 0.00 0 0   02/01/2020
4617 4739 LA-10, Jackson, LA 70748, USA 30.8259277 -91.1650719 1 ROOFTOP 195629 LOUISIANA WAR VETERANS HOME 4739 HIGHWAY 10 JACKSON LA 70748 2253428998 180 East Feliciana Government - State 10 14.3 Medicare false 02/20/2009 false   false false false Resident Yes 4   5     2   2   2 1 12 1 12 6 6                             06/05/2019 1 1 0 8 1 0 8 05/16/2018 0 0 0 0 0 0 0 2017-05-10 2 2 0 1 8 0 8 5.333 0 0 0 0.00 0 0   02/01/2020
4799 26501 Ave 140, Porterville, CA 93257, USA 36.0438161 -118.9803525 1 ROOFTOP 05A198 PORTERVILLE DEVELOPMENTAL CENTER 26501 AVENUE 140 PORTERVILLE CA 93257 5597822222 640 Tulare Government - State 201 9.9 Medicaid true 09/01/1974 false   false false false Resident Yes 5   5   5   5     2 1 12 1 12 6 6                             06/06/2019 5 4 1 28 1 0 28 05/04/2018 2 2 0 8 1 0 8 2017-06-15 5 2 3 1 20 0 20 20 4 0 0 0.00 0 0   02/01/2020
4924 3550 MS-468 BLDG 78, Pearl, MS 39208, USA 32.2419352 -90.07072869999999 1 ROOFTOP 25A197 JNH-JAQUITH INN 3550 HIGHWAY 468 WEST- PO BOX207/BLDG 78 WHITFIELD MS 39193 6013518015 600 Rankin Government - State 58 53.3 Medicaid false 11/01/1978 false   false false false Both Yes 1   2   4   4     2 1 12 1 12 6 6                             06/20/2019 2 2 0 24 1 0 24 07/20/2017 9 7 2 80 1 0 80 2016-08-24 4 4 0 1 16 0 16 41.333 1 0 0 0.00 0 0   02/01/2020
5027 1010 US Hwy 27 N, Avon Park, FL 33825, USA 27.5842556 -81.5150317 1 RANGE_INTERPOLATED 105780 OAKS AT AVON 1010 US 27 N AVON PARK FL 33825 8634535200 270 Highlands Non profit - Other 104 91.6 Medicare and Medicaid false 01/06/1993 false   false false false Resident Yes 3   4   4   5   3   1 12 1 12 6 6                             03/07/2019 4 3 1 16 1 0 16 01/19/2018 4 2 2 12 1 0 12 2016-12-15 8 4 4 1 40 0 40 18.667 0 5 0 0.00 0 0   02/01/2020
5328 712 Copper Rock Drive, Rogersville, MO 65742, USA 37.1013661 -93.06327089999999 1 ROOFTOP 265878 COPPER ROCK HEALTHCARE 712 COPPER ROCK DRIVE ROGERSVILLE MO 65742 4172024606 994 Webster Non profit - Corporation 90   Medicare and Medicaid false 10/03/2019 false   false false false Both Yes   1   1   1   1   1   1   1 6 6                             10/03/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   02/01/2020
5481 3980 Lake Placid Dr, Reno, NV 89511, USA 39.3929796 -119.7897845 1 ROOFTOP 295103 NEURORESTORATIVE NEVADA 3980 LAKE PLACID DRIVE RENO NV 89511 7024999523 150 Washoe For profit - Limited Liability company 24   Medicare and Medicaid false 04/10/2019 false   false false false None Yes   1   1   1   1   1   1   1 6 6                             03/13/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   02/01/2020
5569 275 S Lasalle St, Aurora, IL 60505, USA 41.751409 -88.3177809 1 ROOFTOP 14A539 JENNINGS TERRACE 275 SOUTH LASALLE AURORA IL 60505 6308976947 530 Kane Non profit - Other 60 14.5 Medicaid false 09/18/2008 false   false false false Resident Yes 4   4   4   4     2   2   2 6 6                             12/12/2019 0 0 0 0 1 0 0 11/29/2018 5 4 1 32 1 0 32 2018-01-16 12 9 3 1 56 0 56 20 1 2 0 0.00 0 0   02/01/2020
5898 216 Lincoln Ave, Hebron, NE 68370, USA 40.1666774 -97.59305669999999 1 ROOFTOP 2.8e+280 BLUE VALLEY LUTHERAN CARE HOME P O BOX 166, 755 SOUTH 3RD STREET HEBRON NE 68370 4027683930 840 Thayer Non profit - Church related 64 24.4 Medicaid false 11/22/1991 false   false false false Resident Yes 1   2   4   4     2 1 12 1 12 6 6                             12/04/2018 15 15 1 72 1 0 72 10/12/2017 13 11 12 96 1 0 96 2016-07-18 4 3 1 1 40 0 40 74.667 7 0 0 0.00 0 0   02/01/2020
6046 56-117 Pualalea St, Kahuku, HI 96731, USA 21.6763946 -157.9541328 1 ROOFTOP 125030 KAHUKU MEDICAL CENTER 56-117 PUALALEA STREET KAHUKU HI 96731 8082939221 20 Honolulu Non profit - Other 6 5.9 Medicare and Medicaid true 01/01/1977 false   false false false Resident Yes 1   2     2   2   2 1 12 1 12 6 6                             06/04/2019 6 6 0 28 1 0 28 07/06/2018 5 5 0 60 1 0 60 2017-07-14 10 10 0 2 119 60 179 63.833 0 0 1 19500.00 1 2   02/01/2020
6101 9000 Fathers Legacy, Ellicott City, MD 21042, USA 39.2717181 -76.84284989999999 1 ROOFTOP 215363 THE LUTHERAN VILLAGE AT MILLER'S GRANT 9000 FATHERS LEGACY ELLICOTT CITY MD 21042 4106966700 130 Howard Non profit - Other 12 12 Medicare and Medicaid false 04/18/2017 true   false false false Both Yes 4   5   4   4   4   1 12 1 12 6 6                             05/22/2019 0 0 0 0 0 0 0 01/30/2018 2 2 0 8 1 0 8 2017-03-13 3 3 0 1 12 0 12 4.667 0 0 0 0.00 0 0   02/01/2020
6352 3640 Central Ave, Indianapolis, IN 46205, USA 39.8224421 -86.15029489999999 1 ROOFTOP 155857 TRANQUILITY NURSING AND REHAB 3640 N CENTRAL AVENUE INDIANAPOLIS IN 46205 3174800806 480 Marion For profit - Individual 78 5.3 Medicare and Medicaid false 06/01/2019 false   false false false Resident Yes   1   1   1   1   1   1   1 6 6                             05/31/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   02/01/2020
6587 401 S Van Buren St, Mt Pleasant, IA 52641, USA 40.9636572 -91.5588478 1 ROOFTOP 165147 HENRY COUNTY HEALTH CENTER 401 SOUTH VAN BUREN MOUNT PLEASANT IA 52641 3193856192 430 Henry Government - Hospital district 49 36.4 Medicare and Medicaid true 01/16/1989 false   false false false Both Yes 3   3   5   5     2 1 12 1 12 6 6                             10/17/2019 2 2 0 12 1 0 12 08/02/2018 1 1 0 4 1 0 4 2017-05-11 11 8 3 1 68 0 68 18.667 1 1 0 0.00 0 0   02/01/2020
7085 100 Pioneers Medical Center Dr, Meeker, CO 81641, USA 40.0470026 -107.8822968 1 ROOFTOP 65264 WALBRIDGE MEMORIAL CONVALESCENT WING 100 PIONEERS MEDICAL CENTER DR MEEKER CO 81641 9708785047 510 Rio Blanco Government - Hospital district 30 27.5 Medicare and Medicaid false 12/01/1989 false   false false false Resident Yes 3   4   3   3     2 1 12 1 12 6 6                             07/11/2019 1 1 0 8 1 0 8 05/03/2018 6 6 0 36 1 0 36 2017-03-16 6 6 0 1 52 0 52 24.667 0 0 0 0.00 0 0   02/01/2020
7274 2019 Co Rd 394, Killen, AL 35645, USA 34.9140509 -87.5287791 1 ROOFTOP 15361 LAUDERDALE CHRISTIAN NURSING HOME 2019 COUNTY ROAD 394 KILLEN AL 35645 2567572103 380 Lauderdale Non profit - Corporation 58 57.7 Medicare and Medicaid false 07/23/1970 false   false false false Resident Yes 4   4   5   5     2 1 12 1 12 6 6                             07/25/2019 1 1 0 16 1 0 16 06/20/2018 1 1 0 16 1 0 16 2017-04-20 0 0 0 0 0 0 0 13.333 0 0 0 0.00 0 0   02/01/2020
7349 3265 E Meridian Loop, Wasilla, AK 99654, USA 61.5884294 -149.3588151 1 RANGE_INTERPOLATED 25038 MAPLE SPRINGS OF WASILLA 3265 E MERIDIAN LOOP WASILLA AK 99654 9078411217 170 Matanuska-Susitna For profit - Corporation 67 15.2 Medicare and Medicaid false 07/23/2019 false   false false false None Yes   1   1   1   1   1   1   1 6 6                             07/22/2019                 . .             . . . . . . .   1 2 0 0.00 0 0   02/01/2020
7737 6800 Joliet Rd, Indian Head Park, IL 60525, USA 41.7692481 -87.8901817 1 ROOFTOP 145784 BRIAR PLACE NURSING 6800 WEST JOLIET INDIAN HEAD PARK IL 60525 7082468500 141 Cook For profit - Corporation 232 205.4 Medicare and Medicaid false 02/01/1994 false   true false false Resident Yes 1   1   1   2   1     2   2 6 6                             08/21/2019 20 11 9 136 1 0 136 10/26/2018 16 5 11 112 1 0 112 2017-09-01 21 10 12 1 128 0 128 126.667 1 30 0 0.00 0 0   02/01/2020
7743 3859 US-190, Eunice, LA 70535, USA 30.4962671 -92.3753708 1 ROOFTOP 195547 EUNICE MANOR 3859 HIGHWAY 190 EUNICE LA 70535 3374572681 480 St. Landry For profit - Corporation 152 106.2 Medicare and Medicaid false 05/13/2002 false   false false false Resident Yes 3   4   3   3   3   1 12 1 12 6 6                             10/10/2019 0 0 0 0 0 0 0 10/25/2018 1 1 0 8 1 0 8 2017-11-02 3 3 0 1 20 0 20 6 0 0 0 0.00 0 0   02/01/2020
8074 7301 St Charles Rock Rd, St. Louis, MO 63133, USA 38.691502 -90.3070879 1 ROOFTOP 265578 NORMANDY NURSING CENTER 7301 ST CHARLES ROCK RD SAINT LOUIS MO 63133 3148620555 940 St. Louis For profit - Limited Liability company 116 3.4 Medicare and Medicaid false 03/11/1994 false SFF Candidate false false false Resident Yes 2   1   5   5     2 1 12 1 12 6 6                             02/07/2019 19 19 0 140 1 0 140 04/09/2018 41 26 15 391 1 0 391 2017-04-20 10 8 4 1 80 0 80 213.667 4 9 1 65471.00 1 2   02/01/2020
8187 4356 24th Street Rd, Greeley, CO 80634, USA 40.396826 -104.7481153 1 ROOFTOP 65431 CENTER AT CENTERPLACE LLC, THE 4356 24TH ST RD GREELEY CO 80634 9707027400 610 Weld For profit - Limited Liability company 54   Medicare false 10/17/2019 false   false false false Resident Yes   1   1   1   1   1   1   1 6 6                             09/26/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   02/01/2020
8250 3550 MS-468, Pearl, MS 39208, USA 32.2419352 -90.07072869999999 1 ROOFTOP 25A404 JNH-MADISON INN 3550 HIGHWAY 468 WEST PO BOX 207 BLGS 28 &34 WHITFIELD MS 39193 6013518015 600 Rankin Government - State 85 66 Medicaid false 08/01/2001 false   false false false Both Yes 4   4   5   5     2 1 12 1 12 6 6                             03/07/2019 3 3 0 12 1 0 12 11/21/2017 2 2 0 8 1 0 8 2017-02-16 6 6 0 1 28 0 28 13.333 0 0 0 0.00 0 0   02/01/2020
8276 2951 US-281, George West, TX 78022, USA 28.3365661 -98.1226267 1 ROOFTOP 675104 LIVE OAK NURSING AND REHABILITATION CENTER 2951 HWY 281 GEORGE WEST TX 78022 3614492532 760 Live Oak Government - Hospital district 100 81.2 Medicare and Medicaid false 01/21/1993 false   false false false Resident Yes 1   2   3   4   2   1 12 1 12 6 6                             01/25/2019 12 11 1 76 1 0 76 12/15/2017 11 11 0 96 1 0 96 2016-10-20 3 3 0 1 32 0 32 75.333 2 0 0 0.00 0 0   02/01/2020
8709 931 N Broadway St, Aspermont, TX 79502, USA 33.1481491 -100.2274452 1 RANGE_INTERPOLATED 676077 GIBSON CARE CENTER 931 N BROADWAY ASPERMONT TX 79502 9409893526 903 Stonewall For profit - Corporation 80 26.2 Medicare and Medicaid true 09/13/2005 false   false false false Both Yes 4   5   2   2     2 1 12 1 12 6 6                             03/25/2019 2 1 1 8 1 0 8 02/28/2018 0 0 0 0 0 0 0 2017-01-05 5 5 0 1 48 0 48 12 0 1 0 0.00 0 0   02/01/2020
8744 867 US-70 ALT, Wilson, OK 73463, USA 34.1623225 -97.4215847 1 ROOFTOP 375571 WILSON NURSING CENTER 867 US HIGHWAY 70A WILSON OK 73463 5806682337 90 Carter For profit - Corporation 64 34.7 Medicare and Medicaid false 07/31/2017 false   false false false Resident Yes 1   1   1   1     2 1 12 1 12 6 6                             04/24/2019 8 8 0 60 1 0 60 05/10/2018 20 20 0 164 1 0 164 2017-06-15 17 17 0 1 124 0 124 105.333 0 0 0 0.00 0 0   02/01/2020
8898 700 Weakley County Nursing Home Rd, Dresden, TN 38225, USA 36.2824755 -88.7496318 1 RANGE_INTERPOLATED 445437 WEAKLEY COUNTY NURSING HOME 700 WEAKLEY COUNTY NURSING HOME ROAD DRESDEN TN 38225 7313643158 910 Weakley For profit - Corporation 136 82 Medicare and Medicaid false 01/01/2002 false   false false false Resident Yes 4   4   5   5   4   1 12 1 12 6 6                             03/19/2019 3 2 1 12 1 0 12 04/25/2018 0 0 0 0 0 0 0 2017-04-19 2 2 0 1 8 0 8 7.333 0 1 0 0.00 0 0   02/01/2020
9338 San Lucas, Calle San Cosme, San Juan, 00926, Puerto Rico 18.3442773 -66.0857003 1 GEOMETRIC_CENTER 405030 MILLENNIUM INSTITUTE FOR ADVANCE NURSING CARE INC CALLE COSME REPARTO SAN LUCAS ENTRADA SECTOR CANEJ RIO PIEDRAS PR 926 7877080138 640 San Juan For profit - Corporation 35   Medicare false 02/12/2015 false   false false false None Yes 2   3   4     2 4   1 12 1 12 6 6                             03/13/2019 10 10 0 104 1 0 104 08/24/2018 2 2 0 16 1 0 16 2017-05-26 12 12 0 1 136 0 136 80 0 0 1 5551.00 0 1   02/01/2020
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 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
9759 6975 Graphics Way, Lewis Center, OH 43035, USA 40.1887853 -83.0222383 1 RANGE_INTERPOLATED 366472 CAPRI GARDENS 6975 GRAPHICS WAY LEWIS CENTER OH 43035 7409010754 210 Delaware For profit - Corporation 50   Medicare and Medicaid false 10/01/2019 false   false false false Resident Yes   1   1   1   1   1   1   1 6 6                             10/01/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   02/01/2020
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 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 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 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
10380 15230 15th Ave NE, Shoreline, WA 98155, USA 47.740384 -122.3105044 1 ROOFTOP 50A260 FIRCREST SCHOOL, PAT N 15230-15TH NORTHEAST SEATTLE WA 98155 2063613511 160 King Government - State 92 109.2 Medicaid false 05/13/1994 false   false false false None Yes 5   4   5   5     2   2   2 6 6                             08/15/2019 8 4 5 52 1 0 52 05/17/2018 8 1 7 52 1 0 52 2017-04-14 8 3 7 1 80 0 80 56.667 5 9 0 0.00 0 0   02/01/2020
10541 13600 Birdcall Ln, Cypress, TX 77429, USA 29.9524436 -95.6288139 1 ROOFTOP 676467 CYPRESS CREEK REHABILITATION AND HEALTHCARE CENTER 13600 BIRDCALL LANE CYPRESS TX 77429 5124382630 610 Harris For profit - Individual 122   Medicare and Medicaid false 08/22/2019 false   false false false Resident Yes   1   1   1   1   1   1   1 6 6                             08/22/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   02/01/2020
10921 2781 U.S. 9, Hudson, NY 12534, USA 42.139517 -73.78449599999999 1 ROOFTOP 335389 LIVINGSTON HILLS NURSING AND REHABILITATION CENTER 2781 ROUTE 9 , P O BOX 95 LIVINGSTON NY 12541 5188513041 200 Columbia For profit - Partnership 120 101.4 Medicare and Medicaid false 05/01/1973 false   false false false Resident Yes 1   1   2   2   3   1 12 1 12 6 6                             04/05/2019 28 27 7 152 1 0 152 07/20/2017 7 7 4 36 1 0 36 2016-05-17 9 6 3 1 40 0 40 94.667 2 9 0 0.00 0 0   02/01/2020
11285 564 State Line Rd, Colcord, OK 74338, USA 36.1806625 -94.5670008 1 ROOFTOP 375386 QUAIL RIDGE LIVING CENTER, INC 564 STATE LINE ROAD COLCORD OK 74338 9184225138 200 Delaware For profit - Corporation 120 77.3 Medicare and Medicaid false 07/10/2000 false   false false false Resident Yes 1   1   3   3   3   1 12 1 12 6 6                             10/08/2018 6 6 0 44 1 0 44 08/29/2017 6 2 4 395 1 0 395 2016-06-27 9 9 0 1 185 0 185 184.5 0 1 1 85600.00 1 2   02/01/2020
11480 12520 FM1840, De Kalb, TX 75559, USA 33.502451 -94.6065888 1 ROOFTOP 675936 PONDEROSA NURSING AND REHABILITATION CENTER 12520 FM 1840 DE KALB TX 75559 9036672572 170 Bowie For profit - Corporation 110 74.7 Medicare and Medicaid false 10/29/2002 false   false false false Resident Yes 1   2   2   1   2   1 12 1 12 6 6                             08/23/2018 12 3 9 108 1 0 108 11/08/2017 5 3 2 76 1 0 76 2016-12-14 11 8 3 1 112 0 112 98 1 7 1 13627.00 0 1   02/01/2020
11632 Moravia, NY 13118, USA 42.71257019999999 -76.42160249999999 1 APPROXIMATE 335077 NORTHWOODS REHAB AND NURSING CENTER AT MORAVIA PO BOX 1079 MORAVIA NY 13118 3154970440 50 Cayuga For profit - Partnership 40 32.8 Medicare and Medicaid false 01/01/1967 false   false false false Resident Yes 3   3   5   5   4   1 12 1 12 6 6                             09/20/2019 4 2 2 12 1 0 12 08/30/2018 3 3 0 12 1 0 12 2017-03-31 9 8 5 1 56 0 56 19.333 0 4 1 11053.00 0 1   02/01/2020
11767 1100 Georgia St, Jones, OK 73049, USA 35.5636213 -97.29572209999999 1 ROOFTOP 375117 OAK HILLS LIVING CENTER 1100 WEST GEORGIA JONES OK 73049 4054002295 540 Oklahoma For profit - Individual 160 86.5 Medicare and Medicaid false 02/10/1992 false   true false true Resident Yes 1   1   2   2   2   1 12 1 12 6 6                             04/16/2019 26 12 18 244 1 0 244 03/06/2018 21 15 6 156 1 0 156 2016-12-08 9 5 4 1 56 0 56 183.333 0 19 0 0.00 0 0   02/01/2020
11860 3003 W Iowa Ave, Chickasha, OK 73018, USA 35.046825 -97.97118599999999 1 ROOFTOP 375359 GLENHAVEN RETIREMENT VILLAGE 3003 IOWA CHICKASHA OK 73023 4052240909 250 Grady For profit - Corporation 120 77.3 Medicare and Medicaid false 01/01/1999 true   false false false Resident Yes 3   4   3   2   4   1 12 1 12 6 6                             08/19/2019 1 1 0 16 1 0 16 07/02/2018 8 6 2 48 1 0 48 2017-04-13 1 0 1 0 8 0 8 25.333 0 2 0 0.00 0 0   02/01/2020
11874 300 Clynelish Close, Pittsboro, NC 27312, USA 35.7928629 -79.0964845 1 ROOFTOP 345539 THE ARBOR 300 CLYNELISH CLOSE PITTSBORO NC 27312 9195452660 180 Chatham For profit - Individual 16 4.6 Medicare false 09/28/2006 true   false false false Resident Yes 5   5   5     2 5   1 12 1 12 6 6                             06/25/2019 2 2 0 8 1 0 8 05/16/2018 0 0 0 0 0 0 0 2017-04-26 0 0 0 0 0 0 0 4 0 0 0 0.00 0 0   02/01/2020
12005 1 Nolte Dr, Kittanning, PA 16201, USA 40.8085788 -79.56145769999999 1 ROOFTOP 395890 SNU ARMSTRONG CO MEMORIAL HOSP ONE NOLTE DRIVE KITTANNING PA 16201 7245438458 70 Armstrong Non profit - Other 17 8.9 Medicare true 02/23/1993 false   false false false None Yes 5   5   5     2 5   1 12 1 12 6 6                             09/06/2019 0 0 0 0 0 0 0 08/13/2018 1 1 0 16 1 0 16 2017-08-30 1 1 0 1 4 0 4 6 0 0 0 0.00 0 0   02/01/2020
12345 S Hwy 501, Marion, SC 29571, USA 34.1615973 -79.39602219999999 1 GEOMETRIC_CENTER 425416 SENIOR CARE OF MARION 2770 S HIGHWAY 501 MARION SC 29571 8555738466 330 Marion For profit - Partnership 95   Medicare false 10/10/2019 false   false false false Family Yes   1   1   1   1   1   1   1 6 6                             10/10/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   02/01/2020
12727 335 Township Rd 1026, South Point, OH 45680, USA 38.4097766 -82.5368649 1 ROOFTOP 366265 RIVER'S BEND HEALTH CARE LLC 335 TOWNSHIP ROAD 1026 SOUTH POINT OH 45680 7408943476 450 Lawrence For profit - Corporation 80 36.9 Medicare and Medicaid false 04/24/2003 false SFF Candidate true false false Resident Yes 2   1   5   5   4   1 12 1 12 6 6                             11/16/2018 30 20 10 1464 1 0 1464 09/22/2017 15 15 0 124 1 0 124 2016-12-01 6 6 0 1 32 0 32 778.667 0 3 2 35464.00 2 4   02/01/2020
12763 201 Nelson Ave, Farmington, NM 87401, USA 36.7248998 -108.2207629 1 ROOFTOP 325133 WELBROOK SENIOR LIVING, LLC 201 NELSON AVENUE FARMINGTON NM 87401 5056754545 220 San Juan For profit - Limited Liability company 50   Medicare false 09/16/2019 false   false false false Resident Yes   1   1   1   1   1   1   1 6 6                             09/16/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   02/01/2020
13070 WA-902 & Salnave Rd, Medical Lake, WA 99022, USA 47.55102369999999 -117.7044559 1 GEOMETRIC_CENTER 50A263 LAKELAND VILLAGE NURSING FACILITY STATE HIGHWAY 902 & SALNAVE ROAD MEDICAL LAKE WA 99022 5092991800 310 Spokane Government - State 93 87.7 Medicaid false 05/23/1994 false   false false false Family Yes 4   4   4   4     2   2   2 6 6                             03/19/2019 9 4 5 102 1 0 102 02/23/2018 13 12 1 56 1 0 56 2017-01-18 7 3 4 1 28 0 28 74.333 8 1 0 0.00 0 0   02/01/2020
13865 932 Old US Hwy 70, Black Mountain, NC 28711, USA 35.612557 -82.356127 1 ROOFTOP 34A001 BLACK MOUNTAIN NEURO-MEDICAL TREATMENT CENTER 932 OLD US HIGHWAY 70 BLACK MOUNTAIN NC 28711 8282596700 100 Buncombe Government - State 165 156.3 Medicaid false 10/04/1991 false   false false true Resident Yes 5   4   5   5     2   2   2 6 6                             05/09/2019 0 0 0 0 0 0 0 05/03/2018 6 6 0 24 1 0 24 2017-05-25 0 0 0 0 0 0 0 8 0 0 0 0.00 0 0   02/01/2020
14373 14041 Cottingham Rd, Pearland, TX 77581, USA 29.600774 -95.3408833 1 ROOFTOP 45F886 RICHARD A. ANDERSON (STATE OF TEXAS VETERANS LAND 14041 COTTINGHAM ROAD HOUSTON TX 77048 2108285686 610 Harris Government - State 2   Medicaid false 11/05/2019 false   false false false Resident Yes   1   1   1   1   1   1   1 6 6                             11/05/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   02/01/2020
14595 W Pine St & N Bristow Ave, Drumright, OK 74030, USA 35.995181 -96.60730799999999 1 GEOMETRIC_CENTER 375466 DRUMRIGHT NURSING HOME PINE & BRISTOW DRUMRIGHT OK 74030 9183523249 180 Creek For profit - Corporation 133 47.8 Medicare and Medicaid false 09/15/2004 false   false false false Both Yes 1   2   3   1   5   1 12 1 12 6 6                             07/08/2019 6 6 0 40 1 0 40 05/09/2018 16 15 1 116 1 0 116 2017-02-07 11 6 5 1 305 0 305 109.5 0 2 0 0.00 0 0   02/01/2020
14729 3875 E Galbraith Rd, Deer Park, OH 45236, USA 39.20837210000001 -84.4044189 1 ROOFTOP 366256 WEXFORD CARE CENTER 3875 EAST GALBRAITH ROAD CINCINNATI OH 45236 5137935222 310 Hamilton For profit - Corporation 73 46 Medicare and Medicaid false 02/12/2003 false   false false false Both Yes 1   2   4   4     2 1 12 1 12 6 6                             02/21/2019 14 14 0 72 1 0 72 01/18/2018 4 4 0 20 1 0 20 2016-11-18 24 24 0 1 164 0 164 70 0 0 0 0.00 0 0   02/01/2020
14786 PR-844, San Juan, 00926, Puerto Rico 18.3551846 -66.0400062 1 GEOMETRIC_CENTER 405031 HIMA SAN PABLO CUPEY SNF CARR 844 KM 0 5 CUPEY BAJO RIO PIEDRAS PR 928 7877618383 640 San Juan For profit - Corporation 25 5 Medicare true 06/06/2017 false   false false false None Yes 2   3   4     2 4   1 12 1 12 6 6                             05/16/2019 1 1 0 4 1 0 4 07/19/2018 6 6 0 52 1 0 52 2017-03-16 23 23 0 1 364 0 364 80 0 0 0 0.00 0 0   02/01/2020
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 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
15257 1400 Liberty, Midtown Ave, Mt Pleasant, SC 29464, USA 32.8125724 -79.8401718 1 GEOMETRIC_CENTER 425417 SHEM CREEK NURSING AND REHAB 1400 LIBERTY MIDTOWN DRIVE, SUITE 420 MOUNT PLEASANT SC 29464 8439362801 90 Charleston For profit - Limited Liability company 40   Medicare false 11/05/2019 true   false false false Resident Yes   1   1   1   1   1   1   1 6 6                             11/05/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   02/01/2020
15429 750 Hwy 352, Mesquite, TX 75149, USA 32.7721202 -96.5722369 1 ROOFTOP 676466 CHEYENNE MEDICAL LODGE 750 HIGHWAY 352 MESQUITE TX 75149 5124382630 390 Dallas For profit - Corporation 139   Medicare and Medicaid false 08/28/2019 false   false false false Resident Yes   1   1   1   1   1   1   1 6 6                             08/28/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   02/01/2020
14746 920 E Ave L, Silsbee, TX 77656, USA 30.3427354 -94.17136819999999 1 ROOFTOP 676008 SILSBEE OAKS HEALTH CARE LLP 920 E AVE L SILSBEE TX 77656 4093855571 600 Hardin For profit - Partnership 160 146.1 Medicare and Medicaid false 02/29/2004 false   false false false Resident Yes 2   4   1   1   2   1   1       0.38753 0.97056 0.23165 1.20221 1.58973 0.01952 1.84777 0.69925 0.33201 2.87904 0.43588 1.04369 0.26261 1.77064 08/14/2019 3 3 0 24 1 0 24 09/20/2018 5 5 0 40 1 0 40 2017-08-23 7 5 2 1 92 0 92 40.667 1 1 1 7023.00 0 1   02/01/2020
4678 28W141 Liberty St, Winfield, IL 60190, USA 41.868178 -88.169156 1 ROOFTOP 146168 WINFIELD WOODS HEALTHCARE CTR 28 WEST 141 LIBERTY STREET WINFIELD IL 60190 6306689696 250 Du Page For profit - Individual 138 133.2 Medicare and Medicaid false 04/10/2014 false   false false false Both Yes 2   3   3   3   3   1   1       0.93597 0.40851 0.26879 0.6773 1.61327 0.02218 2.07803 0.72771 0.33674 3.14248 0.93611 0.42212 0.30043 1.64622 05/08/2019 9 8 2 56 1 0 56 04/05/2018 12 10 2 56 1 0 56 2017-06-30 4 4 0 1 12 0 12 48.667 0 2 0 0.00 0 0   02/01/2020
9505 100 NE Loop 304, Crockett, TX 75835, USA 31.3613925 -95.467705 1 ROOFTOP 676043 HOUSTON COUNTY NURSING HOME 100 N E LOOP 304 CROCKETT TX 75835 9365447884 660 Houston For profit - Corporation 90 51.3 Medicare and Medicaid false 01/01/2005 false   false false false Resident Yes 5   5   5   5     2 2   2       0.79847 0.54214 0.30658 0.84872 1.6472 0.00122 1.84436 0.58928 0.25547 2.68911 0.89977 0.6918 0.45168 1.96422 05/08/2019 0 0 0 0 1 0 0 06/13/2018 1 1 0 4 1 0 4 2017-06-14 6 3 3 1 84 0 84 15.333 0 2 0 0.00 0 0   02/01/2020
3791 525 S Martin Luther King Jr Dr, Springfield, IL 62703, USA 39.7961762 -89.6313067 1 ROOFTOP inf APERION CARE SPRINGFIELD 525 SO MARTIN LUTHER KING DR SPRINGFIELD IL 62703 2177891680 920 Sangamon For profit - Corporation 65 61.8 Medicaid false 08/21/1986 false   false false false Resident Yes 5   5   5   5     2 1   1       1.1742 0.21964 0.37999 0.59963 1.77383 0 2.2076 0.82814 0.53805 3.57379 1.10545 0.19943 0.26582 1.59161 07/25/2019 6 6 0 16 1 0 16 06/29/2018 3 3 0 16 1 0 16 2017-05-26 5 3 2 1 20 0 20 16.667 2 2 0 0.00 0 0   02/01/2020
10018 10 Medical Dr, Clarendon, TX 79226, USA 34.9450093 -100.897078 1 ROOFTOP 676411 CLARENDON NURSING HOME TEN MEDICAL CENTER DR CLARENDON TX 79226 8068742273 431 Donley For profit - Corporation 61 52.4 Medicare and Medicaid false 02/02/2017 false   false false false Resident Yes 2   2   5   5     2 1 12 1 12     1.03787 0.60253 0.20731 0.80984 1.84771 0.06249 1.77194 0.68392 0.33597 2.79183 1.21733 0.66246 0.23224 2.12226 06/25/2019 16 11 5 96 1 0 96 08/23/2018 16 15 1 124 1 0 124 2017-09-28 15 11 7 1 116 0 116 108.667 4 5 0 0.00 0 0   02/01/2020
3117 1821 Anderson Ave NW, Atlanta, GA 30314, USA 33.7560109 -84.44704949999999 1 ROOFTOP 115542 SADIE G. MAYS HEALTH & REHABILITATION CENTER 1821 ANDERSON AVENUE NW ATLANTA GA 30314 4047942477 470 Fulton Non profit - Corporation 206 189.8 Medicare and Medicaid false 04/01/1993 false   false false false Both Yes 2   1   5   5   4   1 12 1 12     1.11166 0.52687 0.21323 0.74011 1.85177 0.05883 2.11082 0.72541 0.32994 3.16617 1.09456 0.54614 0.24325 1.87545 04/19/2019 13 13 0 76 1 0 76 03/01/2018 6 5 1 32 1 0 32 2017-04-27 1 1 0 1 4 0 4 49.333 0 2 0 0.00 0 0   02/01/2020
6814 3249 147th St, Midlothian, IL 60445, USA 41.6253172 -87.7012883 1 ROOFTOP 145947 APERION CARE MIDLOTHIAN 3249 WEST 147TH STREET MIDLOTHIAN IL 60445 7083893141 141 Cook For profit - Partnership 91 82.8 Medicare and Medicaid false 12/01/1997 false   false false false Resident Yes 1   3   1   3   1   1   1       1.11563 0.67243 0.20337 0.87581 1.99144 0.01494 2.02671 0.85298 0.49384 3.37354 1.14404 0.59278 0.155 1.89293 06/06/2019 12 7 5 72 1 0 72 07/13/2018 6 6 1 36 1 0 36 2017-08-11 4 2 2 1 20 0 20 51.333 0 10 1 3900.00 0 1   02/01/2020
13359 29-1 216th St #29, Bayside, NY 11360, USA 40.7760288 -73.7690545 1 ROOFTOP 33A081 ST MARYS HOSPITAL FOR CHILDREN 29 01 216 STREET BAYSIDE NY 11360 7182818800 590 Queens Non profit - Corporation 124 122.8 Medicaid false 03/31/1974 false   false false false Both Yes 5   5   5   5     2 5   5       4.87201 0.2506 4.9483 5.19891 10.07092 0.41104 2.37969 0.97388 0.97443 4.328 4.25505 0.19349 1.91133 7.46164 03/29/2019 0 0 0 0 0 0 0 11/22/2017 1 1 0 4 1 0 4 2016-08-26 0 0 0 0 0 0 0 1.333 0 0 0 0.00 0 0   02/01/2020
5063 528 Chief Eddie Hoffman Hwy, Bethel, AK 99559, USA 60.78834669999999 -161.7851781 1 ROOFTOP 25037 YUKON KUSKOKWIM ELDER'S HOME 1100 CHIEF EDDIE HOFFMAN HWY, PO BOX 528 BETHEL AK 99559 9075436782 50 Bethel Government - Federal 18 16.5 Medicare and Medicaid true 04/10/2014 false   false false false Resident Yes 2   1   5   5     2 5   5       3.60122 3.34976 3.12141 6.47118 10.07239 0 2.06157 0.60747 0.26042 2.92946 3.6305 4.14644 4.5113 11.02548 11/09/2018 18 18 0 108 1 0 108 02/02/2018 25 25 4 264 2 132 396 2017-02-14 16 16 0 1 239 0 239 225.833 0 2 3 31012.00 0 3   02/01/2020
15079 900 E Airport Rd, Okmulgee, OK 74447, USA 35.6675915 -95.9597392 1 ROOFTOP 375314 MUSCOGEE (CREEK) NATION SKILLED NURSING FACILITY 900 EAST AIRPORT ROAD OKMULGEE OK 74447 9187569211 550 Okmulgee Government - Federal 8 6.2 Medicare false 07/08/1997 false   false false false None Yes 4   4   5     2 5   1 12 1 12     3.94264 4.94702 3.41021 8.35723 12.29988 0.55692 1.97141 1.02093 0.59448 3.58682 4.15648 3.64359 2.15912 10.99623 04/25/2019 7 7 0 52 1 0 52 06/13/2018 2 2 0 8 1 0 8 2017-04-26 4 4 0 1 32 0 32 34 0 0 0 0.00 0 0   02/01/2020
611 117 Sycamore St, Greenville, MO 63944, USA 37.121988 -90.449789 1 ROOFTOP 265547 GREENVILLE HEALTH CARE CENTER 117 SYCAMORE STREET, PO BOX 108 GREENVILLE MO 63944 5732243298 993 Wayne For profit - Corporation 60 50.5 Medicare and Medicaid false 11/01/1993 false   false false false Resident Yes 2   2   2   2   2   2   2       1.05689 0.70086 0.24306 0.94392 2.00081 0 1.57669 0.60891 0.2673 2.4529 1.39315 0.8655 0.34225 2.61564 11/19/2018 20 19 1 108 1 0 108 10/27/2017 6 6 0 24 1 0 24 2016-12-20 11 11 0 1 52 0 52 70.667 0 1 0 0.00 0 0   02/01/2020
12743 64-11 Beach Channel Dr, Queens, NY 11692, USA 40.5925172 -73.7935787 1 ROOFTOP 335738 HORIZON CARE CENTER 64 11 BEACH CHANNEL DRIVE ARVERNE NY 11692 7189450700 590 Queens For profit - Corporation 280 264.8 Medicare and Medicaid false 04/07/1992 false   false false false Both Yes 1   2   3   5   1   1   1       1.32644 0.4599 0.24176 0.70165 2.02809 0.02295 1.86545 0.82248 0.44888 3.13681 1.47782 0.42045 0.20271 2.07325 10/08/2019 8 8 0 32 1 0 32 05/17/2018 7 7 0 28 1 0 28 2017-01-11 9 9 0 1 40 0 40 32 0 0 0 0.00 0 0   02/01/2020
8185 253 MO-116, Plattsburg, MO 64477, USA 39.5719765 -94.4330876 1 ROOFTOP 265698 NICK'S HEALTH CARE CENTER, LLC 253 EAST HIGHWAY 116 PLATTSBURG MO 64477 8165392376 240 Clinton For profit - Partnership 70 68.9 Medicare and Medicaid false 02/24/1999 false   false false false Resident Yes 3   2   5   5     2 2   2       1.34886 0.40363 0.28478 0.68841 2.03726 0 1.41937 0.56485 0.24531 2.22953 1.97508 0.53732 0.43694 2.93012 03/21/2019 18 15 3 84 1 0 84 04/06/2018 14 12 2 72 2 36 108 2017-04-06 5 5 0 1 28 0 28 82.667 1 6 0 0.00 1 1   02/01/2020
434 8225 W Robindale Rd, Las Vegas, NV 89113, USA 36.0477149 -115.2708861 1 ROOFTOP 295101 DESERT HILLS POST-ACUTE & REHABILITATION CENTER 8225 W ROBINDALE ROAD LAS VEGAS NV 89113 7026806131 10 Clark For profit - Corporation 75 47.9 Medicare and Medicaid false 01/12/2018 false   false false false None Yes 1   1   2   3   1   1 12 1 12     1.3026 0.55836 0.22828 0.78664 2.08925 0.09244 2.1442 0.8039 0.37793 3.32603 1.26259 0.52228 0.22734 2.01427 01/22/2019 25 25 0 144 1 0 144 11/27/2017 11 7 4 56 1 0 56   . . . . . . . 108.8 0 3 0 0.00 0 0   02/01/2020
3269 2401 W Grand St, Springfield, MO 65802, USA 37.1978117 -93.324664 1 RANGE_INTERPOLATED 265477 SPRINGFIELD SKILLED CARE CENTER 2401 WEST GRAND SPRINGFIELD MO 65802 4178644545 380 Greene For profit - Corporation 120 109.9 Medicare and Medicaid false 11/15/1991 false   false false false Resident Yes 1   1   4   5   2   2   2       1.54597 0.21909 0.33627 0.55536 2.10133 0.02986 1.6072 0.64562 0.30693 2.55975 1.99916 0.25517 0.41236 2.63239 11/26/2019 20 20 0 140 1 0 140 01/14/2019 21 10 11 128 1 0 128 2017-11-20 8 6 3 1 36 0 36 118.667 0 13 0 0.00 0 0   02/01/2020
15222 699 Campus Dr, Crane, TX 79731, USA 31.3928161 -102.3634707 1 ROOFTOP 675927 CRANE NURSING & REHABILITATION CENTER 699 CAMPUS DR CRANE TX 79731 4325583400 360 Crane For profit - Corporation 110 72.2 Medicare and Medicaid false 08/16/2002 false   false false false Resident Yes 1   1   1   1   1   1   1       1.21742 0.66853 0.23009 0.89862 2.11604 0.00868 1.95866 0.77265 0.40942 3.14073 1.29181 0.65061 0.21152 2.16046 10/24/2019 21 5 16 152 1 0 152 10/18/2018 5 4 1 32 1 0 32 2017-09-22 18 17 1 1 309 0 309 138.167 0 13 1 100488.00 0 1   02/01/2020
1689 5888 N Ridge Ave, Chicago, IL 60660, USA 41.9888142 -87.6689396 1 ROOFTOP 145765 PARK VIEW REHAB CENTER 5888 NORTH RIDGE CHICAGO IL 60660 7737692626 141 Cook For profit - Partnership 128 120.7 Medicare and Medicaid false 12/01/1993 false   true false false Resident Yes 1   2   1   3   1   2   2       1.2933 0.48066 0.36202 0.84268 2.13598 0.04343 1.85392 0.79482 0.41339 3.06213 1.44986 0.45473 0.32961 2.23679 08/22/2019 12 8 4 68 1 0 68 10/03/2018 14 9 5 108 1 0 108 2017-09-14 13 11 2 1 112 0 112 88.667 0 16 0 0.00 0 0   02/01/2020
5336 15600 Honore St, Blue Island, IL 60406, USA 41.6557735 -87.6660079 1 RANGE_INTERPOLATED 145173 HEATHER HEALTH CARE CENTER 15600 SOUTH HONORE STREET HARVEY IL 60426 7083339550 141 Cook For profit - Corporation 173 141.6 Medicare and Medicaid false 03/17/1978 false   false false false Resident Yes 3   4   2   4   1   1   1       1.27773 0.67002 0.21801 0.88803 2.16576 0.01347 2.02535 0.74572 0.32998 3.10104 1.31116 0.67561 0.24867 2.23952 04/26/2019 2 1 1 8 1 0 8 03/09/2018 10 5 6 44 1 0 44 2017-04-14 14 9 5 1 92 0 92 34 1 15 0 0.00 0 0   02/01/2020
2 Ashville, AL, USA 33.8370433 -86.2544223 1 APPROXIMATE 15407 HEALTH CARE INC P O BOX 130 ASHVILLE AL 35953 2055945148 570 St. Clair For profit - Individual 53 45 Medicare and Medicaid false 08/22/1990 false   false false false Both Yes 3   2   5   5     2 2   3       1.34613 0.44325 0.42724 0.87049 2.21662 0 1.72152 0.60099 0.25615 2.57865 1.62514 0.55459 0.62779 2.75646 08/08/2019 3 3 0 24 1 0 24 06/28/2018 4 4 0 28 1 0 28 2017-04-20 3 3 0 1 24 0 24 25.333 0 0 0 0.00 0 0   02/01/2020
12488 2736 FM 775, La Vernia, TX 78121, USA 29.3484852 -98.13091159999999 1 ROOFTOP 675947 COUNTRY CARE MANOR 2736 FARM TO MARKET 775 LA VERNIA TX 78121 8307792355 971 Wilson For profit - Limited Liability company 91 81.4 Medicare and Medicaid false 12/04/2002 false   false false false Resident Yes 2   2   2   5   1   2   2       1.19734 0.69066 0.33313 1.0238 2.22113 0.06408 1.98833 0.72596 0.35125 3.06555 1.25154 0.71538 0.35697 2.32338 07/12/2019 17 17 0 124 1 0 124 07/12/2018 6 6 0 52 1 0 52 2017-06-22 1 1 0 1 8 0 8 80.667 0 2 0 0.00 0 0   02/01/2020
12542 540 W State Hwy 29, Bertram, TX 78605, USA 30.7459754 -98.0602261 1 RANGE_INTERPOLATED 676117 BERTRAM NURSING AND REHABILITATION 540 E STATE HWY 29 BERTRAM TX 78605 5123552116 222 Burnet For profit - Corporation 61 54.1 Medicare and Medicaid false 11/01/2006 false   false false false Resident Yes 5   5   3   3   3   2   2       1.32723 0.49527 0.40654 0.90181 2.22903 0.01198 1.97406 0.7189 0.37056 3.06351 1.39734 0.51803 0.41293 2.33319 01/23/2019 2 2 0 12 1 0 12 02/07/2018 2 2 0 24 1 0 24 2017-02-15 0 0 0 0 0 0 0 14 0 0 0 0.00 0 0   02/01/2020
61 1 Bay St, Montclair, NJ 07042, USA 40.8120546 -74.2036597 1 ROOFTOP 315389 HACKENSACK-UMC MOUNTAINSIDE ONE BAY AVE MONTCLAIR NJ 7042 9734296949 200 Essex For profit - Corporation 18 28.3 Medicare true 01/08/1998 false   false false false None Yes 5   5   5     2 5   3   5       0.26961 0 1.9601 1.9601 2.22971 0.37038 2.06033 0.86985 0.48637 3.41655 0.27196 0 1.51686 2.09273 07/22/2019 0 0 0 0 0 0 0 08/22/2018 0 0 0 0 0 0 0 2017-05-25 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0   02/01/2020
10780 384 Harmony Hills, Spring Branch, TX 78070, USA 29.8081087 -98.42249699999999 1 ROOFTOP 676418 THE HEIGHTS OF BULVERDE 384 HARMONY HILLS SPRING BRANCH TX 78070 8304381276 320 Comal Government - Hospital district 124 78.2 Medicare and Medicaid false 03/15/2017 false   false false true Resident Yes 2   3   4   4   3   1   1       1.20263 0.85986 0.18338 1.04324 2.24587 0.06836 2.11663 0.82419 0.43191 3.37273 1.18087 0.78448 0.15981 2.13528 04/10/2019 10 9 1 52 1 0 52 04/06/2018 12 8 4 72 1 0 72 2017-03-15 4 0 4 0 68 0 68 61.333 1 3 0 0.00 0 0   02/01/2020

Next page

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
);