Now you can request additional data and/or customized columns!

Try It Now!

UK Condensed SIC 2007

Certified

core

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

Data Files

Download files in this dataset

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  

Signup to Premium Service for additional or customised data - Get Started

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

Integrate this dataset into your favourite tool

Use our data-cli tool designed for data wranglers:

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)
    }
  }
})()

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.

Datapackage.json

Request Customized Data


Notifications of data updates and schema changes

Warranty / guaranteed updates

Workflow integration (e.g. Python packages, NPM packages)

Customized data (e.g. you need different or additional data)

Or suggest your own feature from the link below