Provided by CorpSignals.com

Overview

This dataset provides a comprehensive view of UK companies, including their registration details, financial information, ownership, management, and recent filings for up to the 31st December 2023. The data has been meticulously processed using dbt (Data Build Tool) scripts to ensure accuracy and relevance.

Play with this dataset at the BI app. (Free registration is required)

Application

https://www.youtube.com/watch?v=iybNM8UtQRA" alt="Dataset overview">

Contents

The dataset comprises the following tables:

1. companies
2. companies_sic_codes
3. filings
4. officers_and_owners

Below is a detailed description of each table.

1. companies

Description: Contains detailed information about companies registered in the UK up to January 1, 2024.

Columns:

• company_number: Unique identifier for each company.
• company_type: Type of company (e.g., private limited, public limited).
• office_address: Registered office address.
• incorporation_date: Date of company incorporation.
• jurisdiction: Legal jurisdiction of the company.
• company_status: Current status (e.g., active, dissolved).
• account_type: Type of accounts filed.
• company_name: Official name of the company.
• sic_codes: Standard Industrial Classification codes.
• date_of_cessation: Date when the company ceased operations (if applicable).
• next_accounts_overdue: Indicator if the next accounts are overdue.
• confirmation_statement_overdue: Indicator if the confirmation statement is overdue.
• owners: Number of registered owners (persons with significant control).
• officers: Number of officers (directors, secretaries) associated with the company.
• average_number_employees_during_period: Average number of employees during the last accounting period.
• current_assets: Current assets as per the last accounts.
• last_accounts_period_end: End date of the last accounting period.
• company_url: Where you can check the up-to-date company information. Free registration is required.

Data Generation Process:

• Aggregated counts of owners and officers from the ch_psc and ch_officers tables.
• Joined with the ch_accounts table to include financial information.
• Filtered to include companies incorporated on or before January 1, 2024.

2. companies_sic_codes

Description: Provides detailed SIC (Standard Industrial Classification) codes for each company.

Columns:

• company_number: Company identifier.
• sic_code: SIC code assigned to the company.
• sic_description: Description of the SIC code.
• sic_section: Section of the SIC code.
• sic_division: Division of the SIC code.
• company_url: Where you can check the up-to-date company information. Free registration is required.

Data Generation Process:

• Joined ch_companies_sic_codes with the sic_codes table to enrich SIC code information.

3. filings

Description: Lists up to the five most recent filings for each company as of January 1, 2024.

Columns:

• All relevant filing information excluding transaction_id.
• company_number: Company identifier.
• date: Date of the filing.

Data Generation Process:

• Selected the latest filings from the ch_filings table.
• Applied a window function to rank filings by date for each company.
• Limited to the top five filings per company.

4. officers_and_owners

Description: Details up to five most recent officers and owners for each company, including their roles and personal information.

Columns:

• company_number: Company identifier.
• name: Full name of the officer or owner.
• kind: Type of person (individual or corporate entity).
• officer_role: Role within the company.
• occupation: Occupation of the individual.
• date: Date of appointment or notification.
• is_owner: Boolean indicating if the person is an owner.
• country_of_residence: Country where the individual resides.
• nationality: Nationality of the individual.
• company_country: Country of the company (for corporate persons).
• person_id: Unique identifier for the person.
• person_url: Where you can check the up-to-date company information. Free registration is required.

Data Generation Process:

• Combined data from ch_officers and ch_psc tables.
• Applied filters to include active officers and owners as of January 1, 2024.
• Used a window function to limit to the top five entries per company.

Segments Included:

• Companies
• Owners and Officers
• Filings

Data Generation Process:

• Aggregated counts and latest record dates from respective tables.

Data Sources

• Companies House Data: Official UK government register of UK companies.
• SIC Codes: Standard classification codes for industries.

Data Processing Details

• **Time F...

Here's the description without icons:

UK Companies House - Basic Company Data This dataset contains 850,000 registered companies from the official UK Companies House registry - the government agency responsible for incorporating and dissolving limited companies in the United Kingdom. What's Included ColumnDescriptionCompanyNameRegistered name of the companyCompanyNumberUnique 8-character identifierRegAddress.*Registered office address (street, city, postcode, country)CompanyCategoryType: Private Limited, PLC, LLP, etc.CompanyStatusCurrent status: Active, Dissolved, Liquidation, etc.IncorporationDateDate company was registeredSICCode.SicText_1/2Industry classification codesAccounts.*Financial filing information and due datesURIDirect link to company page on Companies House Dataset Stats

Rows: 849,999 companies Columns: 24 (cleaned from original 55) File Format: Parquet (57 MB, compressed from 398 MB CSV) Date: January 2026 snapshot

Source Official data from UK Companies House (https://www.gov.uk/government/organisations/companies-house), released under the Open Government License (OGL). Download original: https://download.companieshouse.gov.uk/en_output.html Use Cases

Market Research - Analyze industries, company formation trends Lead Generation - Find businesses by location, sector, size Economic Analysis - Track UK business growth over time Compliance - Verify company registration details Machine Learning - Classification, clustering, NLP on company names

Acknowledgements Data provided by UK Companies House under the Open Government License v3.0.

Numbers of enterprises and local units produced from a snapshot of the Inter-Departmental Business Register (IDBR) taken on 14 March 2025.

Dataset

This dataset was created by S Nath

Released under CC0: Public Domain

Contents

The Free Company Data Product is a downloadable data snapshot containing basic company data of live companies on the register.

The latest snapshot will be updated within 5 working days of the previous month end.

The Business Register and Employment Survey publishes employee and employment estimates at detailed geographical and industrial levels. It is regarded as the definitive source of official government employee statistics by industry. These maps allow a visually more meaningful comparison of employee levels by Broad industrial Group over time.

All statutory company information captured by Companies House. Includes basic company data (company name, registered office address, company status, incorporation date, country of origin, company type, nature of business, accounting reference date, date of last accounts/annual return filed, date of next accounts/annual return due, previous names, share allocation) and all statutory filings by companies contained in the Register.

BRES is the definitive source of official employee statistics and can be used to derive employment estimates at varying industrial and geographical levels. Source agency: Office for National Statistics Designation: National Statistics Language: English Alternative title: BRES

Annual employee and employment estimates for Great Britain and UK split by two, three and five-digit Standard Industrial Classification: SIC 2007. Results given by full-time or part-time and public or private splits.

Survey frame for ONS and OGD business surveys

Free Public Data Product Note The dates shown below relate to when the link has been added to data.gov.uk. The link references the latest data set as detailed below What is it? The Free Public Data Product is a downloadable data snapshot containing basic company data of live companies on the register. This snapshot is provided as ZIP files containing data in CSV format and is split into multiple files for ease of downloading. This snapshot is provided free of charge and will not be supported. When will it be updated? The latest snapshot will be updated within 5 working days of the previous month end. Additional Information The contents of the snapshot have been compiled up to the end of the previous month. Up-to-date company information can be obtained by following the URI links in the data. More details on URIs If files are viewed with Microsoft Excel, it is recommended that you use version 2007 or later.

Number of VAT-registered businesses recorded. "Enterprise Directorate: Business Start-ups and Closures: VAT Registrations and De-registrations" Please note that there will be no further releases of this publication. The Office for National Statistics has released a new National Statistics series on business births, deaths and survival rates named ‘Business Demography’. Business Demography is now the only official source of information on business start-ups and closures. Source: Business Registers Unit (BRU) Publisher: Business Registers Unit (BRU) Geographies: Local Authority District (LAD), County/Unitary Authority, Government Office Region (GOR), National Geographic coverage: Great Britain Time coverage: 1994 to 2008 Type of data: Administrative data

This dataset provides details of all UK incorporated companies with equity listed on the London Stock Exchange as at 30 June 2020. Names, market capitalisation, market admitted to and date of admission were taken from LSE data. This data was then cross referenced against the UK Companies House register (https://beta.companieshouse.gov.uk/) to provide each such company with its registered number and jurisdiction of incorporation. All companies were then cross-referenced against the Association of Investment Companies website (https://www.theaic.co.uk/aic/find-compare-investment-companies). All those not listed on the AIC's website were then examined to identify if any evidence could be identified that their headquarters were outside their jurisdictions of incorporation, with any such jurisdiction being noted.

Employee Jobs at Sub Northern Ireland level and by Industry. Source agency: Northern Ireland Statistics and Research Agency Designation: National Statistics Language: English Alternative title: Business Register and Employment Survey