To download the data set, please sign up or log in

Clinics Clients in Services Purchased from Joint Municipal Boards during Year up to 2005 (Sotkanet - Finland)

The dataset collection consists of one table named 'Clinics Clients in Services Purchased from Joint Municipal Boards during Year up to 2005'. This dataset collection is sourced from the website 'Sotkanet' in Finland.

Tables

  • Clinics Clients in Services Purchased from Joint Municipal Boards during Year up to 2005 (Sotkanet - Finland)TSV

    This table contains data on clinics, clients, and services purchased from joint municipal boards during the year up to 2005. The data was extracted from the Sotkanet website, which originates from Finland. The table has 'extract_date' and '_row_number' columns to track the extraction date and row number respectively. The combination of these two columns uniquely identifies each row. The table includes columns such as 'year', 'region', 'gender', 'value_abs', and 'absolute_value'. The 'value_abs' and 'absolute_value' columns contain numeric values related to the purchased services. The table can be utilized in data analytics to analyze the distribution of services based on gender, region, and year. Additionally, the table may include columns with a prefix 'geom' which contain geographic...

  • Clinics Clients in Services Purchased from Joint Municipal Boards during Year up to 2005: Table HistoryTSV

    This table represents the version history of the 'Clinics Clients in Services Purchased from Joint Municipal Boards during Year up to 2005' table. It contains the historical data extracted from the 'Sotkanet' data source, originating from the country Finland (ISO country code: 'fi'). The table includes information about the year, region, gender, absolute value, and other relevant attributes. The 'start_date' column contains the date when each row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row was extracted. The '_row_number' column uniquely identifies each row in the version history. Additionally, this table includes columns starting with 'geom' that contain geographic information in the form of WGS 84 coordinate...

Column Descriptions

Clinics Clients in Services Purchased from Joint Municipal Boards during Year up to 2005 (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 associated with the data entry.
gender string The gender associated with the data entry.
value_abs int The absolute value of the data entry.
absolute_value string The absolute value of the data entry.

Clinics Clients in Services Purchased from Joint Municipal Boards during Year up to 2005: Table History

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 forms a combination that uniquely identifies each row in this version history table
year int The year value associated with the row
region int The region value associated with the row
gender string The gender value associated with the row
value_abs int The absolute value associated with the row
absolute_value string The absolute value associated with the row

Additional Info

Last Updated May 21, 2024
Created May 21, 2024