> ## Documentation Index
> Fetch the complete documentation index at: https://docs.thedatacity.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Using filters

> Use filters across The Data City platform to perform in-depth searches.

> [!WARNING]
>
> LEPs: These are being removed in October's update.
>
> [Strategic Authorities:](#locations) These have been added in September's update.

Our platform offers a powerful filtering system designed to enhance your user experience by helping you pinpoint precisely what you're looking for.

These filters are located in the [EXPLORE](https://docs.thedatacity.com/using-industry-engine/tools/explore.md), COMPARE and ANALYSE section of our platform.

Filters are divided into eight categories, each serving a distinct purpose. Users can select a number of filters across a range of categories to bring about a specific set of results.

### RTICs

This filter helps users navigate our database and discover results for a specific Real-Time Industrial Classification (RTICs). You can scroll or use the search filter to select as many as you want.

Each RTIC has verticals you can see by clicking its dropdown menu beside it. For example, Adtech has 5.

### CICs

CICs are Custom Industrial Classifications. Essentially they are a custom RTIC that's only available to selected group of users.

From here you can view and select any CICs available to you.

> [!TIP]
>
> **Note**: The filter is only available if the user has access to a CIC.

### Sectors

Filter companies by specific sectors within the Standard Industrial Classification (SIC) Codes. The sectors are divided into 3 sections:

* [**SICs**](https://resources.companieshouse.gov.uk/sic/): Target companies by their Standard Industrial Classification (SIC) codes. Search by specific codes or browse through categories. (Data source: [Company house](https://www.gov.uk/government/organisations/companies-house))
* **SIC** **sections**: Focus on broad industry groups using SIC Sections. Choose from 21 high-level categories like 'Manufacturing' or 'Construction'.
* **Categories**: Identify company types and structures. Filter by categories like 'Limited Liability Company' or 'Non-Profit Organisation'.
* **RSIC**: Real-Time SIC Codes (RSICs) use machine learning and a company's website text to fix inaccurate SIC classifications. They show what a company actually does, not just what it declared at Companies House. Read more about [RSICs](https://docs.thedatacity.com/our-data/proprietary-data/what-are-rsics.md).

> [!TIP]
>
> **Paste a list of codes**: To select many codes at once, paste them into the search box of a code filter such as **SIC** or **RSIC**. Separate the codes with new lines, commas or semicolons. Industry Engine selects every code it recognises and tells you which ones it couldn't find.

If you paste a parent code, Industry Engine selects all the codes beneath it. Codes that lost their leading zeros in Excel (for example `1110` instead of `01110`) still match.

### Locations

Refine your results by a specific location, region or city.

We group our locations into:

* **Cities**: The cities filter consists of UK functional urban areas (FUA) as defined by the [OECD](https://www.oecd.org/regional/regional-statistics/functional-urban-areas.htm). An FUA is composed of a core city and its commuting zone. The cities filter reflects the core city and its commuting zone. You can read more about this [here](https://thedatacity.com/blog/product-update-our-cities-filter-just-got-even-smarter/).
* **LAs**: The local authorities (LA) filter is composed of local authority districts Feb 2024 [#1](https://www.data.gov.uk/dataset/e3a0a920-d0e0-49c0-b030-9db882eca78f/local-authority-district-april-2023-to-lau1-to-itl3-to-itl2-to-itl1-january-2021-lookup) [#2](https://geoportal.statistics.gov.uk/datasets/e832e833fe5f45e19096800af4ac800c/about)  of the United Kingdom.
* **ITL1 Regions (International Territorial Level 1):** The regions filter is comprised of [UK ITL1](https://www.ons.gov.uk/methodology/geography/ukgeographies/eurostat) regions.
* **ITL2 Regions (International Territorial Level 2):** The regions filter is comprised of [UK ITL2](https://www.ons.gov.uk/methodology/geography/ukgeographies/eurostat) regions.
* **Constituencies**: The constituencies filter is comprised of [UK parliamentary constituencies.](https://www.parliament.uk/about/how/elections-and-voting/constituencies/)
* **Strategic Authorities**: Strategic Authorities reflect the UK’s updated regional policy landscape, following the phase-out of Local Enterprise Partnerships (LEPs). Strategic Authorities are [replacing](https://www.gov.uk/government/publications/english-devolution-and-community-empowerment-bill-guidance/english-devolution-and-community-empowerment-bill-guidance) Combined Authorities and they are now responsible for driving local economic development.
* **Parent Nation:** The parent nation filter enables filtering by the nationality of a company's ultimate parent. This is available where we have data on company group structure.
* **Postcodes**: Filter by postcode outcode (the first part of a postcode, such as `LS1`), by a single postcode and search radius, or by a pasted list of postcodes. See [Filtering by postcode](#postcodes).

In the locations filter, there is a checkbox: "Exclude companies known to be ultimately foreign owned". Selecting this checkbox will select all companies for where **we know** the ultimate parent company **and** we know that company is in another country (**not the UK)**. In some cases, the ultimate parent company is the same as the parent company.

#### Filtering by postcode

Open the **Locations** filter and select **Postcodes**. You can then:

* **Search by postcode outcode**: choose one or more outcodes from the list.
* **Search by specific postcode**: enter a postcode, then choose a distance from the **Within** dropdown. Options run from **0 (Exact)** to 100 km.

To filter by many postcodes at once:

**1. Set the radius to exact**

Under **Search by specific postcode**, set **Within** to **0 (Exact)**. The **Paste multiple postcodes** icon appears in the postcode box.

**2. Paste your postcodes**

Click the icon to open **Filter by multiple postcodes**. Paste full UK postcodes, one per line or separated by commas. Spaces inside each postcode are optional.

**3. Check and apply**

Industry Engine shows how many postcodes it recognised. It also lists any it doesn't recognise and removes duplicates. Click **Apply**.

You can paste up to 2,500 postcodes. Each one is matched exactly, with no radius. Postcodes that aren't recognised are not used.

Once applied, the filter panel shows how many postcodes are selected. Click **Edit** to change the list, or the cross to clear it. The list is kept when you save a list or share its link.

### Keywords

Refine your search using keywords that match your interests. Keywords has its own **Keywords** tab in the filters drawer, after **Companies**.

You can find companies that use or do not use specific keywords on their website:

* **Contains**: filter by keywords found on a company website.
* **Excludes**: filter by keywords not found on a company website.

Type a keyword and press Enter to add it. Each side has an **AND**/**OR** switch, so you can match all of your keywords or any of them. Click **Advanced syntax** for examples of phrases, wildcards and operators.

You can use both sides together to refine your results. Read more about the [keyword filter](https://docs.thedatacity.com/using-industry-engine/features/using-keyword-filters.md).

### Financials

Use the **Financial** filter to find companies by values from their accounts or by their investment history. It has two tabs: **Finances** and **Investment & Funding**.

#### Finances

On the **Finances** tab, set a minimum, a maximum or both for any of these values. A range only matches companies with a known value, so companies with no value for that measure are left out.

* **Turnover**: The total revenue generated by a company in a year. The turnover filter includes both reported and estimated turnover and refers to the turnover for the latest complete year. (Data source: [Creditsafe](http://www.creditsafe.com))
* **Employee count**: The number of people employed by a company. The filter includes both reported and estimated employee counts and refers to the latest complete year.
* **Pre tax profit**: The company's earnings before taxes are deducted.
* **EBITDA**: Earnings Before Interest, Taxes, Depreciation, and Amortisation, a measure of a company's operational profitability.
* **Net assets**: The value of a company's total assets minus its total liabilities. (Data source: Companies House ([Creditsafe](http://www.creditsafe.com)))
* **Shareholder funds**: The net worth of a company, representing the value of its assets minus its liabilities. (Data source: Companies House ([Creditsafe](http://www.creditsafe.com)))
* **Overseas Income**: The income a company declares from outside the UK, through exports or foreign operations. Companies can choose whether to declare it. (Data source: Companies House. See [Trade data](https://docs.thedatacity.com/our-data/third-party-data/trade-data.md).)

**View outliers** at the top of the tab works with [companies whose accounts are likely to contain anomalies](https://docs.thedatacity.com/our-data/proprietary-data/what-are-companies-with-potential-anomalies.md). Choose **Exclude outliers** to remove them, or **Only outliers** to see just those companies. Click **Reset** to clear your choice.

#### Investment and funding

In the **Financial** filter, select **Investment & Funding** to filter by a company's investment history. (Data source: our [investment data](https://docs.thedatacity.com/our-data/third-party-data/investment-data.md))

Use **Investment received** to choose which companies to show:

* **Any**: show companies with or without investment.
* **Only**: show only companies that have raised third-party investment.
* **Exclude**: hide companies that have raised third-party investment.

Under **Investment**, you can filter by:

* **Investment rounds**: the [types of round](https://docs.thedatacity.com/our-data/third-party-data/investment-data.md#investment-round-types) a company has raised, such as Seed or Series A.
* **Total investment received**: a minimum and maximum amount in pounds.
* **Any valuation**: a minimum and maximum company valuation in pounds.
* **Investment date range**: the months in which rounds took place.
* **Acquisitions**: choose **Has made acquisitions** or **Has been acquired**. Click **Reset** to clear your choice.
* **Initial Public Offering (IPO)**: tick **Has completed an IPO**.

The **Match** switch beside the **Investment** heading changes how the round filters work:

* **Any round** matches companies with any round that meets your filters.
* **Latest round only** matches on each company's most recent round. The headings change to **Latest investment round**, **Latest investment received** and **Latest valuation**.

The **Grant funding** section on the same tab has **Total Innovate UK funding**: the grants or investment a company has received from Innovate UK, a UK government agency that supports innovation. (Data source: [Innovate UK grant funding](https://www.ukri.org/publications/innovate-uk-funded-projects-since-2004/))

The grant funding filters also include **Innovate UK funding** and **360Giving funding**. Each has the same three options: **Any**, **Only** or **Exclude**. Choose **Exclude** to leave out companies that have already received that type of grant funding.

> [!NOTE]
>
> **Saved lists with older investment filters**: We've updated our investment data and filters. When you open a list that used the previous investment filters, Industry Engine migrates them and shows **Investment filters migrated**. The message lists each filter and whether it moved across. In EXPLORE, click **Save and continue** to save the updated list.

### Companies

Allows users streamline their search by targeting specific companies. This includes:

* Only include companies with matched URLs
* Exclude foreign companies
* Filter by [gender category](https://docs.thedatacity.com/our-data/proprietary-data/gender-data.md), for directors (leaders) and founders separately. Each has six mutually-exclusive options: all women led, majority women led, mixed led, majority men led, all men led, and uncertain. Ticking more than one in a group returns companies in any of them.

Users can also add companies they want to be on their list their company number or comapany name.

#### Search by director or PSC

On the **Companies** tab, use **Search by Director** to find companies with a particular director. Only active directors are searched, not those who have resigned.

* Choose **First & last name** to search by **First Name** and **Last Name** together, or **Full name** to search by **Full Name**. You can't use both.
* Matching ignores capital letters and matches from the start of the name. For example, `Joh` matches John.
* Use **Role** to narrow the search to one Companies House appointment type, such as **Director** or **Company Secretary**. The default is **Any role**.
* Use **Director age** under the name search to find companies with directors in an age range.

Use **Search by Persons with Significant Control** to find companies that list a matching person or company as a Person with Significant Control (PSC). Matching ignores capital letters and works from the start of the stored name. Include titles such as Mr or Mrs if the record uses them.

#### Subsidiaries and duplicates

**Subsidiaries & duplicates** controls how Industry Engine handles companies in the same group:

* **Remove subsidiaries**: removes a company when the company that files its group's accounts is also in your results. This is best for financial analysis. It doesn't remove every subsidiary.
* **Distinct brands only**: shows one row per brand. This is best for list building.
* **Show all companies**: no de-duplication.

#### Default filters

Some filters are on by default in EXPLORE: **Company status** is set to **Active**, and **Remove subsidiaries** is selected. These defaults appear under **Active filters** in the filters drawer, so you can always see them. Click a default to change it, or click **Reset to defaults** to return to them.

### B Corps

To find companies with Certified B Corp™ status, open the **Skills & Inclusion** filter and select **Inclusion**. Then tick **Only include certified B Corps**. Read more about [our B Corp data](https://docs.thedatacity.com/our-data/third-party-data/b-corps.md).

### Growth

Use the 'Growth' filter to explore high-growth companies in a specific sector.

* **Growth Rate:** Allows users Select from 'Shrinking fast', 'Shrinking', 'Stable', 'Growing' or 'Growing fast' to focus on specific trends. ([Link](https://thedatacity.com/blog/focusing-on-company-growth/))
* **Company Growth Percentage Per Year**: This filter allows users to pinpoint companies by their annual growth rate by entering a specific percentage range.
* **Incorporation Date**: Narrows results by company age, settable from 1900 to 2024.(Data source: [Company house](https://www.gov.uk/government/organisations/companies-house))
* **Company Size:** Filters by employee count (no employees, micro, small, medium, large). (Data source: [Company size](https://www.legislation.gov.uk/ukpga/2006/46/part/15)).
* **Spinouts and Scaleups**: Separate options to focus on spinouts or OECD-defined scaleups. ([Link](https://thedatacity.com/blog/focusing-on-company-growth/))

**Clear Filter:** Clear your filters and start anew with a simple tap of the Clear button.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.