Database Schema Table Row Count Date Statistics Collected
sandbox public companies_house 4,815,737 Wed 09-Dec-2020 09:42:41

Back to List of Databases

Back to List of Tables

Column Profiles for Table: companies_house

Published: Wed 09-Dec-2020 10:28:55 GMT

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
accounting_reference_day varchar 18 Yes 0 100.00% 32 9 2 Frequency Pattern
accounting_reference_month varchar 18 Yes 0 100.00% 13 9 2 Frequency Pattern
accounts_category varchar 30 Yes 0 100.00% 16 UNAUDITED ABRIDGED 27 Frequency Pattern
accounts_last_made_up_date date 13 Yes 1,396,978 70.99% 2,615 31-Dec-1964 00:00:00 31-Dec-9998 00:00:00 Not a string Frequency Not a string
accounts_next_due_date date 13 Yes 112,627 97.66% 6,362 01-Nov-1876 00:00:00 31-Dec-2022 00:00:00 Not a string Frequency Not a string
company_category varchar 100 Yes 0 100.00% 26 Charitable Incorporated … Scottish Partnership 89 Frequency Pattern
company_name varchar 160 Yes 0 100.00% 4,814,955 ........0.....0.....0...… ZZZZZZZZZZZZZZZZZZZZZZZZ… 160 Frequency Pattern
company_number varchar 8 Yes 0 100.00% 4,815,737 00000086 ZC000204 8 Frequency Pattern
company_status varchar 70 Yes 0 100.00% 14 Active VOLUNTARY ARRANGEMENT / … 48 Frequency Pattern
confirmation_statement_last_made_up_date date 13 Yes 1,019,173 78.84% 1,620 30-Jun-2016 00:00:00 20-Dec-2020 00:00:00 Not a string Frequency Not a string
confirmation_statement_next_due_date date 13 Yes 47,931 99.00% 1,956 14-Jul-2016 00:00:00 03-Jan-2022 00:00:00 Not a string Frequency Not a string
country_of_origin varchar 50 Yes 0 100.00% 198 ZIMBABWE 24 Frequency Pattern
date_of_change_of_company_name_01 date 13 Yes 4,327,674 10.13% 5,349 04-Dec-2000 00:00:00 30-Nov-2020 00:00:00 Not a string Frequency Not a string
date_of_change_of_company_name_02 date 13 Yes 4,730,732 1.77% 5,299 04-Dec-2000 00:00:00 27-Nov-2020 00:00:00 Not a string Frequency Not a string
date_of_change_of_company_name_03 date 13 Yes 4,797,577 0.38% 4,948 04-Dec-2000 00:00:00 20-Nov-2020 00:00:00 Not a string Frequency Not a string
date_of_change_of_company_name_04 date 13 Yes 4,811,224 0.09% 2,886 04-Dec-2000 00:00:00 29-Oct-2020 00:00:00 Not a string Frequency Not a string
date_of_change_of_company_name_05 date 13 Yes 4,814,459 0.03% 1,110 04-Dec-2000 00:00:00 08-Oct-2020 00:00:00 Not a string Frequency Not a string
date_of_change_of_company_name_06 date 13 Yes 4,815,332 0.01% 380 05-Dec-2000 00:00:00 25-Sep-2020 00:00:00 Not a string Frequency Not a string
date_of_change_of_company_name_07 date 13 Yes 4,815,568 0.00% 168 29-Dec-2000 00:00:00 24-Sep-2020 00:00:00 Not a string Frequency Not a string
date_of_change_of_company_name_08 date 13 Yes 4,815,665 0.00% 72 11-Jul-2001 00:00:00 13-Sep-2020 00:00:00 Not a string Frequency Not a string
date_of_change_of_company_name_09 date 13 Yes 4,815,697 0.00% 40 16-Mar-2001 00:00:00 11-Sep-2020 00:00:00 Not a string Frequency Not a string
date_of_change_of_company_name_10 date 13 Yes 4,815,712 0.00% 25 11-Mar-2003 00:00:00 02-Sep-2020 00:00:00 Not a string Frequency Not a string
dissolution_date date 13 Yes 4,815,737 0.00% 0 Null Null Not a string Frequency Not a string
incorporation_date date 13 Yes 0 100.00% 30,344 04-Dec-1416 00:00:00 30-Nov-2020 00:00:00 Not a string Frequency Not a string
number_of_general_partners integer 10 Yes 0 100.00% 28 0 110 Not a string Frequency Not a string
number_of_limited_partners integer 10 Yes 0 100.00% 191 -2 921 Not a string Frequency Not a string
number_of_mortgage_charges integer 10 Yes 0 100.00% 462 0 6,121 Not a string Frequency Not a string
number_of_mortgages_outstanding integer 10 Yes 0 100.00% 393 0 6,121 Not a string Frequency Not a string
number_of_mortgages_part_satisfied integer 10 Yes 0 100.00% 10 0 15 Not a string Frequency Not a string
number_of_mortgages_satisfied integer 10 Yes 0 100.00% 326 0 5,720 Not a string Frequency Not a string
previous_company_name_01 varchar 160 Yes 0 100.00% 485,075 ZZZZZZZZESTY ZEN & FRIEN… 160 Frequency Pattern
previous_company_name_02 varchar 160 Yes 0 100.00% 84,707 ZZZ BB LIMITED 160 Frequency Pattern
previous_company_name_03 varchar 160 Yes 0 100.00% 18,125 ZYGO LIMITED 102 Frequency Pattern
previous_company_name_04 varchar 160 Yes 0 100.00% 4,509 ZYGONIUM LTD 116 Frequency Pattern
previous_company_name_05 varchar 160 Yes 0 100.00% 1,277 ZIMMERMAN ADAMS LIMITED 107 Frequency Pattern
previous_company_name_06 varchar 160 Yes 0 100.00% 406 ZIPCOM PLC 64 Frequency Pattern
previous_company_name_07 varchar 160 Yes 0 100.00% 170 ZER0 LIMITED 64 Frequency Pattern
previous_company_name_08 varchar 160 Yes 0 100.00% 73 WIREFOX OCEAN LLP 52 Frequency Pattern
previous_company_name_09 varchar 160 Yes 0 100.00% 41 WILTSHIRE BUSINESS SERVI… 52 Frequency Pattern
previous_company_name_10 varchar 160 Yes 0 100.00% 26 TUFF FLOORING LIMITED 40 Frequency Pattern
registered_office_address_1 varchar 300 Yes 0 100.00% 1,926,984 Z & Z DRY CLEANERS, 93 101 Frequency Pattern
registered_office_address_2 varchar 300 Yes 0 100.00% 317,102 ZURICH 7 70 Frequency Pattern
registered_office_care_of varchar 100 Yes 0 100.00% 30,682 ZYTRONIC PLC 82 Frequency Pattern
registered_office_country varchar 50 Yes 0 100.00% 193 ZIMBABWE 37 Frequency Pattern
registered_office_county varchar 50 Yes 0 100.00% 13,179 ZURICH 8008 50 Frequency Pattern
registered_office_p_o_box varchar 10 Yes 0 100.00% 5,758 ZRS 10 Frequency Pattern
registered_office_post_code varchar 20 Yes 0 100.00% 905,457 ZE3 9JZ 15 Frequency Pattern
registered_office_town varchar 50 Yes 0 100.00% 45,102 ZURICH 8001 50 Frequency Pattern
returns_last_made_up_date date 13 Yes 2,648,456 45.00% 8,980 11-Jan-1966 00:00:00 31-Dec-2049 00:00:00 Not a string Frequency Not a string
returns_next_due_date date 13 Yes 117,285 97.56% 9,817 10-Feb-1989 00:00:00 28-Dec-2021 00:00:00 Not a string Frequency Not a string
sic_code_1 varchar 170 Yes 0 100.00% 1,177 01110 - Growing of cerea… None Supplied 166 Frequency Pattern
sic_code_2 varchar 170 Yes 0 100.00% 1,013 9999 - Dormant company 166 Frequency Pattern
sic_code_3 varchar 170 Yes 0 100.00% 871 9999 - Dormant company 166 Frequency Pattern
sic_code_4 varchar 170 Yes 0 100.00% 722 99999 - Dormant Company 166 Frequency Pattern
uri varchar 47 Yes 0 100.00% 4,815,737 http://business.data.gov… http://business.data.gov… 47 Frequency Pattern

Published: Wed 09-Dec-2020 10:28:55 GMT