Version History of Museovirasto Web Data from Finland
Click here for a data sample
This table contains the version history of rows from the 'Museovirasto' website, which is sourced from the country 'Finland'. It is derived from the base table 'paikallismuseot_2015_verkko2_xlsxvastanneet'. The table includes the '_start_date' column, which represents the date when each row was extracted from the data source, and the '_end_date' column, which indicates the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it signifies that the corresponding row is the most recent version. In addition to the version history columns, the table also consists of '_row_number', 'maakunta', 'maakuntafloat', and 'lukumaara' columns. The data stored in this table can be utilized in various data analytics scenarios, such as trend analysis of the 'lukumaara' (number) field over time, comparing different versions of rows for changes in the 'maakunta' (region) information, or performing statistical calculations on the 'maakunta__float' (region float) column, among others.
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 | A unique identifier for each row version. |
maakunta | string | The name of the maakunta. |
maakunta__float | float | The floating-point representation of the maakunta. |
lukumaara | float | The number of occurrences. |