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 - None
data-dictionary-health-facilities-state-enforcement-actions.xlsx - None
data-dictionary-ltc-citation-narratives.xlsx - None
e-citation-access-db-how-to-docs.pdf - None
hospital-administrative-penalties-visuals.pdf - None
long-term-care-health-facilities-visuals.pdf - None
ltc-e-citations-access-database-template.accdb - None
medical-breach-penalties-visuals.pdf - None
datapackage.json - None
health-facilities-state-enforcement-actions-1997-2023-data-file.xlsx - health_facilities_state_enforcement_actions_1997_2023_data_file
lookup-table-health-facility-state-enforcement-actions.xlsx - lookup_table_health_facility_state_enforcement_actions
ltc-citation-narratives-2012-2017-data-file.csv - ltc_citation_narratives_2012_2017_data_file
Updates
2025-07-11 17:51:13      None
2025-02-02 17:58:47      0
2025-01-31 16:08:21      0
2025-01-16 17:46:06      0
2025-01-16 17:45:39      0
2025-01-16 17:32:58      0
2025-01-16 17:32:30      0
2024-12-31 18:14:52      0
2024-12-31 18:12:43      0
2024-12-28 23:41:37      0
2024-12-28 23:37:50      1
2024-12-28 21:44:01      1
2024-11-15 15:37:43      None
2024-09-18 12:59:50      None
2024-09-09 15:47:40      None
2024-09-09 13:36:37      None
2024-09-08 21:25:28      None
2024-09-08 21:25:08      None