| Database | Schema | Table | Row Count | Column | Date Statistics Collected |
|---|---|---|---|---|---|
| sandbox | public | companies_house | 4,815,737 | registered_office_address_1 | Wed, 09-Dec-2020 09:42:41 |
Most Popular Values
| Value | Frequency |
|---|---|
| 71-75 SHELTON STREET | 45,143 |
| 20-22 WENLOCK ROAD | 44,558 |
| 39,527 | |
| KEMP HOUSE | 25,178 |
| 27 OLD GLOUCESTER STREET | 13,586 |
| BRUNEL HOUSE 340 FIRECREST COURT | 10,988 |
| INTERNATIONAL HOUSE | 9,267 |
| 85 GREAT PORTLAND STREET | 7,165 |
| 3RD FLOOR | 6,918 |
| UNIT G25 WATERFRONT STUDIOS | 6,660 |
| 1ST FLOOR | 5,976 |
| FIRST FLOOR, TELECOM HOUSE | 5,966 |
| STRON HOUSE | 5,244 |
| FIRST FLOOR | 5,226 |
| 50 LOTHIAN ROAD | 4,973 |
Least Popular Values
| Value | Frequency |
|---|---|
| ` | 1 |
| , | 1 |
| 0001, 9 RENFREW ROAD, | 1 |
| 00-09 TOWER WORKS | 1 |
| 00/11 TOWER WORKS | 1 |
| 00 11 WINDSOR COURT | 1 |
| 001 25 | 1 |
| 00131337: COMPANIES HOUSE DEFAULT ADDRESS | 1 |
| 001 BOWLING MILL COURTYARD | 1 |
| 001 COMPANY MAIL SERVICE | 1 |
| 001 EULER COURT | 1 |
| 001-G-A003 STORE FIRST A ROUNDWOOD POINT | 1 |
| 001 HIGH HOUSE ARTISTS' STUDIOS | 1 |
| 0.01 PROTO, BALTIC BUSINESS QUARTERS | 1 |
| 00255290: COMPANIES HOUSE DEFAULT ADDRESS | 1 |