Company Identifiers (URIs)

Companies House

@ukgov.company_identifiers_uris

Table List

1 table(26.28 KB)

Example Datapoint

@ukgov.company_identifiers_uris.example_datapoint

26.28 KB
1 row
28 columns

primarytopic_companyname

PrimaryTopic.CompanyName

primarytopic_companynumber

PrimaryTopic.CompanyNumber

primarytopic_regaddress_addressline1

PrimaryTopic.RegAddress.AddressLine1

primarytopic_regaddress_posttown

PrimaryTopic.RegAddress.PostTown

primarytopic_regaddress_county

PrimaryTopic.RegAddress.County

primarytopic_regaddress_postcode

PrimaryTopic.RegAddress.Postcode

primarytopic_companycategory

PrimaryTopic.CompanyCategory

primarytopic_companystatus

PrimaryTopic.CompanyStatus

primarytopic_countryoforigin

PrimaryTopic.CountryOfOrigin

primarytopic_incorporationdate

PrimaryTopic.IncorporationDate

primarytopic_previousnames_condate

PrimaryTopic.PreviousNames.CONDate

primarytopic_previousnames_companyname

PrimaryTopic.PreviousNames.CompanyName

primarytopic_previousnames_condate_1

PrimaryTopic.PreviousNames.CONDate.1

primarytopic_previousnames_companyname_1

PrimaryTopic.PreviousNames.CompanyName.1

primarytopic_previousnames_condate_2

PrimaryTopic.PreviousNames.CONDate.2

primarytopic_previousnames_companyname_2

PrimaryTopic.PreviousNames.CompanyName.2

primarytopic_accounts_accountrefday

PrimaryTopic.Accounts.AccountRefDay

primarytopic_accounts_accountrefmonth

PrimaryTopic.Accounts.AccountRefMonth

primarytopic_accounts_nextduedate

PrimaryTopic.Accounts.NextDueDate

primarytopic_accounts_lastmadeupdate

PrimaryTopic.Accounts.LastMadeUpDate

primarytopic_accounts_accountcategory

PrimaryTopic.Accounts.AccountCategory

primarytopic_returns_nextduedate

PrimaryTopic.Returns.NextDueDate

primarytopic_returns_lastmadeupdate

PrimaryTopic.Returns.LastMadeUpDate

primarytopic_mortgages_nummortcharges

PrimaryTopic.Mortgages.NumMortCharges

primarytopic_mortgages_nummortoutstanding

PrimaryTopic.Mortgages.NumMortOutstanding

primarytopic_mortgages_nummortpartsatisfied

PrimaryTopic.Mortgages.NumMortPartSatisfied

primarytopic_mortgages_nummortsatisfied

PrimaryTopic.Mortgages.NumMortSatisfied

primarytopic_siccodes_sictext_1

PrimaryTopic.SICCodes.SicText 1

ZENITH PRINT (UK) LIMITED

2050399

15 LON UCHAF LON UCHAF

CAERPHILLY

MID GLAMORGAN

CF83 1BR

Private Limited Company

Active

United Kingdom

Thu Aug 28 1986 00:00:00 GMT+0000 (Coordinated Universal Time)

Fri Mar 22 1996 00:00:00 GMT+0000 (Coordinated Universal Time)

ZENITH TREFOREST PRESS LIMITED

Thu Apr 22 1993 00:00:00 GMT+0000 (Coordinated Universal Time)

ZENITH COLOUR PRINTING LIMITED

Fri Nov 14 1986 00:00:00 GMT+0000 (Coordinated Universal Time)

CHANCETACKLE LIMITED

Wed Dec 31 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

Sun Mar 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

UNAUDITED ABRIDGED

Wed Jan 14 2026 00:00:00 GMT+0000 (Coordinated Universal Time)

Tue Dec 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

70100 - Activities of head offices


CREATE TABLE example_datapoint (
  "primarytopic_companyname" VARCHAR,
  "primarytopic_companynumber" BIGINT,
  "primarytopic_regaddress_addressline1" VARCHAR,
  "primarytopic_regaddress_posttown" VARCHAR,
  "primarytopic_regaddress_county" VARCHAR,
  "primarytopic_regaddress_postcode" VARCHAR,
  "primarytopic_companycategory" VARCHAR,
  "primarytopic_companystatus" VARCHAR,
  "primarytopic_countryoforigin" VARCHAR,
  "primarytopic_incorporationdate" TIMESTAMP,
  "primarytopic_previousnames_condate" TIMESTAMP,
  "primarytopic_previousnames_companyname" VARCHAR,
  "primarytopic_previousnames_condate_1" TIMESTAMP,
  "primarytopic_previousnames_companyname_1" VARCHAR,
  "primarytopic_previousnames_condate_2" TIMESTAMP,
  "primarytopic_previousnames_companyname_2" VARCHAR,
  "primarytopic_accounts_accountrefday" BIGINT,
  "primarytopic_accounts_accountrefmonth" BIGINT,
  "primarytopic_accounts_nextduedate" TIMESTAMP,
  "primarytopic_accounts_lastmadeupdate" TIMESTAMP,
  "primarytopic_accounts_accountcategory" VARCHAR,
  "primarytopic_returns_nextduedate" TIMESTAMP,
  "primarytopic_returns_lastmadeupdate" TIMESTAMP,
  "primarytopic_mortgages_nummortcharges" BIGINT,
  "primarytopic_mortgages_nummortoutstanding" BIGINT,
  "primarytopic_mortgages_nummortpartsatisfied" BIGINT,
  "primarytopic_mortgages_nummortsatisfied" BIGINT,
  "primarytopic_siccodes_sictext_1" VARCHAR
);