Version History of Child Guidance and Family Counselling Clinics Clients in Services Funded by the Municipality During Year (Sotkanet - Finland)
Click here for a data sample
This table, 'child_guidance_and_family_counselling_clinics_clients_in_services_funded_by_the_municipality_during_yeartablehistory', represents the version history of the base table rows. It contains information about the clients in child guidance and family counselling clinics who received services funded by the municipality during a specific year. The data in the table includes the year of the service, the region where the service was provided, the gender of the client, and the absolute value of a certain metric related to the service. The column '_start_date' indicates the date when the specific row was extracted from the data source, while '_end_date' indicates the date when a newer version of the row was extracted. If the '_end_date' is null, it means the row represents the most recent version. The table is sourced from the 'Sotkanet' website, which is a data source originating from Finland (ISO country code: 'fi'). The table provides valuable data for various data analysis tasks, such as examining trends in client usage of child guidance and family counselling services over time, comparing the utilization of services between different regions, analyzing gender-based patterns in service utilization, and exploring the absolute values of specific metrics associated with the services provided.
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 value of the data. |
region | int | The region where the data belongs to. |
gender | string | The gender of the subject of the data. |
value_abs | int | The absolute value of the data. |
absolute_value | string | An alternative representation of the absolute value of the data. |