Historical Versioning of Paavo Statistical Data and Postal Code Areas 2024
The 'History' table is a rich, multi-faceted dataset sourced from the Finnish Statistics Bureau ('Tilastokeskus'), providing a detailed snapshot of demographic and geographic data projected for the year 2024. It offers a comprehensive array of demographic data, including population demographics, income levels, educational attainment, and employment status, among other factors. The data is organized by postal code areas, offering granular insight into various regions.
The table also provides geographic data which can be useful for geospatial data analytics. This geographic information is presented using the WGS 84 coordinate reference system, with longitude preceding latitude. This can enable detailed spatial analysis and mapping, allowing for regional comparisons and trend identification.
The uniqueness of each row in the table is determined by a combination of the '_start_date' and '_row_number'. '_start_date' indicates the extraction date of the data, while '_row_number' identifies the sequence of the row in the raw data. The table also includes a '_end_date' column, recording the date when a new version of a row was added. If the '_end_date' value is null, it signifies that the row is the most recent version.
In terms of analytics, this table could be leveraged in numerous ways. For instance, demographic data could be used to identify population trends, support urban planning, or inform targeted marketing efforts. Geographic data could be used to visualize these trends spatially, or to support geographically-informed decision-making.
The table is a part of a larger dataset collection, reflecting its role in providing comprehensive, nuanced insights into the population and geography of Finland.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This is the date when the row was extracted from the data source. It is part of the combination that uniquely identifies each row in this version history table. |
| _end_date | date | This is the date when a new version of the row was extracted from the data source. If the value of this column is null, it means that the row 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. Together with '_start_date', it forms a combination that uniquely identifies each row in this version history table. |
| euref_x | long | This is a column of type Integer64 that has not been described by the source. |
| euref_y | long | This is a column of type Integer64 that has not been described by the source. |
| geom_geojson | string | This column contains the geometric data of the area in GeoJSON format. |
| geom_geotext | string | This column contains the geometric data of the area in text format. |
| geom_type | string | This column contains the type of geometric data stored in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_centroid | string | This column contains the geometric centroid of the area. |
| geom_center_x | double | This column contains the x-coordinate of the center of the area. |
| geom_center_y | double | This column contains the y-coordinate of the center of the area. |
| gml_id | string | This is a String type column that has not been described by the source. |
| he_0_2 | long | This is an Integer type column that has not been described by the source. |
| he_13_15 | long | This is an Integer type column that has not been described by the source. |
| he_16_17 | long | This is an Integer type column that has not been described by the source. |
| he_18_19 | long | This is an Integer type column that has not been described by the source. |
| he_20_24 | long | This is an Integer type column that has not been described by the source. |
| he_25_29 | long | This is an Integer type column that has not been described by the source. |
| he_30_34 | long | This is an Integer type column that has not been described by the source. |
| he_35_39 | long | This is an Integer type column that has not been described by the source. |
| he_3_6 | long | This is an Integer type column that has not been described by the source. |
| he_40_44 | long | This is an Integer type column that has not been described by the source. |
| he_45_49 | long | This is an Integer type column that has not been described by the source. |
| he_50_54 | long | This is an Integer type column that has not been described by the source. |
| he_55_59 | long | This is an Integer type column that has not been described by the source. |
| he_60_64 | long | This is an Integer type column that has not been described by the source. |
| he_65_69 | long | This is an Integer type column that has not been described by the source. |
| he_70_74 | long | This is an Integer type column that has not been described by the source. |
| he_75_79 | long | This is an Integer type column that has not been described by the source. |
| he_7_12 | long | This is an Integer type column that has not been described by the source. |
| he_80_84 | long | This is an Integer type column that has not been described by the source. |
| he_85_ | long | This is an Integer type column that has not been described by the source. |
| he_kika | long | This is an Integer type column that has not been described by the source. |
| he_miehet | long | This is an Integer type column that has not been described by the source. |
| he_naiset | long | This is an Integer type column that has not been described by the source. |
| he_vakiy | long | This is an Integer type column that has not been described by the source. |
| hr_hy_tul | long | This is an Integer type column that has not been described by the source. |
| hr_ke_tul | long | This is an Integer type column that has not been described by the source. |
| hr_ktu | long | This is an Integer type column that has not been described by the source. |
| hr_mtu | long | This is an Integer type column that has not been described by the source. |
| hr_ovy | long | This is a column of type Integer64 that has not been described by the source. |
| hr_pi_tul | long | This is an Integer type column that has not been described by the source. |
| hr_tuy | long | This is an Integer type column that has not been described by the source. |
| ko_al_kork | long | This is an Integer type column that has not been described by the source. |
| ko_ammat | long | This is an Integer type column that has not been described by the source. |
| ko_ika18y | long | This is an Integer type column that has not been described by the source. |
| ko_koul | long | This is an Integer type column that has not been described by the source. |
| ko_perus | long | This is an Integer type column that has not been described by the source. |
| ko_yl_kork | long | This is an Integer type column that has not been described by the source. |
| ko_yliop | long | This is an Integer type column that has not been described by the source. |
| kunta | string | This is a String type column that has not been described by the source. |
| namn | string | This is a String type column that has not been described by the source. |
| nimi | string | This is a String type column that has not been described by the source. |
| pinta_ala | long | This is a column of type Integer64 that has not been described by the source. |
| postinumeroalue | string | This is a String type column that has not been described by the source. |
| pt_0_14 | long | This is an Integer type column that has not been described by the source. |
| pt_elakel | long | This is an Integer type column that has not been described by the source. |
| pt_muut | long | This is an Integer type column that has not been described by the source. |
| pt_opisk | long | This is an Integer type column that has not been described by the source. |
| pt_tyoll | long | This is an Integer type column that has not been described by the source. |
| pt_tyott | long | This is an Integer type column that has not been described by the source. |
| pt_vakiy | long | This is an Integer type column that has not been described by the source. |
| ra_as_kpa | double | This is a Real type column that has not been described by the source. |
| ra_asrak | long | This is an Integer type column that has not been described by the source. |
| ra_asunn | long | This is an Integer type column that has not been described by the source. |
| ra_ke | long | This is an Integer type column that has not been described by the source. |
| ra_kt_as | long | This is an Integer type column that has not been described by the source. |
| ra_muu_as | long | This is an Integer type column that has not been described by the source. |
| ra_muut | long | This is an Integer type column that has not been described by the source. |
| ra_pt_as | long | This is an Integer type column that has not been described by the source. |
| ra_raky | long | This is an Integer type column that has not been described by the source. |
| te_aik | long | This is an Integer type column that has not been described by the source. |
| te_aklap | long | This is an Integer type column that has not been described by the source. |
| te_as_valj | double | This is a Real type column that has not been described by the source. |
| te_eil_np | long | This is an Integer type column that has not been described by the source. |
| te_elak | long | This is an Integer type column that has not been described by the source. |
| te_klap | long | This is an Integer type column that has not been described by the source. |
| te_laps | long | This is an Integer type column that has not been described by the source. |
| te_muu_as | long | This is an Integer type column that has not been described by the source. |
| te_nuor | long | This is an Integer type column that has not been described by the source. |
| te_omis_as | long | This is an Integer type column that has not been described by the source. |
| te_plap | long | This is an Integer type column that has not been described by the source. |
| te_takk | double | This is a Real type column that has not been described by the source. |
| te_taly | long | This is an Integer type column that has not been described by the source. |
| te_teini | long | This is an Integer type column that has not been described by the source. |
| te_vuok_as | long | This is an Integer type column that has not been described by the source. |
| te_yhlap | long | This is an Integer type column that has not been described by the source. |
| te_yks | long | This is an Integer type column that has not been described by the source. |
| tp_a_maat | long | This is an Integer type column that has not been described by the source. |
| tp_alku_a | long | This is an Integer type column that has not been described by the source. |
| tp_b_kaiv | long | This is an Integer type column that has not been described by the source. |
| tp_c_teol | long | This is an Integer type column that has not been described by the source. |
| tp_d_ener | long | This is an Integer type column that has not been described by the source. |
| tp_e_vesi | long | This is an Integer type column that has not been described by the source. |
| tp_f_rake | long | This is an Integer type column that has not been described by the source. |
| tp_g_kaup | long | This is an Integer type column that has not been described by the source. |
| tp_h_kulj | long | This is an Integer type column that has not been described by the source. |
| tp_i_majo | long | This is an Integer type column that has not been described by the source. |
| tp_j_info | long | This is an Integer type column that has not been described by the source. |
| tp_jalo_bf | long | This is an Integer type column that has not been described by the source. |
| tp_k_raho | long | This is an Integer type column that has not been described by the source. |
| tp_l_kiin | long | This is an Integer type column that has not been described by the source. |
| tp_m_erik | long | This is an Integer type column that has not been described by the source. |
| tp_n_hall | long | This is an Integer type column that has not been described by the source. |
| tp_o_julk | long | This is an Integer type column that has not been described by the source. |
| tp_p_koul | long | This is an Integer type column that has not been described by the source. |
| tp_palv_gu | long | This is an Integer type column that has not been described by the source. |
| tp_q_terv | long | This is an Integer type column that has not been described by the source. |
| tp_r_taid | long | This is an Integer type column that has not been described by the source. |
| tp_s_muup | long | This is an Integer type column that has not been described by the source. |
| tp_t_koti | long | This is an Integer type column that has not been described by the source. |
| tp_tyopy | long | This is an Integer type column that has not been described by the source. |
| tp_u_kans | long | This is an Integer type column that has not been described by the source. |
| tp_x_tunt | long | This is an Integer type column that has not been described by the source. |
| tr_hy_tul | long | This is an Integer type column that has not been described by the source. |
| tr_ke_tul | long | This is an Integer type column that has not been described by the source. |
| tr_ktu | long | This is an Integer type column that has not been described by the source. |
| tr_kuty | long | This is an Integer type column that has not been described by the source. |
| tr_mtu | long | This is an Integer type column that has not been described by the source. |
| tr_ovy | long | This is a column of type Integer64 that has not been described by the source. |
| tr_pi_tul | long | This is an Integer type column that has not been described by the source. |
| vuosi | long | This is an Integer type column that has not been described by the source. |
No sample for this dataset
Additional Information
| Last updated | November 11, 2024 |
|---|---|
| Created | November 11, 2024 |
| License | No License Provided |
| Geographic coverage | |
| Geographic granularity | |
| Temporal coverage from | |
| Temporal coverage to | |
| Temporal coverage to | |
| Country | fi |
| Database | fi_tilastokeskus |
| Extract date | 2024-11-11 |
| Id | 3591b0c5-49ab-47fb-9145-cc3bee5f15eb |
| Package id | fb3a21b1-1057-479b-badc-c770c5afcb57 |
| Position | 1 |
| Revision id | 36c37cd8-4010-47aa-976c-9be5f2254958 |
| State | active |
| Table | postialue_pno_tilasto_2024__table__history |