Tracking Global CO2 Emissions (1990-2023)
33 years record of CO2 emission all over the world from 1990 to 2023
@kaggle.mabdullahsajid_tracking_global_co2_emissions_1990_2023
33 years record of CO2 emission all over the world from 1990 to 2023
@kaggle.mabdullahsajid_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:
Long (Tidy) Format:
In the Long Format, the dataset is transformed into a structured, tidy format with three key features:
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.
CREATE TABLE tidy_format_co2_emission_dataset (
"country" VARCHAR,
"year" BIGINT,
"co2emissionrate_mt" VARCHAR -- CO2EmissionRate (mt)
);CREATE TABLE wide_format_co2_emission_dataset (
"country" VARCHAR,
"n_1990" VARCHAR -- 1990,
"n_1991" VARCHAR -- 1991,
"n_1992" VARCHAR -- 1992,
"n_1993" VARCHAR -- 1993,
"n_1994" VARCHAR -- 1994,
"n_1995" DOUBLE -- 1995,
"n_1996" VARCHAR -- 1996,
"n_1997" VARCHAR -- 1997,
"n_1998" VARCHAR -- 1998,
"n_1999" VARCHAR -- 1999,
"n_2000" DOUBLE -- 2000,
"n_2001" DOUBLE -- 2001,
"n_2002" DOUBLE -- 2002,
"n_2003" DOUBLE -- 2003,
"n_2004" DOUBLE -- 2004,
"n_2005" DOUBLE -- 2005,
"n_2006" DOUBLE -- 2006,
"n_2007" DOUBLE -- 2007,
"n_2008" VARCHAR -- 2008,
"n_2009" VARCHAR -- 2009,
"n_2010" VARCHAR -- 2010,
"n_2011" VARCHAR -- 2011,
"n_2012" VARCHAR -- 2012,
"n_2013" VARCHAR -- 2013,
"n_2014" VARCHAR -- 2014,
"n_2015" DOUBLE -- 2015,
"n_2018" DOUBLE -- 2018,
"n_2021" DOUBLE -- 2021
);Anyone who has the link will be able to view this.