About this Dataset

Employment By Broad Industrial Group

This data uses a national employer survey to show numbers and percentages of people employed in jobs in industries in each broad industrial group. Data is shown for Lincolnshire and Districts, and also for smaller areas (such as Wards, and Lower super output areas (LSOAs from the 2011 Census)). Some limitations of the dataset are that figures for small areas (Wards and LSOAs) exclude employees in farm agriculture (Standard Industrial Classification subclass 01000). The figures include businesses registered for PAYE but not for VAT. Values may be rounded and low numbers suppressed (particularly at smaller geographies) so numbers may not tally precisely with figures for larger areas. Figures are shown for the most recent year available, although these are provisional and may be subject to later revision by ONS. This data is based on the ONS Business Register and Employment Survey (BRES, open access) sourced from the Office for National Statistics (ONS) Nomis website. More detailed breakouts of Standard Industrial Classifications are available from the Source weblink. This dataset is updated annually
Publisher name: Lincolnshire County Council
Last updated: 2025-03-13T04:00:02Z

Tables

Employment By Broad Industrial Group

@ukgov.employment_by_broad_industrial_group1.employment_by_broad_industrial_group

191.02 KB
5850 rows
32 columns


CREATE TABLE employment_by_broad_industrial_group (
  "organisationname" VARCHAR,
  "organisationcode" VARCHAR,
  "publisheddate" TIMESTAMP,
  "durationfrom" VARCHAR,
  "durationto" VARCHAR,
  "latestdata" VARCHAR,
  "reportingperiodtype" VARCHAR,
  "geoentityname" VARCHAR,
  "geocode" VARCHAR,
  "geoname" VARCHAR,
  "geouri" VARCHAR,
  "datatype" VARCHAR,
  "year" BIGINT,
  "provisional" VARCHAR,
  "a_agriculture_forestry_fishing" DOUBLE,
  "bde_mining_quarrying_utilities" DOUBLE,
  "c_manufacturing" DOUBLE,
  "f_construction" DOUBLE,
  "partg_motor_trades" DOUBLE,
  "partg_wholesale" DOUBLE,
  "partg_retail" DOUBLE,
  "h_transport_storage_inc_postal" DOUBLE,
  "i_accommodation_food_services" DOUBLE,
  "j_information_communication" DOUBLE,
  "k_financial_insurance" DOUBLE,
  "l_property" DOUBLE,
  "m_professional_scientific_technical" DOUBLE,
  "n_business_adminstration_support_services" DOUBLE,
  "o_public_administration_defence" DOUBLE,
  "p_education" DOUBLE,
  "q_health" DOUBLE,
  "rstu_arts_entertainment_recreation_other_services" DOUBLE
);

Table 2

@ukgov.employment_by_broad_industrial_group1.table_2

12.08 KB
31 rows
12 columns


CREATE TABLE table_2 (
  "dataset_id" BIGINT,
  "dataset_name" VARCHAR,
  "field" VARCHAR,
  "type" VARCHAR,
  "mandatory_or_optional_requirement_mor" VARCHAR,
  "field_description" VARCHAR,
  "schema" VARCHAR,
  "lcc_mapping" VARCHAR,
  "schema_comments" VARCHAR,
  "schema_data_rules_comment" VARCHAR,
  "formatreference" VARCHAR,
  "example" VARCHAR
);