Database Table Row Count Date Statistics Collected
public gazetteer 258,382 Tue 09-May-2017 17:58:22

Back to List of Databases

Back to List of Tables

Column Profiles for Table: gazetteer

Published: Fri 03-May-2019 12:09:09 GMT

Column Name Data Type Defined Length Nulls Allowed Null Count Distinct Value Count Minimum Value Maximum Value Max Actual Length Link to Frequencies Link to Patterns
county_abbreviation varchar 20 Yes 0 208 0 York 15 Frequency Pattern
county_code varchar 2 Yes 0 208 AB YY 2 Frequency Pattern
county_name varchar 60 Yes 0 208 Aberdeen City York 37 Frequency Pattern
definitive_name varchar 60 Yes 0 194,184 'S Àirde Beinn àird Sgàparaid 59 Frequency Pattern
east_or_west_of_greenwich varchar 1 Yes 0 2 E W 1 Frequency Pattern
eastings integer 10 Yes 0 613 5,500 656,500 0 Frequency Not a string
edit_date date 13 Yes 0 1,114 01-Mar-1993 00:00:00 10-May-2016 00:00:00 0 Frequency Not a string
feature_code varchar 3 Yes 0 10 A X 2 Frequency Pattern
id integer 10 No 0 258,382 1 258,382 0 Every value distinct Not a string
kilometre_reference varchar 6 Yes 0 169,774 HP4700 TV7194 6 Frequency Pattern
latitude_degrees integer 10 Yes 0 12 49 60 0 Frequency Not a string
latitude_minutes real 8 Yes 0 601 0 Frequency Not a string
longitude_degrees integer 10 Yes 0 9 0 8 0 Frequency Not a string
longitude_minutes real 8 Yes 0 601 0 Frequency Not a string
northings integer 10 Yes 0 1,171 5,500 1,220,500 0 Frequency Not a string
primary_sheet_number integer 10 Yes 0 205 0 204 0 Frequency Not a string
second_sheet_number integer 10 Yes 0 149 0 204 0 Frequency Not a string
standard_county_name varchar 60 Yes 0 208 ABERDENCITY YORK 31 Frequency Pattern
standard_name varchar 60 Yes 0 187,159 106COUNTRYWALK ZULUFM 50 Frequency Pattern
third_sheet_number integer 10 Yes 0 53 0 198 0 Frequency Not a string
tile_reference varchar 4 Yes 0 811 HP40 TV68 4 Frequency Pattern
update_code varchar 1 Yes 0 2 I U 1 Frequency Pattern

Published: Fri 03-May-2019 12:09:09 GMT