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

11 q 5 -- Enforcement matters by enforcement district, 2008-2018

11 q 5 -- Enforcement matters by enforcement district, 2008-2018

Tables

Column Descriptions

Dim year, Statfin uloa pxt 11q5 px, Full history

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

Fact, Statfin uloa pxt 11q5 px, Full history

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 307395 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2008 and maximum value is 2018.
enforcement_district int Datasource did not contain a description for Enforcement_district. Column enforcement_district has 307395 rows, out of which 13365 are empty, making the null percent 4.35. Minimum value is 7 and maximum value is 71.
pendency string Datasource did not contain a description for Pendency. Column pendency has 307395 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2 and maximum string is 3.
type_of_applicant int Datasource did not contain a description for Type_of_applicant. Column type_of_applicant has 307395 rows, out of which 102465 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
enforcement_matter int Datasource did not contain a description for Enforcement_matter. Column enforcement_matter has 307395 rows, out of which 15939 are empty, making the null percent 5.19. Minimum value is 1 and maximum value is 199.
amount_of_enforcement_matters int Datasource did not contain a description for Amount_of_enforcement_matters. Column amount_of_enforcement_matters has 307395 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 5072409.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin uloa pxt 11q5 px, Latest

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 307395 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2008 and maximum value is 2018.
enforcement_district int Datasource did not contain a description for Enforcement_district. Column enforcement_district has 307395 rows, out of which 13365 are empty, making the null percent 4.35. Minimum value is 7 and maximum value is 71.
pendency string Datasource did not contain a description for Pendency. Column pendency has 307395 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2 and maximum string is 3.
type_of_applicant int Datasource did not contain a description for Type_of_applicant. Column type_of_applicant has 307395 rows, out of which 102465 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
enforcement_matter int Datasource did not contain a description for Enforcement_matter. Column enforcement_matter has 307395 rows, out of which 15939 are empty, making the null percent 5.19. Minimum value is 1 and maximum value is 199.
amount_of_enforcement_matters int Datasource did not contain a description for Amount_of_enforcement_matters. Column amount_of_enforcement_matters has 307395 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 5072409.

Dim year, Statfin uloa pxt 11q5 px, Latest

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

Additional Info

Last Updated July 21, 2019
Created July 19, 2019