Clinics Clients in Services Purchased from Joint Municipal Boards during Year up to 2005: Table History
Click here for a data sample
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 reference system, first latitude, followed by longitude. The data within this table can be utilized in various data analytics tasks such as trend analysis, geographical visualization, and demographic studies.
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 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 |
|---|
