Version History of Museums in Finland from Museovirasto Data Source
Click here for a data sample
This table contains the version history of the 'paikallismuseot' table extracted from the 'Museovirasto' website in the country 'Finland' (ISO country code: 'fi'). The rows in this table represent different versions of the base table rows, with each row having its corresponding start and end dates. The '_start_date' column indicates the date when a particular version of a row was extracted, while the '_end_date' column shows the date when a new version of the row was extracted. If the '_end_date' value is null, it means that the row is the most recent version. The table also includes other columns such as 'maakunta', 'maakunta_float', 'vastaajia', 'vastaajia_int', and 'vastaajia_float'. The data in this table can be utilized for various data analytics purposes, such as tracking changes in the base table over time, analyzing response counts ('vastaajia'), and studying regional distribution ('maakunta').
Field Descriptions
Name |
Data type |
Description |
_start_date | date | The datetime when the row version becomes valid. |
_end_date | date | The datetime when the row version expires. |
_row_number | long | The sequence number of the 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. |