UK Condensed SIC 2007

core

Files Size Format Created Updated License Source
2 67kB csv zip 5 days ago OGL-UK-3.0 Company registration and filing – guidance - Standard industrial classification of economic activities (SIC)
UK condensed standard industrial classification of economic activities (SIC) 2007 codes Data List of the Office of National Statistics (ONS) codes for classifying economic activity of business establishments and other standard units. Only codes in the condensed list can be used on a company's read more
Download

Data Files

File Description Size Last changed Download
uk-sic-2007-condensed 131kB csv (131kB) , json (197kB)
uk-sic-2007-condensed_zip Compressed versions of dataset. Includes normalized CSV and JSON data with original data and datapackage.json. 39kB zip (39kB)

uk-sic-2007-condensed  

This is a preview version. There might be more data in the original version.

Field information

Field Name Order Type (Format) Description
sic_code 1 integer
sic_description 2 string
section 3 string
section_description 4 string
sic_version 5 string

uk-sic-2007-condensed_zip  

This is a preview version. There might be more data in the original version.

Read me

UK condensed standard industrial classification of economic activities (SIC) 2007 codes

Data

List of the Office of National Statistics (ONS) codes for classifying economic activity of business establishments and other standard units. Only codes in the condensed list can be used on a company’s annual return. SIC 2007 was adopted from 1st January 2008.

Notes

UK condensed SIC 2007 codes issued by Companies House are a subset of the codes published by the ONS whose copyright page supports an assumption of open data.

Preparation

The Condensed SIC list was downloaded and converted using PDFMiner pdf2txt.py -c UTF-8 -o condensedSICList.txt condensedSICList.pdf. The text file was edited programmitically find /v /c "" condensedSICList.txt and manually, then sanity checked against Nathan Pitman’s Sic-Codes CSV. An error with code 14200 appended code 14190 was corrected.

License

Adapted from data from the Office for National Statistics licensed under the Open Government Licence v.3.0.

Import into your tool

If you are using R here's how to get the data you want quickly loaded:

install.packages("jsonlite")
library("jsonlite")

json_file <- 'https://datahub.io/core/uk-sic-2007-condensed/datapackage.json'
json_data <- fromJSON(paste(readLines(json_file), collapse=""))

# get list of all resources:
print(json_data$resources$name)

# print all tabular data(if exists any)
for(i in 1:length(json_data$resources$datahub$type)){
  if(json_data$resources$datahub$type[i]=='derived/csv'){
    path_to_file = json_data$resources$path[i]
    data <- read.csv(url(path_to_file))
    print(data)
  }
}

In order to work with Data Packages in Pandas you need to install the Frictionless Data data package library and the pandas extension:

import datapackage
import pandas as pd

data_url = 'https://datahub.io/core/uk-sic-2007-condensed/datapackage.json'

# to load Data Package into storage
package = datapackage.Package(data_url)

# to load only tabular data
resources = package.resources
for resource in resources:
    if resource.tabular:
        data = pd.read_csv(resource.descriptor['path'])
        print (data)

For Python, first install the `datapackage` library (all the datasets on DataHub are Data Packages):

pip install datapackage

To get Data Package into your Python environment, run following code:

from datapackage import Package

package = Package('https://datahub.io/core/uk-sic-2007-condensed/datapackage.json')

# get list of all resources:
resources = package.descriptor['resources']
resourceList = [resources[x]['name'] for x in range(0, len(resources))]
print(resourceList)

# print all tabular data(if exists any)
resources = package.resources
for resource in resources:
    if resource.tabular:
        print(resource.read())

If you are using JavaScript, please, follow instructions below:

Install data.js module using npm:

  $ npm install data.js

Once the package is installed, use the following code snippet:

const {Dataset} = require('data.js')

const path = 'https://datahub.io/core/uk-sic-2007-condensed/datapackage.json'

// We're using self-invoking function here as we want to use async-await syntax:
;(async () => {
  const dataset = await Dataset.load(path)
  // get list of all resources:
  for (const id in dataset.resources) {
    console.log(dataset.resources[id]._descriptor.name)
  }
  // get all tabular data(if exists any)
  for (const id in dataset.resources) {
    if (dataset.resources[id]._descriptor.format === "csv") {
      const file = dataset.resources[id]
      // Get a raw stream
      const stream = await file.stream()
      // entire file as a buffer (be careful with large files!)
      const buffer = await file.buffer
      // print data
      stream.pipe(process.stdout)
    }
  }
})()
Datapackage.json