About this Dataset

Company Identifiers (URIs)

Companies House has developed a new service to supply basic company details, using a simple Uniform Resource Identifier (URI) for each company on our register. The URI is a unique web address that represents the company (using the ‘business.data.gov.uk’ domain); and will return basic company details for that company. The development of company URIs fits with the government transparency agenda of providing easier access to public data; and it will provide a more efficient way of data linking for users and the business information industry. Data will be returned in the format appropriate to the requesting system using content negotiation (see http://www.w3.org/TR/cooluris/#r303gendocument) It will only be the basic company details, such as: company name, registered office address, company status, incorporation date, country of origin, company type, nature of business (SIC), accounting reference date, date of last accounts/annual return filed, date of next accounts/annual return due, previous names.
Publisher name: Companies House
Last updated: 2024-06-14T04:03:00Z

Tables

Example Datapoint

@ukgov.company_identifiers_uris.example_datapoint

26.91 kB
1 row
28 columns

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
);