CTC TargetData

Bespoke Data Feeds – Data Item Checklist

This document lists all the data items that are available for inclusion in bespoke data feeds of incorporated businesses from the ICC databases. You may use this as a checklist to ensure that we include everything you want when designing your bespoke feed.

Financial Analysis

The availability of certain data items will depend on the level of financial analysis carried out by ICC. ICC analyses the accounts of all British and Irish companies that are trading and have filed accounts suitable for analysis. The number meeting these criteria is about 1.2 million (c. 3.1 million including those who have ceased trading since analysis). Analysis means that companies can be compared on a like-for-like basis irrespective of differences in reporting methods.

Due mainly to the varying disclosure requirements for small, medium and large companies, accounts are analysed to one of two levels – Superset or Subset.

Subset – These are known at ICC as ‘Subset’ companies because the data available is a subset of that available for the larger companies. Selection criterion: companies filing ‘small’ accounts. Analysed accounts for up to four years can be made available.

Superset – Selection criteria: companies filing ‘full’ or ‘medium’ accounts. Analysed accounts for up to twenty years can be made available for these companies.

The availability of certain data items for a given company will often depend on which of the above two categories it falls into: this will be indicated in the Population column below by the words Superset and Subset. In other cases there may be other factors affecting whether or not a certain data item will be available: these will also be indicated in the Population column.

Your Contact Details

Company
Contact name  
Telephone number  
Email address    
Comments  

Registration

Data Item Population tick all/ untick all
Company registration number All
Type of accounts All
Company type e.g. Ltd/PLC All
Incorporation Date All
Annual return made up date. All
Annual return received date All
Accounting reference date All
Company name All
Previous company name(s) All
Name-change date(s) All
Full history of name changes

Status Flags

Data Item Population tick all/ untick all
Size/status flag All
Status description All
Insolvency flag All
Quoted flag All
Non-trading flag All (where
accounts filed)

Geographical Identifiers

Data Item Population tick all/ untick all
Post code prefix All
Post town All
Region code All

Contact

Data Item Population tick all/ untick all
Principal trading address *
Principal trading address postcode *
Fax number *
Telephone number *
Registered office address All
Registered office postcode All
Previous registered address(es) All
Previous registered office postcode(s) All
Date of change of registered office address(es) All
* Check for latest figures

Full history of registered office addresses

Activities

Data Item Population tick all/ untick all
Principal activities description Superset
Self-reported SIC 92* codes (up to four) [to four-digit precision] All (if annual
return filed)
ICC-verified SIC 92* codes (up to ten) [to five-digit precision] Superset
* UK 1992 standard SIC codes incorporating 1997 revisions

Adverse Information (CCJs)

Data Item Population tick all/ untick all
CCJ flag All
Total number of outstanding CCJs with exact match All
Total value of outstanding CCJs with exact match All
Total number of outstanding CCJs with probable match All
Total value of outstanding CCJs with probable match All
Total number of outstanding CCJs with possible match All
Total value of outstanding CCJs with possible match All
Judgment case number All
Judgment type All
Judgment date All
Satisfaction date All
Satisfaction flag All
Amount of debt to be settled All
The court where the judgment was made All
Name against which the judgment was made All
Address against which the judgment was made All
Grade of match against registered entity All

Adverse Information (Other)

Data Item Population tick all/ untick all
Auditors' comment or qualification All analysed
Dissolved flag All
Dissolution date All
Inspection recommended flag All
Insolvency flag All
Liquidation All
Receivership All
Administration All
Voluntary arrangement All
Winding-up petition All
Unadvertised winding-up petitions All
Pending striking-off All
Winding-up order All
High Court writs All

Score

Data Item Population tick all/ untick all
Date of accounts used as part of score model All where suitable for scoring
Credit score or flag (prediction of failure within 12 months) All where suitable for scoring
Recommended upper trade credit limit or flag All where suitable for scoring
Date of latest re-calculation All where suitable for scoring
Reason for re-calculation All where suitable for scoring
Date of event causing re-calculation All where suitable for scoring
Score history All where suitable for scoring
Number of years' score history

Subsidiaries (All UK and Irish)

Data Item Population tick all/ untick all
Subsidiary registration number All
Subsidiary name All
Subsidiary size/status All
Subsidiary analysed accounts date All
Subsidiary turnover All
Subsidiary dissolution flag All
Subsidiary parent level (immediate or ultimate) All
Specify max. number of subsidiaries (subsidiaries are ranked by turnover)

Directors (Current Appointments)

Data Item Population tick all/ untick all
Number of Officers All
Super person code All
Super person suffix code All
Title All
First name All
Last name All
Honours All
Address All
Nationality All
Usual country of residence All
Date of birth All directors
Appointment type (director or secretary) All
Date of appointment All

Directors (Resigned Appointments)

Data Item Population tick all/ untick all
Super person code All
Super person suffix code All
Title All
First name All
Last name All
Honours All
Address All
Nationality All
Usual country of residence All
Date of birth All directors
Appointment type All
Date of resignation All

Filing and Event History

Data Item Population tick all/ untick all
Event date All
Event data source All
Event type All

Financial (Annuals)

Data Item Population tick all/ untick all
Date of latest filed accounts All analysed
Date latest accounts were filed All analysed
Date these become available to public All analysed
Date of latest ICC-analysed accounts All analysed
Audit qualification All analysed
Number of weeks All analysed
Group consolidated flag All analysed
Subsidiary flag All analysed
Currency (e.g. 'GBP') All analysed
ICC level of analysis All analysed
Tangible assets All analysed
Total current assets All analysed
Total current liabilities All analysed
Total long-term liabilities All analysed
Working capital All analysed
Net worth All analysed
Turnover All analysed
Number of employees All analysed
Pre-tax profit All analysed
Auditors All analysed
Intangible assets All analysed
Total fixed assets All analysed
Stocks All analysed
Trade debtors All analysed
Cash All analysed
Other current assets All analysed
Miscellaneous current assets All analysed
Total assets All analysed
Net assets All analysed
Trade creditors All analysed
Bank overdraft All analysed
Miscellaneous current liabilities All analysed
Bank overdraft and long-term liabilities All analysed
Total liabilities All analysed
Profit & loss account reserve All analysed
Revaluation reserve All analysed
Share capital and other reserves All analysed
Shareholders' funds All analysed
Net cash All analysed
Capital employed All analysed
Liquid assets All analysed
Wages and salaries All analysed
Due from group, non-current All analysed
Due from group, current All analysed
Due to group, non-current All analysed
Due to group, current All analysed
Due to directors, non-current All analysed
Due to directors, current All analysed
Cost of sales All analysed
Gross profit All analysed
Non-audit fees All analysed
Special notes – e.g. post-balance-sheet events All analysed
Fixed assets Superset
Intermediate assets Superset
Short-term loans Superset
Other current liabilities Superset
Long-term loans Superset
Other long-term liabilities Superset
Total debt Superset
Exports Superset
Auditors' fees Superset
Director's emoluments Superset
Depreciation Superset
Non-trading income Superset
Interest expenses Superset
Trading profit Superset
Operating profit Superset
Value added Superset
Bank loans - current portion Superset
Other short-term finance Superset
Long-term bank loans Superset
Other long-term finance Superset
Called-up share capital Superset
Sundry reserves (incl. grants) Superset
Taxation Superset
Profit after tax Superset
Dividends payable Superset
Retained profits Superset
Net cashflow from operating activities Superset
Net cashflow from ROI & servicing of finance Superset
Net cashflow before financing Superset
Net cashflow from financing Superset
Increase In cash Superset
Contingent liability Superset
Number of years data

(Max. for Subset companies: 4 years
Max. for Superset companies: 20 years)

Financials (Interims)

Data Item Population tick all/ untick all
Date of analysed accounts Quoted
No of weeks Quoted
Group consolidated flag Quoted
Currency (e.g. 'GBP') Quoted
Turnover Quoted
Net interest Quoted
Pre-tax profit Quoted
Profit after tax Quoted
Dividends payable Quoted
Retained profits Quoted
Tangible fixed assets Quoted
Intangible fixed assets Quoted
Intermediate assets Quoted
Total fixed assets Quoted
Stocks Quoted
Debtors Quoted
Cash Quoted
Miscellaneous current assets Quoted
Total current assets Quoted
Total current liabilities Quoted
Creditors after one year provision Quoted
Called-up share capital Quoted
P&L account reserve Quoted
Revaluation reserve Quoted
Other (sundry) reserves Quoted
Shareholders' funds Quoted
Minority interests Quoted
Net cashflow from operations Quoted
Net cashflow before financing Quoted
Net current assets Quoted
Net borrowing Quoted
Total liabilities less cash Quoted
Total liabilities Quoted

Parentage

Data Item Population tick all/ untick all
Immediate holding company registration number (UK & Irish companies) All (if annual return filed)
Immediate holding company name All (if annual return filed)
Ultimate holding company registration number (UK & Irish companies) All (if annual return filed)
Ultimate holding company name All (if annual return filed)
Foreign holding company flag All (if annual return filed)

Private Shareholders

Data Item Population tick all/ untick all
Document date All (if annual return filed)
Flag denoting document type All (if annual return filed)
Number of shareholders All (if annual return filed)
Full list flag (Y/N) All (if annual return filed)
Bulk List Company flag (Y/N) All (if annual return filed)
Total Issued Capital All (if annual return filed)
Document added date All (if annual return filed)
Class of shares All (if annual return filed)
Total number of shares issued per share class All (if annual return filed)
Aggregate nominal value All (if annual return filed)
Share value All (if annual return filed)
Individual or Company flag All (if annual return filed)
Shareholder number All (if annual return filed)
Title All (if annual return filed)
Forenames. All (if annual return filed)
Last name. All (if annual return filed)
Number of shares issued. All (if annual return filed)
Aggregate value All (if annual return filed)
Issue Flag All (if annual return filed)
Share issue number. All (if annual return filed)
Registered company number of shareholder if it is a UK or Irish company All (if annual return filed)

Quoted Shareholders

Data Item Population tick all/ untick all
Date of analysed accounts Quoted
Actuary group code Quoted
Company status Quoted
Date company status changed Quoted
Update date Quoted
Description Quoted
Class of share code. Quoted
Shareholder number Quoted
Shareholder name Quoted
Holding in 000's Quoted
Percentage holding Quoted
Beneficial flag (Y,N) Quoted
Name code (M,F,D,I,N) Quoted
Par value Quoted
Issued capital Quoted
Nominal capital Quoted
Class code descriptor Quoted
Analysis date Quoted

Mortgages and Charges

Data Item Population tick all/ untick all
Summary mortgage data (i.e. no. of unsatisfied, partially satisfied and fully satisfied mortgages and charges). All
Comprehensive mortgage data (i.e. full details of mortgages and charges, property, lenders and so on). All

Growth Rates (2, 3 and 4 year [5 for Superset])

Data Item Population tick all/ untick all
Turnover - Percentage All analysed
Pretax Profit - Percentage All analysed
Number Employees - Percentage All analysed
Employee Remuneration - Percentage All analysed
Fixed Assets - Percentage All analysed
Tangible Assets - Percentage All analysed
Total Fixed Assets - Percentage All analysed
Stocks - Percentage All analysed
Trade Debtors - Percentage All analysed
Total Current Assets - Percentage All analysed
Total Assets - Percentage All analysed
Bank Overdraft + Long Term Liabilities - Percentage All analysed
Trade Creditors - Percentage All analysed
Total Current Liabilities - Percentage All analysed
Net Cash - Percentage All analysed
Net Worth - Percentage All analysed
Long Term Liabilities - Percentage All analysed
Capital Employed - Percentage All analysed
Shareholders Funds - Percentage All analysed
Net assets - Percentage All analysed
The number of years growths to which this set of figures relates All analysed

Ratios

Data Item Population tick all/ untick all
Date of analysed accounts (YYYYMMDD)  
Pretax Profit / Total Liabilities - Percentage Superset
Pretax Profit / Value Added - Percentage Superset
Operating Profit / Turnover - Percentage Superset
Trading Profit / Turnover - Percentage Superset
Pre Tax Profit + Interest Expenses / Cap Emp + Sho Superset
Capital Employed / Total Assets - Ratio Superset
Current Liabilities / Debtors - Percentage Superset
Net Worth / Fixed Assets - Percentage Superset
Bank OD & Short Term Loans / Current Assets - Percentage Superset
Bank Overdraft & Short & Long Term Bank Loans/Net Superset
Bank OD & Short & Long Term Bank Loans/Working Cap Superset
Bank Overdraft Short & Long Term Bank Loans/Total Superset
Fixed Assets / Wages - Percentage Superset
Value Added / Sales - Percentage Superset
Value Added / Employee - GBP Superset
Value Added/Employee Renumeration - Ratio Superset
Net Assets / Audit Fees - Ratio Superset
Turnover / Fixed Assets - Ratio Superset
Fixed Assets / Employee - GBP Superset
Interest Expenses/Pre Interest Profit - Percentage Superset
Total Debt / Net Worth - Percentage Superset
Total Debt / Working Capital - Ratio Superset
Total debt / Total assets Superset
Long Term Debt / Net Worth - Percentage Superset
Sales / Audit Fees - Ratio Superset
Total Assets / Audit Fees - Ratio Superset
Exports / Turnover - Percentage Superset
Net Worth / Total Liabilities - Percentage All analysed
Long Term Liab. / Net Worth - Ratio All analysed
Pretax Profit / Capital Employed - Percentage All analysed
Pretax Profit Total Assets Percentage All analysed
Pretax Profit / Turnover - Percentage All analysed
Current Ratio - Ratio All analysed
Liquidity Ratio - Ratio All analysed
Stock Turnover - Ratio All analysed
Debtors Days - Days All analysed
Creditors Days - Days All analysed
Pretax Profit / Crt.Liabilities - Percentage All analysed
Turnover / Capital Employed - Ratio All analysed
Stocks / Working Capital - Percentage All analysed
Current Assets / Total Assets - Percentage All analysed
Turnover / Current Liabilities - Ratio All analysed
Net Cash / Current Liabilities - Percentage All analysed
Liquid Assets / Total Assets - Percentage All analysed
Net Worth / Total Assets - Percentage All analysed
Net Worth / Total Assets less Intangibles - Percentage All analysed
Net Worth / Current Liabilities - Percentage All analysed
Profit & Loss A/c Reserve / Net Worth - Percentage All analysed
Profit & Loss A/c Reserve / Total Assets - Percentage All analysed
Revaluation Reserve / Shareholders Funds - Percentage All analysed
Bank Overdraft / Current Assets - Percentage All analysed
Bank Overdraft & Long Term Liabilities/Net Worth - Percentage All analysed
Bank Overdraft & Long Term Liabilities/Working Cap All analysed
Bank Overdraft & Long Term Liabilities/Total Asset All analysed
Shareholders Funds / Total Liabilities - Percentage All analysed
Pretax Profit / Shareholders' Funds - Percentage All analysed
Turnover / Total Assets - Percentage All analysed
Turnover / Total Fixed Assets - Percentage All analysed
Capital Employed / Employee - GBP All analysed
Total Assets / Employee - GBP All analysed
Creditors / Debtors - Ratio All analysed
Debtors / Total Assets - Percentage All analysed
PreTax Profit Wages GBP All analysed
Total Assets / Employee - GBP All analysed
Current Liabilities / Stocks - Ratio All analysed
Working Capital / Turnover - Percentage All analysed
Shareholders Funds / Total Assets - Ratio All analysed
Average Remuneration - GBP All analysed
Wages / Turnover - Percentage All analysed
Pre-tax Profit / Employee - GBP All analysed
Turnover / Employee - GBP All analysed
Net Worth/Total Fixed Assets - Percentage All analysed

Industry Averages (Lower, Median and Upper Quartiles)

Data Item Population tick all/ untick all
Year end date of accounts used All analysed
SIC code used for quartile calculation All analysed
Number of companies used in quartile calculation All analysed
Exports / Turnover - Percentage Superset
Fixed Assets / Employee - GBP Superset
Interest Expenses/Pre Interest Profit - Percentage Superset
Long Term Debt / Net Worth - Percentage Superset
Sales / Audit Fees - Ratio Superset
Total Assets / Audit Fees - Ratio Superset
Total Debt / Net Worth - Percentage Superset
Total debt / Total assets Superset
Total Debt / Working Capital - Ratio Superset
Turnover / Fixed Assets - Ratio Superset
Value Added / Employee - GBP Superset
Average Remuneration - GBP All analysed
Capital Employed / Employee - GBP All analysed
Creditors / Debtors - Ratio All analysed
Creditors Days - Days All analysed
Current Liabilities / Stocks - Ratio All analysed
Current Ratio - Ratio All analysed
Debtors / Total Assets - Percentage All analysed
Debtors Days - Days All analysed
Liquidity Ratio - Ratio All analysed
Net Worth / Total Assets - Percentage All analysed
Pre-tax Profit / Capital Employed - Percentage All analysed
Pre-tax Profit / Employee - GBP All analysed
Pre-tax Profit / Shareholders' Funds - Percentage All analysed
Pre-tax Profit / Total Assets - Percentage All analysed
Pre-tax Profit / Turnover - Percentage All analysed
Shareholders Funds / Total Assets - Ratio All analysed
Shareholders Funds / Total Liabilities - Percentage All analysed
Stock Turnover - Ratio All analysed
Total Assets / Employee - GBP All analysed
Total Fixed Assets / Employee - GBP All analysed
Turnover / Capital Employed - Ratio All analysed
Turnover / Employee - GBP All analysed
Turnover / Total Assets - Percentage All analysed
Wages / Turnover - Percentage All analysed
Working Capital / Turnover - Percentage All analysed

Index of Images of Original Documents Available

Data Item Population tick all/ untick all
Company registration number All
Unique document id number All
Date of document All
Date of cancellation All
Date of query (if document subject to query) All
Number of pages All
Code denoting document type All
Description of document All
Document family All

Disqualified Directors

Data Item Population tick all/ untick all
Date of birth N/A
Title N/A
Forename(s) N/A
Surname N/A
Honours N/A
Address line 1 N/A
Address line 2 N/A
Post town N/A
County N/A
Postcode N/A
Country N/A
Nationality N/A
Start date for disqualification period N/A
End date for disqualification period N/A
Act and/or Section of Act under which disqualification is made N/A
Exception -- registration number of the company that is excepted N/A
Start date for the exception N/A
End date for the exception N/A