registered-casc

Generate a schema.org compliant JSON file of Registered Community Amateur Sports Clubs in the UK.

Current version

This JSON is based on the 13 October 2023 file.

History

HMRC publish a list of all registered CASCs in the UK. This is an ODS file that is updated infrequently. This project aims to convert that file into a JSON file that is schema.org compliant.

Sample entry

ABBOTS LANGLEY BOWLING CLUB   ,12 GREENWAYS,ABBOTS LANGLEY,,,WD5 0EU

{
  "@context": "https://schema.org",
  "@type": "SportsOrganization",
  "name": "ABBOTS LANGLEY BOWLING CLUB",
  "address": {
    "@type": "PostalAddress",
    "streetAddress": "12 Greenways",
    "addressLocality": "Abbots Langley",
    "addressRegion": "Hertfordshire",
    "postalCode": "WD5 0EU",
    "addressCountry": {
      "@type": "Country",
      "name": "GB"
    }
  }
}

Process

The ODS file is converted to a CSV file using LibreOffice. The CSV file is then converted to a JSON file using a TypeScript script.

1. If the Postcode column has content, use that to populate the addressCountry and postalCode fields.
2. If there's no addressRegion then the addressLocality is used to look up the county in the counties.json file.
3. If addressRegion is still empty, then a lookup is made to https://api.postcodes.io/postcodes/ to populate it from an admin_county response.
4. The column immediately before addressRegion is used for addressLocality.
5. All address fields are title cased.

Usage

bun convert.ts