Global Warning Weather Dataset
To analysis on different Weather Parameters
@kaggle.aritra100_global_warning_weather_dataset
To analysis on different Weather Parameters
@kaggle.aritra100_global_warning_weather_dataset
CREATE TABLE change_in_mean_sea_levels (
"objectid" BIGINT,
"country" VARCHAR,
"iso2" VARCHAR,
"iso3" VARCHAR,
"indicator" VARCHAR,
"unit" VARCHAR,
"source" VARCHAR,
"cts_code" VARCHAR,
"cts_name" VARCHAR,
"cts_full_descriptor" VARCHAR,
"measure" VARCHAR,
"date" VARCHAR,
"value" DOUBLE
);
CREATE TABLE climate_indicators_annual_mean_global_surface_temperature (
"objectid" BIGINT,
"country" VARCHAR,
"iso2" VARCHAR,
"iso3" VARCHAR,
"indicator" VARCHAR,
"unit" VARCHAR,
"source" VARCHAR,
"cts_code" VARCHAR,
"cts_name" VARCHAR,
"cts_full_descriptor" VARCHAR,
"n_1961" DOUBLE,
"n_1962" DOUBLE,
"n_1963" DOUBLE,
"n_1964" DOUBLE,
"n_1965" DOUBLE,
"n_1966" DOUBLE,
"n_1967" DOUBLE,
"n_1968" DOUBLE,
"n_1969" DOUBLE,
"n_1970" DOUBLE,
"n_1971" DOUBLE,
"n_1972" DOUBLE,
"n_1973" DOUBLE,
"n_1974" DOUBLE,
"n_1975" DOUBLE,
"n_1976" DOUBLE,
"n_1977" DOUBLE,
"n_1978" DOUBLE,
"n_1979" DOUBLE,
"n_1980" DOUBLE,
"n_1981" DOUBLE,
"n_1982" DOUBLE,
"n_1983" DOUBLE,
"n_1984" DOUBLE,
"n_1985" DOUBLE,
"n_1986" DOUBLE,
"n_1987" DOUBLE,
"n_1988" DOUBLE,
"n_1989" DOUBLE,
"n_1990" DOUBLE,
"n_1991" DOUBLE,
"n_1992" DOUBLE,
"n_1993" DOUBLE,
"n_1994" DOUBLE,
"n_1995" DOUBLE,
"n_1996" DOUBLE,
"n_1997" DOUBLE,
"n_1998" DOUBLE,
"n_1999" DOUBLE,
"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" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE
);
CREATE TABLE climate_indicators_monthly_atmospheric_carbon_dioxide__87a86402 (
"objectid" BIGINT,
"country" VARCHAR,
"iso2" VARCHAR,
"iso3" VARCHAR,
"indicator" VARCHAR,
"unit" VARCHAR,
"source" VARCHAR,
"cts_code" VARCHAR,
"cts_name" VARCHAR,
"cts_full_descriptor" VARCHAR,
"date" VARCHAR,
"value" DOUBLE
);
CREATE TABLE forest_and_carbon (
"objectid" BIGINT,
"country" VARCHAR,
"iso2" VARCHAR,
"iso3" VARCHAR,
"indicator" VARCHAR,
"unit" VARCHAR,
"source" VARCHAR,
"cts_code" VARCHAR,
"cts_name" VARCHAR,
"cts_full_descriptor" VARCHAR,
"f1992" DOUBLE,
"f1993" DOUBLE,
"f1994" DOUBLE,
"f1995" DOUBLE,
"f1996" DOUBLE,
"f1997" DOUBLE,
"f1998" DOUBLE,
"f1999" DOUBLE,
"f2000" DOUBLE,
"f2001" DOUBLE,
"f2002" DOUBLE,
"f2003" DOUBLE,
"f2004" DOUBLE,
"f2005" DOUBLE,
"f2006" DOUBLE,
"f2007" DOUBLE,
"f2008" DOUBLE,
"f2009" DOUBLE,
"f2010" DOUBLE,
"f2011" DOUBLE,
"f2012" DOUBLE,
"f2013" DOUBLE,
"f2014" DOUBLE,
"f2015" DOUBLE,
"f2016" DOUBLE,
"f2017" DOUBLE,
"f2018" DOUBLE,
"f2019" DOUBLE,
"f2020" DOUBLE,
"f2021" DOUBLE,
"f2022" DOUBLE
);
CREATE TABLE land_cover_accounts (
"objectid" BIGINT,
"country" VARCHAR,
"iso2" VARCHAR,
"iso3" VARCHAR,
"indicator" VARCHAR,
"unit" VARCHAR,
"source" VARCHAR,
"cts_code" VARCHAR,
"cts_name" VARCHAR,
"cts_full_descriptor" VARCHAR,
"climate_influence" VARCHAR,
"f1992" DOUBLE,
"f1993" DOUBLE,
"f1994" DOUBLE,
"f1995" DOUBLE,
"f1996" DOUBLE,
"f1997" DOUBLE,
"f1998" DOUBLE,
"f1999" DOUBLE,
"f2000" DOUBLE,
"f2001" DOUBLE,
"f2002" DOUBLE,
"f2003" DOUBLE,
"f2004" DOUBLE,
"f2005" DOUBLE,
"f2006" DOUBLE,
"f2007" DOUBLE,
"f2008" DOUBLE,
"f2009" DOUBLE,
"f2010" DOUBLE,
"f2011" DOUBLE,
"f2012" DOUBLE,
"f2013" DOUBLE,
"f2014" DOUBLE,
"f2015" DOUBLE,
"f2016" DOUBLE,
"f2017" DOUBLE,
"f2018" DOUBLE,
"f2019" DOUBLE,
"f2020" DOUBLE,
"f2021" DOUBLE,
"f2022" DOUBLE
);
CREATE TABLE physical_risks_climate_related_disasters_frequency (
"objectid" BIGINT,
"country" VARCHAR,
"iso2" VARCHAR,
"iso3" VARCHAR,
"indicator" VARCHAR,
"unit" VARCHAR,
"source" VARCHAR,
"cts_code" VARCHAR,
"cts_name" VARCHAR,
"cts_full_descriptor" VARCHAR,
"n_1980" DOUBLE,
"n_1981" DOUBLE,
"n_1982" DOUBLE,
"n_1983" DOUBLE,
"n_1984" DOUBLE,
"n_1985" DOUBLE,
"n_1986" DOUBLE,
"n_1987" DOUBLE,
"n_1988" DOUBLE,
"n_1989" DOUBLE,
"n_1990" DOUBLE,
"n_1991" DOUBLE,
"n_1992" DOUBLE,
"n_1993" DOUBLE,
"n_1994" DOUBLE,
"n_1995" DOUBLE,
"n_1996" DOUBLE,
"n_1997" DOUBLE,
"n_1998" DOUBLE,
"n_1999" DOUBLE,
"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" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE
);
Anyone who has the link will be able to view this.