| Name |
healthcare-facility-state-enforcement-actions |
|---|
| Updated |
2024-08-29 |
|---|
| 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
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-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 |
|
|---|