Version History of Child Guidance and Family Counselling Clients per 1000 Persons Under 18 in Services Funded by the Municipality during the Year - Finland
Click here for a data sample
This table represents the version history of the 'child_guidance_and_family_counselling_clients_per_1000_persons_under_18_in_services_funded_by_the_municipality_during_year__table'. It contains the historical data sourced from 'Sotkanet', a data source from Finland. The table consists of rows that have been extracted from the data source, each uniquely identified by the combination of '_start_date' and '_row_number'. In addition to the columns included in the base table, this version history table has two additional columns: '_start_date' and '_end_date'. The '_start_date' represents the date when a row was extracted, and the '_end_date' represents the date when a new version of the row was extracted. If a row has a null value in the '_end_date' column, it indicates that the row represents the most recent version of the data. The table can be utilized for various data analytics purposes, such as tracking changes in the number of child guidance and family counselling clients per 1000 persons under 18 in services funded by the municipality over time. Other potential analyses could include examining trends by year, region, gender, and assessing the absolute value and value per 1000 of these services.
Field Descriptions
Name |
Data type |
Description |
_start_date | date | The date when the row was extracted from the data source. |
_end_date | date | The date when a new version of the row was extracted from the data source. If null, it means that the row is the most recent version. |
_row_number | long | The number of the row in the raw data extracted from the data source. |
year | int | The year of the data recorded. |
region | int | The region where the data was recorded. |
gender | string | The gender of the individual recorded. |
value_per1000 | int | The value per 1000 for the specific metric recorded. |
absolute_value | int | The absolute value for the specific metric recorded. |