Comprehensive UK business import database with 5.4M importing companies, 22M filings, and 10.5M decision-makers. Includes import history, financial metrics, and company data up to 2023 for market research and B2B sales.
This comprehensive UK business intelligence database provides detailed information on 5.4 million UK importing companies (multiple records per company), complete with import history, financial metrics, officer details, and corporate filings. The dataset covers the period 2019-2023 and includes over 53.9 million records across six interconnected files, offering complete visibility into UK import activities and business operations.
Data Density by Category
Company Records: 11.88M (22.0%)
People Records: 10.51M (19.5%)
Filing History: 22.53M (41.8%)
Industry Classification: 7.85M (14.6%)
Import Transactions: 1.13M (2.1%)
This massive 53.9M+ record dataset represents one of the most comprehensive UK business intelligence resources available, particularly valuable for its integration of import/export data with traditional company registry information.
Dataset Files & Column Details
1. companies.csv (6.46M records)
Complete registry of UK limited companies with financial and operational metrics.
Column
Description
company_number
Unique Companies House identifier
company_type
Legal structure (Private limited, PLC, etc.)
office_address
Registered business address
incorporation_date
Company formation date
jurisdiction
England/Wales, Scotland, or Northern Ireland
company_status
Active, Dissolved, Liquidation
account_type
Micro Entity, Small, Medium, Large
company_name
Registered business name
sic_codes
Industry classification codes
date_of_cessation
When company ceased operations
next_accounts_overdue
Boolean for overdue filings
confirmation_statement_overdue
Boolean for overdue statements
owners
Number of shareholders
officers
Number of directors/officers
average_number_employees_during_period
FTE employee count
current_assets
Financial position indicator
last_accounts_period_end
Most recent accounts date
2. companies_sic_codes.csv (7.85M records)
Detailed Standard Industrial Classification mapping for all companies.
Column
Description
company_number
Companies House identifier
sic_code
5-digit SIC classification code
sic_description
Official SIC category description
sic_section
High-level industry section
sic_division
Industry division grouping
company_url
Source reference URL
3. importer.csv (1.13M records)
Detailed import transaction records with commodity classification.
Column
Description
commodity_code
HS harmonized system code
sitc_code
Standard International Trade Classification
hs_description
Product description
hs_section
High-level product category
company_number
Importing company identifier
first_date
First import date for product
last_date
Most recent import date
months_traded
Active trading duration
company_url
Source reference URL
4. filings.csv (22.53M records)
Complete corporate filing history from Companies House.
Column
Description
company_number
Companies House identifier
date
Filing submission date
category
Document type (accounts, officers, mortgage)
pages
Document length
description
Detailed filing description
5. importingcompanies.csv (5.42M records)
Subset of companies identified as active importers with enhanced metrics.
Column
Description
company_number
Companies House identifier
[All company columns]
Same as companies.csv
company_url
Enhanced source reference
6. officers_and_owners.csv (10.51M records)
Comprehensive directory of company directors and key decision-makers.
Column
Description
company_number
Companies House identifier
name
Officer/director full name
kind
Individual or corporate entity
officer_role
Director, Secretary, etc.
occupation
Declared profession
date
Appointment date
is_owner
Boolean for shareholder status
country_of_residence
Officer’s residence country
nationality
Officer’s nationality
company_country
Company jurisdiction
person_id
Unique person identifier
person_url
Detailed profile URL
Data Applications & Use Cases
This UK companies database serves market research, competitive intelligence, and B2B sales teams targeting importing businesses. The import company data enables identification of active international traders for logistics services, trade finance, and supply chain partnerships. Sales teams can leverage the officer database for executive outreach to directors and decision-makers responsible for procurement and international trade.
The comprehensive nature supports business intelligence analysis across multiple dimensions: industry classification through SIC codes, financial health via current assets and employee counts, and import behavior patterns through transaction history. This dataset is particularly valuable for identifying growing import businesses, analyzing market entry strategies, and understanding UK import trends across commodity classifications.
Researchers can track company lifecycle from incorporation through dissolution, while recruiters can identify key decision-makers in expanding import businesses. The historical filing data provides due diligence capabilities for risk assessment and compliance monitoring.
