Collection of Local Museums in Finland (2005)
Tables
-
Local Museums Data from Museovirasto (2005) - FinlandTSV
This table contains data from the 'Museovirasto' website in Finland. It provides information about local museums in different regions of Finland. The table includes columns such as '_extract_date', '_row_number', 'maakunta', 'maakuntafloat', 'vastaajia', 'vastaajiaint', and 'vastaajia__float'. The data in this table can be utilized for data analytics in various ways, such as: Analyzing the number of respondents ('vastaajia') in different regions ('maakunta') to gain insights into the popularity and interest in local museums. Identifying trends in the number of respondents over time by analyzing the '_extract_date' column. Conducting statistical analysis on the numeric columns ('vastaajiaint' and 'vastaajiafloat') to calculate averages, ranges, and other relevant metrics...
-
Version History of Museums in Finland from Museovirasto Data SourceTSV
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...
Column Descriptions
Local Museums Data from Museovirasto (2005) - Finland
Column | Type | Comment |
---|---|---|
_extract_date | date | The date the data was extracted. |
_row_number | long | The row number of the data. |
maakunta | string | The name of the county. |
maakunta__float | float | The name of the county as a floating point number. |
vastaajia | string | The number of respondents. |
vastaajia__int | int | The number of respondents as an integer. |
vastaajia__float | float | The number of respondents as a floating point number. |
Version History of Museums in Finland from Museovirasto Data Source
Column | Type | Comment |
---|---|---|
_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. |
Additional Info
Last Updated | April 26, 2024 |
---|---|
Created | April 21, 2024 |