Version History of Local Museums Data in Finland - Sourced from Museovirasto Website
Click here for a data sample
This table contains the version history of the 'paikallismuseot' base table. It provides information about the extracted rows from the 'paikallismuseot' data source on different dates. The table includes '_start_date' column, which specifies the date when the row was extracted, and '_end_date' column, which indicates the date when a new version of the row was extracted. If the value of '_end_date' is null, it means that the row is the most recent version. The table includes additional columns such as 'maakunta', 'maakuntafloat', 'vastaajia', 'vastaajiaint', and 'vastaajiafloat'. The data in this table can be utilized in various data analytics scenarios. For example, it can be used to track the changes in the 'vastaajia' column over time, compare the responses across different 'maakunta' regions, or analyze the float values in the 'vastaajiafloat' column. The table is sourced from the website of Museovirasto, which originates from Finland (ISO country code 'fi').
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period of the row version. |
|---|
| _end_date | date | The end date of the validity period of the row version. |
|---|
| _row_number | long | The unique identifier for each row version. |
|---|
| maakunta | string | The name of the region. |
|---|
| maakunta__float | float | The floating-point representation of the name of the region. |
|---|
| vastaajia | string | The number of respondents. |
|---|
| vastaajia__int | int | The integer representation of the number of respondents. |
|---|
| vastaajia__float | float | The floating-point representation of the number of respondents. |
|---|
