| Database | Schema | Table | Row Count | Date Statistics Collected |
|---|---|---|---|---|
| sandbox | public | gazetteer | 258,382 | Sat 05-Dec-2020 15:19:43 |
| Column Name | Data Type | Defined Length | Nulls Allowed | Null Count | Percentage Populated | Distinct Value Count | Minimum Value | Maximum Value | Max Actual Length | Link to Frequencies | Link to Patterns |
|---|---|---|---|---|---|---|---|---|---|---|---|
| county_abbreviation | varchar | 20 | Yes | 0 | 100.00% | 208 | 0 | York | 15 | Frequency | Pattern |
| county_code | varchar | 2 | Yes | 0 | 100.00% | 208 | AB | YY | 2 | Frequency | Pattern |
| county_name | varchar | 60 | Yes | 0 | 100.00% | 208 | Aberdeen City | York | 37 | Frequency | Pattern |
| definitive_name | varchar | 60 | Yes | 0 | 100.00% | 194,184 | 1066 Country Walk | Zulu Fm | 59 | Frequency | Pattern |
| eastings | integer | 10 | Yes | 0 | 100.00% | 613 | 5,500 | 656,500 | Not a string | Frequency | Not a string |
| east_or_west_of_greenwich | varchar | 1 | Yes | 0 | 100.00% | 2 | E | W | 1 | Frequency | Pattern |
| edit_date | date | 13 | Yes | 0 | 100.00% | 1,114 | 01-Mar-1993 00:00:00 | 10-May-2016 00:00:00 | Not a string | Frequency | Not a string |
| feature | varchar | 21 | Yes | 0 | 100.00% | 10 | All other features | Water feature | 21 | Frequency | Pattern |
| id | integer | 10 | No | 0 | 100.00% | 258,382 | 1 | 258,382 | Not a string | Frequency | Not a string |
| kilometre_reference | varchar | 6 | Yes | 0 | 100.00% | 169,774 | HP4700 | TV7194 | 6 | Frequency | Pattern |
| latitude_degrees | integer | 10 | Yes | 0 | 100.00% | 12 | 49 | 60 | Not a string | Frequency | Not a string |
| latitude_minutes | real | 8 | Yes | 0 | 100.00% | 601 | Not a string | Frequency | Not a string | ||
| longitude_degrees | integer | 10 | Yes | 0 | 100.00% | 9 | 0 | 8 | Not a string | Frequency | Not a string |
| longitude_minutes | real | 8 | Yes | 0 | 100.00% | 601 | Not a string | Frequency | Not a string | ||
| northings | integer | 10 | Yes | 0 | 100.00% | 1,171 | 5,500 | 1,220,500 | Not a string | Frequency | Not a string |
| primary_sheet_number | integer | 10 | Yes | 0 | 100.00% | 205 | 0 | 204 | Not a string | Frequency | Not a string |
| second_sheet_number | integer | 10 | Yes | 0 | 100.00% | 149 | 0 | 204 | Not a string | Frequency | Not a string |
| third_sheet_number | integer | 10 | Yes | 0 | 100.00% | 53 | 0 | 198 | Not a string | Frequency | Not a string |
| tile_reference | varchar | 4 | Yes | 0 | 100.00% | 811 | HP40 | TV68 | 4 | Frequency | Pattern |
| update_code | varchar | 1 | Yes | 0 | 100.00% | 2 | I | U | 1 | Frequency | Pattern |