Help - Sample Data - Public Data API

#1

HI

New to the industry, have been asked to look to do some basic research on the public data API:

https://developer-specs.company-information.service.gov.uk/companies-house-public-data-api/reference

Does anyone know where I might be able to find a sample download of the data that is available? Anything that would help a layperson to understand what the real world data might look like and how it might be used?

Many thanks

#2

I found the Companies House search facility useful for figuring out what all the data means: https://find-and-update.company-information.service.gov.uk/

You can compare what is returned by the API, to how Companies House has chosen to consume and present the same data that we have access to through the API.

#3

Rather than sample data, you can get the data structure of each resource. Click on the get link then in the page that opens click on the resource link.

image
image1111×172 11.4 KB

here’s what a companyProfile response looks like:

{
    "accounts": {
        "accounting_reference_date": {
            "day": "integer",
            "month": "integer"
        },
        "last_accounts": {
            "made_up_to": "date",
            "type": {}
        },
        "next_due": "date",
        "next_made_up_to": "date",
        "overdue": "boolean"
    },
    "annual_return": {
        "last_made_up_to": "date",
        "next_due": "date",
        "next_made_up_to": "date",
        "overdue": "boolean"
    },
    "branch_company_details": {
        "business_activity": "string",
        "parent_company_name": "string",
        "parent_company_number": "string"
    },
    "can_file": "boolean",
    "company_name": "string",
    "company_number": "string",
    "company_status": "string",
    "company_status_detail": "string",
    "confirmation_statement": {
        "last_made_up_to": "date",
        "next_due": "date",
        "next_made_up_to": "date",
        "overdue": "boolean"
    },
    "date_of_cessation": "date",
    "date_of_creation": "date",
    "etag": "string",
    "foreign_company_details": {
        "accounting_requirement": {
            "foreign_account_type": "string",
            "terms_of_account_publication": "string"
        },
        "accounts": {
            "account_period_from:": {
                "day": "integer",
                "month": "integer"
            },
            "account_period_to": {
                "day": "integer",
                "month": "integer"
            },
            "must_file_within": {
                "months": "integer"
            }
        },
        "business_activity": "string",
        "company_type": "string",
        "governed_by": "string",
        "is_a_credit_finance_institution": "boolean",
        "originating_registry": {
            "country": "string",
            "name": "string"
        },
        "registration_number": "string"
    },
    "has_been_liquidated": "boolean",
    "has_charges": "boolean",
    "has_insolvency_history": "boolean",
    "is_community_interest_company": "boolean",
    "jurisdiction": "string",
    "last_full_members_list_date": "date",
    "links": {
        "persons_with_significant_control": "string",
        "persons_with_significant_control_statements": "string",
        "registers": "string",
        "self": "string"
    },
    "previous_company_names": [
        {
            "ceased_on": "date",
            "effective_from": "date",
            "name": "string"
        }
    ],
    "registered_office_address": {
        "address_line_1": "string",
        "address_line_2": "string",
        "care_of": "string",
        "country": "string",
        "locality": "string",
        "po_box": "string",
        "postal_code": "string",
        "premises": "string",
        "region": "string"
    },
    "registered_office_is_in_dispute": "boolean",
    "sic_codes": [
        "string"
    ],
    "type": "string",
    "undeliverable_registered_office_address": "boolean"
}
#4

many thanks for this reply - I’ll try and work it out from this. It’s a step forward. Cheers.

#5

In addition to the helpful responses above Companies House also has a bulk data set that you can download and load into a database engine of your choice.

Please see here [Companies House]