To download the data set, please sign up or log in

Sotkanet regions

Sotkanet regions

Tables

Column Descriptions

Regions, Regions

Column Type Comment
id int Internal Sotkanet region id. Column id has 521 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 1061.
code int Authorative code for the region. Column code has 521 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 992.
category string Category of the region. Column category has 521 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ALUEHALLINTOVIRASTO and maximum string is SUURALUE.
title_en string English name for the region. Column title_en has 521 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Åland.
title_fi string Finnish name for the region. Column title_fi has 521 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ahvenanmaa... and first 25 characters of maximum string: Pohjois- ja Itä-Suomen su...
title_sv string Swedish name for the region. Column title_sv has 521 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Åland.
orig_extractdate string The date when the data was originally fetched from the source.

Hierarchy, Regions

Column Type Comment
id int Internal Sotkanet region id. Column id has 3183 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 1041.
parent_id int Internal Sotkanet region id of the parent. Column parent_id has 3183 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 488 and maximum value is 1033.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 12, 2019
Created March 5, 2019