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

LK 02030 Municipal operations and investments (1993-2009) - discontinued

LK 02030 Municipal operations and investments (1993-2009) - discontinued

Tables

Column Descriptions

Fact, Lk02030 Municipal Operations And Investments 1993 2009 Discontinued

Column Type Comment
municipalities int Datasource did not contain a description for municipalities. Column municipalities has 42840 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4101 and maximum value is 4701.
purpose string Datasource did not contain a description for purpose. Column purpose has 42840 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ADMIN and maximum string is ENVIRON.
kind string Datasource did not contain a description for kind. Column kind has 42840 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is GRANTS and maximum string is OURCHASE.
operations_and_investments string Datasource did not contain a description for Operations_and_investments. Column operations_and_investments has 42840 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is INVEST and maximum string is OPER.
year int Datasource did not contain a description for year. Column year has 42840 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1993 and maximum value is 2009.
municipal_operations_and_investments int Datasource did not contain a description for Municipal_operations_and_investments. Column municipal_operations_and_investments has 42840 rows, out of which 19636 are empty, making the null percent 45.84. Minimum value is -129904 and maximum value is 411078.
orig_extractdate string The date when the data was originally fetched from the source.

Dim Kind, Lk02030 Municipal Operations And Investments 1993 2009 Discontinued

Column Type Comment
code string The code for the dimension value. Column code has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is GRANTS and maximum string is OURCHASE.
label string The label for the dimension value. Column label has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Grants to associations an... and first 25 characters of maximum string: Purchase of goods and ser...
orig_extractdate string The date when the data was originally fetched from the source.

Dim Operations And Investments, Lk02030 Municipal Operations And Investments 1993 2009 Discontinued

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

Dim Year, Lk02030 Municipal Operations And Investments 1993 2009 Discontinued

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

Dim Purpose, Lk02030 Municipal Operations And Investments 1993 2009 Discontinued

Column Type Comment
code string The code for the dimension value. Column code has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ADMIN and maximum string is ENVIRON.
label string The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Local, housing and enviro... and first 25 characters of maximum string: School and cultural matte...
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 12, 2019
Created November 8, 2018