| Database | Schema | Table | Row Count | Column | Date Statistics Collected |
|---|---|---|---|---|---|
| sandbox | public | companies_house | 4,815,737 | registered_office_p_o_box | Wed, 09-Dec-2020 09:42:41 |
| Pattern | Frequency | Legend | ||
|---|---|---|---|---|
| 4,802,114 | Code | Meaning | ||
| 9999 | 5,501 | A | An alphabetic character | |
| AA9s9AA | 1,122 | 9 | A numeric character | |
| AA99s9AA | 1,021 | s | A normal space (U+0020) | |
| 999 | 824 | ! | A punctuation mark | |
| 99999 | 521 | $ | A currency symbol | |
| 99 | 383 | é | An accented letter | |
| AAsAAAs999 | 297 | + | A mathematical or other symbol | |
| A99s9AA | 294 | ^ | A control character | |
| 999999 | 266 | b | A non-breaking space (U+00a0) | |
| A9s9AA | 226 | |||
| AA99AA | 174 | |||
| AA999AA | 170 | |||
| 9 | 145 | |||
| AA9As9AA | 128 | |||
| AAAAAs999 | 115 | |||
| A!AsAAAAAA | 111 | |||
| !AAAAAAA! | 102 | |||
| AAAAAAA | 86 | |||
| 9AAsAAAAs9 | 84 | |||
| AAAAAs99 | 79 | |||
| AAAAs9 | 70 | |||
| AAAAAAAAAA | 59 | |||
| AAsAAAs99 | 58 | |||
| A9As9AA | 52 | |||
| AAAAAs9 | 44 | |||
| 99sAAAAAAA | 44 | |||
| A999AA | 43 | |||
| A!A | 42 | |||
| AAAAsAAAA | 41 | |||
| AAAAs99 | 38 | |||
| AAAAAAs999 | 36 | |||
| AAsAAAs9 | 36 | |||
| A!AsAAA | 35 | |||
| AAAAAA | 33 | |||
| 9AAsAAAAA | 32 | |||
| AAAAs999 | 30 | |||
| AAAA | 29 | |||
| AsAsAAAs99 | 28 | |||
| AAAAAAAAA | 28 | |||
| AAAAAAs99 | 26 | |||
| AAA | 25 | |||
| A99AA | 25 | |||
| 99999999 | 24 | |||
| AAAAAAAA | 23 | |||
| AAAAAAsAAA | 21 | |||
| 99sAAAAAA | 21 | |||
| AAAs999999 | 20 | |||
| A | 19 | |||
| AAAAAAs9 | 19 | |||