Dataset: Tracking Global CO2 Emissions (1990-2023)

About this Dataset

Tracking Global CO2 Emissions (1990-2023)

Dataset Description

This comprehensive dataset provides a detailed account of carbon dioxide (CO2) emissions spanning from 1990 to 2023 for countries across the world. It is presented in two distinct formats: the Wide Format and the Long (Tidy) Format, allowing users the flexibility to analyze and visualize CO2 emission data in their preferred structure.

Wide Format:
In the Wide Format, the dataset offers a snapshot of CO2 emissions with features that include:

Country Name: Names of countries and regions.
Years (1990-2023): An extensive time series ranging from 1990 to 2023, allowing for a comprehensive historical perspective on emissions.

Long (Tidy) Format:
In the Long Format, the dataset is transformed into a structured, tidy format with three key features:

Country: The name of each country or region.
Year: The specific year within the 1990-2023 timeframe.
CO2 Emission Rate (mt): The amount of carbon dioxide emissions in metric tons for each country and year, providing granular and organized data for analysis.

This dataset is a valuable resource for researchers, analysts, and data scientists interested in exploring global CO2 emission patterns, tracking historical trends, and conducting in-depth studies related to climate change, environmental policy, and sustainability. The dual presentation in both Wide and Long Formats empowers users to choose the data structure that best suits their analytical needs.

Tables

Tidy Format Co2 Emission Dataset

@kaggle.mabdullahsajid_tracking_global_co2_emissions_1990_2023.tidy_format_co2_emission_dataset

13.88 KB
5572 rows
3 columns


CREATE TABLE tidy_format_co2_emission_dataset (
  "country" VARCHAR,
  "year" BIGINT,
  "co2emissionrate_mt" VARCHAR
);

Wide Format Co2 Emission Dataset

@kaggle.mabdullahsajid_tracking_global_co2_emissions_1990_2023.wide_format_co2_emission_dataset

36.31 KB
199 rows
29 columns


CREATE TABLE wide_format_co2_emission_dataset (
  "country" VARCHAR,
  "n_1990" VARCHAR,
  "n_1991" VARCHAR,
  "n_1992" VARCHAR,
  "n_1993" VARCHAR,
  "n_1994" VARCHAR,
  "n_1995" DOUBLE,
  "n_1996" VARCHAR,
  "n_1997" VARCHAR,
  "n_1998" VARCHAR,
  "n_1999" VARCHAR,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" VARCHAR,
  "n_2009" VARCHAR,
  "n_2010" VARCHAR,
  "n_2011" VARCHAR,
  "n_2012" VARCHAR,
  "n_2013" VARCHAR,
  "n_2014" VARCHAR,
  "n_2015" DOUBLE,
  "n_2018" DOUBLE,
  "n_2021" DOUBLE
);