About this Dataset

Companies Registered In Camden And Surrounding Boroughs

This datasets contains companies which have a registered address located in the London Boroughs of Camden, Barnet, Brent, City and County of the City of London, City of Westminster, Haringey and Islington; this does not necessarily mean they are located in these boroughs. The data is based on the Basic Company dataset published by Companies House; the location is based on postcode. Attributes include the name of the company, the registered address, accounts information and what it does.
Publisher name: London Borough of Camden
Last updated: 2025-05-09T04:05:24Z

Tables

Table 1

@ukgov.companies_registered_in_camden_and_surrounding_boroughs.table_1

55.55 MB
637,043 rows
46 columns

CREATE TABLE table_1 (
  "company_name" VARCHAR,
  "company_number" VARCHAR,
  "care_of" VARCHAR,
  "po_box" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "town" VARCHAR,
  "county" VARCHAR,
  "country" VARCHAR,
  "postcode" VARCHAR,
  "company_category" VARCHAR,
  "company_status" VARCHAR,
  "country_of_origin" VARCHAR,
  "incorporation_date" TIMESTAMP,
  "dissolution_date" VARCHAR,
  "account_reference_day" DOUBLE,
  "account_reference_month" DOUBLE,
  "accounts_next_due_date" TIMESTAMP,
  "accounts_last_made_up_to_date" VARCHAR,
  "account_category" VARCHAR,
  "returns_next_due_date" TIMESTAMP,
  "returns_last_made_up_to_date" VARCHAR,
  "number_of_mortgage_charges" DOUBLE,
  "number_of_outstanding_mortgage_charges" DOUBLE,
  "number_of_part_satisfied_mortgage_charges" BIGINT,
  "number_of_satisfied_mortgage_charges" DOUBLE,
  "standard_industrial_classification_code_1" VARCHAR,
  "standard_industrial_classification_code_2" VARCHAR,
  "standard_industrial_classification_code_3" VARCHAR,
  "standard_industrial_classification_code_4" VARCHAR,
  "number_of_general_partners" BIGINT,
  "number_of_limited_partners" DOUBLE,
  "unique_resource_identifier" VARCHAR,
  "previous_names" VARCHAR,
  "local_authority_code" VARCHAR,
  "local_authority_name" VARCHAR,
  "ward_code" VARCHAR,
  "ward_name" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "spatial_accuracy" VARCHAR,
  "location" VARCHAR,
  "last_uploaded" VARCHAR,
  "organisation_uri" VARCHAR
);