Company Identifiers (URIs)
Companies House
@ukgov.company_identifiers_uris
Example Datapoint
@ukgov.company_identifiers_uris.example_datapoint
- 26.28 KB
- 1 row
- 28 columns
primarytopic_companynamePrimaryTopic.CompanyName | primarytopic_companynumberPrimaryTopic.CompanyNumber | primarytopic_regaddress_addressline1PrimaryTopic.RegAddress.AddressLine1 | primarytopic_regaddress_posttownPrimaryTopic.RegAddress.PostTown | primarytopic_regaddress_countyPrimaryTopic.RegAddress.County | primarytopic_regaddress_postcodePrimaryTopic.RegAddress.Postcode | primarytopic_companycategoryPrimaryTopic.CompanyCategory | primarytopic_companystatusPrimaryTopic.CompanyStatus | primarytopic_countryoforiginPrimaryTopic.CountryOfOrigin | primarytopic_incorporationdatePrimaryTopic.IncorporationDate | primarytopic_previousnames_condatePrimaryTopic.PreviousNames.CONDate | primarytopic_previousnames_companynamePrimaryTopic.PreviousNames.CompanyName | primarytopic_previousnames_condate_1PrimaryTopic.PreviousNames.CONDate.1 | primarytopic_previousnames_companyname_1PrimaryTopic.PreviousNames.CompanyName.1 | primarytopic_previousnames_condate_2PrimaryTopic.PreviousNames.CONDate.2 | primarytopic_previousnames_companyname_2PrimaryTopic.PreviousNames.CompanyName.2 | primarytopic_accounts_accountrefdayPrimaryTopic.Accounts.AccountRefDay | primarytopic_accounts_accountrefmonthPrimaryTopic.Accounts.AccountRefMonth | primarytopic_accounts_nextduedatePrimaryTopic.Accounts.NextDueDate | primarytopic_accounts_lastmadeupdatePrimaryTopic.Accounts.LastMadeUpDate | primarytopic_accounts_accountcategoryPrimaryTopic.Accounts.AccountCategory | primarytopic_returns_nextduedatePrimaryTopic.Returns.NextDueDate | primarytopic_returns_lastmadeupdatePrimaryTopic.Returns.LastMadeUpDate | primarytopic_mortgages_nummortchargesPrimaryTopic.Mortgages.NumMortCharges | primarytopic_mortgages_nummortoutstandingPrimaryTopic.Mortgages.NumMortOutstanding | primarytopic_mortgages_nummortpartsatisfiedPrimaryTopic.Mortgages.NumMortPartSatisfied | primarytopic_mortgages_nummortsatisfiedPrimaryTopic.Mortgages.NumMortSatisfied | primarytopic_siccodes_sictext_1PrimaryTopic.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 | 31 | 3 | 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) | 6 | 2 | 4 | 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
);