11 tp -- Cars by seats, 2014-2018

Tables

Dim region, Statfin mkan pxt 11tp px, Full historyTSV
Dimension Region (Maakunta)
Dim region, Statfin mkan pxt 11tp px, LatestTSV
Dimension Region (Maakunta)
Dim seats, Statfin mkan pxt 11tp px, Full historyTSV
Dimension Seats (Istumapaikkoja)
Dim seats, Statfin mkan pxt 11tp px, LatestTSV
Dimension Seats (Istumapaikkoja)
Dim traffic use, Statfin mkan pxt 11tp px, Full historyTSV
Dimension Traffic_use (Liikennekäyttö)
Dim traffic use, Statfin mkan pxt 11tp px, LatestTSV
Dimension Traffic_use (Liikennekäyttö)
Dim vehicle class, Statfin mkan pxt 11tp px, Full historyTSV
Dimension Vehicle_class (Ajoneuvoluokka)
Dim vehicle class, Statfin mkan pxt 11tp px, LatestTSV
Dimension Vehicle_class (Ajoneuvoluokka)
Dim year, Statfin mkan pxt 11tp px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin mkan pxt 11tp px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin mkan pxt 11tp px, Full historyTSV
Cars by seats by Region, Vehicle class, Seats, Traffic use, Year and Information
Fact, Statfin mkan pxt 11tp px, LatestTSV
Cars by seats by Region, Vehicle class, Seats, Traffic use, Year and Information

Column Descriptions

Dim region, Statfin mkan pxt 11tp 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.

Dim region, Statfin mkan pxt 11tp 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 seats, Statfin mkan pxt 11tp px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 25 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 65.
label	int	The label for the dimension value. Column label has 25 rows, out of which 15 are empty, making the null percent 60.00. Minimum value is 1 and maximum value is 24.

Dim year, Statfin mkan pxt 11tp px, Latest

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

Dim year, Statfin mkan pxt 11tp px, Full history

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

Dim traffic use, Statfin mkan pxt 11tp px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 2.
label	string	The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Decommissioned from traff... and first 25 characters of maximum string: Number of all vehicles re...

Dim traffic use, Statfin mkan pxt 11tp px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 2.
label	string	The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Decommissioned from traff... and first 25 characters of maximum string: Number of all vehicles re...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim vehicle class, Statfin mkan pxt 11tp px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 5 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 5.
label	string	The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ...Buses and maximum string is ...Coaches.

Dim vehicle class, Statfin mkan pxt 11tp px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 5 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 5.
label	string	The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ...Buses and maximum string is ...Coaches.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfin mkan pxt 11tp px, Latest

Column	Type	Comment
region	string	Region of domicile of vehicles . Column region has 39375 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.
vehicle_class	int	Vehicle class . Column vehicle_class has 39375 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 5.
seats	int	Number of seats . Column seats has 39375 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 65.
traffic_use	int	Datasource did not contain a description for Traffic_use. Column traffic_use has 39375 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 2.
year	int	Datasource did not contain a description for Year. Column year has 39375 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2014 and maximum value is 2018.
number_of_the_vehicles	int	Number of the vehicles . Column number_of_the_vehicles has 39375 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 3470507.

Fact, Statfin mkan pxt 11tp px, Full history

Column	Type	Comment
region	string	Region of domicile of vehicles . Column region has 39375 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.
vehicle_class	int	Vehicle class . Column vehicle_class has 39375 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 5.
seats	int	Number of seats . Column seats has 39375 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 65.
traffic_use	int	Datasource did not contain a description for Traffic_use. Column traffic_use has 39375 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 2.
year	int	Datasource did not contain a description for Year. Column year has 39375 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2014 and maximum value is 2018.
number_of_the_vehicles	int	Number of the vehicles . Column number_of_the_vehicles has 39375 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 3470507.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim seats, Statfin mkan pxt 11tp px, Full history

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

Additional Info

Last Updated	July 22, 2019
Created	July 18, 2019