Home

Dataset:

Name	healthcare-facility-state-enforcement-actions
Updated	2024-08-29
CA Dataset	link
Current	True
Tables	health_facilities_state_enforcement_actions_1997_2023_data_file     facid - varchar(9) facility_name - varchar(75) ltc - varchar(7) fac_type_code - varchar(9) fac_fdr - varchar(44) district_office - varchar(24) penalty_issue_date - varchar(19) penalty_number - varchar(9) disposition - varchar(6) penalty_type - varchar(25) penalty_detail - varchar(56) penalty_category - varchar(57) penalty_category_other - varchar(25) violation_from_date - varchar(19) violation_to_date - varchar(19) appealed - varchar(3) appeal_due_date - varchar(19) appeal_received_date - varchar(19) class_assessed_initial - varchar(9) class_assessed_final - varchar(20) total_amount_initial - varchar(8) total_amount_due_final - varchar(8) total_penalty_offset_amount - varchar(9) total_collected_amount - varchar(8) total_balance_due - varchar(8) aclaims_visit_number - varchar(9) eventid - varchar(6) death_related - varchar(1) intakeid_all - varchar(430) priority_all - varchar(106) sfy - varchar(10) lookup_table_health_facility_state_enforcement_actions     variable - varchar(38) description - varchar(70) value - varchar(212) definition - varchar(1728) ltc_citation_narratives_2012_2017_data_file     facid - varchar(9) facility_name - varchar(75) penalty_number - varchar(14) class_assessed_initial - varchar(22) penalty_issue_date - varchar(18) eventid - varchar(7) narrative_length - varchar(16) narrative - text
Sources	about-health-facilities-state-enforcement-actions.pdf  -    data-dictionary-health-facilities-state-enforcement-actions.xlsx  -    data-dictionary-ltc-citation-narratives.xlsx  -    e-citation-access-db-how-to-docs.pdf  -    hospital-administrative-penalties-visuals.pdf  -    long-term-care-health-facilities-visuals.pdf  -    ltc-e-citations-access-database-template.accdb  -    medical-breach-penalties-visuals.pdf  -    datapackage.json  -    health-facilities-state-enforcement-actions-1997-2023-data-file.xlsx  -  Table: health_facilities_state_enforcement_actions_1997_2023_data_file   Updated: 2025-10-13 lookup-table-health-facility-state-enforcement-actions.xlsx  -  Table: lookup_table_health_facility_state_enforcement_actions   Updated: 2025-10-13 ltc-citation-narratives-2012-2017-data-file.csv  -  Table: ltc_citation_narratives_2012_2017_data_file   Fails: 17
Updated