Name: ESG - Synthetic UK Population And Businesses
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

About this Dataset

ESG - Synthetic UK Population And Businesses

ESG footprint of Synthetic UK Individuals and Businesses

Contains information on various energy usages, housing, and their associated costs on 4000 synthetic UK individuals. It can be used to analyze the trends towards sustainability at the individual level.

This sample data is part of the statistically accurate representation of the UK economy that can be found at https://nayaone.com/digital-twin/. Our mission is democratization and quality data governance in areas where the lack of data is a major hurdle for innovation and progress. To learn more, contact us: contact@nayaone.com

Content

Attributes

Businesses

borough_county: Districts in the UK (some are counties some are towns)
primary_sector: SIC - 2007 numerical codes
entity_trade_name: Trading name of the company
annual_turnover: Annual turnover split into 4 bands
entity_status: Active org = 1, Dissolved = 0
country_of_primary_operation: All UK
Coal_Consumption_By_Sector(toe): Total coal consumption by company
Electricity_Consumption_By_Structure(toe): total electricity consumption by the company according th the structure type and location
Gas_Consumption_By_Structure(toe): total gas consumption by the company according the structure type and location
Geographic Code: Geocode according th the county of company
Local Authority: County of the company
NG_Consumption_By_Sector(toe): Natural gas consumption by compcompany according the structure type and location
Petrol_Consumption_By_Sector(toe): Petrol consumption by the company according the structure type and location
Region: UK region where company is lcompany is located
SIC Group: Industrial classification of company group
Section: Industrial classification of the company section
Sector: Sector of the company work
Structure_Type: Structure type of the company

Individual

individual_ID: Key
name: First name + Surname
sex: Individual's gender
geography: Geography
postcode: Postcode
ethic_group: The ethnic group classification presented is the recommended framework from the 'Harmonised Concepts and Questions for Social Data Sources Primary Standards' for presentation of UK outputs on ethnic group
nationality: Nationality of the individual
marital_and_civil_partnership_status: Marital and civil partnership status classifies an individual according to their legal marital or registered same-sex civil
occupation: The person's occupation relates to their main job and is derived from either their job title or details of the activities involved in their job
Diesel car: Number of dissel car
Diesel consumption: Diesel consumption per individual
Electricity consumption: electricity consumption per individual
Family type: Type of the family individual living in
Gas Availability: Gas connection availibility
Gas consumption: Gas consumption of the individual
House ID: House ID, per family
House members: Number of house members in house
Individual type: Type of the Individual
Motor cycle: Number of Motor cycle present
Number of bedrooms: Totol number of bedrooms in the house
Other fuel car: Number of other fuel cars
Petrol car: Number of petrol cars
Petrol consumption: Petrol consumption per indivdual
Region: UK region where family or house is located

Tables

Esg Businesses 1000

@kaggle.nayaone_esg_synthetic_uk_population_and_businesses.esg_businesses_1000

96.15 kB
1,000 rows
19 columns

CREATE TABLE esg_businesses_1000 (
  "id" BIGINT,
  "borough_county" VARCHAR,
  "primary_sector" VARCHAR,
  "entity_trade_name" VARCHAR,
  "annual_turnover" VARCHAR,
  "entity_status" BIGINT,
  "country_of_primary_operation" VARCHAR,
  "coal_consumption_by_sector_toe" DOUBLE  -- Coal Consumption By Sector(toe),
  "electricity_consumption_by_structure_toe" DOUBLE  -- Electricity Consumption By Structure(toe),
  "gas_consumption_by_structure_toe" DOUBLE  -- Gas Consumption By Structure(toe),
  "geographic_code" VARCHAR,
  "local_authority" VARCHAR,
  "ng_consumption_by_sector_toe" DOUBLE  -- NG Consumption By Sector(toe),
  "petrol_consumption_by_sector_toe" DOUBLE  -- Petrol Consumption By Sector(toe),
  "region" VARCHAR,
  "sic_group" VARCHAR,
  "section" VARCHAR,
  "sector" VARCHAR,
  "structure_type" VARCHAR
);

Esg Indv 4000

@kaggle.nayaone_esg_synthetic_uk_population_and_businesses.esg_indv_4000

179.96 kB
4,000 rows
24 columns

CREATE TABLE esg_indv_4000 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" BIGINT,
  "name" VARCHAR,
  "sex" VARCHAR,
  "geography" VARCHAR,
  "postcode" VARCHAR,
  "ethnic_group" VARCHAR,
  "nationality" VARCHAR,
  "occupation" VARCHAR,
  "diesel_car" DOUBLE,
  "diesel_consumption" DOUBLE,
  "electricity_consumption" DOUBLE,
  "family_type" VARCHAR,
  "gas_availability" VARCHAR,
  "gas_consumption" DOUBLE,
  "house_id" VARCHAR,
  "house_members" DOUBLE,
  "individual_type" VARCHAR,
  "motor_cycle" DOUBLE,
  "number_of_bedrooms" VARCHAR,
  "other_fuel_car" DOUBLE,
  "petrol_car" DOUBLE,
  "petrol_consumption" DOUBLE,
  "region" VARCHAR
);