aft19_industri_riktvardeangivelser_xls
Tables
-
Historical Version Record of Industrial Benchmark StatementsTSV
The 'History' table is a part of a larger dataset collection, and it primarily serves to keep a record of the version history of its base table rows. This table is distinguished by two additional columns that are not found in its base table. These columns help in tracking the version history of each row. One of these columns contains the date when the row was extracted from the data source, whereas the other column contains the date when the row was updated with a new version. Notably, a null value in the 'end date' column signifies that the current row is the most recent version. In addition to these, there's a unique identifier for each row in this version history table, which is a combination of the start date and the row number extracted from the raw data. Other columns provide...
-
Industry Standard Value Declarations OverviewTSV
The table, sourced from Lantmäteriet (The Land Survey) of Sweden, is a collection of industrially relevant data. It consists of various columns that contain unique and valuable information. Each row of the table is distinctive and identified by the specific date of data extraction along with the row number from the original data source. This combination of extraction date and row number makes each entry unique. This table includes key data such as the unique identification number, name, reference value, and age of investment. The presence of this information makes the table quite useful in various analytical scenarios. For instance, organizations could use this data to track industry trends over time by analyzing the reference value and age of investments. Furthermore, the data could...
Column Descriptions
Industry Standard Value Declarations Overview
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. The data source is the website of 'Lantmäteriet' (The Land Survey) in Sweden. |
_row_number | long | This column contains the row number in the data extracted from the source. The extract date is specified by the '_extract_date' column. Together, these two columns uniquely identify each row. |
vonummer | int | This column contains the 'vonummer' attribute of the data. The specific details of 'vonummer' are based on the context of the dataset. |
namn | string | This column contains the 'namn' attribute of the data. The specific details of 'namn' are based on the context of the dataset. |
riktvarde | int | This column contains the 'riktvarde' attribute of the data. The specific details of 'riktvarde' are based on the context of the dataset. |
iniva | float | This column contains the 'iniva' attribute of the data. The specific details of 'iniva' are based on the context of the dataset. |
aldersinv | int | This column contains the 'aldersinv' attribute of the data. The specific details of 'aldersinv' are based on the context of the dataset. |
Historical Version Record of Industrial Benchmark Statements
Column | Type | Comment |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source. It forms a unique identifier for each row in the version history table, in combination with the '_row_number' column. |
_end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value is null, it indicates that this is the most recent version of the row. |
_row_number | long | This column contains the number of the row in the raw data extracted from the data source. It forms a unique identifier for each row in the version history table, in combination with the '_start_date' column. |
vonummer | int | This column contains data specific to the base table from which the history table is derived. |
namn | string | This column contains data specific to the base table from which the history table is derived. |
riktvarde | int | This column contains data specific to the base table from which the history table is derived. |
iniva | float | This column contains data specific to the base table from which the history table is derived. |
aldersinv | int | This column contains data specific to the base table from which the history table is derived. |
Additional Info
Last Updated | September 13, 2024 |
---|---|
Created | August 27, 2024 |