Name: Worldwide Temperature Trends 1961–2024
Creator: Kaggle
License: https://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

Worldwide Temperature Trends 1961–2024

This dataset is a collection of files from the Food and Agriculture Organization (FAO) that record and organize global temperature change data over time.
It helps researchers and learners understand how the Earth’s land temperatures have changed across different countries, regions, and seasons.

📂 Files Included

Environment_Temperature_change_E_All_Data_NOFLAG.csv
Contains detailed temperature change data (in °C) for countries and regions, showing how temperatures have shifted annually and seasonally compared to a baseline period.
FAOSTAT_data_1-10-2022.csv
Provides an updated version of the climate change domain data, including annual and seasonal temperature change records up to 2021. It helps track long-term warming patterns globally.
FAOSTAT_data_11-24-2020.csv
A country reference file listing all countries and regions with their FAO codes, UN M49 codes, and ISO codes. It helps connect and organize data across different FAO files.
FAOSTAT_data_en_11-1-2024.csv
The most recent and detailed file (2024 release), showing monthly and annual temperature changes on land for each country, along with flags that indicate data reliability (e.g., estimated values).

🌍 Purpose

Together, these files allow users to explore global warming trends, compare temperature changes by country or region, and study climate patterns over time using trusted FAO data.

Tables

Faostat Data 1–10–2022

@kaggle.rehan497_worldwide_temperature_trends_19612024.faostat_data_1_10_2022

504.78 kB
229,925 rows
14 columns

CREATE TABLE faostat_data_1_10_2022 (
  "domain_code" VARCHAR,
  "domain" VARCHAR,
  "area_code_fao" BIGINT  -- Area Code (FAO),
  "area" VARCHAR,
  "element_code" BIGINT,
  "element" VARCHAR,
  "months_code" BIGINT,
  "months" VARCHAR,
  "year_code" BIGINT,
  "year" BIGINT,
  "unit" VARCHAR,
  "value" DOUBLE,
  "flag" VARCHAR,
  "flag_description" VARCHAR
);

Faostat Data 11–24–2020

@kaggle.rehan497_worldwide_temperature_trends_19612024.faostat_data_11_24_2020

15.94 kB
321 rows
7 columns

CREATE TABLE faostat_data_11_24_2020 (
  "country_code" BIGINT,
  "country" VARCHAR,
  "m49_code" DOUBLE,
  "iso2_code" VARCHAR,
  "iso3_code" VARCHAR,
  "start_year" DOUBLE,
  "end_year" DOUBLE
);

Faostat Data En 11–1–2024

@kaggle.rehan497_worldwide_temperature_trends_19612024.faostat_data_en_11_1_2024

527.36 kB
241,893 rows
14 columns

CREATE TABLE faostat_data_en_11_1_2024 (
  "domain_code" VARCHAR,
  "domain" VARCHAR,
  "area_code_m49" BIGINT  -- Area Code (M49),
  "area" VARCHAR,
  "element_code" BIGINT,
  "element" VARCHAR,
  "months_code" BIGINT,
  "months" VARCHAR,
  "year_code" BIGINT,
  "year" BIGINT,
  "unit" VARCHAR,
  "value" DOUBLE,
  "flag" VARCHAR,
  "flag_description" VARCHAR
);