UK Charity Commission High-Income Charity Intelligence

Turn the official daily Charity Commission for England and Wales bulk register into filtered organisation intelligence and flat JSON/CSV records for Clay, n8n, due diligence and sector research.

Coverage: registered main charities on the England and Wales register. Scotland and Northern Ireland have separate registers and are not covered as registration jurisdictions. An England/Wales charity may operate elsewhere. Linked subsidiary records and removed charities are excluded. This is an independent product, not endorsed by the Charity Commission.

Quick start

{"minIncomeGbp":1000000,"maxResults":10}

The default returns up to ten unique charities with latest reported annual income of at least £1 million, in source file order. It downloads two official daily files once per run and streams their contents without a browser, proxy or Commission API account. This is daily snapshot data, not a live API lookup. A small result limit does not eliminate the initial full-source download/validation cost.

For a published operation area and latest reporting year:

{"minIncomeGbp":1000000,"region":"Kent","reportingYear":2025,"maxResults":100}

Input	Meaning
minIncomeGbp	Inclusive threshold applied to latest_income; default 1000000
region	Exact case-insensitive published area-of-operation description; blank = all
reportingYear	Calendar year in which the latest reported accounting period ends; optional
maxResults	Unique registration-number limit, default 10, maximum 10000

region is not a registered-office location or inferred coverage hierarchy. Examples include Kent, Throughout London, Throughout England, Throughout Wales, Throughout England And Wales. A charity declaring a nationwide area is not automatically included in a search for a local authority. No fuzzy/geographic expansion is performed. Check operation_areas to understand the returned scope. Unknown area labels simply return no results.

reportingYear filters the latest financial period, not older annual returns. If a charity's latest period ends in 2025, a 2024 query will not return its 2024 historical finances. Current contacts are never presented as historical contacts. Financial periods are charity-specific and may not last exactly twelve months. Missing income or financial dates excludes a record; missing expenditure remains JSON null.

Output

One row per registered_charity_number, with:

Field	Meaning
registered_charity_number	Registration number as string
charity_name	Official registered name
latest_income_gbp	Source latest income, numeric GBP
latest_expenditure_gbp	Source latest expenditure for the same period, numeric GBP or null
public_email	Published register contact, empty string if absent
public_phone	Published register contact, string preserving leading zero, empty if absent
website_url	Published website, https scheme added if missing, empty if absent/invalid
address	Published contact address joined into a single string
registration_date	ISO date or empty string
financial_year_start / financial_year_end	Exact source latest accounting period dates
reporting_year	Year of financial_year_end
operation_areas	Sorted, distinct published area labels separated by semicolons
source_date	Publisher's date_of_extract, not the download time
source_url / source_attribution	Official landing page and attribution

Contact fields are published register contacts only. They are not validated for reachability, enriched, guessed or guaranteed to be non-personal. Blank values remain blank. This Actor does not download trustee files, process trustee names or offer individual/person leads. It does not grant permission to contact anyone or promise marketing-ready leads. Where a register contact identifies a person, users must establish their own lawful processing basis; public availability is not marketing consent.

Export from the Apify Dataset as JSON or CSV. All fields are scalar, so Clay can import CSV and n8n can consume the JSON Dataset endpoint directly. Keep charity numbers and phone numbers as strings during downstream imports to preserve leading zeros. CSV income/expenditure blanks correspond to missing amounts, never invented zeroes.

Price

Target and release price: $0.005 per successfully delivered unique charity ($5 / 1,000), using the apify-default-dataset-item Pay-per-Event event. No Actor-start fee or platform-usage surcharge is configured for standard runs. The live Store pricing is authoritative. Post-run Dataset storage/access can incur standard Apify account charges.

Duplicate registration numbers are filtered before Dataset writes and are not charged. Existing rows are checked when a run resumes; different source hashes or filters fail before new writes, and existing rows count against maxResults. Each separate new run is a separate request and can return and charge the same charity again. Empty results, validation errors and source failures do not create billable Dataset rows. Apify's SDK respects the run's spending limit. Stop/restart a run only through supported Apify lifecycle controls; do not concurrently modify its default Dataset.

Sources and data handling

Official download service: https://register-of-charities.charitycommission.gov.uk/en/register/full-register-download

Official anonymous daily files:

• https://ccewuksprdoneregsadata1.blob.core.windows.net/data/txt/publicextract.charity.zip
• https://ccewuksprdoneregsadata1.blob.core.windows.net/data/txt/publicextract.charity_area_of_operation.zip

The operation-area join uses organisation_number AND registered_charity_number, excluding non-zero linked_charity_number. Finances and their period dates come together from the charity row; no cross-year financial join is used. Results follow source order, not income ranking.

Downloads have two attempts, connection/read timeouts, a 180-second aggregate deadline and an 80 MiB per-file compressed limit. Archives must contain exactly the expected file and no more than 1 GiB uncompressed. Schema changes, inconsistent daily snapshots and extracts older than three days fail closed before output. ETag, Last-Modified, download time, byte count, SHA-256 and source date are saved in SOURCE_MANIFEST; a fresh temporary cache is used per run and supports conditional revalidation within a downloader invocation directory. No unofficial mirrors, authentication workarounds, CAPTCHA bypasses or private endpoints are used. The Commission API requires account registration and a subscription API key, and is deliberately not called.

RUN_SUMMARY records the filters, delivered count and elapsed time. Source archives are temporary. The Actor does not set up a permanent copy or external scheduled downloader. Users control Dataset retention in their Apify account and should remove outdated records and comply with valid deletion/correction requests. Source availability and completeness are not guaranteed; income reflects self-reported accounts, not an independent audit or current cash position.

Licence and permitted use

Source: Charity Commission for England and Wales.

Contains public sector information licensed under the Open Government Licence v3.0. https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/

The OGL permits commercial reuse of licensed public-sector information with attribution. It excludes personal data and does not replace data-protection obligations or imply official endorsement. The Commission's API has separate terms, including restrictions on marketing uses of personal data; this Actor does not use that API. Do not interpret the bulk download route as a way around those obligations. Use this service for lawful organisation research and analysis; establish any additional rights required for personal data yourself.

API access and terms reviewed:

• https://register-of-charities.charitycommission.gov.uk/en/documentation-on-the-api
• https://api-portal.charitycommission.gov.uk/terms

Development

Python 3.13, Apify SDK 4.1.0. Install requirements and run python -m unittest discover -s tests -v; run the Actor with python -m src. Docker: docker build -t newapi38:1.0 . then docker run --rm newapi38:1.0. Configuration and Dataset/input/output schemas are in .actor. Version 1.0.0.