Domestic patent applications by region in Finland 1990-2013

Tables

Dim applicant, T020 pat tau 102 px, Full historyTSV
Dimension Applicant (Hakija)
Dim applicant, T020 pat tau 102 px, LatestTSV
Dimension Applicant (Hakija)
Dim ipcsection, T020 pat tau 102 px, Full historyTSV
Dimension IPCsection (IPC-lohko)
Dim ipcsection, T020 pat tau 102 px, LatestTSV
Dimension IPCsection (IPC-lohko)
Dim region subregional unit, T020 pat tau 102 px, Full historyTSV
Dimension Region_Subregional_unit (Maakunta)
Dim region subregional unit, T020 pat tau 102 px, LatestTSV
Dimension Region_Subregional_unit (Maakunta)
Dim year, T020 pat tau 102 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, T020 pat tau 102 px, LatestTSV
Dimension Year (Vuosi)
Fact, T020 pat tau 102 px, Full historyTSV
Domestic patent applications by region in Finland by Year, Region - Sub-regional unit, Applicant and IPC-section
Fact, T020 pat tau 102 px, LatestTSV
Domestic patent applications by region in Finland by Year, Region - Sub-regional unit, Applicant and IPC-section

Column Descriptions

Fact, T020 pat tau 102 px, Full history

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 66096 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1990 and maximum value is 2013.
region_subregional_unit	int	Datasource did not contain a description for Region_Subregional_unit. Column region_subregional_unit has 66096 rows, out of which 3240 are empty, making the null percent 4.90. Minimum value is 1 and maximum value is 999.
applicant	string	Datasource did not contain a description for Applicant. Column applicant has 66096 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 and maximum string is 2.
ipcsection	string	Datasource did not contain a description for IPCsection. Column ipcsection has 66096 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is H.
domestic_patent_applications_by_region_in_finland	int	Datasource did not contain a description for Domestic_patent_applications_by_region_in_Finland. Column domestic_patent_applications_by_region_in_finland has 66096 rows, out of which 30935 are empty, making the null percent 46.80. Minimum value is 0 and maximum value is 2575.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, T020 pat tau 102 px, Latest

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 66096 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1990 and maximum value is 2013.
region_subregional_unit	int	Datasource did not contain a description for Region_Subregional_unit. Column region_subregional_unit has 66096 rows, out of which 3240 are empty, making the null percent 4.90. Minimum value is 1 and maximum value is 999.
applicant	string	Datasource did not contain a description for Applicant. Column applicant has 66096 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 and maximum string is 2.
ipcsection	string	Datasource did not contain a description for IPCsection. Column ipcsection has 66096 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is H.
domestic_patent_applications_by_region_in_finland	int	Datasource did not contain a description for Domestic_patent_applications_by_region_in_Finland. Column domestic_patent_applications_by_region_in_finland has 66096 rows, out of which 30935 are empty, making the null percent 46.80. Minimum value is 0 and maximum value is 2575.

Dim region subregional unit, T020 pat tau 102 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 102 rows, out of which 5 are empty, making the null percent 4.90. Minimum value is 1 and maximum value is 999.
label	string	The label for the dimension value. Column label has 102 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 UNKNOWN/FOREIGN COUNTRIES.

Dim year, T020 pat tau 102 px, Latest

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

Dim applicant, T020 pat tau 102 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 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: Enterprises or associatio... and first 25 characters of maximum string: Total of applicants...

Dim year, T020 pat tau 102 px, Full history

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

Dim applicant, T020 pat tau 102 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 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: Enterprises or associatio... and first 25 characters of maximum string: Total of applicants...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim region subregional unit, T020 pat tau 102 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 102 rows, out of which 5 are empty, making the null percent 4.90. Minimum value is 1 and maximum value is 999.
label	string	The label for the dimension value. Column label has 102 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 UNKNOWN/FOREIGN COUNTRIES.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim ipcsection, T020 pat tau 102 px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is H.
label	string	The label for the dimension value. Column label has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A: Human necessities and maximum string is H: Electricity.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim ipcsection, T020 pat tau 102 px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is H.
label	string	The label for the dimension value. Column label has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A: Human necessities and maximum string is H: Electricity.

Additional Info

Last Updated	July 18, 2019
Created	July 11, 2019