Climate Change Dataset

"Dataset of Temperature, Emissions, and Environmental Trends (2000-2024)"

@kaggle.bhadramohit_climate_change_dataset

Table List

1 table(31.81 KB)

Climate Change Dataset

@kaggle.bhadramohit_climate_change_dataset.climate_change_dataset

31.81 KB
1000 rows
10 columns

year Year	country Country	avg_temperature_c Avg Temperature (°C)	co2_emissions_tons_capita CO2 Emissions (Tons/Capita)	sea_level_rise_mm Sea Level Rise (mm)	rainfall_mm Rainfall (mm)	population Population	renewable_energy Renewable Energy (%)	extreme_weather_events Extreme Weather Events	forest_area Forest Area (%)
2006	UK	8.9	9.3	3.1	1441	530911230	20.4	14	59.8
2019	USA	31	4.8	4.2	2407	107364344	49.2	8	31
2014	France	33.9	2.8	2.2	1241	441101758	33.3	9	35.5
2010	Argentina	5.9	1.8	3.2	1892	1069669579	23.7	7	17.7
2007	Germany	26.9	5.6	2.4	1743	124079175	12.5	4	17.4
2020	China	32.3	1.4	2.7	2100	1202028857	49.4	12	47.2
2006	Argentina	30.7	11.6	3.9	1755	586706107	41.9	10	50.5
2018	South Africa	33.9	6	4.5	827	83947380	17.7	1	56.6
2022	UK	27.8	16.6	1.5	1966	980305187	8.2	4	43.4
2010	Australia	18.3	1.9	3.5	2599	849496137	7.5	5	48.7


CREATE TABLE climate_change_dataset (
  "year" BIGINT,
  "country" VARCHAR,
  "avg_temperature_c" DOUBLE,
  "co2_emissions_tons_capita" DOUBLE,
  "sea_level_rise_mm" DOUBLE,
  "rainfall_mm" BIGINT,
  "population" BIGINT,
  "renewable_energy" DOUBLE,
  "extreme_weather_events" BIGINT,
  "forest_area" DOUBLE
);