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

001 -- First registrations of vehicles, monthly 1999 to 2018

001 -- First registrations of vehicles, monthly 1999 to 2018

Tables

Column Descriptions

Fact, Statfinpas merek pxt 001 201809 px, Latest

Column Type Comment
vehicle_class int Vehicle class . Column vehicle_class has 92820 rows, out of which 5460 are empty, making the null percent 5.88. Minimum value is 0 and maximum value is 17.
region string Region of domicile of vehicles . Column region has 92820 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MA1 and maximum string is MKUU.
year int Datasource did not contain a description for Year. Column year has 92820 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1999 and maximum value is 2018.
month int Datasource did not contain a description for Month. Column month has 92820 rows, out of which 7140 are empty, making the null percent 7.69. Minimum value is 1 and maximum value is 12.
first_registrations_of_vehicles int Datasource did not contain a description for First_registrations_of_vehicles. Column first_registrations_of_vehicles has 92820 rows, out of which 23456 are empty, making the null percent 25.27. Minimum value is 1 and maximum value is 264309.

Dim month, Statfinpas merek pxt 001 201809 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 13 rows, out of which 1 are empty, making the null percent 7.69. Minimum value is 1 and maximum value is 12.
label string The label for the dimension value. Column label has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is April and maximum string is Months total.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfinpas merek pxt 001 201809 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1999 and maximum value is 2018.
label int The label for the dimension value. Column label has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1999 and maximum value is 2018.
orig_extractdate string The date when the data was originally fetched from the source.

Dim region, Statfinpas merek pxt 001 201809 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MA1 and maximum string is MKUU.
label string The label for the dimension value. Column label has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Central Finland and maximum string is Foreign countries.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas merek pxt 001 201809 px, Full history

Column Type Comment
vehicle_class int Vehicle class . Column vehicle_class has 92820 rows, out of which 5460 are empty, making the null percent 5.88. Minimum value is 0 and maximum value is 17.
region string Region of domicile of vehicles . Column region has 92820 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MA1 and maximum string is MKUU.
year int Datasource did not contain a description for Year. Column year has 92820 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1999 and maximum value is 2018.
month int Datasource did not contain a description for Month. Column month has 92820 rows, out of which 7140 are empty, making the null percent 7.69. Minimum value is 1 and maximum value is 12.
first_registrations_of_vehicles int Datasource did not contain a description for First_registrations_of_vehicles. Column first_registrations_of_vehicles has 92820 rows, out of which 23456 are empty, making the null percent 25.27. Minimum value is 1 and maximum value is 264309.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vehicle class, Statfinpas merek pxt 001 201809 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 17 rows, out of which 1 are empty, making the null percent 5.88. Minimum value is 0 and maximum value is 17.
label string The label for the dimension value. Column label has 17 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is All automobiles and maximum string is Other trailers total.
orig_extractdate string The date when the data was originally fetched from the source.

Dim region, Statfinpas merek pxt 001 201809 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MA1 and maximum string is MKUU.
label string The label for the dimension value. Column label has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Central Finland and maximum string is Foreign countries.

Dim year, Statfinpas merek pxt 001 201809 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1999 and maximum value is 2018.
label int The label for the dimension value. Column label has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1999 and maximum value is 2018.

Dim vehicle class, Statfinpas merek pxt 001 201809 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 17 rows, out of which 1 are empty, making the null percent 5.88. Minimum value is 0 and maximum value is 17.
label string The label for the dimension value. Column label has 17 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is All automobiles and maximum string is Other trailers total.

Dim month, Statfinpas merek pxt 001 201809 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 13 rows, out of which 1 are empty, making the null percent 7.69. Minimum value is 1 and maximum value is 12.
label string The label for the dimension value. Column label has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is April and maximum string is Months total.

Additional Info

Last Updated September 20, 2019
Created August 5, 2019