UK Condensed SIC 2007

core

Files Size Format Created Updated License Source
2 70kB csv zip 6 months ago 2 months 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

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

Data-cli or just data is the program to get and post your data with the datahub.
Download CLI tool and use it with the datahub almost like you use git with the github:

data get https://datahub.io/core/uk-sic-2007-condensed
data info core/uk-sic-2007-condensed
tree core/uk-sic-2007-condensed
# Get a list of dataset's resources
curl -L -s https://datahub.io/core/uk-sic-2007-condensed/datapackage.json | grep path

# Get resources

curl -L https://datahub.io/core/uk-sic-2007-condensed/r/0.csv

curl -L https://datahub.io/core/uk-sic-2007-condensed/r/1.zip

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

install.packages("jsonlite", repos="https://cran.rstudio.com/")
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)
  }
}

Note: You might need to run the script with root permissions if you are running on Linux machine

Install the Frictionless Data data package library and the pandas itself:

pip install datapackage
pip install pandas

Now you can use the datapackage in the Pandas:

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')

# print list of all resources:
print(package.resource_names)

# print processed tabular data (if exists any)
for resource in package.resources:
    if resource.descriptor['datahub']['type'] == 'derived/csv':
        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