In collaboration with The Seattle Times, Big Local News is providing full-text nursing home deficiencies from Centers for Medicare & Medicaid Services (CMS). These files contain the full narrative details of each nursing home deficiency cited regulators. The files include deficiencies from Standard Surveys (routine inspections) and from Complaint Surveys. Complete data begins January 2011 (although some earlier inspections do show up). Individual states are provides as CSV files. A very large (4.5GB) national file is also provided as a zipped archive. New data will be updated on a monthly basis. For additional documentation, please see the README.

Data source: Big Local News · About: big-local-datasette

Custom SQL query

cms_AK

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

1,610 rows

cms_AL

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

8,867 rows

cms_AZ

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

7,860 rows

cms_DC

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

2,583 rows

cms_DE

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

5,676 rows

cms_GA

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

10,655 rows

cms_GU

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

107 rows

cms_HI

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

3,005 rows

cms_ID

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

6,401 rows

cms_ME

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

4,239 rows

cms_MS

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

8,794 rows

cms_MT

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

5,734 rows

cms_ND

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

4,626 rows

cms_NE

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

12,996 rows

cms_NH

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

2,308 rows

cms_NM

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

5,698 rows

cms_NV

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

6,037 rows

cms_OR

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

9,387 rows

cms_PR

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

731 rows

cms_RI

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

1,896 rows

cms_SC

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

10,300 rows

cms_SD

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

5,155 rows

cms_TN

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

14,361 rows

cms_UT

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

7,494 rows

cms_VI

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

16 rows

cms_VT

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

2,517 rows

cms_WV

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

11,539 rows

cms_WY

facility_name, facility_id, address, city, state, zip, inspection_date, deficiency_tag, scope_severity...

3,594 rows

Download SQLite DB: CMS-Nursing-Home-Full-Deficiencies.db 719.5 MB