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.

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.

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

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.

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.

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.

UK: Start-Up Procedures to Register a Business: Female data was reported at 4.000 Number in 2017. This stayed constant from the previous number of 4.000 Number for 2016. UK: Start-Up Procedures to Register a Business: Female data is updated yearly, averaging 6.000 Number from Dec 2003 (Median) to 2017, with 15 observations. The data reached an all-time high of 6.000 Number in 2014 and a record low of 4.000 Number in 2017. UK: Start-Up Procedures to Register a Business: Female data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s United Kingdom – Table UK.World Bank.WDI: Company Statistics. Start-up procedures are those required to start a business, including interactions to obtain necessary permits and licenses and to complete all inscriptions, verifications, and notifications to start operations. Data are for businesses with specific characteristics of ownership, size, and type of production.; ; World Bank, Doing Business project (http://www.doingbusiness.org/).; Unweighted average; Data are presented for the survey year instead of publication year.

Weekly data showing the number of Companies House incorporations, voluntary dissolutions accepted, and companies placed into compulsory dissolution in the UK. These are official statistics in development. Source: Companies House.

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

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

HM Land Registry’s Overseas Companies data contains entries made in the Title Register for property owned in England and Wales by non-UK companies (companies incorporated outside of the UK). The data includes the following ownership types: corporate bodies, limited companies, public limited companies, unlimited companies, limited liability partnerships. It is available for download as monthly files and contains approximately 100,000 records