Clinics Clients in Services Funded by the Municipality during Year (from Sotkanet - Finland)

The dataset collection contains information about the number of clients using services in clinics funded by the municipality during a specific year. The data is sourced from the web site of Sotkanet in Finland.

Tables

A Clinics Clients In Services Funded By The Municipality During YearTSV
The indicator gives the number of clients in A-clinics during the year. Each person is counted only once in the number of clients during the year, irrespective of how many times he or she has been registered as a client. The data have been collected from 1997 onwards so as to describe the municipality's own provision, sale and purchase of services. Data includes services produced by the municipality and services purchased from other municipalities, joint municipal authorities, the central government, or private service providers. 1. "Municipal services" are services produced in units owned by the municipality.2. "Services sold" are services (cf. previous section) sold to other municipalities, for example.3. "Services purchased from public bodies" are services purchased from...
Clinics Clients in Services Funded by the Municipality during Year (from Sotkanet - Finland)TSV
This table contains data on clinics and clients in services funded by the municipality during the specified year. The data is sourced from the 'Sotkanet' website, which originates from Finland (ISO country code 'fi'). The table has two special columns: 'extract_date' and '_row_number'. The '_extract_date' column contains the date when the data on the row was extracted from the data source, while the '_row_number' column contains the row number in the extracted data. The combination of '_extract_date' and '_row_number' uniquely identifies each row. The table includes columns such as 'year', 'region', 'gender', 'value_abs', and 'absolute_value'. The values in the 'year' column represent the specific year the data corresponds to. The 'region' column denotes the geographical region related...
Version History of Clinics' Clients in Services Funded by the Municipality During Year - Sotkanet, FinlandTSV
This table contains the version history of the base table 'Clinics Clients in Services Funded by the Municipality During Year', sourced from the website 'Sotkanet' in Finland. The table includes information about clinics' clients in services funded by the municipality, such as the year, region, gender, absolute value, and other relevant data. The column 'start_date' represents the extraction date of the row, while the column '_end_date' indicates the date when a newer version of the row was extracted. The column '_row_number' uniquely identifies each row in the table. Some columns starting with 'geom' contain geographic information, specifically geographic coordinates using the WGS 84 coordinate reference system. This table provides valuable data for various data analytics tasks, such...

Column Descriptions

A Clinics Clients In Services Funded By The Municipality During Year

Column	Type	Comment
year	int	Observation year. Column year has 9513 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1997 and maximum value is 2016.
region	int	Sotkanet region code (Municipality, sub-region, region, area for the regional state administrative agency, major region, Mainland Finland/Åland, hospital district, university hospital special responsibility area, whole country). Column region has 9513 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 955.
gender	string	gender total. Column gender has 9513 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: total.
value_abs	int	Absolute number. Column value_abs has 9513 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 47602.
absolute_value	string	Absolute value. Column is empty.
orig_extractdate	string	The date when the data was originally fetched from the source.

Clinics Clients in Services Funded by the Municipality during Year (from Sotkanet - Finland)

Column	Type	Comment
_extract_date	date	The date when the data on the row of the table was extracted from the data source
_row_number	long	The row number in the data extracted from the source on the extract date specified by the column '_extract_date'
year	int	The year of the data entry
region	int	The region where the data belongs to
gender	string	The gender of the data entry
value_abs	int	The absolute value of the data entry
absolute_value	string	The absolute value of the data entry

Version History of Clinics' Clients in Services Funded by the Municipality During Year - Sotkanet, Finland

Column	Type	Comment
_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 the value is 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. Together with _start_date, it uniquely identifies each row in this version history table.
year	int	The year value of the data in the row.
region	int	The region to which the data in the row belongs.
gender	string	The gender to which the data in the row corresponds.
value_abs	int	The absolute value of the data in the row.
absolute_value	string	An alternative name for value_abs. Represents the absolute value of the data in the row.

Additional Info

Last Updated	May 21, 2024
Created	March 7, 2019