Number of children and young people involved in concern reports.
Distribution/Table | Path/Column |
Child Protection Reporting - Base Data Asset | CHILDSTORY_ID |
CONTACT_START_DATE |
A percentage of unique/individual children and young people involved in concern reports, divided by the population of individuals aged 0 -17.
Number of children and young people involved in concern reports.
Distribution/Table | Path/Column |
Child Protection Reporting - Base Data Asset | CHILDSTORY_ID |
CONTACT_START_DATE |
Population of individuals aged 0-17
A percentage calculated by dividing the number of unique/individual children and young people involved in concern reports, by the population of individuals aged 0-17, during the reporting period, multiplied by 100.
By LGA and DCJ district
Demographic Breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
Child Protection Reporting - Base Data Asset | DITRICT_COMMON | District |
Data is sourced from ChildStory/CIW (not from KiDS) - Published by the NSW Department of Family and Community Services - from financial year 2018 onwards.
A percentage calculated by dividing the number of unique/individual children and young people involved in concern reports, by the population of individuals aged 0-17, during the reporting period, multiplied by 100.
Number of children and young people involved in concern reports.
Distribution/Table | Path/Column |
Child Protection Reporting - Base Data Asset | CHILDSTORY_ID |
CONTACT_START_DATE |
DISTINCT CHILDSTORY_ID
Where CONTACT_START_DATE is derived from data in the Federated Analytics Platform, which is built on data from ChildStory/CIW, relevant to a particular ETL run date period:
FinancialYearReporting:
extract(MONTH from ETL_RUN_DT)=9
AND (contact_start_date between Date_SUB(DATE_SUB(Date(etl_run_dt), INTERVAL 1 YEAR), interval 2 MONTH) and DATE_SUB(DATE_SUB(DATE(ETL_RUN_DT), INTERVAL 2 MONTH), INTERVAL 1 DAY))
ETL_RUN date '9' is selected to ensure, with 2 months aging, that all submitted data for the financial year is included in the calculation - eg by selecting 9 (September), all records up to the end of June are included (ie all data between 1 July and 30 June)
Population of individuals aged 0-17
By LGA and DCJ district
Demographic Breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
Child Protection Reporting - Base Data Asset | DITRICT_COMMON | District |
Data Source:
Data limitations:
Relation | Count |
---|---|
Indicator Sets that include this Indicator | 0 |
Data Sets that are used in this Indicator | 1 |