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

29 rows where Long-Stay QM Rating Footnote = 1 and geocode_flag = 1

View and edit SQL

Suggested facets: geocode_accuracy, prvdr_state, prvdr_phn, prvdr_cnty, prvdr_cnty_name, ownership, nmbr_beds, avg_residents, prvdr_type, Legal Business Name, Date First Approved to Provide Medicare and Medicaid services, Continuing Care Retirement Community, With a Resident and Family Council, 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, Rating Cycle 1 Standard Survey Health Date, Number of Facility Reported Incidents, Number of Substantiated Complaints

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
52 3130 S John Duffy Dr, Joplin, MO 64804, USA 37.0563566 -94.5886796 1 RANGE_INTERPOLATED 265877 WESTGATE 3130 JOHN DUFFY DR JOPLIN MO 64804 4175533688 480 Jasper For profit - Limited Liability company 120 26.9 Medicare and Medicaid false 07/16/2019 false   false false false Resident Yes   1   1   1   1   1   1   1     2.78035 1.09527 1.0944 2.18967 4.97002 0.01571 2.03434 0.64967 0.29061 2.97462         07/16/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   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
1396 10250 U.S. Hwy 42, Union, KY 41091, USA 38.9623133 -84.67945929999999 1 RANGE_INTERPOLATED 185486 BOONESPRING TRANSITIONAL CARE CENTER, LLC 10250 US HWY 42 UNION KY 41091 8593841200 70 Boone For profit - Corporation 143 94.5 Medicare and Medicaid false 03/05/2019 false   false false false None Yes   1   1   1   1   1   1   1     2.12726 0.97201 1.0344 2.00642 4.13368 0.11569 2.3011 0.83356 0.40891 3.54357         03/05/2019                 . .             . . . . . . .   1 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
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
3350 400 Winchester Rd, Bernie, MO 63822, USA 36.6656408 -89.98114389999999 1 ROOFTOP 265874 WINCHESTER NURSING CENTER, INC 400 WINCHESTER DR, PO BOX 760 BERNIE MO 63822 5732936702 985 Stoddard For profit - Corporation 40 34.9 Medicare and Medicaid false 01/09/2019 false   false false false None Yes   1   1   1   1   1   1   1     2.2797 0.49897 0.72684 1.22581 3.5055 0.05017 1.98294 0.69796 0.32387 3.00477         01/09/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   02/01/2020
3801 1521 N Pine Cliff Dr, Flagstaff, AZ 86001, USA 35.2072208 -111.6352139 1 ROOFTOP 35296 WELBROOK SENIOR LIVING FLAGSTAFF LLC 1521 NORTH PINE CLIFF DRIVE EAST FLAGSTAFF AZ 86001 9284402350 20 Coconino For profit - Corporation 50 27.9 Medicare false 10/11/2018 false   false false false Resident Yes   1   1   1   1   1   1   1     2.59385 1.35367 1.5853 2.93897 5.53282 0.46782 1.96303 0.96939 0.53901 3.47144         10/04/2018                 . .             . . . . . . .   0 0 0 0.00 0 0   02/01/2020
3806 W Village Cir, Wichita, KS 67205, USA 37.757614 -97.41983 1 GEOMETRIC_CENTER 175563 THE HEALTHCARE RESORT OF WICHITA 7057 WEST VILLAGE CIRCLE WICHITA KS 67205 3169777015 860 Sedgwick For profit - Corporation 70 17.3 Medicare and Medicaid false 05/02/2019 true   false false false Resident Yes   1   1   1   1   1   1   1     4.98718 1.64176 1.66029 3.30205 8.28923 0 2.36944 1.12306 0.60673 4.09922         05/02/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   02/01/2020
4933 2355 Vidina Dr, Melbourne, FL 32940, USA 28.2256546 -80.72861929999999 1 ROOFTOP 106123 VIERA DEL MAR HEALTH AND REHABILITATION CENTER 2355 VIDINA DRIVE VIERA FL 32940 3217756800 40 Brevard For profit - Corporation 131 25.2 Medicare and Medicaid false 05/22/2019 false   false false false None Yes   1   1   1   1   1   1   1     4.19286 3.18952 1.93219 5.12171 9.31458 0.34781 2.33761 1.0947 0.56421 3.99652         05/22/2019                 . .             . . . . . . .   0 0 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
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
7318 800 E County Rd 540A, Lakeland, FL 33813, USA 27.9524791 -81.9469546 1 RANGE_INTERPOLATED 106120 SCOTT LAKE HEALTH AND REHABILITATION CENTER 800 E COUNTY RD 540A LAKELAND FL 33813 8635004015 520 Polk For profit - Corporation 120 70.6 Medicare and Medicaid false 10/16/2018 false   false false false None Yes   1   1   1   1   1   1   1     2.92013 1.01051 0.75447 1.76498 4.68511 0.16209 2.07263 0.78988 0.41457 3.27709         10/16/2018                 . .             . . . . . . .   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
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
8379 6100 Arrowhead Dr, Osage Beach, MO 65065, USA 38.1219085 -92.6953317 1 ROOFTOP 265876 ARROWHEAD SENIOR LIVING COMMUNITY 6100 ARROWHEAD DRIVE OSAGE BEACH MO 65065 5733027111 140 Camden For profit - Limited Liability company 80 21.8 Medicare and Medicaid false 04/12/2019 false   false false false Resident Yes   1   1   1   1   1   1   1     3.17438 0.90225 1.5023 2.40455 5.57892 0.11131 1.94239 0.85191 0.45994 3.25424         04/12/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   02/01/2020
9224 3421 Story Rd W, Irving, TX 75038, USA 32.8715582 -96.9932719 1 ROOFTOP 676464 LAS BRISAS REHABILITATION AND WELLNESS SUITES 3421 W STORY RD IRVING TX 75038 8322854798 390 Dallas For profit - Corporation 128 46.8 Medicare and Medicaid false 03/06/2019 false   false false false None Yes   1   1   1   1   1   1   1     2.26955 1.37879 0.50264 1.88142 4.15098 0.01373 2.18339 0.91783 0.50261 3.60383         03/05/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   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
10158 Eagle Butte, SD 57625, USA 44.9886537 -101.2224805 1 APPROXIMATE 43A138 MEDICINE WHEEL VILLAGE 24266 AIRPORT ROAD PO BOX 880 EAGLE BUTTE SD 57625 6059648155 200 Dewey Non profit - Other 50 22.8 Medicaid false 02/05/2019 false   false false false Resident Yes   1   1   1   1   1   1   1     4.00312 1.3967 1.38696 2.78366 6.78678 0 1.75731 0.62804 0.28224 2.66759         02/05/2019                 . .             . . . . . . .   0 0 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
11747 701 Butler Blvd, Dimmitt, TX 79027, USA 34.5412931 -102.3238318 1 ROOFTOP 676461 CASTRO COUNTY HOSPITAL DISTRICT DBA COUNTRY VIEW L 701 BUTLER BLVD. DIMMITT TX 79027 5124382630 270 Castro Government - Hospital district 40 19.4 Medicare and Medicaid false 04/18/2019 false   false false false Resident Yes   1   1   1   1   1   1   1     4.96221 2.21952 1.06927 3.28879 8.25101 0.0397 1.93451 0.74778 0.38238 3.06467         04/18/2019                 . .             . . . . . . .   0 0 0 0.00 0 0   02/01/2020
12157 5280 SW 157th Ave, Miami, FL 33185, USA 25.7025198 -80.4467755 1 ROOFTOP 686123 KENDALL LAKES HEALTH AND REHABILITATION CENTER 5280 SW 157 AVENUE MIAMI FL 33185 7864337400 120 Miami-Dade For profit - Corporation 150 100.5 Medicare and Medicaid false 05/29/2019 false   false false false Resident Yes   1   1   1   1   1   1   1     2.4198 0.66675 0.56965 1.2364 3.6562 0.13303 2.26796 0.84492 0.39244 3.50532         05/29/2019                 . .             . . . . . . .   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
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
14256 19279 McKay Dr, Humble, TX 77338, USA 29.9975359 -95.2776516 1 ROOFTOP 676463 CRIMSON HEIGHTS HEALTH & WELLNESS 19279 MCKAY DR. HUMBLE TX 77338 5124382630 610 Harris For profit - Corporation 95 44.8 Medicare and Medicaid false 04/17/2019 false   false false false Resident Yes   1   1   1   1   1   1   1     2.48326 1.1354 0.29972 1.43512 3.91838 0.01652 2.07672 0.87031 0.44788 3.3949         04/17/2019                 . .             . . . . . . .   0 2 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
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
15438 4588 Wesley Woods Blvd, New Albany, OH 43054, USA 40.0749599 -82.8526526 1 ROOFTOP 366470 WESLEY WOODS AT NEW ALBANY 4588 WESLEY WOODS BLVD NEW ALBANY OH 43054 6146564100 250 Franklin Non profit - Corporation 16 8.6 Medicare and Medicaid false 02/07/2019 true   false false false None Yes   1   1   1   1   1   1   1     3.39987 1.01072 2.39206 3.40277 6.80265 0.05651 2.27985 0.90782 0.39234 3.58001         02/07/2019                 . .             . . . . . . .   0 1 0 0.00 0 0   02/01/2020

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [nh_gen_info_geocoded_final] (
   [address] TEXT,
   [lat] TEXT,
   [lng] TEXT,
   [geocode_flag] INTEGER,
   [geocode_accuracy] TEXT,
   [prvdr_nmbr] INTEGER,
   [prvdr_nm] TEXT,
   [prvdr_add] TEXT,
   [prvdr_city] TEXT,
   [prvdr_state] TEXT,
   [prvdr_zip] INTEGER,
   [prvdr_phn] INTEGER,
   [prvdr_cnty] INTEGER,
   [prvdr_cnty_name] TEXT,
   [ownership] TEXT,
   [nmbr_beds] INTEGER,
   [avg_residents] TEXT,
   [prvdr_type] TEXT,
   [Provider Resides in Hospital] TEXT,
   [Legal Business Name] TEXT,
   [Date First Approved to Provide Medicare and Medicaid services] TEXT,
   [Continuing Care Retirement Community] TEXT,
   [Special Focus Status] TEXT,
   [Abuse Icon] TEXT,
   [Most Recent Health Inspection More Than 2 Years Ago] TEXT,
   [Provider Changed Ownership in Last 12 Months] TEXT,
   [With a Resident and Family Council] TEXT,
   [Automatic Sprinkler Systems in All Required Areas] TEXT,
   [Overall Rating] INTEGER,
   [Overall Rating Footnote] TEXT,
   [Health Inspection Rating] INTEGER,
   [Health Inspection Rating Footnote] TEXT,
   [QM Rating] INTEGER,
   [QM Rating Footnote] TEXT,
   [Long-Stay QM Rating] TEXT,
   [Long-Stay QM Rating Footnote] TEXT,
   [Short-Stay QM Rating] TEXT,
   [Short-Stay QM Rating Footnote] TEXT,
   [Staffing Rating] TEXT,
   [Staffing Rating Footnote] TEXT,
   [RN Staffing Rating] TEXT,
   [RN Staffing Rating Footnote] TEXT,
   [Reported Staffing Footnote] TEXT,
   [Physical Therapist Staffing Footnote] TEXT,
   [Reported Nurse Aide Staffing Hours per Resident per Day] TEXT,
   [Reported LPN Staffing Hours per Resident per Day] TEXT,
   [Reported RN Staffing Hours per Resident per Day] TEXT,
   [Reported Licensed Staffing Hours per Resident per Day] TEXT,
   [Reported Total Nurse Staffing Hours per Resident per Day] TEXT,
   [Reported Physical Therapist Staffing Hours per Resident Per Day] TEXT,
   [Case-Mix Nurse Aide Staffing Hours per Resident per Day] TEXT,
   [Case-Mix LPN Staffing Hours per Resident per Day] TEXT,
   [Case-Mix RN Staffing Hours per Resident per Day] TEXT,
   [Case-Mix Total Nurse Staffing Hours per Resident per Day] TEXT,
   [Adjusted Nurse Aide Staffing Hours per Resident per Day] TEXT,
   [Adjusted LPN Staffing Hours per Resident per Day] TEXT,
   [Adjusted RN Staffing Hours per Resident per Day] TEXT,
   [Adjusted Total Nurse Staffing Hours per Resident per Day] TEXT,
   [Rating Cycle 1 Standard Survey Health Date] TEXT,
   [Rating Cycle 1 Total Number of Health Deficiencies] INTEGER,
   [Rating Cycle 1 Number of Standard Health Deficiencies] INTEGER,
   [Rating Cycle 1 Number of Complaint Health Deficiencies] INTEGER,
   [Rating Cycle 1 Health Deficiency Score] INTEGER,
   [Rating Cycle 1 Number of Health Revisits] INTEGER,
   [Rating Cycle 1 Health Revisit Score] INTEGER,
   [Rating Cycle 1 Total Health Score] INTEGER,
   [Rating Cycle 2 Standard Health Survey Date] TEXT,
   [Rating Cycle 2 Total Number of Health Deficiencies] INTEGER,
   [Rating Cycle 2 Number of Standard Health Deficiencies] INTEGER,
   [Rating Cycle 2 Number of Complaint Health Deficiencies] INTEGER,
   [Rating Cycle 2 Health Deficiency Score] INTEGER,
   [Rating Cycle 2 Number of Health Revisits] INTEGER,
   [Rating Cycle 2 Health Revisit Score] INTEGER,
   [Rating Cycle 2 Total Health Score] INTEGER,
   [Rating Cycle 3 Standard Health Survey Date] TEXT,
   [Rating Cycle 3 Total Number of Health Deficiencies] INTEGER,
   [Rating Cycle 3 Number of Standard Health Deficiencies] INTEGER,
   [Rating Cycle 3 Number of Complaint Health Deficiencies] INTEGER,
   [Rating Cycle 3 Number of Health Revisits] INTEGER,
   [Rating Cycle 3 Health Deficiency Score] INTEGER,
   [Rating Cycle 3 Health Revisit Score] INTEGER,
   [Rating Cycle 3 Total Health Score] INTEGER,
   [Total Weighted Health Survey Score] TEXT,
   [Number of Facility Reported Incidents] INTEGER,
   [Number of Substantiated Complaints] INTEGER,
   [Number of Fines] INTEGER,
   [Total Amount of Fines in Dollars] TEXT,
   [Number of Payment Denials] INTEGER,
   [Total Number of Penalties] INTEGER,
   [Location] TEXT,
   [Processing Date] TEXT
);