Loading dataset
Back to data
Updated

124 MB across 84 parts, newest sealed 14 September 2026 at 19:06 UTC.

The last refresh rewrote 84 parts and added 424,706 rows.

ONE_ROW_PER_FACILITY_PER_RELEASE passed.

OPERATOR_PRESENT passed.

ENROLLMENT_MOSTLY_MATCHED failed.

OWNERS_MOSTLY_MATCHED failed.

RN_HOURS_PLAUSIBLE passed.

TOTAL_HOURS_PLAUSIBLE passed.

TURNOVER_PLAUSIBLE passed.

TOP_OWNER_PCT_PLAUSIBLE passed.

ALL_FACILITIES_PRESENT passed.

ccn

string

The CMS certification number of the facility.

  • 01A1930%
  • 01A2080%
  • 04A2930%
  • Other (17,891)
Valid
1,269,396 · 100%
Missing
0 · 0%
Distinct
17,903 · 1.4% of valid

observed_date

date

The UTC day this release of the CMS files was acquired on; one partition per refresh day.

  • 2019-03-091%
  • 2019-02-091%
  • 2019-01-171%
  • Other (72)
Valid
1,269,396 · 100%
Missing
0 · 0%
Distinct
84 · 0% of valid

facility_name

string

The facility name on Care Compare.

  • MILLER'S MERRY MANOR0%
  • PARKVIEW CARE CENTER0%
  • LITTLE SISTERS OF THE POOR0%
  • Other (27,650)
Valid
1,269,396 · 100%
Missing
0 · 0%
Distinct
27,662 · 2.2% of valid

state

string

The facility state.

  • TX8%
  • CA8%
  • OH6%
  • Other (41)
Valid
1,269,396 · 100%
Missing
0 · 0%
Distinct
53 · 0% of valid

city

string

The facility city.

  • CHICAGO1%
  • LOS ANGELES1%
  • CINCINNATI0%
  • Other (7,135)
Valid
1,269,396 · 100%
Missing
0 · 0%
Distinct
7,147 · 0.6% of valid

address

string

The facility street address.

  • N2665 CTY RD QQ0%
  • 1 HEALTHY WAY0%
  • 1001 E 11TH ST N0%
  • Other (21,293)
Valid
1,269,396 · 100%
Missing
0 · 0%
Distinct
21,305 · 1.7% of valid

zip_code

string

The facility ZIP code.

  • 945410%
  • 116910%
  • 630170%
  • Other (10,149)
Valid
1,269,396 · 100%
Missing
0 · 0%
Distinct
10,161 · 0.8% of valid

county

string

The facility county or parish.

  • Los Angeles2%
  • Cook1%
  • Jefferson1%
  • Other (1,716)
Valid
1,269,396 · 100%
Missing
0 · 0%
Distinct
1,728 · 0.1% of valid

latitude

decimal

Facility latitude in decimal degrees.

  • 40.7702000%
  • 32.9120000%
  • 40.6022000%
  • Other (15,862)
Valid
488,236 · 38.5%
Missing
781,160 · 61.5%
Distinct
15,874 · 3.3% of valid
Min
13.462000
25%
34.189300
Median
39.044300
75%
41.507200
Max
66.895300

longitude

decimal

Facility longitude in decimal degrees.

  • -118.1500000%
  • -118.2700000%
  • -118.3100000%
  • Other (13,353)
Valid
488,236 · 38.5%
Missing
781,160 · 61.5%
Distinct
13,365 · 2.7% of valid
Min
-165.390000
25%
-96.615000
Median
-87.730000
75%
-80.923000
Max
144.797000

certified_beds

integer

The number of certified beds.

Histogram: 0 to 173.625, 1,139,121; 173.625 to 347.25, 121,990; 347.25 to 520.875, 6,216; 520.875 to 694.5, 1,312; 694.5 to 868.125, 610; 868.125 to 1041.75, 45; 1041.75 to 1215.375, 0; 1215.375 to 1389, 33
01389
Valid
1,269,327 · 100%
Missing
69 · 0%
Distinct
420 · 0% of valid
Min
0
25%
65
Median
99
75%
127
Max
1389

average_residents_per_day

decimal

The average daily census over the staffing reporting quarter.

  • 55.300%
  • 55.800%
  • 56.300%
  • Other (4,343)
Valid
1,262,628 · 99.5%
Missing
6,768 · 0.5%
Distinct
4,355 · 0.3% of valid
Min
1.00
25%
48.70
Median
73.60
75%
101.70
Max
753.10

ownership_type

string

The CMS ownership category, such as For profit - Corporation or Non profit - Church related.

  • For profit - Corporation45%
  • Non profit - Corporation17%
  • For profit - Limited Liability company17%
  • Other (1)
Valid
1,269,389 · 100%
Missing
7 · 0%
Distinct
13 · 0% of valid

provider_type

string

Whether the facility is certified for Medicare, Medicaid or both.

  • Medicare and Medicaid94%
  • Medicare4%
  • Medicaid2%
Valid
1,269,396 · 100%
Missing
0 · 0%
Distinct
3 · 0% of valid

first_approved_date

date

The day the facility was first approved for Medicare and Medicaid.

  • 1967-01-013%
  • 1990-07-011%
  • 1992-01-010%
  • Other (7,393)
Valid
1,269,396 · 100%
Missing
0 · 0%
Distinct
7,405 · 0.6% of valid

operator

string

The operator: the affiliated entity CMS assigns from owners and managers shared across facilities, or the legal business name where the facility belongs to no chain.

  • THE ENSIGN GROUP1%
  • GENESIS HEALTHCARE1%
  • LIFE CARE CENTERS OF AMERICA1%
  • Other (24,293)
Valid
1,269,396 · 100%
Missing
0 · 0%
Distinct
24,305 · 1.9% of valid

chain_name

string

The affiliated entity name from Care Compare, empty for an unaffiliated facility.

  • THE ENSIGN GROUP3%
  • GENESIS HEALTHCARE2%
  • LIFE CARE CENTERS OF AMERICA2%
  • Other (862)
Valid
348,310 · 27.4%
Missing
921,086 · 72.6%
Distinct
874 · 0.3% of valid

chain_id

string

The CMS identifier of the affiliated entity.

  • 5073%
  • 2372%
  • 3112%
  • Other (883)
Valid
348,310 · 27.4%
Missing
921,086 · 72.6%
Distinct
895 · 0.3% of valid

facilities_in_chain

integer

How many facilities CMS counts in the same affiliated entity, 1 for an unaffiliated facility.

Histogram: 1 to 44.125, 1,224,577; 44.125 to 87.25, 18,954; 87.25 to 130.375, 11,309; 130.375 to 173.5, 1,920; 173.5 to 216.625, 5,481; 216.625 to 259.75, 990; 259.75 to 302.875, 1,919; 302.875 to 346, 4,246
1346
Valid
1,269,396 · 100%
Missing
0 · 0%
Distinct
140 · 0% of valid
Min
1
25%
1
Median
1
75%
1
Max
346

legal_business_name

string

The legal business name of the enrolled organisation.

  • THE EVANGELICAL LUTHERAN GOOD SAMARITAN SOCIETY1%
  • THE HEALTH AND HOSPITAL CORPORATION OF MARION COUNTY1%
  • WEST WHARTON COUNTY HOSPITAL DISTRICT0%
  • Other (19,405)
Valid
1,213,221 · 95.6%
Missing
56,175 · 4.4%
Distinct
19,417 · 1.6% of valid

enrollment_id

string

The PECOS enrollment identifier of the facility.

  • O200208010000000%
  • O200208050000040%
  • O200208140000070%
  • Other (14,203)
Valid
14,215 · 1.1%
Missing
1,255,181 · 98.9%
Distinct
14,215 · 100% of valid

npi

string

The National Provider Identifier the facility bills under.

  • 17705906890%
  • 13664399860%
  • 10030005140%
  • Other (14,200)
Valid
14,215 · 1.1%
Missing
1,255,181 · 98.9%
Distinct
14,212 · 100% of valid

is_for_profit

boolean

True for a for-profit enrollment, false for a non-profit one.

  • true69%
  • false31%
Valid
14,032 · 1.1%
Missing
1,255,364 · 98.9%
Distinct
2 · 0% of valid

owner_count

integer

How many distinct owners, officers and managers PECOS lists for the facility.

Histogram: 1 to 21.875, 11,789; 21.875 to 42.75, 2,194; 42.75 to 63.625, 184; 63.625 to 84.5, 36; 84.5 to 105.375, 5; 105.375 to 126.25, 4; 126.25 to 147.125, 2; 147.125 to 168, 1
1168
Valid
14,215 · 1.1%
Missing
1,255,181 · 98.9%
Distinct
90 · 0.6% of valid
Min
1
25%
7
Median
11
75%
18
Max
168

organization_owner_count

integer

How many of those are organisations rather than individuals.

Histogram: 0 to 12.75, 12,678; 12.75 to 25.5, 1,453; 25.5 to 38.25, 70; 38.25 to 51, 11; 51 to 63.75, 1; 63.75 to 76.5, 0; 76.5 to 89.25, 0; 89.25 to 102, 2
0102
Valid
14,215 · 1.1%
Missing
1,255,181 · 98.9%
Distinct
45 · 0.3% of valid
Min
0
25%
1
Median
4
75%
7
Max
102

chain_home_office

string

The owner PECOS flags as the chain home office, the most direct operator link CMS records.

  • LIFE CARE CENTERS OF AMERICA, INC.7%
  • GENESIS HEALTHCARE LLC6%
  • TRILOGY MANAGEMENT SERVICES LLC3%
  • Other (289)
Valid
2,127 · 0.2%
Missing
1,267,269 · 99.8%
Distinct
301 · 14.2% of valid

management_company

string

The owner PECOS flags as a management services company.

  • LIFE CARE CENTERS OF AMERICA, INC.4%
  • TRILOGY MANAGEMENT SERVICES LLC2%
  • AMERICAN SENIOR COMMUNITIES LLC2%
  • Other (1,118)
Valid
3,703 · 0.3%
Missing
1,265,693 · 99.7%
Distinct
1,130 · 30.5% of valid

top_owner

string

The owner holding the largest direct ownership percentage.

  • THE ENSIGN GROUP INC1%
  • PROVIDENCE GROUP NH, LLC1%
  • LIFE CARE CENTERS OF AMERICA, INC.1%
  • Other (6,429)
Valid
13,574 · 1.1%
Missing
1,255,822 · 98.9%
Distinct
6,441 · 47.5% of valid

top_owner_percentage

decimal

The largest direct ownership percentage held, in percent.

  • 100.0081%
  • 50.003%
  • 0.003%
  • Other (357)
Valid
13,598 · 1.1%
Missing
1,255,798 · 98.9%
Distinct
369 · 2.7% of valid
Min
0.00
25%
100.00
Median
100.00
75%
100.00
Max
100.00

has_private_equity_owner

boolean

True when any owner is flagged as a private equity company.

  • false99%
  • true1%
Valid
12,731 · 1%
Missing
1,256,665 · 99%
Distinct
2 · 0% of valid

has_reit_owner

boolean

True when any owner is flagged as a real estate investment trust.

  • false95%
  • true5%
Valid
12,731 · 1%
Missing
1,256,665 · 99%
Distinct
2 · 0% of valid

newest_owner_since

date

The most recent date any owner, officer or manager relationship began.

  • 2025-01-012%
  • 2024-04-151%
  • 2024-01-011%
  • Other (2,277)
Valid
14,215 · 1.1%
Missing
1,255,181 · 98.9%
Distinct
2,289 · 16.1% of valid

changed_ownership_last_12_months

boolean

True when Care Compare records a change of ownership in the twelve months before the release.

  • false98%
  • true2%
Valid
1,269,396 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

last_transfer_date

date

The effective date of the most recent change of ownership since 2016, null if none.

  • 2017-04-012%
  • 2022-04-012%
  • 2019-07-012%
  • Other (710)
Valid
266,914 · 21%
Missing
1,002,482 · 79%
Distinct
722 · 0.3% of valid

last_transfer_type

string

The kind of the most recent transfer: change of ownership, acquisition or merger, or consolidation.

  • CHANGE OF OWNERSHIP100%
  • ACQUISITION/MERGER0%
Valid
266,914 · 21%
Missing
1,002,482 · 79%
Distinct
2 · 0% of valid

last_transfer_buyer

string

The legal name of the buyer in the most recent transfer.

  • WEST WHARTON COUNTY HOSPITAL DISTRICT2%
  • HAMILTON COUNTY HOSPITAL DISTRICT1%
  • WINNIE-STOWELL HOSPITAL DISTRICT1%
  • Other (4,435)
Valid
266,914 · 21%
Missing
1,002,482 · 79%
Distinct
4,447 · 1.7% of valid

last_transfer_seller

string

The legal name of the seller in the most recent transfer.

  • THE EVANGELICAL LUTHERAN GOOD SAMARITAN SOCIETY1%
  • CITY OF PAULS VALLEY1%
  • LIFE CARE CENTERS OF AMERICA, INC.1%
  • Other (4,648)
Valid
266,914 · 21%
Missing
1,002,482 · 79%
Distinct
4,660 · 1.7% of valid

transfers_since_2016

integer

How many changes of ownership CMS recorded for the facility since 1 January 2016.

Histogram: 0 to 0.6666666666666666, 1,002,482; 0.6666666666666666 to 1.3333333333333333, 266,890; 1.3333333333333333 to 2, 24
02
Valid
1,269,396 · 100%
Missing
0 · 0%
Distinct
3 · 0% of valid
Min
0
25%
0
Median
0
75%
0
Max
2

transfers_last_24_months

integer

How many of those took effect in the twenty-four months before the release.

Histogram: 0 to 0.5, 1,174,329; 0.5 to 1, 95,067
01
Valid
1,269,396 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid
Min
0
25%
0
Median
0
75%
0
Max
1

rn_hours_per_resident_day

decimal

Reported registered nurse hours per resident per day.

  • 0.000000%
  • 0.383670%
  • 0.538040%
  • Other (131,169)
Valid
1,226,249 · 96.6%
Missing
43,147 · 3.4%
Distinct
131,181 · 10.7% of valid
Min
0.00000
25%
0.40409
Median
0.57910
75%
0.81925
Max
11.06985

lpn_hours_per_resident_day

decimal

Reported licensed practical nurse hours per resident per day.

  • 0.000000%
  • 0.741030%
  • 0.885760%
  • Other (134,038)
Valid
1,226,249 · 96.6%
Missing
43,147 · 3.4%
Distinct
134,050 · 10.9% of valid
Min
0.00000
25%
0.65624
Median
0.86747
75%
1.07361
Max
6.79494

aide_hours_per_resident_day

decimal

Reported nurse aide hours per resident per day.

  • 0.000000%
  • 1.951440%
  • 1.799240%
  • Other (179,483)
Valid
1,226,249 · 96.6%
Missing
43,147 · 3.4%
Distinct
179,495 · 14.6% of valid
Min
0.00000
25%
1.91354
Median
2.20481
75%
2.56909
Max
13.74131

total_nurse_hours_per_resident_day

decimal

Reported total nurse staffing hours per resident per day.

  • 3.529480%
  • 3.792480%
  • 3.278370%
  • Other (221,509)
Valid
1,226,249 · 96.6%
Missing
43,147 · 3.4%
Distinct
221,521 · 18.1% of valid
Min
0.00118
25%
3.28210
Median
3.68599
75%
4.21523
Max
17.78707

weekend_total_nurse_hours_per_resident_day

decimal

Reported total nurse staffing hours per resident per day on weekends.

  • 2.864210%
  • 2.841030%
  • 2.908460%
  • Other (161,286)
Valid
737,391 · 58.1%
Missing
532,005 · 41.9%
Distinct
161,298 · 21.9% of valid
Min
0.00218
25%
2.83075
Median
3.19020
75%
3.66807
Max
16.02606

weekend_rn_hours_per_resident_day

decimal

Reported registered nurse hours per resident per day on weekends.

  • 0.000000%
  • 0.250000%
  • 0.500000%
  • Other (89,179)
Valid
737,391 · 58.1%
Missing
532,005 · 41.9%
Distinct
89,191 · 12.1% of valid
Min
0.00000
25%
0.24528
Median
0.37027
75%
0.55293
Max
11.19196

adjusted_rn_hours_per_resident_day

decimal

Case-mix adjusted registered nurse hours per resident per day.

  • 0.000000%
  • 0.384740%
  • 0.480800%
  • Other (137,605)
Valid
1,221,659 · 96.2%
Missing
47,737 · 3.8%
Distinct
137,617 · 11.3% of valid
Min
0.00000
25%
0.40587
Median
0.59303
75%
0.86945
Max
16.06062

adjusted_total_nurse_hours_per_resident_day

decimal

Case-mix adjusted total nurse staffing hours per resident per day.

  • 3.447560%
  • 4.042510%
  • 3.784800%
  • Other (231,701)
Valid
1,221,659 · 96.2%
Missing
47,737 · 3.8%
Distinct
231,713 · 19% of valid
Min
0.00125
25%
3.26695
Median
3.73899
75%
4.31823
Max
18.14315

rn_turnover_pct

decimal

Share of registered nurses who left over the prior year, in percent.

  • 50.07%
  • 33.35%
  • 66.73%
  • Other (795)
Valid
618,242 · 48.7%
Missing
651,154 · 51.3%
Distinct
807 · 0.1% of valid
Min
0.0
25%
33.3
Median
46.2
75%
62.5
Max
100.0

total_nursing_turnover_pct

decimal

Share of all nursing staff who left over the prior year, in percent.

  • 50.02%
  • 33.31%
  • 40.01%
  • Other (944)
Valid
666,884 · 52.5%
Missing
602,512 · 47.5%
Distinct
956 · 0.1% of valid
Min
0.0
25%
39.5
Median
49.6
75%
60.2
Max
100.0

administrators_left

integer

How many administrators left the facility over the prior year.

Histogram: 0 to 6.5, 603,199; 6.5 to 13, 1,563; 13 to 19.5, 216; 19.5 to 26, 41; 26 to 32.5, 33; 32.5 to 39, 0; 39 to 45.5, 3; 45.5 to 52, 12
052
Valid
605,067 · 47.7%
Missing
664,329 · 52.3%
Distinct
36 · 0% of valid
Min
0
25%
0
Median
0
75%
1
Max
52

staffing_footnote

string

The CMS footnote code explaining a suppressed or unusual staffing figure.

  • 681%
  • 258%
  • 236%
Valid
43,148 · 3.4%
Missing
1,226,248 · 96.6%
Distinct
5 · 0% of valid

turnover_footnote

string

The CMS footnote code explaining a suppressed turnover figure.

  • 680%
  • 2618%
  • 272%
Valid
93,878 · 7.4%
Missing
1,175,518 · 92.6%
Distinct
3 · 0% of valid

staffing_rating

integer

The staffing star rating, one to five.

Histogram: 1 to 1.8, 236,967; 1.8 to 2.6, 274,124; 2.6 to 3.4000000000000004, 306,250; 3.4000000000000004 to 4.2, 273,518; 4.2 to 5, 147,761
15
Valid
1,238,620 · 97.6%
Missing
30,776 · 2.4%
Distinct
5 · 0% of valid
Min
1
25%
2
Median
3
75%
4
Max
5

overall_rating

integer

The Care Compare overall star rating, one to five.

Histogram: 1 to 1.8, 245,135; 1.8 to 2.6, 254,069; 2.6 to 3.4000000000000004, 238,212; 3.4000000000000004 to 4.2, 247,780; 4.2 to 5, 269,250
15
Valid
1,254,446 · 98.8%
Missing
14,950 · 1.2%
Distinct
5 · 0% of valid
Min
1
25%
2
Median
3
75%
4
Max
5

health_inspection_rating

integer

The health inspection star rating, one to five.

Histogram: 1 to 1.8, 244,370; 1.8 to 2.6, 305,366; 2.6 to 3.4000000000000004, 284,032; 3.4000000000000004 to 4.2, 290,189; 4.2 to 5, 130,489
15
Valid
1,254,446 · 98.8%
Missing
14,950 · 1.2%
Distinct
5 · 0% of valid
Min
1
25%
2
Median
3
75%
4
Max
5

qm_rating

integer

The quality measure star rating, one to five.

Histogram: 1 to 1.8, 86,715; 1.8 to 2.6, 181,100; 2.6 to 3.4000000000000004, 261,267; 3.4000000000000004 to 4.2, 323,087; 4.2 to 5, 396,560
15
Valid
1,248,729 · 98.4%
Missing
20,667 · 1.6%
Distinct
5 · 0% of valid
Min
1
25%
3
Median
4
75%
5
Max
5

special_focus_status

string

The Special Focus Facility status, empty for a facility not in the programme.

  • N69%
  • SFF Candidate26%
  • SFF5%
Valid
134,461 · 10.6%
Missing
1,134,935 · 89.4%
Distinct
4 · 0% of valid

abuse_icon

boolean

True when Care Compare shows the abuse icon for the facility.

  • false93%
  • true7%
Valid
1,129,478 · 89%
Missing
139,918 · 11%
Distinct
2 · 0% of valid

number_of_fines

integer

How many civil money penalties CMS imposed in the reporting window.

Histogram: 0 to 13.75, 1,260,689; 13.75 to 27.5, 6,989; 27.5 to 41.25, 1,138; 41.25 to 55, 386; 55 to 68.75, 87; 68.75 to 82.5, 67; 82.5 to 96.25, 24; 96.25 to 110, 16
0110
Valid
1,269,396 · 100%
Missing
0 · 0%
Distinct
104 · 0% of valid
Min
0
25%
0
Median
1
75%
2
Max
110

total_fines_dollars

decimal

The total amount of civil money penalties, in US dollars.

  • 0.0049%
  • 650.002%
  • 3250.001%
  • Other (76,801)
Valid
1,269,390 · 100%
Missing
6 · 0%
Distinct
76,813 · 6.1% of valid
Min
0.00
25%
0.00
Median
650.00
75%
19817.50
Max
2105570.61

previous_release_date

date

The release date of the facility's previous reading, null on its first.

  • 2019-02-091%
  • 2019-01-171%
  • 2019-03-091%
  • Other (71)
Valid
1,251,493 · 98.6%
Missing
17,903 · 1.4%
Distinct
83 · 0% of valid

operator_changed

boolean

True when the operator name differs from the facility's previous reading.

  • false98%
  • true2%
Valid
1,269,396 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

rn_turnover_change_pts

decimal

RN turnover minus the previous reading's, in percentage points; null where either is missing.

  • 0.069%
  • -10.00%
  • -7.10%
  • Other (1,153)
Valid
595,493 · 46.9%
Missing
673,903 · 53.1%
Distinct
1,165 · 0.2% of valid
Min
-100.0
25%
0.0
Median
0.0
75%
0.0
Max
100.0

total_nurse_hours_change

decimal

Total nurse hours per resident day minus the previous reading's.

  • 0.0000067%
  • 0.018680%
  • -0.041200%
  • Other (123,511)
Valid
1,200,867 · 94.6%
Missing
68,529 · 5.4%
Distinct
123,523 · 10.3% of valid
Min
-10.07463
25%
0.00000
Median
0.00000
75%
0.00000
Max
10.23400