Benchmark Declarations: Comprehensive Collection of Tables from a Swedish Web Source
Tables
-
Historical Version Records of Base Table DataTSV
The 'sheet_1__history' table is a historical record sourced from 'Lantmäteriet' (The Swedish National Land Survey) in Sweden. It is a specialized table that not only contains the data of its base table but also includes version history of each row. This history is tracked through two additional columns that record the start and end dates of each row's validity. The start date signifies when the row was first extracted from the data source, while the end date indicates when a new version of the row was extracted. If the end date is null, it signifies that the row represents the most recent version of the data. The table incorporates a wide array of columns, each representing different aspects of the data. An interesting attribute of this table is that each row is uniquely identified by a...
-
Swedish Geological and Industrial Material Extraction DataTSV
The table 'sheet_1' is part of a larger dataset collection, sourced from the website of Lantmäteriet (The Land Survey) in Sweden. It is a structured set of data, organized in rows and columns, each with specific information. Two special columns in the table help to uniquely identify each data entry: one contains the date the data was extracted, and the other contains the row number of the extracted data. The rest of the columns contain a variety of information, including different types of materials and substances. The data in the table could be used in a variety of ways in data analytics. For example, one could track changes in the data over time by comparing the extraction dates. This could be useful for identifying trends or patterns. Additionally, the data could be used to analyze...
Column Descriptions
Swedish Geological and Industrial Material Extraction Data
Column | Type | Comment |
---|---|---|
_extract_date | date | This column contains the date when the data on the row of the table was extracted from the source. This date is crucial to understanding when the data was recorded. |
_row_number | long | This column contains the row number in the data extracted from the source on the extract date. This row number in combination with the extract date uniquely identifies each row in the table. |
vo | int | This column contains data pertaining to the variable 'vo'. Further context would be needed to provide a more precise description. |
grus__sand | int | This column contains data pertaining to the variable 'grus__sand'. Further context would be needed to provide a more precise description. |
berg | int | This column contains data pertaining to the variable 'berg'. Further context would be needed to provide a more precise description. |
moran | int | This column contains data pertaining to the variable 'moran'. Further context would be needed to provide a more precise description. |
alunrodfyr | int | This column contains data pertaining to the variable 'alunrodfyr'. Further context would be needed to provide a more precise description. |
industrileror | int | This column contains data pertaining to the variable 'industrileror'. Further context would be needed to provide a more precise description. |
kalkstenskrossdolomit | int | This column contains data pertaining to the variable 'kalkstenskrossdolomit'. Further context would be needed to provide a more precise description. |
kalksten | int | This column contains data pertaining to the variable 'kalksten'. Further context would be needed to provide a more precise description. |
kvartsit | int | This column contains data pertaining to the variable 'kvartsit'. Further context would be needed to provide a more precise description. |
marmor | int | This column contains data pertaining to the variable 'marmor'. Further context would be needed to provide a more precise description. |
gra_granit | int | This column contains data pertaining to the variable 'gra_granit'. Further context would be needed to provide a more precise description. |
rod_granit | int | This column contains data pertaining to the variable 'rod_granit'. Further context would be needed to provide a more precise description. |
ovrig_granit | int | This column contains data pertaining to the variable 'ovrig_granit'. Further context would be needed to provide a more precise description. |
skiffer | int | This column contains data pertaining to the variable 'skiffer'. Further context would be needed to provide a more precise description. |
svart_granit | float | This column contains data pertaining to the variable 'svart_granit'. Further context would be needed to provide a more precise description. |
sandsten | int | This column contains data pertaining to the variable 'sandsten'. Further context would be needed to provide a more precise description. |
taljsten | float | This column contains data pertaining to the variable 'taljsten'. Further context would be needed to provide a more precise description. |
pegmatitfaltspat | int | This column contains data pertaining to the variable 'pegmatitfaltspat'. Further context would be needed to provide a more precise description. |
energitorv | int | This column contains data pertaining to the variable 'energitorv'. Further context would be needed to provide a more precise description. |
stro__vaxttorv | int | This column contains data pertaining to the variable 'stro__vaxttorv'. Further context would be needed to provide a more precise description. |
Historical Version Records of Base Table Data
Column | Type | Comment |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source. This column, together with '_row_number', forms a unique identifier for each row in this history table. |
_end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value in this column is null, it means that the row is the most recent version. |
_row_number | long | This column contains the number of the row as it appears in the raw data extracted from the data source. This column, when combined with '_start_date', forms a unique identifier for each row in this history table. |
vo | int | This column contains data related to the 'vo' field in the base table. |
grus__sand | int | This column contains data related to the 'grus__sand' field in the base table. |
berg | int | This column contains data related to the 'berg' field in the base table. |
moran | int | This column contains data related to the 'moran' field in the base table. |
alunrodfyr | int | This column contains data related to the 'alunrodfyr' field in the base table. |
industrileror | int | This column contains data related to the 'industrileror' field in the base table. |
kalkstenskrossdolomit | int | This column contains data related to the 'kalkstenskrossdolomit' field in the base table. |
kalksten | int | This column contains data related to the 'kalksten' field in the base table. |
kvartsit | int | This column contains data related to the 'kvartsit' field in the base table. |
marmor | int | This column contains data related to the 'marmor' field in the base table. |
gra_granit | int | This column contains data related to the 'gra_granit' field in the base table. |
rod_granit | int | This column contains data related to the 'rod_granit' field in the base table. |
ovrig_granit | int | This column contains data related to the 'ovrig_granit' field in the base table. |
skiffer | int | This column contains data related to the 'skiffer' field in the base table. |
svart_granit | float | This column contains data related to the 'svart_granit' field in the base table. |
sandsten | int | This column contains data related to the 'sandsten' field in the base table. |
taljsten | float | This column contains data related to the 'taljsten' field in the base table. |
pegmatitfaltspat | int | This column contains data related to the 'pegmatitfaltspat' field in the base table. |
energitorv | int | This column contains data related to the 'energitorv' field in the base table. |
stro__vaxttorv | int | This column contains data related to the 'stro__vaxttorv' field in the base table. |
Additional Info
Last Updated | September 13, 2024 |
---|---|
Created | August 27, 2024 |