| Database | Schema | Table | Row Count | Column | Date Statistics Collected |
|---|---|---|---|---|---|
| sandbox | public | companies_house | 4,815,737 | registered_office_post_code | Wed, 09-Dec-2020 09:42:41 |
| Pattern | Frequency | Legend | ||
|---|---|---|---|---|
| AA9s9AA | 1,942,331 | Code | Meaning | |
| AA99s9AA | 1,658,243 | A | An alphabetic character | |
| A99s9AA | 476,966 | 9 | A numeric character | |
| A9s9AA | 311,940 | s | A normal space (U+0020) | |
| AA9As9AA | 270,883 | ! | A punctuation mark | |
| A9As9AA | 92,893 | $ | A currency symbol | |
| 59,912 | é | An accented letter | ||
| A9sss9AA | 254 | + | A mathematical or other symbol | |
| AA99AA | 225 | ^ | A control character | |
| AAAs9AA | 211 | b | A non-breaking space (U+00a0) | |
| AA999AA | 155 | |||
| 99999 | 133 | |||
| AA99 | 78 | |||
| AA9s9sAA | 60 | |||
| 99s999 | 54 | |||
| AA9 | 54 | |||
| A999AA | 49 | |||
| 9999 | 48 | |||
| A99 | 37 | |||
| A9 | 37 | |||
| AA99s9sAA | 37 | |||
| A9ss9AA | 37 | |||
| AA9!9999 | 31 | |||
| A999s9AA | 29 | |||
| 999999 | 27 | |||
| AA9s9A | 24 | |||
| AA9s99AA | 24 | |||
| AAA9s9AA | 24 | |||
| AA9s9AA! | 23 | |||
| AAs9AA | 23 | |||
| AAs99s9AA | 23 | |||
| AA99s9AA! | 23 | |||
| A99AA | 23 | |||
| AA99sAA | 22 | |||
| AA9s9AAA | 19 | |||
| AA9s99A | 17 | |||
| 9A9s9AA | 17 | |||
| 9999AA | 17 | |||
| A9s9A | 16 | |||
| AA99s9A | 16 | |||
| AA9sAAA | 16 | |||
| AAs99999 | 15 | |||
| AA9sAA | 14 | |||
| A99sAA | 14 | |||
| A9As9A9 | 13 | |||
| AA9s9A9 | 13 | |||
| A99s9sAA | 13 | |||
| A9s9sAA | 12 | |||
| AA9sA9AA | 11 | |||
| AAs9s9AA | 11 | |||