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

44 rows where Overall Rating = 4 and ownership = "Government - Hospital district"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: prvdr_state, prvdr_type, Provider Resides in Hospital, Legal Business Name, Abuse Icon, With a Resident and Family Council, Health Inspection Rating, QM Rating, 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 Physical Therapist Staffing Hours per Resident Per Day, Rating Cycle 1 Total Number of Health Deficiencies, Rating Cycle 1 Number of Standard Health Deficiencies, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Health Deficiency Score, Rating Cycle 1 Number of Health Revisits, Rating Cycle 1 Health Revisit Score, Rating Cycle 1 Total Health Score, Rating Cycle 2 Total Number of Health Deficiencies, Rating Cycle 2 Number of Standard Health Deficiencies, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 2 Health Deficiency Score, Rating Cycle 2 Number of Health Revisits, Rating Cycle 2 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
245 245 505 W ELM BUCKLIN, KS 67834 37.54739 -99.640197 0   175500 HILL TOP HOUSE 505 W ELM, PO BOX 248 BUCKLIN KS 67834 6208263202 280 Ford Government - Hospital district 30 26.7 Medicare and Medicaid false BUCKLIN DISTRICT HOSPITAL 01/01/2008 false   false false false Resident Yes 4   5   1   1     2 5   5       2.57693 0.11878 1.34157 1.46035 4.03728 0.00417 1.89897 0.63808 0.29316 2.83021 2.82033 0.13998 1.7224 4.57428 11/07/2019 0 0 0 0 0 0 0 10/31/2018 0 0 0 0 0 0 0 2017-03-29 8 8 0 2 64 32 96 16 0 0 1 3316.00 0 1 505 W ELM BUCKLIN, KS 67834 (37.54739, -99.640197) 02/01/2020
526 526 650 W TAYLOR ST VANDALIA, IL 62471 38.970644 -89.098209 0   145499 FAYETTE COUNTY HOSPITAL 650 W TAYLOR ST VANDALIA IL 62471 6182831231 340 Fayette Government - Hospital district 85 45.5 Medicare and Medicaid false Legal Business Name Not Available 10/17/1984 false   false false false Both Yes 4   5   1   1     2 5   5       2.26361 0.89894 0.79024 1.68918 3.95279 0.0009 2.0572 0.63687 0.26831 2.96239 2.28687 1.06136 1.10855 4.27874 08/22/2019 2 2 0 12 1 0 12 07/19/2018 0 0 0 0 0 0 0 2017-06-23 3 3 0 1 12 0 12 8 0 0 0 0.00 0 0 650 W TAYLOR ST VANDALIA, IL 62471 (38.970644, -89.098209) 02/01/2020
2018 2018 5189 HOSPITAL ROAD MARIPOSA, CA 95338 37.500531 -119.976948 0   55283 JOHN C. FREMONT HEALTHCARE DISTRICT DP/SNF 5189 HOSPITAL ROAD MARIPOSA CA 95338 2099663631 320 Mariposa Government - Hospital district 16 15.6 Medicare and Medicaid true JOHN C FREMONT HEALTHCARE DISTRICT 01/01/1967 false   false false false Resident Yes 4   5   4   4     2 1 12 1 12     4.25873 2.32821 0.11051 2.43872 6.69745 0 1.5971 0.5999 0.26701 2.46401 5.54196 2.9183 0.15578 8.71607 11/15/2019 1 1 0 4 1 0 4 11/16/2018 4 4 0 16 1 0 16 2017-09-13 2 0 2 0 8 0 8 8.667 1 0 0 0.00 0 0 5189 HOSPITAL ROAD MARIPOSA, CA 95338 (37.500531, -119.976948) 02/01/2020
2065 2065 708 KEYSER AVENUE NATCHITOCHES, LA 71457 31.753261 -93.074911 0   195213 COURTYARD OF NATCHITOCHES 708 KEYSER AVENUE NATCHITOCHES LA 71457 3182144361 340 Natchitoches Government - Hospital district 108 104.3 Medicare and Medicaid true NATCHITOCHES PARISH HOSPITAL SERVICE DISTRICT 01/30/1987 false   false false false Resident Yes 4   4   2   3   2   3   2       2.39577 0.85952 0.31631 1.17583 3.5716 0.04886 1.91671 0.62651 0.27197 2.81519 2.59779 1.03159 0.43775 4.06824 08/29/2019 2 2 0 16 1 0 16 08/16/2018 0 0 0 0 0 0 0 2017-08-02 3 3 0 1 24 0 24 12 0 0 0 0.00 0 0 708 KEYSER AVENUE NATCHITOCHES, LA 71457 (31.753261, -93.074911) 02/01/2020
4019 4019 510 ROOSEVELT STREET AMERICAN FALLS, ID 83211 42.781858 -112.849047 0   135066 POWER COUNTY NURSING HOME 510 ROOSEVELT STREET (83211-1362) AMERICAN FALLS ID 83211 2082263200 380 Power Government - Hospital district 20 15.9 Medicare and Medicaid true POWER COUNTY HOSPITAL DISTRICT 05/01/1976 false   false false false Resident Yes 4   3   4   4     2 5   5       3.53074 0.95882 1.08995 2.04877 5.57951 0 1.94413 0.62211 0.30482 2.87105 3.77447 1.15892 1.34586 6.23172 09/06/2019 6 6 0 56 2 28 84 05/17/2018 7 7 0 52 1 0 52 2017-01-27 10 10 0 1 52 0 52 68 0 0 0 0.00 0 0 510 ROOSEVELT STREET AMERICAN FALLS, ID 83211 (42.781858, -112.849047) 02/01/2020
5073 5073 535 SOUTH FREEBORN MARION, KS 66861 38.342708 -97.010014 0   17A029 ST LUKE LIVING CENTER 535 SOUTH FREEBORN MARION KS 66861 6203822177 570 Marion Government - Hospital district 32 24.4 Medicaid true Legal Business Name Not Available 03/31/1974 false   false false false Resident Yes 4   3   3   3     2 5   5       3.19202 0.44815 1.26394 1.71209 4.9041 0 2.03563 0.62396 0.24449 2.90408 3.25899 0.54007 1.94579 5.41507 05/01/2019 6 6 0 40 1 0 40 04/19/2018 13 8 5 96 1 0 96 2016-06-22 9 7 2 1 52 0 52 60.667 1 1 0 0.00 0 0 535 SOUTH FREEBORN MARION, KS 66861 (38.342708, -97.010014) 02/01/2020
5568 5568 200 VALLEY VIEW DRIVE PENDER, NE 68047 42.107508 -96.705466 0   285186 LEGACY GARDEN REHABILITATION & LIVING CENTER 200 VALLEY VIEW DRIVE PENDER NE 68047 4023853072 860 Thurston Government - Hospital district 42 33.4 Medicare and Medicaid false PENDER CARE CENTRE DISTRICT INC 05/01/1996 false   false false false Both Yes 4   2   5   5   4   5   5       2.54338 0.22373 0.92483 1.14856 3.69193 0.01263 1.91333 0.58736 0.27685 2.77754 2.76273 0.28642 1.25732 4.26233 10/04/2018 6 6 6 56 1 0 56 07/20/2017 9 9 9 68 1 0 68 2016-07-13 2 2 0 1 36 0 36 56.667 1 0 1 10400.00 1 2 200 VALLEY VIEW DRIVE PENDER, NE 68047 (42.107508, -96.705466) 02/01/2020
6079 6079 735 THIRD STREET SOUTHWEST PERHAM, MN 56573 46.596991 -95.582467 0   245486 PERHAM LIVING 735 THIRD STREET SOUTHWEST PERHAM MN 56573 2183464500 550 Otter Tail Government - Hospital district 96 88.6 Medicare and Medicaid true PERHAM HOSPITAL DISTRICT 07/01/1987 false   false false false Both Yes 4   3   4   4   4   5   5       3.24056 0.65347 1.27111 1.92457 5.16514 0.0561 1.88126 0.64806 0.27099 2.80031 3.58005 0.75821 1.76548 5.91465 06/13/2019 7 7 0 28 1 0 28 08/23/2018 6 6 0 48 1 0 48 2017-06-29 8 8 0 1 40 0 40 36.667 0 0 0 0.00 0 0 735 THIRD STREET SOUTHWEST PERHAM, MN 56573 (46.596991, -95.582467) 02/01/2020
6191 6191 801 E GRANT MEADE, KS 67864 37.287616 -100.331014 0   1.7e+27 MEADE DISTRICT HOSP LTCU DBA LONE TREE RETIREMENT 801 E GRANT MEADE KS 67864 6208732146 590 Meade Government - Hospital district 45 33.2 Medicaid true Legal Business Name Not Available 10/01/1981 false   false false false Resident Yes 4   3   2   2     2 5   5       3.11596 0.24877 1.01194 1.26071 4.37668 0 1.89744 0.63858 0.28254 2.81857 3.41303 0.29293 1.34804 4.97931 01/09/2020 0 0 0 0 0 0 0 01/17/2019 0 0 0 0 0 0 0 2017-08-21 10 3 7 1 368 0 368 61.333 4 0 0 0.00 0 0 801 E GRANT MEADE, KS 67864 (37.287616, -100.331014) 02/01/2020
6194 6194 401 S CHEYENNE STREET SATANTA, KS 67870 37.437411 -100.985626 0   inf SATANTA DISTRICT HOSPITAL LTCU 401 S CHEYENNE STREET, PO BOX 159 SATANTA KS 67870 6206492761 391 Haskell Government - Hospital district 44 29.8 Medicaid true Legal Business Name Not Available 05/01/1976 false   false false false Resident Yes 4   4   1   1     2 5   5       5.20342 0.72476 0.99496 1.71971 6.92313 0.00745 1.92165 0.61301 0.25169 2.78636 5.62768 0.88901 1.48786 7.96744 02/06/2019 0 0 0 0 0 0 0 11/01/2017 2 2 0 36 1 0 36 2015-12-16 10 10 0 1 68 0 68 23.333 0 0 0 0.00 0 0 401 S CHEYENNE STREET SATANTA, KS 67870 (37.437411, -100.985626) 02/01/2020
6257 6257 206 NW 4TH STREET MULLEN, NE 69152 42.04562 -101.043131 0   2.8e+176 PIONEER MEMORIAL COMMUNITY HOSPITAL P O BOX 578, 206 NW 4TH STREET MULLEN NE 69152 3085462217 450 Hooker Government - Hospital district 30 25.6 Medicaid false Legal Business Name Not Available 03/31/1974 false   false false false Resident Yes 4   3   4   4     2 4   4       1.97803 0.6646 0.73741 1.40201 3.38004 0 2.03365 0.66145 0.28174 2.97684 2.02149 0.75552 0.98514 3.64099 04/11/2019 7 7 0 44 1 0 44 06/25/2018 6 6 0 52 1 0 52 2017-08-02 5 4 1 1 32 0 32 44.667 1 0 0 0.00 0 0 206 NW 4TH STREET MULLEN, NE 69152 (42.04562, -101.043131) 02/01/2020
6889 6889 6300 MAIN STREET ZACHARY, LA 70791 30.649957 -91.136747 0   195617 LANE NSG HOME AN AFFILIATE OF LANE REG MEDICAL CTR 6300 MAIN STREET ZACHARY LA 70791 2256584345 160 E. Baton Rouge Government - Hospital district 39 35.3 Medicare and Medicaid true HOSPITAL SERVICE DISTRICT 1 OF EAST BATON ROUGE PARISH 11/21/2004 false   false false false Both Yes 4   4   3   1   5   3   3       2.53011 0.91051 0.40535 1.31585 3.84596 0 1.96298 0.6024 0.26047 2.82585 2.67881 1.13653 0.58572 4.36424 01/11/2019 3 3 0 12 1 0 12 01/11/2018 0 0 0 0 0 0 0 2017-01-26 2 2 0 1 4 0 4 6.667 0 0 0 0.00 0 0 6300 MAIN STREET ZACHARY, LA 70791 (30.649957, -91.136747) 02/01/2020
7022 7022 516 N WILLIAMS ST ANGOLA, IN 46703 41.640437 -84.994588 0   155449 NORTHERN LAKES NURSING AND REHABILITATION CENTER 516 N WILLIAMS ST ANGOLA IN 46703 2606659467 750 Steuben Government - Hospital district 99 87.7 Medicare and Medicaid false PULASKI MEMORIAL HOSPITAL 07/01/1992 false   false false false Resident Yes 4   3   5   4   5   2   2       2.36552 0.761 0.37778 1.13878 3.5043 0.02337 2.09027 0.75028 0.35304 3.19359 2.35201 0.76269 0.40276 3.51864 09/30/2019 2 2 0 8 1 0 8 08/22/2018 5 3 2 32 1 0 32 2017-08-03 8 5 3 1 123 0 123 35.167 3 4 2 31475.00 0 2 516 N WILLIAMS ST ANGOLA, IN 46703 (41.640437, -84.994588) 02/01/2020
7096 7096 777 SOUTH DOUGLAS ROAD PEMBROKE PINES, FL 33025 26.003892 -80.263569 0   105668 MEMORIAL MANOR 777 SOUTH DOUGLAS ROAD PEMBROKE PINES FL 33025 9542766200 50 Broward Government - Hospital district 120 112 Medicare and Medicaid false SOUTH BROWARD HOSPITAL DISTRICT 07/14/1989 false   false false false Resident Yes 4   3   4   4   5   5   5       2.82129 0.59211 1.32102 1.91313 4.73442 0.14933 2.16279 0.77042 0.41175 3.34496 2.71112 0.57791 1.20755 4.53867 07/11/2019 7 7 0 36 1 0 36 06/14/2018 3 3 0 12 1 0 12 2017-05-25 4 4 0 1 40 0 40 28.667 0 0 0 0.00 0 0 777 SOUTH DOUGLAS ROAD PEMBROKE PINES, FL 33025 (26.003892, -80.263569) 02/01/2020
7343 7343 139 NINTH STREET JENA, LA 71342 31.695924 -92.158096 0   195466 LASALLE NURSING HOME 139 NINTH STREET JENA LA 71342 3189926627 290 Lasalle Government - Hospital district 133 71.6 Medicare and Medicaid false HOSPITAL SERVICE DISTRICT # 2 OF LASALLE PARISH 06/30/1998 false   false false false Resident Yes 4   5   1   2   1   3   2       3.00789 1.26104 0.41301 1.67405 4.68194 0.07688 1.92616 0.77834 0.38068 3.08518 3.24554 1.21826 0.40835 4.86629 07/11/2019 0 0 0 0 0 0 0 06/28/2018 0 0 0 0 1 0 0 2017-05-17 1 1 0 1 4 0 4 0.667 0 0 0 0.00 0 0 139 NINTH STREET JENA, LA 71342 (31.695924, -92.158096) 02/01/2020
8303 8303 150 N NEVADA ST WALSH, CO 81090 37.384426 -102.28072 0   06A175 WALSH HEALTHCARE CENTER 150 N NEVADA ST WALSH CO 81090 7193245262 40 Baca Government - Hospital district 30 20.5 Medicaid false Legal Business Name Not Available 07/01/1991 false   false false false Resident Yes 4   5   3   3     2 1 12 1 12     3.50137 1.23597 0.65294 1.88891 5.39028 0 2.04703 0.62451 0.26723 2.93878 3.55491 1.48817 0.91963 5.88163 05/16/2019 4 4 0 16 1 0 16 04/05/2018 3 3 0 12 1 0 12 2016-10-06 2 2 0 1 12 0 12 14 0 0 0 0.00 0 0 150 N NEVADA ST WALSH, CO 81090 (37.384426, -102.28072) 02/01/2020
10403 10403 1038 MCGILL LANE SAINT STEPHEN, SC 29479 33.398011 -79.933413 0   425341 LAKE MOULTRIE NURSING HOME 1038 MCGILL LANE SAINT STEPHEN SC 29479 8435672307 70 Berkeley Government - Hospital district 88 84.9 Medicare and Medicaid false CLARENDON MEMORIAL HOSPITAL 05/01/1995 false   false false false Resident Yes 4   4   4   5   3   4   3       2.67741 0.94218 0.48572 1.42789 4.1053 0.0378 2.07948 0.6035 0.25857 2.94155 2.67594 1.17393 0.70702 4.47531 08/31/2018 6 6 0 20 1 0 20 05/25/2017 4 4 0 16 1 0 16 2016-06-17 3 3 0 1 16 0 16 18 0 0 1 3421.00 0 1 1038 MCGILL LANE SAINT STEPHEN, SC 29479 (33.398011, -79.933413) 02/01/2020
10418 10418 246 HALEY DR CENTER, TX 75935 31.772695 -94.172334 0   675230 PINE GROVE NURSING CENTER 246 HALEY DR CENTER TX 75935 9365986286 890 Shelby Government - Hospital district 120 67.4 Medicare and Medicaid false LIBERTY COUNTY HOSPITAL DISTRICT NO 1 11/01/1993 false   false false false Resident Yes 4   5   4   5   3   1   1       1.85624 1.18663 0.20668 1.39331 3.24955 0.07243 2.10054 0.82538 0.41701 3.34293 1.83662 1.08105 0.18654 3.11709 08/28/2019 3 3 1 32 1 0 32 07/25/2018 0 0 0 0 0 0 0 2017-07-19 1 1 0 1 8 0 8 17.333 1 0 0 0.00 0 0 246 HALEY DR CENTER, TX 75935 (31.772695, -94.172334) 02/01/2020
10487 10487 389 SERPENTINE DRIVE SPARTANBURG, SC 29303 34.966404 -81.93694 0   425384 SPARTANBURG HOSPITAL FOR RESTORATIVE CARE SNF 389 SERPENTINE DRIVE SPARTANBURG SC 29303 8645603265 410 Spartanburg Government - Hospital district 25 12.4 Medicare true SPARTANBURG HOSPITAL FOR RESTORATIVE CARE 03/07/2006 false   true false false Resident Yes 4   2   5     2 5   5   5       2.79881 0.6173 4.3158 4.9331 7.73191 0.47893 1.99646 0.98538 0.5512 3.53304 2.9136 0.47106 2.947 7.01764 03/07/2019 3 0 3 60 0 0 60 04/04/2018 1 1 0 4 1 0 4 2017-02-22 0 0 0 0 0 0 0 31.333 2 0 1 19416.00 0 1 389 SERPENTINE DRIVE SPARTANBURG, SC 29303 (34.966404, -81.93694) 02/01/2020
10763 10763 807 W BOIS D ARC HENRIETTA, TX 76365 33.813129 -98.202979 0   455893 GRACE CARE CENTER OF HENRIETTA 807 W BOIS D ARC HENRIETTA TX 76365 9405384303 291 Clay Government - Hospital district 60 41.1 Medicare and Medicaid false NOCONA HOSPITAL DISTRICT 09/07/1990 false   false false false Resident Yes 4   4   3   3     2 2   2       1.70923 0.94759 0.46887 1.41646 3.12569 0 1.95729 0.70797 0.34893 3.01419 1.81494 1.00644 0.50576 3.32528 07/24/2019 5 5 0 48 1 0 48 08/09/2018 2 2 0 20 1 0 20 2017-08-11 2 2 0 1 16 0 16 33.333 0 0 0 0.00 0 0 807 W BOIS D ARC HENRIETTA, TX 76365 (33.813129, -98.202979) 02/01/2020
10820 10820 2001 SCENIC RD GEORGETOWN, TX 78626 30.625182 -97.687214 0   675727 THE WESLEYAN AT SCENIC 2001 SCENIC RD GEORGETOWN TX 78626 5128639511 970 Williamson Government - Hospital district 184 109.6 Medicare and Medicaid false GUADALUPE COUNTY HOSPITAL BOARD 11/01/1997 false   false false false Resident Yes 4   4   4   5   2   4   3       2.91025 1.16403 0.65643 1.82046 4.73071 0.04576 2.14043 0.78068 0.37619 3.29731 2.82582 1.12118 0.65676 4.60065 08/07/2019 5 5 0 32 1 0 32 08/02/2018 3 2 3 28 1 0 28 2017-06-30 1 1 1 1 8 0 8 26.667 0 0 0 0.00 0 0 2001 SCENIC RD GEORGETOWN, TX 78626 (30.625182, -97.687214) 02/01/2020
10949 10949 127 SECOND AVENUE SOUTHWEST SOAP LAKE, WA 98851 47.387265 -119.492841 0   505390 MCKAY HEALTHCARE & REHAB CTR 127 SECOND AVENUE SOUTHWEST SOAP LAKE WA 98851 5092461111 120 Grant Government - Hospital district 42 34.8 Medicare and Medicaid false PUBLIC HOSPITAL DISTRICT 4 OF GRANT COUNTY 08/01/1991 false   false false false Resident Yes 4   3   4   4     2 4   5       2.31358 0.28292 1.05662 1.33954 3.65311 0 2.11045 0.68665 0.30678 3.10388 2.27837 0.30982 1.29634 3.77408 10/31/2019 11 10 1 64 1 0 64 01/17/2019 16 15 1 84 1 0 84 2018-03-30 14 12 2 1 251 0 251 101.833 3 0 3 45179.00 0 3 127 SECOND AVENUE SOUTHWEST SOAP LAKE, WA 98851 (47.387265, -119.492841) 02/01/2020
11130 11130 1601 NE MUSTANG ANDREWS, TX 79714 32.338742 -102.544896 0   676175 PERMIAN RESIDENTIAL CARE CENTER 1601 NE MUSTANG ANDREWS TX 79714 4324642430 10 Andrews Government - Hospital district 90 64.9 Medicare and Medicaid true ANDREWS COUNTY HOSPITAL DISTRICT 05/23/2008 false   false false false Resident Yes 4   4   4   4   5   3   3       2.79324 1.13591 0.40398 1.53989 4.33313 0.00255 2.30501 0.7141 0.2953 3.31441 2.51855 1.1961 0.51491 4.19226 04/16/2019 2 2 0 16 1 0 16 03/08/2018 5 5 2 48 1 0 48 2017-01-20 6 6 0 1 64 0 64 34.667 0 0 0 0.00 0 0 1601 NE MUSTANG ANDREWS, TX 79714 (32.338742, -102.544896) 02/01/2020
11524 11524 11902 RESOURCE PKWY HOUSTON, TX 77089 29.585839 -95.209096 0   675819 PARK MANOR OF SOUTH BELT 11902 RESOURCE PKWY HOUSTON TX 77089 2819226802 610 Harris Government - Hospital district 120 107.9 Medicare and Medicaid false WINNIE-STOWELL HOSPITAL DISTRICT 01/07/2000 false   false false false Resident Yes 4   3   5   5   5   2   2       1.78399 0.85005 0.3381 1.18815 2.97214 0.04714 2.06809 0.77214 0.36803 3.20825 1.79283 0.82781 0.34578 2.97067 02/15/2019 5 3 2 28 1 0 28 03/09/2018 7 4 3 76 1 0 76 2017-04-06 5 5 0 1 64 0 64 50 0 4 1 8648.00 0 1 11902 RESOURCE PKWY HOUSTON, TX 77089 (29.585839, -95.209096) 02/01/2020
11572 11572 707 S ROLAND ST SPEARMAN, TX 79081 36.190475 -101.200127 0   45F497 HANSFORD MANOR 707 S ROLAND ST SPEARMAN TX 79081 8066595535 591 Hansford Government - Hospital district 64 54.3 Medicaid false Legal Business Name Not Available 04/01/2001 false   false false false Resident Yes 4   5   2   2     2 1 12 1 12     2.21468 0.68072 0.37191 1.05263 3.26731 0 1.98739 0.61297 0.26046 2.86082 2.31603 0.83505 0.53743 3.66229 10/17/2019 2 2 0 12 1 0 12 01/09/2019 5 5 0 28 1 0 28 2018-02-08 3 3 0 1 12 0 12 17.333 0 0 0 0.00 0 0 707 S ROLAND ST SPEARMAN, TX 79081 (36.190475, -101.200127) 02/01/2020
11680 11680 1402 W ELM OLNEY, TX 76374 33.372748 -98.773894 0   455611 GRACE CARE CENTER OF OLNEY 1402 W ELM OLNEY TX 76374 9405645631 981 Young Government - Hospital district 99 43.8 Medicare and Medicaid false OLNEY-HAMILTON HOSPITAL DISTRICT 04/01/1986 false   false false false Resident Yes 4   5   1   2   1   2   1       2.2466 1.30248 0.21196 1.51444 3.76104 0 2.02285 0.76073 0.37174 3.15533 2.30823 1.28742 0.21461 3.82223 08/01/2019 3 3 0 24 1 0 24 09/06/2018 0 0 0 0 0 0 0 2017-09-14 3 2 1 1 8 0 8 13.333 0 1 0 0.00 0 0 1402 W ELM OLNEY, TX 76374 (33.372748, -98.773894) 02/01/2020
11843 11843 305 FIFTH ST FARWELL, TX 79325 34.385446 -103.037643 0   675098 FARWELL CARE AND REHABILITATION CENTER 305 FIFTH ST FARWELL TX 79325 8064819027 844 Parmer Government - Hospital district 75 58.2 Medicare and Medicaid false FARWELL HOSPITAL DISTRICT 11/01/1992 false   false false false Resident Yes 4   3   3   3   4   4   4       2.08338 0.80555 0.66617 1.47172 3.5551 0.00484 2.03415 0.678 0.32316 3.03532 2.12863 0.8934 0.77588 3.75579 05/23/2019 7 6 1 52 1 0 52 07/18/2018 5 5 0 20 1 0 20 2017-06-14 9 5 4 1 116 0 116 52 2 0 2 30905.00 0 2 305 FIFTH ST FARWELL, TX 79325 (34.385446, -103.037643) 02/01/2020
11905 11905 1114 EAST GEORGIA ROAD WOODRUFF, SC 29388 34.750101 -82.017402 0   425179 WOODRUFF MANOR 1114 EAST GEORGIA ROAD WOODRUFF SC 29388 8644767092 410 Spartanburg Government - Hospital district 88 83.3 Medicare and Medicaid false WOODRUFF MANOR 01/05/1990 false   false false false Resident Yes 4   3   3   2   3   4   4       2.14426 0.60782 0.58606 1.19388 3.33813 0.02056 1.97244 0.60892 0.26273 2.84409 2.25938 0.75058 0.83958 3.76369 10/04/2018 8 8 0 44 1 0 44 09/28/2017 4 4 0 32 1 0 32 2016-09-16 14 12 2 1 60 0 60 42.667 0 0 1 13627.00 0 1 1114 EAST GEORGIA ROAD WOODRUFF, SC 29388 (34.750101, -82.017402) 02/01/2020
11917 11917 101 POSEY AVENUE CLIFTON, TX 76634 31.777153 -97.588431 0   45F411 GOODALL WITCHER NURSING FACILITY 101 POSEY AVENUE CLIFTON TX 76634 2546758322 160 Bosque Government - Hospital district 43 29 Medicaid true Legal Business Name Not Available 01/16/1998 false   false false false Resident Yes 4   5   1   1     2 4   4       2.67671 0.85417 0.53834 1.39251 4.06923 0 2.25594 0.62788 0.26354 3.14736 2.46599 1.02295 0.76884 4.1459 08/29/2019 4 4 0 28 1 0 28 07/25/2018 0 0 0 0 0 0 0 2017-08-01 0 0 0 0 0 0 0 14 0 0 0 0.00 0 0 101 POSEY AVENUE CLIFTON, TX 76634 (31.777153, -97.588431) 02/01/2020
11971 11971 103 TEAKWOOD ST CENTERVILLE, TX 75833 31.251578 -95.973091 0   675065 CENTERVILLE HEALTHCARE CENTER 103 TEAKWOOD ST CENTERVILLE TX 75833 9035362596 756 Leon Government - Hospital district 74 34 Medicare and Medicaid false LIBERTY COUNTY HOSPITAL DISTRICT NO 1 06/25/1992 false   false false false Resident Yes 4   3   5   5     2 2   2       1.83023 0.95489 0.44045 1.39535 3.22558 0.03204 1.95013 0.82084 0.42621 3.19718 1.95056 0.87475 0.38896 3.23515 10/23/2019 5 5 0 44 0 0 44 10/17/2018 6 5 1 44 1 0 44 2017-09-22 11 6 5 1 168 0 168 64.667 0 3 1 5200.00 0 1 103 TEAKWOOD ST CENTERVILLE, TX 75833 (31.251578, -95.973091) 02/01/2020
12364 12364 1400 N MAIN ST GIDDINGS, TX 78942 30.194776 -96.934651 0   675101 OAKLAND MANOR NURSING CENTER 1400 N MAIN ST GIDDINGS TX 78942 9795421755 755 Lee Government - Hospital district 102 60.1 Medicare and Medicaid true WINNIE-STOWELL HOSPITAL DISTRICT 10/15/1992 false   false false false Resident Yes 4   5   2   3   1   1   1       1.75555 0.99496 0.13568 1.13064 2.88619 0.01227 1.99076 0.75794 0.38878 3.13749 1.83278 0.98707 0.13135 2.94982 12/05/2018 2 2 0 12 1 0 12 12/06/2017 4 4 0 16 1 0 16 2016-11-30 2 2 0 1 16 0 16 14 0 0 0 0.00 0 0 1400 N MAIN ST GIDDINGS, TX 78942 (30.194776, -96.934651) 02/01/2020
12376 12376 200 NAT WASHINGTON WAY EPHRATA, WA 98823 47.315742 -119.548125 0   50A181 COLUMBIA BASIN HOSPITAL 200 NAT WASHINGTON WAY EPHRATA WA 98823 5097544631 120 Grant Government - Hospital district 12 11 Medicaid true Legal Business Name Not Available 08/11/1975 false   false false false None Yes 4   4   5   5     2 1 12 1 12     4.02333 0.40576 1.49188 1.89764 5.92096 0 2.24289 0.69519 0.25765 3.19573 3.72815 0.43888 2.17941 5.94122 03/06/2019 4 3 1 56 1 0 56 01/11/2018 6 6 0 36 1 0 36 2017-03-24 3 1 2 1 28 0 28 44.667 2 0 0 0.00 0 0 200 NAT WASHINGTON WAY EPHRATA, WA 98823 (47.315742, -119.548125) 02/01/2020
12404 12404 501 N MAIN ST COLLINSVILLE, TX 76233 33.564659 -96.911186 0   675206 HOMESTEAD NURSING AND REHABILITATION OF COLLINSVIL 501 N MAIN ST COLLINSVILLE TX 76233 9034296426 564 Grayson Government - Hospital district 65 34.9 Medicare and Medicaid false JACK COUNTY HOSPITAL DISTRICT 12/06/1993 false   false false false Resident Yes 4   4   4   4     2 2   2       1.48722 0.87765 0.43501 1.31266 2.79988 0.01432 2.01622 0.81419 0.43746 3.26788 1.53304 0.81055 0.37427 2.74743 04/11/2019 2 2 0 4 1 0 4 04/05/2018 7 6 5 52 1 0 52 2017-04-27 7 7 2 1 80 0 80 32.667 1 0 0 0.00 0 0 501 N MAIN ST COLLINSVILLE, TX 76233 (33.564659, -96.911186) 02/01/2020
12710 12710 1012 SOUTH 3RD STREET DAYTON, WA 99328 46.312564 -117.968872 0   505437 BOOKER REST HOME 1012 SOUTH 3RD STREET DAYTON WA 99328 5093823212 60 Columbia Government - Hospital district 34 12.4 Medicare and Medicaid true COLUMBIA COUNTY HOSPITAL DISTRICT 01/01/1992 false   false false false Resident Yes 4   5   4   4     2 1 12 1 12 6 6                             11/14/2019 2 2 0 20 1 0 20 02/05/2019 2 2 0 8 1 0 8 2018-03-27 4 4 0 1 32 0 32 18 0 0 0 0.00 0 0 1012 SOUTH 3RD STREET DAYTON, WA 99328 (46.312564, -117.968872) 02/01/2020
12793 12793 830 ROCKFORD STREET MOUNT AIRY, NC 27030 36.488418 -80.611181 0   345278 NORTHERN REGIONAL HOSPITAL 830 ROCKFORD STREET MOUNT AIRY NC 27030 3367197000 850 Surry Government - Hospital district 33 31.3 Medicare and Medicaid true NORTHERN HOSPITAL DISTRICT OF SURRY COUNTY. 05/25/1988 false   false false false Resident Yes 4   3   3   2   4   4   4       2.3093 0.91417 0.776 1.69017 3.99948 0.01726 2.18556 0.71552 0.3408 3.24188 2.19601 0.96071 0.85702 3.95603 05/23/2019 5 5 0 20 1 0 20 03/15/2018 0 0 0 0 0 0 0 2017-02-10 12 12 0 1 76 0 76 22.667 0 0 0 0.00 0 0 830 ROCKFORD STREET MOUNT AIRY, NC 27030 (36.488418, -80.611181) 02/01/2020
12967 12967 200 E RYAN ST BOERNE, TX 78006 29.796437 -98.731875 0   675678 CARECHOICE OF BOERNE 200 E RYAN ST BOERNE TX 78006 8302492594 731 Kendall Government - Hospital district 74 54.4 Medicare and Medicaid false UVALDE COUNTY HOSPITAL AUTHORITY 04/11/1997 false   false false false Resident Yes 4   3   5   5     2 2   2       1.30591 0.88615 0.38781 1.27397 2.57988 0.05198 2.03383 0.80036 0.43509 3.26929 1.33449 0.83254 0.33549 2.53046 09/27/2019 7 7 0 40 1 0 40 09/28/2018 13 13 4 116 1 0 116 2017-08-03 6 6 0 1 44 0 44 66 0 1 0 0.00 0 0 200 E RYAN ST BOERNE, TX 78006 (29.796437, -98.731875) 02/01/2020
13332 13332 711 ONYX STREET KEMMERER, WY 83101 41.78958 -110.540607 0   53A051 SOUTH LINCOLN NURSING CENTER 711 ONYX STREET KEMMERER WY 83101 3078775717 110 Lincoln Government - Hospital district 24 20.2 Medicaid true Legal Business Name Not Available 07/01/1999 false   false false false Both Yes 4   3   3   3     2 5   5       3.97871 0.67606 1.05336 1.72942 5.70814 0 2.01884 0.66107 0.34098 3.02089 4.09597 0.76899 1.16272 6.05916 11/07/2019 11 11 0 60 0 0 60 01/31/2019 4 4 0 20 1 0 20 2018-01-10 12 12 0 1 92 0 92 52 0 0 0 0.00 0 0 711 ONYX STREET KEMMERER, WY 83101 (41.78958, -110.540607) 02/01/2020
13386 13386 501 N MEDFORD DR LUFKIN, TX 75901 31.341426 -94.691336 0   675962 SOUTHLAND REHABILITATION AND HEALTHCARE CENTER 501 N MEDFORD DR LUFKIN TX 75901 9366391252 20 Angelina Government - Hospital district 150 87.2 Medicare and Medicaid false LIBERTY COUNTY HOSPITAL DISTRICT NO 1 05/06/2003 false   false false false Resident Yes 4   4   5   5   5   1   1       1.93617 0.99593 0.31977 1.3157 3.25187 0.06067 1.9979 0.79664 0.4134 3.20795 2.01412 0.94004 0.29114 3.25056 07/17/2019 4 4 0 20 1 0 20 08/29/2018 3 3 0 16 1 0 16 2017-10-12 2 2 0 1 32 0 32 20.667 0 0 0 0.00 0 0 501 N MEDFORD DR LUFKIN, TX 75901 (31.341426, -94.691336) 02/01/2020
13802 13802 3617 O HARE DR MESQUITE, TX 75150 32.81426 -96.60251 0   676146 TOWN EAST REHABILITATION AND HEALTHCARE CENTER 3617 O'HARE DR MESQUITE TX 75150 9722848600 390 Dallas Government - Hospital district 130 79.7 Medicare and Medicaid false DALLAS COUNTY HOSPITAL DISTRICT 08/22/2007 false   false false false Resident Yes 4   5   4   4   4   1   1       2.05608 1.2992 0.27837 1.57757 3.63365 0.06999 2.1095 0.83798 0.45335 3.40083 2.0257 1.16581 0.23111 3.42619 09/26/2019 2 0 2 20 0 0 20 09/28/2018 4 2 2 24 1 0 24 2017-09-28 0 0 0 0 0 0 0 18 0 5 0 0.00 0 0 3617 O HARE DR MESQUITE, TX 75150 (32.81426, -96.60251) 02/01/2020
13934 13934 212 NW 10TH ST SEMINOLE, TX 79360 32.721958 -102.656213 0   45F414 MEMORIAL HEALTH CARE CENTER 212 NW 10TH ST SEMINOLE TX 79360 4327584877 542 Gaines Government - Hospital district 58 33.8 Medicaid false Legal Business Name Not Available 04/10/1998 false   false false false Resident Yes 4   5   3   3     2 1 12 1 12 6 6                             09/11/2019 1 1 0 8 1 0 8 10/04/2018 3 3 0 20 1 0 20 2017-09-08 3 3 0 1 32 0 32 16 0 0 0 0.00 0 0 212 NW 10TH ST SEMINOLE, TX 79360 (32.721958, -102.656213) 02/01/2020
14260 14260 1005 IRA E WOODS PARKWAY GRAPEVINE, TX 76051 32.93195 -97.087895 0   676104 KINDRED TRANSITIONAL CARE AND REHABILITATION-GRAPE 1005 IRA E. WOODS PARKWAY GRAPEVINE TX 76051 8174211313 910 Tarrant Government - Hospital district 132 89.3 Medicare and Medicaid false DECATUR HOSPITAL AUTHORITY 06/20/2006 false   false false false Resident Yes 4   4   5   5   5   1   1       1.99899 1.18374 0.22904 1.41278 3.41177 0.06452 2.19552 0.89196 0.48119 3.56867 1.89229 0.99792 0.17915 3.06568 06/03/2019 3 1 2 20 1 0 20 06/29/2018 6 6 0 44 1 0 44 2017-06-16 2 0 2 0 16 0 16 27.333 4 0 0 0.00 0 0 1005 IRA E WOODS PARKWAY GRAPEVINE, TX 76051 (32.93195, -97.087895) 02/01/2020
14978 14978 615 PROSPECT AVENUE SPRINGER, NM 87747 36.363506 -104.585853 0   3.2e+33 COLFAX GENERAL LTC 615 PROSPECT AVENUE SPRINGER NM 87747 5754833300 30 Colfax Government - Hospital district 34 26.9 Medicaid false Legal Business Name Not Available 05/01/1980 false   false false false Resident Yes 4   5   2   2     2 1 12 1 12     1.20887 0.21615 0.21079 0.42694 1.63581 0 1.89836 0.61327 0.26745 2.77908 1.32348 0.26502 0.29665 1.8875 06/19/2019 7 7 0 52 1 0 52 04/18/2018 7 7 0 24 1 0 24 2017-02-08 2 2 0 1 12 0 12 36 0 0 0 0.00 0 0 615 PROSPECT AVENUE SPRINGER, NM 87747 (36.363506, -104.585853) 02/01/2020
15134 15134 1907 REFINERY RD GAINESVILLE, TX 76240 33.644421 -97.153451 0   455970 RIVER VALLEY HEALTH & REHABILITATION CENTER 1907 REFINERY RD GAINESVILLE TX 76240 9406650386 340 Cooke Government - Hospital district 116 38.7 Medicare and Medicaid false DALLAS COUNTY HOSPITAL DISTRICT 01/01/1992 false   false false false Resident Yes 4   4   5   3   5   1   1       1.82671 1.10997 0.30706 1.41704 3.24375 0 2.07712 0.80304 0.42351 3.30367 1.82779 1.03934 0.27289 3.1485 10/31/2019 2 2 1 20 1 0 20 10/18/2018 6 5 1 44 1 0 44 2017-11-03 2 2 0 1 16 0 16 27.333 1 1 0 0.00 0 0 1907 REFINERY RD GAINESVILLE, TX 76240 (33.644421, -97.153451) 02/01/2020
15440 15440 575 EAST 1400 SOUTH OREM, UT 84097 40.271489 -111.681473 0   465104 OREM REHABILITATION AND NURSING CENTER 575 EAST 1400 SOUTH OREM UT 84097 8012254741 240 Utah Government - Hospital district 120 71.9 Medicare and Medicaid false BEAVER VALLEY HOSPITAL 09/04/1986 false   false false false Resident Yes 4   3   5   4   5   3   3       2.15064 0.84046 0.68623 1.52669 3.67733 0.15201 2.00533 0.76093 0.36865 3.13491 2.22893 0.83053 0.70063 3.7615 10/25/2018 4 3 1 28 1 0 28 07/13/2017 11 11 10 64 1 0 64 2016-04-28 15 6 9 1 76 0 76 48 0 12 1 11053.00 1 2 575 EAST 1400 SOUTH OREM, UT 84097 (40.271489, -111.681473) 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
);